{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Series 2-3-4-7 Wall Mounted"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":21,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Series 2-3-4-7 Wall Mounted","index":0,"n_rows":122,"n_cols":39,"rows_kept":122,"cut":false,"hidden":false,"merged":[[111,2,111,3],[111,4,111,25],[5,45,5,47],[89,2,89,3],[89,4,89,25],[5,30,5,33],[5,35,5,36],[98,1,98,28],[99,2,99,3],[99,4,99,28],[100,2,100,3],[95,4,95,25],[95,35,95,36],[96,1,96,28],[97,1,97,28],[84,1,84,28],[85,1,85,28],[86,2,86,3],[86,4,86,28],[87,2,87,3],[87,4,87,25],[88,2,88,3],[88,4,88,25],[94,2,94,3],[91,1,91,28],[82,1,82,28],[77,1,77,25],[79,1,79,25],[81,1,81,25],[75,26,81,26],[75,27,81,27],[75,28,81,28],[78,1,78,4],[78,5,78,6],[78,7,78,10],[78,11,78,12],[78,13,78,16],[78,17,78,18],[78,19,78,22],[78,23,78,24],[75,1,75,25],[80,18,80,22],[80,1,80,17],[80,23,80,24],[20,1,20,28],[19,1,19,28],[18,1,18,28],[22,2,22,3],[22,5,22,6],[22,7,22,28],[48,1,48,28],[47,2,47,3],[47,5,47,6],[47,7,47,25],[42,1,42,17],[42,18,42,20],[42,21,42,22],[42,23,42,28],[45,5,45,6],[45,7,45,28],[46,2,46,3],[32,1,32,28],[73,1,73,28],[33,1,33,28],[31,1,31,28],[7,26,13,26],[7,27,13,27],[7,28,13,28],[10,19,10,22],[12,1,12,17],[12,18,12,22],[29,5,29,6],[46,5,46,6],[17,1,17,28],[23,7,23,25],[24,7,24,25],[27,1,27,28],[26,1,26,28],[29,2,29,3],[25,1,25,28],[30,2,30,3],[8,18,8,24],[10,7,10,10],[71,1,71,28],[44,1,44,28],[45,2,45,3],[12,31,12,32],[16,1,16,28],[18,31,18,32],[21,1,21,28],[23,2,23,3],[24,2,24,3],[23,5,23,6],[24,5,24,6],[115,1,115,28],[74,1,74,28],[76,1,76,4],[76,5,76,13],[76,14,76,17],[76,18,76,24],[72,1,72,28],[28,2,28,3],[28,5,28,6],[28,7,28,28],[30,5,30,6],[29,7,29,25],[30,7,30,25],[41,1,41,28],[69,1,69,28],[70,1,70,28],[119,12,119,14],[117,1,117,5],[119,3,119,4],[119,5,119,7],[119,10,119,11],[113,1,113,28],[114,1,114,28],[83,1,83,28],[92,1,92,28],[93,2,93,3],[93,4,93,28],[94,28,95,28],[90,1,90,28],[103,2,103,3],[103,4,103,25],[100,4,100,25],[100,28,103,28],[101,2,101,3],[101,4,101,25],[102,2,102,3],[102,4,102,25],[95,2,95,3],[104,1,104,28],[94,4,94,25],[1,1,1,28],[10,1,10,4],[5,1,5,28],[3,1,3,28],[8,1,8,4],[8,5,8,13],[8,14,8,17],[14,1,14,28],[15,1,15,28],[10,13,10,16],[10,17,10,18],[10,5,10,6],[10,11,10,12],[2,1,2,28],[4,1,4,28],[6,1,6,28],[9,1,9,25],[7,1,7,25],[10,23,10,24],[12,23,12,24],[13,1,13,25],[11,1,11,25],[36,33,36,36],[39,5,39,6],[40,5,40,6],[39,7,39,25],[40,7,40,25],[34,1,34,8],[36,1,36,8],[34,11,34,20],[34,21,34,28],[36,11,36,20],[36,21,36,28],[34,31,34,32],[36,31,36,32],[38,2,38,3],[38,5,38,6],[38,7,38,28],[39,2,39,3],[40,2,40,3],[34,33,34,37],[35,1,35,28],[37,1,37,28],[34,9,34,10],[36,9,36,10],[45,31,45,32],[121,3,121,6],[121,7,121,19],[5,38,5,43],[8,38,8,43],[105,1,105,28],[106,1,106,28],[108,2,108,3],[107,2,107,3],[110,2,110,3],[112,1,112,28],[107,4,107,28],[108,4,108,25],[110,4,110,25],[108,28,110,28],[109,2,109,3],[109,4,109,25],[46,7,46,25],[42,31,42,32],[43,1,43,28],[43,31,43,32],[42,33,42,39],[43,33,43,39],[87,28,89,28]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"AE6&AI6&AJ6&AL6&AL9&AM6&AM9","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,\"Series 2, 2'' Slide Body\",IF(BodyType=2,\"Series 2, 2'' Bleed Body\",IF(BodyType=3,\"Series 2, 2'' Frameless Body\",IF(BodyType=4,\"Series 2, 2'' Beveled Frame\",IF(BodyType=5,\"Series 3, 3-1/4'' Slide Body\",IF(BodyType=6,\"Series 3, 3-1/4'' Bleed Body\",IF(BodyType=7,\"Series 3, 3-1/4'' Frameless Body\",IF(BodyType=8,\"Series 3, 3-1/4'' - 1/4 Round Body\",IF(BodyType=9,\"Series 4, 4'' Frameless Body\",IF(BodyType=10,\"Series 3, Single Face Access Body\",IF(BodyType=11,\"Series 3, 1-5/8'', 1/2 Slide Body\",IF(BodyType=12,\"Series 7, 3-1/2'', 1/2 Slide Body\",\"\"))))))))))))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType=10,CVR>=1),\" with\",\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=9),\"\",IF(AND(BodyType=10,CVR=1),\" Slide Cover\",IF(AND(BodyType=10,CVR=2),\" Radius Slide Cover\",IF(AND(BodyType=10,CVR=3),\" Bleed Cover\",IF(AND(BodyType=10,CVR=4),\" Frameless Cover\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(Divdr=1,\"\",IF(AND(AND(BodyType=10,RadTyp<=2,Divdr=2)),\" and\",\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(Divdr=1,\"\",IF(AND(AND(BodyType=10,RadTyp<=2,Divdr=2)),\" Divder\",\"\"))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lengths Required","Lengths Used","Drops Used"]
[null,"Customer  ",null,null,null,null,null,null,null,null,null,null,null,null,"Order#   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RadEnd=1,\"\",IF(AND(BodyType=11,RadTyp>=1),\" and\",IF(AND(BodyType=12,RadTyp>=1),\" and\",\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RadEnd=1,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=1)),\" Radius Ends (sides)\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=2)),\" Radius Ends (Top & Bottom)\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=3)),\" Radius Ends (All Sides)\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos=1)),\" Radius Ends (Sides)\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos=2)),\" Radius Ends (Top & Bottom)\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos=3)),\" Radius Ends ( All Sides)\",\"\")))))))))","v":""}]
[]
[null,"Kit Quantity  ",null,null,null,0,null,"Cab./Panel Height ",null,null,null,0,null," Cab./Panel Width",null,null,null,0]
[]
[null,"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,1,"Mill/Pre-Paint",null,{"$f":"IF(PPTD=1,\"\",IF(PPTD=2,\"P\",\"\"))","v":""}]
[]
[null,"Extrusions"]
[]
[null,"Body",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Bodies"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Body Type"]
[]
[]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=13),2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD>=1,BOD<=13),Wdt,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"1110\"&PTD,IF(BodyType=2,\"1120\",IF(BodyType=3,\"1125\",IF(BodyType=4,\"1990\"&PTD,IF(BodyType=5,\"1260\"&PTD,IF(BodyType=6,\"1270\",IF(BodyType=7,\"1275\",IF(BodyType=8,\"1280\",IF(BodyType=9,\"1355\",IF(BodyType=10,\"1291\",IF(BodyType=11,\"1265\",IF(BodyType=12,\"1565\",IF(BodyType=13,\"1391\",\"\")))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 2, 2'' Slide Body - Mitred both ends - Top and Bottom\",IF(BodyType=2,\" Series 2, 2'' Bleed Body - Mitered both ends - Top and Bottom\",IF(BodyType=3,\" Series 2, 2'' Frameless Body - Mitered both ends - Top and Bottom\",IF(BodyType=4,\" Series 2, 2'' Beveled Frame - Mitered Both Ends - Top and Bottom\",IF(BodyType=5,\" Series 3, 3-1/4'' Slide Body - Mitered both ends - Top and Bottom\",IF(BodyType=6,\" Series 3, 3-1/4'' Bleed Body - Mitered both ends - Top and Bottom\",IF(BodyType=7,\" Series 3, 3-1/4'' Frameless Body - Mitered both ends - Top and Bottom\",IF(BodyType=8,\" Series 3, 3-1/4'' - 1/4 Round Body - Mitered both ends - Top and Bottom\",IF(BodyType=9,\" Series 4, 4'' Frameless Body - Mitered both ends - Top and Bottom\",IF(BodyType=10,\" Series 3, Single Face Access Body - Mitered both ends - Top and Bottom\",IF(BodyType=11,\" Series 3, 1-5/8'' Half Slide Body - Mitered both ends - Top and Bottom\",IF(BodyType=12,\" Series 7, 3-1/2'' Half Slide Body - Mitered both ends - Top and Bottom\",IF(BodyType=13,\" Series 4, 4'' Single Face Access Body - Mitered both ends - Top and Bottom\",\"\")))))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=13),2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=13),Hgt,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"1110\"&PTD,IF(BodyType=2,\"1120\",IF(BodyType=3,\"1125\",IF(BodyType=4,\"1990\"&PTD,IF(BodyType=5,\"1260\"&PTD,IF(BodyType=6,\"1270\",IF(BodyType=7,\"1275\",IF(BodyType=8,\"1280\",IF(BodyType=9,\"1355\",IF(BodyType=10,\"1291\",IF(BodyType=11,\"1265\",IF(BodyType=12,\"1565\",IF(BodyType=13,\"1391\",\"\")))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 2, 2'' Slide Body - Mitred both ends - Sides/Ends\",IF(BodyType=2,\" Series 2, 2'' Bleed Body - Mitered both ends - Sides/Ends\",IF(BodyType=3,\" Series 2, 2'' Frameless Body - Mitered both ends - Sides/Ends\",IF(BodyType=4,\" Series 2, 2'' Beveled Frame - Mitered Both Ends - Sides/Ends\",IF(BodyType=5,\" Series 3, 3-1/4'' Slide Body - Mitered both ends - Sides/Ends\",IF(BodyType=6,\" Series 3, 3-1/4'' Bleed Body - Mitered both ends - Sides/Ends\",IF(BodyType=7,\" Series 3, 3-1/4'' Frameless Body - Mitered both ends - Sides/Ends\",IF(BodyType=8,\" Series 3, 3-1/4'' - 1/4 Round Body - Mitered both ends - Sides/Ends\",IF(BodyType=9,\" Series 4, 4'' Frameless Body - Mitered both ends - Sides/Ends\",IF(BodyType=10,\" Series 3, Single Face Access Body - Mitered both ends - Sides/Ends\",IF(BodyType=11,\" Series 3, 1-5/8'' Half Slide Body - Mitered both ends - Sides/Ends\",IF(BodyType=12,\" Series 7, 3-1/2'' Half Slide Body - Mitered both ends - Sides/Ends\",IF(BodyType=13,\" Series 4, 4'' Single Face Access Body - Mitered both ends - Sides/Ends\",\"\")))))))))))))))","v":""}]
[]
[null,"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,1,"Cover"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=9),\"\",IF(AND(BodyType=10,CVR<=4),2*KQ,IF(OR(BodyType=11,BodyType=12),\"\",IF(AND(BodyType=13,CVR<=4),2*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=9),\"\",IF(AND(BodyType=10,CVR<=4),Wdt+0.03125,IF(OR(BodyType=11,BodyType=12),\"\",IF(AND(BodyType=13,CVR<=4),Wdt+0.03125,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=9),\"\",IF(OR(BodyType=11,BodyType=12),\"\",IF(AND(BodyType=10,CVR=1),\"1694\",IF(AND(BodyType=10,CVR=2),\"1695\",IF(AND(BodyType=10,CVR=3),\"1692\",IF(AND(BodyType=10,CVR=4),\"1693\",IF(AND(BodyType=13,CVR=1),\"1694\",IF(AND(BodyType=13,CVR=2),\"1695\",IF(AND(BodyType=13,CVR=3),\"1692\",IF(AND(BodyType=13,CVR=4),\"1693\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=9),\"\",IF(AND(BodyType=10,CVR=1),\" Slide Cover - Mitered both ends - Top and Bottom\",IF(AND(BodyType=10,CVR=2),\" Radius Slide Cover - Mitered both ends - Top and Bottom\",IF(AND(BodyType=10,CVR=3),\" Bleed Cover - Mitered both ends - Top and Bottom\",IF(AND(BodyType=10,CVR=4),\" Frameless Cover - Mitered both ends - Top and Bottom\",IF(OR(BodyType=11,BodyType=12),\"\",IF(AND(BodyType=13,CVR=1),\" Slide Cover - Mitered both ends - Top and Bottom\",IF(AND(BodyType=13,CVR=2),\" Radius Slide Cover - Mitered both ends - Top and Bottom\",IF(AND(BodyType=13,CVR=3),\" Bleed Cover - Mitered both ends - Top and Bottom\",IF(AND(BodyType=13,CVR=4),\" Frameless Cover - Mitered both ends - Top and Bottom\",\"\"))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=9),\"\",IF(AND(BodyType=10,CVR<=4),2*KQ,IF(OR(BodyType=11,BodyType=12),\"\",IF(AND(BodyType=13,CVR<=4),2*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=9),\"\",IF(AND(BodyType=10,CVR<=4),Hgt+0.03125,IF(OR(BodyType=11,BodyType=12),\"\",IF(AND(BodyType=13,CVR<=4),Hgt+0.03125,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=9),\"\",IF(OR(BodyType=11,BodyType=12),\"\",IF(AND(BodyType=10,CVR=1),\"1694\",IF(AND(BodyType=10,CVR=2),\"1695\",IF(AND(BodyType=10,CVR=3),\"1692\",IF(AND(BodyType=10,CVR=4),\"1693\",IF(AND(BodyType=13,CVR=1),\"1694\",IF(AND(BodyType=13,CVR=2),\"1695\",IF(AND(BodyType=13,CVR=3),\"1692\",IF(AND(BodyType=13,CVR=4),\"1693\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=9),\"\",IF(AND(BodyType=10,CVR=1),\" Slide Cover - Mitered both ends - Sides/Ends\",IF(AND(BodyType=10,CVR=2),\" Radius Slide Cover - Mitered both ends - Sides/Ends\",IF(AND(BodyType=10,CVR=3),\" Bleed Cover - Mitered both ends - Sides/Ends\",IF(AND(BodyType=10,CVR=4),\" Frameless Cover - Mitered both ends - Sides/Ends\",IF(OR(BodyType=11,BodyType=12),\"\",IF(AND(BodyType=13,CVR=1),\" Slide Cover - Mitered both ends - Sides/Ends\",IF(AND(BodyType=13,CVR=2),\" Radius Slide Cover - Mitered both ends - Sides/Ends\",IF(AND(BodyType=13,CVR=3),\" Bleed Cover - Mitered both ends - Sides/Ends\",IF(AND(BodyType=13,CVR=4),\" Frameless Cover - Mitered both ends - Sides/Ends\",\"\"))))))))))))","v":""}]
[]
[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,"Divider"]
[]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(Hdiv=FALSE,\"\",IF(AND(BodyType<=9,Divdr=2),\" Select Single Face Access Body or Access Body\",IF(AND(CVR>=3,Divdr=2),\" Select Slide Cover or Radius Slide Cover\",IF(AND(Divdr=2,Hdiv=TRUE),\"Number of Horizontal Dividers\",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Horizontal Divider",null," Select Single Face Access Body"]
[]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(Vdiv=FALSE,\"\",IF(AND(BodyType<=9,Divdr=2),\" Select Single Face Access Body or Access Body\",IF(AND(CVR>=3,Divdr=2),\" Select Slide Cover or Radius Slide Cover\",IF(AND(Divdr=2,Vdiv=TRUE),\"Number of Vertical Dividers\",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Vertical Divider",null," Select Slide Cover or Radius Slide Cover"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,Hdiv=FALSE),\"\",IF(AND(BodyType<=9,OR(BodyType=11,BodyType=12,Divdr=2)),\"\",IF(AND(CVR>=3,Divdr=2),\"\",IF(AND(BodyType=10,Divdr=2,OR(CVR=1,CVR=2)),HDQTY*1*KQ,IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),HDQTY*1*KQ,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,Hdiv=FALSE),\"\",IF(AND(BodyType<=9,OR(BodyType=11,BodyType=12,Divdr=2)),\"\",IF(AND(CVR>=3,Divdr=2),\"\",IF(AND(BodyType=10,Divdr=2,OR(CVR=1,CVR=2)),Wdt-2.86,IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),Wdt-2.86,\"\")))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,Hdiv=FALSE),\"\",IF(AND(BodyType<=9,OR(BodyType=11,BodyType=12,Divdr=2)),\"\",IF(AND(CVR>=3,Divdr=2),\"\",IF(AND(BodyType=10,Divdr=2,OR(CVR=1,CVR=2)),\"1662\",IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),\"1662\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,Hdiv=FALSE),\"\",IF(AND(BodyType<=9,Divdr=2),\" Select Single Face Access Body\",IF(AND(BodyType=11,Divdr=2),\" Select Single Face Access Body\",IF(AND(BodyType=12,Divdr=2),\" Select Single Face Access Body\",IF(AND(CVR>=3,Divdr=2),\" Select Slide Cover or Radius Slide Cover\",IF(AND(BodyType=10,Divdr=2,OR(CVR=1,CVR=2)),\" 1-1/4'' Divider - Straight cut both ends - Horizontal\",IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),\" 1-1/4'' Divider - Straight cut both ends - Horizontal\",\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,Vdiv=FALSE),\"\",IF(AND(BodyType<=9,OR(BodyType=11,BodyType=12,Divdr=2)),\"\",IF(AND(CVR>=3,Divdr=2),\"\",IF(AND(BodyType=10,Divdr=2,OR(CVR=1,CVR=2)),VDQTY*1*KQ,IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),VDQTY*1*KQ,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,Vdiv=FALSE),\"\",IF(AND(BodyType<=9,OR(BodyType=11,BodyType=12,Divdr=2)),\"\",IF(AND(CVR>=3,Divdr=2),\"\",IF(AND(BodyType=10,Divdr=2,OR(CVR=1,CVR=2)),Hgt-2.86,IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),Hgt-2.86,\"\")))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,Vdiv=FALSE),\"\",IF(AND(BodyType<=9,OR(BodyType=11,BodyType=12,Divdr=2)),\"\",IF(AND(CVR>=3,Divdr=2),\"\",IF(AND(BodyType=10,Divdr=2,OR(CVR=1,CVR=2)),\"1662\",IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),\"1662\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,Vdiv=FALSE),\"\",IF(AND(BodyType<=9,Divdr=2),\" Select Single Face Access Body\",IF(AND(BodyType=11,Divdr=2),\" Select Single Face Access Body\",IF(AND(BodyType=12,Divdr=2),\" Select Single Face Access Body\",IF(AND(CVR>=3,Divdr=2),\" Select Slide Cover or Radius Slide Cover\",IF(AND(BodyType=10,Divdr=2,OR(CVR=1,CVR=2)),\" 1-1/4'' Divider - Straight cut both ends - Vertical\",IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),\" 1-1/4'' Divider - Straight cut both ends - Vertical\",\"\")))))))))","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,"Radius Ends",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reveal Size: ",null,null,0,null,null,null,null,null,null,null,null,1,"Radius Ends",null," Select Series 7, 3 1/2'' Half Slide Body or Series 3, 1-5/8'', 1/4 Round End"]
[null,null,null,null,null,null,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,"Radius Type",null," Select Series 3, 1-5/8'' Half Side Body or Series 7, 3-1/2'', 1/4 Round End"]
[]
[null,"Qty.","Size (in)",null,"x","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,1,"Radius Position"]
[null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(BodyType<=10,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos>=1)),2*KQ,IF(AND(AND(BodyType=12,RadTyp=2,RadPos>=1)),2*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(BodyType<=10,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=1)),Hgt-0.25,IF(AND(AND(BodyType=11,RadTyp=1,RadPos=2)),Wdt-0.25,IF(AND(AND(BodyType=11,RadTyp=1,RadPos=3)),(Hgt+3.75)+(RvlHgt*2),IF(AND(AND(BodyType=12,RadTyp=2,RadPos=1)),Hgt-0.25,IF(AND(AND(BodyType=12,RadTyp=2,RadPos=2)),Wdt-0.25,IF(AND(AND(BodyType=12,RadTyp=2,RadPos=3)),(Hgt+7)+(RvlHgt*2),\"\")))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(BodyType<=10,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos>=1)),\"1215\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos>=1)),\"1670\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(BodyType<=10,\"\",IF(AND(BodyType=11,RadTyp=2),\" Select Series 7, 3 1/2'' Half Slide Body or Series 3, 1-5/8'', 1/4 Round End\",IF(AND(BodyType=12,RadTyp=1),\" Select Series 3, 1-5/8'' Half Side Body or Series 7, 3-1/2'', 1/4 Round End\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=1)),\" Series 3, 1-5/8'', 1/4 Round End - Straight cut both ends - Sides/Ends\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=2)),\" Series 3, 1-5/8'', 1/4 Round End - Straight cut both ends - Top and Bottom\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=3)),\" Series 3, 1-5/8'', 1/4 Round End - Mitered both ends - Sides/Ends\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos=1)),\" Series 7, 3-1/2'', 1/4 Round End - Straight cut both ends - Sides/Ends\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos=2)),\" Series 7, 3-1/2'', 1/4 Round End - Straight cut both ends - Sides/Ends\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos=3)),\" Series 7, 3-1/2'', 1/4 Round End - Mitered both ends - Sides/Ends\",\"\")))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(BodyType<=10,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=3)),2*KQ,IF(AND(AND(BodyType=12,RadTyp=2,RadPos=3)),2*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(BodyType<=10,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=1)),\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=2)),\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=3)),(Wdt+3.75)+(RvlHgt*2),IF(AND(AND(BodyType=12,RadTyp=2,RadPos=1)),\"\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos=2)),\"\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos=3)),(Wdt+7)+(RvlHgt*2),\"\")))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(BodyType<=10,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=3)),\"1215\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos=3)),\"1670\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(BodyType<=10,\"\",IF(AND(BodyType=11,RadTyp=2),\" Select Series 7, 3 1/2'' Half Slide Body or Series 3, 1-5/8'', 1/4 Round End\",IF(AND(BodyType=12,RadTyp=1),\" Select Series 3, 1-5/8'' Half Side Body or Series 7, 3-1/2'', 1/4 Round End\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=1)),\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=2)),\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos=3)),\" Series 3, 1-5/8'', 1/4 Round End - Mitered both ends - Top and Bottom\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos=1)),\"\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos=2)),\"\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos=3)),\" Series 7, 3-1/2'', 1/4 Round End - Mitered both ends - Top and Bottom\",\"\")))))))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Lengths Required","Lengths Used","Drops Used"]
[null,"Customer",null,null,null,{"$f":"IF(Cust=0,\"\",Cust)","v":""},null,null,null,null,null,null,null,null,"Order #",null,null,null,{"$f":"IF(Ordnum=0,\"\",Ordnum)","v":""}]
[]
[null,"Kit Quantity",null,null,null,{"$f":"IF(KQ=0,\"\",KQ)","v":""},null,"Cab./Panel Height",null,null,null,{"$f":"IF(Hgt=0,\"\",Hgt)","v":""},null,"Cab.Panel Width",null,null,null,{"$f":"IF(Wdt=0,\"\",Wdt)","v":""}]
[]
[]
[]
[null,"Hardware"]
[]
[null,"Body"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,4*KQ,IF(BodyType=2,4*KQ,IF(BodyType=3,4*KQ,IF(BodyType=4,\"\",IF(BodyType=5,4*KQ,IF(BodyType=6,4*KQ,IF(BodyType=7,4*KQ,IF(BodyType=8,\"\",IF(BodyType=9,4*KQ,IF(BodyType=10,4*KQ,IF(BodyType=11,\"\",IF(BodyType=12,\"\",IF(BodyType=13,4*KQ,\"\")))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"5330\",IF(BodyType=2,\"5331\",IF(BodyType=3,\"5331\",IF(BodyType=4,\"\",IF(BodyType=5,\"5335\",IF(BodyType=6,\"5337\",IF(BodyType=7,\"5337\",IF(BodyType=8,\"\",IF(BodyType=9,\"5341\",IF(BodyType=10,\"5338\",IF(BodyType=11,\"\",IF(BodyType=12,\"\",IF(BodyType=13,\"5340\",\"\")))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 2 Slide Body Corner Angle - 1'' x 1'' x 1/8'' (1-1/8'') - One (1) per corner\",IF(BodyType=2,\" Series 2 Bleed Body Corner Angle - 1'' x 1'' x 1/8'' (1-1/2'') - One (1) per corner\",IF(BodyType=3,\" Series 2 Frameless Body Corner Angle - 1'' x 1'' x 1/8'' (1-1/2'') - One per corner\",IF(BodyType=4,\"\",IF(BodyType=5,\" Series Slide Body Corner Angle - 1'' x 1'' x 1/8'' (2-1/4'') - One per corner\",IF(BodyType=6,\" Series 3 Bleed Body Corner Angle - 1'' x 1'' x 1/8'' (2-11/16'') - One (1) per corner\",IF(BodyType=7,\" Series 3 Frameless Body Corner Angle - 1'' x 1'' x 2-11/16'' - One (1) per corner\",IF(BodyType=8,\"\",IF(BodyType=9,\" Series 4 Frameless Body Corner Angle - 1'' x 1'' x 1/8'' (3-9/16'') - Oner (1) per corner\",IF(BodyType=10,\" Series 3 Single Face Access Body Corner Angle - 2'' x 2'' x 1/8'' (1-1/2'') - One (1) per corner\",IF(BodyType=11,\"\",IF(BodyType=12,\"\",IF(BodyType=13,\" Series 4, 4'' Single Face Access Body Corner Angle - 2'' x 2'' x 1/8'' (2'') - One (1) per corner\",\"\")))))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"\",IF(BodyType=2,\"\",IF(BodyType=3,\"\",IF(BodyType=4,\"\",IF(BodyType=5,\"\",IF(BodyType=6,\"\",IF(BodyType=7,\"\",IF(BodyType=8,8*KQ,IF(BodyType=9,\"\",IF(BodyType=10,\"\",IF(BodyType=11,4*KQ,IF(BodyType=12,4*KQ,IF(BodyType=13,\"\",\"\")))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"\",IF(BodyType=2,\"\",IF(BodyType=3,\"\",IF(BodyType=4,\"\",IF(BodyType=5,\"\",IF(BodyType=6,\"\",IF(BodyType=7,\"\",IF(BodyType=8,\"5210\",IF(BodyType=9,\"\",IF(BodyType=10,\"\",IF(BodyType=11,\"5210\",IF(BodyType=12,\"5210\",IF(BodyType=13,\"\",\"\")))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"\",IF(BodyType=2,\"\",IF(BodyType=3,\"\",IF(BodyType=4,\"\",IF(BodyType=5,\"\",IF(BodyType=6,\"\",IF(BodyType=7,\"\",IF(BodyType=8,\" Series 3, 1/4 Round Body Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(BodyType=9,\"\",IF(BodyType=10,\"\",IF(BodyType=11,\" Series 3, 1-5/8'', 1/2 Slide Body Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(BodyType=12,\" Series 7, 3-1/2'' 1/2 Slide Body Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(BodyType=13,\"\",\"\")))))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,10*KQ,IF(BodyType=2,\"\",IF(BodyType=3,\"\",IF(BodyType=4,10*KQ,IF(BodyType=5,10*KQ,IF(BodyType=6,\"\",IF(BodyType=7,\"\",IF(BodyType=8,\"\",IF(BodyType=9,\"\",IF(BodyType=10,10*KQ,IF(BodyType=11,6*KQ,IF(BodyType=12,10*KQ,IF(BodyType=13,10*KQ,\"\")))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"5240\"&PTD,IF(BodyType=2,\"\",IF(BodyType=3,\"\",IF(BodyType=4,\"5270\",IF(BodyType=5,\"5240\"&PTD,IF(BodyType=6,\"\",IF(BodyType=7,\"\",IF(BodyType=8,\"\",IF(BodyType=9,\"\",IF(BodyType=10,\"5270\",IF(BodyType=11,\"5241\",IF(BodyType=12,\"5241\",IF(BodyType=13,\"5270\",\"\")))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Slide Body Corner Screw - 10-24 x 3/4'' S.S. Sq/Phillips countersink thread cutting screw - Two (2) per corner\",IF(BodyType=2,\"\",IF(BodyType=3,\"\",IF(BodyType=4,\" Beveled Frame Corner Screw - #8 x 1-1/2'' S.S. Sq/Phillips countersink screw - Two (2) per corner\",IF(BodyType=5,\" Slide Body Corner Screw - 10-24 x 3/4'' S.S. Sq/Phillips countersink thread cutting screw - Two (2) per corner\",IF(BodyType=6,\"\",IF(BodyType=7,\"\",IF(BodyType=8,\"\",IF(BodyType=9,\"\",IF(BodyType=10,\" Single Face Access Body Corner Screw - #8 x 1-1/2'' S.S. Sq/Phillips countersink screw - Two (2) per corner\",IF(BodyType=11,\" 1/2 Slide Body Corner Screw - #8 x 3/4'' S.S. Sq/Phillips countersink screw - One (1) per corner\",IF(BodyType=12,\" 1/2 Slide Body Corner Screw - #8 x 3/4'' S.S. Sq/Phillips countersink screw - Two (2) per corner\",IF(BodyType=13,\" Single Face Access Body Corner Screw - #8 x 1-1/2'' S.S. Sq/Phillips countersink screw - Two (2) per corner\",\"\")))))))))))))))","v":""}]
[]
[null,"Cover"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType<=9,\"\",IF(BodyType=11,\"\",IF(BodyType=12,\"\",IF(AND(BodyType=10,OR(CVR=1,CVR=3,CVR=4)),4*KQ,IF(AND(BodyType=10,CVR=2),4*KQ,IF(AND(BodyType=13,OR(CVR=1,CVR=3,CVR=4)),4*KQ,IF(AND(BodyType=13,CVR=2),4*KQ,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType<=9,\"\",IF(BodyType=11,\"\",IF(BodyType=12,\"\",IF(AND(BodyType=10,OR(CVR=1,CVR=3,CVR=4)),\"5210\",IF(AND(BodyType=10,CVR=2),\"5226\",IF(AND(BodyType=13,OR(CVR=1,CVR=3,CVR=4)),\"5210\",IF(AND(BodyType=13,CVR=2),\"5226\",\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType<=9,\"\",IF(BodyType=11,\"\",IF(BodyType=12,\"\",IF(AND(BodyType=10,CVR=1),\" Slide Cover Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=10,CVR=2),\" Radius Slide Cover 3/4'' Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=10,CVR=3),\" Bleed Cover Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=10,CVR=4),\" Frameless Cover Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=13,CVR=1),\" Slide Cover Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=13,CVR=2),\" Radius Slide Cover 3/4'' Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=13,CVR=3),\" Bleed Cover Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=13,CVR=4),\" Frameless Cover Corner Key - .120 Stamped Aluminum - One (1) per corner\",\"\")))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType<=9,\"\",IF(BodyType=11,\"\",IF(BodyType=12,\"\",IF(AND(BodyType=10,CVR>=1),CCVRScrws*KQ,IF(AND(BodyType=13,CVR>=1),CCVRScrws*KQ,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType<=9,\"\",IF(BodyType=11,\"\",IF(BodyType=12,\"\",IF(AND(BodyType=10,CVR>=1),\"5168\",IF(AND(BodyType=13,CVR>=1),\"5168\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType<=9,\"\",IF(BodyType=11,\"\",IF(BodyType=12,\"\",IF(AND(BodyType=10,CVR>=1),\" Single Face Access Body Cover Screw - #8 x 1/2'' S.S. Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(BodyType=13,CVR>=1),\" Single Face Access Body Cover Screw - #8 x 1/2'' S.S. Sq/Phillips countersink screw - 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":"ROUNDUP(Hgt/12,0)+1","v":1},{"$f":"ROUNDUP(Wdt/12,0)+1","v":1},{"$f":"ROUNDUP(Hgt/12,0)+1","v":1},{"$f":"ROUNDUP(Wdt/12,0)+1","v":1},{"$f":"IF(KQ=0,\"\",IF(BodyType<=9,\"\",IF(BodyType=11,\"\",IF(BodyType=12,\"\",IF(BodyType=10,SUM(AE96:AH96)+2,IF(BodyType=13,SUM(AE96:AH96)+2))))))","v":""},"Cover Screws"]
[]
[null,"Divider"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(BodyType<=9,\"\",IF(CVR>=3,\"\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=10)),HDQTY*2*KQ,IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=13)),HDQTY*4*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(BodyType<=9,\"\",IF(CVR>=3,\"\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=10)),\"5308\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=13)),\"5308\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(BodyType<=9,Hdiv=TRUE),\" Select Single Face Access Body or Access Body\",IF(AND(CVR>=3,Hdiv=TRUE),\" Select Slide Cover or Radius Slide Cover\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=10)),\" 1-1/4'' Divider Tab - 1'' 2-1/4'' x .125'' - Two (2) per Divider ( One (1) each end of Divider)\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=13)),\" 1-1/4'' Divider Tab - 1'' 2-1/4'' x .125'' - Two (2) per Divider ( One (1) each end of Divider)\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(BodyType<=9,\"\",IF(CVR>=3,\"\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=10)),((HDQTY*2)+2)*KQ,IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=13)),((HDQTY*4)+2)*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(BodyType<=9,\"\",IF(CVR>=3,\"\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=10)),\"5168\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=13)),\"5168\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(BodyType<=9,\"\",IF(CVR>=3,\"\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=10)),\" 1-1/4'' Divider Tab - #8 x 1/2'' S.S. Sq/Phillips countersink screw - Two (2) per Divider ( One (1) each end of Divider)\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=13)),\" 1-1/4'' Divider Tab - #8 x 1/2'' S.S. Sq/Phillips countersink screw - Two (2) per Divider ( One (1) each end 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,null," "]
[null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(BodyType<=9,\"\",IF(CVR>=3,\"\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=10)),VDQTY*2*KQ,IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=13)),VDQTY*4*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(BodyType<=9,\"\",IF(CVR>=3,\"\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=10)),\"5308\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=13)),\"5308\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(BodyType<=9,Vdiv=TRUE),\" Select Single Face Access Body or Access Body\",IF(AND(CVR>=3,Vdiv=TRUE),\" Select Slide Cover or Radius Slide Cover\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=10)),\" 1-1/4'' Divider Tab - 1'' 2-1/4'' x .125'' - Two (2) per Divider ( One (1) each end of Divider)\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=13)),\" 1-1/4'' Divider Tab - 1'' 2-1/4'' x .125'' - Two (2) per Divider ( One (1) each end of Divider)\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(BodyType<=9,\"\",IF(CVR>=3,\"\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=10)),((VDQTY*2)+2)*KQ,IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=13)),((VDQTY*4)+2)*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(BodyType<=9,\"\",IF(CVR>=3,\"\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=10)),\"5168\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=13)),\"5168\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(BodyType<=9,\"\",IF(CVR>=3,\"\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=10)),\" 1-1/4'' Divider Tab - #8 x 1/2'' S.S. Sq/Phillips countersink screw - Two (2) per Divider ( One (1) each end of Divider)\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=13)),\" 1-1/4'' Divider Tab - #8 x 1/2'' S.S. Sq/Phillips countersink screw - Two (2) per Divider ( One (1) each end of Divider)\",\"\"))))))","v":""}]
[]
[null,"Radius Ends"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos<=2)),2*KQ,IF(AND(AND(BodyType=12,RadTyp=2,RadPos<=2)),4*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos<=2)),\"5003L\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos<=2)),\"5028\",\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(BodyType=11,RadTyp=1),4*KQ,IF(AND(BodyType=12,RadTyp=2),4*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos<=2)),\" Series 3, 1/4 Round End Cap (Left) - One (1) cap each end\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos<=2)),\" Series 7, 3-1/2'' Radius End Cap - One (1) cap each end\",\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(BodyType=11,RadTyp=1),4*KQ,IF(AND(BodyType=12,RadTyp=2),4*KQ,\"\"))))","v":""},"","","","","","","","","",{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(BodyType=11,RadTyp=1),4*KQ,IF(AND(BodyType=12,RadTyp=2),4*KQ,\"\"))))","v":""},"","","","","","","","","",""]
[null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos<=2)),2*KQ,IF(AND(BodyType=12,RadTyp=2),\"\",\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos<=2)),\"5003R\",IF(AND(BodyType=12,RadTyp=2),\"\",\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(BodyType=11,RadTyp=1),4*KQ,IF(AND(BodyType=12,RadTyp=2),4*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos<=2)),\" Series 3, 1/4 Round End Cap (Right) - One (1) cap each end\",IF(AND(BodyType=12,RadTyp=2),\"\",\"\"))))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos<=2)),8*KQ,IF(AND(AND(BodyType=12,RadTyp=2,RadPos<=2)),8*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos<=2)),\"5168\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos<=2)),\"5168\",\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(BodyType=11,RadTyp=1),4*KQ,IF(AND(BodyType=12,RadTyp=2),4*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(AND(BodyType=11,RadTyp=1,RadPos<=2)),\" Series 3, 1/2 Round End Cap Screw - #8 x 1/2'' Sq/Phillips Countersink Screw - Two (2) per cap\",IF(AND(AND(BodyType=12,RadTyp=2,RadPos<=2)),\" Series 7, 1/2 Round End Cap Screw - #8 x 1/2'' Sq/Phillips Countersink Screw - Two (2) per cap\",\"\"))))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(RadTyp=2,\"\",IF(AND(RadTyp=1,RadPos=1),KQ*AE112,IF(AND(RadTyp=1,RadPos=2),KQ*AF112,IF(AND(RadTyp=1,RadPos=3),KQ*AE112+AF112))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(RadTyp=2,\"\",IF(AND(RadTyp=1,RadPos=1),\"5218\",IF(AND(RadTyp=1,RadPos=2),\"5218\",IF(AND(RadTyp=1,RadPos=3),\"5218\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(RadTyp=2,\"\",IF(AND(RadTyp=1,RadPos=1),\" Radius Attchment Screw - #10 x 1/2'' Sq/Phillips Pan Head Screw - One approx 12'' OC\",IF(AND(RadTyp=1,RadPos=2),\" Radius Attchment Screw - #10 x 1/2'' Sq/Phillips Pan Head Screw - One approx 12'' OC\",IF(AND(RadTyp=1,RadPos=3),\" Radius Attchment Screw - #10 x 1/2'' Sq/Phillips Pan Head Screw - One approx 12'' OC\"))))))","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/12+1),0)*2","v":2},{"$f":"ROUNDUP((Wdt/12+1),0)*2","v":2}]
[]
[null,"Face Trim Size"]
[]
[null,"Face - (Not Included in kit)"]
[]
[null,"Face Trim Size"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(Divdr=2,\"\",IF(BodyType=1,Hgt-0.375,IF(BodyType=2,Hgt-0.2,IF(BodyType=3,Hgt,IF(BodyType=4,Hgt-1.0625,IF(BodyType=5,Hgt-0.375,IF(BodyType=6,Hgt-0.25,IF(BodyType=7,Hgt,IF(BodyType=8,Hgt-1,IF(BodyType=9,Hgt,IF(AND(BodyType=10,CVR=1),Hgt-0.375,IF(AND(BodyType=10,CVR=2),Hgt-0.375,IF(AND(BodyType=10,CVR=3),Hgt-0.25,IF(AND(BodyType=10,CVR=4),Hgt,IF(BodyType=11,Hgt-0.375,IF(BodyType=12,Hgt-0.375,IF(AND(BodyType=13,CVR=1),Hgt-0.375,IF(AND(BodyType=13,CVR=2),Hgt-0.375,IF(AND(BodyType=13,CVR=3),Hgt-0.25,IF(AND(BodyType=13,CVR=4),Hgt,\"\")))))))))))))))))))))","v":""},null,"Height",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Divdr=2,\"\",IF(BodyType=1,Wdt-0.375,IF(BodyType=2,Wdt-0.2,IF(BodyType=3,Wdt,IF(BodyType=4,Wdt-1.0625,IF(BodyType=5,Wdt-0.375,IF(BodyType=6,Wdt-0.25,IF(BodyType=7,Wdt,IF(BodyType=8,Wdt-1,IF(BodyType=9,Wdt,IF(AND(BodyType=10,CVR=1),Wdt-0.375,IF(AND(BodyType=10,CVR=2),Wdt-0.375,IF(AND(BodyType=10,CVR=3),Wdt-0.25,IF(AND(BodyType=10,CVR=4),Wdt,IF(BodyType=11,Wdt-0.375,IF(BodyType=12,Wdt-0.375,IF(AND(BodyType=13,CVR=1),Wdt-0.375,IF(AND(BodyType=13,CVR=2),Wdt-0.375,IF(AND(BodyType=13,CVR=3),Wdt-0.25,IF(AND(BodyType=13,CVR=4),Wdt,\"\")))))))))))))))))))))","v":""},null,"Width"]
[]
[null,null,null,"Material Thickness:",null,null,null,{"$f":"IF(KQ=0,\"\",IF(Divdr=2,\"\",IF(BodyType=1,\" .100 - .125 Flat Aluminum,3mm ACM (Solid Core) or Acrylic Sheet\",IF(BodyType=2,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(BodyType=3,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(BodyType=4,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(BodyType=5,\" .100 - .125 Flat Aluminum, 3mm ACM (Solid Core) or Acrylic Sheet\",IF(BodyType=6,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(BodyType=7,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(BodyType=8,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(BodyType=9,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(AND(BodyType=10,CVR=1),\" .1875  Flat Acrylic Sheet or 4mm ACM (Solid Core)\",IF(AND(BodyType=10,CVR=2),\" .1875 Acrylic Sheet or 4mm ACM (Solid Core)\",IF(AND(BodyType=10,CVR=3),\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(AND(BodyType=10,CVR=4),\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(BodyType=11,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(BodyType=12,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",\"\")))))))))))))))))","v":""}]