{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Front Page","Mandatory Risk Filter WT","Risk Working Table","Opportunity Working Table","Action and Monitoring Plans WT","Risks and Opportunities for AMP","Risk Causes","Opportunity Guidelines","Matrices","Further Help","Further Help (2)","Further Help (3)","Further Help (4)","Data Ranges"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":96,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Front Page","index":0,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,9,14,10],[2,1,2,10],[1,1,1,10],[3,7,3,10],[3,2,3,5],[13,1,13,10],[10,2,10,10]]}
[]
[null,"BIODIVERSITY RISK AND OPPORTUNITY ASSESSMENT (BROA)"]
[null,"This BROA tool helps users to capture the evidence from their assessment, and to identify, assess and prioritise biodiversity risks and opportunities in a systematic way. The output of the tool is a set of prioritised risks and opportunities with defined Action and Monitoring Plans."]
[null,null,"This tool should be used in a stepped approach working through the tables in the order below:",null,null,null,null,"Help is embedded within the worksheets - (Hover over cells with a red corner or follow help links)  Extra information is available here:"]
[]
[null,"1."]
[null,"2a."]
[null,"2b."]
[null,"3."]
[]
[null,null,"This sheet is an automatically populated reference page containing relevant information from the Risk and Opportunity Working Tables.  This information should not be edited."]
[]
[]
[null,"Please note: Macros must be enabled before using this workbook. \nThe workbook must be used and saved in a macro enabled xlsm format."]
[null,null,null,null,null,null,null,null,null,"Admin Log-in"]

{"sheet":"Mandatory Risk Filter WT","index":1,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[103,1,103,2],[107,1,107,2],[115,1,115,2],[124,1,124,2],[129,1,129,2],[117,1,117,2],[170,1,170,2],[214,1,214,2],[192,1,192,2],[138,1,138,2],[136,1,136,2],[177,1,177,2],[168,1,168,2],[207,1,207,2],[185,1,185,2],[181,1,181,2],[191,1,191,2],[195,1,195,2],[202,1,202,2],[193,1,193,2],[169,1,169,2],[162,1,162,2],[149,1,149,2],[155,1,155,2],[2,0,5,0],[4,1,4,2],[6,1,6,2],[5,1,5,2],[54,1,54,2],[2,1,2,2],[3,1,3,2],[99,1,99,2],[142,1,142,2],[141,1,141,2],[114,1,114,2],[61,1,61,2],[113,1,113,2],[92,1,92,2]]}
[null,"BIODIVERSITY RISK AND OPPORTUNITY ASSESSMENT - MANDATORY RISK FILTER"]
[null,"PHASE 2: STEP 1"]
["PHASE 2: STEP 1","\nWHAT ARE THE BIODIVERSITY RISKS IN THE LANDSCAPE?\n"]
[null,"Select 'yes', 'no' or 'maybe' against each of the biodiversity risk topics for EACH operating region. Have you identified any Biodiversity Opportunities? Please add these to Opportunity Working Table."]
[null,"OPERATING REGION:",null,"EXAMPLE: \nNorth District","Enter operating region here ","DESCRIPTION OF RISK ","PRELIMINARY OBSERVATIONS ON EVIDENCE"]
[null,"RISK TOPIC"]
[null,"TERRESTRIAL"]
[null,"1. Landscape:  "]
[" ",null,"1.1 large scale land conversion from a natural state to other uses/increase in large scale monocropping","no","Please select:"]
[" ",null,"1.2 loss or lack of agroforestry systems ","no"]
[" ",null,"1.3 loss of migratory routes / increase in barriers to movement of species, including loss or lack of native forest corridors for wildlife (e.g. tree lines, forests connecting protected areas)","yes"]
[" ",null,"1.4 other landscape risk, please specify (delete text and insert here) ","no"]
[" ","2. Terrestrial habitats:"]
[" ",null,"2.1 habitat loss, clearance or conversion to other uses","yes"]
[" ",null,"2.2 habitat fragmentation and/or habitat degradation","no"]
[" ",null,"2.3 encroachment or proximity (5km or less) to areas of biodiversity significance or protected areas","no"]
[" ",null,"2.4 loss or lack of natural vegetation buffers around land edges ","no"]
[" ",null,"2.5 other terrestrial habitat risk, please specify (delete text and insert here) ","no"]
[" ","3. Terrestrial species:"]
[" ",null,"3.1 decline in native terrestial populations (number and / or range) e.g. through habitat loss or hunting ","no"]
[" ",null,"3.2 increase or spread of invasive / exotic / pest terrestrial species or disease","no"]
[" ",null,"3.3 decline or loss of beneficial terrestrial species e.g. pest predators or pollinators / species used or valued by community","no"]
[" ",null,"3.4 increase in terrestrial species disturbance  (e.g. resulting in species behavioural change, increased conflict with humans such as from crop-raiding) ","no"]
[" ",null,"3.5 other terrestrial species risk, please specify (delete text and insert here) ","no"]
[" "]
[" ","SOIL"]
[" ","4. Soil erosion & structure:  "]
[" ",null,"4.1 soil erosion by water or  wind  (including landslides) ","no"]
[" ",null,"4.2 poor soil structure or decline in soil structure e.g. through compaction or loss of soil organic matter (also including hard pans)","no"]
[" ",null,"4.3 other soil erosion and structure risk, please specify (delete text and insert here) ","no"]
[" ","5. Soil health:"]
[" ",null,"5.1 low soil nutrient status or decrease in nutrient status,  acidification or altered soil pH (e.g. through significant use of agrochemicals/inorganic fertilizers)","yes"]
[" ",null,"5.2 soil salinization","no"]
[" ",null,"5.3 decline or loss of soil species (including beneficial pest predators, detritivores etc)","no"]
[" ",null,"5.4 other soil health risk, please specify (delete text and insert here) ","no"]
[" "]
[" ","AQUATIC  "]
[" ","6. Aquatic habitats:"]
[" ",null,"6.1 loss, conversion, change in aquatic habitat (e.g. through waterbodies being filled in/ dams or building water channels)","no"]
[" ",null,"6.2 loss or lack of watercourse buffer (e.g. natural forest or vegetation along a river)  ","maybe"]
[" ",null,"6.3 decline in water flow / quantity / water table (e.g. due to increase in siltation, groundwater extraction) ","no"]
[" ",null,"6.4 increase in water flow (e.g. flash flooding)","no"]
[" ",null,"6.5 other aquatic habitats risk, please specify (delete text and insert here) ","no"]
[" ","7. Aquatic health:"]
[" ",null,"7.1 poor water quality or reduction in water quality (e.g. through surface pollution, siltation or eutrophication (nitrates)) ","no"]
[" ",null,"7.2 groundwater pollution","no"]
[" ",null,"7.3 other aquatic health risk, please specify (delete text and insert here) ","no"]
[" ","8. Aquatic species:"]
[" ",null,"8.1 decline / disturbance of native aquatic species e.g. through hunting / collection / fishing","no"]
[" ",null,"8.2 increase or spread of invasive / exotic / pest aquatic species or disease","no"]
[" ",null,"8.3 decline or loss of beneficial aquatic species e.g. pest predators / species used or valued by community","no"]
[" ",null,"8.4 other aquatic species risk, please specify (delete text and insert here) ","no"]
[" "]

{"sheet":"Risk Working Table","index":2,"n_rows":200,"n_cols":33,"rows_kept":200,"cut":false,"hidden":false,"merged":[[0,32,3,32],[1,22,1,24],[0,2,0,6],[2,22,2,24],[2,25,2,27],[0,22,0,26],[2,0,4,0],[2,9,2,15],[2,18,3,18],[2,21,4,21],[1,2,1,4]]}
[null,null,"BIODIVERSITY RISK AND OPPORTUNITY ASSESSMENT - RISK WORKING TABLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIODIVERSITY RISK AND OPPORTUNITY ASSESSMENT - RISK MATRIX",null,null,null,null,null,null,null,null,null,"For each risk selected for Action and Monitoring Planning, information on operating region, site, risk topic, description and causes will be automatically copied to the Risks and Opportunities for AMP table. To transfer this information to the Action and Monitoring Plans Working Table click the ’Copy information’ button below.\n\nThe population of Action and Monitoring Plans is a one-time only process. This will take you on to fully complete your Action and Monitoring Plans."]
[null,null,"PHASE 2:  STEP 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHASE 2:  STEP 3"]
["PHASE 2: STEP 2",null,"OPERATING REGION","SITE(S)","RISK TOPIC","DESCRIPTION OF RISK ","PRELIMINARY OBSERVATIONS ON EVIDENCE","PRIMARY CAUSE OF RISK","SECONDARY CAUSES OF RISK","POTENTIAL NEGATIVE IMPACTS ON:",null,null,null,null,null,null,"DESCRIBE THE POTENTIAL NEGATIVE IMPACTS \n(consequences of the risk)","CONSIDERATION OF OPPORTUNITIES ","SITE SURVEYS","EVIDENCE OF RISK IMPACTS \n(for completion following site surveys)",null,"PHASE 2: STEP 3","BIODIVERSITY IMPACTS\nNEGATIVE IMPACTS ON BIODIVERSITY:  \nHabitats or protected areas;  Species of biodiversity significance;  \nEcosystem services  \n",null,null,"BIODIVERSITY DEPENDENCIES\nNEGATIVE IMPACTS ON BUSINESS:\nCompliance; Sustainability; Reputation & Relationships; \nOperating turnover",null,null,"HIGHEST RISK SCORE ","\nACTION & MONITORING PLAN TO BE PRODUCED?","CONSIDERATION OF OPPORTUNITIES"]
[null,"RISK NO.","Site Name/ Growing Area. Geographic location of the risk\n","Specific location within the operating region",null,"Provide as much detail as possible about the risk topic (i.e. specific location, what is happening on the ground)","Initial evidence for risk i.e. How do you know about the potential risk?","Identify the one main cause of the Risk.\nRefer to 'Risk Causes' worksheet and the further help link.","Identify any other causes of the Risk.\nRefer to 'Risk Causes' worksheet.\n","Habitats and / or protected areas","Species of biodiversity significance","Ecosystem services","Compliance with company policy, biodiversity & environmental legal requirements, liability or obligations incurred","The sustainability of farming or other agricultural production in the landscape","The reputation of the company or stakeholder relationships","Company operating  turnover ","Describe the possible consequences of the risk, with reference to any potential negative impacts that you identified for each of the 7 previous categories.","Have you identified any opportunities related to this risk?",null,"Record the evidence for the potential impacts of this risk  \ne.g. Summary of the results of site surveys, mapping, interviews, observations etc. \n\nUpdate with additional information as it is collected.","Once the Risk Working Table is complete, click here to open the Risk Matrix to Score and Prioritise the Risks.",null,"SCORE THE MAGNITUDE OF NEGATIVE IMPACT ON BIODIVERSITY\n                                                     \n(click for magnitude matrix)","SCORE THE LIKELIHOOD OF NEGATIVE IMPACT ON BIODIVERSITY                                                      \n\n(click for likelihood matrix)","BIODIVERSITY IMPACT RISK SCORE\n\n(automatically calculated)","SCORE THE MAGNITUDE OF NEGATIVE IMPACT ON THE BUSINESS\n                                                     \n(click for magnitude matrix)","SCORE THE LIKELIHOOD OF NEGATIVE IMPACT ON THE BUSINESS                                                      \n\n(click for likelihood matrix)","BIODIVERSITY DEPENDENCY RISK SCORE\n\n(automatically calculated)","Automatically populated","Yes / No\n\n(Select as appropriate)\n\n","Have you identified any opportunities related to this risk?\n "]
[null,null,"RISKS"]
[null,1,"EXAMPLE: North District","Site A","1.3 loss of migratory routes / increase in barriers to movement of species, including loss or lack of native forest corridors for wildlife (e.g. tree lines, forests connecting protected areas)","YES: Native forest is being extensively cleared around farms, villages and along roads. Possible impacts to wildlife, which may no longer be able to access larger blocks of protected forest parks for food through loss of forest corridors (links)","Verbal reports by farmers and local communities","agriculture expansion particularly increase of crops A, B, and C due to improved market access","Increasing human population and in migration of people into new settlements in region","YES","YES","YES","NO","YES","NO","NO","Increased pressure on wildlife through lack of access to habitat/food sources, particularly species 'X' and 'Y'.","NO",null,"Interviews with  farmers and  local communities.  Biodiversity mapping and a Forest Survey conducted by conservation partner in April 2012 identified that native forest provides a corridor between Protected Area 'X', Productive forest 'Y' and fragments of community forest.  Species 'X', and 'Y' where identified in the survey as potentially being at risk  but these species are not classified as threatened.  ",null,null,2,2,4,1,1,{"$f":"Z6*AA6","v":1},{"$f":"IF(AB6+Y6=0,\"0\",IF(AB6=Y6,(\"IMPACT & DEPENDENCY  \"&Y6),IF(Y6>AB6,(\"IMPACT  \"&Y6),(\"DEPENDENCY  \"&AB6))))","v":"IMPACT  4"},"YES","NO"]
[null,2,"EXAMPLE: North District","Site A","2.1 habitat loss, clearance or conversion to other uses ","YES: Large areas of native forest being cleared to grow new crops. This may be a risk regarding certain ecosystem services, wildlife and local communities ","Observations of site managers","agriculture expansion particularly increase of crops A, B, and C due to improved market access","Increasing human population and in migration of people into new settlements in region","YES","YES","YES","YES","YES","YES","NO","loss of certain ecosystem services provided by forests cleared (e.g. prevention of soil erosion). Potential loss of wildlife and loss of natural sources of food for local communities who rely on forests.  ","NO",null,"Interviews with  farmers and extension workers. 42% of people interviewed reported collecting food from local forests and 82% reported collecting some fire wood from the local forests to supplement food and fuel needs. The recent Forest Survey conducted by local ecological consultant estimated 'X' hectares has been cleared since 2001, mainly for local cash crops of 'A', 'B' and 'C'.  ",null,null,2,2,{"$f":"W7*X7","v":4},2,2,{"$f":"Z7*AA7","v":4},{"$f":"IF(AB7+Y7=0,\"0\",IF(AB7=Y7,(\"IMPACT & DEPENDENCY  \"&Y7),IF(Y7>AB7,(\"IMPACT  \"&Y7),(\"DEPENDENCY  \"&AB7))))","v":"IMPACT & DEPENDENCY  4"},"YES","YES"]
[null,3,"EXAMPLE: North District","Site B","5.1 low soil nutrient status or decrease in nutrient status,  acidification or altered soil pH (e.g. through significant use of agrochemicals/inorganic fertilizers)","YES: Some farmers are still using chemicals that are now banned and/or being phased out. This may have potentially harmful effects on soil/water courses.","Discussions with farmers","Lack of farmer awareness / education on regulations of pesticides and fertilisers.","Banned chemicals now available very cheaply ","YES","NO","YES","YES","YES","YES","NO","Possible impact on soil health and health of rivers and streams ","NO",null,"Data on soil health obtained from national environmental monitoring agency. Interviews with extension workers. 59% of extension workers reported farmers using pesticide 'A' and herbicide 'B'. ",null,null,1,2,2,2,2,4,"DEPENDENCY  4","YES","NO"]
[null,4,"EXAMPLE: North District","Site B","6.2 loss or lack of watercourse buffer (e.g. natural forest or vegetation along a river)  ","MAYBE: clearance of vegetation along river banks ","Some verbal reports of a few farmers clearing natural vegetation along their riverbanks to maximise crop area","Increased pressure on land for growing crops ","Lack of enforcement of regulations for river management by local agri department","NO","NO","YES","YES","YES","YES","NO","reduced water quality and siltation etc","NO",null,"Following site surveys and study of aerial photography, there is no evidence of loss of watercourse vegetation and regeneration of areas with reported loss is now in progress. None of the company farmers questioned were found to be noncompliant. ",null,null,0,0,0,0,0,0,"0","NO","NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W10*X10","v":0},null,null,{"$f":"Z10*AA10","v":0},{"$f":"IF(AB10+Y10=0,\"0\",IF(AB10=Y10,(\"IMPACT & DEPENDENCY  \"&Y10),IF(Y10>AB10,(\"IMPACT  \"&Y10),(\"DEPENDENCY  \"&AB10))))","v":"0"},null,{"$f":"IF((R10>0),R10,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,{"$f":"W42*X42","v":0},null,null,{"$f":"Z42*AA42","v":0},{"$f":"IF(AB42+Y42=0,\"0\",IF(AB42=Y42,(\"IMPACT & DEPENDENCY  \"&Y42),IF(Y42>AB42,(\"IMPACT  \"&Y42),(\"DEPENDENCY  \"&AB42))))","v":"0"},null,{"$f":"IF((R42>0),R42,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,{"$f":"W74*X74","v":0},null,null,{"$f":"Z74*AA74","v":0},{"$f":"IF(AB74+Y74=0,\"0\",IF(AB74=Y74,(\"IMPACT & DEPENDENCY  \"&Y74),IF(Y74>AB74,(\"IMPACT  \"&Y74),(\"DEPENDENCY  \"&AB74))))","v":"0"},null,{"$f":"IF((R74>0),R74,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,{"$f":"W106*X106","v":0},null,null,{"$f":"Z106*AA106","v":0},{"$f":"IF(AB106+Y106=0,\"0\",IF(AB106=Y106,(\"IMPACT & DEPENDENCY  \"&Y106),IF(Y106>AB106,(\"IMPACT  \"&Y106),(\"DEPENDENCY  \"&AB106))))","v":"0"},null,{"$f":"IF((R106>0),R106,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,{"$f":"W138*X138","v":0},null,null,{"$f":"Z138*AA138","v":0},{"$f":"IF(AB138+Y138=0,\"0\",IF(AB138=Y138,(\"IMPACT & DEPENDENCY  \"&Y138),IF(Y138>AB138,(\"IMPACT  \"&Y138),(\"DEPENDENCY  \"&AB138))))","v":"0"},null,{"$f":"IF((R138>0),R138,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,{"$f":"W170*X170","v":0},null,null,{"$f":"Z170*AA170","v":0},{"$f":"IF(AB170+Y170=0,\"0\",IF(AB170=Y170,(\"IMPACT & DEPENDENCY  \"&Y170),IF(Y170>AB170,(\"IMPACT  \"&Y170),(\"DEPENDENCY  \"&AB170))))","v":"0"},null,{"$f":"IF((R170>0),R170,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",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,0,null,null,0,"0",null,""]

{"sheet":"Opportunity Working Table","index":3,"n_rows":200,"n_cols":30,"rows_kept":200,"cut":false,"hidden":false,"merged":[[0,29,3,29],[2,0,4,0],[2,7,2,13],[2,15,3,15],[2,19,2,21],[0,2,0,6],[0,19,0,24],[2,22,2,24],[1,2,1,4],[1,19,1,21],[2,18,4,18],[4,2,4,3]]}
[null,null,"BIODIVERSITY RISK AND OPPORTUNITY ASSESSMENT: OPPORTUNITY WORKING TABLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIODIVERSITY RISK AND OPPORTUNITY ASSESSMENT: OPPORTUNITY WORKING TABLE",null,null,null,null,null,null,null,null,null,"For each opportunity adopted for Action and Monitoring Planning, information on operating region, site, opportunity topic and description will be automatically copied to the Risks and Opportunities for AMP table. To transfer this information to the Action and Monitoring Plans Working Table click the ’Copy information’ button below\n\nTThe population of Action and Monitoring Plans is a one-time only process. This will take you on to fully complete your Action and Monitoring Plans."]
[null,null,"PHASE 2: STEP 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHASE 2: STEP 3"]
["PHASE 2: STEP 2",null,"OPERATING REGION","SITE(S)","OPPORTUNITY TOPIC","DESCRIPTION OF OPPORTUNITY","PRELIMINARY OBSERVATIONS ON EVIDENCE","POTENTIAL POSITIVE IMPACTS ON:",null,null,null,null,null,null,"DESCRIBE THE POTENTIAL POSITIVE IMPACTS \n(consequences of the opportunity)","SITE SURVEYS","EVIDENCE OF OPPORTUNITY IMPACTS \n(for completion following site surveys)",null,"PHASE 2: STEP 3","BIODIVERSITY IMPACTS\nPOSITIVE IMPACTS ON BIODIVERSITY:  \nHabitats or protected areas;  Species of biodiversity significance;  Ecosystem services\nRefer to 'Matrices' worksheet",null,null,"BIODIVERSITY DEPENDENCIES\nPOSITIVE IMPACTS ON BUSINESS:\nCompliance; Sustainability; Reputation & Relationships; Operating turnover\nRefer to 'Matrices' worksheet",null,null,"HIGHEST OPPORTUNITY SCORE","DOES THIS OPPORTUNITY HELP TO ADDRESS ANY RISKS?","DECISION TO ADOPT OR REJECT OPPORTUNITY \n(Action and Monitoring Plan to be Produced?)"]
[null,"OPPORTUNITY NO.","Site Name/ Growing Area. Geographic location of the risk","Specific location within the operating region","Enter a relevant biodiversity topic for the opportunity","Provide as much detail as possible about the opportunity \n(i.e. what is happening on the ground)","Initial evidence for opportunity i.e. How do you know about the opportunity?\n","Habitats and / or protected areas","Species of biodiversity significance","Ecosystem services","Compliance with company policy, biodiversity & environmental legal requirements, liability or obligations incurred","The sustainability of  farming or other agricultural production in the landscape","The reputation of the company or stakeholder relationships","Company operating turnover ","Describe the possible consequences of the opportunity, with reference to any potential positive impacts that you identified for each of the 7 previous categories",null,"Record the evidence for the potential impacts of the opportunity\ne.g. results of site surveys, mapping, interviews, observations etc. \n\nUpdate with additional information as it is collected\n","Once the Opportunities Working Table is complete, click here to open the Opportunity Matrix to Score and Proritise the Opportunities.",null,"SCORE THE MAGNITUDE OF POSITIVE IMPACT ON BIODIVERSITY                                                    \n\n (click for magnitude matrix)","SCORE THE LIKELIHOOD OF SUCCESS OF POSITIVE IMPACT ON BIODIVERSITY                                                 \n\n(click for likelihood matrix)","BIODIVERSITY IMPACT OPPORTUNITY SCORE\n\n(automatically calculated)","SCORE THE MAGNITUDE OF POSITIVE IMPACT ON BIODIVERSITY DEPENDENCIES\n\n(click for magnitude matrix)","SCORE THE LIKELIHOOD OF SUCCESS OF POSITIVE IMPACT ON BIODIVERSITY DEPENDENCIES                                                             \n\n(click for likelihood matrix)","BIODIVERSITY DEPENDENCY OPPORTUNITY SCORE\n\n(automatically calculated)","Automatically populated","(YES / NO)\n","(ADOPT / REJECT)\n"]
[null,null,"OPPORTUNITIES"]
[null,2,"EXAMPLE: North District","Site A","2.1 habitat loss, clearance or conversion to other uses ","There is a national platform for biodiversity organisations and agri-businesses. There is an opportunity to become involved with this through the action related plan. ","Company biodiversity manager aware of this platform but currently not involved","YES","YES","YES","NO","YES","YES","NO","Company reputation improved through engagment with conservation organisations and initiatives. Potential to become part of larger projects on forest restoration which could ultimately improve sustainability of agri landscape. ",null,"Some small scale projects have been implemented in the south of the country as a result of collaboration through this forum. They have been very successful in improving forest areas and improving relations between business and conservation. As species 'X' and 'Y' are present in our area, there is also the opportunity for join monitoring of the species through the forum's work. ",null,null,2,2,{"$f":"T6*U6","v":4},2,1,{"$f":"W6*X6","v":2},{"$f":"IF(Y6+V6=0,\"0\",IF(Y6=V6,(\"IMPACT & DEPENDENCY  \"&V6),IF(V6>Y6,(\"IMPACT  \"&V6),(\"DEPENDENCY  \"&Y6))))","v":"IMPACT  4"},"YES","ADOPT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T7*U7","v":0},null,null,{"$f":"W7*X7","v":0},{"$f":"IF(Y7+V7=0,\"0\",IF(Y7=V7,(\"IMPACT & DEPENDENCY  \"&V7),IF(V7>Y7,(\"IMPACT  \"&V7),(\"DEPENDANCY  \"&Y7))))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T39*U39","v":0},null,null,{"$f":"W39*X39","v":0},{"$f":"IF(Y39+V39=0,\"0\",IF(Y39=V39,(\"IMPACT & DEPENDENCY  \"&V39),IF(V39>Y39,(\"IMPACT  \"&V39),(\"DEPENDANCY  \"&Y39))))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T71*U71","v":0},null,null,{"$f":"W71*X71","v":0},{"$f":"IF(Y71+V71=0,\"0\",IF(Y71=V71,(\"IMPACT & DEPENDENCY  \"&V71),IF(V71>Y71,(\"IMPACT  \"&V71),(\"DEPENDANCY  \"&Y71))))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T103*U103","v":0},null,null,{"$f":"W103*X103","v":0},{"$f":"IF(Y103+V103=0,\"0\",IF(Y103=V103,(\"IMPACT & DEPENDENCY  \"&V103),IF(V103>Y103,(\"IMPACT  \"&V103),(\"DEPENDANCY  \"&Y103))))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T135*U135","v":0},null,null,{"$f":"W135*X135","v":0},{"$f":"IF(Y135+V135=0,\"0\",IF(Y135=V135,(\"IMPACT & DEPENDENCY  \"&V135),IF(V135>Y135,(\"IMPACT  \"&V135),(\"DEPENDANCY  \"&Y135))))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T167*U167","v":0},null,null,{"$f":"W167*X167","v":0},{"$f":"IF(Y167+V167=0,\"0\",IF(Y167=V167,(\"IMPACT & DEPENDENCY  \"&V167),IF(V167>Y167,(\"IMPACT  \"&V167),(\"DEPENDANCY  \"&Y167))))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T199*U199","v":0},null,null,{"$f":"W199*X199","v":0},{"$f":"IF(Y199+V199=0,\"0\",IF(Y199=V199,(\"IMPACT & DEPENDENCY  \"&V199),IF(V199>Y199,(\"IMPACT  \"&V199),(\"DEPENDANCY  \"&Y199))))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"0"]

{"sheet":"Action and Monitoring Plans WT","index":4,"n_rows":70,"n_cols":21,"rows_kept":70,"cut":false,"hidden":false,"merged":[[3,15,4,15],[3,16,4,16],[3,18,4,18],[3,19,4,19],[3,20,4,20],[2,17,4,17],[1,2,1,4],[3,9,4,9],[3,2,4,2],[3,3,4,3],[0,2,0,5],[2,0,4,0],[2,1,5,1],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,7,4,7],[3,8,4,8],[3,10,4,10],[3,11,4,11]]}
[null,null,"BIODIVERSITY RISK AND OPPORTUNITY ASSESSMENT - ACTION AND MONITORING PLANS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BROA - ACTION AND MONITORING PLANS "]
[null,null,"PHASE 3:  STEP 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHASE 3:  STEP 2"]
["PHASE 3: STEP 1","RISK NO.","OPERATING REGION","SITE(S)","RISK / OPPORTUNITY TOPICS","DESCRIPTION OF RISK / OPPORTUNITIES","PRIMARY CAUSE OF RISK ","SECONDARY CAUSES OF RISK","JUSTIFICATION FOR ANY GROUPINGS PRIOR TO ACTION & MONITORING PLAN","CURRENT MEASURES TO ADDRESS THE RISK /ADOPT THE OPPORTUNITY","GOAL","OUTCOMES","ACTIONS ","COMPLETION DATE OF RISK ACTION","PERSON RESPONSIBLE","BUDGET ALLOCATED IN PLAN FOR EACH ACTION","INDICATORS","PHASE 3: STEP 2","STATUS OF RISK OR OPPORTUNITY MANAGEMENT ACTIVITIES","EVIDENCE FOR PROGRESS IN ACTION AND MONITORING PLAN IMPLEMENTATION PROVIDED THROUGH INDICATORS","NEXT REVIEW DATE"]
[null,null,"Site Name/ Growing Area. Geographic location of the risk","Specific location within the operating region","Topics carried over from Phase 2 and grouped according to primary and or secondary causes, site and / or actions to be undertaken, as appropriate","Provide as much detail as possible about the risk / opportunity topic (i.e. what is happening on the ground)","(Leave blank for opportunities)","(Leave blank for opportunities)","Provide a brief explanation on why you have grouped your risk / opportunity topics","Provide a brief description of what is currently being done to address this risk or adopt this opportunity (if appropriate) ","Describe the goal  (i.e. desired situation in which the risk is eliminated or mitigated, or the opportunity realised)","Describe outcomes that will secure the desired change","Describe what will be done to achieve the outcomes\nNumber each action separately","Include a completion date against each separate numbered action","List persons responsible for the planned actions as numbered","Please detail the budget provided for each individual action","List indicators that will provide a reliable measure of the progress towards the goal \nNumber each indicator separately, and start a new line in the cell for each",null,"Colour code + Date","Results from monitoring indicators"]
[]
[null,null,"RISKS"]
[null,"1 & 2","EXAMPLE: North District","Site A","1.3 loss of migratory routes / increase in barriers to movement of species, including loss or lack of native forest corridors for wildlife (e.g. tree lines, forests connecting protected areas)\n\n2.1 habitat loss, clearance or conversion to other uses\n\n","YES: Native forest corridors are being cleared extensively around villages and along roads. Native forest is being cleared in larger blocks. Possible impacts to wildlife, which may no longer be able to access larger blocks of protected forest parks for food through loss of forest corridors (links). Also possible risks to certain ecosystem services, wildlife and local communities\n","agriculture expansion particularly increase of crops A, B, and C due to improved market access","Increasing human population and in migration of people into new settlements in region","Grouping has been done according to Operating Region, Site, Risk Topic  and causes","The company has guidelines on forest clearance but it appears this is being ignored by some farmers. Plantations are also being planted by Forestry Commission to replace any potential loss of trees. But these are mostly exotic species (planted for timber for construction) and will not replace value of native forests. ","Forest loss is halted, areas of forest restored and corridors of forest are established, linking larger forest areas so that wildlife can access habitat and food sources. ","Farmers aware of value of forests and the importance of retaining links (corridors) of forest for wildlife. Areas of forest restored. Agricultural landscapes more resilient and productive. Local communities are better able to supplement their income from forest foods (which helps meet demands of increased population in area). ","1. Company to work with conservation partner NGO and other organisations in area on forest restoration initiatives.                                                                                              2. Education programme rolled out to all farmers to equip them with knowledge, skills and understanding in forest conservation and its value.                                        3. Engage with crop 'A' companies 'X' and 'Y' to develop collaborative approach to address forest clearance for crop 'A' ","\n1. End 2014: Forest activities                                                                                                  2. End 2013: Farmer training                                              3. End 2014: Company collaboration","1. Site Manager,                                                                                                                                                                       2. Company Training Manager                                                                             1 & 2. Project Manager of partner Conservation NGO                 3. Operations Manager  ","This example has not specified budget as this will vary greatly between and/or within companies/users of this Tool. ","No. hectares of forest restored                           Annual % of seedlings surviving                                 Range of native species used of restoration\nNo. km of wildlife corridors developed                                                                                           Conservation Partner NGO reporting on trends in Species 'X' and 'Y'\nNo. farmers receiving training and applying new skills/knowledge                                                                        No. of companies engaged including 'X' and 'Y' with effective measures to address forest loss                                                                                          ",null,"2013-08-01","1. Restoration plan agreed and seedling nursery for native species identified. Agreements with local government, communities and land owners for restoration sites to be signed by end August.                                                                           2. Training delayed due to localised flooding. Re-scheduled for end September 2013.                                                           3. Company 'X' helping to design approach with Conservation Partner. Company 'Y' not yet engaged. ","2013-09-01"]
[null,3,"EXAMPLE: North District","Site B","5.1 low soil nutrient status or decrease in nutrient status,  acidification or altered soil pH (e.g. through significant use of agrochemicals/inorganic fertilizers)","YES: Some farmers are still using chemicals that are now banned and/or being phased out. This may have potentially harmful effects on soil/water courses.","Lack of farmer awareness / education on regulations of pesticides and fertilisers.","cheap, harmful chemicals easily avaiable","No grouping done as this was a single risk relating to soil health which was carried through. ","The company has guidelines which are intended to address the problems associated with use of chemicals which are being withdrawn. Although alternative methods/chemicals have been produced or are being rolled out, adoption rates are reportedly low. ","Farmers to stop using banned chemicals and change to environmentally friendly alternatives","Soil health improved","1. Training programme rolled out across all operating regions on regulations and use of pesticides. Farmers supplied with tools, materials and knowledge to improve soil health.                                                                               2.Technical specialists contracted to undertake soil and freshwater surveys.    \n3. Engage with MoE staff to prevent banned chemicals ending up on market                                                               ","1. End 2013: Farmer training                                                    2. End 2013: Soil and Freshwater surveys\n3. End 2015: Banned chemicals removed","1. Company Training Manager                                   1. Extension workers (Site B)                      2. Site Manager                               2. Technical Specialists \n3. Purchasing Manager","This example has not specified budget as this will vary greatly between and/or within companies/users of this Tool. ","No. farmers trained and applying new skills/knowledge 100% compliance of regulations on pesticide use across Site B.                                                                No. of farmers using recommended alternatives across Site B                                                                           Levels of chemical 'X' in soil reported annually                                                            Levels of chemical 'Y' in surrounding streams reported annually \nChemicals no longer available for purchase at local markets",null,"2013-08-01","1. 10,000 farmers trained out of a total of 50,000                                                                               2. Technical specialists reports due by November 2013\n3. Discussions underway with MoE","2013-12-01"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Opp NO.","OPPORTUNITIES"]
[null,2,"EXAMPLE:\n North District ",null,"habitat loss, clearance or conversion to other uses ","There is a national platform for biodiversity organisations and agri-businesses. There is an opportunity to become involved with this through the action related plan. ",null,null,null,"There are currently no measures in place to address this opportunity. The company does not currently engage with any biodiversity organisations on this platform.","Company reputation improved through engagment with conservation organisations and initiatives. Become part of larger projects on forest restoration which has improved sustainability of agri landscape. Locall communities able to depend on elements of biodiversity and ecosystem services important for livelihoods ","Enhanced biodiversity and ecosystem service conservation in operating region leading to improved ecological integrity and sustainability of the landscape.","1. Company to engage with national platform and to seek collaboration with conservation NGO to address biodiversity and ecosystem service conservation in operating landscape.\n2. Company to actively support at least one landscape level conservation project in operating region","1. End of 2012\n2. End of 2013\n","Sustainability Manager","This example has not specified budget as this will vary greatly between and/or within companies/users of this Tool. ","1. Company to present to national platform, explain motivations, and request proposals for collaboration from conservation organisations.\n2. Involvement in at least one landscape level conservation project"]

{"sheet":"Risks and Opportunities for AMP","index":5,"n_rows":66,"n_cols":9,"rows_kept":66,"cut":false,"hidden":false,"merged":[[3,3,4,3],[0,2,0,8],[1,2,1,4],[2,0,4,0],[2,1,5,1],[3,8,4,8],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,2,4,2]]}
[null,null,"RISKS AND OPPORTUNITIES FOR ACTION AND MONITORING PLANNING"]
[null,null,"PHASE 3:  STEP 1 - REFERENCE DOCUMENT"]
[null,"RISK NO.","OPERATING REGION","SITE(S)","RISK / OPPORTUNITY TOPICS\n","DESCRIPTION OF RISK / OPPORTUNITIES","PRIMARY CAUSE OF RISK ","SECONDARY CAUSES OF RISK","RISK / OPPORTUNITY SCORE"]
[null,null,null,null,"Topics carried over from Phase 2 and grouped according to primary and or secondary causes, site and / or actions to be undertaken, as appropriate",null,"(Blank for opportunities)","(Blank for opportunities)"]
[]
[null,null,"RISKS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Opp NO.","OPPORTUNITIES"]
[null,2]

{"sheet":"Risk Causes","index":6,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,"Identifying the likely Causes of your Risks"]
[null,"\nFor each risk, ask 'but why?': Why is the risk happening - what is its cause? But why is that cause happening? But why? But why? - until you build up a tree-like diagram with your ultimate (or root) causes at the bottom of the diagram. \n\nSee the example below in which a risk (flash flooding) is tracked back to its ultimate causes.  Bear in mind that one risk may have several causes, and one ultimate cause may contribute to several risks. Where more than one cause contributes to a risk, as in this example, use your judgment to consider whether one cause is having a more significant impact than another. If you believe this to be the case you can distinguish between primary and secondary causes in the Risk Working Table. This function allows you greater flexibility and choice when grouping risks to design Action and Monitoring Plans on the Action and Monitoring Plans Working Table tab. \n\nRemember, in practice it may not always be possible to identify the ultimate causes of your risks, or to be fully certain what all the causal factors are, but carrying out this exercises as far as possible can help you determine links between seemingly separate risks.\n"]
[null,"Note: it is not always possible to address the ultimate cause of your risks; you may need to address intermediate causal factors through Action and Monitoring Plans."]

{"sheet":"Opportunity Guidelines","index":7,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[null,"Opportunity Guidelines"]
[]
[null,"This is a guide with some ideas on what Opportunities may be and how they may differ from risk related Action and Monitoring Plans. You will need to expand these as you develop your Action and Monitoring Plan. "]
[null,"Further examples are also provided within the Opportunity Working Table and additional guidance is also provided in the BROA Handbook "]
[]
[null,"Opportunities that provide benefits to biodiversity or a reduction in biodiversity dependencies, and that go beyond or are unrelated to Risk Action and Monitoring Plans e.g.:"]
[null,"·         Engaging in community wide initiatives (education, conservation projects, ecosystem services enhancement)"]
[null,"·         Linking into existing wildlife corridor / biodiversity plans in your region"]
[null,"·         Improving biodiversity through the farming landscape (these may be low scoring Opportunities but are relatively easy to implement)  "]
[null,"·         Using 'NTFPs' (non-timber forest products) to provide incentives for community conservation of forests by enhancing community livelihoods and reducing poverty, e.g. bee-keeping, fruit trees"]
[null,"·         Protecting watersheds and riverine strips to improve water quality (riverside native tree planting, forest regeneration or restoration)"]
[null,"·         Water harvesting and water efficiency"]
[null,"·         Enhancing agroforestry to meet multiple needs including increased native biodiversity"]
[null,"·         Biodiversity plantings (e.g. natural vegetation boundaries, trees) where there appears to be a lack of biodiversity features in the growing landscape.",null,null,null,null,"`"]
[]
[null,"Opportunities that encourage your Operation to collaborate / share with external stakeholders, but which lie outside your usual range of experience / expertise e.g.:"]
[null,"·         Sharing best practice with other non-tobacco stakeholders (including Private Sector, Government, Civil Society Organisations)  "]
[null,"·         Engaging in local, regional or international initiatives (Reducing Emissions from Deforestation and forest Degradation - REDD, Payment for Ecosystem Services etc)"]
[null,"·         Participating in national or regional level forums which focus on environmental / conservation issues "]
[null,"·         Identifying other parties (e.g. companies, organisations, associations etc) sourcing different crops from your farmers and developing joint initiatives with them"]
[null,"·         Identifying other parties who have similar dependencies (water, woodfuel) and developing joint initiatives with them"]
[null,"Opportunities that provide additional benefits to your business (e.g. reputational gains) and/or help to address biodiversity dependencies e.g.:"]
[null,"·         Recognition of farmers for biodiversity awareness / achievements (certificates etc)"]
[null,"·         Recognition of staff for biodiversity awareness (certificates etc) "]
[null,"·         Training staff on biodiversity"]
[null,"·         Improving fuel efficiency (alternative fuels, solar)"]
[]
[null,"Opportunities that encourage other stakeholders to share (finance or resources) the responsibility for interventions e.g.:"]
[null,"Opportunities that encourage other stakeholders to share (finance or resources) the responsibility for interventions e.g.:"]
[null,"·         Identification of beneficiaries from clean water (free of debris or pollution) downstream of operations who would support actions to improve water quality."]
[null,"·         Identification of upstream organisations that have an impact on the biodiversity your operations depend upon, e.g. mining or logging, and have a responsibility to mitigate their impacts."]
[null,"·         Identification of potential beneficiaries of improved biodiversity in the area of your operations who might be willing and able to contribute (finance or resources) to action. "]
[]
[null,"Adoption or Rejection of Opportunities"]
[null,"Adoption or rejection of Opportunities is a matter of using your knowledge and experience of the landscape, and consulting with your conservation partner. Please use the Biodiversity Impact and Biodiversity Dependency scores to guide your decision whether to adopt or reject each Opportunity.  "]
[null,"Types of Opportunities that should be considered seriously for adopting within the Action and Monitoring Plans: "]
[null,"·         Opportunities that may provide multiple types of benefit, as described in the Opportunity Guideline"]
[null,"·         Opportunities that have a high positive impact with a high likelihood of success."]
[null,"·         Opportunities that may contribute to addressing risks but are not directly risk related actions in the Action and Monitoring Plan.  "]
[null,"•        Opportunities that are low scoring, but simple to implement with immediate positive impacts - ‘low hanging fruit’"]
[null,"·         Opportunities that may bring long-term cumulative benefits"]
[null,"Types of Opportunities that may be rejected: "]
[null,"·         Opportunities that have low positive impact with a low likelihood of success."]
[null,"·         Opportunities which have a high positive impact but a low likelihood of success  "]

{"sheet":"Matrices","index":8,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":true,"merged":[[0,1,0,5],[1,1,2,1],[28,1,28,3],[19,1,19,3],[20,1,20,3],[3,1,5,1],[11,1,14,1],[7,1,7,5],[30,4,30,5],[31,4,31,5],[9,1,10,1],[42,1,42,4],[19,4,19,5],[29,1,29,3],[22,4,22,5],[21,4,21,5],[16,1,17,5]]}
[null,"BIODIVERSITY RISK & OPPORTUNITY IMPACT MAGNITUDE MATRIX - OPERATING COMPANY LEVEL"]
[null,null,"MAGNITUDE","LOW = 1","MEDIUM = 2","HIGH = 3"]
[null,null,"Risk / Opportunity Category"]
[null,"BIODIVERSITY IMPACTS  \n\nIMPACTS OF THE BUSINESS ON BIODIVERSITY & ECOSYSTEM SERVICES","Impact on habitats & protected areas   ","- Local impacts to native habitats of no biodiversity significance.","- Local impacts to native habitats of biodiversity significance.\n"," - Regional impacts to native habitats of biodiversity significance. \n- Impacts on protected areas.   \n- Large scale impacts to local habitats of biodiversity significance."]
[null,null,"Impact on native species","- Local impacts on native species of no biodiversity significance.","\n - Local impacts on native species of biodiversity significance."," - Regional impacts on native species of biodiversity significance.    \n- Species disappearance at the local level.    \n- Large scale impacts to species of biodiversity significance at the local level."]
[null,null,"Impact on ecosystem services","- Identified stresses to ecosystem services reported at local level."," - Small scale impacts on ecosystem services at a local level.","\n - Significant local changes and / or changes to ecosystem services regionally"]
[null,null,null,"No Biodiversity Impact  = 0"]
[null,"INSTRUCTIONS FOR USE:  Start at the right and work from the High column left towards the Low column.  If the risk /opportunity meets any one of the criteria in the High column it is high, if it meets none of the High criteria but meets one of the Medium criteria then it is medium and so forth."]
[]
[null,null,"MAGNITUDE","LOW = 1","MEDIUM = 2","HIGH = 3"]
[null,null,"Risk / Opportunity Category"]
[null,"BIODIVERSITY DEPENDENCIES\n\nIMPACTS ON THE BUSINESS DUE TO RELIANCE ON BIODIVERSITY & ECOSYSTEM SERVICES\n","Impact on company compliance with biodiversity and environmental legal requirements, liability or obligations incurred"," - Company non-compliance is likely to give rise to any of the 'low magnitude' impacts on habitats/species, native species, ecosystem services."," - Company non-compliance is likely to give rise to any of the 'medium magnitude' impacts on habitats/species, native species, ecosystem services. "," - Company non-compliance is likely to give rise to any of the 'high magnitude' impacts on habitats, species, ecosystem services."]
[null,null,"Impact on the sustainability of agricultural production, in the landscape"," - Potential impacts to sustainability of local agriculture identified by a local stakeholder."," - Impact on the sustainability of local agriculture."," - Impacts the sustainability of agriculture at landscape level."]
[null,null,"Impact on the reputation of the company or stakeholder relationships"," - Reputational impact identified by a local stakeholder."," - Reputational impact identified by a number of local stakeholders."," - Impact on local stakeholder confidence or relationship(s).\n - Reputational impact identified by a number of regional or national stakeholders."]
[null,null,"Impact on company operating turnover or\noperating cash flow"," - Impacts net operating turnover by 0-5%."," - Impacts net operating turnover by 5-10%."," - Any issues identified as potentially a criminal offence.\n\n - Impacts net operating turnover by 10-15% or greater."]
[null,null,null,"No Biodiversity Dependency = 0"]
[null,"INSTRUCTIONS FOR USE:  Start at the right and work from the High column left towards the Low column.  If the risk /opportunity meets any one of the criteria in the High column it is high, if it meets none of the High criteria but meets one of the Medium criteria then it is medium and so forth."]
[]
[]
[null,"BIODIVERSITY RISK LIKELIHOOD MATRIX"]
[null,"Likelihood of NEGATIVE IMPACTS occurring"]
[null,"LOW = 1","MEDIUM = 2","HIGH = 3","ZERO SCORE"]
[null,"No current observations and / or considered possible by at least one authoritative source","Some indications that it is occurring and / or is predicted as likely to occur by authoritative sources ","Currently observed or documented and / or expected to occur by authoritative sources  ","If you conclude that your identified biodiversity risk or opportunity has NO impact or dependency on biodiversity, or NO likelihood of occurring or NO likelihood of being successful, your overall Biodiversity Impact / Biodiversity Dependency Score will be zero, and there is no need to proceed with this risk or opportunity."]
[null,null,"No likelihood of occurring = 0"]
[]
[]
[]
[]
[null,"BIODIVERSITY OPPORTUNITY LIKELIHOOD OF SUCCESS MATRIX"]
[null,"Likelihood of POSITIVE IMPACTS occurring"]
[null,"LOW = 1","MEDIUM = 2","HIGH = 3","ZERO SCORE"]
[null,"Will require substantial additional resources, time (several years), stakeholder engagement, and technical expertise.  May be subject to external factors.  May require feasibility study.  ","Will require modest to significant additional resources, over a year or more, with some stakeholder engagement and some additional technical expertise. Few external factors. ","Will require little to modest additional resources over a period of up to a year; relatively straightforward to implement with existing capacity within your organisation and local Partners.  Largely unaffected by external factors.","If you conclude that your identified biodiversity risk or opportunity has NO impact or dependency on biodiversity, or NO likelihood of occurring or NO likelihood of being successful, your overall Biodiversity Impact / Biodiversity Dependency Score will be zero, and there is no need to proceed with this risk or opportunity."]
[null,null,"No likelihood of success = 0"]

{"sheet":"Further Help","index":9,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"What are the Biodiversity risks in the landscape?"]
[]
[null,null,"When assessing risk topics you should consider current status of the landscape, as well as any signs of change to habitats, species, or biodiversity and ecosystems happening NOW or up to 5 YEARS previous to the assessment.You also need to consider historic changes that still affect the landscape, and are still having consequences and creating risks. Consider the status and trends in the landscape as a whole, as well as the direct impacts and dependencies of your operations. For example, if there is a reported increase in use of agrochemicals, field technicians might also suspect a reduction in water quality, or loss of soil species that in themselves present a different risk to biodiversity and the business operations."]
[null,null,"For each operating region: Consider each risk topic in the list and decide whether it applies, may apply or does not apply in that region."]
[null,null,"Consult with other stakeholders for their views."]
[]
[null,null,"Instructions:"]
[null,null,"1. Enter all operating region names in Row 5"]
[null,null,"2. Select 'yes', 'no' or 'maybe' against EACH of the biodiversity risk topics for EACH operating region. "]
[null,null,"3. When complete, press the \"Transfer Data to Risk Working Table\" button to transfer all 'yes' and 'maybe' topics."]
[null,null,"Please Note: This button should not be pressed until ALL of the data for ALL of the operating regions has been entered."]

{"sheet":"Further Help (2)","index":10,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Grouping Risks and grouping Opportunities"]
[null,null,"‘Once the identified risks and opportunities have been selected for production of Action and Monitoring Plans, now take time to group different risks together, and group different opportunities together, to see if you can design Action and Monitoring Plans that address more than one risk or opportunity simultaneously. You can do this by copying and pasting entire rows on the Action and Monitoring Plans Working Table."]
[null,null,"Risks and opportunities can be grouped by operating area, by specific site, by risk/opportunity topic, by primary cause, or by secondary cause. Risk and Opportunities which can be addressed through the same Action and Monitoring Plans can also be grouped accordingly within the Action and Monitoring Plan Working Table. \n\nThis exercise requires a good knowledge of the area, a good understanding of the causes and context of the risks and opportunities, a clear vision of the desired outcomes, and an understanding of how to achieve those outcomes. Time spent considering the possible grouping of risks and opportunities could prove to be time well spent, as it could help you use your resources more efficiently to create further-reaching and more strategically designed Action and Monitoring Plans.’"]

{"sheet":"Further Help (3)","index":11,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Potential Negative Impacts"]
[]
[null,null,"Identify for each risk topic whether it has potential negative impacts on the 7 categories below.  Answer yes or no for each."]
[]
[null,null,"Habitats and / or protected areas"]
[null,null,"Species of biodiversity significance"]
[null,null,"Ecosystem services"]
[null,null,"Compliance with company policy, biodiversity & environmental legal requirements, liability or obligations incurred"]
[null,null,"The sustainability of farming, or other agricultural production, in the landscape"]
[null,null,"The reputation of the company or stakeholder relationships"]
[null,null,"Company operating  turnover "]
[]
[null,null,"If you have marked ‘yes’ against any of the first 3 biodiversity topics (habitats, species, ecosystem services) you must investigate these risks in more detail through field surveys."]
[]
[null,null,"Any risk topic which has 'no' potential negative impacts on all the 7 categories, does not need to be carried any further through the BROA process."]

{"sheet":"Further Help (4)","index":12,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Risks to be carried over to Phase 3: Action and Monitoring Plans Working Table"]
[]
[null,null,"All risks with an Impact or Dependency score of 3 or above MUST be addressed with an Action and Monitoring Plan. "]
[]
[null,null,"All low risks that can be addressed quickly to avoid them becoming high or medium risks in the future should also be addressed through Action and Monitoring Plans"]
[null,null,"For each risk selected for Action and Monitoring Planning, information on operating region, site, risk topic, description and causes will be automatically copied to the ‘Risks and Opportunities for AMP’ table and transferred to the ‘Action and Monitoring Plans Working Table’ once the ‘Copy information’ button is pressed"]

{"sheet":"Data Ranges","index":13,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Yes","YesNo",null,"Score"]
["yes","YES",null,0]
["no","NO",null,1]
["maybe",null,null,2]
[null,null,null,3]