{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Series 2-3-4 Post and Panels"],"not_rendered":{"charts":0,"images":1,"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":"Series 2-3-4 Post and Panels","index":0,"n_rows":128,"n_cols":46,"rows_kept":128,"cut":false,"hidden":false,"merged":[[53,2,53,3],[16,1,16,8],[16,9,16,12],[16,13,16,28],[88,1,88,28],[48,33,48,37],[50,33,50,36],[53,5,53,6],[54,5,54,6],[53,7,53,25],[54,7,54,25],[48,1,48,8],[50,1,50,8],[48,11,48,20],[48,21,48,28],[50,11,50,20],[50,21,50,28],[48,31,48,32],[50,31,50,32],[56,34,56,35],[31,1,31,28],[41,1,41,28],[43,2,43,3],[44,2,44,3],[37,7,37,25],[38,7,38,25],[34,1,34,28],[33,1,33,28],[32,1,32,28],[36,2,36,3],[36,5,36,6],[36,7,36,28],[52,5,52,6],[52,7,52,28],[43,5,43,6],[52,2,52,3],[60,16,60,17],[62,16,62,17],[64,16,64,17],[60,18,60,21],[62,18,62,21],[64,18,64,21],[66,2,66,3],[66,5,66,6],[61,1,61,28],[7,28,13,28],[10,19,10,22],[12,1,12,17],[12,18,12,22],[45,1,45,28],[46,1,46,28],[47,1,47,28],[49,1,49,28],[51,1,51,28],[48,9,48,10],[50,9,50,10],[26,7,26,25],[27,2,27,3],[21,1,21,28],[22,1,22,28],[18,1,18,28],[19,1,19,28],[24,1,24,28],[23,21,23,22],[23,23,23,28],[23,1,23,20],[27,5,27,6],[27,7,27,25],[26,5,26,6],[26,2,26,3],[1,1,1,28],[25,5,25,6],[25,7,25,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],[20,1,20,28],[25,2,25,3],[10,5,10,6],[10,11,10,12],[2,1,2,28],[4,1,4,28],[6,1,6,28],[9,1,9,25],[7,1,7,25],[7,26,13,26],[28,5,28,6],[28,7,28,25],[56,31,56,32],[67,2,67,3],[67,5,67,6],[67,7,67,25],[29,1,29,28],[60,9,60,10],[62,9,62,10],[58,9,58,10],[64,9,64,10],[58,11,58,14],[60,11,60,14],[62,11,62,14],[38,2,38,3],[37,5,37,6],[38,5,38,6],[56,1,56,28],[57,1,57,28],[54,2,54,3],[44,5,44,6],[43,7,43,25],[44,7,44,25],[64,11,64,14],[12,31,12,32],[116,1,116,28],[55,1,55,28],[119,1,119,28],[117,1,117,28],[118,1,118,28],[87,1,87,28],[89,1,89,28],[73,1,73,28],[74,1,74,28],[75,1,75,28],[17,1,17,28],[93,1,93,28],[92,2,92,3],[78,1,78,28],[80,1,80,4],[80,5,80,13],[80,14,80,17],[7,27,13,27],[69,5,69,6],[70,5,70,6],[32,31,32,32],[35,1,35,28],[37,2,37,3],[127,12,127,14],[125,1,125,5],[127,3,127,4],[127,5,127,7],[127,10,127,11],[66,7,66,28],[68,2,68,3],[69,2,69,3],[70,2,70,3],[68,5,68,6],[68,7,68,25],[69,7,69,25],[70,7,70,25],[123,3,123,4],[123,5,123,7],[123,10,123,11],[123,12,123,14],[79,1,79,25],[81,1,81,25],[83,1,83,25],[85,1,85,25],[79,26,85,26],[79,27,85,27],[80,18,80,24],[10,23,10,24],[12,23,12,24],[8,18,8,24],[13,1,13,25],[10,7,10,10],[11,1,11,25],[58,16,58,17],[76,1,76,28],[77,1,77,28],[63,1,63,28],[59,1,59,28],[30,8,30,11],[30,12,30,13],[30,14,30,28],[30,1,30,7],[65,1,65,28],[58,18,58,21],[58,1,58,5],[40,1,40,28],[39,1,39,28],[42,2,42,3],[42,5,42,6],[42,7,42,28],[28,2,28,3],[84,18,84,22],[84,1,84,17],[84,23,84,24],[91,2,91,3],[91,4,91,25],[92,4,92,25],[86,1,86,28],[88,32,88,34],[82,1,82,4],[82,5,82,6],[82,7,82,10],[82,11,82,12],[82,13,82,16],[82,17,82,18],[82,19,82,22],[82,23,82,24],[79,28,85,28],[95,1,95,28],[90,2,90,3],[90,4,90,28],[96,2,96,3],[97,2,97,3],[96,4,96,28],[97,4,97,25],[97,35,97,37],[98,1,98,28],[91,30,91,34],[92,30,92,34],[92,35,92,38],[91,35,91,38],[94,1,94,28],[106,4,106,25],[107,2,107,3],[107,4,107,25],[102,28,107,28],[107,35,107,36],[108,1,108,28],[109,1,109,28],[99,1,99,28],[100,1,100,28],[101,2,101,3],[101,4,101,28],[102,2,102,3],[102,4,102,25],[103,2,103,3],[103,4,103,25],[105,2,105,3],[105,4,105,25],[104,31,104,32],[60,35,60,36],[5,45,5,47],[90,30,90,31],[104,2,104,3],[104,4,104,25],[121,1,121,11],[5,30,5,33],[5,34,5,36],[5,37,5,38],[5,39,5,42],[5,43,5,44],[110,1,110,28],[111,2,111,3],[111,4,111,28],[112,2,112,3],[115,2,115,3],[115,4,115,25],[112,4,112,25],[112,28,115,28],[113,2,113,3],[113,4,113,25],[114,2,114,3],[114,4,114,25],[106,2,106,3]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"AE6&AI6&AL6&AM9&AN6&AR6&AT6","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST=1,\" Series 2, 2'' Square Post\",IF(PST=2,\" Series 3, 3-1/4'' Square Post\",IF(PST=3,\" Series 3, 3-1/4'' Round Post\",IF(PST=4,\" Series 3, 3-1/4'' Rectangular Post\",IF(PST=5,\" Series 3, 3-1/4'' Radius Post\",IF(PST=6,\" Series 3, 3-1/4'' Triangular Post\",IF(PST=7,\" Series 3, 3-1/4'' Square Post w/Radius Edges\",IF(PST=8,\" Series 3, 3-1/4'' Rectangular Post w/Radius Edges\",IF(PST=9,\" Series 3, 3-1/4'' Triangular Post w/Radius Edges\",IF(PST=10,\" Series 4, 4'' Round Post\",\"\"))))))))))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(MNT=1,\" - Single Post Flag Mounted\",IF(MNT=2,\" - Double Post Mounted\",\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(BOD=1,\"\",IF(RVLSET=1,\" - Zero Reveal\",IF(RVLSET=2,\" - 3/8'' Reveal\",IF(RVLSET=3,\" - 3/4'' Reveal\",\"\"))))))","v":""},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, Access Body\",\"\")))))))))))))","v":""},null,null,null,{"$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\",IF(AND(BodyType=11,CVR=1),\"-Slide Cover\",IF(AND(BodyType=11,CVR=2),\"-Radius Slide Cover\",IF(AND(BodyType=11,CVR=3),\"-Bleed Cover\",IF(AND(BodyType=11,CVR=4),\"-Frameless Cover\",\"\")))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel1=FALSE,\"\",IF(AND(AND(MNT=1,PANADTYP=1,PANAD=2)),\" and 1/8'' Panel Adaptor\",IF(AND(AND(MNT=1,PANADTYP=2,PANAD=2)),\" and 1/4'' Panel Adaptor\",IF(AND(AND(MNT=1,PANADTYP=3,PANAD=2)),\" and 1/2'' Panel Adaptor\",IF(AND(AND(MNT=2,PANADTYP=1,PANAD=2)),\" and 1/8'' Panel Adaptor\",IF(AND(AND(MNT=2,PANADTYP=2,PANAD=2)),\" and 1/4'' Panel Adaptor\",IF(AND(AND(MNT=2,PANADTYP=3,PANAD=2)),\" and 1/2'' Panel Adaptor\",\"\")))))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lengths Required","Lengths Used","Drops Used"]
[null,"Customer  ",null,null,null,null,null,null,null,null,null,null,null,null,"Order#   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PANAD=2,BOD=2),\" - with \",IF(BOD=1,\"\",IF(POST=1,\" - with \",\"\")))))","v":""},null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PANAD=1,BOD=2),\" - and \",IF(BOD=1,\"\",IF(PANAD=2,\" - and \",\"\")))))","v":""}]
[]
[null,"Kit Quantity  ",null,null,null,0,null,"Cab./Panel Height ",null,null,null,{"$f":"IF(KQ=0,\"\",IF(AND(PANAD=2,BOD=1),SUM(AG59,AG61,AG63,AG65),IF(AND(BOD=2,PANAD=1),HOC,IF(AND(PANAD=2,BOD=2),(SUM(AG59,AG61,AG63,AG65))+HOC,0))))","v":""},null," Cab./Panel Width",null,null,null,0,null,"Grade to Top"]
[]
[null,"Enter Fractions as Decimals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clearance to Grade",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Hgt=0,\"0.000\",OAH-Hgt))","v":""},null,null,null,null,null,null,1,"Mill/Pre-Paint",null,{"$f":"IF(PPTD=1,\"\",IF(PPTD=2,\"P\",\"\"))","v":""}]
[]
[null,"Extrusions"]
[]
[null,"Post",null,null,null,null,null,null,null,"Reveal Position",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Posts"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Post Type"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Mount"]
[]
[null,"Post Length",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,3,"Length"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(MNT=1,1*KQ,IF(MNT=2,KQ*2,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(LNGTH=1,\"71.625\",IF(LNGTH=2,\"84.000\",IF(LNGTH=3,\"95.625\",IF(LNGTH=4,\"108.000\",IF(LNGTH=5,\"120.000\",IF(LNGTH=6,\"132.000\",IF(LNGTH=7,\"143.625\",IF(LNGTH=8,\"156.000\",IF(LNGTH=9,\"168.000\",IF(LNGTH=10,PSTLNT,\"\"))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST=1,\"1100\"&PTD,IF(AND(AND(PST=2,LNGTH=10,PSTLNT=72)),\"1233\",IF(AND(AND(AND(PST=2,LNGTH=10,PSTLNT>=73,PSTLNT<=96))),\"1233-8'\",IF(AND(AND(PST=2,LNGTH=10,PSTLNT>=97)),\"1233\",IF(AND(PST=2,LNGTH=2),\"1233-8'\",IF(AND(PST=2,LNGTH=3),\"1233-8'\",IF(PST=2,\"1233\",IF(PST=3,\"1237\",IF(PST=4,\"1220\"&PTD,IF(PST=5,\"1210\"&PTD,IF(PST=6,\"1240\",IF(PST=7,\"1235\",IF(PST=8,\"1230\",IF(PST=9,\"1250\",IF(PST=10,\"1337\",IF(PST=11,\"1333\",\"\"))))))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=1,MNT=1),\" Series 2, 2'' Square Post - Single Post Flag Mounted\",IF(AND(PST=2,MNT=1),\" Series 3, 3-1/4'' Square Post - Single Post Flag Mounted\",IF(AND(PST=3,MNT=1),\" Series 3, 3-1/4'' Round Post - Single Post Flag Mounted\",IF(AND(PST=4,MNT=1),\" Series 3, 3-1/4'' Rectangular Post - Single Post Flag Mounted\",IF(AND(PST=5,MNT=1),\" Series 3, 3-1/4'' Radius Post - Single Post Flag Mounted\",IF(AND(PST=6,MNT=1),\" Series 3, 3-1/4'' Triangular Post - Single Post Flag Mounted\",IF(AND(PST=7,MNT=1),\" Series 3, 3-1/4'' Square Post w/Radius Edges - Single Post Flag Mounted\",IF(AND(PST=8,MNT=1),\" Series 3, 3-1/4'' Rectangular Post w/Radius Edges - Single Post Flag Mounted\",IF(AND(PST=9,MNT=1),\" Series 3, 3-1/4'' Triangular Post w/Radius Edges - Single Post Flag Mounted\",IF(AND(PST=10,MNT=1),\" Series 4, 4'' Round Post - Single Post Flag Mounted\",IF(AND(PST=11,MNT=1),\" Series 4, 4'' Square Post - Single Post Flag Mounted\",IF(AND(PST=1,MNT=2),\" Series 2, 2'' Square Post - Double Post Mounted\",IF(AND(PST=2,MNT=2),\" Series 3, 3-1/4'' Square Post - Double Post Mounted\",IF(AND(PST=3,MNT=2),\" Series 3, 3-1/4'' Round Post - Single Post Mounted\",IF(AND(PST=4,MNT=2),\" Series 3, 3-1/4'' Rectangular Post - Double Post Mounted\",IF(AND(PST=5,MNT=2),\" Series 3, 3-1/4'' Radius Post - Double Post Mounted\",IF(AND(PST=6,MNT=2),\" Series 3, 3-1/4'' Triangular Post - Double Post Mounted\",IF(AND(PST=7,MNT=2),\" Series 3, 3-1/4'' Square Post w/Radius Edges - Double Post Mounted\",IF(AND(PST=8,MNT=2),\" Series 3, 3-1/4'' Rectangular Post w/Radius Edges - Double Post Mounted\",IF(AND(PST=9,MNT=2),\" Series 3, 3-1/4'' Triangular Post w/Radius Edges - Double Post Mounted\",IF(AND(PST=10,MNT=2),\" Series 4, 4'' Round Post - Double Post Mounted\",IF(AND(PST=11,MNT=2),\" Series 4, 4'' Square Post - Double Post Mounted\",\"\"))))))))))))))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(BOD=1,\"\",IF(RVLSET=4,\"\",IF(AND(MNT=1,BOD=2),1*KQ,IF(AND(MNT=2,BOD=2),KQ*2,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(BOD=1,\"\",IF(RVLSET=4,\"\",IF(PST>=1,HOC-0.125,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(BOD=1,\"\",IF(RVLSET=4,\"\",IF(PST>=1,\"1200\"&PTD,\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(POST=2,\"\",IF(RVLSET=4,\"\",IF(AND(MNT=1,PST>=1),\" Series 2/3/4 Reveal - (Body Reveal attached to one end/side, 1/8'' down from top of cabinet)\",IF(AND(MNT=2,PST>=1),\" Series 2/3/4 Reveal - (Body Reveal attached to both ends/sides, 1/8'' down from top of cabinet)\",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(MNT=1,OR(BOD=2,PANAD=2)),1*KQ,IF(AND(MNT=2,OR(BOD=2,PANAD=2)),KQ*2,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST>=1,CTG+6,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(OR(PST=3,PST=10),\"1201\",IF(PST>=1,\"1200\"&PTD,\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(OR(PST=3,PST=10),\" Series 3/4 Round Post Filler - (Below the cabint/panel round post filler)\",IF(PST>=1,\" Series 2/3/4 Post Filler - (Below the cabinet/panel post filler)\",\"\"))))","v":""}]
[]
[null,"Body",null,null,null,null,null,null,"Height of Cabinet",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"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(BOD>=1,BOD<=11),2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD>=1,BOD<=11),Wdt,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"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,\"1290\",IF(BodyType=12,\"1391\",IF(BodyType=13,\"1390\",\"\")))))))))))))))","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, Access Body - Mitered both ends - Top and Bottom\",IF(BodyType=12,\" Series 4, Single Face Access Body - Mitered both ends - Top and Bottom\",IF(BodyType=13,\" Series 4, Access Body - Mitered both ends - Top and Bottom\",\"\")))))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD>=1,BOD<=11),2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD>=1,BOD<=11),Hgt,\"\")))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"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,\"1290\",IF(BodyType=12,\"1391\",IF(BodyType=13,\"1390\",\"\")))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 2, 2'' Slide Body - Mitred both ends - Ends\",IF(BodyType=2,\" Series 2, 2'' Bleed Body - Mitered both ends - Ends\",IF(BodyType=3,\" Series 2, 2'' Frameless Body - Mitered both ends - Ends\",IF(BodyType=4,\" Series 2, 2'' Beveled Frame - Mitered Both Ends - Ends\",IF(BodyType=5,\" Series 3, 3-1/4'' Slide Body - Mitered both ends - Ends\",IF(BodyType=6,\" Series 3, 3-1/4'' Bleed Body - Mitered both ends - Ends\",IF(BodyType=7,\" Series 3, 3-1/4'' Frameless Body - Mitered both ends - Ends\",IF(BodyType=8,\" Series 3, 3-1/4'' - 1/4 Round Body - Mitered both ends - Ends\",IF(BodyType=9,\" Series 4, 4'' Frameless Body - Mitered both ends - Ends\",IF(BodyType=10,\" Series 3, Single Face Access Body - Mitered both ends - Ends\",IF(BodyType=11,\" Series 3, Access Body - Mitered both ends - Ends\",IF(BodyType=12,\" Series 4, Single Face Access Body - Mitered both ends - Ends\",IF(BodyType=13,\" Series 4, Access Body - Mitered both ends - 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(AND(BodyType=11,CVR<=4),4*KQ,IF(AND(BodyType=12,CVR<=4),2*KQ,IF(AND(BodyType=13,CVR<=4),4*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(AND(BodyType=11,CVR<=4),Wdt+0.03125,IF(AND(BodyType=12,CVR<=4),Wdt+0.03125,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(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=11,CVR=1),\"1694\",IF(AND(BodyType=11,CVR=2),\"1695\",IF(AND(BodyType=11,CVR=3),\"1692\",IF(AND(BodyType=11,CVR=4),\"1693\",IF(AND(BodyType=12,CVR=1),\"1694\",IF(AND(BodyType=12,CVR=2),\"1695\",IF(AND(BodyType=12,CVR=3),\"1692\",IF(AND(BodyType=12,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(AND(CVR=1,BodyType>=10,BodyType<=13)),\" Slide Cover - Mitered both ends - Top and Bottom\",IF(AND(AND(CVR=2,BodyType>=10,BodyType<=13)),\" Radius Slide Cover - Mitered both ends - Top and Bottom\",IF(AND(AND(CVR=3,BodyType>=10,BodyType<=13)),\" Bleed Cover - Mitered both ends - Top and Bottom\",IF(AND(AND(CVR=4,BodyType>=10,BodyType<=14)),\" 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(AND(BodyType=11,CVR<=4),4*KQ,IF(AND(BodyType>=1,BodyType<=9),\"\",IF(AND(BodyType=12,CVR<=4),2*KQ,IF(AND(BodyType=13,CVR<=4),4*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(AND(BodyType=11,CVR<=4),Hgt+0.03125,IF(AND(BodyType=12,CVR<=4),Hgt+0.03125,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(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=11,CVR=1),\"1694\",IF(AND(BodyType=11,CVR=2),\"1695\",IF(AND(BodyType=11,CVR=3),\"1692\",IF(AND(BodyType=11,CVR=4),\"1693\",IF(AND(BodyType=12,CVR=1),\"1694\",IF(AND(BodyType=12,CVR=2),\"1695\",IF(AND(BodyType=12,CVR=3),\"1692\",IF(AND(BodyType=12,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(AND(CVR=1,BodyType>=10,BodyType<=13)),\" Slide Cover - Mitered both ends - Ends\",IF(AND(AND(CVR=2,BodyType>=10,BodyType<=13)),\" Radius Slide Cover - Mitered both ends - Ends\",IF(AND(AND(CVR=3,BodyType>=10,BodyType<=13)),\" Bleed Cover - Mitered both ends - Ends\",IF(AND(AND(CVR=4,BodyType>=10,BodyType<=13)),\" Frameless Cover - Mitered both ends - 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 or 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,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=11,Divdr=2,OR(CVR=1,CVR=2)),HDQTY*2*KQ,IF(AND(BodyType=12,Divdr=2,OR(CVR=1,CVR=2)),HDQTY*1*KQ,IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),HDQTY*2*KQ,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,Hdiv=FALSE),\"\",IF(AND(BodyType<=9,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=11,Divdr=2,OR(CVR=1,CVR=2)),Wdt-2.86,IF(AND(BodyType=12,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,Divdr=2),\"\",IF(AND(CVR>=3,Divdr=2),\"\",IF(AND(BodyType=10,Divdr=2,OR(CVR=1,CVR=2)),\"1662\",IF(AND(BodyType=11,Divdr=2,OR(CVR=1,CVR=2)),\"1662\",IF(AND(BodyType=12,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 or 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\",IF(AND(BodyType=11,Divdr=2,OR(CVR=1,CVR=2)),\" 1-1/4'' Divider - Straight cut both ends\",IF(AND(BodyType=12,Divdr=2,OR(CVR=1,CVR=2)),\" 1-1/4'' Divider - Straight cut both ends\",IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),\" 1-1/4'' Divider - Straight cut both ends\",\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,Vdiv=FALSE),\"\",IF(AND(BodyType<=9,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=11,Divdr=2,OR(CVR=1,CVR=2)),VDQTY*2*KQ,IF(AND(BodyType=12,Divdr=2,OR(CVR=1,CVR=2)),VDQTY*1*KQ,IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),VDQTY*2*KQ,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,Vdiv=FALSE),\"\",IF(AND(BodyType<=9,Divdr=2),\"\",IF(AND(CVR>=3,Divdr=2),\"\",IF(AND(BodyType=10,Divdr=2,OR(CVR=1,CVR=2)),HOC-2.86,IF(AND(BodyType=11,Divdr=2,OR(CVR=1,CVR=2)),HOC-2.86,IF(AND(BodyType=12,Divdr=2,OR(CVR=1,CVR=2)),HOC-2.86,IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),HOC-2.86,\"\")))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,Vdiv=FALSE),\"\",IF(AND(BodyType<=9,Divdr=2),\"\",IF(AND(CVR>=3,Divdr=2),\"\",IF(AND(BodyType=10,Divdr=2,OR(CVR=1,CVR=2)),\"1662\",IF(AND(BodyType=11,Divdr=2,OR(CVR=1,CVR=2)),\"1662\",IF(AND(BodyType=12,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 or 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\",IF(AND(BodyType=12,Divdr=2,OR(CVR=1,CVR=2)),\" 1-1/4'' Divider - Straight cut both ends\",IF(AND(BodyType=13,Divdr=2,OR(CVR=1,CVR=2)),\" 1-1/4'' Divider - Straight cut 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,"Panel Adaptor",null,null,null,null,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,"Panel Adaptor",null,1,"Panel Adap Type"]
[]
[null,"Panel(s)",null,null,null,null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel1=FALSE,\"\",IF(Panel1=TRUE,\"Number of Panels\",\"\")))","v":""},null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel1=FALSE,\"\",IF(Panel1=TRUE,\"Height of Panels\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,false,"Panel 1",{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel1=TRUE,NOPNL1*PNLH1,\"\")))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel2=FALSE,\"\",IF(Panel2=TRUE,\"Number of Panels\",\"\")))","v":""},null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel2=FALSE,\"\",IF(Panel2=TRUE,\"Height of Panels\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,false,"Panel 2",{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel2=TRUE,NOPNL2*PNLH2,\"\")))","v":""},null,{"$f":"IF(AND(PANAD=2,MNT=1),SUM(J59,J61,J63,J65),IF(AND(PANAD=2,MNT=2),SUM(J59,J61,J63,J65)*2,\"\"))","v":""},"Num Adaptors"]
[]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel3=FALSE,\"\",IF(Panel3=TRUE,\"Number of Panels\",\"\")))","v":""},null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel3=FALSE,\"\",IF(Panel3=TRUE,\"Height of Panels\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,false,"Panel 3",{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel3=TRUE,NOPNL3*PNLH3,\"\")))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel4=FALSE,\"\",IF(Panel4=TRUE,\"Number of Panels\",\"\")))","v":""},null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Panel4=FALSE,\"\",IF(Panel4=TRUE,\"Height of Panels\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,false,"Panel 4",{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel4=TRUE,NOPNL4*PNLH4,\"\")))","v":""}]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel1=FALSE,\"\",IF(AND(MNT=1,PANAD=2),1*NOPNL1*KQ,IF(AND(MNT=2,PANAD=2),2*NOPNL1*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel1=FALSE,\"\",IF(AND(MNT=1,PANAD=2),PNLH1,IF(AND(MNT=2,PANAD=2),PNLH1,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel1=FALSE,\"\",IF(AND(AND(MNT=1,PANADTYP=1,PANAD=2)),\"1203\"&PTD,IF(AND(AND(MNT=1,PANADTYP=2,PANAD=2)),\"1202\"&PTD,IF(AND(AND(MNT=1,PANADTYP=3,PANAD=2)),\"1204\"&PTD,IF(AND(AND(MNT=2,PANADTYP=1,PANAD=2)),\"1203\"&PTD,IF(AND(AND(MNT=2,PANADTYP=2,PANAD=2)),\"1202\"&PTD,IF(AND(AND(MNT=2,PANADTYP=3,PANAD=2)),\"1204\"&PTD,\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel1=FALSE,\"\",IF(AND(AND(MNT=1,PANADTYP=1,PANAD=2)),\" Series 2/3/4, 1/8'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=1,PANADTYP=2,PANAD=2)),\" Series 2/3/4, 1/4'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=1,PANADTYP=3,PANAD=2)),\" Series 2/3/4, 1/2'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=2,PANADTYP=1,PANAD=2)),\" Series 2/3/4, 1/8'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=2,PANADTYP=2,PANAD=2)),\" Series 2/3/4, 1/4'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=2,PANADTYP=3,PANAD=2)),\" Series 2/3/4, 1/2'' Panel Adaptor - Straight cut both ends\",\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel2=FALSE,\"\",IF(AND(MNT=1,PANAD=2),1*NOPNL2*KQ,IF(AND(MNT=2,PANAD=2),2*NOPNL2*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel2=FALSE,\"\",IF(AND(MNT=1,PANAD=2),PNLH2,IF(AND(MNT=2,PANAD=2),PNLH2,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel2=FALSE,\"\",IF(AND(AND(MNT=1,PANADTYP=1,PANAD=2)),\"1203\"&PTD,IF(AND(AND(MNT=1,PANADTYP=2,PANAD=2)),\"1202\"&PTD,IF(AND(AND(MNT=1,PANADTYP=3,PANAD=2)),\"1204\"&PTD,IF(AND(AND(MNT=2,PANADTYP=1,PANAD=2)),\"1203\"&PTD,IF(AND(AND(MNT=2,PANADTYP=2,PANAD=2)),\"1202\"&PTD,IF(AND(AND(MNT=2,PANADTYP=3,PANAD=2)),\"1204\"&PTD,\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel2=FALSE,\"\",IF(AND(AND(MNT=1,PANADTYP=1,PANAD=2)),\" Series 2/3/4, 1/8'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=1,PANADTYP=2,PANAD=2)),\" Series 2/3/4, 1/4'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=1,PANADTYP=3,PANAD=2)),\" Series 2/3/4, 1/2'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=2,PANADTYP=1,PANAD=2)),\" Series 2/3/4, 1/8'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=2,PANADTYP=2,PANAD=2)),\" Series 2/3/4, 1/4'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=2,PANADTYP=3,PANAD=2)),\" Series 2/3/4, 1/2'' Panel Adaptor - Straight cut both ends\",\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel3=FALSE,\"\",IF(AND(MNT=1,PANAD=2),1*NOPNL3*KQ,IF(AND(MNT=2,PANAD=2),2*NOPNL3*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel3=FALSE,\"\",IF(AND(MNT=1,PANAD=2),PNLH3,IF(AND(MNT=2,PANAD=2),PNLH3,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel3=FALSE,\"\",IF(AND(AND(MNT=1,PANADTYP=1,PANAD=2)),\"1203\"&PTD,IF(AND(AND(MNT=1,PANADTYP=2,PANAD=2)),\"1202\"&PTD,IF(AND(AND(MNT=1,PANADTYP=3,PANAD=2)),\"1204\"&PTD,IF(AND(AND(MNT=2,PANADTYP=1,PANAD=2)),\"1203\"&PTD,IF(AND(AND(MNT=2,PANADTYP=2,PANAD=2)),\"1202\"&PTD,IF(AND(AND(MNT=2,PANADTYP=3,PANAD=2)),\"1204\"&PTD,\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel3=FALSE,\"\",IF(AND(AND(MNT=1,PANADTYP=1,PANAD=2)),\" Series 2/3/4, 1/8'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=1,PANADTYP=2,PANAD=2)),\" Series 2/3/4, 1/4'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=1,PANADTYP=3,PANAD=2)),\" Series 2/3/4, 1/2'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=2,PANADTYP=1,PANAD=2)),\" Series 2/3/4, 1/8'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=2,PANADTYP=2,PANAD=2)),\" Series 2/3/4, 1/4'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=2,PANADTYP=3,PANAD=2)),\" Series 2/3/4, 1/2'' Panel Adaptor - Straight cut both ends\",\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel4=FALSE,\"\",IF(AND(MNT=1,PANAD=2),1*NOPNL4*KQ,IF(AND(MNT=2,PANAD=2),2*NOPNL4*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel4=FALSE,\"\",IF(AND(MNT=1,PANAD=2),PNLH4,IF(AND(MNT=2,PANAD=2),PNLH4,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel4=FALSE,\"\",IF(AND(AND(MNT=1,PANADTYP=1,PANAD=2)),\"1203\"&PTD,IF(AND(AND(MNT=1,PANADTYP=2,PANAD=2)),\"1202\"&PTD,IF(AND(AND(MNT=1,PANADTYP=3,PANAD=2)),\"1204\"&PTD,IF(AND(AND(MNT=2,PANADTYP=1,PANAD=2)),\"1203\"&PTD,IF(AND(AND(MNT=2,PANADTYP=2,PANAD=2)),\"1202\"&PTD,IF(AND(AND(MNT=2,PANADTYP=3,PANAD=2)),\"1204\"&PTD,\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(Panel4=FALSE,\"\",IF(AND(AND(MNT=1,PANADTYP=1,PANAD=2)),\" Series 2/3/4, 1/8'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=1,PANADTYP=2,PANAD=2)),\" Series 2/3/4, 1/4'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=1,PANADTYP=3,PANAD=2)),\" Series 2/3/4, 1/2'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=2,PANADTYP=1,PANAD=2)),\" Series 2/3/4, 1/8'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=2,PANADTYP=2,PANAD=2)),\" Series 2/3/4, 1/4'' Panel Adaptor - Straight cut both ends\",IF(AND(AND(MNT=2,PANADTYP=3,PANAD=2)),\" Series 2/3/4, 1/2'' Panel Adaptor - Straight cut both ends\",\"\")))))))))","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,"Overall Height",null,null,null,{"$f":"IF(OAH=0,\"\",OAH)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clearance to Grade",null,null,null,null,{"$f":"IF(CTG=0,\"\",CTG)","v":""}]
[]
[null,"Hardware"]
[]
[null,"Post",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Reveal"," Select 3/4'' Reveal"]
[]
[null,"Qty.","Part #",null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Select Zero Reveal"]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PANAD=2,BOD=2,OR(RVLSET=2,RVLSET=3)),\"\",IF(MNT=1,1*KQ,IF(MNT=2,KQ*2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PANAD=2,BOD=2,OR(RVLSET=2,RVLSET=3)),\"\",IF(AND(PST=1,RVLSET=1),\"5260\"&PTD,IF(AND(PST=1,RVLSET=2),\"5261\"&PTD,IF(AND(PST=1,RVLSET=3),\"5262\"&PTD,IF(AND(PST=2,RVLSET=1),\"5405\",IF(AND(PST=2,RVLSET=2),\"5406\",IF(AND(PST=2,RVLSET=3),\"5407\",IF(AND(PST=3,RVLSET=1),\"5415\",IF(AND(PST=3,RVLSET=2),\"5416\",IF(AND(PST=3,RVLSET=3),\"5417\",IF(AND(PST=4,RVLSET=1),\"5010\"&PTD,IF(AND(PST=4,RVLSET=2),\"5012\"&PTD,IF(AND(PST=4,RVLSET=3),\"5014\"&PTD,IF(AND(PST=5,RVLSET=1),\"5000\"&PTD,IF(AND(PST=5,RVLSET=2),\"5002\"&PTD,IF(AND(PST=5,RVLSET=3),\"5004\"&PTD,IF(AND(PST=6,RVLSET=1),\"5015\",IF(AND(PST=6,RVLSET=2),\"5016\",IF(AND(PST=6,RVLSET=3),\"5017\",IF(AND(PST=7,RVLSET=1),\"5410\",IF(AND(PST=7,RVLSET=2),\"5411\",IF(AND(PST=7,RVLSET=3),\"5412\",IF(AND(PST=8,RVLSET=1),\"5006\",IF(AND(PST=8,RVLSET=2),\"5007\",IF(AND(PST=8,RVLSET=3),\"5008\",IF(AND(PST=9,RVLSET=1),\"5400\",IF(AND(PST=9,RVLSET=2),\"5401\",IF(AND(PST=9,RVLSET=3),\"5402\",IF(AND(PST=10,RVLSET>=1),\"5430\",IF(AND(PST=11,RVLSET>=1),\"5433\",\"\"))))))))))))))))))))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PANAD=2,BOD=2,OR(RVLSET=2,RVLSET=3)),\" Select Zero Reveal\",IF(POST=2,\"\",IF(POST=1,PSTC1&PSTC2&PSTC3&PSTC4,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PST=1,\" Series 2, 2'' Square Post Cap\",IF(PST=2,\" Series 3, 3-1/4'' Square Post Cap\",IF(PST=3,\" Series 3, 3-1/4'' Round Post Cap\",IF(PST=4,\" Series 3, 3-1/4'' Rectangular Post Cap\",IF(PST=5,\" Series 3, 3-1/4'' Radius Post Cap\",IF(PST=6,\" Series 3, 3-1/4'' Triangular Post Cap\",IF(PST=7,\" Series 3, 3-1/4'' Square Post Cap w/Radius Edges\",IF(PST=8,\" Series 3, 3-1/4'' Rectangular Post Cap w/Radius Edges\",IF(PST=9,\" Series 3, 3-1/4'' Triangular Post Cap w/Radius Edges\",IF(PST=10,\" Series 4, 4'' Round Post Cap\",IF(PST=11,\" Series 4, 4'' Square Post Cap\",\"\")))))))))))","v":" Series 2, 2'' Square Post Cap"},null,null,null,null,{"$f":"IF(AND(PST>=10,RVLSET<=3),\" 3/4'' Reveal - trim to fit 3/8'' and Zero Reveal\",IF(RVLSET=1,\" - Zero Reveal\",IF(RVLSET=2,\" - 3/8'' Reveal\",IF(RVLSET=3,\" - 3/4'' Reveal\",\"\"))))","v":" - Zero Reveal"}]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=6,MNT=1),4*KQ,IF(AND(PST=6,MNT=2),7*KQ,IF(MNT=1,3*KQ,IF(MNT=2,5*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST=1,\"5040\"&PTD,IF(PST=2,\"5040\",IF(PST=3,\"5040\",IF(PST=4,\"5040\"&PTD,IF(PST=5,\"5040\"&PTD,IF(PST=6,\"5040\",IF(PST=7,\"5040\",IF(PST=8,\"5040\",IF(PST=9,\"5040\",IF(PST=10,\"5040\",IF(PST=11,\"5040\",\"\")))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=6,MNT>=1),\" Cap Screw - #10 x 1/2 S.S. Countersink Sq./Phillips screw - Type A - Three (3) per Post Cap\",IF(AND(PST>=1,MNT>=1),\" Cap Screw - #10 x 1/2 S.S. Countersink Sq./Phillips screw - Type A - Two (2) per Post Cap\",\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MNT=1,\" - Single Post Flag Mounted\",IF(MNT=2,\" - Double Post Mounted\",\"\"))","v":" - Double Post Mounted"},null,null,null,null,{"$f":"IF(MNT=1,\" - One (1) Cap Per Post\",IF(MNT=2,\" - One (1) Cap Per Post\",\"\"))","v":" - One (1) Cap Per Post"}]
[]
[null,"Panel Adaptor"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(AND(PANAD=2,PANADTYP>=1),((PAScrws*NumAdpt)+2)*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(AND(AND(PANAD=2,PANADTYP>=1,MNT=1)),\"5218\",IF(AND(AND(PANAD=2,PANADTYP>=1,MNT=2)),\"5218\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(AND(AND(PANAD=2,PANADTYP>=1,MNT=1)),\" Panel Adaptor Attachmet Screws - #10 x 1/2'' Sq/Phillips Pan Head Screw - One (1) Approx. 6'' on center - One end\",IF(AND(AND(PANAD=2,PANADTYP>=1,MNT=2)),\" Panel Adaptor Attachmet Screws - #10 x 1/2'' Sq/Phillips Pan Head Screw - One (1) Approx. 6'' on center - 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,{"$f":"IF(Panel1=FALSE,0,ROUNDUP(PNLH1/6,0)+1)","v":0},{"$f":"IF(Panel2=FALSE,0,ROUNDUP(PNLH2/6,0)+1)","v":0},{"$f":"IF(Panel3=FALSE,0,ROUNDUP(PNLH3/6,0)+1)","v":0},{"$f":"IF(Panel4=FALSE,0,ROUNDUP(PNLH4/6,0)+1)","v":0},{"$f":"SUM(AE98:AH98)","v":0},"Panel Adaptor Screws"]
[]
[null,"Body / Cover"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),4*KQ,IF(AND(BOD=2,BodyType=2),4*KQ,IF(AND(BOD=2,BodyType=3),4*KQ,IF(AND(BOD=2,BodyType=4),\"\",IF(AND(BOD=2,BodyType=5),4*KQ,IF(AND(BOD=2,BodyType=6),4*KQ,IF(AND(BOD=2,BodyType=7),4*KQ,IF(AND(BOD=2,BodyType=8),\"\",IF(AND(BOD=2,BodyType=9),4*KQ,IF(AND(BOD=2,BodyType=10),4*KQ,IF(AND(BOD=2,BodyType=11),4*KQ,IF(AND(BOD=2,BodyType=12),4*KQ,IF(AND(BOD=2,BodyType=13),4*KQ,\"\")))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\"5330\",IF(AND(BOD=2,BodyType=2),\"5331\",IF(AND(BOD=2,BodyType=3),\"5331\",IF(AND(BOD=2,BodyType=4),\"\",IF(AND(BOD=2,BodyType=5),\"5335\",IF(AND(BOD=2,BodyType=6),\"5337\",IF(AND(BOD=2,BodyType=7),\"5337\",IF(AND(BOD=2,BodyType=8),\"\",IF(AND(BOD=2,BodyType=9),\"5341\",IF(AND(BOD=2,BodyType=10),\"5338\",IF(AND(BOD=2,BodyType=11),\"5339\",IF(AND(BOD=2,BodyType=12),\"5340\",IF(AND(BOD=2,BodyType=13),\"5340\",\"\")))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\" Series 2 Slide Body Corner Angle - 1'' x 1'' x 1/8'' (1-1/8'') - One (1) per corner\",IF(AND(BOD=2,BodyType=2),\" Series 2 Bleed Body Corner Angle - 1'' x 1'' x 1/8'' (1-1/2'') - One (1) per corner\",IF(AND(BOD=2,BodyType=3),\" Series 2 Frameless Body Corner Angle - 1'' x 1'' x 1/8'' (1-1/2'') - One per corner\",IF(AND(BOD=2,BodyType=4),\"\",IF(AND(BOD=2,BodyType=5),\" Series Slide Body Corner Angle - 1'' x 1'' x 1/8'' (2-1/4'') - One per corner\",IF(AND(BOD=2,BodyType=6),\" Series 3 Bleed Body Corner Angle - 1'' x 1'' x 1/8'' (2-11/16'') - One (1) per corner\",IF(AND(BOD=2,BodyType=7),\" Series 3 Frameless Body Corner Angle - 1'' x 1'' x 2-11/16'' - One (1) per corner\",IF(AND(BOD=2,BodyType=8),\"\",IF(AND(BOD=2,BodyType=9),\" Series 4 Frameless Body Corner Angle - 1'' x 1'' x 1/8'' (3-9/16'') - Oner (1) per corner\",IF(AND(BOD=2,BodyType=10),\" Series 3 Single Face Access Body Corner Angle - 2'' x 2'' x 1/8'' (1-1/2'') - One (1) per corner\",IF(AND(BOD=2,BodyType=11),\" Series 3 Access Body Corner Angle - 2'' x 2'' x 1/8'' (1-9/32'') - One (1) per corner\",IF(AND(BOD=2,BodyType=12),\" Series 4 Single Face Access Body Corner Angle - 2'' x 2'' x 1/8'' (2'') - One (1) per corner\",IF(AND(BOD=2,BodyType=13),\" Series 4 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(AND(BOD=2,BodyType=1),\"\",IF(AND(BOD=2,BodyType=2),\"\",IF(AND(BOD=2,BodyType=3),\"\",IF(AND(BOD=2,BodyType=4),\"\",IF(AND(BOD=2,BodyType=5),\"\",IF(AND(BOD=2,BodyType=6),\"\",IF(AND(BOD=2,BodyType=7),\"\",IF(AND(BOD=2,BodyType=8),8*KQ,IF(AND(BOD=2,BodyType=9),\"\",IF(AND(BOD=2,BodyType=10),\"\",IF(AND(BOD=2,BodyType=11),\"\",IF(AND(BOD=2,BodyType=12),\"\",IF(AND(BOD=2,BodyType=13),\"\",\"\")))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\"\",IF(AND(BOD=2,BodyType=2),\"\",IF(AND(BOD=2,BodyType=3),\"\",IF(AND(BOD=2,BodyType=4),\"\",IF(AND(BOD=2,BodyType=5),\"\",IF(AND(BOD=2,BodyType=6),\"\",IF(AND(BOD=2,BodyType=7),\"\",IF(AND(BOD=2,BodyType=8),\"5210\",IF(AND(BOD=2,BodyType=9),\"\",IF(AND(BOD=2,BodyType=10),\"\",IF(AND(BOD=2,BodyType=11),\"\",IF(AND(BOD=2,BodyType=12),\"\",IF(AND(BOD=2,BodyType=13),\"\",\"\")))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\"\",IF(AND(BOD=2,BodyType=2),\"\",IF(AND(BOD=2,BodyType=3),\"\",IF(AND(BOD=2,BodyType=4),\"\",IF(AND(BOD=2,BodyType=5),\"\",IF(AND(BOD=2,BodyType=6),\"\",IF(AND(BOD=2,BodyType=7),\"\",IF(AND(BOD=2,BodyType=8),\" Series 3, 1/4 Round Body Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BOD=2,BodyType=9),\"\",IF(AND(BOD=2,BodyType=10),\"\",IF(AND(BOD=2,BodyType=11),\"\",IF(AND(BOD=2,BodyType=12),\"\",IF(AND(BOD=2,BodyType=13),\"\",\"\")))))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RVLSET=4,\"\",IF(MNT=1,REVSCR*KQ,IF(MNT=2,REVSCR*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RVLSET=4,\"\",IF(MNT=1,\"5218\",IF(MNT=2,\"5218\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RVLSET=4,\"\",IF(MNT=1,\" Reveal to Body Screw - #10 x 1/2'' S.S. Sq/Phillips pan head screw - One (1) every 6'' on center\",IF(MNT=2,\" Reveal to Body Screw - #10 x 1/2'' S.S. Sq/Phillips pan head screw - One (1) every 6'' on center\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RVLSET=4,\"\",IF(MNT=1,ROUNDUP(HOC/6,0)+2,IF(MNT=2,(ROUNDUP(HOC/6,0)*2)+2,\"\"))))","v":""},"Reveal Screw"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType<=9),\"\",IF(AND(AND(BOD=2,BodyType=10,OR(CVR=1,CVR=3,CVR=4))),4*KQ,IF(AND(AND(BOD=2,BodyType=10,CVR=2)),4*KQ,IF(AND(AND(BOD=2,BodyType=11,OR(CVR=1,CVR=3,CVR=4))),8*KQ,IF(AND(AND(BOD=2,BodyType=11,CVR=2)),8*KQ,IF(AND(AND(BOD=2,BodyType=12,OR(CVR=1,CVR=3,CVR=4))),4*KQ,IF(AND(AND(BOD=2,BodyType=12,CVR=2)),4*KQ,IF(AND(AND(BOD=2,BodyType=13,OR(CVR=1,CVR=3,CVR=4))),8*KQ,IF(AND(AND(BOD=2,BodyType=13,CVR=2)),8*KQ,\"\")))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType<=9),\"\",IF(AND(AND(BOD=2,BodyType=10,OR(CVR=1,CVR=3,CVR=4))),\"5210\",IF(AND(AND(BOD=2,BodyType=10,CVR=2)),\"5226\",IF(AND(AND(BOD=2,BodyType=11,OR(CVR=1,CVR=3,CVR=4))),\"5210\",IF(AND(AND(BOD=2,BodyType=11,CVR=2)),\"5226\",IF(AND(AND(BOD=2,BodyType=12,OR(CVR=1,CVR=3,CVR=4))),\"5210\",IF(AND(AND(BOD=2,BodyType=12,CVR=2)),\"5226\",IF(AND(AND(BOD=2,BodyType=13,OR(CVR=1,CVR=3,CVR=4))),\"5210\",IF(AND(AND(BOD=2,BodyType=13,CVR=2)),\"5226\",\"\")))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType<=9),\"\",IF(AND(AND(BOD=2,BodyType=10,CVR=1)),\" Slide Cover Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(AND(BOD=2,BodyType=10,CVR=2)),\" Radius Slide Cover 3/4'' Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(AND(BOD=2,BodyType=10,CVR=3)),\" Slide Cover Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(AND(BOD=2,BodyType=10,CVR=4)),\" Slide Cover Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(AND(BOD=2,BodyType=11,CVR=1)),\" Slide Cover Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(AND(BOD=2,BodyType=11,CVR=2)),\" Radius Slide Cover 3/4'' Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(AND(BOD=2,BodyType=11,CVR=3)),\" Slide Cover Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(AND(BOD=2,BodyType=11,CVR=4)),\" Slide Cover Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(AND(BOD=2,BodyType=12,CVR=1)),\" Slide Cover Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(AND(BOD=2,BodyType=12,CVR=2)),\" Radius Slide Cover 3/4'' Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(AND(BOD=2,BodyType=12,CVR=3)),\" Slide Cover Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(AND(BOD=2,BodyType=12,CVR=4)),\" Slide Cover Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(AND(BOD=2,BodyType=13,CVR=1)),\" Slide Cover Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(AND(BOD=2,BodyType=13,CVR=2)),\" Radius Slide Cover 3/4'' Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(AND(BOD=2,BodyType=13,CVR=3)),\" Slide Cover Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(AND(BOD=2,BodyType=13,CVR=4)),\" Slide Cover Corner Key - .120 Stamped Aluminum - Two (2) per corner\",\"\")))))))))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),10*KQ,IF(AND(BOD=2,BodyType=2),\"\",IF(AND(BOD=2,BodyType=3),\"\",IF(AND(BOD=2,BodyType=4),10*KQ,IF(AND(BOD=2,BodyType=5),10*KQ,IF(AND(BOD=2,BodyType=6),\"\",IF(AND(BOD=2,BodyType=7),\"\",IF(AND(BOD=2,BodyType=8),\"\",IF(AND(BOD=2,BodyType=9),\"\",IF(AND(BOD=2,BodyType=10),10*KQ,IF(AND(BOD=2,BodyType=11),10*KQ,IF(AND(BOD=2,BodyType=12),10*KQ,IF(AND(BOD=2,BodyType=13),10*KQ,\"\")))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\"5240\"&PTD,IF(AND(BOD=2,BodyType=2),\"\",IF(AND(BOD=2,BodyType=3),\"\",IF(AND(BOD=2,BodyType=4),\"5241\"&PTD,IF(AND(BOD=2,BodyType=5),\"5240\"&PTD,IF(AND(BOD=2,BodyType=6),\"\",IF(AND(BOD=2,BodyType=7),\"\",IF(AND(BOD=2,BodyType=8),\"\",IF(AND(BOD=2,BodyType=9),\"\",IF(AND(BOD=2,BodyType=10),\"5270\",IF(AND(BOD=2,BodyType=11),\"5270\",IF(AND(BOD=2,BodyType=12),\"5270\",IF(AND(BOD=2,BodyType=13),\"5270\",\"\")))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType=1),\" Slide Body Corner Screw - 10-24 x 3/4'' S.S. Sq/Phillips countersink thread cutting screw - Two (2) per corner\",IF(AND(BOD=2,BodyType=2),\"\",IF(AND(BOD=2,BodyType=3),\"\",IF(AND(BOD=2,BodyType=4),\" Beveled Frame Corner Screw - #8 x 3/4'' S.S. Sq/Phillips countersink screw - Two (2) per corner\",IF(AND(BOD=2,BodyType=5),\" Slide Body Corner Screw - 10-24 x 3/4'' S.S. Sq/Phillips countersink thread cutting screw - Two (2) per corner\",IF(AND(BOD=2,BodyType=6),\"\",IF(AND(BOD=2,BodyType=7),\"\",IF(AND(BOD=2,BodyType=8),\"\",IF(AND(BOD=2,BodyType=9),\"\",IF(AND(BOD=2,BodyType=10),\" Singe Face Access Body Corner Screw - #8 x 1-1/2'' S.S. Sq/Phillips countersink screw - Two (2) per corner\",IF(AND(BOD=2,BodyType=11),\" Access Body Corner Screw - #8 x 1-1/2'' S.S. Sq/Phillips countersink screw - Two (2) per corner\",IF(AND(BOD=2,BodyType=12),\" Singe Face Access Body Corner Screw - #8 x 1-1/2'' S.S. Sq/Phillips countersink  screw - Two (2) per corner\",IF(AND(BOD=2,BodyType=13),\" Access Body Corner Screw - #8 x 1-1/2'' S.S. Sq/Phillips countersink screw - Two (2) per corner\",\"\")))))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType<=9),\"\",IF(AND(AND(BOD=2,BodyType=10,CVR>=1)),CCVRScrws*KQ,IF(AND(AND(BOD=2,BodyType=11,CVR>=1)),CCVRScrws*2*KQ,IF(AND(AND(BOD=2,BodyType=12,CVR>=1)),CCVRScrws*KQ,IF(AND(AND(BOD=2,BodyType=13,CVR>=1)),CCVRScrws*2*KQ,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType<=9),\"\",IF(AND(AND(BOD=2,BodyType=10,CVR>=1)),\"5168\",IF(AND(AND(BOD=2,BodyType=11,CVR>=1)),\"5168\",IF(AND(AND(BOD=2,BodyType=12,CVR>=1)),\"5168\",IF(AND(AND(BOD=2,BodyType=13,CVR>=1)),\"5168\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BOD=2,BodyType<=9),\"\",IF(AND(AND(BOD=2,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(AND(BOD=2,BodyType=11,CVR>=1)),\" Access Body Cover Screw - #8 x 1/2'' S.S. Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BOD=2,BodyType=12,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(AND(BOD=2,BodyType=13,CVR>=1)),\" 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(HOC/12,0)+1","v":1},{"$f":"ROUNDUP(Wdt/12,0)+1","v":1},{"$f":"ROUNDUP(HOC/12,0)+1","v":1},{"$f":"ROUNDUP(Wdt/12,0)+1","v":1},{"$f":"IF(KQ=0,\"',IF(BodyType<=9,\"\"\",SUM(AE108:AH108)+2)","v":"',IF(BodyType<=9,\""},"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=11)),HDQTY*4*KQ,IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=12)),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=11)),\"5308\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=12)),\"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=11)),\" 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=12)),\" 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*KQ,IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=11)),HDQTY*4*KQ,IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=12)),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)),\"5168\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=11)),\"5168\",IF(AND(AND(Divdr=2,Hdiv=TRUE,BodyType=12)),\"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=11)),\" 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=12)),\" 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=11)),VDQTY*4*KQ,IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=12)),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=11)),\"5308\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=12)),\"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=11)),\" 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=12)),\" 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*KQ,IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=11)),VDQTY*4*KQ,IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=12)),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)),\"5168\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=11)),\"5168\",IF(AND(AND(Divdr=2,Vdiv=TRUE,BodyType=12)),\"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=11)),\" 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=12)),\" 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,"Face Trim Size - Visual Openings"]
[]
[null,"Panel and/or Face - (Not Included in kit)"]
[]
[null,"Panel Cut Size (Width) for Panel Adaptors"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(AND(PANAD=2,MNT=1),Wdt+1,\"\")))","v":""},null,"Single Post",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(PANAD=1,\"\",IF(AND(PANAD=2,MNT=2),Wdt+2,\"\")))","v":""},null,"Double Post"]
[]
[null,"Face Trim Size"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(Divdr=2,\"\",IF(BOD=1,\"\",IF(BodyType=1,HOC-0.375,IF(BodyType=2,HOC-0.2,IF(BodyType=3,HOC,IF(BodyType=4,HOC-1.0625,IF(BodyType=5,HOC-0.375,IF(BodyType=6,HOC-0.25,IF(BodyType=7,HOC,IF(BodyType=8,HOC-1,IF(BodyType=9,HOC,IF(BodyType=10,HOC-0.375,IF(BodyType=11,HOC-0.375,IF(BodyType=12,HOC-0.375,IF(BodyType=13,HOC-0.375,\"\"))))))))))))))))","v":""},null,"Height",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Divdr=2,\"\",IF(BOD=1,\"\",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(BodyType=10,Wdt-0.375,IF(BodyType=11,Wdt-0.375,IF(BodyType=12,Wdt-0.375,IF(BodyType=13,Wdt-0.375,\"\"))))))))))))))))","v":""},null,"Width"]