{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Title","Scenario Inputs","Comparison Page","About","Module1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":4,"reason":"part_missing"}],"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":"Title","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Scenario Inputs","index":1,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[[5,3,5,5],[6,3,6,5],[7,3,7,5]]}
[]
[]
[null,null,"Step 1 - Operation Information"]
[]
[null,null,"Date ",{"$f":"TODAY()","v":"2019-11-12"}]
[null,null,"Property "]
[null,null,"Block "]
[null,null,"Sprayer / Tractor "]
[]
[]
[]
[null,null,"Step 2 - Time Spent Spraying"]
[]
[null,null,"Travel Speed ",null," km/hr","Distance Travelled / ha ",{"$f":"10/(D15*D18)","v":{"$error":"#DIV/0!"}}," km"]
[null,null,"Row Spacing ",null," m","Spray Time / ha ",{"$f":"600/(D14*D15*D18)","v":{"$error":"#DIV/0!"}}," min."]
[null,null,"Spray Volume ",null," l/ha","Spray Time / Tank ",{"$f":"G15*D17/D16","v":{"$error":"#DIV/0!"}}," min."]
[null,null,"Tank Size ",null," l","Ha Sprayed / Tank ",{"$f":"D17/D16","v":{"$error":"#DIV/0!"}}," ha"]
[null,null,"Rows Sprayed / Pass "]
[null,null,"Labour Cost ",null," $/hr","Work Rate ",{"$f":"60*G17/(G16)","v":{"$error":"#DIV/0!"}}," ha/hr"]
[null,null,"Tractor Cost ",null," $/hr","Cost / ha ",{"$f":"SUM($D$19:$D$21)/G19","v":{"$error":"#DIV/0!"}}," /ha"]
[null,null,"Sprayer Cost ",null," $/hr"]
[]
[]
[]
[null,null,"Step 3 - Loading Time"]
[]
[null,null,"Filling / Mixing Time ",null," min.","Work Rate ",{"$f":"60*G17/(G16+D29)","v":{"$error":"#DIV/0!"}}," ha/hr"]
[null,null,"Avg. Travel Time ",null," min.","Cost / ha ",{"$f":"SUM($D$19:$D$21)/G27","v":{"$error":"#DIV/0!"}}," /ha"]
[null,null,"Total Time ",{"$f":"D27+D28","v":0}," min."]
[]
[]
[]
[null,null,"Step 4 - Turning Time"]
[]
[null,null,"Turning Time ",null," sec.","Turns / ha ",{"$f":"10000/D36/D15/D18","v":{"$error":"#DIV/0!"}}]
[null,null,"Avg. Row Length ",null," m","Time Turning / ha ",{"$f":"G35*(D35/60)","v":{"$error":"#DIV/0!"}}," min."]
[null,null,null,null,null,"Spray Time / ha ",{"$f":"G15+G36","v":{"$error":"#DIV/0!"}}," min."]
[null,null,null,null,null,"Spray Time / Tank ",{"$f":"G17*G37","v":{"$error":"#DIV/0!"}}," min."]
[null,null,"Time Spraying / ha ",{"$f":"$G$15/($G$15+$G$36+(0/$G$16)+($D$29/$G$17))","v":{"$error":"#DIV/0!"}}]
[null,null,"Time Turning / ha ",{"$f":"$G$36/($G$15+$G$36+(0/$G$16)+($D$29/$G$17))","v":{"$error":"#DIV/0!"}},null,"Work Rate ",{"$f":"60*G17/(G38+D29)","v":{"$error":"#DIV/0!"}}," ha/hr"]
[null,null,"Time Loading / ha ",{"$f":"($D$29/$G$17)/($G$15+$G$36+(0/$G$16)+($D$29/$G$17))","v":{"$error":"#DIV/0!"}},null,"Cost / ha ",{"$f":"SUM($D$19:$D$21)/G40","v":{"$error":"#DIV/0!"}}," /ha"]
[]
[]
[]
[null,null,"Step 5 - Property Totals"]
[null,null,null,null,null,"Time to Spray Area ",{"$f":"D47/G40","v":{"$error":"#DIV/0!"}}," hr"]
[null,null,"Spray Area ",null," ha","Cost per Application ",{"$f":"G41*D47","v":{"$error":"#DIV/0!"}}," /spray"]
[null,null,"Annual Applications ",null," /yr","Annual Cost ",{"$f":"G47*D48","v":{"$error":"#DIV/0!"}}," /yr"]
[]
[]
[]
[null,null,"Step 6 - Sprayer Investment on an Hourly Cost of Use Basis."]
[null,null,"Note: Results May Warrant Reconsidering Sprayer Cost Input in Step 2."]
[null,null,null,null,null,"Depreciation ",{"$f":"D55/D56","v":{"$error":"#DIV/0!"}}," /yr"]
[null,null,"Purchase Cost ",null,null,"Total Cost ",{"$f":"D57+G54","v":{"$error":"#DIV/0!"}}," /yr"]
[null,null,"Depreciation Term ",null," yrs","Hours Operation ",{"$f":"G46*D48","v":{"$error":"#DIV/0!"}}," /yr"]
[null,null,"Repair / Maintenance ",null," /yr","Operating Cost ",{"$f":"G55/G56","v":{"$error":"#DIV/0!"}}," /hr"]
[]
[]
[]
[null,null,"Step 7 - Copy up to Four Scenarios to Comparison Page."]

{"sheet":"Comparison Page","index":2,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"   Work Rate and Spray Application Cost Comparisons   "]
[]
[null,"Date ",{"$f":"'Scenario Inputs'!D5","v":"2019-11-12"}]
[null,"Property ",{"$f":"'Scenario Inputs'!D6","v":0}]
[null,"Block ",{"$f":"'Scenario Inputs'!D7","v":0}]
[null,"Sprayer / Tractor ",{"$f":"'Scenario Inputs'!D8","v":0}]
[]
[]
[]
[null,null,"Scenario #1","Scenario #2","Scenario #3","Scenario #4"]
[]
[null,"Travel Speed ",null,null,null,null," km/hr"]
[null,"Spray Volume ",null,null,null,null," l/ha"]
[null,"Tank Size ",null,null,null,null," l"]
[null,"Loading Time",null,null,null,null," min."]
[null,"Turning Time ",null,null,null,null," sec."]
[]
[null,"Row Spacing ",null,null,null,null," m"]
[null,"Rows Sprayed / Pass "]
[null,"Avg. Row Length ",null,null,null,null," m"]
[null,"Spray Area ",null,null,null,null," ha"]
[]
[null,"Labour Cost ",null,null,null,null," /hr"]
[null,"Tractor Cost ",null,null,null,null," /hr"]
[null,"Sprayer Cost ",null,null,null,null," /hr"]
[]
[null,"WORK RATE",null,null,null,null," ha/hr"]
[]
[null,"Cost / ha ",null,null,null,null," /ha"]
[null,"Time to Spray Area ",null,null,null,null," hr"]
[null,"Cost / Application ",null,null,null,null," /spray"]

{"sheet":"About","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"© Dr. David Manktelow"]
[null,"Applied Research and Technologies Ltd."]
[]
[null,"Napier, New Zealand"]
[null,"email: david@applied research.nz"]
[null,"twitter: @spray_kiwi"]
[]
[null,"This spreadsheet can be freely copied provided acknowldegement to the developer "]
[null,"www.sprayers101.com"]