{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Inputs","Comparisons","Module1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":2,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Inputs","index":0,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Copyright:  This spreadsheet tool can be freely copied provided acknowldegement to the developer is retained"]
[]
[]
[]
[]
[]
[]
[{"$nulls":11},"Version 8:2011"]
["Spraying work rates and application costs calculator",{"$nulls":10},"Notes on use"]
["Property",{"$nulls":10},"Data entry to cells in yellow only"]
[{"$nulls":4},"Date","2020-05-06",{"$nulls":5},"Use copy buttons to produce comparisons "]
["Block",{"$nulls":10},"of workrates/costs under different scenarios"]
["Sprayer/tractor",{"$nulls":10},"Print area is already set "]
[]
["Spraying time only (disregarding mixing time,  turning times & edge row factors)",{"$nulls":5},"Buttons copy "," use this to copy data to other sheets for printed summaries",null,null,null,"Sprayer Costing      Note: calculations require that property size etc info is filled in)"]
["Travel speed ",8,"km/hr","Distance travelled per ha =",2.5,"km","scenarios to the",{"$nulls":4},55000,"purchase cost"]
["Row spacing ",4,"m","Time to spray one hectare =",18.75,"minutes","comparisons page","ASSUMPTIONS LIST ",null,null,null,10,"depreciation term (years)"]
["Spray volume ",700,"l/ha","Time to spray one tank =",53.57142857142857,"minutes",null,"Travel speed ",8,"km/hr",null,3000,"annual R&M cost"]
["Tank size ",2000,"l","Area sprayed per tank =",2.857142857142857,"hectares",null,"Spray volume ",700,"l/ha",null,5500,"Annual depreciation cost"]
["Rows sprayed/pass ",1,{"$nulls":5},"Tank size ",2000,"l",null,8500,"Total annual cost "]
["Labour cost",25,"$/hr","       Work rate =",3.2000000000000006,"ha/hr",null,"Mix and fill time ",20,"minutes",null,"For current scenario"]
["Tractor cost",45,"$/hr","Cost = ",29.999999999999993,"per ha",null,"Turning time per turn",10,"seconds",null,278.33333333333326,"Hours operation per year"]
["Sprayer cost",26,"$/hr",{"$nulls":8},30.53892215568863,"Operating cost per hour"]
["With mix and fill time included (disregarding turning times & edge row factors)",{"$nulls":6},"Row spacing ",4,"m"]
["Mix and fill time ",20,"minutes",{"$nulls":4},"Rows sprayed/pass ",1]
["INCLUDE TRAVEL TIME!",null,null,"       Work rate =",2.330097087378641,"ha/hr",null,"Average row length",200,"metres"]
[null,null,null,"Cost = ",41.199999999999996,"per ha",null,"Property area",30,"ha"]
[]
["With turning times factored in (disregarding edge row effects)",{"$nulls":6},"Labour cost",25,"$/hr"]
["Turning time per turn",10,"seconds","Turns per hectare =",12.5,null,null,"Tractor cost",45,"$/hr"]
["or",0.16666666666666666,"minutes","Time spent turning per ha =",2.083333333333333,"minutes",null,"Sprayer cost",26,"$/hr"]
["Average row length",200,"metres","Time to spray one hectare =",20.833333333333332,"minutes"]
[null,null,null,"Time to spray one tank =",59.52380952380952,"minutes",null,"OUTPUT"]
["Time spraying/ha",0.6736526946107785,18.75,{"$nulls":4},"Work rate (with mix and fill and turning times factored)",2.1556886227544916,"ha/hr"]
["Time turning/ha",0.0748502994011976,2.083333333333333,"       Work rate =",2.1556886227544916,"ha/hr"]
["Time mixing/ha",0.25149700598802394,0,"Cost = ",44.533333333333324,"per ha",null,"Cost per ha",44.533333333333324,"per ha"]
[null,null,7,{"$nulls":4},"Time to spray block",13.916666666666663,"hours"]
["On a whole property basis",null,null,"Time to spray property =",13.916666666666663,"hours",null,"Cost to spray block",1335.9999999999998,"per spray"]
["Property area",30,"ha","Cost to spray property =",1335.9999999999998,"per round",null,"Cost to spray block",26719.999999999996,"per season"]
["Spray rounds per year",20,null,"Total application cost =",26719.999999999996,"for season"]
[]
[]
[]
[]
["                Developed by:",null,null,"Contacts:"]
["David Manktelow ",null,null,"Applied Research and Technologies Ltd"]
[null,null,null,"1 Ballantyne Place"]
[null,null,null,"RD2"]
[null,null,null,"Napier"]
[null,null,null,"New Zealand 4182"]
[]
[null,null,null,"+64 27 5653 043"]
[null,null,null,"email: david@applied research.nz"]
[]
["Copyright:  This spreadsheet tool can be freely copied provided acknowldegement to the developer is retained"]

{"sheet":"Comparisons","index":1,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[{"$nulls":4},"Workrate and spray application cost comparisons   "]
[null,null,"Property",0]
[{"$nulls":6},"Date","2020-05-06"]
[null,null,"Block",0]
[null,null,"Sprayer/tractor",0]
[]
[]
[null,null,"Comparison","#1","#2","#3","#4"]
[null,null,"ASSUMPTIONS"]
[null,null,"Travel speed ",8,8,8,8,"km/hr"]
[null,null,"Spray volume ",700,700,700,700,"l/ha"]
[null,null,"Tank size ",2000,3000,3000,2000,"l"]
[null,null,"Mix and fill time ",35,35,20,20,"minutes"]
[null,null,"Turning time per turn",10,10,10,10,"seconds"]
[]
[null,null,"Row spacing ",4,4,4,4,"m"]
[null,null,"Rows sprayed/pass ",1,1,1,1]
[null,null,"Average row length",200,200,200,200,"metres"]
[null,null,"Property area",30,30,30,30,"ha"]
[]
[null,null,"Labour cost",25,25,25,25,"$/hr"]
[null,null,"Tractor cost",45,45,45,45,"$/hr"]
[null,null,"Sprayer cost",26,26,26,26,"$/hr"]
[]
[]
[null,null,"WORK RATE",1.8136020151133505,2.068965517241379,2.3529411764705883,2.1556886227544916,"ha/hr"]
[null,null,"Includes fill, travel and turning times"]
[null,null,"Cost per ha",52.93333333333332,46.400000000000006,40.8,44.533333333333324,"per ha"]
[null,null,"Time to spray block",16.541666666666664,14.500000000000002,12.75,13.916666666666663,"hours"]
[null,null,"Cost to spray block",1587.9999999999998,1392.0000000000002,1224,1335.9999999999998,"per spray"]
[]
[]
[]
[]
["                Developed by:",null,null,"Contacts:"]
["David Manktelow ",null,null,"Applied Research and Technologies Ltd"]
[null,null,null,"1 Ballantyne Place"]
[null,null,null,"RD2 "]
[null,null,null,"Napier"]
[null,null,null,"New Zealand 4182"]
[]
[null,null,null,"+64 27 5653 043"]
[null,null,null,"email: david@applied research.nz"]
[]
["Copyright:  This spreadsheet tool can be freely copied provided acknowldegement to the developer is retained"]