{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Hectare","Hour","Workrate","Repair costs"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":3,"pivot_tables":0},"unopened":[],"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"}

{"sheet":"Hectare","index":0,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,5],[37,1,37,5]]}
[null,"Machinery costing calculator:\nMachinery costs calculation (per hectare)\nNote: Edit blue cells only*"]
[]
[]
[{"$nulls":4},"£"]
[]
[null,"Purchase price",null,null,126000]
[null,"Selling price after",8,"Years",34000]
[null,"Hectares worked annually",null,null,1200]
[]
[null,"Fixed costs "]
[null,"Average value per year owned",null,null,{"$f":"(E6+E7)/2","v":80000}]
[null,"Interest",2,"% rate",{"$f":"(E11*C12)/100","v":1600}]
[null,"Annual depreciation",null,null,{"$f":"(E6-E7)/C7","v":11500}]
[null,"Insurance",2,"% of purchase price",{"$f":"(E6*C14)/100","v":2520}]
[null,"Building/storage cost",1,"% of purchase price",{"$f":"(E6*C15)/100","v":1260}]
[]
[null,"Total annual fixed cost",null,null,{"$f":"(E12+E13+E14+E15)","v":16880}]
[]
[null,"Fixed cost per hectare",null,null,{"$f":"(E17/E8)","v":14.066666666666666}]
[]
[null,"Operating costs"]
[null,"Ha covered/worked",4,"Per Hr"]
[null,"Labour cost",14,"£/Hr"]
[null,"Labour per Ha",null,null,{"$f":"C23/C22","v":3.5}]
[null,"Fuel price (click for price data)",0.53,"£/L"]
[null,"Fuel consumption (click for typical figures, see page 12)",20,"L/Ha"]
[null,"Cost of fuel per Ha",null,null,{"$f":"C26*C25","v":10.600000000000001}]
[null,"Spares and repairs",2,"% of purchase price",{"$f":"(E6*C28/100)/E8","v":2.1}]
[]
[null,"Total cost per Ha",null,null,{"$f":"E24+E27+E28+E19","v":30.266666666666669}]
[]
[null,"Contractors/machinery ring charge per Ha",null,null,76]
[null,"(Click for typical contractor charges)"]
[]
[null,"Annual savings by using contractor and not purchasing",null,null,{"$f":"(E30-E32)*E8","v":-54880}]
[null," -£ would suggest you may be better purchasing"]
[]
[null,"*Note: Blue cells pre-populated for illustrative purposes only"]

{"sheet":"Hour","index":1,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,0,5],[36,1,36,5]]}
[null,"Machinery costing calculator:\nMachinery costs calculation (per hour)\nNote: Edit blue cells only*"]
[]
[]
[{"$nulls":4},"£"]
[]
[null,"Purchase price",null,null,92751]
[null,"Selling price after",7,"Years",40000]
[null,"Hours worked annually",null,null,700]
[]
[null,"Fixed costs "]
[null,"Average value per year owned",null,null,{"$f":"(E6+E7)/2","v":66375.5}]
[null,"Interest",2,"% rate",{"$f":"(E11*C12)/100","v":1327.51}]
[null,"Actual annual depreciation",null,null,{"$f":"(E6-E7)/C7","v":7535.8571428571431}]
[null,"Insurance",2,"% of purchase price",{"$f":"(E6*C14)/100","v":1855.02}]
[null,"Building /storage cost",1,"% of purchase price",{"$f":"(E6*C15)/100","v":927.51}]
[]
[null,"Total annual fixed cost",null,null,{"$f":"(E12+E13+E14+E15)","v":11645.897142857144}]
[]
[null,"Fixed cost per hour",null,null,{"$f":"(E17/E8)","v":16.636995918367347}]
[]
[null,"Operating costs"]
[null,"Ha covered/worked per hour",4,"Per Hr"]
[null,"Fuel price (click for price data)",14,"£/Hr"]
[null,"Fuel consumption (click for typical figures, see page 12)",0.6,"£/Lt"]
[null,"Cost of fuel per hour",null,null,{"$f":"(C22*C23)*C24","v":33.6}]
[null,"Spares and repairs",1,"% of purchase price",{"$f":"(E6*C26/100)/E8","v":1.3250142857142857}]
[null,"Labour cost per hour",null,null,14]
[]
[null,"Total cost per hour",null,null,{"$f":"(E19+E27+E25+E26)","v":65.562010204081631}]
[]
[null,"Contractors/machinery ring charge per hour",null,null,45]
[null,"(Click for typical contractor charges)"]
[]
[null,"Annual savings by using contractor and not purchasing",null,null,{"$f":"(E29-E31)*E8","v":14393.407142857141}]
[null," -£ would suggest you may be better purchasing"]
[]
[null,"*Note: Blue cells pre-populated for illustrative purposes only"]

{"sheet":"Workrate","index":2,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,4],[32,1,32,4]]}
[null,"Machinery costing calculator:\nWorkrate (compare between to machines)\nNote: Edit blue cells only*"]
[]
[]
[]
[null,null,"Model","Model"]
[null,null,"A","B"]
[null,"Input"]
[null,"Implement width (m)",4,30]
[null,"Capacity (kg or L)",800,2000]
[null,"Forward speed (km/Hr)",6,12]
[null,"Application rate",180,250]
[null,"Transport time, one way (min)",5,5]
[null,"Filling time (min)",10,10]
[null,"Field efficiency (%)",65,75]
[]
[]
[null,"Output"]
[null,"Area covered per load (ha)",{"$f":"(C9/C11)","v":4.4444444444444446},5]
[null,"Filling rate (kg/min or L/min)",{"$f":"(C9/C13)","v":80},{"$f":"D9/D13","v":200}]
[null,"Spot work rate (Ha/Hr)",{"$f":"(C8*C10/10)","v":2.4},{"$f":"D8*D10/10","v":36}]
[null,"Total time per load (min)",{"$f":"(C13+2*C12)+(6000*C18)/(C20*C14)","v":190.94017094017096},{"$f":"D13+2*D12+(6000*D18)/(D20*D14)","v":31.111111111111111}]
[null,"Overall work rate (Ha/Hr)",{"$f":"(60*C18/C21)","v":1.3965980304386749},{"$f":"60*D18/D21","v":9.6428571428571423}]
[null,"Overall efficiency (%)",{"$f":"100*C22/C20","v":58.19158460161146},{"$f":"100*D22/D20","v":26.785714285714285}]
[]
[null,"Components"]
[null,"Application time per load (min)",{"$f":"6000*C18/(C20*C14)","v":170.94017094017096},{"$f":"6000*D18/(D20*D14)","v":11.111111111111111}]
[null,"Application time (%)",{"$f":"100*C26/C21","v":89.52551477170995},{"$f":"100*D26/D21","v":35.714285714285715}]
[null,"Filling time per load (min)",{"$f":"C13","v":10},{"$f":"D13","v":10}]
[null,"Filling time (%)",{"$f":"100*C28/C21","v":5.237242614145031},{"$f":"100*D28/D21","v":32.142857142857146}]
[null,"Transport time per load (min)",{"$f":"2*C12","v":10},{"$f":"2*D12","v":10}]
[null,"Transport time (%)",{"$f":"100*C30/C21","v":5.237242614145031},{"$f":"100*D30/D21","v":32.142857142857146}]
[]
[null,"*Note: Blue cells pre-populated for illustrative purposes only"]

{"sheet":"Repair costs","index":3,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,10],[6,6,6,10],[1,5,2,5],[1,6,1,10],[11,1,11,3]]}
[null,"Machinery costing calculator:\nEstimated Annual cost of repairs\nNote: Edit blue cells only"]
[{"$nulls":5},"Table 1. Percentage of purchase price as cost of repairs","Annual use (hours)"]
[{"$nulls":6},500,750,1000,1500,"Additional hours \n(for every 100 hours)"]
[null,"Purchase price",69000,null,null,null,"%","%","%","%","%"]
[{"$nulls":5},"Tractors",3,3.5,5,7,0.5]
[null,"Annual use",400,"Hr/Year"]
[{"$nulls":6},"Annual use (hours)"]
[null,"% of purchase price (table 1)",5,"%",null,null,50,100,150,200,"Additional hours \n(for every 100 hours)"]
[{"$nulls":6},"%","%","%","%","%"]
[null,"Budgeted repair and maintenance bill",{"$f":"C4*C8/100","v":3450}]
[{"$nulls":5},"Harvesting machinery"]
[null,"*Note: Blue cells pre-populated for illustrative purposes only",null,null,null,"Combine harvesters, self-propelled forage harvesters, self-propelled potato harvesters",1.5,2.5,3.5,4.5,2]
[]
[{"$nulls":5},"Trailed forage harvesters, pick-up balers, potato and sugar beet harvesters",3,5,6,7,2]
[]
[{"$nulls":5},"Other implements and machines"]
[{"$nulls":5},"Ploughs, cultivators and toothed harrows",4.5,8,11,14,6]
[]
[{"$nulls":5},"Rotary cultivators, mowers and pea cutters - windrowers",4,7,9.5,12,5]
[]
[{"$nulls":5},"Disc harrows, fertiliser spreaders, muck spreaders,combine drills, potato planters with fertiliser attachment,sprayers and hedge cutters",3,5.5,7.5,9.5,4]
[]
[{"$nulls":5},"Tedders, unit drills, flail forage harvesters, semi-automatic, potato planters and transplanters",2.5,4.5,6.5,8.5,4]
[]
[{"$nulls":5},"Cereal drills, hydraulic loaders and potato planting attachments",2,4,5.5,7,3]
[]
[{"$nulls":5},"Grain dryers, grain cleaners and rolls",1.5,2,2.5,3,0.5]