{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Series 1 Post & Panel"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":12,"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 1 Post & Panel","index":0,"n_rows":50,"n_cols":35,"rows_kept":50,"cut":false,"hidden":false,"merged":[[5,30,5,35],[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],[6,1,6,28],[9,1,9,25],[11,1,11,25],[49,5,49,6],[49,8,49,9],[49,10,49,27],[47,1,47,11],[35,1,35,28],[37,1,37,6],[39,3,39,4],[39,5,39,7],[39,10,39,11],[39,12,39,14],[44,12,44,14],[42,1,42,5],[44,3,44,4],[44,5,44,7],[44,10,44,11],[34,1,34,28],[26,1,26,28],[28,1,28,28],[31,1,31,28],[27,1,27,28],[30,2,30,3],[29,2,29,3],[29,4,29,25],[30,4,30,25],[33,1,33,28],[1,1,1,28],[20,5,20,6],[20,7,20,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],[10,7,10,10],[2,1,2,28],[4,1,4,28],[25,1,25,28],[32,1,32,28],[24,1,24,28],[23,1,23,28],[21,5,21,6],[21,2,21,3],[21,7,21,25],[22,2,22,3],[22,4,22,6],[22,7,22,25],[20,2,20,3],[10,5,10,6],[10,11,10,12],[16,1,16,18],[16,19,16,28],[17,1,17,28],[19,1,19,28],[18,21,18,22],[18,23,18,28],[18,1,18,20]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"POSTMT","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(AND(PST=1,MNT=1),\" Series 1, 2'' Square Post - Single Post Flag Mounted\",IF(AND(PST=2,MNT=1),\" Series 1, 3-1/4'' Square Post - Single Post Flag Mounted\",IF(AND(PST=3,MNT=1),\" Series 1, 3-1/4'' Round Post - Single Post Flag Mounted\",IF(AND(PST=1,MNT=2),\" Series 1, 2'' Square Post - Double Post Mounted\",IF(AND(PST=2,MNT=2),\" Series 1, 3-1/4'' Square Post - Double Post Mounted\",IF(AND(PST=3,MNT=2),\" Series 1, 3-1/4'' Round Post - Double Post Mounted\",\"\")))))))","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,"Face Height  ",null,null,null,0,null,"Face 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 Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mounting",null,null,null,null,null,null,null,null,null,null,1,"Post",2,"Mount"]
[]
[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,1,"Length"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(MNT=1,1*KQ,IF(MNT=2,KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",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(PST=1,\"1000\",IF(PST=2,\"1005\",IF(PST=3,\"1007\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(PST=1,MNT=1),\" Series 1, 2'' Square Post - Single Post Flag Mounted\",IF(AND(PST=2,MNT=1),\" Series 1, 3-1/4'' Square Post - Single Post Flag Mounted\",IF(AND(PST=3,MNT=1),\" Series 1, 3-1/4'' Round Post - Single Post Flag Mounted\",IF(AND(PST=1,MNT=2),\" Series 1, 2'' Square Post - Double Post Mounted\",IF(AND(PST=2,MNT=2),\" Series 1, 3-1/4'' Square Post - Double Post Mounted\",IF(AND(PST=3,MNT=2),\" Series 1, 3-1/4'' Round Post - Double Post Mounted\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(MNT=1,1*KQ,IF(MNT=2,KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(PST<=3,Hgt,\"\"))","v":""},null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(PST<=3,\" Slot Length - One (1) Slot per post,\"\"\"))","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,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,"Hardware"]
[]
[null,"Hardware"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(MNT=1,1*KQ,IF(MNT=2,KQ*2,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(PST=1,\"5250\",IF(PST=2,\"5252\",IF(PST=3,\"5254\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(PST=1,MNT=1),\" Series 1, 2'' Square Post Cap - Single Post Flag Mounted - One (1) cap per post\",IF(AND(PST=2,MNT=1),\" Series 1, 3-1/4'' Square Post Cap - Single Post Flag Mounted - One (1) cap per post\",IF(AND(PST=3,MNT=1),\" Series 1, 3-1/4'' Round Post Cap - Single Post Flag Mounted - One (1) cap per post\",IF(AND(PST=1,MNT=2),\" Series 1, 2'' Square Post Cap - Double Post Mounted - One (1) cap per post\",IF(AND(PST=2,MNT=2),\" Series 1, 3-1/4'' Square Post Cap - Double Post Mounted - One (1) cap per post\",IF(AND(PST=3,MNT=2),\" Series 1, 3-1/4'' Round Post Cap - Double Post Mounted - One (1) cap per post\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(MNT=1,3*KQ,IF(MNT=2,5*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(PST=1,\"5040\",IF(PST=2,\"5040\",IF(PST=3,\"5040\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",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\",IF(AND(PST=2,MNT=1),\" Cap Screw - #10 x 1/2 S.S. Countersink Sq./Phillips screw - Type A - Two (2) per post cap\",IF(AND(PST=3,MNT=1),\" Cap Screw - #10 x 1/2 S.S. Countersink Sq./Phillips screw - Type A - Two (2) per post cap\",IF(AND(PST=1,MNT=2),\" Cap Screw - #10 x 1/2 S.S. Countersink Sq./Phillips screw - Type A - Two (2) per post cap\",IF(AND(PST=2,MNT=2),\" Cap Screw - #10 x 1/2 S.S. Countersink Sq./Phillips screw - Type A - Two (2) per post cap\",IF(AND(PST=3,MNT=2),\" Cap Screw - #10 x 1/2 S.S. Countersink Sq./Phillips screw - Type A - Two (2) per post cap\",\"\")))))))","v":""}]
[]
[]
[null,"Face Trim Size - Visual Openings"]
[]
[null,"Face - (Not Included in kit)"]
[]
[null,"Face Trim Size"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(PST=1,Hgt,IF(PST=2,Hgt,IF(PST=3,Hgt,\"\"))))","v":""},null,"Height",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(AND(PST=1,MNT=1),Wdt+1.875,IF(AND(PST=2,MNT=1),Wdt+3.125,IF(AND(PST=3,MNT=1),Wdt+3.125,IF(AND(PST=1,MNT=2),Wdt+3.75,IF(AND(PST=2,MNT=2),Wdt+6.25,IF(AND(PST=3,MNT=2),Wdt+6.25,\"\")))))))","v":""},null,"Width"]
[]
[]
[null,"Visual Opening"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(PST=1,Hgt,IF(PST=2,Hgt,IF(PST=3,Hgt,\"\"))))","v":""},null,"Height",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(PST=1,Wdt,IF(PST=2,Wdt,IF(PST=3,Wdt,\"\"))))","v":""},null,"Width"]
[]
[]
[null,"Locking Strips - (Not Included in kit)"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(MNT=1,2*KQ,IF(MNT=2,KQ*4,\"\")))","v":""},"@",{"$f":"IF(KQ=0,\"\",IF(PST=1,\"1.625''\",IF(PST=2,\"2.936''\",IF(PST=3,\"2.936''\",\"\"))))","v":""},null,"x",{"$f":"IF(KQ=0,\"\",IF(PST=1,\"6.000''\",IF(PST=2,\"6.000''\",IF(PST=3,\"6.000''\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(PST<=3,MNT=1),\" 1/8'' or 3mm Alum or ACM Locking Strip - Two (2) Locking Strips attached to one end (height) of panel\",IF(AND(PST<=3,MNT=2),\" 1/8'' or 3mm Alum or ACM Locking Strip - Two (2) Locking Strips attached to each end (height) of panel\",\"\")))","v":""}]