{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Series 7 Post and Panels"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":22,"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 7 Post and Panels","index":0,"n_rows":64,"n_cols":40,"rows_kept":64,"cut":false,"hidden":false,"merged":[[59,8,59,9],[58,1,58,28],[59,1,59,2],[59,15,59,28],[60,1,60,28],[61,2,61,7],[61,8,61,20],[63,30,63,36],[63,3,63,15],[61,21,61,28],[63,1,63,2],[63,16,63,28],[62,1,62,28],[59,12,59,14],[59,3,59,4],[59,5,59,7],[59,10,59,11],[5,45,5,47],[41,30,41,31],[50,2,50,3],[50,4,50,25],[5,30,5,33],[5,34,5,36],[5,37,5,38],[5,39,5,42],[5,43,5,44],[41,2,41,3],[41,4,41,28],[44,1,44,28],[39,1,39,5],[39,6,39,9],[39,10,39,28],[42,30,42,34],[43,30,43,34],[43,35,43,38],[42,35,42,38],[42,2,42,3],[42,4,42,25],[43,4,43,25],[37,1,37,28],[29,1,29,28],[51,2,51,3],[51,4,51,25],[48,28,51,28],[52,1,52,28],[45,1,45,28],[46,1,46,28],[47,2,47,3],[47,4,47,28],[48,2,48,3],[48,4,48,25],[49,2,49,3],[49,4,49,25],[56,1,56,28],[57,1,57,28],[36,1,36,28],[7,1,7,25],[7,26,13,26],[7,27,13,27],[7,28,13,28],[10,19,10,22],[12,1,12,17],[12,18,12,22],[10,23,10,24],[12,23,12,24],[8,18,8,24],[13,1,13,25],[10,7,10,10],[11,1,11,25],[55,1,55,28],[53,1,53,28],[54,1,54,28],[38,1,38,28],[40,1,40,28],[17,1,17,28],[16,1,16,28],[43,2,43,3],[28,1,28,28],[50,31,50,32],[31,31,31,32],[32,1,32,28],[34,2,34,3],[35,2,35,3],[34,5,34,6],[35,5,35,6],[27,2,27,3],[27,5,27,6],[27,7,27,25],[30,1,30,28],[34,7,34,25],[35,7,35,25],[31,1,31,28],[33,2,33,3],[33,5,33,6],[33,7,33,28],[1,1,1,28],[24,5,24,6],[24,7,24,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],[19,1,19,28],[24,2,24,3],[10,5,10,6],[10,11,10,12],[2,1,2,28],[4,1,4,28],[6,1,6,28],[9,1,9,25],[25,7,25,25],[26,2,26,3],[20,1,20,28],[21,1,21,28],[18,1,18,28],[23,1,23,28],[22,21,22,22],[22,23,22,28],[22,1,22,20],[26,5,26,6],[26,7,26,25],[25,5,25,6],[25,2,25,3]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"AN6&AM9&AE6&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(PST=1,\"Series 7, 7'' Radius Post\",IF(PST=2,\"Series 7, 7'' Rectangular Post\",IF(PST=3,\"Series 7, 7'' Triangular Post\",\"\")))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(MNT=1,\" - Single Post Flag Mounted\",IF(MNT=2,\" - Double Post Mounted\",\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(BOD=1,\"\",IF(RVLSET=1,\" - Zero Reveal\",IF(RVLSET=2,\" - 1/2'' Reveal\",IF(RVLSET=3,\" - 1'' Reveal\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"Series 7, 7'' Slide Body\",IF(BodyType=2,\"Series 7, 7'' Bleed Body\",IF(BodyType=3,\"Series 7, 7'' Frameless Body\",IF(BodyType=4,\"Series 7, 7'' 1/4 Round Body\",\"\"))))))","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(POST=1,\" - with \",\"\"))))","v":""}]
[]
[null,"Kit Quantity  ",null,null,null,0,null,"Cab./Panel Height ",null,null,null,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":"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,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,2,"Mount"]
[]
[null,"Post Length",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,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(MNT=1,1*KQ,IF(MNT=2,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(AND(AND(PST=1,LNGTH=10,PSTLNT=72)),\"1500\",IF(AND(AND(AND(PST=1,LNGTH=10,PSTLNT>=73,PSTLNT<=96))),\"1500-10'\",IF(AND(AND(PST=1,LNGTH=10,PSTLNT>=97)),\"1500\",IF(AND(AND(PST=2,LNGTH=10,PSTLNT=72)),\"1510\",IF(AND(AND(AND(PST=2,LNGTH=10,PSTLNT>=73,PSTLNT<=96))),\"1510-10'\",IF(AND(AND(PST=2,LNGTH=10,PSTLNT>=97)),\"1510\",IF(AND(PST=1,LNGTH=4),\"1500-10\",IF(AND(PST=1,LNGTH=5),\"1500-10\",IF(AND(PST=2,LNGTH=4),\"1510-10\",IF(AND(PST=2,LNGTH=5),\"1510-10\",IF(PST=1,\"1500\",IF(PST=2,\"1510\",IF(PST=3,\"1530\",\"\")))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=1,MNT=1),\" Series 7, 7'' Radius Post - Single Post Flag Mounted\",IF(AND(PST=2,MNT=1),\" Series 7, 7'' Rectangular Post - Single Post Flag Mounted\",IF(AND(PST=3,MNT=1),\" Series 7, 7'' Triangular Post - Single Post Flag Mounted\",IF(AND(PST=1,MNT=2),\" Series 7, 7'' Radius Post - Double Post Mounted\",IF(AND(PST=2,MNT=2),\" Series 7, 7'' Rectangular Post - Double Post Mounted\",IF(AND(PST=3,MNT=2),\" Series 7, 7'' Triangular Post - Double Post Mounted\",\"\"))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(MNT=1,BOD=2),1*KQ,IF(AND(MNT=2,BOD=2),KQ*2,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST>=1,Hgt-0.125,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST>=1,\"1550\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(MNT=1,PST>=1),\" Series 7 Reveal - (Body Reveal attached to one end/side, 1/8'' down from top of cabinet)\",IF(AND(MNT=2,PST>=1),\" Series 7 Reveal - (Body Reveal attached to both ends/sides, 1/8'' down from top of cabinet)\",\"\"))))","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(AND(MNT=1,BOD=2),1*KQ,IF(AND(MNT=2,BOD=2),KQ*2,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST>=1,CTG+6,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST>=1,\"1550\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST>=1,\" Series 7 Post Filler - (Below the cabinet/panel post filler)\",\"\")))","v":""}]
[]
[null,"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,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<=11),2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD>=1,BOD<=11),Wdt,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"1560\",IF(BodyType=2,\"1570\",IF(BodyType=3,\"1575\",IF(BodyType=4,\"1580\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 7, 7'' Slide Body - Mitred both ends - Top and Bottom\",IF(BodyType=2,\" Series 7, 7'' Bleed Body - Mitered both ends - Top and Bottom\",IF(BodyType=3,\" Series 7, 7'' Frameless Body - Mitered both ends - Top and Bottom\",IF(BodyType=4,\" Series 7, 7'' 1/4 Round Body - Mitered Both Ends - Top and Bottom\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD>=1,BOD<=11),2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD>=1,BOD<=11),Hgt,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"1560\",IF(BodyType=2,\"1570\",IF(BodyType=3,\"1575\",IF(BodyType=4,\"1580\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 7, 7'' Slide Body - Mitred both ends - Ends\",IF(BodyType=2,\" Series 7, 7'' Bleed Body - Mitered both ends - Ends\",IF(BodyType=3,\" Series 7, 7'' Frameless Body - Mitered both ends - Ends\",IF(BodyType=4,\" Series 7, 7'' 1/4 Round Body - Mitered Both Ends - Ends\",\"\"))))))","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(MNT=1,1*KQ,IF(MNT=2,KQ*2,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=1,RVLSET=1),\"5020\",IF(AND(PST=1,RVLSET=2),\"5024\",IF(AND(PST=1,RVLSET=3),\"5026\",IF(AND(PST=2,RVLSET=1),\"5030\",IF(AND(PST=2,RVLSET=2),\"5034\",IF(AND(PST=2,RVLSET=3),\"5036\",IF(AND(PST=3,RVLSET=1),\"5425\",IF(AND(PST=3,RVLSET=2),\"5426\",IF(AND(PST=3,RVLSET=3),\"5427\",\"\")))))))))))","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 7, 7'' Radius Post Cap\",IF(PST=2,\" Series 7, 7'' Rectangular Post Cap\",IF(PST=3,\" Series 7, 7'' Triangular Post Cap\",\"\")))","v":" Series 7, 7'' Radius Post Cap"},null,null,null,null,{"$f":"IF(RVLSET=1,\" - Zero Reveal\",IF(RVLSET=2,\" - 1/2'' Reveal\",IF(RVLSET=3,\" - 1'' Reveal\",\"\")))","v":" - Zero Reveal"}]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=3,MNT=1),4*KQ,IF(AND(PST=3,MNT=2),7*KQ,IF(MNT=1,3*KQ,IF(MNT=2,KQ*5,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST=1,\"5040\",IF(PST=2,\"5040\",IF(PST=3,\"5040\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=3,MNT>=1),\" Cap Screw - #10 x 1/2 S.S. Countersink Sq./Phillips screw - Type A - Three (3) per Post Cap\",IF(AND(PST>=1,MNT>=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(MNT=1,\" - Single Post Flag Mounted\",IF(MNT=2,\" - Double Post Mounted\",\"\"))","v":" - Double Post Mounted"},null,null,null,null,{"$f":"IF(MNT=1,\" - One (1) Cap Per Post\",IF(MNT=2,\" - Two (2) Post Caps - One (1) per Post\",\"\"))","v":" - Two (2) Post Caps - One (1) per Post"}]
[]
[null,"Body"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),4*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\"5348\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\" Series 7 Slide Body Corner Angle - 2'' x 2'' x 1/8'' (5-3/4'') - One (1) per corner\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),8*KQ,IF(AND(BOD=2,BodyType=2),8*KQ,IF(AND(BOD=2,BodyType=3),8*KQ,IF(AND(BOD=2,BodyType=4),8*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\"5210\",IF(AND(BOD=2,BodyType=2),\"5210\",IF(AND(BOD=2,BodyType=3),\"5210\",IF(AND(BOD=2,BodyType=4),\"5210\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\" Series 7, Slide Body Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BOD=2,BodyType=2),\" Series 7, Bleed Body Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BOD=2,BodyType=3),\" Series 7, Frameless Body Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BOD=2,BodyType=4),\" Series 7, 1/4 Round Body Corner Key - .120 Stamped Aluminum - Two (2) per corner\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(POST=2,\"\",IF(AND(POST=1,MNT=1),REVSCR*KQ,IF(AND(POST=1,MNT=2),REVSCR*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(POST=2,\"\",IF(AND(POST=1,MNT=1),\"5218\",IF(AND(POST=1,MNT=2),\"5218\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(POST=2,\"\",IF(AND(POST=1,MNT=1),\" Reveal to Body Screw - #10 x 1/2'' S.S. Sq/Phillips pan head screw - Two (2) every 6'' on center\",IF(AND(POST=1,MNT=2),\" Reveal to Body Screw - #10 x 1/2'' S.S. Sq/Phillips pan head screw - Two (2) 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(MNT=1,(ROUNDUP(Hgt/6,0)*2)+2,IF(MNT=2,((ROUNDUP(Hgt/6,0)*2)*2)+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,"Face Trim Size"]
[]
[null,"Face - (Not Included in kit)"]
[]
[null,"Face Trim Size"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,Hgt-0.375,IF(BodyType=2,Hgt-0.25,IF(BodyType=3,Hgt,IF(BodyType=4,Hgt-1.25,\"\"))))))","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.25,IF(BodyType=3,Wdt,IF(BodyType=4,Wdt-1.25,\"\"))))))","v":""},null,"Width"]
[]
[null,null,"Face Material Thickness:",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BodyType=1,\" .125 Flat Aluminum or 3mm ACM\",IF(BodyType=2,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(BodyType=3,\" .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(BodyType=4,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",\"\")))))","v":""}]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(BodyType=1,\"\",IF(BodyType=2,\"\",IF(BodyType=3,\" It is recommended to oversize the panel and trim off with flush router\",IF(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," It is recommended to oversize the panel and trim off with flush router"]