{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Series 4 Post and Panel"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":57,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Series 4 Post and Panel","index":0,"n_rows":115,"n_cols":44,"rows_kept":115,"cut":false,"hidden":false,"merged":[[112,1,112,28],[113,1,113,28],[114,3,114,4],[114,5,114,10],[114,12,114,13],[114,14,114,19],[114,20,114,28],[114,1,114,2],[5,39,5,41],[50,6,50,8],[50,9,50,10],[50,11,50,12],[50,23,50,25],[52,21,52,22],[23,26,24,26],[23,27,24,27],[21,1,21,28],[31,1,31,28],[24,7,24,25],[23,5,23,6],[33,1,33,28],[46,2,46,3],[44,5,44,6],[104,32,104,33],[5,43,5,45],[105,1,105,28],[106,1,106,28],[108,1,108,28],[107,1,107,28],[109,1,109,28],[110,1,110,28],[111,3,111,4],[111,12,111,13],[111,5,111,10],[111,14,111,19],[111,1,111,2],[111,20,111,28],[102,4,102,25],[55,7,55,25],[91,4,91,25],[57,2,57,3],[93,4,93,25],[90,1,90,28],[62,2,62,3],[100,1,100,28],[101,4,101,25],[92,2,92,3],[92,4,92,25],[1,1,1,28],[22,5,22,6],[22,7,22,28],[5,1,5,28],[6,1,6,28],[16,1,16,28],[3,1,3,28],[9,1,9,4],[9,5,9,13],[22,2,22,3],[9,14,9,17],[15,1,15,28],[13,18,13,22],[19,1,19,28],[20,1,20,28],[9,18,9,24],[11,19,11,22],[11,17,11,18],[11,13,11,16],[11,11,11,12],[11,7,11,10],[2,1,2,28],[7,1,7,28],[4,1,4,28],[145,30,145,31],[144,30,144,31],[68,2,68,3],[68,5,68,6],[68,7,68,25],[89,1,89,28],[93,2,93,3],[91,2,91,3],[91,32,91,33],[92,32,92,33],[93,32,93,33],[103,2,103,3],[103,4,103,25],[101,2,101,3],[104,2,104,3],[104,4,104,25],[101,28,104,28],[69,1,69,28],[98,1,98,28],[99,2,99,3],[99,4,99,25],[102,2,102,3],[94,2,94,3],[94,4,94,25],[57,32,57,34],[52,1,52,4],[52,5,52,6],[52,7,52,8],[52,23,52,24],[52,25,52,26],[23,7,23,25],[24,2,24,3],[23,28,24,28],[24,5,24,6],[23,2,23,3],[56,32,56,34],[34,1,34,8],[36,1,36,8],[38,1,38,8],[40,1,40,8],[34,9,34,10],[36,9,36,10],[38,9,38,10],[40,9,40,10],[34,11,34,15],[36,11,36,15],[38,11,38,15],[40,11,40,15],[17,13,17,14],[12,1,12,25],[14,1,14,25],[17,15,17,17],[17,18,17,28],[63,2,63,3],[62,7,62,25],[63,7,63,25],[43,7,43,25],[43,2,43,3],[43,5,43,6],[52,9,52,10],[52,11,52,12],[52,13,52,14],[57,5,57,6],[57,7,57,25],[51,1,51,28],[53,1,53,28],[52,27,52,28],[45,5,45,6],[46,5,46,6],[44,7,44,25],[45,7,45,25],[46,7,46,25],[34,16,34,17],[36,16,36,17],[38,16,38,17],[40,16,40,17],[34,18,34,22],[36,18,36,22],[32,35,32,36],[32,32,32,33],[32,1,32,28],[35,1,35,28],[37,1,37,28],[39,1,39,28],[34,23,34,28],[36,23,36,28],[38,23,38,28],[38,18,38,22],[40,18,40,22],[40,23,40,28],[65,1,65,28],[63,5,63,6],[62,5,62,6],[50,13,50,14],[50,15,50,16],[50,17,50,19],[50,20,50,22],[50,4,50,5],[47,1,47,28],[49,1,49,28],[54,5,54,6],[54,7,54,28],[52,15,52,16],[52,17,52,18],[52,19,52,20],[50,1,50,3],[48,1,48,28],[41,1,41,28],[42,2,42,3],[42,5,42,6],[42,7,42,28],[44,2,44,3],[64,1,64,28],[59,1,59,28],[54,2,54,3],[58,1,58,28],[60,1,60,28],[61,2,61,3],[61,5,61,6],[61,7,61,28],[55,2,55,3],[56,2,56,3],[56,5,56,6],[55,5,55,6],[56,7,56,25],[45,2,45,3],[99,36,99,38],[75,1,75,28],[76,1,76,28],[77,1,77,28],[78,1,78,28],[79,1,79,28],[80,1,80,28],[81,1,81,28],[83,1,83,4],[83,5,83,13],[83,14,83,17],[83,18,83,24],[82,1,82,25],[84,1,84,25],[94,32,94,33],[95,1,95,28],[96,2,96,3],[96,4,96,25],[97,2,97,3],[97,4,97,25],[88,1,88,25],[66,1,66,28],[85,17,85,18],[85,19,85,22],[85,23,85,24],[87,23,87,24],[87,18,87,22],[87,1,87,17],[67,2,67,3],[67,5,67,6],[67,7,67,28],[86,1,86,25],[82,26,88,26],[82,27,88,27],[82,28,88,28],[85,1,85,4],[85,5,85,6],[85,7,85,10],[85,11,85,12],[85,13,85,16],[24,32,24,33],[5,31,5,33],[5,34,5,37],[19,32,19,33],[25,1,25,28],[27,1,27,28],[28,2,28,3],[28,5,28,6],[28,7,28,28],[26,1,26,28],[11,23,11,24],[10,1,10,25],[8,1,8,25],[8,26,14,26],[8,27,14,27],[8,28,14,28],[11,5,11,6],[11,1,11,4],[18,1,18,28],[17,1,17,4],[17,5,17,8],[17,9,17,12],[13,1,13,17],[13,23,13,24],[30,5,30,6],[29,7,29,25],[30,7,30,25],[29,26,30,26],[29,27,30,27],[29,28,30,28],[29,5,29,6],[29,2,29,3],[30,2,30,3]]}
[]
[]
[]
[null,"BILL OF MATERIAL"]
[]
[null,{"$f":"IF(KQ=0,\"\",AF6&AI6&AM6&AN6&AQ6&AR6)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(OR(OR(OR(OR(OR(OR(Config=1,Config=2,Config=3,Config=4,Config=6,Config=7,Config=8)))))),\"Series 4, 4'' Round Post \"))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(OR(OR(Config=3,Config=4,Config=6)),\"/ Series 4, 4'' Round 90 Degree Post\",IF(OR(OR(Config=2,Config=7,Config=8)),\"/ Series 4, 4'' Round 4 Sided Post\",\"\")))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(OR(BodTyp>=1,AdapTyp>1),\" with \",\"\"))","v":""},{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\"Series 2 Bleed Body\",IF(BodTyp=2,\"Series 2 Slide Body\",IF(BodTyp=3,\"Series 2 Frameless Body\",IF(BodTyp=4,\"Series 3 Bleed Body\",IF(BodTyp=5,\"Series 3 Slide Body\",IF(BodTyp=6,\"Series 3 - 1/4 Round Body\",IF(BodTyp=7,\"Series 3 Frameless Body\",IF(BodTyp=8,\"Series 4 Frameless Body\"))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(AdapTyp>=1,\" and \",\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(AdapTyp=1,\"1/8'' Panel Adaptor\",IF(AdapTyp=2,\"1/4'' Panel Adaptor\",IF(AdapTyp=3,\"1/2'' Panel Adaptor\",\"\")))))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lengths Required","Lengths Used","Drops Used"]
[null,"Customer",null,null,null,null,null,null,null,null,null,null,null,null,"Order#"]
[]
[null,"Kit Quantity",null,null,null,0,null,"Cab./Panel Height",null,null,null,{"$f":"HgtB+PNLH1A+PNLH2A+PNLH3A+PNLH4A","v":0},null,"Cab./Panel Width",null,null,null,0,null,"Grade to Top",null,null,null,0]
[]
[null,"Enter Fractions as Decimals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clearance to Grade",null,null,null,null,{"$f":"OHS-(HgtB+PNLH1A+PNLH2A+PNLH3A+PNLH4A)","v":0}]
[]
[null,"Extrusions"]
[]
[null,"Body",null,null,null,null,null,null,null,"Body Height",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Body"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Body Type"]
[null,"`"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(Config=1,KQ*2,IF(Config=2,KQ*4,IF(Config=3,KQ*4,IF(Config=4,KQ*6,IF(Config=5,KQ*8,IF(Config=6,KQ*6,IF(Config=7,KQ*6,IF(Config=8,KQ*8,IF(Config=9,KQ*8,IF(Config=10,KQ*6,IF(Config=11,KQ*4)))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",HgtB))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\"1120\",IF(BodTyp=2,\"1110\",IF(BodTyp=3,\"1125\",IF(BodTyp=4,\"1270\",IF(BodTyp=5,\"1260\",IF(BodTyp=6,\"1280\",IF(BodTyp=7,\"1275\",IF(BodTyp=8,\"1355\",IF(BodTyp=9,\"1291\",IF(BodTyp=10,\"1290\",IF(BodTyp=11,\"1391\",IF(BodTyp=12,\"1390\"))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\"Series 2 Bleed Body - Mitered both ends - Sides/Ends\",IF(BodTyp=2,\"Series 2 Slide Body - Mitered both ends - Sides/Ends\",IF(BodTyp=3,\"Series 2 Frameless Body - Mitered both ends - Sides/Ends\",IF(BodTyp=4,\"Series 3 Bleed Body - Mitered both ends - Sides/Ends\",IF(BodTyp=5,\"Series 3 Slide Body - Mitered both ends - Sides/Ends\",IF(BodTyp=6,\"Series 3 - 1/4 Round Body - Mitered both ends - Sides/Ends\",IF(BodTyp=7,\"Series 3 Frameless Body - Mitered both ends - Sides/Ends\",IF(BodTyp=8,\"Series 4 Frameless Body - Mitered both ends - Sides/Ends\",IF(BodTyp=9,\"Series 3 S/F Access Body - Mitered both ends - Sides/Ends\",IF(BodTyp=10,\"Series 3 Access Body - Mitered both ends - Sides/Ends\",IF(BodTyp=11,\"Series 4 S/F Access Body - Mitered both ends - Sides/Ends\",IF(BodTyp=12,\"Series 4 Access - Mitered both ends - Sides/Ends\"))))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Cover"]
[null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(Config=1,KQ*2,IF(Config=2,KQ*4,IF(Config=3,KQ*4,IF(Config=4,KQ*6,IF(Config=5,KQ*8,IF(Config=6,KQ*6,IF(Config=7,KQ*6,IF(Config=8,KQ*8,IF(Config=9,KQ*8,IF(Config=10,KQ*6,IF(Config=11,KQ*4)))))))))))))","v":""},{"$f":"IF(HgtB=0,\"\",WdtB)","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\"1120\",IF(BodTyp=2,\"1110\",IF(BodTyp=3,\"1125\",IF(BodTyp=4,\"1270\",IF(BodTyp=5,\"1260\",IF(BodTyp=6,\"1280\",IF(BodTyp=7,\"1275\",IF(BodTyp=8,\"1355\",IF(BodTyp=9,\"1291\",IF(BodTyp=10,\"1290\",IF(BodTyp=11,\"1391\",IF(BodTyp=12,\"1390\"))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,\"Series 2 Bleed Body - Mitered both ends - Top and Bottom\",IF(BodTyp=2,\"Series 2 Slide Body - Mitered both ends - Top and Bottom\",IF(BodTyp=3,\"Series 2 Frameless Body - Mitered both ends - Top and Bottom\",IF(BodTyp=4,\"Series 3 Bleed Body - Mitered both ends - Top and Bottom\",IF(BodTyp=5,\"Series 3 Slide Body - Mitered both ends - Top and Bottom\",IF(BodTyp=6,\"Series 3 - 1/4 Round Body - Mitered both ends - Top and Bottom\",IF(BodTyp=7,\"Series 3 Frameless Body - Mitered both ends - Top and Bottom\",IF(BodTyp=8,\"Series 4 Frameless Body - Mitered both ends - Top and Bottom\",IF(BodTyp=9,\"Series 3 S/F Access Body - Mitered both ends - Top and Bottom\",IF(BodTyp=10,\"Series 3 Access Body - Mitered both ends - Top and Bottom\",IF(BodTyp=11,\"Series 4 S/F Access Body - Mitered both ends - Top and Bottom\",IF(BodTyp=12,\"Series 4 Access Body - Mitered both ends - Top and Bottom\"))))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Cover Type"]
[]
[null,"Cover"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(BodTyp=9,SCov,IF(BodTyp=10,SCov*2,IF(BodTyp=11,SCov,IF(BodTyp=12,SCov*2,)))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",HgtB+0.03125)))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(CovTyp=1,\"1694\",IF(CovTyp=2,\"1695\",IF(CovTyp=3,\"1693\",IF(CovTyp=4,\"1692\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(CovTyp=1,\"Slide Cover - Mitered both ends - Sides/Ends\",IF(CovTyp=2,\"Radius Slide Cover - Mitered both ends - Sides/Ends\",IF(CovTyp=3,\"Frameless Cover - Mitered both ends - Sides/Ends\",IF(CovTyp=4,\"Bleed Cover - Mitered both ends - Sides/Ends\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(BodTyp=9,TBCov,IF(BodTyp=10,TBCov*2,IF(BodTyp=11,TBCov,IF(BodTyp=12,TBCov*2,)))))))","v":""},{"$f":"IF(HgtB=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",WdtB+0.03125)))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(CovTyp=1,\"1694\",IF(CovTyp=2,\"1695\",IF(CovTyp=3,\"1693\",IF(CovTyp=4,\"1692\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(CovTyp=1,\"Slide Cover - Mitered both ends - Top and Bottom\",IF(CovTyp=2,\"Radius Slide Cover - Mitered both ends - Top and Bottom\",IF(CovTyp=3,\"Frameless Cover - Mitered both ends - Top and Bottom\",IF(CovTyp=4,\"Bleed Cover - Mitered both ends - Top and Bottom\")))))))","v":""}]
[]
[null,"Panel Adaptors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Panel Adaptor Type",null,1,"Panel Adaptor"]
[]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL1A=TRUE,\"Number of Panels\",\"\")))","v":""},null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL1A=TRUE,\"Height of Panels\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"PNLH1*PNLN1","v":0},"Panel 1"]
[]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL2A=TRUE,\"Number of Panels\",\"\")))","v":""},null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL2A=TRUE,\"Height of Panels\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"PNLH2*PNLN2","v":0},"Panel 2"]
[]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL3A=TRUE,\"Number of Panels\",\"\")))","v":""},null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL3A=TRUE,\"Height of Panels\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"PNLH3*PNLN3","v":0},"Panel 3"]
[]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL4A=TRUE,\"Number of Panels\",\"\")))","v":""},null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL4A=TRUE,\"Height of Panels\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"PNLH4*PNLN4","v":0},"Panel 4"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL1A=FALSE,\"\",IF(Config=1,PNLN1*2*KQ,IF(Config=2,PNLN1*4*KQ,IF(Config=3,PNLN1*4*KQ,IF(Config=4,PNLN1*6*KQ,IF(Config=5,PNLN1*8*KQ,IF(Config=6,PNLN1*6*KQ,IF(Config=7,PNLN1*6*KQ,IF(Config=8,PNLN1*8*KQ,IF(Config=9,PNLN1*4*KQ,IF(Config=10,PNLN1*3*KQ,IF(Config=11,PNLN1*2*KQ,\"\"))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL1A=FALSE,\"\",IF(PANL1A=TRUE,PNLH1,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL1A=FALSE,\"\",IF(AdapTyp=1,\"1203\",IF(AdapTyp=2,\"1202\",IF(AdapTyp=3,\"1204\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL1A=FALSE,\"\",IF(AdapTyp=1,\" 1/8'' Panel Adaptor - Both ends straight cut\",IF(AdapTyp=2,\" 1/4'' Panel Adaptor - Both ends straight cut\",IF(AdapTyp=3,\" 1/2'' Panel Adaptor - Both ends straight cut\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL2A=FALSE,\"\",IF(Config=1,PNLN2*2*KQ,IF(Config=2,PNLN2*4*KQ,IF(Config=3,PNLN2*4*KQ,IF(Config=4,PNLN2*6*KQ,IF(Config=5,PNLN2*8*KQ,IF(Config=6,PNLN2*6*KQ,IF(Config=7,PNLN2*6*KQ,IF(Config=8,PNLN2*8*KQ,IF(Config=9,PNLN2*4*KQ,IF(Config=10,PNLN2*3*KQ,IF(Config=11,PNLN2*2*KQ,\"\"))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL2A=FALSE,\"\",IF(PANL2A=TRUE,PNLH2,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL2A=FALSE,\"\",IF(AdapTyp=1,\"1203\",IF(AdapTyp=2,\"1202\",IF(AdapTyp=3,\"1204\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL2A=FALSE,\"\",IF(AdapTyp=1,\" 1/8'' Panel Adaptor - Both ends straight cut\",IF(AdapTyp=2,\" 1/4'' Panel Adaptor - Both ends straight cut\",IF(AdapTyp=3,\" 1/2'' Panel Adaptor - Both ends straight cut\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL3A=FALSE,\"\",IF(Config=1,PNLN3*2*KQ,IF(Config=2,PNLN3*4*KQ,IF(Config=3,PNLN3*4*KQ,IF(Config=4,PNLN3*6*KQ,IF(Config=5,PNLN3*8*KQ,IF(Config=6,PNLN3*6*KQ,IF(Config=7,PNLN3*6*KQ,IF(Config=8,PNLN3*8*KQ,IF(Config=9,PNLN3*4*KQ,IF(Config=10,PNLN3*3*KQ,IF(Config=11,PNLN3*2*KQ,\"\"))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL3A=FALSE,\"\",IF(PANL3A=TRUE,PNLH3,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL3A=FALSE,\"\",IF(AdapTyp=1,\"1203\",IF(AdapTyp=2,\"1202\",IF(AdapTyp=3,\"1204\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL3A=FALSE,\"\",IF(AdapTyp=1,\" 1/8'' Panel Adaptor - Both ends straight cut\",IF(AdapTyp=2,\" 1/4'' Panel Adaptor - Both ends straight cut\",IF(AdapTyp=3,\" 1/2'' Panel Adaptor - Both ends straight cut\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL4A=FALSE,\"\",IF(Config=1,PNLN4*2*KQ,IF(Config=2,PNLN4*4*KQ,IF(Config=3,PNLN4*4*KQ,IF(Config=4,PNLN4*6*KQ,IF(Config=5,PNLN4*8*KQ,IF(Config=6,PNLN4*6*KQ,IF(Config=7,PNLN4*6*KQ,IF(Config=8,PNLN4*8*KQ,IF(Config=9,PNLN4*4*KQ,IF(Config=10,PNLN4*3*KQ,IF(Config=11,PNLN4*2*KQ,\"\"))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(PANL4A=FALSE,\"\",IF(Panel=1,\"\",IF(PANL4A=TRUE,PNLH4,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(PANL4A=FALSE,\"\",IF(Panel=1,\"\",IF(AdapTyp=1,\"1203\",IF(AdapTyp=2,\"1202\",IF(AdapTyp=3,\"1204\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(PANL4A=FALSE,\"\",IF(AdapTyp=1,\" 1/8'' Panel Adaptor - Both ends straight cut\",IF(AdapTyp=2,\" 1/4'' Panel Adaptor - Both ends straight cut\",IF(AdapTyp=3,\" 1/2'' Panel Adaptor - Both ends straight cut\"))))))","v":""}]
[]
[null,"Post Configruation"]
[]
[]
[]
[null,"Post Length",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Config=1,KQ*2,IF(Config=2,KQ*2,IF(Config=3,KQ*2,IF(Config=4,KQ*2,IF(Config=5,\"\",IF(Config=6,KQ*2,IF(Config=7,KQ*3,IF(Config=8,KQ*4,IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Config=1,PLC,IF(Config=2,PLC,IF(Config=3,PLC,IF(Config=4,PLC,IF(Config=5,\"\",IF(Config=6,PLC,IF(Config=7,PLC,IF(Config=8,PLC,IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,\"\"))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"1337\",IF(Config=2,\"1337\",IF(Config=3,\"1337\",IF(Config=4,\"1337\",IF(Config=5,\"\",IF(Config=6,\"1337\",IF(Config=7,\"1337\",IF(Config=8,\"1337\",IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"Series 4 Round Post - Straigt cut both ends\",IF(Config=2,\"Series 4 Round Post - Straigt cut both ends\",IF(Config=3,\"Series 4 Round Post - Straigt cut both ends\",IF(Config=4,\"Series 4 Round Post - Straigt cut both ends\",IF(Config=5,\"\",IF(Config=6,\"Series 4 Round Post - Straigt cut both ends\",IF(Config=7,\"Series 4 Round Post - Straigt cut both ends\",IF(Config=8,\"Series 4 Round Post - Straigt cut both ends\",IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,\"\"))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"\",IF(Config=3,KQ*1,IF(Config=4,KQ*2,IF(Config=5,KQ*4,IF(Config=6,KQ*2,IF(Config=7,\"\",IF(Config=8,\"\",IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,KQ*1))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"\",IF(Config=3,PLC,IF(Config=4,PLC,IF(Config=5,PLC,IF(Config=6,PLC,IF(Config=7,\"\",IF(Config=8,\"\",IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,PLC))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"\",IF(Config=3,\"1339\",IF(Config=4,\"1339\",IF(Config=5,\"1339\",IF(Config=6,\"1339\",IF(Config=7,\"\",IF(Config=8,\"\",IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,\"1339\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"\",IF(Config=3,\"Series 4 - 90 Deg Round Post - Straigt cut both ends\",IF(Config=4,\"Series 4  - 90 Deg Round Post - Straigt cut both ends\",IF(Config=5,\"Series 4 - 90 Degree Post - Straight cut both ends\",IF(Config=6,\"Series 4 - 90 Deg Round Post - Straigt cut both ends\",IF(Config=7,\"\",IF(Config=8,\"\",IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,\"Series 4 - 90 Deg Round Post - Straight cut both ends\"))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Post Configuration"]
[null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,KQ*1,IF(Config=3,\"\",IF(Config=4,\"\",IF(Config=5,\"\",IF(Config=6,\"\",IF(Config=7,KQ*1,IF(Config=8,KQ*1,IF(Config=9,KQ*1,IF(Config=10,KQ*1,IF(Config=11,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,PLC,IF(Config=3,\"\",IF(Config=4,\"\",IF(Config=5,\"\",IF(Config=6,\"\",IF(Config=7,PLC,IF(Config=8,PLC,IF(Config=9,PLC,IF(Config=10,PLC,IF(Config=11,\"\"))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"1338\",IF(Config=3,\"\",IF(Config=4,\"\",IF(Config=5,\"\",IF(Config=6,\"\",IF(Config=7,\"1338\",IF(Config=8,\"1338\",IF(Config=9,\"1338\",IF(Config=10,\"1338\",IF(Config=11,\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"Series 4 - 4 Sided Round Post - Straigt cut both ends\",IF(Config=3,\"\",IF(Config=4,\"\",IF(Config=5,\"\",IF(Config=6,\"\",IF(Config=7,\"Series 4 - 4 Sided Round Post - Straigt cut both ends\",IF(Config=8,\"Series 4 - 4 Sided Round Post - Straigt cut both ends\",IF(Config=9,\"Series 4 - 4 Sided Round Post - Straigt cut both ends\",IF(Config=10,\"Series 4 - 4 Sided Round Post - Straigt cut both ends\",IF(Config=11,\"\"))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(PL=1,\"71.625\",IF(PL=2,\"84.000\",IF(PL=3,\"95.625\",IF(PL=4,\"108.000\",IF(PL=5,\"120.000\",IF(PL=6,\"132.000\",IF(PL=7,\"143.625\",IF(PL=8,\"156.000\",IF(PL=9,\"168.000\",IF(PL=10,CLEN)))))))))))","v":""},3,"Post Length"]
[]
[null,"Post Filler"]
[]
[null,"Qty.","Size (in)",null,null,"Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Config=1,KQ*2,IF(Config=2,KQ*4,IF(Config=3,KQ*4,IF(Config=4,KQ*6,IF(Config=5,KQ*8,IF(Config=6,KQ*6,IF(Config=7,KQ*6,IF(Config=8,KQ*8,IF(Config=9,KQ*4,IF(Config=10,KQ*3,IF(Config=11,KQ*2))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Config=1,CTG+6,IF(Config=2,CTG+6,IF(Config=3,CTG+6,IF(Config=4,CTG+6,IF(Config=5,CTG+6,IF(Config=6,CTG+6,IF(Config=7,CTG+6,IF(Config=8,CTG+6,IF(Config=9,CTG+6,IF(Config=10,CTG+6,IF(Config=11,CTG+6))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"1201\",IF(Config=2,\"1201\",IF(Config=3,\"1201\",IF(Config=4,\"1201\",IF(Config=5,\"1201\",IF(Config=6,\"1201\",IF(Config=7,\"1201\",IF(Config=8,\"1201\",IF(Config=9,\"1201\",IF(Config=10,\"1201\",IF(Config=11,\"1201\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=2,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=3,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=4,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=5,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=6,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=7,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=8,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=9,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=10,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=11,\"Series 4 - Round Post Filler - Straigt cut both ends\"))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,KQ*2,IF(Config=3,\"\",IF(Config=4,\"\",IF(Config=5,\"\",IF(Config=6,\"\",IF(Config=7,KQ*1,IF(Config=8,\"\",IF(Config=9,\"\",IF(Config=10,KQ*1,IF(Config=11,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,OHS+6,IF(Config=3,\"\",IF(Config=4,\"\",IF(Config=5,\"\",IF(Config=6,\"\",IF(Config=7,OHS+6,IF(Config=8,\"\",IF(Config=9,\"\",IF(Config=10,OHS+6,IF(Config=11,\"\"))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"1201\",IF(Config=3,\"\",IF(Config=4,\"\",IF(Config=5,\"\",IF(Config=6,\"\",IF(Config=7,\"1201\",IF(Config=8,\"\",IF(Config=9,\"\",IF(Config=10,\"1201\",IF(Config=11,\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=3,\"\",IF(Config=4,\"\",IF(Config=5,\"\",IF(Config=6,\"\",IF(Config=7,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=8,\"\",IF(Config=9,\"\",IF(Config=10,\"Series 4 - Round Post Filler - Straigt cut both ends\",IF(Config=11,\"\"))))))))))))","v":""}]
[]
[null,"Body Reveal"]
[]
[null,"Qty.","Size (in)",null,null,"Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(HgtB=0,WdtB=0),\"\",IF(Bod=1,\"\",IF(AND(Config=1,BodTyp>=1),KQ*2,IF(AND(Config=2,BodTyp>=1),KQ*4,IF(AND(Config=3,BodTyp>=1),KQ*4,IF(AND(Config=4,BodTyp>=1),KQ*6,IF(AND(Config=5,BodTyp>=1),KQ*8,IF(AND(Config=6,BodTyp>=1),KQ*6,IF(AND(Config=7,BodTyp>=1),KQ*6,IF(AND(Config=8,BodTyp>=1),KQ*8,IF(AND(Config=9,BodTyp>=1),KQ*4,IF(AND(Config=10,BodTyp>=1),KQ*3,IF(AND(Config=11,BodTyp>=1),KQ*2))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(HgtB=0,WdtB=0),\"\",IF(Bod=1,\"\",IF(AND(Config=1,BodTyp>=1),HgtB-0.125,IF(AND(Config=2,BodTyp>=1),HgtB-0.125,IF(AND(Config=3,BodTyp>=1),HgtB-0.125,IF(AND(Config=4,BodTyp>=1),HgtB-0.125,IF(AND(Config=5,BodTyp>=1),HgtB-0.125,IF(AND(Config=6,BodTyp>=1),HgtB-0.125,IF(AND(Config=7,BodTyp>=1),HgtB-0.125,IF(AND(Config=8,BodTyp>=1),HgtB-0.125,IF(AND(Config=9,BodTyp>=1),HgtB-0.125,IF(AND(Config=10,BodTyp>=1),HgtB-0.125,IF(AND(Config=11,BodTyp>=1),HgtB-0.125))))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(AND(HgtB=0,WdtB=0),\"\",IF(Bod=1,\"\",IF(AND(Config=1,BodTyp>=1),\"1200\",IF(AND(Config=2,BodTyp>=1),\"1200\",IF(AND(Config=3,BodTyp>=1),\"1200\",IF(AND(Config=4,BodTyp>=1),\"1200\",IF(AND(Config=5,BodTyp>=1),\"1200\",IF(AND(Config=6,BodTyp>=1),\"1200\",IF(AND(Config=7,BodTyp>=1),\"1200\",IF(AND(Config=8,BodTyp>=1),\"1200\",IF(AND(Config=9,BodTyp>=1),\"1200\",IF(AND(Config=10,BodTyp>=1),\"1200\",IF(AND(Config=11,BodTyp>=1),\"1200\"))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(HgtB=0,WdtB=0),\"\",IF(Bod=1,\"\",IF(Config=1,\"Series 2/3 Reveal - Straigt cut both ends\",IF(Config=2,\"Series 2/3 Reveal - Straigt cut both ends\",IF(Config=3,\"Series 2/3 Reveal - Straigt cut both ends\",IF(Config=4,\"Series 2/3 Reveal - Straigt cut both ends\",IF(Config=5,\"Series 2/3 Reveal - Straigt cut both ends\",IF(Config=6,\"Series 2/3 Reveal - Straigt cut both ends\",IF(Config=7,\"Series 2/3 Reveal - Straigt cut both ends\",IF(Config=8,\"Series 2/3 Reveal - Straigt cut both ends\",IF(Config=9,\"Series 2/3 Reveal - Straigt cut both ends\",IF(Config=10,\"Series 2/3 Reveal - Straigt cut both ends\",IF(Config=11,\"Series 2/3 Reveal - Straigt cut both ends\"))))))))))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BILL OF MATERIAL"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(Title=0,\"\",Title))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lengths Required","Lengths Used","Drops Used"]
[null,"Customer",null,null,null,{"$f":"IF(Cust=0,\"\",Cust)","v":""},null,null,null,null,null,null,null,null,"Order #",null,null,null,{"$f":"IF(Ordnum=0,\"\",Ordnum)","v":""}]
[]
[null,"Kit Quantity",null,null,null,{"$f":"IF(KQ=0,\"\",KQ)","v":""},null,"Cab./Panel Height",null,null,null,{"$f":"IF(Hgt=0,\"\",Hgt)","v":""},null,"Cab./Panel Width",null,null,null,{"$f":"IF(WdtB=0,\"\",WdtB)","v":""},null,"Overall Height",null,null,null,{"$f":"IF(OHS=0,\"\",OHS)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clearance to Grade",null,null,null,null,{"$f":"IF(CTG=0,\"\",CTG)","v":""}]
[]
[null,"Hardware"]
[null,"Body"]
[null,{"$f":"IF(HgtB=0,\"\",IF(BodTyp=6,\"\",IF(Config=1,CA*KQ,IF(Config=2,CA*2*KQ,IF(Config=3,CA*2*KQ,IF(Config=4,CA*3*KQ,IF(Config=5,CA*4*KQ,IF(Config=6,CA*3*KQ,IF(Config=7,CA*3*KQ,IF(Config=8,CA*4*KQ,IF(Config=9,CA*4*KQ,IF(Config=10,CA*3*KQ,IF(Config=11,CA*2*KQ,\"\")))))))))))))","v":""},{"$f":"IF(HgtB=0,\"\",IF(BodTyp=1,\"5331\",IF(BodTyp=2,\"5330\",IF(BodTyp=3,\"5331\",IF(BodTyp=4,\"5337\",IF(BodTyp=5,\"5335\",IF(BodTyp=6,\"\",IF(BodTyp=7,\"5337\",IF(BodTyp=8,\"5341\",IF(BodTyp=9,\"5338\",IF(BodTyp=10,\"5339\",IF(BodTyp=11,\"5340\",IF(BodTyp=12,\"5340\",\"\")))))))))))))","v":""},null,{"$f":"IF(HgtB=0,\"\",IF(BodTyp=1,\" Series 2 Bleed Body Corner Angle - 1'' x 1'' x 1/8'' (1-1/2'') - One per corner\",IF(BodTyp=2,\" Series 3 Slide Body Corner Angle - 1'' x 1'' x 1/8'' (2-1/4'') - One per corner\",IF(BodTyp=3,\" Series 2 Frameless Body Corner Angle - 1'' x 1'' x 1/8'' (1-1/2'') - One per corner\",IF(BodTyp=4,\" Series 3 Bleed Body Corner Angle - 1'' x 1'' x 1/8'' (2-11/16'') - One per corner\",IF(BodTyp=5,\" Series 3 Slide Body Corner Angle - 1'' x 1'' x 1/8'' (2-1/4'') - One per corner\",IF(BodTyp=6,\"\",IF(BodTyp=7,\" Series 3 Frameless Body Corner Angle - 1'' x 1'' x 1/8'' (2-11/16'') - One per corner\",IF(BodTyp=8,\" Series 4 Frameless Body Corner Angle - 1'' x 1'' x 1/8'' (3-9/16'') - Oner per corner\",IF(BodTyp=9,\" Series 3 Single Face Access Body Corner Angle - 2'' x 2'' x 1/8'' (1-1/2'') - Oner per corner\",IF(BodTyp=10,\" Series 3 Access Body Corner Angle - 2'' x 2'' x 1/8'' (1-5/16'') - Oner per corner\",IF(BodTyp=11,\" Series 4 Single Face Access Body Corner Angle - 2'' x 2'' x 1/8'' (2'') - Oner per corner\",IF(BodTyp=12,\" Series 4 Access Body Corner Angle - 2'' x 2'' x 1/8'' (2'') - Oner per corner\")))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BodTyp=1,\"4\",IF(BodTyp=2,\"4\",IF(BodTyp=3,\"4\",IF(BodTyp=4,\"4\",IF(BodTyp=5,\"4\",IF(BodTyp=6,\"\",IF(BodTyp=7,\"4\",IF(BodTyp=8,\"4\",IF(BodTyp=9,\"4\",IF(BodTyp=10,\"4\",IF(BodTyp=11,\"4\",IF(BodTyp=12,\"4\",\"\")))))))))))))","v":""},"Corner Angles"]
[null,{"$f":"IF(HgtB=0,\"\",IF(AND(BodTyp>=1,BodTyp<=5),\"\",IF(BodTyp=7,\"\",IF(BodTyp>=8,\"\",IF(Config=1,CK*KQ,IF(Config=2,CK*2*KQ,IF(Config=3,CK*2*KQ,IF(Config=4,CK*3*KQ,IF(Config=5,CK*4*KQ,IF(Config=6,CK*3*KQ,IF(Config=7,CK*3*KQ,IF(Config=8,CK*4*KQ,IF(Config=9,CK*4*KQ,IF(Config=10,CK*3*KQ,IF(Config=11,CK*2*KQ,\"\")))))))))))))))","v":""},{"$f":"IF(HgtB=0,\"\",IF(BodTyp=1,\"\",IF(BodTyp=2,\"\",IF(BodTyp=3,\"\",IF(BodTyp=4,\"\",IF(BodTyp=5,\"\",IF(BodTyp=6,\"5210\",IF(BodTyp=7,\"\",IF(BodTyp>=8,\"\",\"\")))))))))","v":""},null,{"$f":"IF(HgtB=0,\"\",IF(BodTyp=1,\"\",IF(BodTyp=2,\"\",IF(BodTyp=3,\"\",IF(BodTyp=4,\"\",IF(BodTyp=5,\"\",IF(BodTyp=6,\"Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(BodTyp=7,\"\",IF(BodTyp=8,\"\",\"\")))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BodTyp=1,\"\",IF(BodTyp=2,\"\",IF(BodTyp=3,\"\",IF(BodTyp=4,\"\",IF(BodTyp=5,\"\",IF(BodTyp=6,\"8\",IF(BodTyp=7,\"\",IF(BodTyp=8,\"\",IF(BodTyp=9,\"\",IF(BodTyp=10,\"\",IF(BodTyp=11,\"\",IF(BodTyp=12,\"\",\"\")))))))))))))","v":""},"Corner Keys"]
[null,{"$f":"IF(HgtB=0,\"\",IF(BodTyp=1,\"\",IF(BodTyp=3,\"\",IF(AND(BodTyp>=5,BodTyp<=8),\"\",IF(Config=1,SC*KQ,IF(Config=2,SC*2*KQ,IF(Config=3,SC*2*KQ,IF(Config=4,SC*3*KQ,IF(Config=5,SC*4*KQ,IF(Config=6,SC*3*KQ,IF(Config=7,SC*3*KQ,IF(Config=8,SC*4*KQ,IF(Config=9,SC*4*KQ,IF(Config=10,SC*3*KQ,IF(Config=11,SC*2*KQ,\"\")))))))))))))))","v":""},{"$f":"IF(HgtB=0,\"\",IF(BodTyp=1,\"\",IF(BodTyp=2,\"5240\",IF(BodTyp=3,\"\",IF(BodTyp=4,\"5240\",IF(BodTyp=5,\"\",IF(BodTyp=6,\"\",IF(BodTyp=7,\"\",IF(BodTyp=8,\"\",IF(BodTyp=9,\"5270\",IF(BodTyp=10,\"5270\",IF(BodTyp=11,\"5270\",IF(BodTyp=12,\"5270\",\"\")))))))))))))","v":""},null,{"$f":"IF(HgtB=0,\"\",IF(BodTyp=1,\"\",IF(BodTyp=2,\"Slide Body Corner Screw - #10 - 24 x 3/4'' S.S., C.S. sq/phil thread cutting screw - Type F - Two (2) per corner\",IF(BodTyp=3,\"\",IF(BodTyp=4,\"Slide Body Corner Screw - #10 - 24 x 3/4'' S.S., C.S. sq/phil thread cutting screw - Type F - Two (2) per corner\",IF(BodTyp=5,\"\",IF(BodTyp=6,\"\",IF(BodTyp=7,\"\",IF(BodTyp=8,\"\",IF(BodTyp=9,\" S/F Access Body Corner Screw - #8 x 1-1/2'' S.S Sq/Phillips Countersink - Type A - Two (2) per corner\",IF(BodTyp=10,\" Access Body Corner Screw - #8 x 1-1/2'' S.S Sq/Phillips Countersink - Type A - Two (2) per corner\",IF(BodTyp=11,\" S/F Access Body Corner Screw - #8 x 1-1/2'' S.S Sq/Phillips Countersink - Type A - Two (2) per corner\",IF(BodTyp=12,\" Access Body Corner Screw - #8 x 1-1/2'' S.S Sq/Phillips Countersink - Type A- Two (2) per corner\",\"\")))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BodTyp=1,\"\",IF(BodTyp=2,\"10\",IF(BodTyp=3,\"\",IF(BodTyp=4,\"10\",IF(BodTyp=5,\"\",IF(BodTyp=6,\"\",IF(BodTyp=7,\"\",IF(BodTyp=8,\"\",IF(BodTyp=9,\"10\",IF(BodTyp=10,\"10\",IF(BodTyp=11,\"10\",IF(BodTyp=12,\"10\",\"\")))))))))))))","v":""},"Screws"]
[null,{"$f":"IF(HgtB=0,\"\",IF(Config=1,((RVSCRS*2)+2)*KQ,IF(Config=2,((RVSCRS*4)+2)*KQ,IF(Config=3,((RVSCRS*4)+2)*KQ,IF(Config=4,((RVSCRS*6)+2)*KQ,IF(Config=5,((RVSCRS*8)+2)*KQ,IF(Config=6,((RVSCRS*8)+2)*KQ,IF(Config=7,((RVSCRS*6)+2)*KQ,IF(Config=8,((RVSCRS*8)+2)*KQ,IF(Config=9,((RVSCRS*4)+2)*KQ,IF(Config=10,((RVSCRS*3)+2)*KQ,IF(Config=11,((RVSCRS*2)+2)*KQ,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(HgtB>=1,\"5218\",\"\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(HgtB>=1,\" Reveal to Body Screw -  #10 x 1/2'' Sq/Phillips Pan Head Tapping Screw - Type AB - One (1) every 10'' on center \",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EVEN(((HgtB/10)+1))","v":2},"Reveal Screws"]
[null,"Covers"]
[null,{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(BodTyp=9,SCov*2,IF(BodTyp=10,SCov*4,IF(BodTyp=11,SCov*2,IF(BodTyp=12,SCov*4,)))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(CovTyp=1,\"5210\",IF(CovTyp=2,\"5226\",IF(CovTyp=3,\"5210\",IF(CovTyp=4,\"5210\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(BodTyp=9,\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(BodTyp=10,\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(BodTyp=11,\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(BodTyp=12,\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(Config=1,CvrScrB*KQ,IF(Config=2,CvrScrB*KQ*2,IF(Config=3,CvrScrB*KQ*2,IF(Config=4,CvrScrB*KQ*3,IF(Config=5,CvrScrB*KQ*4,IF(Config=6,CvrScrB*KQ*3,IF(Config=7,CvrScrB*KQ*3,IF(Config=8,CvrScrB*KQ*4,IF(Config=9,CvrScrB*KQ*4,IF(Config=10,CvrScrB*KQ*3,IF(Config=11,CvrScrB*KQ*2))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(CovTyp=1,\"5168\",IF(CovTyp=2,\"5168\",IF(CovTyp=3,\"5168\",IF(CovTyp=4,\"5168\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(BodTyp=9,\" Slide Cover Screw - #8 x 1/2'' S.S. Sq./Phillips countersink screw Type A - 12'' OC\",IF(BodTyp=10,\" Radius Slide Cover Screw - #8 x 1/2'' S.S. Sq./Phillips countersink screw Type A - 12'' OC\",IF(BodTyp=11,\" Frameless Cover Screw - #8 x 1/2'' S.S. Sq./Phillips countersink screw Type A - 12'' OC\",IF(BodTyp=12,\" Bleed Cover Screw - #8 x 1/2'' S.S. Sq./Phillips countersink screw Type A - 12'' OC\")))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Cov=1,\"\",IF(BodTyp<=8,\"\",IF(BodTyp=9,CvrScr,IF(BodTyp=10,CvrScr*2,IF(BodTyp=11,CvrScr,IF(BodTyp=12,CvrScr*2,)))))))","v":""},{"$f":"AG98+AH98+AI98+AJ98","v":0},{"$f":"Hgt/12","v":0},{"$f":"WdtB/12","v":0},{"$f":"Hgt/12","v":0},{"$f":"WdtB/12","v":0}]
[null,"Adaptors"]
[null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(Config=1,ADPTScrws*KQ,IF(Config=2,ADPTScrws*KQ,IF(Config=3,ADPTScrws*KQ,IF(Config=4,ADPTScrws*KQ,IF(Config=5,ADPTScrws*KQ,IF(Config=6,ADPTScrws*KQ,IF(Config=7,ADPTScrws*KQ,IF(Config=8,ADPTScrws*KQ,IF(Config=9,ADPTScrws*KQ,IF(Config=10,ADPTScrws*KQ,IF(Config=11,ADPTScrws*KQ)))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",\"5218\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",\"Adaptor to Panel Screw - #10 x 1/2'' S.S. sq/phil pan head tapping screw - Type AB - One every 10'' on center\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PANL1A=FALSE,0,IF(PANL1A=TRUE,ROUNDUP(PNLH1/6,0)+1)*PNLAQ1)","v":0},{"$f":"IF(PANL2A=FALSE,0,IF(PANL2A=TRUE,ROUNDUP(PNLH2/6,0)+1)*PNLAQ2)","v":0},{"$f":"IF(PANL3A=FALSE,0,IF(PANL3A=TRUE,ROUNDUP(PNLH3/6,0)+1)*PNLAQ3)","v":0},{"$f":"IF(PANL4A=FALSE,0,IF(PANL4A=TRUE,ROUNDUP(PNLH4/6,0)+1)*PNLAQ4)","v":0},{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",SUM(AF100:AI100)+2))","v":""},"Panel Adaptor Screw"]
[null,"Post Caps"]
[null,{"$f":"IF(KQ=0,\"\",IF(Config=1,KQ*2,IF(Config=2,KQ*2,IF(Config=3,KQ*2,IF(Config=4,KQ*2,IF(Config=5,\"\",IF(Config=6,KQ*2,IF(Config=7,KQ*3,IF(Config=8,KQ*4,IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,\"\",\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Config=1,\"5430\",IF(Config=2,\"5430\",IF(Config=3,\"5430\",IF(Config=4,\"5430\",IF(Config=5,\"\",IF(Config=6,\"5430\",IF(Config=7,\"5430\",IF(Config=8,\"5430\",IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"Series 4 Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=2,\"Series 4 Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=3,\"Series 4 Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=4,\"Series 4 Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=5,\"\",IF(Config=6,\"Series 4 Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=7,\"Series 4 Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=8,\"Series 4 Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,\"\"))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"\",IF(Config=3,KQ*1,IF(Config=4,KQ*2,IF(Config=5,KQ*4,IF(Config=6,KQ*2,IF(Config=7,\"\",IF(Config=8,\"\",IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,KQ*1))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"\",IF(Config=3,\"5431\",IF(Config=4,\"5431\",IF(Config=5,\"5431\",IF(Config=6,\"5431\",IF(Config=7,\"\",IF(Config=8,\"\",IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,\"5431\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"\",IF(Config=3, \"Series 4, 90 deg Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=4,\"Series 4, 90 deg Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=5,\"Series 4, 90 deg Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=6,\"Series 4, 90 deg Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=7,\"\",IF(Config=8,\"\",IF(Config=9,\"\",IF(Config=10,\"\",IF(Config=11,\"Series 4, 90 deg Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\"))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,KQ*1,IF(Config=3,\"\",IF(Config=4,\"\",IF(Config=5,\"\",IF(Config=6,\"\",IF(Config=7,KQ*1,IF(Config=8,KQ*1,IF(Config=9,KQ*1,IF(Config=10,KQ*1,IF(Config=11,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"5432\",IF(Config=3,\"\",IF(Config=4,\"\",IF(Config=5,\"\",IF(Config=6,\"\",IF(Config=7,\"5432\",IF(Config=8,\"5432\",IF(Config=9,\"5432\",IF(Config=10,\"5432\",IF(Config=11,\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Config=1,\"\",IF(Config=2,\"Series 4, 4 Sided Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=3, \"\",IF(Config=4,\"\",IF(Config=5,\"\",IF(Config=6,\"\",IF(Config=7,\"Series 4, 4 Sided Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=8,\"Series 4, 4 Sided Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=9,\"Series 4, 4 Sided Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=10,\"Series 4, 4 Sided Round Post Cap - 3/4'' Reveal Tab - Note: Reveal Tab to be trimmed to fit 3/8'' and Zero Reveal positions\",IF(Config=11,\"\"))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(KQ=0,\"\",IF(Config=1,CPS,IF(Config=2,CPS,IF(Config=3,CPS,IF(Config=4,CPS,IF(Config=5,CPS,IF(Config=6,CPS,IF(Config=7,CPS,IF(Config=8,CPS,IF(Config=9,CPS,IF(Config=10,CPS,IF(Config=11,CPS))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(Config>=1,Config<=11),\"5040\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(Config>=1,Config<=11),\"Post Cap Screw - #10 x 1/2'' stainless steel counter sunk sq/phillips screw - Type A - Two (2) per cap\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Config=1,KQ*5,IF(Config=2,KQ*7,IF(Config=3,KQ*7,IF(Config=4,KQ*9,IF(Config=5,KQ*9,IF(Config=6,KQ*9,IF(Config=7,KQ*9,IF(Config=8,KQ*11,IF(Config=9,KQ*3,IF(Config=10,KQ*3,IF(Config=11,KQ*3))))))))))))","v":""},"Cap Screws"]
[]
[null,"Face Trim Size - Panel Cut Length"]
[]
[null,"Panel and/or Face - (Not Included in Kit)"]
[]
[null,"Panel Cut Size (Width) for Panel Adaptors"]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(AND(AdapTyp>=1,Config>=9),WdtB+1,\"\")))","v":""},null,"Single Adaptor (One end)",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Panel=1,\"\",IF(AND(AdapTyp>=1,Config<=8),WdtB+2,\"\")))","v":""},null,"Double Adaptor (Both ends)"]
[]
[null,"Face Trim Size"]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,HgtB-0.2,IF(BodTyp=2,HgtB-0.375,IF(BodTyp=3,HgtB,IF(BodTyp=4,HgtB-0.25,IF(BodTyp=5,HgtB-0.375,IF(BodTyp=6,HgtB-1,IF(BodTyp=7,HgtB,IF(BodTyp=8,HgtB,\"\"))))))))))","v":""},null,"Face Height",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Bod=1,\"\",IF(BodTyp=1,WdtB-0.2,IF(BodTyp=2,WdtB-0.375,IF(BodTyp=3,WdtB,IF(BodTyp=4,WdtB-0.25,IF(BodTyp=5,WdtB-0.375,IF(BodTyp=6,WdtB-1,IF(BodTyp=7,WdtB,IF(BodTyp=8,HgtB,\"\"))))))))))","v":""},null,"Face Width"]