{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculators","BackEnd","Our Assumption Numbers"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Calculators","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,0,4,5],[7,0,7,5],[18,1,18,5],[1,0,1,5],[5,0,6,5]]}
[]
["Macros must be enabled for this tool to function"]
["The purpose of this tool is to assist producers with determining the annual savings from investing in one or more platforms to prune, hand thin and harvest apples. "]
[]
[]
["Some monitors may not be able to accommodate the larger version of this tool, in this case please use the smaller version"]
[]
["To begin click the \"Start Payback Tool\" button below in your preferred size"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"due to incompatability this tool will not work on a mac"]

{"sheet":"BackEnd","index":1,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":true,"merged":[[12,5,15,5],[10,7,11,8],[9,7,9,8]]}
[]
[]
["Acres"]
[100,null,null,"Weeks","Old hours PA","New hours PA","Total Hours Needed"]
["Harvest Efficiency Gain",null,"Pruning",16,40,{"$f":"E5*(1-A8)","v":28},{"$f":"F5*Acres","v":2800}]
[0.13,null,"Thinning",8,60,{"$f":"E6*(1-A10)","v":36},{"$f":"F6*Acres","v":3600}]
["Pruning Efficiency Gain",null,"Harvest",8.5,70,{"$f":"E7*(1-A6)","v":60.9},{"$f":"F7*Acres","v":6090}]
[0.3]
["Hand Thining Efficiency Gain",null,null,"Platform-hours (Hours/ ppl on Platform)","Capacity (Hours)","Requirement Met with Machine","Annaul Wage Savings"]
[0.4,null,null,{"$f":"G5/H34","v":466.66666666666669},{"$f":"D5*40*A20","v":1280},{"$f":"IF(E10/D10>1,1,E10/D10)","v":1},{"$f":"(E5-F5)*A$4*A$16*F10","v":17520},"Made Savings Times % Met"]
["Pruning Cost p Acre",null,null,{"$f":"G6/H34","v":600},{"$f":"D6*40*A20","v":640},{"$f":"IF(E11/D11>0.2,0.2,E11/D11)","v":0.2},{"$f":"(E6-F6)*A$4*A$16*F11","v":7008},"Reflects the work that is actually done, before was assuming 100%"]
[null,null,null,{"$f":"G7/H34","v":1015},{"$f":"D7*50*A20","v":850},{"$f":"IF(E12/D12>1,1,E12/D12)","v":0.83743842364532017},{"$f":"(E7-F7)*A$4*A$16*F12","v":11126.206896551725}]
["Hand Thining Cost p Acre",null,null,null,null,"Made the \"with machine\" distinction because this only accounts for work done on machines meaning 5 ppl can do this much",{"$f":"SUM(G10:G12)","v":35654.206896551725}]
[]
["Wage"]
[14.6]
["Apple Yield p BA (bu)"]
[1000]
["Machines",null,{"$f":"9*5.5","v":49.5}]
[2]
["Total Cost"]
[]
["Pruning Worker Hours pA"]
[]
["Thinning Hours p A"]
[]
["Harvest Labor p A","WH per Acre","Max Savings"]
[null,{"$f":"A28/A16","v":0},{"$f":"B28*A16*A6*A4","v":0}]
["Thinning Hours p A"]
[]
[]
[]
["Machine","Cost of Machine","Rate","Down Payment","Monthly Payments","Years","Monthly Payment","Capacity","Total Cost"]
["Bandit Xpress",65000,0.04,20000,1,5,{"$f":"PMT(C34/E34,E34*F34,B34*A20,-D34,0)","v":-25508.982484233733},6,{"$f":"-(E34*F34*G34-D34)","v":147544.91242116867}]
["Huron Fruit System",65000,4.1500000000000002E-2,0,{"$f":"12","v":12},5,{"$f":"PMT(C35/E35,E35*F35,B35,-D35,0)","v":-1201.4788973057066},4]
[]
[]
["Capacity Options"]
[4]
[6]

{"sheet":"Our Assumption Numbers","index":2,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":true,"merged":[[9,7,9,8],[10,7,11,8],[12,5,15,5]]}
[]
[]
["Acres"]
[100,null,null,"Weeks","Old hours PA","New hours PA","Total Hours Needed"]
["Harvest Efficiency Gain",null,"Pruning",16,40,{"$f":"E5*(1-A8)","v":28},{"$f":"F5*Acres","v":2800}]
[0.13,null,"Thinning",8,60,{"$f":"E6*(1-A10)","v":36},{"$f":"F6*Acres","v":3600}]
["Pruning Efficiency Gain",null,"Harvest",8.5,70,{"$f":"E7*(1-A6)","v":60.9},{"$f":"F7*Acres","v":6090}]
[0.3]
["Hand Thining Efficiency Gain",null,null,"Platform-hours (Hours/ ppl on Platform)","Capacity (Hours)","Requirement Met with Machine","Savings"]
[0.4,null,null,{"$f":"G5/H34","v":466.66666666666669},{"$f":"D5*40*A20","v":640},{"$f":"IF(E10/D10>1,1,E10/D10)","v":1},{"$f":"(E5-F5)*A$4*A$16*F10","v":17760},"Made Savings Times % Met"]
["Pruning Cost p Acre",null,null,{"$f":"G6/H34","v":600},{"$f":"D6*40*A20","v":320},{"$f":"IF(E11/D11>0.2,0.2,E11/D11)","v":0.2},{"$f":"(E6-F6)*A$4*A$16*F11","v":7104},"Reflects the work that is actually done, before was assuming 100%"]
[500,null,null,{"$f":"G7/H34","v":1015},{"$f":"D7*50*A20","v":425},{"$f":"IF(E12/D12>1,1,E12/D12)","v":0.41871921182266009},{"$f":"(E7-F7)*A$4*A$16*F12","v":5639.310344827587}]
["Hand Thining Cost p Acre",null,null,null,null,"Made the \"with machine\" distinction because this only accounts for work done on machines meaning 5 ppl can do this much",{"$f":"SUM(G10:G12)","v":30503.310344827587}]
[800]
["Wage"]
[14.8]
["Apple Yield p BA (bu)"]
[1000]
["Machines",null,{"$f":"9*5.5","v":49.5}]
[1]
["Total Cost"]
[{"$f":"#REF!*E34*F34","v":{"$error":"#REF!"}}]
["Pruning Worker Hours pA"]
[{"$f":"A12/A16","v":33.783783783783782}]
["Thinning Hours p A"]
[61.02]
["Harvest Labor p A","WH per Acre","Max Savings"]
[1152,{"$f":"A28/A16","v":77.837837837837839},{"$f":"B28*A16*A6*A4","v":14976}]
["Thinning Hours p A"]
[61.02]
[]
[]
["Machine","Cost of Machine","Rate","Down Payment","Monthly Payments","Years","Monthly Payment","Capacity","Total Cost"]
["Bandit Xpress",32000,6.7500000000000004E-2,2000,1,5,{"$f":"PMT(C34/E34,E34*F34,B34*A20,-D34,0)","v":-7402.8111940594717},6,{"$f":"-(E34*F34*G34-D34)","v":39014.055970297355}]
["Huron Fruit System",65000,4.1500000000000002E-2,0,{"$f":"12","v":12},5,{"$f":"PMT(C35/E35,E35*F35,B35,-D35,0)","v":-1201.4788973057066},4]
[]
[]
["Capacity Options"]
[4]
[6]