{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Series 7-12 Insert Panels"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":69,"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 Insert Panels","index":0,"n_rows":144,"n_cols":41,"rows_kept":144,"cut":false,"hidden":false,"merged":[[123,4,123,25],[107,2,107,3],[108,2,108,3],[109,2,109,3],[110,2,110,3],[111,2,111,3],[107,4,107,28],[108,4,108,25],[109,4,109,25],[110,4,110,25],[111,4,111,25],[108,28,111,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],[8,30,8,33],[8,40,8,41],[10,30,10,33],[118,1,118,28],[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],[117,4,117,25],[116,28,117,28],[116,31,116,32],[105,1,105,28],[106,1,106,28],[33,31,33,32],[53,5,53,6],[54,5,54,6],[55,5,55,6],[57,5,57,6],[58,5,58,6],[101,34,101,35],[36,2,36,3],[36,5,36,6],[36,7,36,25],[39,2,39,3],[39,5,39,6],[39,7,39,25],[41,1,41,28],[37,2,37,3],[37,5,37,6],[37,7,37,25],[38,2,38,3],[38,5,38,6],[38,7,38,25],[61,1,61,28],[62,1,62,28],[43,1,43,28],[45,1,45,28],[92,2,92,3],[55,2,55,3],[57,2,57,3],[58,2,58,3],[42,31,42,32],[61,31,61,32],[132,1,132,28],[133,2,133,7],[135,30,135,36],[135,3,135,15],[135,1,135,2],[134,1,134,28],[131,12,131,14],[131,3,131,4],[131,5,131,7],[131,10,131,11],[87,1,87,28],[102,31,102,32],[131,8,131,9],[130,1,130,28],[131,1,131,2],[131,15,131,28],[44,20,44,24],[46,9,46,10],[103,4,103,25],[104,1,104,28],[98,2,98,3],[98,4,98,25],[99,2,99,3],[99,4,99,25],[100,2,100,3],[100,4,100,25],[101,4,101,25],[101,2,101,3],[128,1,128,28],[53,2,53,3],[54,2,54,3],[100,31,100,32],[124,1,124,28],[123,2,123,3],[91,30,91,31],[102,2,102,3],[102,4,102,25],[5,30,5,33],[5,34,5,36],[5,37,5,38],[5,39,5,42],[91,2,91,3],[91,4,91,28],[94,1,94,28],[89,1,89,5],[89,6,89,9],[89,10,89,28],[92,30,92,34],[93,30,93,34],[93,35,93,38],[92,35,92,38],[98,28,103,28],[95,1,95,28],[96,1,96,28],[97,2,97,3],[97,4,97,28],[92,4,92,25],[93,4,93,25],[129,1,129,28],[30,1,30,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],[88,1,88,28],[90,1,90,28],[17,1,17,28],[93,2,93,3],[103,2,103,3],[16,1,16,5],[31,33,31,34],[34,1,34,28],[35,2,35,3],[1,1,1,28],[20,5,20,6],[20,7,20,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,2,20,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],[25,33,25,34],[16,6,16,8],[65,1,65,28],[66,1,66,28],[66,31,66,32],[67,1,67,28],[68,2,68,3],[68,5,68,6],[68,7,68,28],[63,2,63,3],[63,5,63,6],[63,7,63,28],[64,2,64,3],[64,5,64,6],[64,7,64,25],[16,22,16,28],[60,1,60,28],[42,1,42,28],[40,2,40,3],[40,7,40,25],[40,5,40,6],[25,6,25,28],[25,1,25,5],[21,7,21,25],[33,1,33,28],[74,1,74,28],[75,1,75,28],[76,1,76,28],[81,14,81,17],[81,18,81,24],[83,1,83,4],[83,5,83,6],[83,7,83,10],[83,11,83,12],[83,13,83,16],[83,17,83,18],[83,19,83,22],[83,23,83,24],[29,2,29,3],[29,5,29,6],[29,7,29,25],[31,1,31,6],[31,7,31,10],[31,11,31,28],[32,1,32,28],[51,7,51,25],[52,7,52,25],[44,26,44,27],[44,1,44,6],[44,11,44,15],[51,5,51,6],[52,5,52,6],[51,2,51,3],[52,2,52,3],[46,7,46,8],[48,7,48,8],[46,11,46,12],[48,11,48,12],[46,14,46,15],[48,14,48,15],[46,18,46,19],[48,18,48,19],[18,21,18,22],[18,23,18,28],[18,1,18,20],[22,5,22,6],[22,7,22,25],[21,5,21,6],[21,2,21,3],[26,1,26,28],[28,2,28,3],[28,5,28,6],[23,2,23,3],[23,5,23,6],[23,7,23,25],[28,7,28,25],[27,2,27,3],[27,5,27,6],[27,7,27,28],[24,1,24,28],[22,2,22,3],[19,1,19,28],[35,5,35,6],[35,7,35,28],[47,1,47,28],[44,8,44,10],[102,33,102,34],[77,1,77,28],[78,1,78,28],[79,1,79,28],[80,1,80,25],[82,1,82,25],[84,1,84,25],[86,1,86,25],[80,26,86,26],[80,27,86,27],[80,28,86,28],[81,1,81,4],[81,5,81,13],[57,7,57,25],[58,7,58,25],[48,9,48,10],[48,16,48,17],[49,1,49,28],[46,16,46,17],[44,17,44,19],[36,30,36,32],[140,1,140,28],[142,1,142,28],[141,1,141,28],[139,10,139,11],[59,2,59,3],[59,5,59,6],[139,22,139,23],[69,30,69,37],[133,8,133,17],[136,1,136,28],[138,1,138,28],[53,7,53,25],[54,7,54,25],[55,7,55,25],[85,1,85,17],[85,23,85,24],[85,18,85,22],[69,2,69,3],[69,5,69,6],[69,7,69,25],[70,2,70,3],[70,5,70,6],[70,7,70,25],[59,7,59,25],[46,23,46,24],[48,23,48,24],[46,25,46,26],[48,25,48,26],[56,2,56,3],[56,5,56,6],[56,7,56,25],[50,2,50,3],[50,5,50,6],[50,7,50,28],[46,21,46,22],[48,21,48,22],[46,27,46,28],[48,27,48,28],[143,22,143,23],[139,2,139,3],[139,6,139,7],[139,14,139,15],[139,18,139,19],[143,2,143,3],[143,6,143,7],[143,10,143,11],[143,14,143,15],[143,18,143,19]]}
[]
[]
[]
[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, Radius Post\",IF(PST=2,\" Series 7, Rectangular Post\",IF(PST=3,\" Series 7, Triangular Post\",\"\")))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(MNT=1,\" - Single Post Mount\",IF(MNT=2,\" - Double Post Mount\",\"\"))))","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,\" Insert Retainer\",IF(RetType=2,\" Insert / Bleed Retainer\",IF(RetType=3,\" Insert / Frameless Retainer\",\"\")))))","v":""},null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(POST=1,\" and\",IF(RadEnd=2,\" and\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(RetType>=1,\" with\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(EndCVR=1,\" / Insert End Cover\",IF(EndCVR=2,\" / Ext Insert End Cover\",\"\"))))","v":""}]
[]
[null,"Kit Quantity  ",null,null,null,0,null,"Cabinet Height ",null,null,null,{"$f":"IF(KQ=0,\"\",SUM(AK45,AL45,AM45,AG47,AH47,AI47,AG49,AH49,AI49)+0.25)","v":""},null," Cabinet Width",null,null,null,0,null,"Overall Height",null,null,null,0,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(AND(RadEnd=2,BodyType=1),\" 6'' 1/4 Round End\",IF(AND(RadEnd=2,BodyType=2),\" 3-1/2'' Radius End\",IF(AND(RadEnd,BodyType=3),\" 6'' Radius End\",\"\")))))","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,"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,2,"Posts",2,"Mount",1,"Post Type"]
[]
[null,"Post Length",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,null,null,null,null,null,null,null,null,10,"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>=72,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>=72,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,"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,1,"Bodies",1,"Body Type"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=4),2*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=4),Wdt,\"\")))","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<=4),Hgt,\"\")))","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,"Retainer Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Retainer",1,"Retainer Type"]
[]
[null,"End Cover 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,"End Cover"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(AND(BodyType=1,RetType=1),2*KQ,IF(AND(BodyType=2,RetType=1),4*KQ,IF(AND(BodyType=3,RetType=1),4*KQ,IF(AND(BodyType=4,RetType=1),2*KQ,IF(AND(BodyType=1,RetType>=2),2*KQ,IF(AND(BodyType=2,RetType>=2),2*KQ,IF(AND(BodyType=3,RetType>=2),2*KQ,\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(AND(BodyType>=1,BodyType<=4),Wdt,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(RetType=1,\"1666\",IF(RetType=2,\"1666\",IF(RetType=3,\"1666\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\" Select Insert Retainer\",IF(RetType=1,\" Insert Retainer - Mitered Both Ends - Top and Bottom\",IF(RetType=2,\" Insert Retainer - Mitered Both Ends - Top and Bottom\",IF(RetType=3,\" Insert Retainer - Mitered Both Ends - Top 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," Select Insert Retainer"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(AND(BodyType=1,RetType=1),2*KQ,IF(AND(BodyType=2,RetType=1),4*KQ,IF(AND(BodyType=3,RetType=1),4*KQ,IF(AND(BodyType=4,RetType=1),2*KQ,IF(AND(BodyType=1,RetType>=2),2*KQ,IF(AND(BodyType=2,RetType>=2),2*KQ,IF(AND(BodyType=3,RetType>=2),2*KQ,\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(AND(BodyType>=1,BodyType<=4),Hgt,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(RetType=1,\"1690\",IF(RetType=2,\"1690\",IF(RetType=3,\"1690\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(RetType=1,\" Access Frame - Mitered Both Ends - Ends/Sides\",IF(RetType=2,\" Access Frame - Mitered Both Ends - Ends/Sides\",IF(RetType=3,\" Access Frame - Mitered Both Ends - Ends/Sides\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(AND(BodyType=1,RetType=1),2*KQ,IF(AND(BodyType=2,RetType=1),4*KQ,IF(AND(BodyType=3,RetType=1),4*KQ,IF(AND(BodyType=4,RetType=1),2*KQ,IF(AND(AND(BodyType=1,RetType>=2,EndCVR>=1)),2*KQ,IF(AND(AND(BodyType=2,RetType>=2,EndCVR>=1)),2*KQ,IF(AND(AND(BodyType=3,RetType>=2,EndCVR>=1)),2*KQ,\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(AND(BodyType>=1,BodyType<=4),Hgt+0.03125,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(AND(RetType>=1,EndCVR=1),\"1696\",IF(AND(RetType>=1,EndCVR=2),\"1698\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(AND(RetType>=1,EndCVR=1),\" Insert End Cover - Mitered Both Ends - Ends/Sides\",IF(AND(RetType>=1,EndCVR=2),\" Extended Insert End Cover - Mitered Both Ends - Ends/Sides\",\"\")))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(AND(BodyType=1,RetType>=2),2*KQ,IF(AND(BodyType=2,RetType>=2),2*KQ,IF(AND(BodyType=3,RetType>=2),2*KQ,IF(AND(BodyType=4,RetType>=2),\"\",\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=4,RetType>=2),\"\",IF(AND(RetType>=2,OR(BodyType=2,BodyType=3)),Wdt,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=4,RetType>=2),\"\",IF(AND(RetType=2,OR(BodyType=2,BodyType=3)),\"1632\",IF(AND(RetType=3,OR(BodyType=2,BodyType=3)),\"1631\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=4,RetType>=2),\"\",IF(AND(RetType=2,OR(BodyType=2,BodyType=3)),\" Bleed Retainer - Miter Both Ends - Top and Bottom\",IF(AND(RetType=3,OR(BodyType=2,BodyType=3)),\" Frameless Retainer - Mitered Both Ends - Top and Bottom\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(AND(BodyType=1,RetType>=2),2*KQ,IF(AND(BodyType=2,RetType>=2),2*KQ,IF(AND(BodyType=3,RetType>=2),2*KQ,IF(AND(BodyType=4,RetType>=2),\"\",\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=4,RetType>=2),\"\",IF(AND(RetType>=2,OR(BodyType=2,BodyType=3)),Hgt,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=4,RetType>=2),\"\",IF(AND(RetType=2,OR(BodyType=2,BodyType=3)),\"1632\",IF(AND(RetType=3,OR(BodyType=2,BodyType=3)),\"1631\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=4,RetType>=2),\"\",IF(AND(RetType=2,OR(BodyType=2,BodyType=3)),\" Bleed Retainer - Miter Both Ends - Ends/Sides\",IF(AND(RetType=3,OR(BodyType=2,BodyType=3)),\" Frameless Retainer - Mitered Both Ends - Ends/Sides\",\"\")))))","v":""}]
[]
[null,"Insert Panels",null,null,null,null,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,"Insert Panels"]
[]
[null,null,null,null,null,null,null,0,{"$f":"IF(KQ=0,\"\",IF(Panel4=TRUE,\" Insert Panels\",\"\"))","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(KQ=0,\"\",IF(Panel6=TRUE,\" Insert Panels\",\"\"))","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(KQ=0,\"\",IF(Panel8=TRUE,\" Insert Panels\",\"\"))","v":""},null,null,null,false,"4\" Panel",false,"6\" Panel",false,"8\"Panel",{"$f":"IF(Panel4=FALSE,0,PanelA*4.03)","v":0},{"$f":"IF(Panel6=FALSE,0,PanelB*6.03)","v":0},{"$f":"IF(Panel8=FALSE,0,PanelC*8.03)","v":0}]
[]
[null,null,null,null,null,null,0,{"$f":"IF(KQ=0,\"\",IF(PlasPan=TRUE,\" Panel(s)\",\"\"))","v":""},null,0,null,{"$f":"IF(KQ=0,\"\",IF(PlasPan=TRUE,\" Height\",\"\"))","v":""},null,0,{"$f":"IF(KQ=0,\"\",IF(PlasPan=TRUE,\" Panel(s)\",\"\"))","v":""},null,0,null,{"$f":"IF(KQ=0,\"\",IF(PlasPan=TRUE,\" Height\",\"\"))","v":""},null,0,{"$f":"IF(KQ=0,\"\",IF(PlasPan=TRUE,\" Panel(s)\",\"\"))","v":""},null,0,null,{"$f":"IF(KQ=0,\"\",IF(PlasPan=TRUE,\" Height\",\"\"))","v":""},null,null,null,null,false,"Plastic Ad",{"$f":"IF(PlasPan=FALSE,0,(PnlHgtD+0.03)*PanelD)","v":0},{"$f":"IF(PlasPan=FALSE,0,(PnlHgtD1+0.03)*PanelD1)","v":0},{"$f":"IF(PlasPan=FALSE,0,(PnlHgtD2+0.03)*PanelD2)","v":0}]
[]
[null,null,null,null,null,null,0,{"$f":"IF(KQ=0,\"\",IF(AlumPan=TRUE,\" Panel(s)\",\"\"))","v":""},null,0,null,{"$f":"IF(KQ=0,\"\",IF(AlumPan=TRUE,\" Height\",\"\"))","v":""},null,0,{"$f":"IF(KQ=0,\"\",IF(AlumPan=TRUE,\" Panel(s)\",\"\"))","v":""},null,0,null,{"$f":"IF(KQ=0,\"\",IF(AlumPan=TRUE,\" Height\",\"\"))","v":""},null,0,{"$f":"IF(KQ=0,\"\",IF(AlumPan=TRUE,\" Panel(s)\",\"\"))","v":""},null,0,null,{"$f":"IF(KQ=0,\"\",IF(AlumPan=TRUE,\" Height\",\"\"))","v":""},null,null,null,null,false,"Alum Ad",{"$f":"IF(AlumPan=FALSE,0,(PnlHgtE+0.03)*PanelE)","v":0},{"$f":"IF(AlumPan=FALSE,0,(PnlHgtE1+0.03)*PanelE1)","v":0},{"$f":"IF(AlumPan=FALSE,0,(PnlHgtE2+0.03)*PanelE2)","v":0}]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelA=0,\"\",IF(RetType=1,PanFor,IF(RetType>=2,PanFor/2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelA=0,\"\",IF(AND(PanelA>=1,EndCVR=1),Wdt-0.25,IF(AND(PanelA>=1,EndCVR=2),Wdt-0.125,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelA=0,\"\",IF(PanelA>=1,\"1674\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelA=0,\"\",IF(PanelA>=1,\" 4'' Aluminum Insert Panel - 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,{"$f":"IF(KQ=0,\"\",IF(PanelA=0,\"\",IF(AND(BodyType=1,PanelA>=1),PanelA*KQ,IF(AND(BodyType=2,PanelA>=1),PanelA*2*KQ,IF(AND(BodyType=3,PanelA>=1),PanelA*2*KQ,IF(AND(BodyType=4,PanelA>=1),PanelA*KQ,\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelB=0,\"\",IF(RetType=1,PanSix,IF(RetType>=2,PanSix/2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelB=0,\"\",IF(AND(PanelB>=1,EndCVR=1),Wdt-0.25,IF(AND(PanelB>=1,EndCVR=2),Wdt-0.125,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelB=0,\"\",IF(PanelB>=1,\"1676\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelB=0,\"\",IF(PanelB>=1,\" 6'' Aluminum Insert Panel - 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,{"$f":"IF(KQ=0,\"\",IF(PanelB=0,\"\",IF(AND(BodyType=1,PanelB>=1),PanelB*KQ,IF(AND(BodyType=2,PanelB>=1),PanelB*2*KQ,IF(AND(BodyType=3,PanelB>=1),PanelB*2*KQ,IF(AND(BodyType=4,PanelB>=1),PanelB*KQ,\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelC=0,\"\",IF(RetType=1,PanEght,IF(RetType>=2,PanEght/2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelC=0,\"\",IF(AND(PanelC>=1,EndCVR=1),Wdt-0.25,IF(AND(PanelC>=1,EndCVR=2),Wdt-0.125,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelC=0,\"\",IF(PanelC>=1,\"1678\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelC=0,\"\",IF(PanelC>=1,\" 8'' Aluminum Insert Panel - 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,{"$f":"IF(KQ=0,\"\",IF(PanelC=0,\"\",IF(AND(BodyType=1,PanelC>=1),PanelC*KQ,IF(AND(BodyType=2,PanelC>=1),PanelC*2*KQ,IF(AND(BodyType=3,PanelC>=1),PanelC*2*KQ,IF(AND(BodyType=4,PanelC>=1),PanelC*KQ,\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelD=0,\"\",IF(RetType=1,PanAdA,IF(RetType>=2,PanAdA/2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelD=0,\"\",IF(AND(PanelD>=1,EndCVR=1),Wdt-0.25,IF(AND(PanelD>=1,EndCVR=2),Wdt-0.125,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelD=0,\"\",IF(PanelD>=1,\"1689\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelD=0,\"\",IF(PanelD>=1,\" Plastic Insert Adaptor - 2 Per Panel - 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,{"$f":"IF(KQ=0,\"\",IF(PanelD=0,\"\",IF(AND(BodyType=1,PanelD>=1),PanelD*2*KQ,IF(AND(BodyType=2,PanelD>=1),(PanelD*2)*2*KQ,IF(AND(BodyType=3,PanelD>=1),(PanelD*2)*2*KQ,IF(AND(BodyType=4,PanelD>=1),PanelD*2*KQ,\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelD1=0,\"\",IF(RetType=1,PanAdB,IF(RetType>=2,PanAdB/2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelD1=0,\"\",IF(AND(PanelD1>=1,EndCVR=1),Wdt-0.25,IF(AND(PanelD1>=1,EndCVR=2),Wdt-0.125,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelD1=0,\"\",IF(PanelD1>=1,\"1689\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelD1=0,\"\",IF(PanelD1>=1,\" Plastic Insert Adaptor - 2 Per Panel - 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,{"$f":"IF(KQ=0,\"\",IF(PanelD1=0,\"\",IF(AND(BodyType=1,PanelD1>=1),PanelD1*2*KQ,IF(AND(BodyType=2,PanelD1>=1),(PanelD1*2)*2*KQ,IF(AND(BodyType=3,PanelD1>=1),(PanelD1*2)*2*KQ,IF(AND(BodyType=4,PanelD1>=1),PanelD1*2*KQ,\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelD2=0,\"\",IF(RetType=1,PanAdC,IF(RetType>=2,PanAdC/2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelD2=0,\"\",IF(AND(PanelD2>=1,EndCVR=1),Wdt-0.25,IF(AND(PanelD2>=1,EndCVR=2),Wdt-0.125,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelD2=0,\"\",IF(PanelD2>=1,\"1689\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelD2=0,\"\",IF(PanelD2>=1,\" Plastic Insert Adaptor - 2 Per Panel - 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,{"$f":"IF(KQ=0,\"\",IF(PanelD2=0,\"\",IF(AND(BodyType=1,PanelD2>=1),PanelD2*2*KQ,IF(AND(BodyType=2,PanelD2>=1),(PanelD2*2)*2*KQ,IF(AND(BodyType=3,PanelD2>=1),(PanelD2*2)*2*KQ,IF(AND(BodyType=4,PanelD2>=1),PanelD2*2*KQ,\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelE=0,\"\",IF(RetType=1,PanAdD,IF(RetType>=2,PanAdD/2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelE=0,\"\",IF(AND(PanelE>=1,EndCVR=1),Wdt-0.25,IF(AND(PanelE>=1,EndCVR=2),Wdt-0.125,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelE=0,\"\",IF(PanelE>=1,\"1679\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelE=0,\"\",IF(PanelE>=1,\" Aluminum Insert Adaptor - 2 Per Panel - 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,{"$f":"IF(KQ=0,\"\",IF(PanelE=0,\"\",IF(AND(BodyType=1,PanelE>=1),PanelE*2*KQ,IF(AND(BodyType=2,PanelE>=1),(PanelE*2)*2*KQ,IF(AND(BodyType=3,PanelE>=1),(PanelE*2)*2*KQ,IF(AND(BodyType=4,PanelE>=1),PanelE*2*KQ,\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelE1=0,\"\",IF(RetType=1,PanAdE,IF(RetType>=2,PanAdE/2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelE1=0,\"\",IF(AND(PanelE1>=1,EndCVR=1),Wdt-0.25,IF(AND(PanelE1>=1,EndCVR=2),Wdt-0.125,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelE1=0,\"\",IF(PanelE1>=1,\"1679\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelE1=0,\"\",IF(PanelE1>=1,\" Aluminum Insert Adaptor - 2 Per Panel - 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,{"$f":"IF(KQ=0,\"\",IF(PanelE1=0,\"\",IF(AND(BodyType=1,PanelE1>=1),PanelE1*2*KQ,IF(AND(BodyType=2,PanelE1>=1),(PanelE1*2)*2*KQ,IF(AND(BodyType=3,PanelE1>=1),(PanelE1*2)*2*KQ,IF(AND(BodyType=4,PanelE1>=1),PanelE1*2*KQ,\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelE2=0,\"\",IF(RetType=1,PanAdF,IF(RetType>=2,PanAdF/2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelE2=0,\"\",IF(AND(PanelE2>=1,EndCVR=1),Wdt-0.25,IF(AND(PanelE2>=1,EndCVR=2),Wdt-0.125,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelE2=0,\"\",IF(PanelE2>=1,\"1679\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",IF(PanelE2=0,\"\",IF(PanelE2>=1,\" Aluminum Insert Adaptor - 2 Per Panel - 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,{"$f":"IF(KQ=0,\"\",IF(PanelE2=0,\"\",IF(AND(BodyType=1,PanelE2>=1),PanelE2*2*KQ,IF(AND(BodyType=2,PanelE2>=1),(PanelE2*2)*2*KQ,IF(AND(BodyType=3,PanelE2>=1),(PanelE2*2)*2*KQ,IF(AND(BodyType=4,PanelE2>=1),PanelE2*2*KQ,\"\"))))))","v":""}]
[]
[null,"Insert 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,2,"Insert Divider"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(AND(RetType>=2,Divdr=2,OR(BodyType=2,BodyType=3))),(SUM(H45,G47,G49,Q45,N47,N49,Z45,U47,U49)-1)*KQ,IF(AND(BodyType=1,Divdr=2),(SUM(H45,G47,G49,Q45,N47,N49,Z45,U47,U49)-1)*KQ,IF(AND(BodyType=2,Divdr=2),((SUM(H45,G47,G49,Q45,N47,N49,Z45,U47,U49)-1)*2)*KQ,IF(AND(BodyType=3,Divdr=2),((SUM(H45,G47,G49,Q45,N47,N49,Z45,U47,U49)-1)*2)*KQ,IF(AND(BodyType=4,Divdr=2),(SUM(H45,G47,G49,Q45,N47,N49,Z45,U47,U49)-1)*KQ,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(BodyType>=1,Divdr=2),Wdt-2.86,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(BodyType=1,Divdr=2),SUM(D52:D59)-1,IF(AND(BodyType=2,Divdr=2),SUM(D52:D59)-2,IF(AND(BodyType=3,Divdr=2),SUM(D52:D59)-2,IF(AND(BodyType=4,Divdr=2),SUM(D52:D59)-1,\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(BodyType>=1,Divdr=2),\"1668\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(BodyType>=1,Divdr=2),\" Insert 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.125,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,\" Select Seies 7 Single Face / Double Face Hinge Bodies or Series 12 Hinge Body\",\"\")))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Select Seies 7 Single Face / Double Face Hinge Bodies or Series 12 Hinge Body"]
[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.125,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 MATERIALS"]
[]
[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,"Reveal Postion",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(AF102:AH102)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(Hgt/36,0)+1","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(Wdt/36,0)+1","v":1},{"$f":"ROUNDUP(Hgt/36,0)+1","v":{"$error":"#VALUE!"}},"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(AND(BodyType=1,RetType=1),4*KQ,IF(AND(BodyType=2,RetType=1),8*KQ,IF(AND(BodyType=3,RetType=1),8*KQ,IF(AND(BodyType=4,RetType=1),4*KQ,IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),4*KQ,IF(AND(BodyType=3,RetType>=2),4*KQ,IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),\"5210\",IF(AND(BodyType=2,RetType=1),\"5210\",IF(AND(BodyType=3,RetType=1),\"5210\",IF(AND(BodyType=4,RetType=1),\"5210\",IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),\"5210\",IF(AND(BodyType=3,RetType>=2),\"5210\",IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),\" Corner Key - One (1) per corner\",IF(AND(BodyType=2,RetType=1),\" Corner Key - One (1) per corner\",IF(AND(BodyType=3,RetType=1),\" Corner Key - One (1) per corner\",IF(AND(BodyType=4,RetType=1),\" Corner Key - One (1) per corner\",IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),\" Corner Key - One (1) per corner (Insert Retainer /Access Frame)\",IF(AND(BodyType=3,RetType>=2),\" Corner Key - One (1) per corner (Insert Retainer /Access Frame)\",IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType>=1,RetType=1),\"\",IF(AND(BodyType=2,RetType>=2),8*KQ,IF(AND(BodyType=3,RetType>=2),8*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType>=1,RetType=1),\"\",IF(AND(BodyType=2,RetType>=2),\"5210\",IF(AND(BodyType=3,RetType>=2),\"5210\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType>=1,RetType=1),\"\",IF(AND(BodyType=2,RetType=2),\" Corner Key - Two (2) per corner - (Bleed Retainer)\",IF(AND(BodyType=3,RetType=2),\" Corner Key - Two (2) per corner - (Bleed Retainer)\",IF(AND(BodyType=2,RetType=3),\" Corner Key - Two (2) per corner - (Frameless Retainer)\",IF(AND(BodyType=3,RetType=3),\" Corner Key - Two (2) per corner - (Frameless Retainer)\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),10*KQ,IF(AND(BodyType=2,RetType=1),18*KQ,IF(AND(BodyType=3,RetType=1),18*KQ,IF(AND(BodyType=4,RetType=1),10*KQ,IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),10*KQ,IF(AND(BodyType=3,RetType>=2),10*KQ,IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),\"5270\",IF(AND(BodyType=2,RetType=1),\"5270\",IF(AND(BodyType=3,RetType=1),\"5270\",IF(AND(BodyType=4,RetType=1),\"5270\",IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),\"5270\",IF(AND(BodyType=3,RetType>=2),\"5270\",IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - Two (2) per corner\",IF(AND(BodyType=2,RetType=1),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - Two (2) per corner\",IF(AND(BodyType=3,RetType=1),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - Two (2) per corner\",IF(AND(BodyType=4,RetType=1),\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - Two (2) per corner\",IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),\" 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 - Two (2) per corner\",IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),(CvrSCR+2)*KQ,IF(AND(BodyType=2,RetType=1),((CvrSCR*2)+2)*KQ,IF(AND(BodyType=3,RetType=1),((CvrSCR*2)+2)*KQ,IF(AND(BodyType=4,RetType=1),(CvrSCR+2)*KQ,IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),(CvrSCR+2)*KQ,IF(AND(BodyType=3,RetType>=2),(CvrSCR+2)*KQ,IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),\"5168\",IF(AND(BodyType=2,RetType=1),\"5168\",IF(AND(BodyType=3,RetType=1),\"5168\",IF(AND(BodyType=4,RetType=1),\"5168\",IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),\"5168\",IF(AND(BodyType=3,RetType>=2),\"5168\",IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(BodyType=2,RetType=1),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(BodyType=3,RetType=1),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(BodyType=4,RetType=1),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(BodyType=3,RetType>=2),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","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":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(Hgt/12,0)+1","v":{"$error":"#VALUE!"}},null,{"$f":"ROUNDUP(Hgt/12,0)+1","v":{"$error":"#VALUE!"}},null,"Cover Screws"]
[]
[null,"Divider"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),DivdTab,IF(AND(BodyType=2,RetType=1),DivdTab,IF(AND(BodyType=3,RetType=1),DivdTab,IF(AND(BodyType=4,RetType=1),DivdTab,IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),DivdTab,IF(AND(BodyType=3,RetType>=2),DivdTab,IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),\"5306\",IF(AND(BodyType=2,RetType=1),\"5306\",IF(AND(BodyType=3,RetType=1),\"5306\",IF(AND(BodyType=4,RetType=1),\"5306\",IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),\"5306\",IF(AND(BodyType=3,RetType>=2),\"5306\",IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),\" Insert Divider Tab - 3/4'' x 2'' x .125'' Aluminum - Two (2) per Divider\",IF(AND(BodyType=2,RetType=1),\" Insert Divider Tab - 3/4'' x 2'' x .125'' Aluminum - Two (2) per Divider\",IF(AND(BodyType=3,RetType=1),\" Insert Divider Tab - 3/4'' x 2'' x .125'' Aluminum - Two (2) per Divider\",IF(AND(BodyType=4,RetType=1),\" Insert Divider Tab - 3/4'' x 2'' x .125'' Aluminum - Two (2) per Divider\",IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),\" Insert Divider Tab - 3/4'' x 2'' x .125'' Aluminum - Two (2) per Divider\",IF(AND(BodyType=3,RetType>=2),\" Insert Divider Tab - 3/4'' x 2'' x .125'' Aluminum - Two (2) per Divider\",IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","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":"Divid*2","v":{"$error":"#VALUE!"}},"Divider Tabs"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),DivdTab+2,IF(AND(BodyType=2,RetType=1),DivdTab+2,IF(AND(BodyType=3,RetType=1),DivdTab+2,IF(AND(BodyType=4,RetType=1),DivdTab+2,IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),DivdTab+2,IF(AND(BodyType=3,RetType>=2),DivdTab+2,IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),\"5168\",IF(AND(BodyType=2,RetType=1),\"5168\",IF(AND(BodyType=3,RetType=1),\"5168\",IF(AND(BodyType=4,RetType=1),\"5168\",IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),\"5168\",IF(AND(BodyType=3,RetType>=2),\"5168\",IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BodyType=1,RetType=1),\" Divider Tab Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(AND(BodyType=2,RetType=1),\" Divider Tab Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(AND(BodyType=3,RetType=1),\" Divider Tab Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(AND(BodyType=4,RetType=1),\" Divider Tab Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(AND(BodyType=1,RetType>=2),\"\",IF(AND(BodyType=2,RetType>=2),\" Divider Tab Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(AND(BodyType=3,RetType>=2),\" Divider Tab Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(AND(BodyType=4,RetType>=2),\"\",\"\"))))))))))","v":""}]
[]
[null,"Radius Ends"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(RadEnd=1,\"\",IF(POST=1,\"\",IF(BodyType=1,2*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 Cap 1/4 Round -  .125 Aluminum - 1-1/4'' Reveal Tab\",IF(BodyType=2,\" 1/2 Round End Cap  - .125 Aluminum\",IF(BodyType=3,\" 6'' Radius End Cap - .125 Aluminum - 1-1/4'' Reveal Tab\",IF(BodyType=4,\" Select Seies 7 Single Face / Double Face Hinge Bodies or Series 12 Hinge Body\",\"\")))))))","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(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(Ret=1,\"\",IF(RetType=2,Hgt-0.25,IF(RetType=3,Hgt+0.25,\"\")))))","v":""},null,"Height",null,null,"X",null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(RetType=2,Wdt-0.25,IF(RetType=3,Wdt+0.25,\"\")))))","v":""},null,"Width"]
[]
[null,null,"Face Material Thickness:",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(RetType=2,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",IF(RetType=3,\" .100 - .125 Flat Aluminum or 3mm ACM (Solid Core)\",\"\"))))","v":""}]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(AND(RetType>=2,OR(BodyType=1,BodyType=4)),\"\",IF(RetType>=2,\" It is recommended to oversize the panel and trim off with flush router\",\"\")))","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"]
[]
[null,"Plastic Panel Trim Size"]
[]
[null,null,{"$f":"IF(InstPnls=1,\"\",IF(AND(PlasPan=TRUE,PanelD>=1),PnlHgtD,\"\"))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(PlasPan=TRUE,PanelD>=1),\"Hgt\",\"\"))","v":""},"X",{"$f":"IF(InstPnls=1,\"\",IF(AND(AND(PlasPan=TRUE,PanelD>=1,EndCVR=1)),Wdt-0.25,IF(AND(AND(PlasPan=TRUE,PanelD>=1,EndCVR=2)),Wdt-0.125,\"\")))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(PlasPan=TRUE,PanelD>=1),\"Wdt\",\"\"))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(PlasPan=TRUE,PanelD1>=1),PnlHgtD1,\"\"))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(PlasPan=TRUE,PanelD>=1),\"Hgt\",\"\"))","v":""},"X",{"$f":"IF(InstPnls=1,\"\",IF(AND(AND(PlasPan=TRUE,PanelD1>=1,EndCVR=1)),Wdt-0.25,IF(AND(AND(PlasPan=TRUE,PanelD1>=1,EndCVR=2)),Wdt-0.125,\"\")))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(PlasPan=TRUE,PanelD>=1),\"Wdt\",\"\"))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(PlasPan=TRUE,PanelD2>=1),PnlHgtD2,\"\"))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(PlasPan=TRUE,PanelD>=1),\"Hgt\",\"\"))","v":""},"X",{"$f":"IF(InstPnls=1,\"\",IF(AND(AND(PlasPan=TRUE,PanelD2>=1,EndCVR=1)),Wdt-0.25,IF(AND(AND(PlasPan=TRUE,PanelD2>=1,EndCVR=2)),Wdt-0.125,\"\")))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(PlasPan=TRUE,PanelD>=1),\"Wdt\",\"\"))","v":""}]
[]
[null,"Aluminum Panel Trim Size"]
[]
[null,null,{"$f":"IF(InstPnls=1,\"\",IF(AND(AlumPan=TRUE,PanelE>=1),PnlHgtE,\"\"))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(AlumPan=TRUE,PanelE>=1),\"Hgt\",\"\"))","v":""},"X",{"$f":"IF(InstPnls=1,\"\",IF(AND(AND(AlumPan=TRUE,PanelE>=1,EndCVR=1)),Wdt-0.25,IF(AND(AND(AlumPan=TRUE,PanelE>=1,EndCVR=2)),Wdt-0.125,\"\")))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(AlumPan=TRUE,PanelE>=1),\"Wdt\",\"\"))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(AlumPan=TRUE,PanelE1>=1),PnlHgtE1,\"\"))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(AlumPan=TRUE,PanelE>=1),\"Hgt\",\"\"))","v":""},"X",{"$f":"IF(InstPnls=1,\"\",IF(AND(AND(AlumPan=TRUE,PanelE1>=1,EndCVR=1)),Wdt-0.25,IF(AND(AND(AlumPan=TRUE,PanelE1>=1,EndCVR=2)),Wdt-0.125,\"\")))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(AlumPan=TRUE,PanelE>=1),\"Wdt\",\"\"))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(AlumPan=TRUE,PanelE2>=1),PnlHgtE2,\"\"))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(AlumPan=TRUE,PanelE>=1),\"Hgt\",\"\"))","v":""},"X",{"$f":"IF(InstPnls=1,\"\",IF(AND(AND(AlumPan=TRUE,PanelE2>=1,EndCVR=1)),Wdt-0.25,IF(AND(AND(AlumPan=TRUE,PanelE2>=1,EndCVR=2)),Wdt-0.125,\"\")))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(AlumPan=TRUE,PanelE>=1),\"Wdt\",\"\"))","v":""}]