{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["DATA","Ui","Code Basic","Calc","BOM_Product","Advance Code","DAD","SMACNA TABLE"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":79,"comments":1,"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":"DATA","index":0,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Sheet Metal Gauge to Thickness (mm) Chart",null,null,null,null,null,"Galvanized Steel Gauge Tolerance Chart (mm)",null,null,null,null,"1-Letter Material Codes"]
["Gauge","Galvanized Steel","Stainless Steel","Mild Steel","Aluminum",null,"Gauge","Minimum (mm)","Nominal (mm)","Maximum (mm)",null,"Material & Grade","1-Letter Code",null,"BOM ItemType","Desc",null,"BOM ItemType","Cam loCk W","H","Hing"]
[3,0,6.35,6.07,5.83,null,8,4.0410000000000004,4.2699999999999996,4.4980000000000002,null,"Galvanized Steel_G90","G",null,"MTO",null,null,"LOW ",5,3,1]
[4,0,5.95,5.69,5.19,null,9,3.6629999999999998,3.891,4.12,null,"Galvanized Steel_G115","H",null,"MTS",null,null,"Medium"]
[5,0,5.56,5.31,4.62,null,10,3.282,3.51,3.7389999999999999,null,"Stainless Steel_S304","S",null,"BUY",null,null,"High"]
[6,0,5.16,4.9400000000000004,4.1100000000000003,null,11,2.903,3.1320000000000001,3.36,null,"Stainless Steel_S316","V",null,"ASSY."]
[7,0,4.76,4.55,3.67,null,12,2.5249999999999999,2.7530000000000001,2.9820000000000002]
[8,4.2699999999999996,4.37,4.18,3.26,null,13,2.169,2.3719999999999999,2.5760000000000001]
[9,3.89,3.97,3.8,2.91,null,14,1.7909999999999999,1.994,2.1970000000000001,null,null,null,null,null,null,null,"TblData_05_ItemType"]
[10,3.51,3.57,3.42,2.59,null,15,1.651,1.8029999999999999,1.956,null,null,null,null,"TblData_05_ItemType",null,null,"TblData_05_ItemType_List"]
[11,3,3.18,3.04,2.2999999999999998,null,16,1.4610000000000001,1.613,1.7649999999999999,null,null,null,null,"TblData_05_ItemType_List"]
[12,2.75,2.78,2.66,2.0499999999999998,null,17,1.3340000000000001,1.4610000000000001,1.5880000000000001]
[13,2.37,2.38,2.2799999999999998,1.83,null,18,1.1839999999999999,1.3109999999999999,1.4379999999999999]
[14,2,1.98,1.9,1.63,null,19,1.0309999999999999,1.1579999999999999,1.2849999999999999]
[15,1.8,1.79,1.71,1.45,null,20,0.90400000000000003,1.006,1.107]
[16,1.5,1.59,1.52,1.29,null,21,0.82799999999999996,0.93,1.0309999999999999]
[17,1.46,1.43,1.37,1.1499999999999999,null,22,0.752,0.85299999999999998,0.95499999999999996]
[18,1.2,1.27,1.21,1.02,null,23,0.67600000000000005,0.77700000000000002,0.879]
[19,1.1599999999999999,1.1100000000000001,1.06,0.91,null,24,0.59899999999999998,0.70099999999999996,0.80300000000000005]
[20,1,0.95,0.91,0.81,null,25,0.52600000000000002,0.627,0.72899999999999998]
[21,0.93,0.87,0.84,0.72,null,26,0.47499999999999998,0.55100000000000005,0.627]
[22,0.8,0.79,0.76,0.64,null,27,0.437,0.51300000000000001,0.58899999999999997]
[23,0.78,0.71,0.68,0.56999999999999995,null,28,0.39900000000000002,0.47499999999999998,0.55100000000000005]
[24,0.7,0.64,0.61,0.51,null,29,0.36099999999999999,0.437,0.51300000000000001]
[25,0.63,0.56000000000000005,0.53,0.45,null,30,0.32300000000000001,0.39900000000000002,0.47499999999999998]
[26,0.55000000000000004,0.48,0.45,0.4,null,31,0.28399999999999997,0.36099999999999999,0.437]
[27,0.51,0.44,0.42,0.36,null,32,0.26400000000000001,0.34,0.41699999999999998]
[28,0.47,0.4,0.38,0.32]
[29,0.44,0.36,0.34,0.28999999999999998]
[30,0.4,0.32,0.3,0.25]
[31,0.36,0.28000000000000003,0.27,0.23]
[32,0.34,0.25,0.25,0.2]

{"sheet":"Ui","index":1,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Sales Ref","##"]
[null,null,null,null,"WorkOrder","###"]
[{"$f":"WO_Code","v":{"$error":"#REF!"}},null,null,"BASIC OPTIONS"]
["ADDRESS",null,null,null,"PRODUCT & CERTIFICATION"]
["Sr#",null,2,14,"Product","Duct Access Door"]
["Building",null,3,15,"Certification","-"]
["Floor",null,4]
["Zone",null,5,null,"CONSTRUCTION SPECIFICATION"]
["Room",null,6,16,"Material","Galvanized Steel_G90"]
["Unit",null,7,17,"Type","CamLock and Hinge"]
["TAG",null,8,18,"Depth","1 Inch"]
["Notes",null,10,19,"Pressure Class","Low"]
["SIZES",null,null,20,"Window Option","Without Window"]
["Width [mm]",150,11,21,"Insulation","Fiber Glass"]
["Height [mm]",150,12,22,"Insulation Density","24 KG/m³"]
["QTY",1,13,23,"Fire Rating Option","Non-Fire Rated"]
[null,null,9,24,"Hinge Location","None"]
["Calculation","WorkOrder",null,25,"Neck Height","Standard"]
[null,null,null,26,"No. Of Camlock",{"$f":"IF(Var_No_of_Camlock_T=0,\"\",Var_No_of_Camlock_T&\"T \")&IF(Var_No_of_Camlock_B=0,\"\",Var_No_of_Camlock_B&\"B \")&IF(Var_No_of_Camlock_L=0,\"\",Var_No_of_Camlock_L&\"L \")&IF(Var_No_of_Camlock_R=0,\"\",Var_No_of_Camlock_R&\"R \")","v":"1L 1R "}]
[null,null,null,27,"No. Of Hinge"]
[null,null,null,null,"Door Thickness"]
[null,null,null,null,"Frame Thickness"]
[null,null,null,null,"Back Thickness"]
[]
[]
[null,null,null,null,"Accessories"]
[null,null,null,null,"CamLock"]
[null,null,null,null,"Hinge"]
[]
[]
[null,null,null,"ADVANCED OPTIONS"]
[]
[]
[]
[null,null,null,"OPERATIONS"]
[null,null,null,34,"Package","Standard"]
[null,null,null,35,"Finish","Mill Finish"]

{"sheet":"Code Basic","index":2,"n_rows":90,"n_cols":24,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[]
["Code","Description","Default",null,"1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model"]
["DAD","Duct Access Door",true]
[]
["Code","Description","Default",null,"2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Material"]
["G","Galvanized Steel_G90",true]
["S","Stainless Steel_304"]
["V","Stainless Steel_316L"]
["B","Black Steel"]
[]
["Code","Description","Default",null,"3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type"]
["C","CamLock (Removable)"]
["H","CamLock and Hinge",true]
[]
["Code","Description","Default",null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Thickness"]
[1,"1 Inch",true]
[2,"2 Inch"]
[]
["Code","Description","Default",null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Finish"]
["M","Mill Finish",true]
["P","Painted"]
[]
["Code","Description","Default",null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRESSURE CLASS"]
["L","Low",true]
["T","Medium"]
["O","High"]
[]
["Code","Description","Default",null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Window Option"]
["W","With Window"]
["N","Without Window",true]
[]
["Code","Description","Default",null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insulation Type"]
["A","Fiber Glass",true]
["E","Rock Wool"]
[]
["Code","Description","Default",null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insulation Density"]
[24,"24 KG/m³",true]
[48,"48 KG/m³"]
[56,"56 KG/m³"]
[]
["Code","Description","Default",null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fire Rated Options"]
["F","Fire Rated Uncoated"]
["R","Fire Rated Coated"]
["X","Non-Fire Rated",true]
[]
[]
["Code","Description","Default",null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Neck Height"]
[null,"Standard",true]
[]
["Code","Description","Default",null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. Of CamLock"]
[null,"1-S"]
[null,"2-S"]
[null,"1-S, 1-T, 1-B"]
[null,"2-S, 1-T, 1-B"]
[null,"2-S, 2-T, 2-B"]
[]
["Code","Description","Default",null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. Of Hinge"]
[null,1]
[null,2]
[null,3]
[]
["Code","Description","Default",null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frame Thickness"]
[null,"Gauge 26"]
[null,"Gauge 24"]
[null,"Gauge 22"]
[null,"Gauge 20"]
[null,"Gauge 18"]
[]
["Code","Description","Default",null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Thickness"]
[null,"Gauge 26"]
[null,"Gauge 24"]
[null,"Gauge 22"]
[null,"Gauge 20"]
[null,"Gauge 18"]
[]
["Code","Description","Default",null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back Thickness"]
[null,"Gauge 26"]
[null,"Gauge 24"]
[null,"Gauge 22"]
[null,"Gauge 20"]
[null,"Gauge 18"]
[]
["Code","Description","Default",null,17]
[null,"Left",true]
[null,"Right"]
[null,"Top"]
[null,"Bottom"]
[null,"None"]

{"sheet":"Calc","index":3,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Constants",null,null,null,null,"Global Variables"]
[null,"VALUE","BUM","NOTES",null,null,"VALUE","BUM","NOTES"]
["Cns_SEG_MaxWidth_SMACNA",610,"mm",null,null,"Var_ProductID_Full",{"$f":"_xlfn.XLOOKUP(DAD_Model,Tbl_dad_model_list,Tbl_dad_model[Code])&\"-\"&_xlfn.XLOOKUP(DAD_Material,Tbl_dad_Material_list,Tbl_dad_Material[Code])&_xlfn.XLOOKUP(DAD_Type,Tbl_dad_type_list,Tbl_dad_type[Code])&_xlfn.XLOOKUP(DAD_Thickness,Tbl_dad_drthk_list,Tbl_dad_drthk[Code])&_xlfn.XLOOKUP(DAD_PressureClass,Tbl_dad_pressureClass_list,Tbl_dad_pressureClass[Code])&_xlfn.XLOOKUP(DAD_window,Tbl_dad_windowOption_list,Tbl_dad_windowOption[Code])&_xlfn.XLOOKUP(DAD_insulation,Tbl_dad_insType_list,Tbl_dad_insType[Code])&_xlfn.XLOOKUP(DAD_Insulation_Dens,Tbl_dad_insDense_list,Tbl_dad_insDense[Code])&_xlfn.XLOOKUP(DAD_FireRating,Tbl_dad_frOpt_list,Tbl_dad_frOpt[Code])&\"-\"&DAD_Width&\"x\"&DAD_Height&\"/\"&DAD_Finish&\" - With \"&DAD_Package&\" Packing\"","v":"DAD-GH1LNA24X-150x150/Mill Finish - With Standard Packing"}]
["Cns_SEG_MaxWidth_NonSMACNA",1000,"mm",null,null,"Var_ProductDesc_Full"]
[null,null,null,null,null,"Var_Neck_W",{"$f":"DAD_Width-5","v":145},"mm"]
[null,null,null,null,null,"Var_Neck_H",{"$f":"DAD_Height-5","v":145},"mm"]
[null,null,null,null,null,"Var_Neck_D",20,"mm","Standard"]
[null,null,null,null,null,"Var_No_Of_Cut_by_W",{"$f":"CEILING((DAD_Width-7.39)/56.94,1)-1","v":2}]
[null,null,null,null,null,"Var_Cut_dist_by_W",{"$f":"(DAD_Width-7.39)/CEILING((DAD_Width-7.39)/56.94,1)","v":47.536666666666669},"mm"]
[null,null,null,null,null,"Var_No_Of_Cut_by_H",{"$f":"CEILING((DAD_Height-7.39)/56.94,1)-1","v":2}]
[null,null,null,null,null,"Var_Cut_dist_by_H",{"$f":"(DAD_Height-7.39)/CEILING((DAD_Height-7.39)/56.94,1)","v":47.536666666666669},"mm"]
[null,null,null,null,null,"Var_Neck2Face_dist",17,"mm","Standard"]
[null,null,null,null,null,"Var_Face_W",{"$f":"Var_Neck_W+34","v":179},"mm"]
[null,null,null,null,null,"Var_Face_H",{"$f":"Var_Neck_H+34","v":179},"mm"]
[null,null,null,null,null,"Var_Face_D",{"$f":"IF(DAD_Thickness=\"1 Inch\",30,IF(DAD_Thickness=\"2 Inch\",55,IF(DAD_Depth,DAD_Depth)))","v":30},"mm"]
[null,null,null,null,null,"Var_Frame_Type",{"$f":"IF(DAD_Width*DAD_Height<=160000,\"WRAP\",\"LSHAPE\")","v":"WRAP"}]
[null,null,null,null,null,"Var_Frame_Thickness",{"$f":"INDEX(SMACNA_tbl[FRAME],\n  MATCH(1,\n    (TRIM(UPPER(SMACNA_tbl[PRESSURE CLASS]))=TRIM(UPPER(DAD_PressureClass)))*\n    (SMACNA_tbl[DAD W]>=DAD_Width)*\n    (SMACNA_tbl[DAD H]>=DAD_Height),\n  0)\n)","v":0.7},"mm"]
[null,null,null,null,null,"Var_Frame_Qty",{"$f":"IF(G16=\"WRAP\",DAD_Qty,DAD_Qty*2)","v":1}]
[null,null,null,null,null,"Var_Door_W",{"$f":"G13-10","v":169},"mm"]
[null,null,null,null,null,"Var_Door_H",{"$f":"G14-10","v":169},"mm"]
[null,null,null,null,null,"Var_Door_D",{"$f":"G15-5","v":25},"mm"]
[null,null,null,null,null,"Var_Door_Thickness",{"$f":"INDEX(SMACNA_tbl[DOOR],\n  MATCH(1,\n    (TRIM(UPPER(SMACNA_tbl[PRESSURE CLASS]))=TRIM(UPPER(DAD_PressureClass)))*\n    (SMACNA_tbl[DAD W]>=DAD_Width)*\n    (SMACNA_tbl[DAD H]>=DAD_Height),\n  0)\n)","v":0.55000000000000004},"mm"]
[null,null,null,null,null,"Var_Door_Qty",{"$f":"DAD_Qty","v":1}]
[null,null,null,null,null,"Var_No_of_Camlock_T",{"$f":"IFERROR(\nINDEX(SMACNA_tbl2[No Of Lock T],\n MATCH(1,\n  (SMACNA_tbl2[PRESSURE CLASS]=DAD_PressureClass)*\n  (SMACNA_tbl2[DAD W]>=DAD_Width)*\n  (SMACNA_tbl2[DAD H]>=DAD_Height),\n 0)\n),\n0)","v":0}]
[null,null,null,null,null,"Var_No_of_Camlock_B",{"$f":"IFERROR(\nINDEX(SMACNA_tbl2[No Of Lock B],\n MATCH(1,\n  (SMACNA_tbl2[PRESSURE CLASS]=DAD_PressureClass)*\n  (SMACNA_tbl2[DAD W]>=DAD_Width)*\n  (SMACNA_tbl2[DAD H]>=DAD_Height),\n 0)\n),\n0)","v":0}]
[null,null,null,null,null,"Var_No_of_Camlock_L",{"$f":"IFERROR(\nINDEX(SMACNA_tbl2[No Of Lock L],\n MATCH(1,\n  (SMACNA_tbl2[PRESSURE CLASS]=DAD_PressureClass)*\n  (SMACNA_tbl2[DAD W]>=DAD_Width)*\n  (SMACNA_tbl2[DAD H]>=DAD_Height),\n 0)\n),\n0)","v":1}]
[null,null,null,null,null,"Var_No_of_Camlock_R",{"$f":"IFERROR(\nINDEX(SMACNA_tbl2[No Of Lock R],\n MATCH(1,\n  (SMACNA_tbl2[PRESSURE CLASS]=DAD_PressureClass)*\n  (SMACNA_tbl2[DAD W]>=DAD_Width)*\n  (SMACNA_tbl2[DAD H]>=DAD_Height),\n 0)\n),\n0)","v":1}]
[null,null,null,null,null,"Var_Door_Back_W",{"$f":"G19-5","v":164},"mm"]
[null,null,null,null,null,"Var_Door_Back_H",{"$f":"G20-5","v":164},"mm"]
[null,null,null,null,null,"Var_Door_Back_Thickness",{"$f":"INDEX(SMACNA_tbl[BACK],\n  MATCH(1,\n    (TRIM(UPPER(SMACNA_tbl[PRESSURE CLASS]))=TRIM(UPPER(DAD_PressureClass)))*\n    (SMACNA_tbl[DAD W]>=DAD_Width)*\n    (SMACNA_tbl[DAD H]>=DAD_Height),\n  0)\n)","v":0.55000000000000004},"mm"]
[null,null,null,null,null,"Var_Door_Back_Qty",{"$f":"G23","v":1}]
[null,null,null,null,null,"Var_Gasket_L",{"$f":"(G13*2)+(G14*2)","v":716},"mm"]

{"sheet":"BOM_Product","index":4,"n_rows":9,"n_cols":46,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Line","ProductID","WorkOrder","CAD","Description","REV","Group","DesignTable","TYPE","Level","IsShMtl","BDS_Parent","Report","Material","ITEM_BOM_ID","ShMtlT","ShMtlR","ShMtlK","CONFIG","Prm01","Prm02","Prm03","Prm04","Prm05","Prm06","Prm07","Prm08","Prm09","Prm10","Prm11","Prm12","BOM_Description","Unit","Quantity","Dependencies","ShMtl_BB_W","ShMtl_BB_L","ShMtl_Area","Weight","RM_ERP","RM_DESC","RM_BUM","RM_QTY","RM_Cost","Routing_BendNum","Routing_BendCoeff"]
[null,{"$f":"Var_ProductID_Full","v":"DAD-GH1LNA24X-150x150/Mill Finish - With Standard Packing"},{"$f":"Ui_WorkOrder","v":"###"},"DAD","DAD-ASSEMBLY",0,null,{"$f":"IF(Calc!G15=\"WRAP\",TRUE)","v":false},"MTO","ASSY",false,"ASSEMBLY",null,{"$f":"UI_DmpMaterial_FRM","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,null,null,100,{"$f":"TEXT(Var_Module_W_Val,\"0000.0\")","v":{"$error":"#NAME?"}},{"$f":"Var_Module_H_Val","v":{"$error":"#NAME?"}},{"$f":"Var_Section_W_Num","v":{"$error":"#NAME?"}},{"$f":"Var_Section_H_Num","v":{"$error":"#NAME?"}},{"$f":"Var_Cut_dist_by_H","v":47.536666666666669},{"$f":"Var_No_Of_Cut_by_H","v":2},{"$f":"Var_No_Of_Cut_by_H","v":2},null,null,null,null,null,{"$f":"Tbl_BOM_Product[[#This Row],[Description]]","v":"DAD-ASSEMBLY"},"PCS",{"$f":"UI_QTY*Var_Module_W_Num*Var_Module_H_Num","v":{"$error":"#NAME?"}},true]
[null,{"$f":"Var_ProductID_Full","v":"DAD-GH1LNA24X-150x150/Mill Finish - With Standard Packing"},{"$f":"Ui_WorkOrder","v":"###"},"CDAD---001","Wrap-Frame",0,null,{"$f":"IF(Var_Frame_Type=\"WRAP\",TRUE)","v":true},"MTO","Part",true,"DAD-ASSEMBLY","CAM",{"$f":"DAD_Material","v":"Galvanized Steel_G90"},{"$f":"LEFT(Tbl_BOM_Product[[#This Row],[CAD]],4)&\n\"S32\"&\nRIGHT(Tbl_BOM_Product[[#This Row],[CAD]],3)&\"-[\"&Tbl_BOM_Product[[#This Row],[CONFIG]]&\"]\"&Tbl_BOM_Product[[#This Row],[Prm01]]&\"x\"&TEXT(Tbl_BOM_Product[[#This Row],[Prm02]],\"0.0\")&\"x\"&Tbl_BOM_Product[[#This Row],[Prm03]]&\"_r\"&TEXT(Tbl_BOM_Product[[#This Row],[REV]],\"00\")","v":"CDADS32001-[100]150x150.0x30_r00"},{"$f":"Var_Frame_Thickness","v":0.7},1,{"$f":"IF(_xlfn.TEXTBEFORE(Tbl_BOM_Product[[#This Row],[Material]],\"_\",1,1)=\"Stainless Steel\",0.4,0.37)","v":0.37},100,{"$f":"DAD_Width","v":150},{"$f":"DAD_Height","v":150},{"$f":"IF(DAD_Thickness=\"1 Inch\",30,IF(DAD_Thickness=\"2 Inch\",55))","v":30},{"$f":"Var_Cut_dist_by_W","v":47.536666666666669},{"$f":"Var_No_Of_Cut_by_W","v":2},{"$f":"Var_Cut_dist_by_H","v":47.536666666666669},{"$f":"Var_No_Of_Cut_by_H","v":2},null,null,null,null,null,{"$f":"Tbl_BOM_Product[[#This Row],[Description]]","v":"Wrap-Frame"},"PCS",{"$f":"Var_Frame_Qty","v":1},{"$f":"DAD_Type=\"CamLock and Hinge\"","v":true},165,192,3.168E-2,0.38170473121598403,"140306020120","STEEL COIL GI G90 1220X1.50MM MF UP TO 4 TON PER COIL","KG",0.45804567745918079,1.9466941292015183,4,2]
[null,"DAD-GH1LNA24X-150x150/Mill Finish - With Standard Packing",{"$f":"Ui_WorkOrder","v":"###"},"CDAD---002","L-FRAME",0,null,{"$f":"IF(Var_Frame_Type=\"LSHAPE\",TRUE)","v":false},"MTO","Part",true,"DAD-ASSEMBLY","CAM",{"$f":"DAD_Material","v":"Galvanized Steel_G90"},{"$f":"LEFT(Tbl_BOM_Product[[#This Row],[CAD]],4)&\n\"S32\"&\nRIGHT(Tbl_BOM_Product[[#This Row],[CAD]],3)&\"-[\"&Tbl_BOM_Product[[#This Row],[CONFIG]]&\"]\"&Tbl_BOM_Product[[#This Row],[Prm01]]&\"x\"&TEXT(Tbl_BOM_Product[[#This Row],[Prm02]],\"0.0\")&\"x\"&Tbl_BOM_Product[[#This Row],[Prm03]]&\"_r\"&TEXT(Tbl_BOM_Product[[#This Row],[REV]],\"00\")","v":"CDADS32002-[100]150x150.0x30_r00"},{"$f":"Var_Frame_Thickness","v":0.7},1,{"$f":"IF(_xlfn.TEXTBEFORE(Tbl_BOM_Product[[#This Row],[Material]],\"_\",1,1)=\"Stainless Steel\",0.4,0.37)","v":0.37},100,{"$f":"DAD_Width","v":150},{"$f":"DAD_Height","v":150},{"$f":"IF(DAD_Thickness=\"1 Inch\",30,IF(DAD_Thickness=\"2 Inch\",55))","v":30},{"$f":"Var_Cut_dist_by_W","v":47.536666666666669},{"$f":"Var_No_Of_Cut_by_W","v":2},{"$f":"Var_Cut_dist_by_H","v":47.536666666666669},2,null,null,null,null,null,{"$f":"Tbl_BOM_Product[[#This Row],[Description]]","v":"L-FRAME"},"PCS",{"$f":"Var_Frame_Qty","v":1},true,165,296,9.7680000000000003E-2,1.1769229212492842,"140306020120","STEEL COIL GI G90 1220X1.50MM MF UP TO 4 TON PER COIL","KG",1.412307505499141,6.0023068983713488,4,1]
[null,"DAD-GH1LNA24X-150x150/Mill Finish - With Standard Packing","###","CDAD---003","Door",0,null,true,"MTO","Part",true,"DAD-ASSEMBLY","CAM",{"$f":"DAD_Material","v":"Galvanized Steel_G90"},{"$f":"LEFT(Tbl_BOM_Product[[#This Row],[CAD]],4)&\n\"S32\"&\nRIGHT(Tbl_BOM_Product[[#This Row],[CAD]],3)&\"-[\"&Tbl_BOM_Product[[#This Row],[CONFIG]]&\"]\"&Tbl_BOM_Product[[#This Row],[Prm01]]&\"x\"&TEXT(Tbl_BOM_Product[[#This Row],[Prm02]],\"0.0\")&\"x\"&Tbl_BOM_Product[[#This Row],[Prm03]]&\"_r\"&TEXT(Tbl_BOM_Product[[#This Row],[REV]],\"00\")","v":"CDADS32003-[100]150x150.0x25_r00"},{"$f":"Var_Door_Thickness","v":0.55000000000000004},1,{"$f":"IF(_xlfn.TEXTBEFORE(Tbl_BOM_Product[[#This Row],[Material]],\"_\",1,1)=\"Stainless Steel\",0.4,0.37)","v":0.37},100,{"$f":"DAD_Width","v":150},{"$f":"DAD_Height","v":150},{"$f":"IF(DAD_Thickness=\"1 Inch\",25,IF(DAD_Thickness=\"2 Inch\",50))","v":25},null,null,null,2,null,null,null,null,null,{"$f":"Tbl_BOM_Product[[#This Row],[Description]]","v":"Door"},"PCS",{"$f":"Var_Door_Qty","v":1},null,165,296,9.7680000000000003E-2,1.1769229212492842,"140306020120","STEEL COIL GI G90 1220X1.50MM MF UP TO 4 TON PER COIL","KG",1.412307505499141,6.0023068983713488,4,1]
[null,{"$f":"Var_ProductID_Full","v":"DAD-GH1LNA24X-150x150/Mill Finish - With Standard Packing"},{"$f":"Ui_WorkOrder","v":"###"},"CDAD---004","BackSide-FlatSheet",0,null,true,"MTO","Part",true,"DAD-ASSEMBLY","CAM",{"$f":"DAD_Material","v":"Galvanized Steel_G90"},{"$f":"LEFT(Tbl_BOM_Product[[#This Row],[CAD]],4)&\n\"S32\"&\nRIGHT(Tbl_BOM_Product[[#This Row],[CAD]],3)&\"-[\"&Tbl_BOM_Product[[#This Row],[CONFIG]]&\"]\"&Tbl_BOM_Product[[#This Row],[Prm01]]&\"x\"&TEXT(Tbl_BOM_Product[[#This Row],[Prm02]],\"0.0\")&\"x\"&Tbl_BOM_Product[[#This Row],[Prm03]]&\"_r\"&TEXT(Tbl_BOM_Product[[#This Row],[REV]],\"00\")","v":"CDADS32004-[100]150x150.0x_r00"},{"$f":"Var_Door_Back_Thickness","v":0.55000000000000004},1,{"$f":"IF(_xlfn.TEXTBEFORE(Tbl_BOM_Product[[#This Row],[Material]],\"_\",1,1)=\"Stainless Steel\",0.4,0.37)","v":0.37},100,{"$f":"DAD_Width","v":150},{"$f":"DAD_Height","v":150},null,null,null,null,2,null,null,null,null,null,{"$f":"Tbl_BOM_Product[[#This Row],[Description]]","v":"BackSide-FlatSheet"},"PCS",{"$f":"Var_Door_Back_Qty","v":1},false]
[null,{"$f":"Var_ProductID_Full","v":"DAD-GH1LNA24X-150x150/Mill Finish - With Standard Packing"},{"$f":"Ui_WorkOrder","v":"###"},"ADAD---005","CamLock",0,null,false,null,null,null,null,null,{"$f":"UI_DmpMaterial","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(_xlfn.TEXTBEFORE(Tbl_BOM_Product[[#This Row],[Material]],\"_\",1,1)=\"Stainless Steel\",0.4,0.37)","v":{"$error":"#NAME?"}},null,null,null,null,null,{"$f":"Var_Cut_dist_by_H","v":47.536666666666669},{"$f":"Var_No_Of_Cut_by_H","v":2},2,null,null,null,null,null,{"$f":"Tbl_BOM_Product[[#This Row],[Description]]","v":"CamLock"}]
[null,{"$f":"Var_ProductID_Full","v":"DAD-GH1LNA24X-150x150/Mill Finish - With Standard Packing"},{"$f":"Ui_WorkOrder","v":"###"},"ADAD---006","Hinge",0,null,false,null,null,null,null,null,{"$f":"UI_DmpMaterial","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(_xlfn.TEXTBEFORE(Tbl_BOM_Product[[#This Row],[Material]],\"_\",1,1)=\"Stainless Steel\",0.4,0.37)","v":{"$error":"#NAME?"}},null,null,null,null,null,{"$f":"Var_Cut_dist_by_H","v":47.536666666666669},{"$f":"Var_No_Of_Cut_by_H","v":2},2,null,null,null,null,null,{"$f":"Tbl_BOM_Product[[#This Row],[Description]]","v":"Hinge"}]
[null,{"$f":"Var_ProductID_Full","v":"DAD-GH1LNA24X-150x150/Mill Finish - With Standard Packing"},{"$f":"Ui_WorkOrder","v":"###"},"ADAD---007","Gasket",0,null,false,null,null,null,null,null,{"$f":"UI_DmpMaterial","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(_xlfn.TEXTBEFORE(Tbl_BOM_Product[[#This Row],[Material]],\"_\",1,1)=\"Stainless Steel\",0.4,0.37)","v":{"$error":"#NAME?"}},null,null,null,null,null,{"$f":"Var_Cut_dist_by_H","v":47.536666666666669},{"$f":"Var_No_Of_Cut_by_H","v":2},2,null,null,null,null,null,{"$f":"Tbl_BOM_Product[[#This Row],[Description]]","v":"Gasket"}]

{"sheet":"Advance Code","index":5,"n_rows":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,1,2,3,4,5,6]
[]
["Code","Description","Default",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model"]
["G","Galvanized Steel (G90)",true]
["S4","Stainless Steel 304"]
["S6","Stainless Steel 316L"]
[]
[]
["Code","Description","Default",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Material"]
[null,"Galvanized Steel (G90)",true]
[null,"Stainless Steel 304"]
[null,"Stainless Steel 316L"]
[]
[]
["Code","Description","Default",null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hinge Type"]
[null,"Piano Hinge",true]
[]
[]
["Code","Description","Default",null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hinge Location"]
[null,"Left",true]
[null,"Right"]
[null,"UP"]
[null,"Down"]
[]
[]
["Code","Description","Default",null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Package"]
[null,"Standard",true]
[null,"Carton"]
[null,"W/O Packing"]
[]
[]
["Code","Description","Default",null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fasteners"]
[null,"Rivet 4.8x10",true]

{"sheet":"DAD","index":6,"n_rows":1,"n_cols":30,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,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":"_xlfn.XLOOKUP(DAD_Model,Tbl_dad_model[Description],Tbl_dad_model[Code])&\"-\"&_xlfn.XLOOKUP(DAD_Material,Tbl_dad_Material[Description],Tbl_dad_Material[Code])&_xlfn.XLOOKUP(DAD_Type,Tbl_dad_type[Description],Tbl_dad_type[Code])&_xlfn.XLOOKUP(DAD_Thickness,Tbl_dad_drthk[Description],Tbl_dad_drthk[Code])&_xlfn.XLOOKUP(DAD_PressureClass,Tbl_dad_pressureClass[Description],Tbl_dad_pressureClass[Code])&_xlfn.XLOOKUP(DAD_window,Tbl_dad_windowOption[Description],Tbl_dad_windowOption[Code])&_xlfn.XLOOKUP(DAD_insulation,Tbl_dad_insType[Description],Tbl_dad_insType[Code])&_xlfn.XLOOKUP(DAD_Insulation_Dens,Tbl_dad_insDense[Description],Tbl_dad_insDense[Code])&_xlfn.XLOOKUP(DAD_FireRating,Tbl_dad_frOpt[Description],Tbl_dad_frOpt[Code])&\"-\"&DAD_Width&\"x\"&DAD_Height&\"x\"&DAD_Depth&\"/\"&_xlfn.XLOOKUP(DAD_Finish,Tbl_dad_Finish[Description],Tbl_dad_Finish[Code])","v":{"$error":"#REF!"}}]

{"sheet":"SMACNA TABLE","index":7,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["PRESSURE CLASS","DAD W","DAD H","FRAME","DOOR","BACK"]
["Low",300,300,0.7,0.55000000000000004,0.55000000000000004]
["Low",400,{"$f":"20*25","v":500},0.85,0.7,0.55000000000000004]
["Low",{"$f":"24*25","v":600},{"$f":"24*25","v":600},0.85,0.85,0.55000000000000004]
["Medium",300,300,0.85,0.85,0.55000000000000004]
["Medium",{"$f":"16*25","v":400},500,1,1,0.55000000000000004]
["Medium",600,600,1,1,0.7]
["High",300,300,1,1,0.55000000000000004]
["High",400,500,1,1.2,0.7]
["High",600,600,1.2,1.2,0.7]
[]
[]
["PRESSURE CLASS","DAD W","DAD H","No Of Lock L","No Of Lock R","No Of Lock T","No Of Lock B"]
["Low",300,300,1,1,0,0]
["Low",400,{"$f":"20*25","v":500},2,2,0,0]
["Low",{"$f":"24*25","v":600},{"$f":"24*25","v":600},2,2,0,0]
["Medium",300,300,1,1,0,0]
["Medium",{"$f":"16*25","v":400},500,1,1,1,1]
["Medium",600,600,2,2,1,1]
["High",300,300,1,1,1,1]
["High",400,500,2,2,1,1]
["High",600,600,2,2,2,2]