{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Menu","Pricing","Gas Support"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":1,"defined_names":71,"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":"Menu","index":0,"n_rows":117,"n_cols":63,"rows_kept":117,"cut":false,"hidden":false,"merged":[[90,2,90,3],[90,4,90,25],[105,8,105,9],[105,11,105,12],[115,8,115,9],[115,11,115,12],[98,15,98,20],[97,8,97,9],[97,11,97,12],[100,8,100,9],[100,11,100,12],[98,24,98,25],[98,21,98,22],[97,21,97,22],[97,24,97,25],[93,1,93,28],[94,2,94,3],[94,4,94,25],[100,2,100,7],[102,2,102,7],[96,2,96,8],[98,8,98,9],[98,11,98,12],[98,2,98,7],[100,15,100,20],[100,24,100,25],[100,21,100,22],[102,21,102,22],[62,7,62,25],[92,31,92,32],[37,1,37,5],[54,5,54,6],[51,5,51,6],[54,7,54,25],[51,7,51,25],[51,2,51,3],[57,1,57,28],[54,2,54,3],[50,7,50,25],[39,7,39,28],[48,2,48,3],[61,1,61,28],[62,2,62,3],[58,2,58,3],[55,1,55,28],[59,1,59,28],[60,1,60,28],[56,1,56,28],[62,31,62,32],[63,31,63,32],[64,31,64,32],[65,31,65,32],[58,5,58,6],[58,7,58,25],[92,4,92,25],[76,14,76,17],[11,30,11,32],[77,5,77,6],[88,28,89,28],[81,4,81,25],[85,1,85,28],[64,2,64,3],[64,5,64,6],[64,7,64,25],[69,1,69,28],[77,13,77,16],[72,1,72,28],[87,1,87,28],[76,5,76,13],[76,26,76,28],[65,2,65,3],[71,1,71,28],[11,34,11,36],[25,30,25,31],[16,30,16,32],[18,30,18,32],[20,30,20,32],[20,34,20,36],[22,34,22,36],[22,30,22,32],[62,5,62,6],[48,5,48,6],[37,35,37,36],[52,1,52,28],[53,2,53,3],[53,5,53,6],[53,7,53,25],[47,31,47,32],[48,31,48,32],[51,31,51,32],[35,7,35,25],[35,5,35,6],[35,2,35,3],[46,5,46,6],[50,2,50,3],[14,30,14,32],[8,26,10,26],[8,27,10,27],[11,1,11,28],[26,1,26,28],[30,5,30,6],[29,2,29,3],[29,5,29,6],[33,1,33,28],[30,7,30,25],[1,1,1,28],[28,5,28,6],[28,7,28,28],[8,18,8,25],[9,1,9,4],[5,1,5,28],[6,1,6,28],[3,1,3,28],[8,1,8,4],[8,5,8,13],[10,1,10,18],[9,17,9,18],[9,19,10,25],[28,2,28,3],[9,5,9,6],[8,14,8,17],[2,1,2,28],[7,1,7,28],[9,7,9,10],[23,2,23,6],[25,2,25,6],[21,8,21,14],[23,8,23,14],[25,8,25,14],[77,17,77,18],[77,19,77,28],[77,1,77,4],[78,1,78,28],[80,1,80,28],[83,1,83,28],[4,1,4,28],[8,28,10,28],[12,1,12,28],[63,7,63,25],[65,5,65,6],[65,7,65,25],[43,1,43,28],[44,1,44,28],[82,2,82,3],[79,1,79,28],[81,2,81,3],[82,4,82,25],[34,2,34,3],[29,7,29,25],[76,18,76,25],[74,1,74,28],[9,11,9,12],[9,13,9,16],[77,11,77,12],[75,1,75,28],[63,2,63,3],[63,5,63,6],[30,2,30,3],[36,1,36,28],[116,2,116,7],[116,11,116,12],[116,8,116,9],[41,2,41,3],[41,5,41,6],[41,7,41,25],[102,15,102,20],[102,8,102,9],[102,11,102,12],[91,1,91,28],[92,2,92,3],[98,26,98,27],[100,26,100,27],[102,26,102,27],[81,28,82,28],[77,7,77,10],[86,2,86,3],[86,4,86,25],[14,34,14,36],[21,16,21,19],[21,20,21,21],[21,22,21,25],[21,26,21,27],[23,16,23,19],[23,20,23,21],[32,30,32,32],[34,30,34,32],[27,1,27,28],[25,16,25,19],[21,2,21,6],[25,20,25,21],[31,1,31,28],[34,7,34,28],[42,30,42,32],[37,30,37,32],[40,5,40,6],[70,1,70,28],[106,2,106,7],[108,2,108,7],[114,2,114,8],[84,4,84,25],[104,2,104,8],[106,11,106,12],[106,8,106,9],[108,11,108,12],[108,8,108,9],[110,11,110,12],[110,8,110,9],[88,2,88,3],[88,4,88,25],[89,2,89,3],[89,4,89,25],[110,2,110,7],[84,2,84,3],[102,24,102,25],[76,1,76,4],[73,1,73,28],[54,31,54,32],[44,30,44,32],[45,1,45,28],[49,1,49,28],[47,7,47,25],[32,1,32,28],[40,7,40,25],[37,6,37,28],[42,2,42,3],[42,5,42,6],[42,7,42,25],[34,5,34,6],[40,2,40,3],[50,5,50,6],[48,7,48,25],[46,7,46,28],[38,1,38,28],[39,2,39,3],[39,5,39,6],[47,5,47,6],[46,2,46,3],[47,2,47,3],[40,30,40,32],[41,30,41,32]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(MenuTyp=1,DIVYON=2),\" Single Door Menu Board without Internal Divider \",IF(AND(MenuTyp=2,DIVYON=2),\" Two Door Menu Board without Internal Divider \",IF(AND(MenuTyp=3,DIVYON=2),\" Three Door Menu Board without Internal Divider \",IF(AND(MenuTyp=4,DIVYON=2),\" Four Door Menu Board without Internal Divider \",IF(AND(MenuTyp=5,DIVYON=2),\" Five Door Menu Board without Internal Divider \",IF(AND(MenuTyp=1,DIVYON=1),\" Single Door Menu Board with Internal Divider \",IF(AND(MenuTyp=2,DIVYON=1),\" Two Door Menu Board with Internal Divider \",IF(AND(MenuTyp=3,DIVYON=1),\" Three Door Menu Board with Internal Divider \",IF(AND(MenuTyp=4,DIVYON=1),\" Four Door Menu Board with Internal Divider \",IF(AND(MenuTyp=5,DIVYON=1),\" five Door Menu Board with Internal Divider \")))))))))))","v":""}]
[]
[]
[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,"Lengths Required","Lengths Used","Drops Used"]
[null,"Kit Quantity  ",null,null,null,0,null,"Height  ",null,null,null,{"$f":"IF(KQ=0,0,IF(MenuTyp=1,HOC,IF(MenuTyp=2,HOC,IF(MenuTyp=3,HOC,IF(MenuTyp=4,HOC,IF(MenuTyp=5,HOC))))))","v":0},null,"Width",null,null,null,{"$f":"IF(KQ=0,0,IF(MenuTyp=1,WOC,IF(MenuTyp=2,WOC,IF(MenuTyp=3,WOC,IF(MenuTyp=4,WOC,IF(MenuTyp=5,WOC))))))","v":0}]
[null,"Enter Fractions as Decimals"]
[null,"Extrusions",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,"Outer Cab/Door Frm Add-On",null,null,1.627,"Outer Div/Door Frames Add-on",null,null,3.0710000000000002]
[]
[null,"Menu Doors"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall Door(s) Width",null,null,{"$f":"IF(KQ=0,\"\",WVOA*NODA)","v":""},"Overall Door(s) Height",null,null,{"$f":"IF(KQ=0,\"\",HVOA)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall Door(s) Width",null,null,{"$f":"IF(KQ=0,\"\",WVOB*NODB)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall Door(s) Width",null,null,{"$f":"IF(KQ=0,\"\",WVOC*NODC)","v":""}]
[]
[null,null,null,null,null,"Note: The Configuration above must match the total number of doors. Five (5) total doors max.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Width of Doors",null,null,{"$f":"IF(KQ=0,\"\",AH15+AH17+AH19)","v":""},"Height of Doors",null,null,{"$f":"IF(KQ=0,\"\",ODH)","v":""}]
[null,null,"Insert Number of Doors",null,null,null,null,0,"Insert Number of Internal Dividers",null,null,null,null,null,null,0,"Door Width V.O.",null,null,null,0,null,"Door(s) Height V.O.",null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Width of Cabinet",null,null,{"$f":"IF(KQ=0,\"\",IF(TWD=0,\"0\",IF(MenuTyp=1,(OUTCAB*2)+TWD,IF(MenuTyp=2,((OUTCAB*2)+OUTDIV)+TWD,IF(MenuTyp=3,(OUTCAB*2)+(OUTDIV*2)+TWD,IF(MenuTyp=4,(OUTCAB*2)+(OUTDIV*3)+TWD,IF(MenuTyp=5,(OUTCAB*2)+(OUTDIV*4)+TWD,)))))))","v":""},"Height of Cabinet",null,null,{"$f":"IF(KQ=0,\"\",(OUTCAB*2)+HOD)","v":""}]
[null,null,"Insert Number of Doors",null,null,null,null,0,"Insert Number of Internal Dividers",null,null,null,null,null,null,0,"Door Width V.O."]
[]
[null,null,"Insert Number of Doors",null,null,null,null,0,"Insert Number of Internal Dividers",null,null,null,null,null,null,0,"Door Width V.O.",null,null,null,0,null,null,null,null,null,null,null,null,null,"Menu Size",null,3]
[null,"Menu Body"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,KQ*2,IF(MenuTyp=2,KQ*2,IF(MenuTyp=3,KQ*2,IF(MenuTyp=4,KQ*2,IF(MenuTyp=5,KQ*2,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,Hgt,IF(MenuTyp=2,Hgt,IF(MenuTyp=3,Hgt,IF(MenuTyp=4,Hgt,IF(MenuTyp=5,Hgt,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"1802\",IF(MenuTyp=2,\"1802\",IF(MenuTyp=3,\"1802\",IF(MenuTyp=4,\"1802\",IF(MenuTyp=5,\"1802\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\" Menu 5'' Single Face Body - Sides - Mitered Both Ends \",IF(MenuTyp=2,\" Menu 5'' Single Face Body - Sides - Mitered Both Ends \",IF(MenuTyp=3,\" Menu 5'' Single Face Body - Sides - Mitered Both Ends \",IF(MenuTyp=4,\" Menu 5'' Single Face Body - Sides - Mitered Both Ends \",IF(MenuTyp=5,\" Menu 5'' Single Face Body - Sides - Mitered Both Ends \",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C30*B30","v":{"$error":"#VALUE!"}},"in",{"$f":"ROUNDUP((BH30+BH31)/12,0)","v":{"$error":"#VALUE!"}},"ft."]
[null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,KQ*2,IF(MenuTyp=2,KQ*2,IF(MenuTyp=3,KQ*2,IF(MenuTyp=4,KQ*2,IF(MenuTyp=5,KQ*2,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,Wdt,IF(MenuTyp=2,Wdt,IF(MenuTyp=3,Wdt,IF(MenuTyp=4,Wdt,IF(MenuTyp=5,Wdt,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"1802\",IF(MenuTyp=2,\"1802\",IF(MenuTyp=3,\"1802\",IF(MenuTyp=4,\"1802\",IF(MenuTyp=5,\"1802\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\" Menu 5'' Single Face Body - Top and Bottom - Mitered Both Ends \",IF(MenuTyp=2,\" Menu 5'' Single Face Body - Top and Bottom - Mitered Both Ends \",IF(MenuTyp=3,\" Menu 5'' Single Face Body - Top and Bottom - Mitered Both Ends \",IF(MenuTyp=4,\" Menu 5'' Single Face Body - Top and Bottom - Mitered Both Ends \",IF(MenuTyp=5,\" Menu 5'' Single Face Body - Top and Bottom - Mitered Both Ends \",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C31*B31","v":{"$error":"#VALUE!"}},"in"]
[]
[null,"External 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,"External Divider Deduct",null,null,0.36]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"External Divider Length",null,null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"\",IF(MenuTyp=2,HOC-EDD,IF(MenuTyp=3,HOC-EDD,IF(MenuTyp=4,HOC-EDD,IF(MenuTyp=5,HOC-EDD))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"\",IF(MenuTyp=2,KQ*1,IF(MenuTyp=3,KQ*2,IF(MenuTyp=4,KQ*3,IF(MenuTyp=5,KQ*4,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,EDL,IF(MenuTyp=2,EDL,IF(MenuTyp=3,EDL,IF(MenuTyp=4,EDL,IF(MenuTyp=5,EDL,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,EDL,IF(MenuTyp=2,\"1806\",IF(MenuTyp=3,\"1806\",IF(MenuTyp=4,\"1806\",IF(MenuTyp=5,\"1806\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,EDL,IF(MenuTyp=2,\" Menu Extrenal Divider - Vertical - Straight Cut Both Ends \",IF(MenuTyp=3,\" Menu Extrenal Divider - Vertical - Straight Cut Both Ends \",IF(MenuTyp=4,\" Menu Extrenal Divider - Vertical - Straight Cut Both Ends \",IF(MenuTyp=5,\" Menu Extrenal Divider - Vertical - Straight Cut Both Ends \",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C36=\"\",\"0\",C36*B36)","v":"0"},"in",{"$f":"ROUNDUP(BH36/12,0)","v":0},"ft."]
[]
[null,"Internal 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,"Internal Divider Deduct",null,null,0.13600000000000001,null,"Internal Divider",null,1]
[]
[" ","Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NOIDA=0,\"\",IF(NODA>=1,NODA*NOIDA*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NOIDA=0,\"\",IF(NODA>=1,IDLA,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NOIDA=0,\"\",IF(NODA>=1,\"1807\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NOIDA=0,\"\",IF(NODA>=1,\" Menu Internal Divider - Horizontal - 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,"Internal Divider Length A",null,null,{"$f":"IF(KQ=0,\"\",WVOA-IDD)","v":""},{"$f":"IF(DIVYON=2,\"\",NODA*NOIDA)","v":0},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(MDIDLen=\"\",\"0\",MDIDLen*B41)","v":"0"},"in",{"$f":"ROUNDUP((BH41+BH42+BH43)/12,0)","v":0},"ft."]
[null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NODB=0,\"\",IF(NOIDB=0,\"\",IF(NODB>=1,NODB*NOIDB*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NODB=0,\"\",IF(NOIDB=0,\"\",IF(NODB>=1,IDLB,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NODA=0,\"\",IF(NOIDB=0,\"\",IF(NODB>=1,\"1807\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NODB=0,\"\",IF(NOIDB=0,\"\",IF(NODB>=1,\" Menu Internal Divider - Horizontal - 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,"Internal Divider Length B",null,null,{"$f":"IF(KQ=0,\"\",IF(WVOB=0,\"0\",WVOB-IDD))","v":""},{"$f":"IF(DIVYON=2,\"\",NODB*NOIDB)","v":0},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(C42=\"\",\"0\",C42*B42)","v":"0"},"in"]
[null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NODC=0,\"\",IF(NOIDC=0,\"\",IF(NODC>=1,NODC*NOIDC*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NODC=0,\"\",IF(NOIDC=0,\"\",IF(NODC>=1,IDLC,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NODC=0,\"\",IF(NOIDC=0,\"\",IF(NODC>=1,\"1807\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NODC=0,\"\",IF(NOIDC=0,\"\",IF(NODC>=1,\" Menu Internal Divider - Horizontal - 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,"Internal Divider Length C",null,null,{"$f":"IF(KQ=0,\"\",IF(WVOC=0,0,WVOC-IDD))","v":""},{"$f":"IF(DIVYON=2,\"\",NODC*NOIDC)","v":0},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(MidDID=\"\",\"0\",MidDID*B43)","v":"0"},"in"]
[]
[null,"Menu Door(s)",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,"Door Add-on",null,null,2.8460000000000001,{"$f":"SUM(AI41:AI43)","v":0}]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",(NODA*2)*KQ)","v":""},{"$f":"IF(KQ=0,\"\",IF(NODA=0,\"\",DHA))","v":""},null,null,{"$f":"IF(KQ=0,\"\",\"1804\")","v":""},null,{"$f":"IF(KQ=0,\"\",\" Menu Door Frame - Sides - Mitered Both Ends \")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Height A,B,C",null,{"$f":"IF(KQ=0,\"\",HVOA+DAO)","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":"Mdhgt*B48","v":{"$error":"#VALUE!"}},"in",{"$f":"ROUNDUP((BH48+BH49+BH51+BH52+BH54+BH55)/12,0)","v":{"$error":"#VALUE!"}},"ft."]
[null,{"$f":"IF(KQ=0,\"\",(NODA*2)*KQ)","v":""},{"$f":"IF(KQ=0,\"\",IF(NODA=0,\"\",DWA))","v":""},null,null,{"$f":"IF(KQ=0,\"\",\"1804\")","v":""},null,{"$f":"IF(KQ=0,\"\",\" Menu Door Frame - Top and Bottom - Mitered Both Ends \")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Width A",null,{"$f":"IF(KQ=0,\"\",WVOA+DAO)","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":"MdWdt*B49","v":{"$error":"#VALUE!"}},"in"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",(NODB*2)*KQ))","v":""},{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",DHA))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",\"1804\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",\" Menu Door Frame - Sides - Mitered Both Ends \"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tdhgt=\"\",\"0\",Tdhgt*B51)","v":"0"},"in"]
[null,{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",(NODB*2)*KQ))","v":""},{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",DWB))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",\"1804\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",\" Menu Door Frame - Top and Bottom - Mitered Both Ends \"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Width B",null,{"$f":"IF(KQ=0,\"\",IF(WVOB=0,\"\",WVOB+DAO))","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(C52=\"\",\"0\",C52*B52)","v":"0"},"in"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",(NODC*2)*KQ))","v":""},{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",DHA))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",\"1804\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",\" Menu Door Frame - Sides - Mitered Both Ends \"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C54=\"\",\"0\",C54*B54)","v":"0"},"in"]
[null,{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",(NODC*2)*KQ))","v":""},{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",DWC))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",\"1804\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",\" Menu Door Frame - Top and Bottom - Mitered Both Ends \"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Width C",null,{"$f":"IF(KQ=0,\"\",IF(WVOC=0,\"\",WVOC+DAO))","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(Bdhgt=\"\",\"0\",Bdhgt*B55)","v":"0"},"in"]
[]
[null,"Hinge"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,KQ,IF(MenuTyp=2,2*KQ,IF(MenuTyp=3,3*KQ,IF(MenuTyp=4,4*KQ,IF(MenuTyp=5,5*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,HOC-0.875,IF(MenuTyp=2,HOC-0.875,IF(MenuTyp=3,HOC-0.875,IF(MenuTyp=4,HOC-0.875,IF(MenuTyp=5,HOC-0.875,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"5997\",IF(MenuTyp=2,\"5997\",IF(MenuTyp=3,\"5997\",IF(MenuTyp=4,\"5997\",IF(MenuTyp=5,\"5997\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\" Door Hinge - One Side Main Doors - Straight Cut Both Ends \",IF(MenuTyp=2,\" Door Hinge - One Side Each Door - Straight Cut Both Ends \",IF(MenuTyp=3,\" Door Hinge - One Side - Straight Cut Both Ends \",IF(MenuTyp=4,\" Door Hinge - One Side - Straight Cut Both Ends \",IF(MenuTyp=5,\" Door Hinge - One Side - Straight Cut Both Ends \",\"\"))))))","v":""}]
[]
[null,"Menu Clips"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(NODA=0,\"\",(NODA*2)*KQ))","v":""},{"$f":"IF(KQ=0,\"\",IF(NODA=0,\"\",WVOA-3))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NODA=0,\"\",\"1809\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NODA=0,\"\",\" Menu Clip - Top and Bottom Main Doors - Straight Cut Both Ends \"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Menu Clips",null,{"$f":"IF(KQ=0,\"\",IF(AND(NODA=0,NOIDA=0),0,IF(AND(NODA>=1,NOIDA=0),NODA*KQ,IF(AND(NODA=1,NOIDA=1),NOIDA+1*KQ,IF(AND(NODA>=2,NOIDA>=1),NODA*2*KQ)))))","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":"C63*B63","v":{"$error":"#VALUE!"}},"in",{"$f":"ROUNDUP((BH63+BH64+BH65+BH66)/12,0)","v":{"$error":"#VALUE!"}},"ft."]
[null,{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",(NODB*2)*KQ))","v":""},{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",WVOB-3))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",\"1809\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",\" Menu Clip - Top and Bottom Main Doors - Straight Cut Both Ends \"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Menu Clips",null,{"$f":"IF(KQ=0,\"\",IF(AND(NODB=0,NOIDB=0),0,IF(AND(NODB=1,NOIDB=0),NODB*KQ,IF(AND(NODB=1,NOIDB=1),NOIDB+1*KQ,IF(AND(NODB=2,NOIDB>=1),NODB*2*KQ)))))","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(C64=\"\",\"0\",C64*B64)","v":"0"},"in"]
[null,{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",(NODC*2)*KQ))","v":""},{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",WVOC-3))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",\"1809\"))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",\" Menu Clip - Top and Bottom Main Doors - Straight Cut Both Ends \"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Menu Clips",null,{"$f":"IF(KQ=0,\"\",IF(AND(NODC=0,NOIDC=0),0,IF(AND(NODC=1,NOIDC=0),NODC*KQ,IF(AND(NODC=1,NOIDC=1),NOIDC+1*KQ,IF(AND(NODC=2,NOIDC>=1),NOIDC*2*KQ)))))","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(C65=\"\",\"0\",C65*B65)","v":"0"},"in"]
[null,{"$f":"IF(KQ=0,\"\",IF(AND(MenuTyp=1,DIVYON=1),TDiv*2,IF(AND(MenuTyp=2,DIVYON=1),TDiv*2,IF(AND(MenuTyp=3,DIVYON=1),TDiv*2,IF(AND(MenuTyp=4,DIVYON=1),TDiv*2,IF(AND(MenuTyp=5,DIVYON=1),TDiv*2,IF(MenuTyp=1,KQ,IF(MenuTyp=2,2*KQ,IF(MenuTyp=3,3*KQ,IF(MenuTyp=4,4*KQ,IF(MenuTyp=5,5*KQ,\"\")))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,6,IF(MenuTyp=2,6,IF(MenuTyp=3,6,IF(MenuTyp=4,6,IF(MenuTyp=5,6,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"1809\",IF(MenuTyp=2,\"1809\",IF(MenuTyp=3,\"1809\",IF(MenuTyp=4,\"1809\",IF(MenuTyp=5,\"1809\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\" Menu Clip - One (1) Each Menu Section - Side - Straight Cut Both Ends \",IF(MenuTyp=2,\" Menu Clip - One (1) Each Menu Section - Side - Straight Cut Both Ends \",IF(MenuTyp=3,\" Menu Clip - Side - Straight Cut Both Ends \",IF(MenuTyp=4,\" Menu Clip - Side - Straight Cut Both Ends \",IF(MenuTyp=5,\" Menu Clip - Side - Straight Cut Both Ends \",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Menu Clips",null,{"$f":"SUM(AH63:AH65)","v":0},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":"C66*B66","v":{"$error":"#VALUE!"}},"in"]
[]
[]
[]
[]
[]
[null,"BILL OF MATERIALS"]
[]
[null,{"$f":"IF(KQ=0,\"\",AI6&AE4&AE6&AE7&AE9&AE10&AI7)","v":""}]
[]
[]
[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,"Height  ",null,null,null,{"$f":"IF(Hgt=0,\"\",Hgt)","v":""},null,"Width",null,null,null,{"$f":"IF(Wdt=0,\"\",Wdt)","v":""}]
[]
[null,"Hardware"]
[null,"Body"]
[null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,KQ*4,IF(MenuTyp=2,KQ*4,IF(MenuTyp=3,KQ*4,IF(MenuTyp=4,KQ*4,IF(MenuTyp=5,KQ*4,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"5952\",IF(MenuTyp=2,\"5952\",IF(MenuTyp=3,\"5952\",IF(MenuTyp=4,\"5952\",IF(MenuTyp=5,\"5952\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\" Menu 5'' Single Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (3-9/16'') - One (1) per corner\",IF(MenuTyp=2,\" Menu 5'' Single Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (3-9/16'') - One (1) per corner\",IF(MenuTyp=3,\" Menu 5'' Single Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (3-9/16'') - One (1) per corner\",IF(MenuTyp=4,\" Menu 5'' Single Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (3-9/16'') - One (1) per corner\",IF(MenuTyp=5,\" Menu 5'' Single Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (3-9/16'') - One (1) per corner\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,KQ*4,IF(MenuTyp=2,KQ*4,IF(MenuTyp=3,KQ*4,IF(MenuTyp=4,KQ*4,IF(MenuTyp=5,KQ*4,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"5895\",IF(MenuTyp=2,\"5895\",IF(MenuTyp=3,\"5895\",IF(MenuTyp=4,\"5895\",IF(MenuTyp=5,\"5895\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\" Menu Angle Assembly - 2-1/2'' x 2-1/2'' x 1/4'' (1/2'') - One (1) per corner\",IF(MenuTyp=2,\" Menu Angle Assembly - 2-1/2'' x 2-1/2'' x 1/4'' (1/2'') - One (1) per corner\",IF(MenuTyp=3,\" Menu Angle Assembly - 2-1/2'' x 2-1/2'' x 1/4'' (1/2'') - One (1) per corner\",IF(MenuTyp=4,\" Menu Angle Assembly - 2-1/2'' x 2-1/2'' x 1/4'' (1/2'') - One (1) per corner\",IF(MenuTyp=5,\" Menu Angle Assembly - 2-1/2'' x 2-1/2'' x 1/4'' (1/2'') - One (1) per corner\"))))))","v":""}]
[null,"External Divider"]
[null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"\",IF(MenuTyp=2,KQ*4,IF(MenuTyp=3,KQ*8,IF(MenuTyp=4,KQ*12,IF(MenuTyp=5,KQ*16,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"\",IF(MenuTyp=2,\"5895\",IF(MenuTyp=3,\"5895\",IF(MenuTyp=4,\"5895\",IF(MenuTyp=5,\"5895\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"\",IF(MenuTyp=2,\" Menu Angle Assembly - 2-1/2'' x 2-1/2'' x 1/4'' (1/2'') - Two (2) per End (Vertical) \",IF(MenuTyp=3,\" Menu Angle Assembly - 2-1/2'' x 2-1/2'' x 1/4'' (1/2'') - Two (2) per End (Vertical) \",IF(MenuTyp=4,\" Menu Angle Assembly - 2-1/2'' x 2-1/2'' x 1/4'' (1/2'') - Two (2) per End (Vertical) \",IF(MenuTyp=5,\" Menu Angle Assembly - 2-1/2'' x 2-1/2'' x 1/4'' (1/2'') - Two (2) per End (Vertical) \",))))))","v":""}]
[null,"Internal Divider"]
[null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NODA>=1,((DivA+DivB+DivC)*4)*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NODA>=1,\"5895\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(NODA>=1,\" Menu Angle Assembly - 2-1/2'' x 2-1/2'' x 1/4'' (1/2'') - Two (2) per End \",\"\")))","v":""}]
[null,"Menu Door(s)"]
[null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,KQ*4,IF(MenuTyp=2,KQ*8,IF(MenuTyp=3,KQ*12,IF(MenuTyp=4,KQ*16,IF(MenuTyp=5,KQ*20,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"5226\",IF(MenuTyp=2,\"5226\",IF(MenuTyp=3,\"5226\",IF(MenuTyp=4,\"5226\",IF(MenuTyp=5,\"5226\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\" Corner Key - 3-1/16'' x 3-1/16'' x .120'' - One (1) per corner\",IF(MenuTyp=2,\" Corner key - 3-1/16'' x 3-1/16'' x .120'' - One (1) per corner\",IF(MenuTyp=3,\" Corner Key - 3-1/16'' x 3-1/16'' x .120'' - One (1) per corner\",IF(MenuTyp=4,\" Corner Key - 3-1/16'' x 3-1/16'' x .120'' - One (1) per corner\",IF(MenuTyp=5,\" Corner Key - 3-1/16'' x 3-1/16'' x .120'' - One (1) per corner\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,KQ*4,IF(MenuTyp=2,KQ*8,IF(MenuTyp=3,KQ*12,IF(MenuTyp=4,KQ*16,IF(MenuTyp=5,KQ*20,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"5890\",IF(MenuTyp=2,\"5890\",IF(MenuTyp=3,\"5890\",IF(MenuTyp=4,\"5890\",IF(MenuTyp=5,\"5890\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\" 2 Piece Corner Key - 2'' x 2'' Stamped Steel - One (1) per corner\",IF(MenuTyp=2,\" 2 Piece Corner Key - 2'' x 2'' Stamped Steel - One (1) per corner\",IF(MenuTyp=3,\" 2 Piece Corner Key - 2'' x 2'' Stamped Steel - One (1) per corner\",IF(MenuTyp=4,\" 2 Piece Corner Key - 2'' x 2'' Stamped Steel - One (1) per corner\",IF(MenuTyp=5,\" 2 Piece Corner Key - 2'' x 2'' Stamped Steel - One (1) per corner\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,KQ*2,IF(MenuTyp=2,KQ*4,IF(MenuTyp=3,KQ*6,IF(MenuTyp=4,KQ*8,IF(MenuTyp=5,KQ*10,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"5995\",IF(MenuTyp=2,\"5995\",IF(MenuTyp=3,\"5995\",IF(MenuTyp=4,\"5995\",IF(MenuTyp=5,\"5995\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\" Door Lock - 1/4 Turn Stud,Keeper and Receiver - Two (2) per door\",IF(MenuTyp=2,\" Door Lock - 1/4 Turn Stud,Keeper and Receiver - Two (2) per door\",IF(MenuTyp=3,\" Door Lock - 1/4 Turn Stud,Keeper and Receiver - Two (2) per door\",IF(MenuTyp=4,\" Door Lock - 1/4 Turn Stud,Keeper and Receiver - Two (2) per door\",IF(MenuTyp=5,\" Door Lock - 1/4 Turn Stud,Keeper and Receiver - Two (2) per door\"))))))","v":""}]
[null,"Hinge Screws"]
[null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,HSa,IF(MenuTyp=2,HSa,IF(MenuTyp=3,HSa,IF(MenuTyp=4,HSa,IF(MenuTyp=5,HSa,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"5193\",IF(MenuTyp=2,\"5193\",IF(MenuTyp=3,\"5193\",IF(MenuTyp=4,\"5193\",IF(MenuTyp=5,\"5193\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\" Hinge Attachment Screw - #8 x 5/16'' S.S Sq./Phillips Drive Countersink Screw - One (1) Approx. Every 2'' on Center \",IF(MenuTyp=2,\" Hinge Attachment Screw - #8 x 5/16'' S.S Sq./Phillips Drive Countersink Screw - One (1) Approx. 2'' on Center \",IF(MenuTyp=3,\" Hinge Attachment Screw - #8 x 5/16'' S.S Sq./Phillips Drive Countersink Screw - One (1) Approx. Every 2'' on Center \",IF(MenuTyp=4,\" Hinge Attachment Screw - #8 x 5/16'' S.S Sq./Phillips Drive Countersink Screw - One (1) Approx. Every 2'' on Center \",IF(MenuTyp=5,\" Hinge Attachment Screw - #8 x 5/16'' S.S Sq./Phillips Drive Countersink Screw - One (1) Approx. Every 2'' 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,null,"Hinge Screws",null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,KQ*ROUNDUP(C59/2,0)*2,IF(MenuTyp=2,KQ*ROUNDUP(C59/2,0)*4,IF(MenuTyp=3,KQ*ROUNDUP(C59/2,0)*6,IF(MenuTyp=4,KQ*ROUNDUP(C59/2,0)*8,IF(MenuTyp=5,KQ*ROUNDUP(C59/2,0)*10))))))","v":""}]
[null,"Menu Clip Screws"]
[null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,((MCa+MCb+MCd+MCc)*2),IF(MenuTyp=2,((MCa+MCb+MCd+MCc)*2),IF(MenuTyp=3,((MCa+MCb+MCd+MCc)*2),IF(MenuTyp=4,((MCa+MCb+MCd+MCc)*2),IF(MenuTyp=5,((MCa+MCb+MCd+MCc)*2),\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\"5241\",IF(MenuTyp=2,\"5241\",IF(MenuTyp=3,\"5241\",IF(MenuTyp=4,\"5241\",IF(MenuTyp=5,\"5241\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(MenuTyp=1,\" Menu Clip Attachment Screw - #8 x 3/4'' S.S. Sq./Phillips Drive Countersink Screw - Two (2) per Menu Clip \",IF(MenuTyp=2,\" Menu Clip Attachment Screw - #8 x 3/4'' S.S. Sq./Phillips Drive Countersink Screw - Two (2) per Menu Clip \",IF(MenuTyp=3,\" Menu Clip Attachment Screw - #8 x 3/4'' S.S. Sq./Phillips Drive Countersink Screw - Two (2) per Menu Clip \",IF(MenuTyp=4,\" Menu Clip Attachment Screw - #8 x 3/4'' S.S. Sq./Phillips Drive Countersink Screw - Two (2) per Menu Clip \",IF(MenuTyp=5,\" Menu Clip Attachment Screw - #8 x 3/4'' S.S. Sq./Phillips Drive Countersink Screw - Two (2) per Menu Clip \"))))))","v":""}]
[]
[null,null,"Menu Panel Trim Sizes"]
[null,null,null,null,null,null,null,null,"(w)",null,null,"(h)",null,null,null,null,null,null,null,null,null,"(w)",null,null,"(h)"]
[null,null,"Menu Trim Size (No Divider)",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NODA=0,\"\",IF(AND(DIVYON=1,NOIDA>=1),\"\",IF(AND(DIVYON=1,NOIDA=0),WVOA+0.564,IF(DIVYON=2,WVOA+0.564)))))","v":""},null,"x",{"$f":"IF(KQ=0,\"\",IF(NODA=0,\"\",IF(AND(DIVYON=1,NOIDA>=1),\"\",IF(AND(DIVYON=1,NOIDA=0),HVOA+0.564,IF(DIVYON=2,HVOA+0.564)))))","v":""},null,null,null,"Menu Trim Size with Divider",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(AND(DIVYON=1,NOIDA=0),\"\",IF(AND(DIVYON=1,NOIDA>=1),(WVOA+0.564)))))","v":""},{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(AND(DIVYON=1,NOIDA=0),\"\",IF(AND(DIVYON=1,NOIDA>=1),(WVOA+0.564)))))","v":""},"x",{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(AND(DIVYON=1,NOIDA=0),\"\",IF(AND(DIVYON=1,NOIDA>=1),(HVOA-0.812)/2+0.638))))","v":""},null,"2 Panels Req'd"]
[]
[null,null,"Menu Trim Size (No Divider)",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",IF(AND(DIVYON=1,NOIDB>=1),\"\",IF(AND(DIVYON=1,NOIDB=0),WVOB+0.564,IF(DIVYON=2,WVOB+0.564)))))","v":""},null,"x",{"$f":"IF(KQ=0,\"\",IF(NODB=0,\"\",IF(AND(DIVYON=1,NOIDB>=1),\"\",IF(AND(DIVYON=1,NOIDB=0),HVOA+0.564,IF(DIVYON=2,HVOA+0.564)))))","v":""},null,null,null,"Menu Trim Size with Divider",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(AND(DIVYON=1,NOIDB=0),\"\",IF(AND(DIVYON=1,NOIDB>=1),(WVOB+0.564)))))","v":""},null,"x",{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(AND(DIVYON=1,NOIDB=0),\"\",IF(AND(DIVYON=1,NOIDB>=1),(HVOA-0.812)/2+0.638))))","v":""},null,"2 Panels Req'd"]
[]
[null,null,"Menu Trim Size (No Divider)",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",IF(AND(DIVYON=1,NOIDC>=1),\"\",IF(AND(DIVYON=1,NOIDC=0),WVOC+0.564,IF(DIVYON=2,WVOC+0.564)))))","v":""},null,"x",{"$f":"IF(KQ=0,\"\",IF(NODC=0,\"\",IF(AND(DIVYON=1,NOIDC>=1),\"\",IF(AND(DIVYON=1,NOIDC=0),HVOA+0.564,IF(DIVYON=2,HVOA+0.564)))))","v":""},null,null,null,"Menu Trim Size with Divider",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(AND(DIVYON=1,NOIDC=0),\"\",IF(AND(DIVYON=1,NOIDC>=1),(WVOC+0.564)))))","v":""},null,"x",{"$f":"IF(KQ=0,\"\",IF(DIVYON=2,\"\",IF(AND(DIVYON=1,NOIDC=0),\"\",IF(AND(DIVYON=1,NOIDC>=1),(HVOA-0.812)/2+0.638))))","v":""},null,"2 Panels Req'd"]
[]
[null,null,"Clear Face Trim Sizes"]
[null,null,null,null,null,null,null,null,"(w)",null,null,"(h)"]
[null,null,"Clear Face Trim Size",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",WVOA+2)","v":""},null,"x",{"$f":"IF(KQ=0,\"\",HVOA+2)","v":""}]
[]
[null,null,"Clear Face Trim Size",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(WVOB=0,\"\",WVOB+2))","v":""},null,"x",{"$f":"IF(KQ=0,\"\",IF(WVOB=0,\"\",HVOA+2))","v":""}]
[]
[null,null,"Clear Face Trim Size",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(WVOC=0,\"\",WVOC+2))","v":""},null,"x",{"$f":"IF(KQ=0,\"\",IF(WVOC=0,\"\",HVOA+2))","v":""}]
[]
[]
[]
[null,null,"Back Trim Size"]
[null,null,null,null,null,null,null,null,"(w)",null,null,"(h)"]
[null,null,".063 Aluminum Back",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",Wdt-0.27)","v":""},null,"x",{"$f":"IF(KQ=0,\"\",Hgt-0.27)","v":""}]

{"sheet":"Pricing","index":1,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,14,17,15],[15,11,15,12],[16,11,16,12],[17,11,17,12],[14,11,14,12],[15,14,15,15],[14,14,14,15],[16,14,16,15],[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[7,16,7,17],[4,11,4,12],[6,14,6,15],[14,0,14,3],[13,1,13,4],[11,8,11,9],[14,8,14,9],[11,1,11,7],[11,11,11,12],[5,11,5,12],[6,11,6,12],[7,11,7,12],[8,16,8,17],[10,16,10,17],[11,16,11,17],[11,14,11,15],[9,16,9,17],[1,1,1,4],[2,1,2,7],[2,8,2,9],[2,11,2,12],[3,11,3,12],[3,1,3,7],[3,8,3,9],[7,14,7,15],[8,14,8,15],[10,14,10,15],[7,8,7,9],[10,11,10,12],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,11,8,12],[4,8,4,9],[5,8,5,9],[6,8,6,9],[2,16,2,17],[3,16,3,17],[4,16,4,17],[5,16,5,17],[6,16,6,17],[19,5,19,6],[18,5,18,6],[19,8,19,9],[8,8,8,9],[10,8,10,9],[8,1,8,7],[19,0,19,3],[17,0,17,3],[15,0,15,3],[16,0,16,3],[17,8,17,9],[10,1,10,7],[19,11,19,12],[18,11,18,12],[19,14,19,15],[18,14,18,15],[9,1,9,7],[9,8,9,9],[9,11,9,12],[9,14,9,15],[15,8,15,9],[16,8,16,9],[18,0,18,3],[18,8,18,9],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6]]}
[]
[null,"Hardware"]
[null,"Part",null,null,null,null,null,null,"Part #",null,"Qty","List Price",null,null,"Price",null,"Pricing as of"]
[null,"Menu Angle Assembly (ED)",null,null,null,null,null,null,5895,null,{"$f":"IF(KQ=0,0,IF(MenuTyp=1,0,Menu!B85))","v":0},2.4500000000000002,null,null,{"$f":"L4*K4","v":0},null,"2023-09-19"]
[null,"Menu Angle Assembly (ID)",null,null,null,null,null,null,5895,null,{"$f":"IF(KQ=0,0,IF(DIVYON=2,0,Menu!B87))","v":0},2.4500000000000002,null,null,0,null,"2023-09-19"]
[null,"Corner Key",null,null,null,null,null,null,5226,null,{"$f":"IF(KQ=0,0,Menu!B89)","v":0},1.22,null,null,0,null,"2023-09-19"]
[null,"2 Piece Corner Angle",null,null,null,null,null,null,5890,null,{"$f":"IF(KQ=0,0,Menu!B90)","v":0},0.77,null,null,0,null,"2023-09-19"]
[null,"Hinge Screw",null,null,null,null,null,null,5193,null,{"$f":"IF(KQ=0,0,Menu!B93)","v":0},0.28000000000000003,null,null,0,null,"2023-09-19"]
[null,"Menu Clip Screw",null,null,null,null,null,null,5241,null,{"$f":"IF(KQ=0,0,Menu!B95)","v":0},0.1,null,null,0,null,"2023-09-19"]
[null,"Door Locks",null,null,null,null,null,null,5995,null,{"$f":"IF(KQ=0,0,Menu!B91)","v":0},5.27,null,null,{"$f":"K10*L10","v":0},null,"2024-01-09"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O4:P11)","v":0},null,"Total"]
[]
[null,"Extrusion"]
["Part",null,null,null,null,"Length",null,null,"Part #",null,null,"PF",null,null,"PL"]
["External Divider",null,null,null,null,"16'-2\"",null,null,1806,null,null,5.97,null,null,96.52]
["Internal Divider",null,null,null,null,"16'-2\"",null,null,1807,null,null,2.27,null,null,36.700000000000003]
["Menu Door",null,null,null,null,"24'-4\"",null,null,1804,null,null,4.17,null,null,101.47]
["Hinge",null,null,null,null,"8'-0\"",null,null,5997,null,null,4.2300000000000004,null,null,33.799999999999997]
["Menu Clip",null,null,null,null,"16'-2\"",null,null,1809,null,null,1.57,null,null,25.38]

{"sheet":"Gas Support","index":2,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":true,"merged":[[60,0,60,1],[20,0,20,1],[22,0,22,1],[38,0,38,1],[42,0,42,1],[44,0,44,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"HT","Width"]
["Actual Cabinet Size",null,{"$f":"[0]!Hgt","v":0},{"$f":"[0]!Wdt","v":0},null,null,{"$f":"IF(AH>=90,\"\",IF(AH>=84,84,IF(AH>=78,78,IF(AH>=72,72,IF(AH>=66,66,IF(AH>=60,60,IF(AH>=54,54,IF(AH>=48,48,IF(AH>=42,42,IF(AH>=36,36,IF(AH>=30,30,IF(AH>=24,24))))))))))))","v":{"$error":"#NAME?"}}]
[]
["Nominal Cabinet Size",null,{"$f":"G21","v":{"$error":"#NAME?"}},{"$f":"G23","v":{"$error":"#NAME?"}},null,null,{"$f":"IF(AW>=150,\"\",IF(AW>=144,144,IF(AW>=132,132,IF(AW>=120,120,IF(AW>=108,108,IF(AW>=96,96,IF(AW>=84,84,IF(AW>=72,72,IF(AW>=60,60,IF(AW>=48,48,IF(AW>=36,36)))))))))))","v":{"$error":"#NAME?"}}]
[]
[null,null,null,"WIDTH"]
[null,null,null,36,48,60,72,84,96,108,120,132,144]
[null,"HT",24,"K5933-30","K5933-30","K5933-40","K5933-40","K5933-50","K5933-50","K5933-50","K5933-60","K5933-60","K5933-70"]
[null,null,30,"K5934-30","K5934-30","K5934-30","K5934-40","K5934-40","K5934-40","K5934-50","K5934-50","K5934-50","K5934-60"]
[null,null,36,"K5934-30","K5934-30","K5934-40","K5934-50","K5934-50","K5934-60","K5934-60","K5934-70","K5934-70","K5934-70"]
[null,null,42,"K5934-40","K5934-50","K5934-50","K5934-60","K5934-60","K5934-70","K5934-80","K5934-80","K5934-90","K5934-90"]
[null,null,48,"K5934-50","K5934-60","K5934-60","K5934-70","K5934-80","K5934-90","K5934-90","K5934-100","K5934-110","K5934-110"]
[null,null,54,"K5934-60","K5934-70","K5934-80","K5934-80","K5934-90","K5934-100","K5934-110","K5934-120","K5934-130","K5934-140"]
[null,null,60,"K5934-70","K5934-80","K5934-90","K5934-100","K5934-110","K5934-120","K5934-130","K5934-140","K5934-160","K5934-170"]
[null,null,66,"K5934-80","K5934-90","K5934-100","K5934-120","K5934-130","K5934-140","K5934-150","K5934-170","K5934-180","K5934-110"]
[null,null,72,"K5934-90","K5934-100","K5934-120","K5934-130","K5934-150","K5934-160","K5934-180","K5934-110","K5934-110","K5934-120"]
[null,null,78,"K5934-60","K5934-70","K5934-80","K5934-80","K5934-90","K5934-100","K5934-110","K5934-120","K5934-130","K5934-140"]
[null,null,84,"K5934-60","K5934-70","K5934-80","K5934-90","K5934-100","K5934-120","K5934-130","K5934-140","K5934-150","K5934-160"]
[]
["Gas Support Required",null,{"$f":"INDEX(D27:M37,MATCH(HT,C27:C37,0),MATCH(WTH,D26:M26,0))","v":{"$error":"#NAME?"}}]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(AH>=90,\"\",IF(AH>=84,84,IF(AH>=78,78,IF(AH>=72,72,IF(AH>=66,66,IF(AH>=60,60,IF(AH>=54,54,IF(AH>=48,48,IF(AH>=42,42,IF(AH>=36,36,IF(AH>=30,30,IF(AH>=24,24))))))))))))","v":{"$error":"#NAME?"}}]
[]
["Nominal Cabinet Size",null,{"$f":"G43","v":{"$error":"#NAME?"}},{"$f":"G45","v":{"$error":"#NAME?"}},null,null,{"$f":"IF(AW>=150,\"\",IF(AW>=144,144,IF(AW>=132,132,IF(AW>=120,120,IF(AW>=108,108,IF(AW>=96,96,IF(AW>=84,84,IF(AW>=72,72,IF(AW>=60,60,IF(AW>=48,48,IF(AW>=36,36)))))))))))","v":{"$error":"#NAME?"}}]
[]
[null,null,null,"WIDTH"]
[null,null,null,36,48,60,72,84,96,108,120,132,144]
[null,"HT",24,"A","A","A","A","A","A","A","A","A","A"]
[null,null,30,"B","B","B","B","B","B","B","B","B","B"]
[null,null,36,"B","B","B","B","B","B","B","B","B","B"]
[null,null,42,"B","B","B","B","B","B","B","B","B","B"]
[null,null,48,"B","B","B","B","B","B","B","B","B","B"]
[null,null,54,"B","B","B","B","B","B","B","B","B","B"]
[null,null,60,"B","B","B","B","B","B","B","B","B","B"]
[null,null,66,"B","B","B","B","B","B","B","B","B","C"]
[null,null,72,"B","B","B","B","B","B","B","C","C","C"]
[null,null,78,"C","C","C","C","C","C","C","C","C","C"]
[null,null,84,"C","C","C","C","C","C","C","C","C","C"]
[]
["Gas Support Placement",null,{"$f":"INDEX(D49:M59,MATCH(HT,C49:C59,0),MATCH(WTH,D48:M48,0))","v":{"$error":"#NAME?"}}]