{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Guidance","Summary","Beef","Dairy","Sheep","Cropping","Drainage","General inputs and assumptions","Document control","Calcs - hide","Lookups - hide"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":4,"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":"Guidance","index":0,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Guidance"]
[]
[]
[null,null,"The purpose of this tool is for individual landholders and groups of landholders to assess if  "]
[null,null,"renewing and maintaining on-farm drains is economically viable."]
[]
[null,null,"The tool is designed to be as simple as possible to provide an approximation of economic viability, "]
[null,null,"as a first step towards determining if further investigation and detail is warranted. All outputs "]
[null,null,"should be treated as indicative and should not be relied upon alone to make investment or"]
[null,null,"management decisions."]
[]
[null,null,"Ensure macros are enabled by clicking on File => Enable Content => Enable All Content"]
[]
[null,null,"The assessment requires a few basic inputs from the user relating to production on their land, and"]
[null,null,"drainage works required. The assessment can be undertaken on one to ten properties."]
[]
[null,null,"Inputs required of the user are marked in orange => "]
[]
[null,null,"For simplicity, many of the input fields have default values provided. The user may enter their own "]
[null,null,"inputs to override these."]
[]
[null,null,"Step 1: Clear all existing input values =>"]
[]
[]
[null,null,"Step 2: Provide input production values for each farming activity (more than one activity can be "]
[null,null,null,"selected for each property). "]
[null,null,null,"Press on a button below to provide inputs for each activity that exists withing the "]
[null,null,null,"drainage area. You can return to this guidance sheet from each activity sheet."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[]
[]
[null,null,"Step 3: Provide inputs for drainage on one or more properties =>"]
[]
[]
[]
[]
[null,null,"Step 4: Review summary of inputs and results of economic analysis =>"]

{"sheet":"Summary","index":1,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[[30,5,30,6],[5,4,7,4],[8,4,10,4],[11,4,13,4],[14,4,16,4],[17,4,19,4],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[22,4,22,5]]}
["Summary"]
[]
[]
[null,null,"SUMMARY OF INPUTS"]
[null,null,"Button",null,"Beef","Description","Units","Property 1 ","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10","ALL PROPERTIES"]
[null,null,null,null,"Beef","Number of breeding livestock in a typical year with no drainage works","head",{"$f":"IF(Beef!C4=0,\"\",Beef!C4)","v":""},{"$f":"IF(Beef!D4=0,\"\",Beef!D4)","v":""},{"$f":"IF(Beef!E4=0,\"\",Beef!E4)","v":""},{"$f":"IF(Beef!F4=0,\"\",Beef!F4)","v":""},{"$f":"IF(Beef!G4=0,\"\",Beef!G4)","v":""},{"$f":"IF(Beef!H4=0,\"\",Beef!H4)","v":""},{"$f":"IF(Beef!I4=0,\"\",Beef!I4)","v":""},{"$f":"IF(Beef!J4=0,\"\",Beef!J4)","v":""},{"$f":"IF(Beef!K4=0,\"\",Beef!K4)","v":""},{"$f":"IF(Beef!L4=0,\"\",Beef!L4)","v":""},{"$f":"SUM(H6:Q6)","v":0}]
[null,null,null,null,null,"Expected number of breeding livestock in a typical year with improved drainage","head",{"$f":"IF(Beef!C5=0,\"\",Beef!C5)","v":""},{"$f":"IF(Beef!D5=0,\"\",Beef!D5)","v":""},{"$f":"IF(Beef!E5=0,\"\",Beef!E5)","v":""},{"$f":"IF(Beef!F5=0,\"\",Beef!F5)","v":""},{"$f":"IF(Beef!G5=0,\"\",Beef!G5)","v":""},{"$f":"IF(Beef!H5=0,\"\",Beef!H5)","v":""},{"$f":"IF(Beef!I5=0,\"\",Beef!I5)","v":""},{"$f":"IF(Beef!J5=0,\"\",Beef!J5)","v":""},{"$f":"IF(Beef!K5=0,\"\",Beef!K5)","v":""},{"$f":"IF(Beef!L5=0,\"\",Beef!L5)","v":""},{"$f":"SUM(H7:Q7)","v":0}]
[null,null,null,null,null,"Average gross margin per head","$ per head",{"$f":"IF(H6=\"\",\"\",'Calcs - hide'!B6)","v":""},{"$f":"IF(I6=\"\",\"\",'Calcs - hide'!C6)","v":""},{"$f":"IF(J6=\"\",\"\",'Calcs - hide'!D6)","v":""},{"$f":"IF(K6=\"\",\"\",'Calcs - hide'!E6)","v":""},{"$f":"IF(L6=\"\",\"\",'Calcs - hide'!F6)","v":""},{"$f":"IF(M6=\"\",\"\",'Calcs - hide'!G6)","v":""},{"$f":"IF(N6=\"\",\"\",'Calcs - hide'!H6)","v":""},{"$f":"IF(O6=\"\",\"\",'Calcs - hide'!I6)","v":""},{"$f":"IF(P6=\"\",\"\",'Calcs - hide'!J6)","v":""},{"$f":"IF(Q6=\"\",\"\",'Calcs - hide'!K6)","v":""},"N/A"]
[null,null,null,null,"Dairy","Number of breeding livestock in a typical year with no drainage works","head",{"$f":"IF(Dairy!C4=0,\"\",Dairy!C4)","v":""},{"$f":"IF(Dairy!D4=0,\"\",Dairy!D4)","v":""},{"$f":"IF(Dairy!E4=0,\"\",Dairy!E4)","v":""},{"$f":"IF(Dairy!F4=0,\"\",Dairy!F4)","v":""},{"$f":"IF(Dairy!G4=0,\"\",Dairy!G4)","v":""},{"$f":"IF(Dairy!H4=0,\"\",Dairy!H4)","v":""},{"$f":"IF(Dairy!I4=0,\"\",Dairy!I4)","v":""},{"$f":"IF(Dairy!J4=0,\"\",Dairy!J4)","v":""},{"$f":"IF(Dairy!K4=0,\"\",Dairy!K4)","v":""},{"$f":"IF(Dairy!L4=0,\"\",Dairy!L4)","v":""},{"$f":"SUM(H9:Q9)","v":0}]
[null,null,null,null,null,"Expected number of breeding livestock in a typical year with improved drainage","head",{"$f":"IF(Dairy!C5=0,\"\",Dairy!C5)","v":""},{"$f":"IF(Dairy!D5=0,\"\",Dairy!D5)","v":""},{"$f":"IF(Dairy!E5=0,\"\",Dairy!E5)","v":""},{"$f":"IF(Dairy!F5=0,\"\",Dairy!F5)","v":""},{"$f":"IF(Dairy!G5=0,\"\",Dairy!G5)","v":""},{"$f":"IF(Dairy!H5=0,\"\",Dairy!H5)","v":""},{"$f":"IF(Dairy!I5=0,\"\",Dairy!I5)","v":""},{"$f":"IF(Dairy!J5=0,\"\",Dairy!J5)","v":""},{"$f":"IF(Dairy!K5=0,\"\",Dairy!K5)","v":""},{"$f":"IF(Dairy!L5=0,\"\",Dairy!L5)","v":""},{"$f":"SUM(H10:Q10)","v":0}]
[null,null,null,null,null,"Average gross margin per head","$ per head",{"$f":"IF(H9=\"\",\"\",'Calcs - hide'!B7)","v":""},{"$f":"IF(I9=\"\",\"\",'Calcs - hide'!C7)","v":""},{"$f":"IF(J9=\"\",\"\",'Calcs - hide'!D7)","v":""},{"$f":"IF(K9=\"\",\"\",'Calcs - hide'!E7)","v":""},{"$f":"IF(L9=\"\",\"\",'Calcs - hide'!F7)","v":""},{"$f":"IF(M9=\"\",\"\",'Calcs - hide'!G7)","v":""},{"$f":"IF(N9=\"\",\"\",'Calcs - hide'!H7)","v":""},{"$f":"IF(O9=\"\",\"\",'Calcs - hide'!I7)","v":""},{"$f":"IF(P9=\"\",\"\",'Calcs - hide'!J7)","v":""},{"$f":"IF(Q9=\"\",\"\",'Calcs - hide'!K7)","v":""},"N/A"]
[null,null,null,null,"Sheep","Number of breeding livestock in a typical year with no drainage works","head",{"$f":"IF(Sheep!C4=0,\"\",Sheep!C4)","v":""},{"$f":"IF(Sheep!D4=0,\"\",Sheep!D4)","v":""},{"$f":"IF(Sheep!E4=0,\"\",Sheep!E4)","v":""},{"$f":"IF(Sheep!F4=0,\"\",Sheep!F4)","v":""},{"$f":"IF(Sheep!G4=0,\"\",Sheep!G4)","v":""},{"$f":"IF(Sheep!H4=0,\"\",Sheep!H4)","v":""},{"$f":"IF(Sheep!I4=0,\"\",Sheep!I4)","v":""},{"$f":"IF(Sheep!J4=0,\"\",Sheep!J4)","v":""},{"$f":"IF(Sheep!K4=0,\"\",Sheep!K4)","v":""},{"$f":"IF(Sheep!L4=0,\"\",Sheep!L4)","v":""},{"$f":"SUM(H12:Q12)","v":0}]
[null,null,null,null,null,"Expected number of breeding livestock in a typical year with improved drainage","head",{"$f":"IF(Sheep!C5=0,\"\",Sheep!C5)","v":""},{"$f":"IF(Sheep!D5=0,\"\",Sheep!D5)","v":""},{"$f":"IF(Sheep!E5=0,\"\",Sheep!E5)","v":""},{"$f":"IF(Sheep!F5=0,\"\",Sheep!F5)","v":""},{"$f":"IF(Sheep!G5=0,\"\",Sheep!G5)","v":""},{"$f":"IF(Sheep!H5=0,\"\",Sheep!H5)","v":""},{"$f":"IF(Sheep!I5=0,\"\",Sheep!I5)","v":""},{"$f":"IF(Sheep!J5=0,\"\",Sheep!J5)","v":""},{"$f":"IF(Sheep!K5=0,\"\",Sheep!K5)","v":""},{"$f":"IF(Sheep!L5=0,\"\",Sheep!L5)","v":""},{"$f":"SUM(H13:Q13)","v":0}]
[null,null,null,null,null,"Average gross margin per head","$ per head",{"$f":"IF(H12=\"\",\"\",'Calcs - hide'!B8)","v":""},{"$f":"IF(I12=\"\",\"\",'Calcs - hide'!C8)","v":""},{"$f":"IF(J12=\"\",\"\",'Calcs - hide'!D8)","v":""},{"$f":"IF(K12=\"\",\"\",'Calcs - hide'!E8)","v":""},{"$f":"IF(L12=\"\",\"\",'Calcs - hide'!F8)","v":""},{"$f":"IF(M12=\"\",\"\",'Calcs - hide'!G8)","v":""},{"$f":"IF(N12=\"\",\"\",'Calcs - hide'!H8)","v":""},{"$f":"IF(O12=\"\",\"\",'Calcs - hide'!I8)","v":""},{"$f":"IF(P12=\"\",\"\",'Calcs - hide'!J8)","v":""},{"$f":"IF(Q12=\"\",\"\",'Calcs - hide'!K8)","v":""},"N/A"]
[null,null,null,null,"Cropping","Expected total yield in a typical year with no drainage works","tonnes",{"$f":"IF(Cropping!C6=0,\"\",Cropping!C6)","v":""},{"$f":"IF(Cropping!D6=0,\"\",Cropping!D6)","v":""},{"$f":"IF(Cropping!E6=0,\"\",Cropping!E6)","v":""},{"$f":"IF(Cropping!F6=0,\"\",Cropping!F6)","v":""},{"$f":"IF(Cropping!G6=0,\"\",Cropping!G6)","v":""},{"$f":"IF(Cropping!H6=0,\"\",Cropping!H6)","v":""},{"$f":"IF(Cropping!I6=0,\"\",Cropping!I6)","v":""},{"$f":"IF(Cropping!J6=0,\"\",Cropping!J6)","v":""},{"$f":"IF(Cropping!K6=0,\"\",Cropping!K6)","v":""},{"$f":"IF(Cropping!L6=0,\"\",Cropping!L6)","v":""},{"$f":"SUM(H15:Q15)","v":0}]
[null,null,null,null,null,"Expected total yield in a typical year with improved drainage","tonnes",{"$f":"IF(Cropping!C7=0,\"\",Cropping!C7)","v":""},{"$f":"IF(Cropping!D7=0,\"\",Cropping!D7)","v":""},{"$f":"IF(Cropping!E7=0,\"\",Cropping!E7)","v":""},{"$f":"IF(Cropping!F7=0,\"\",Cropping!F7)","v":""},{"$f":"IF(Cropping!G7=0,\"\",Cropping!G7)","v":""},{"$f":"IF(Cropping!H7=0,\"\",Cropping!H7)","v":""},{"$f":"IF(Cropping!I7=0,\"\",Cropping!I7)","v":""},{"$f":"IF(Cropping!J7=0,\"\",Cropping!J7)","v":""},{"$f":"IF(Cropping!K7=0,\"\",Cropping!K7)","v":""},{"$f":"IF(Cropping!L7=0,\"\",Cropping!L7)","v":""},{"$f":"SUM(H16:Q16)","v":0}]
[null,null,null,null,null,"Average gross margin per hectare with improved drainage","$ per hectare",{"$f":"IF(H15=\"\",\"\",'Calcs - hide'!B10)","v":""},{"$f":"IF(I15=\"\",\"\",'Calcs - hide'!C10)","v":""},{"$f":"IF(J15=\"\",\"\",'Calcs - hide'!D10)","v":""},{"$f":"IF(K15=\"\",\"\",'Calcs - hide'!E10)","v":""},{"$f":"IF(L15=\"\",\"\",'Calcs - hide'!F10)","v":""},{"$f":"IF(M15=\"\",\"\",'Calcs - hide'!G10)","v":""},{"$f":"IF(N15=\"\",\"\",'Calcs - hide'!H10)","v":""},{"$f":"IF(O15=\"\",\"\",'Calcs - hide'!I10)","v":""},{"$f":"IF(P15=\"\",\"\",'Calcs - hide'!J10)","v":""},{"$f":"IF(Q15=\"\",\"\",'Calcs - hide'!K10)","v":""},"N/A"]
[null,null,null,null,"Drainage","Length of drain on property","m",{"$f":"IF(Drainage!C4=0,\"\",Drainage!C4)","v":""},{"$f":"IF(Drainage!D4=0,\"\",Drainage!D4)","v":""},{"$f":"IF(Drainage!E4=0,\"\",Drainage!E4)","v":""},{"$f":"IF(Drainage!F4=0,\"\",Drainage!F4)","v":""},{"$f":"IF(Drainage!G4=0,\"\",Drainage!G4)","v":""},{"$f":"IF(Drainage!H4=0,\"\",Drainage!H4)","v":""},{"$f":"IF(Drainage!I4=0,\"\",Drainage!I4)","v":""},{"$f":"IF(Drainage!J4=0,\"\",Drainage!J4)","v":""},{"$f":"IF(Drainage!K4=0,\"\",Drainage!K4)","v":""},{"$f":"IF(Drainage!L4=0,\"\",Drainage!L4)","v":""},{"$f":"SUM(H18:Q18)","v":0}]
[null,null,null,null,null,"Upfront refurbishment cost","$",{"$f":"IF(H18=\"\",\"\",'Calcs - hide'!B57)","v":""},{"$f":"IF(I18=\"\",\"\",'Calcs - hide'!C57)","v":""},{"$f":"IF(J18=\"\",\"\",'Calcs - hide'!D57)","v":""},{"$f":"IF(K18=\"\",\"\",'Calcs - hide'!E57)","v":""},{"$f":"IF(L18=\"\",\"\",'Calcs - hide'!F57)","v":""},{"$f":"IF(M18=\"\",\"\",'Calcs - hide'!G57)","v":""},{"$f":"IF(N18=\"\",\"\",'Calcs - hide'!H57)","v":""},{"$f":"IF(O18=\"\",\"\",'Calcs - hide'!I57)","v":""},{"$f":"IF(P18=\"\",\"\",'Calcs - hide'!J57)","v":""},{"$f":"IF(Q18=\"\",\"\",'Calcs - hide'!K57)","v":""},0]
[null,null,null,null,null,"Ongoing annual maintenance cost","$ per year",{"$f":"IF(H18=\"\",\"\",'Calcs - hide'!B59)","v":""},{"$f":"IF(I18=\"\",\"\",'Calcs - hide'!C59)","v":""},{"$f":"IF(J18=\"\",\"\",'Calcs - hide'!D59)","v":""},{"$f":"IF(K18=\"\",\"\",'Calcs - hide'!E59)","v":""},{"$f":"IF(L18=\"\",\"\",'Calcs - hide'!F59)","v":""},{"$f":"IF(M18=\"\",\"\",'Calcs - hide'!G59)","v":""},{"$f":"IF(N18=\"\",\"\",'Calcs - hide'!H59)","v":""},{"$f":"IF(O18=\"\",\"\",'Calcs - hide'!I59)","v":""},{"$f":"IF(P18=\"\",\"\",'Calcs - hide'!J59)","v":""},{"$f":"IF(Q18=\"\",\"\",'Calcs - hide'!K59)","v":""},0]
[]
[null,null,"SUMMARY OF OUTPUTS"]
[null,null,null,null,"Output desciption",null,"Units","Property 1 ","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10","TOTAL ALL PROPERTIES"]
[null,null,null,null,"Annualised benefit from increased production ($ per year)",null,"$ per year",{"$f":"IF('Calcs - hide'!B51=0,\"\",'Calcs - hide'!B51)","v":""},{"$f":"IF('Calcs - hide'!C51=0,\"\",'Calcs - hide'!C51)","v":""},{"$f":"IF('Calcs - hide'!D51=0,\"\",'Calcs - hide'!D51)","v":""},{"$f":"IF('Calcs - hide'!E51=0,\"\",'Calcs - hide'!E51)","v":""},{"$f":"IF('Calcs - hide'!F51=0,\"\",'Calcs - hide'!F51)","v":""},{"$f":"IF('Calcs - hide'!G51=0,\"\",'Calcs - hide'!G51)","v":""},{"$f":"IF('Calcs - hide'!H51=0,\"\",'Calcs - hide'!H51)","v":""},{"$f":"IF('Calcs - hide'!I51=0,\"\",'Calcs - hide'!I51)","v":""},{"$f":"IF('Calcs - hide'!J51=0,\"\",'Calcs - hide'!J51)","v":""},{"$f":"IF('Calcs - hide'!K51=0,\"\",'Calcs - hide'!K51)","v":""},{"$f":"SUM(H24:Q24)","v":0}]
[null,null,null,null,"Annualised refurbishment and maintenance costs ($ per year)",null,"$ per year",{"$f":"IF('Calcs - hide'!B91=0,\"\",'Calcs - hide'!B91)","v":""},{"$f":"IF('Calcs - hide'!C91=0,\"\",'Calcs - hide'!C91)","v":""},{"$f":"IF('Calcs - hide'!D91=0,\"\",'Calcs - hide'!D91)","v":""},{"$f":"IF('Calcs - hide'!E91=0,\"\",'Calcs - hide'!E91)","v":""},{"$f":"IF('Calcs - hide'!F91=0,\"\",'Calcs - hide'!F91)","v":""},{"$f":"IF('Calcs - hide'!G91=0,\"\",'Calcs - hide'!G91)","v":""},{"$f":"IF('Calcs - hide'!H91=0,\"\",'Calcs - hide'!H91)","v":""},{"$f":"IF('Calcs - hide'!I91=0,\"\",'Calcs - hide'!I91)","v":""},{"$f":"IF('Calcs - hide'!J91=0,\"\",'Calcs - hide'!J91)","v":""},{"$f":"IF('Calcs - hide'!K91=0,\"\",'Calcs - hide'!K91)","v":""},{"$f":"SUM(H25:Q25)","v":0}]
[null,null,null,null,"Benefit Cost Ratio:",null,"Unitless",{"$f":"IFERROR(IF(AND(H24=\"\",H25=\"\"),\"\",IF(OR(H25=0,H25=\"\"),\"no cost\", H24/H25)),0)","v":""},"","",{"$f":"IFERROR(IF(AND(K24=\"\",K25=\"\"),\"\",IF(OR(K25=0,K25=\"\"),\"no cost\", K24/K25)),0)","v":""},{"$f":"IFERROR(IF(AND(L24=\"\",L25=\"\"),\"\",IF(OR(L25=0,L25=\"\"),\"no cost\", L24/L25)),0)","v":""},{"$f":"IFERROR(IF(AND(M24=\"\",M25=\"\"),\"\",IF(OR(M25=0,M25=\"\"),\"no cost\", M24/M25)),0)","v":""},{"$f":"IFERROR(IF(AND(N24=\"\",N25=\"\"),\"\",IF(OR(N25=0,N25=\"\"),\"no cost\", N24/N25)),0)","v":""},"",{"$f":"IFERROR(IF(AND(P24=\"\",P25=\"\"),\"\",IF(OR(P25=0,P25=\"\"),\"no cost\", P24/P25)),0)","v":""},{"$f":"IF(AND(Q24=\"\",Q25=\"\"),\"\",IF(OR(Q25=0,Q25=\"\"),\"no cost\", Q24/Q25))","v":""},{"$f":"IF(AND(R24=0,R25=0),\"\",IF(OR(R25=0,R25=\"\"),\"no cost\", R24/R25))","v":""}]
[null,null,null,null,"Payback period",null,"years",{"$f":"IF('Calcs - hide'!B123=0,\"\",'Calcs - hide'!B123)","v":""},{"$f":"IF('Calcs - hide'!C123=0,\"\",'Calcs - hide'!C123)","v":""},{"$f":"IF('Calcs - hide'!D123=0,\"\",'Calcs - hide'!D123)","v":""},{"$f":"IF('Calcs - hide'!E123=0,\"\",'Calcs - hide'!E123)","v":""},{"$f":"IF('Calcs - hide'!F123=0,\"\",'Calcs - hide'!F123)","v":""},{"$f":"IF('Calcs - hide'!G123=0,\"\",'Calcs - hide'!G123)","v":""},{"$f":"IF('Calcs - hide'!H123=0,\"\",'Calcs - hide'!H123)","v":""},{"$f":"IF('Calcs - hide'!I123=0,\"\",'Calcs - hide'!I123)","v":""},{"$f":"IF('Calcs - hide'!J123=0,\"\",'Calcs - hide'!J123)","v":""},{"$f":"IF('Calcs - hide'!K123=0,\"\",'Calcs - hide'!K123)","v":""},{"$f":"'Calcs - hide'!L123","v":0}]
[]
[null,null,"ECONOMIC VIABILITY OF DRAINAGE ACROSS ALL PROPERTIES"]
[]
[null,null,null,null,null,{"$f":"IF(OR(G32=\"\",G32=\"no cost\"),\"\",IF(G32<0.5,\"Drainage project is not economically viable\",IF(AND(G32>0.5,G32<1),\"Drainage project is marginal, further investigation is required\",IF(OR(G32>1,G32=1),\"Drainage project is economically viable\",\"\"))))","v":""}]
[null,null,null,null,null,"Benefit Cost Ratio:",{"$f":"IF(AND(R24=0,R25=0),\"\",IF(R25=0,\"no cost\", R24/R25))","v":""}]
[null,null,null,null,null,"Net Present Value:",{"$f":"ROUND(('Calcs - hide'!L50-'Calcs - hide'!L90),-3)","v":0}]
[null,null,null,null,null,"Payback period (years): ",{"$f":"R27","v":0}]

{"sheet":"Beef","index":2,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,0,6,0],[7,0,8,0],[2,0,2,1],[3,0,3,1],[4,0,4,1]]}
["Beef enterprise - user inputs"]
[]
["Input description",null,"Property 1 ","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10"]
["On average, how many head of breeding stock would you run on each property if drains are not maintained or improved (cows per year)?"]
["If drains were improved and maintained on an ongoing basis, how many head of breeding stock would you sensibly run on each property (cows per year)?"]
["As an approximate average across the herd on each property, what is the annual gross income \nper breeding head of stock?\n(\"Gross income\" includes the annual revenue from  all livestock sales minus the value of livestock purchases - \ndefault value will apply if user value is not provided)","Default value",{"$f":"IF(OR(C4=0,C4=\"\"),\"\",'General inputs and assumptions'!$B$11)","v":""},{"$f":"IF(OR(D4=0,D4=\"\"),\"\",'General inputs and assumptions'!$B$11)","v":""},{"$f":"IF(OR(E4=0,E4=\"\"),\"\",'General inputs and assumptions'!$B$11)","v":""},{"$f":"IF(OR(F4=0,F4=\"\"),\"\",'General inputs and assumptions'!$B$11)","v":""},{"$f":"IF(OR(G4=0,G4=\"\"),\"\",'General inputs and assumptions'!$B$11)","v":""},{"$f":"IF(OR(H4=0,H4=\"\"),\"\",'General inputs and assumptions'!$B$11)","v":""},{"$f":"IF(OR(I4=0,I4=\"\"),\"\",'General inputs and assumptions'!$B$11)","v":""},{"$f":"IF(OR(J4=0,J4=\"\"),\"\",'General inputs and assumptions'!$B$11)","v":""},{"$f":"IF(OR(K4=0,K4=\"\"),\"\",'General inputs and assumptions'!$B$11)","v":""},{"$f":"IF(OR(L4=0,L4=\"\"),\"\",'General inputs and assumptions'!$B$11)","v":""}]
[null,"User input value \n(over-rides default value)"]
["As an average across the herd, what is the annual variable cost per breeding head of stock (approximately)?\n(\"Variable costs\" include costs associated with animal health, feed, pasture management, freight and selling costs - default value will apply if user value is not provided)","Default value",{"$f":"IF(OR(C4=0,C4=\"\"),\"\",'General inputs and assumptions'!$C$11)","v":""},{"$f":"IF(OR(D4=0,D4=\"\"),\"\",'General inputs and assumptions'!$C$11)","v":""},{"$f":"IF(OR(E4=0,E4=\"\"),\"\",'General inputs and assumptions'!$C$11)","v":""},{"$f":"IF(OR(F4=0,F4=\"\"),\"\",'General inputs and assumptions'!$C$11)","v":""},{"$f":"IF(OR(G4=0,G4=\"\"),\"\",'General inputs and assumptions'!$C$11)","v":""},{"$f":"IF(OR(H4=0,H4=\"\"),\"\",'General inputs and assumptions'!$C$11)","v":""},{"$f":"IF(OR(I4=0,I4=\"\"),\"\",'General inputs and assumptions'!$C$11)","v":""},{"$f":"IF(OR(J4=0,J4=\"\"),\"\",'General inputs and assumptions'!$C$11)","v":""},{"$f":"IF(OR(K4=0,K4=\"\"),\"\",'General inputs and assumptions'!$C$11)","v":""},{"$f":"IF(OR(L4=0,L4=\"\"),\"\",'General inputs and assumptions'!$C$11)","v":""}]
[null,"User input value \n(over-rides default value)"]

{"sheet":"Dairy","index":3,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,6,0],[7,0,8,0]]}
["Dairy enterprise - user inputs"]
[]
["Input description",null,"Property 1 ","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10"]
["On average, how many head of breeding stock would you run on each property if drains are not maintained or improved (cows per year)?"]
["If drains were improved and maintained on an ongoing basis, how many head of breeding stock would you sensibly run on each property (cows per year)?"]
["As an approximate average across the herd on each property, what is the annual gross income per breeding head of stock?\n(\"Gross income\" includes the annual revenue from  all milk and livestock sales minus the value of livestock purchases - default value will apply if user value is not provided)","Default value",{"$f":"IF(OR(C4=0,C4=\"\"),\"\",'General inputs and assumptions'!$B$12)","v":""},{"$f":"IF(OR(D4=0,D4=\"\"),\"\",'General inputs and assumptions'!$B$12)","v":""},{"$f":"IF(OR(E4=0,E4=\"\"),\"\",'General inputs and assumptions'!$B$12)","v":""},{"$f":"IF(OR(F4=0,F4=\"\"),\"\",'General inputs and assumptions'!$B$12)","v":""},{"$f":"IF(OR(G4=0,G4=\"\"),\"\",'General inputs and assumptions'!$B$12)","v":""},{"$f":"IF(OR(H4=0,H4=\"\"),\"\",'General inputs and assumptions'!$B$12)","v":""},{"$f":"IF(OR(I4=0,I4=\"\"),\"\",'General inputs and assumptions'!$B$12)","v":""},{"$f":"IF(OR(J4=0,J4=\"\"),\"\",'General inputs and assumptions'!$B$12)","v":""},{"$f":"IF(OR(K4=0,K4=\"\"),\"\",'General inputs and assumptions'!$B$12)","v":""},{"$f":"IF(OR(L4=0,L4=\"\"),\"\",'General inputs and assumptions'!$B$12)","v":""}]
[null,"User input value \n(over-rides default value)"]
["As an average across the herd, what is the annual variable cost per breeding head of stock (approximately)?\n(\"Variable costs\" include costs associated with animal health, feed, pasture management, freight and selling costs - default value will apply if user value is not provided)","Default value",{"$f":"IF(OR(C4=0,C4=\"\"),\"\",'General inputs and assumptions'!$C$12)","v":""},{"$f":"IF(OR(D4=0,D4=\"\"),\"\",'General inputs and assumptions'!$C$12)","v":""},{"$f":"IF(OR(E4=0,E4=\"\"),\"\",'General inputs and assumptions'!$C$12)","v":""},{"$f":"IF(OR(F4=0,F4=\"\"),\"\",'General inputs and assumptions'!$C$12)","v":""},{"$f":"IF(OR(G4=0,G4=\"\"),\"\",'General inputs and assumptions'!$C$12)","v":""},{"$f":"IF(OR(H4=0,H4=\"\"),\"\",'General inputs and assumptions'!$C$12)","v":""},{"$f":"IF(OR(I4=0,I4=\"\"),\"\",'General inputs and assumptions'!$C$12)","v":""},{"$f":"IF(OR(J4=0,J4=\"\"),\"\",'General inputs and assumptions'!$C$12)","v":""},{"$f":"IF(OR(K4=0,K4=\"\"),\"\",'General inputs and assumptions'!$C$12)","v":""},{"$f":"IF(OR(L4=0,L4=\"\"),\"\",'General inputs and assumptions'!$C$12)","v":""}]
[null,"User input value \n(over-rides default value)"]

{"sheet":"Sheep","index":4,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,6,0],[7,0,8,0]]}
["Sheep enterprise - user inputs"]
[]
["Input description",null,"Property 1 ","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10"]
["On average, how many head of breeding stock would you run on each property if drains are not maintained or improved (sheep per year)?"]
["If drains were improved and maintained on an ongoing basis, how many head of breeding stock would you sensibly run on each property (sheep per year)?"]
["As an approximate average across the flock on each property, what is the annual gross income per breeding head of stock?\n(\"Gross income\" includes the annual revenue from  all livestock sales minus the value of livestock purchases - default value will apply if user value is not provided)","Default value",{"$f":"IF(OR(C4=0,C4=\"\"),\"\",'General inputs and assumptions'!$B$13)","v":""},{"$f":"IF(OR(D4=0,D4=\"\"),\"\",'General inputs and assumptions'!$B$13)","v":""},{"$f":"IF(OR(E4=0,E4=\"\"),\"\",'General inputs and assumptions'!$B$13)","v":""},{"$f":"IF(OR(F4=0,F4=\"\"),\"\",'General inputs and assumptions'!$B$13)","v":""},{"$f":"IF(OR(G4=0,G4=\"\"),\"\",'General inputs and assumptions'!$B$13)","v":""},{"$f":"IF(OR(H4=0,H4=\"\"),\"\",'General inputs and assumptions'!$B$13)","v":""},{"$f":"IF(OR(I4=0,I4=\"\"),\"\",'General inputs and assumptions'!$B$13)","v":""},{"$f":"IF(OR(J4=0,J4=\"\"),\"\",'General inputs and assumptions'!$B$13)","v":""},{"$f":"IF(OR(K4=0,K4=\"\"),\"\",'General inputs and assumptions'!$B$13)","v":""},{"$f":"IF(OR(L4=0,L4=\"\"),\"\",'General inputs and assumptions'!$B$13)","v":""}]
[null,"User input value \n(over-rides default value)"]
["As an average across the flock, what is the annual variable cost per breeding head of stock (approximately)?\n(\"Variable costs\" include costs associated with animal health, feed, pasture management, freight and selling costs - default value will apply if user value is not provided)","Default value",{"$f":"IF(OR(C4=0,C4=\"\"),\"\",'General inputs and assumptions'!$C$13)","v":""},{"$f":"IF(OR(D4=0,D4=\"\"),\"\",'General inputs and assumptions'!$C$13)","v":""},{"$f":"IF(OR(E4=0,E4=\"\"),\"\",'General inputs and assumptions'!$C$13)","v":""},{"$f":"IF(OR(F4=0,F4=\"\"),\"\",'General inputs and assumptions'!$C$13)","v":""},{"$f":"IF(OR(G4=0,G4=\"\"),\"\",'General inputs and assumptions'!$C$13)","v":""},{"$f":"IF(OR(H4=0,H4=\"\"),\"\",'General inputs and assumptions'!$C$13)","v":""},{"$f":"IF(OR(I4=0,I4=\"\"),\"\",'General inputs and assumptions'!$C$13)","v":""},{"$f":"IF(OR(J4=0,J4=\"\"),\"\",'General inputs and assumptions'!$C$13)","v":""},{"$f":"IF(OR(K4=0,K4=\"\"),\"\",'General inputs and assumptions'!$C$13)","v":""},{"$f":"IF(OR(L4=0,L4=\"\"),\"\",'General inputs and assumptions'!$C$13)","v":""}]
[null,"User input value \n(over-rides default value)"]

{"sheet":"Cropping","index":5,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,0,2,1],[5,0,5,1],[6,0,6,1],[7,0,8,0],[9,0,10,0]]}
["Cropping enterprise - user inputs"]
[]
["Input description",null,"Property 1 ","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10"]
["On average, what area of your land would you use for cropping if drains are not maintained or improved (hectares)?"]
["On average, what is an estimate of your annual crop yield for all crops, across all areas cropped,  if drains were not maintained or improved (tonnes per hectare)?"]
["If drains were improved and maintained on an ongoing basis, what area of your land would you expect to use for cropping (hectares)?"]
["If drains were improved and maintained on an ongoing basis, what is an estimate of your annual crop yield for all crops, across all areas cropped (tonnes per hectare)?"]
["What is your expected annual gross income per tonne in an average year (approximately)?\n(\"Gross income\" includes the annual revenue from sale of all crops over the year - default value will apply if user value is not provided)","Default value",{"$f":"IF(OR(C4=0,C4=\"\"),\"\",'General inputs and assumptions'!$B$14)","v":""},{"$f":"IF(OR(D4=0,D4=\"\"),\"\",'General inputs and assumptions'!$B$14)","v":""},{"$f":"IF(OR(E4=0,E4=\"\"),\"\",'General inputs and assumptions'!$B$14)","v":""},{"$f":"IF(OR(F4=0,F4=\"\"),\"\",'General inputs and assumptions'!$B$14)","v":""},{"$f":"IF(OR(G4=0,G4=\"\"),\"\",'General inputs and assumptions'!$B$14)","v":""},{"$f":"IF(OR(H4=0,H4=\"\"),\"\",'General inputs and assumptions'!$B$14)","v":""},{"$f":"IF(OR(I4=0,I4=\"\"),\"\",'General inputs and assumptions'!$B$14)","v":""},{"$f":"IF(OR(J4=0,J4=\"\"),\"\",'General inputs and assumptions'!$B$14)","v":""},{"$f":"IF(OR(K4=0,K4=\"\"),\"\",'General inputs and assumptions'!$B$14)","v":""},{"$f":"IF(OR(L4=0,L4=\"\"),\"\",'General inputs and assumptions'!$B$14)","v":""}]
[null,"User input value \n(over-rides default value)"]
["What are your annual variable costs per hectare (approximately)?\n(\"Variable costs\" includes the annual costs of labour, fertiliser, irrigation, pesticides, sowing, harvesting, cartage and  machinery operation - default value will apply if user value is not provided)","Default value",{"$f":"IF(OR(C4=0,C4=\"\"),\"\",'General inputs and assumptions'!$C$15)","v":""},{"$f":"IF(OR(D4=0,D4=\"\"),\"\",'General inputs and assumptions'!$C$15)","v":""},{"$f":"IF(OR(E4=0,E4=\"\"),\"\",'General inputs and assumptions'!$C$15)","v":""},{"$f":"IF(OR(F4=0,F4=\"\"),\"\",'General inputs and assumptions'!$C$15)","v":""},{"$f":"IF(OR(G4=0,G4=\"\"),\"\",'General inputs and assumptions'!$C$15)","v":""},{"$f":"IF(OR(H4=0,H4=\"\"),\"\",'General inputs and assumptions'!$C$15)","v":""},{"$f":"IF(OR(I4=0,I4=\"\"),\"\",'General inputs and assumptions'!$C$15)","v":""},{"$f":"IF(OR(J4=0,J4=\"\"),\"\",'General inputs and assumptions'!$C$15)","v":""},{"$f":"IF(OR(K4=0,K4=\"\"),\"\",'General inputs and assumptions'!$C$15)","v":""},{"$f":"IF(OR(L4=0,L4=\"\"),\"\",'General inputs and assumptions'!$C$15)","v":""}]
[null,"User input value \n(over-rides default value)"]

{"sheet":"Drainage","index":6,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[6,0,7,0],[8,0,9,0],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1]]}
["Drainage"]
[]
["Input description",null,"Property 1 ","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10"]
["What is the approximate total length of drains on your property (in metres)?"]
["What total length of drains currently require refurbishment to function properly (in metres)?"]
["What is the current condition of drains (poor = significant upfront work to function effectively, average = some upfront work to function effectively, good = little unfront work to function effectively)?"]
["What is the approximate  cost per metre to refurbish drains? \n(default value  will apply unless user input value is provided)                  ","Default value",{"$f":"IF(OR(C$5=0,C$5=\"\"),\"\",IF(C6=\"\",\"select condition\",'General inputs and assumptions'!$B$18*VLOOKUP(C6,DRAINCOND,2,FALSE)))","v":""},{"$f":"IF(OR(D$5=0,D$5=\"\"),\"\",IF(D6=\"\",\"select condition\",'General inputs and assumptions'!$B$18*VLOOKUP(D6,DRAINCOND,2,FALSE)))","v":""},{"$f":"IF(OR(E$5=0,E$5=\"\"),\"\",IF(E6=\"\",\"select condition\",'General inputs and assumptions'!$B$18*VLOOKUP(E6,DRAINCOND,2,FALSE)))","v":""},{"$f":"IF(OR(F$5=0,F$5=\"\"),\"\",IF(F6=\"\",\"select condition\",'General inputs and assumptions'!$B$18*VLOOKUP(F6,DRAINCOND,2,FALSE)))","v":""},{"$f":"IF(OR(G$5=0,G$5=\"\"),\"\",IF(G6=\"\",\"select condition\",'General inputs and assumptions'!$B$18*VLOOKUP(G6,DRAINCOND,2,FALSE)))","v":""},{"$f":"IF(OR(H$5=0,H$5=\"\"),\"\",IF(H6=\"\",\"select condition\",'General inputs and assumptions'!$B$18*VLOOKUP(H6,DRAINCOND,2,FALSE)))","v":""},{"$f":"IF(OR(I$5=0,I$5=\"\"),\"\",IF(I6=\"\",\"select condition\",'General inputs and assumptions'!$B$18*VLOOKUP(I6,DRAINCOND,2,FALSE)))","v":""},{"$f":"IF(OR(J$5=0,J$5=\"\"),\"\",IF(J6=\"\",\"select condition\",'General inputs and assumptions'!$B$18*VLOOKUP(J6,DRAINCOND,2,FALSE)))","v":""},{"$f":"IF(OR(K$5=0,K$5=\"\"),\"\",IF(K6=\"\",\"select condition\",'General inputs and assumptions'!$B$18*VLOOKUP(K6,DRAINCOND,2,FALSE)))","v":""},{"$f":"IF(OR(L$5=0,L$5=\"\"),\"\",IF(L6=\"\",\"select condition\",'General inputs and assumptions'!$B$18*VLOOKUP(L6,DRAINCOND,2,FALSE)))","v":""}]
[null,"User input value \n(over-rides default value)"]
["What is the ongoing cost of maintaining drains (cost per metre per year)?\n(default value  will apply unless user input value is provided)    ","Default value",{"$f":"IF(OR(C$4=0,C$4=\"\"),\"\",'General inputs and assumptions'!$B$19)","v":""},{"$f":"IF(OR(D$4=0,D$4=\"\"),\"\",'General inputs and assumptions'!$B$19)","v":""},{"$f":"IF(OR(E$4=0,E$4=\"\"),\"\",'General inputs and assumptions'!$B$19)","v":""},{"$f":"IF(OR(F$4=0,F$4=\"\"),\"\",'General inputs and assumptions'!$B$19)","v":""},{"$f":"IF(OR(G$4=0,G$4=\"\"),\"\",'General inputs and assumptions'!$B$19)","v":""},{"$f":"IF(OR(H$4=0,H$4=\"\"),\"\",'General inputs and assumptions'!$B$19)","v":""},{"$f":"IF(OR(I$4=0,I$4=\"\"),\"\",'General inputs and assumptions'!$B$19)","v":""},{"$f":"IF(OR(J$4=0,J$4=\"\"),\"\",'General inputs and assumptions'!$B$19)","v":""},{"$f":"IF(OR(K$4=0,K$4=\"\"),\"\",'General inputs and assumptions'!$B$19)","v":""},{"$f":"IF(OR(L$4=0,L$4=\"\"),\"\",'General inputs and assumptions'!$B$19)","v":""}]
[null,"User input value \n(over-rides default value)"]
[]
[]
["Time taken to refurbish drains (all properties)",null,"years"]

{"sheet":"General inputs and assumptions","index":7,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,0,21,0]]}
["General inputs and assumptions"]
[]
[null,null,null,null,null,"Comment","Info sources"]
["Required rate of return on capital",0.1,"per annum",null,null,"Variable depending on operation. Should be reflective of enterprise owner's hurdle rate (not social discount rate)"]
["Evaluation period",25,"years"]
["Ramp up period to achieve full benefit of drain refurbushment",5,"years",null,null,"Reflects that herds will typically  be built up through breeding over a few years once carrying capacity has increased"]
[]
[]
["Default production values:"]
["Production type","Gross income per unit","Variable costs per unit","Gross margin per unit",null,"Comment","Info sources"]
["Beef ($ per breeding unit)",{"$f":"20*50","v":1000},{"$f":"20*20","v":400},{"$f":"B11-C11","v":600},null,"\nBased on a self-replacing herd. Assumes 1 breeding unit is on average approximately 20 dse, gross income is approx $50 per dse and variable costs are approx. $20 per dse.","DEDJTR Livestock Farm Monitor Project 2015-16"]
["Dairy  ($ per breeding unit)",2800,1024,{"$f":"B12-C12","v":1776},null,"Based on a self-replacing herd. Figures are based on dairy farm budgets undertaken by Primary Industries, Parks, Water and Environment (Tas) and adjusted based on Victorian Dairy Farm Monitor Project outpupts (2015/16, DEDJTR) ","DEDJTR Livestock Farm Monitor Project 2015-16, DPIPWE (Tas) Dairy GMs & profitability analysis"]
["Sheep  ($ per breeding unit)",120,60,60,null,"Based on a self-replacing flock. Assumes 1 breeding unit is on average approximately 2 dse, gross income is approx $60 per dse and variable costs are approx. $30 per dse.","DEDJTR Livestock Farm Monitor Project 2015-16"]
["Cropping income ($ per tonne)",220,"not used","not used",null,"Based on dryland wheat as a default","DPIPWE (Tas) High "]
["Cropping cost ($ per hectare)","not used",1250,"not used",null,"Based on dryland wheat as a default","DPIPWE (Tas) High "]
[]
["Drainage costs","$ per m",null,null,null,"Comment","Info sources"]
["Refurbishment of existing drains ($ per metre)",2.2000000000000002,null,null,null,"Includes earthworks, weed spraying, slashing/mowing","Moe Main Drain Investigation (2000), Submissions to ENRC Enquiry (for Woady Yaloak, Lough Calvert, Yatchaw, and Moe drainage schemes), Shepparton Irrigation Regional Catchment Strategy Review (2015). All costs inflated to present day using a 3% inflation rate."]
["Maintenance ($ per metre)",0.41,null,null,null,"Includes weed spraying, slashing/mowing","As above"]
["Refurbishment multiplier (condition)","Poor",4,null,null,"Approximation based on range of costs and condition in literature","As above"]
[null,"Average",1,null,null,"Approximation based on range of costs and condition in literature","As above"]
[null,"Good",0.5,null,null,"Approximation based on range of costs and condition in literature","As above"]

{"sheet":"Document control","index":8,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,2,10,12],[10,13,10,16],[4,2,4,12],[4,13,4,16],[8,2,8,12],[8,13,8,16],[9,2,9,12],[9,13,9,16],[5,2,5,12],[5,13,5,16],[6,2,6,12],[6,13,6,16],[7,2,7,12],[7,13,7,16]]}
["Rural Drainage AssessmentTool"]
[]
[]
["Version","Date","Description",null,null,null,null,null,null,null,null,null,null,"Changes made by"]
[1,"2017-06-16","Initial version of tool presented to DELWP for feedback.",null,null,null,null,null,null,null,null,null,null,"Lucas van Raalte (Jacobs)"]
[1.01,"2017-06-23","Definitions added. Chart added to 'Summary' sheet showing flows of costs and benefits. ",null,null,null,null,null,null,null,null,null,null,"Lucas van Raalte (Jacobs)"]
[1.02,"2017-07-04","Production values updated. Ramp up period of benefits added. Changes to 'Summary' sheet calcs.",null,null,null,null,null,null,null,null,null,null,"Lucas van Raalte (Jacobs)"]
[1.03,"2017-09-01","Extended to multiple properties and functionality for mixed farming. Drainage sheet added and condition function. Revised 'Summary' and 'Guidance'.",null,null,null,null,null,null,null,null,null,null,"Lucas van Raalte (Jacobs)"]
[1.04,"2017-10-01","Altered cropping input fields to allow variable costs to be expressed per area. ",null,null,null,null,null,null,null,null,null,null,"Lucas van Raalte (Jacobs)"]
[1.05,"2017-10-31","Updated costs of drainage",null,null,null,null,null,null,null,null,null,null,"Lucas van Raalte (Jacobs)"]
[1.06,"2017-11-01","Updated baseline definitions in enteprise input and summary sheets. Protected worksheets and hid calculation sheets.",null,null,null,null,null,null,null,null,null,null,"Lucas van Raalte (Jacobs)"]

{"sheet":"Calcs - hide","index":9,"n_rows":123,"n_cols":13,"rows_kept":123,"cut":false,"hidden":true,"merged":[]}
[]
["Production values:"]
[]
["Gross margins per unit:"]
[null,"Property 1","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10"]
["Beef (per breeding head)",{"$f":"IFERROR(IF(Beef!C$7>0,Beef!C$7,Beef!C$6)-IF(Beef!C$9>0,Beef!C$9,Beef!C$8),0)","v":0},{"$f":"IFERROR(IF(Beef!D$7>0,Beef!D$7,Beef!D$6)-IF(Beef!D$9>0,Beef!D$9,Beef!D$8),0)","v":0},{"$f":"IFERROR(IF(Beef!E$7>0,Beef!E$7,Beef!E$6)-IF(Beef!E$9>0,Beef!E$9,Beef!E$8),0)","v":0},{"$f":"IFERROR(IF(Beef!F$7>0,Beef!F$7,Beef!F$6)-IF(Beef!F$9>0,Beef!F$9,Beef!F$8),0)","v":0},{"$f":"IFERROR(IF(Beef!G$7>0,Beef!G$7,Beef!G$6)-IF(Beef!G$9>0,Beef!G$9,Beef!G$8),0)","v":0},{"$f":"IFERROR(IF(Beef!H$7>0,Beef!H$7,Beef!H$6)-IF(Beef!H$9>0,Beef!H$9,Beef!H$8),0)","v":0},{"$f":"IFERROR(IF(Beef!I$7>0,Beef!I$7,Beef!I$6)-IF(Beef!I$9>0,Beef!I$9,Beef!I$8),0)","v":0},{"$f":"IFERROR(IF(Beef!J$7>0,Beef!J$7,Beef!J$6)-IF(Beef!J$9>0,Beef!J$9,Beef!J$8),0)","v":0},{"$f":"IFERROR(IF(Beef!K$7>0,Beef!K$7,Beef!K$6)-IF(Beef!K$9>0,Beef!K$9,Beef!K$8),0)","v":0},{"$f":"IFERROR(IF(Beef!L$7>0,Beef!L$7,Beef!L$6)-IF(Beef!L$9>0,Beef!L$9,Beef!L$8),0)","v":0}]
["Dairy (per breeding head)",{"$f":"IFERROR(IF(Dairy!C$7>0,Dairy!C$7,Dairy!C$6)-IF(Dairy!C$9>0,Dairy!C$9,Dairy!C$8),0)","v":0},{"$f":"IFERROR(IF(Dairy!D$7>0,Dairy!D$7,Dairy!D$6)-IF(Dairy!D$9>0,Dairy!D$9,Dairy!D$8),0)","v":0},{"$f":"IFERROR(IF(Dairy!E$7>0,Dairy!E$7,Dairy!E$6)-IF(Dairy!E$9>0,Dairy!E$9,Dairy!E$8),0)","v":0},{"$f":"IFERROR(IF(Dairy!F$7>0,Dairy!F$7,Dairy!F$6)-IF(Dairy!F$9>0,Dairy!F$9,Dairy!F$8),0)","v":0},{"$f":"IFERROR(IF(Dairy!G$7>0,Dairy!G$7,Dairy!G$6)-IF(Dairy!G$9>0,Dairy!G$9,Dairy!G$8),0)","v":0},{"$f":"IFERROR(IF(Dairy!H$7>0,Dairy!H$7,Dairy!H$6)-IF(Dairy!H$9>0,Dairy!H$9,Dairy!H$8),0)","v":0},{"$f":"IFERROR(IF(Dairy!I$7>0,Dairy!I$7,Dairy!I$6)-IF(Dairy!I$9>0,Dairy!I$9,Dairy!I$8),0)","v":0},{"$f":"IFERROR(IF(Dairy!J$7>0,Dairy!J$7,Dairy!J$6)-IF(Dairy!J$9>0,Dairy!J$9,Dairy!J$8),0)","v":0},{"$f":"IFERROR(IF(Dairy!K$7>0,Dairy!K$7,Dairy!K$6)-IF(Dairy!K$9>0,Dairy!K$9,Dairy!K$8),0)","v":0},{"$f":"IFERROR(IF(Dairy!L$7>0,Dairy!L$7,Dairy!L$6)-IF(Dairy!L$9>0,Dairy!L$9,Dairy!L$8),0)","v":0}]
["Sheep  (per breeding head)",{"$f":"IFERROR(IF(Sheep!C$7>0,Sheep!C$7,Sheep!C$6)-IF(Sheep!C$9>0,Sheep!C$9,Sheep!C$8),0)","v":0},{"$f":"IFERROR(IF(Sheep!D$7>0,Sheep!D$7,Sheep!D$6)-IF(Sheep!D$9>0,Sheep!D$9,Sheep!D$8),0)","v":0},{"$f":"IFERROR(IF(Sheep!E$7>0,Sheep!E$7,Sheep!E$6)-IF(Sheep!E$9>0,Sheep!E$9,Sheep!E$8),0)","v":0},{"$f":"IFERROR(IF(Sheep!F$7>0,Sheep!F$7,Sheep!F$6)-IF(Sheep!F$9>0,Sheep!F$9,Sheep!F$8),0)","v":0},{"$f":"IFERROR(IF(Sheep!G$7>0,Sheep!G$7,Sheep!G$6)-IF(Sheep!G$9>0,Sheep!G$9,Sheep!G$8),0)","v":0},{"$f":"IFERROR(IF(Sheep!H$7>0,Sheep!H$7,Sheep!H$6)-IF(Sheep!H$9>0,Sheep!H$9,Sheep!H$8),0)","v":0},{"$f":"IFERROR(IF(Sheep!I$7>0,Sheep!I$7,Sheep!I$6)-IF(Sheep!I$9>0,Sheep!I$9,Sheep!I$8),0)","v":0},{"$f":"IFERROR(IF(Sheep!J$7>0,Sheep!J$7,Sheep!J$6)-IF(Sheep!J$9>0,Sheep!J$9,Sheep!J$8),0)","v":0},{"$f":"IFERROR(IF(Sheep!K$7>0,Sheep!K$7,Sheep!K$6)-IF(Sheep!K$9>0,Sheep!K$9,Sheep!K$8),0)","v":0},{"$f":"IFERROR(IF(Sheep!L$7>0,Sheep!L$7,Sheep!L$6)-IF(Sheep!L$9>0,Sheep!L$9,Sheep!L$8),0)","v":0}]
["Cropping (per hectare with current drainage)",{"$f":"IFERROR(Cropping!C5*IF(Cropping!C9>0,Cropping!C9,Cropping!C8)-IF(Cropping!C11>0,Cropping!C11,Cropping!C10),0)","v":0},{"$f":"IFERROR(Cropping!D5*IF(Cropping!D9>0,Cropping!D9,Cropping!D8)-IF(Cropping!D11>0,Cropping!D11,Cropping!D10),0)","v":0},{"$f":"IFERROR(Cropping!E5*IF(Cropping!E9>0,Cropping!E9,Cropping!E8)-IF(Cropping!E11>0,Cropping!E11,Cropping!E10),0)","v":0},{"$f":"IFERROR(Cropping!F5*IF(Cropping!F9>0,Cropping!F9,Cropping!F8)-IF(Cropping!F11>0,Cropping!F11,Cropping!F10),0)","v":0},{"$f":"IFERROR(Cropping!G5*IF(Cropping!G9>0,Cropping!G9,Cropping!G8)-IF(Cropping!G11>0,Cropping!G11,Cropping!G10),0)","v":0},{"$f":"IFERROR(Cropping!H5*IF(Cropping!H9>0,Cropping!H9,Cropping!H8)-IF(Cropping!H11>0,Cropping!H11,Cropping!H10),0)","v":0},{"$f":"IFERROR(Cropping!I5*IF(Cropping!I9>0,Cropping!I9,Cropping!I8)-IF(Cropping!I11>0,Cropping!I11,Cropping!I10),0)","v":0},{"$f":"IFERROR(Cropping!J5*IF(Cropping!J9>0,Cropping!J9,Cropping!J8)-IF(Cropping!J11>0,Cropping!J11,Cropping!J10),0)","v":0},{"$f":"IFERROR(Cropping!K5*IF(Cropping!K9>0,Cropping!K9,Cropping!K8)-IF(Cropping!K11>0,Cropping!K11,Cropping!K10),0)","v":0},{"$f":"IFERROR(Cropping!L5*IF(Cropping!L9>0,Cropping!L9,Cropping!L8)-IF(Cropping!L11>0,Cropping!L11,Cropping!L10),0)","v":0}]
["Cropping (per hectare with improved drainage)",{"$f":"IFERROR(Cropping!C7*IF(Cropping!C9>0,Cropping!C9,Cropping!C8)-IF(Cropping!C11>0,Cropping!C11,Cropping!C10),0)","v":0},{"$f":"IFERROR(Cropping!D7*IF(Cropping!D9>0,Cropping!D9,Cropping!D8)-IF(Cropping!D11>0,Cropping!D11,Cropping!D10),0)","v":0},{"$f":"IFERROR(Cropping!E7*IF(Cropping!E9>0,Cropping!E9,Cropping!E8)-IF(Cropping!E11>0,Cropping!E11,Cropping!E10),0)","v":0},{"$f":"IFERROR(Cropping!F7*IF(Cropping!F9>0,Cropping!F9,Cropping!F8)-IF(Cropping!F11>0,Cropping!F11,Cropping!F10),0)","v":0},{"$f":"IFERROR(Cropping!G7*IF(Cropping!G9>0,Cropping!G9,Cropping!G8)-IF(Cropping!G11>0,Cropping!G11,Cropping!G10),0)","v":0},{"$f":"IFERROR(Cropping!H7*IF(Cropping!H9>0,Cropping!H9,Cropping!H8)-IF(Cropping!H11>0,Cropping!H11,Cropping!H10),0)","v":0},{"$f":"IFERROR(Cropping!I7*IF(Cropping!I9>0,Cropping!I9,Cropping!I8)-IF(Cropping!I11>0,Cropping!I11,Cropping!I10),0)","v":0},{"$f":"IFERROR(Cropping!J7*IF(Cropping!J9>0,Cropping!J9,Cropping!J8)-IF(Cropping!J11>0,Cropping!J11,Cropping!J10),0)","v":0},{"$f":"IFERROR(Cropping!K7*IF(Cropping!K9>0,Cropping!K9,Cropping!K8)-IF(Cropping!K11>0,Cropping!K11,Cropping!K10),0)","v":0},{"$f":"IFERROR(Cropping!L7*IF(Cropping!L9>0,Cropping!L9,Cropping!L8)-IF(Cropping!L11>0,Cropping!L11,Cropping!L10),0)","v":0}]
[]
[]
["Increase in gross margin per property from improved drainage:"]
[null,"Property 1","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10","ALL PROPERTIES"]
["Beef",{"$f":"(Beef!C$5-Beef!C$4)*B6","v":0},{"$f":"(Beef!D$5-Beef!D$4)*C6","v":0},{"$f":"(Beef!E$5-Beef!E$4)*D6","v":0},{"$f":"(Beef!F$5-Beef!F$4)*E6","v":0},{"$f":"(Beef!G$5-Beef!G$4)*F6","v":0},{"$f":"(Beef!H$5-Beef!H$4)*G6","v":0},{"$f":"(Beef!I$5-Beef!I$4)*H6","v":0},{"$f":"(Beef!J$5-Beef!J$4)*I6","v":0},{"$f":"(Beef!K$5-Beef!K$4)*J6","v":0},{"$f":"(Beef!L$5-Beef!L$4)*K6","v":0},{"$f":"SUM(B15:K15)","v":0}]
["Dairy",{"$f":"(Dairy!C5-Dairy!C4)*B7","v":0},{"$f":"(Dairy!D5-Dairy!D4)*C7","v":0},{"$f":"(Dairy!E5-Dairy!E4)*D7","v":0},{"$f":"(Dairy!F5-Dairy!F4)*E7","v":0},{"$f":"(Dairy!G5-Dairy!G4)*F7","v":0},{"$f":"(Dairy!H5-Dairy!H4)*G7","v":0},{"$f":"(Dairy!I5-Dairy!I4)*H7","v":0},{"$f":"(Dairy!J5-Dairy!J4)*I7","v":0},{"$f":"(Dairy!K5-Dairy!K4)*J7","v":0},{"$f":"(Dairy!L5-Dairy!L4)*K7","v":0},{"$f":"SUM(B16:K16)","v":0}]
["Sheep",{"$f":"(Sheep!C5-Sheep!C4)*B8","v":0},{"$f":"(Sheep!D5-Sheep!D4)*C8","v":0},{"$f":"(Sheep!E5-Sheep!E4)*D8","v":0},{"$f":"(Sheep!F5-Sheep!F4)*E8","v":0},{"$f":"(Sheep!G5-Sheep!G4)*F8","v":0},{"$f":"(Sheep!H5-Sheep!H4)*G8","v":0},{"$f":"(Sheep!I5-Sheep!I4)*H8","v":0},{"$f":"(Sheep!J5-Sheep!J4)*I8","v":0},{"$f":"(Sheep!K5-Sheep!K4)*J8","v":0},{"$f":"(Sheep!L5-Sheep!L4)*K8","v":0},0]
["Cropping",{"$f":"B10*Cropping!C6 - B9*Cropping!C4","v":0},{"$f":"C10*Cropping!D6 - C9*Cropping!D4","v":0},{"$f":"D10*Cropping!E6 - D9*Cropping!E4","v":0},{"$f":"E10*Cropping!F6 - E9*Cropping!F4","v":0},{"$f":"F10*Cropping!G6 - F9*Cropping!G4","v":0},{"$f":"G10*Cropping!H6 - G9*Cropping!H4","v":0},{"$f":"H10*Cropping!I6 - H9*Cropping!I4","v":0},{"$f":"I10*Cropping!J6 - I9*Cropping!J4","v":0},{"$f":"J10*Cropping!K6 - J9*Cropping!K4","v":0},{"$f":"K10*Cropping!L6 - K9*Cropping!L4","v":0},0]
["TOTAL",{"$f":"SUM(B15:B18)","v":0},{"$f":"SUM(C15:C18)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Production ramp up period (years)",{"$f":"'General inputs and assumptions'!B6","v":5}]
[]
["Year","Property 1","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10","ALL PROPERTIES","Cumulative"]
[0,{"$f":"IF(($A24/$B$21)<1,($A24/$B$21),1)*B$19","v":0},{"$f":"IF(($A24/$B$21)<1,($A24/$B$21),1)*C$19","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(B24:K24)","v":0},{"$f":"L24","v":0}]
[1,{"$f":"IF(($A25/$B$21)<1,($A25/$B$21),1)*B$19","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(B25:K25)","v":0},{"$f":"L25+M24","v":0}]
[2,0,0,0,0,0,0,0,0,0,0,0,{"$f":"L26+M25","v":0}]
[3,0,0,0,0,0,0,0,0,0,0,0,0]
[4,0,0,0,0,0,0,0,0,0,0,0,0]
[5,0,0,0,0,0,0,0,0,0,0,0,0]
[6,0,0,0,0,0,0,0,0,0,0,0,0]
[7,0,0,0,0,0,0,0,0,0,0,0,0]
[8,0,0,0,0,0,0,0,0,0,0,0,0]
[9,0,0,0,0,0,0,0,0,0,0,0,0]
[10,0,0,0,0,0,0,0,0,0,0,0,0]
[11,0,0,0,0,0,0,0,0,0,0,0,0]
[12,0,0,0,0,0,0,0,0,0,0,0,0]
[13,0,0,0,0,0,0,0,0,0,0,0,0]
[14,0,0,0,0,0,0,0,0,0,0,0,0]
[15,0,0,0,0,0,0,0,0,0,0,0,0]
[16,0,0,0,0,0,0,0,0,0,0,0,0]
[17,0,0,0,0,0,0,0,0,0,0,0,0]
[18,0,0,0,0,0,0,0,0,0,0,0,0]
[19,0,0,0,0,0,0,0,0,0,0,0,0]
[20,0,0,0,0,0,0,0,0,0,0,0,0]
[21,0,0,0,0,0,0,0,0,0,0,0,0]
[22,0,0,0,0,0,0,0,0,0,0,0,0]
[23,0,0,0,0,0,0,0,0,0,0,0,0]
[24,0,0,0,0,0,0,0,0,0,0,0,0]
[25,0,0,0,0,0,0,0,0,0,0,0,0]
["Present Value",{"$f":"NPV(DR,B24:B49)","v":0},0,0,0,0,0,0,0,0,0,0]
["Annualised Value",{"$f":"-PMT(DR,EP,'Calcs - hide'!B50,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!C50,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!D50,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!E50,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!F50,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!G50,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!H50,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!I50,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!J50,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!K50,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!L50,0,1)","v":0}]
[]
["DRAINAGE:"]
[]
[null,"Property 1","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10"]
["Refurbishment costs per metre",{"$f":"IF(Drainage!C8=0,Drainage!C7,Drainage!C8)","v":""},{"$f":"IF(Drainage!D8=0,Drainage!D7,Drainage!D8)","v":""},{"$f":"IF(Drainage!E8=0,Drainage!E7,Drainage!E8)","v":""},{"$f":"IF(Drainage!F8=0,Drainage!F7,Drainage!F8)","v":""},{"$f":"IF(Drainage!G8=0,Drainage!G7,Drainage!G8)","v":""},{"$f":"IF(Drainage!H8=0,Drainage!H7,Drainage!H8)","v":""},{"$f":"IF(Drainage!I8=0,Drainage!I7,Drainage!I8)","v":""},{"$f":"IF(Drainage!J8=0,Drainage!J7,Drainage!J8)","v":""},{"$f":"IF(Drainage!K8=0,Drainage!K7,Drainage!K8)","v":""},{"$f":"IF(Drainage!L8=0,Drainage!L7,Drainage!L8)","v":""}]
["Total refurbishment cost",{"$f":"IF(Drainage!C5=\"\",0,B56*Drainage!C5)","v":0},{"$f":"IF(Drainage!D5=\"\",0,C56*Drainage!D5)","v":0},{"$f":"IF(Drainage!E5=\"\",0,D56*Drainage!E5)","v":0},{"$f":"IF(Drainage!F5=\"\",0,E56*Drainage!F5)","v":0},{"$f":"IF(Drainage!G5=\"\",0,F56*Drainage!G5)","v":0},{"$f":"IF(Drainage!H5=\"\",0,G56*Drainage!H5)","v":0},{"$f":"IF(Drainage!I5=\"\",0,H56*Drainage!I5)","v":0},{"$f":"IF(Drainage!J5=\"\",0,I56*Drainage!J5)","v":0},{"$f":"IF(Drainage!K5=\"\",0,J56*Drainage!K5)","v":0},{"$f":"IF(Drainage!L5=\"\",0,K56*Drainage!L5)","v":0}]
["Maintenance costs per metre",{"$f":"IF(Drainage!C10=0,Drainage!C9,Drainage!C10)","v":""},{"$f":"IF(Drainage!D10=0,Drainage!D9,Drainage!D10)","v":""},{"$f":"IF(Drainage!E10=0,Drainage!E9,Drainage!E10)","v":""},{"$f":"IF(Drainage!F10=0,Drainage!F9,Drainage!F10)","v":""},{"$f":"IF(Drainage!G10=0,Drainage!G9,Drainage!G10)","v":""},{"$f":"IF(Drainage!H10=0,Drainage!H9,Drainage!H10)","v":""},{"$f":"IF(Drainage!I10=0,Drainage!I9,Drainage!I10)","v":""},{"$f":"IF(Drainage!J10=0,Drainage!J9,Drainage!J10)","v":""},{"$f":"IF(Drainage!K10=0,Drainage!K9,Drainage!K10)","v":""},{"$f":"IF(Drainage!L10=0,Drainage!L9,Drainage!L10)","v":""}]
["Total maintenance cost",{"$f":"IF(Drainage!C4=\"\",0,B58*Drainage!C4)","v":0},{"$f":"IF(Drainage!D4=\"\",0,C58*Drainage!D4)","v":0},{"$f":"IF(Drainage!E4=\"\",0,D58*Drainage!E4)","v":0},{"$f":"IF(Drainage!F4=\"\",0,E58*Drainage!F4)","v":0},{"$f":"IF(Drainage!G4=\"\",0,F58*Drainage!G4)","v":0},{"$f":"IF(Drainage!H4=\"\",0,G58*Drainage!H4)","v":0},{"$f":"IF(Drainage!I4=\"\",0,H58*Drainage!I4)","v":0},{"$f":"IF(Drainage!J4=\"\",0,I58*Drainage!J4)","v":0},{"$f":"IF(Drainage!K4=\"\",0,J58*Drainage!K4)","v":0},{"$f":"IF(Drainage!L4=\"\",0,K58*Drainage!L4)","v":0}]
[]
["Years to refurbish",{"$f":"Drainage!$B$13","v":0}]
[]
["Year","Property 1","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10","ALL PROPERTIES","Cumulative"]
[0,{"$f":"IF(($A64<$B$61),B$57/$B$61,0)+IF($A64=0,0,B$59)","v":0},{"$f":"IF(($A64<$B$61),C$57/$B$61,0)+IF($A64=0,0,C$59)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(B64:K64)","v":0},{"$f":"L64","v":0}]
[1,{"$f":"IF(($A65<$B$61),B$57/$B$61,0)+IF($A65=0,0,B$59)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(B65:K65)","v":0},{"$f":"L65+M64","v":0}]
[2,0,0,0,0,0,0,0,0,0,0,0,{"$f":"L66+M65","v":0}]
[3,0,0,0,0,0,0,0,0,0,0,0,0]
[4,0,0,0,0,0,0,0,0,0,0,0,0]
[5,0,0,0,0,0,0,0,0,0,0,0,0]
[6,0,0,0,0,0,0,0,0,0,0,0,0]
[7,0,0,0,0,0,0,0,0,0,0,0,0]
[8,0,0,0,0,0,0,0,0,0,0,0,0]
[9,0,0,0,0,0,0,0,0,0,0,0,0]
[10,0,0,0,0,0,0,0,0,0,0,0,0]
[11,0,0,0,0,0,0,0,0,0,0,0,0]
[12,0,0,0,0,0,0,0,0,0,0,0,0]
[13,0,0,0,0,0,0,0,0,0,0,0,0]
[14,0,0,0,0,0,0,0,0,0,0,0,0]
[15,0,0,0,0,0,0,0,0,0,0,0,0]
[16,0,0,0,0,0,0,0,0,0,0,0,0]
[17,0,0,0,0,0,0,0,0,0,0,0,0]
[18,0,0,0,0,0,0,0,0,0,0,0,0]
[19,0,0,0,0,0,0,0,0,0,0,0,0]
[20,0,0,0,0,0,0,0,0,0,0,0,0]
[21,0,0,0,0,0,0,0,0,0,0,0,0]
[22,0,0,0,0,0,0,0,0,0,0,0,0]
[23,0,0,0,0,0,0,0,0,0,0,0,0]
[24,0,0,0,0,0,0,0,0,0,0,0,0]
[25,{"$f":"IF(($A89<$B$61),B$57/$B$61,0)+IF($A89=0,0,B$59)","v":0},{"$f":"IF(($A89<$B$61),C$57/$B$61,0)+IF($A89=0,0,C$59)","v":0},0,0,0,0,0,0,0,0,0,0]
["Present Value",{"$f":"NPV(DR,B64:B89)","v":0},0,0,0,0,0,0,0,0,0,0]
["Annualised Value",{"$f":"-PMT(DR,EP,'Calcs - hide'!B90,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!C90,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!D90,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!E90,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!F90,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!G90,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!H90,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!I90,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!J90,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!K90,0,1)","v":0},{"$f":"-PMT(DR,EP,'Calcs - hide'!L90,0,1)","v":0}]
[]
["PAY BACK PERIOD"]
[]
["Cumulative cash flows"]
["Year","Property 1","Property 2","Property 3","Property 4","Property 5","Property 6","Property 7","Property 8","Property 9","Property 10","ALL PROPERTIES"]
[0,{"$f":"B24-B64","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(B97:K97)","v":0}]
[1,{"$f":"B25-B65+B97","v":0},{"$f":"C25-C65+C97","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(B98:K98)","v":0}]
[2,{"$f":"B26-B66+B98","v":0},0,0,0,0,0,0,0,0,0,0]
[3,0,0,0,0,0,0,0,0,0,0,0]
[4,0,0,0,0,0,0,0,0,0,0,0]
[5,0,0,0,0,0,0,0,0,0,0,0]
[6,0,0,0,0,0,0,0,0,0,0,0]
[7,0,0,0,0,0,0,0,0,0,0,0]
[8,0,0,0,0,0,0,0,0,0,0,0]
[9,0,0,0,0,0,0,0,0,0,0,0]
[10,0,0,0,0,0,0,0,0,0,0,0]
[11,0,0,0,0,0,0,0,0,0,0,0]
[12,0,0,0,0,0,0,0,0,0,0,0]
[13,0,0,0,0,0,0,0,0,0,0,0]
[14,0,0,0,0,0,0,0,0,0,0,0]
[15,0,0,0,0,0,0,0,0,0,0,0]
[16,0,0,0,0,0,0,0,0,0,0,0]
[17,0,{"$f":"C41-C81+C113","v":0},{"$f":"D41-D81+D113","v":0},{"$f":"E41-E81+E113","v":0},{"$f":"F41-F81+F113","v":0},{"$f":"G41-G81+G113","v":0},{"$f":"H41-H81+H113","v":0},{"$f":"I41-I81+I113","v":0},{"$f":"J41-J81+J113","v":0},{"$f":"K41-K81+K113","v":0},0]
[18,0,0,0,0,0,0,0,0,0,0,0]
[19,0,0,0,0,0,0,0,0,0,0,0]
[20,0,0,0,0,0,0,0,0,0,0,0]
[21,0,0,0,0,0,0,0,0,0,0,0]
[22,0,0,0,0,0,0,0,0,0,0,0]
[23,0,0,0,0,0,0,0,0,0,0,0]
[24,0,0,0,0,0,0,0,0,0,0,0]
[25,0,0,0,0,0,0,0,0,0,0,0]
["Payback period (years)",{"$f":"IF(B122<0,\">25\",COUNTIF(B97:B122,\"<0\"))","v":0},{"$f":"IF(C122<0,\">25\",COUNTIF(C97:C122,\"<0\"))","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Lookups - hide","index":10,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Production types:",null,"Beef"]
[null,null,"Dairy"]
[null,null,"Sheep"]
[null,null,"Cropping"]
[]
["Cropping types:",null,"Canola "]
[null,null,"Barley"]
[null,null,"Triticale"]
[null,null,"Hay"]
[]
["Drainage condition",null,"poor"]
[null,null,"average"]
[null,null,"good"]