{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Step1_ConservationSignificance","Step2_SignificantResidualImpact","Step3_Offsets","Rationale"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":9,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[17,2,22,2],[17,3,22,3],[0,0,0,6],[2,2,2,3],[15,3,16,3],[15,2,16,2],[9,2,9,4],[13,2,13,4],[8,2,8,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[1,0,1,6]]}
["WA Environmental Offsets calculator"]
["PLEASE ENABLE MACROS FOR THIS SPREADSHEET"]
[]
[]
[null,null,"Produced by:"]
[null,null,"The Department of Water and Environmental Regulation (DWER) in consultation with stakeholder working groups"]
[null,null,"Purpose:"]
[null,null,"Use the WA Envirionmental Offsets calculator in conjunction with the Environmental offsets metric: Quantifying environmental offsets in Western Australia guideline. Together, they form a supplement to section 4 of the WA Environmental Offsets Guidelines and provide information to help decision-makers, government officers, industry and the community to quantify environmental offsets."]
[null,null,"Data currency:"]
[null,null,"The correct application of the WA Environmental Offsets Calculator relies on access to current datasets (such as vegetation extent and land tenure)."]
[]
[]
[]
[null,null,"Process for using the WA Environmental Offsets Calculator"]
[null,null,"Step","Worksheet","Component"]
[null,null,"Step 1: Determining conservation significance","Step1_ConservationSignificance","Conservation significance determination"]
[null,null,null,null,"Combined area/feature"]
[null,null,"Step 2: Calculating significant residual impact","Step2_SignificantResidualImpact","Part A: Significant impact calculation"]
[null,null,null,null,"Separate area or feature calculations"]
[null,null,null,null,"Part B: Rehabilitation credit calculation"]
[null,null,null,null,"Separate area or feature calculations"]
[null,null,null,null,"Part C: Significant residual impact calculation"]
[null,null,null,null,"Separate area or feature calculations"]
[null,null,"Step 3: Calculating offsets","Step3_Offsets","Offsets calculation"]
[null,null,null,null,"Separate area or feature calculations"]
[null,null,"Rationale for scores used in the Offsets Calculator","Rationale","All"]

{"sheet":"Step1_ConservationSignificance","index":1,"n_rows":24,"n_cols":22,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,1,8,8],[2,0,2,9],[0,0,0,9],[0,13,0,21],[16,3,16,4],[9,1,12,1],[9,3,9,8],[10,3,10,8],[11,3,11,8],[12,3,12,8],[16,1,16,2],[1,0,1,9]]}
["WA Environmental Offsets Calculator",null,null,null,null,null,null,null,null,null,null,null,null,"Calculations"]
[]
["Step 1: Determining conservation significance"]
[null,null,null,null,null,"Key:",null,null,null,null,null,null,null,"Type","Species (flora/fauna)","Ecological Community","Wetland/watercourse","Vegetation/Habitat","Conservation Area","Value","Score","Type"]
[null,null,null,null,null,null,"Data to be entered",null,null,null,null,null,null,"Species (flora/fauna)","Rare/threatened species - critically endangered","Threatened ecological community - critically endangered","Vegetation associated with a wetland or watercourse for which an offset is required","Terrestrial native vegetation complex - <30% extent remaining in the bioregion","Crown reserve established under the Conservation and Land Management Act 1984 and/or the Land Administration Act 1997 for the purpose of conservation","Rare/threatened species - critically endangered",6.8000000000000005E-2,"Area"]
[null,null,null,null,null,null,"Drop-down selection",null,null,null,null,null,null,"Ecological community","Rare/threatened species - endangered","Threatened ecological community - endangered","A category or type of wetland or watercourse for which an offset is required","Terrestrial native vegetation complex - <10% extent remaining in a constrained area","Conservation covenant","Rare/threatened Species - endangered",1.2E-2,"Feature"]
[null,null,null,null,null,null,"Automatically-generated scores",null,null,null,null,null,null,"Wetland/watercourse","Rare/threatened Species - vulnerable","Threatened ecological community - vulnerable",null,"Habitat supporting migratory species (e.g. listed in the JAMBA, CAMBA or RoKAMBA)","Bush Forever site","Rare/threatened species - vulnerable",2E-3]
[null,"Area / feature (Impact site)",null,null,null,null,"(Or, if appropriate, manual data entry permitted)",null,null,null,null,null,null,"Vegetation/habitat","Priority species","Priority ecological community",null,"Vegetation/Habitat representative of high biodiversity","Other conservation area","Priority species",1E-3]
[null,"Conservation significance determination\nfor the environmental value impacted",null,null,null,null,null,null,null,null,null,null,null,"Conservation area","Other species","Other ecological community",null,null,null,"Other species",1E-3]
[null,"Conservation significance","Description","Northern Quoll and Pilbara Olive Python Habitat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Threatened ecological community - critically endangered",6.8000000000000005E-2]
[null,null,"Type of environmental value","Species (flora/fauna)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Threatened ecological community - endangered",1.2E-2]
[null,null,"Conservation significance of environmental value","Rare/threatened species - endangered",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Threatened ecological community - vulnerable",2E-3]
[null,null,"Conservation significance score",{"$f":"IF(D12=\"\",0,IF(D12>\"\",VLOOKUP(D12,T5:U24,2,FALSE)))","v":1.2E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Priority ecological community",1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other ecological community",1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vegetation associated with a wetland or watercourse for which an offset is required",1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A category or type of wetland or watercourse for which an offset is required",1E-3]
[null,"Please select area or feature for the calculations",null,"Area",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terrestrial native vegetation complex - <30% extent remaining in the bioregion",1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terrestrial native vegetation complex - <10% extent remaining in a constrained area",1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Habitat supporting migratory species (e.g. listed in the JAMBA, CAMBA or RoKAMBA)",1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vegetation/Habitat representative of high biodiversity",1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crown reserve established under the Conservation and Land Management Act 1984 and/or the Land Administration Act 1997 for the purpose of conservation","A conservation significance score does not apply in this case; an offset ratio may be appropriate (step 3)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conservation covenant","A conservation significance score does not apply in this case; an offset ratio may be appropriate (step 3)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bush Forever site","A conservation significance score does not apply in this case; an offset ratio may be appropriate (step 3)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other conservation area","A conservation significance score does not apply in this case; an offset ratio may be appropriate (step 3)"]

{"sheet":"Step2_SignificantResidualImpact","index":2,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[[19,13,19,17],[0,13,0,17],[20,0,23,0],[20,7,23,7],[15,1,17,1],[21,1,23,1],[13,0,13,3],[19,7,19,9],[22,4,23,4],[22,5,23,5],[19,0,19,5],[0,0,0,9],[14,0,17,0],[14,2,14,3],[2,0,2,9],[22,8,23,8],[32,13,32,17],[35,9,36,9],[35,8,36,8],[33,7,36,7],[22,9,23,9],[32,7,32,9],[1,0,1,9],[8,0,10,1],[8,2,10,2],[35,4,36,4],[35,5,36,5],[34,1,36,1],[33,0,36,0],[26,0,26,3],[27,0,30,0],[27,2,27,3],[28,1,30,1],[32,0,32,5],[15,4,17,4]]}
["WA Environmental Offsets Calculator",null,null,null,null,null,null,null,null,null,null,null,null,"Calculations"]
[]
["Step 2: Calculating significant residual impact"]
[null,null,null,null,null,"Key:"]
[null,null,null,null,null,null,"Data to be entered"]
[null,null,null,null,null,null,"Drop-down selection"]
[null,null,null,null,null,null,"Automatically-generated scores"]
[]
["Environmental value\n(step 1)",null,{"$f":"Step1_ConservationSignificance!$D$10","v":"Northern Quoll and Pilbara Olive Python Habitat"}]
[]
[]
["(SCROLL DOWN FOR FEATURE CALCULATION)"]
["Area (impact site)"]
["Part A: Significant impact calculation\nArea"]
["Significant impact","Description","Quantum of impact"]
[null,"Clearing of NQ/POP habitat","Significant impact (hectares)",67.53,{"$f":"IF(Step1_ConservationSignificance!D12=\"Crown reserve established under the Conservation and Land Management Act 1984 and/or the Land Administration Act 1997 for the purpose of conservation\",\"NOTE: Quality score must be entered as '10' for a Crown reserve established for the purpose of conservation\",\"\")","v":""}]
[null,null,"Quality (scale)",7]
[null,null,"Total quantum of impact",{"$f":"D16*(D17/10)","v":47.271000000000001}]
[]
["Part B: Rehabilitation credit calculation\nArea (onsite)",null,null,null,null,null,null,"Part C: Significant residual impact calculation Area",null,null,null,null,null,"Part B: Rehabilitation Credit Calculation\nArea (On-site)"]
["Rehabilitation Credit","Description","Proposed rehabilitation (area in hectares)",null,"Time until ecological benefit (years)",null,null,"Significant residual impact","Total quantum of impact",{"$f":"D18","v":47.271000000000001},null,null,null,null,"Quality",null,"Conservation significance score",{"$f":"IF(Step1_ConservationSignificance!$D$13=0%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=0.1%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=0.2%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=1.2%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=6.8%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=\"A conservation significance score does not apply in this case; an offset ratio may be appropriate (Step 3)\",0,0))))))","v":1.2E-2}]
[null,null,"Current quality of rehabilitation site (scale)",null,"Confidence in rehabilitation result (%)",null,null,null,"Rehabilitation credit",{"$f":"F23","v":0},null,null,null,"Raw gain",{"$f":"(D24-D22)-(D23-D22)","v":0}]
[null,null,"Future quality WITHOUT rehabilitation (scale)",null,"Rehabilitation credit",{"$f":"(O24/10)*D21","v":0},null,null,"Significant residual impact",{"$f":"J21-J22","v":47.271000000000001},null,null,null,"Adjusted gain",{"$f":"O22*F22","v":0}]
[null,null,"Future quality WITH rehabilitation (scale)",null,null,null,null,null,null,null,null,null,null,"Net present value (adjusted)",{"$f":"O23/(1+R21)^F21","v":0}]
[]
["Feature (impact site)"]
["Part A: Significant impact calculation\nFeature"]
["Significant impact","Description","Quantum of impact"]
[null,null,"Type of feature","Number"]
[]
[null,null,"Total quantum of impact",{"$f":"D30","v":0}]
[]
["Part B: Rehabilitation credit calculation\nFeature (onsite)",null,null,null,null,null,null,"Part C: Significant residual impact calculation Feature",null,null,null,null,null,"Part B: Rehabilitation Credit Calculation\nFeature (On-site)"]
["Rehabilitation credit","Description","Start number (of type of feature)",null,"Time until ecological benefit (years)",null,null,"Significant residual impact","Total quantum of impact",{"$f":"D31","v":0},null,null,null,null,"Number",null,"Conservation significance score",{"$f":"IF(Step1_ConservationSignificance!$D$13=0%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=0.1%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=0.2%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=1.2%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=6.8%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=\"A conservation significance score does not apply in this case; an offset ratio may be appropriate (Step 3)\",0,0))))))","v":1.2E-2}]
[null,null,"Future number WITHOUT rehabilitation",null,"Confidence in rehabilitation result (%)",null,null,null,"Rehabilitation credit",{"$f":"F36","v":0},null,null,null,"Raw gain",{"$f":"(D36-D34)-(D35-D34)","v":0}]
[null,null,"Future number WITH rehabilitation",null,"Rehabilitation credit",{"$f":"O36/(1+R34)^F34","v":0},null,null,"Significant residual impact",{"$f":"J34-J35","v":0},null,null,null,"Adjusted gain",{"$f":"O35*F35","v":0}]

{"sheet":"Step3_Offsets","index":3,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[[22,1,22,8],[22,13,22,18],[23,7,24,7],[24,2,26,2],[23,1,26,1],[0,13,0,21],[14,7,15,7],[13,1,13,8],[13,13,13,18],[16,7,17,7],[14,1,19,1],[15,2,17,2],[17,19,19,21],[0,0,0,9],[2,0,2,9],[8,1,10,2],[8,4,8,5],[9,4,9,5],[10,4,10,5],[8,3,10,3],[1,0,1,9]]}
["WA Environmental Offsets Calculator",null,null,null,null,null,null,null,null,null,null,null,null,"Calculations"]
[]
["Step 3: Calculating offsets"]
[null,null,null,null,null,null,"Key:"]
[null,null,null,null,null,null,null,"Data to be entered"]
[null,null,null,null,null,null,null,"Drop-down selection"]
[null,null,null,null,null,null,null,"Automatically-generated scores"]
[]
[null,"Environmental value\n(step 1)",null,{"$f":"Step1_ConservationSignificance!$D$10","v":"Northern Quoll and Pilbara Olive Python Habitat"},"Significant impact\n(step 2, part A)",null,{"$f":"Step2_SignificantResidualImpact!$D$16+Step2_SignificantResidualImpact!$D$31","v":67.53}]
[null,null,null,null,"Rehabilitation credit\n(step 2, part B)",null,{"$f":"Step2_SignificantResidualImpact!$F$23+Step2_SignificantResidualImpact!$F$36","v":0}]
[null,null,null,null,"Significant residual impact\n(step 2, part C)",null,{"$f":"Step2_SignificantResidualImpact!$J$23+Step2_SignificantResidualImpact!$J$36","v":47.271000000000001}]
[null,"(SCROLL DOWN FOR FEATURE CALCULATION)"]
[null,"Area (offset site)"]
[null,"Offset calculation\nArea",null,null,null,null,null,null,null,null,null,null,null,"Offsets Calculation - Land Acquisition / On-ground Management\nArea"]
[null,"Offsets calculation","Description","Proposed offset (area in hectares)",225,"Duration of offset implementation (maximum 20 years)",20,"Offset value",{"$f":"IF(S15>0%,((P20/10)*O16)+((E18/10)*O20),E15)","v":48.023715415019772},null,null,null,null,null,"Risk","Quality",null,"Conservation significance score",{"$f":"IF(Step1_ConservationSignificance!$D$13=0%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=0.1%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=0.2%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=1.2%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=6.8%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=\"A conservation significance score does not apply in this case; an offset ratio may be appropriate (Step 3)\",0,0))))))","v":1.2E-2}]
[null,null,"Land management to address weed and grazing impacts","Current quality of offset site (scale)",4,"Time until offset site secured (years)",1,null,{"$f":"I15/Step2_SignificantResidualImpact!J23","v":1.015923407903784},null,null,null,null,"Future area without offset (adjusted)",{"$f":"E15*(1-G17)","v":202.5},null,null,"Conservation Area?",{"$f":"IF(Step1_ConservationSignificance!D11=Step1_ConservationSignificance!S4,\"Yes\",\"No\")","v":"No"}]
[null,null,null,"Future quality WITHOUT offset (scale)",3,"Risk of future loss WITHOUT offset (%)",0.1,"Offset value\nConservation area\n(applied to step 2, part A)\n\n\n",3,null,null,null,null,"Future area with offset (adjusted)",{"$f":"E15*(1-(G18*G15+(G17*(20-G15)))/20)","v":202.5},null,null,"Offset for significant residual impact","Offset for Conservation Area"]
[null,null,null,"Future quality WITH offset (scale)",6,"Risk of future loss WITH offset (%)",0.1,null,{"$f":"E15/(I17*Step2_SignificantResidualImpact!D16)","v":1.1106175033318524},null,null,null,null,"Raw gain",{"$f":"O17-O16","v":0},{"$f":"(E18-E16)-(E17-E16)","v":3},"Offset adequate? (Y=1; N=0; N/A=0)",{"$f":"IF(I15<Step2_SignificantResidualImpact!J23,0,IF(I15>=Step2_SignificantResidualImpact!J23,1))","v":1},{"$f":"IF(E15<(I17*Step2_SignificantResidualImpact!$D$16),0,IF(E15>=(I17*Step2_SignificantResidualImpact!$D$16),1,IF(S16=\"No\",1)))","v":1},{"$f":"IF(R19>10,\"The spatial offset is more than ten times the spatial impact - this offset design may be unfeasible; reconsideration recommended\",IF(S19>10,\"The spatial offset is more than ten times the spatial impact - this offset design may be unfeasible; reconsideration recommended\",IF(R19<1,\"The spatial offset is less than the spatial impact - this offset design may be inconsistent with the WA Environmental Offsets Policy\",IF(S19<1,\"The spatial offset is less than the spatial impact - this offset design may be inconsistent with the WA Environmental Offsets Policy\",\"\"))))","v":""}]
[null,null,null,"Time until ecological benefit (years)",1,null,null,null,null,null,null,null,null,"Adjusted gain",null,{"$f":"P18*E20","v":2.4000000000000004},"Ratio",{"$f":"E15/Step2_SignificantResidualImpact!D16","v":3.3318525099955574},{"$f":"E15/Step2_SignificantResidualImpact!D16","v":3.3318525099955574}]
[null,null,null,"Confidence in offset result (%)",0.8,null,null,"OFFSET ADEQUATE?",{"$f":"IF((R18+S18)<=1,\"NO\",IF((R18+S18)>1,\"YES\"))","v":"YES"},null,null,null,null,"Net present value (adjusted)",{"$f":"O18/(1+S15)^G16","v":0},{"$f":"P19/(1+S15)^E19","v":2.3715415019762851},"Ratio offset:impact",{"$f":"ROUND(E15/Step2_SignificantResidualImpact!D16,2)&\":\"&1","v":"3.33:1"},{"$f":"ROUND(E15/Step2_SignificantResidualImpact!D16,2)&\":\"&1","v":"3.33:1"}]
[]
[null,"Feature (offset site)"]
[null,"Offset calculation\nFeature",null,null,null,null,null,null,null,null,null,null,null,"Offsets Calculation\nFeature"]
[null,"Offsets calculation","Description","Start number (of type of feature)",null,"Time until ecological benefit (years)",null,"Offset value",{"$f":"O26/(1+S24)^G24","v":0},null,null,null,null,null,"Number",null,null,"Conservation significance score",{"$f":"IF(Step1_ConservationSignificance!$D$13=0%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=0.1%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=0.2%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=1.2%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=6.8%,Step1_ConservationSignificance!$D$13,IF(Step1_ConservationSignificance!$D$13=\"A conservation significance score does not apply in this case; an offset ratio may be appropriate (Step 3)\",0,0))))))","v":1.2E-2}]
[null,null,null,"Future number WITHOUT offset",null,"Confidence in offset result (%)",null,null,{"$f":"I24/Step2_SignificantResidualImpact!J36","v":{"$error":"#DIV/0!"}},null,null,null,null,"Raw gain",{"$f":"(E26-E24)-(E25-E24)","v":0}]
[null,null,null,"Future number WITH offset",null,null,null,null,null,null,null,null,null,"Adjusted gain",{"$f":"O25*G25","v":0}]
[null,null,null,null,null,null,null,"OFFSET ADEQUATE?",{"$f":"IF(I24<Step2_SignificantResidualImpact!J36,\"NO\",IF(I24>=Step2_SignificantResidualImpact!J36,\"YES\"))","v":"YES"}]

{"sheet":"Rationale","index":4,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,0,2,3],[0,0,0,3],[1,0,1,3]]}
["WA Environmental Offsets Calculator"]
[]
["Rationale for scores used in the offsets calculator"]
[]
[]
[]
[]
["Environmental value to be offset"]
["Calculation","Score (Area)","Score (Feature)","Rationale"]
["Conservation significance"]
["Description",{"$f":"Step1_ConservationSignificance!D10","v":"Northern Quoll and Pilbara Olive Python Habitat"},{"$f":"Step1_ConservationSignificance!D10","v":"Northern Quoll and Pilbara Olive Python Habitat"},"Refer to Offset Strategy"]
["Type of environmental value",{"$f":"Step1_ConservationSignificance!D11","v":"Species (flora/fauna)"},{"$f":"Step1_ConservationSignificance!D11","v":"Species (flora/fauna)"}]
["Conservation significance of environmental value",{"$f":"Step1_ConservationSignificance!D12","v":"Rare/threatened species - endangered"},{"$f":"Step1_ConservationSignificance!D12","v":"Rare/threatened species - endangered"}]
["Landscape-level value impacted","yes/no","yes/no"]
["Significant impact"]
["Description",{"$f":"Step2_SignificantResidualImpact!B16","v":"Clearing of NQ/POP habitat"},{"$f":"Step2_SignificantResidualImpact!B29","v":0}]
["Significant impact (hectares) / Type of feature",{"$f":"Step2_SignificantResidualImpact!D16","v":67.53},{"$f":"Step2_SignificantResidualImpact!C30","v":0}]
["Quality (scale) / Number",{"$f":"Step2_SignificantResidualImpact!D17","v":7},{"$f":"Step2_SignificantResidualImpact!D30","v":0}]
["Rehabilitation credit"]
["Description",{"$f":"Step2_SignificantResidualImpact!B22","v":0},{"$f":"Step2_SignificantResidualImpact!B35","v":0}]
["Proposed rehabilitation (area in hectares)",{"$f":"Step2_SignificantResidualImpact!D21","v":0},"N/A"]
["Current quality of rehabilitation site / Start number (of type of feature)",{"$f":"Step2_SignificantResidualImpact!D22","v":0},{"$f":"Step2_SignificantResidualImpact!D34","v":0}]
["Future quality WITHOUT rehabilitation (scale) / Future number WITHOUT rehabilitation",{"$f":"Step2_SignificantResidualImpact!D23","v":0},{"$f":"Step2_SignificantResidualImpact!D35","v":0}]
["Future quality WITH rehabilitation (scale) / \nFuture number WITH rehabilitation",{"$f":"Step2_SignificantResidualImpact!D24","v":0},{"$f":"Step2_SignificantResidualImpact!D36","v":0}]
["Time until ecological benefit (years)",{"$f":"Step2_SignificantResidualImpact!F21","v":0},{"$f":"Step2_SignificantResidualImpact!F34","v":0}]
["Confidence in rehabilitation result (%)",{"$f":"Step2_SignificantResidualImpact!F22","v":0},{"$f":"Step2_SignificantResidualImpact!F35","v":0}]
["Offset"]
["Description",{"$f":"Step3_Offsets!C16","v":"Land management to address weed and grazing impacts"},{"$f":"Step3_Offsets!C25","v":0}]
["Proposed offset (area in hectares)",{"$f":"Step3_Offsets!E15","v":225},"N/A"]
["Current quality of offset site / Start number (of type of feature)",{"$f":"Step3_Offsets!E16","v":4},{"$f":"Step3_Offsets!E24","v":0}]
["Future quality WITHOUT offset (scale) / Future number WITHOUT offset",{"$f":"Step3_Offsets!E17","v":3},{"$f":"Step3_Offsets!E25","v":0}]
["Future quality WITH offset (scale) / Future number WITH offset",{"$f":"Step3_Offsets!E18","v":6},{"$f":"Step3_Offsets!E26","v":0}]
["Time until ecological benefit (years)",{"$f":"Step3_Offsets!E19","v":1},{"$f":"Step3_Offsets!G24","v":0}]
["Confidence in offset result (%)",{"$f":"Step3_Offsets!E20","v":0.8},{"$f":"Step3_Offsets!G25","v":0}]
["Duration of offset implementation (maximum 20 years)",{"$f":"Step3_Offsets!G15","v":20},"N/A"]
["Time until offset site secured (years)",{"$f":"Step3_Offsets!G16","v":1},"N/A"]
["Risk of future loss WITHOUT offset (%)",{"$f":"Step3_Offsets!G17","v":0.1},"N/A"]
["Risk of future loss WITH offset (%)",{"$f":"Step3_Offsets!G18","v":0.1},"N/A"]
["Offset ratio (Conservation area only)",{"$f":"IF(Step3_Offsets!S16=\"No\",\"N/A\",Step3_Offsets!I17)","v":"N/A"},"N/A"]
["Landscape level values of offset?","N/A","N/A"]