{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Sheet1","Start","Input Data Confidence","Cover Sheet","Results Chain","Investment Data Entry","Global Market Data Entry","Market Share Data Entry","Operations Data Entry","Other Impact Data Entry","Competitive Environment","Investment Sensitivity","Projection Sensitivity","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":8,"comments":1,"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":"Sheet1","index":0,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Terms & Conditions"]
["With the exception of MLAs logo and any material protected by a trade mark, this material is available for use under Creative Commons Attribution 4.0 Australia CC Licence: CC-BY-SA 4.0 © Meat & Livestock Australia"]
[]
["Disclaimer: Care has been taken to ensure the accuracy of the information contained in this tool. However, MLA does not accept responsibility for the accuracy, currency or completeness of the information provided when using this tool. MLA make no representations about the suitability or validity of this tool for commercial use. This tool is intended to provide general information only and it has been prepared without taking into account your specific circumstances, objectives, or needs. You should make your own enquiries before making decisions concerning your interests. Your use of, or reliance on this tool is entirely at your own risk and MLA accepts no liability for any losses or damages incurred by you as a result of that use or reliance."]

{"sheet":"Start","index":1,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Results Chain Model"]
[]
[null,"Full Edition"]
[null,null,"The Full Edition of the RESULTS CHAIN MODEL allows users to set assumptions data in the PROJECTION tabsheet.\nThis information sets the base for the Model projections and includes commercially sensitive information provided by the MLA Partner.\nTHIS VERSION IS ONLY AVAILABLE TO PROJECT PARTNERS AS IT CONTAINS COMMERCIAL INFORMATION"]
[null,null,"To Access the RESULTS CHAIN click here"]
[null,null,"To Access the INVESTMENT Data Entry click here"]
[null,null,"To Access the GLOBAL MARKET Data Entry click here"]
[null,null,"To Access the MARKET SHARE Data Entry click here"]
[null,null,"To Access the OPERATIONS Data Entry click here"]
[null,null,"To Access the OTHER IMPACT Data Entry click here"]
[null,null,"To Access the SENSITIVITY Parameters click here"]
[null,null,"To Access Comments on COMPETITIVE ENVIRONMENT click here"]
[null,null,"To Access Input Data Confidence Results click here"]
[]
[]
[null,"Limited Edition"]
[null,null,"The Limited Edition of the Results Chain Model provides an opportunity to conduct a Sensitivity analysis based on certain parameters and provides comparison between the Base line projection and the results when the sensitivity factors are entered. The Sensitivity sheet also provides output of the input data that has been changed as a result of the Sensitivity Inputs"]
[null,null,"To Access the RESULTS CHAIN click here"]
[null,null,"To Access the SENSITIVITY Parameters click here"]
[null,null,"To Access Comments on COMPETITIVE ENVIRONMENT click here"]

{"sheet":"Input Data Confidence","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,2,3,3],[13,2,13,3]]}
[]
[]
[]
[null,null,"INPUT DATA CONFIDENCE LEVELS"]
[null,null,"Investment Data Entry",{"$f":"'Investment Data Entry'!N29","v":0}]
[null,null,"Global Market Data Entry",{"$f":"'Global Market Data Entry'!N19","v":0}]
[null,null,"Market Share Data Entry",{"$f":"'Market Share Data Entry'!N33","v":0}]
[null,null,"Operations Data Entry",{"$f":"'Operations Data Entry'!N14","v":0}]
[null,null,"Other Impact Data Entry",{"$f":"'Other Impact Data Entry'!N15","v":0}]
[null,null,"OVERALL CONFIDENCE LEVEL",{"$f":"AVERAGE(D5:D9)","v":0}]
[null,null,"\"Note: 5 = high confidence, 1 = low confidence\""]
[]
[]
[null,null,"RETURN TO \"START\" CLICK HERE"]

{"sheet":"Cover Sheet","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"RESULTS CHAIN ANALYSIS"]
[]
[null,null,null,null,null,null,"Project Cover Sheet"]

{"sheet":"Results Chain","index":4,"n_rows":2,"n_cols":19,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,18,1,24]]}
[]
["Project Title:","RCA Example – Value Adding Animal Products ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURN TO \"START\" CLICK HERE"]

{"sheet":"Investment Data Entry","index":5,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,1,3,3],[4,1,9,1],[10,1,15,1],[16,1,21,1],[22,1,27,1]]}
[null,"Investment Data Entry Assumptions"]
[]
[null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6-10","Year 11-15"]
[null,null,null,null,"Actual","Actual","Forecast","Forecast","Forecast","Forecast","Forecast",null,"COMMENTS","CONFIDENCE LEVEL"]
[null,"Innovation Investment","MLA","Accountable",200000,null,null,null,null,null,null,null,"MLA invests directly in technology proving","Enter From List",{"$f":"IF(N5=\"very confident\",5,IF(N5=\"Moderately Confident\",4,IF(N5=\"somewhat confident\",3,IF(N5=\"less than confident\",2,IF(N5=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"In-kind",20000,null,null,null,null,null,null,null,"MLA provides in-kind support through the provision of business and market information","Enter From List",{"$f":"IF(N6=\"very confident\",5,IF(N6=\"Moderately Confident\",4,IF(N6=\"somewhat confident\",3,IF(N6=\"less than confident\",2,IF(N6=\"not confident at all\",1,0)))))","v":0}]
[null,null,"Research Partner","Accountable",200000,null,null,null,null,null,null,null,"Research partner co-invests in technology, business development and market development","Enter From List",0]
[null,null,null,"In-kind",100000,null,null,null,null,null,null,null,"Partner provides in-kind support for the technology and business development process","Enter From List",0]
[null,null,"Third Party","Accountable",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,null,null,"In-kind",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,"Capital Investment","MLA","Accountable",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,null,null,"In-kind",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,null,"Research Partner","Accountable",null,1000000,null,null,null,null,null,null,"Research Partner Invests","Enter From List",0]
[null,null,null,"In-kind",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,null,"Third Party","Accountable",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,null,null,"In-kind",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,"Business Development Investment","MLA","Accountable",null,20000,20000,null,null,null,null,null,"MLA invests in business development","Enter From List",0]
[null,null,null,"In-kind",null,null,null,null,null,null,null,null,"MLA provides in-kind support for business development","Enter From List",0]
[null,null,"Research Partner","Accountable",null,20000,20000,null,null,null,null,null,null,"Enter From List",0]
[null,null,null,"In-kind",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,null,"Third Party","Accountable",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,null,null,"In-kind",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,"Market Development Investment","MLA","Accountable",null,20000,20000,null,null,null,null,null,"MLA invests in market development","Enter From List",0]
[null,null,null,"In-kind",null,null,null,null,null,null,null,null,"MLA provides in-kind support for market development","Enter From List",0]
[null,null,"Research Partner","Accountable",null,50000,50000,null,null,null,null,null,null,"Enter From List",0]
[null,null,null,"In-kind",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,null,"Third Party","Accountable",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,null,null,"In-kind",null,null,null,null,null,null,null,null,null,"Enter From List",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"AVERAGE CONFIDENCE LEVEL",{"$f":"AVERAGE(O5:O28)","v":0}]
[null,"RETURN TO \"START\" CLICK HERE"]

{"sheet":"Global Market Data Entry","index":6,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,1,3,3],[4,1,17,1],[4,2,7,2],[8,2,11,2],[12,2,14,2],[15,2,17,2]]}
[null,"Global Market Data Entry Assumptions"]
[]
[null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6-10","Year 11-15",null,"COMMENTS/ASSUMPTIONS","CONFIDENCE LEVEL"]
[null,null,null,null,"Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast",null,"Is data actual or forecast - should be updated annually"]
[null,"MARKET PROJECTIONS","Global Market Volumes","Product 1",null,null,null,null,null,null,null," (Tonne/annum)","Global market for product 1 derived from ********","Enter From List",{"$f":"IF(N5=\"very confident\",5,IF(N5=\"Moderately Confident\",4,IF(N5=\"somewhat confident\",3,IF(N5=\"less than confident\",2,IF(N5=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Product 2",null,null,null,null,null,null,null," (Tonne/annum)","Global market for product 2 derived from ******** ","Enter From List",{"$f":"IF(N6=\"very confident\",5,IF(N6=\"Moderately Confident\",4,IF(N6=\"somewhat confident\",3,IF(N6=\"less than confident\",2,IF(N6=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Product 3",null,null,null,null,null,null,null," (Tonne/annum)","Global market for product 3  derived from ********","Enter From List",0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,"Domestic Market Volumes","Product 1",110000,110000,110000,110000,110000,110000,110000," (Tonne/annum)","Domestic market for product 1 derived from ********","Enter From List",0]
[null,null,null,"Product 2",null,null,null,null,null,null,null," (Tonne/annum)","Domestic  market for product 2  derived from ******** ","Enter From List",0]
[null,null,null,"Product 3",null,null,null,null,null,null,null," (Tonne/annum)","Domestic market for product 3  derived from ********","Enter From List",0]
[]
[null,null,"Global Market Price \n(ex Factory)","Product 1",12,12.25,12.5,12.75,13,13.25,13.5,"$A/kg","Global market trade price projections from ********","Enter From List",0]
[null,null,null,"Product 2",null,null,null,null,null,null,null,"$A/kg","Global market trade price projections from ********","Enter From List",0]
[null,null,null,"Product 3",null,null,null,null,null,null,null,"$A/kg","Global market trade price projections from ********","Enter From List",0]
[null,null,"Domestic Market Price \n(Ex Factory)","Product 1",13,13.25,13.5,13.75,14,14.25,14.5,"$A/kg","Domestic market trade price projections from ********","Enter From List",0]
[null,null,null,"Product 2",null,null,null,null,null,null,null,"$A/kg","Domestic market trade price projections from ********","Enter From List",0]
[null,null,null,"Product 3",null,null,null,null,null,null,null,"$A/kg","Domestic market trade price projections from ********","Enter From List",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"AVERAGE CONFIDENCE LEVEL",{"$f":"AVERAGE(O5:O7,O9:O11,O13:O18)","v":0}]
[null,null,"RETURN TO \"START\" CLICK HERE"]

{"sheet":"Market Share Data Entry","index":7,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,1,3,3],[4,1,10,1],[12,1,13,3],[14,2,17,2],[18,2,20,2],[14,1,31,1],[4,2,6,2],[7,2,9,2],[21,2,26,2],[27,2,31,2]]}
[null,"Market Share Data Entry Assumptions"]
[]
[null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6-10","Year 11-15",null,"COMMENTS/ASSUMPTIONS","CONFIDENCE LEVEL"]
[null,null,null,null,"Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast",null,"Is data actual or forecast - should be updated annually"]
[null,"MARKET SHARE PROJECTIONS","% of Production Supplied to Global Market","Product 1",0.2,0.25,0.3,0.35,0.4,0.45,0.5,"%","Percent of production supplied into global market by partner","Enter From List",{"$f":"IF(N5=\"very confident\",5,IF(N5=\"Moderately Confident\",4,IF(N5=\"somewhat confident\",3,IF(N5=\"less than confident\",2,IF(N5=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Product 2",null,null,null,null,null,null,null,"%","Percent of production supplied into global market by partner","Enter From List",{"$f":"IF(N6=\"very confident\",5,IF(N6=\"Moderately Confident\",4,IF(N6=\"somewhat confident\",3,IF(N6=\"less than confident\",2,IF(N6=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Product 3",null,null,null,null,null,null,null,"%","Percent of production supplied into global market by partner","Enter From List",0]
[null,null,"% of Production Supplied to DomesticMarket","Product 1",0.8,0.75,0.7,0.65,0.6,0.55000000000000004,0.5,"%","Percent of production supplied into domestic market by partner","Enter From List",0]
[null,null,null,"Product 2",null,null,null,null,null,null,null,"%","Percent of production supplied into domestic market by partner","Enter From List",0]
[null,null,null,"Product 3",null,null,null,null,null,null,null,"%","Percent of production supplied into domestic market by partner","Enter From List",0]
[null,null,null,null,{"$f":"SUM(E5:E10)","v":1},{"$f":"SUM(F5:F10)","v":1},1,1,1,1,1,null,"TOTAL MUST EQUAL 100%"]
[]
[null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6-10","Year 11-15",null,"COMMENTS/ASSUMPTIONS"]
[null,null,null,null,"Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast",null,"Is data actual or forecast - should be updated annually"]
[null,"RAW MATERIAL PROJECTIONS","Production Projection","Product 1",200,500,600,700,800,900,1000," (Tonne/annum)","Production Projection - Tonnes/annum","Enter From List",{"$f":"IF(N15=\"very confident\",5,IF(N15=\"Moderately Confident\",4,IF(N15=\"somewhat confident\",3,IF(N15=\"less than confident\",2,IF(N15=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Product 2",null,null,null,null,null,null,null," (Tonne/annum)","Production Projection - Tonnes/annum","Enter From List",{"$f":"IF(N16=\"very confident\",5,IF(N16=\"Moderately Confident\",4,IF(N16=\"somewhat confident\",3,IF(N16=\"less than confident\",2,IF(N16=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Product 3",null,null,null,null,null,null,null," (Tonne/annum)","Production Projection - Tonnes/annum","Enter From List",0]
[null,null,null,null,{"$f":"SUM(E15:E17)","v":200},500,600,700,800,900,1000," (Tonne/annum)"]
[null,null,"Final Product/Animal Product (%)","Product 1",1.66,1.66,1.66,1.66,1.66,1.66,1.66,"%","% will be <100% if product is an animal product extractive & >100% if product contains animal product as an ingredient","Enter From List",{"$f":"IF(N19=\"very confident\",5,IF(N19=\"Moderately Confident\",4,IF(N19=\"somewhat confident\",3,IF(N19=\"less than confident\",2,IF(N19=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Product 2",null,null,null,null,null,null,null,"%","% will be <100% if product is an animal product extractive & >100% if product contains animal product as an ingredient","Enter From List",{"$f":"IF(N20=\"very confident\",5,IF(N20=\"Moderately Confident\",4,IF(N20=\"somewhat confident\",3,IF(N20=\"less than confident\",2,IF(N20=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Product 3",null,null,null,null,null,null,null,"%","% will be <100% if product is an animal product extractive & >100% if product contains animal product as an ingredient","Enter From List",0]
[null,null,"Meat Product Supply Percent","Premium Primal",null,null,null,null,null,null,null,"%","% of animal product in raw material mix  - based on ___________","Enter From List",0]
[null,null,null,"Secondary Primal",1,1,1,1,1,1,1,"%","% of animal product in raw material mix  - based on ___________","Enter From List",0]
[null,null,null,"Manufacturing",null,null,null,null,null,null,null,"%","% of animal product in raw material mix  - based on ___________","Enter From List",0]
[null,null,null,"Offal",null,null,null,null,null,null,null,"%","% of animal product in raw material mix  - based on ___________","Enter From List",0]
[null,null,null,"Other",null,null,null,null,null,null,null,"%","% of animal product in raw material mix  - based on ___________","Enter From List",0]
[null,null,null,"TOTAL",{"$f":"SUM(E22:E26)","v":1},{"$f":"SUM(F22:F26)","v":1},1,1,1,1,1,"%","TOTAL MUST EQUAL 100%"]
[null,null,"Meat Product Supply Price","Premium Primal",null,null,null,null,null,null,null,"$A/kg","Expected price paid for animal product - based on ___________","Enter From List",{"$f":"IF(N28=\"very confident\",5,IF(N28=\"Moderately Confident\",4,IF(N28=\"somewhat confident\",3,IF(N28=\"less than confident\",2,IF(N28=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Secondary Primal",7.5,7.6,7.7,7.8,7.9,8,8.1,"$A/kg","Expected price paid for animal product - based on ___________","Enter From List",{"$f":"IF(N29=\"very confident\",5,IF(N29=\"Moderately Confident\",4,IF(N29=\"somewhat confident\",3,IF(N29=\"less than confident\",2,IF(N29=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Manufacturing",null,null,null,null,null,null,null,"$A/kg","Expected price paid for animal product - based on ___________","Enter From List",0]
[null,null,null,"Offal",null,null,null,null,null,null,null,"$A/kg","Expected price paid for animal product - based on ___________","Enter From List",0]
[null,null,null,"Other",null,null,null,null,null,null,null,"$A/kg","Expected price paid for animal product - based on ___________","Enter From List",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"AVERAGE CONFIDENCE LEVEL",{"$f":"AVERAGE(O5:O10,O15:O17,O19:O26,O28:O32)","v":0}]
[null,null,"RETURN TO \"START\" CLICK HERE"]

{"sheet":"Operations Data Entry","index":8,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,1,12,1],[4,2,9,2],[10,2,12,2]]}
[null,"Operations Data Entry"]
[]
[null,"ASSUMPTIONS",null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6-10","Year 11-15",null,"COMMENTS/ASSUMPTIONS","CONFIDENCE LEVEL"]
[null,null,null,null,"Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast",null,"Is data actual or forecast - should be updated annually"]
[null,"OPERATING PERFORMANCE","Variable Operating Costs per tonne produced","Other Ingredients",1,1,1,1,1,1,1,"$A/tonne product produced","Sourced from Manufacturer","Enter From List",{"$f":"IF(N5=\"very confident\",5,IF(N5=\"Moderately Confident\",4,IF(N5=\"somewhat confident\",3,IF(N5=\"less than confident\",2,IF(N5=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Electricity",1,1,1,1,1,1,1,"$A/tonne product produced","Sourced from Manufacturer","Enter From List",{"$f":"IF(N6=\"very confident\",5,IF(N6=\"Moderately Confident\",4,IF(N6=\"somewhat confident\",3,IF(N6=\"less than confident\",2,IF(N6=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Water",1,1,1,1,1,1,1,"$A/tonne product produced","Sourced from Manufacturer","Enter From List",0]
[null,null,null,"Gas",1,1,1,1,1,1,1,"$A/tonne product produced","Sourced from Manufacturer","Enter From List",0]
[null,null,null,"Packaging",1,1,1,1,1,1,1,"$A/tonne product produced","Sourced from Manufacturer","Enter From List",0]
[null,null,null,"Labour",1,1,1,1,1,1,1,"$A/tonne product produced","Sourced from Manufacturer","Enter From List",0]
[null,null,"Fixed Operating Costs","Management",1,1,1,1,1,1,1,"$A/annum","Sourced from Manufacturer","Enter From List",0]
[null,null,null,"Marketing",1,1,1,1,1,1,1,"$A/annum","Sourced from Manufacturer","Enter From List",0]
[null,null,null,"Overheads",1,1,1,1,1,1,1,"$A/annum","Sourced from Manufacturer","Enter From List",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"AVERAGE CONFIDENCE LEVEL",{"$f":"AVERAGE(O5:O13)","v":0}]
[null,"RETURN TO \"START\" CLICK HERE"]

{"sheet":"Other Impact Data Entry","index":9,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,2,6,2],[4,1,6,1],[8,1,9,1],[11,1,13,1],[11,2,13,2],[8,2,9,2]]}
[null,"Other Impacts Data Entry"]
[]
[null,"ASSUMPTIONS",null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6-10","Year 11-15",null,"COMMENTS/ASSUMPTIONS","CONFIDENCE LEVEL"]
[null,"TO ESTIMATE BENEFITS OF THE MEAT PROCESSOR SELLING TO THE PARTNER",null,null,"Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast",null,"Is data actual or forecast - should be updated annually"]
[null,"MEAT PROCESSOR VALUE ADDED","Value Added at Processor Level","Improved returns at meat processor level",1,1,1,1,1,1,1,"$A/tonne sold","improved returns at the processor level (Sale price to Partner minus price in other markets)","Enter From List",{"$f":"IF(N5=\"very confident\",5,IF(N5=\"Moderately Confident\",4,IF(N5=\"somewhat confident\",3,IF(N5=\"less than confident\",2,IF(N5=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Reduced costs at meat processor level",1,1,1,1,1,1,1,"$A/tonne sold","Reduced trimming","Enter From List",{"$f":"IF(N6=\"very confident\",5,IF(N6=\"Moderately Confident\",4,IF(N6=\"somewhat confident\",3,IF(N6=\"less than confident\",2,IF(N6=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Other",1,1,1,1,1,1,1,"$A/tonne sold","Other______________","Enter From List",0]
[null,"TO ESTIMATE EMPLOYMENT INCREASE"]
[null,"EMPLOYMENT","Employee Cost","Labour",1,1,1,1,1,1,1,"$A/annum","Expected average labour salary cost","Enter From List",{"$f":"IF(N9=\"very confident\",5,IF(N9=\"Moderately Confident\",4,IF(N9=\"somewhat confident\",3,IF(N9=\"less than confident\",2,IF(N9=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Management",1,1,1,1,1,1,1,"$A/annum","Expected average management salary","Enter From List",{"$f":"IF(N10=\"very confident\",5,IF(N10=\"Moderately Confident\",4,IF(N10=\"somewhat confident\",3,IF(N10=\"less than confident\",2,IF(N10=\"not confident at all\",1,0)))))","v":0}]
[null,"TO ESTIMATE ENVIRONMENTAL BENEFITS"]
[null,"ENVIRONMENTAL IMPACT","Reduction in Environmental Impact","Reduced Wastage",0,0,0,0,0,0,0,"$A/tonne sold",null,"Enter From List",{"$f":"IF(N12=\"very confident\",5,IF(N12=\"Moderately Confident\",4,IF(N12=\"somewhat confident\",3,IF(N12=\"less than confident\",2,IF(N12=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Reduced Packaging",0,0,0,0,0,0,0,"$A/tonne sold","No need to VP at processor level","Enter From List",{"$f":"IF(N13=\"very confident\",5,IF(N13=\"Moderately Confident\",4,IF(N13=\"somewhat confident\",3,IF(N13=\"less than confident\",2,IF(N13=\"not confident at all\",1,0)))))","v":0}]
[null,null,null,"Other",0,0,0,0,0,0,0,"$A/tonne sold",null,"Enter From List",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"AVERAGE CONFIDENCE LEVEL",{"$f":"AVERAGE(O12:O14,O9:O10,O5:O7)","v":0}]
[null,"RETURN TO \"START\" CLICK HERE"]

{"sheet":"Competitive Environment","index":10,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":false,"merged":[[24,2,24,3]]}
[null,"Raw Material Competition",null,"RETURN TO START"]
[null,"Raw Material Definition",null,"Comment - Description of Raw Material"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[]
[null,"Raw Material Source",null,"Comment - Description of Raw Material Source"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[]
[null,"Alternative Demand for Raw Material",null,"Comment - Description of characteristics of alternative demand for raw material"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[]
[null,"Finished Product Competition"]
[null,"Competitive Market Definition"]
[]
[null,"Finished Product Definition",null,"Comment - Description of Finished Product"]
[null,1,"Value Added Sausage"]
[null,2,"Product 2_______________"]
[null,3,"Product 3_______________"]
[]
[null,"Finished Product Alternative Supply"]
[null,null,{"$f":"C27","v":"Value Added Sausage"},"Comment - Information on market size, location, quality requirements, price"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[]
[null,"Finished Product Alternative Supply"]
[null,null,{"$f":"C28","v":"Product 2_______________"},"Comment - Information on market size, location, quality requirements, price"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[]
[null,"Finished Product Alternative Supply"]
[null,null,{"$f":"C29","v":"Product 3_______________"},"Comment - Information on market size, location, quality requirements, price"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]

{"sheet":"Investment Sensitivity","index":11,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":true,"merged":[[48,0,49,1],[48,2,48,3],[49,2,49,3],[2,1,3,3],[2,12,2,14],[4,1,9,1],[10,1,15,1],[16,1,21,1],[22,1,27,1],[29,1,34,1],[37,1,42,1],[46,0,47,1],[46,2,46,3],[47,2,47,3]]}
[]
[]
[null,"INVESTMENT",null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6-10","Year 11-15",null,"TOTAL"]
[null,null,null,null,{"$f":"'Investment Data Entry'!E4","v":"Actual"},{"$f":"'Investment Data Entry'!F4","v":"Actual"},{"$f":"'Investment Data Entry'!G4","v":"Forecast"},{"$f":"'Investment Data Entry'!H4","v":"Forecast"},{"$f":"'Investment Data Entry'!I4","v":"Forecast"},{"$f":"'Investment Data Entry'!J4","v":"Forecast"},{"$f":"'Investment Data Entry'!K4","v":"Forecast"},null,"Actual","Forecast","Total"]
[null,"Innovation Investment","MLA","Accountable",{"$f":"'Investment Data Entry'!E5*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F5*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G5*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H5*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I5*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J5*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K5*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUMIFS(E5:K5,E$4:K$4,\"actual\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(E5:K5,E$4:K$4,\"forecast\")","v":{"$error":"#REF!"}},{"$f":"M5+N5","v":{"$error":"#REF!"}}]
[null,null,null,"In-kind",{"$f":"'Investment Data Entry'!E6*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F6*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G6*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H6*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I6*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J6*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K6*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUMIFS(E6:K6,E$4:K$4,\"actual\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(E6:K6,E$4:K$4,\"forecast\")","v":{"$error":"#REF!"}},{"$f":"M6+N6","v":{"$error":"#REF!"}}]
[null,null,"Research Partner","Accountable",{"$f":"'Investment Data Entry'!E7*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F7*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G7*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H7*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I7*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J7*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K7*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"In-kind",{"$f":"'Investment Data Entry'!E8*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F8*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G8*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H8*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I8*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J8*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K8*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Third Party","Accountable",{"$f":"'Investment Data Entry'!E9*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F9*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G9*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H9*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I9*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J9*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K9*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"In-kind",{"$f":"'Investment Data Entry'!E10*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F10*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G10*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H10*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I10*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J10*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K10*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Capital Investment","MLA","Accountable",{"$f":"'Investment Data Entry'!E11*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F11*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G11*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H11*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I11*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J11*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K11*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUMIFS(E11:K11,E$4:K$4,\"actual\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(E11:K11,E$4:K$4,\"forecast\")","v":{"$error":"#REF!"}},{"$f":"M11+N11","v":{"$error":"#REF!"}}]
[null,null,null,"In-kind",{"$f":"'Investment Data Entry'!E12*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F12*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G12*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H12*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I12*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J12*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K12*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUMIFS(E12:K12,E$4:K$4,\"actual\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(E12:K12,E$4:K$4,\"forecast\")","v":{"$error":"#REF!"}},{"$f":"M12+N12","v":{"$error":"#REF!"}}]
[null,null,"Research Partner","Accountable",{"$f":"'Investment Data Entry'!E13*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F13*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G13*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H13*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I13*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J13*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K13*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"In-kind",{"$f":"'Investment Data Entry'!E14*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F14*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G14*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H14*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I14*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J14*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K14*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Third Party","Accountable",{"$f":"'Investment Data Entry'!E15*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F15*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G15*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H15*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I15*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J15*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K15*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"In-kind",{"$f":"'Investment Data Entry'!E16*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F16*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G16*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H16*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I16*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J16*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K16*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Business Development Investment","MLA","Accountable",{"$f":"'Investment Data Entry'!E17*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F17*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G17*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H17*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I17*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J17*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K17*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUMIFS(E17:K17,E$4:K$4,\"actual\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(E17:K17,E$4:K$4,\"forecast\")","v":{"$error":"#REF!"}},{"$f":"M17+N17","v":{"$error":"#REF!"}}]
[null,null,null,"In-kind",{"$f":"'Investment Data Entry'!E18*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F18*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G18*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H18*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I18*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J18*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K18*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUMIFS(E18:K18,E$4:K$4,\"actual\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(E18:K18,E$4:K$4,\"forecast\")","v":{"$error":"#REF!"}},{"$f":"M18+N18","v":{"$error":"#REF!"}}]
[null,null,"Research Partner","Accountable",{"$f":"'Investment Data Entry'!E19*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F19*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G19*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H19*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I19*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J19*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K19*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"In-kind",{"$f":"'Investment Data Entry'!E20*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F20*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G20*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H20*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I20*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J20*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K20*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Third Party","Accountable",{"$f":"'Investment Data Entry'!E21*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F21*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G21*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H21*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I21*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J21*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K21*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"In-kind",{"$f":"'Investment Data Entry'!E22*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F22*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G22*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H22*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I22*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J22*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K22*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Market Development Investment","MLA","Accountable",{"$f":"'Investment Data Entry'!E23*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F23*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G23*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H23*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I23*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J23*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K23*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUMIFS(E23:K23,E$4:K$4,\"actual\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(E23:K23,E$4:K$4,\"forecast\")","v":{"$error":"#REF!"}},{"$f":"M23+N23","v":{"$error":"#REF!"}}]
[null,null,null,"In-kind",{"$f":"'Investment Data Entry'!E24*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F24*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G24*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H24*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I24*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J24*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K24*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUMIFS(E24:K24,E$4:K$4,\"actual\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(E24:K24,E$4:K$4,\"forecast\")","v":{"$error":"#REF!"}},{"$f":"M24+N24","v":{"$error":"#REF!"}}]
[null,null,"Research Partner","Accountable",{"$f":"'Investment Data Entry'!E25*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F25*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G25*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H25*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I25*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J25*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K25*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"In-kind",{"$f":"'Investment Data Entry'!E26*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F26*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G26*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H26*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I26*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J26*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K26*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Third Party","Accountable",{"$f":"'Investment Data Entry'!E27*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F27*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G27*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H27*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I27*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J27*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K27*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"In-kind",{"$f":"'Investment Data Entry'!E28*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!F28*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!G28*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!H28*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!I28*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!J28*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"'Investment Data Entry'!K28*(1+#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6-10","Year 11-15"]
[null,"Annual Total","MLA","Accountable",{"$f":"E5+E11+E17+E23","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"SUMIFS(E30:K30,E$4:K$4,\"actual\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(E30:K30,E$4:K$4,\"forecast\")","v":{"$error":"#REF!"}},{"$f":"M30+N30","v":{"$error":"#REF!"}}]
[null,null,null,"In-kind",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"SUMIFS(E31:K31,E$4:K$4,\"actual\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(E31:K31,E$4:K$4,\"forecast\")","v":{"$error":"#REF!"}},{"$f":"M31+N31","v":{"$error":"#REF!"}}]
[null,null,"Research Partner","Accountable",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"In-kind",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Third Party","Accountable",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"In-kind",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"TOTAL",{"$f":"SUM(E30:E35)","v":{"$error":"#REF!"}},{"$f":"SUM(F30:F35)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,"Year 1","Year 1-2","Year 1-3","Year 1-4","Year 1-5","Year 1-10","Year 1-15"]
[null,"Cumulative Total","MLA","Accountable",{"$f":"E5+E11+E17+E23","v":{"$error":"#REF!"}},{"$f":"E38+F30","v":{"$error":"#REF!"}},{"$f":"F38+G30","v":{"$error":"#REF!"}},{"$f":"G38+H30","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"I38+5*J30","v":{"$error":"#REF!"}},{"$f":"J38+5*K30","v":{"$error":"#REF!"}}]
[null,null,null,"In-kind",{"$error":"#REF!"},{"$f":"E39+F31","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"I39+5*J31","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,"Research Partner","Accountable",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"In-kind",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Third Party","Accountable",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"In-kind",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"TOTAL (ex MLA)",{"$f":"SUM(E40:E43)","v":{"$error":"#REF!"}},{"$f":"SUM(F40:F43)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
["MLA Leverage",null,"Annual Ratio to Investment",null,{"$f":"(E30+E31)/E36","v":{"$error":"#REF!"}},{"$f":"(F30+F31)/(F30+F31+F32+F33+F34+F35)","v":{"$error":"#REF!"}},{"$f":"(G30+G31)/(G30+G31+G32+G33+G34+G35)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Cumulative Ratio to All Investment",null,{"$f":"(E38+E39)/(E44+E38+E39)","v":{"$error":"#REF!"}},{"$f":"(F38+F39)/(F44+F38+F39)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Estimated Payback Period",null,"EBITDA",null,{"$f":"'Projection Sensitivity'!E113","v":{"$error":"#REF!"}},{"$f":"'Projection Sensitivity'!F113","v":{"$error":"#REF!"}},{"$f":"'Projection Sensitivity'!G113","v":{"$error":"#REF!"}},{"$f":"'Projection Sensitivity'!H113","v":{"$error":"#REF!"}},{"$f":"'Projection Sensitivity'!I113","v":{"$error":"#REF!"}},{"$f":"'Projection Sensitivity'!J113","v":{"$error":"#REF!"}},{"$f":"'Projection Sensitivity'!K113","v":{"$error":"#REF!"}}]
[null,null,"Estimated Payback Period (Months)",null,{"$f":"12*E44/E49","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"12*G44/G49","v":{"$error":"#REF!"}},{"$f":"12*H44/H49","v":{"$error":"#REF!"}},{"$f":"12*I44/I49","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Projection Sensitivity","index":12,"n_rows":154,"n_cols":12,"rows_kept":154,"cut":false,"hidden":true,"merged":[[150,2,153,2],[130,1,133,1],[130,2,133,2],[135,1,139,1],[135,2,139,2],[141,1,147,1],[141,2,147,2],[118,1,128,1],[118,2,128,2],[67,1,95,1],[67,2,70,2],[71,2,73,2],[74,2,77,2],[78,2,83,2],[84,2,88,2],[89,2,95,2],[97,1,116,1],[97,2,99,2],[100,2,105,2],[106,2,108,2],[109,2,116,2],[35,1,65,1],[35,2,37,2],[38,2,40,2],[42,2,45,2],[46,2,49,2],[50,2,53,2],[54,2,57,2],[58,2,61,2],[62,2,65,2],[2,1,3,3],[4,1,33,1],[4,2,7,2],[8,2,11,2],[12,2,14,2],[15,2,17,2],[18,2,21,2],[22,2,25,2],[26,2,29,2],[30,2,33,2]]}
[]
[]
[null,"PROJECTIONS",null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6-10","Year 11-15"]
[null,null,null,null,{"$f":"'Global Market Data Entry'!E4","v":"Actual"},{"$f":"'Global Market Data Entry'!F4","v":"Forecast"},{"$f":"'Global Market Data Entry'!G4","v":"Forecast"},{"$f":"'Global Market Data Entry'!H4","v":"Forecast"},{"$f":"'Global Market Data Entry'!I4","v":"Forecast"},{"$f":"'Global Market Data Entry'!J4","v":"Forecast"},{"$f":"'Global Market Data Entry'!K4","v":"Forecast"}]
[null,"MARKET PROJECTIONS","Global Market Volumes","Product 1",{"$f":"'Global Market Data Entry'!E5","v":0},{"$f":"'Global Market Data Entry'!F5","v":0},{"$f":"'Global Market Data Entry'!G5","v":0},{"$f":"'Global Market Data Entry'!H5","v":0},{"$f":"'Global Market Data Entry'!I5","v":0},{"$f":"'Global Market Data Entry'!J5","v":0},{"$f":"'Global Market Data Entry'!K5","v":0}," (Tonne/annum)"]
[null,null,null,"Product 2",{"$f":"'Global Market Data Entry'!E6","v":0},{"$f":"'Global Market Data Entry'!F6","v":0},{"$f":"'Global Market Data Entry'!G6","v":0},{"$f":"'Global Market Data Entry'!H6","v":0},{"$f":"'Global Market Data Entry'!I6","v":0},{"$f":"'Global Market Data Entry'!J6","v":0},{"$f":"'Global Market Data Entry'!K6","v":0}," (Tonne/annum)"]
[null,null,null,"Product 3",{"$f":"'Global Market Data Entry'!E7","v":0},{"$f":"'Global Market Data Entry'!F7","v":0},{"$f":"'Global Market Data Entry'!G7","v":0},{"$f":"'Global Market Data Entry'!H7","v":0},{"$f":"'Global Market Data Entry'!I7","v":0},{"$f":"'Global Market Data Entry'!J7","v":0},{"$f":"'Global Market Data Entry'!K7","v":0}," (Tonne/annum)"]
[null,null,null,"TOTAL",{"$f":"SUM(E5:E7)","v":0},{"$f":"SUM(F5:F7)","v":0},0,0,0,0,0," (Tonne/annum)"]
[null,null,"Domestic Market Volumes","Product 1",{"$f":"'Global Market Data Entry'!E9","v":110000},{"$f":"'Global Market Data Entry'!F9","v":110000},{"$f":"'Global Market Data Entry'!G9","v":110000},{"$f":"'Global Market Data Entry'!H9","v":110000},{"$f":"'Global Market Data Entry'!I9","v":110000},{"$f":"'Global Market Data Entry'!J9","v":110000},{"$f":"'Global Market Data Entry'!K9","v":110000}," (Tonne/annum)"]
[null,null,null,"Product 2",{"$f":"'Global Market Data Entry'!E10","v":0},{"$f":"'Global Market Data Entry'!F10","v":0},{"$f":"'Global Market Data Entry'!G10","v":0},{"$f":"'Global Market Data Entry'!H10","v":0},{"$f":"'Global Market Data Entry'!I10","v":0},{"$f":"'Global Market Data Entry'!J10","v":0},{"$f":"'Global Market Data Entry'!K10","v":0}," (Tonne/annum)"]
[null,null,null,"Product 3",{"$f":"'Global Market Data Entry'!E11","v":0},{"$f":"'Global Market Data Entry'!F11","v":0},{"$f":"'Global Market Data Entry'!G11","v":0},{"$f":"'Global Market Data Entry'!H11","v":0},{"$f":"'Global Market Data Entry'!I11","v":0},{"$f":"'Global Market Data Entry'!J11","v":0},{"$f":"'Global Market Data Entry'!K11","v":0}," (Tonne/annum)"]
[null,null,null,"TOTAL",{"$f":"SUM(E9:E11)","v":110000},{"$f":"SUM(F9:F11)","v":110000},110000,110000,110000,110000,110000," (Tonne/annum)"]
[null,null,"Global Market Prices","Product 1",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/kg"]
[null,null,null,"Product 2",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/kg"]
[null,null,null,"Product 3",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/kg"]
[null,null,"Domestic Market Prices","Product 1",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/kg"]
[null,null,null,"Product 2",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/kg"]
[null,null,null,"Product 3",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/kg"]
[null,null,"Global Market Annual Value","Product 1",{"$f":"E5*E13*1000","v":{"$error":"#REF!"}},{"$f":"F5*F13*1000","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Product 2",{"$f":"E6*E14*1000","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Product 3",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"TOTAL",{"$f":"SUM(E19:E21)","v":{"$error":"#REF!"}},{"$f":"SUM(F19:F21)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,"Domestic Market Annual Value","Product 1",{"$f":"E9*E16*1000","v":{"$error":"#REF!"}},{"$f":"F9*F16*1000","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Product 2",{"$f":"E10*E17*1000","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Product 3",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"TOTAL",{"$f":"SUM(E23:E25)","v":{"$error":"#REF!"}},{"$f":"SUM(F23:F25)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,"Global Market Share Provided by Australian Partner","Product 1",{"$f":"E43/E5","v":{"$error":"#DIV/0!"}},{"$f":"F43/F5","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"$A/annum"]
[null,null,null,"Product 2",{"$f":"E44/E6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"$A/annum"]
[null,null,null,"Product 3",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"$A/annum"]
[null,null,null,"TOTAL",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"$A/annum"]
[null,null,"Domestic Market Share Provided by Australian Partner","Product 1",{"$f":"E47/E9","v":1.4545454545454545E-3},{"$f":"F47/F9","v":3.4090909090909089E-3},3.8181818181818182E-3,4.1363636363636359E-3,4.3636363636363638E-3,4.5000000000000005E-3,4.5454545454545452E-3,"$A/annum"]
[null,null,null,"Product 2",{"$f":"E48/E10","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"$A/annum"]
[null,null,null,"Product 3",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"$A/annum"]
[null,null,null,"TOTAL",1.4545454545454545E-3,3.4090909090909089E-3,3.8181818181818182E-3,4.1363636363636359E-3,4.3636363636363638E-3,4.5000000000000005E-3,4.5454545454545452E-3,"$A/annum"]
[]
[null,"MARKET SHARE PROJECTIONS","% of Production Supplied to Global Market","Product 1",{"$f":"'Market Share Data Entry'!E5","v":0.2},{"$f":"'Market Share Data Entry'!F5","v":0.25},{"$f":"'Market Share Data Entry'!G5","v":0.3},{"$f":"'Market Share Data Entry'!H5","v":0.35},{"$f":"'Market Share Data Entry'!I5","v":0.4},{"$f":"'Market Share Data Entry'!J5","v":0.45},{"$f":"'Market Share Data Entry'!K5","v":0.5},"%"]
[null,null,null,"Product 2",{"$f":"'Market Share Data Entry'!E6","v":0},{"$f":"'Market Share Data Entry'!F6","v":0},{"$f":"'Market Share Data Entry'!G6","v":0},{"$f":"'Market Share Data Entry'!H6","v":0},{"$f":"'Market Share Data Entry'!I6","v":0},{"$f":"'Market Share Data Entry'!J6","v":0},{"$f":"'Market Share Data Entry'!K6","v":0},"%"]
[null,null,null,"Product 3",{"$f":"'Market Share Data Entry'!E7","v":0},{"$f":"'Market Share Data Entry'!F7","v":0},{"$f":"'Market Share Data Entry'!G7","v":0},{"$f":"'Market Share Data Entry'!H7","v":0},{"$f":"'Market Share Data Entry'!I7","v":0},{"$f":"'Market Share Data Entry'!J7","v":0},{"$f":"'Market Share Data Entry'!K7","v":0},"%"]
[null,null,"% of Production Supplied to DomesticMarket","Product 1",{"$f":"'Market Share Data Entry'!E8","v":0.8},{"$f":"'Market Share Data Entry'!F8","v":0.75},{"$f":"'Market Share Data Entry'!G8","v":0.7},{"$f":"'Market Share Data Entry'!H8","v":0.65},{"$f":"'Market Share Data Entry'!I8","v":0.6},{"$f":"'Market Share Data Entry'!J8","v":0.55000000000000004},{"$f":"'Market Share Data Entry'!K8","v":0.5},"%"]
[null,null,null,"Product 2",{"$f":"'Market Share Data Entry'!E9","v":0},{"$f":"'Market Share Data Entry'!F9","v":0},{"$f":"'Market Share Data Entry'!G9","v":0},{"$f":"'Market Share Data Entry'!H9","v":0},{"$f":"'Market Share Data Entry'!I9","v":0},{"$f":"'Market Share Data Entry'!J9","v":0},{"$f":"'Market Share Data Entry'!K9","v":0},"%"]
[null,null,null,"Product 3",{"$f":"'Market Share Data Entry'!E10","v":0},{"$f":"'Market Share Data Entry'!F10","v":0},{"$f":"'Market Share Data Entry'!G10","v":0},{"$f":"'Market Share Data Entry'!H10","v":0},{"$f":"'Market Share Data Entry'!I10","v":0},{"$f":"'Market Share Data Entry'!J10","v":0},{"$f":"'Market Share Data Entry'!K10","v":0},"%"]
[null,null,null,null,{"$f":"SUM(E36:E41)","v":1},{"$f":"SUM(F36:F41)","v":1},1,1,1,1,1]
[null,null,"Global Market Volume supplied by Australia","Product 1",{"$f":"IF(E68=0,\"0\",E68*E36*E71/E68)","v":40},{"$f":"IF(F68=0,\"0\",F68*F36*F71/F68)","v":125},180,244.99999999999997,320,405,500," (Tonne/annum)"]
[null,null,null,"Product 2",{"$f":"IF(E69=0,\"0\",E69*E37*E71/E69)","v":"0"},{"$f":"IF(F69=0,\"0\",F69*F37*F71/F69)","v":"0"},"0","0","0","0","0"," (Tonne/annum)"]
[null,null,null,"Product 3",{"$f":"IF(E70=0,\"0\",E70*E38*E71/E70)","v":"0"},{"$f":"IF(F70=0,\"0\",F70*F38*F71/F70)","v":"0"},"0","0","0","0","0"," (Tonne/annum)"]
[null,null,null,"TOTAL",{"$f":"SUM(E43:E45)","v":40},{"$f":"SUM(F43:F45)","v":125},180,244.99999999999997,320,405,500," (Tonne/annum)"]
[null,null,"Domestic Market Volume supplied by Australia","Product 1",{"$f":"IF(E68=0,\"0\",E68*E39*E71/E68)","v":160},{"$f":"IF(F68=0,\"0\",F68*F39*F71/F68)","v":375},420,455,480,495.00000000000006,500," (Tonne/annum)"]
[null,null,null,"Product 2",{"$f":"IF(E69=0,\"0\",E69*E40*E71/E69)","v":"0"},{"$f":"IF(F69=0,\"0\",F69*F40*F71/F69)","v":"0"},"0","0","0","0","0"," (Tonne/annum)"]
[null,null,null,"Product 3",{"$f":"IF(E70=0,\"0\",E70*E41*E71/E70)","v":"0"},{"$f":"IF(F70=0,\"0\",F70*F41*F71/F70)","v":"0"},"0","0","0","0","0"," (Tonne/annum)"]
[null,null,null,"TOTAL",{"$f":"SUM(E47:E49)","v":160},{"$f":"SUM(F47:F49)","v":375},420,455,480,495.00000000000006,500," (Tonne/annum)"]
[null,null,"Total Market Volume supplied by Australia","Product 1",{"$f":"E43+E47","v":200},{"$f":"F43+F47","v":500},{"$f":"G43+G47","v":600},700,800,900,1000," (Tonne/annum)"]
[null,null,null,"Product 2",{"$f":"E44+E48","v":0},0,0,0,0,0,0," (Tonne/annum)"]
[null,null,null,"Product 3",0,0,0,0,0,0,0," (Tonne/annum)"]
[null,null,null,"TOTAL",{"$f":"SUM(E51:E53)","v":200},{"$f":"SUM(F51:F53)","v":500},600,700,800,900,1000," (Tonne/annum)"]
[null,null,"Global Market Annual Value supplied","Product 1",{"$f":"E13*E43*1000","v":{"$error":"#REF!"}},{"$f":"F13*F43*1000","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Product 2",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Product 3",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"TOTAL",{"$f":"SUM(E55:E57)","v":{"$error":"#REF!"}},{"$f":"SUM(F55:F57)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,"Domestic Market Annual Value supplied","Product 1",{"$f":"E16*E47*1000","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Product 2",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Product 3",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"TOTAL",{"$f":"SUM(E59:E61)","v":{"$error":"#REF!"}},{"$f":"SUM(F59:F61)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,"Total Market Annual Value supplied","Product 1",{"$f":"E55+E59","v":{"$error":"#REF!"}},{"$f":"F55+F59","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Product 2",{"$f":"E56+E60","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Product 3",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"TOTAL",{"$f":"SUM(E63:E65)","v":{"$error":"#REF!"}},{"$f":"SUM(F63:F65)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[]
[null,"RAW MATERIAL PROJECTIONS","Production Projection","Product 1",{"$f":"'Market Share Data Entry'!E15","v":200},{"$f":"'Market Share Data Entry'!F15","v":500},{"$f":"'Market Share Data Entry'!G15","v":600},{"$f":"'Market Share Data Entry'!H15","v":700},{"$f":"'Market Share Data Entry'!I15","v":800},{"$f":"'Market Share Data Entry'!J15","v":900},{"$f":"'Market Share Data Entry'!K15","v":1000}," (Tonne/annum)"]
[null,null,null,"Product 2",{"$f":"'Market Share Data Entry'!E16","v":0},{"$f":"'Market Share Data Entry'!F16","v":0},{"$f":"'Market Share Data Entry'!G16","v":0},{"$f":"'Market Share Data Entry'!H16","v":0},{"$f":"'Market Share Data Entry'!I16","v":0},{"$f":"'Market Share Data Entry'!J16","v":0},{"$f":"'Market Share Data Entry'!K16","v":0}," (Tonne/annum)"]
[null,null,null,"Product 3",{"$f":"'Market Share Data Entry'!E17","v":0},{"$f":"'Market Share Data Entry'!F17","v":0},{"$f":"'Market Share Data Entry'!G17","v":0},{"$f":"'Market Share Data Entry'!H17","v":0},{"$f":"'Market Share Data Entry'!I17","v":0},{"$f":"'Market Share Data Entry'!J17","v":0},{"$f":"'Market Share Data Entry'!K17","v":0}," (Tonne/annum)"]
[null,null,null,null,{"$f":"SUM(E68:E70)","v":200},{"$f":"SUM(F68:F70)","v":500},600,700,800,900,1000," (Tonne/annum)"]
[null,null,"Final Product/Animal Product (%)","Product 1",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"%"]
[null,null,null,"Product 2",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"%"]
[null,null,null,"Product 3",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"%"]
[null,null,"Animal Product processed into Final Product","Product 1",{"$f":"IF(E68=0,0,E68/E72)","v":{"$error":"#REF!"}},{"$f":"IF(F68=0,0,F68/F72)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}," (Tonne/annum)"]
[null,null,null,"Product 2",{"$f":"IF(E69=0,0,E69/E73)","v":0},0,0,0,0,0,0," (Tonne/annum)"]
[null,null,null,"Product 3",0,0,0,0,0,0,0," (Tonne/annum)"]
[null,null,null,"TOTAL",{"$f":"SUM(E75:E77)","v":{"$error":"#REF!"}},{"$f":"SUM(F75:F77)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}," (Tonne/annum)"]
[null,null,"Animal Product Supply Percent","Premium Primal",{"$f":"'Market Share Data Entry'!E22","v":0},{"$f":"'Market Share Data Entry'!F22","v":0},{"$f":"'Market Share Data Entry'!G22","v":0},{"$f":"'Market Share Data Entry'!H22","v":0},{"$f":"'Market Share Data Entry'!I22","v":0},{"$f":"'Market Share Data Entry'!J22","v":0},{"$f":"'Market Share Data Entry'!K22","v":0},"%"]
[null,null,null,"Secondary Primal",{"$f":"'Market Share Data Entry'!E23","v":1},{"$f":"'Market Share Data Entry'!F23","v":1},{"$f":"'Market Share Data Entry'!G23","v":1},{"$f":"'Market Share Data Entry'!H23","v":1},{"$f":"'Market Share Data Entry'!I23","v":1},{"$f":"'Market Share Data Entry'!J23","v":1},{"$f":"'Market Share Data Entry'!K23","v":1},"%"]
[null,null,null,"Manufacturing",0,0,0,0,0,0,0,"%"]
[null,null,null,"Offal",0,0,0,0,0,0,0,"%"]
[null,null,null,"Other",{"$f":"'Market Share Data Entry'!E24","v":0},{"$f":"'Market Share Data Entry'!F24","v":0},{"$f":"'Market Share Data Entry'!G24","v":0},{"$f":"'Market Share Data Entry'!H24","v":0},{"$f":"'Market Share Data Entry'!I24","v":0},{"$f":"'Market Share Data Entry'!J24","v":0},{"$f":"'Market Share Data Entry'!K24","v":0},"%"]
[null,null,null,"TOTAL",{"$f":"SUM(E79:E83)","v":1},{"$f":"SUM(F79:F83)","v":1},1,1,1,1,1,"%"]
[null,null,"Animal Product Supply Price","Premium Primal",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},"$A/kg"]
[null,null,null,"Secondary Primal",{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},"$A/kg"]
[null,null,null,"Manufacturing",{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},"$A/kg"]
[null,null,null,"Offal",{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},"$A/kg"]
[null,null,null,"Other",{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)+#REF!","v":{"$error":"#REF!"}},"$A/kg"]
[null,null,"Animal Product Supply Value","Premium Primal",{"$f":"E$78*E79*E85*1000","v":{"$error":"#REF!"}},{"$f":"F$78*F79*F85*1000","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Secondary Primal",{"$f":"E$78*E80*E86*1000","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Manufacturing",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Offal",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Other",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"TOTAL",{"$f":"SUM(E90:E92)","v":{"$error":"#REF!"}},{"$f":"SUM(F90:F92)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"SUPPLY COST PER TONNE FINISHED PRODUCT",{"$f":"IF(E95=0,0,E95/E71)","v":{"$error":"#REF!"}},{"$f":"IF(F95=0,0,F95/F71)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[]
[null,"OPERATING PERFORMANCE","Gross Margin","Sales Value",{"$f":"E66","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Raw Animal Product Material Cost",{"$f":"E95","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"GROSS MARGIN",{"$f":"E98-E99","v":{"$error":"#REF!"}},{"$f":"F98-F99","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,"Variable Operating Costs per tonne produced","Other Ingredients",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/tonne product produced"]
[null,null,null,"Electricity",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/tonne product produced"]
[null,null,null,"Water",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/tonne product produced"]
[null,null,null,"Gas",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/tonne product produced"]
[null,null,null,"Packaging",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/tonne product produced"]
[null,null,null,"Labour",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/tonne product produced"]
[null,null,"Fixed Operating Costs","Management",{"$f":"'Operations Data Entry'!E11","v":1},{"$f":"'Operations Data Entry'!F11","v":1},{"$f":"'Operations Data Entry'!G11","v":1},{"$f":"'Operations Data Entry'!H11","v":1},{"$f":"'Operations Data Entry'!I11","v":1},{"$f":"'Operations Data Entry'!J11","v":1},{"$f":"'Operations Data Entry'!K11","v":1},"$A/annum"]
[null,null,null,"Marketing",{"$f":"'Operations Data Entry'!E12","v":1},{"$f":"'Operations Data Entry'!F12","v":1},{"$f":"'Operations Data Entry'!G12","v":1},{"$f":"'Operations Data Entry'!H12","v":1},{"$f":"'Operations Data Entry'!I12","v":1},{"$f":"'Operations Data Entry'!J12","v":1},{"$f":"'Operations Data Entry'!K12","v":1},"$A/annum"]
[null,null,null,"Overheads",{"$f":"'Operations Data Entry'!E13","v":1},{"$f":"'Operations Data Entry'!F13","v":1},{"$f":"'Operations Data Entry'!G13","v":1},{"$f":"'Operations Data Entry'!H13","v":1},{"$f":"'Operations Data Entry'!I13","v":1},{"$f":"'Operations Data Entry'!J13","v":1},{"$f":"'Operations Data Entry'!K13","v":1},"$A/annum"]
[null,null,"Overall Operating Costs","Variable",{"$f":"(E101+E102+E103+E104+E105+E106)*E71","v":{"$error":"#REF!"}},{"$f":"(F101+F102+F103+F104+F105+F106)*F71","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Fixed",{"$f":"E107+E108+E109","v":3},{"$f":"F107+F108+F109","v":3},3,3,3,3,3,"$A/annum"]
[null,null,null,"TOTAL OPERATING COST",{"$f":"SUM(E110:E111)","v":{"$error":"#REF!"}},{"$f":"SUM(F110:F111)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"ESTIMATED EBITDA OUTCOME",{"$f":"E100-E112","v":{"$error":"#REF!"}},{"$f":"F100-F112","v":{"$error":"#REF!"}},{"$f":"G100-G112","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"INVESTMENT COST ADJUSTMENT",{"$f":"#REF!/10","v":{"$error":"#REF!"}},{"$f":"#REF!/10","v":{"$error":"#REF!"}},{"$f":"#REF!/10","v":{"$error":"#REF!"}},{"$f":"#REF!/10","v":{"$error":"#REF!"}},{"$f":"#REF!/10","v":{"$error":"#REF!"}},{"$f":"#REF!/10","v":{"$error":"#REF!"}},{"$f":"#REF!/10","v":{"$error":"#REF!"}},"$A/annum"]
[null,null,null,"ESTIMATED OVERALL OUTCOME",{"$f":"E100-E112-E114","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"CUMULATIVE OVERALL OUTCOME",{"$f":"E115","v":{"$error":"#REF!"}},{"$f":"E116+F115","v":{"$error":"#REF!"}},{"$f":"F116+G115","v":{"$error":"#REF!"}},{"$f":"G116+H115","v":{"$error":"#REF!"}},{"$f":"H116+I115","v":{"$error":"#REF!"}},{"$f":"I116+J115*5","v":{"$error":"#REF!"}},{"$f":"J116+K115*5","v":{"$error":"#REF!"}},"$A/annum"]
[null,null,null,"ESTIMATED PAYBACK PERIOD",{"$f":"IF(E113=0,\" \",12*#REF!/'Projection Sensitivity'!E113)","v":{"$error":"#REF!"}},{"$f":"IF(F113=0,\" \",12*#REF!/'Projection Sensitivity'!F113)","v":{"$error":"#REF!"}},{"$f":"IF(G113=0,\" \",12*#REF!/'Projection Sensitivity'!G113)","v":{"$error":"#REF!"}},{"$f":"IF(H113=0,\" \",12*#REF!/'Projection Sensitivity'!H113)","v":{"$error":"#REF!"}},{"$f":"IF(I113=0,\" \",12*#REF!/'Projection Sensitivity'!I113)","v":{"$error":"#REF!"}},{"$f":"IF(J113=0,\" \",12*#REF!/'Projection Sensitivity'!J113)","v":{"$error":"#REF!"}},{"$f":"IF(K113=0,\" \",12*#REF!/'Projection Sensitivity'!K113)","v":{"$error":"#REF!"}},"Months"]
[]
[null,"ADDITIONAL PROCESSOR VALUE","Value Added at Processor Level","Improved return at meat processor level",{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!*(1+#REF!)","v":{"$error":"#REF!"}},"$A/tonne"]
[null,null,null,"Reduced cost at meat processor level",{"$f":"'Other Impact Data Entry'!E6","v":1},{"$f":"'Other Impact Data Entry'!F6","v":1},{"$f":"'Other Impact Data Entry'!G6","v":1},{"$f":"'Other Impact Data Entry'!H6","v":1},{"$f":"'Other Impact Data Entry'!I6","v":1},{"$f":"'Other Impact Data Entry'!J6","v":1},{"$f":"'Other Impact Data Entry'!K6","v":1},"$A/tonne"]
[null,null,null,"Other",{"$f":"'Other Impact Data Entry'!E7","v":1},{"$f":"'Other Impact Data Entry'!F7","v":1},{"$f":"'Other Impact Data Entry'!G7","v":1},{"$f":"'Other Impact Data Entry'!H7","v":1},{"$f":"'Other Impact Data Entry'!I7","v":1},{"$f":"'Other Impact Data Entry'!J7","v":1},{"$f":"'Other Impact Data Entry'!K7","v":1},"$A/tonne"]
[null,null,null,"Increased Value of Premium Primal for the Processor",{"$f":"(E$119+E$120+E$121)*E79*E$78","v":{"$error":"#REF!"}},{"$f":"(F$119+F$120+F$121)*F79*F$78","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Increased Value of Secondary Primal for the Processor",{"$f":"(E$119+E$120+E$121)*E80*E$78","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Increased Value of Manufacturing for the Processor",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Increased Value of Offal for the Processor",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Increased Value of Other Products for the Processor",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"ADDITIONAL VALUE ADDED",{"$f":"SUM(E122:E126)","v":{"$error":"#REF!"}},{"$f":"SUM(F122:F126)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"CUMULATIVE VALUE ADDED",{"$f":"E127","v":{"$error":"#REF!"}},{"$f":"E128+F127","v":{"$error":"#REF!"}},{"$f":"F128+G127","v":{"$error":"#REF!"}},{"$f":"G128+H127","v":{"$error":"#REF!"}},{"$f":"H128+I127","v":{"$error":"#REF!"}},{"$f":"I128+J127*5","v":{"$error":"#REF!"}},{"$f":"J128+K127*5","v":{"$error":"#REF!"}},"$A/annum"]
[null,null,null,"VALUE ADDED PER TONNE RAW MATERIAL PURCHASED",{"$f":"IF(E78=0,\" \",E127/E78)","v":{"$error":"#REF!"}},{"$f":"IF(F78=0,\" \",F127/F78)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/Tonne Raw Material"]
[]
[null,"ADDITIONAL GDP VALUE","Value Added at GDP Level","Value of Finished Product Exported",{"$f":"E58","v":{"$error":"#REF!"}},{"$f":"F58","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Value of Raw Material in Exported Product",{"$f":"E95*(E36+E37+E38)","v":{"$error":"#REF!"}},{"$f":"F95*(F36+F37+F38)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"GDP VALUE ADDED",{"$f":"E131-E132","v":{"$error":"#REF!"}},{"$f":"F131-F132","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"CUMULATIVE GDP INCREASE",{"$f":"E133","v":{"$error":"#REF!"}},{"$f":"E134+F133","v":{"$error":"#REF!"}},{"$f":"F134+G133","v":{"$error":"#REF!"}},{"$f":"G134+H133","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"I134+J133*5","v":{"$error":"#REF!"}},{"$f":"J134+K133*5","v":{"$error":"#REF!"}},"$A/annum"]
[]
[null,"EMPLOYMENT INCREASE","Employees","Labour",{"$f":"'Other Impact Data Entry'!E9","v":1},{"$f":"'Other Impact Data Entry'!F9","v":1},{"$f":"'Other Impact Data Entry'!G9","v":1},{"$f":"'Other Impact Data Entry'!H9","v":1},{"$f":"'Other Impact Data Entry'!I9","v":1},{"$f":"'Other Impact Data Entry'!J9","v":1},{"$f":"'Other Impact Data Entry'!K9","v":1},"$A/annum"]
[null,null,null,"Management",{"$f":"'Other Impact Data Entry'!E10","v":1},{"$f":"'Other Impact Data Entry'!F10","v":1},{"$f":"'Other Impact Data Entry'!G10","v":1},{"$f":"'Other Impact Data Entry'!H10","v":1},{"$f":"'Other Impact Data Entry'!I10","v":1},{"$f":"'Other Impact Data Entry'!J10","v":1},{"$f":"'Other Impact Data Entry'!K10","v":1},"$A/annum"]
[null,null,null,"Labour Units",{"$f":"(E106*E54)/E136","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"Persons"]
[null,null,null,"Management Team",{"$f":"E107/E137","v":1},1,1,1,1,1,1,"Persons"]
[null,null,null,"TOTAL EMPLOYMENT",{"$f":"SUM(E138:E139)","v":{"$error":"#REF!"}},{"$f":"SUM(F138:F139)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"Persons"]
[]
[null,"ENVIRONMENTAL IMPACT","Reduction in Environmental Impact","Reduced Wastage",{"$f":"'Other Impact Data Entry'!E12","v":0},{"$f":"'Other Impact Data Entry'!F12","v":0},{"$f":"'Other Impact Data Entry'!G12","v":0},{"$f":"'Other Impact Data Entry'!H12","v":0},{"$f":"'Other Impact Data Entry'!I12","v":0},{"$f":"'Other Impact Data Entry'!J12","v":0},{"$f":"'Other Impact Data Entry'!K12","v":0},"$A/tonne sold"]
[null,null,null,"Reduced Packaging",{"$f":"'Other Impact Data Entry'!E13","v":0},{"$f":"'Other Impact Data Entry'!F13","v":0},{"$f":"'Other Impact Data Entry'!G13","v":0},{"$f":"'Other Impact Data Entry'!H13","v":0},{"$f":"'Other Impact Data Entry'!I13","v":0},{"$f":"'Other Impact Data Entry'!J13","v":0},{"$f":"'Other Impact Data Entry'!K13","v":0},"$A/tonne sold"]
[null,null,null,"Other",{"$f":"'Other Impact Data Entry'!E14","v":0},{"$f":"'Other Impact Data Entry'!F14","v":0},{"$f":"'Other Impact Data Entry'!G14","v":0},{"$f":"'Other Impact Data Entry'!H14","v":0},{"$f":"'Other Impact Data Entry'!I14","v":0},{"$f":"'Other Impact Data Entry'!J14","v":0},{"$f":"'Other Impact Data Entry'!K14","v":0},"$A/tonne sold"]
[null,null,null,"Reduced Wastage",{"$f":"E142*E$78","v":{"$error":"#REF!"}},{"$f":"F142*F$78","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Reduced Packaging",{"$f":"E143*E$78","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"Other",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[null,null,null,"TOTAL",{"$f":"SUM(E145:E147)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM(G145:G147)","v":{"$error":"#REF!"}},{"$f":"SUM(H145:H147)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$A/annum"]
[]
[]
[null,null,"FOR USE IN SENSIIVITY ANALYSIS","Average Product Sales Price ($/kg)",{"$f":"IF(E71=0,0,E98/E71/1000)","v":{"$error":"#REF!"}},{"$f":"IF(F71=0,0,F98/F71/1000)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$/kg"]
[null,null,null,"Average Animal Product Conversion (Finished/Raw material)",{"$f":"IF(E78=0,0,E71/E78)","v":{"$error":"#REF!"}},{"$f":"IF(F78=0,0,F71/F78)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"%"]
[null,null,null,"Average Raw Material Price",{"$f":"IF(E78=0,0,E99/E78)","v":{"$error":"#REF!"}},{"$f":"IF(F78=0,0,F99/F78)","v":{"$error":"#REF!"}},{"$f":"IF(G78=0,0,G99/G78)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$/Tonne"]
[null,null,null,"Operating Cost $/kg Product Produced",{"$f":"IF(E71=0,0,E112/E71/1000)","v":{"$error":"#REF!"}},{"$f":"IF(F71=0,0,F112/F71/1000)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"$/kg"]

{"sheet":"Lists","index":13,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[null,"ACTUAL/FORECAST LIST",null,null,"CONFIDENCE LEVEL LIST"]
[null,"Enter from list",null,null,"Enter From List"]
[null,"Actual",null,null,"Very Confident",{"$f":"IF(E4=\"very confident\",5,IF(E4=\"Moderately Confident\",4,IF(E4=\"somewhat confident\",3,IF(E4=\"less than confident\",2,IF(E4=\"not confident at all\",1,0)))))","v":5}]
[null,"Forecast",null,null,"Moderately Confident",{"$f":"IF(E5=\"very confident\",5,IF(E5=\"Moderately Confident\",4,IF(E5=\"somewhat confident\",3,IF(E5=\"less than confident\",2,IF(E5=\"not confident at all\",1,0)))))","v":4}]
[null,null,null,null,"Somewhat Confident",3]
[null,null,null,null,"Less than Confident",2]
[null,null,null,null,"Not Confident at all",1]