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

{"sheet":"Series 2-3-4 Insert Panels","index":0,"n_rows":142,"n_cols":41,"rows_kept":142,"cut":false,"hidden":false,"merged":[[16,6,16,16],[16,17,16,20],[16,21,16,28],[87,1,87,28],[134,1,134,28],[136,1,136,28],[38,5,38,6],[38,7,38,28],[48,1,48,28],[45,8,45,10],[21,23,21,28],[21,1,21,20],[127,1,127,28],[33,1,33,28],[126,1,126,28],[83,23,83,24],[83,18,83,22],[18,1,18,28],[128,1,128,28],[129,1,129,2],[129,15,129,28],[99,1,99,28],[100,1,100,28],[129,12,129,14],[140,1,140,28],[139,1,139,28],[141,10,141,11],[141,22,141,23],[137,10,137,11],[137,22,137,23],[138,1,138,28],[130,1,130,28],[131,2,131,7],[133,1,133,2],[132,1,132,28],[137,2,137,3],[137,6,137,7],[137,14,137,15],[137,18,137,19],[141,2,141,3],[141,6,141,7],[141,14,141,15],[141,18,141,19],[129,3,129,4],[129,5,129,7],[129,10,129,11],[129,8,129,9],[131,8,131,17],[28,33,28,34],[66,1,66,28],[64,2,64,3],[64,5,64,6],[64,7,64,28],[65,2,65,3],[65,5,65,6],[65,7,65,25],[61,1,61,28],[43,1,43,28],[29,1,29,28],[31,2,31,3],[32,2,32,3],[31,5,31,6],[32,5,32,6],[31,7,31,25],[32,7,32,25],[30,2,30,3],[30,5,30,6],[30,7,30,28],[39,30,39,32],[46,1,46,28],[56,2,56,3],[36,31,36,32],[1,1,1,28],[23,5,23,6],[23,7,23,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],[23,2,23,3],[10,5,10,6],[10,11,10,12],[2,1,2,28],[4,1,4,28],[7,1,7,25],[51,2,51,3],[53,2,53,3],[57,2,57,3],[57,5,57,6],[57,7,57,25],[49,27,49,28],[49,7,49,8],[7,26,13,26],[7,27,13,27],[7,28,13,28],[10,19,10,22],[12,1,12,17],[44,1,44,28],[39,2,39,3],[39,5,39,6],[39,7,39,25],[42,1,42,28],[40,2,40,3],[40,5,40,6],[40,7,40,25],[41,2,41,3],[41,5,41,6],[41,7,41,25],[27,1,27,28],[52,7,52,25],[53,7,53,25],[34,1,34,6],[10,23,10,24],[12,23,12,24],[8,18,8,24],[13,1,13,25],[10,7,10,10],[11,1,11,25],[16,1,16,5],[17,1,17,28],[38,2,38,3],[24,7,24,25],[25,2,25,3],[25,5,25,6],[25,7,25,25],[24,5,24,6],[24,2,24,3],[26,2,26,3],[26,5,26,6],[26,7,26,25],[49,9,49,10],[49,16,49,17],[50,1,50,28],[125,1,125,28],[123,1,123,28],[124,1,124,28],[28,6,28,28],[28,1,28,5],[36,1,36,28],[81,5,81,6],[20,1,20,28],[91,2,91,3],[98,2,98,3],[98,4,98,25],[55,2,55,3],[58,2,58,3],[59,2,59,3],[88,1,88,28],[81,7,81,10],[101,1,101,28],[55,5,55,6],[122,1,122,28],[102,2,102,3],[103,2,103,3],[104,2,104,3],[102,4,102,28],[103,4,103,25],[5,30,5,33],[96,28,98,28],[93,1,93,28],[94,1,94,28],[95,2,95,3],[95,4,95,28],[98,31,98,32],[45,17,45,19],[45,26,45,27],[45,1,45,6],[45,11,45,15],[52,5,52,6],[53,5,53,6],[52,2,52,3],[6,1,6,28],[9,1,9,25],[22,1,22,28],[21,21,21,22],[96,2,96,3],[96,4,96,25],[97,2,97,3],[97,4,97,25],[54,2,54,3],[12,18,12,22],[5,34,5,36],[5,37,5,38],[5,39,5,42],[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,4,90,25],[91,4,91,25],[34,33,34,34],[89,30,89,31],[8,30,8,33],[8,40,8,41],[51,5,51,6],[19,1,19,28],[51,7,51,28],[86,1,86,28],[43,31,43,32],[62,31,62,32],[55,7,55,25],[54,5,54,6],[112,1,112,28],[58,5,58,6],[59,5,59,6],[54,7,54,25],[72,1,72,28],[73,1,73,28],[74,1,74,28],[81,1,81,4],[63,1,63,28],[62,1,62,28],[60,2,60,3],[60,5,60,6],[85,1,85,28],[81,11,81,12],[60,7,60,25],[56,5,56,6],[56,7,56,25],[58,7,58,25],[59,7,59,25],[105,35,105,36],[106,1,106,28],[107,1,107,28],[108,1,108,28],[109,2,109,3],[109,4,109,28],[110,2,110,3],[110,4,110,25],[110,28,111,28],[110,31,110,32],[105,2,105,3],[105,4,105,25],[103,28,105,28],[111,2,111,3],[111,4,111,25],[104,4,104,25],[98,33,98,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],[90,2,90,3],[87,32,87,33],[81,13,81,16],[81,17,81,18],[81,19,81,22],[81,23,81,24],[83,1,83,17],[47,23,47,24],[49,23,49,24],[47,25,47,26],[49,25,49,26],[47,27,47,28],[34,7,34,10],[34,11,34,28],[35,1,35,28],[37,1,37,28],[47,7,47,8],[47,11,47,12],[49,11,49,12],[47,14,47,15],[49,14,49,15],[47,18,47,19],[49,18,49,19],[47,21,47,22],[49,21,49,22],[45,20,45,24],[47,9,47,10],[47,16,47,17]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"AE6&AI6&AL6&AN6&AE9&AM9&AO9","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(PST=1,\" Series 2, Square Post\",IF(PST=2,\" Series 3, Square Post\",IF(PST=3,\" Series 3, Round Post\",IF(PST=4,\" Series 3, Rectangular Post\",IF(PST=5,\" Series 3, Radius Post\",IF(PST=6,\" Series 3, Triangular Post\",IF(PST=7,\" Series 3, Sq Post w/Rad Edges\",IF(PST=8,\" Series 3, Rec Post w/Rad Edges\",IF(PST=9,\" Series 3, Triangular Post w/Rad Edges\",IF(PST=10,\" Series 4, Round Post\",IF(PST=11,\" Series 4, Square 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(AND(PST=10,RVLSET>=1),\" - 3/4'' Reveal\",IF(RVLSET=1,\" - Zero Reveal\",IF(RVLSET=2,\" - 3/8'' Reveal\",IF(RVLSET=3,\" - 3/4'' Reveal\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"Series 3, S/F Access Body\",IF(BodyType=2,\"Series 3, Access Body\",IF(BodyType=3,\"Series 4, S/F Access Body\",IF(BodyType=4,\"Series 4, Access 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 Top/Bottom Cover\",\"\"))))","v":""},null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(RetType=2,\" 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(AK46,AL46,AM46,AG48,AH48,AI48,AG50,AH50,AI50)+0.25)","v":""},null," Cabinet Width",null,null,null,0,null,"Grade to Top",null,null,null,0]
[]
[null,"Enter Fractions as Decimals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,null,null,null,null,null,null,"Reveal Position",null,null,null,null,null,null,null,null,null,null,null,null,2,"Posts",2,"Mount",2,"Post Type"]
[null,"Post Type"]
[]
[]
[]
[null,"Post Length",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102,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,RetType=1),\"\",IF(MNT=1,1*KQ,IF(MNT=2,KQ*2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,RetType=1),\"\",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,RetType=1),\"\",IF(PST=1,\"1100\",IF(AND(AND(PST=2,LNGTH=10,PSTLNT=72)),\"1233\",IF(AND(AND(AND(PST=2,LNGTH=10,PSTLNT>=73,PSTLNT<=96))),\"1233-8'\",IF(AND(AND(PST=2,LNGTH=10,PSTLNT>=97)),\"1233\",IF(AND(PST=2,LNGTH=2),\"1233-8'\",IF(AND(PST=2,LNGTH=3),\"1233-8'\",IF(PST=2,\"1233\",IF(PST=3,\"1237\",IF(PST=4,\"1220\",IF(PST=5,\"1210\",IF(PST=6,\"1240\",IF(PST=7,\"1235\",IF(PST=8,\"1230\",IF(PST=9,\"1250\",IF(PST=10,\"1337\",IF(PST=11,\"1333\",\"\")))))))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,RetType=1),\" Select '' No Posts ''\",IF(AND(PST=1,MNT=1),\" Series 2, 2'' Square Post - Single Post Flag Mounted - Straight Cut Both Ends\",IF(AND(PST=2,MNT=1),\" Series 3, 3-1/4'' Square Post - Single Post Flag Mounted - Straight Cut Both Ends\",IF(AND(PST=3,MNT=1),\" Series 3, 3-1/4'' Round Post - Single Post Flag Mounted - Straight Cut Both Ends\",IF(AND(PST=4,MNT=1),\" Series 3, 3-1/4'' Rectangular Post - Single Post Flag Mounted - Straight Cut Both Ends\",IF(AND(PST=5,MNT=1),\" Series 3, 3-1/4'' Radius Post - Single Post Flag Mounted - Straight Cut Both Ends\",IF(AND(PST=6,MNT=1),\" Series 3, 3-1/4'' Triangular Post - Single Post Flag Mounted - Straight Cut Both Ends\",IF(AND(PST=7,MNT=1),\" Series 3, 3-1/4'' Square Post w/Radius Edges - Single Post Flag Mounted - Straight Cut Both Ends\",IF(AND(PST=8,MNT=1),\" Series 3, 3-1/4'' Rectangular Post w/Radius Edges - Single Post Flag Mounted - Straight Cut Both Ends\",IF(AND(PST=9,MNT=1),\" Series 3, 3-1/4'' Triangular Post w/Radius Edges - Single Post Flag Mounted - Straight Cut Both Ends\",IF(AND(PST=10,MNT=1),\" Series 4, 4'' Round Post - Single Post Flag Mounted - Straight Cut Both Ends\",IF(AND(PST=11,MNT=1),\" Series 4, 4'' Square Post - Single Post Flag Mounted - Straight Cut Both Ends\",IF(AND(PST=1,MNT=2),\" Series 2, 2'' Square Post - Double Post Mounted - Straight Cut Both Ends\",IF(AND(PST=2,MNT=2),\" Series 3, 3-1/4'' Square Post - Double Post Mounted - Straight Cut Both Ends\",IF(AND(PST=3,MNT=2),\" Series 3, 3-1/4'' Round Post - Double Post Mounted - Straight Cut Both Ends\",IF(AND(PST=4,MNT=2),\" Series 3, 3-1/4'' Rectangular Post - Double Post Mounted - Straight Cut Both Ends\",IF(AND(PST=5,MNT=2),\" Series 3, 3-1/4'' Radius Post - Double Post Mounted - Straight Cut Both Ends\",IF(AND(PST=6,MNT=2),\" Series 3, 3-1/4'' Triangular Post - Double Post Mounted - Straight Cut Both Ends\",IF(AND(PST=7,MNT=2),\" Series 3, 3-1/4'' Square Post w/Radius Edges - Double Post Mounted - Straight Cut Both Ends\",IF(AND(PST=8,MNT=2),\" Series 3, 3-1/4'' Rectangular Post w/Radius Edges - Double Post Mounted - Straight Cut Both Ends\",IF(AND(PST=9,MNT=2),\" Series 3, 3-1/4'' Triangular Post w/Radius Edges - Double Post Mounted - Straight Cut Both Ends\",IF(AND(PST=10,MNT=2),\" Series 4, 4'' Round Post - Double Post Mounted - Straight Cut Both Ends\",IF(AND(PST=11,MNT=2),\" Series 4, 4'' Square Post - Double Post Mounted - Straight Cut Both Ends\",\"\")))))))))))))))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(BOD=1,\"\",IF(AND(POST=1,RetType=1),\"\",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,RetType=1),\"\",IF(BOD=1,\"\",IF(PST>=1,Hgt-0.125,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,RetType=1),\"\",IF(BOD=1,\"\",IF(PST>=1,\"1200\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(BOD=1,\"\",IF(AND(POST=1,RetType=1),\"\",IF(AND(MNT=1,PST>=1),\" Series 2/3/4 Reveal - (Body Reveal attached to one end/side, 1/8'' down from top of cabinet)\",IF(AND(MNT=2,PST>=1),\" Series 2/3/4 Reveal - (Body Reveal attached to both ends/sides, 1/8'' down from top of cabinet)\",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,RetType=1),\"\",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,RetType=1),\"\",IF(PST>=1,CTG+6,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,RetType=1),\"\",IF(OR(PST=3,PST=10),\"1201\",IF(PST>=1,\"1200\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(POST=1,RetType=1),\"\",IF(OR(PST=3,PST=10),\" Series 3/4 Round Post Filler - (Below the cabinet/panel post filler)\",IF(PST>=1,\" Series 2/3/4 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(RetType=1,\"\",IF(OR(BodyType>=1,BodyType<=4),2*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RetType=1,\"\",IF(OR(BodyType>=1,BodyType<=2),Wdt,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RetType=1,\"\",IF(BodyType=1,\"1291\",IF(BodyType=2,\"1290\",IF(BodyType=3,\"1391\",IF(BodyType=4,\"1390\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RetType=1,\" Select ''No'' Body or ''Insert Top/Bottom Cover''\",IF(BodyType=1,\" Series 3, Single Face Access Body - Mitred both ends - Top and Bottom\",IF(BodyType=2,\" Series 3, Access Body - Mitered both ends - Top and Bottom\",IF(BodyType=3,\" Series 4, Single Face Access Body - Mitred both ends - Top and Bottom\",IF(BodyType=4,\" Series 4, Access Body - Mitered both ends - Top and Bottom\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RetType=1,\"\",IF(OR(BodyType>=1,BodyType<=2),2*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RetType=1,\"\",IF(OR(BodyType>=1,BodyType<=2),Hgt,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RetType=1,\"\",IF(BodyType=1,\"1291\",IF(BodyType=2,\"1290\",IF(BodyType=3,\"1391\",IF(BodyType=4,\"1390\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RetType=1,\"\",IF(BodyType=1,\" Series 3, Single Face Access Body - Mitred both ends - Ends/Sides\",IF(BodyType=2,\" Series 3, Access Body - Mitered both ends - Ends/Sides\",IF(BodyType=3,\" Series 4, Single Face Access Body - Mitred both ends - Ends/Sides\",IF(BodyType=4,\" Series 4, Access 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",2,"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(BOD=2,RetType=1),\"\",IF(AND(AND(BOD=2,BodyType=1,RetType=2)),2*KQ,IF(AND(AND(BOD=2,BodyType=2,RetType=2)),4*KQ,IF(AND(AND(BOD=2,BodyType=3,RetType=2)),2*KQ,IF(AND(AND(BOD=2,BodyType=4,RetType=2)),4*KQ,IF(RetType=1,2*KQ,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=1),\"\",IF(AND(BOD=2,OR(BodyType>=1,BodyType<=2)),Wdt+0.03125,IF(RetType=1,Wdt,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=1),\"\",IF(AND(BOD=2,RetType=2),\"1292\",IF(RetType=1,\"1666\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=1),\" Select ''No'' Body or ''Insert Top/Bottom Cover''\",IF(AND(BOD=2,RetType=2),\" Insert Top/Bottom Cover - Mitered Both Ends - Top and Bottom\",IF(RetType=1,\" 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 ''No'' Body or ''Insert Top/Bottom Cover''"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=1),\"\",IF(RetType=2,\"\",IF(RetType=1,2*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=1),\"\",IF(RetType=2,\"\",IF(RetType=1,Hgt,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=1),\"\",IF(RetType=2,\"\",IF(RetType=1,\"1690\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=1),\"\",IF(RetType=2,\"\",IF(RetType=1,\" Access Frame - Mitered Both Ends - Top and Bottom\",\"\")))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=1),\"\",IF(AND(AND(BOD=2,BodyType=1,RetType=2)),2*KQ,IF(AND(AND(BOD=2,BodyType=2,RetType=2)),4*KQ,IF(AND(AND(BOD=2,BodyType=3,RetType=2)),2*KQ,IF(AND(AND(BOD=2,BodyType=4,RetType=2)),4*KQ,IF(RetType=1,2*KQ,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=1),\"\",IF(AND(AND(BOD=2,BodyType=1,RetType=2)),Hgt+0.03125,IF(AND(AND(BOD=2,BodyType=2,RetType=2)),Hgt+0.03125,IF(AND(AND(BOD=2,BodyType=3,RetType=2)),Hgt+0.03125,IF(AND(AND(BOD=2,BodyType=4,RetType=2)),Hgt,IF(RetType=1,Hgt+0.03125,\"\"))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=1),\"\",IF(AND(AND(AND(BOD=2,BodyType=1,RetType=2,EndCVR=1))),\"1696\",IF(AND(AND(AND(BOD=2,BodyType=1,RetType=2,EndCVR=2))),\"1698\",IF(AND(AND(AND(BOD=2,BodyType=2,RetType=2,EndCVR=1))),\"1696\",IF(AND(AND(AND(BOD=2,BodyType=2,RetType=2,EndCVR=2))),\"1698\",IF(AND(AND(AND(BOD=2,BodyType=3,RetType=2,EndCVR=1))),\"1696\",IF(AND(AND(AND(BOD=2,BodyType=3,RetType=2,EndCVR=2))),\"1698\",IF(AND(AND(AND(BOD=2,BodyType=4,RetType=2,EndCVR=1))),\"1696\",IF(AND(AND(AND(BOD=2,BodyType=4,RetType=2,EndCVR=2))),\"1698\",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(BOD=2,RetType=1),\"\",IF(AND(AND(AND(BOD=2,BodyType=1,RetType=2,EndCVR=1))),\" Insert End Cover - Mitered Both Ends - Sides/Ends\",IF(AND(AND(AND(BOD=2,BodyType=1,RetType=2,EndCVR=2))),\" Extended Insert End Cover - Mitered Both Ends - Sides/Ends\",IF(AND(AND(AND(BOD=2,BodyType=2,RetType=2,EndCVR=1))),\" Insert End Cover - Mitered Both Ends - Sides/Ends\",IF(AND(AND(AND(BOD=2,BodyType=2,RetType=2,EndCVR=2))),\" Extended Insert End Cover - Mitered Both Ends - Sides/Ends\",IF(AND(AND(AND(BOD=2,BodyType=3,RetType=2,EndCVR=1))),\" Insert End Cover - Mitered Both Ends - Sides/Ends\",IF(AND(AND(AND(BOD=2,BodyType=3,RetType=2,EndCVR=2))),\" Extended Insert End Cover - Mitered Both Ends - Sides/Ends\",IF(AND(AND(AND(BOD=2,BodyType=4,RetType=2,EndCVR=1))),\" Insert End Cover - Mitered Both Ends - Sides/Ends\",IF(AND(AND(AND(BOD=2,BodyType=4,RetType=2,EndCVR=2))),\" Extended Insert End Cover - Mitered Both Ends - Sides/Ends\",IF(AND(RetType=1,EndCVR=1),\" Insert End Cover - Mitered Both Ends - Sides/Ends\",IF(AND(RetType=1,EndCVR=2),\" Extended Insert End Cover - Mitered Both Ends - Sides/Ends\",\"\")))))))))))))","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(PanelA=0,\"\",IF(InstPnls=1,\"\",IF(AND(BodyType=1,PanelA>=1),PanelA*KQ,IF(AND(BodyType=2,PanelA>=1),PanelA*2*KQ,IF(AND(BodyType=3,PanelA>=1),PanelA*KQ,IF(AND(BodyType=4,PanelA>=1),PanelA*2*KQ,\"\")))))))","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,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",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*KQ,IF(AND(BodyType=4,PanelB>=1),PanelB*2*KQ,\"\")))))))","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,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",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*KQ,IF(AND(BodyType=4,PanelC>=1),PanelC*2*KQ,\"\")))))))","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,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",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*KQ,IF(AND(BodyType=4,PanelD>=1),(PanelD*2)*2*KQ,\"\")))))))","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,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",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*KQ,IF(AND(BodyType=4,PanelD1>=1),(PanelD1*2)*2*KQ,\"\")))))))","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,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",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*KQ,IF(AND(BodyType=4,PanelD2>=1),(PanelD2*2)*2*KQ,\"\")))))))","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,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",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*KQ,IF(AND(BodyType=4,PanelE>=1),(PanelE*2)*2*KQ,\"\")))))))","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,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",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*KQ,IF(AND(BodyType=4,PanelE1>=1),(PanelE1*2)*2*KQ,\"\")))))))","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,{"$f":"IF(KQ=0,\"\",IF(InstPnls=1,\"\",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*KQ,IF(AND(BodyType=4,PanelE2>=1),(PanelE2*2)*2*KQ,\"\")))))))","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,"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(AND(BodyType=1,RetType=2,Divdr=2))),(SUM(H46,G48,G50,Q46,N48,N50,Z46,U48,U50)-1)*KQ,IF(AND(AND(AND(BodyType=2,RetType=2,Divdr=2))),((SUM(H46,G48,G50,Q46,N48,N50,Z46,U48,U50)-1)*2)*KQ,IF(AND(AND(AND(BodyType=3,RetType=2,Divdr=2))),(SUM(H46,G48,G50,Q46,N48,N50,Z46,U48,U50)-1)*KQ,IF(AND(AND(AND(BodyType=4,RetType=2,Divdr=2))),((SUM(H46,G48,G50,Q46,N48,N50,Z46,U48,U50)-1)*2)*KQ,IF(AND(AND(AND(BOD=1,RetType=1,Divdr=2))),(SUM(H46,G48,G50,Q46,N48,N50,Z46,U48,U50)-1)*KQ,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(AND(AND(BOD=2,RetType=1,Divdr=2))),\"\",IF(AND(AND(AND(BOD=1,RetType=1,Divdr=2))),Wdt-2.86,IF(AND(BodyType>=1,Divdr=2),Wdt-2.86,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(BodyType=1,Divdr=2),SUM(D53:D60)-1,IF(AND(BodyType=2,Divdr=2),SUM(D53:D60)-2,IF(AND(BodyType=3,Divdr=2),SUM(D53:D60)-2,IF(AND(BodyType=4,Divdr=2),SUM(D53:D60)-1,\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(AND(AND(BOD=2,RetType=1,Divdr=2))),\"\",IF(AND(AND(AND(BOD=1,RetType=1,Divdr=2))),\"1668\",IF(AND(BodyType>=1,Divdr=2),\"1668\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divdr=1,\"\",IF(AND(AND(AND(BOD=2,RetType=1,Divdr=2))),\" Select ''No'' Body or ''Insert Top/Bottom Cover''\",IF(AND(AND(AND(BOD=1,RetType=1,Divdr=2))),\" Insert Divider - Straight Cut Both Ends\",IF(AND(BodyType>=1,Divdr=2),\" Insert Divider - Straight Cut Both Ends\",\"\")))))","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Reveal"," Select 3/4'' Reveal"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$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),\"5260\",IF(AND(PST=1,RVLSET=2),\"5261\",IF(AND(PST=1,RVLSET=3),\"5262\",IF(AND(PST=2,RVLSET=1),\"5405\",IF(AND(PST=2,RVLSET=2),\"5406\",IF(AND(PST=2,RVLSET=3),\"5407\",IF(AND(PST=3,RVLSET=1),\"5415\",IF(AND(PST=3,RVLSET=2),\"5416\",IF(AND(PST=3,RVLSET=3),\"5417\",IF(AND(PST=4,RVLSET=1),\"5010\",IF(AND(PST=4,RVLSET=2),\"5012\",IF(AND(PST=4,RVLSET=3),\"5014\",IF(AND(PST=5,RVLSET=1),\"5000\",IF(AND(PST=5,RVLSET=2),\"5002\",IF(AND(PST=5,RVLSET=3),\"5004\",IF(AND(PST=6,RVLSET=1),\"5015\",IF(AND(PST=6,RVLSET=2),\"5016\",IF(AND(PST=6,RVLSET=3),\"5017\",IF(AND(PST=7,RVLSET=1),\"5410\",IF(AND(PST=7,RVLSET=2),\"5411\",IF(AND(PST=7,RVLSET=3),\"5412\",IF(AND(PST=8,RVLSET=1),\"5006\",IF(AND(PST=8,RVLSET=2),\"5007\",IF(AND(PST=8,RVLSET=3),\"5008\",IF(AND(PST=9,RVLSET=1),\"5400\",IF(AND(PST=9,RVLSET=2),\"5401\",IF(AND(PST=9,RVLSET=3),\"5402\",IF(AND(PST=10,RVLSET<=3),\"5430\",IF(AND(PST=11,RVLSET<=3),\"5433\",\"\")))))))))))))))))))))))))))))))","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 2, Square Post Cap\",IF(PST=2,\" Series 3, Square Post Cap\",IF(PST=3,\" Series 3, Round Post Cap\",IF(PST=4,\" Series 3, Rectangular Post Cap\",IF(PST=5,\" Series 3, Radius Post Cap\",IF(PST=6,\" Series 3, Triangular Post Cap\",IF(PST=7,\" Series 3, Sq. Post Cap w/Radius Edges\",IF(PST=8,\" Series 3, Rec. Post Cap w/Radius Edges\",IF(PST=9,\" Series 3, Triangular Post Cap w/Radius Edges\",IF(PST=10,\" Series 4, Round Post Cap\",IF(PST=11,\" Series 4, Square Post Cap\",\"\")))))))))))","v":" Series 3, Square Post Cap"},null,null,null,null,{"$f":"IF(AND(PST>=10,RVLSET>=1),\" - 3/4'' Reveal - Trim to fit 3/8'' and Zero Reveal\",IF(RVLSET=1,\" - Zero Reveal\",IF(RVLSET=2,\" - 3/8'' Reveal\",IF(RVLSET=3,\" - 3/4'' Reveal\",\"\"))))","v":" - Zero Reveal"}]
[null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=6,MNT=1),4*KQ,IF(AND(PST=6,MNT=2),7*KQ,IF(MNT=1,3*KQ,IF(MNT=2,5*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST>=1,PST<=11),\"5040\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(POST=2,\"\",IF(AND(PST=6,MNT>=1),\" Cap Screw - #10 x 1/2 S.S. Countersink Sq./Phillips screw - Type A - Three (3) per Post Cap\",IF(AND(PST>=1,MNT>=1),\" Cap Screw - #10 x 1/2 S.S. Countersink Sq./Phillips screw - Type A - Two (2) per Post Cap\",\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MNT=1,\" - Single Post Flag Mounted\",IF(MNT=2,\" - Double Post Mounted\",\"\"))","v":" - Double Post Mounted"},null,null,null,null,{"$f":"IF(MNT=1,\" - One (1) Cap Per Post\",IF(MNT=2,\" - One (1) Cap Per Post\",\"\"))","v":" - One (1) Cap Per Post"}]
[]
[null,"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,4*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"5338\",IF(BodyType=2,\"5339\",IF(BodyType=3,\"5340\",IF(BodyType=4,\"5340\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 3 Single Face Access Body Corner Angle - 2'' x 2'' x 1/8'' (1-1/2'') - One (1) per corner\",IF(BodyType=2,\" Series 3 Double Face Access Body Corner Angle - 2'' x 2'' x 1/8'' (1-5/16'') - One (1) per corner\",IF(BodyType=3,\" Series 4 Single Face Access Body Corner Angle - 2'' x 2'' x 1/8'' (2'') - One (1) per corner\",IF(BodyType=4,\" Series 4 Access Body Corner Angle - 2'' x 2'' x 1/8'' (2'') - One (1) per corner\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,10*KQ,IF(BodyType=2,10*KQ,IF(BodyType=3,10*KQ,IF(BodyType=4,10*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"5270\",IF(BodyType=2,\"5270\",IF(BodyType=3,\"5270\",IF(BodyType=4,\"5270\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Series 3 S/F Access Body Corner Screw - #8 x 1-1/2'' S.S. Sq/Phillips Countersink Screw - Two (2) per corner\",IF(BodyType=2,\" Series 3 Access Body Corner Screw - #8 x 1-1/2'' S.S. Sq/Phillips Countersink Screw - Two (2) per corner\",IF(BodyType=3,\" Series 4 S/F Access Body Corner Screw - #8 x 1-1/2'' S.S. Sq/Phillips Countersink Screw - Two (2) per corner\",IF(BodyType=4,\" Series 4 Access Body Corner Screw - #8 x 1-1/2'' S.S. Sq/Phillips Countersink Screw - Two (2) per corner\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(POST=2,\"\",IF(AND(POST=1,MNT=1),REVSCR*KQ,IF(AND(POST=1,MNT=2),REVSCR*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(POST=2,\"\",IF(BodyType=5,\"\",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,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,"Retainer"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=2),\"\",IF(RetType=1,4*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=2),\"\",IF(RetType=1,\"5210\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=2),\"\",IF(RetType=1,\" Corner Key - One (1) per corner\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=2),\"\",IF(RetType=1,8*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=2),\"\",IF(RetType=1,\"5270\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(BOD=2,RetType=2),\"\",IF(RetType=1,\" Retainer Corner Screw - #8 x 1-1/2'' Sq/Phillips countersink screw - Two (2) per corner\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(BOD=2,BodyType=1,RetType=2)),CvrSCR*KQ,IF(AND(AND(BOD=2,BodyType=2,RetType=2)),(CvrSCR*2)*KQ,IF(AND(AND(BOD=2,BodyType=3,RetType=2)),CvrSCR*KQ,IF(AND(AND(BOD=2,BodyType=4,RetType=2)),(CvrSCR*2)*KQ,IF(RetType=1,CvrSCR*KQ,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(BOD=2,BodyType=1,RetType=2)),\"5168\",IF(AND(AND(BOD=2,BodyType=2,RetType=2)),\"5168\",IF(AND(AND(BOD=2,BodyType=3,RetType=2)),\"5168\",IF(AND(AND(BOD=2,BodyType=4,RetType=2)),\"5168\",IF(RetType=1,\"5168\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(BOD=2,BodyType=1,RetType=2)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BOD=2,BodyType=2,RetType=2)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BOD=2,BodyType=3,RetType=2)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(AND(AND(BOD=2,BodyType=4,RetType=2)),\" Cover Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) every 12'' on center\",IF(RetType=1,\" 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(AF106:AI106)+2","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(Hgt/12,0)+1","v":{"$error":"#VALUE!"}},{"$f":"IF(RetType=1,0,ROUNDUP(Wdt/12,0)+1)","v":1},{"$f":"ROUNDUP(Hgt/12,0)+1","v":{"$error":"#VALUE!"}},{"$f":"IF(RetType=1,0,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(AND(AND(BOD=2,BodyType=1,RetType=2)),DivdTab,IF(AND(AND(BOD=2,BodyType=2,RetType=2)),DivdTab,IF(AND(AND(BOD=2,BodyType=3,RetType=2)),DivdTab,IF(AND(AND(BOD=2,BodyType=4,RetType=2)),DivdTab,IF(RetType=1,DivdTab,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(BOD=2,BodyType=1,RetType=2)),\"5306\",IF(AND(AND(BOD=2,BodyType=2,RetType=2)),\"5306\",IF(AND(AND(BOD=2,BodyType=3,RetType=2)),\"5306\",IF(AND(AND(BOD=2,BodyType=4,RetType=2)),\"5306\",IF(RetType=1,\"5306\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(BOD=2,BodyType=1,RetType=2)),\" Insert Divider Tab - 3/4'' x 2'' x .125'' Aluminum - Two (2) per Divider\",IF(AND(AND(BOD=2,BodyType=2,RetType=2)),\" Insert Divider Tab - 3/4'' x 2'' x .125'' Aluminum - Two (2) per Divider\",IF(AND(AND(BOD=2,BodyType=3,RetType=2)),\" Insert Divider Tab - 3/4'' x 2'' x .125'' Aluminum - Two (2) per Divider\",IF(AND(AND(BOD=2,BodyType=4,RetType=2)),\" Insert Divider Tab - 3/4'' x 2'' x .125'' Aluminum - Two (2) per Divider\",IF(RetType=1,\" Insert Divider Tab - 3/4'' x 2'' x .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":"Divid*2","v":{"$error":"#VALUE!"}},"Divider Tabs"]
[null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(BOD=2,BodyType=1,RetType=2)),DivdTab,IF(AND(AND(BOD=2,BodyType=2,RetType=2)),DivdTab,IF(AND(AND(BOD=2,BodyType=3,RetType=2)),DivdTab,IF(AND(AND(BOD=2,BodyType=4,RetType=2)),DivdTab,IF(RetType=1,DivdTab,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(BOD=2,BodyType=1,RetType=2)),\"5168\",IF(AND(AND(BOD=2,BodyType=2,RetType=2)),\"5168\",IF(AND(AND(BOD=2,BodyType=3,RetType=2)),\"5168\",IF(AND(AND(BOD=2,BodyType=4,RetType=2)),\"5168\",IF(RetType=1,\"5168\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Ret=1,\"\",IF(AND(AND(BOD=2,BodyType=1,RetType=2)),\" Divider Tab Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(AND(AND(BOD=2,BodyType=2,RetType=2)),\" Divider Tab Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(AND(AND(BOD=2,BodyType=3,RetType=2)),\" Divider Tab Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(AND(AND(BOD=2,BodyType=4,RetType=2)),\" Divider Tab Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",IF(RetType=1,\" Divider Tab Screw - #8 x 1/2'' Sq/Phillips countersink screw - One (1) per Divider Tab\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Face Trim Size"]
[]
[null,"Back for Single Face Accerss Body - (Not Included in kit)"]
[]
[null,"Back Trim Size"]
[]
[null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,Hgt-0.375,IF(BodyType=2,\"\",IF(BodyType=3,Hgt-0.375,IF(BodyType=4,\"\",\"\"))))))","v":""},null,"Height",null,null,"X",null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,Wdt-0.375,IF(BodyType=2,\"\",IF(BodyType=3,Wdt-0.375,IF(BodyType=4,\"\",\"\"))))))","v":""},null,"Width"]
[]
[null,null,"Face Material Thickness:",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BodyType=1,\" .040 to .060 Flat Aluminum\",\"\"))","v":""}]
[]
[]
[]
[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,PanelD1>=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,PanelD1>=1),\"Wdt\",\"\"))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(PlasPan=TRUE,PanelD1>=1),PnlHgtD2,\"\"))","v":""},null,{"$f":"IF(InstPnls=1,\"\",IF(AND(PlasPan=TRUE,PanelD1>=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,PanelD1>=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":""}]