{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Series CB"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":38,"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 CB","index":0,"n_rows":115,"n_cols":44,"rows_kept":115,"cut":false,"hidden":false,"merged":[[4,1,4,28],[6,1,6,28],[9,1,9,25],[24,7,24,25],[25,2,25,3],[18,1,18,28],[19,1,19,28],[22,1,22,28],[21,21,21,22],[21,23,21,28],[21,1,21,20],[25,5,25,6],[25,7,25,25],[24,5,24,6],[24,2,24,3],[10,19,10,22],[12,1,12,17],[12,18,12,22],[10,23,10,24],[12,23,12,24],[11,1,11,25],[1,1,1,28],[23,5,23,6],[23,7,23,28],[10,1,10,4],[5,1,5,28],[3,1,3,28],[8,1,8,4],[8,5,8,13],[8,14,8,17],[14,1,14,28],[15,1,15,28],[10,13,10,16],[10,17,10,18],[20,1,20,28],[23,2,23,3],[10,5,10,6],[10,11,10,12],[2,1,2,28],[7,1,7,25],[7,27,13,27],[7,28,13,28],[8,18,8,24],[13,1,13,25],[10,7,10,10],[46,31,46,32],[47,1,47,28],[49,2,49,3],[39,2,39,3],[39,5,39,6],[39,7,39,25],[49,7,49,25],[46,1,46,28],[48,2,48,3],[48,5,48,6],[48,7,48,28],[49,5,49,6],[45,1,45,28],[44,14,44,28],[44,1,44,7],[85,1,85,28],[69,1,69,28],[70,1,70,28],[71,1,71,28],[17,1,17,28],[16,1,16,28],[89,1,89,28],[88,2,88,3],[7,26,13,26],[27,1,27,28],[44,8,44,11],[44,12,44,13],[72,1,72,28],[73,1,73,28],[74,1,74,28],[50,7,50,25],[50,2,50,3],[50,5,50,6],[30,6,30,7],[30,12,30,13],[30,1,30,2],[30,18,30,19],[30,24,30,25],[32,6,32,7],[28,1,28,28],[29,1,29,28],[35,2,35,3],[35,5,35,6],[35,7,35,25],[43,1,43,28],[31,1,31,28],[26,2,26,3],[26,5,26,6],[26,7,26,25],[32,1,32,2],[36,2,36,3],[37,2,37,3],[38,2,38,3],[36,5,36,6],[37,5,37,6],[38,5,38,6],[34,2,34,3],[34,5,34,6],[34,7,34,28],[36,7,36,25],[37,7,37,25],[38,7,38,25],[40,1,42,28],[5,43,5,45],[86,30,86,31],[94,2,94,3],[94,4,94,25],[5,30,5,33],[5,34,5,36],[5,37,5,38],[5,39,5,42],[84,1,84,5],[84,6,84,9],[84,10,84,28],[87,30,87,34],[88,30,88,34],[88,35,88,38],[87,35,87,38],[87,2,87,3],[87,4,87,25],[88,4,88,25],[77,1,77,25],[79,1,79,25],[81,1,81,25],[78,1,78,4],[78,5,78,6],[78,7,78,10],[75,26,81,26],[75,27,81,27],[75,28,81,28],[76,1,76,4],[76,5,76,13],[76,14,76,17],[90,1,90,28],[91,1,91,28],[92,2,92,3],[92,4,92,28],[76,18,76,24],[82,1,82,28],[86,2,86,3],[86,4,86,28],[78,11,78,12],[78,13,78,16],[78,17,78,18],[78,19,78,22],[78,23,78,24],[80,23,80,24],[80,18,80,22],[80,1,80,17],[75,1,75,25],[83,1,83,28],[103,2,103,3],[104,2,104,3],[94,31,94,32],[100,4,100,25],[101,4,101,25],[102,4,102,25],[103,4,103,25],[104,4,104,25],[95,2,95,3],[95,4,95,25],[93,28,95,28],[93,2,93,3],[93,4,93,25],[96,1,96,28],[97,1,97,28],[98,1,98,28],[105,4,105,25],[106,1,106,28],[99,4,99,28],[100,28,105,28],[114,3,114,17],[114,30,114,37],[105,31,105,32],[110,1,110,28],[109,1,109,28],[113,3,113,7],[113,8,113,25],[111,8,111,9],[111,16,111,25],[105,2,105,3],[111,12,111,14],[111,3,111,4],[111,5,111,7],[111,10,111,11],[107,1,107,28],[108,1,108,28],[99,2,99,3],[100,2,100,3],[101,2,101,3],[102,2,102,3]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"AE6&AM9&AN6&AR9&AR6&AL6&AI6","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,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,PST=1),\" Series 2, 2'' Square Post\",IF(AND(POST=1,PST=2),\" Series 3, 3-1/4'' Square Post\",IF(AND(POST=1,PST=3),\" Series 3, 3-1/4'' Round Post\",IF(AND(POST=1,PST=4),\" Series 3, 3-1/4'' Rectangular Post\",IF(AND(POST=1,PST=5),\" Series 3, 3-1/4'' Radius Post\",IF(AND(POST=1,PST=6),\" Series 3, 3-1/4'' Triangular Post\",IF(AND(POST=1,PST=7),\" Series 3, 3-1/4'' Square Post w/Radius Edges\",IF(AND(POST=1,PST=8),\" Series 3, 3-1/4'' Rectangular Post w/Radius Edges\",IF(AND(POST=1,PST=9),\" Series 3, 3-1/4'' Triangular Post w/Radius Edges\",IF(AND(POST=1,PST=10),\" Series 4, 4'' Round Post\",IF(AND(POST=1,PST=11),\" Series 4, 4'' Square Post\",\"\")))))))))))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(POST=1,\" - Double Post Mounted\",\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(RVLSET=1,\" - Zero Reveal\",IF(RVLSET=2,\" - 3/8'' Reveal\",IF(RVLSET=3,\" - 3/4'' Reveal\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"Series 2, 2'' Slide Body Header Panel\",IF(BodyType=2,\"Series 2, 2'' Bleed Body Header Panel\",IF(BodyType=3,\"Series 2, 2'' Frameless Body Header Panel\",IF(BodyType=4,\"Series 2, 2'' Beveled Frame Header Panel\",\"\"))))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(COPYBR=2,\"\",IF(COPYBR=1,\"Copy Bars\",\"\"))))","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,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(POST=2,\"\",IF(BOD=1,\"\",IF(BOD=2,\" - with \",\"\"))))","v":""},null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(COPYBR=2,\"\",IF(AND(COPYBR=1,BOD=1),\" - with \",IF(COPYBR=1,\" - and \",\"\")))))","v":""}]
[]
[null,"Kit Quantity  ",null,null,null,0,null,"Cab./Panel Height ",null,null,null,{"$f":"IF(KQ=0,\"\",IF(AND(COPYBR=1,BOD=1),SUM(AG31,AJ31,AM31,AP31,AG33,AJ33,HOC),IF(AND(COPYBR=2,BOD=2),HOC,IF(AND(COPYBR=1,BOD=2),SUM(AG31,AJ31,AM31,AP31,AG33,AJ33,HOC),\"\"))))","v":""},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":"IF(KQ=0,\"\",IF(Hgt=0,\"0.000\",OAH-Hgt))","v":""}]
[]
[null,"Extrusions"]
[]
[null,"Post",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,2,"Posts"]
[]
[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,"Post Type"]
[]
[]
[null,"Post Length",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,3,"Length"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(POST=1,KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(LNGTH=1,\"71.625\",IF(LNGTH=2,\"84.000\",IF(LNGTH=3,\"95.625\",IF(LNGTH=4,\"108.000\",IF(LNGTH=5,\"120.000\",IF(LNGTH=6,\"132.000\",IF(LNGTH=7,\"143.625\",IF(LNGTH=8,\"156.000\",IF(LNGTH=9,\"168.000\",IF(LNGTH=10,PSTLNT,\"\"))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST=1,\"1100\",IF(PST=2,\"1233\",IF(PST=3,\"1237\",IF(PST=4,\"1220\",IF(PST=5,\"1210\",IF(PST=6,\"1240\",IF(PST=7,\"1235\",IF(PST=8,\"1230\",IF(PST=9,\"1250\",IF(PST=10,\"1337\",IF(PST=11,\"1333\",\"\")))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,PST=1),\" Series 2, 2'' Square Post - Double Post Mounted\",IF(AND(POST=1,PST=2),\" Series 3, 3-1/4'' Square Post - Double Post Mounted\",IF(AND(POST=1,PST=3),\" Series 3, 3-1/4'' Round Post - Double Post Mounted\",IF(AND(POST=1,PST=4),\" Series 3, 3-1/4'' Rectangular Post - Double Post Mounted\",IF(AND(POST=1,PST=5),\" Series 3, 3-1/4'' Radius Post - Double Post Mounted\",IF(AND(POST=1,PST=6),\" Series 3, 3-1/4'' Triangular Post - Double Post Mounted\",IF(AND(POST=1,PST=7),\" Series 3, 3-1/4'' Square Post w/Radius Edges - Double Post Mounted\",IF(AND(POST=1,PST=8),\" Series 3, 3-1/4'' Rectangular Post w/Radius Edges - Double Post Mounted\",IF(AND(POST=1,PST=9),\" Series 3, 3-1/4'' Triangular Post w/Radius Edges - Double Post Mounted\",IF(AND(POST=1,PST=10),\" Series 4, 4'' Round Post - Double Post Mounted\",IF(AND(POST=1,PST=11),\" Series 4, 4'' Square Post - Double Post Mounted\",\"\")))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType>=1),KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(PST>=1,HOC-0.125,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(PST>=1,\"1200\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType>=1),\" Series 2/3/4 Reveal - Straight Cut Both Ends - (Reveal attached to both ends/sides, 1/8'' down from top)\",\"\")))","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,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(POST=1,2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST>=1,CTG+6,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(OR(PST=3,PST=10),\"1201\",IF(PST>=1,\"1200\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(OR(PST=3,PST=10),\" Series 3/4 Round Post Filler - Straight Cut Both Ends - (Below the cabinet/copy bar round post filler)\",IF(PST>=1,\" Series 2/3/4 Post Filler - Straight Cut Both Ends - (Below the cabinet/copy bar post filler)\",\"\"))))","v":""}]
[]
[null,"Copy Bars",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,2,"Copy Bar"]
[]
[null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,false,"2'' CB",{"$f":"IF(KQ=0,\"\",IF(CPYBR2a=FALSE,0,IF(CPYBR2a=TRUE,CPYBR2*2,\"\")))","v":""},false,"3'' CB",{"$f":"IF(KQ=0,\"\",IF(CPYBR3a=FALSE,\"0\",IF(CPYBR3a=TRUE,CPYBR3*3,\"\")))","v":""},false,"4'' CB",{"$f":"IF(KQ=0,\"\",IF(CPYBR4a=FALSE,\"0\",IF(CPYBR4a=TRUE,CPYBR4*4,\"\")))","v":""},false,"5'' CB",{"$f":"IF(KQ=0,\"\",IF(CPYBR5a=FALSE,\"0\",IF(CPYBR5a=TRUE,CPYBR5*5,\"\")))","v":""}]
[]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"6'' CB",{"$f":"IF(KQ=0,\"\",IF(CPYBR6a=FALSE,\"0\",IF(CPYBR6a=TRUE,CPYBR6*6,\"\")))","v":""},true,"Custom",{"$f":"IF(KQ=0,\"\",IF(CUSTCBa=FALSE,0,IF(CUSTCBa=TRUE,CUSTBR*CPYBRHgt,\"\")))","v":""}]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR2a=FALSE,\"\",IF(CPYBR2a=TRUE,CPYBR2*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR2a=FALSE,\"\",IF(CPYBR2a=TRUE,Wdt-0.25,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR2a=FALSE,\"\",IF(CPYBR2a=TRUE,\"1420\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR2a=FALSE,\"\",IF(CPYBR2a=TRUE,\" Series CB - 2'' Copy Bar - Straight cut both ends - Pre-drilled\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR3a=FALSE,\"\",IF(CPYBR3a=TRUE,CPYBR3*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR3a=FALSE,\"\",IF(CPYBR3a=TRUE,Wdt-0.25,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR3a=FALSE,\"\",IF(CPYBR3a=TRUE,\"1430\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR3a=FALSE,\"\",IF(CPYBR3a=TRUE,\" Series CB - 3'' Copy Bar - Straight cut both ends - Pre-drilled\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR4a=FALSE,\"\",IF(CPYBR4a=TRUE,CPYBR4*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR4a=FALSE,\"\",IF(CPYBR4a=TRUE,Wdt-0.25,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR4a=FALSE,\"\",IF(CPYBR4a=TRUE,\"1440\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR4a=FALSE,\"\",IF(CPYBR4a=TRUE,\" Series CB - 4'' Copy Bar - Straight cut both ends - Pre-drilled\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR5a=FALSE,\"\",IF(CPYBR5a=TRUE,CPYBR5*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR5a=FALSE,\"\",IF(CPYBR5a=TRUE,Wdt-0.25,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR5a=FALSE,\"\",IF(CPYBR5a=TRUE,\"1450\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR5a=FALSE,\"\",IF(CPYBR5a=TRUE,\" Series CB - 5'' Copy Bar - Straight cut both ends - Pre-drilled\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR6a=FALSE,\"\",IF(CPYBR6a=TRUE,CPYBR6*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR6a=FALSE,\"\",IF(CPYBR6a=TRUE,Wdt-0.25,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR6a=FALSE,\"\",IF(CPYBR6a=TRUE,\"1460\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR6a=FALSE,\"\",IF(CPYBR6a=TRUE,\" Series CB - 6'' Copy Bar - Straight cut both ends - Pre-drilled\",\"\"))))","v":""}]
[]
[]
[]
[]
[null,"Body",null,null,null,null,null,null,"Height of Cabinet",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Bodies"]
[]
[null,"Body Type",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,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD>=1,BOD<=4),2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD>=1,BOD<=4),Wdt,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"1110\",IF(BodyType=2,\"1120\",IF(BodyType=3,\"1125\",IF(BodyType=4,\"1990\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 2, 2'' Slide Body - Mitred both ends - Top and Bottom\",IF(BodyType=2,\" Series 2, 2'' Bleed Body - Mitered both ends - Top and Bottom\",IF(BodyType=3,\" Series 2, 2'' Frameless Body - Mitered both ends - Top and Bottom\",IF(BodyType=4,\" Series 2, 2'' Beveled Frame - Mitered Both Ends - Top and Bottom\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD>=1,BOD<=4),2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD>=1,BOD<=4),HOC,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"1110\",IF(BodyType=2,\"1120\",IF(BodyType=3,\"1125\",IF(BodyType=4,\"1990\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 2, 2'' Slide Body - Mitred both ends - Ends\",IF(BodyType=2,\" Series 2, 2'' Bleed Body - Mitered both ends - Ends\",IF(BodyType=3,\" Series 2, 2'' Frameless Body - Mitered both ends - Ends\",IF(BodyType=4,\" Series 2, 2'' Beveled Frame - Mitered Both Ends - Ends\",\"\"))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"IF(Descript=0,\"\",Descript)","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(Wdt=0,\"\",Wdt)","v":""},null,"Overall Height",null,null,null,{"$f":"IF(OAH=0,\"\",OAH)","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,"Post",null,null,null,null,"Reveal Postion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Reveal"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(POST=1,KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=1,RVLSET=1),\"5260\",IF(AND(PST=1,RVLSET=2),\"5261\",IF(AND(PST=1,RVLSET=3),\"5262\",IF(AND(PST=2,RVLSET=1),\"5405\",IF(AND(PST=2,RVLSET=2),\"5406\",IF(AND(PST=2,RVLSET=3),\"5407\",IF(AND(PST=3,RVLSET=1),\"5415\",IF(AND(PST=3,RVLSET=2),\"5416\",IF(AND(PST=3,RVLSET=3),\"5417\",IF(AND(PST=4,RVLSET=1),\"5010\",IF(AND(PST=4,RVLSET=2),\"5012\",IF(AND(PST=4,RVLSET=3),\"5014\",IF(AND(PST=5,RVLSET=1),\"5000\",IF(AND(PST=5,RVLSET=2),\"5002\",IF(AND(PST=5,RVLSET=3),\"5004\",IF(AND(PST=6,RVLSET=1),\"5015\",IF(AND(PST=6,RVLSET=2),\"5016\",IF(AND(PST=6,RVLSET=3),\"5017\",IF(AND(PST=7,RVLSET=1),\"5410\",IF(AND(PST=7,RVLSET=2),\"5411\",IF(AND(PST=7,RVLSET=3),\"5412\",IF(AND(PST=8,RVLSET=1),\"5006\",IF(AND(PST=8,RVLSET=2),\"5007\",IF(AND(PST=8,RVLSET=3),\"5008\",IF(AND(PST=9,RVLSET=1),\"5400\",IF(AND(PST=9,RVLSET=2),\"5401\",IF(AND(PST=9,RVLSET=3),\"5402\",IF(AND(PST=10,RVLSET>=1),\"5430\",IF(AND(PST=11,RVLSET>=1),\"5433\",\"\")))))))))))))))))))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(POST=1,PSTC1&PSTC2&PSTC3&PSTC4,\"\")))","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(PST=1,\" Series 2, 2'' Square Post Cap\",IF(PST=2,\" Series 3, 3-1/4'' Square Post Cap\",IF(PST=3,\" Series 3, 3-1/4'' Round Post Cap\",IF(PST=4,\" Series 3, 3-1/4'' Rectangular Post Cap\",IF(PST=5,\" Series 3, 3-1/4'' Radius Post Cap\",IF(PST=6,\" Series 3, 3-1/4'' Triangular Post Cap\",IF(PST=7,\" Series 3, 3-1/4'' Square Post Cap w/Radius Edges\",IF(PST=8,\" Series 3, 3-1/4'' Rectangular Post Cap w/Radius Edges\",IF(PST=9,\" Series 3, 3-1/4'' Triangular Post Cap w/Radius Edges\",IF(PST=10,\" Series 4, 4'' Round Post Cap\",IF(PST=11,\" Series 4, 4'' Square Post Cap\",\"\")))))))))))","v":" Series 2, 2'' Square Post Cap"},null,null,null,null,{"$f":"IF(RVLSET=1,\" - Zero Reveal\",IF(RVLSET=2,\" - 3/8'' Reveal\",IF(RVLSET=3,\" - 3/4'' Reveal\",\"\")))","v":" - Zero Reveal"}]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(PST=6,POST=1),8*KQ,IF(POST=1,6*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST=1,\"5040\",IF(PST=2,\"5040\",IF(PST=3,\"5040\",IF(PST=4,\"5040\",IF(PST=5,\"5040\",IF(PST=6,\"5040\",IF(PST=7,\"5040\",IF(PST=8,\"5040\",IF(PST=9,\"5040\",IF(PST=10,\"5040\",IF(PST=11,\"5040\",\"\")))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=6,POST=1),\" Cap Screw - #10 x 1/2 S.S. Countersink Sq./Phillips screw - Type A - Three (3) per Post Cap\",IF(AND(PST>=1,POST=1),\" Cap Screw - #10 x 1/2 S.S. Countersink Sq./Phillips screw - Type A - Two (2) per Post 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,{"$f":"IF(POST=2,\"\",IF(POST=1,\" - Double Post Mounted\",\"\"))","v":""},null,null,null,null,{"$f":"IF(POST=2,\"\",IF(POST=1,\" - Two (2) Post Caps - One (1) per Post\",\"\"))","v":""}]
[]
[null,"Body"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),4*KQ,IF(AND(BOD=2,BodyType=2),4*KQ,IF(AND(BOD=2,BodyType=3),4*KQ,IF(AND(BOD=2,BodyType=4),\"\",\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\"5330\",IF(AND(BOD=2,BodyType=2),\"5331\",IF(AND(BOD=2,BodyType=3),\"5331\",IF(AND(BOD=2,BodyType=4),\"\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\" Series 2 Slide Body Corner Angle - 1'' x 1'' x 1/8'' (1-1/8'') - One (1) per corner\",IF(AND(BOD=2,BodyType=2),\" Series 2 Bleed Body Corner Angle - 1'' x 1'' x 1/8'' (1-1/2'') - One (1) per corner\",IF(AND(BOD=2,BodyType=3),\" Series 2 Frameless Body Corner Angle - 1'' x 1'' x 1/8'' (1-1/2'') - One per corner\",IF(AND(BOD=2,BodyType=4),\"\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(POST=2,\"\",IF(AND(POST=1,BOD=2),(REVSCR+2)*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(POST=2,\"\",IF(AND(POST=1,BOD=2),\"5218\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(POST=2,\"\",IF(AND(POST=1,BOD=2),\" Reveal to Body Screw - #10 x 1/2'' S.S. Sq/Phillips pan head screw - One (1) every 6'' 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,{"$f":"IF(KQ=0,\"\",IF(BOD=2,ROUNDUP(HOC/6,0)*2,\"\"))","v":""},"Reveal Screw"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),10*KQ,IF(AND(BOD=2,BodyType=2),\"\",IF(AND(BOD=2,BodyType=3),\"\",IF(AND(BOD=2,BodyType=4),\"\",\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\"5240\",IF(AND(BOD=2,BodyType=2),\"\",IF(AND(BOD=2,BodyType=3),\"\",IF(AND(BOD=2,BodyType=4),\"\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\" Slide Body Corner Screw - 10-24 x 3/4'' S.S. Sq/Phillips countersink thread cutting screw - Two (2) per corner\",IF(AND(BOD=2,BodyType=2),\"\",IF(AND(BOD=2,BodyType=3),\"\",IF(AND(BOD=2,BodyType=4),\"\",\"\"))))))","v":""}]
[]
[null,"Copy Bars"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR2a=FALSE,\"\",IF(CPYBR2a=TRUE,CPYBR2*2*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR2a=FALSE,\"\",IF(CPYBR2a=TRUE,\"1412\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR2a=FALSE,\"\",IF(CPYBR2a=TRUE,\" Series CB - 2'' Copy Bar Reveal - Two (2) per Copy Bar\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR3a=FALSE,\"\",IF(CPYBR3a=TRUE,CPYBR3*2*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR3a=FALSE,\"\",IF(CPYBR3a=TRUE,\"1413\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR3a=FALSE,\"\",IF(CPYBR3a=TRUE,\" Series CB - 3'' Copy Bar Reveal - Two (2) per Copy Bar\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR4a=FALSE,\"\",IF(CPYBR4a=TRUE,CPYBR4*2*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR4a=FALSE,\"\",IF(CPYBR4a=TRUE,\"1414\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR4a=FALSE,\"\",IF(CPYBR4a=TRUE,\" Series CB - 4'' Copy Bar Reveal - Two (2) per Copy Bar\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR5a=FALSE,\"\",IF(CPYBR5a=TRUE,CPYBR5*2*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR5a=FALSE,\"\",IF(CPYBR5a=TRUE,\"1415\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR5a=FALSE,\"\",IF(CPYBR5a=TRUE,\" Series CB - 5'' Copy Bar Reveal - Two (2) per Copy Bar\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR6a=FALSE,\"\",IF(CPYBR6a=TRUE,CPYBR6*2*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR6a=FALSE,\"\",IF(CPYBR6a=TRUE,\"1416\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(CPYBR6a=FALSE,\"\",IF(CPYBR6a=TRUE,\" Series CB - 6'' Copy Bar Reveal - Two (2) per Copy Bar\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(COPYBR=1,(CpyBarScrw+2)*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(COPYBR=1,\"5168\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(COPYBR=2,\"\",IF(COPYBR=1,\" Copy Bar Reveal Attachment Screw - #8 x 1/2'' S.S. Sq/Phillips countersink screw - Four (4) per Copy Bar\",\"\")))","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(COPYBR=2,\"\",IF(COPYBR=1,SUM(CPYBR2*4,CPYBR3*4,CPYBR4*4,CPYBR5*4,CPYBR6*4))))","v":""},"Copy Bar Screw"]
[]
[null,"Face Trim Size"]
[]
[null,"Header Panel Face Trim Size - (Not Included in kit)"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,HOC-0.375,IF(BodyType=2,HOC-0.2,IF(BodyType=3,HOC,IF(BodyType=4,HOC-1.0625,\"\"))))))","v":""},null,"Height",null,null,"X",null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,Wdt-0.375,IF(BodyType=2,Wdt-0.2,IF(BodyType=3,Wdt,IF(BodyType=4,Wdt-1.0625,\"\"))))))","v":""},null,"Width"]
[]
[null,null,null,"Face Material Thickness:",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\" .125 Flat Aluminum or 3mm ACM\",IF(AND(BOD=2,BodyType=2),\" .100 -.125 Flat Aluminum or 3mm ACM\",IF(AND(BOD=2,BodyType=3),\" .125 Flat Aluminum or 3mm ACM with Solid Core\",IF(AND(BOD=2,BodyType=4),\" .125 Flat Aluminum or 3mm ACM\",\"\"))))))","v":""}]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\"\",IF(AND(BOD=2,BodyType=2),\"\",IF(AND(BOD=2,BodyType=3),\" NOTE: it is recommended to oversize the panels and trim off with flush router\",IF(AND(BOD=2,BodyType=4),\"\",\"\"))))))","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," NOTE: it is recommended to oversize the panels and trim off with flush router"]