{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Introduction","T&C","Definitions","Instructions for Use","1. Treatments & Products","2. Land & Property","3. Control Methods","Treatment Regimes","Reference Data","Settings","Primary Treatment","5 year Cost Benefit Graph","5 year cumulative","5 year per hectare benefit"],"not_rendered":{"charts":4,"images":8,"macros":1,"external_links":0,"defined_names":91,"comments":5,"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":"Introduction","index":0,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,11,54,12],[25,1,29,11],[49,1,52,11],[44,1,46,11],[39,1,41,11],[33,1,36,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Version:",{"$f":"Settings!App_Version","v":"V1.0f2c"}]
[]
[null,{"$f":"Settings!App_Name","v":"Blackberry Weed Management - Agricultural Productivity Model"}]
[]
[null,"A 'cost  benefit' analysis tool for a livestock grazing operation, specific to chemical control costs and projected productivity benefit"]
[]
[null,"This project is funded through the Established Pest Animals and Weeds Initiative, part of the Australian Government’s Agricultural Competitiveness White Paper, the government’s plan for stronger farmers and a stronger economy."]
[]
[]
[]
[]
[]
[null,"Preface"]
[]
[null,"\"Land, in economics, is the resource that encompasses the natural resources used in production. In classical economics, the three factors of production are land, labour, and capital. Land was considered to be the “original and inexhaustible gift of nature.” In modern economics, it is broadly defined to include all that nature provides, including minerals, forest products, and water and land resources.\"                 Encyclopaedia Britannica "]
[]
[]
[]
[null,"Introduction"]
[]
[null,"Despite the definition set out in classical economic theory, it is now universally accepted that land resources are not inexhaustible. Land is the principal asset base and means of rural production. Land infested with blackberry (Rubus fruticosus agg.) has an impaired level of productive agricultural capacity, ranging from minor to complete loss in severe cases.\n\nThe economic costs in relation to lost forms of production in addition to the resources devoted to control and maintenance measures of blackberry infestation are significant. There are other major costs in terms of environmental damage and degradation.\n\nFurther to this economic and environmental opportunity cost there is an ongoing and increasingly adverse impact upon the value of rural land that is severely affected by blackberry infestation. The combined impact of these main factors is estimated to result in the loss of a significant amount of economic wealth and environmental capital. "]
[]
[]
[null,"Purpose of the Model"]
[]
[null,"This model aims to highlight the economic impact of blackberry affected agricultural land. The adverse impact that weed infestation has on livestock carrying capacities can also lead to a detrimental impact upon the underlying rural property value."]
[]
[]
[null,"The Cost Benefit Analysis Model"]
[]
[null,"A model has been developed for the use of land managers and other land management agencies. \nThe model includes reference to a range of key variables and is intended to be a simple to use, decision making support tool related to the economics of blackberry management. It will assist land managers to quantify and identify the economic cost of blackberry infestation in comparison to the potential economic uplift that is acheived through improved productive capacity over a specified time frame.\n"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"NEXT >>"]

{"sheet":"T&C","index":1,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,2,34,3],[34,0,34,1],[29,1,29,2],[0,0,0,1],[10,1,10,2],[17,1,17,2],[21,1,21,2],[25,1,25,2],[8,1,8,2],[28,1,28,2]]}
["<< PREVIOUS",null,"Version:",{"$f":"Settings!App_Version","v":"V1.0f2c"}]
[]
[null,{"$f":"Settings!App_Name","v":"Blackberry Weed Management - Agricultural Productivity Model"}]
[]
[null,"A 'cost  benefit' analysis tool for a livestock grazing operation, specific to chemical control costs and projected productivity benefit"]
[]
[]
[null,"Terms and Conditions of Model Use"]
[]
[null,"Explanation "]
[]
[null,1,"The following terms and conditions have been prepared by Preston Rowe Paterson Albury Wodonga Pty Ltd, in their capacity as concept originators and developers of the Blackberry Weed Management – Agricultural Productivity Model (“the Model”)."]
[null,2,"Users agree that these terms and conditions apply to the use and application of this model."]
[null,3,"The model is for indicative budgeting and scenario forecasting purposes only and is not intended to replace a customised quote for blackberry weed spraying services and formal, property specific agronomic and productivity uplift advice."]
[null,4,"The Blackberry Weed Management – Agricultural Productivity Model is provided by Preston Rowe Paterson Albury Wodonga in conjunction with Agriculture Victoria, Victorian Blackberry Taskforce and Australian Government Department of Agriculture and Water Resources, subject to these Terms and Conditions."]
[]
[null,"Definitions "]
[]
[null,5,"The following definitions apply to these terminology as set out in Model:-\n- ‘Parties’ means You and/or Us as the context dictates.\n- ‘Model’ means the Blackberry Weed Agricultural Productivity Model\n- ‘We’, ‘Us’, ‘Our (s)’ means Preston Rowe Paterson Albury Wodonga , our employees, contractors, servants and agents;\n- ‘You’, ‘Your’ means the Parties using the Model"]
[]
[null,"Your Obligations "]
[]
[null,6,"You agree that:\n(a) You will not use any advice We provide for any purpose other than as stated in the Introduction page to the Model;\n(b) You will not pursue any claim against Us for any loss You suffer because You have used the output of the Model for any other purpose;\n(c) You will indemnify Us in relation to any loss suffered by a third party that relies on the output of the Model without first receiving Our written consent to do so.  "]
[]
[null,"Intellectual Property "]
[]
[null,7,"All Our intellectual property contained within the Model, remains Our property.  We only grant you licence to use Our intellectual property to carry out the purpose for which the advice was provided."]
[]
[null,"Property or Valuation Circumstance Specific Qualifications, Assumptions and Conditions Precedent within our reports "]
[]
[null,8,"You agree to read these qualifications, assumptions and conditions precedent carefully, and understand that if the assumptions that we have made or relied on are circumstances that do not prevail or eventuate, or are found later to be inaccurate, Our opinion as to various inputs within the Model may be materially different.  You agree to solely bear the risk in relation to any loss you might suffer, should this occur."]
[null,9,"The qualifications, assumptions, and conditions precedent that We make will usually depend on the circumstances of the property scenario being considered and are made in relation to matters that The model is not intended to verify the information input into the model for indicative Cost Benefit Analysis purposes. "]
[]
[]
["<< PREVIOUS",null,"NEXT >>"]

{"sheet":"Definitions","index":2,"n_rows":95,"n_cols":6,"rows_kept":95,"cut":false,"hidden":false,"merged":[[31,4,31,6],[0,0,0,1],[94,0,94,1],[94,2,94,3],[7,0,7,2],[11,1,11,2],[37,1,37,2],[51,1,51,2],[62,1,62,2],[74,1,74,2]]}
["<< PREVIOUS",null,"Version:",{"$f":"Settings!App_Version","v":"V1.0f2c"}]
[]
[null,{"$f":"Settings!App_Name","v":"Blackberry Weed Management - Agricultural Productivity Model"}]
[]
[null,"A 'cost  benefit' analysis tool for a livestock grazing operation, specific to chemical control costs and projected productivity benefit"]
[]
[]
["In order to get the most out of the tool, users will benefit from having an understanding of the definitions, key inputs and the underlying assumptions that are built into the model."]
["Definitions "]
[]
[1,"Land Class: "]
[null,"In this model, land classess are based on the framework as set out in “The land and soil capability assessment scheme: Second approximation” as published by the NSW Government Office of Environment and Heritage."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source:","“The land and soil capability assessment scheme: Second approximation”\nNSW Government Office of Environment and Heritage, October 2012."]
[]
["1a",null,"Class 1 – Premium Quality Land"]
[null,null,"Refers to a combination of LSC Classes 1 and 2 – representing extremely high and very high capability rural land;"]
[]
["1b",null,"Class 2 – Highly Productive Land",null,null,"SCROLL"]
[null,null,"Refers to LSC Class 3 – High capability rural land with moderate limitations."]
[]
["1c",null,"Class 3 – Moderately Productive",null,null,"UP TO"]
[null,null,"Refers to a combination of LSC Classes 4 and 5 – moderate capability and moderate to low capability rural land.",null,null,"SEE"]
[]
["1d",null,"Class 4 – Low Productive Capacity",null,"CLASS DESCRIPTIONS"]
[null,null,"Refers to a combination of LSC Classes 6, 7 and 8 – low, very low and extremely low capability rural land."]
[]
[]
[]
[2,"Infestation Intensity/Density"]
[null,"This variable refers to the density, coverage and amount of blackberry plants within a defined area of the affected property. Visual assessment is the simplest way to determine weed density. Use the images to help with your assesment:"]
[]
["2a",null,"Minor (1-15% groundcover)"]
[null,null,"\n5%\n\n\n\n10%"]
[]
["2b",null,"Moderate (16-35% groundcover)"]
[null,null,"\n20%\n\n\n\n30%"]
[]
["2c",null,"Heavy (35%+ groundcover)"]
[null,null,"\n40%\n\n\n\n50%"]
[]
[]
[]
[3,"Access"]
[null,"This variable refers to the standard of access that is available to the blackberry infested land:"]
[]
["3a",null,"Good – is defined as land with access tracks that are clearly defined and well formed and/or land with minimal limitations to cross country vehicular access with a fully laden purpose designed control vehicle (spray rig);"]
[]
["3b",null,"Fair - is defined as land with access tracks that are not defined and partially or roughly formed and/or land with a moderate level of limitation to cross country vehicular access with a fully laden purpose designed control vehicle (spray rig);"]
[]
["3c",null,"Difficult - is defined as land with minimal or no access tracks and/or land with major limitations to cross country vehicular access with a fully laden purpose designed control vehicle (spray rig);"]
[]
[]
[]
[4,"Terrain"]
[null,"This variable refers to the nature of the topography, slope and gradient of the blackberry infested land. \n\nUsers should apply their own interpretation of terrain for use in the model, in the context of the particular property scenario. The terminology for the description of terrain adopted in this model is:"]
[]
["4a",null,"Flat  - say, 0% to 2% grade"]
[]
["4b",null,"Sloping - say 2% to 10% grade"]
[]
["4c",null,"Steep - say greater than 10% grade"]
[]
[]
[]
[5,"Treatment Regime"]
[]
[null,"This variable refers to the intensity of the treatment regime to be applied for blackberry eradication. \n\nThe regime will be determined by the goals of the property owner and available resources. Currently available regimes in this model are:"]
[]
["5a",null,"Aggressive - refers to a major control program over the whole property, including all land classes and terrain classes, in the initial year, with a highly vigilant follow up strategy over the property in subsequent years"]
[]
["5b",null,"Active  - refers to a control program over part of the property, including the more productive land classes and flat/sloping terrain in the initial year, with an active progressive follow up strategy in subsequent years over the initially treated land and a secondary focus on the less productive land and steeper terrain"]
[]
["5c",null,"Passive - refers to a minor control program over part of the property, focussed on the more productive land classes and flat terrain, in the initial year. The balance of the land, particularly the steeper and less productive land is not treated as a high priority until full control is acheived on the initially treated land"]
[]
[]
[]
["Key Assumptions"]
[]
[1,"All dollar amounts included in the model are GST exclusive"]
[2,"All dollar amounts and projected cashflows are nominal and not adjusted / indexed to CPI"]
[3,"The unit rates for labour and plant hire reflect trained professional contractors and modern, high quality, efficient equipment"]
[4,"Chemical product application rates are based from published label recommendations"]
[5,"Where small areas are identified for aerial control that a practical and efficient scheduling solution can be reached"]
[6,"Assumes control is undertaken in accordance with best practice under appropriate seasonal and weather conditions"]
[]
[]
["<< PREVIOUS",null,"NEXT >>"]

{"sheet":"Instructions for Use","index":3,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[22,12,22,14],[24,1,24,2],[22,1,22,2],[22,3,22,4],[26,1,26,10],[24,4,24,10],[0,0,0,1],[35,0,35,1],[27,3,27,7],[28,3,28,7],[29,3,29,7],[18,1,18,2],[18,3,18,7],[30,3,30,7],[31,3,31,7],[20,4,20,10]]}
["<< PREVIOUS",null,null,null,null,null,null,null,null,null,"Version:",{"$f":"Settings!App_Version","v":"V1.0f2c"}]
[]
[null,{"$f":"Settings!App_Name","v":"Blackberry Weed Management - Agricultural Productivity Model"}]
[]
[null,"A 'cost  benefit' analysis tool for a livestock grazing operation, specific to chemical control costs and projected productivity benefit"]
[]
[null,"Instructions for Use",null,null,null,null,null,null,null,null,null,null,"To get started and activate the model:"]
[]
[null,"Some key points for users to note:",null,null,null,null,null,null,null,null,null,null,"1.  A pale yellow ribbon containing a security warning/s may appear at the top of the document when excel is opened."]
[null,null,null,null,null,null,null,null,null,null,null,null,"2.  You will need to click \"Enable Macros\" on the yellow ribbon."]
[null,"Worksheet Tab Colours:",null,"Introduction, Definitions and User Instructions",null,null,null,null,null,null,null,null,"3.  You will need to click on \"Enable Content\" and \"Enable Editing\" on the yellow ribbon."]
[null,null,null,"User information and inputs required",null,null,null,null,null,null,null,null,"4. Read the \"Introduction\" page and agree to Terms of Use."]
[null,null,null,"Model Outputs",null,null,null,null,null,null,null,null,"5. Read the \"Terms and Conditions\" page and agree to Terms of Use."]
[null,null,null,null,null,null,null,null,null,null,null,null,"6. Read the \"Definitions\" page and agree to Terms of Use."]
[null,"Pale Yellow Cells:",null,"User Data Entry Cells ",null,null,null,null,null,null,null,null,"7. Read the steps set out on the page \"Instructions for Use\" and agree to Terms of Use."]
[]
[null,"Orange Cells:",null,"Drop Down Box selection cells"]
[]
[null,"Light Grey Cells :",null,"Provides advisory notes to assist model users",null,null,null,null,null,null,null,null,"Click \"I Agree…\" to enable the model (the model will then show all its remaining sheets)"]
[]
[null,"Explanation Note:",null,null,"Hover over cells with a red marker in top RH corner"]
[]
[null,"Advisory Notes:",null,"Red bold italic text"]
[]
[null,"Follow the arrows:",null,">>>>","(input data and follow arrow direction to the next data table where indicated)"]
[]
[null,"Populate the information in the yellow tabs from left to right, populating information from top to bottom:"]
[null,null,"First:","\"Treatments & Products\""]
[null,null,"Second:","\"Land & Property\""]
[null,null,"Third:","\"Control Methods\""]
[null,null,"Fourth","Review the assumptions of your selected regime in "]
[null,null,null,"the Treatment  Regime worksheet"]
[]
[null,"All other cells in the model are linked to pre determined background data and are not editable."]
[]
["<< PREVIOUS",null,null,null,null,null,null,null,null,null,"NEXT >>"]

{"sheet":"1. Treatments & Products","index":4,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,10,47,11],[46,0,46,1],[0,0,0,1],[9,1,9,11],[25,1,25,11]]}
["<< PREVIOUS",null,null,null,null,"Version:",{"$f":"Settings!App_Version","v":"V1.0f2c"}]
[]
[null,{"$f":"\"Victorian Blackberry Taskforce - \"&Settings!App_Name","v":"Victorian Blackberry Taskforce - Blackberry Weed Management - Agricultural Productivity Model"}]
[]
[null,{"$f":"Introduction!B24","v":"A 'cost  benefit' analysis tool for a livestock grazing operation, specific to chemical control costs and projected productivity benefit"}]
[]
[]
["Table 1: Product Details & Costs",null,"IMPORTANT: The user must complete relevant information in Table 1 before selecting products for the treatment mix in Table 2)"]
[]
[null,"The herbicide products listed in Table 1 below are examples of common chemicals used for blackberry treatment. The content of these columns (shaded yellow) can be tailored to suit the user. As the purchasing power of different users is variable, users should apply their own figures to the cost of of the chemicals employed in the blackberry control program. These component products form the basis of the treatment to be selected by the user for their particular circumstances."]
[]
[null,"Product Name","Active Constituents","Strength","State","Unit","Cost/Drum","Units/Drum","Cost/Unit","Unit / 100 L","Units /1000 L","Cost/1000 L"]
[1,"Alpha Consume - Wetter","Polyether modified polysiloxane","1020g/L ","Liquid","litres",310,20,{"$f":"IF(H13=0,0,G13/H13)","v":15.5},0.2,{"$f":"J13*10","v":2},{"$f":"I13*K13","v":31}]
[2,"Brush Off (Genfarm Metsulfuron 600)","Metsulfuron-Methyl","600g/L ","Solid","grams",24,500,{"$f":"IF(H14=0,0,G14/H14)","v":4.8000000000000001E-2},10,{"$f":"J14*10","v":100},4.8]
[3,"Grazon DS (Genfarm Tric/Pic)","Picloram plus Triclopyr","100g/300g","Liquid","litres",310,20,15.5,0.35,{"$f":"J15*10","v":3.5},54.25]
[4,"Grazon Extra","Picloram plus Triclopyr plus Aminopyralid","100g/300g/8g ","Liquid","litres",615,20,30.75,0.35,3.5,107.625]
[5,"Stinger","Aminopyralid plus Metsulfuron-Methyl","375g/300g ","Solid granule","grams",142.5,500,0.28499999999999998,20,{"$f":"J17*10","v":200},{"$f":"I17*K17","v":56.999999999999993}]
[6,"Garlon",null,null,null,null,250,20,12.5,0.2,{"$f":"J18*10","v":2},{"$f":"I18*K18","v":25}]
[7,null,null,null,null,null,null,null,0,null,0,0]
[8,null,null,null,null,null,null,null,0,null,0,0]
[9,null,null,null,null,null,null,null,0,null,0,0]
[10,null,null,null,null,null,null,null,0,null,0,0]
[11,null,null,null,null,null,null,null,0,null,0,0]
[]
[]
[null,"The herbicide product treatment combinations listed in Table 2 below are examples of common mixes used for blackberry treatment. The treatment combination name (ie Mix 1, Mix 2, Mix 3 etc) can be tailored by the user, according to the herbicides and additives to be included in the overall mix. The user can select products from the ORANGE shaded cells, which are sourced from Table 1. The cost of the specified treatment is therefore able to be tailored to the specific circumstances of the user. The blue column sets out the total combined cost of the materials expressed per 1000 litres of mixed product."]
[]
["Table 2: Treatment Data"]
[]
[null,"Treatment Combination Name","Product 1","Prod 1 $/kL","Product 2","Prod 2 $/kL","Product 3","Prod 3 $/kL","Product 4","Prod 4 $/kL","Treatment Cost $/kL"]
[1,"eg Custom Mix 1","Grazon DS (Genfarm Tric/Pic)",{"$f":"IF(ISBLANK(C31),0,INDEX(Product_Details_Cost_Per_kL,MATCH(C31,Product_Details_Name,0)))","v":54.25},"Alpha Consume - Wetter",{"$f":"IF(ISBLANK(E31),0,INDEX(Product_Details_Cost_Per_kL,MATCH(E31,Product_Details_Name,0)))","v":31},null,{"$f":"IF(ISBLANK(G31),0,INDEX(Product_Details_Cost_Per_kL,MATCH(G31,Product_Details_Name,0)))","v":0},null,{"$f":"IF(ISBLANK(I31),0,INDEX(Product_Details_Cost_Per_kL,MATCH(I31,Product_Details_Name,0)))","v":0},{"$f":"SUM(D31,F31,H31,J31)","v":85.25}]
[2,"eg Custom Mix 2","Grazon Extra",{"$f":"IF(ISBLANK(C32),0,INDEX(Product_Details_Cost_Per_kL,MATCH(C32,Product_Details_Name,0)))","v":107.625},null,0,null,0,null,0,107.625]
[3,"(user to create a name)",null,0,null,0,null,0,null,0,0]
[4,null,null,0,null,{"$f":"IF(ISBLANK(E34),0,INDEX(Product_Details_Cost_Per_kL,MATCH(E34,Product_Details_Name,0)))","v":0},null,0,null,0,0]
[5,null,null,0,null,0,null,0,null,0,0]
[6,null,null,0,null,0,null,0,null,0,0]
[7,null,null,0,null,0,null,0,null,0,0]
[8,null,null,0,null,0,null,0,null,0,0]
[9,null,null,0,null,0,null,{"$f":"IF(ISBLANK(G39),0,INDEX(Product_Details_Cost_Per_kL,MATCH(G39,Product_Details_Name,0)))","v":0},null,0,0]
[10,null,null,0,null,0,null,0,null,0,0]
[11,null,null,0,null,0,null,0,null,0,0]
[12,null,null,0,null,0,null,0,null,0,0]
[13,null,null,0,null,0,null,0,null,0,0]
[14,null,null,0,null,0,null,0,null,0,0]
[]
[]
["<< PREVIOUS"]
[null,null,null,null,null,null,null,null,null,null,"NEXT >>"]

{"sheet":"2. Land & Property","index":5,"n_rows":162,"n_cols":22,"rows_kept":162,"cut":false,"hidden":false,"merged":[[65,3,65,4],[53,1,53,3],[54,1,54,3],[55,1,55,3],[56,1,56,3],[161,0,161,1],[161,14,161,15],[90,9,90,11],[90,1,90,2],[90,7,90,8],[91,7,91,8],[92,7,92,8],[93,7,93,8],[94,7,94,8],[91,9,91,11],[92,9,92,11],[93,9,93,11],[94,9,94,11],[100,9,100,11],[101,9,101,11],[102,9,102,11],[95,7,95,8],[102,7,102,8],[97,7,97,8],[95,9,95,11],[96,9,96,11],[97,9,97,11],[98,9,98,11],[99,9,99,11],[96,7,96,8],[98,7,98,8],[99,7,99,8],[100,7,100,8],[101,7,101,8],[0,0,0,1],[23,3,23,4],[24,3,24,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[22,3,22,4]]}
["<< PREVIOUS",null,null,null,null,null,null,null,null,"Version:",{"$f":"Settings!App_Version","v":"V1.0f2c"}]
[]
[null,{"$f":"\"Victorian Blackberry Taskforce - \"&Settings!App_Name","v":"Victorian Blackberry Taskforce - Blackberry Weed Management - Agricultural Productivity Model"}]
[]
[null,{"$f":"Introduction!B24","v":"A 'cost  benefit' analysis tool for a livestock grazing operation, specific to chemical control costs and projected productivity benefit"}]
[]
[null,"Key Assumptions"]
[null,1,"All dollar amounts are GST exclusive"]
[null,2,"All dollar amounts and projected cashflows are nominal and not adjusted / indexed to CPI"]
[null,3,"The unit rates for labour and plant hire reflect trained professional contractors and modern, high quality, efficient equipment"]
[null,4,"Chemical product application rates are based from published label recommendations"]
[null,5,"Where small areas are identified for aerial control that a practical scheduling solution can be reached"]
[null,6,"Assumes control is undertaken in accordance with best practice under appropriate seasonal and weather conditions"]
[]
[null,"1.0 Landholder Data"]
[]
[null,"Owner Name:"]
[null,"Locality / District:"]
[null,"User Reference:"]
[]
[null,"2.0 General Property Data"]
[]
[null,"Property Name:"]
[null,"Road Name:"]
[null,"District / Township:"]
[null,"State:"]
[null,"Postcode:"]
[null,"Overall Land Area:",null,{"$f":"H58","v":0},null,"which equates to:",{"$f":"D28/Hectares_To_Acres","v":0}]
[]
[null,"Geocode Reference:",null,"Not yet developed"]
[null,"Latitude / Longtitude:",null,"Not yet developed"]
[]
[null,"3.0 Livestock Production Gross Margins"]
[]
[null,"3.1 Gross Livestock Income",null,null,null,null,null,"3.2 Production Costs & Gross Margin",null,null,null,null,"3.3 Livestock Production per annum"]
[null,null,"Sales per annum","Sale Weight","Sale Price",null,null,"Variable Cost","Variable Cost","Gross Margin","Total",null,"Livestock Class","DSE Equivalent"]
[null,"Livestock Class","No. head","Average kg/head","Average $/kg","Average $/head",null,"% of sale price","$ per head","$ per head","Gross Margin",null,"DSE Equivalent","Override","Total DSE equiv."]
[null,null,0,0,0,{"$f":"D38*E38","v":0},">>>>",0,{"$f":"H38*F38","v":0},{"$f":"F38-I38","v":0},{"$f":"C38*J38","v":0},">>>>",{"$f":"IF(ISNA(MATCH(B38,Livestock_Class_Names,0)),0,INDEX(Livestock_Class_DSE_Equiv,(MATCH(B38,Livestock_Class_Names,0))))","v":0},0,{"$f":"C38*IF(VALUE(N38)=0,M38,N38)","v":0}]
[null,null,0,0,0,{"$f":"D39*E39","v":0},">>>>",0,{"$f":"H39*F39","v":0},{"$f":"F39-I39","v":0},{"$f":"C39*J39","v":0},">>>>",{"$f":"IF(ISNA(MATCH(B39,Livestock_Class_Names,0)),0,INDEX(Livestock_Class_DSE_Equiv,(MATCH(B39,Livestock_Class_Names,0))))","v":0},0,{"$f":"C39*IF(VALUE(N39)=0,M39,N39)","v":0}]
[null,null,0,0,0,0,">>>>",0,{"$f":"H40*F40","v":0},{"$f":"F40-I40","v":0},{"$f":"C40*J40","v":0},">>>>",{"$f":"IF(ISNA(MATCH(B40,Livestock_Class_Names,0)),0,INDEX(Livestock_Class_DSE_Equiv,(MATCH(B40,Livestock_Class_Names,0))))","v":0},0,0]
[null,null,0,0,0,0,">>>>",0,{"$f":"H41*F41","v":0},{"$f":"F41-I41","v":0},{"$f":"C41*J41","v":0},">>>>",{"$f":"IF(ISNA(MATCH(B41,Livestock_Class_Names,0)),0,INDEX(Livestock_Class_DSE_Equiv,(MATCH(B41,Livestock_Class_Names,0))))","v":0},0,0]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K38:K41)","v":0},null,"Total",null,{"$f":"SUM(O38:O41)","v":0}]
[]
[null,"3.4 Profitability Measure"]
[null,"For modelling purposes, adopt sustainable profit per DSE (per annum):",null,null,null,{"$f":"IF(O42=0,0,K42/O42)","v":0}]
[]
[]
[null,"4.0 Land Classification & Livestock Carrying Capacity Data"]
[]
[null,"4.1 Overall Property - Hectares by Land Class & Terrain",null,null,null,null,null,null,null,"4.2 Livestock Carrying Capacity by Land Class",null,null,null,null,"4.3 Projected Uplift "]
[]
[null,"REFER TO HYPERLINKS BELOW FOR DESCRIPTIONS",null,null,"Terrain in Hectares",null,null,null,null,"DSE Per Hectare",null,"DSE Per Acre",null,null,null,"Productivity Uplift Post Treatment"]
[null,null,null,null,"Flat","Sloping","Steep","Totals",null,"Current","Potential","Current","Potential",null,"DSE per ha","Total DSE equiv'","Efficiency Gain"]
[1,{"$f":"INDEX(Land_Class,A54)&\" - Premium Quality Land\"","v":"Class 1 - Premium Quality Land"},null,null,0,0,0,{"$f":"SUM(E54:G54)","v":0},">>>>",0,0,{"$f":"J54/Hectares_To_Acres","v":0},0,">>>>",{"$f":"K54-J54","v":0},{"$f":"O54*H54","v":0},{"$f":"IF(J54=0,0,O54/J54)","v":0}]
[2,{"$f":"INDEX(Land_Class,A55)&\" - Highly Productive\"","v":"Class 2 - Highly Productive"},null,null,0,0,0,{"$f":"SUM(E55:G55)","v":0},">>>>",0,0,0,0,">>>>",{"$f":"K55-J55","v":0},{"$f":"O55*H55","v":0},{"$f":"IF(J55=0,0,O55/J55)","v":0}]
[3,{"$f":"INDEX(Land_Class,A56)&\" - Moderately Productive\"","v":"Class 3 - Moderately Productive"},null,null,0,0,0,{"$f":"SUM(E56:G56)","v":0},">>>>",0,0,0,0,">>>>",{"$f":"K56-J56","v":0},{"$f":"O56*H56","v":0},{"$f":"IF(J56=0,0,O56/J56)","v":0}]
[4,{"$f":"INDEX(Land_Class,A57)&\" - Low Productive Capacity\"","v":"Class 4 - Low Productive Capacity"},null,null,0,0,0,{"$f":"SUM(E57:G57)","v":0},">>>>",0,0,0,0,">>>>",{"$f":"K57-J57","v":0},{"$f":"O57*H57","v":0},{"$f":"IF(J57=0,0,O57/J57)","v":0}]
[null,"TOTAL HECTARES",null,null,{"$f":"SUM(E54:E57)","v":0},{"$f":"SUM(F54:F57)","v":0},{"$f":"SUM(G54:G57)","v":0},{"$f":"SUM(E58:G58)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(P54:P57)","v":0}]
[null,null,null,null,null,null,null,null,"DSE Capacity:",{"$f":"SUMPRODUCT($H$54:$H$57,J54:J57)","v":0},{"$f":"SUMPRODUCT($H$54:$H$57,K54:K57)","v":0}]
[null,null,null,null,null,null,null,null,"Cow Area Equivalent:",{"$f":"J59/DSE_Per_Cow","v":0},{"$f":"K59/DSE_Per_Cow","v":0}]
[]
[null,"5.0 Treatment Regime, Productivity & Profitability"]
[]
[null,"5.1 Treatment Regime",null,"(select from the Drop Down box below)"]
[]
[null,"Treatment Regime:",">>>>","Aggressive"]
[]
[null,null,null,null,0,0,0]
[null,null,"Total Projected Gain (pa)","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Affected Area (ha)"]
[null,"Class 1",{"$f":"P54*$F$45","v":0},{"$f":"INDEX(Treatment_By_Class_Year_Uplift,MATCH($B70&\"/\"&D$69,Treatment_By_Class_Year_Tag,0),1)","v":0.25},0.6,0.9,1,1,1,{"$f":"M92+M93+M94","v":0}]
[null,"Class 2",{"$f":"P55*$F$45","v":0},0.25,0.6,0.9,1,1,1,{"$f":"M95+M96+M97","v":0}]
[null,"Class 3",{"$f":"P56*$F$45","v":0},0.25,0.6,0.9,1,1,1,{"$f":"M98+M99+M100","v":0}]
[null,"Class 4",{"$f":"P57*$F$45","v":0},0.25,0.6,0.9,1,1,1,{"$f":"M101+M102+M103","v":0}]
[null,null,{"$f":"SUM(C70:C73)","v":0}]
[]
[null,"5.2 Notional Productivity Benefit     (excluding capital cost of breeding stock acquisition)",null,null,null,null,null,null,null,null,"5.3 Notional Profitability Summary at Completition"]
[]
[null,"Total Projected Gain (pa)",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6",null,null,null,"DSE","Profit / DSE","Gross Profit (pa)"]
[null,{"$f":"C70","v":0},"Class 1",{"$f":"$B$79*D70","v":0},{"$f":"$B$79*E70","v":0},{"$f":"$B$79*F70","v":0},0,0,0,null,"Current ",null,{"$f":"J59","v":0},{"$f":"F45","v":0},{"$f":"F45*J59","v":0}]
[null,{"$f":"C71","v":0},"Class 2",{"$f":"$D$71*B80","v":0},{"$f":"$E$71*B80","v":0},{"$f":"$F$71*B80","v":0},{"$f":"$G$71*B80","v":0},{"$f":"$H$71*B80","v":0},{"$f":"$H$71*B80","v":0},null,"Projected ",null,{"$f":"K59","v":0},{"$f":"F45","v":0},{"$f":"F45*K59","v":0}]
[null,{"$f":"C72","v":0},"Class 3",{"$f":"$B$81*D72","v":0},0,0,0,0,0,null,"Uplift",null,{"$f":"K59-J59","v":0},{"$f":"F45","v":0},{"$f":"O80-O79","v":0}]
[null,{"$f":"C73","v":0},"Class 4",{"$f":"$B$82*D73","v":0},0,0,0,0,0]
[null,{"$f":"SUM(B79:B82)","v":0},"Total",{"$f":"SUM(D79:D82)","v":0},{"$f":"SUM(E79:E82)","v":0},0,0,{"$f":"SUM(H79:H82)","v":0},{"$f":"SUM(I79:I82)","v":0}]
[]
[null,"Cumulative Benefit",null,{"$f":"D83","v":0},{"$f":"D85+E83","v":0},{"$f":"E85+F83","v":0},{"$f":"F85+G83","v":0},{"$f":"F85+H83","v":0},{"$f":"G85+I83","v":0}]
[]
[null,"6.0 Infestation Details, Control Methods &  Treatments"]
[]
[null,"6.1 Infestion & Control Details by Class & Terrain"]
[null,"Only enter values for non-greyed out rows, ie where Hectares is > 0",null,null,null,null,null,null,null,null,"Click here to see the Product Treatment Options>>"]
[null,"Class By Terrain",null,"Hectares (as above)","% Infestation","Infestation Density","Access","Control Method",null,"Treatment Combination Name",null,null,"Hectares Affected","Terrain+Access","Range1 Name","Range2 Name","Hectares/Day","L/Hectare","Labour & Equip/Day","Labour & Equip Cost","Chemical Cost","Total Cost"]
[1,{"$f":"INDEX(Land_Class,A92)&\"/\"&$E$53","v":"Class 1/Flat"},null,{"$f":"$E$54","v":0},0,null,null,null,null,null,null,null,{"$f":"D92*E92","v":0},{"$f":"MID(B92,FIND(\"/\",B92)+1,100)&\"+\"&G92","v":"Flat+"},{"$f":"CHOOSE(MATCH($H92,Control_Method_Tbl[Method Name],0),\"Method_1_Hectares_Per_Day\",\"Method_2_Hectares_Per_Day\",\"Method_3_Hectares_Per_Day\")","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H92,Control_Method_Tbl[Method Name],0),\"Method_1_Litres_Per_Hectare\",\"Method_2_Litres_Per_Hectare\",\"Method_3_Litres_Per_Hectare\")","v":{"$error":"#N/A"}},{"$f":"INDEX(INDIRECT(O92),MATCH($N92,INDEX(INDIRECT(O92),0,1),0),MATCH($F92,Infestation_Intensity_Names,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(INDIRECT(P92),MATCH($N92,INDEX(INDIRECT(P92),0,1),0),MATCH($F92,Infestation_Intensity_Names,0))","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H92,Control_Method_Tbl[Method Name],0),Method_1_Labour_Equip_Per_Day,Method_2_Labour_Equip_Per_Day,Method_3_Labour_Equip_Per_Day)","v":{"$error":"#N/A"}},{"$f":"IF(VALUE(E92)=0,0,S92/Q92)","v":0},{"$f":"IF(VALUE(E92)=0,0,R92/1000*INDEX(Treatment_Details_Cost_Per_kL,MATCH($J92,Treatment_Details_Name,0)))","v":0},{"$f":"SUM(T92:U92)","v":0}]
[1,{"$f":"INDEX(Land_Class,A93)&\"/\"&$F$53","v":"Class 1/Sloping"},null,{"$f":"$F$54","v":0},0,null,null,null,null,null,null,null,{"$f":"D93*E93","v":0},"Sloping+",{"$f":"CHOOSE(MATCH($H93,Control_Method_Tbl[Method Name],0),\"Method_1_Hectares_Per_Day\",\"Method_2_Hectares_Per_Day\",\"Method_3_Hectares_Per_Day\")","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H93,Control_Method_Tbl[Method Name],0),\"Method_1_Litres_Per_Hectare\",\"Method_2_Litres_Per_Hectare\",\"Method_3_Litres_Per_Hectare\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHOOSE(MATCH($H93,Control_Method_Tbl[Method Name],0),Method_1_Labour_Equip_Per_Day,Method_2_Labour_Equip_Per_Day,Method_3_Labour_Equip_Per_Day)","v":{"$error":"#N/A"}},0,0,0]
[1,{"$f":"INDEX(Land_Class,A94)&\"/\"&$G$53","v":"Class 1/Steep"},null,{"$f":"$G$54","v":0},0,null,null,null,null,null,null,null,0,"Steep+",{"$f":"CHOOSE(MATCH($H94,Control_Method_Tbl[Method Name],0),\"Method_1_Hectares_Per_Day\",\"Method_2_Hectares_Per_Day\",\"Method_3_Hectares_Per_Day\")","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H94,Control_Method_Tbl[Method Name],0),\"Method_1_Litres_Per_Hectare\",\"Method_2_Litres_Per_Hectare\",\"Method_3_Litres_Per_Hectare\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHOOSE(MATCH($H94,Control_Method_Tbl[Method Name],0),Method_1_Labour_Equip_Per_Day,Method_2_Labour_Equip_Per_Day,Method_3_Labour_Equip_Per_Day)","v":{"$error":"#N/A"}},0,0,0]
[2,{"$f":"INDEX(Land_Class,A95)&\"/\"&$E$53","v":"Class 2/Flat"},null,{"$f":"$E$55","v":0},0,null,null,null,null,null,null,null,0,"Flat+",{"$f":"CHOOSE(MATCH($H95,Control_Method_Tbl[Method Name],0),\"Method_1_Hectares_Per_Day\",\"Method_2_Hectares_Per_Day\",\"Method_3_Hectares_Per_Day\")","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H95,Control_Method_Tbl[Method Name],0),\"Method_1_Litres_Per_Hectare\",\"Method_2_Litres_Per_Hectare\",\"Method_3_Litres_Per_Hectare\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHOOSE(MATCH($H95,Control_Method_Tbl[Method Name],0),Method_1_Labour_Equip_Per_Day,Method_2_Labour_Equip_Per_Day,Method_3_Labour_Equip_Per_Day)","v":{"$error":"#N/A"}},0,0,0]
[2,{"$f":"INDEX(Land_Class,A96)&\"/\"&$F$53","v":"Class 2/Sloping"},null,{"$f":"$F$55","v":0},0,null,null,null,null,null,null,null,0,"Sloping+",{"$f":"CHOOSE(MATCH($H96,Control_Method_Tbl[Method Name],0),\"Method_1_Hectares_Per_Day\",\"Method_2_Hectares_Per_Day\",\"Method_3_Hectares_Per_Day\")","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H96,Control_Method_Tbl[Method Name],0),\"Method_1_Litres_Per_Hectare\",\"Method_2_Litres_Per_Hectare\",\"Method_3_Litres_Per_Hectare\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHOOSE(MATCH($H96,Control_Method_Tbl[Method Name],0),Method_1_Labour_Equip_Per_Day,Method_2_Labour_Equip_Per_Day,Method_3_Labour_Equip_Per_Day)","v":{"$error":"#N/A"}},0,0,0]
[2,{"$f":"INDEX(Land_Class,A97)&\"/\"&$G$53","v":"Class 2/Steep"},null,{"$f":"$G$55","v":0},0,null,null,null,null,null,null,null,0,"Steep+",{"$f":"CHOOSE(MATCH($H97,Control_Method_Tbl[Method Name],0),\"Method_1_Hectares_Per_Day\",\"Method_2_Hectares_Per_Day\",\"Method_3_Hectares_Per_Day\")","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H97,Control_Method_Tbl[Method Name],0),\"Method_1_Litres_Per_Hectare\",\"Method_2_Litres_Per_Hectare\",\"Method_3_Litres_Per_Hectare\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHOOSE(MATCH($H97,Control_Method_Tbl[Method Name],0),Method_1_Labour_Equip_Per_Day,Method_2_Labour_Equip_Per_Day,Method_3_Labour_Equip_Per_Day)","v":{"$error":"#N/A"}},0,0,0]
[3,{"$f":"INDEX(Land_Class,A98)&\"/\"&$E$53","v":"Class 3/Flat"},null,{"$f":"$E$56","v":0},0,null,null,null,null,null,null,null,0,"Flat+",{"$f":"CHOOSE(MATCH($H98,Control_Method_Tbl[Method Name],0),\"Method_1_Hectares_Per_Day\",\"Method_2_Hectares_Per_Day\",\"Method_3_Hectares_Per_Day\")","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H98,Control_Method_Tbl[Method Name],0),\"Method_1_Litres_Per_Hectare\",\"Method_2_Litres_Per_Hectare\",\"Method_3_Litres_Per_Hectare\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHOOSE(MATCH($H98,Control_Method_Tbl[Method Name],0),Method_1_Labour_Equip_Per_Day,Method_2_Labour_Equip_Per_Day,Method_3_Labour_Equip_Per_Day)","v":{"$error":"#N/A"}},0,0,0]
[3,{"$f":"INDEX(Land_Class,A99)&\"/\"&$F$53","v":"Class 3/Sloping"},null,{"$f":"$F$56","v":0},0,null,null,null,null,null,null,null,0,"Sloping+",{"$f":"CHOOSE(MATCH($H99,Control_Method_Tbl[Method Name],0),\"Method_1_Hectares_Per_Day\",\"Method_2_Hectares_Per_Day\",\"Method_3_Hectares_Per_Day\")","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H99,Control_Method_Tbl[Method Name],0),\"Method_1_Litres_Per_Hectare\",\"Method_2_Litres_Per_Hectare\",\"Method_3_Litres_Per_Hectare\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHOOSE(MATCH($H99,Control_Method_Tbl[Method Name],0),Method_1_Labour_Equip_Per_Day,Method_2_Labour_Equip_Per_Day,Method_3_Labour_Equip_Per_Day)","v":{"$error":"#N/A"}},0,0,0]
[3,{"$f":"INDEX(Land_Class,A100)&\"/\"&$G$53","v":"Class 3/Steep"},null,{"$f":"$G$56","v":0},0,null,null,null,null,null,null,null,0,"Steep+",{"$f":"CHOOSE(MATCH($H100,Control_Method_Tbl[Method Name],0),\"Method_1_Hectares_Per_Day\",\"Method_2_Hectares_Per_Day\",\"Method_3_Hectares_Per_Day\")","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H100,Control_Method_Tbl[Method Name],0),\"Method_1_Litres_Per_Hectare\",\"Method_2_Litres_Per_Hectare\",\"Method_3_Litres_Per_Hectare\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHOOSE(MATCH($H100,Control_Method_Tbl[Method Name],0),Method_1_Labour_Equip_Per_Day,Method_2_Labour_Equip_Per_Day,Method_3_Labour_Equip_Per_Day)","v":{"$error":"#N/A"}},0,0,0]
[4,{"$f":"INDEX(Land_Class,A101)&\"/\"&$E$53","v":"Class 4/Flat"},null,{"$f":"$E$57","v":0},0,null,null,null,null,null,null,null,0,"Flat+",{"$f":"CHOOSE(MATCH($H101,Control_Method_Tbl[Method Name],0),\"Method_1_Hectares_Per_Day\",\"Method_2_Hectares_Per_Day\",\"Method_3_Hectares_Per_Day\")","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H101,Control_Method_Tbl[Method Name],0),\"Method_1_Litres_Per_Hectare\",\"Method_2_Litres_Per_Hectare\",\"Method_3_Litres_Per_Hectare\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHOOSE(MATCH($H101,Control_Method_Tbl[Method Name],0),Method_1_Labour_Equip_Per_Day,Method_2_Labour_Equip_Per_Day,Method_3_Labour_Equip_Per_Day)","v":{"$error":"#N/A"}},0,0,0]
[4,{"$f":"INDEX(Land_Class,A102)&\"/\"&$F$53","v":"Class 4/Sloping"},null,{"$f":"$F$57","v":0},0,null,null,null,null,null,null,null,0,"Sloping+",{"$f":"CHOOSE(MATCH($H102,Control_Method_Tbl[Method Name],0),\"Method_1_Hectares_Per_Day\",\"Method_2_Hectares_Per_Day\",\"Method_3_Hectares_Per_Day\")","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H102,Control_Method_Tbl[Method Name],0),\"Method_1_Litres_Per_Hectare\",\"Method_2_Litres_Per_Hectare\",\"Method_3_Litres_Per_Hectare\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHOOSE(MATCH($H102,Control_Method_Tbl[Method Name],0),Method_1_Labour_Equip_Per_Day,Method_2_Labour_Equip_Per_Day,Method_3_Labour_Equip_Per_Day)","v":{"$error":"#N/A"}},0,0,0]
[4,{"$f":"INDEX(Land_Class,A103)&\"/\"&$G$53","v":"Class 4/Steep"},null,{"$f":"$G$57","v":0},0,null,null,null,null,null,null,null,0,"Steep+",{"$f":"CHOOSE(MATCH($H103,Control_Method_Tbl[Method Name],0),\"Method_1_Hectares_Per_Day\",\"Method_2_Hectares_Per_Day\",\"Method_3_Hectares_Per_Day\")","v":{"$error":"#N/A"}},{"$f":"CHOOSE(MATCH($H103,Control_Method_Tbl[Method Name],0),\"Method_1_Litres_Per_Hectare\",\"Method_2_Litres_Per_Hectare\",\"Method_3_Litres_Per_Hectare\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"CHOOSE(MATCH($H103,Control_Method_Tbl[Method Name],0),Method_1_Labour_Equip_Per_Day,Method_2_Labour_Equip_Per_Day,Method_3_Labour_Equip_Per_Day)","v":{"$error":"#N/A"}},0,0,0]
[null,"TOTAL HECTARES",null,{"$f":"SUM(D92:D103)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(M92:M103)","v":0}]
[]
[]
[null,"LINKED TABLE","Index",1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,"Hectares Affected",{"$f":"INDEX($M$92:$M$103,D107)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Labour & Equip Cost",{"$f":"INDEX($T$92:$T$103,D107)","v":0},{"$f":"INDEX($T$92:$T$103,E107)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Chemical Cost",{"$f":"INDEX($U$92:$U$103,D107)","v":0},0,0,{"$f":"INDEX($U$92:$U$103,G107)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Total Cost",{"$f":"INDEX($V$92:$V$103,D107)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Infestation Index",{"$f":"MATCH(INDEX($F$92:$F$103,D107),Infestation_Intensity_Names,0)-1","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Class Index",{"$f":"INDEX(Land_Class,INDEX($A$92:$A$103,D107))","v":"Class 1"},"Class 1","Class 1","Class 2","Class 2","Class 2","Class 3","Class 3","Class 3","Class 4","Class 4","Class 4"]
[null,null,null,{"$f":"B92","v":"Class 1/Flat"},{"$f":"B93","v":"Class 1/Sloping"},{"$f":"B94","v":"Class 1/Steep"},{"$f":"B95","v":"Class 2/Flat"},{"$f":"B96","v":"Class 2/Sloping"},{"$f":"B97","v":"Class 2/Steep"},{"$f":"B98","v":"Class 3/Flat"},{"$f":"B99","v":"Class 3/Sloping"},{"$f":"B100","v":"Class 3/Steep"},{"$f":"B101","v":"Class 4/Flat"},{"$f":"B102","v":"Class 4/Sloping"},{"$f":"B103","v":"Class 4/Steep"},"Total"]
[null,"TREATED HECTARES BY YEAR"]
[null,null,"Year 1",{"$f":"IF(ISNA(D$113),0,D$108*INDEX(Treatment_By_Class_Year_PCT_Area_Tbl,MATCH(D$114&\"/\"&$C117,Treatment_By_Class_Year_Tag,0),D$113))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Year 2",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Year 3",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Year 4",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Year 5",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"PRIMARY COST BY YEAR"]
[null,null,"Year 1",{"$f":"D117*D$111","v":0},{"$f":"E117*E$111","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D124:O124)","v":0}]
[null,null,"Year 2",{"$f":"D118*D$111","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D125:O125)","v":0}]
[null,null,"Year 3",{"$f":"D119*D$111","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Year 4",{"$f":"D120*D$111","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Year 5",{"$f":"D121*D$111","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"HECTARES NEEDING MAINTENANCE BY YEAR"]
[null,0,"Year 1",{"$f":"IF($B131=0,0,SUM(OFFSET(D$117:D$121,0,0,B$140)))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,1,"Year 2",{"$f":"IF($B132=0,0,SUM(OFFSET(D$117:D$121,0,0,$B132)))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,2,"Year 3",0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,"Year 4",0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,"Year 5",0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,"Year 6",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"MAINTENANCE COST BY YEAR"]
[null,0,"Year 1",{"$f":"IF(ISNA(D$113),0,D131*INDEX(Treatment_By_Class_Year_PCT_Cost_Tbl,MATCH(D$114&\"/\"&$C139,Treatment_By_Class_Year_Tag,0),D$113)*D$111)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D139:O139)","v":0}]
[null,1,"Year 2",{"$f":"IF(ISNA(D$113),0,D132*INDEX(Treatment_By_Class_Year_PCT_Cost_Tbl,MATCH(D$114&\"/\"&$C140,Treatment_By_Class_Year_Tag,0),D$113)*D$111)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D140:O140)","v":0}]
[null,2,"Year 3",{"$f":"IF(ISNA(D$113),0,D133*INDEX(Treatment_By_Class_Year_PCT_Cost_Tbl,MATCH(D$114&\"/\"&$C141,Treatment_By_Class_Year_Tag,0),D$113)*D$111)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D141:O141)","v":0}]
[null,3,"Year 4",{"$f":"IF(ISNA(D$113),0,D134*INDEX(Treatment_By_Class_Year_PCT_Cost_Tbl,MATCH(D$114&\"/\"&$C142,Treatment_By_Class_Year_Tag,0),D$113)*D$111)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,"Year 5",{"$f":"IF(ISNA(D$113),0,D135*INDEX(Treatment_By_Class_Year_PCT_Cost_Tbl,MATCH(D$114&\"/\"&$C143,Treatment_By_Class_Year_Tag,0),D$113)*D$111)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,"Year 6",{"$f":"IF(ISNA(D$113),0,D136*INDEX(Treatment_By_Class_Year_PCT_Cost_Tbl,MATCH(D$114&\"/\"&$C144,Treatment_By_Class_Year_Tag,0),D$113)*D$111)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"TEST: % for Maintenance"]
[null,0,"Year 1",{"$f":"IF($B146=0,0,INDEX(Treatment_By_Class_Year_PCT_Cost_Tbl,MATCH(D$114&\"/\"&$C146,Treatment_By_Class_Year_Tag,0),D$113))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,1,"Year 2",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2,"Year 3",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,3,"Year 4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,4,"Year 5",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,5,"Year 6",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,"TOTAL COST BY YEAR"]
[null,0,"Year 1",{"$f":"SUM(D124,D139)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D154:O154)","v":0}]
[null,1,"Year 2",{"$f":"SUM(D125,D140)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D155:O155)","v":0}]
[null,2,"Year 3",{"$f":"SUM(D126,D141)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,"Year 4",{"$f":"SUM(D127,D142)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,"Year 5",{"$f":"SUM(D128,D143)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,"Year 6",{"$f":"SUM(D129,D144)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P154:P159)","v":0}]
[]
["<< PREVIOUS",null,null,null,null,null,null,null,null,null,null,null,null,null,"NEXT >>"]

{"sheet":"3. Control Methods","index":6,"n_rows":145,"n_cols":31,"rows_kept":145,"cut":false,"hidden":false,"merged":[[7,1,7,13],[0,0,0,2],[49,11,49,12],[49,0,49,2],[37,8,44,12]]}
["<< PREVIOUS",null,null,null,null,null,null,null,null,null,null,"Version:",{"$f":"Settings!App_Version","v":"V1.0f2c"}]
[]
[null,{"$f":"\"Victorian Blackberry Taskforce - \"&Settings!App_Name","v":"Victorian Blackberry Taskforce - Blackberry Weed Management - Agricultural Productivity Model"}]
[]
[null,{"$f":"Introduction!B24","v":"A 'cost  benefit' analysis tool for a livestock grazing operation, specific to chemical control costs and projected productivity benefit"}]
[]
[]
[null,"4.0 Labour and Equipment Costs by Control Method",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costs by Control Method",null,null,null,null,null,null,null,null,null,"Control Method Details & Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Currently Only 1st Column Used!!!!"]
[null,null,1,{"$f":"INDEX(Control_Method_Tbl[Method Name],C10)","v":"Ground"},null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Blackberry Control Method Data",null,null,null,null,null,null,null,null,"Method Name","Method Description","Base Hectares/Day","Cost/Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ground",null,10,1400]
[null,null,"(a) Labour & Plant Hire Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.1 - Chemical Control Inputs",null,"Ground Based Application (Method 1)",null,null,null,null,null,null,null,"Aerial - Broadacre",null,300,{"$f":"AL34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiplier Rates",null,null,null,null,null,"Aerial - Spot Spray ",null,250,25000]
[null,null,"The model assumes the application of 2 x labour units:"]
[null,null,"Hours worked per day per labour unit:",null,null,8,"hours",null,null,null,null,null,null,null,null,null,null,"(a) Estimated Mixed Product Use Matrix (litres per day)",null,null,{"$f":"INDEX(Infestation_Intensity_Treatment_Multiplier,MATCH($U$19,Infestation_Intensity_Names,0))","v":1},{"$f":"INDEX(Infestation_Intensity_Treatment_Multiplier,MATCH($V$19,Infestation_Intensity_Names,0))","v":2},{"$f":"INDEX(Infestation_Intensity_Treatment_Multiplier,MATCH($W$19,Infestation_Intensity_Names,0))","v":3}]
[null,null,"Total hours worked per day:",null,null,{"$f":"F15*2","v":16},"hours"]
[]
[null,null,"Cost per labour unit - per hour",null,null,60,"per hour",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infestation Intensity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor","Moderate","Heavy"]
[null,null,"Includes:",null,"Spray vehicle",2,null,null,null,null,null,null,null,null,null,null,null,"Flat","Good",{"$f":"R20&\"+\"&S20","v":"Flat+Good"},1000,{"$f":"$U20*V$15","v":2000},3000]
[null,null,null,null,"Labour units",1,null,null,null,null,null,null,null,null,null,null,null,"Flat","Fair","Flat+Fair",900,1800,2700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Difficult","Flat+Difficult",600,1200,1800]
[null,null,"Total Daily Cost:",null,{"$f":"F16*F18","v":960},"per day","(includes 2 x labour units and 1 x fully equipped, fit for purpose spray rig vehicle)",null,null,null,null,null,null,null,null,null,null,"Sloping","Good","Sloping+Good",900,1800,2700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Fair","Sloping+Fair",800,1600,2400]
[null,null,2,{"$f":"INDEX(Control_Method_Tbl[Method Name],C25)","v":"Aerial - Broadacre"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Difficult","Sloping+Difficult",500,1000,1500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Good","Steep+Good",800,1600,2400]
[null,null,"Helicopter cost per hour:",null,null,2500,null,null,"VBT suggested input",null,null,null,null,null,null,null,null,"Steep","Fair","Steep+Fair",700,1400,2100]
[null,null,"Loads completed per hour:",null,null,4,null,null,"per load numbers",null,null,null,null,null,null,null,null,"Steep","Difficult","Steep+Difficult",500,1000,1500]
[null,null,"Area covered per Load:",null,null,3,"hectares",null,"need to factor in:"]
[null,null,"Litres per Load:",null,null,300,"litres",null,"ferry time, unless combined with other nearby users",null,null,null,null,null,null,null,null,null,null,null,null,"Discount Rates"]
[null,null,"Area covered per hour:",null,null,{"$f":"F28*F29","v":12},"hectares",null,null,null,null,null,null,null,null,null,null,"(b) Estimated Area Treated (hectares per 10 hour day)",null,null,{"$f":"1/INDEX(Infestation_Intensity_Labour_Multiplier,MATCH(U$33,Infestation_Intensity_Names,0))","v":1},{"$f":"1/INDEX(Infestation_Intensity_Labour_Multiplier,MATCH(V$33,Infestation_Intensity_Names,0))","v":0.5},{"$f":"1/INDEX(Infestation_Intensity_Labour_Multiplier,MATCH(W$33,Infestation_Intensity_Names,0))","v":0.25}]
[null,null,"Mixed Product used per hour:",null,null,{"$f":"F30*F28","v":1200},"litres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infestation Intensity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terrain","Access","Tag","Minor","Moderate","Heavy"]
[null,null,"Total Daily Cost:",null,{"$f":"F27*F15","v":20000},"per day","(10 hrs)",null,null,null,null,null,null,null,null,null,null,"Flat","Good",{"$f":"R34&\"+\"&S34","v":"Flat+Good"},40,{"$f":"U34*$V$31","v":20},{"$f":"U34*$W$31","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Fair","Flat+Fair",35,17.5,8.75]
[null,null,3,{"$f":"INDEX(Control_Method_Tbl[Method Name],C36)","v":"Aerial - Spot Spray "},null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Difficult","Flat+Difficult",30,15,7.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Good","Sloping+Good",25,12.5,6.25]
[null,null,"Helicopter cost per hour:",null,null,2500,null,null,"Please note that the use of aerial spray techniques for the purposes of controlling blackberry may result in some non-target vegetation being adversely impacted, ie collateral damage. Caution should be applied with this method of application and the relevant approvals sought as necessary.",null,null,null,null,null,null,null,null,"Sloping","Fair","Sloping+Fair",20,10,5]
[null,null,"Loads completed per hour:",null,null,2,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Difficult","Sloping+Difficult",15,7.5,3.75]
[null,null,"Area covered per Load:",null,null,5,"hectares",null,null,null,null,null,null,null,null,null,null,"Steep","Good","Steep+Good",15,7.5,3.75]
[null,null,"Litres per Load:",null,null,300,"litres",null,null,null,null,null,null,null,null,null,null,"Steep","Fair","Steep+Fair",10,5,2.5]
[null,null,"Area covered per hour:",null,null,{"$f":"F39*F40","v":10},"hectares",null,null,null,null,null,null,null,null,null,null,"Steep","Difficult","Steep+Difficult",8,4,2]
[null,null,"Mixed Product used per hour:",null,null,{"$f":"F41*F39","v":600},"litres"]
[]
[null,null,"Total Daily Cost:",null,{"$f":"F38*F15","v":20000},"per day",null,null,null,null,null,null,null,null,null,null,null,"(c ) Estimated Mixed Product Use Matrix (litres per hectare)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infestation Intensity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terrain","Access","Tag","Minor","Moderate","Heavy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Good",{"$f":"R48&\"+\"&S48","v":"Flat+Good"},{"$f":"U20/U34","v":25},100,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Fair","Flat+Fair",25.714285714285715,102.85714285714286,308.57142857142856]
["<< PREVIOUS",null,null,null,null,null,null,null,null,null,null,"NEXT >>",null,null,null,null,null,"Flat","Difficult","Flat+Difficult",20,80,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Good","Sloping+Good",36,144,432]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Fair","Sloping+Fair",40,160,480]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Difficult","Sloping+Difficult",33.333333333333336,133.33333333333334,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Good","Steep+Good",53.333333333333336,213.33333333333334,640]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Fair","Steep+Fair",70,280,840]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Difficult","Steep+Difficult",62.5,250,750]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.2 - Chemical Control Inputs",null,"Aerial Application - Broadacre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiplier Rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(a) Estimated Mixed Product Use Matrix (litres per hour)",null,null,{"$f":"INDEX(Infestation_Intensity_Treatment_Multiplier,MATCH($U$19,Infestation_Intensity_Names,0))","v":1},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infestation Intensity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terrain","Access","Tag","Minor","Moderate","Heavy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Good",{"$f":"R64&\"+\"&S64","v":"Flat+Good"},1200,{"$f":"$U64*V$61","v":1200},{"$f":"$U64*W$61","v":1200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Fair","Flat+Fair",1200,{"$f":"$U65*V$61","v":1200},1200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Difficult","Flat+Difficult",1200,1200,1200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Good","Sloping+Good",1200,1200,1200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Fair","Sloping+Fair",1200,1200,1200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Difficult","Sloping+Difficult",1200,1200,1200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Good","Steep+Good",1200,1200,1200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Fair","Steep+Fair",1200,1200,1200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Difficult","Steep+Difficult",1200,{"$f":"$U72*V$61","v":1200},{"$f":"$U72*W$61","v":1200}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Discount Rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(b) Estimated Area Treated (hectares per hour)",null,null,null,{"$f":"1/INDEX(Infestation_Intensity_Labour_Multiplier,MATCH(V$33,Infestation_Intensity_Names,0))","v":0.5},{"$f":"1/INDEX(Infestation_Intensity_Labour_Multiplier,MATCH(W$33,Infestation_Intensity_Names,0))","v":0.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infestation Intensity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terrain","Access","Tag","Minor","Moderate","Heavy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Good",{"$f":"R78&\"+\"&S78","v":"Flat+Good"},12,{"$f":"U78*$V$75","v":6},{"$f":"U78*$W$75","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Fair","Flat+Fair",12,{"$f":"U79*$V$75","v":6},{"$f":"U79*$W$75","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Difficult","Flat+Difficult",12,6,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Good","Sloping+Good",12,6,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Fair","Sloping+Fair",12,6,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Difficult","Sloping+Difficult",12,6,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Good","Steep+Good",12,6,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Fair","Steep+Fair",12,6,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Difficult","Steep+Difficult",12,6,3]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(c ) Estimated Mixed Product Use Matrix (litres per hectare)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infestation Intensity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terrain","Access","Tag","Minor","Moderate","Heavy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Good",{"$f":"R92&\"+\"&S92","v":"Flat+Good"},{"$f":"U64/U78","v":100},200,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Fair","Flat+Fair",{"$f":"U65/U79","v":100},200,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Difficult","Flat+Difficult",{"$f":"U66/U80","v":100},200,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Good","Sloping+Good",{"$f":"U67/U81","v":100},200,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Fair","Sloping+Fair",{"$f":"U68/U82","v":100},200,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Difficult","Sloping+Difficult",{"$f":"U69/U83","v":100},200,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Good","Steep+Good",{"$f":"U70/U84","v":100},200,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Fair","Steep+Fair",{"$f":"U71/U85","v":100},200,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Difficult","Steep+Difficult",{"$f":"U72/U86","v":100},200,{"$f":"W72/W86","v":400}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.3 - Chemical Control Inputs",null,"Aerial Application - Spot Spray"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiplier Rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(a) Estimated Mixed Product Use Matrix (litres per hour)",null,null,{"$f":"INDEX(Infestation_Intensity_Treatment_Multiplier,MATCH($U$19,Infestation_Intensity_Names,0))","v":1},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infestation Intensity",null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terrain","Access","Tag","Minor","Moderate","Heavy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Good",{"$f":"R109&\"+\"&S109","v":"Flat+Good"},600,{"$f":"$U109*V$61","v":600},600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Fair","Flat+Fair",600,600,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Difficult","Flat+Difficult",600,600,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Good","Sloping+Good",600,600,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Fair","Sloping+Fair",600,600,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Difficult","Sloping+Difficult",600,600,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Good","Steep+Good",600,600,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Fair","Steep+Fair",600,600,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Difficult","Steep+Difficult",600,{"$f":"$U117*V$61","v":600},{"$f":"$U117*W$61","v":600}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Discount Rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(b) Estimated Area Treated (hectares per hour)",null,null,null,{"$f":"1/INDEX(Infestation_Intensity_Labour_Multiplier,MATCH(V$33,Infestation_Intensity_Names,0))","v":0.5},{"$f":"1/INDEX(Infestation_Intensity_Labour_Multiplier,MATCH(W$33,Infestation_Intensity_Names,0))","v":0.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infestation Intensity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terrain","Access","Tag","Minor","Moderate","Heavy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Good",{"$f":"R123&\"+\"&S123","v":"Flat+Good"},10,{"$f":"U123*$V$75","v":5},{"$f":"U123*$W$75","v":2.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Fair","Flat+Fair",10,{"$f":"U124*$V$75","v":5},{"$f":"U124*$W$75","v":2.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Difficult","Flat+Difficult",10,5,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Good","Sloping+Good",10,5,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Fair","Sloping+Fair",10,5,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Difficult","Sloping+Difficult",10,5,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Good","Steep+Good",10,5,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Fair","Steep+Fair",10,5,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Difficult","Steep+Difficult",10,5,2.5]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(c ) Estimated Mixed Product Use Matrix (litres per hectare)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infestation Intensity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terrain","Access","Tag","Minor","Moderate","Heavy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Good",{"$f":"R137&\"+\"&S137","v":"Flat+Good"},{"$f":"U109/U123","v":60},120,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Fair","Flat+Fair",{"$f":"U110/U124","v":60},{"$f":"V110/V124","v":120},240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat","Difficult","Flat+Difficult",{"$f":"U111/U125","v":60},{"$f":"V111/V125","v":120},240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Good","Sloping+Good",{"$f":"U112/U126","v":60},120,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Fair","Sloping+Fair",{"$f":"U113/U127","v":60},120,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sloping","Difficult","Sloping+Difficult",{"$f":"U114/U128","v":60},120,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Good","Steep+Good",{"$f":"U115/U129","v":60},120,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Fair","Steep+Fair",{"$f":"U116/U130","v":60},120,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steep","Difficult","Steep+Difficult",{"$f":"U117/U131","v":60},120,{"$f":"W117/W131","v":240}]

{"sheet":"Treatment Regimes","index":7,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[103,0,103,1],[0,0,0,1],[0,12,0,13],[103,12,103,13]]}
["<< PREVIOUS",null,null,null,null,null,null,null,null,null,null,null,"NEXT >>"]
[null,6,"Rural Management Assumptions and Metrics"]
[]
[null,"6.1 Treatment Regimes - Proportion of Affected Land Actively Treated per annum"]
[]
[null,"6.1.1 Aggressive"]
[null,null,null,null,null,null,null,"Initial Treatment Area as % of Infested By Year",null,null,null,"Yearly Treatment as % of Initial Cost"]
[null,"Land Classification","Year","Tag","% DSE Uplift",null,{"$f":"'Reference Data'!R4","v":"Minor"},{"$f":"'Reference Data'!S4","v":"Moderate"},{"$f":"'Reference Data'!T4","v":"Heavy"},null,{"$f":"'Reference Data'!V4","v":"Minor"},{"$f":"'Reference Data'!W4","v":"Moderate"},{"$f":"'Reference Data'!X4","v":"Heavy"}]
[1,{"$f":"'Reference Data'!M5","v":"Class 1"},{"$f":"'Reference Data'!N5","v":"Year 1"},{"$f":"'Reference Data'!O5","v":"Class 1/Year 1"},0.25,null,1,1,1,null,1,1,1]
[2,{"$f":"'Reference Data'!M6","v":"Class 2"},{"$f":"'Reference Data'!N6","v":"Year 1"},{"$f":"'Reference Data'!O6","v":"Class 2/Year 1"},0.25,null,1,1,1,null,1,1,1]
[3,{"$f":"'Reference Data'!M7","v":"Class 3"},{"$f":"'Reference Data'!N7","v":"Year 1"},{"$f":"'Reference Data'!O7","v":"Class 3/Year 1"},0.25,null,1,1,1,null,1,1,1]
[4,{"$f":"'Reference Data'!M8","v":"Class 4"},{"$f":"'Reference Data'!N8","v":"Year 1"},{"$f":"'Reference Data'!O8","v":"Class 4/Year 1"},0.25,null,1,1,1,null,1,1,1]
[1,{"$f":"'Reference Data'!M9","v":"Class 1"},{"$f":"'Reference Data'!N9","v":"Year 2"},{"$f":"'Reference Data'!O9","v":"Class 1/Year 2"},0.6,null,0,0,0,null,0.1,0.2,0.3]
[2,{"$f":"'Reference Data'!M10","v":"Class 2"},{"$f":"'Reference Data'!N10","v":"Year 2"},{"$f":"'Reference Data'!O10","v":"Class 2/Year 2"},0.6,null,0,0,0,null,0.1,0.2,0.3]
[3,{"$f":"'Reference Data'!M11","v":"Class 3"},{"$f":"'Reference Data'!N11","v":"Year 2"},{"$f":"'Reference Data'!O11","v":"Class 3/Year 2"},0.6,null,0,0,0,null,0.1,0.2,0.3]
[4,{"$f":"'Reference Data'!M12","v":"Class 4"},{"$f":"'Reference Data'!N12","v":"Year 2"},{"$f":"'Reference Data'!O12","v":"Class 4/Year 2"},0.6,null,0,0,0,null,0.1,0.2,0.3]
[1,{"$f":"'Reference Data'!M13","v":"Class 1"},{"$f":"'Reference Data'!N13","v":"Year 3"},{"$f":"'Reference Data'!O13","v":"Class 1/Year 3"},0.9,null,0,0,0,null,0.05,0.1,0.2]
[2,{"$f":"'Reference Data'!M14","v":"Class 2"},{"$f":"'Reference Data'!N14","v":"Year 3"},{"$f":"'Reference Data'!O14","v":"Class 2/Year 3"},0.9,null,0,0,0,null,0.05,0.1,0.2]
[3,{"$f":"'Reference Data'!M15","v":"Class 3"},{"$f":"'Reference Data'!N15","v":"Year 3"},{"$f":"'Reference Data'!O15","v":"Class 3/Year 3"},0.9,null,0,0,0,null,0.05,0.1,0.2]
[4,{"$f":"'Reference Data'!M16","v":"Class 4"},{"$f":"'Reference Data'!N16","v":"Year 3"},{"$f":"'Reference Data'!O16","v":"Class 4/Year 3"},0.9,null,0,0,0,null,0.05,0.1,0.2]
[1,{"$f":"'Reference Data'!M17","v":"Class 1"},{"$f":"'Reference Data'!N17","v":"Year 4"},{"$f":"'Reference Data'!O17","v":"Class 1/Year 4"},1,null,0,0,0,null,0.01,0.05,0.05]
[2,{"$f":"'Reference Data'!M18","v":"Class 2"},{"$f":"'Reference Data'!N18","v":"Year 4"},{"$f":"'Reference Data'!O18","v":"Class 2/Year 4"},1,null,0,0,0,null,0.01,0.05,0.05]
[3,{"$f":"'Reference Data'!M19","v":"Class 3"},{"$f":"'Reference Data'!N19","v":"Year 4"},{"$f":"'Reference Data'!O19","v":"Class 3/Year 4"},1,null,0,0,0,null,0.01,0.05,0.05]
[4,{"$f":"'Reference Data'!M20","v":"Class 4"},{"$f":"'Reference Data'!N20","v":"Year 4"},{"$f":"'Reference Data'!O20","v":"Class 4/Year 4"},1,null,0,0,0,null,0.01,0.05,0.05]
[1,{"$f":"'Reference Data'!M21","v":"Class 1"},{"$f":"'Reference Data'!N21","v":"Year 5"},{"$f":"'Reference Data'!O21","v":"Class 1/Year 5"},1,null,0,0,0,null,0.01,0.03,0.03]
[2,{"$f":"'Reference Data'!M22","v":"Class 2"},{"$f":"'Reference Data'!N22","v":"Year 5"},{"$f":"'Reference Data'!O22","v":"Class 2/Year 5"},1,null,0,0,0,null,0.01,0.03,0.03]
[3,{"$f":"'Reference Data'!M23","v":"Class 3"},{"$f":"'Reference Data'!N23","v":"Year 5"},{"$f":"'Reference Data'!O23","v":"Class 3/Year 5"},1,null,0,0,0,null,0.01,0.03,0.03]
[4,{"$f":"'Reference Data'!M24","v":"Class 4"},{"$f":"'Reference Data'!N24","v":"Year 5"},{"$f":"'Reference Data'!O24","v":"Class 4/Year 5"},1,null,0,0,0,null,0.01,0.03,0.03]
[1,{"$f":"'Reference Data'!M25","v":"Class 1"},{"$f":"'Reference Data'!N25","v":"Year 6"},{"$f":"'Reference Data'!O25","v":"Class 1/Year 6"},1,null,0,0,0,null,0.01,0.03,0.03]
[2,{"$f":"'Reference Data'!M26","v":"Class 2"},{"$f":"'Reference Data'!N26","v":"Year 6"},{"$f":"'Reference Data'!O26","v":"Class 2/Year 6"},1,null,0,0,0,null,0.01,0.03,0.03]
[3,{"$f":"'Reference Data'!M27","v":"Class 3"},{"$f":"'Reference Data'!N27","v":"Year 6"},{"$f":"'Reference Data'!O27","v":"Class 3/Year 6"},1,null,0,0,0,null,0.01,0.03,0.03]
[4,{"$f":"'Reference Data'!M28","v":"Class 4"},{"$f":"'Reference Data'!N28","v":"Year 6"},{"$f":"'Reference Data'!O28","v":"Class 4/Year 6"},1,null,0,0,0,null,0.01,0.03,0.03]
[]
[null,null,null,null,null,"CHECK TOTALS =>>",{"$f":"SUM(G9,G13,G17,G21,G25,G29)","v":1},{"$f":"SUM(H9,H13,H17,H21,H25,H29)","v":1},{"$f":"SUM(I9,I13,I17,I21,I25,I29)","v":1}]
[null,null,null,null,null,"All should be 100%!!",1,1,1]
[null,null,null,null,null,null,1,1,1]
[null,null,null,null,null,null,1,1,{"$f":"SUM(I12,I16,I20,I24,I28,I32)","v":1}]
[]
[null,"6.1.2 Active"]
[null,null,null,null,null,null,null,"Initial Treatment Area as % of Infested By Year",null,null,null,"Yearly Treatment as % of Initial Cost"]
[null,"Land Classification","Year","Tag",{"$f":"E8","v":"% DSE Uplift"},null,"Minor","Moderate","Heavy",null,"Minor","Moderate","Heavy"]
[1,{"$f":"B9","v":"Class 1"},"Year 1","Class 1/Year 1",0.15,null,1,1,1,null,1,1,1]
[2,"Class 2","Year 1","Class 2/Year 1",0.15,null,1,1,1,null,1,1,1]
[3,"Class 3","Year 1","Class 3/Year 1",0.05,null,0.5,0.4,0.3,null,0.5,0.4,0.3]
[4,"Class 4","Year 1","Class 4/Year 1",0.05,null,0.5,0.4,0.3,null,0.5,0.4,0.3]
[1,"Class 1","Year 2","Class 1/Year 2",0.6,null,0,0,0,null,0.1,0.1,0.1]
[2,"Class 2","Year 2","Class 2/Year 2",0.6,null,0,0,0,null,0.1,0.1,0.1]
[3,"Class 3","Year 2","Class 3/Year 2",0.5,null,0.4,0.3,0.2,null,0.2,0.2,0.2]
[4,"Class 4","Year 2","Class 4/Year 2",0.5,null,0.4,0.3,0.2,null,0.2,0.2,0.2]
[1,"Class 1","Year 3","Class 1/Year 3",0.7,null,0,0,0,null,0.05,0.05,0.05]
[2,"Class 2","Year 3","Class 2/Year 3",0.7,null,0,0,0,null,0.05,0.05,0.05]
[3,"Class 3","Year 3","Class 3/Year 3",0.7,null,0.1,0.1,0.2,null,0.1,0.1,0.1]
[4,"Class 4","Year 3","Class 4/Year 3",0.7,null,0.1,0.1,0.2,null,0.1,0.1,0.1]
[1,"Class 1","Year 4","Class 1/Year 4",0.9,null,0,0,0,null,0.01,0.01,0.01]
[2,"Class 2","Year 4","Class 2/Year 4",0.9,null,0,0,0,null,0.01,0.01,0.01]
[3,"Class 3","Year 4","Class 3/Year 4",0.8,null,0,0.1,0.1,null,0.05,0.05,0.05]
[4,"Class 4","Year 4","Class 4/Year 4",0.8,null,0,0.1,0.2,null,0.05,0.05,0.05]
[1,"Class 1","Year 5","Class 1/Year 5",0.9,null,0,0,0,null,0.01,0.01,0.01]
[2,"Class 2","Year 5","Class 2/Year 5",0.9,null,0,0,0,null,0.01,0.01,0.01]
[3,"Class 3","Year 5","Class 3/Year 5",0.9,null,0,0.1,0.1,null,0.01,0.01,0.01]
[4,"Class 4","Year 5","Class 4/Year 5",0.9,null,0,0.1,0,null,0.01,0.05,0.05]
[1,"Class 1","Year 6","Class 1/Year 6",1,null,0,0,0,null,0.01,0.01,0.01]
[2,"Class 2","Year 6","Class 2/Year 6",1,null,0,0,0,null,0.01,0.01,0.01]
[3,"Class 3","Year 6","Class 3/Year 6",1,null,0,0,0.1,null,0.01,0.01,0.01]
[4,"Class 4","Year 6","Class 4/Year 6",1,null,0,0,0.1,null,0.01,0.05,0.05]
[]
[null,null,null,null,null,"CHECK TOTALS =>>",{"$f":"SUM(G42,G46,G50,G54,G58,G62)","v":1},1,1]
[null,null,null,null,null,"All should be 100%!!",{"$f":"SUM(G43,G47,G51,G55,G59,G63)","v":1},1,1]
[null,null,null,null,null,null,{"$f":"SUM(G44,G48,G52,G56,G60,G64)","v":1},0.99999999999999989,0.99999999999999989]
[null,null,null,null,null,null,{"$f":"SUM(G45,G49,G53,G57,G61,G65)","v":1},0.99999999999999989,{"$f":"SUM(I45,I49,I53,I57,I61,I65)","v":0.99999999999999989}]
[]
[null,"6.1.3 Passive"]
[null,null,null,null,null,null,null,"Initial Treatment Area as % of Infested By Year",null,null,null,"Yearly Treatment as % of Initial Cost"]
[null,"Land Classification","Year","Tag",{"$f":"E8","v":"% DSE Uplift"},null,"Minor","Moderate","Heavy",null,"Minor","Moderate","Heavy"]
[1,{"$f":"B9","v":"Class 1"},"Year 1","Class 1/Year 1",0.05,null,1,0.75,0.5,null,1,0.75,0.25]
[2,"Class 2","Year 1","Class 2/Year 1",0.05,null,0.5,0.25,0.25,null,0.5,0.25,0.25]
[3,"Class 3","Year 1","Class 3/Year 1",0,null,0,0,0,null,0,0,0]
[4,"Class 4","Year 1","Class 4/Year 1",0,null,0,0,0,null,0,0,0]
[1,"Class 1","Year 2","Class 1/Year 2",0.2,null,0,0.25,0.25,null,0.1,0.2,0.3]
[2,"Class 2","Year 2","Class 2/Year 2",0.2,null,0.25,0.25,0.25,null,0.1,0.2,0.3]
[3,"Class 3","Year 2","Class 3/Year 2",0.2,null,0.25,0.25,0.25,null,0.1,0.2,0.3]
[4,"Class 4","Year 2","Class 4/Year 2",0,null,0,0,0,null,0,0,0]
[1,"Class 1","Year 3","Class 1/Year 3",0.4,null,0,0,0.25,null,0.1,0.1,0.1]
[2,"Class 2","Year 3","Class 2/Year 3",0.4,null,0.25,0.25,0.25,null,0.1,0.1,0.1]
[3,"Class 3","Year 3","Class 3/Year 3",0.4,null,0.25,0.25,0.25,null,0.05,0.05,0.05]
[4,"Class 4","Year 3","Class 4/Year 3",0,null,0,0,0,null,0,0,0]
[1,"Class 1","Year 4","Class 1/Year 4",0.8,null,0,0,0,null,0.05,0.05,0.05]
[2,"Class 2","Year 4","Class 2/Year 4",0.8,null,0,0.25,0.25,null,0.05,0.05,0.05]
[3,"Class 3","Year 4","Class 3/Year 4",0.8,null,0.25,0.25,0.25,null,0.05,0.05,0.05]
[4,"Class 4","Year 4","Class 4/Year 4",0,null,0,0,0,null,0,0,0]
[1,"Class 1","Year 5","Class 1/Year 5",0.9,null,0,0,0,null,0.05,0.05,0.05]
[2,"Class 2","Year 5","Class 2/Year 5",0.9,null,0,0,0,null,0.05,0.05,0.05]
[3,"Class 3","Year 5","Class 3/Year 5",0.9,null,0.25,0.25,0.25,null,0.05,0.05,0.05]
[4,"Class 4","Year 5","Class 4/Year 5",0.1,null,0.5,0.5,0.5,null,0,0,0]
[1,"Class 1","Year 6","Class 1/Year 6",1,null,0,0,0,null,0.01,0.01,0.01]
[2,"Class 2","Year 6","Class 2/Year 6",1,null,0,0,0,null,0.01,0.01,0.01]
[3,"Class 3","Year 6","Class 3/Year 6",1,null,0,0,0,null,0.01,0.01,0.01]
[4,"Class 4","Year 6","Class 4/Year 6",0.5,null,0.5,0.5,0.5,null,0.2,0.2,0.2]
[]
[null,null,null,null,null,"CHECK TOTALS =>>",{"$f":"SUM(G75,G79,G83,G87,G91,G95)","v":1},1,1]
[null,null,null,null,null,"All should be 100%!!",{"$f":"SUM(G76,G80,G84,G88,G92,G96)","v":1},1,1]
[null,null,null,null,null,null,{"$f":"SUM(G77,G81,G85,G89,G93,G97)","v":1},1,1]
[null,null,null,null,null,null,{"$f":"SUM(G78,G82,G86,G90,G94,G98)","v":1},1,{"$f":"SUM(I78,I82,I86,I90,I94,I98)","v":1}]
["<< PREVIOUS",null,null,null,null,null,null,null,null,null,null,null,"NEXT >>"]

{"sheet":"Reference Data","index":8,"n_rows":33,"n_cols":30,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Reference Data",null,null,null,null,null,null,null,null,null,null,"Selected Treatment Regime Details"]
[null,null,null,null,null,"GROUND APPLICATION MULTIPLIERS",null,null,null,null,null,null,"Currently Selected:",{"$f":"Treatment_Regime_Selected","v":"Aggressive"},null,"Idx:",{"$f":"MATCH(N2,Treatment_Regimes,0)","v":1}]
[null,"Land Class",null,null,null,"Infestation Intensity","Treatment Multiplier","Labour Multiplier",null,null,null,null,null,null,null,null,null,null,"Initial Treatment Area as % of Infested By Year",null,null,null,"Yearly Treatment as % of Initial Cost",null,null,null,null,"LATER: Think about formatting…"]
[null,"Class 1",null,null,null,"(none)",0,0,null,null,null,null,"Land Classification","Year","Tag","% DSE Uplift",null,{"$f":"$F$5","v":"Minor"},{"$f":"$F$6","v":"Moderate"},{"$f":"$F$7","v":"Heavy"},null,{"$f":"$F$5","v":"Minor"},{"$f":"$F$6","v":"Moderate"},{"$f":"$F$7","v":"Heavy"}]
[null,"Class 2",null,null,null,"Minor",1,1,null,null,null,1,{"$f":"INDEX(Land_Class,L5)","v":"Class 1"},"Year 1",{"$f":"M5&\"/\"&N5","v":"Class 1/Year 1"},{"$f":"INDEX(Treatment_Regime_Areas,ROW()-ROW($M$5)+1,COLUMN()-COLUMN($M$5)+1,$Q$2)","v":0.25},null,{"$f":"INDEX(Treatment_Regime_Areas,ROW()-ROW($M$5)+1,COLUMN()-COLUMN($M$5)+1,$Q$2)","v":1},1,1,null,{"$f":"INDEX(Treatment_Regime_Areas,ROW()-ROW($M$5)+1,COLUMN()-COLUMN($M$5)+1,$Q$2)","v":1},1,1,null,null,null,null,"Property Name:","Test Property 1"]
[null,"Class 3",null,null,null,"Moderate",2,2,null,null,null,2,"Class 2","Year 1","Class 2/Year 1",0.25,null,1,1,1,null,1,1,1]
[null,"Class 4",null,null,null,"Heavy",3,4,null,null,null,3,"Class 3","Year 1","Class 3/Year 1",0.25,null,1,1,1,null,1,1,1,null,null,null,null,"Property Name:","Test Property 1"]
[null,null,null,null,null,null,null,null,null,null,null,4,"Class 4","Year 1","Class 4/Year 1",0.25,null,1,1,1,null,1,1,1]
[null,"Treatment Regimes",null,null,null,null,null,null,null,null,null,1,"Class 1","Year 2","Class 1/Year 2",0.6,null,0,0,0,null,0.1,0.2,0.3,null,null,null,null,null,"Test Property 1"]
[null,"Aggressive",null,null,null,null,null,null,null,null,null,2,"Class 2","Year 2","Class 2/Year 2",0.6,null,0,0,0,null,0.1,0.2,0.3]
[null,"Active",null,null,null,"Site Access","(spare)",null,null,null,null,3,"Class 3","Year 2","Class 3/Year 2",0.6,null,0,0,0,null,0.1,0.2,0.3,null,null,null,null,"Calculated Fields"]
[null,"Passive",null,null,null,"Good",null,null,null,null,null,4,"Class 4","Year 2","Class 4/Year 2",0.6,null,0,0,0,null,0.1,0.2,0.3]
[null,"(not used)",null,null,null,"Fair",null,null,null,null,null,1,"Class 1","Year 3","Class 1/Year 3",0.9,null,0,0,0,null,0.05,0.1,0.2,null,null,null,null,"Calculated Fields"]
[null,null,null,null,null,"Difficult",null,null,null,null,null,2,"Class 2","Year 3","Class 2/Year 3",0.9,null,0,0,0,null,0.05,0.1,0.2]
[null,null,null,null,null,null,null,null,null,null,null,3,"Class 3","Year 3","Class 3/Year 3",0.9,null,0,0,0,null,0.05,0.1,0.2]
[null,null,null,null,null,"AERIAL APPLICATION MULTIPLIERS",null,null,null,null,null,4,"Class 4","Year 3","Class 4/Year 3",0.9,null,0,0,0,null,0.05,0.1,0.2]
[null,null,null,null,null,"Infestation Intensity","Treatment Multiplier","Labour Multiplier",null,null,null,1,"Class 1","Year 4","Class 1/Year 4",1,null,0,0,0,null,0.01,0.05,0.05,null,null,null,null,"Property Name:","Test Property 1"]
[null,null,null,null,null,"(none)",null,null,null,null,null,2,"Class 2","Year 4","Class 2/Year 4",1,null,0,0,0,null,0.01,0.05,0.05]
[null,null,null,null,null,"Minor",null,null,null,null,null,3,"Class 3","Year 4","Class 3/Year 4",1,null,0,0,0,null,0.01,0.05,0.05,null,null,null,null,"Calculated Fields"]
[null,null,null,null,null,"Moderate",null,null,null,null,null,4,"Class 4","Year 4","Class 4/Year 4",1,null,0,0,0,null,0.01,0.05,0.05]
[null,null,null,null,null,"Heavy",null,null,null,null,null,1,"Class 1","Year 5","Class 1/Year 5",1,null,0,0,0,null,0.01,0.03,0.03]
[null,null,null,null,null,null,null,null,null,null,null,2,"Class 2","Year 5","Class 2/Year 5",1,null,0,0,0,null,0.01,0.03,0.03,null,null,null,{"$f":"IF('2. Land & Property'!H58='2. Land & Property'!D28,1,IF(ISBLANK('2. Land & Property'!D28),0,-1))","v":1},{"$f":"IF(AB22=-1,\"ERROR: This Total must match Property Total at \"&ADDRESS(ROW('2. Land & Property'!D28),COLUMN('2. Land & Property'!D28)),\"\")","v":""}]
[null,null,null,null,null,"Livestock Class",null,null,null,null,null,3,"Class 3","Year 5","Class 3/Year 5",1,null,0,0,0,null,0.01,0.03,0.03]
[null,null,null,null,null,"Livestock Class","DSE Equivalent","(spare)",null,null,null,4,"Class 4","Year 5","Class 4/Year 5",1,null,0,0,0,null,0.01,0.03,0.03]
[null,null,null,null,null,"CFA Cows",10,null,null,null,null,1,"Class 1","Year 6","Class 1/Year 6",1,null,0,0,0,null,0.01,0.03,0.03]
[null,null,null,null,null,"Cow & Calf Unit",15,null,null,null,null,2,"Class 2","Year 6","Class 2/Year 6",1,null,0,0,0,null,0.01,0.03,0.03]
[null,null,null,null,null,"Weaners",7,null,null,null,null,3,"Class 3","Year 6","Class 3/Year 6",1,null,0,0,0,null,0.01,0.03,0.03]
[null,null,null,null,null,"Steers",10,null,null,null,null,4,"Class 4","Year 6","Class 4/Year 6",1,null,0,0,0,null,0.01,0.03,0.03]
[null,null,null,null,null,"Heifers",9]
[null,null,null,null,null,"Bullocks",12,null,null,null,null,null,null,null,null,null,"CHECK TOTALS =>>",{"$f":"SUM(R5,R9,R13,R17,R21,R25)","v":1},1,1]
[null,null,null,null,null,"Bulls",16,null,null,null,null,null,null,null,null,null,"All should be 100%!!",1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1]

{"sheet":"Settings","index":9,"n_rows":52,"n_cols":21,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[null,"Application Settings",null,null,null,null,null,null,null,null,null,"Lookup Tables"]
[null,null,null,null,"(Default)"]
[null,null,"Name","Comment","Value",null,null,null,null,null,null,"GST Taxable Tags",null,null,null,null,null,null,null,"Dimension","Values"]
[null,null,"App_Version","Version number of the application","V1.0f2c",null,null,null,null,null,null,null,"Text Tag","Taxed",null,null,null,null,null,"Class of Land","Class 1, 2, 3 & 4 by %"]
[null,null,"App_Name","Defines the section or department  this timesheet is for.","Blackberry Weed Management - Agricultural Productivity Model",null,null,null,null,null,null,null,"AUS GST","Y",null,null,null,null,null,"% Infestation","% by Class of Land"]
[null,null,null,null,null,null,null,null,null,null,null,null,"No GST","N",null,null,null,null,null,"Intestation Intensity","Minor/Moderate/Heavy by Class of Land"]
[null,null,"App_Save_Enabled","Determines if User can normally Save the Application Workbook",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Control Method","Ground/Aerial by Class of Land"]
[null,null,"App_Startup_Worksheet","Worksheet to activate on Workbook Open","Main",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product Treatment","Chemicals (1 to 3) by Class of Land"]
[null,null,"App_Startup_Process","Name of Default Processing. Often used in initialising the Startup Worksheet and setting labels","GL",null,null,null,null,null,null,"GST Tax Types",null,null,null,null,null,null,null,null,"=> Products"]
[null,null,"Admin_Users","List of Usernames that can unprotect the Workbook","ROB-HP-PROBOOK-\\ROB,AZUREAD\\MICHAELREDFERN",null,null,null,null,null,null,null,"Text Tag","Debit","Credit",null,null,null,null,"Terrain","Flat/Moderate/Steep by Class of Land"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Access","Good/Fair/Difficult by Class of Land"]
[]
[null,null,"Connection_Auto_Connect","If TRUE, the App will automatically connect to the current database asap (generally via the Workbook_Open event). Other it will do it on demand when required to execute a requested function.","N"]
[null,null,"Connection_Enabled","Flags if database connection is enabled or not","N"]
[null,null,"Connection_DSN_Less","Flags if database connection is DSN less or not","Y"]
[null,null,"Connection_DNS_Name","Data Source Name (DSN) if not using DSN-less connection"]
[null,null,"Connection_Username","Database Username if using SQL Authentication (leave blank to use Windows Authentication)"]
[null,null,"Connection_Password","Database password if using SQL Authentication"]
[null,null,"Connection_Reset","Flags to reset connection every time a function is executed (good for testing or when changing connection details regularily)","N"]
[]
[null,null,"Debug_Enabled","Enable extra processing/logging for debugging purposes","N"]
[null,null,"Development_Enabled","Flags application is in development mode so some security and data protection is disabled","N"]
[]
[null,null,"DSE_Per_Cow","Factor to convert Dry Sheep Equivalent (DSE) to Cows",10]
[null,null,"Hectares_To_Acres","Factor to convert Hectares to Acres",{"$f":"1/0.404686","v":2.4710516301527603}]
[]
[null,null,"Worksheet_Pwd","Password used in protecting the worksheets","prpaw2019!"]
[]
[]
[null,"Persistant Application Values"]
[null,null,"Used to save application variables whose values can't be lost on an untrapped error or you want available next time you open the workbook"]
[null,null,"Name","Comment","Value"]
[]
[null,null,"Current_User_Domain","Network Domain name - used to detect change in Domain and prompt for confirm of Database Connection","ROB-HP-PROBOOK-"]
[]
[]
[]
[]
[null,"Excel Settings"]
[null,null,"Used to save settings on Application Open for later restore on close"]
[null,null,"Name","Comment","Value"]
[null,null,"Sample 1",null,true]
[]
[null,null,"XL_Environ_Initialised","XL_Environ_Initialised",false,"Indicates if the original XL values have been captured"]
[null,null,"XL_Orig_CellDragAndDrop","XL_Orig_CellDragAndDrop",true,"Original value of the Application.CellDragAndDrop property on the WB's open"]
[null,null,"XL_Orig_DisplayStatusBar","XL_Orig_DisplayStatusBar",true,"Original value of the Application.DisplayStatusBar property on the WB's open"]
[null,null,"XL_Orig_ErrorCheckingOptions.NumberAsText","XL_Orig_ErrorCheckingOptions.NumberAsText",true,"Original value of the Application.ShowSelectionFloaties property on the WB's open"]
[null,null,"XL_Orig_Ribbon_Minimised","XL_Orig_Ribbon_Minimised",false,"Original value of the Application.ShowSelectionFloaties property on the WB's open"]
[null,null,"XL_Orig_Ribbon_Visible","XL_Orig_Ribbon_Visible",true,"Original value of the Application.ShowSelectionFloaties property on the WB's open"]
[null,null,"XL_Orig_ShowSelectionFloaties","XL_Orig_ShowSelectionFloaties",true,"Original value of the Application.ShowSelectionFloaties property on the WB's open"]
[]
[null,null,"XL_Ribbon_Pointer","Temporary storage of pointer to IRibbonUI control.\nSaved here to void its lost as a variable when a VBA error occurs and resets all global variables."]

{"sheet":"Primary Treatment","index":10,"n_rows":68,"n_cols":9,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,0,1],[67,0,67,1]]}
["<< PREVIOUS",null,null,null,null,"Version:",{"$f":"Settings!App_Version","v":"V1.0f2c"},null,"NEXT >>"]
[]
[null,{"$f":"\"Victorian Blackberry Taskforce - \"&Settings!App_Name","v":"Victorian Blackberry Taskforce - Blackberry Weed Management - Agricultural Productivity Model"}]
[]
[null,{"$f":"Introduction!B24","v":"A 'cost  benefit' analysis tool for a livestock grazing operation, specific to chemical control costs and projected productivity benefit"}]
[]
[null,"Annual Output Summary Tables",null,null,null,null,null,"Treatment Regime:",{"$f":"Treatment_Regime_Selected","v":"Aggressive"}]
[]
[null,"Cost Year 1"]
[null,"Land Classification (%)","Primary Area Affected (ha)","Primary Treated Area (ha)","Maintenance (ha)","Cost Per ha","Total Cost (Primary & Maintenance)","Total Benefit","Differential"]
[null,"Class 1",{"$f":"'2. Land & Property'!M92+'2. Land & Property'!M93+'2. Land & Property'!M94","v":0},{"$f":"'2. Land & Property'!D117+'2. Land & Property'!E117+'2. Land & Property'!F117","v":0},{"$f":"'2. Land & Property'!D131+'2. Land & Property'!E131+'2. Land & Property'!F131","v":0},{"$f":"IF(SUM(D11+E11)=0,0,G11/(D11+E11))","v":0},{"$f":"'2. Land & Property'!D124+'2. Land & Property'!E124+'2. Land & Property'!F124+'2. Land & Property'!D139+'2. Land & Property'!E139+'2. Land & Property'!F139","v":0},{"$f":"'2. Land & Property'!D79","v":0},{"$f":"H11-G11","v":0}]
[null,"Class 2",{"$f":"'2. Land & Property'!M95+'2. Land & Property'!M96+'2. Land & Property'!M97","v":0},{"$f":"'2. Land & Property'!G117+'2. Land & Property'!H117+'2. Land & Property'!I117","v":0},{"$f":"'2. Land & Property'!G131+'2. Land & Property'!H131+'2. Land & Property'!I131","v":0},0,{"$f":"'2. Land & Property'!G124+'2. Land & Property'!H124+'2. Land & Property'!I124+'2. Land & Property'!G139+'2. Land & Property'!H139+'2. Land & Property'!I139","v":0},{"$f":"'2. Land & Property'!D80","v":0},{"$f":"H12-G12","v":0}]
[null,"Class 3",{"$f":"'2. Land & Property'!M98+'2. Land & Property'!M99+'2. Land & Property'!M100","v":0},{"$f":"'2. Land & Property'!J117+'2. Land & Property'!K117+'2. Land & Property'!L117","v":0},{"$f":"'2. Land & Property'!J131+'2. Land & Property'!K131+'2. Land & Property'!L131","v":0},0,{"$f":"'2. Land & Property'!J124+'2. Land & Property'!K124+'2. Land & Property'!L124+'2. Land & Property'!J139+'2. Land & Property'!K139+'2. Land & Property'!L139","v":0},{"$f":"'2. Land & Property'!D81","v":0},0]
[null,"Class 4",{"$f":"'2. Land & Property'!M101+'2. Land & Property'!M102+'2. Land & Property'!M103","v":0},{"$f":"'2. Land & Property'!M117+'2. Land & Property'!N117+'2. Land & Property'!O117","v":0},{"$f":"'2. Land & Property'!M131+'2. Land & Property'!N131+'2. Land & Property'!O131","v":0},0,{"$f":"'2. Land & Property'!M124+'2. Land & Property'!N124+'2. Land & Property'!O124+'2. Land & Property'!M139+'2. Land & Property'!N139+'2. Land & Property'!O139","v":0},{"$f":"'2. Land & Property'!D82","v":0},0]
[null,"Total",{"$f":"SUM(C11:C14)","v":0},{"$f":"SUM(D11:D14)","v":0},{"$f":"SUM(E11:E14)","v":0},null,{"$f":"SUM(G11:G14)","v":0},{"$f":"SUM(H11:H14)","v":0},{"$f":"H15-G15","v":0}]
[]
[null,"Percentage of Area Treated",null,{"$f":"IF(C15=0,0,D15/C15)","v":0},{"$f":"IF(C15=0,0,E15/C15)","v":0}]
[]
[]
[]
[null,"Cost Year 2"]
[null,"Land Classification (%)","Primary Area Affected (ha)","Primary Treated Area (ha)","Maintenance (ha)","Cost Per ha","Total Cost (Primary & Maintenance)","Total Benefit","Differential"]
[null,"Class 1",{"$f":"C11-D11","v":0},{"$f":"'2. Land & Property'!D118+'2. Land & Property'!E118+'2. Land & Property'!F118","v":0},{"$f":"'2. Land & Property'!D132+'2. Land & Property'!E132+'2. Land & Property'!F132","v":0},{"$f":"IF(SUM(D23+E23)=0,0,G23/(D23+E23))","v":0},{"$f":"'2. Land & Property'!D125+'2. Land & Property'!E125+'2. Land & Property'!F125+'2. Land & Property'!D140+'2. Land & Property'!E140+'2. Land & Property'!F140","v":0},{"$f":"'2. Land & Property'!E79","v":0},{"$f":"H23-G23","v":0}]
[null,"Class 2",{"$f":"C12-D12","v":0},{"$f":"'2. Land & Property'!G118+'2. Land & Property'!H118+'2. Land & Property'!I118","v":0},{"$f":"'2. Land & Property'!G132+'2. Land & Property'!H132+'2. Land & Property'!I132","v":0},0,{"$f":"'2. Land & Property'!G125+'2. Land & Property'!H125+'2. Land & Property'!I125+'2. Land & Property'!G140+'2. Land & Property'!H140+'2. Land & Property'!I140","v":0},{"$f":"'2. Land & Property'!E80","v":0},{"$f":"H24-G24","v":0}]
[null,"Class 3",{"$f":"C13-D13","v":0},{"$f":"'2. Land & Property'!J118+'2. Land & Property'!K118+'2. Land & Property'!L118","v":0},{"$f":"'2. Land & Property'!J132+'2. Land & Property'!K132+'2. Land & Property'!L132","v":0},0,{"$f":"'2. Land & Property'!J125+'2. Land & Property'!K125+'2. Land & Property'!L125+'2. Land & Property'!J140+'2. Land & Property'!K140+'2. Land & Property'!L140","v":0},{"$f":"'2. Land & Property'!E81","v":0},0]
[null,"Class 4",{"$f":"C14-D14","v":0},{"$f":"'2. Land & Property'!M118+'2. Land & Property'!N118+'2. Land & Property'!O118","v":0},{"$f":"'2. Land & Property'!M132+'2. Land & Property'!N132+'2. Land & Property'!O132","v":0},0,{"$f":"'2. Land & Property'!M125+'2. Land & Property'!N125+'2. Land & Property'!O125+'2. Land & Property'!M140+'2. Land & Property'!N140+'2. Land & Property'!O140","v":0},{"$f":"'2. Land & Property'!E82","v":0},0]
[null,"Total",{"$f":"SUM(C23:C26)","v":0},{"$f":"SUM(D23:D26)","v":0},{"$f":"SUM(E23:E26)","v":0},null,{"$f":"SUM(G23:G26)","v":0},{"$f":"SUM(H23:H26)","v":0},{"$f":"H27-G27","v":0}]
[]
[null,"Percentage of Area Treated",null,{"$f":"IF(C27=0,0,D27/C27)","v":0},{"$f":"IF(C27=0,0,E27/C27)","v":0}]
[]
[]
[]
[null,"Cost Year 3"]
[null,"Land Classification (%)","Primary Area Affected (ha)","Primary Treated Area (ha)","Maintenance (ha)","Cost Per ha","Total Cost (Primary & Maintenance)","Total Benefit","Differential"]
[null,"Class 1",{"$f":"C23-D23","v":0},{"$f":"'2. Land & Property'!D119+'2. Land & Property'!E119+'2. Land & Property'!F119","v":0},{"$f":"'2. Land & Property'!D133+'2. Land & Property'!E133+'2. Land & Property'!F133","v":0},{"$f":"IF(SUM(D35+E35)=0,0,G35/(D35+E35))","v":0},{"$f":"'2. Land & Property'!D126+'2. Land & Property'!E126+'2. Land & Property'!F126+'2. Land & Property'!D141+'2. Land & Property'!E141+'2. Land & Property'!F141","v":0},{"$f":"'2. Land & Property'!F81","v":0},{"$f":"H35-G35","v":0}]
[null,"Class 2",{"$f":"C24-D24","v":0},{"$f":"'2. Land & Property'!G119+'2. Land & Property'!H119+'2. Land & Property'!I119","v":0},{"$f":"'2. Land & Property'!G133+'2. Land & Property'!H133+'2. Land & Property'!I133","v":0},0,{"$f":"'2. Land & Property'!G126+'2. Land & Property'!H126+'2. Land & Property'!I126+'2. Land & Property'!G141+'2. Land & Property'!H141+'2. Land & Property'!I141","v":0},{"$f":"'2. Land & Property'!F80","v":0},{"$f":"H36-G36","v":0}]
[null,"Class 3",{"$f":"C25-D25","v":0},{"$f":"'2. Land & Property'!J119+'2. Land & Property'!K119+'2. Land & Property'!L119","v":0},{"$f":"'2. Land & Property'!J133+'2. Land & Property'!K133+'2. Land & Property'!L133","v":0},0,{"$f":"'2. Land & Property'!J126+'2. Land & Property'!K126+'2. Land & Property'!L126+'2. Land & Property'!J141+'2. Land & Property'!K141+'2. Land & Property'!L141","v":0},{"$f":"'2. Land & Property'!F81","v":0},0]
[null,"Class 4",{"$f":"C26-D26","v":0},{"$f":"'2. Land & Property'!M119+'2. Land & Property'!N119+'2. Land & Property'!O119","v":0},{"$f":"'2. Land & Property'!M133+'2. Land & Property'!N133+'2. Land & Property'!O133","v":0},0,{"$f":"'2. Land & Property'!M126+'2. Land & Property'!N126+'2. Land & Property'!M141+'2. Land & Property'!N141+'2. Land & Property'!O141","v":0},{"$f":"'2. Land & Property'!F82","v":0},0]
[null,"Total",{"$f":"SUM(C35:C38)","v":0},{"$f":"SUM(D35:D38)","v":0},{"$f":"SUM(E35:E38)","v":0},null,{"$f":"SUM(G35:G38)","v":0},{"$f":"SUM(H35:H38)","v":0},{"$f":"H39-G39","v":0}]
[]
[null,"Percentage of Area Treated",null,{"$f":"IF(C39=0,0,D39/C39)","v":0},{"$f":"IF(C39=0,0,E39/C39)","v":0}]
[]
[]
[]
[null,"Cost Year 4"]
[null,"Land Classification (%)","Primary Area Affected (ha)","Primary Treated Area (ha)","Maintenance (ha)","Cost Per ha","Total Cost (Primary & Maintenance)","Total Benefit","Differential"]
[null,"Class 1",{"$f":"C35-D35","v":0},{"$f":"'2. Land & Property'!D120+'2. Land & Property'!E120+'2. Land & Property'!F120","v":0},{"$f":"'2. Land & Property'!D135+'2. Land & Property'!E135+'2. Land & Property'!F135","v":0},{"$f":"IF(SUM(D47+E47)=0,0,G47/(D47+E47))","v":0},{"$f":"'2. Land & Property'!D127+'2. Land & Property'!E127+'2. Land & Property'!F127+'2. Land & Property'!D142+'2. Land & Property'!E142+'2. Land & Property'!F142","v":0},{"$f":"'2. Land & Property'!G79","v":0},{"$f":"H47-G47","v":0}]
[null,"Class 2",{"$f":"C36-D36","v":0},{"$f":"'2. Land & Property'!G120+'2. Land & Property'!H120+'2. Land & Property'!I120","v":0},{"$f":"'2. Land & Property'!G134+'2. Land & Property'!H134+'2. Land & Property'!I134","v":0},0,{"$f":"'2. Land & Property'!G127+'2. Land & Property'!H127+'2. Land & Property'!I127+'2. Land & Property'!G142+'2. Land & Property'!H142+'2. Land & Property'!I142","v":0},{"$f":"'2. Land & Property'!G80","v":0},{"$f":"H48-G48","v":0}]
[null,"Class 3",0,{"$f":"'2. Land & Property'!J120+'2. Land & Property'!K120+'2. Land & Property'!L120","v":0},{"$f":"'2. Land & Property'!J134+'2. Land & Property'!K134+'2. Land & Property'!L134","v":0},0,{"$f":"'2. Land & Property'!J127+'2. Land & Property'!K127+'2. Land & Property'!L127+'2. Land & Property'!J142+'2. Land & Property'!K142+'2. Land & Property'!L142","v":0},{"$f":"'2. Land & Property'!G81","v":0},0]
[null,"Class 4",0,{"$f":"'2. Land & Property'!M120+'2. Land & Property'!N120+'2. Land & Property'!O120","v":0},{"$f":"'2. Land & Property'!M134+'2. Land & Property'!N134+'2. Land & Property'!O134","v":0},0,{"$f":"'2. Land & Property'!M127+'2. Land & Property'!N127+'2. Land & Property'!O127+'2. Land & Property'!M142+'2. Land & Property'!N142+'2. Land & Property'!O142","v":0},{"$f":"'2. Land & Property'!G82","v":0},0]
[null,"Total",{"$f":"SUM(C47:C50)","v":0},{"$f":"SUM(D47:D50)","v":0},{"$f":"SUM(E47:E50)","v":0},null,{"$f":"SUM(G47:G50)","v":0},{"$f":"SUM(H47:H50)","v":0},{"$f":"H51-G51","v":0}]
[]
[null,"Percentage of Area Treated",null,{"$f":"IF(C51=0,0,D51/C51)","v":0},{"$f":"IF(C51=0,0,E51/C51)","v":0}]
[]
[]
[]
[null,"Cost Year 5"]
[null,"Land Classification (%)","Primary Area Affected (ha)","Primary Treated Area (ha)","Maintenance (ha)","Cost Per ha","Total Cost (Primary & Maintenance)","Total Benefit","Differential"]
[null,"Class 1",{"$f":"C47-D47","v":0},{"$f":"'2. Land & Property'!D121+'2. Land & Property'!E121+'2. Land & Property'!F121","v":0},{"$f":"'2. Land & Property'!D135+'2. Land & Property'!E135+'2. Land & Property'!F135","v":0},{"$f":"IF(SUM(D59+E59)=0,0,G59/(D59+E59))","v":0},{"$f":"'2. Land & Property'!D128+'2. Land & Property'!E128+'2. Land & Property'!F128+'2. Land & Property'!D143+'2. Land & Property'!E143+'2. Land & Property'!F143","v":0},{"$f":"'2. Land & Property'!I79","v":0},{"$f":"H59-G59","v":0}]
[null,"Class 2",{"$f":"C48-D48","v":0},{"$f":"'2. Land & Property'!G121+'2. Land & Property'!H121+'2. Land & Property'!I121","v":0},{"$f":"'2. Land & Property'!G135+'2. Land & Property'!H135+'2. Land & Property'!I135","v":0},0,{"$f":"'2. Land & Property'!G128+'2. Land & Property'!H128+'2. Land & Property'!I128+'2. Land & Property'!G143+'2. Land & Property'!H143+'2. Land & Property'!I143","v":0},{"$f":"'2. Land & Property'!I80","v":0},{"$f":"H60-G60","v":0}]
[null,"Class 3",0,{"$f":"'2. Land & Property'!J121+'2. Land & Property'!K121+'2. Land & Property'!L121","v":0},{"$f":"'2. Land & Property'!J135+'2. Land & Property'!K135+'2. Land & Property'!L135","v":0},0,{"$f":"'2. Land & Property'!J128+'2. Land & Property'!K128+'2. Land & Property'!L128+'2. Land & Property'!J143+'2. Land & Property'!K143+'2. Land & Property'!L143","v":0},{"$f":"'2. Land & Property'!I81","v":0},0]
[null,"Class 4",0,{"$f":"'2. Land & Property'!M121+'2. Land & Property'!N121+'2. Land & Property'!O121","v":0},{"$f":"'2. Land & Property'!M135+'2. Land & Property'!N135+'2. Land & Property'!O135","v":0},0,{"$f":"'2. Land & Property'!M128+'2. Land & Property'!N128+'2. Land & Property'!O128+'2. Land & Property'!M143+'2. Land & Property'!N143+'2. Land & Property'!O143","v":0},{"$f":"'2. Land & Property'!I82","v":0},0]
[null,"Total",{"$f":"SUM(C59:C62)","v":0},{"$f":"SUM(D59:D62)","v":0},{"$f":"SUM(E59:E62)","v":0},null,{"$f":"SUM(G59:G62)","v":0},{"$f":"SUM(H59:H62)","v":0},{"$f":"H63-G63","v":0}]
[]
[null,"Percentage of Area Treated",null,{"$f":"IF(C63=0,0,D63/C63)","v":0},{"$f":"IF(C63=0,0,E63/C63)","v":0}]
[]
[]
["<< PREVIOUS",null,null,null,null,null,null,null,"NEXT >>"]

{"sheet":"5 year Cost Benefit Graph","index":11,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,1,2,13],[0,0,0,1],[38,0,38,1]]}
["<< PREVIOUS",null,null,null,null,null,null,null,null,null,"Version:",{"$f":"Settings!App_Version","v":"V1.0f2c"},"NEXT >>"]
[]
[null,{"$f":"\"Victorian Blackberry Taskforce - \"&Settings!App_Name","v":"Victorian Blackberry Taskforce - Blackberry Weed Management - Agricultural Productivity Model"}]
[]
[null,{"$f":"Introduction!B24","v":"A 'cost  benefit' analysis tool for a livestock grazing operation, specific to chemical control costs and projected productivity benefit"}]
[]
[null,"Cost Benefit Graph - Five year program"]
[]
[]
[null,"Treatment Regime:",null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,{"$f":"Treatment_Regime_Selected","v":"Aggressive"},null,"Cost",{"$f":"'Primary Treatment'!$G$15","v":0},{"$f":"'Primary Treatment'!$G$27","v":0},{"$f":"'Primary Treatment'!$G$39","v":0},{"$f":"'Primary Treatment'!$G$51","v":0},{"$f":"'Primary Treatment'!$G$63","v":0}]
[null,null,null,"Benefit ",{"$f":"'Primary Treatment'!$H$15","v":0},{"$f":"'Primary Treatment'!$H$27","v":0},{"$f":"'Primary Treatment'!$H$39","v":0},{"$f":"'Primary Treatment'!$H$51","v":0},{"$f":"'Primary Treatment'!$H$63","v":0}]
[null,null,null,"Net*",{"$f":"E12-E11","v":0},0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["<< PREVIOUS",null,null,null,null,null,null,null,null,null,null,null,"NEXT >>"]

{"sheet":"5 year cumulative","index":12,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[2,1,2,14],[0,0,0,1],[60,0,60,1]]}
["<< PREVIOUS",null,null,null,null,null,null,null,null,null,"Version:",{"$f":"Settings!App_Version","v":"V1.0f2c"}]
[]
[null,{"$f":"\"Victorian Blackberry Taskforce - \"&Settings!App_Name","v":"Victorian Blackberry Taskforce - Blackberry Weed Management - Agricultural Productivity Model"}]
[]
[null,{"$f":"Introduction!B24","v":"A 'cost  benefit' analysis tool for a livestock grazing operation, specific to chemical control costs and projected productivity benefit"}]
[]
[null,"Cost Benefit Graph - Five year program (cumulative)"]
[]
[null,"Treatment Regime:",null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,{"$f":"Treatment_Regime_Selected","v":"Aggressive"},null,"Cost",{"$f":"'Primary Treatment'!$G$15","v":0},{"$f":"'Primary Treatment'!$G$27","v":0},{"$f":"'Primary Treatment'!$G$39","v":0},{"$f":"'Primary Treatment'!$G$51","v":0},{"$f":"'Primary Treatment'!$G$63","v":0}]
[null,null,null,"Cumulative Cost",{"$f":"E10","v":0},{"$f":"SUM(E11,F10)","v":0},0,0,0]
[null,null,null,"Benefit ",{"$f":"'Primary Treatment'!$H$15","v":0},{"$f":"'Primary Treatment'!$H$27","v":0},{"$f":"'Primary Treatment'!$H$39","v":0},{"$f":"'Primary Treatment'!$H$51","v":0},{"$f":"'Primary Treatment'!$H$63","v":0}]
[null,null,null,"Cumulative Benefit",{"$f":"E12","v":0},{"$f":"SUM(E13,F12)","v":0},{"$f":"SUM(F13,G12)","v":0},{"$f":"SUM(G13,H12)","v":0},{"$f":"SUM(H13,I12)","v":0}]
[null,null,null,"Net (by Year)*",{"$f":"E12-E10","v":0},0,0,0,0]
[null,null,null,"Cumulative Net*",{"$f":"E13-E11","v":0},{"$f":"F13-F11","v":0},0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["<< PREVIOUS"]

{"sheet":"5 year per hectare benefit","index":13,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":true,"merged":[[2,1,2,14],[0,0,0,1],[39,0,39,1]]}
["<< PREVIOUS",null,null,null,null,null,null,null,null,null,null,null,"Version:",{"$f":"Settings!App_Version","v":"V1.0f2c"}]
[]
[null,{"$f":"\"Victorian Blackberry Taskforce - \"&Settings!App_Name","v":"Victorian Blackberry Taskforce - Blackberry Weed Management - Agricultural Productivity Model"}]
[]
[null,{"$f":"Introduction!B24","v":"A 'cost  benefit' analysis tool for a livestock grazing operation, specific to chemical control costs and projected productivity benefit"}]
[]
[null,"Cost Benefit Graph - Nominal dollar cost - Five year program"]
[]
[null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"Cost per hectare",{"$f":"#REF!/'2. Land & Property'!$D$28","v":{"$error":"#REF!"}},{"$f":"#REF!/'2. Land & Property'!$D$28","v":{"$error":"#REF!"}},{"$f":"#REF!/'2. Land & Property'!$D$28","v":{"$error":"#REF!"}},{"$f":"#REF!/'2. Land & Property'!$D$28","v":{"$error":"#REF!"}},{"$f":"#REF!/'2. Land & Property'!$D$28","v":{"$error":"#REF!"}}]
[null,"Benefit per hectare",{"$f":"#REF!/'2. Land & Property'!$D$28","v":{"$error":"#REF!"}},{"$f":"#REF!/'2. Land & Property'!$D$28","v":{"$error":"#REF!"}},{"$f":"#REF!/'2. Land & Property'!$D$28","v":{"$error":"#REF!"}},{"$f":"#REF!/'2. Land & Property'!$D$28","v":{"$error":"#REF!"}},{"$f":"#REF!/'2. Land & Property'!$D$28","v":{"$error":"#REF!"}}]
[null,"Loss/benefit",{"$f":"C11-C10","v":{"$error":"#REF!"}},{"$f":"D11-D10","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["<< PREVIOUS"]