{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Question bank","Parameters","Driver Summary","Main","Resources","Evaluation","Value Chain","Biosecurity","Market","Cost","Climate","Downstream processing","Product differentiation","Improving productivity","Financial resilience","Building networks","Diversification"],"not_rendered":{"charts":17,"images":18,"macros":1,"external_links":0,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Question bank","index":0,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["Category","Title","Question","Rating","Score","Adjustment factor","Justfication","Adjusted score"]
["Driver","Market","Prices are highly variable for my produce.",{"$f":"Market!U10","v":0},{"$f":"VLOOKUP(D2,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$f":"E2*F2","v":{"$error":"#N/A"}},null,null,"Normalised score refers to "]
["Driver","Market","A change in prices has had a big impact on my revenues in the past.",{"$f":"Market!U15","v":0},{"$f":"VLOOKUP(D3,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$f":"E3*F3","v":{"$error":"#N/A"}}]
["Driver","Market","I am able to quickly respond to changes in prices by changing production capacity or product mix. ",{"$f":"Market!U20","v":0},{"$f":"VLOOKUP(D4,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},-1,null,{"$error":"#N/A"},null,null,"Guide for Drivers",null,null,null,"Guide for Strategies"]
["Driver","Market","I anticipate an increase in demand for my produce in the near future and I am well-positioned to respond. ",{"$f":"Market!U25","v":0},{"$f":"VLOOKUP(D5,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},-1,null,{"$error":"#N/A"},null,null,"High numbers = high vulnerability",null,null,null,"High numbers = well versed in the strategy"]
["Driver","Costs","My costs of production are likely to vary significantly year-to-year. ",{"$f":"Cost!U10","v":0},{"$f":"VLOOKUP(D6,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"},null,3,"Low numbers = little impact ",null,null,null,"Low numbers = capacity to implement"]
["Driver","Costs","In the past, these changes in costs of production have had a big impact on my profitability.",{"$f":"Cost!U15","v":0},{"$f":"VLOOKUP(D7,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"},null,{"$f":"J6/4","v":0.75}]
["Driver","Costs","I actively search for ways to minimise costs to control for them in the long-term. ",{"$f":"Cost!U20","v":0},{"$f":"VLOOKUP(D8,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},-1,null,{"$error":"#N/A"},null,null,"21  Driver questions ",null,null,null,"26 Driver questions"]
["Driver","Costs","I am able to adequately manage variability in costs e.g., chemicals and fertiliser, labour, seeds, other input costs, etc. ",{"$f":"Cost!U25","v":0},{"$f":"VLOOKUP(D9,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},-1,null,{"$error":"#N/A"},null,null,"Max score for each question ranges from 0 to 3."]
["Driver","Supply and value chain","I have ready access to value-adding processing options.",{"$f":"'Value Chain'!U10","v":0},{"$f":"VLOOKUP(D10,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},-1,null,{"$error":"#N/A"},null,null,"Max score for a driver is 16 "]
["Driver","Supply and value chain","I have ready access to my target market/s. ",{"$f":"'Value Chain'!U15","v":0},{"$f":"VLOOKUP(D11,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},-1,null,{"$error":"#N/A"}]
["Driver","Supply and value chain","It is easy for me to access/utilise the natural resources (e.g., water, native vegetation) needed for production. ",{"$f":"'Value Chain'!U20","v":0},{"$f":"VLOOKUP(D12,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},-1,null,{"$error":"#N/A"}]
["Driver","Supply and value chain","I have timely access to the inputs (e.g., chemicals, fertilisers) needed for production.",{"$f":"'Value Chain'!U25","v":0},{"$f":"VLOOKUP(D13,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},-1,null,{"$error":"#N/A"}]
["Driver","Biosecurity","My industry has an effective biosecurity management plan. ",{"$f":"Biosecurity!U10","v":0},{"$f":"VLOOKUP(D14,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},-1,null,{"$error":"#N/A"}]
["Driver","Biosecurity","I have an effective biosecurity management plan. ",{"$f":"Biosecurity!U15","v":0},{"$f":"VLOOKUP(D15,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},-1,null,{"$error":"#N/A"}]
["Driver","Biosecurity","There is a high or increasing likelihood of biosecurity incursions.",{"$f":"Biosecurity!U20","v":0},{"$f":"VLOOKUP(D16,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Driver","Biosecurity","There will be a significant negative impact ( > 20% decline in profitability) on my business if these biosecurity incursions occur. ",{"$f":"Biosecurity!U25","v":0},{"$f":"VLOOKUP(D17,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"},null," "]
["Driver","Biosecurity","If impacted, I will be able to manage the financial impact of these costs. ",{"$f":"Biosecurity!U30","v":0},{"$f":"VLOOKUP(D18,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},-1,null,{"$error":"#N/A"}]
["Driver","Climate","My enterprise performance is negatively impacted by extreme weather events and climate variability.",{"$f":"Climate!U10","v":0},{"$f":"VLOOKUP(D19,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Driver","Climate","There is a high or increasing likelihood of exposure to extreme weather events (e.g., drought, floods, heatwaves, bushfire) in the region/s where I farm.",{"$f":"Climate!U15","v":0},{"$f":"VLOOKUP(D20,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Driver","Climate","I am currently able to manage the effect of extreme weather events and climate variability on my enterprise e.g., sediment fence construction, adequate fire suppression activities. ",{"$f":"Climate!U20","v":0},{"$f":"VLOOKUP(D21,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},-1,null,{"$error":"#N/A"}]
["Driver","Climate","I anticipate that my ability to manage the effect of extreme weather events and climate variability to be diminished in the future. ",{"$f":"Climate!U25","v":0},{"$f":"VLOOKUP(D22,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Product differentiation","My product/enterprise is differentiated from my competitors in the market.",{"$f":"'Product differentiation'!U10","v":0},{"$f":"VLOOKUP(D23,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Product differentiation","There is potential for further product differentiation in the market to boost my profitability.",{"$f":"'Product differentiation'!U15","v":0},{"$f":"VLOOKUP(D24,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Product differentiation","I am able to obtain a price premium for my product through certification (e.g., organic certification, sustainable production certification etc.).",{"$f":"'Product differentiation'!U20","v":0},{"$f":"VLOOKUP(D25,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Product differentiation","I have the skills and resources to differentiate my product.",{"$f":"'Product differentiation'!U25","v":0},{"$f":"VLOOKUP(D26,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Product differentiation","My efforts at product differentiation have had a positive effect on my profitability.",{"$f":"'Product differentiation'!U30","v":0},{"$f":"VLOOKUP(D27,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Downstream processing","I am able to send my products downstream for processing, packaging, or value-adding/enhancing my product.",{"$f":"'Downstream processing'!U10","v":0},{"$f":"VLOOKUP(D28,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Downstream processing","There are opportunities for value adding to my products within the supply chain.",{"$f":"'Downstream processing'!U15","v":0},{"$f":"VLOOKUP(D29,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Downstream processing","I am able to distribute my products for sale.",{"$f":"'Downstream processing'!U20","v":0},{"$f":"VLOOKUP(D30,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Downstream processing","Profitability of my enterprise is constrained by a lack of investment in downstream processing capacity. ",{"$f":"'Downstream processing'!U25","v":0},{"$f":"VLOOKUP(D31,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Productivity","I consistently meet the quality and quantity expectations of my customers. ",{"$f":"'Improving productivity'!U10","v":0},{"$f":"VLOOKUP(D32,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Productivity","I can access the skills and information I need (e.g., agronomic advice) to optimise my productivity. ",{"$f":"'Improving productivity'!U15","v":0},{"$f":"VLOOKUP(D33,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Productivity","My production methods are up to date and reflect best practice guidelines for my business. ",{"$f":"'Improving productivity'!U20","v":0},{"$f":"VLOOKUP(D34,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Productivity","Further investment in productivity improvement (information from research and development initiatives, adoption of new technology) will improve my profitability.",{"$f":"'Improving productivity'!U25","v":0},{"$f":"VLOOKUP(D35,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Financial resilience","I have an understanding of financial management and financial products.",{"$f":"'Financial resilience'!U10","v":0},{"$f":"VLOOKUP(D36,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Financial resilience","I have a clear financial plan for my business moving forward.",{"$f":"'Financial resilience'!U15","v":0},{"$f":"VLOOKUP(D37,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Financial resilience","I build up cash reserves during good times to provide additional liquidity during lean years. ",{"$f":"'Financial resilience'!U20","v":0},{"$f":"VLOOKUP(D38,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Financial resilience","I have ready access to debt financing if I need it.",{"$f":"'Financial resilience'!U25","v":0},{"$f":"VLOOKUP(D39,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Building networks","I participate in an industry organisation such as advocacy groups, RDCs, local grower associations. (inclusive of local, state, and national levels).",{"$f":"'Building networks'!U10","v":0},{"$f":"VLOOKUP(D40,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Building networks","I have access to and participate in events, seminars, networking opportunties to learn more where I can. ",{"$f":"'Building networks'!U15","v":0},{"$f":"VLOOKUP(D41,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Building networks","My industry organisation arranges events, seminars, and networking opportunities where I can learn more about improving my business practices.",{"$f":"'Building networks'!U20","v":0},{"$f":"VLOOKUP(D42,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Building networks","I maintain good relations with people throughout my supply chain. ",{"$f":"'Building networks'!U25","v":0},{"$f":"VLOOKUP(D43,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Building networks","I am able to draw on my relationships with other growers. ",{"$f":"'Building networks'!U30","v":0},{"$f":"VLOOKUP(D44,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Diversification","I am able to change my land use for an alternative revenue generating purpose if my main farm or commodity become less financially viable. ",{"$f":"Diversification!U10","v":0},{"$f":"VLOOKUP(D45,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Diversification","I have more than one income-generating activity on my farm.",{"$f":"Diversification!U15","v":0},{"$f":"VLOOKUP(D46,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$f":"E46*F46","v":{"$error":"#N/A"}}]
["Strategies","Diversification","The diversity of my business makes me more secure during lean years. ",{"$f":"Diversification!U20","v":0},{"$f":"VLOOKUP(D47,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Diversification","I am confident in diversifying my business if necessary. ",{"$f":"Diversification!U25","v":0},{"$f":"VLOOKUP(D48,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]
["Strategies","Diversification","I am able to engage in non-farming diversification e.g., agritourism or off-farm income if needed. ",{"$f":"Diversification!U30","v":0},{"$f":"VLOOKUP(D49,Parameters!$B$3:$C$9,2,FALSE)","v":{"$error":"#N/A"}},1,null,{"$error":"#N/A"}]

{"sheet":"Parameters","index":1,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Likert scale answers","Rating",null,null,"Driver-Strategy pairings",null,null,null,null,null,null,null,null,null,"Enterprise selection matrix"]
[null,"Strongly Disagree",-3,null,null,"Pairing 1","Pairing 2","Pairing 3","Pairing 4","Pairing 5",null,null,null,null,null,{"$f":"F13","v":"Supply and value chain"},{"$f":"F14","v":"Biosecurity"},"Output 1",{"$f":"F15","v":"Market"},"Output 2"]
[null,"Disagree",-2,null,null,"Market","Climate","Costs","Biosecurity","Supply and value chain",null,null,null,null,null,{"$f":"HLOOKUP(P$3,$F$4:$J$8,2,FALSE)","v":"Downstream processing"},{"$f":"HLOOKUP(Q$3,$F$4:$J$8,2,FALSE)","v":"Diversification"},{"$f":"_xlfn._xlws.FILTER(P4:P9,COUNTIF(Q4:Q9,P4:P9))","v":"Financial resilience"},{"$f":"HLOOKUP(S$3,$F$4:$J$8,2,FALSE)","v":"Product differentiation"},{"$f":"_xlfn._xlws.FILTER(R4:R9,COUNTIF(S4:S9,R4:R9))","v":"Financial resilience"}]
[null,"Slightly Disagree",-1,null,null,"Product differentiation","Product differentiation","Improve productivity","Diversification","Downstream processing",null,null,null,null,null,{"$f":"HLOOKUP(P$3,$F$4:$J$8,3,FALSE)","v":"Financial resilience"},{"$f":"HLOOKUP(Q$3,$F$4:$J$8,3,FALSE)","v":"Building networks"},"Building networks",{"$f":"HLOOKUP(S$3,$F$4:$J$8,3,FALSE)","v":"Diversification"},"Building networks"]
[null,"Neither agree nor disagree",0,null,null,"Diversification","Diversification","Financial resilience","Building networks","Financial resilience",null,null,null,null,null,{"$f":"HLOOKUP(P$3,$F$4:$J$8,4,FALSE)","v":"Building networks"},{"$f":"HLOOKUP(Q$3,$F$4:$J$8,4,FALSE)","v":"Financial resilience"},"Diversification",{"$f":"HLOOKUP(S$3,$F$4:$J$8,4,FALSE)","v":"Financial resilience"},"Diversification"]
[null,"Slightly Agree",1,null,null,"Financial resilience","Improve productivity","Building networks","Financial resilience","Building networks",null,null,null,null,null,{"$f":"HLOOKUP(P$3,$F$4:$J$8,5,FALSE)","v":"Diversification"},{"$f":"HLOOKUP(Q$3,$F$4:$J$8,5,FALSE)","v":0},0,{"$f":"HLOOKUP(S$3,$F$4:$J$8,5,FALSE)","v":"Building networks"}]
[null,"Agree",2,null,null,"Building networks","Financial resilience",null,null,"Diversification",null,null,null,null,null,null,null,0]
[null,"Strongly Agree",3]
[]
[null,1,{"$f":"VLOOKUP(B11,$E$13:$F$17,2,FALSE)","v":{"$error":"#N/A"}},null,null,"Driver rating"]
[null,2,{"$f":"VLOOKUP(B12,$E$13:$F$17,2,FALSE)","v":{"$error":"#N/A"}},null,null,"Driver","Score","Number of questions","High","Very High","Number of questions2","Rank","Tie","Tie2",null,null,null,"Total risk score","Risk level",null,"Total strategy rating","Risk level",null,"Text for resources page"]
[null,3,{"$error":"#N/A"},null,{"$f":"Table5[[#This Row],[Tie2]]","v":{"$error":"#N/A"}},"Supply and value chain",{"$f":"SUMIFS(Table1[Adjusted score],Table1[Title],F13)/4*4/Table5[[#This Row],[Number of questions]]","v":{"$error":"#N/A"}},{"$f":"COUNTIF(Table1[Title],\"Supply and value chain\")","v":4},11,16,4,{"$f":"_xlfn.RANK.EQ(G13,$G$13:$G$17,0)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($L$13:Table5[[#This Row],[Rank]],Table5[[#This Row],[Rank]])>1,Table5[[#This Row],[Rank]]+1,Table5[[#This Row],[Rank]])","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($M$13:Table5[[#This Row],[Tie]],Table5[[#This Row],[Tie]])>1,Table5[[#This Row],[Tie]]+1,Table5[[#This Row],[Tie]])","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"21/4","v":5.25},1,"room for improvement",{"$f":"H34/4","v":4.5},"This page contains a list of information and resources made available online. These resources will contain information that might be useful for your enterprise. "]
[null,null,null,null,{"$f":"Table5[[#This Row],[Tie2]]","v":{"$error":"#N/A"}},"Biosecurity",{"$f":"SUMIFS(Table1[Adjusted score],Table1[Title],F14)/4*4/Table5[[#This Row],[Number of questions]]","v":{"$error":"#N/A"}},{"$f":"COUNTIF(Table1[Title],\"Biosecurity\")","v":5},11,16,5,{"$f":"_xlfn.RANK.EQ(G14,$G$13:$G$17,0)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($L$13:Table5[[#This Row],[Rank]],Table5[[#This Row],[Rank]])>1,Table5[[#This Row],[Rank]]+1,Table5[[#This Row],[Rank]])","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($M$13:Table5[[#This Row],[Tie]],Table5[[#This Row],[Tie]])>1,Table5[[#This Row],[Tie]]+1,Table5[[#This Row],[Tie]])","v":{"$error":"#N/A"}},null,null,null,0,"low",null,2,"room for improvement",null,"The resources provided in this page are gathered from a range of publications and industries. You might be given a recommendation to a source that may have been originally catered to a different industry to yours because we believe that there are still valueable lessons and insights that can be drawn from this information. This is not an exhaustive list of information, but it is meant to act as a starting point to for producers to understand the drivers that they are vulnerable to and what options they can explore to build their robustness. "]
[null,null,null,null,{"$f":"Table5[[#This Row],[Tie2]]","v":{"$error":"#N/A"}},"Market",{"$f":"SUMIFS(Table1[Adjusted score],Table1[Title],F15)/4*4/Table5[[#This Row],[Number of questions]]","v":{"$error":"#N/A"}},{"$f":"COUNTIF(Table1[Title],\"Market\")","v":4},11,16,4,{"$f":"_xlfn.RANK.EQ(G15,$G$13:$G$17,0)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($L$13:Table5[[#This Row],[Rank]],Table5[[#This Row],[Rank]])>1,Table5[[#This Row],[Rank]]+1,Table5[[#This Row],[Rank]])","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($M$13:Table5[[#This Row],[Tie]],Table5[[#This Row],[Tie]])>1,Table5[[#This Row],[Tie]]+1,Table5[[#This Row],[Tie]])","v":{"$error":"#N/A"}},null,null,null,1,"low",null,3,"room for improvement",null,"Based on how you have answered the questions on the drivers, the strategies that you are recommended to look further into are:"]
[null,null,null,null,{"$f":"Table5[[#This Row],[Tie2]]","v":{"$error":"#N/A"}},"Climate",{"$f":"SUMIFS(Table1[Adjusted score],Table1[Title],F16)/4*4/Table5[[#This Row],[Number of questions]]","v":{"$error":"#N/A"}},{"$f":"COUNTIF(Table1[Title],\"Climate\")","v":4},11,16,4,{"$f":"_xlfn.RANK.EQ(G16,$G$13:$G$17,0)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($L$13:Table5[[#This Row],[Rank]],Table5[[#This Row],[Rank]])>1,Table5[[#This Row],[Rank]]+1,Table5[[#This Row],[Rank]])","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($M$13:Table5[[#This Row],[Tie]],Table5[[#This Row],[Tie]])>1,Table5[[#This Row],[Tie]]+1,Table5[[#This Row],[Tie]])","v":{"$error":"#N/A"}},null,null,null,2,"low",null,4,"room for improvement",null,"Based on how you have answered the questions on the strategies, you are recommended to look further into:"]
[null,null,null,null,{"$f":"Table5[[#This Row],[Tie2]]","v":{"$error":"#N/A"}},"Costs",{"$f":"SUMIFS(Table1[Adjusted score],Table1[Title],F17)/4*4/Table5[[#This Row],[Number of questions]]","v":{"$error":"#N/A"}},{"$f":"COUNTIF(Table1[Title],\"Costs\")","v":4},11,16,4,{"$f":"_xlfn.RANK.EQ(G17,$G$13:$G$17,0)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($L$13:Table5[[#This Row],[Rank]],Table5[[#This Row],[Rank]])>1,Table5[[#This Row],[Rank]]+1,Table5[[#This Row],[Rank]])","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($M$13:Table5[[#This Row],[Tie]],Table5[[#This Row],[Tie]])>1,Table5[[#This Row],[Tie]]+1,Table5[[#This Row],[Tie]])","v":{"$error":"#N/A"}},null,null,null,3,"low",null,5,"room for improvement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"low",null,6,"room for improvement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"moderate",null,7,"moderately fluent",null,"Text for driver summary page"]
[null,null,null,null,null,"Total risk rating",{"$f":"SUM(G13:G17)","v":{"$error":"#N/A"}},{"$f":"3*5","v":15},null,null,null,null,null,null,null,null,null,6,"moderate",null,8,"moderately fluent",null,{"$f":"\"The chart on the left shows the additional contribution of each external driver to your overall risk exposure, and the diagram shows that\"&\" your overall risk level is rated at \"&ROUNDUP(Parameters!G20,0)&\" out of a possible \"&Parameters!G21&\", indicating that your risk level is considered \"&IF(Parameters!G20>0,(VLOOKUP(ROUNDUP(Parameters!G20,0),Parameters!O14:P34,2,FALSE)),\"Low\")&\". \"&CHAR(10)&CHAR(10)&\" *A positive score indicates that you are relatively more able to capitalise on boom factors for that driver. Whereas a negative score indicates that you are relatively more vulnerable to bust drivers for that driver. \"&CHAR(10)&CHAR(10)&\"The three drivers that you are relatively more exposed to are \"&Parameters!C11&\", \"&Parameters!C12&\", and \"&Parameters!C13&\".\"&CHAR(10)&CHAR(10)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Possible risk rating",{"$f":"H20","v":15},null,null,null,null,null,null,null,null,{"$f":"15/3","v":5},null,7,"moderate",null,9,"moderately fluent"]
[null,1,{"$f":"VLOOKUP(B22,$E$26:$F$31,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"18/3","v":6},null,8,"moderate",null,10,"moderately fluent"]
[null,2,{"$f":"VLOOKUP(B23,$E$26:$F$31,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"moderate",null,11,"moderately fluent"]
[null,3,{"$error":"#N/A"},null,null,"Strategy rating",null,null,null,null,null,null,null,null,null,null,null,10,"high",null,12,"moderately fluent",null,{"$f":"\"The chart on the left shows the rating for each strategy, and the diagram shows that\"&\" your total strategy rating is rated at \"&ROUNDUP(Parameters!G34,0)&\" out of a possible \"&Parameters!G35&\", indicating that your strategy level is considered \"&IF(Parameters!G34>0,(VLOOKUP(ROUNDUP(Parameters!G34,0),Parameters!R13:S36,2)),\"Low\")&\". A negative score indicates that you are relatively less well versed in that strategy whereas a positive score indicates that you are relatively more well versed in that strategy. \"&CHAR(10)&CHAR(10)&\" The three strategies that you are relatively more well versed in are \"&Parameters!C22&\", \"&Parameters!C23&\", and \"&Parameters!C24&\".\"&CHAR(10)&CHAR(10)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Driver","Score","Number of questions","Rank","Tie","Tie2",null,null,null,null,null,null,11,"high",null,13,"highly fluent"]
[null,null,null,null,{"$f":"Table6[[#This Row],[Tie2]]","v":{"$error":"#N/A"}},{"$f":"'Question bank'!B23","v":"Product differentiation"},{"$f":"SUMIFS(Table1[Adjusted score],Table1[Title],Parameters!F26)/4*4/Table6[[#This Row],[Number of questions]]","v":{"$error":"#N/A"}},{"$f":"COUNTIF(Table1[Title],\"Product differentiation\")","v":5},{"$f":"_xlfn.RANK.EQ(G26,Table6[Score],0)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($I$26:Table6[[#This Row],[Rank]],Table6[[#This Row],[Rank]])>1,Table6[[#This Row],[Rank]]+1,Table6[[#This Row],[Rank]])","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($J$26:Table6[[#This Row],[Tie]],Table6[[#This Row],[Tie]])>1,Table6[[#This Row],[Tie]]+1,Table6[[#This Row],[Tie]])","v":{"$error":"#N/A"}},null,null,null,null,"Drivers",null,12,"high",null,14,"highly fluent"]
[null,6,{"$f":"VLOOKUP(B27,$E$26:$F$31,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"Table6[[#This Row],[Tie2]]","v":{"$error":"#N/A"}},{"$f":"'Question bank'!B40","v":"Building networks"},{"$f":"SUMIFS(Table1[Adjusted score],Table1[Title],Parameters!F27)/4*4/Table6[[#This Row],[Number of questions]]","v":{"$error":"#N/A"}},{"$f":"COUNTIF(Table1[Title],\"Building networks\")","v":5},{"$f":"_xlfn.RANK.EQ(G27,Table6[Score],0)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($I$26:Table6[[#This Row],[Rank]],Table6[[#This Row],[Rank]])>1,Table6[[#This Row],[Rank]]+1,Table6[[#This Row],[Rank]])","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($J$26:Table6[[#This Row],[Tie]],Table6[[#This Row],[Tie]])>1,Table6[[#This Row],[Tie]]+1,Table6[[#This Row],[Tie]])","v":{"$error":"#N/A"}},null,null,null,5,"Number of drivers",null,13,"high",null,15,"highly fluent"]
[null,5,{"$f":"VLOOKUP(B28,$E$26:$F$31,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"Table6[[#This Row],[Tie2]]","v":{"$error":"#N/A"}},{"$f":"'Question bank'!B32","v":"Productivity"},{"$f":"SUMIFS(Table1[Adjusted score],Table1[Title],Parameters!F28)/4*4/Table6[[#This Row],[Number of questions]]","v":{"$error":"#N/A"}},{"$f":"COUNTIF(Table1[Title],\"Productivity\")","v":4},{"$f":"_xlfn.RANK.EQ(G28,Table6[Score],0)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($I$26:Table6[[#This Row],[Rank]],Table6[[#This Row],[Rank]])>1,Table6[[#This Row],[Rank]]+1,Table6[[#This Row],[Rank]])","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($J$26:Table6[[#This Row],[Tie]],Table6[[#This Row],[Tie]])>1,Table6[[#This Row],[Tie]]+1,Table6[[#This Row],[Tie]])","v":{"$error":"#N/A"}},null,null,null,4,"Number of questions per driver",null,14,"high",null,16,"highly fluent"]
[null,null,null,null,{"$f":"Table6[[#This Row],[Tie2]]","v":{"$error":"#N/A"}},{"$f":"'Question bank'!B36","v":"Financial resilience"},{"$f":"SUMIFS(Table1[Adjusted score],Table1[Title],Parameters!F29)/4*4/Table6[[#This Row],[Number of questions]]","v":{"$error":"#N/A"}},{"$f":"COUNTIF(Table1[Title],\"Financial resilience\")","v":4},{"$f":"_xlfn.RANK.EQ(G29,Table6[Score],0)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($I$26:Table6[[#This Row],[Rank]],Table6[[#This Row],[Rank]])>1,Table6[[#This Row],[Rank]]+1,Table6[[#This Row],[Rank]])","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($J$26:Table6[[#This Row],[Tie]],Table6[[#This Row],[Tie]])>1,Table6[[#This Row],[Tie]]+1,Table6[[#This Row],[Tie]])","v":{"$error":"#N/A"}},null,null,null,3,"Max score per question",null,15,"high",null,17,"highly fluent"]
[null,null,null,null,{"$f":"Table6[[#This Row],[Tie2]]","v":{"$error":"#N/A"}},{"$f":"'Question bank'!B45","v":"Diversification"},{"$f":"SUMIFS(Table1[Adjusted score],Table1[Title],Parameters!F30)/4*4/Table6[[#This Row],[Number of questions]]","v":{"$error":"#N/A"}},{"$f":"COUNTIF(Table1[Title],\"Diversification\")","v":5},{"$f":"_xlfn.RANK.EQ(G30,Table6[Score],0)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($I$26:Table6[[#This Row],[Rank]],Table6[[#This Row],[Rank]])>1,Table6[[#This Row],[Rank]]+1,Table6[[#This Row],[Rank]])","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($J$26:Table6[[#This Row],[Tie]],Table6[[#This Row],[Tie]])>1,Table6[[#This Row],[Tie]]+1,Table6[[#This Row],[Tie]])","v":{"$error":"#N/A"}},null,null,null,{"$f":"O27*O28*O29/4","v":15},null,null,null,null,null,18,"highly fluent"]
[null,null,null,null,{"$f":"Table6[[#This Row],[Tie2]]","v":{"$error":"#N/A"}},{"$f":"'Question bank'!B28","v":"Downstream processing"},{"$f":"SUMIFS(Table1[Adjusted score],Table1[Title],Parameters!F31)/4*4/Table6[[#This Row],[Number of questions]]","v":{"$error":"#N/A"}},{"$f":"COUNTIF(Table1[Title],\"Downstream processing\")","v":4},{"$f":"_xlfn.RANK.EQ(G31,Table6[Score],0)","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($I$26:Table6[[#This Row],[Rank]],Table6[[#This Row],[Rank]])>1,Table6[[#This Row],[Rank]]+1,Table6[[#This Row],[Rank]])","v":{"$error":"#N/A"}},{"$f":"IF(COUNTIF($J$26:Table6[[#This Row],[Tie]],Table6[[#This Row],[Tie]])>1,Table6[[#This Row],[Tie]]+1,Table6[[#This Row],[Tie]])","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strategies"]
[null,null,null,null,null,"Total strategy rating",{"$f":"SUM(G26:G31)","v":{"$error":"#N/A"}},18,null,null,null,null,null,null,6,"Number of strategies"]
[null,null,null,null,null,"Possible Strategy rating",{"$f":"H34","v":18},null,null,null,null,null,null,null,4,"Number of statements per strategy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Max score per question"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"4","v":4},"Adjustment factor"]
[null,"Count the number of questions (total) ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O34*O35*O36/O37","v":18},"Max possible score for strategies"]
[null,"Count the number of questions (completed) ",null,null,null,"Progress bar"]
[null,null,null,null,null,null,"Percentage complete","Value (absolute)",null,null,null,null,null,null,null," *A negative score indicates that you are relatively less exposed and can capitalise on boom factors for that driver. Whereas a positive score indicates that you are relatively more vulnerable to bust drivers for that driver. A score of 0 means that it has the potential of either being a positive or negative driver for your enterprise. "]
[null,"Number of driver questions left ",null,null,null,null,{"$f":"H41/H42","v":0},{"$f":"SUMPRODUCT(--ISNUMBER(Table1[Adjusted score]))","v":0},null,null,null,null,null,null,null,"The more positive the score is, the more exposed you are to boom factors relative to bust drivers. The more negative the score is, the more you are exposed to bust factors relative to boom drivers. "]
[null,null,null,null,null,null,{"$f":"H42/H42","v":1},48,null,null,null,null,null,null,null," *A negative score indicates that you are relatively less well versed in that strategy whereas a positive score indicates that you are relatively more well versed in that strategy."]
[null,"Number of strategy questions left ",null,null,null,null,{"$f":"G42-G41","v":1},{"$f":"H42-H41","v":48},null,null,null,null,null,null,null,"The more positive the score is, the more fluent your enterprise is at implementing strategies. The more negative the score is, the less fluent your enterprise is at implementing strategies. "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Text for analysis"]

{"sheet":"Driver Summary","index":2,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":true,"merged":[[2,2,4,20],[30,2,32,18],[10,13,28,20],[7,13,9,20]]}
[]
[]
[null,null,"Summary -  Drivers"]
[]
[]
[null,null,"This page shows you your relative risk rating for the five different drivers. "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary analysis on your enterprise's sensitivity to external drivers"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"The chart on the left shows the additional contribution of each external driver to your overall risk exposure, and the diagram on the right shows that\"&\" your overall risk level is rated at \"&ROUNDUP(Parameters!G20,0)&\", indicating that your risk level is considered \"&IF(Parameters!G20>0,(VLOOKUP(ROUNDUP(Parameters!G20,0),Parameters!R14:S34,2,FALSE)),\"low\")&\". \"&CHAR(10)&CHAR(10)& _xlfn.CONCAT(Parameters!P40)&CHAR(10)&CHAR(10)&_xlfn.CONCAT(Parameters!P41)&CHAR(10)&CHAR(10)&\"The three drivers that you are relatively more exposed to as potential bust factors are \"&Parameters!C11&\", \"&Parameters!C12&\", and \"&Parameters!C13&\".\"&CHAR(10)&CHAR(10)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Click here to resume the self-assessment tool to identify the strategies that might be viable for your enterprise."]

{"sheet":"Main","index":3,"n_rows":76,"n_cols":4,"rows_kept":76,"cut":false,"hidden":false,"merged":[[2,3,4,21],[6,3,56,21],[65,3,71,21],[75,3,78,21]]}
[]
[]
[null,null,null,"Vulnerability and Opportunities Self-Assessment Tool"]
[]
[]
[]
[null,null,null,"Our project aims to provide primary producers with a self-assessment tool to help them understand, at a high level, their strengths and weaknesses, their vulnerabilities to risk, and their capacity to take advantage of opportunities as they present themselves. \n\nThis self-assessment questionnaire will cover 2 main themes and is split into two halves:\n- The degree of exposure to 5 external drivers (Market, Cost, Climate, Biosecurity, and Value Chain).\n- The viability of strategies that can be undertaken to navigate your enterprise through these drivers. \n\nPrior to using the tool, you will need to click on \"enable content\" above.\n\n\n\n\n\nThis questionnaire will be set up as a series of Likert scale questions to assess the level of agreeableness to a series of statements. As you progress through the tool, you will be asked to select 1 of these 7 responses from the box to the right of the question. You will only be allowed to progress if you have answered all of the statements on the page. \n\n\n\n\n\n\n\n\n\n\n\n\n\nClick on the Start button above to begin the self-assessment tool. \n\nThis self-assessment tool is intenteded to be used in conjuction with the Boom and Bust Planning Guide which is currently in development. The guide will contain supplementary information for this tool."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Disclaimer"]
[null,null,null,"The recommendations from this tool are intented as a guide. The contents of this tool should not be used as a substitute to seeking further information. NCEconomics and the Australian Farm Institute make no warranty as to the accuracy of the information provided and will not be liable if the information is inaccurate, incomplete, or out of date. Nor will NCEconomics and the Australian Farm Institute be liable for direct or indirect damages arising from its use. "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Copyright"]
[null,null,null,"This work is copyright. Apart from any use permitted under the Copyright Act 1968, no part of it may be reproduced by any process without a written permission from the publisher. Requests and inquiries concerning reproduction rights should be directed to the publisher. "]

{"sheet":"Resources","index":4,"n_rows":117,"n_cols":14,"rows_kept":117,"cut":false,"hidden":true,"merged":[[3,2,4,14]]}
[]
[]
[null,null,"Resources"]
[null,null,{"$f":"_xlfn.CONCAT(Parameters!X13,Parameters!X14,CHAR(10),CHAR(10),CHAR(10),Parameters!X16)","v":"This page contains a list of information and resources made available online. These resources will contain information that might be useful for your enterprise. The resources provided in this page are gathered from a range of publications and industries. You might be given a recommendation to a source that may have been originally catered to a different industry to yours because we believe that there are still valueable lessons and insights that can be drawn from this information. This is not an exhaustive list of information, but it is meant to act as a starting point to for producers to understand the drivers that they are vulnerable to and what options they can explore to build their robustness. \n\n\nBased on how you have answered the questions on the strategies, you are recommended to look further into:"}]
[]
[null,null,{"$f":"_xlfn.CONCAT(\"i) \",Parameters!C27)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"_xlfn.CONCAT(\"ii) \", Parameters!C28)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[null,null,null,"Strategy",null,"Segment",null,null,"Title",null,"Descriptions",null,null,"Link"]
[]
[null,null,null,"1. What strategies are you interested in?","Column4","2. What segments of the strategies are you interested in?","Industry","Column3","Title","Column1","Description","Website","Column2","Link"]
[null,null,null,"Diversification",null,"Considerations for diversification ","Various",null,"Ag Vic Farm diversification decision-making",null,"Agriculture Vic framework which breaks down the decision of whether to diversify into 5 steps: Compatibility, Observing, Trialling, Complexity, and Resource Advantage. ",null,"https://agriculture.vic.gov.au/farm-management/business-management/new-landholders/farm-diversification-decisionmaking",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Diversification",null,"Considerations for diversification ","Various",null,"FarmTable 7 ways to diversify your farm",null,"Simple description for diversification options. Less detailed than the Ag Vic one.",null,"https://farmtable.com.au/part-1-7-ways-to-diversify-your-farm/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Downstream processing",null,"Vertical integration","Mung bean",null,"Vertical integration a winner for Queensland mungbean producers and processors",null,"Case study of the Australian Mungbean Company based in Central Queensland. The case study describes how they went through the process of vertical integration and the challenges that they face throughout this process.",null,"https://groundcover.grdc.com.au/grower-stories/northern/market-understanding-a-foundation-for-mungbean-operation",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Downstream processing",null,"Processing","Faba bean",null,"Vertical steps from paddock to packet",null,"Case study of Human Bean Co, a family farm based in Goondiwindi, Queensland to manage their supply chain by engaging in grain growing, processing, packaging, transport, and marketing. Discusses their philosophy on marketing and branding their own products and the benefits they can reap from this practice. ",null,"https://grdc.com.au/resources-and-publications/groundcover/groundcover-138-january-february-2019/vertical-steps-from-paddock-to-packet",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Financial Resilience",null,"Financial planing","Cropping ",null,"Simple Gross Margin Calculator",null,"Simple gross margin calculator for cropping enterprise.",null,"https://soilquality.org.au/calculators/gross_margin",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Financial Resilience",null,"Financial planing","Various",null,"GRDC Grownotes Farm Business Models",null,"A long form report that discusses farm business models and potential modifications",null,"https://grdc.com.au/Business-planning-guide-for-farmers-recovering-from-drought?utm_source=website&utm_medium=short_url&utm_campaign=ORM00004&utm_term=&utm_content=Business%20planning%20guide%20for%20farmers%20recovering%20from%20drought",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Financial Resilience",null,"Financial planing","Various",null,"GRDC Module Business planning guide for farmers recovering from drought",null,"The guidelines in the report are tailored to businesses with limited finances. It can also provide guidance to businesses in a stronger financial position but who are also seeking to minimise risk in other parts of their business.  ",null,"https://grdc.com.au/Business-planning-guide-for-farmers-recovering-from-drought?utm_source=website&utm_medium=short_url&utm_campaign=ORM00004&utm_term=&utm_content=Business%20planning%20guide%20for%20farmers%20recovering%20from%20drought",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Financial Resilience",null,"Financial planning","Various",null,"GRDC Module on understanding the financial performance of your business",null,"Introduces concepts such as liquidity and efficiency and how to monitor/measure them. This includes a desciption of the relevant variables that have to be taken into consideration. ",null,"https://grdc.com.au/resources-and-publications/all-publications/publications/2015/01/farming-the-business-manual/FB_Manual_Document_3rd-edition_Jul19-WEB-72dpi070-149.pdf",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Financial Resilience",null,"Cost reduction","Various",null,"Energy savings ideas for agricultural businesses",null,"While it is a source from Business Queensland, it houses some useful tips for how to understand energy use and costs, and provides some pointers on adopting other energy efficient equipment and practices for irrigation, refrigeration and cold storage, hot-water systems, lighting and ventilation, and solar PV systems.",null,"https://www.business.qld.gov.au/industries/farms-fishing-forestry/agriculture/agribusiness/energy-efficiency/savings-ideas",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Improving productivity",null,"Agronomy ","Livestock",null,"MLA tools and calculators",null,"Various tools provided by MLA to assist producers of red meat in decision making. Grouped into feed calculators and pasture calculators. The webpage also houses other useful sources to calculate your cost of production and other animal health and nutrition calculators. ",null,"https://www.mla.com.au/extension-training-and-tools/tools-calculators/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Improving productivity",null,"Agronomy ","Livestock",null,"Beef water calculator",null,"Water requirement calculator for beef cattle in Vic. Provides a monthly and cumulative figure.",null,"https://www.feedinglivestock.vic.gov.au/stock-water-resources/beef-water-calculator/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Improving productivity",null,"Building knowledge","Livestock, cropping",null,"Managing drought ",null,"SA information page for farm management strategies on drought management.",null,"https://www.pir.sa.gov.au/emergency_management/drought_support/drought_resources",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Improving productivity",null,"Building knowledge","Livestock ",null,"MLA stocking rate calculator",null,"The stocking rate calculator is designed to determine the number of cattle or sheep you should put into a paddock based on its carrying capacity.",null,"https://www.mla.com.au/extension-training-and-tools/tools-calculators/stocking-rate-calculator/ ",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Improving productivity",null,"Building knowledge","Livestock",null,"MLA resource hub",null,"Collection of resources for a range of topics ",null,"https://www.mla.com.au/extension-training-and-tools/resource-hubs/ ",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Improving productivity",null,"Technology","Various",null,"Producer Technology Uptake Program",null,"National AgriFutures initiative to support eligible producer groups and Ag schools to increase adoption of tech solutions on farm. ",null,"https://agrifutures.com.au/national-rural-issues/producer-technology-uptake-program/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Improving productivity",null,"Agronomy ","Various",null,"Ag Vic tools and calculators",null,"Hosts dry matter, farm water, summer water, and hay vs grain calculators",null,"https://agriculture.vic.gov.au/support-and-resources/tools-and-calculators ",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Improving productivity",null,"Agronomy ","Various",null,"Designing your own farm experiments",null,"A guide for farmers to learn how to design their own farm experiments and what issues to consider. ",null,"https://grdc.com.au/resources-and-publications/all-publications/publications/2021/designing-your-own-on-farm-experiments",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Improving productivity",null,"Climate resilience","Various",null,"DAWE Drought Resilience Self-Assessment Tool",null,"A free tool that provides producers with an opportunity to assess their resilience against climate risks and provides unique options to make their practice more robust over time.",null,"https://www.awe.gov.au/agriculture-land/farm-food-drought/drought/future-drought-fund/drought-resilience-self-assessment-tool",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Improving productivity",null,"Adoption of technology ","Grains ",null,"SoilWaterApp",null,"Provides growers with an estimate of plant available water in the soil during a fallow and early crop phase. The app estimates soil water using a water balance model and other inputs.",null,"http://soilwaterapp.net.au",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Networks and relationships",null,"Internal management networks","Various",null,"GRDC Module on Leadership And People Management",null,"Discusses the features of effective leadership and how to develop management skills essential to any farm business. ",null,"https://grdc.com.au/resources-and-publications/all-publications/publications/2015/01/farming-the-business-manual/FB_Manual_Document_3rd-edition_Jul19-WEB-72dpi028-033.pdf",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Networks and relationships",null,"Succession planning","Various",null,"GRDC Module on Succession planning",null,"Discusses the important issues to consider in the succession planning process e.g., timing, people management. Financial capacity, business transfer, meeting",null,"https://grdc.com.au/resources-and-publications/all-publications/publications/2015/01/farming-the-business-manual/FB_Manual_Document_3rd-edition_Jul19-WEB-72dpi196-207.pdf",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Networks and relationships",null,"Farming models","Various",null,"Possible business models and associated strategies",null,"Explores three different major farming business models - family farming model, collaborative model, and the corporate model. Also considers the pros and cons of leasing and sharing farming land  ",null,"https://grdc.com.au/resources-and-publications/all-publications/publications/2015/01/farming-the-business-manual/FB_Manual_Document_3rd-edition_Jul19-WEB-72dpi184-195.pdf",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Product differentiation",null,"Quality assurance","Cotton",null,"Cotton Australia myBMP",null,"Best Management Practice (BMP) program for the Australian Cotton industry. This is a summary of the myBMP program and what cotton growers can stand to gain from following through with the accreditation. This may be relevant to other industries as an indication for what the benefits are of a similar accreditation program for their industry.",null,"https://cottonaustralia.com.au/mybmp",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Product differentiation",null,"Quality assurance","Beekeeping",null,"BQUal",null,"Quality assurance system for beekeepers where they can obtain B-Qual certification by going through training and an enterprise audit. May be relevant to other industries to understand what the process of certification is like",null,"https://bqual.com.au/Why",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Product differentiation",null,"Marketing and consumer education","Various",null,"AgriFutures Provenance Storytelling Guide - Producer Templates",null,"Templates for businesses to who want to devise strategy of communicating a unique story about their product to their customers. Paired with the AgriFutures Provenance Storytelling Guide - Stories for success. ",null,"https://www.agrifutures.com.au/wp-content/uploads/2020/03/19-064.pdf",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Product differentiation",null,"Marketing and consumer education","Various",null,"AgriFutures Provenance Storytelling Guide - Stories for success",null,"Handbook with a decision-making framework to aid producers in determining how and where to communicate the provenance stories with consideration of the target market and available resources. To be paired with AgriFutures Provenance Storytelling Guide - Producer Templates. ",null,"https://www.agrifutures.com.au/wp-content/uploads/2020/02/19-063-2.pdf",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Diversification",null,"Output Differentiation","Agritourism",null,"Communities in Transition - Agritourism",null,"Collection of resources to help transition into providing agritourism services.",null,"https://www.cleangrowthchoices.org/diverse-farm-agritourism",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Downstream processing",null,"Vertical integration","Various",null,"Communities in Transition - Vertical Integration - Supply Chains",null,"Collection of resources to help transition and make suggestions to expand business through vertical integration",null,"https://www.cleangrowthchoices.org/vertical-integration",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Diversification",null,"Overview of Diversification","Various",null,"Why do Farming Families Diversify? Who are most likely, what are their reasons and what are the results?",null,"This report produced by AgriFutures is an attempt to better understand why farming families diversify their on-farm activities and what the outcomes of those diversifications are. The report is targeted at multiple stakeholders, including farming families who are considering diversification of their current business, and gives an overview of diversification and case studies.",null,"https://www.agrifutures.com.au/product/why-do-farming-families-diversify-who-are-most-likely-what-are-their-reasons-and-what-are-the-results/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Diversification",null,"Overview of Diversification","Various",null,"Reasons why Farmers Diversify: Northern Midlands, Tasmania",null,"This report produced by AgriFutures studies farm diversification in the Northern Midlands of Tasmania, which has suffered a downturn in the local wool industry and severe drought. In particular the focus of this study was on the 'how' and 'why' landholders diversify and evaluate the success of diversification. The report is targeted at multiple stakeholders, including farming families who are considering diversification of their current business.",null,"https://www.agrifutures.com.au/product/reasons-why-farmers-diversify-northern-midlands-tasmania/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Diversification",null,"Diversify Landholdings","Carbon Farming",null,"Carbon Farming Extension and Outreach: Case Studies for Farmers and Land Managers",null,"Case study analysis of implementing carbon faming in cattle, sheep and grain businesses and the degree of greenhouse emission reduction",null,"https://silo.tips/download/carbon-farming-extension-and-outreach",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Networks and relationships",null,"Information exchange within industry","Various",null,"Regional Development Australia Networks",null,"Regional Development Australia is a national network of committees made up of local leaders who work with all levels of government, business and community groups to support and broker economic development opportunities for their regions. Local RDA committees play an active and facilitative role to utilise their region's competitive advantage and seek economic opportunities and investment. ",null,"https://www.rda.gov.au/join-your-rda",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Networks and relationships",null,"Industry leadership and cohesion","Support for Young Farmers",null,"Future Farmers",null,"The Future Farmers Network aims to support younger people in the agriculture industry develop into better farmers. The network gives access to mentoring, scholarship/learning opportunities and connections with other young farmers.",null,"https://futurefarmers.com.au/about-us/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Networks and relationships",null,"Relationships with other parts of Supply Chain","Various",null,"Australian Farmers' Markets Association",null,"The Australian Farmers' Markets Association is a volunteer organisation which aims to support farmers seeking to sell their fresh produce directly to consumers through farmers' markets. The association aims to support the development of sustainable farmer's markets across the country. They facilitate information information regarding best-practice. ",null,"https://farmersmarkets.org.au/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Networks and relationships",null,"Industry leadership and cohesion","Various",null,"National Farmers Federation",null,"The National Farmers Federation advocates for farmers across a wide range of issues while also supporting farmers handle issues which threaten their business.",null,"https://nff.org.au/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Product differentiation",null,"Certification","Organic Products",null,"Australian Organics",null,"Australian Organic represents farmers who grow 'organic' products. This organisation provides certification of farmers produce to confirm they are 'organic' in nature before they are sold to wholesellers and supermarkets.",null,"https://austorganic.com/industry/certification-and-standards/certification-faqs/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Product differentiation",null,"Standards","Organic Products",null,"Australian Organics",null,"Australian Organic maintains the Australian Certified Organic Standard which is equivalent to international standards, allowing for export to areas such as the EU.",null,"https://austorganic.com/industry/certification-and-standards/standards/acos/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Product differentiation",null,"Certification","Various",null,"Aus-Meat and Aus-Qual",null,"Aus-Meat and Aus-Qual provide access to numerous auditing opportunities to certify a variety of products which enables farmers access to markets or to make representations about the quality of their products",null,"https://www.ausmeat.com.au/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Product differentiation",null,"Quality assurance","Eggs",null,"Australian Eggs",null,"The Egg Standards of Australia (ESA) is a voluntary quality assurance program for producers to demonstrate compliance and the quality of their egg products. This is a voluntary quality assurance program for egg producers. It may be relevant to other industries as it provides a brief description of the components required to suit business' needs and customer demands. ",null,"https://www.australianeggs.org.au/farming/egg-quality-standards",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Financial Resilience",null,"Asset and hazard recovery",null,null,"Ag VIC page with different hazards to monitor. Houses different guides to recover from bushfire e.g., how to protect soils and pasture, recovering horticulture, pasture recovery etc.",null,"Introduces concepts such as liquidity and efficiency and how to monitor/measure them. This includes a desciption of the relevant variables that have to be taken into consideration. ",null,"https://agriculture.vic.gov.au/farm-management/emergency-management/bushfires/what-to-do-after-a-bushfire/recover-assets-and-check-hazards#h2-6",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Downstream processing",null,"Traceability",null,null,"What is traceability?",null,"Discusses the six drivers of traceability across three categories - compliance and regulation, brand building, and production. Explains the importance of a traceability system in agriculture and the potential benefits that may arise. ",null,"https://agriculture.vic.gov.au/export/traceability/what-is-traceability",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Improving productivity ",null,"Building knowledge",null,null,"NSW DPI - Soil erosion factsheet ",null,"Houses a list of different resources regarding erosion management e.g., type of erosion, indicators of erosion, monitoring erosion, gully erosion, roads and tracks, and how to plan an erosion project. ",null,"https://www.dpi.nsw.gov.au/agriculture/soils/guides/soil-erosion/soil-erosion-factsheets",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Downstream processing",null,"Processing and packaging",null,null,"Regional Development Australia - Central West case study on processing and packaging (page 24)",null,"Case studies of a fibre and food processor who fill the gap in the market by providing processing services.",null,"https://rdacentralwest.org.au/wp-content/uploads/2019/10/FINAL-Value-Adding-to-Agriculture.pdf",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Downstream processing",null,"Investment in plant and machinery",null,null,"GRDC document on investment in plant and machinery. ",null,"Provides a framework for growers to think about how to invest in harvesting machinery in 4 steps. ",null,"https://grdc.com.au/resources-and-publications/grdc-update-papers/tab-content/grdc-update-papers/2018/06/efficiency-versus-over-investment-in-plant-and-equipment-guidelines",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Downstream processing",null,"Investment in plant and machinery",null,null,"GRDC document on how to determine the optimal investment on harvest machinery ",null,"Provides a framework for growers to understand when to invest in new harvesting machinery and maximise the gains from existing machinery.",null,"https://grdc.com.au/resources-and-publications/all-publications/factsheets/2017/10/determining-the-optimum-level-of-investment-in-harvest-machinery/GRDC_ORM_FS_InvestmentHarvestMachinery_LR.pdf",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Financial Resilience",null,"Managing debt/equity",null,null,"GRDC Understanding a bank's approach to farm business",null,"Provides a primer on how to understand banks' interest rates. This document is slightly dated but is still informative on the banks' approach. ",null,"https://grdc.com.au/resources-and-publications/all-publications/factsheets/2014/02/understanding-a-banks-approach",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]
[null,null,null,"Diversification",null,"Considerations for diversification ",null,null,"AgriFutures farmer's handbook to on-farm carbon management",null,"Handbook that introduces carbon sequestration concepts for farmers and is needed to participate in a carbon scheme. Provides the steps to sign up for a scheme and discusses the risks and returns associated for farmers.  ",null,"https://agrifutures.com.au/product/a-farmers-handbook-to-on-farm-carbon-management/",{"$f":"HYPERLINK(Table14[[#This Row],[Column2]],\"link\")","v":"link"}]

{"sheet":"Evaluation","index":5,"n_rows":40,"n_cols":31,"rows_kept":40,"cut":false,"hidden":true,"merged":[[2,3,4,21],[30,3,32,19],[5,3,5,21],[10,14,28,21],[7,14,9,21]]}
[]
[]
[null,null,null,"Summary -  Strategies"]
[]
[]
[null,null,null,"This page shows you the relative rating of the 6 strategies. The further out the lines are, the more well versed you are in the strategy. The lower the score is the less experienced you are in the strategy. "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary analysis on your enterprise's capacity to implement strategies"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"The chart on the left shows the rating for each strategy, and the diagram shows that\"&\" your total strategy rating is scored at \"&ROUNDUP(Parameters!G34,0)&\", indicating that your enterprise's capacity to implement strategies is considered to have \"&IF(Parameters!G34>0,(VLOOKUP(ROUNDUP(Parameters!G34,0),Parameters!U13:V36,2)),\"room for improvement\")&\". \"&CHAR(10)&CHAR(10)&_xlfn.CONCAT(Parameters!P42)&CHAR(10)&CHAR(10)&\"The three strategies that you are relatively more well versed in are \"&Parameters!C22&\", \"&Parameters!C23&\", and \"&Parameters!C24&\".\"&CHAR(10)&CHAR(10)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Thank you for completing the questionnaire. Click on the button to the right to be directed to the Resources page, where you can further explore information that is relevant to the strategies. "]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,"s"]

{"sheet":"Value Chain","index":6,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":true,"merged":[[19,3,21,3],[19,4,21,19],[19,20,21,21],[24,3,26,3],[24,4,26,19],[24,20,26,21],[2,3,4,21],[9,3,11,3],[9,4,11,19],[9,20,11,21],[14,3,16,3],[14,4,16,19],[14,20,16,21]]}
[]
[]
[null,null,null,"Value Chain"]
[]
[]
[null,null,null,"This refers to domestic processing capabilities, issues with transport and logistics, "]
[null,null,null,"accessibility of key inputs, and access to natural resources."]
[]
[]
[null,null,null,1,{"$f":"'Question bank'!C10","v":"I have ready access to value-adding processing options."}]
[]
[]
[]
[]
[null,null,null,2,{"$f":"'Question bank'!C11","v":"I have ready access to my target market/s. "}]
[]
[]
[]
[]
[null,null,null,3,{"$f":"'Question bank'!C12","v":"It is easy for me to access/utilise the natural resources (e.g., water, native vegetation) needed for production. "}]
[]
[]
[]
[]
[null,null,null,4,{"$f":"'Question bank'!C13","v":"I have timely access to the inputs (e.g., chemicals, fertilisers) needed for production."}]

{"sheet":"Biosecurity","index":7,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[[29,3,31,3],[29,4,31,19],[29,20,31,21],[2,3,4,21],[9,3,11,3],[9,4,11,19],[9,20,11,21],[14,3,16,3],[14,4,16,19],[14,20,16,21],[19,3,21,3],[19,4,21,19],[19,20,21,21],[24,3,26,3],[24,4,26,19],[24,20,26,21]]}
[]
[]
[null,null,null,"Biosecurity"]
[]
[]
[null,null,null,"This refers to pests, weeds, disease, and how they might affect market access and operations."]
[]
[]
[]
[null,null,null,1,{"$f":"'Question bank'!C14","v":"My industry has an effective biosecurity management plan. "}]
[]
[]
[]
[]
[null,null,null,2,{"$f":"'Question bank'!C15","v":"I have an effective biosecurity management plan. "}]
[]
[]
[]
[]
[null,null,null,3,{"$f":"'Question bank'!C16","v":"There is a high or increasing likelihood of biosecurity incursions."}]
[]
[]
[]
[]
[null,null,null,4,{"$f":"'Question bank'!C17","v":"There will be a significant negative impact ( > 20% decline in profitability) on my business if these biosecurity incursions occur. "}]
[]
[]
[]
[]
[null,null,null,5,{"$f":"'Question bank'!C18","v":"If impacted, I will be able to manage the financial impact of these costs. "}]

{"sheet":"Market","index":8,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":true,"merged":[[2,3,4,21],[24,4,26,19],[24,3,26,3],[24,20,26,21],[19,20,21,21],[14,20,16,21],[9,20,11,21],[9,4,11,19],[14,4,16,19],[19,4,21,19],[19,3,21,3],[14,3,16,3],[9,3,11,3]]}
[]
[]
[null,null,null,"Market"]
[]
[]
[null,null,null,"This refers to considerations such as market access and demand, prices that you receive for your product, "]
[null,null,null,"the level of competition,  consumer preferenecs, and a social license to operate."]
[]
[]
[null,null,null,1,{"$f":"'Question bank'!C2","v":"Prices are highly variable for my produce."}]
[]
[]
[]
[]
[null,null,null,2,{"$f":"'Question bank'!C3","v":"A change in prices has had a big impact on my revenues in the past."}]
[]
[]
[]
[]
[null,null,null,3,{"$f":"'Question bank'!C4","v":"I am able to quickly respond to changes in prices by changing production capacity or product mix. "}]
[]
[]
[]
[]
[null,null,null,4,{"$f":"'Question bank'!C5","v":"I anticipate an increase in demand for my produce in the near future and I am well-positioned to respond. "}]

{"sheet":"Cost","index":9,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":true,"merged":[[19,3,21,3],[19,4,21,19],[19,20,21,21],[24,3,26,3],[24,4,26,19],[24,20,26,21],[2,3,4,21],[9,3,11,3],[9,4,11,19],[9,20,11,21],[14,3,16,3],[14,4,16,19],[14,20,16,21]]}
[]
[]
[null,null,null,"Cost"]
[]
[]
[null,null,null,"These refer to costs such as energy/fuel, water and irrigation, fertiliser/chemicals, financing, "]
[null,null,null,"capital and plant and equipment expenditure."]
[]
[]
[null,null,null,1,{"$f":"'Question bank'!C6","v":"My costs of production are likely to vary significantly year-to-year. "}]
[]
[]
[]
[]
[null,null,null,2,{"$f":"'Question bank'!C7","v":"In the past, these changes in costs of production have had a big impact on my profitability."}]
[]
[]
[]
[]
[null,null,null,3,{"$f":"'Question bank'!C8","v":"I actively search for ways to minimise costs to control for them in the long-term. "}]
[]
[]
[]
[]
[null,null,null,4,{"$f":"'Question bank'!C9","v":"I am able to adequately manage variability in costs e.g., chemicals and fertiliser, labour, seeds, other input costs, etc. "}]

{"sheet":"Climate","index":10,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":true,"merged":[[19,3,21,3],[19,4,21,19],[19,20,21,21],[24,3,26,3],[24,4,26,19],[24,20,26,21],[2,3,4,21],[9,3,11,3],[9,4,11,19],[9,20,11,21],[14,3,16,3],[14,4,16,19],[14,20,16,21]]}
[]
[]
[null,null,null,"Climate"]
[]
[]
[null,null,null,"This refers to considerations such as drought, floods, rainfall, heatwaves, frost/hail, and bushfires."]
[]
[]
[]
[null,null,null,1,{"$f":"'Question bank'!C19","v":"My enterprise performance is negatively impacted by extreme weather events and climate variability."}]
[]
[]
[]
[]
[null,null,null,2,{"$f":"'Question bank'!C20","v":"There is a high or increasing likelihood of exposure to extreme weather events (e.g., drought, floods, heatwaves, bushfire) in the region/s where I farm."}]
[]
[]
[]
[]
[null,null,null,3,{"$f":"'Question bank'!C21","v":"I am currently able to manage the effect of extreme weather events and climate variability on my enterprise e.g., sediment fence construction, adequate fire suppression activities. "}]
[]
[]
[]
[]
[null,null,null,4,{"$f":"'Question bank'!C22","v":"I anticipate that my ability to manage the effect of extreme weather events and climate variability to be diminished in the future. "}]

{"sheet":"Downstream processing","index":11,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":true,"merged":[[19,3,21,3],[19,4,21,19],[19,20,21,21],[24,3,26,3],[24,4,26,19],[24,20,26,21],[2,3,4,21],[9,3,11,3],[9,4,11,19],[9,20,11,21],[14,3,16,3],[14,4,16,19],[14,20,16,21]]}
[]
[]
[null,null,null,"Downstream processing"]
[]
[]
[null,null,null,"This refers to processing and packaging capabilities, and whether there currently is (or will be) "]
[null,null,null,"sufficient investment in plants and equipment. Logistical capabilities are also considered. "]
[]
[]
[null,null,null,1,{"$f":"'Question bank'!C28","v":"I am able to send my products downstream for processing, packaging, or value-adding/enhancing my product."}]
[]
[]
[]
[]
[null,null,null,2,{"$f":"'Question bank'!C29","v":"There are opportunities for value adding to my products within the supply chain."}]
[]
[]
[]
[]
[null,null,null,3,{"$f":"'Question bank'!C30","v":"I am able to distribute my products for sale."}]
[]
[]
[]
[]
[null,null,null,4,{"$f":"'Question bank'!C31","v":"Profitability of my enterprise is constrained by a lack of investment in downstream processing capacity. "}]

{"sheet":"Product differentiation","index":12,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[[29,3,31,3],[29,4,31,19],[29,20,31,21],[2,3,4,21],[9,3,11,3],[9,4,11,19],[9,20,11,21],[14,3,16,3],[14,4,16,19],[14,20,16,21],[19,3,21,3],[19,4,21,19],[19,20,21,21],[24,3,26,3],[24,4,26,19],[24,20,26,21]]}
[]
[]
[null,null,null,"Product differentiation"]
[]
[]
[null,null,null,"This refers to quality assurance, compliance to standards, certifcation (e.g., organic), branding, "]
[null,null,null,"marketing, and consumer education. An example of this is using agritech to value add to cherry waste and"]
[null,null,null,"converting waste cherries into food for sale. "]
[]
[null,null,null,1,{"$f":"'Question bank'!C23","v":"My product/enterprise is differentiated from my competitors in the market."}]
[]
[]
[]
[]
[null,null,null,2,{"$f":"'Question bank'!C24","v":"There is potential for further product differentiation in the market to boost my profitability."}]
[]
[]
[]
[]
[null,null,null,3,{"$f":"'Question bank'!C25","v":"I am able to obtain a price premium for my product through certification (e.g., organic certification, sustainable production certification etc.)."}]
[]
[]
[]
[]
[null,null,null,4,{"$f":"'Question bank'!C26","v":"I have the skills and resources to differentiate my product."}]
[]
[]
[]
[]
[null,null,null,5,{"$f":"'Question bank'!C27","v":"My efforts at product differentiation have had a positive effect on my profitability."}]

{"sheet":"Improving productivity","index":13,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":true,"merged":[[19,3,21,3],[19,4,21,19],[19,20,21,21],[24,3,26,3],[24,4,26,19],[24,20,26,21],[2,3,4,21],[9,3,11,3],[9,4,11,19],[9,20,11,21],[14,3,16,3],[14,4,16,19],[14,20,16,21]]}
[]
[]
[null,null,null,"Improving productivity"]
[]
[]
[null,null,null,"This refers to building knowledge, access to data and information. Also considers genetics, "]
[null,null,null,"agronomy, and adoption of new technology."]
[]
[]
[null,null,null,1,{"$f":"'Question bank'!C32","v":"I consistently meet the quality and quantity expectations of my customers. "}]
[]
[]
[]
[]
[null,null,null,2,{"$f":"'Question bank'!C33","v":"I can access the skills and information I need (e.g., agronomic advice) to optimise my productivity. "}]
[]
[]
[]
[]
[null,null,null,3,{"$f":"'Question bank'!C34","v":"My production methods are up to date and reflect best practice guidelines for my business. "}]
[]
[]
[]
[]
[null,null,null,4,{"$f":"'Question bank'!C35","v":"Further investment in productivity improvement (information from research and development initiatives, adoption of new technology) will improve my profitability."}]

{"sheet":"Financial resilience","index":14,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":true,"merged":[[19,3,21,3],[19,4,21,19],[19,20,21,21],[24,3,26,3],[24,4,26,19],[24,20,26,21],[2,3,4,21],[9,3,11,3],[9,4,11,19],[9,20,11,21],[14,3,16,3],[14,4,16,19],[14,20,16,21]]}
[]
[]
[null,null,null,"Financial resilience"]
[]
[]
[null,null,null,"This refers to availability of cash reserves, management of debt/equity, adequate financial planning, "]
[null,null,null,"utilisation of financial tools e.g., forward contracts, regulatory compliance, and insurance. "]
[]
[]
[null,null,null,1,{"$f":"'Question bank'!C36","v":"I have an understanding of financial management and financial products."}]
[]
[]
[]
[]
[null,null,null,2,{"$f":"'Question bank'!C37","v":"I have a clear financial plan for my business moving forward."}]
[]
[]
[]
[]
[null,null,null,3,{"$f":"'Question bank'!C38","v":"I build up cash reserves during good times to provide additional liquidity during lean years. "}]
[]
[]
[]
[]
[null,null,null,4,{"$f":"'Question bank'!C39","v":"I have ready access to debt financing if I need it."}]

{"sheet":"Building networks","index":15,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[[29,3,31,3],[29,4,31,19],[29,20,31,21],[19,3,21,3],[19,4,21,19],[19,20,21,21],[24,3,26,3],[24,4,26,19],[24,20,26,21],[2,3,4,21],[9,3,11,3],[9,4,11,19],[9,20,11,21],[14,3,16,3],[14,4,16,19],[14,20,16,21]]}
[]
[]
[null,null,null,"Building networks"]
[]
[]
[null,null,null,"This refers to the strength of relationships with other aspects of the supply chain which leads to information exchange "]
[null,null,null,"within industry and industry leadership and cohesion. "]
[]
[]
[null,null,null,1,{"$f":"'Question bank'!C40","v":"I participate in an industry organisation such as advocacy groups, RDCs, local grower associations. (inclusive of local, state, and national levels)."}]
[]
[]
[]
[]
[null,null,null,2,{"$f":"'Question bank'!C41","v":"I have access to and participate in events, seminars, networking opportunties to learn more where I can. "}]
[]
[]
[]
[]
[null,null,null,3,{"$f":"'Question bank'!C42","v":"My industry organisation arranges events, seminars, and networking opportunities where I can learn more about improving my business practices."}]
[]
[]
[]
[]
[null,null,null,4,{"$f":"'Question bank'!C43","v":"I maintain good relations with people throughout my supply chain. "}]
[]
[]
[]
[]
[null,null,null,5,{"$f":"'Question bank'!C44","v":"I am able to draw on my relationships with other growers. "}]

{"sheet":"Diversification","index":16,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[[24,3,26,3],[24,4,26,19],[24,20,26,21],[29,3,31,3],[29,4,31,19],[29,20,31,21],[2,3,4,21],[9,3,11,3],[9,4,11,19],[9,20,11,21],[19,3,21,3],[19,4,21,19],[19,20,21,21],[14,20,16,21],[14,3,16,3],[14,4,16,19]]}
[]
[]
[null,null,null,"Diversification"]
[]
[]
[null,null,null,"This refers to diversification of crops, animals, output differentiation (e.g., expanding into the sale of processed goods), and "]
[null,null,null,"diversifying landholdings. "]
[]
[]
[null,null,null,1,{"$f":"'Question bank'!C45","v":"I am able to change my land use for an alternative revenue generating purpose if my main farm or commodity become less financially viable. "}]
[]
[]
[]
[]
[null,null,null,2,{"$f":"'Question bank'!C46","v":"I have more than one income-generating activity on my farm."}]
[]
[]
[]
[]
[null,null,null,2,{"$f":"'Question bank'!C47","v":"The diversity of my business makes me more secure during lean years. "}]
[]
[]
[]
[]
[null,null,null,3,{"$f":"'Question bank'!C48","v":"I am confident in diversifying my business if necessary. "}]
[]
[]
[]
[]
[null,null,null,4,{"$f":"'Question bank'!C49","v":"I am able to engage in non-farming diversification e.g., agritourism or off-farm income if needed. "}]