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

{"sheet":"Offsets assessment guide","index":0,"n_rows":49,"n_cols":52,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,18,35,19],[42,17,42,19],[42,22,42,24],[39,15,40,16],[41,31,41,36],[38,31,38,37],[34,20,35,20],[34,32,35,32],[34,36,35,36],[47,29,47,30],[48,29,48,30],[34,5,35,5],[34,6,35,10],[34,11,35,11],[34,12,35,12],[32,28,33,29],[25,28,25,29],[38,14,38,30],[39,25,39,30],[39,17,40,19],[39,20,40,20],[39,21,40,21],[39,22,40,24],[34,28,35,29],[39,14,47,14],[46,15,46,16],[46,17,46,19],[46,22,46,24],[46,25,46,26],[30,30,31,30],[25,6,25,10],[30,22,31,23],[45,15,45,16],[27,4,28,4],[27,17,28,17],[27,18,28,19],[27,20,28,20],[27,21,28,21],[27,26,28,27],[29,2,29,12],[30,18,31,19],[30,5,31,5],[30,4,31,4],[30,24,31,25],[27,6,28,10],[27,11,28,11],[30,6,31,10],[30,11,31,11],[30,12,31,12],[32,6,33,10],[32,11,33,11],[32,12,33,12],[27,12,28,12],[32,20,33,20],[25,24,25,25],[25,22,25,23],[26,22,26,23],[26,24,26,25],[23,6,23,9],[24,6,24,9],[32,5,33,5],[34,2,35,3],[25,2,25,3],[26,2,26,3],[1,51,3,52],[4,15,5,16],[4,46,4,47],[4,51,4,52],[6,15,7,16],[5,46,5,47],[5,51,5,52],[6,51,6,52],[15,14,15,38],[7,51,7,52],[8,51,8,52],[10,15,11,16],[9,51,9,52],[10,51,10,52],[11,51,11,52],[12,51,12,52],[34,4,35,4],[27,5,28,5],[22,4,24,4],[22,5,24,5],[22,6,22,9],[22,12,24,12],[22,2,24,3],[21,15,21,38],[22,20,24,20],[22,21,24,21],[22,37,24,37],[22,38,24,38],[22,35,24,35],[22,36,24,36],[22,34,24,34],[21,2,21,12],[16,14,35,14],[25,18,25,19],[16,2,16,3],[16,6,16,10],[16,15,16,16],[26,18,26,19],[25,15,25,16],[26,15,26,16],[16,18,16,19],[22,15,24,16],[18,17,20,17],[18,18,20,19],[18,31,19,31],[18,38,20,38],[3,1,3,10],[2,1,2,10],[11,4,13,7],[8,15,9,16],[7,3,7,4],[8,3,8,4],[9,3,10,4],[18,35,20,35],[18,36,20,36],[18,37,20,37],[16,1,35,1],[27,15,28,16],[30,15,31,16],[34,15,35,16],[32,18,33,19],[32,4,33,4],[32,2,33,3],[30,2,31,3],[27,2,28,3],[26,6,26,10],[16,33,16,34],[16,22,16,23],[0,43,0,50],[3,15,3,16],[1,43,3,43],[1,44,3,44],[1,45,3,45],[1,46,3,47],[1,48,3,48],[1,49,3,49],[1,50,3,50],[16,26,16,27],[18,15,20,16],[22,17,24,17],[22,18,24,19],[4,1,4,10],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[15,1,15,12],[18,4,20,4],[18,5,20,5],[18,6,18,9],[18,12,20,12],[8,6,8,10],[9,6,9,10],[8,11,8,12],[9,11,9,12],[17,2,17,12],[18,2,20,3],[17,15,17,38],[19,6,19,9],[20,6,20,9],[18,20,20,20],[16,28,16,29],[32,36,33,36],[30,36,31,36],[30,35,31,35],[32,35,33,35],[34,35,35,35],[30,31,31,31],[34,31,35,31],[27,38,28,38],[30,37,31,37],[30,38,31,38],[32,37,33,37],[32,38,33,38],[34,37,35,37],[34,38,35,38],[27,35,28,35],[27,37,28,37],[30,33,31,34],[32,33,33,34],[34,33,35,34],[32,31,33,31],[32,32,33,32],[27,31,28,31],[27,28,28,29],[27,36,28,36],[32,15,33,16],[26,33,26,34],[22,30,23,30],[22,31,23,31],[22,32,23,32],[18,32,19,32],[26,28,26,29],[25,33,25,34],[27,33,28,34],[22,33,23,33],[27,32,28,32],[27,30,28,30],[18,33,19,33],[18,30,19,30],[30,32,31,32],[29,15,29,38],[22,22,23,22],[22,25,23,25],[22,24,23,24],[18,21,20,21],[18,34,20,34],[18,23,19,23],[47,17,47,19],[47,22,47,24],[47,25,47,26],[47,27,47,28],[42,25,42,26],[42,27,42,28],[44,15,44,16],[44,17,44,19],[41,15,41,16],[46,27,46,28],[47,15,47,16],[41,17,41,19],[41,22,41,24],[45,17,45,19],[45,22,45,24],[45,25,45,26],[18,22,19,22],[22,23,23,23],[18,24,19,24],[18,25,19,25],[27,22,28,23],[27,24,28,25],[30,20,31,20],[16,24,16,25],[26,26,26,27],[25,26,25,27],[46,31,46,32],[32,30,33,30],[32,26,33,27],[43,15,43,16],[43,17,43,19],[43,22,43,24],[43,25,43,26],[43,27,43,28],[40,25,40,26],[40,27,40,28],[32,22,33,23],[32,24,33,25],[34,22,35,23],[41,25,41,26],[41,27,41,28],[42,15,42,16],[34,24,35,25],[43,31,43,32],[43,29,43,30],[40,29,40,30],[41,29,41,30],[42,29,42,30],[45,29,45,30],[46,29,46,30],[106,17,106,18],[45,27,45,28],[48,25,48,26],[48,27,48,28],[45,31,45,32],[40,31,40,32],[30,17,31,17],[32,17,33,17],[34,17,35,17],[30,21,31,21],[32,21,33,21],[34,21,35,21],[44,31,44,32],[44,25,44,26],[50,22,51,24],[50,27,51,27],[53,24,53,25],[34,30,35,30],[44,27,44,28],[30,26,31,27],[30,28,31,29],[34,26,35,27],[44,22,44,24],[44,29,44,30]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop-down list inputs"]
[null,"Offsets Assessment Guide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EPBC Status","Annual Probability of Extinction","Units","Factor relevant to case?",null,"Quality","To Factor","Rank Options","MNES Ranking"]
[null,"For use in determining offsets under the Environment Protection and Biodiversity Conservation Act 1999 "]
[null,"2012-10-02",null,null,null,null,null,null,null,null,null,null,null,null,null,"Key to Cell Colours"]
[null,"This guide relies on Macros being enabled in your browser.",null,null,null,null,null,null,null,null,null,null,null,null,null,"User input required",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critically Endangered",6.8000000000000005E-2,"Count","Yes",null,0,"Population Viability","N/A",{"$f":"IF(#REF!=\"\",\"N/A\",#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Endangered",1.2E-2,"Adjusted hectares","No",null,1,"Mortality Rate",1,{"$f":"IF(#REF!=\"\",\"N/A\",#REF!)","v":{"$error":"#REF!"}}]
[null,"Matter of National Environmental Significance",null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop-down list",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vulnerable",2E-3,"% Benchmark",null,null,2,"Number of individuals",2,{"$f":"IF(#REF!=\"\",\"N/A\",#REF!)","v":{"$error":"#REF!"}}]
[null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,"%",null,null,3,"Number of features",3,{"$f":"IF(#REF!=\"\",\"N/A\",#REF!)","v":{"$error":"#REF!"}}]
[null,"EPBC Act status ",null,"Endangered",null,null,{"$f":"IF(D9=\"Other\",\"Other annual probability of extinction\",\"\")","v":""},null,null,null,null,{"$f":"IF(D9=\"Other\",\"Information source\",\"\")","v":""},null,null,null,"Calculated output",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hectares",null,null,4,"Condition of habitat",4,{"$f":"IF(#REF!=\"\",\"N/A\",#REF!)","v":{"$error":"#REF!"}}]
[null,"Annual probability of extinction",null,{"$f":"IF(D9=\"Critically Endangered\",AS5, IF(D9=\"Endangered\",AS6, IF(D9=\"Other\",G10, IF(D9=\"Vulnerable\",AS7, \"\"))))","v":1.2E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scale 0-10",null,null,5,"Area of habitat",5,{"$f":"IF(#REF!=\"\",\"N/A\",#REF!)","v":{"$error":"#REF!"}}]
[null,"Based on IUCN category definitions",null,null,null,null,null,null,null,null,null,null,null,null,null,"Not applicable to attribute",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Area of community",6,{"$f":"IF(#REF!=\"\",\"N/A\",#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,7,{"$f":"IF(#REF!=\"\",\"N/A\",#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,"Impact calculator",null,null,null,null,null,null,null,null,null,null,null,null,"Offset calculator"]
[null,"Impact calculator","Protected matter attributes",null,"Attribute relevant to case?","Description","Quantum of impact",null,null,null,null,"Units","Information source",null,"Offset calculator\n","Protected matter attributes",null,"Attribute relevant to case?","Total quantum of impact",null,"Units","Proposed offset","Time horizon (years)",null,"Start area and quality",null,"Future area and quality without offset",null,"Future area and quality with offset",null,"Raw gain","Confidence in result (%)","Adjusted gain","Net present value (adjusted hectares)",null,"% of impact offset","Minimum (90%) direct offset requirement met?","Cost ($ total)","Information source"]
[null,null,"Ecological communities",null,null,null,null,null,null,null,null,null,null,null,null,"Ecological Communities"]
[null,null,"Area of community",null,"No",null,"Area",null,null,null,null,{"$f":"IF(E19=\"Yes\",AT9, IF(E19=\"No\",\"\",\"\"))","v":""},null,null,null,"Area of community",null,"No",{"$f":"IF(K21>=0.1,K21,IF(K21=0,\"\"))","v":""},null,{"$f":"IF(R19=\"Yes\",$AT6, IF(R19=\"No\",\"\",\"\"))","v":""},null,"Risk-related time horizon (max. 20 years)",null,"Start area (hectares)",null,"Risk of loss (%) without offset",null,"Risk of loss (%) with offset",null,{"$f":"IF(R19=\"No\",\"\",IF(R19=\"Yes\",AD20-AB20))","v":""},null,{"$f":"IF(R19=\"Yes\",AE19*AF19, IF(R19=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R19=\"Yes\",(AG19/(1+$D$10)^X19),IF(R19=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R19=\"Yes\",((AH21/10)*AB20)+((AD21/10)*AH19),IF(R19=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R19=\"Yes\",(IF(K21>=0,AI19/K21,\"\")),IF(R19=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R19=\"Yes\",IF(AJ19>=90%,\"Yes\",\"No\"),\"\")","v":""}]
[null,null,null,null,null,null,"Quality",null,null,null,null,{"$f":"IF(E19=\"Yes\",AT10, IF(E19=\"No\",\"\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Future area without offset (adjusted hectares)",{"$f":"Z19*(1-AB19)","v":0},"Future area with offset (adjusted hectares)",{"$f":"Z19*(1-AD19)","v":0}]
[null,null,null,null,null,null,"Total quantum of impact",null,null,null,{"$f":"K19*(K20/10)","v":0},{"$f":"IF(E19=\"Yes\",AT6, IF(E19=\"No\",\"\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,"Time until ecological benefit",null,"Start quality (scale of 0-10)",null,"Future quality without offset (scale of 0-10)",null,"Future quality with offset (scale of 0-10)",null,{"$f":"IF(R19=\"No\",\"\",IF(R19=\"Yes\",AD21-AB21))","v":""},null,{"$f":"IF(R19=\"Yes\",AE21*AF21, IF(R19=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R19=\"Yes\",(AG21/(1+$D$10)^X21),IF(R19=\"No\",\"\",\"\"))","v":""}]
[null,null,"Threatened species habitat",null,null,null,null,null,null,null,null,null,null,null,null,"Threatened species habitat"]
[null,null,"Area of habitat",null,"Yes",null,"Area",null,null,null,13.9,{"$f":"IF(E23=\"Yes\",AT9, IF(E23=\"No\",\"\",\"\"))","v":"Hectares"},null,null,null,"Area of habitat",null,"Yes",{"$f":"IF(K25>=0.1,K25,IF(K25=0,\"\"))","v":9.73},null,{"$f":"IF(R23=\"Yes\",$AT6, IF(R23=\"No\",\"\",\"\"))","v":"Adjusted hectares"},25,"Time over which loss is averted (max. 20 years)",20,"Start area (hectares)",52.5,"Risk of loss (%) without offset",0.35,"Risk of loss (%) with offset",0.05,{"$f":"IF(R23=\"No\",\"\",IF(R23=\"Yes\",AD24-AB24))","v":15.75},0.9,{"$f":"IF(R23=\"Yes\",AE23*AF23, IF(R23=\"No\",\"\",\"\"))","v":14.175000000000001},{"$f":"IF(R23=\"Yes\",(AG23/(1+$D$10)^X23),IF(R23=\"No\",\"\",\"\"))","v":11.16639065403519},{"$f":"IF(R23=\"Yes\",((AH25/10)*AB24)+((AD25/10)*AH23),IF(R23=\"No\",\"\",\"\"))","v":10.239496376386727},{"$f":"IF(R23=\"Yes\",(IF(K25>=0,AI23/K25,\"\")),IF(R23=\"No\",\"\",\"\"))","v":1.0523634508105577},{"$f":"IF(R23=\"Yes\",IF(AJ23>=90%,\"Yes\",\"No\"),\"\")","v":"Yes"}]
[null,null,null,null,null,null,"Quality ",null,null,null,7,{"$f":"IF(E23=\"Yes\",AT10, IF(E23=\"No\",\"\",\"\"))","v":"Scale 0-10"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Future area without offset (adjusted hectares)",{"$f":"Z23*(1-AB23)","v":34.125},"Future area with offset (adjusted hectares)",{"$f":"Z23*(1-AD23)","v":49.875}]
[null,null,null,null,null,null,"Total quantum of impact",null,null,null,{"$f":"K23*(K24/10)","v":9.73},{"$f":"IF(E23=\"Yes\",AT6, IF(E23=\"No\",\"\",\"\"))","v":"Adjusted hectares"},null,null,null,null,null,null,null,null,null,null,"Time until ecological benefit",10,"Start quality (scale of 0-10)",7,"Future quality without offset (scale of 0-10)",6,"Future quality with offset (scale of 0-10)",7,{"$f":"IF(R23=\"No\",\"\",IF(R23=\"Yes\",AD25-AB25))","v":1},0.8,{"$f":"IF(R23=\"Yes\",AE25*AF25, IF(R23=\"No\",\"\",\"\"))","v":0.8},{"$f":"IF(R23=\"Yes\",(AG25/(1+$D$10)^X25),IF(R23=\"No\",\"\",\"\"))","v":0.71004334609878217}]
[null,null,"Protected matter attributes",null,"Attribute relevant to case?","Description","Quantum of impact",null,null,null,null,"Units","Information source",null,null,"Protected matter attributes",null,"Attribute relevant to case?","Total quantum of impact",null,"Units","Proposed offset","Time horizon (years)",null,"Start value",null,"Future value without offset",null,"Future value with offset",null,"Raw gain","Confidence in result (%)","Adjusted gain","Net present value ",null,"% of impact offset","Minimum (90%) direct offset requirement met?","Cost ($ total)","Information source"]
[null,null,"Number of features\ne.g. Nest hollows, habitat trees",null,"Yes","Habitat trees",45,null,null,null,null,{"$f":"IF(E27=\"Yes\",$AT5, IF(E27=\"No\",\"\",\"\"))","v":"Count"},"Survey",null,null,"Number of features\ne.g. Nest hollows, habitat trees",null,"Yes",{"$f":"IF(G27>=0.1,G27,IF(G27=\"\",\"\"))","v":45},null,{"$f":"IF(R27=\"Yes\",$AT5, IF(R27=\"No\",\"\",\"\"))","v":"Count"},150,20,null,150,null,0,null,150,null,{"$f":"IF(R27=\"No\",\"\",IF(R27=\"Yes\",AC27-AA27))","v":150},0.9,{"$f":"IF(R27=\"Yes\",AE27*AF27, IF(R27=\"No\",\"\",\"\"))","v":135},{"$f":"IF(R27=\"Yes\",AG27/(1+$D$10)^W27, IF(R27=\"No\",\"\",\"\"))","v":106.34657765747799},null,{"$f":"IF(R27=\"Yes\",(IF(G27>=0,AH27/G27,\"\")), IF(R27=\"No\",\"\",\"\"))","v":2.363257281277289},{"$f":"IF(R27=\"Yes\",IF(AJ27>=90%,\"Yes\",\"No\"),\"\")","v":"Yes"}]
[null,null,"Condition of habitat\nChange in habitat condition, but no change in extent",null,"No",null,null,null,null,null,null,{"$f":"IF(E28=\"Yes\",$AT7, IF(E28=\"No\",\"\",\"\"))","v":""},null,null,null,"Condition of habitat\nChange in habitat condition, but no change in extent",null,"No",{"$f":"IF(G28>=0.1,G28,IF(G28=\"\",\"\"))","v":""},null,{"$f":"IF(R28=\"Yes\",$AT7, IF(R28=\"No\",\"\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(R28=\"No\",\"\",IF(R28=\"Yes\",AC28-AA28))","v":""},null,{"$f":"IF(R28=\"Yes\",AE28*AF28, IF(R28=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R28=\"Yes\",AG28/(1+$D$10)^W28, IF(R28=\"No\",\"\",\"\"))","v":""},null,{"$f":"IF(R28=\"Yes\",(IF(G28>=0,AH28/G28,\"\")), IF(R28=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R28=\"Yes\",IF(AJ28>=90%,\"Yes\",\"No\"),\"\")","v":""}]
[]
[null,null,"Threatened species",null,null,null,null,null,null,null,null,null,null,null,null,"Threatened species"]
[null,null,"Birth rate\ne.g. Change in nest success",null,"No",null,null,null,null,null,null,{"$f":"IF(E31=\"Yes\",$AT8, IF(E31=\"No\",\"\",\"\"))","v":""},null,null,null,"Birth rate\ne.g. Change in nest success",null,"No",{"$f":"IF(G31>=0.1,G31,IF(G31=\"\",\"\"))","v":""},null,{"$f":"IF(R31=\"Yes\",$AT8, IF(R31=\"No\",\"\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(R31=\"No\",\"\",IF(R31=\"Yes\",AC31-AA31))","v":""},null,{"$f":"IF(R31=\"Yes\",AE31*AF31, IF(R31=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R31=\"Yes\",AG31/(1+$D$10)^W31, IF(R31=\"No\",\"\",\"\"))","v":""},null,{"$f":"IF(R31=\"Yes\",(IF(G31>=0,AH31/G31,\"\")), IF(R31=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R31=\"Yes\",IF(AJ31>=90%,\"Yes\",\"No\"),\"\")","v":""}]
[]
[null,null,"Mortality rate\ne.g Change in number of road kills per year",null,"No",null,null,null,null,null,null,{"$f":"IF(E33=\"Yes\",$AT8, IF(E33=\"No\",\"\",\"\"))","v":""},null,null,null,"Mortality rate\ne.g Change in number of road kills per year",null,"No",{"$f":"IF(G33>=0.1,G33,IF(G33=\"\",\"\"))","v":""},null,{"$f":"IF(R33=\"Yes\",$AT8, IF(R33=\"No\",\"\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(R33=\"No\",\"\",IF(R33=\"Yes\",AA33-AC33))","v":""},null,{"$f":"IF(R33=\"Yes\",AE33*AF33, IF(R33=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R33=\"Yes\",AG33/(1+$D$10)^W33, IF(R33=\"No\",\"\",\"\"))","v":""},null,{"$f":"IF(R33=\"Yes\",(IF(G33>=0,AH33/G33,\"\")), IF(R33=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R33=\"Yes\",IF(AJ33>=90%,\"Yes\",\"No\"),\"\")","v":""}]
[]
[null,null,"Number of individuals\ne.g. Individual plants/animals",null,"No",null,null,null,null,null,null,{"$f":"IF(E35=\"Yes\",$AT5, IF(E35=\"No\",\"\",\"\"))","v":""},null,null,null,"Number of individuals\ne.g. Individual plants/animals",null,"No",{"$f":"IF(G35>=0.1,G35,IF(G35=\"\",\"\"))","v":""},null,{"$f":"IF(R35=\"Yes\",$AT5, IF(R35=\"No\",\"\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(R35=\"No\",\"\",IF(R35=\"Yes\",AC35-AA35))","v":""},null,{"$f":"IF(R35=\"Yes\",AE35*AF35, IF(R35=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R35=\"Yes\",AG35/(1+$D$10)^W35, IF(R35=\"No\",\"\",\"\"))","v":""},null,{"$f":"IF(R35=\"Yes\",(IF(G35>=0,AH35/G35,\"\")), IF(R35=\"No\",\"\",\"\"))","v":""},{"$f":"IF(R35=\"Yes\",IF(AJ35>=90%,\"Yes\",\"No\"),\"\")","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary","Protected matter attributes",null,"Quantum of impact",null,null,"Net present value of offset","% of impact offset","Direct offset adequate?",null,null," Cost ($)"]
[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,"Direct offset ($)",null,"Other compensatory measures ($)",null,"Total ($)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Birth rate",null,{"$f":"G31","v":0},null,null,{"$f":"AH31","v":""},{"$f":"AJ31","v":""},{"$f":"IF(V42=\"\",\"\",IF(V42>=0.9,\"Yes\",\"No\"))","v":""},null,null,{"$f":"AL31","v":0},null,{"$f":"IF(V42=\"\",\"\",IF(V42>1,\"N/A\",IF(R42>=0,IF(V42>0,1/(V42/Z42^(1/3))^3-Z42,\"N/A\"),\"0\")))","v":""},null,{"$f":"SUM(Z42:AC42)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mortality rate",null,{"$f":"G33","v":0},null,null,{"$f":"AH33","v":""},{"$f":"AJ33","v":""},"",null,null,{"$f":"AL33","v":0},null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of individuals",null,{"$f":"G35","v":0},null,null,{"$f":"AH35","v":""},{"$f":"AJ35","v":""},"",null,null,{"$f":"AL35","v":0},null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of features",null,{"$f":"G27","v":45},null,null,{"$f":"AH27","v":106.34657765747799},{"$f":"AJ27","v":2.363257281277289},"Yes",null,null,{"$f":"AL27","v":0},null,"N/A",null,{"$f":"SUM(Z45:AC45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condition of habitat",null,{"$f":"G28","v":0},null,null,{"$f":"AH28","v":""},{"$f":"AJ28","v":""},"",null,null,{"$f":"AL28","v":0},null,"",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area of habitat",null,{"$f":"K25","v":9.73},null,null,{"$f":"AI23","v":10.239496376386727},{"$f":"AJ23","v":1.0523634508105577},"Yes",null,null,{"$f":"AL23","v":0},null,"N/A",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area of community",null,{"$f":"K21","v":0},null,null,{"$f":"AI19","v":""},{"$f":"AJ19","v":""},"",null,null,{"$f":"AL19","v":0},null,"",null,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":"SUM(Z42:AA48)","v":0},null,{"$f":"SUM(AB42:AC48)","v":0},null,{"$f":"SUM(AD42:AD48)","v":0}]