{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Series 7-12 Illuminated"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":44,"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 7-12 Illuminated","index":0,"n_rows":136,"n_cols":41,"rows_kept":136,"cut":false,"hidden":false,"merged":[[100,33,100,34],[75,1,75,28],[76,1,76,28],[77,1,77,28],[78,1,78,25],[80,1,80,25],[82,1,82,25],[84,1,84,25],[78,26,84,26],[78,27,84,27],[78,28,84,28],[79,1,79,4],[79,5,79,13],[79,14,79,17],[79,18,79,24],[81,1,81,4],[81,5,81,6],[81,7,81,10],[81,11,81,12],[81,13,81,16],[81,17,81,18],[81,19,81,22],[81,23,81,24],[83,1,83,17],[83,23,83,24],[63,2,63,3],[63,5,63,6],[63,7,63,25],[64,2,64,3],[64,5,64,6],[64,7,64,25],[72,1,72,28],[73,1,73,28],[74,1,74,28],[83,18,83,22],[58,2,58,3],[58,5,58,6],[58,7,58,25],[59,1,59,28],[60,1,60,28],[60,31,60,32],[61,1,61,28],[62,2,62,3],[62,5,62,6],[62,7,62,28],[54,11,54,21],[52,22,52,28],[54,22,54,28],[52,32,52,36],[56,2,56,3],[56,5,56,6],[56,7,56,28],[57,2,57,3],[57,5,57,6],[57,7,57,25],[56,30,56,32],[25,7,25,25],[26,2,26,3],[20,1,20,28],[21,1,21,28],[18,1,18,28],[23,1,23,28],[22,21,22,22],[22,23,22,28],[22,1,22,20],[26,5,26,6],[26,7,26,25],[25,5,25,6],[25,2,25,3],[1,1,1,28],[24,5,24,6],[24,7,24,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],[19,1,19,28],[24,2,24,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],[16,1,16,10],[16,11,16,15],[16,16,16,28],[27,2,27,3],[27,5,27,6],[27,7,27,25],[30,1,30,28],[36,7,36,25],[37,7,37,25],[31,1,31,28],[35,2,35,3],[35,5,35,6],[35,7,35,28],[33,5,33,8],[33,1,33,4],[32,1,32,28],[33,19,33,20],[33,21,33,28],[128,1,128,28],[129,1,129,28],[38,1,38,28],[7,1,7,25],[7,26,13,26],[7,27,13,27],[7,28,13,28],[10,19,10,22],[12,1,12,17],[12,18,12,22],[10,23,10,24],[12,23,12,24],[8,18,8,24],[13,1,13,25],[10,7,10,10],[11,1,11,25],[127,1,127,28],[125,1,125,28],[126,1,126,28],[86,1,86,28],[88,1,88,28],[17,1,17,28],[91,2,91,3],[28,1,28,28],[101,2,101,3],[101,4,101,25],[96,28,101,28],[102,1,102,28],[93,1,93,28],[94,1,94,28],[95,2,95,3],[95,4,95,28],[96,2,96,3],[96,4,96,25],[97,2,97,3],[97,4,97,25],[98,2,98,3],[98,4,98,25],[99,4,99,25],[99,2,99,3],[5,45,5,47],[89,30,89,31],[100,2,100,3],[100,4,100,25],[5,30,5,33],[5,34,5,36],[5,37,5,38],[5,39,5,42],[5,43,5,44],[89,2,89,3],[89,4,89,28],[92,1,92,28],[90,30,90,34],[91,30,91,34],[91,35,91,38],[90,35,90,38],[90,2,90,3],[90,4,90,25],[91,4,91,25],[85,1,85,28],[29,1,29,28],[100,31,100,32],[31,31,31,32],[34,1,34,28],[131,8,131,9],[130,1,130,28],[131,1,131,2],[131,15,131,28],[132,1,132,28],[133,2,133,7],[133,8,133,20],[135,30,135,36],[135,3,135,15],[133,21,133,28],[135,1,135,2],[135,16,135,28],[134,1,134,28],[131,12,131,14],[131,3,131,4],[131,5,131,7],[131,10,131,11],[33,33,33,34],[39,1,39,28],[40,1,40,28],[41,1,41,28],[42,1,42,28],[41,31,41,32],[43,1,43,28],[44,2,44,3],[44,5,44,6],[44,7,44,28],[39,33,39,34],[36,2,36,3],[37,2,37,3],[36,5,36,6],[37,5,37,6],[33,30,33,31],[98,31,98,32],[99,34,99,35],[45,2,45,3],[45,5,45,6],[45,7,45,25],[48,2,48,3],[48,5,48,6],[48,7,48,25],[49,1,49,28],[46,2,46,3],[46,5,46,6],[46,7,46,25],[47,2,47,3],[47,5,47,6],[47,7,47,25],[50,1,50,28],[51,1,51,28],[53,1,53,28],[55,1,55,28],[52,1,52,8],[54,1,54,8],[52,9,52,10],[54,9,54,10],[52,11,52,21],[117,4,117,25],[116,28,117,28],[116,31,116,32],[103,1,103,28],[104,1,104,28],[105,2,105,3],[106,2,106,3],[107,2,107,3],[108,2,108,3],[110,2,110,3],[111,2,111,3],[105,4,105,28],[106,4,106,25],[107,4,107,25],[108,4,108,25],[110,4,110,25],[111,4,111,25],[106,28,111,28],[109,4,109,25],[109,2,109,3],[87,1,87,28],[109,35,109,36],[124,1,124,28],[8,30,8,33],[8,40,8,41],[10,30,10,33],[118,1,118,28],[120,1,120,28],[119,1,119,28],[121,2,121,3],[121,4,121,28],[122,2,122,3],[122,4,122,25],[123,2,123,3],[123,4,123,25],[111,35,111,36],[112,1,112,28],[113,1,113,28],[114,1,114,28],[115,2,115,3],[115,4,115,28],[116,2,116,3],[116,4,116,25],[117,2,117,3]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"AN6&AM9&AE9&AO9&AK9&AE6&AL6&AI6&AE11","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 7, 7'' Radius Post\",IF(PST=2,\"Series 7, 7'' Rectangular Post\",IF(PST=3,\"Series 7, 7'' Triangular 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,\" - 1/2'' Reveal\",IF(RVLSET=3,\" - 1'' Reveal\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"Series 7, Single Face Hinge Body\",IF(BodyType=2,\"Series 7, Hinge Body\",IF(BodyType=3,\"Series 12, Hinge Body\",IF(BodyType=4,\"Series 7/12, Retro Body\",\"\"))))))","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,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(RetType=1,\"Slide Retainer\",IF(RetType=2,\"3/4'' Slide Retainer\",IF(RetType=3,\"Frameless Rigid Retainer\",IF(RetType=4,\"Frameless Retainer\",IF(RetType=5,\"Bleed Retainer\",IF(RetType=6,\"Radius Cover/Access Frame\",IF(RetType=7,\"1/4 Round Retainer\",IF(RetType=8,\"Extended 1/4 Round Retainer\",IF(RetType=9,\"Extended 1/4 Round Retainer w/Reveal\",IF(RetType=10,\"Beveled Retainer\",\"\"))))))))))))","v":""},null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Ret=2,\" - and \",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(BOD=1,\"\",IF(POST=1,\" - with \",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(Divdr=2,OR(RetType=1,RetType=6)),\" / Divider \",\"\")))","v":""}]
[]
[null,"Kit Quantity  ",null,null,null,0,null,"Cabinet Height ",null,null,null,0,null," Cabinet Width",null,null,null,0,null,"Grade to Top",null,null,null,0,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(POST=1,\"\",IF(RadEnd=1,\"\",IF(AND(BodyType=1,RadEnd=2),\"6'' Radius 1/4 Round Ends\",IF(AND(BodyType=2,RadEnd=2),\"Series 7, 3-1/2'' Radius Ends\",IF(BodyType=3,\"6'' Radius Ends\",\"\"))))))","v":""}]
[]
[null,"Enter Fractions as Decimals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clearance to Grade",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Hgt=0,\"0.000\",OAH-Hgt))","v":""}]
[]
[null,"Extrusions"]
[]
[null,"Post",null,null,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,2,"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,97,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(AND(POST=1,BodyType=4),\"\",IF(MNT=1,1*KQ,IF(MNT=2,KQ*2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,BodyType=4),\"\",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(AND(POST=1,BodyType=4),\"\",IF(AND(AND(PST=1,LNGTH=10,PSTLNT=72)),\"1500\",IF(AND(AND(AND(PST=1,LNGTH=10,PSTLNT>=73,PSTLNT<=96))),\"1500-10'\",IF(AND(AND(PST=1,LNGTH=10,PSTLNT>=97)),\"1500\",IF(AND(AND(PST=2,LNGTH=10,PSTLNT=72)),\"1510\",IF(AND(AND(AND(PST=2,LNGTH=10,PSTLNT>=73,PSTLNT<=96))),\"1510-10'\",IF(AND(AND(PST=2,LNGTH=10,PSTLNT>=97)),\"1510\",IF(AND(PST=1,LNGTH=4),\"1500-10\",IF(AND(PST=1,LNGTH=5),\"1500-10\",IF(AND(PST=2,LNGTH=4),\"1510-10\",IF(AND(PST=2,LNGTH=5),\"1510-10\",IF(PST=1,\"1500\",IF(PST=2,\"1510\",IF(PST=3,\"1530\",\"\"))))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,BodyType=4),\" Select '' No Posts ''\",IF(AND(PST=1,MNT=1),\" Series 7, 7'' Radius Post - Single Post Flag Mounted\",IF(AND(PST=2,MNT=1),\" Series 7, 7'' Rectangular Post - Single Post Flag Mounted\",IF(AND(PST=3,MNT=1),\" Series 7, 7'' Triangular Post - Single Post Flag Mounted\",IF(AND(PST=1,MNT=2),\" Series 7, 7'' Radius Post - Double Post Mounted\",IF(AND(PST=2,MNT=2),\" Series 7, 7'' Rectangular Post - Double Post Mounted\",IF(AND(PST=3,MNT=2),\" Series 7, 7'' Triangular Post - Double Post Mounted\",\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(BOD=1,\"\",IF(AND(POST=1,BodyType=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(AND(POST=1,BodyType=4),\"\",IF(BOD=1,\"\",IF(PST>=1,Hgt-0.125,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,BodyType=4),\"\",IF(BOD=1,\"\",IF(PST>=1,\"1550\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(BOD=1,\"\",IF(AND(POST=1,BodyType=4),\"\",IF(AND(MNT=1,PST>=1),\" Series 7 Reveal - (Body Reveal attached to one end/side, 1/8'' down from top of cabinet)\",IF(AND(MNT=2,PST>=1),\" Series 7 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(POST=1,BodyType=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(AND(POST=1,BodyType=4),\"\",IF(PST>=1,CTG+6,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,BodyType=4),\"\",IF(PST>=1,\"1550\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,BodyType=4),\"\",IF(PST>=1,\" Series 7 Post Filler - (Below the cabinet/panel post filler)\",\"\"))))","v":""}]
[]
[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,2,"Bodies"]
[]
[null,"Body Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Body Type"]
[]
[null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType<=3,\"\",IF(BodyType=4,\"Select Add-on:\",\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null," ",null,null,null,null,null,null,null,null,"Select Add-on:",null,1,"Ret Add-on"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=4),2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=3),Wdt,IF(AND(BodyType=4,RetroAdd=1),Wdt+0.18,IF(AND(BodyType=4,RetroAdd=2),Wdt+0.305,IF(AND(BodyType=4,RetroAdd=3),Wdt+RetAdd,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"1602\",IF(BodyType=2,\"1592\",IF(BodyType=3,\"1612\",IF(BodyType=4,\"1600\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 7, Single Face Body - Mitred both ends - Top and Bottom\",IF(BodyType=2,\" Series 7, Hinge Body - Mitered both ends - Top and Bottom\",IF(BodyType=3,\" Series 12, Hinge Body - Mitered both ends - Top and Bottom\",IF(BodyType=4,\" Series 7-12, Retro Body - Mitered Both Ends - Top and Bottom\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=4),2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=3),Hgt,IF(AND(BodyType=4,RetroAdd=1),Hgt+0.18,IF(AND(BodyType=4,RetroAdd=2),Hgt+0.305,IF(AND(BodyType=4,RetroAdd=3),Hgt+RetAdd,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"1602\",IF(BodyType=2,\"1592\",IF(BodyType=3,\"1612\",IF(BodyType=4,\"1600\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 7, Single Face Body - Mitred both ends - Ends/Sides\",IF(BodyType=2,\" Series 7, Hinge Body - Mitered both ends - Ends/Sides\",IF(BodyType=3,\" Series 12, Hinge Body - Mitered both ends - Ends/Sides\",IF(BodyType=4,\" Series 7-12, Retro Body - Mitered Both Ends - Ends/Sides\",\"\"))))))","v":""}]
[]
[null,"Retainer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Retainer",1,"Slide Retainer"]
[]
[null,"Retainer Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Retainer Type"]
[]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(AND(AND(BodyType=1,RetType=1,Divdr=2,Hdiv=TRUE)))),2*KQ,IF(AND(AND(AND(AND(BodyType=2,RetType=1,Divdr=2,Hdiv=TRUE)))),4*KQ,IF(AND(AND(AND(AND(BodyType=3,RetType=1,Divdr=2,Hdiv=TRUE)))),4*KQ,IF(AND(AND(AND(AND(BodyType=4,RetType=1,Divdr=2,Hdiv=TRUE)))),2*KQ,IF(BodyType=1,2*KQ,IF(BodyType=2,4*KQ,IF(BodyType=3,4*KQ,IF(BodyType=4,2*KQ,\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType>=1,BodyType<=3),Wdt,IF(AND(BodyType=4,RetroAdd=1),Wdt+0.18,IF(AND(BodyType=4,RetroAdd=2),Wdt+0.305,IF(AND(BodyType=4,RetroAdd=3),Wdt+RetAdd,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(AND(AND(BodyType>=1,RetType=1,Divdr=2,Vdiv=TRUE)))),\"1690\",IF(RetType=1,\"1624\",IF(RetType=2,\"1626\",IF(RetType=3,\"1628\",IF(RetType=4,\"1631\",IF(RetType=5,\"1632\",IF(RetType=6,\"1690\",IF(RetType=7,\"1640\",IF(RetType=8,\"1650\",IF(RetType=9,\"1655\",IF(RetType=10,\"1656\",\"\")))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(AND(AND(BodyType>=1,RetType=1,Divdr=2,Vdiv=TRUE)))),\" Access Frame - Mitered Both Ends - Top and Bottom\",IF(RetType=1,\" Slide Retainer - Mitered Both Ends - Top and Bottom\",IF(RetType=2,\" 3/4 Slide Retainer - Mitered Both Ends - Top and Bottom\",IF(RetType=3,\" Frameless Rigid Retainer - Mitered Both Ends - Top and Bottom\",IF(RetType=4,\" Frameless Retainer - Mitered Both Ends - Top and Bottom\",IF(RetType=5,\" Bleed Retainer - Mitered Both Ends - Top and Bottom\",IF(RetType=6,\" Access Frame - Mitered Both Ends - Top and Bottom\",IF(RetType=7,\" 1/4 Round Retainer - Mitered Both Ends - Top and Bottom\",IF(RetType=8,\" Extended 1/4 Round Retainer - Mitered Both Ends - Top and Bottom\",IF(RetType=9,\" Extended 1/4 Round Retainer w/Reveal - Mitered Both Ends - Top and Bottom\",IF(RetType=10,\" Beveled Retainer - Mitered Both Ends - Top and Bottom\",\"\")))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(SLDRETCvr=2,Divdr=1),\"\",IF(AND(AND(AND(AND(AND(AND(AND(BodyType>=1,RetType=1,SLDRETCvr=2,Divdr=2,Hdiv=TRUE,Vdiv=FALSE))))))),\"\",IF(AND(AND(BodyType=1,SLDRETCvr=1,RetType=1)),1*KQ,IF(AND(AND(BodyType=2,SLDRETCvr=1,RetType=1)),2*KQ,IF(AND(AND(BodyType=3,SLDRETCvr=1,RetType=1)),2*KQ,IF(AND(AND(BodyType=4,SLDRETCvr=1,RetType=1)),1*KQ,IF(BodyType=1,2*KQ,IF(BodyType=2,4*KQ,IF(BodyType=3,4*KQ,IF(BodyType=4,2*KQ,))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(AND(AND(BodyType>=1,RetType=1,Divdr=2,Vdiv=TRUE)))),RETCOV,IF(AND(AND(AND(AND(AND(BodyType=4,RetType=1,Divdr=2,Hdiv=TRUE,RetroAdd=2))))),Hgt+0.305,IF(AND(AND(AND(AND(AND(BodyType=4,RetType=1,Divdr=2,Hdiv=TRUE,RetroAdd=3))))),Hgt+RetAdd,IF(AND(AND(BodyType>=1,SLDRETCvr=2,RetType=1)),\"\",IF(AND(BodyType>=1,BodyType<=3),Hgt,IF(AND(BodyType=4,RetroAdd=1),Hgt+0.18,IF(AND(BodyType=4,RetroAdd=2),Hgt+0.305,IF(AND(BodyType=4,RetroAdd=3),Hgt+RetAdd,\"\"))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(AND(AND(BodyType>=1,RetType=1,Divdr=2,Vdiv=TRUE)))),\"1694\",IF(AND(AND(BodyType>=1,SLDRETCvr=2,RetType=1)),\"\",IF(RetType=1,\"1624\",IF(RetType=2,\"1626\",IF(RetType=3,\"1628\",IF(RetType=4,\"1631\",IF(RetType=5,\"1632\",IF(RetType=6,\"1690\",IF(RetType=7,\"1640\",IF(RetType=8,\"1650\",IF(RetType=9,\"1655\",IF(RetType=10,\"1656\",\"\"))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(AND(AND(BodyType>=1,Divdr=2,Vdiv=TRUE)))),\" Slide Cover - Mitered Both Ends - Top and Bottom\",IF(AND(AND(BodyType>=1,SLDRETCvr=2,RetType=1)),\"\",IF(RetType=1,\" Slide Retainer - Mitered Both Ends - One End/Side\",IF(RetType=2,\" 3/4 Slide Retainer - Mitered Both Ends - Both Ends/Sides\",IF(RetType=3,\" Frameless Rigid Retainer - Mitered Both Ends - Both Ends/Sides\",IF(RetType=4,\" Frameless Retainer - Mitered Both Ends - Both Ends/Sides\",IF(RetType=5,\" Bleed Retainer - Mitered Both Ends - Both Ends/Sides\",IF(RetType=6,\" Access Frame - Mitered Both Ends - Both Ends/Sides\",IF(RetType=7,\" 1/4 Round Retainer - Mitered Both Ends - Both Ends/Sides\",IF(RetType=8,\" Extended 1/4 Round Retainer - Mitered Both Ends - Both Ends/Sides\",IF(RetType=9,\" Extended 1/4 Round Retainer w/Reveal - Mitered Both Ends - Both Ends/Sides\",IF(RetType=10,\" Beveled Retainer - Mitered Both Ends - Both Ends/Sides\",\"\"))))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(AND(AND(BodyType=1,RetType=1,Divdr=2,Vdiv=TRUE)))),2*KQ,IF(AND(AND(AND(AND(BodyType=2,RetType=1,Divdr=2,Vdiv=TRUE)))),4*KQ,IF(AND(AND(AND(AND(BodyType=3,RetType=1,Divdr=2,Vdiv=TRUE)))),4*KQ,IF(AND(AND(AND(AND(BodyType=4,RetType=1,Divdr=2,Vdiv=TRUE)))),2*KQ,IF(AND(AND(BodyType=1,SLDRETCvr=1,RetType=1)),1*KQ,IF(AND(AND(BodyType=2,SLDRETCvr=1,RetType=1)),2*KQ,IF(AND(AND(BodyType=3,SLDRETCvr=1,RetType=1)),2*KQ,IF(AND(AND(BodyType=4,SLDRETCvr=1,RetType=1)),1*KQ,IF(AND(AND(BodyType=1,SLDRETCvr=2,RetType=1)),2*KQ,IF(AND(AND(BodyType=2,SLDRETCvr=2,RetType=1)),4*KQ,IF(AND(AND(BodyType=3,SLDRETCvr=2,RetType=1)),4*KQ,IF(AND(AND(BodyType=4,SLDRETCvr=2,RetType=1)),2*KQ,IF(AND(BodyType=1,RetType=6),2*KQ,IF(AND(BodyType=2,RetType=6),4*KQ,IF(AND(BodyType=3,RetType=6),4*KQ,IF(AND(BodyType=4,RetType=6),2*KQ,\"\"))))))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,RetType<=5),\"\",IF(AND(RetType>=7,RetType<=10),\"\",IF(AND(AND(BodyType>=1,BodyType<=3,RetType=6)),Wdt+0.03125,IF(AND(AND(BodyType=4,RetroAdd=1,RetType=6)),Wdt+0.18,IF(AND(AND(BodyType=4,RetroAdd=2,RetType=6)),Wdt+0.305,IF(AND(AND(BodyType=4,RetroAdd=3,RetType=6)),Wdt+RetAdd,IF(AND(BodyType>=1,BodyType<=3),Hgt,IF(AND(BodyType=4,RetroAdd=1),Hgt+0.18,IF(AND(BodyType=4,RetroAdd=2),Hgt+0.305,IF(AND(BodyType=4,RetroAdd=3),Hgt+RetAdd,\"\"))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(AND(AND(BodyType>=1,RetType=1,Divdr=2,Vdiv=TRUE)))),\"1690\",IF(AND(RetType>=2,RetType<=5),\"\",IF(AND(RetType>=7,RetType<=10),\"\",IF(AND(AND(BodyType<=4,SLDRETCvr=1,RetType=1)),\"1690\",IF(AND(AND(BodyType<=4,SLDRETCvr=2,RetType=1)),\"1690\",IF(RetType=6,\"1695\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(AND(AND(AND(BodyType>=1,RetType=1,SLDRETCvr=1,Divdr=2,Vdiv=TRUE))))),\" Access Frame - Mitered Both Ends - Both Ends/Sides\",IF(AND(AND(AND(AND(BodyType=1,RetType=1,Divdr=2,Vdiv=TRUE)))),\" Access Frame - Mitered Both Ends - Both Ends/Sides\",IF(AND(RetType>=2,RetType<=5),\"\",IF(AND(RetType>=7,RetType<=10),\"\",IF(AND(AND(BodyType<=4,SLDRETCvr=1,RetType=1)),\" Access Frame - Mitered Both Ends - One End/Side\",IF(AND(AND(BodyType<=4,SLDRETCvr=2,RetType=1)),\" Access Frame - Mitered Both Ends - Both Ends/Sides\",IF(RetType=6,\" Radius Slide Cover - Mitered Both Ends - Top and Bottom\",\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(AND(AND(BodyType=1,RetType=1,Divdr=2,Vdiv=TRUE)))),2*KQ,IF(AND(AND(AND(AND(BodyType=2,RetType=1,Divdr=2,Vdiv=TRUE)))),4*KQ,IF(AND(AND(AND(AND(BodyType=3,RetType=1,Divdr=2,Vdiv=TRUE)))),4*KQ,IF(AND(AND(AND(AND(BodyType=4,RetType=1,Divdr=2,Vdiv=TRUE)))),2*KQ,IF(AND(AND(BodyType=1,SLDRETCvr=1,RetType=1)),1*KQ,IF(AND(AND(BodyType=2,SLDRETCvr=1,RetType=1)),2*KQ,IF(AND(AND(BodyType=3,SLDRETCvr=1,RetType=1)),2*KQ,IF(AND(AND(BodyType=4,SLDRETCvr=1,RetType=1)),1*KQ,IF(AND(AND(BodyType=1,SLDRETCvr=2,RetType=1)),2*KQ,IF(AND(AND(BodyType=2,SLDRETCvr=2,RetType=1)),4*KQ,IF(AND(AND(BodyType=3,SLDRETCvr=2,RetType=1)),4*KQ,IF(AND(AND(BodyType=4,SLDRETCvr=2,RetType=1)),2*KQ,IF(AND(BodyType=1,RetType=6),2*KQ,IF(AND(BodyType=2,RetType=6),4*KQ,IF(AND(BodyType=3,RetType=6),4*KQ,IF(AND(BodyType=4,RetType=6),2*KQ,\"\"))))))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,RetType<=5),\"\",IF(AND(RetType>=7,RetType<=10),\"\",IF(AND(BodyType>=1,BodyType<=3),Hgt+0.03125,IF(AND(BodyType=4,RetroAdd=1),Hgt+0.18,IF(AND(BodyType=4,RetroAdd=2),Hgt+0.305,IF(AND(BodyType=4,RetroAdd=3),Hgt+RetAdd,\"\"))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(AND(AND(BodyType>=1,RetType=1,Divdr=2,Vdiv=TRUE)))),\"1694\",IF(AND(RetType>=2,RetType<=5),\"\",IF(AND(RetType>=7,RetType<=10),\"\",IF(AND(AND(BodyType<=4,SLDRETCvr=1,RetType=1)),\"1694\",IF(AND(AND(BodyType<=4,SLDRETCvr=2,RetType=1)),\"1694\",IF(RetType=6,\"1695\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(AND(AND(AND(BodyType>=1,RetType=1,SLDRETCvr=1,Divdr=2,Vdiv=TRUE))))),\" Slide Cover - Mitered Both Ends - Both Ends/Sides\",IF(AND(AND(AND(AND(BodyType=1,RetType=1,Divdr=2,Vdiv=TRUE)))),\" Slide Cover - Mitered Both Ends - Both Ends/Sides\",IF(AND(RetType>=2,RetType<=5),\"\",IF(AND(RetType>=7,RetType<=10),\"\",IF(AND(AND(BodyType<=4,SLDRETCvr=1,RetType=1)),\" Slide Cover - Mitered Both Ends - One End/Side\",IF(AND(AND(BodyType<=4,SLDRETCvr=2,RetType=1)),\" Slide Cover - Mitered Both Ends - Both Ends/Sides\",IF(RetType=6,\" Radius Slide Cover - Mitered Both Ends - Both Ends/Sides\",\"\")))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[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(Hdiv=TRUE,OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7)),\" Select Slide Retainer or Radius Cover/Access Frame\",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,"H-Divider"," Select Slide Retainer or Radius Cover/Access Frame"]
[]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(Vdiv=FALSE,\"\",IF(AND(Vdiv=TRUE,OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7)),\" Select Slide Retainer or Radius Cover/Access Frame\",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,"V-Divider"]
[]
[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," Select Both Sides Removable"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(Hdiv=FALSE,\"\",IF(AND(AND(RetType=1,Divdr=2,SLDRETCvr=1)),\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\"\",IF(BodyType=1,NUMHD*KQ,IF(BodyType=2,NUMHD*2*KQ,IF(BodyType=3,NUMHD*2*KQ,IF(BodyType=4,NUMHD*KQ,\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(Hdiv=FALSE,\"\",IF(AND(AND(RetType=1,Divdr=2,SLDRETCvr=1)),\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\"\",IF(AND(BodyType>=1,BodyType<=3),Wdt-2.86,IF(AND(BodyType=4,RetroAdd=1),(Wdt+0.18)-2.86,IF(AND(BodyType=4,RetroAdd=2),(Wdt+0.305)-2.86,IF(AND(BodyType=4,RetroAdd=3),(Wdt+RetAdd)-2.86,\"\"))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(Hdiv=FALSE,\"\",IF(AND(AND(RetType=1,Divdr=2,SLDRETCvr=1)),\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\"\",IF(RetType=1,\"1662\",IF(RetType=6,\"1662\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(Hdiv=FALSE,\"\",IF(AND(AND(RetType=1,Divdr=2,SLDRETCvr=1)),\" Select Both Sides Removable\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\"\",IF(RetType=1,\" 1-1/4'' Divider - Straight Cut Both Ends\",IF(RetType=6,\" 1-1/4'' Divider - Straight Cut Both Ends\",\"\"))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(Vdiv=FALSE,\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\"\",IF(BodyType=1,NUMVD*KQ,IF(BodyType=2,NUMVD*2*KQ,IF(BodyType=3,NUMVD*2*KQ,IF(BodyType=4,NUMVD*KQ,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(Vdiv=FALSE,\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\"\",IF(AND(BodyType>=1,BodyType<=3),Hgt-2.86,IF(AND(BodyType=4,RetroAdd=1),(Hgt+0.18)-2.86,IF(AND(BodyType=4,RetroAdd=2),(Hgt+0.305)-2.86,IF(AND(BodyType=4,RetroAdd=3),(Hgt+RetAdd)-2.86,\"\")))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(Vdiv=FALSE,\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\"\",IF(RetType=1,\"1662\",IF(RetType=6,\"1662\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(Vdiv=FALSE,\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\"\",IF(RetType=1,\" 1-1/4'' Divider - Straight Cut Both Ends\",IF(RetType=6,\" 1-1/4'' Divider - Straight Cut Both Ends\",\"\")))))))","v":""}]
[]
[null,"Radius Ends",null,null,null,null,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 Ends"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,2*KQ,IF(BodyType=2,4*KQ,IF(BodyType=3,4*KQ,IF(BodyType=4,\"\",\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,Hgt-0.25,IF(BodyType=2,Hgt-0.125,IF(BodyType=3,Hgt-0.125,IF(BodyType=4,\"\",\"\")))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,\"1671\",IF(BodyType=2,\"1670\",IF(BodyType=3,\"1671\",IF(BodyType=4,\"\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,\" 6'' Raidus 1/4 Round End - Staight Cut Both Ends - One (1) Each End/Side\",IF(BodyType=2,\" Series 7, 3-1/2'', 1/4 Round End - Staight Cut Both Ends - Two (2) Each End/Side\",IF(BodyType=3,\" 6'' Raidus 1/4 Round End - Staight Cut Both Ends - Two (2) Each End/Side\",IF(BodyType=4,\"\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,2*KQ,IF(BodyType=2,\"\",IF(BodyType=3,4*KQ,IF(BodyType=4,\"\",\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,Hgt-0.25,IF(BodyType=2,\"\",IF(BodyType=3,Hgt-0.125,IF(BodyType=4,\"\",\"\")))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,\"2183\",IF(BodyType=2,\"\",IF(BodyType=3,\"2183\",IF(BodyType=4,\"\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,\" 2'' x 2'' x .125'' Aluminum Angle - Staight Cut Both Ends - One (1) Each End/Side\",IF(BodyType=2,\"\",IF(BodyType=3,\" 2'' x 2'' x .125'' Aluminum Angle - Staight Cut Both Ends - Two (2) Each End/Side\",IF(BodyType=4,\"\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BILL OF MATERIAL"]
[]
[null,{"$f":"IF(Discrpt=0,\"\",Discrpt)","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,{"$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,"Cabinet Height",null,null,null,{"$f":"IF(Hgt=0,\"\",Hgt)","v":""},null,"Cabinet 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"]
[]
[null,"Qty.","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(AND(PST=1,RVLSET=1),\"5020\",IF(AND(PST=1,RVLSET=2),\"5024\",IF(AND(PST=1,RVLSET=3),\"5026\",IF(AND(PST=2,RVLSET=1),\"5030\",IF(AND(PST=2,RVLSET=2),\"5034\",IF(AND(PST=2,RVLSET=3),\"5036\",IF(AND(PST=3,RVLSET=1),\"5425\",IF(AND(PST=3,RVLSET=2),\"5426\",IF(AND(PST=3,RVLSET=3),\"5427\",\"\")))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",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 7, 7'' Radius Post Cap\",IF(PST=2,\" Series 7, 7'' Rectangular Post Cap\",IF(PST=3,\" Series 7, 7'' Triangular Post Cap\",\"\")))","v":" Series 7, 7'' Radius Post Cap"},null,null,null,null,{"$f":"IF(RVLSET=1,\" - Zero Reveal\",IF(RVLSET=2,\" - 1/2'' Reveal\",IF(RVLSET=3,\" - 1'' Reveal\",\"\")))","v":" - Zero Reveal"}]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=3,MNT=1),4*KQ,IF(AND(PST=3,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\",IF(PST=2,\"5040\",IF(PST=3,\"5040\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=3,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,\" - Two (2) Post Caps - One (1) per Post\",\"\"))","v":" - Two (2) Post Caps - One (1) per Post"}]
[]
[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,\"\",\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"5346\",IF(BodyType=2,\"5344\",IF(BodyType=3,\"5342\",IF(BodyType=4,\"\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 7 Single Face Hinge Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (4-1/8'') - One (1) per corner\",IF(BodyType=2,\" Series 7 Hinge Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (3-13/16'') - One (1) per corner\",IF(BodyType=3,\" Series 12 Hinge Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (8-3/4'') - One (1) per corner\",IF(BodyType=4,\"\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=3,8*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=3,\"5210\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=3,\" Series 12, Hinge Body Corner Key - .120 Stamped Aluminum - Two (2) per corner\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,(HScr+2)*KQ,IF(BodyType=2,((HScr*2)+2)*KQ,IF(BodyType=3,((HScr*2)+2)*KQ,IF(BodyType=4,(HScr+2)*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"5280\",IF(BodyType=2,\"5280\",IF(BodyType=3,\"5280\",IF(BodyType=4,\"5280\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Hinge Screw - 1/4-20  x 1/2'' S.S. Allen Head Machine Screw - One (1) every 18'' on center accross top\",IF(BodyType=2,\" Hinge Screw - 1/4-20  x 1/2'' S.S. Allen Head Machine Screw - One (1) every 18'' on center accross top\",IF(BodyType=3,\" Hinge Screw - 1/4-20  x 1/2'' S.S. Allen Head Machine Screw - One (1) every 18'' on center accross top\",IF(BodyType=4,\" Hinge Screw - 1/4-20  x 1/2'' S.S. Allen Head Machine Screw - One (1) every 18'' on center accross top\",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(Wdt/18,0)+1","v":1},"Hinge Screws"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,(CScr+2)*KQ,IF(BodyType=2,((CScr*2)+2)*KQ,IF(BodyType=3,((CScr*2)+2)*KQ,IF(BodyType=4,(CScr+2)*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"5230\",IF(BodyType=2,\"5230\",IF(BodyType=3,\"5230\",IF(BodyType=4,\"5230\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Closure Screw - 1/4-20  x 3/4'' S.S. Pan Head Machine Screw - One (1) every 36'' on center along sides and bottom\",IF(BodyType=2,\" Closure Screw - 1/4-20  x 3/4'' S.S. Pan Head Machine Screw - One (1) every 36'' on center along sides and bottom\",IF(BodyType=3,\" Closure Screw - 1/4-20  x 3/4'' S.S. Pan Head Machine Screw - One (1) every 36'' on center along sides and bottom\",IF(BodyType=4,\" Closure Screw - 1/4-20  x 3/4'' S.S. Pan Head Machine Screw - One (1) every 36'' on center along sides and bottom\",\"\"))))))","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":"SUM(AF100:AH100)","v":3},{"$f":"ROUNDUP(Hgt/36,0)+1","v":1},{"$f":"ROUNDUP(Wdt/36,0)+1","v":1},{"$f":"ROUNDUP(Hgt/36,0)+1","v":1},"Closure Screws"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(POST=2,\"\",IF(BodyType=4,\"\",IF(AND(POST=1,MNT=1),(REVSCR+2)*KQ,IF(AND(POST=1,MNT=2),(REVSCR+2)*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(POST=2,\"\",IF(BodyType=4,\"\",IF(AND(POST=1,MNT=1),\"5218\",IF(AND(POST=1,MNT=2),\"5218\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(POST=2,\"\",IF(AND(POST=1,BodyType=4),\" Select '' No Posts ''\",IF(AND(POST=1,MNT=1),\" Reveal to Body Screw - #10 x 1/2'' S.S. Sq/Phillips pan head screw - Two (2) every 6'' on center\",IF(AND(POST=1,MNT=2),\" Reveal to Body Screw - #10 x 1/2'' S.S. Sq/Phillips pan head screw - Two (2) 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(MNT=1,ROUNDUP(Hgt/6,0)*2,IF(MNT=2,(ROUNDUP(Hgt/6,0)*2)*2,\"\")))","v":""},"Reveal Screw",null," Select '' No Posts ''"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,16*KQ,IF(BodyType=2,16*KQ,IF(BodyType=3,16*KQ,IF(BodyType=4,\"\",\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"5218\",IF(BodyType=2,\"5218\",IF(BodyType=3,\"5218\",IF(BodyType=4,\"\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 7 S/F Hinge Body Corner Angle Screw - #10 x 1/2'' S.S. Sq/Phillips Pan Head Tapping Screw - Four (4) per corner\",IF(BodyType=2,\" Series 7 Hinge Body Corner Angle Screw - #10 x 1/2'' S.S. Sq/Phillips Pan Head Tapping Screw - Four (4) per corner\",IF(BodyType=3,\" Series 12 Hinge Body Corner Angle Screw - #10 x 1/2'' S.S. Sq/Phillips Pan Head Tapping Screw - Four (4) per corner\",IF(BodyType=4,\"\",\"\"))))))","v":""}]
[]
[null,"Retainer"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(RetType=2,\"\",IF(AND(BOD=1,RetType=1),4*KQ,IF(AND(BOD=1,RetType>=3),4*KQ,IF(AND(BodyType=1,RetType=1),8*KQ,IF(AND(BodyType=1,RetType>=3),4*KQ,IF(AND(BodyType=2,RetType=1),8*2*KQ,IF(AND(BodyType=2,RetType>=3),4*2*KQ,IF(AND(BodyType=3,RetType=1),8*2*KQ,IF(AND(BodyType=3,RetType>=3),4*2*KQ,IF(AND(BodyType=4,RetType=1),8*KQ,IF(AND(BodyType=4,RetType>=3),4*KQ,\"\")))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(RetType=2,\"\",IF(AND(BOD=1,RetType=1),\"5210\",IF(AND(BOD=1,RetType>=3),\"5210\",IF(AND(BodyType=1,RetType=1),\"5210\",IF(AND(BodyType=1,RetType>=3),\"5210\",IF(AND(BodyType=2,RetType=1),\"5210\",IF(AND(BodyType=2,RetType>=3),\"5210\",IF(AND(BodyType=3,RetType=1),\"5210\",IF(AND(BodyType=3,RetType>=3),\"5210\",IF(AND(BodyType=4,RetType=1),\"5210\",IF(AND(BodyType=4,RetType>=3),\"5210\",\"\")))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(RetType=2,\"\",IF(AND(BOD=1,RetType=1),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BOD=1,RetType>=3),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=1,RetType=1),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BodyType=1,RetType>=3),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=2,RetType=1),\" Corner Key - .120 Stamped Aluminum - Four (4) per corner\",IF(AND(BodyType=2,RetType>=3),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=3,RetType=1),\" Corner Key - .120 Stamped Aluminum - Four (4) per corner\",IF(AND(BodyType=3,RetType>=3),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=4,RetType=1),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BodyType=4,RetType>=3),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",\"\")))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=1,RetType=2),4*KQ,IF(AND(BOD=1,RetType=6),4*KQ,IF(AND(BodyType=1,RetType=2),4*KQ,IF(AND(BodyType=1,RetType=6),4*KQ,IF(AND(BodyType=2,RetType=2),8*KQ,IF(AND(BodyType=2,RetType=6),8*KQ,IF(AND(BodyType=3,RetType=2),8*KQ,IF(AND(BodyType=3,RetType=6),8*KQ,IF(AND(BodyType=4,RetType=2),4*KQ,IF(AND(BodyType=4,RetType=6),4*KQ,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=1,RetType=2),\"5226\",IF(AND(BOD=1,RetType=6),\"5226\",IF(AND(BodyType=1,RetType=2),\"5226\",IF(AND(BodyType=1,RetType=6),\"5226\",IF(AND(BodyType=2,RetType=2),\"5226\",IF(AND(BodyType=2,RetType=6),\"5226\",IF(AND(BodyType=3,RetType=2),\"5226\",IF(AND(BodyType=3,RetType=6),\"5226\",IF(AND(BodyType=4,RetType=2),\"5226\",IF(AND(BodyType=4,RetType=6),\"5226\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=1,RetType=2),\" 3/4'' Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BOD=1,RetType=6),\" 3/4'' Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=1,RetType=2),\" 3/4'' Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=1,RetType=6),\" 3/4'' Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=2,RetType=2),\" 3/4'' Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BodyType=2,RetType=6),\" 3/4'' Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BodyType=3,RetType=2),\" 3/4'' Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BodyType=3,RetType=6),\" 3/4'' Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BodyType=4,RetType=2),\" 3/4'' Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=4,RetType=6),\" 3/4'' Corner Key - .120 Stamped Aluminum - One (1) per corner\",\"\"))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=1,RetType>=8),4*KQ,IF(AND(BodyType=1,RetType>=8),4*KQ,IF(AND(BodyType=2,RetType>=8),8*KQ,IF(AND(BodyType=3,RetType>=8),8*KQ,IF(AND(BodyType=4,RetType>=8),4*KQ,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=1,RetType>=8),\"5325\",IF(AND(BodyType=1,RetType>=8),\"5325\",IF(AND(BodyType=2,RetType>=8),\"5325\",IF(AND(BodyType=3,RetType>=8),\"5325\",IF(AND(BodyType=4,RetType>=8),\"5325\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=1,RetType>=8),\" Corner Angle - 1'' x 1'' x 1/8'' (1/2'') - One (1) per corner\",IF(AND(BodyType=1,RetType>=8),\" Corner Angle - 1'' x 1'' x 1/8'' (1/2'') - One (1) per corner\",IF(AND(BodyType=2,RetType>=8),\" Corner Angle - 1'' x 1'' x 1/8'' (1/2'') - One (1) per corner\",IF(AND(BodyType=3,RetType>=8),\" Corner Angle - 1'' x 1'' x 1/8'' (1/2'') - One (1) per corner\",IF(AND(BodyType=4,RetType>=8),\" Corner Angle - 1'' x 1'' x 1/8'' (1/2'') - One (1) per corner\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=1,RetType=3),FceScrws*KQ,IF(AND(BodyType=1,RetType=3),FceScrws*KQ,IF(AND(BodyType=2,RetType=3),FceScrws*2*KQ,IF(AND(BodyType=3,RetType=3),FceScrws*2*KQ,IF(AND(BodyType=4,RetType=3),FceScrws*KQ,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=1,RetType=3),\"5285\",IF(AND(BodyType=1,RetType=3),\"5285\",IF(AND(BodyType=2,RetType=3),\"5285\",IF(AND(BodyType=3,RetType=3),\"5285\",IF(AND(BodyType=4,RetType=3),\"5285\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=1,RetType=3),\" Face Attachment Hardware - 1/4-20 x 1'' CS Machine Screw/Bushing /Nut - One (1) every 12'' on Center\",IF(AND(BodyType=1,RetType=3),\" Face Attachment Hardware - 1/4-20 x 1'' CS Machine Screw/Bushing /Nut - One (1) every 12'' on Center\",IF(AND(BodyType=2,RetType=3),\" Face Attachment Hardware - 1/4-20 x 1'' CS Machine Screw/Bushing /Nut - One (1) every 12'' on Center\",IF(AND(BodyType=3,RetType=3),\" Face Attachment Hardware - 1/4-20 x 1'' CS Machine Screw/Bushing /Nut - One (1) every 12'' on Center\",IF(AND(BodyType=4,RetType=3),\" Face Attachment Hardware - 1/4-20 x 1'' CS Machine Screw/Bushing /Nut - One (1) every 12'' on Center\",\"\")))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AF110:AI110)","v":4},{"$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},"Face Screws"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=1,OR(RetType=1,RetType=3,RetType=6)),10*KQ,IF(AND(BOD=1,RetType=2),6*KQ,IF(AND(BodyType=1,OR(RetType=1,RetType=3,RetType=6)),10*KQ,IF(AND(BodyType=1,RetType=2),6*KQ,IF(AND(BodyType=2,OR(RetType=1,RetType=3,RetType=6)),((8*2)+2)*KQ,IF(AND(BodyType=2,RetType=2),((4*2)+2)*KQ,IF(AND(BodyType=3,OR(RetType=1,RetType=3,RetType=6)),((8*2)+2)*KQ,IF(AND(BodyType=3,RetType=2),((4*2)+2)*KQ,IF(AND(BodyType=4,OR(RetType=1,RetType=3,RetType=6)),10*KQ,IF(AND(BodyType=4,RetType=2),6*KQ,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=1,OR(RetType=1,RetType=3,RetType=6)),\"5270\",IF(AND(BOD=1,RetType=2),\"5270\",IF(AND(BodyType=1,OR(RetType=1,RetType=3,RetType=6)),\"5270\",IF(AND(BodyType=1,RetType=2),\"5270\",IF(AND(BodyType=2,OR(RetType=1,RetType=3,RetType=6)),\"5270\",IF(AND(BodyType=2,RetType=2),\"5270\",IF(AND(BodyType=3,OR(RetType=1,RetType=3,RetType=6)),\"5270\",IF(AND(BodyType=3,RetType=2),\"5270\",IF(AND(BodyType=4,OR(RetType=1,RetType=3,RetType=6)),\"5270\",IF(AND(BodyType=4,RetType=2),\"5270\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=1,OR(RetType=1,RetType=3,RetType=6)),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - Two (2) per corner\",IF(AND(BOD=1,RetType=2),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - One (1) per corner\",IF(AND(BodyType=1,OR(RetType=1,RetType=3,RetType=6)),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - Two (2) per corner\",IF(AND(BodyType=1,RetType=2),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - One (1) per corner\",IF(AND(BodyType=2,OR(RetType=1,RetType=3,RetType=6)),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - Two (2) per corner\",IF(AND(BodyType=2,RetType=2),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - One (1) per corner\",IF(AND(BodyType=3,OR(RetType=1,RetType=3,RetType=6)),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - Two (2) per corner\",IF(AND(BodyType=3,RetType=2),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - One (1) per corner\",IF(AND(BodyType=4,OR(RetType=1,RetType=3,RetType=6)),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - Two (2) per corner\",IF(AND(BodyType=4,RetType=2),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - One (1) per corner\",\"\"))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(BOD=1,RetType=1,SLDRETCvr=1)),(HgtCvrScrA+2)*KQ,IF(AND(AND(BOD=1,RetType=1,SLDRETCvr=2)),((HgtCvrScrA+HgtCvrScrB)+2)*KQ,IF(AND(BOD=1,RetType=6),(CvrSCR+2)*KQ,IF(AND(AND(BodyType=1,RetType=1,SLDRETCvr=1)),(HgtCvrScrA+2)*KQ,IF(AND(AND(BodyType=1,RetType=1,SLDRETCvr=2)),((HgtCvrScrA+HgtCvrScrB)+2)*KQ,IF(AND(BodyType=1,RetType=6),(CvrSCR+2)*KQ,IF(AND(AND(BodyType=2,RetType=1,SLDRETCvr=1)),((HgtCvrScrA*2)+2)*KQ,IF(AND(AND(BodyType=2,RetType=1,SLDRETCvr=2)),(((HgtCvrScrA+HgtCvrScrB)*2)+2)*KQ,IF(AND(BodyType=2,RetType=6),((CvrSCR*2)+2)*KQ,IF(AND(AND(BodyType=3,RetType=1,SLDRETCvr=1)),((HgtCvrScrA*2)+2)*KQ,IF(AND(AND(BodyType=3,RetType=1,SLDRETCvr=2)),(((HgtCvrScrA+HgtCvrScrB)*2)+2)*KQ,IF(AND(BodyType=3,RetType=6),((CvrSCR*2)+2)*KQ,IF(AND(AND(BodyType=4,RetType=1,SLDRETCvr=1)),(HgtCvrScrA+2)*KQ,IF(AND(AND(BodyType=4,RetType=1,SLDRETCvr=2)),((HgtCvrScrA+HgtCvrScrB)+2)*KQ,IF(AND(BodyType=4,RetType=6),(CvrSCR+2)*KQ,\"\")))))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(BOD=1,RetType=1,SLDRETCvr=1)),\"5168\",IF(AND(AND(BOD=1,RetType=1,SLDRETCvr=2)),\"5168\",IF(AND(BOD=1,RetType=6),\"5168\",IF(AND(AND(BodyType=1,RetType=1,SLDRETCvr=1)),\"5168\",IF(AND(AND(BodyType=1,RetType=1,SLDRETCvr=2)),\"5168\",IF(AND(BodyType=1,RetType=6),\"5168\",IF(AND(AND(BodyType=2,RetType=1,SLDRETCvr=1)),\"5168\",IF(AND(AND(BodyType=2,RetType=1,SLDRETCvr=2)),\"5168\",IF(AND(BodyType=2,RetType=6),\"5168\",IF(AND(AND(BodyType=3,RetType=1,SLDRETCvr=1)),\"5168\",IF(AND(AND(BodyType=3,RetType=1,SLDRETCvr=2)),\"5168\",IF(AND(BodyType=3,RetType=6),\"5168\",IF(AND(AND(BodyType=4,RetType=1,SLDRETCvr=1)),\"5168\",IF(AND(AND(BodyType=4,RetType=1,SLDRETCvr=2)),\"5168\",IF(AND(BodyType=4,RetType=6),\"5168\",\"\")))))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(BOD=1,RetType=1,SLDRETCvr=1)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BOD=1,RetType=1,SLDRETCvr=2)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(BOD=1,RetType=6),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BodyType=1,RetType=1,SLDRETCvr=1)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BodyType=1,RetType=1,SLDRETCvr=2)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(BodyType=1,RetType=6),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BodyType=2,RetType=1,SLDRETCvr=1)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BodyType=2,RetType=1,SLDRETCvr=2)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(BodyType=2,RetType=6),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BodyType=3,RetType=1,SLDRETCvr=1)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BodyType=3,RetType=1,SLDRETCvr=2)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(BodyType=3,RetType=6),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BodyType=4,RetType=1,SLDRETCvr=1)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BodyType=4,RetType=1,SLDRETCvr=2)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(BodyType=4,RetType=6),\" Cover Screw - #8 x 1/2'' 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":"SUM(AF112:AI112)","v":4},{"$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},"Cover Screws"]
[]
[null,"Divider"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\"\",IF(BodyType=1,DivdTab*KQ,IF(BodyType=2,DivdTab*2*KQ,IF(BodyType=3,DivdTab*2*KQ,IF(BodyType=4,DivdTab*KQ,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\"\",IF(BodyType=1,\"5308\",IF(BodyType=2,\"5308\",IF(BodyType=3,\"5308\",IF(BodyType=4,\"5308\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\" Select Slide Retainer or Radius Cover/Access Frame\",IF(BodyType=1,\" 1-1/4'' Divider Tab - 1'' x 2-1/4'' .125 Aluminum - Two (2) per Divider\",IF(BodyType=2,\" 1-1/4'' Divider Tab - 1'' x 2-1/4'' .125 Aluminum - Two (2) per Divider\",IF(BodyType=3,\" 1-1/4'' Divider Tab - 1'' x 2-1/4'' .125 Aluminum - Two (2) per Divider\",IF(BodyType=4,\" 1-1/4'' Divider Tab - 1'' x 2-1/4'' .125 Aluminum - Two (2) per Divider\",\"\"))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(NUMHD+NUMVD)*2","v":0},"Divider Tabs"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\"\",IF(BodyType=1,(DivdTab)*KQ,IF(BodyType=2,((DivdTab*2)+2)*KQ,IF(BodyType=3,((DivdTab*2)+2)*KQ,IF(BodyType=4,(DivdTab)*KQ,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\"\",IF(BodyType=1,\"5168\",IF(BodyType=2,\"5168\",IF(BodyType=3,\"5168\",IF(BodyType=4,\"5168\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(Divdr=1,\"\",IF(OR(RetType=2,RetType=3,RetType=4,RetType=5,RetType>=7),\" Select Slide Retainer or Radius Cover/Access Frame\",IF(BodyType=1,\" #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(BodyType=2,\" #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(BodyType=3,\" #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(BodyType=4,\" #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",\"\"))))))))","v":""}]
[]
[null,"Radius Ends"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,4*KQ,IF(BodyType=2,2*KQ,IF(BodyType=3,2*KQ,IF(BodyType=4,\"\",\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,\"5441\",IF(BodyType=2,\"5029\",IF(BodyType=3,\"5440\",IF(BodyType=4,\"\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,\" 6'' Radius End 1/4 Round - .125 Aluminum - 1-1/4'' Reveal Tab\",IF(BodyType=2,\" 1/2 Round End - .125 Aluminum\",IF(BodyType=3,\" 6'' Radius End - .125 Aluminum - 1-1/4'' Reveal Tab\",IF(BodyType=4,\"\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,\"\",IF(BodyType=2,6*KQ,IF(BodyType=3,\"\",IF(BodyType=4,\"\",\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,\"\",IF(BodyType=2,\"5040\",IF(BodyType=3,\"\",IF(BodyType=4,\"\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,\"\",IF(BodyType=2,\" Cap Screw - #10 x 1/2'' Sq/Phillips countersink screw\",IF(BodyType=3,\"\",IF(BodyType=4,\"\",\"\")))))))","v":""}]
[]
[null,"Face Trim Size"]
[]
[null,"Face - (Not Included in kit)"]
[]
[null,"Face Trim Size"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(Divdr=2,OR(RetType=1,RetType=6)),\"\",IF(RetType=1,Hgt-0.25,IF(RetType=2,Hgt-0.25,IF(RetType=3,Hgt-0.18,IF(RetType=4,Hgt+0.25,IF(RetType=5,Hgt-0.25,IF(RetType=6,Hgt-0.25,IF(RetType=7,Hgt-1.23,IF(RetType=8,Hgt-3,IF(RetType=9,Hgt-8.25,IF(RetType=10,Hgt-6.306,\"\")))))))))))))","v":""},null,"Height",null,null,"X",null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(Divdr=2,OR(RetType=1,RetType=6)),\"\",IF(RetType=1,Wdt-0.25,IF(RetType=2,Wdt-0.25,IF(RetType=3,Wdt-0.18,IF(RetType=4,Wdt+0.25,IF(RetType=5,Wdt-0.25,IF(RetType=6,Wdt-0.25,IF(RetType=7,Wdt-1.23,IF(RetType=8,Wdt-3,IF(RetType=9,Wdt-8.25,IF(RetType=10,Wdt-6.306,\"\")))))))))))))","v":""},null,"Width"]
[]
[null,null,"Face Material Thickness:",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RetType=1,\" .1875 Acrylic or Polycarbonate\",IF(RetType=2,\" .1875 Acrylic or Polycarbonate\",IF(RetType=3,\" .1875 Acrylic or Polycarbonate (Pan-Formed)\",IF(RetType=4,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(RetType=5,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(RetType=6,\" .1875 Acrylic or Polycarbonate\",IF(RetType=7,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(RetType=8,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(RetType=9,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(RetType=10,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",\"\")))))))))))","v":""}]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(RetType=1,\"\",IF(RetType=2,\"\",IF(RetType=3,\"\",IF(RetType=4,\" It is recommended to oversize the panel and trim off with flush router\",IF(RetType>=5,\"\",\"\"))))))","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," It is recommended to oversize the panel and trim off with flush router"]