{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Sheet2","Calcs","Macros","Graph Data"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[5,30,6,45],[40,0,40,45],[41,0,41,45],[7,39,7,40],[7,30,7,38],[20,32,20,35],[17,32,17,39],[22,0,22,4],[22,5,22,9],[22,10,22,14],[27,10,27,14],[28,10,28,14],[29,10,29,14],[25,0,25,9],[26,0,26,9],[27,0,27,9],[28,0,28,9],[29,0,29,9],[3,13,3,41],[5,24,6,29],[6,0,6,4],[20,5,21,9],[11,16,11,17],[12,16,12,17],[11,18,11,22],[12,18,12,22],[8,30,8,45],[14,30,14,45],[15,30,15,45],[7,41,7,45],[10,24,12,29],[10,30,12,45],[14,8,14,22],[15,8,15,22],[8,24,8,29],[14,0,14,7],[18,27,18,30],[18,16,18,22],[19,16,19,22],[19,23,19,26],[19,27,19,30],[20,16,20,22],[0,13,2,41],[14,24,14,29],[15,24,15,29],[24,0,24,14],[20,27,20,30],[21,16,21,22],[21,23,21,26],[21,27,21,30],[21,32,21,35],[22,32,23,35],[18,36,18,39],[19,36,19,39],[20,36,20,39],[21,36,21,39],[22,36,23,39],[18,32,18,35],[7,24,7,29],[9,24,9,29],[9,30,9,45],[11,0,11,4],[12,0,12,4],[11,5,11,15],[12,5,12,15],[18,23,18,26],[25,32,26,35],[25,36,26,39],[19,32,19,35],[5,0,5,4],[5,5,5,22],[6,5,6,22],[7,5,7,22],[8,5,8,22],[9,5,9,22],[17,23,17,26],[17,27,17,30],[17,16,17,22],[26,16,26,22],[26,23,26,26],[26,27,26,30],[24,16,24,22],[24,23,24,26],[24,27,24,30],[15,0,15,7],[9,0,9,4],[8,0,8,4],[7,0,7,4],[20,0,21,4],[20,10,21,14],[33,0,38,14],[35,16,35,30],[36,16,36,30],[37,16,37,30],[38,16,38,30],[22,27,22,30],[23,16,23,22],[23,23,23,26],[23,27,23,30],[30,0,30,9],[30,10,30,14],[27,16,27,22],[27,23,27,26],[27,27,27,30],[28,16,28,22],[28,23,28,26],[28,27,28,30],[32,23,33,26],[32,27,33,30],[32,16,33,22],[31,16,31,22],[31,23,31,26],[31,27,31,30],[29,16,29,22],[20,23,20,26],[25,10,25,14],[26,10,26,14],[25,16,25,22],[25,23,25,26],[25,27,25,30],[22,16,22,22],[22,23,22,26],[32,0,32,14],[29,23,29,26],[29,27,29,30],[30,16,30,22],[30,23,30,26],[30,27,30,30]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Return On Investment Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4417despairMt"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"based on an increase of yield and a reduction of labor, scrap and mold damage"]
[]
["Company",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Workcell ID",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This form is provided by Yushin America as an example of calculating the Return on Investment of capital equipment."]
["Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"It is not a guarantee of actual results.  Yushin is not responsible for accuracy of the data input or content. "]
["Contact name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposal number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
["Contact phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Robot manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use of this form:"]
["Contact e-mail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Robot model",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEXT DATA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter data in those cells highlighted in light green."]
["Data provided by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Although inclusion of all data in the fields is not required, it may prove helpful when reviewing multiple printed copies."]
["Data entered by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To easily reset all manually inputted text fields to their blank condition, click the \"Clear Text Data\" button."]
[]
["Sales contact organization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales contact phone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATION DATA"]
["Sales contact name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales contact e-mail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter data in those cells highlighted in light green."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If the capital, installation and other costs are entered before the data, the estimated savings will update with each relevant entry."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OPERATION",null,null,null,null,null,null,"CURRENT",null,null,null,"EXPECTED",null,null,null,null,"ESTIMATED SAVINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Although inclusion of all data in the fields is not required, the more data provided will enable more accurate results."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"number of operators",null,null,null,null,null,null,null,null,null,null,{"$f":"+X19","v":0},null,null,null,null,"Incr. yield",null,null,null,{"$f":"+Calcs!L11","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"The formula in the expected overall cycle field can be overtyped."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hrs / operator / week",null,null,null,null,null,null,null,null,null,null,{"$f":"+X20","v":0},null,null,null,null,"Decr. labor",null,null,null,{"$f":"+Calcs!L10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"To easily reset all manually inputted data fields to their blank condition, click the \"Reset Calculations\" button."]
["profit result after 1 year",null,null,null,null,"profit result after 2 years",null,null,null,null,"profit result after 3 years",null,null,null,null,null,"burdened labor $ / hr",null,null,null,null,null,null,null,null,null,null,{"$f":"+X21","v":0},null,null,null,null,"Decr. scrap",null,null,null,{"$f":"+Calcs!L9","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"weeks / year",null,null,null,null,null,null,null,null,null,null,{"$f":"+X22","v":0},null,null,null,null,"Decr. Damage",null,null,null,{"$f":"+Calcs!L8","v":{"$error":"#DIV/0!"}}]
[{"$f":"+Calcs!L15","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"+Calcs!L16","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"+Calcs!L17","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"total machine hrs / wk",null,null,null,null,null,null,{"$f":"+X19*X20","v":0},null,null,null,{"$f":"+X23","v":0},null,null,null,null,"Total First Year Savings",null,null,null,{"$f":"SUM(AK19:AN22)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"workcell productivity %",null,null,null,null,null,null,null,null,null,null,{"$f":"+X24","v":0}]
["ESTIMATED EXPENSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"number of cavities",null,null,null,null,null,null,null,null,null,null,{"$f":"+X25","v":0}]
["Equipment costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"part cost ($ / 1,000)",null,null,null,null,null,null,null,null,null,null,{"$f":"+X26","v":0},null,null,null,null,"months to pay-off",null,null,null,{"$f":"+Calcs!L21","v":{"$error":"#DIV/0!"}}]
["Installation costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"part sell price ($ / 1,000)",null,null,null,null,null,null,null,null,null,null,{"$f":"+X27","v":0}]
["Facility costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mold open (seconds)"]
["Training costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"overall cycle (seconds)",null,null,null,null,null,null,null,null,null,null,{"$f":"+X29-(X28-AB28)","v":0}]
["Other costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"scrap %"]
["TOTAL COSTS",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K26:O30)","v":0},null,null,null,null,null,"scrap disposal ($/1000)",null,null,null,null,null,null,null,null,null,null,{"$f":"+X31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mold damage"]
["INSTRUCTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lost production hours due to mold damage"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yushin America, Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35 Kenney Drive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cranston, RI  02920  USA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"401 463-1800        www.yushinamerica.com"]
[]
["The information contained within this document is an example of an ROI calculation.   "]
["The actual payback shown is an estimate based upon the information provided and is not guaranteed."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4177mtdespair"]

{"sheet":"Sheet2","index":1,"n_rows":68,"n_cols":6,"rows_kept":68,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"PROFITS FROM ADDITIONAL YIELD","current","expected","current","expected"]
[null,"parts cost ( $ / 1,000)",10.55,{"$f":"+C5","v":10.55},{"$f":"+C5","v":10.55},10.55]
[null,"part sell price ( $ / 1,000)",12.1212,{"$f":"+C6","v":12.1212},12.1212,12.1212]
[null,"number of cavities",8,{"$f":"+C7","v":8},8,8]
[null,"total machine hours per week",45,{"$f":"+C8","v":45},45,45]
[null,"weeks per year",51,51,51,51]
[null,"overall cycle time",16,14,16,14]
[null,"workcell productivity percentage",0.97499999999999998,0.98,0.97499999999999998,0.98]
[null,"cycles per hour",null,null,{"$f":"(60*60)/E10","v":225},{"$f":"(60*60)/F10","v":257.14285714285717}]
[null,"parts per hour",null,null,{"$f":"+E7*E12","v":1800},{"$f":"+F7*F12","v":2057.1428571428573}]
[null,"parts per year at 100% productivity",null,null,{"$f":"+E8*E9*E13","v":4131000},{"$f":"+F8*F9*F13","v":4721142.8571428573}]
[null,"parts per year at workcell productivity",null,null,{"$f":"+E11*E14","v":4027725},{"$f":"+F11*F14","v":4626720}]
[null,"part profitability per year",null,null,{"$f":"(+E6-E5)*E15","v":6328361.5199999968},{"$f":"(+F6-F5)*F15","v":7269502.4639999969}]
[]
[null,"ADDITIONAL PARTS PROFIT",{"$f":"+F16-E16","v":941140.94400000013}]
[]
[]
[]
[null,"LABOR SAVINGS","current","expected","current","expected"]
[null,"number of operators",1,{"$f":"+C23","v":1},{"$f":"+C23","v":1},1]
[null,"hours per operator per week",45,40,45,40]
[null,"weeks per year",{"$f":"+C9","v":51},{"$f":"+D9","v":51},51,51]
[null,"full burdened labor cost per hour",18.5,{"$f":"+C26","v":18.5},18.5,18.5]
[null,"labor hours per year",null,null,{"$f":"+E23*E24*E25","v":2295},{"$f":"+F23*F24*F25","v":2040}]
[null,"labor dollars per year",null,null,{"$f":"+E26*E27","v":42457.5},{"$f":"+F26*F27","v":37740}]
[]
[null,"TOTAL LABOR SAVINGS",{"$f":"+E28-F28","v":4717.5}]
[]
[]
[]
[null,"SCRAP COSTS","current","expected","current","expected"]
[null,"parts cost ( $ / 1,000)",{"$f":"+C5","v":10.55},{"$f":"+C35","v":10.55},{"$f":"+C35","v":10.55},10.55]
[null,"part sell price ( $ / 1,000)",{"$f":"+C6","v":12.1212},{"$f":"+D6","v":12.1212},12.1212,12.1212]
[null,"percentage of scrap",4.7500000000000001E-2,1.7500000000000002E-2,4.7500000000000001E-2,1.7500000000000002E-2]
[null,"cost to dispose of scrap ($/1000)",8.5,{"$f":"+C38","v":8.5},8.5,8.5]
[null,"number of cavities",{"$f":"+C7","v":8},8,8,8]
[null,"total machine hours per week",45,45,45,45]
[null,"weeks per year",51,51,51,51]
[null,"overall cycle time (seconds)",16,14,16,14]
[null,"cycles per hour",null,null,{"$f":"(60*60)/E42","v":225},{"$f":"(60*60)/F42","v":257.14285714285717}]
[null,"parts per hour",null,null,{"$f":"+E39*E43","v":1800},{"$f":"+F39*F43","v":2057.1428571428573}]
[null,"parts per year",null,null,{"$f":"+E40*E41*E44","v":4131000},{"$f":"+F40*F41*F44","v":4721142.8571428573}]
[null,"scrapped parts per year",null,null,{"$f":"+E37*E45","v":196222.5},{"$f":"+F37*F45","v":82620.000000000015}]
[null,"lost profit of scrapped parts per year",null,null,{"$f":"((+E36-E35)*E46)/1000","v":308.30479199999985},{"$f":"((+F36-F35)*F46)/1000","v":129.81254399999997}]
[null,"cost to dispose of scrap",null,null,{"$f":"(+E46/1000)*E38","v":1667.8912499999999},{"$f":"(+F46/1000)*F38","v":702.27000000000021}]
[]
[null,"TOTAL COST DUE TO SCRAP",{"$f":"(+E47+E48)-(F47+F48)","v":1144.1134979999997}]
[]
[]
[]
[null,"REPAIR COSTS","current","expected","current","expected"]
[null,"mold damage (dollars)",5000,150,{"$f":"+C55","v":5000},150]
[null,"lost production hours due to mold damage",24,0,24,0]
[null,"number of cavities",{"$f":"+C7","v":8},{"$f":"+D7","v":8},8,8]
[null,"parts cost ( $ / 1,000)",10.55,{"$f":"+C58","v":10.55},10.55,10.55]
[null,"part sell price ( $ / 1,000)",12.1212,{"$f":"+C59","v":12.1212},12.1212,12.1212]
[null,"overall cycle time (seconds)",16,14,16,14]
[null,"profit per 1,000 parts",null,null,{"$f":"+E59-E58","v":1.5711999999999993},{"$f":"+F59-F58","v":1.5711999999999993}]
[null,"profit per cycle",null,null,{"$f":"(+E57*E61)/1000","v":1.2569599999999993E-2},{"$f":"(+F57*F61)/1000","v":1.2569599999999993E-2}]
[null,"cycles per hour",null,null,{"$f":"(60*60)/E60","v":225},{"$f":"(60*60)/F60","v":257.14285714285717}]
[null,"parts per hour",null,null,{"$f":"+E57*E63","v":1800},{"$f":"+F57*F63","v":2057.1428571428573}]
[null,"lost parts due to mold damage",null,null,{"$f":"+E56*E64","v":43200},{"$f":"+F56*F64","v":0}]
[null,"lost profit due to mold damage",null,null,{"$f":"(+E61/1000)*E65","v":67.875839999999968},{"$f":"(+F61/1000)*F65","v":0}]
[]
[null,"TOTAL COST DUE TO MOLD DAMAGE",{"$f":"+E55+E66-F55","v":4917.8758399999997}]

{"sheet":"Calcs","index":2,"n_rows":105,"n_cols":32,"rows_kept":105,"cut":false,"hidden":true,"merged":[[27,7,27,8],[21,7,21,8],[22,7,22,8],[26,7,26,8],[23,7,23,8],[24,7,24,8],[25,7,25,8]]}
[]
[]
["R","S","L","P","I","U",null,"current","expected",null,"RETURN ON INVESTMENT",null,null,"PROFITS FROM ADDITIONAL PRODUCTS","current","expected",null,"LABOR SAVINGS","current","expected",null,"SCRAP COSTS","current","expected",null,"REPAIR COSTS","current","expected",null,"MACHINE UTILIZATION","current","expected"]
[null,null,null,null,null,null,"number of operators",{"$f":"+Sheet1!X19","v":0},{"$f":"+Sheet1!AB19","v":0},null,null,null,null,"parts cost ( $ / 1,000)",{"$f":"+H10/1000","v":0},{"$f":"+I10/1000","v":0},null,"number of operators",{"$f":"+H4","v":0},{"$f":"+I4","v":0},null,"parts cost ( $ / 1,000)",{"$f":"+H10/1000","v":0},{"$f":"+I10/1000","v":0},null,"mold damage (dollars)",{"$f":"+H18","v":0},{"$f":"+I18","v":0},null,"dollars per machine hour",{"$f":"+H19","v":0},{"$f":"+I19","v":0}]
[null,null,null,null,null,null,"hours per operator per week",{"$f":"+Sheet1!X20","v":0},{"$f":"+Sheet1!AB20","v":0},null,null,null,null,"part sell price ( $ / 1,000)",{"$f":"+H11/1000","v":0},{"$f":"+I11/1000","v":0},null,"hours per operator per week",{"$f":"+H5","v":0},{"$f":"+I5","v":0},null,"part sell price ( $ / 1,000)",{"$f":"+H11/1000","v":0},{"$f":"+I11/1000","v":0},null,"lost production hours due to mold damage",{"$f":"+H17","v":0},{"$f":"+I17","v":0},null,"total machine hours per week",{"$f":"+H7","v":0},{"$f":"+I7","v":0}]
[null,null,null,null,null,null,"full burdened labor cost per hour",{"$f":"+Sheet1!X21","v":0},{"$f":"+Sheet1!AB21","v":0},null,null,null,null,"number of cavities",{"$f":"+H9","v":0},{"$f":"+I9","v":0},null,"weeks per year",{"$f":"+H8","v":0},{"$f":"+I8","v":0},null,"percentage of scrap",{"$f":"+H15","v":0},{"$f":"+I15","v":0},null,"number of cavities",{"$f":"+H9","v":0},{"$f":"+AA6","v":0},null,"weeks per year",{"$f":"+H8","v":0},{"$f":"+I8","v":0}]
[null,null,null,null,null,null,"total machine hours per week",{"$f":"+Sheet1!X23","v":0},{"$f":"+Sheet1!AB23","v":0},null,null,null,null,"total machine hours per week",{"$f":"+H7","v":0},{"$f":"+I7","v":0},null,"full burdened labor cost per hour",{"$f":"+H6","v":0},{"$f":"+I6","v":0},null,"cost to dispose of scrap ($/1000)",{"$f":"+H16","v":0},{"$f":"+I16","v":0},null,"parts cost ( $ / 1,000)",{"$f":"+H10/1000","v":0},{"$f":"+I10/1000","v":0},null,"mold open time",{"$f":"+H13","v":0},{"$f":"+I13","v":0}]
[null,null,null,null,null,null,"weeks per year",{"$f":"+Sheet1!X22","v":0},{"$f":"+Sheet1!AB22","v":0},null,"SAVINGS DUE TO MOLD DAMAGE",{"$f":"+AA18","v":{"$error":"#DIV/0!"}},null,"weeks per year",{"$f":"+H8","v":0},{"$f":"+I8","v":0},null,"labor hours per year",{"$f":"+S4*S5*S6","v":0},{"$f":"+T4*T5*T6","v":0},null,"number of cavities",{"$f":"+H9","v":0},{"$f":"+I9","v":0},null,"part sell price ( $ / 1,000)",{"$f":"+H11/1000","v":0},{"$f":"+I11/1000","v":0},null,"overall cycle time",{"$f":"+H14","v":0},{"$f":"+I14","v":0}]
[null,null,null,null,null,null,"number of cavities",{"$f":"+Sheet1!X25","v":0},{"$f":"+Sheet1!AB25","v":0},null,"SAVINGS DUE TO SCRAP",{"$f":"+X23","v":{"$error":"#DIV/0!"}},null,"overall cycle time",{"$f":"+H14","v":0},{"$f":"+I14","v":0},null,"labor dollars per year",{"$f":"+S7*S8","v":0},{"$f":"+T7*T8","v":0},null,"total machine hours per week",{"$f":"+H7","v":0},{"$f":"+I7","v":0},null,"number of cavities",{"$f":"+H9","v":0},{"$f":"+AA9","v":0},null,"increased open machine time",null,{"$f":"1-(+AF8/AE8)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"parts cost each  ($ / 1,000)",{"$f":"+Sheet1!X26","v":0},{"$f":"+Sheet1!AB26","v":0},null,"TOTAL LABOR SAVINGS",{"$f":"+T11","v":0},null,"workcell productivity percentage",{"$f":"+H12","v":0},{"$f":"+I12","v":0},null,null,null,null,null,"weeks per year",{"$f":"+H8","v":0},{"$f":"+I8","v":0},null,"overall cycle time (seconds)",{"$f":"+H14","v":0},{"$f":"+I14","v":0},null,"dollars per machine week",null,{"$f":"+AF4*AF5","v":0}]
[null,null,null,null,null,null,"part sell price each  ($ / 1,000)",{"$f":"+Sheet1!X27","v":0},{"$f":"+Sheet1!AB27","v":0},null,"ADDITIONAL PARTS PROFIT",{"$f":"+P17","v":{"$error":"#DIV/0!"}},null,"cycles per hour",{"$f":"(60*60)/O9","v":{"$error":"#DIV/0!"}},{"$f":"(60*60)/P9","v":{"$error":"#DIV/0!"}},null,"TOTAL LABOR SAVINGS",null,{"$f":"+S9-T9","v":0},null,"overall cycle time",{"$f":"+H14","v":0},{"$f":"+I14","v":0},null,"profit per part",{"$f":"+AA8-AA7","v":0},{"$f":"+AB8-AB7","v":0},null,"savings per week",null,{"$f":"+AF9*AF10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"workcell productivity percentage",{"$f":"+Sheet1!X24","v":0},{"$f":"+Sheet1!AB24","v":0},null,"TOTAL SAVINGS",{"$f":"SUM(L8:L11)","v":{"$error":"#DIV/0!"}},null,"parts per hour",{"$f":"+O6*O11","v":{"$error":"#DIV/0!"}},{"$f":"+P6*P11","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"cycles per hour",{"$f":"(60*60)/W11","v":{"$error":"#DIV/0!"}},{"$f":"(60*60)/X11","v":{"$error":"#DIV/0!"}},null,"profit per cycle",{"$f":"+AA9*AA11","v":0},{"$f":"+AB9*AB11","v":0},null,"savings per year",null,{"$f":"+AF6*AF11","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"mold open time",{"$f":"+Sheet1!X28","v":0},{"$f":"+Sheet1!AB28","v":0},null,"MACHINE UTILIZATION",{"$f":"+AF14","v":{"$error":"#DIV/0!"}},null,"parts per year at 100% productivity",{"$f":"+O7*O8*O12","v":{"$error":"#DIV/0!"}},{"$f":"+P7*P8*P12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"parts per hour",{"$f":"+W8*W12","v":{"$error":"#DIV/0!"}},{"$f":"+X8*X12","v":{"$error":"#DIV/0!"}},null,"cycles per hour",{"$f":"(60*60)/AA10","v":{"$error":"#DIV/0!"}},{"$f":"(60*60)/AB10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"overall cycle time",{"$f":"+Sheet1!X29","v":0},{"$f":"+Sheet1!AB29","v":0},null,null,null,null,"parts per year at workcell productivity",{"$f":"+O10*O13","v":{"$error":"#DIV/0!"}},{"$f":"+P10*P13","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"parts per year",{"$f":"+W9*W10*W13","v":{"$error":"#DIV/0!"}},{"$f":"+X9*X10*X13","v":{"$error":"#DIV/0!"}},null,"parts per hour",{"$f":"+AA6*AA13","v":{"$error":"#DIV/0!"}},{"$f":"+AB6*AB13","v":{"$error":"#DIV/0!"}},null,"ADDITIONAL MACHINE UTILIZATION",null,{"$f":"+AF12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"percentage of scrap",{"$f":"+Sheet1!X30","v":0},{"$f":"+Sheet1!AB30","v":0},null,"PROFIT RESULT AFTER 1 YEAR",{"$f":"+L12-H28","v":{"$error":"#DIV/0!"}},null,"part profitability per year",{"$f":"(+O5-O4)*O14","v":{"$error":"#DIV/0!"}},{"$f":"(+P5-P4)*P14","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"scrapped parts per year",{"$f":"+W6*W14","v":{"$error":"#DIV/0!"}},{"$f":"+X6*X14","v":{"$error":"#DIV/0!"}},null,"lost parts due to mold damage",{"$f":"+AA5*AA14","v":{"$error":"#DIV/0!"}},{"$f":"+AB5*AB14","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"cost to dispose of scrap ($/1000)",{"$f":"+Sheet1!X31","v":0},{"$f":"+Sheet1!AB31","v":0},null,"PROFIT RESULT AFTER 2 YEARS",{"$f":"(+L12*2)-H28","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"lost profit of scrapped parts per year",{"$f":"(+W5-W4)*W15","v":{"$error":"#DIV/0!"}},{"$f":"(+X5-X4)*X15","v":{"$error":"#DIV/0!"}},null,"lost profit due to mold damage",{"$f":"+AA11*AA15","v":{"$error":"#DIV/0!"}},{"$f":"+AB11*AB15","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"lost production hours due to mold damage",{"$f":"+Sheet1!X33","v":0},{"$f":"+Sheet1!AB33","v":0},null,"PROFIT RESULT AFTER 3 YEARS",{"$f":"(+L12*3)-H28","v":{"$error":"#DIV/0!"}},null,"ADDITIONAL PARTS PROFIT",null,{"$f":"+P15-O15","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"cost to dispose of scrap",{"$f":"(+W15/1000)*W7","v":{"$error":"#DIV/0!"}},{"$f":"(+X15/1000)*X7","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"mold damage (dollars)",{"$f":"+Sheet1!X32","v":0},{"$f":"+Sheet1!AB32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"lost production hours due to mold damage",{"$f":"+H17","v":0},{"$f":"+I17","v":0},null,"TOTAL COST DUE TO MOLD DAMAGE",{"$f":"+AA4+AA16","v":{"$error":"#DIV/0!"}},{"$f":"+AB4+AB16","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"dollars per machine hour"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lost profit due to lost production",{"$f":"(+W5-W4)*W13*W18","v":{"$error":"#DIV/0!"}},{"$f":"(+X5-X4)*X13*X18","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"MONTHS TO EXPENDITURE PAYOFF",{"$f":"+'Graph Data'!J8","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"expected"]
[null,null,null,null,null,null,"Equipment costs",{"$f":"+Sheet1!K26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL COST DUE TO SCRAP",null,{"$f":"(+W16+W17+W20)-(X16+X17+X20)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Installation costs",{"$f":"+Sheet1!K27","v":0}]
[null,null,null,null,null,null,"Facility costs",{"$f":"+Sheet1!K28","v":0}]
[null,null,null,null,null,null,"Training costs",{"$f":"+Sheet1!K29","v":0}]
[null,null,null,null,null,null,"Other costs",{"$f":"+Sheet1!K30","v":0}]
[null,null,null,null,null,null,"TOTAL COSTS",{"$f":"+Sheet1!K31","v":0}]
[]
[]
[null,null,null,null,null,null,"repair costs","R"]
[null,null,null,null,null,null,"decreased scrap","S"]
[null,null,null,null,null,null,"labor savings","L"]
[null,null,null,null,null,null,"addition product profits","P"]
[]
[]
[null,null,null,null,null,null,"tons cf","Q4 -2013","Q2 -2009"]
[null,null,null,null,null,null,"<50",39.590000000000003,37.72]
[null,null,null,null,null,null,"50-99",43.65,43.88]
[null,null,null,null,null,null,"100-299",51.02,47.86]
[null,null,null,null,null,null,"300-499",59.69,55.82]
[null,null,null,null,null,null,"500-749",76.86,70.459999999999994]
[null,null,null,null,null,null,"750-999",107.59,88.61]
[null,null,null,null,null,null,"1000-1499",174.31,103.98]
[null,null,null,null,null,null,"1500-1999",214.21,141.59]
[null,null,null,null,null,null,"2000-2999",331.54,274.98]
[null,null,null,null,null,null,"3000+",416.94,339.29]
[]
[]
[null,null,null,null,null,null,"4th qtr 2013 Plastics Technology"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4177despairmt"]

{"sheet":"Macros","index":3,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":true,"merged":[[2,1,2,3],[2,7,2,9]]}
[null,null,"4177despairmt"]
[]
[null,"Clear_Text_Data",null,null,null,null,null,"Reset_Calculations"]
[]
[null,null,"F6:W6","'delete'",null,null,null,null,"K26:O26","'delete'"]
[null,null,"F7:W7","'delete'",null,null,null,null,"K27:O27","'delete'"]
[null,null,"F8:W8","'delete'",null,null,null,null,"K28:O28","'delete'"]
[null,null,"F9:W9","'delete'",null,null,null,null,"K29:O29","'delete'"]
[null,null,"F10:W10","'delete'",null,null,null,null,"K30:O30","'delete'"]
[null,null,"F12:P12","'delete'",null,null,null,null,"X19:AA19","'delete'"]
[null,null,"F13:P13","'delete'",null,null,null,null,"X20:AA20","'delete'"]
[null,null,"S12:W12","'delete'",null,null,null,null,"X21:AA21","'delete'"]
[null,null,"S13:W13","'delete'",null,null,null,null,"X22:AA22","'delete'"]
[null,null,"I15:W15","'delete'",null,null,null,null,"X23:AA23","'=+X19*X20'"]
[null,null,"I16:W16","'delete'",null,null,null,null,"X24:AA24","'delete'"]
[null,null,"AE6:AT7","'delete'",null,null,null,null,"X25:AA25","'delete'"]
[null,null,"AE8:AL8","'delete'",null,null,null,null,"X26:AA26","'delete'"]
[null,null,"AP8:AT8","'delete'",null,null,null,null,"X27:AA27","'delete'"]
[null,null,"AE9:AT9","'delete'",null,null,null,null,"X28:AA28","'delete'"]
[null,null,"AE10:AT10","'delete'",null,null,null,null,"X29:AA29","'delete'"]
[null,null,"AE11:AT13","'delete'",null,null,null,null,"X30:AA30","'delete'"]
[null,null,"AE15:AT15","'delete'",null,null,null,null,"X31:AA31","'delete'"]
[null,null,"AE16:AT16","'delete'",null,null,null,null,"X32:AA32","'delete'"]
[null,null,"F6:W6","'enter'",null,null,null,null,"X33:AA34","'delete'"]
[null,null,null,null,null,null,null,null,"AB19:AE19","'=+X19'"]
[null,null,null,null,null,null,null,null,"AB20:AE20","'=+X20'"]
[null,null,null,null,null,null,null,null,"AB21:AE21","'=+X21'"]
[null,null,null,null,null,null,null,null,"AB22:AE22","'=+X22'"]
[null,null,null,null,null,null,null,null,"AB23:AE23","'=+AB19*AB20'"]
[null,null,null,null,null,null,null,null,"AB24:AE24","'=+X24'"]
[null,null,null,null,null,null,null,null,"AB25:AE25","'=+X25'"]
[null,null,null,null,null,null,null,null,"AB26:AE26","'=+X26'"]
[null,null,null,null,null,null,null,null,"AB27:AE27","'=+X27'"]
[null,null,null,null,null,null,null,null,"AB28:AE28","'delete'"]
[null,null,null,null,null,null,null,null,"AB29:AE29","'=+X29-(X28-AB28)'"]
[null,null,null,null,null,null,null,null,"AB30:AE30","'delete'"]
[null,null,null,null,null,null,null,null,"AB31:AE31","'=+X31'"]
[null,null,null,null,null,null,null,null,"AB32:AE32","'delete'"]
[null,null,null,null,null,null,null,null,"AB33:AE34","'delete'"]
[null,null,null,null,null,null,null,null,"K26:O26","'delete'"]

{"sheet":"Graph Data","index":4,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[null,"month","costs","savings","month","net profit"]
[null,null,{"$f":"+Calcs!H28","v":0},{"$f":"+Calcs!L12","v":{"$error":"#DIV/0!"}},null,{"$f":"+D3-C3","v":{"$error":"#DIV/0!"}}]
[null,1,null,{"$f":"+D3/12","v":{"$error":"#DIV/0!"}},1,{"$f":"-C3+D4","v":{"$error":"#DIV/0!"}}]
[null,2,null,{"$f":"+D4","v":{"$error":"#DIV/0!"}},2,{"$f":"+F4+D5","v":{"$error":"#DIV/0!"}}]
[null,3,null,{"$f":"+D5","v":{"$error":"#DIV/0!"}},3,{"$f":"+F5+D6","v":{"$error":"#DIV/0!"}},null,null,"savings per month",{"$f":"+D3/12","v":{"$error":"#DIV/0!"}}]
[null,4,null,{"$error":"#DIV/0!"},4,{"$error":"#DIV/0!"},null,null,"total expenditure",{"$f":"+C3","v":0}]
[null,5,null,{"$error":"#DIV/0!"},5,{"$error":"#DIV/0!"},null,null,"months to payoff",{"$f":"+J7/J6","v":{"$error":"#DIV/0!"}}]
[null,6,null,{"$error":"#DIV/0!"},6,{"$error":"#DIV/0!"}]
[null,7,null,{"$error":"#DIV/0!"},7,{"$error":"#DIV/0!"}]
[null,8,null,{"$error":"#DIV/0!"},8,{"$error":"#DIV/0!"},null,null,"PROFIT RESULT AFTER 1 YEAR",{"$f":"+Calcs!L15","v":{"$error":"#DIV/0!"}}]
[null,9,null,{"$error":"#DIV/0!"},9,{"$error":"#DIV/0!"},null,null,"PROFIT RESULT AFTER 2 YEARS",{"$f":"+Calcs!L16","v":{"$error":"#DIV/0!"}}]
[null,10,null,{"$error":"#DIV/0!"},10,{"$error":"#DIV/0!"},null,null,"PROFIT RESULT AFTER 3 YEARS",{"$f":"+Calcs!L17","v":{"$error":"#DIV/0!"}}]
[null,11,null,{"$error":"#DIV/0!"},11,{"$error":"#DIV/0!"}]
[null,12,null,{"$error":"#DIV/0!"},12,{"$error":"#DIV/0!"}]
[null,13,null,{"$error":"#DIV/0!"},13,{"$error":"#DIV/0!"}]
[null,14,null,{"$error":"#DIV/0!"},14,{"$error":"#DIV/0!"},null,null,"SAVINGS DUE TO MOLD DAMAGE",{"$f":"+Calcs!L8","v":{"$error":"#DIV/0!"}}]
[null,15,null,{"$error":"#DIV/0!"},15,{"$error":"#DIV/0!"},null,null,"SAVINGS DUE TO SCRAP",{"$f":"+Calcs!L9","v":{"$error":"#DIV/0!"}}]
[null,16,null,{"$error":"#DIV/0!"},16,{"$error":"#DIV/0!"},null,null,"TOTAL LABOR SAVINGS",{"$f":"+Calcs!L10","v":0}]
[null,17,null,{"$error":"#DIV/0!"},17,{"$error":"#DIV/0!"},null,null,"ADDITIONAL PARTS PROFIT",{"$f":"+Calcs!L11","v":{"$error":"#DIV/0!"}}]
[null,18,null,{"$error":"#DIV/0!"},18,{"$error":"#DIV/0!"}]
[null,19,null,{"$error":"#DIV/0!"},19,{"$error":"#DIV/0!"}]
[null,20,null,{"$error":"#DIV/0!"},20,{"$f":"+F22+D23","v":{"$error":"#DIV/0!"}}]
[null,21,null,{"$error":"#DIV/0!"},21,{"$error":"#DIV/0!"},null,1,null,{"$f":"+J17","v":{"$error":"#DIV/0!"}},{"$f":"+J18","v":{"$error":"#DIV/0!"}},{"$f":"+J19","v":0},{"$f":"+J20","v":{"$error":"#DIV/0!"}}]
[null,22,null,{"$error":"#DIV/0!"},22,{"$error":"#DIV/0!"}]
[null,23,null,{"$error":"#DIV/0!"},23,{"$error":"#DIV/0!"},null,2,null,1000,2000,20000,1000]
[null,24,null,{"$error":"#DIV/0!"},24,{"$error":"#DIV/0!"}]
[null,25,null,{"$error":"#DIV/0!"},25,{"$error":"#DIV/0!"}]
[null,26,null,{"$error":"#DIV/0!"},26,{"$error":"#DIV/0!"},null,"Damage",null,{"$f":"+J17","v":{"$error":"#DIV/0!"}}]
[null,27,null,{"$error":"#DIV/0!"},27,{"$error":"#DIV/0!"},null,"Scrap",null,{"$f":"+J18","v":{"$error":"#DIV/0!"}}]
[null,28,null,{"$error":"#DIV/0!"},28,{"$error":"#DIV/0!"},null,"Labor",null,{"$f":"+J19","v":0}]
[null,29,null,{"$error":"#DIV/0!"},29,{"$error":"#DIV/0!"},null,"Yield",null,{"$f":"+J20","v":{"$error":"#DIV/0!"}}]
[null,30,null,{"$error":"#DIV/0!"},30,{"$error":"#DIV/0!"}]
[null,31,null,{"$error":"#DIV/0!"},31,{"$error":"#DIV/0!"}]
[null,32,null,{"$error":"#DIV/0!"},32,{"$error":"#DIV/0!"}]
[null,33,null,{"$error":"#DIV/0!"},33,{"$error":"#DIV/0!"}]
[null,34,null,{"$error":"#DIV/0!"},34,{"$error":"#DIV/0!"}]
[null,35,null,{"$error":"#DIV/0!"},35,{"$error":"#DIV/0!"}]
[null,36,null,{"$error":"#DIV/0!"},36,{"$f":"+F38+D39","v":{"$error":"#DIV/0!"}}]
[null,37,null,{"$error":"#DIV/0!"},37,{"$error":"#DIV/0!"}]
[null,38,null,{"$error":"#DIV/0!"},38,{"$error":"#DIV/0!"}]
[null,39,null,{"$error":"#DIV/0!"},39,{"$error":"#DIV/0!"}]
[null,40,null,{"$error":"#DIV/0!"},40,{"$error":"#DIV/0!"}]
[null,41,null,{"$error":"#DIV/0!"},41,{"$error":"#DIV/0!"}]
[null,42,null,{"$error":"#DIV/0!"},42,{"$error":"#DIV/0!"}]
[null,43,null,{"$error":"#DIV/0!"},43,{"$error":"#DIV/0!"}]
[null,44,null,{"$error":"#DIV/0!"},44,{"$error":"#DIV/0!"}]
[null,45,null,{"$error":"#DIV/0!"},45,{"$error":"#DIV/0!"}]
[null,46,null,{"$error":"#DIV/0!"},46,{"$error":"#DIV/0!"}]
[null,47,null,{"$error":"#DIV/0!"},47,{"$error":"#DIV/0!"}]
[null,48,null,{"$error":"#DIV/0!"},48,{"$error":"#DIV/0!"}]