{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Eff Value Inputs and Data","Efficiency Value Chart","1% Improvement Value Chart","Improvment Value Data (Static)"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Efficiency Value Chart","index":1,"reason":"not_a_worksheet"},{"sheet":"1% Improvement Value Chart","index":2,"reason":"not_a_worksheet"}],"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":"Eff Value Inputs and Data","index":0,"n_rows":95,"n_cols":14,"rows_kept":95,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,9,0,10],[62,1,62,13]]}
["IMM + Material",null,null,null,null,null,null,null,null,"IMM Only"]
["hours / year",{"$f":"52*7*24","v":8736},null,null,null,null,null,null,null,"hours / year",{"$f":"52*7*24","v":8736}]
["% utility",0.6,null,null,null,null,null,null,null,"% utility",{"$f":"B3","v":0.6}]
["Working hous",{"$f":"B2*B3","v":5241.5999999999995},null,null,null,null,null,null,null,"Working hous",{"$f":"K2*K3","v":5241.5999999999995}]
[]
["rate $ / hour",76,"median mapp selling rate",null,null,null,null,null,null,"rate $ / hour",{"$f":"B6","v":76},"median mapp selling rate"]
[]
["revenue IMM",{"$f":"B6*B4","v":398361.59999999998},null,null,null,null,null,null,null,"revenue IMM",{"$f":"K6*K4","v":398361.59999999998}]
["material multiplier",2,null,null,null,null,null,null,null,"material multiplier",1]
["Revenue Production",{"$f":"B8*B9","v":796723.19999999995},null,null,null,null,null,null,null,"Revenue Production",{"$f":"K8*K9","v":398361.59999999998}]
[]
[]
["revenue",{"$f":"B10","v":796723.19999999995},null,null,null,null,null,null,null,"revenue",{"$f":"K10","v":398361.59999999998}]
["margin",0.15,null,null,null,null,null,null,null,"margin",{"$f":"B14","v":0.15}]
["baseline eff",0.65,null,null,null,null,null,null,null,"baseline eff",{"$f":"B15","v":0.65}]
["profit",{"$f":"B13*B14","v":119508.47999999998},null,null,null,null,null,null,null,"profit",{"$f":"K13*K14","v":59754.239999999991}]
["cost",{"$f":"B13*(1-B14)","v":677214.71999999997},null,null,null,null,null,null,null,"cost",{"$f":"K13*(1-K14)","v":338607.35999999999}]
["cost at 100% eff",{"$f":"B17*B15","v":440189.56799999997},null,null,null,null,null,null,null,"cost at 100% eff",{"$f":"K17*K15","v":220094.78399999999}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Data for Efficiency Value Chart"]
[null,"workcell eff","cost","profit","delta IMM+Material",null,null,null,null,null,"workcell eff","cost","profit","delta IMM"]
[null,{"$f":"B15-(0.005*14)","v":0.58000000000000007},{"$f":"$B$18/B65","v":758947.53103448264},{"$f":"$B$13-C65","v":37775.66896551731},{"$f":"D65-$B$16","v":-81732.811034482671},null,null,null,null,null,{"$f":"B65","v":0.58000000000000007},{"$f":"$K$18/K65","v":379473.76551724132},{"$f":"$K$13-L65","v":18887.834482758655},{"$f":"M65-$K$16","v":-40866.405517241335}]
[null,{"$f":"B65+0.005","v":0.58500000000000008},752460.79999999981,44262.40000000014,{"$f":"D66-$B$16","v":-75246.079999999842},null,null,null,null,null,{"$f":"B66","v":0.58500000000000008},{"$f":"$K$18/K66","v":376230.39999999991},{"$f":"$K$13-L66","v":22131.20000000007},{"$f":"M66-$K$16","v":-37623.039999999921}]
[null,{"$f":"B66+0.005","v":0.59000000000000008},746084.01355932187,50639.186440678081,-68869.293559321901,null,null,null,null,null,0.59000000000000008,373042.00677966094,25319.59322033904,-34434.64677966095]
[null,0.59500000000000008,739814.39999999979,56908.800000000163,-62599.679999999818,null,null,null,null,null,0.59500000000000008,369907.1999999999,28454.400000000081,-31299.839999999909]
[null,0.60000000000000009,733649.2799999998,63073.920000000158,-56434.559999999823,null,null,null,null,null,0.60000000000000009,366824.6399999999,31536.960000000079,-28217.279999999912]
[null,0.60500000000000009,727586.06280991714,69137.137190082809,-50371.342809917172,null,null,null,null,null,0.60500000000000009,363793.03140495857,34568.568595041404,-25185.671404958586]
[null,0.6100000000000001,721622.2426229507,75100.957377049257,-44407.522622950724,null,null,null,null,null,0.6100000000000001,360811.12131147535,37550.478688524629,{"$f":"M71-$K$16","v":-22203.761311475362}]
[null,0.6150000000000001,715755.39512195101,80967.804878048948,-38540.675121951033,null,null,null,null,null,0.6150000000000001,357877.6975609755,40483.902439024474,-19270.337560975517]
[null,0.62000000000000011,709983.17419354827,86740.025806451682,-32768.454193548299,null,null,null,null,null,0.62000000000000011,354991.58709677414,43370.012903225841,-16384.22709677415]
[null,0.62500000000000011,704303.30879999988,92419.891200000071,-27088.58879999991,null,null,null,null,null,0.62500000000000011,352151.65439999994,46209.945600000035,-13544.294399999955]
[null,0.63000000000000012,698713.59999999986,98009.600000000093,-21498.879999999888,null,null,null,null,null,0.63000000000000012,349356.79999999993,49004.800000000047,-10749.439999999944]
[null,0.63500000000000012,693211.91811023606,103511.28188976389,-15997.198110236088,null,null,null,null,null,0.63500000000000012,346605.95905511803,51755.640944881947,-7998.5990551180439]
[null,0.64000000000000012,687796.19999999984,108927.00000000012,-10581.479999999865,null,null,null,null,null,0.64000000000000012,343898.09999999992,54463.500000000058,-5290.7399999999325]
[null,0.64500000000000013,682464.44651162776,114258.7534883722,-5249.7265116277849,null,null,null,null,null,0.64500000000000013,341232.22325581388,57129.376744186098,-2624.8632558138925]
[null,0.65000000000000013,{"$f":"$B$18/B79","v":677214.71999999986},119508.4800000001,1.1641532182693481E-10,null,null,null,null,null,0.65000000000000013,338607.35999999993,59754.240000000049,5.8207660913467407E-11]
[null,0.65500000000000014,672045.14198473259,124678.05801526736,5169.5780152673833,null,null,null,null,null,0.65500000000000014,336022.57099236629,62339.029007633682,2584.7890076336917]
["+1%",0.66000000000000014,{"$f":"$B$18/B81","v":666953.89090909075},129769.3090909092,10260.829090909217,null,null,null,null,null,0.66000000000000014,333476.94545454538,64884.654545454599,5130.4145454546087]
[null,0.66500000000000015,661939.19999999984,134784.00000000012,15275.520000000135,null,null,null,null,null,0.66500000000000015,330969.59999999992,67392.000000000058,7637.7600000000675]
[null,0.67000000000000015,656999.35522388038,139723.84477611957,20215.36477611959,null,null,null,null,null,0.67000000000000015,328499.67761194019,69861.922388059786,10107.682388059795]
[null,0.67500000000000016,652132.69333333313,144590.50666666683,25082.026666666847,null,null,null,null,null,0.67500000000000016,326066.34666666656,72295.253333333414,12541.013333333423]
[null,0.68000000000000016,647337.59999999986,149385.60000000009,29877.120000000112,null,null,null,null,null,0.68000000000000016,323668.79999999993,74692.800000000047,14938.560000000056]
[null,0.68500000000000016,642612.50802919688,154110.69197080308,34602.211970803095,null,null,null,null,null,0.68500000000000016,321306.25401459844,77055.345985401538,17301.105985401548]
[null,0.69000000000000017,637955.89565217367,158767.30434782628,39258.824347826303,null,null,null,null,null,0.69000000000000017,318977.94782608683,79383.652173913142,19629.412173913151]
[null,0.69500000000000017,633366.28489208617,163356.91510791378,43848.4351079138,null,null,null,null,null,0.69500000000000017,316683.14244604309,81678.45755395689,21924.2175539569]
[null,0.70000000000000018,628842.23999999976,167880.9600000002,48372.480000000214,null,null,null,null,null,0.70000000000000018,314421.11999999988,83940.480000000098,24186.240000000107]
[null,0.70500000000000018,624382.36595744663,172340.83404255332,52832.354042553343,null,null,null,null,null,0.70500000000000018,312191.18297872331,86170.417021276662,26416.177021276671]
[null,0.71000000000000019,619985.30704225332,176737.89295774663,57229.412957746652,null,null,null,null,null,0.71000000000000019,309992.65352112666,88368.946478873317,28614.706478873326]
[null,0.71500000000000019,615649.74545454525,181073.4545454547,61564.974545454723,null,null,null,null,null,0.71500000000000019,307824.87272727262,90536.727272727352,30782.487272727361]
[null,0.7200000000000002,611374.39999999979,185348.80000000016,65840.320000000182,null,null,null,null,null,0.7200000000000002,305687.1999999999,92674.400000000081,32920.160000000091]
[null,0.7250000000000002,607158.02482758602,189565.17517241393,70056.695172413951,null,null,null,null,null,0.7250000000000002,303579.01241379301,94782.587586206966,35028.347586206975]
[null,0.7300000000000002,602999.40821917786,193723.7917808221,74215.311780822114,null,null,null,null,null,0.7300000000000002,301499.70410958893,96861.895890411048,37107.655890411057]

{"sheet":"Improvment Value Data (Static)","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,1,5,5]]}
["The values below used for the 1% Improvement Value Chart are Static and do not change with inputs to the Eff Value Inputs and Data worksheet"]
["inputs for the data below are as follows"]
["material multiplier = 2"]
["margin = 15%"]
[]
["Utilization","workcell efficiency"]
[null,0.25,0.4,0.55000000000000004,0.7,0.85]
["25 IMM+Mat",10853,6882,5039,3974,3281]
["50 IMM+Mat",21706,13765,10078,7948,6562]
["75 IMM+Mat",32558,20647,15116,11992,9834]
[]
[null,{"$f":"B7","v":0.25},{"$f":"C7","v":0.4},0.55000000000000004,0.7,0.85]
["25 IMM",{"$f":"B8/2","v":5426.5},{"$f":"C8/2","v":3441},2519.5,1987,1640.5]
["50 IMM",{"$f":"B9/2","v":10853},6882.5,5039,3974,3281]
["75 IMM",16279,10323.5,7558,5996,4917]