{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Standard","Gas Support","GS Placement A","GS Placement B","GS Placement C"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":55,"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":"Standard","index":0,"n_rows":117,"n_cols":37,"rows_kept":117,"cut":false,"hidden":false,"merged":[[108,1,108,28],[110,2,110,3],[111,2,111,3],[112,2,112,3],[113,2,113,3],[114,2,114,3],[115,2,115,3],[116,2,116,3],[110,6,110,7],[111,6,111,7],[112,6,112,7],[113,6,113,7],[114,6,114,7],[115,6,115,7],[116,6,116,7],[110,10,110,11],[111,10,111,11],[112,10,112,11],[113,10,113,11],[114,10,114,11],[115,10,115,11],[116,10,116,11],[3,34,3,37],[16,1,16,28],[15,1,15,28],[18,7,18,28],[81,4,81,25],[82,4,82,25],[25,11,25,28],[84,2,84,3],[71,1,71,4],[72,1,72,4],[30,2,30,3],[36,2,36,3],[35,5,35,6],[36,5,36,6],[36,7,36,25],[35,7,35,28],[38,1,38,8],[66,1,66,28],[80,4,80,25],[20,5,20,6],[19,2,19,3],[20,2,20,3],[77,2,77,3],[38,9,38,12],[93,35,93,36],[91,35,91,38],[92,35,92,38],[94,35,94,38],[90,35,90,38],[49,30,49,34],[50,30,50,34],[42,30,42,32],[51,30,51,34],[48,33,48,35],[45,31,45,32],[107,4,107,25],[107,2,107,3],[106,28,107,28],[49,2,49,3],[88,31,88,33],[105,1,105,28],[106,2,106,3],[106,4,106,25],[71,26,71,28],[68,1,68,28],[82,2,82,3],[69,1,69,28],[81,2,81,3],[105,30,105,34],[100,4,100,25],[101,2,101,3],[101,4,101,25],[98,4,98,25],[98,2,98,3],[94,4,94,25],[91,2,91,3],[71,5,71,13],[71,14,71,17],[71,18,71,25],[102,2,102,3],[102,4,102,25],[96,28,102,28],[72,5,72,6],[76,28,78,28],[84,4,84,25],[83,2,83,3],[83,4,83,25],[93,4,93,25],[80,28,86,28],[93,2,93,3],[90,1,90,28],[94,2,94,3],[92,2,92,3],[89,2,89,3],[78,2,78,3],[1,1,1,28],[8,18,8,25],[9,1,9,4],[5,1,5,28],[6,1,6,28],[3,1,3,28],[8,1,8,4],[8,5,8,13],[10,1,10,18],[9,17,9,18],[9,19,10,25],[9,5,9,6],[8,14,8,17],[9,11,9,12],[9,7,9,10],[9,13,9,16],[28,5,28,6],[28,7,28,25],[42,7,42,25],[42,2,42,3],[42,5,42,6],[41,1,41,28],[72,11,72,12],[72,13,72,16],[72,17,72,18],[72,19,72,28],[67,1,67,28],[70,1,70,28],[64,1,64,28],[28,2,28,3],[43,2,43,3],[19,5,19,6],[25,9,25,10],[4,1,4,28],[8,28,10,28],[2,1,2,28],[95,1,95,28],[96,2,96,3],[96,4,96,25],[77,4,77,25],[91,28,94,28],[19,7,19,25],[76,4,76,25],[87,1,87,28],[88,2,88,3],[72,7,72,10],[35,2,35,3],[88,4,88,25],[49,5,49,6],[48,5,48,6],[43,5,43,6],[49,7,49,25],[48,7,48,25],[43,7,43,25],[27,5,27,6],[9,30,9,33],[5,34,5,37],[65,1,65,28],[91,4,91,25],[92,4,92,25],[5,30,5,33],[6,30,6,33],[8,26,10,26],[8,27,10,27],[11,1,11,28],[7,1,7,28],[13,31,13,32],[27,7,27,28],[20,7,20,25],[18,2,18,3],[21,1,21,28],[22,1,22,28],[24,1,24,28],[12,1,12,28],[13,1,14,28],[23,1,23,28],[23,31,23,32],[25,1,25,6],[25,7,25,8],[10,30,10,39],[18,5,18,6],[17,1,17,28],[106,30,106,34],[6,34,6,37],[3,30,3,31],[30,5,30,6],[30,7,30,25],[31,2,31,3],[39,1,39,28],[32,1,32,28],[33,1,33,28],[22,31,22,32],[37,1,37,28],[31,7,31,25],[29,2,29,3],[29,5,29,6],[29,7,29,25],[34,1,34,28],[31,5,31,6],[14,32,14,33],[8,30,8,33],[73,1,73,28],[38,31,38,32],[26,1,26,28],[27,2,27,3],[104,30,104,34],[104,2,104,3],[104,4,104,25],[97,2,97,3],[97,4,97,25],[44,1,44,28],[103,1,103,28],[99,2,99,3],[99,4,99,25],[100,2,100,3],[45,1,46,28],[47,1,47,28],[48,2,48,3],[78,4,78,25],[79,1,79,28],[80,2,80,3],[85,2,85,3],[85,4,85,25],[86,2,86,3],[86,4,86,25],[40,31,40,32],[48,30,48,32],[38,34,38,35],[38,13,38,28],[40,14,40,15],[40,16,40,17],[40,19,40,20],[40,21,40,22],[40,23,40,26],[89,4,89,25],[88,28,89,28],[50,1,50,28],[51,5,51,6],[51,7,51,25],[75,1,75,28],[51,2,51,3],[74,1,74,28],[76,2,76,3]]}
[]
[]
[]
[null,"BILL OF MATERIALS",null,null,null,null,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(Body=2,\"\",IF(BodyType<=5,\" 2Part\",\"\")))","v":""},null,null,null,{"$f":"IF(NoYesHD=1,\"\",IF(Body=2,\"\",IF(AND(RETTYPE=4,INFRM=1),\"\",IF(AND(RETTYPE<=3,INFRM=2),\"\",IF(RETTYPE=1,\" with \",IF(RETTYPE=2,\" with \",IF(RETTYPE=3,\" with \",IF(RETTYPE=4,\" with\",\"\"))))))))","v":""}]
[]
[null,{"$f":"IF(KQ=0,\"\",AI6&AE4&AE6&AI4&AE7&AE9)","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(Body=2,\"\",IF(BodyType=1,\" 6'' Single Face Body\",IF(BodyType=2,\" 8'' Single Face Body\",IF(BodyType=3,\" 6'' Double Face Body\",IF(BodyType=4,\" 9'' Double Face Body\",IF(BodyType=5,\" 12'' Double Face Body\")))))))","v":""},null,null,null,{"$f":"IF(PTDS=1,\"Mill Finish -\",IF(PTDS=2,\"Pre-Painted -\"))","v":"Mill Finish -"}]
[null,{"$f":"IF(KQ=0,\"\",AE10&AI7)","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(NoYesHD=1,\"\",IF(AND(RETTYPE=4,INFRM=1),\"\",IF(AND(RETTYPE<=3,INFRM=2),\"\",IF(RETTYPE=1,\" 2Part Extended Retainer\",IF(RETTYPE=2,\" 2Part Extended Retainer - One End Removable\",IF(RETTYPE=3,\" 2Part Extended Retainer - Both Ends Removable\",IF(RETTYPE=4,\" 2Part Large Extended Retainer\",\"\")))))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(Hinge=1,\" with Top/Bottom Hinge\",IF(Hinge=2,\" with Side Hinge\",\"\")))","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,\"\",IF(AND(RETTYPE=4,INFRM=1),\"\",IF(AND(AND(NOYES=2,MNUB=2,INFRM=1)),\" and Multiple Door Vandal Cover\",IF(AND(AND(NOYES=2,MNUB=2,INFRM=2)),\" and Multiple Door Large Vandal Cover\",IF(AND(NOYES=2,INFRM=1),\" and Vandal Cover\",IF(AND(NOYES=2,INFRM=2),\" and Large Vandal Cover\",\"\"))))))","v":""}]
[null,"Kit Quantity  ",null,null,null,0,null,"Height  ",null,null,null,0,null,"Width",null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(OR(BodyType<=2,BodyType>=4),\"Add 1-3/4'' to the overall height or width in the direction the lamps will be placed.\",IF(BodyType=3,\"Add 1'' to the overall height or width in the direction the lamps will be placed.\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(MNUB=2,\"\",IF(AND(NOYES=2,NoYes2=2),\" and Vertical 2Part Divider\",\"\")))","v":""}]
[null,"Enter Fractions as Decimals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add 1'' to the overall height or width in the direction the lamps will be placed."]
[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,"Body Type",null,1,"Body"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(PTDS=1,\"\",IF(PTDS=2,\"P\"))","v":""},"Mill or Painted"]
[]
[null,"2Part 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,"Retro"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType<=2,KQ*2,IF(BodyType>=3,KQ*2,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType<=2,Wdt,IF(BodyType>=3,Wdt,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType=1,\"1926\"&PPTD,IF(BodyType=2,\"1927\"&PPTD,IF(BodyType=3,\"1936\"&PPTD,IF(BodyType=4,\"1928\"&PPTD,IF(BodyType=5,\"1929\"&PPTD,\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType=1,\" 2Part 6'' Single Face Body - Top & Bottom - Mitered both ends\",IF(BodyType=2,\" 2Part 8'' Single Face Body - Top & Bottom - Mitered both ends\",IF(BodyType=3,\" 2Part 6'' Double Face Body - Top & Bottom - Mitered both ends\",IF(BodyType=4,\" 2Part 9'' Double Face Body - Top & Bottom - Mitered both ends\",IF(BodyType=5,\" 2Part 12'' Double Face Body - Top & Bottom - Mitered both ends\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType<=2,KQ*2,IF(BodyType>=3,KQ*2,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType<=2,Hgt,IF(BodyType>=3,Hgt,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType=1,\"1926\"&PPTD,IF(BodyType=2,\"1927\"&PPTD,IF(BodyType=3,\"1936\"&PPTD,IF(BodyType=4,\"1928\"&PPTD,IF(BodyType=5,\"1929\"&PPTD,\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType=1,\" 2Part 6'' Single Face Body - Both Ends - Mitered both ends\",IF(BodyType=2,\" 2Part 8'' Single Face Body - Both Ends - Mitered both ends\",IF(BodyType=3,\" 2Part 6'' Double Face Body - Both Ends - Mitered both ends\",IF(BodyType=4,\" 2Part 9'' Double Face Body - Both Ends - Mitered both ends\",IF(BodyType=5,\" 2Part 12'' Double Face Body - Both Ends - 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1," Retainer"]
[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," Header Panel"]
[]
[null,"Header Panel Size",null,null,null,null,null,"Height",null,0]
[]
[" ","Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE<=3)),KQ*2,IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE<=3)),KQ*4,IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE=4)),KQ*2,IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE=4)),KQ*4,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(AND(NoYesHD=2,Body=2,retro=1,RETTYPE<=3))),Wdt+0.125,IF(AND(AND(AND(NoYesHD=2,Body=2,retro=1,RETTYPE=4))),Wdt+0.125,IF(AND(AND(AND(NoYesHD=2,Body=2,retro=2,RETTYPE<=3))),Wdt+0.25,IF(AND(AND(AND(NoYesHD=2,Body=2,retro=2,RETTYPE=4))),Wdt+0.25,IF(AND(NoYesHD=2,RETTYPE<=3),Wdt,IF(AND(NoYesHD=2,RETTYPE=4),Wdt,\"\"))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(NoYesHD=2,RETTYPE<=3),\"1940\"&PPTD,IF(AND(NoYesHD=2,RETTYPE=4),\"1939\"&PPTD,\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(NoYesHD=2,RETTYPE<=3),\" 2Part Extended Retainer - Top & Bottom - Mitered both ends\",IF(AND(NoYesHD=2,RETTYPE=4),\" 2Part Large Extended Retainer - Top & Bottom - Mitered both ends\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE=1)),KQ*2,IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE=2)),KQ,IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE=4)),KQ*2,IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE=1)),KQ*4,IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE=2)),KQ*2,IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE=4)),KQ*4,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(AND(Body=2,retro=1,NoYesHD=2,RETTYPE=1))),HgtHD+0.0625,IF(AND(AND(AND(Body=2,retro=1,NoYesHD=2,RETTYPE=2))),HgtHD+0.0625,IF(AND(AND(AND(Body=2,retro=1,NoYesHD=2,RETTYPE=4))),HgtHD+0.0625,IF(AND(AND(AND(Body=2,retro=2,NoYesHD=2,RETTYPE=1))),HgtHD+0.125,IF(AND(AND(AND(Body=2,retro=2,NoYesHD=2,RETTYPE=2))),HgtHD+0.125,IF(AND(AND(AND(Body=2,retro=2,NoYesHD=2,RETTYPE=4))),HgtHD+0.125,IF(AND(NoYesHD=2,RETTYPE=1),HgtHD,IF(AND(NoYesHD=2,RETTYPE=2),HgtHD,IF(AND(NoYesHD=2,RETTYPE=4),HgtHD,\"\")))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(NoYesHD=2,RETTYPE=1),\"1940\"&PPTD,IF(AND(NoYesHD=2,RETTYPE=2),\"1940\"&PPTD,IF(AND(NoYesHD=2,RETTYPE=4),\"1939\"&PPTD,\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(NoYesHD=2,RETTYPE=1),\" 2Part Extended Retainer - Both Ends - Mitered both ends\",IF(AND(NoYesHD=2,RETTYPE=2),\" 2Part Extended Retainer - One End - Mitered both ends\",IF(AND(NoYesHD=2,RETTYPE=4),\" 2Part Large Extended Retainer - Both Ends - 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,null,null," "]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE=2)),KQ,IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE=3)),KQ*2,IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE=2)),KQ*2,IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE=3)),KQ*4,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(AND(NoYesHD=2,Body=2,retro=1,RETTYPE=2))),HgtHD+0.0625,IF(AND(AND(AND(NoYesHD=2,Body=2,retro=1,RETTYPE=3))),HgtHD+0.0625,IF(AND(AND(AND(NoYesHD=2,Body=2,retro=2,RETTYPE=2))),HgtHD+0.125,IF(AND(AND(AND(NoYesHD=2,Body=2,retro=2,RETTYPE=3))),HgtHD+0.125,IF(AND(NoYesHD=2,RETTYPE=2),HgtHD,IF(AND(NoYesHD=2,RETTYPE=3),HgtHD,\"\"))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(NoYesHD=2,RETTYPE=2),\"1955\"&PPTD,IF(AND(NoYesHD=2,RETTYPE=3),\"1955\"&PPTD,\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(NoYesHD=2,RETTYPE=2),\"2Part Extened Frame - One End - Mitered both ends\",IF(AND(NoYesHD=2,RETTYPE=3),\"2Part Extened Frame - Both Ends - Mitered both ends\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE=2)),KQ,IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE=3)),KQ*2,IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE=2)),KQ*2,IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE=3)),KQ*4,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(AND(NoYesHD=2,Body=2,retro=1,RETTYPE=2))),HgtHD+0.0625,IF(AND(AND(AND(NoYesHD=2,Body=2,retro=1,RETTYPE=3))),HgtHD+0.0625,IF(AND(AND(AND(NoYesHD=2,Body=2,retro=2,RETTYPE=2))),HgtHD+0.125,IF(AND(AND(AND(NoYesHD=2,Body=2,retro=2,RETTYPE=3))),HgtHD+0.125,IF(AND(NoYesHD=2,RETTYPE=2),HgtHD,IF(AND(NoYesHD=2,RETTYPE=3),HgtHD,\"\"))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(NoYesHD=2,RETTYPE=2),\"1944\"&PPTD,IF(AND(NoYesHD=2,RETTYPE=3),\"1944\"&PPTD,\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(NoYesHD=2,RETTYPE=2),\"2Part Retainer - One End - Mitered both ends\",IF(AND(NoYesHD=2,RETTYPE=3),\"2Part Retainer - Both Ends - 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,null,null,null,null," "]
[]
[null,"2Part 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," Divider",false]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(MNUB=2,\"\",IF(BodyType<=2,KQ,IF(BodyType>=3,KQ*2,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(MNUB=2,\"\",IF(AND(RETTYPE<=4,VD=TRUE),HgtVC-3.518,IF(AND(RETTYPE=5,VD=TRUE),HgtVC-4.936,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(MNUB=2,\"\",IF(AND(INFRM=1,VD=TRUE),\"1905\"&PPTD,IF(AND(INFRM=2,VD=TRUE),\"1905\"&PPTD,\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(MNUB=2,\"\",IF(AND(INFRM=1,VD=TRUE),\" 2Part Divider - Vertical - Straight Cut Both Ends\",IF(AND(INFRM=2,VD=TRUE),\" 2Part Divider - Vertical - Straight Cut Both Ends\",\"\"))))))","v":""}]
[]
[null,"Vandal Cover",null,null,null,null,null,null,null,"Menu Board",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1," Vandal Cover",null,1," Menu Board"]
[]
[null,"Inner Frame",null,null,null,null,null,null,null,null,null,null,null,null,"Height",null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(Body=2,retro=1,NoYesHD=1)),Hgt+0.125,IF(AND(AND(AND(Body=2,retro=1,NoYesHD=2,NOYES=2))),Hgt-HgtHD+0.0625,IF(AND(AND(Body=2,retro=2,NoYesHD=1)),Hgt+0.25,IF(AND(AND(AND(Body=2,retro=2,NoYesHD=2,NOYES=2))),Hgt-HgtHD+0.125,IF(NoYesHD=1,Hgt,IF(AND(NoYesHD=2,NOYES=2),Hgt-HgtHD,\"\")))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(AND(NOYES=2,MNUB=2),\"Width\",\"\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NDRS=0,0,IF(AND(AND(AND(Body=2,retro=1,NOYES=2,MNUB=2))),(Wdt+0.125)/NDRS,IF(AND(AND(AND(Body=2,retro=2,NOYES=2,MNUB=2))),(Wdt+0.25)/NDRS,IF(AND(NOYES=2,MNUB=2),Wdt/NDRS,\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(NOYES=2,MNUB=2),\"Number of Doors\",\"\"))","v":""},null,null,null,0,null,null,1," Frame Type",null,null," "]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=2,MNUB=2),(NDRS*2)*KQ,IF(AND(BodyType>=3,MNUB=2),(NDRS*4)*KQ,IF(BodyType<=2,KQ*2,IF(BodyType>=3,KQ*4,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(Body=2,retro=1,MNUB=1)),Wdt+0.125,IF(AND(AND(Body=2,retro=2,MNUB=1)),Wdt+0.25,IF(MNUB=2,WdtMB,IF(AND(BodyType>=1,MNUB=1),Wdt,\"\")))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(INFRM=1,\"1960\"&PPTD,IF(INFRM=2,\"1959\"&PPTD,\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\" Select Menu Board\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\" Select 2Part Inner and Outer Frame\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\" Select 2Part Large Inner and Outer Frame\",IF(INFRM=1,\" 2Part Inner Frame - Top & Bottom - Mitered both ends\",IF(INFRM=2,\" 2Part Large Inner Frame - Top & 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," Select Menu Board",null,null,null,null,null," "]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=2,MNUB=2),(NDRS*2)*KQ,IF(AND(BodyType>=3,MNUB=2),(NDRS*4)*KQ,IF(BodyType<=2,KQ*2,IF(BodyType>=3,KQ*4,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(NoYesHD=1,HgtVC,IF(MNUB=2,HgtVC,IF(AND(BodyType>=1,MNUB=1),HgtVC,\"\"))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(INFRM=1,\"1960\"&PPTD,IF(INFRM=2,\"1959\"&PPTD,\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\" Select Menu Board\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\" Select 2Part Inner and Outer Frame\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\" Select 2Part Large Inner and Outer Frame\",IF(INFRM=1,\" 2Part Inner Frame - Both Ends - Mitered both ends\",IF(INFRM=2,\" 2Part Large Inner Frame - Both Ends - Mitered both ends\",\"\")))))))","v":""}]
[]
[null,"Outer Frame",null,null,null,null,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," Vandal Cover"]
[null,null,null,null,null,null,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," Hinge"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=2),\"\",IF(AND(BodyType<=2,MNUB=2),(NDRS*2)*KQ,IF(AND(BodyType>=3,MNUB=2),(NDRS*4)*KQ,IF(BodyType<=2,KQ*2,IF(BodyType>=3,KQ*4,\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=2),\"\",IF(AND(INFRM=2,OTFRM=1),\"\",IF(AND(OTFRM=1,Hinge=1),IFW-0.875,IF(AND(OTFRM=2,Hinge=1),IFW-1.1875,IF(AND(OTFRM=1,Hinge=2),IFW-1.125,IF(AND(OTFRM=2,Hinge=2),IFW-1.171875)))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=2),\"\",IF(AND(INFRM=2,OTFRM=1),\"\",IF(OTFRM=1,\"1942\"&PPTD,IF(OTFRM=2,\"1941\"&PPTD)))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\" Select Menu Board\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\" Select 2Part Inner and Outer Frame\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\" Select 2Part Large Inner and Outer Frame\",IF(AND(INFRM=1,OTFRM=2),\" Select 2Part Outer Frame\",IF(AND(INFRM=2,OTFRM=1),\" Select 2Part Large Outer Frame\",IF(OTFRM=1,\" 2Part Outer Frame - Top/Bottom - Mitered both ends\",IF(OTFRM=2,\" 2Part Large Outer Frame - Top/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," Select 2Part Large Inner Frame",null,null," Select 2Part Large Outer Frame"]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=2),\"\",IF(AND(BodyType<=2,MNUB=2),(NDRS*2)*KQ,IF(AND(BodyType>=3,MNUB=2),(NDRS*4)*KQ,IF(BodyType<=2,KQ*2,IF(BodyType>=3,KQ*4,\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=2),\"\",IF(AND(INFRM=2,OTFRM=1),\"\",IF(AND(OTFRM=1,Hinge=1),IFH-1.125,IF(AND(OTFRM=2,Hinge=1),IFH-1.171875,IF(AND(OTFRM=1,Hinge=2),IFH-0.875,IF(AND(OTFRM=2,Hinge=2),IFH-1.1875)))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=2),\"\",IF(AND(INFRM=2,OTFRM=1),\"\",IF(OTFRM=1,\"1942\"&PPTD,IF(OTFRM=2,\"1941\"&PPTD)))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\" Select Menu Board\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\" Select 2Part Inner and Outer Frame\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\" Select 2Part Large Inner and Outer Frame\",IF(AND(INFRM=1,OTFRM=2),\" Select 2Part Outer Frame\",IF(AND(INFRM=2,OTFRM=1),\" Select 2Part Large Outer Frame\",IF(OTFRM=1,\" 2Part Outer Frame - Both ends -  Mitered both ends\",IF(OTFRM=2,\" 2Part Large Outer Frame -  Both ends - 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," Select 2Part Inner and Outer Frame"]
[null,"Hinge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Select 2Part Large Inner and Outer Frame"]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=2),\"\",IF(AND(INFRM=2,OTFRM=1),\"\",IF(AND(BodyType<=2,MNUB=2),NDRS*KQ,IF(AND(BodyType>=3,MNUB=2),(NDRS*2)*KQ,IF(BodyType<=2,KQ,IF(BodyType>=3,KQ*2,\"\")))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=2),\"\",IF(AND(INFRM=2,OTFRM=1),\"\",IF(Hinge=1,OFH,IF(Hinge=2,OFW)))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=2),\"\",IF(AND(INFRM=2,OTFRM=1),\"\",IF(OTFRM=1,\"5996\"&PPTD,IF(OTFRM=2,\"5997\"&PPTD)))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\" Select Menu Board\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\" Select 2Part Inner and Outer Frame\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\" Select 2Part Large Inner and Outer Frame\",IF(AND(INFRM=1,OTFRM=2),\" Select 2Part Outer Frame\",IF(AND(INFRM=2,OTFRM=1),\" Select 2Part Large Outer Frame\",IF(AND(OTFRM=1,Hinge=1),\" 2Part Hinge - Top or Bottom Hinged - 1-1/16'' x .90'' Aluminum Hinge\",IF(AND(OTFRM=2,Hinge=1),\" 2Part Large Hinge - Top or Bottom Hinged - 1-1/16'' x .090'' Aluminum Hinge\",IF(AND(OTFRM=1,Hinge=2),\" 2Part Hinge - Side Hinged - 1-1/2'' x .090'' Aluminum Hinge\",IF(AND(OTFRM=2,Hinge=2),\" 2Part Large Hinge - Side Hinged - 1-1/2'' x .090'' Aluminum Hinge\")))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Select 2Part Outer Frame"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BILL OF MATERIAL"]
[]
[null,{"$f":"IF(KQ=0,\"\",HeadA)","v":""}]
[null,{"$f":"IF(KQ=0,\"\",HeadB)","v":""}]
[]
[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,"Height  ",null,null,null,{"$f":"IF(Hgt=0,\"\",Hgt)","v":""},null,"Width",null,null,null,{"$f":"IF(Wdt=0,\"\",Wdt)","v":""}]
[]
[null,"Hardware"]
[null,"Body"]
[null,{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType<=5,KQ*4,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType=1,\"5981\",IF(BodyType=2,\"5979\",IF(BodyType=3,\"5985\",IF(BodyType=4,\"5978\",IF(BodyType=5,\"5977\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType=1,\" 1Part-2Part 6'' Single Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (4-3/16'') - One (1) per corner\",IF(BodyType=2,\" 1Part-2Part 8'' Single Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (6-3/16'') - One (1) per corner\",IF(BodyType=3,\" 1Part-2Part 6'' Double Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (3-3/4'') - One (1) per corner\",IF(BodyType=4,\" 1Part-2Part 9'' Double Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (6-5/16'') - One (1) per corner\",IF(BodyType=5,\" 1Part-2Part 12'' Double Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (9-5/16'') - One (1) per corner\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType<=5,KQ*18,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType<=5,\"5218\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType<=5,\" Corner Angle Screw - #10 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type AB - Four (4) per corner\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType=3,\"\",IF(OR(BodyType<=2,BodyType>=4),KQ*8,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType=3,\"\",IF(OR(BodyType<=2,BodyType>=4),\"5210\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Body=2,\"\",IF(BodyType=3,\"\",IF(OR(BodyType<=2,BodyType>=4),\" Corner Key  - .120 Stamped Aluminum - Two (2) per corner\",\"\"))))","v":""}]
[null,"Retainer"]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE<=4)),KQ*4,IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE<=4)),KQ*8,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE<=4)),\"5210\",IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE<=4)),\"5210\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE<=4)),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE<=4)),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE<=4)),KQ*4,IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE<=4)),KQ*8,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE<=4)),\"5305\",IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE<=4)),\"5305\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(NoYesHD=2,BodyType<=2,RETTYPE<=4)),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' - 1-1/16'' - One (1) per corner\",IF(AND(AND(NoYesHD=2,BodyType>=3,RETTYPE<=4)),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' - 1-1/16'' - One (1) per corner\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE<=4)),(HDSC+2)*KQ,IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE<=4)),((HDSC*2)+2)*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE<=4)),\"5290\"&PPTD,IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE<=4)),\"5290\"&PPTD,\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE<=3)),\" 2Part Extended Retainer Screw - #8 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type A - One (1) every 12'' on center\",IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE<=3)),\" 2Part Extended Retainer Screw - #8 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type A - One (1) every 12'' on center\",IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE=4)),\" 2Part Large Extended Retainer Screw - #8 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type A - One (1) every 12'' on center\",IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE=4)),\" 2Part Large Extended Retainer Screw - #8 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type A - One (1) every 12'' on center\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(BodyType<=5,NoYesHD=2,RETTYPE=3)),\"\",IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE=1)),KQ*6,IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE=1)),KQ*10,IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE=2)),KQ*4,IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE=2)),KQ*6,IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE=4)),KQ*6,IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE=4)),KQ*10,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(BodyType<=5,NoYesHD=2,RETTYPE=3)),\"\",IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE=1)),\"5241\"&PPTD,IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE=1)),\"5241\"&PPTD,IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE=2)),\"5241\"&PPTD,IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE=2)),\"5241\"&PPTD,IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE=4)),\"5241\"&PPTD,IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE=4)),\"5241\"&PPTD,\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(BodyType<=5,NoYesHD=2,RETTYPE=3)),\"\",IF(AND(AND(BodyType>=1,NoYesHD=2,RETTYPE=1)),\" 2Part Extended Retainer Screw - #8 x 3/4'' Sq/Phillips Counter Sink S.S. Screw - Type A - One (1) per corner\",IF(AND(AND(BodyType>=1,NoYesHD=2,RETTYPE=2)),\" 2Part Extended Retainer Screw - #8 x 3/4'' Sq/Phillips Counter Sink S.S. Screw - Type A - One (1) per corner/one side\",IF(AND(AND(BodyType>=1,NoYesHD=2,RETTYPE=4)),\" 2Part Large Extended Retainer Screw - #8 x 3/4'' Sq/Phillips Counter Sink S.S. Screw - Type A - One (1) per corner\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE=2)),(VERTHD+2)*KQ,IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE=2)),((VERTHD*2)+2)*KQ,IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE=3)),((VERTHD+VERTHDB)+2)*KQ,IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE=3)),(((VERTHD+VERTHDB)*2)+2)*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE=2)),\"5290\"&PPTD,IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE=2)),\"5290\"&PPTD,IF(AND(AND(BodyType<=2,NoYesHD=2,RETTYPE=3)),\"5290\"&PPTD,IF(AND(AND(BodyType>=3,NoYesHD=2,RETTYPE=3)),\"5290\"&PPTD,\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYesHD=1,\"\",IF(AND(AND(BodyType<=5,NoYesHD=2,RETTYPE=2)),\" 2Part Retainer Screw - #8 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type A - One (1) every 12'' on center\",IF(AND(AND(BodyType<=5,NoYesHD=2,RETTYPE=3)),\" 2Part Retainer Screw - #8 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type A - One (1) every 12'' on center\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(AND(BodyType<=2,NoYesHD=2,NOYES=2,MNUB=2))),((NDRS-1)*4)+4*KQ,IF(AND(AND(AND(BodyType>=3,NoYesHD=2,NOYES=2,MNUB=2))),((NDRS-1)*4)+4*2*KQ,IF(AND(AND(BodyType<=2,NoYesHD=2,NOYES=2)),KQ*4,IF(AND(AND(BodyType>=3,NoYesHD=2,NOYES=2)),KQ*8,IF(AND(AND(AND(BodyType<=2,NoYesHD=1,NOYES=2,MNUB=2))),((NDRS-1)*4)*KQ,IF(AND(AND(AND(BodyType>=3,NoYesHD=1,NOYES=2,MNUB=2))),(((NDRS-1)*4)*2)*KQ,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(BodyType<=2,NoYesHD=2,NOYES=2)),\"5980\",IF(AND(AND(BodyType>=3,NoYesHD=2,NOYES=2)),\"5980\",IF(AND(AND(AND(BodyType<=2,NoYesHD=2,NOYES=2,MNUB=2))),\"5980\",IF(AND(AND(AND(BodyType>=3,NoYesHD=2,NOYES=2,MNUB=2))),\"5980\",IF(AND(AND(AND(BodyType<=2,NoYesHD=1,NOYES=2,MNUB=2))),\"5980\",IF(AND(AND(AND(BodyType>=3,NoYesHD=1,NOYES=2,MNUB=2))),\"5980\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(BodyType<=2,NoYesHD=2,NOYES=2)),\" Header/Reader Divider Angle - 2'' x 2'' x 1/8'' - 3/4'' - Two (2) per end\",IF(AND(AND(BodyType>=3,NoYesHD=2,NOYES=2)),\" Header/Reader Divider Angle - 2'' x 2'' x 1/8'' - 3/4'' - Two (2) per end\",IF(AND(AND(AND(BodyType<=2,NoYesHD=2,NOYES=2,MNUB=2))),\" Header/Reader Divider Angle - 2'' x 2'' x 1/8'' - 3/4'' - Two (2) per end\",IF(AND(AND(AND(BodyType>=3,NoYesHD=2,NOYES=2,MNUB=2))),\" Header/Reader Divider Angle - 2'' x 2'' x 1/8'' - 3/4'' - Two (2) per end\",IF(AND(AND(AND(BodyType<=2,NoYesHD=1,NOYES=2,MNUB=2))),\" Header/Reader Divider Angle - 2'' x 2'' x 1/8'' - 3/4'' - Two (2) per end\",IF(AND(AND(AND(BodyType>=3,NoYesHD=1,NOYES=2,MNUB=2))),\" Header/Reader Divider Angle - 2'' x 2'' x 1/8'' - 3/4'' - Two (2) per end\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(AND(BodyType<=2,NoYesHD=2,NOYES=2,MNUB=2))),(((NDRS-1)*6)+6)+2*KQ,IF(AND(AND(AND(BodyType>=3,NoYesHD=2,NOYES=2,MNUB=2))),((((NDRS-1)*6)+6)*2)+2*KQ,IF(AND(AND(BodyType<=2,NoYesHD=2,NOYES=2)),KQ*8,IF(AND(AND(BodyType>=3,NoYesHD=2,NOYES=2)),KQ*14,IF(AND(AND(AND(BodyType<=2,NoYesHD=1,NOYES=2,MNUB=2))),((NDRS-1)*6)+2*KQ,IF(AND(AND(AND(BodyType>=3,NoYesHD=1,NOYES=2,MNUB=2))),(((NDRS-1)*6)*2)+2*KQ,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(BodyType<=2,NoYesHD=2,NOYES=2)),\"5290\",IF(AND(AND(BodyType>=3,NoYesHD=2,NOYES=2)),\"5290\",IF(AND(AND(AND(BodyType<=2,NoYesHD=2,NOYES=2,MNUB=2))),\"5290\",IF(AND(AND(AND(BodyType>=3,NoYesHD=2,NOYES=2,MNUB=2))),\"5290\",IF(AND(AND(AND(BodyType<=2,NoYesHD=1,NOYES=2,MNUB=2))),\"5290\",IF(AND(AND(AND(BodyType>=3,NoYesHD=1,NOYES=2,MNUB=2))),\"5290\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(BodyType<=2,NoYesHD=2,NOYES=2)),\" Header/Reader Divider Angle Screw - #8 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type A - Three (3) each end\",IF(AND(AND(BodyType>=3,NoYesHD=2,NOYES=2)),\" Header/Reader Divider Angle Screw - #8 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type A - Three (3) each end\",IF(AND(AND(AND(BodyType<=2,NoYesHD=2,NOYES=2,MNUB=2))),\" Header/Reader Divider Angle Screw - #8 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type A - Three (3) each end\",IF(AND(AND(AND(BodyType>=3,NoYesHD=2,NOYES=2,MNUB=2))),\" Header/Reader Divider Angle Screw - #8 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type A - Three (3) each end\",IF(AND(AND(AND(BodyType<=2,NoYesHD=1,NOYES=2,MNUB=2))),\" Header/Reader Divider Angle Screw - #8 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type A - Three (3) each end\",IF(AND(AND(AND(BodyType>=3,NoYesHD=1,NOYES=2,MNUB=2))),\" Header/Reader Divider Angle Screw - #8 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type A - Three (3) each end\",\"\")))))))","v":""}]
[null,"Divider"]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(MNUB=2,\"\",IF(AND(AND(BodyType<=2,INFRM<=2,VD=TRUE)),KQ*VDA,IF(AND(AND(BodyType>=3,INFRM<=2,VD=TRUE)),KQ*VDA,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(MNUB=2,\"\",IF(AND(AND(BodyType<=2,INFRM<=2,VD=TRUE)),\"5300\",IF(AND(AND(BodyType>=3,INFRM<=2,VD=TRUE)),\"5300\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(MNUB=2,\"\",IF(AND(AND(BodyType<=2,INFRM<=2,VD=TRUE)),\" 2Part Divider Angle - Two (2) Per End -( Vertical Divider)\",IF(AND(AND(BodyType>=3,INFRM<=2,VD=TRUE)),\" 2Part Divider Angle - Two (2) Per End - (Vertical 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(NoYes2=1,\"\",IF(AND(AND(BodyType<=2,NoYes2=2,VD=TRUE)),4,IF(AND(AND(BodyType>=3,NoYes2=2,VD=TRUE)),8,\"\")))","v":""}," Number of Divider Angles"]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(MNUB=2,\"\",IF(AND(AND(BodyType<=2,INFRM<=2,VD=TRUE)),KQ*6,IF(AND(AND(BodyType>=3,INFRM<=2,VD=TRUE)),KQ*10,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(MNUB=2,\"\",IF(AND(AND(BodyType<=2,INFRM<=2,VD=TRUE)),\"5218\",IF(AND(AND(BodyType>=3,INFRM<=2,VD=TRUE)),\"5218\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(MNUB=2,\"\",IF(AND(AND(BodyType<=2,INFRM<=2,VD=TRUE)),\" 2Part Divider Angle Screw - #10 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Two (2) Per End - (Vertical Divider)\",IF(AND(AND(BodyType>=3,INFRM<=2,VD=TRUE)),\" 2Part Divider Angle Screw - #10 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Two (2) Per End - (Vertical Divider)\",\"\"))))))","v":""}]
[null,"Inner Frame"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM<=2,MNUB=2)),4*NDRS*KQ,IF(AND(AND(BodyType>=3,INFRM<=2,MNUB=2)),8*NDRS*KQ,IF(AND(BodyType<=2,INFRM<=2),KQ*4,IF(AND(BodyType>=3,INFRM<=2),KQ*8,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=2,INFRM<=2),\"5210\",IF(AND(BodyType>=3,INFRM<=2),\"5210\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=2,INFRM<=2),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType>=3,INFRM<=2),\" Corner Key - .120 Stamped Aluminum - One (1) 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":"INT(HgtHD/12)+1","v":1},{"$f":"INT(Wdt/12)+1","v":1},{"$f":"INT(HgtHD/12)+1","v":1},{"$f":"INT(Wdt/12)+1","v":1},{"$f":"SUM(AE92:AH92)","v":4}," Retainer Screws - Header"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=5,INFRM=1),\"\",IF(AND(AND(BodyType<=2,INFRM=2,MNUB=2)),4*NDRS*KQ,IF(AND(AND(BodyType>=3,INFRM=2,MNUB=2)),8*NDRS*KQ,IF(AND(BodyType<=2,INFRM=2),KQ*4,IF(AND(BodyType>=3,INFRM=2),KQ*8,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=5,INFRM=1),\"\",IF(AND(BodyType<=2,INFRM=2),\"5305\",IF(AND(BodyType>=3,INFRM=2),\"5305\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=5,INFRM=1),\"\",IF(AND(BodyType<=2,INFRM=2),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (1-1/16'') Aluminum Angle - One (1) per corner\",IF(AND(BodyType>=3,INFRM=2),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (1-1/16'') Aluminum Angle - One (1) 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":"INT(HgtVC/12)+1","v":{"$error":"#VALUE!"}},{"$f":"INT(Wdt/12)+1","v":1},{"$f":"INT(HgtVC/12)+1","v":{"$error":"#VALUE!"}},{"$f":"SUM(AE93:AG93)","v":{"$error":"#VALUE!"}},null," Retainer Screws - Reader"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=1,MNUB=2)),(4*NDRS)+2*KQ,IF(AND(AND(BodyType>=3,INFRM=1,MNUB=2)),(8*NDRS)+2*KQ,IF(AND(BodyType<=2,INFRM=1),KQ*6,IF(AND(BodyType>=3,INFRM=1),KQ*10,IF(AND(AND(BodyType<=2,INFRM=2,MNUB=2)),(8*NDRS)+2*KQ,IF(AND(AND(BodyType>=3,INFRM=2,MNUB=2)),(16*NDRS)+2*KQ,IF(AND(BodyType<=2,INFRM=2),KQ*10,IF(AND(BodyType>=3,INFRM=2),KQ*18,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=1,MNUB=2)),\"5241\"&PPTD,IF(AND(AND(BodyType>=3,INFRM=1,MNUB=2)),\"5241\"&PPTD,IF(AND(BodyType<=2,INFRM=1),\"5241\"&PPTD,IF(AND(BodyType>=3,INFRM=1),\"5241\"&PPTD,IF(AND(AND(BodyType<=2,INFRM=2,MNUB=2)),\"5990\",IF(AND(AND(BodyType>=3,INFRM=2,MNUB=2)),\"5990\",IF(AND(BodyType<=2,INFRM=2),\"5990\",IF(AND(BodyType>=3,INFRM=2),\"5990\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=1,MNUB=2)),\" Corner Screw - #8 x 3/4'' Sq/Phillips Counter Sink S.S. Screw - Type A - One (1) per corner\",IF(AND(AND(BodyType>=3,INFRM=1,MNUB=2)),\" Corner Screw - #8 x 3/4'' Sq/Phillips Counter Sink S.S. Screw - Type A - One (1) per corner\",IF(AND(BodyType<=2,INFRM=1),\" Corner Screw - #8 x 3/4'' Sq/Phillips Counter Sink S.S. Screw - Type A - One (1) per corner\",IF(AND(BodyType>=3,INFRM=1),\" Corner Screw - #8 x 3/4'' Sq/Phillips Counter Sink S.S. Screw - Type A - One (1) per corner\",IF(AND(AND(BodyType<=2,INFRM=2,MNUB=2)),\" Corner Screw - #8 x 3/8'' Sq/Phillips Counter Sink S.S. Screw - Type A - Two (2) per corner\",IF(AND(AND(BodyType>=3,INFRM=2,MNUB=2)),\" Corner Screw - #8 x 3/8'' Sq/Phillips Counter Sink S.S. Screw - Type A - Two (2) per corner\",IF(AND(BodyType<=2,INFRM=2),\" Corner Screw - #8 x 3/8'' Sq/Phillips Counter Sink S.S. Screw - Type A - Two (2) per corner\",IF(AND(BodyType>=3,INFRM=2),\" Corner Screw - #8 x 3/8'' Sq/Phillips Counter Sink S.S. Screw - Type A - Two (2) per corner\",\"\"))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM<=2,MNUB=2)),(MBRS*NDRS)+2*KQ,IF(AND(AND(BodyType>=3,INFRM<=2,MNUB=2)),((MBRS*2)*NDRS)+2*KQ,IF(AND(BodyType<=2,INFRM<=2),VASC+2*KQ,IF(AND(BodyType>=3,INFRM<=2),(VASC*2)+2*KQ,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM<=2,MNUB=2)),\"5290\"&PPTD,IF(AND(AND(BodyType>=3,INFRM<=2,MNUB=2)),\"5290\"&PPTD,IF(AND(BodyType<=2,INFRM<=2),\"5290\"&PPTD,IF(AND(BodyType>=3,INFRM<=2),\"5290\"&PPTD,\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM<=2,MNUB=2)),\"  Inner Frame to Body Screw - #8 x 1/2'' Sq/Phil Pan Head Steel Zinc Screw - Type A - One (1) every 12'' on center\",IF(AND(AND(BodyType>=3,INFRM<=2,MNUB=2)),\"  Inner Frame to Body Screw - #8 x 1/2'' Sq/Phil Pan Head Steel Zinc Screw - Type A - One (1) every 12'' on center\",IF(AND(BodyType<=2,INFRM<=2),\"  Inner Frame to Body Screw - #8 x 1/2'' Sq/Phil Pan Head Steel Zinc Screw - Type A - One (1) every 12'' on center\",IF(AND(BodyType>=3,INFRM<=2),\"  Inner Frame to Body Screw - #8 x 1/2'' Sq/Phil Pan Head Steel Zinc Screw - Type A - 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":"INT(Hgt/12)+1","v":1},{"$f":"INT(WdtMB/12)+1","v":{"$error":"#VALUE!"}},{"$f":"INT(WdtMB/12)+1","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(AE95:AG95)","v":{"$error":"#VALUE!"}}," Retainer Screws - Menu"]
[null,"Outer Frame"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=2,MNUB=2)),4*NDRS*KQ,IF(AND(AND(BodyType>=3,INFRM=2,MNUB=2)),8*NDRS*KQ,IF(AND(BodyType<=2,INFRM=2),KQ*4,IF(AND(BodyType>=3,INFRM=2),KQ*8,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=2,INFRM=2),\"5210\",IF(AND(BodyType>=3,INFRM=2),\"5210\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=2,INFRM=2),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType>=3,INFRM=2),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=1,MNUB=2)),8*NDRS*KQ,IF(AND(AND(BodyType>=3,INFRM=1,MNUB=2)),16*NDRS*KQ,IF(AND(BodyType<=2,INFRM=1),KQ*8,IF(AND(BodyType>=3,INFRM=1),KQ*16,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=2,INFRM=1),\"5975\",IF(AND(BodyType>=3,INFRM=1),\"5975\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=2,INFRM=1),\" Outer Frame Corner Angle - 2'' x 2'' x 1/8'' (3/8'') - Two (2) per corner\",IF(AND(BodyType>=3,INFRM=1),\" Outer Frame Corner Angle - 2'' x 2'' x 1/8'' (3/8'') - Two (2) per corner\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=2,MNUB=2)),8*NDRS*KQ,IF(AND(AND(BodyType>=3,INFRM=2,MNUB=2)),16*NDRS*KQ,IF(AND(BodyType<=2,INFRM=2),KQ*8,IF(AND(BodyType>=3,INFRM=2),KQ*16,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=2,INFRM=2),\"5305\",IF(AND(BodyType>=3,INFRM=2),\"5305\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=2,INFRM=2),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (1-1/16'') Aluminum Angle - Two (2) per corner\",IF(AND(BodyType>=3,INFRM=2),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (1-1/16'') Aluminum Angle - Two (2) per corner\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,OTFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,OTFRM=1)),\"\",IF(AND(AND(BodyType<=2,OTFRM=1,MNUB=2)),((16*NDRS)+2)*KQ,IF(AND(AND(BodyType>=3,OTFRM=1,MNUB=2)),((32*NDRS)+2)*KQ,IF(AND(BodyType<=2,OTFRM=1),KQ*18,IF(AND(BodyType>=3,OTFRM=1),KQ*34,IF(AND(AND(BodyType<=2,OTFRM=2,MNUB=2)),((8*NDRS)+2)*KQ,IF(AND(AND(BodyType>=3,OTFRM=2,MNUB=2)),((18*NDRS)+2)*KQ,IF(AND(BodyType<=2,OTFRM=2),KQ*10,IF(AND(BodyType>=3,OTFRM=2),KQ*18,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,OTFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,OTFRM=1)),\"\",IF(AND(AND(BodyType<=2,OTFRM=1,MNUB=2)),\"5990\",IF(AND(AND(BodyType>=3,OTFRM=1,MNUB=2)),\"5990\",IF(AND(BodyType<=2,OTFRM=1),\"5990\",IF(AND(BodyType>=3,OTFRM=1),\"5990\",IF(AND(AND(BodyType<=2,OTFRM=2,MNUB=2)),\"5990\",IF(AND(AND(BodyType>=3,OTFRM=2,MNUB=2)),\"5990\",IF(AND(BodyType<=2,OTFRM=2),\"5990\",IF(AND(BodyType>=3,OTFRM=2),\"5990\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=1,MNUB=2)),\" Corner Screw - #8 x 3/8'' Sq/Phillips Counter Sink S.S. Screw - Type A - Four (4) per corner\",IF(AND(AND(BodyType>=3,INFRM=1,MNUB=2)),\" Corner Screw - #8 x 3/8'' Sq/Phillips Counter Sink S.S. Screw - Type A - Four (4) per corner\",IF(AND(BodyType<=2,INFRM=1),\" Corner Screw - #8 x 3/8'' Sq/Phillips Counter Sink S.S. Screw - Type A - Four (4) per corner\",IF(AND(BodyType>=3,INFRM=1),\" Corner Screw - #8 x 3/8'' Sq/Phillips Counter Sink S.S. Screw - Type A - Four (4) per corner\",IF(AND(AND(BodyType<=2,INFRM=2,MNUB=2)),\" Corner Screw - #8 x 3/8'' Sq/Phillips Counter Sink S.S. Screw - Type A - Two (2) per corner\",IF(AND(AND(BodyType>=3,INFRM=2,MNUB=2)),\" Corner Screw - #8 x 3/8'' Sq/Phillips Counter Sink S.S. Screw - Type A - Two (2) per corner\",IF(AND(BodyType<=2,INFRM=2),\" Corner Screw - #8 x 3/8'' Sq/Phillips Counter Sink S.S. Screw - Type A - Two (2) per corner\",IF(AND(BodyType>=3,INFRM=2),\" Corner Screw - #8 x 3/8'' Sq/Phillips Counter Sink S.S. Screw - Type A - Two (2) per corner\",\"\"))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=2,MNUB=2)),(8*NDRS)+2*KQ,IF(AND(AND(BodyType>=3,INFRM=2,MNUB=2)),(16*NDRS)+2*KQ,IF(AND(BodyType<=2,INFRM=2),KQ*10,IF(AND(BodyType>=3,INFRM=2),KQ*18,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=2,INFRM=2),\"5218\",IF(AND(BodyType>=3,INFRM=2),\"5218\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(BodyType<=2,INFRM=2),\" Frame Corner Angle Screw - #10 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type AB - Two (2) per corner\",IF(AND(BodyType>=3,INFRM=2),\" Frame Corner Angle Screw - #10 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type AB - Two (2) per corner\",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=1,MNUB=2)),NumLocks*KQ,IF(AND(AND(BodyType>=3,INFRM=1,MNUB=2)),(2*NumLocks)*KQ,IF(AND(BodyType<=2,INFRM=1),KQ*NumLocks,IF(AND(BodyType>=3,INFRM=1),(NumLocks*2)*KQ,IF(AND(AND(BodyType<=2,INFRM=2,MNUB=2)),NumLocks*KQ,IF(AND(AND(BodyType>=3,INFRM=2,MNUB=2)),(2*NumLocks)*KQ,IF(AND(BodyType<=2,INFRM=2),KQ*NumLocks,IF(AND(BodyType>=3,INFRM=2),(NumLocks*2)*KQ,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=1,MNUB=2)),\"5994\",IF(AND(AND(BodyType>=3,INFRM=1,MNUB=2)),\"5994\",IF(AND(BodyType<=2,INFRM=1),\"5994\",IF(AND(BodyType>=3,INFRM=1),\"5994\",IF(AND(AND(BodyType<=2,INFRM=2,MNUB=2)),\"5993\",IF(AND(AND(BodyType>=3,INFRM=2,MNUB=2)),\"5993\",IF(AND(BodyType<=2,INFRM=2),\"5993\",IF(AND(BodyType>=3,INFRM=2),\"5993\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=1,MNUB=2)),\" 2Part Lock\",IF(AND(AND(BodyType>=3,INFRM=1,MNUB=2)),\" 2Part Lock\",IF(AND(BodyType<=2,INFRM=1),\" 2Part Lock\",IF(AND(BodyType>=3,INFRM=1),\" 2Part Lock\",IF(AND(AND(BodyType<=2,INFRM=2,MNUB=2)),\" 2Part Large Lock\",IF(AND(AND(BodyType>=3,INFRM=2,MNUB=2)),\" 2Part Large Lock\",IF(AND(BodyType<=2,INFRM=2),\" 2Part Large Lock\",IF(AND(BodyType>=3,INFRM=2),\" 2Part Large Lock\",\"\"))))))))))))","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(AND(AND(AND(IFW<=60,NOYES=2,MNUB=1,Hinge=1))),1,IF(AND(AND(AND(IFW>=61,NOYES=2,MNUB=1,Hinge=1))),2,IF(AND(AND(AND(IFH<=60,NOYES=2,MNUB=1,Hinge=2))),1,IF(AND(AND(AND(IFH>=61,NOYES=2,MNUB=1,Hinge=2))),2,IF(AND(AND(AND(IFW<=60,NOYES=2,MNUB=2,Hinge=1))),1*NDRS,IF(AND(AND(AND(IFW>=61,NOYES=2,MNUB=2,Hinge=1))),2*NDRS,IF(AND(AND(AND(IFH<=60,NOYES=2,MNUB=2,Hinge=2))),1*NDRS,IF(AND(AND(AND(IFH>=61,NOYES=2,MNUB=2,Hinge=2))),2*NDRS)))))))))","v":""},"Locks"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=1,MNUB=2)),1,IF(AND(AND(BodyType>=3,INFRM=1,MNUB=2)),1,IF(AND(BodyType<=2,INFRM=1),1,IF(AND(BodyType>=3,INFRM=1),1,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=1,MNUB=2)),\"5992\",IF(AND(AND(BodyType>=3,INFRM=1,MNUB=2)),\"5992\",IF(AND(BodyType<=2,INFRM=1),\"5992\",IF(AND(BodyType>=3,INFRM=1),\"5992\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(AND(BodyType<=2,INFRM=1,MNUB=2)),\" 2Part Lock Wrench\",IF(AND(AND(BodyType>=3,INFRM=1,MNUB=2)),\" 2Part Lock Wrench\",IF(AND(BodyType<=2,INFRM=1),\" 2Part Lock Wrench\",IF(AND(BodyType>=3,INFRM=1),\" 2Part Lock Wrench\",\"\"))))))))","v":""}]
[null,"Hinge"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(AND(AND(AND(BodyType<=2,MNUB=2,OTFRM=2,Hinge=2))),((((HgtVC/6)*2)*NDRS)+2)*KQ,IF(AND(AND(AND(BodyType>=3,MNUB=2,OTFRM=2,Hinge=2))),(((((HgtVC/6)*2)*2)*NDRS)+2)*KQ,IF(AND(AND(BodyType<=2,OTFRM=2,Hinge=1)),(((((Wdt-36)/6)+12)*2)+2)*KQ,IF(AND(AND(BodyType>=3,OTFRM=2,Hinge=1)),((((((Wdt-36)/6)+12)*2)*2)+2)*KQ,IF(AND(AND(BodyType<=2,OTFRM=2,Hinge=2)),(((HgtVC/6)*2)+2)*KQ,IF(AND(AND(BodyType>=3,OTFRM=2,Hinge=2)),((((HgtVC/6)*2)*2)+2)*KQ,\"\")))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(AND(AND(MNUB=2,OTFRM=2,Hinge=2)),\"5990\",IF(AND(OTFRM=2,Hinge=1),\"5990\",IF(AND(OTFRM=2,Hinge=2),\"5990\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(AND(AND(MNUB=2,OTFRM=2,Hinge=2)),\"2Part Large Hinge Screw - #8 x 3/8'' Sq/Phillips Counter Sunk S.S. Screw - Type-A\",IF(AND(OTFRM=2,Hinge=1),\"2Part Large Hinge Screw - #8 x 3/8'' Sq/Phillips Counter Sunk S.S. Screw - Type-A\",IF(AND(OTFRM=2,Hinge=2),\"2Part Large Hinge Screw - #8 x 3/8'' Sq/Phillips Counter Sunk S.S. Screw - Type-A\",\"\"))))))))","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," See Gas Support Placement ''A'' Instruction Sheet"]
[null,"Gas Support",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," See Gas Support Placement ''B'' Instruction Sheet"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(MNUB=2,\"\",IF(Hinge=2,\"\",IF(AND(BodyType<=2,OTFRM=2),KQ*1,IF(AND(BodyType>=3,OTFRM=2),KQ*2,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(MNUB=2,\"\",IF(Hinge=2,\"\",IF(AND(INFRM=2,OTFRM=2),'Gas Support'!$C$39))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(MNUB=2,\"\",IF(Hinge=2,\"\",IF(AND(INFRM=2,OTFRM=2),\" Gas Supports - Two (2) Per Face\",\"\"))))))))","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," See Gas Support Placement ''C'' Instruction Sheet"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(MNUB=2,\"\",IF(Hinge=2,\"\",IF(AND(INFRM=2,OTFRM=2),'Gas Support'!$C$61,\"\"))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(AND(AND(NoYesHD=1,NOYES=2,MNUB=1)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE<=3,INFRM=2)),\"\",IF(AND(AND(NoYesHD=2,RETTYPE=4,INFRM=1)),\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(MNUB=2,\"\",IF(Hinge=2,\"\",IF(GSPLMT=\"A\",\" See Gas Support Placement ''A'' Instruction Sheet\",IF(GSPLMT=\"B\",\" See Gas Support Placement ''B'' Instruction Sheet\",IF(GSPLMT=\"C\",\" See Gas Support Placement ''C'' Instruction Sheet\",\"\"))))))))))","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,"A","B","C"]
[null,"Hardware Summary"]
[]
[null,null,5985,null,{"$f":"SUMIF(C77:C105,C111,B77:B105)","v":0},null,5241,null,{"$f":"SUMIF(C77:C105,G111,B77:B105)","v":0},null,5978,null,{"$f":"SUMIF(C77:C105,K111,B77:B105)","v":0}]
[null,null,5218,null,{"$f":"SUMIF(C77:C105,C112,B77:B105)","v":0},null,5990,null,{"$f":"SUMIF(C77:C105,G112,B77:B105)","v":0},null,5977,null,{"$f":"SUMIF(C77:C105,K112,B77:B105)","v":0}]
[null,null,5210,null,{"$f":"SUMIF(C77:C105,C113,B77:B105)","v":0},null,5993,null,{"$f":"SUMIF(C77:C105,G113,B77:B105)","v":0},null,5168,null,{"$f":"SUMIF(C77:C105,K113,B77:B105)","v":0}]
[null,null,5305,null,{"$f":"SUMIF(C77:C105,C114,B77:B105)","v":0},null,5992,null,{"$f":"SUMIF(C77:C105,G114,B77:B105)","v":0},null,5980,null,{"$f":"SUMIF(C77:C105,K114,B77:B105)","v":0}]
[null,null,"5290P",null,{"$f":"SUMIF(C77:C105,C115,B77:B105)","v":0},null,5994,null,{"$f":"SUMIF(C77:C105,G115,B77:B105)","v":0},null,5975,null,{"$f":"SUMIF(C77:C105,K115,B77:B105)","v":0}]
[null,null,"5241P",null,{"$f":"SUMIF(C77:C105,C116,B77:B105)","v":0},null,5981,null,{"$f":"SUMIF(C77:C105,G116,B77:B105)","v":0},null,5300,null,{"$f":"SUMIF(C77:C105,K116,B77:B105)","v":0}]
[null,null,5290,null,{"$f":"SUMIF(C77:C105,C117,B77:B105)","v":0},null,5979,null,{"$f":"SUMIF(C77:C105,G117,B77:B105)","v":0}]

{"sheet":"Gas Support","index":1,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":true,"merged":[[60,0,60,1],[20,0,20,1],[22,0,22,1],[38,0,38,1],[42,0,42,1],[44,0,44,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"HT","Width"]
["Actual Cabinet Size",null,{"$f":"HgtVC","v":""},{"$f":"[0]!Wdt","v":0},null,null,{"$f":"IF(AH>=90,\"\",IF(AH>=84,84,IF(AH>=78,78,IF(AH>=72,72,IF(AH>=66,66,IF(AH>=60,60,IF(AH>=54,54,IF(AH>=48,48,IF(AH>=42,42,IF(AH>=36,36,IF(AH>=30,30,IF(AH>=24,24))))))))))))","v":""}]
[]
["Nominal Cabinet Size",null,{"$f":"G21","v":""},{"$f":"G23","v":false},null,null,{"$f":"IF(AW>=150,\"\",IF(AW>=144,144,IF(AW>=132,132,IF(AW>=120,120,IF(AW>=108,108,IF(AW>=96,96,IF(AW>=84,84,IF(AW>=72,72,IF(AW>=60,60,IF(AW>=48,48,IF(AW>=36,36)))))))))))","v":false}]
[]
[null,null,null,"WIDTH"]
[null,null,null,36,48,60,72,84,96,108,120,132,144]
[null,"HT",24,"K5933-30","K5933-30","K5933-40","K5933-40","K5933-50","K5933-50","K5933-50","K5933-60","K5933-60","K5933-70"]
[null,null,30,"K5934-30","K5934-30","K5934-30","K5934-40","K5934-40","K5934-40","K5934-50","K5934-50","K5934-50","K5934-60"]
[null,null,36,"K5934-30","K5934-30","K5934-40","K5934-50","K5934-50","K5934-60","K5934-60","K5934-70","K5934-70","K5934-70"]
[null,null,42,"K5934-40","K5934-50","K5934-50","K5934-60","K5934-60","K5934-70","K5934-80","K5934-80","K5934-90","K5934-90"]
[null,null,48,"K5934-50","K5934-60","K5934-60","K5934-70","K5934-80","K5934-90","K5934-90","K5934-100","K5934-110","K5934-110"]
[null,null,54,"K5934-60","K5934-70","K5934-80","K5934-80","K5934-90","K5934-100","K5934-110","K5934-120","K5934-130","K5934-140"]
[null,null,60,"K5934-70","K5934-80","K5934-90","K5934-100","K5934-110","K5934-120","K5934-130","K5934-140","K5934-160","K5934-170"]
[null,null,66,"K5934-80","K5934-90","K5934-100","K5934-120","K5934-130","K5934-140","K5934-150","K5934-170","K5934-180","K5934-110"]
[null,null,72,"K5934-90","K5934-100","K5934-120","K5934-130","K5934-150","K5934-160","K5934-180","K5934-110","K5934-110","K5934-120"]
[null,null,78,"K5934-60","K5934-70","K5934-80","K5934-80","K5934-90","K5934-100","K5934-110","K5934-120","K5934-130","K5934-140"]
[null,null,84,"K5934-60","K5934-70","K5934-80","K5934-90","K5934-100","K5934-120","K5934-130","K5934-140","K5934-150","K5934-160"]
[]
["Gas Support Required",null,{"$f":"INDEX(D27:M37,MATCH(HT,C27:C37,0),MATCH(WTH,D26:M26,0))","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(AH>=90,\"\",IF(AH>=84,84,IF(AH>=78,78,IF(AH>=72,72,IF(AH>=66,66,IF(AH>=60,60,IF(AH>=54,54,IF(AH>=48,48,IF(AH>=42,42,IF(AH>=36,36,IF(AH>=30,30,IF(AH>=24,24))))))))))))","v":""}]
[]
["Nominal Cabinet Size",null,{"$f":"G43","v":""},{"$f":"G45","v":false},null,null,{"$f":"IF(AW>=150,\"\",IF(AW>=144,144,IF(AW>=132,132,IF(AW>=120,120,IF(AW>=108,108,IF(AW>=96,96,IF(AW>=84,84,IF(AW>=72,72,IF(AW>=60,60,IF(AW>=48,48,IF(AW>=36,36)))))))))))","v":false}]
[]
[null,null,null,"WIDTH"]
[null,null,null,36,48,60,72,84,96,108,120,132,144]
[null,"HT",24,"A","A","A","A","A","A","A","A","A","A"]
[null,null,30,"B","B","B","B","B","B","B","B","B","B"]
[null,null,36,"B","B","B","B","B","B","B","B","B","B"]
[null,null,42,"B","B","B","B","B","B","B","B","B","B"]
[null,null,48,"B","B","B","B","B","B","B","B","B","B"]
[null,null,54,"B","B","B","B","B","B","B","B","B","B"]
[null,null,60,"B","B","B","B","B","B","B","B","B","B"]
[null,null,66,"B","B","B","B","B","B","B","B","B","C"]
[null,null,72,"B","B","B","B","B","B","B","C","C","C"]
[null,null,78,"C","C","C","C","C","C","C","C","C","C"]
[null,null,84,"C","C","C","C","C","C","C","C","C","C"]
[]
["Gas Support Placement",null,{"$f":"INDEX(D49:M59,MATCH(HT,C49:C59,0),MATCH(WTH,D48:M48,0))","v":{"$error":"#N/A"}}]

{"sheet":"GS Placement A","index":2,"n_rows":70,"n_cols":13,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,4,13],[5,1,6,13],[73,1,76,13],[68,8,68,9],[67,8,67,9]]}
[null,"S  I  G  N  C  O  M  P       S  Y  S  T  E  M  S      A  N  D      E  X  T  R  U  S  I  O  N  S"]
[]
[]
[]
[]
[null,"  2Part Large Vandal Cover and Large Vandal Cover"]
[]
[]
[null,null,"Gas Support Placement and Poundage Table:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Weight table for door in lbs."]
[]
[null,null,null,"Width"]
[null,null,"Height",36,48,60,72,84,96,108,120,132,144]
[null,null,24,16,20,24,28,32,37,41,45,49,53]
[null,null,30,19,23,28,33,37,42,47,51,56,60]
[null,null,36,21,26,32,37,42,47,52,58,63,68]
[null,null,42,24,30,35,41,47,53,58,64,70,76]
[null,null,48,26,33,39,45,52,58,64,70,77,83]
[null,null,54,29,36,43,50,56,63,70,77,84,91]
[null,null,60,32,39,46,54,61,69,76,83,91,98]
[null,null,66,34,42,50,58,66,74,82,90,98,106]
[null,null,72,37,45,54,62,71,79,88,96,105,113]
[null,null,78,39,48,58,67,76,85,94,103,112,121]
[null,null,84,42,52,61,71,80,90,100,109,119,128]
[]
[null,null,"Poundage per Gas Support in lbs. (2 Gas Supports per door)"]
[]
[null,null,null,"Width"]
[null,null,"Height",36,48,60,72,84,96,108,120,132,144]
[null,null,24,30,30,40,40,50,50,50,60,60,70]
[null,null,30]
[null,null,36]
[null,null,42]
[null,null,48]
[null,null,54]
[null,null,60]
[null,null,66]
[null,null,72]
[null,null,78]
[null,null,84]
[]
[null,null,null,null,"Placement \"A\" #5933 Gas Support",null,null,null,"Normal",null,"Stock Item"]
[null,null,null,null,"Placement \"B\" #5934 Gas Support",null,null,null,"Bold-Italic",null,"Non-Stock Item (Special Order)"]
[null,null,null,null,"Placement \"C\" #5934 Gas Support"]

{"sheet":"GS Placement B","index":3,"n_rows":70,"n_cols":13,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,4,13],[5,1,6,13],[73,1,76,13],[67,8,67,9],[68,8,68,9]]}
[null,"S  I  G  N  C  O  M  P       S  Y  S  T  E  M  S      A  N  D      E  X  T  R  U  S  I  O  N  S"]
[]
[]
[]
[]
[null,"  2Part Large Vandal Cover and Large Vandal Cover"]
[]
[]
[null,null,"Gas Support Placement and Poundage Table:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Weight table for door in lbs."]
[]
[null,null,null,"Width"]
[null,null,"Height",36,48,60,72,84,96,108,120,132,144]
[null,null,24,16,20,24,28,32,37,41,45,49,53]
[null,null,30,19,23,28,33,37,42,47,51,56,60]
[null,null,36,21,26,32,37,42,47,52,58,63,68]
[null,null,42,24,30,35,41,47,53,58,64,70,76]
[null,null,48,26,33,39,45,52,58,64,70,77,83]
[null,null,54,29,36,43,50,56,63,70,77,84,91]
[null,null,60,32,39,46,54,61,69,76,83,91,98]
[null,null,66,34,42,50,58,66,74,82,90,98,106]
[null,null,72,37,45,54,62,71,79,88,96,105,113]
[null,null,78,39,48,58,67,76,85,94,103,112,121]
[null,null,84,42,52,61,71,80,90,100,109,119,128]
[]
[null,null,"Poundage per Gas Support in lbs. (2 Gas Supports per door)"]
[]
[null,null,null,"Width"]
[null,null,"Height",36,48,60,72,84,96,108,120,132,144]
[null,null,24]
[null,null,30,30,30,30,40,40,40,50,50,50,60]
[null,null,36,30,30,40,50,50,60,60,70,70,70]
[null,null,42,40,50,50,60,60,70,80,80,90,90]
[null,null,48,50,60,60,70,80,90,90,100,110,110]
[null,null,54,60,70,80,80,90,100,110,120,130,140]
[null,null,60,70,80,90,100,110,120,130,140,160,170]
[null,null,66,80,90,100,120,130,140,150,170,180]
[null,null,72,90,100,120,130,150,160,180]
[null,null,78]
[null,null,84]
[]
[null,null,null,null,"Placement \"A\" #5933 Gas Support",null,null,null,"Normal",null,"Stock Item"]
[null,null,null,null,"Placement \"B\" #5934 Gas Support",null,null,null,"Bold-Italic",null,"Non-Stock Item (Special Order)"]
[null,null,null,null,"Placement \"C\" #5934 Gas Support"]

{"sheet":"GS Placement C","index":4,"n_rows":71,"n_cols":13,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,4,13],[5,1,6,13],[73,1,76,13],[68,8,68,9],[69,8,69,9]]}
[null,"S  I  G  N  C  O  M  P       S  Y  S  T  E  M  S      A  N  D      E  X  T  R  U  S  I  O  N  S"]
[]
[]
[]
[]
[null,"  2Part Large Vandal Cover and Large Vandal Cover"]
[]
[]
[null,null,"Gas Support Placement and Poundage Table:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Weight table for door in lbs."]
[]
[null,null,null,"Width"]
[null,null,"Height",36,48,60,72,84,96,108,120,132,144]
[null,null,24,16,20,24,28,32,37,41,45,49,53]
[null,null,30,19,23,28,33,37,42,47,51,56,60]
[null,null,36,21,26,32,37,42,47,52,58,63,68]
[null,null,42,24,30,35,41,47,53,58,64,70,76]
[null,null,48,26,33,39,45,52,58,64,70,77,83]
[null,null,54,29,36,43,50,56,63,70,77,84,91]
[null,null,60,32,39,46,54,61,69,76,83,91,98]
[null,null,66,34,42,50,58,66,74,82,90,98,106]
[null,null,72,37,45,54,62,71,79,88,96,105,113]
[null,null,78,39,48,58,67,76,85,94,103,112,121]
[null,null,84,42,52,61,71,80,90,100,109,119,128]
[]
[]
[null,null,"Poundage per Gas Support in lbs. (2 Gas Supports per door)"]
[]
[null,null,null,"Width"]
[null,null,"Height",36,48,60,72,84,96,108,120,132,144]
[null,null,24]
[null,null,30]
[null,null,36]
[null,null,42]
[null,null,48]
[null,null,54]
[null,null,60]
[null,null,66,null,null,null,null,null,null,null,null,null,110]
[null,null,72,null,null,null,null,null,null,null,110,110,120]
[null,null,78,60,70,80,80,90,100,110,120,130,140]
[null,null,84,60,70,80,90,100,120,130,140,150,160]
[]
[null,null,null,null,"Placement \"A\" #5933 Gas Support",null,null,null,"Normal",null,"Stock Item"]
[null,null,null,null,"Placement \"B\" #5934 Gas Support",null,null,null,"Bold-Italic",null,"Non-Stock Item (Special Order)"]
[null,null,null,null,"Placement \"C\" #5934 Gas Support"]