{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["20XX Summary","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Welding","Coatings","Detailing","Vendor","Fitting"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":17,"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":"20XX Summary","index":0,"n_rows":77,"n_cols":19,"rows_kept":77,"cut":false,"hidden":false,"merged":[[1,14,12,17],[70,18,81,21],[49,15,60,18],[28,15,39,18]]}
[null,"Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)","Total\nHours","Total\nCost"]
["Jan",{"$f":"Jan!D33","v":0},{"$f":"Jan!E33","v":0},{"$f":"Jan!F33","v":0},{"$f":"Jan!G33","v":0},{"$f":"Jan!H33","v":0},{"$f":"Jan!I33","v":0},{"$f":"Jan!J33","v":0},{"$f":"Jan!K33","v":0},{"$f":"Jan!L33","v":0},{"$f":"Jan!M35","v":0},{"$f":"SUM(B2:J2)","v":0},{"$f":"Jan!O35","v":0},null,"This is a montly summary of errors broken down by process.  All of these cells are calculated from monthly data, and will not take user input except for customizing the \"Labor Hours\" value to suit your business."]
["Feb",{"$f":"Feb!D31","v":0},{"$f":"Feb!E31","v":0},{"$f":"Feb!F31","v":0},{"$f":"Feb!G31","v":0},{"$f":"Feb!H31","v":0},{"$f":"Feb!I31","v":0},{"$f":"Feb!J31","v":0},{"$f":"Feb!K31","v":0},{"$f":"Feb!L31","v":0},{"$f":"Feb!M33","v":0},{"$f":"SUM(B3:J3)","v":0},{"$f":"Feb!O33","v":0}]
["Mar",{"$f":"Mar!D33","v":0},{"$f":"Mar!E33","v":0},{"$f":"Mar!F33","v":0},{"$f":"Mar!G33","v":0},{"$f":"Mar!H33","v":0},{"$f":"Mar!I33","v":0},{"$f":"Mar!J33","v":0},{"$f":"Mar!K33","v":0},{"$f":"Mar!L33","v":0},{"$f":"Mar!M35","v":0},0,{"$f":"Mar!O35","v":0}]
["Apr",{"$f":"Apr!D33","v":0},{"$f":"Apr!E33","v":0},{"$f":"Apr!F33","v":0},{"$f":"Apr!G33","v":0},{"$f":"Apr!H33","v":0},{"$f":"Apr!I33","v":0},{"$f":"Apr!J33","v":0},{"$f":"Apr!K33","v":0},{"$f":"Apr!L33","v":0},{"$f":"Apr!M35","v":0},0,{"$f":"Apr!O35","v":0}]
["May",{"$f":"May!D33","v":0},{"$f":"May!E33","v":0},{"$f":"May!F33","v":0},{"$f":"May!G33","v":0},{"$f":"May!H33","v":0},{"$f":"May!I33","v":0},{"$f":"May!J33","v":0},{"$f":"May!K33","v":0},{"$f":"May!L33","v":0},{"$f":"May!M35","v":0},0,{"$f":"May!O35","v":0}]
["Jun",{"$f":"Jun!D33","v":0},{"$f":"Jun!E33","v":0},{"$f":"Jun!F33","v":0},{"$f":"Jun!G33","v":0},{"$f":"Jun!H33","v":0},{"$f":"Jun!I33","v":0},{"$f":"Jun!J33","v":0},{"$f":"Jun!K33","v":0},{"$f":"Jun!L33","v":0},{"$f":"Jun!M35","v":0},0,{"$f":"Jun!O35","v":0}]
["Jul",{"$f":"Jul!D33","v":0},{"$f":"Jul!E33","v":0},{"$f":"Jul!F33","v":0},{"$f":"Jul!G33","v":0},{"$f":"Jul!H33","v":0},{"$f":"Jul!I33","v":0},{"$f":"Jul!J33","v":0},{"$f":"Jul!K33","v":0},{"$f":"Jul!L33","v":0},{"$f":"Jul!M35","v":0},0,{"$f":"Jul!O35","v":0}]
["Aug",{"$f":"Aug!D33","v":0},{"$f":"Aug!E33","v":0},{"$f":"Aug!F33","v":0},{"$f":"Aug!G33","v":0},{"$f":"Aug!H33","v":0},{"$f":"Aug!I33","v":0},{"$f":"Aug!J33","v":0},{"$f":"Aug!K33","v":0},{"$f":"Aug!L33","v":0},{"$f":"Aug!M35","v":0},0,{"$f":"Aug!O35","v":0}]
["Sep",{"$f":"Sep!D33","v":0},{"$f":"Sep!E33","v":0},{"$f":"Sep!F33","v":0},{"$f":"Sep!G33","v":0},{"$f":"Sep!H33","v":0},{"$f":"Sep!I33","v":0},{"$f":"Sep!J33","v":0},{"$f":"Sep!K33","v":0},{"$f":"Sep!L33","v":0},{"$f":"Sep!M35","v":0},0,{"$f":"Sep!O35","v":0}]
["Oct",{"$f":"Oct!D33","v":0},{"$f":"Oct!E33","v":0},{"$f":"Oct!F33","v":0},{"$f":"Oct!G33","v":0},{"$f":"Oct!H33","v":0},{"$f":"Oct!I33","v":0},{"$f":"Oct!J33","v":0},{"$f":"Oct!K33","v":0},{"$f":"Oct!L33","v":0},{"$f":"Oct!M35","v":0},0,{"$f":"Oct!O35","v":0}]
["Nov",{"$f":"Nov!D33","v":0},{"$f":"Nov!E33","v":0},{"$f":"Nov!F33","v":0},{"$f":"Nov!G33","v":0},{"$f":"Nov!H33","v":0},{"$f":"Nov!I33","v":0},{"$f":"Nov!J33","v":0},{"$f":"Nov!K33","v":0},{"$f":"Nov!L33","v":0},{"$f":"Nov!M35","v":0},0,{"$f":"Nov!O35","v":0}]
["Dec",{"$f":"Dec!D33","v":0},{"$f":"Dec!E33","v":0},{"$f":"Dec!F33","v":0},{"$f":"Dec!G33","v":0},{"$f":"Dec!H33","v":0},{"$f":"Dec!I33","v":0},{"$f":"Dec!J33","v":0},{"$f":"Dec!K33","v":0},{"$f":"Dec!L33","v":0},{"$f":"Dec!M35","v":0},0,{"$f":"Dec!O35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B14:K14)","v":0}]
["Totals",{"$f":"SUM(B2:B13)","v":0},0,0,0,0,0,0,0,0]
["Labor",55,55,55,55,55,55,55,55,55]
["Cost",{"$f":"B15*B16","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K2:K13)","v":0},{"$f":"SUM(B15:J15)","v":0},{"$f":"SUM(B17:K17)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use this graph to see how much money you are losing each month due to shop rework hours and backcharges."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This graph can be used as a visual tool to help determine where specific problem areas are.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter in your total annual cost from this sheet as well as previous years to benchmark your progress.  This chart can be helpful in meeting the criteria in Chapter 1.5.2 of Certification Standard."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,108906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,91431]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,52230]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,110000]

{"sheet":"Jan","index":1,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,2],[32,0,32,2],[33,0,33,2],[34,0,34,2]]}
["Date","Job #\n","Pc Mark","Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D3:D32)","v":0},{"$f":"SUM(E3:E32)","v":0},0,{"$f":"SUM(G3:G32)","v":0},0,0,0,0,0,null,null,{"$f":"SUM(D33:L33)","v":0},"Total hours/month"]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D33*D34","v":0},{"$f":"E33*E34","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M3:M32)","v":0},null,{"$f":"SUM(D35:M35)","v":0},"Total cost/month"]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Feb","index":2,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,0,30,2],[31,0,31,2],[32,0,32,2],[34,0,34,2]]}
["Date","Job #\n","Pc Mark","Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D30)","v":0},{"$f":"SUM(E2:E30)","v":0},0,{"$f":"SUM(G2:G30)","v":0},0,0,0,0,0,null,null,{"$f":"SUM(D31:L31)","v":0},"Total hours/month"]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D31*D32","v":0},{"$f":"E31*E32","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M2:M30)","v":0},null,{"$f":"SUM(D33:M33)","v":0},"Total cost/month"]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D31>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E31>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Mar","index":3,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,0,32,2],[33,0,33,2],[34,0,34,2],[36,0,36,2]]}
["Date","Job #\n","Pc Mark","Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D32)","v":0},{"$f":"SUM(E2:E32)","v":0},0,{"$f":"SUM(G2:G32)","v":0},0,0,0,0,0,null,null,{"$f":"SUM(D33:L33)","v":0},"Total hours/month"]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D33*D34","v":0},{"$f":"E33*E34","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M2:M32)","v":0},null,{"$f":"SUM(D35:M35)","v":0},"Total cost/month"]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Apr","index":4,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,0,32,2],[33,0,33,2],[34,0,34,2],[36,0,36,2]]}
["Date","Job #\n","Pc Mark","Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D32)","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(D33:L33)","v":0},"Total hours/month"]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D33*D34","v":0},{"$f":"E33*E34","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M2:M32)","v":0},null,{"$f":"SUM(D35:M35)","v":0},"Total cost/month"]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"May","index":5,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,0,32,2],[33,0,33,2],[34,0,34,2],[36,0,36,2]]}
["Date","Job #\n","Pc Mark","Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D32)","v":0},{"$f":"SUM(E2:E32)","v":0},0,{"$f":"SUM(G2:G32)","v":0},0,0,0,0,0,null,null,{"$f":"SUM(D33:L33)","v":0},"Total hours/month"]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D33*D34","v":0},{"$f":"E33*E34","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M2:M32)","v":0},null,{"$f":"SUM(D35:M35)","v":0},"Total cost/month"]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Jun","index":6,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,0,32,2],[33,0,33,2],[34,0,34,2],[36,0,36,2]]}
["Date","Job #\n","Pc Mark","Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D32)","v":0},{"$f":"SUM(E2:E32)","v":0},0,{"$f":"SUM(G2:G32)","v":0},0,0,0,0,0,null,null,{"$f":"SUM(D33:L33)","v":0},"Total hours/month"]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D33*D34","v":0},{"$f":"E33*E34","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M2:M32)","v":0},null,{"$f":"SUM(D35:M35)","v":0},"Total cost/month"]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Jul","index":7,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,0,32,2],[33,0,33,2],[34,0,34,2],[36,0,36,2]]}
["Date","Job #\n","Pc Mark","Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D32)","v":0},{"$f":"SUM(E2:E32)","v":0},0,{"$f":"SUM(G2:G32)","v":0},0,0,0,0,0,null,null,{"$f":"SUM(D33:L33)","v":0},"Total hours/month"]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D33*D34","v":0},{"$f":"E33*E34","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M2:M32)","v":0},null,{"$f":"SUM(D35:M35)","v":0},"Total cost/month"]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Aug","index":8,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,0,32,2],[33,0,33,2],[34,0,34,2],[36,0,36,2]]}
["Date","Job #\n","Pc Mark","Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D32)","v":0},{"$f":"SUM(E2:E32)","v":0},0,{"$f":"SUM(G2:G32)","v":0},0,0,0,0,0,null,null,{"$f":"SUM(D33:L33)","v":0},"Total hours/month"]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D33*D34","v":0},{"$f":"E33*E34","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M2:M32)","v":0},null,{"$f":"SUM(D35:M35)","v":0},"Total cost/month"]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Sep","index":9,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,0,32,2],[33,0,33,2],[34,0,34,2],[36,0,36,2]]}
["Date","Job #\n","Pc Mark","Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D32)","v":0},{"$f":"SUM(E2:E32)","v":0},0,{"$f":"SUM(G2:G32)","v":0},0,0,0,0,0,null,null,{"$f":"SUM(D33:L33)","v":0},"Total hours/month"]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D33*D34","v":0},{"$f":"E33*E34","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M2:M32)","v":0},null,{"$f":"SUM(D35:M35)","v":0},"Total cost/month"]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Oct","index":10,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,0,32,2],[33,0,33,2],[34,0,34,2],[36,0,36,2]]}
["Date","Job #\n","Pc Mark","Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D32)","v":0},{"$f":"SUM(E2:E32)","v":0},0,{"$f":"SUM(G2:G32)","v":0},0,0,0,0,0,null,null,{"$f":"SUM(D33:L33)","v":0},"Total hours/month"]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D33*D34","v":0},{"$f":"E33*E34","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M2:M32)","v":0},null,{"$f":"SUM(D35:M35)","v":0},"Total cost/month"]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Nov","index":11,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,0,32,2],[33,0,33,2],[34,0,34,2],[36,0,36,2]]}
["Date","Job #\n","Pc Mark","Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D32)","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(D33:L33)","v":0},"Total hours/month"]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D33*D34","v":0},{"$f":"E33*E34","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M2:M32)","v":0},null,{"$f":"SUM(D35:M35)","v":0},"Total cost/month"]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Dec","index":12,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,0,32,2],[33,0,33,2],[34,0,34,2],[36,0,36,2]]}
["Date","Job #\n","Pc Mark","Burn Error  \n(hr)","Detailing Error\n(hr)","Fit Up\n(hr)","Layout Error\n(hr)","Purchasing\n(hr)","Welding\n(hr)","Painting\n(hr)","Shipping\n(hr)","Vendor\n(hr)","Material Cost\n($)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D32)","v":0},{"$f":"SUM(E2:E32)","v":0},0,{"$f":"SUM(G2:G32)","v":0},0,0,0,0,0,null,null,{"$f":"SUM(D33:L33)","v":0},"Total hours/month"]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D33*D34","v":0},{"$f":"E33*E34","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M2:M32)","v":0},null,{"$f":"SUM(D35:M35)","v":0},"Total cost/month"]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E33>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Welding","index":13,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,0,30,2],[31,0,31,2],[32,0,32,2],[34,0,34,2]]}
["Date","Job #","Pc Mark","Cracks","Incomplete Penetration","Lack of Fusion","Lack of Penetration","Oversize Weld","Porosity","Undercut","UT Defect","RT Defect","Wrong Consumable/Process",null,"Dropdown List"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Process"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cracks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incomplete Penetration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lack of Fusion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lack of Penetration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oversize Weld"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porosity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Undercut"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT Defect"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RT Defect"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Consumable"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D30)","v":0},{"$f":"SUM(E2:E30)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(D31:L31)","v":0},{"$f":"IF(O31='20XX Summary'!G15,\"OK\", \"NG\")","v":"OK"}]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D31*D32","v":0},{"$f":"E31*E32","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(D33:M33)","v":0}]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D31>=8,\"CAR REQD.\",\"NO\")","v":"NO"},{"$f":"IF(E31>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Coatings","index":14,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,0,30,2],[31,0,31,2],[32,0,32,2],[34,0,34,2]]}
["Date","Job #","Pc Mark","Wrong Color","Mud Cracking","Orange Peel","Lack of Adhesion","Runs/Sags","Insufficient DFT","Insufficient Blast Profile","Contamination","Blistering","Dry Spray",null,"Dropdown List"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Color"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mud Cracking"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orange Peel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lack of Adhesion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Runs/Sags"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Coating"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insufficient DFT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insufficient Blast Profile"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contamination"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blistering"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dry Spray"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D30)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D31:L31)","v":0},{"$f":"IF(O31='20XX Summary'!H15,\"OK\", \"NG\")","v":"OK"}]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D31*D32","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D33:M33)","v":0}]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D31>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Detailing","index":15,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,0,30,2],[31,0,31,2],[32,0,32,2],[34,0,34,2]]}
["Date","Job #","Pc Mark","Missed Dim","Wrong Dim","No weld symbol","Wrong weld symbol","Insufficient information","Wrong Material","Drawings not checked","Interference of parts","Missing Parts","Misc. error",null,"Dropdown List"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Missed Dim"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Dim"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No weld symbol"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong weld symbol"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insufficient information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Material"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drawings not checked"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interference of parts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Missing Parts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc. error"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D30)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D31:L31)","v":0},{"$f":"IF(O31='20XX Summary'!C15,\"OK\", \"NG\")","v":"OK"}]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D31*D32","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D33:M33)","v":0}]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D31>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Vendor","index":16,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,0,30,2],[31,0,31,2],[32,0,32,2],[34,0,34,2]]}
["Date","Job #","Pc Mark","Misc","Late Delivery","No MTR/CoC","Wrong Material","Defective Material","No ID","Wrong Heat #","No or Wrong CVN's","Damage","Foreign Material",null,"Dropdown List"]
["2007-09-01",6078,"N/A",null,null,null,null,null,null,null,null,null,null,null,"Misc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Late Delivery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No MTR/CoC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Material"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defective Material"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No ID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Heat #"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No or Wrong CVN's"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Spec/Grade"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Damage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Foreign Material"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D30)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D31:L31)","v":0},{"$f":"IF(O31='20XX Summary'!J15,\"OK\", \"NG\")","v":"OK"}]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D31*D32","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D33:M33)","v":0}]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D31>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO"]

{"sheet":"Fitting","index":17,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,0,30,2],[31,0,31,2],[32,0,32,2],[34,0,34,2]]}
["Date","Job #","Pc Mark","Wrong Dimension","Mislocated Holes","Wrong Size Hole","Wrong Detail","Too Long","Too Short","Bad Cope","Cope Wrong Side","Wrong Material","Misc",null,"Dropdown List"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Dimension"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mislocated Holes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Size Hole"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Detail"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Too Long"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Too Short"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bad Cope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cope Wrong Side"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong Material"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Improper Weld Prep"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Monthly Hours",null,null,{"$f":"SUM(D2:D30)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D31:L31)","v":0},{"$f":"IF(O31='20XX Summary'!J15,\"OK\", \"NG\")","v":"OK"}]
["Labor Cost",null,null,55,55,55,55,55,55,55,55,55,55]
["Montly Cost per Error Type",null,null,{"$f":"D31*D32","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D33:M33)","v":0}]
[]
["CAR REQUIRED?",null,null,{"$f":"IF(D31>=8,\"CAR REQD.\",\"NO\")","v":"NO"},"NO","NO","NO","NO","NO","NO","NO","NO","NO"]