{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Input Data","D1","D1 Template","Accessories","AFE_hidden_codesheet_49ddb8b8"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":53,"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":"Input Data","index":0,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,3,15,4],[15,9,15,12],[16,3,16,4],[16,9,16,12],[4,3,4,5],[5,1,5,12],[7,11,7,12],[8,11,8,12],[11,3,11,5],[11,9,11,12],[12,3,12,5],[12,9,12,12],[13,3,13,5],[13,9,13,12],[14,9,14,12]]}
[]
[]
[null,"Fill in field in Green"]
[]
[null,null,"STATUS:","For Fabrication"]
[null,"Bill of Materials - Input Data"]
[]
[null,null,null,"BOM Date",null,null,null,null,null,null,"Detailed By:"]
[null,null,null,"CSM Order #:",null,null,null,null,null,null,"Checked By:"]
[]
[]
[null,null,"Customer:",null,null,null,null,null,"Jobsite Name:"]
[null,null,"Address:",null,null,null,null,null,"Address:"]
[]
[]
[null,null,"Customer PO Number:",null,null,null,null,null,"Jobsite Contact:"]
[null,null,"Date Req'd:",null,null,null,null,null,"Contact Phone:"]

{"sheet":"D1","index":1,"n_rows":58,"n_cols":37,"rows_kept":58,"cut":false,"hidden":false,"merged":[[2,3,2,4],[10,3,10,4],[11,3,11,4],[1,1,1,15],[12,1,12,15],[22,25,22,27],[17,17,17,23],[31,17,31,23],[14,1,14,2],[15,1,16,2],[15,5,16,5],[15,7,16,7],[15,10,16,10],[18,1,18,4],[22,1,22,15],[24,3,24,5],[24,11,24,13],[14,13,14,14]]}
[]
[null,"BILL OF MATERIALS - CSM METAL DECK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop Down Source Area"]
[null,null,"Date:",{"$f":"IF('Input Data'!E8=\"\",\"\",'Input Data'!E8)","v":""},null,null,null,null,null,null,null,null,null,null,"DTLR / CHKR",{"$f":"IF(AND(DtlrName=\"\",ChkrName=\"\"),\"\",DtlrName & \"/\" & ChkrName)","v":""},null,"Panel Options",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deck Gauge","Deck Finish"]
[null,null,"Job Status:",{"$f":"IF(JobStatus=\"None\",\"\",JobStatus)","v":"For Fabrication"},null,null,null,null,null,null,null,null,null,null,"PAGE",null,null,null,"Gauges",null,null,null,null,"Finishes",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(TRANSPOSE(INDEX(Deck_Gauges,MATCH(B16,Deck_Type,0),0))<>0,TRANSPOSE(INDEX(Deck_Gauges,MATCH(B16,Deck_Type,0),0)),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRANSPOSE(INDEX(Deck_Finishes,MATCH(B16,Deck_Type,0),0))<>0,TRANSPOSE(INDEX(Deck_Finishes,MATCH(B16,Deck_Type,0),0)),\"\"),\"\")","v":""}]
[null,null,"CSM Order #:",{"$f":"IF('Input Data'!E9=\"\",\"\",'Input Data'!E9)","v":""},null,null,null,null,null,null,null,null,null,null,"OF",null,null,"Deck Type",1,2,3,4,"Width",1,2,3,4,5,6]
[null,"PROJECT INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B-Deck",22,20,18,16,36,"G60","G90","Ptd G/G","Ptd G/W","Galv/Gray","Galv/White"]
[null,null,"Customer:",{"$f":"IF('Input Data'!D12<>\"\",'Input Data'!D12,\"\")","v":""},null,null,null,null,null,null,null,null,"Jobsite Name:",{"$f":"IF('Input Data'!J12<>\"\",'Input Data'!J12,\"\")","v":""},null,null,null,"N-Deck",22,20,18,16,32,"G60","G90","Ptd G/G","Ptd G/W","Galv/Gray","Galv/White"]
[null,null,"Address:",{"$f":"IF('Input Data'!D13<>\"\",'Input Data'!D13,\"\")","v":""},null,null,null,null,null,null,null,null,"Address:",{"$f":"IF('Input Data'!J13<>\"\",'Input Data'!J13,\"\")","v":""},null,null,null,"1\" RD",26,24,22,20,36,"G60","G90","Ptd G/G","Ptd G/W","Galv/Gray","Galv/White"]
[null,null,null,{"$f":"IF('Input Data'!D14=\"\",\"\",'Input Data'!D14)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF('Input Data'!J14<>\"\",'Input Data'!J14,\"\")","v":""},null,null,null,"1 1/2\" Composite",22,20,18,16,36,"G60","G90","Galv/Gray","Galv/White"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Input Data'!J15<>\"\",'Input Data'!J15,\"\")","v":""},null,null,null,"2\" Composite",22,20,18,16,36,"G60","G90","Galv/Gray","Galv/White"]
[null,null,"PO Number:",{"$f":"IF('Input Data'!D16<>\"\",'Input Data'!D16,\"\")","v":""},null,null,null,null,null,null,null,null,"Jobsite Contact:",{"$f":"IF('Input Data'!J16<>\"\",'Input Data'!J16,\"\")","v":""},null,null,null,"3\" Composite",22,20,18,16,36,"G60","G90","Galv/Gray","Galv/White"]
[null,null,"Date Req'd:",{"$f":"IF('Input Data'!D17<>\"\",'Input Data'!D17,\"\")","v":""},null,null,null,null,null,null,null,null,"Contact Phone:",{"$f":"IF('Input Data'!J17<>\"\",'Input Data'!J17,\"\")","v":""},null,null,null,"1\" Form",26,24,22,20,36,"G60","G90","Galv/Gray","Galv/White"]
[null,"PANEL TYPE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9/16\" Form",26,24,22,null,35,"G60","G90"]
[null,"Select panel data in geen fields from drop down list. Complete fields in yellow if applicable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 1/2\" Form",22,20,18,16,36,"G60","G90","Galv/Gray","Galv/White"]
[null,"Deck Type",null,null,null,"Gauge",null,"Width",null,null,"Finish",null,"Sequence:",null,null,null,null,"2\" Form",22,20,18,16,36,"G60","G90","Galv/Gray","Galv/White"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Deck_Width,MATCH(B16,Deck_Type,0),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,"3\" Form",22,20,18,16,36,"G60","G90","Galv/Gray","Galv/White"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weight per SF"]
[null,"CHECK IF APPLICABLE:",null,null,null,null,null,"Special Coating or Grade:",null,null,null,null,null,"Panel Weight:",{"$f":"IFERROR(INDEX(WgtPerSFTbl,MATCH(B16,Deck_Type,0),MATCH(F16,Deck_Gauge_Hdr,0)),\"\")","v":""},"psf",null,null,"Gauge"]
[null,null,"Interlocking Sidelap",null,null,"Domestic Steel",null,null,null,null,null,null,null,"Total Weight:",{"$f":"SUM(H27:H56)+SUM(P27:P56)","v":0},"lbs",null,"Deck Type",26,24,22,20,18,16]
[null,null,"Screwable Sidelap",null,null,"Hanger Tabs",null,null,null,null,null,null,null,null,null,null,null,"B-Deck",null,null,1.6,2,2.6,3]
[null,null,"Vented",null,null,"Mill Test Report",null,null,null,null,null,null,null,"Total SQ:",{"$f":"SUM(G27:G56)+SUM(O27:O56)","v":0},null,null,"N-Deck",null,null,1.8,2.2999999999999998,3.2,3.7]
[null,"PRODUCTION INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1\" RD",0.9,1.2,1.5,1.8,null,null,null,"Production Limits"]
[null,"Length format is  Ft-integer, In-?.?? (decimal) or ? ?/16 (fraction)",null,null,null,null,null,"if cell turns red = bundle error (check production limit tables to the right)",null,null,null,null,null,null,null,null,null,"1 1/2\" Composite",null,null,1.6,2,2.6,3,null,null,"Max. Bundle Weight:",3900]
[null,null,null,"Length",null,null,null,null,null,null,null,"Length",null,null,null,null,null,"2\" Composite",null,null,1.6,1.9,2.5,3.2,null,null,"Max Panel Length (ft)",45]
[null,"Bdl #","Quantity","Ft-In",null,"Dec","Total SQ","Weight",null,"Bdl #","Quantity","Ft-In",null,"Dec","Total SQ","Weight",null,"3\" Composite",null,null,1.7,2,2.7,3.4,null,null,"Min Panel Length (ft)",4]
[null,null,null,null,null,{"$f":"IF(ROUND(D27,0)+E27/12=0,\"\",ROUND(D27,0)+E27/12)","v":""},{"$f":"IF(OR(C27=\"\",F27=\"\",$H$16=\"\"),\"\",(C27*F27*($H$16/12))/100)","v":""},{"$f":"IF(OR(G27=\"\",$O$19=\"\"),\"\",G27*100*$O$19)","v":""},null,null,null,null,null,{"$f":"IF(ROUND(L27,0)+M27/12=0,\"\",ROUND(L27,0)+M27/12)","v":""},{"$f":"IF(OR(K27=\"\",N27=\"\",$H$16=\"\"),\"\",(K27*N27*($H$16/12))/100)","v":""},{"$f":"IF(OR(O27=\"\",$O$19=\"\"),\"\",O27*100*$O$19)","v":""},null,"1\" Form",0.9,1.2,1.5,1.8]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"9/16\" Form",0.9,1.2,1.4]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"1 1/2\" Form",null,null,1.6,2,2.6,3]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"2\" Form",null,null,1.6,1.9,2.5,3.2]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"3\" Form",null,null,1.7,2,2.7,3.4]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"Max Sheets per Bundle"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,null,"Gauge",null,null,null,null,null,null,"Extra Material Guidelines"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"Deck Type",26,24,22,20,18,16,null,"Cut-up or irregular shape building:"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"B-Deck",null,null,50,50,40,40,null,"0 - 500 SQ:","Add 2% total SQ, increase quantity of longest length sheet"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"N-Deck",null,null,40,30,25,20,null,"500 SQ+:","Add 1% total SQ, increase quantity of longest length sheet"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"1\" RD",80,60,60,50,null,null,null,"Simple or Box Building:"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"1 1/2\" Composite",null,null,40,40,30,30,null,"0 - 500 SQ:","Add 1% total SQ, increase quantity of longest length sheet"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"2\" Composite",null,null,30,30,25,25,null,"500 SQ+:","Add 0.5% total SQ, increase quantity of longest length sheet"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"3\" Composite",null,null,25,25,20,20]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"1\" Form",80,60,60,50,null,null,null,"Logic"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"9/16\" Form",80,60,60,null,null,null,null,"Gauge drop down selection is based on the Deck Type (see panel option table)"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"1 1/2\" Form",null,null,50,50,40,40,null,"Width drop down selection is based on the Deck Type (see panel option table)"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"2\" Form",null,null,30,30,25,25,null,"Finish drop down selection is based on the Deck Type (see panel option table)"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"3\" Form",null,null,25,25,20,20,null,"Panel Weight field is based on the Deck Type and Gauge (see Weight per SF table)"]
[null,null,null,null,null,"",{"$f":"IF(OR(C46=\"\",F46=\"\",$H$16=\"\"),\"\",(C46*F46*($H$16/12))/100)","v":""},"",null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,"Bundle Error Warnings:"]
[null,null,null,null,null,{"$f":"IF(ROUND(D47,0)+E47/12=0,\"\",ROUND(D47,0)+E47/12)","v":""},{"$f":"IF(OR(C47=\"\",F47=\"\",$H$16=\"\"),\"\",(C47*F47*($H$16/12))/100)","v":""},{"$f":"IF(OR(G47=\"\",$O$19=\"\"),\"\",G47*100*$O$19)","v":""},null,null,null,null,null,{"$f":"IF(ROUND(L47,0)+M47/12=0,\"\",ROUND(L47,0)+M47/12)","v":""},{"$f":"IF(OR(K47=\"\",N47=\"\",$H$16=\"\"),\"\",(K47*N47*($H$16/12))/100)","v":""},{"$f":"IF(OR(O47=\"\",$O$19=\"\"),\"\",O47*100*$O$19)","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,null,null,null,null,"","","",null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,"a) Quantity greater than maximum sheets per bundle (see table)"]
[null,null,null,null,null,"","","",null,"Extra Material ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b) Weight greater than Max. Bundle Weight (see Production Limits)"]
[null,null,null,null,null,"","","",null,null,null,null,null,{"$f":"IF(ROUND(L55,0)+M55/12=0,\"\",ROUND(L55,0)+M55/12)","v":""},{"$f":"IF(OR(K55=\"\",N55=\"\",$H$16=\"\"),\"\",(K55*N55*($H$16/12))/100)","v":""},{"$f":"IF(OR(O55=\"\",$O$19=\"\"),\"\",O55*100*$O$19)","v":""},null,null,null,null,null,null,null,null,null,"c) Length greater than Max. Panel Length (see Production Limits)"]
[null,null,null,null,null,"","","",null,null,null,null,null,{"$f":"IF(ROUND(L56,0)+M56/12=0,\"\",ROUND(L56,0)+M56/12)","v":""},{"$f":"IF(OR(K56=\"\",N56=\"\",$H$16=\"\"),\"\",(K56*N56*($H$16/12))/100)","v":""},{"$f":"IF(OR(O56=\"\",$O$19=\"\"),\"\",O56*100*$O$19)","v":""},null,null,null,null,null,null,null,null,null,"d) Length less than Min. Panel Length (see Production Limits)"]
[null,"www.metaldecking.com",null,null,null,null,null,null,null,null,null,null,null,null,"Printed: ",{"$f":"NOW()","v":"2023-06-10T22:13:03.600"},null,null,null,null,null,null,null,null,null,"*If multiple lines are for the same bundle, then the bundle weight shall be the sum "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"of all the lines for that bundle"]

{"sheet":"D1 Template","index":2,"n_rows":58,"n_cols":37,"rows_kept":58,"cut":false,"hidden":true,"merged":[[14,13,14,14],[31,17,31,23],[17,17,17,23],[22,1,22,15],[22,25,22,27],[24,3,24,5],[24,11,24,13],[18,1,18,4],[14,1,14,2],[15,1,16,2],[15,5,16,5],[15,7,16,7],[15,10,16,10],[1,1,1,15],[2,3,2,4],[10,3,10,4],[11,3,11,4],[12,1,12,15]]}
[]
[null,"BILL OF MATERIALS - CSM METAL DECK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop Down Source Area"]
[null,null,"Date:",{"$f":"IF('Input Data'!E8=\"\",\"\",'Input Data'!E8)","v":""},null,null,null,null,null,null,null,null,null,null,"DTLR / CHKR",{"$f":"IF(AND(DtlrName=\"\",ChkrName=\"\"),\"\",DtlrName & \"/\" & ChkrName)","v":""},null,"Panel Options",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deck Gauge","Deck Finish"]
[null,null,"Job Status:",{"$f":"IF(JobStatus=\"None\",\"\",JobStatus)","v":"For Fabrication"},null,null,null,null,null,null,null,null,null,null,"PAGE",null,null,null,"Gauges",null,null,null,null,"Finishes",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(TRANSPOSE(INDEX(Deck_Gauges,MATCH(B16,Deck_Type,0),0))<>0,TRANSPOSE(INDEX(Deck_Gauges,MATCH(B16,Deck_Type,0),0)),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(TRANSPOSE(INDEX(Deck_Finishes,MATCH(B16,Deck_Type,0),0))<>0,TRANSPOSE(INDEX(Deck_Finishes,MATCH(B16,Deck_Type,0),0)),\"\"),\"\")","v":""}]
[null,null,"CSM Order #:",{"$f":"IF('Input Data'!E9=\"\",\"\",'Input Data'!E9)","v":""},null,null,null,null,null,null,null,null,null,null,"OF",null,null,"Deck Type",1,2,3,4,"Width",1,2,3,4,5,6]
[null,"PROJECT INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B-Deck",22,20,18,16,36,"G60","G90","Ptd G/G","Ptd G/W","Galv/Gray","Galv/White"]
[null,null,"Customer:",{"$f":"IF('Input Data'!D12<>\"\",'Input Data'!D12,\"\")","v":""},null,null,null,null,null,null,null,null,"Jobsite Name:",{"$f":"IF('Input Data'!J12<>\"\",'Input Data'!J12,\"\")","v":""},null,null,null,"N-Deck",22,20,18,16,32,"G60","G90","Ptd G/G","Ptd G/W","Galv/Gray","Galv/White"]
[null,null,"Address:",{"$f":"IF('Input Data'!D13<>\"\",'Input Data'!D13,\"\")","v":""},null,null,null,null,null,null,null,null,"Address:",{"$f":"IF('Input Data'!J13<>\"\",'Input Data'!J13,\"\")","v":""},null,null,null,"1\" RD",26,24,22,20,36,"G60","G90","Ptd G/G","Ptd G/W","Galv/Gray","Galv/White"]
[null,null,null,{"$f":"IF('Input Data'!D14=\"\",\"\",'Input Data'!D14)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF('Input Data'!J14<>\"\",'Input Data'!J14,\"\")","v":""},null,null,null,"1 1/2\" Composite",22,20,18,16,36,"G60","G90","Galv/Gray","Galv/White"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Input Data'!J15<>\"\",'Input Data'!J15,\"\")","v":""},null,null,null,"2\" Composite",22,20,18,16,36,"G60","G90","Galv/Gray","Galv/White"]
[null,null,"PO Number:",{"$f":"IF('Input Data'!D16<>\"\",'Input Data'!D16,\"\")","v":""},null,null,null,null,null,null,null,null,"Jobsite Contact:",{"$f":"IF('Input Data'!J16<>\"\",'Input Data'!J16,\"\")","v":""},null,null,null,"3\" Composite",22,20,18,16,36,"G60","G90","Galv/Gray","Galv/White"]
[null,null,"Date Req'd:",{"$f":"IF('Input Data'!D17<>\"\",'Input Data'!D17,\"\")","v":""},null,null,null,null,null,null,null,null,"Contact Phone:",{"$f":"IF('Input Data'!J17<>\"\",'Input Data'!J17,\"\")","v":""},null,null,null,"1\" Form",26,24,22,20,36,"G60","G90","Galv/Gray","Galv/White"]
[null,"PANEL TYPE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9/16\" Form",26,24,22,null,35,"G60","G90"]
[null,"Select panel data in geen fields from drop down list. Complete fields in yellow if applicable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 1/2\" Form",22,20,18,16,36,"G60","G90","Galv/Gray","Galv/White"]
[null,"Deck Type",null,null,null,"Gauge",null,"Width",null,null,"Finish",null,"Sequence:",null,null,null,null,"2\" Form",22,20,18,16,36,"G60","G90","Galv/Gray","Galv/White"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Deck_Width,MATCH(B16,Deck_Type,0),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,"3\" Form",22,20,18,16,36,"G60","G90","Galv/Gray","Galv/White"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weight per SF"]
[null,"CHECK IF APPLICABLE:",null,null,null,null,null,"Special Coating or Grade:",null,null,null,null,null,"Panel Weight:",{"$f":"IFERROR(INDEX(WgtPerSFTbl,MATCH(B16,Deck_Type,0),MATCH(F16,Deck_Gauge_Hdr,0)),\"\")","v":""},"psf",null,null,"Gauge"]
[null,null,"Interlocking Sidelap",null,null,"Domestic Steel",null,null,null,null,null,null,null,"Total Weight:",{"$f":"SUM(H27:H56)+SUM(P27:P56)","v":0},"lbs",null,"Deck Type",26,24,22,20,18,16]
[null,null,"Screwable Sidelap",null,null,"Hanger Tabs",null,null,null,null,null,null,null,null,null,null,null,"B-Deck",null,null,1.6,2,2.6,3]
[null,null,"Vented",null,null,"Mill Test Report",null,null,null,null,null,null,null,"Total SQ:",{"$f":"SUM(G27:G56)+SUM(O27:O56)","v":0},null,null,"N-Deck",null,null,1.8,2.2999999999999998,3.2,3.7]
[null,"PRODUCTION INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1\" RD",0.9,1.2,1.5,1.8,null,null,null,"Production Limits"]
[null,"Length format is  Ft-integer, In-?.?? (decimal) or ? ?/16 (fraction)",null,null,null,null,null,"if cell turns red = bundle error (check production limit tables to the right)",null,null,null,null,null,null,null,null,null,"1 1/2\" Composite",null,null,1.6,2,2.6,3,null,null,"Max. Bundle Weight:",3900]
[null,null,null,"Length",null,null,null,null,null,null,null,"Length",null,null,null,null,null,"2\" Composite",null,null,1.6,1.9,2.5,3.2,null,null,"Max Panel Length (ft)",45]
[null,"Bdl #","Quantity","Ft-In",null,"Dec","Total SQ","Weight",null,"Bdl #","Quantity","Ft-In",null,"Dec","Total SQ","Weight",null,"3\" Composite",null,null,1.7,2,2.7,3.4,null,null,"Min Panel Length (ft)",4]
[null,null,null,null,null,{"$f":"IF(ROUND(D27,0)+E27/12=0,\"\",ROUND(D27,0)+E27/12)","v":""},{"$f":"IF(OR(C27=\"\",F27=\"\",$H$16=\"\"),\"\",(C27*F27*($H$16/12))/100)","v":""},{"$f":"IF(OR(G27=\"\",$O$19=\"\"),\"\",G27*100*$O$19)","v":""},null,null,null,null,null,{"$f":"IF(ROUND(L27,0)+M27/12=0,\"\",ROUND(L27,0)+M27/12)","v":""},{"$f":"IF(OR(K27=\"\",N27=\"\",$H$16=\"\"),\"\",(K27*N27*($H$16/12))/100)","v":""},{"$f":"IF(OR(O27=\"\",$O$19=\"\"),\"\",O27*100*$O$19)","v":""},null,"1\" Form",0.9,1.2,1.5,1.8]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"9/16\" Form",0.9,1.2,1.4]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"1 1/2\" Form",null,null,1.6,2,2.6,3]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"2\" Form",null,null,1.6,1.9,2.5,3.2]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"3\" Form",null,null,1.7,2,2.7,3.4]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"Max Sheets per Bundle"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,null,"Gauge",null,null,null,null,null,null,"Extra Material Guidelines"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"Deck Type",26,24,22,20,18,16,null,"Cut-up or irregular shape building:"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"B-Deck",null,null,50,50,40,40,null,"0 - 500 SQ:","Add 2% total SQ, increase quantity of longest length sheet"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"N-Deck",null,null,30,25,25,null,null,"500 SQ+:","Add 1% total SQ, increase quantity of longest length sheet"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"1\" RD",80,60,60,50,null,null,null,"Simple or Box Building:"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"1 1/2\" Composite",null,null,40,40,30,30,null,"0 - 500 SQ:","Add 1% total SQ, increase quantity of longest length sheet"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"2\" Composite",null,null,30,30,25,25,null,"500 SQ+:","Add 0.5% total SQ, increase quantity of longest length sheet"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"3\" Composite",null,null,25,25,20,20]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"1\" Form",80,60,60,50,null,null,null,"Logic"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"9/16\" Form",80,60,60,null,null,null,null,"Gauge drop down selection is based on the Deck Type (see panel option table)"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"1 1/2\" Form",null,null,50,50,40,40,null,"Width drop down selection is based on the Deck Type (see panel option table)"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"2\" Form",null,null,30,30,25,25,null,"Finish drop down selection is based on the Deck Type (see panel option table)"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,"3\" Form",null,null,25,25,20,20,null,"Panel Weight field is based on the Deck Type and Gauge (see Weight per SF table)"]
[null,null,null,null,null,"","","",null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,"Bundle Error Warnings:"]
[null,null,null,null,null,{"$f":"IF(ROUND(D47,0)+E47/12=0,\"\",ROUND(D47,0)+E47/12)","v":""},{"$f":"IF(OR(C47=\"\",F47=\"\",$H$16=\"\"),\"\",(C47*F47*($H$16/12))/100)","v":""},{"$f":"IF(OR(G47=\"\",$O$19=\"\"),\"\",G47*100*$O$19)","v":""},null,null,null,null,null,{"$f":"IF(ROUND(L47,0)+M47/12=0,\"\",ROUND(L47,0)+M47/12)","v":""},{"$f":"IF(OR(K47=\"\",N47=\"\",$H$16=\"\"),\"\",(K47*N47*($H$16/12))/100)","v":""},{"$f":"IF(OR(O47=\"\",$O$19=\"\"),\"\",O47*100*$O$19)","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,null,null,null,null,"","","",null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,"a) Quantity greater than maximum sheets per bundle (see table)"]
[null,null,null,null,null,"","","",null,"Extra Material ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b) Weight greater than Max. Bundle Weight (see Production Limits)"]
[null,null,null,null,null,"","","",null,null,null,null,null,{"$f":"IF(ROUND(L55,0)+M55/12=0,\"\",ROUND(L55,0)+M55/12)","v":""},{"$f":"IF(OR(K55=\"\",N55=\"\",$H$16=\"\"),\"\",(K55*N55*($H$16/12))/100)","v":""},{"$f":"IF(OR(O55=\"\",$O$19=\"\"),\"\",O55*100*$O$19)","v":""},null,null,null,null,null,null,null,null,null,"c) Length greater than Max. Panel Length (see Production Limits)"]
[null,null,null,null,null,"","","",null,null,null,null,null,{"$f":"IF(ROUND(L56,0)+M56/12=0,\"\",ROUND(L56,0)+M56/12)","v":""},{"$f":"IF(OR(K56=\"\",N56=\"\",$H$16=\"\"),\"\",(K56*N56*($H$16/12))/100)","v":""},{"$f":"IF(OR(O56=\"\",$O$19=\"\"),\"\",O56*100*$O$19)","v":""},null,null,null,null,null,null,null,null,null,"d) Length less than Min. Panel Length (see Production Limits)"]
[null,"www.metaldecking.com",null,null,null,null,null,null,null,null,null,null,null,null,"Printed: ",{"$f":"NOW()","v":"2023-06-10T22:13:03.600"},null,null,null,null,null,null,null,null,null,"*If multiple lines are for the same bundle, then the bundle weight shall be the sum "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"of all the lines for that bundle"]

{"sheet":"Accessories","index":3,"n_rows":57,"n_cols":19,"rows_kept":57,"cut":false,"hidden":false,"merged":[[51,11,51,14],[54,11,54,14],[53,11,53,14],[46,11,46,14],[47,11,47,14],[48,11,48,14],[49,11,49,14],[50,11,50,14],[17,1,17,15],[42,11,42,14],[43,11,43,14],[44,11,44,14],[45,11,45,14],[1,1,1,15],[6,12,6,15],[7,12,7,15],[8,12,8,15],[5,1,5,15],[13,3,13,5],[13,11,13,13],[55,11,55,14],[9,12,9,15],[10,12,10,15],[41,11,41,14],[11,12,11,15],[34,4,34,6],[35,11,35,14],[34,8,35,8],[36,11,36,14],[37,11,37,14],[38,11,38,14],[39,11,39,14],[40,11,40,14],[12,1,12,15]]}
[]
[null,"DECK ACCESSORIES - CSM METAL DECK"]
[null,null,"Date:",{"$f":"'Input Data'!E8","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,"DTLR / CHKR",{"$f":"DtlrName & \"/\" & ChkrName","v":"/"}]
[null,null,"Job Status:",{"$f":"IF(JobStatus=\"None\",\"\",JobStatus)","v":"For Fabrication"},null,null,null,null,null,null,null,null,null,null,"PAGE"]
[null,null,"CSM Order #:",{"$f":"'Input Data'!E9","v":0},null,null,null,null,null,null,null,null,null,null,"OF"]
[null,"PROJECT INFORMATION"]
[null,null,"Customer:",{"$f":"'Input Data'!D12","v":0},null,null,null,null,null,null,null,"Jobsite Name:",{"$f":"'Input Data'!J12","v":0}]
[null,null,"Address:",{"$f":"'Input Data'!D13","v":0},null,null,null,null,null,null,null,"Address:",{"$f":"'Input Data'!J13","v":0}]
[null,null,null,{"$f":"'Input Data'!D14","v":0},null,null,null,null,null,null,null,null,{"$f":"'Input Data'!J14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!J15","v":0}]
[null,null,"PO Number:",{"$f":"'Input Data'!D16","v":0},null,null,null,null,null,null,null,"Jobsite Contact:",{"$f":"'Input Data'!J16","v":0}]
[null,null,"Date Req'd:",{"$f":"'Input Data'!D17","v":"00:00:00"},null,null,null,null,null,null,null,"Contact Phone:",{"$f":"'Input Data'!J17","v":0}]
[null,"REQUIRED FASTENERS"]
[null,null,null,"Type",null,null,"Quantity",null,null,null,null,"Type",null,null,"Quantity"]
[null,null,"Support Screws:",null,null,null,null,null,null,null,"Support Screws:"]
[null,null,"Sidelap Screws:",null,null,null,null,null,null,null,"Sidelap Screws:"]
[null,null,"Other:",null,null,null,null,null,null,null,"Other:"]
[null,"PRODUCTION INFORMATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Complete fields in yellow if applicable, Default Length for accessories is 10'-0\" (120\")"]
[null,null,null,null,"Dimensions (inches)",null,null,null,"Length (inches)"]
[null,"Type","Pieces","Gauge","A","B","C","Angle",null,"Finish","Wt (psf)","Description",null,null,null,"Weight"]
[null,null,null,null,null,null,null,null,120,null,{"$f":"IF(D37=\"\",\"\",VLOOKUP(D37,$R$39:$S$47,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(D37=\"\",\"\",((E37+F37+G37)/12)*(I37/12)*K37*C37)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,"Gauge","Weight per SF"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,26,0.90600000000000003]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,24,1.1559999999999999]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,22,1.4059999999999999]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,20,1.6559999999999999]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,18,2.1560000000000001]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,16,2.6560000000000001]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,14,3.2810000000000001]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,12,4.5309999999999997]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,10,5.718]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,"Logic"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","1)","Weight selection is based on the Gauge (weight per SF table)"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","2)","Max. length is 120\""]
[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(D54=\"\",\"\",VLOOKUP(D54,$R$39:$S$47,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(D54=\"\",\"\",((E54+F54+G54)/12)*(I54/12)*K54*C54)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D55=\"\",\"\",VLOOKUP(D55,$R$39:$S$47,2,FALSE))","v":""},null,null,null,null,{"$f":"IF(D55=\"\",\"\",((E55+F55+G55)/12)*(I55/12)*K55*C55)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Accessory Weight:",null,null,null,{"$f":"SUM(P37:P55)","v":0}]
[null,"www.metaldecking.com",null,null,null,null,null,null,null,null,null,null,null,null,"Printed: ",{"$f":"NOW()","v":"2023-06-10T22:13:03.600"}]

{"sheet":"AFE_hidden_codesheet_49ddb8b8","index":4,"n_rows":68,"n_cols":6,"rows_kept":68,"cut":false,"hidden":true,"merged":[]}
["rows","columns","namespace","name","start","code_0"]
[1,1,1,1,1,66]
[68,6,null,"Workbook",0,"BdlCol1 = 'D1'!$B$32:$B$69;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"BdlCol2 = 'D1'!$J$32:$J$69;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"ChkrName = 'Input Data'!$L$9;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"Deck_Finish_List = 'Drop Lists'!$D$2 :"]
[null,null,null,null,null,"    INDEX("]
[null,null,null,null,null,"        'Drop Lists'!$D:$D,"]
[null,null,null,null,null,"        MAX(('Drop Lists'!$D:$D <> 0) * (ROW('Drop Lists'!$D:$D)))"]
[null,null,null,null,null,"    );"]
[null,null,null,null,null,""]
[null,null,null,null,null,"Deck_Finish_Row = TRANSPOSE("]
[null,null,null,null,null,"    INDEX(Deck_Finishes, MATCH(DeckTypeChoice, Deck_Type, 0), )"]
[null,null,null,null,null,");"]
[null,null,null,null,null,""]
[null,null,null,null,null,"Deck_Finishes = 'D1'!$X$5:$AA$13;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"Deck_Gauge_Hdr = 'D1'!$S$19:$X$19;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"Deck_Gauge_Index = IFERROR(MATCH(DeckGageChoice, Deck_Gauge, 0), 0);"]
[null,null,null,null,null,""]
[null,null,null,null,null,"Deck_Gauge_List = 'Drop Lists'!$B$2 :"]
[null,null,null,null,null,"    INDEX("]
[null,null,null,null,null,"        'Drop Lists'!$B:$B,"]
[null,null,null,null,null,"        MAX(('Drop Lists'!$B:$B <> 0) * (ROW('Drop Lists'!$B:$B)))"]
[null,null,null,null,null,"    );"]
[null,null,null,null,null,""]
[null,null,null,null,null,"Deck_Gauge_Row = TRANSPOSE("]
[null,null,null,null,null,"    INDEX(Deck_Gauges, MATCH(DeckTypeChoice, Deck_Type, 0), )"]
[null,null,null,null,null,");"]
[null,null,null,null,null,""]
[null,null,null,null,null,"Deck_Gauge_Row_count = COUNT('Drop Lists'!$B:$B);"]
[null,null,null,null,null,""]
[null,null,null,null,null,"Deck_Gauges = 'D1'!$S$5:$V$13;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"Deck_Type = 'D1'!$R$5:$R$13;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"Deck_Type_Index = IFERROR(MATCH(DeckTypeChoice, Deck_Type, 0), 0);"]
[null,null,null,null,null,""]
[null,null,null,null,null,"Deck_Width = 'D1'!$W$5:$W$13;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"DeckGageChoice = 'D1'!$F$17;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"DeckTypeChoice = 'D1'!$B$17;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"DtlrName = 'Input Data'!$L$8;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"JobStatus = 'Input Data'!$D$5;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"MaxBdlWgt = 'D1'!$T$45;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"MaxPnlLen = 'D1'!$T$46;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"MaxShtPerBdl = INDEX("]
[null,null,null,null,null,"    MaxShtPerBdlTbl,"]
[null,null,null,null,null,"    MATCH(DeckTypeChoice, Deck_Type, 0),"]
[null,null,null,null,null,"    MATCH(DeckGageChoice, Deck_Gauge_Hdr, 0)"]
[null,null,null,null,null,");"]
[null,null,null,null,null,""]
[null,null,null,null,null,"MaxShtPerBdlTbl = 'D1'!$R$33:$W$42;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"MinPnlLen = 'D1'!$T$47;"]
[null,null,null,null,null,""]
[null,null,null,null,null,"WgtPerSFTbl = 'D1'!$R$19:$X$28;"]
[null,null,null,null,null,"MaxWgtPerSF = INDEX(WgtPerSFTbl, MATCH(DeckTypeChoice, Deck_Type, 0), MATCH(DeckGageChoice, Deck_Gauge_Hdr, 0));"]