{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Flat Bodies","Flex Face Dimensions"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":52,"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":"Flat Bodies","index":0,"n_rows":143,"n_cols":40,"rows_kept":143,"cut":false,"hidden":false,"merged":[[41,5,41,12],[20,30,21,30],[6,30,6,31],[5,30,5,35],[4,30,4,32],[100,34,100,35],[100,31,100,32],[98,36,98,39],[98,34,98,35],[98,31,98,32],[29,32,29,39],[25,37,25,38],[25,32,25,33],[20,31,21,32],[22,31,22,32],[12,31,12,32],[93,1,93,28],[94,2,94,3],[95,2,95,3],[96,2,96,3],[95,4,95,25],[96,4,96,25],[94,4,94,28],[65,1,65,28],[66,1,66,28],[67,1,67,28],[68,1,68,28],[69,1,69,28],[72,1,72,25],[70,1,70,4],[71,1,71,4],[70,5,70,13],[71,5,71,6],[71,7,71,10],[71,11,71,12],[71,13,71,16],[71,17,71,18],[71,19,71,25],[92,1,92,28],[70,14,70,17],[9,1,9,28],[45,2,45,3],[45,5,45,6],[45,7,45,25],[14,1,14,3],[91,1,91,28],[70,18,70,25],[70,26,72,26],[70,27,72,27],[70,28,72,28],[78,2,78,3],[79,2,79,3],[79,4,79,25],[80,4,80,25],[75,1,75,28],[78,4,78,28],[25,2,25,3],[24,5,24,6],[25,5,25,6],[32,2,32,3],[39,1,39,28],[40,1,40,28],[84,2,84,3],[14,5,14,11],[14,13,14,18],[14,19,14,28],[10,1,10,28],[12,1,13,28],[17,7,17,25],[18,2,18,3],[18,5,18,6],[88,4,88,25],[89,4,89,25],[17,2,17,3],[17,5,17,6],[26,5,26,6],[26,7,26,25],[32,5,32,6],[23,1,23,28],[81,1,81,28],[31,2,31,3],[31,5,31,6],[31,7,31,25],[27,2,27,3],[27,5,27,6],[27,7,27,25],[28,2,28,3],[28,5,28,6],[26,2,26,3],[24,7,24,28],[32,7,32,25],[90,2,90,3],[90,4,90,25],[85,28,90,28],[24,2,24,3],[25,7,25,25],[29,2,29,3],[29,5,29,6],[29,7,29,25],[37,2,37,3],[38,1,38,28],[37,4,37,25],[33,1,33,28],[74,1,74,28],[82,1,82,28],[83,1,83,28],[43,7,43,28],[28,7,28,25],[30,2,30,3],[30,5,30,6],[30,7,30,25],[41,1,41,3],[6,27,8,27],[105,1,105,28],[76,1,76,28],[77,1,77,28],[104,4,104,25],[79,28,80,28],[97,1,97,28],[98,1,98,28],[84,4,84,28],[101,1,101,28],[103,1,103,28],[85,4,85,25],[86,4,86,25],[87,4,87,25],[102,1,102,28],[80,2,80,3],[100,4,100,25],[85,2,85,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[89,2,89,3],[100,2,100,3],[99,1,99,28],[104,2,104,3],[1,1,1,28],[16,5,16,6],[16,7,16,28],[6,18,6,25],[7,1,7,4],[4,1,4,28],[5,1,5,28],[2,1,2,28],[6,1,6,4],[6,5,6,13],[7,17,7,18],[16,2,16,3],[7,5,7,6],[6,14,6,17],[7,11,7,12],[7,7,7,10],[7,13,7,16],[7,19,7,25],[8,1,8,25],[11,1,11,28],[3,1,3,28],[6,28,8,28],[6,26,8,26],[107,36,107,42],[100,37,100,38],[105,36,105,40],[106,36,106,42],[14,31,14,32],[15,1,15,28],[19,1,19,28],[20,1,21,28],[18,7,18,25],[36,2,36,3],[34,1,34,28],[36,4,36,28],[35,1,35,28],[22,1,22,28],[34,31,34,33],[41,14,41,20],[41,21,41,28],[44,2,44,3],[42,1,42,28],[73,1,73,28],[44,5,44,6],[44,7,44,25],[43,2,43,3],[43,5,43,6]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[null,{"$f":"AE5&AK6&AE6","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(BOD=1,\"\",IF(BodyType=1,\"Flat Single Face Body\",IF(BodyType=2,\"Flat Double Face Medium Body\",IF(BodyType=3,\"Flat Double Face Body\",IF(BodyType=4,\"Flat 2 Piece Double Face Medium Body\",IF(BodyType=5,\"Flat 2 Piece Double Face Body\",IF(BodyType=6,\"Flat Retro Body\",IF(BodyType=7,\"Flat Wall Mount Retro Body\",\"\")))))))))","v":""}]
[null,{"$f":"AE7","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(RET=1,\"\",IF(RetType=1,\" 1-1/2'' Retainer\",IF(RetType=2,\" 2'' Retainer\",IF(RetType=3,\" Flat Bleed Rigid Retainer\",IF(RetType=4,\" Flat Bleed Retro Frame and Flat Bleed Retro Frame Cover\",IF(RetType=5,\" Flat Bleed Retro Frame II and Flat Bleed Retro Frame Cover\")))))))","v":""},null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RET=1,\"\",IF(RetType=1,\" with\",IF(RetType=2,\" with\",IF(RetType=3,\" with\",IF(RetType=4,\" with\",IF(RetType=5,\" with\"))))))))","v":""}]
[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,"Lengths Required","Lengths Used","Drops Used",null,{"$f":"IF(KQ=0,\"\",\"Mill Finish\")","v":""}]
[null,"Kit Quantity  ",null,null,null,0,null,"Height  ",null,null,null,0,null,"Width",null,null,null,0,null,"Enter Fractions as Decimals"]
[null,"Add one inch (1'') the direction of the lamp when fluorescent lamps are to be used for illumination."]
[]
[null,"Extrusions"]
[]
[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,"Flat Bodies",null,1,"Bodies"]
[]
[null,"Body",null,null,null,{"$f":"IF(KQ=0,\"\",IF(BodyType=6,\"Retro Body Standard Add-on\",\"\"))","v":""},null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BodyType=6,\"Retro Body No Add-on\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Retro Add-on"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=3),KQ*2,IF(OR(BodyType=4,BodyType=5),KQ*4,IF(OR(BodyType=6,BodyType=7),KQ*2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=3),Hgt,IF(OR(BodyType=4,BodyType=5),Hgt,IF(AND(BodyType=6,AE15=1),Hgt+0.325,IF(AND(BodyType=6,AE15=2),Hgt+0.2,IF(BodyType=7,Hgt,\"\")))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"2027\",IF(BodyType=2,\"2007\",IF(BodyType=3,\"2008\",IF(BodyType=4,\"2010\",IF(BodyType=5,\"2009\",IF(BodyType=6,\"2041\",IF(BodyType=7,\"2042\",\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Flat Single Face Body - Sides - Mitered Both Ends \",IF(BodyType=2,\" Flat Double Face Medium Body - Sides - Mitered Both Ends\",IF(BodyType=3,\" Flat Double Face Body - Sides - Mitered Both Ends\",IF(BodyType=4,\" Flat 2 Piece Double Face Medium Body - Sides - Mitered Both Ends\",IF(BodyType=5,\" Flat 2 Piece Double Face Body - Sides - Mitered Both Ends\",IF(BodyType=6,\" Flat Retro Body - Sides - Mitered Both Ends\",IF(BodyType=7,\" Flat Wall Mount Retro Body - Sides - Mitered Both Ends\",\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=3),KQ*2,IF(OR(BodyType=4,BodyType=5),KQ*4,IF(OR(BodyType=6,BodyType=7),KQ*2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=3),Wdt,IF(OR(BodyType=4,BodyType=5),Wdt,IF(AND(BodyType=6,RetroADD=1),Wdt+0.325,IF(AND(BodyType=6,RetroADD=2),Wdt+0.2,IF(BodyType=7,Wdt,\"\")))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"2027\",IF(BodyType=2,\"2007\",IF(BodyType=3,\"2008\",IF(BodyType=4,\"2010\",IF(BodyType=5,\"2009\",IF(BodyType=6,\"2041\",IF(BodyType=7,\"2042\",\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Flat Single Face Body - Top and Bottom - Mitered Both Ends \",IF(BodyType=2,\" Flat Double Face Medium Body - Top and Bottom - Mitered Both Ends\",IF(BodyType=3,\" Flat Double Face Body - Top and Bottom - Mitered Both Ends\",IF(BodyType=4,\" Flat 2 Piece Double Face Medium Body - Top and Bottom - Mitered Both Ends\",IF(BodyType=5,\" Flat 2 Piece Double Face Body - Top and Bottom - Mitered Both Ends\",IF(BodyType=6,\" Flat Retro Body - Top and Bottom - Mitered Both Ends\",IF(BodyType=7,\" Flat Wall Mount Retro Body - Top and Bottom - Mitered Both Ends\",\"\")))))))))","v":""}]
[]
[null,"Retainer 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,"Retainers"]
[]
[null,"Retainer",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,"Retainers"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),KQ*2,IF(OR(BodyType>=2,BodyType<=5),KQ*4,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(BodyType=6,RetroADD=1),Hgt+0.325,IF(AND(BodyType=6,RetroADD=2),Hgt+0.2,IF(AND(RetType>=3,RetType<=5),Hgt,IF(OR(RetType=1,RetType=2),Hgt+0.03,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=1,\"2052\",IF(RetType=2,\"2047\",IF(RetType=3,\"2204\",IF(RetType=4,\"2104\",IF(RetType=5,\"2107\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=1,\" 1-1/2'' Retainer - Sides - Mitered Both Ends\",IF(RetType=2,\" 2'' Retainer - Sides - Mitered Both Ends\",IF(RetType=3,\" Flat Bleed Rigid Retainer - Sides - Mitered Both Ends\",IF(RetType=4,\" Flat Bleed Retro Frame - Sides - Mitered Both Ends\",IF(RetType=5,\" Flat Bleed Retro Frame II - Sides - Mitered 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,null,"Height (2121 Cover)",null,null,null,null,"Width (2121 Cover)"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Hgt>=432,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),KQ*2,IF(OR(BodyType>=2,BodyType<=5),KQ*4,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Hgt>=432,\"\",IF(AND(BodyType=6,RetroADD=1),HeightA+0.325,IF(AND(BodyType=6,RetroADD=2),HeightA+0.2,IF(RetType=4,HeightA,IF(RetType=5,HeightA,\"\"))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Hgt>=432,\"\",IF(RetType=4,\"2121-12'-3''\",IF(RetType=5,\"2121-12'-3''\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Hgt>=432,\"Exceeds Calulation Limits, to be Caculated Manually\",IF(AND(Hgt<=144,RetType=4),\" Flat Bleed Retro Frame Cover - Sides - Mitered Both Ends\",IF(AND(Hgt<=144,RetType=5),\" Flat Bleed Retro Frame Cover - Sides - Mitered Both Ends\",IF(AND(Hgt>=145,RetType=4),\" Flat Bleed Retro Frame Cover - Sides - Miter One End, Straight Cut One End\",IF(AND(Hgt>=145,RetType=5),\" Flat Bleed Retro Frame Cover - Sides - Miter One End, Straight Cut One End\",\"\"))))))))","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,{"$f":"IF(KQ=0,\"\",IF(Hgt<=144,Hgt,IF(Hgt>=169,144,IF(OR(Hgt>=145,Hgt<=287),Hgt-24))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Hgt<=144,\"\",IF(Hgt>=313,144,IF(AND(Hgt>=288,Hgt<=312),HeightD,IF(OR(Hgt>145,Hgt<=287),Hgt-HeightA,IF(Hgt>=313,144))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Hgt<=144,\"\",IF(AND(Hgt>145,Hgt<=287),\"\",IF(AND(Hgt>=289,Hgt<=312),24,IF(Hgt>=313,Hgt-288)))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Wdt<=144,Wdt,IF(Wdt>=169,144,IF(OR(Wdt>=145,Wdt<=287),Wdt-24))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Wdt<=144,\"\",IF(Wdt>=313,144,IF(AND(Wdt>=288,Wdt<=312),WidthD,IF(OR(Wdt>145,Wdt<=287),Wdt-WidthA,IF(Wdt>=313,144))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Wdt<=144,\"\",IF(AND(Wdt>145,Wdt<=287),\"\",IF(AND(Wdt>=289,Wdt<=312),24,IF(Wdt>=313,Wdt-288)))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Hgt>=432,\"\",IF(Hgt<=144,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),KQ*2,IF(OR(BodyType>=2,BodyType<=5),KQ*4,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Hgt>=432,\"\",IF(RetType=4,HeightB,IF(RetType=5,HeightB,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Hgt>=432,\"\",IF(Hgt<=144,\"\",IF(RetType=4,\"2121-12'-3''\",IF(RetType=5,\"2121-12'-3''\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Hgt>=432,\"\",IF(Hgt<=144,\"\",IF(RetType=4,\" Flat Bleed Retro Frame Cover - Sides - Miter One End, Straight Cut One End\",IF(RetType=5,\" Flat Bleed Retro Frame Cover - Sides - Miter One End, Straigt Cut One End\",\"\")))))))","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,{"$f":"IF(KQ=0,\"\",IF(AND(Hgt>=289,Hgt<=312),Hgt-144-24))","v":""},null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(AND(Wdt>=289,Wdt<=312),Wdt-144-24))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Hgt>=432,\"\",IF(Hgt<=288,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),KQ*2,IF(OR(BodyType>=2,BodyType<=5),KQ*4,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Hgt>=432,\"\",IF(RetType=4,HeightC,IF(RetType=5,HeightC,\"\"\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Hgt>=432,\"\",IF(Hgt<=288,\"\",IF(RetType=4,\"2121-12'-3''\",IF(RetType=5,\"2121-12'-3''\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Hgt>=432,\"\",IF(Hgt<=288,\"\",IF(RetType=4,\" Flat Bleed Retro Frame Cover - Top and Bottom - Straight Cut Both Ends\",IF(RetType=5,\" Flat Bleed Retro Frame Cover - Top and Bottom - Mitered Both Ends\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),KQ*2,IF(OR(BodyType>=2,BodyType<=5),KQ*4,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(BodyType=6,RetroADD=1),Wdt+0.325,IF(AND(BodyType=6,RetroADD=2),Wdt+0.2,IF(AND(RetType>=3,RetType<=5),Wdt,IF(OR(RetType=1,RetType=2),Wdt+0.03,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=1,\"2052\",IF(RetType=2,\"2047\",IF(RetType=3,\"2204\",IF(RetType=4,\"2104\",IF(RetType=5,\"2107\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=1,\" 1-1/2'' Retainer - Top and Bottom - Mitered Both Ends\",IF(RetType=2,\" 2'' Retainer - Top and Bottom - Mitered Both Ends\",IF(RetType=3,\" Flat Bleed Rigid Retainer - Top and Bottom - Mitered Both Ends\",IF(RetType=4,\" Flat Bleed Retro Frame - Top and Bottom - Mitered Both Ends\",IF(RetType=5,\" Flat Bleed Retro Frame II - Top and Bottom - Mitered 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,null,"Exceeds Calulation Limits, to be Caculated Manually"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Wdt>=432,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),KQ*2,IF(OR(BodyType>=2,BodyType<=5),KQ*4,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Wdt>=432,\"\",IF(AND(BodyType=6,RetroADD=1),WidthA+0.325,IF(AND(BodyType=6,RetroADD=2),WidthA+0.2,IF(RetType=4,WidthA,IF(RetType=5,WidthA,\"\"))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Wdt>=432,\"\",IF(RetType=4,\"2121-12'-3''\",IF(RetType=5,\"2121-12'-3''\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Wdt>=432,\"Exceeds Calulation Limits, to be Caculated Manually\",IF(AND(Wdt<=144,RetType=4),\" Flat Bleed Retro Frame Cover - Top and Bottom - Mitered Both Ends\",IF(AND(Wdt<=144,RetType=5),\" Flat Bleed Retro Frame Cover - Top and Bottom - Mitered Both Ends\",IF(AND(Wdt>=145,RetType=4),\" Flat Bleed Retro Frame Cover - Top and Bottom - Miter One End, Straight Cut One End\",IF(AND(Wdt>=145,RetType=5),\" Flat Bleed Retro Frame Cover - Top and Bottom - Miter One End, Straight Cut One End\",\"\"))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Wdt>=432,\"\",IF(Wdt<=144,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),KQ*2,IF(OR(BodyType>=2,BodyType<=5),KQ*4,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Wdt>=432,\"\",IF(RetType=4,WidthB,IF(RetType=5,WidthB,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Wdt>=432,\"\",IF(Wdt<=144,\"\",IF(RetType=4,\"2121-12'-3''\",IF(RetType=5,\"2121-12'-3''\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Wdt>=432,\"\",IF(Wdt<=144,\"\",IF(RetType=4,\" Flat Bleed Retro Frame Cover - Top and Bottom - Miter One End, Straight Cut One End\",IF(RetType=5,\" Flat Bleed Retro Frame Cover - Top and Bottom - Miter One End, Straigt Cut One End\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Wdt>=432,\"\",IF(Wdt<=288,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),KQ*2,IF(OR(BodyType>=2,BodyType<=5),KQ*4,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Wdt>=435,\"\",IF(RetType=4,WidthC,IF(RetType=5,WidthC,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Wdt>=432,\"\",IF(Wdt<=288,\"\",IF(RetType=4,\"2121-12'-3''\",IF(RetType=5,\"2121-12'-3''\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(Wdt>=432,\"\",IF(Wdt<=288,\"\",IF(RetType=4,\" Flat Bleed Retro Frame Cover - Top and Bottom - Straight Cut Both Ends\",IF(RetType=5,\" Flat Bleed Retro Frame Cover - Top and Bottom - Mitered Both Ends\",\"\")))))))","v":""}]
[]
[null,"Frame Support Tube",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,"Frame Suppot Tube"]
[]
[null,"Qty.","Part #",null,"Description",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,"Height","FST Horz","Width","FST Vert","FSTH (In)","FSTV (In)","FSTReq SF","FSTReq DF"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(FST=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=1,FBTYP=4),\"\",IF(AND(BodyType=2,FBTYP=2),\"\",IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),FSTLngthsSF*KQ,IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),FSTLngthsSF*KQ,IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),FSTLngthsDF*KQ,IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),FSTLngthsDF*KQ,\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(FST=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=1,FBTYP=4),\"\",IF(AND(BodyType=2,FBTYP=2),\"\",IF(FBTYP=1,\"2175\",IF(FBTYP=2,\"2175\",IF(FBTYP=3,\"2177\",IF(FBTYP=4,\"2177\",IF(AND(BodyType=7,FBTYP=5),\"2177\",IF(FBTYP=5,\"2175\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(FST=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=1,FBTYP=4),\" Retro Frame Brace Is Not For Use With Single Face Body\",IF(AND(BodyType=2,FBTYP=2),\" 2 Piece Frame Brace Is Not For Use With Flat Medium Double Face Body\",IF(AND(BodyType=7,FBTYP=4),\" Retro Frame Brace Is Not For Use With Flat Wall Mount Retro Body\",IF(FBTYP=1,\" Frame Support Tube - 3/4'' x 1-5/8'' Rectangular Aluminum Tube - (24'-0'' lengths)\",IF(FBTYP=2,\" Frame Support Tube - 3/4'' x 1-5/8'' Rectangular Aluminum Tube - (24'-0'' lengths)\",IF(FBTYP=3,\" Small Frame Support Tube - 1'' x 1'' Sq. Aluminum Tube - (24'-0'' lengths)\",IF(FBTYP=4,\" Small Frame Support Tube - 1'' x 1'' Sq. Aluminum Tube - (24'-0'' lengths)\",IF(AND(BodyType=7,FBTYP=5),\"Frame Support Tube - 1'' x 1'' Sq. Aluminum Tube - (24'-0'' lengths)\",IF(FBTYP=5,\" Frame Support Tube - 3/4'' x 1-5/8'' Rectangular Aluminum Tube - (24'-0'' lengths)\",\"\")))))))))))))","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":"Hgt","v":0},{"$f":"IF(FBTYP=4,ROUNDDOWN(CHgt/25,0),IF(CHgt<=71,0,ROUNDDOWN(CHgt/37,0)))","v":0},{"$f":"Wdt","v":0},{"$f":"IF(FBTYP=4,ROUNDDOWN(CWdth/25,0),IF(CWdth<=71,0,ROUNDDOWN(CWdth/37,0)))","v":0},{"$f":"CWdth*NumFSTH","v":0},{"$f":"CHgt*NumFTSV","v":0},{"$f":"ROUNDUP((((FSTHTIn+FSTVTIn)/12)/24),0)","v":0},{"$f":"ROUNDUP(((((FSTHTIn+FSTVTIn)*2)/12)/24),0)","v":0}]
[]
[null,"Divider",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]
[null,"Divider 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,false,false]
[null,null,null,null,0,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(Horz=FALSE,\"\",IF(Horz=TRUE,\"  Insert Number of Horizontal Divider(s),\",\"\"))))","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(Vert=FALSE,\"\",IF(Vert=TRUE,\"  Insert Number of Vertical Divider(s),\",\"\"))))","v":""}]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=TRUE,BodyType=1),HDivider*KQ,IF(AND(Horz=TRUE,BodyType=2),HDivider*2*KQ,IF(AND(Horz=TRUE,BodyType=3),HDivider*2*KQ,IF(AND(Horz=TRUE,BodyType=4),HDivider*2*KQ,IF(AND(Horz=TRUE,BodyType=5),HDivider*2*KQ,IF(AND(Horz=TRUE,BodyType=6),HDivider*KQ,IF(AND(Horz=TRUE,BodyType=7),HDivider*KQ,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(AND(RetType=1,RetroADD=1,Horz=TRUE)),Wdt-2.675,IF(AND(AND(RetType=2,RetroADD=1,Horz=TRUE)),Wdt-3.675,IF(AND(AND(RetType=1,RetroADD=2,Horz=TRUE)),Wdt-2.8,IF(AND(AND(RetType=2,RetroADD=2,Horz=TRUE)),Wdt-3.8,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(Horz=TRUE,\"2130\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(Horz=TRUE,\"  Flat Divider - Horizontal - Straight Cut Both Ends\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Vert=TRUE,BodyType=1),VDivider*KQ,IF(AND(Vert=TRUE,BodyType=2),VDivider*2*KQ,IF(AND(Vert=TRUE,BodyType=3),VDivider*2*KQ,IF(AND(Vert=TRUE,BodyType=4),VDivider*2*KQ,IF(AND(Vert=TRUE,BodyType=5),VDivider*2*KQ,IF(AND(Vert=TRUE,BodyType=6),VDivider*KQ,IF(AND(Vert=TRUE,BodyType=7),VDivider*KQ,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(AND(RetType=1,RetroADD=1,Vert=TRUE)),Hgt-2.675,IF(AND(AND(RetType=2,RetroADD=1,Vert=TRUE)),Hgt-3.675,IF(AND(AND(RetType=1,RetroADD=2,Vert=TRUE)),Hgt-2.8,IF(AND(AND(RetType=2,RetroADD=2,Vert=TRUE)),Hgt-3.8,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(Vert=TRUE,\"2130\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(Vert=TRUE,\"  Flat Divider - Vertical - Straight Cut Both Ends\",\"\")))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BILL OF MATERIALS"]
[null,{"$f":"AE5&AK6&AE6","v":""}]
[null,{"$f":"AE7","v":""}]
[null,"Customer  ",null,null,null,{"$f":"Cust","v":0},null,null,null,null,null,null,null,null,"Order #",null,null,null,{"$f":"Ordnum","v":0},null,null,null,null,null,null,null,"Lengths Required","Lengths Used","Drops Used"]
[null,"Kit Quantity  ",null,null,null,{"$f":"KQ","v":0},null,"Height  ",null,null,null,{"$f":"Hgt","v":0},null,"Width",null,null,null,{"$f":"Wdt","v":0},null,"Enter Fractions as Decimals"]
[null,"Add one inch (1'') the direction of the lamp when fluorescent lamps are to be used for illumination."]
[]
[null,"Hardware"]
[]
[null,"Body"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=3),KQ*4,IF(OR(BodyType=4,BodyType=5),KQ*4,IF(OR(BodyType=6,BodyType=7),KQ*4,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"5327\",IF(BodyType=2,\"5907\",IF(BodyType=3,\"5908\",IF(BodyType=4,\"5910\",IF(BodyType=5,\"5909\",IF(BodyType=6,\"5305\",IF(BodyType=7,\"5305\",\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Flat Single Face Body Corner Angle - One (1) Per Corner - 2-1/2'' x 2-1/2'' x 1/4'' (5-5/8'')\",IF(BodyType=2,\" Flat Double Face Medium Body Corner Angle - One (1) Per Corner - 2-1/2'' x 2-1/2'' x 1/4'' (3-13/16'')\",IF(BodyType=3,\" Flat Double Face Body Corner Angle - One (1) Per Corner - 2-1/2'' x 2-1/2'' x 1/4'' (8-9/16'')\",IF(BodyType=4,\" Flat 2 Piece Double Face Medium Body Corner Angle - One (1) Per Corner - 2-1/2'' x 2-1/2'' x 1/4'' (11-9/16'')\",IF(BodyType=5,\" Flat 2 Piece Double Face Body Corner Angle - One (1) Per Corner - (2-1/2'' x 2-1/2'' x 1/4'' (15-9/16'')\",IF(BodyType=6,\" Flat Retro Body Corner Angle - One (1) Per Corner - 1-3/4'' x 1-3/4'' x 1/4'' (1-1/16'')\",IF(BodyType=7,\" Flat Wall Mount Retro Body Corner Angle - One (1) Per Corner - 1-3/4'' x 1-3/4'' x 1/4'' (1-1/16'')\",\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,34*KQ,IF(OR(BodyType=2,BodyType=3),18*KQ,IF(OR(BodyType=4,BodyType=5),18*KQ,IF(OR(BodyType=6,BodyType=7),10*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"5199\",IF(OR(BodyType=2,BodyType=3),\"5218\",IF(OR(BodyType=4,BodyType=5),\"5218\",IF(OR(BodyType=6,BodyType=7),\"5218\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Body Corner Angle Screw - #8 x 3/8'' steel zinc sq/phillips drive pan head screw - Type B - Eight (8) Per Corner\",IF(OR(BodyType=2,BodyType=3),\" Body Corner Angle Screw - #10 x 1/2'' SS sq/phillips dirve pan head tapping screw w/wax - Type AB - Four (4) Per Corner\",IF(OR(BodyType=4,BodyType=5),\" Body Corner Angle Screw - #10 x 1/2'' SS sq/phillips dirve pan head tapping screw w/wax - Type AB - Four (4) Per Corner\",IF(OR(BodyType=6,BodyType=7),\" Body Corner Angle Screw - #10 x 1/2'' SS sq/phillips dirve pan head tapping screw w/wax - Type AB - Two (2) Per Corner\",\"\"))))))","v":""}]
[]
[null,"Retainer"]
[]
[null,"Qty.","Part#",null,"Description",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,"Hnge Scr","Height","Width","Height","Cls Scr"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType=1,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*4,IF(AND(RetType=2,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*4,IF(AND(RetType=3,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*4,IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*8,IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*8,IF(AND(RetType=1,OR(BodyType>=2,BodyType<=5)),KQ*8,IF(AND(RetType=2,OR(BodyType>=2,BodyType<=5)),KQ*8,IF(AND(RetType=3,OR(BodyType>=2,BodyType<=5)),KQ*8,IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),KQ*16,IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),KQ*16,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType=1,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5213\",IF(AND(RetType=2,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5214\",IF(AND(RetType=3,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5210\",IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5305\",IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5305\",IF(AND(RetType=1,OR(BodyType>=2,BodyType<=5)),\"5213\",IF(AND(RetType=2,OR(BodyType>=2,BodyType<=5)),\"5214\",IF(AND(RetType=3,OR(BodyType>=2,BodyType<=5)),\"5210\",IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),\"5305\",IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),\"5305\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType=1,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" 1-1/2''/38.1mm Frame Corner Bracket - One (1) Set Per Corner\",IF(AND(RetType=2,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" 2''/50.8mm Frame Corner Bracket - One (1) Set Per Corner\",IF(AND(RetType=3,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Corner Key - .120 stamped aluminum - One (1) Per Corner\",IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' - 1-1/16'' aluminum angle - Two (2) Per Corner\",IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' - 1-1/16'' aluminum angle - Two (2) Per Corner\",IF(AND(RetType=1,OR(BodyType>=2,BodyType<=5)),\" 1-1/2''/38.1mm Frame Corner Bracket - One (1) Set Per Corner\",IF(AND(RetType=2,OR(BodyType>=2,BodyType<=5)),\" 2''/50.8mm Frame Corner Bracket - One (1) Set Per Corner\",IF(AND(RetType=3,OR(BodyType>=2,BodyType<=5)),\" Corner Key - .120 stamped aluminum - One (1) Per Corner\",IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' - 1-1/16'' aluminum angle - Two (2) Per Corner\",IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' - 1-1/16'' aluminum angle - 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,{"$f":"ROUNDUP((Wdt/18)+1,0)","v":1},{"$f":"ROUNDUP((Hgt/36)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/36)+1,0)","v":1},{"$f":"ROUNDUP((Hgt/36)+1,0)","v":1},{"$f":"SUM(AF86:AH86)","v":3}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType=1,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*18,IF(AND(RetType=2,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*18,IF(AND(RetType=3,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*18,IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*10,IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*10,IF(AND(RetType=1,OR(BodyType>=2,BodyType<=5)),KQ*34,IF(AND(RetType=2,OR(BodyType>=2,BodyType<=5)),KQ*34,IF(AND(RetType=3,OR(BodyType>=2,BodyType<=5)),KQ*34,IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),KQ*18,IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),KQ*18,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType=1,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5195\",IF(AND(RetType=2,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5195\",IF(AND(RetType=3,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5168\",IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5218\",IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5218\",IF(AND(RetType=1,OR(BodyType>=2,BodyType<=5)),\"5195\",IF(AND(RetType=2,OR(BodyType>=2,BodyType<=5)),\"5195\",IF(AND(RetType=3,OR(BodyType>=2,BodyType<=5)),\"5168\",IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),\"5218\",IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),\"5218\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType=1,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Corner Bracket Screw - #8 x 5/16'' steel zinc sq/phillips drive pan head screw - Type B - Four (4) Per Corner\",IF(AND(RetType=2,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Corner Bracket Screw - #8 x 5/16'' steel zinc sq/phillips drive pan head screw - Type B - Four (4) Per Corner\",IF(AND(RetType=3,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Frame Corner Key Screw - #8 x 1/2'' SS sq/phillips drive countersink screw - Type A - Four (4) Per Corner\",IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Frame Corner Angle Screw - #10 x1/2'' SS sq/phillips pan head tapping screw w/wax - Type AB - Two (2) Per Corner\",IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Frame Corner Angle Screw - #10 x1/2'' SS sq/phillips pan head tapping screw w/wax - Type AB - Two (2) Per Corner\",IF(AND(RetType=1,OR(BodyType>=2,BodyType<=5)),\" Corner Bracket Screw - #8 x 5/16'' steel zinc sq/phillips drive pan head screw - Type B - Four (4) Per Corner\",IF(AND(RetType=2,OR(BodyType>=2,BodyType<=5)),\" Corner Bracket Screw - #8 x 5/16'' steel zinc sq/phillips drive pan head screw - Type B - Four (4) Per Corner\",IF(AND(RetType=3,OR(BodyType>=2,BodyType<=5)),\" Frame Corner Key Screw - #8 x 1/2'' SS sq/phillips drive countersink screw - Type A - Four (4) Per Corner\",IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),\" Frame Corner Angle Screw - #10 x1/2'' SS sq/phillips pan head tapping screw w/wax - Type AB - Two (2) Per Corner\",IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),\" Frame Corner Angle Screw - #10 x1/2'' SS sq/phillips pan head tapping screw w/wax - Type AB - Two (2) Per Corner\",\"\"))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),(CVRSCR+2)*KQ,IF(OR(BodyType>=2,BodyType<=5),((CVRSCR*2)+2)*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(RetType=4,\"5195\",IF(RetType=5,\"5195\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(RetType=4,\" Cover Screw - #8 x 5/16'' steel zinc sq/phillips drive pan head screw - Type B - One (1) every 24'' on center\",IF(RetType=5,\" Cover Screw - #8 x 5/16'' steel zinc sq/phillips drive pan head screw - Type B - One (1) every 24'' 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,"Height","Width","Height","Width","Cvr Scrs"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),(HNGSCR+2)*KQ,IF(OR(BodyType>=2,BodyType<=5),((HNGSCR*2)+2)*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=5),5178,\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=5),\" Hinge Screw - #10 x 5/8'' steel zinc sq/phillips drive flat head screw - Type B - One (1) every 18'' 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":"ROUNDUP((Hgt/24)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/24)+1,0)","v":1},{"$f":"ROUNDUP((Hgt/24)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/24)+1,0)","v":1},{"$f":"SUM(AE89:AH89)","v":4}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),(CLSSCR+2)*KQ,IF(OR(BodyType>=2,BodyType<=5),((CLSSCR*2)+2)*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=5),5178,\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=5),\" Closure Screw - #10 x 5/8'' steel zinc sq/phillips drive flat head screw - Type B - One (1) every 36'' on center\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=3,FCEBLT*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=3,\"5285\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=3,\" Face Attachment Hardware - 1/4-20 x 1'' CS Machine Screw/Bushing /Nut - One (1) every 12'' 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(RetType=3,ROUNDUP((Hgt/12),0),ROUNDDOWN((Hgt/24)+1,0))","v":1},{"$f":"IF(RetType=3,ROUNDUP((Wdt/12),0),ROUNDDOWN((Wdt/24)+1,0))","v":1},{"$f":"IF(RetType=3,ROUNDUP((Hgt/12),0),ROUNDDOWN((Hgt/24)+1,0))","v":1},{"$f":"IF(RetType=3,ROUNDUP((Wdt/12),0),ROUNDDOWN((Wdt/24)+1,0))","v":1},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=2,\"\",IF(AND(BodyType=1,RetType=3),SUM(AE91:AH91)+2,IF(AND(AND(BodyType>=2,BodyType<=5,RetType=3)),SUM(AE91:AH91)*2+2,IF(AND(BodyType>=6,RetType=3),SUM(AE91:AH91)+2,IF(RetType=4,\"\",\"\")))))))","v":""}]
[]
[null,"Divider"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(BodyType=1,BKTT,IF(BodyType=2,BKTT*2,IF(BodyType=3,BKTT*2,IF(BodyType=4,BKTT*2,IF(BodyType=5,BKTT*2,IF(BodyType=6,BKTT,IF(BodyType=7,BKTT,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=TRUE,Vert=FALSE),\"5302\",IF(AND(Horz=FALSE,Vert=TRUE),\"5302\",IF(AND(Horz=TRUE,Vert=TRUE),\"5302\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=TRUE,Vert=FALSE),\" Flat Divider Mounting Bracket - Horizontal - One (1) each end\",IF(AND(Horz=FALSE,Vert=TRUE),\" Flat Divder Mounting Bracket - Vertical - One (1) each end\",IF(AND(Horz=TRUE,Vert=TRUE),\" Flat Divider Mounting Bracket - Horizontal and Vertical - One (1) end of each section of divider\",\"\")))))","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(Divider=1,\"\",IF(AND(Horz=FALSE,Vert=TRUE),\"0\",IF(Horz=TRUE,HDivider*2))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=TRUE,Vert=FALSE),\"0\",IF(AND(Horz=FALSE,Vert=TRUE),VDivider*2,IF(AND(Horz=TRUE,Vert=TRUE),VDivider*2+(HDivider*2),\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",(HBKT+VBKT)*KQ))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",((B96*2)+(KQ*2))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=TRUE,Vert=FALSE),\"5290\",IF(AND(Horz=FALSE,Vert=TRUE),\"5290\",IF(AND(Horz=TRUE,Vert=TRUE),\"5290\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=TRUE,Vert=FALSE),\" Flat Divider Mounting Bracket Screw - Horizontal - Two (2) each end\",IF(AND(Horz=FALSE,Vert=TRUE),\" Flat Divder Mounting Bracket Screw - Vertical - Two (2) each end\",IF(AND(Horz=TRUE,Vert=TRUE),\" Flat Divider Mounting Bracket Screw - Horizontal and Vertical - Two (2) end of each section of divider\",\"\")))))","v":""}]
[]
[null,"Frame Braces",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,5,"Frame Braces"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=1,FBTYP=4),\"\",IF(AND(BodyType=7,FBTYP=1),\"\",IF(AND(BodyType=7,FBTYP=2),\"\",IF(AND(BodyType=7,FBTYP=4),\"\",IF(AND(BodyType=2,FBTYP=2),\"\",IF(AND(AND(BodyType=1,FBTYP=5,OR(RetType=4,RetType=5))),KQ*FRMBRC,IF(AND(AND(BodyType=2,FBTYP=5,OR(RetType=4,RetType=5))),KQ*FRMBRC*2,IF(AND(AND(BodyType=3,FBTYP=5,OR(RetType=4,RetType=5))),KQ*FRMBRC*2,IF(AND(AND(BodyType=4,FBTYP=5,OR(RetType=4,RetType=5))),KQ*FRMBRC*2,IF(AND(AND(BodyType=5,FBTYP=5,OR(RetType=4,RetType=5))),KQ*FRMBRC*2,IF(AND(AND(BodyType=6,FBTYP=5,OR(RetType=4,RetType=5))),KQ*FRMBRC,IF(AND(AND(BodyType=7,FBTYP=5,OR(RetType=4,RetType=5))),KQ*FRMBRC,IF(AND(AND(BodyType=7,RetType>=4,FBTYP>=1)),(VFB+HFB)*KQ,IF(AND(AND(RetType>=4,FBTYP>=1,OR(BodyType=1,BodyType=6))),(VFB+HFB)*KQ,IF(AND(AND(RetType>=4,FBTYP>=1,BodyType>=2,BodyType<=5)),((VFB+HFB)*2)*KQ,\"\")))))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=1,FBTYP=4),\"\",IF(AND(BodyType=7,FBTYP=1),\"\",IF(AND(BodyType=7,FBTYP=2),\"\",IF(AND(BodyType=7,FBTYP=4),\"\",IF(AND(BodyType=2,FBTYP=2),\"\",IF(AND(AND(BodyType=1,FBTYP=5,OR(RetType=4,RetType=5))),\"5357\",IF(AND(AND(BodyType=2,FBTYP=5,OR(RetType=4,RetType=5))),\"5357\",IF(AND(AND(BodyType=3,FBTYP=5,OR(RetType=4,RetType=5))),\"5357\",IF(AND(AND(BodyType=4,FBTYP=5,OR(RetType=4,RetType=5))),\"5357\",IF(AND(AND(BodyType=5,FBTYP=5,OR(RetType=4,RetType=5))),\"5357\",IF(AND(AND(BodyType=6,FBTYP=5,OR(RetType=4,RetType=5))),\"5357\",IF(AND(AND(BodyType=7,FBTYP=5,OR(RetType=4,RetType=5))),\"5352\",IF(BodyType=7,\"5352\",IF(FBTYP=1,\"5350\",IF(FBTYP=2,\"5357\",IF(FBTYP=3,\"5352\",IF(FBTYP=4,\"5354\",\"\")))))))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=1,FBTYP=4),\" Retro Frame Brace Is Not For Use With Single Face Body\",IF(AND(BodyType=7,FBTYP=1),\"\",IF(AND(BodyType=7,FBTYP=2),\"\",IF(AND(BodyType=7,FBTYP=4),\" Retro Frame Brace Is Not For Use With Flat Wall Mount Retro Body\",IF(AND(BodyType=2,FBTYP=2),\" 2 Piece Frame Brace Is Not For Use With Flat Medium Double Face Body\",IF(AND(AND(BodyType=1,FBTYP=5,OR(RetType=4,RetType=5))),\" 2 Piece Frame Brace - 1'' Wide - Approx. Every 36'' on Center\",IF(AND(AND(BodyType=2,FBTYP=5,OR(RetType=4,RetType=5))),\" 2 Piece Frame Brace - 1'' Wide - Approx. Every 36'' on Center\",IF(AND(AND(BodyType=3,FBTYP=5,OR(RetType=4,RetType=5))),\" 2 Piece Frame Brace - 1'' Wide - Approx. Every 36'' on Center\",IF(AND(AND(BodyType=4,FBTYP=5,OR(RetType=4,RetType=5))),\" 2 Piece Frame Brace - 1'' Wide - Approx. Every 36'' on Center\",IF(AND(AND(BodyType=5,FBTYP=5,OR(RetType=4,RetType=5))),\" 2 Piece Frame Brace - 1'' Wide - Approx. Every 36'' on Center\",IF(AND(AND(BodyType=6,FBTYP=5,OR(RetType=4,RetType=5))),\" 2 Piece Frame Brace - 1'' Wide - Approx. Every 36'' on Center\",IF(AND(AND(BodyType=7,FBTYP=5,OR(RetType=4,RetType=5))),\" Small Frame Brace - 1-1/8'' Wide - Approx. Every 36'' on Center\",IF(BodyType=7,\" Small Frame Brace - 1-1/8'' Wide - One (1) Approx. Every 36'' on Center\",IF(FBTYP=1,\" Frame Brace - 1-3/8'' Wide - Approx. Every 36'' on Center\",IF(FBTYP=2,\" 2 Piece Frame Brace - 1'' Wide - Approx. Every 36'' on Center\",IF(FBTYP=3,\" Small Frame Brace - 1-1/8'' Wide - Approx. Every 36'' on Center\",IF(FBTYP=4,\" Retro Frame Brace - 1-1/8'' Wide - Approx. Every 24'' 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":"NumFTSV*2","v":0},"Vert Braces",null,{"$f":"NumFSTH*2","v":0},"Horz Braces",null,{"$f":"VFB+HFB","v":0},"Total Frame Braces"]
[]
[null,"Tension Clips",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,"Height","Width","Height","Width","Total Clips"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(AND(RetType>=4,OR(BodyType=1,BodyType=6,BodyType=7)),TENCLIPS*KQ,IF(AND(RetType>=4,OR(BodyType=2,BodyType=3,BodyType=4,BodyType=5)),TENCLIPS*2*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,\"5360\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,\" Tension Clip - One (1) every 5'' on center along the top, bottom and sides\",\"\"))))","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":"ROUNDUP((Hgt/5)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/5)+1,0)","v":1},{"$f":"ROUNDUP((Hgt/5)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/5)+1,0)","v":1},{"$f":"SUM(AE105:AH105)","v":4}]
[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," Retro Frame Brace Is Not For Use With Single Face 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,null,null,null,null,null," 2 Piece Frame Brace Is Not For Use With Flat Medium Double Face 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,null,null,null,null,null," Retro Frame Brace is Not For Use With Flat Wall Mount Retro 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,1]

{"sheet":"Flex Face Dimensions","index":1,"n_rows":58,"n_cols":31,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,1,7,28],[1,1,1,28],[2,1,2,28],[3,1,3,28],[4,1,5,28],[6,1,6,28],[29,1,29,28],[8,1,8,28],[25,1,25,28],[26,1,26,4],[26,5,26,21],[26,22,26,28],[27,1,27,28],[28,3,28,9],[28,10,28,11],[28,13,28,19],[28,20,28,21],[28,22,28,28],[33,1,33,28],[30,3,30,9],[30,10,30,11],[30,13,30,19],[30,20,30,21],[30,22,30,28],[31,1,31,28],[32,3,32,9],[32,10,32,11],[32,13,32,19],[32,20,32,21],[32,22,32,28],[34,1,34,28],[35,1,35,28],[52,1,52,28],[53,8,53,12],[53,13,53,14],[53,15,53,24],[54,1,54,28],[55,7,55,12],[55,13,55,14],[55,15,55,24],[57,7,57,12],[57,13,57,14],[57,15,57,26]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Face Trim Size Calculations"]
[]
[]
[]
[]
[]
[]
[]
[]
[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,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Frame Type:",null,null,null,{"$f":"IF(KQ=0,\"\",IF(AND(Body=1,Cover=1),\" 2'' Retro Frame and 2=3/8'' Retro Frame Cover\",IF(AND(Body=2,Cover=2),\" Bleed Retro Frame and Bleed Retro Frame Cover\",IF(AND(Body=3,Cover=3),\" Flat Bleed Retro Frame and Flat Bleed Retro Frame Cover\",IF(AND(Body=3,Cover=4),\" Flat Bleed Retro Frame and Extended Flat Bleed Retro Frame Cover\",IF(AND(Body=3,Cover=5),\" Flat Bleed Retro Frame and 1-1/2'' Flat Bleed Retro Frame Cover\",IF(AND(Body=4,Cover=6),\" Wall Mount Tension Frame and Wall Mount Tension Frame Radius Cover\",IF(AND(Body=4,Cover=7),\" Wall Mount Tension Frame and Wall Mount Tension Frame Square Cover\",IF(AND(Body=4,Cover=8),\" Wall Mount Tension Frame and Wall Mount Tension Frame Beveled Cover\",\"\")))))))))","v":""}]
[]
[null,null,null,"Outside Frame dimension (Height) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,Hgt,\"\"))))","v":""},null,null,"Outside Frame Dimension (Width) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,Wdt,\"\"))))","v":""}]
[]
[null,null,null,"Visual Opening (Height) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,Hgt-0.184,\"\"))))","v":""},null,null,"Visual Opening (Width) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,Wdt-0.184,\"\"))))","v":""}]
[]
[null,null,null,"Face Trim Size (Height) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,Hgt+6.5,\"\"))))","v":""},null,null,"Face Trim Size (Width) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,Wdt+6.5,\"\"))))","v":""}]
[]
[]
[null,"Clip Line Calculations"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Clip Line Placement ",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,\"1-1/2''\",\"\"))))","v":""},null,"(In from the trimmed edge of the face.)"]
[]
[null,null,null,null,null,null,null,"Clip Spacing ",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,\"5''\",\"\"))))","v":""},null,"(Center to Center)"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType=4,\"Tensioning Tool \",\"\"))))","v":""},null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,\"5135\",\"\"))))","v":""},null,"(See Commercial Catalog Pg. 13 or Contact Customer Service)"]