|
Index |
AU Habitat Group |
AV Group |
AW Existing Area |
AX Existing Value Lost |
AY Proposed Area On-site |
AZ Proposed Value On-site |
BA On-site Area Change |
BB On-site Unit Change |
BC Proposed Area Off-site |
BD Off-site Unit Change |
BE Unit Change Including Off-site |
BF Units Required Off-site or Trading Up |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79 | Cropland - Arable field margins cultivated annually | Cropland | =VLOOKUP($AU79,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU79,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU79,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU79,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU79,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU79,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU79,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU79,AllHabsSummaryData,30,FALSE) | =BB79+BD79 | =IF(BE79<0,BE79,"") |
| 80 | Individual trees - Rural tree | Individual trees | =VLOOKUP($AU80,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU80,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU80,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU80,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU80,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU80,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU80,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU80,AllHabsSummaryData,30,FALSE) | =BB80+BD80 | =IF(BE80,BE80,"") |
| 81 | Cropland - Arable field margins game bird mix | Cropland | =VLOOKUP($AU81,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU81,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU81,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU81,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU81,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU81,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU81,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU81,AllHabsSummaryData,30,FALSE) | =BB81+BD81 | =IF(BE81<0,BE81,"") |
| 82 | Cropland - Arable field margins pollen and nectar | Cropland | =VLOOKUP($AU82,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU82,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU82,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU82,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU82,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU82,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU82,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU82,AllHabsSummaryData,30,FALSE) | =BB82+BD82 | =IF(BE82<0,BE82,"") |
| 83 | Cropland - Arable field margins tussocky | Cropland | =VLOOKUP($AU83,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU83,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU83,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU83,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU83,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU83,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU83,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU83,AllHabsSummaryData,30,FALSE) | =BB83+BD83 | =IF(BE83<0,BE83,"") |
| 84 | Grassland - Other lowland acid grassland | Grassland | =VLOOKUP($AU84,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU84,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU84,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU84,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU84,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU84,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU84,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU84,AllHabsSummaryData,30,FALSE) | =BB84+BD84 | =IF(BE84<0,BE84,"") |
| 85 | Grassland - Other neutral grassland | Grassland | =VLOOKUP($AU85,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU85,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU85,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU85,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU85,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU85,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU85,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU85,AllHabsSummaryData,30,FALSE) | =BB85+BD85 | =IF(BE85<0,BE85,"") |
| 86 | Grassland - Upland acid grassland | Grassland | =VLOOKUP($AU86,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU86,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU86,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU86,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU86,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU86,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU86,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU86,AllHabsSummaryData,30,FALSE) | =BB86+BD86 | =IF(BE86<0,BE86,"") |
| 87 | Heathland and shrub - Blackthorn scrub | Heathland and shrub | =VLOOKUP($AU87,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU87,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU87,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU87,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU87,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU87,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU87,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU87,AllHabsSummaryData,30,FALSE) | =BB87+BD87 | =IF(BE87<0,BE87,"") |
| 88 | Heathland and shrub - Bramble scrub | Heathland and shrub | =VLOOKUP($AU88,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU88,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU88,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU88,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU88,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU88,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU88,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU88,AllHabsSummaryData,30,FALSE) | =BB88+BD88 | =IF(BE88<0,BE88,"") |
| 89 | Heathland and shrub - Gorse scrub | Heathland and shrub | =VLOOKUP($AU89,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU89,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU89,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU89,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU89,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU89,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU89,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU89,AllHabsSummaryData,30,FALSE) | =BB89+BD89 | =IF(BE89<0,BE89,"") |
| 90 | Heathland and shrub - Hawthorn scrub | Heathland and shrub | =VLOOKUP($AU90,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU90,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU90,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU90,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU90,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU90,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU90,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU90,AllHabsSummaryData,30,FALSE) | =BB90+BD90 | =IF(BE90,BE90,"") |
| 91 | Heathland and shrub - Hazel scrub | Heathland and shrub | =VLOOKUP($AU91,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU91,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU91,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU91,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU91,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU91,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU91,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU91,AllHabsSummaryData,30,FALSE) | =BB91+BD91 | =IF(BE91<0,BE91,"") |
| 92 | Heathland and shrub - Mixed scrub | Heathland and shrub | =VLOOKUP($AU92,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU92,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU92,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU92,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU92,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU92,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU92,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU92,AllHabsSummaryData,30,FALSE) | =BB92+BD92 | =IF(BE92<0,BE92,"") |
| 93 | Lakes - Ponds (non-priority habitat) | Lakes | =VLOOKUP($AU93,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU93,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU93,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU93,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU93,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU93,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU93,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU93,AllHabsSummaryData,30,FALSE) | =BB93+BD93 | =IF(BE93<0,BE93,"") |
| 94 | Lakes - Reservoirs | Lakes | =VLOOKUP($AU94,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU94,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU94,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU94,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU94,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU94,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU94,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU94,AllHabsSummaryData,30,FALSE) | =BB94+BD94 | =IF(BE94<0,BE94,"") |
| 95 | Sparsely vegetated land - Other inland rock and scree | Sparsely vegetated land | =VLOOKUP($AU95,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU95,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU95,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU95,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU95,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU95,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU95,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU95,AllHabsSummaryData,30,FALSE) | =BB95+BD95 | =IF(BE95<0,BE95,"") |
| 96 | Urban - Cemeteries and churchyards | Urban | =VLOOKUP($AU96,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU96,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU96,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU96,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU96,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU96,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU96,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU96,AllHabsSummaryData,30,FALSE) | =BB96+BD96 | =IF(BE96<0,BE96,"") |
| 97 | Urban - Biodiverse green roof | Urban | =VLOOKUP($AU97,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU97,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU97,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU97,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU97,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU97,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU97,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU97,AllHabsSummaryData,30,FALSE) | =BB97+BD97 | =IF(BE97<0,BE97,"") |
| 98 | Woodland and forest - Other Scot's pine woodland | Woodland and forest | =VLOOKUP($AU98,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU98,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU98,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU98,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU98,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU98,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU98,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU98,AllHabsSummaryData,30,FALSE) | =BB98+BD98 | =IF(BE98<0,BE98,"") |
| 99 | Woodland and forest - Other woodland; broadleaved | Woodland and forest | =VLOOKUP($AU99,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU99,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU99,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU99,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU99,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU99,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU99,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU99,AllHabsSummaryData,30,FALSE) | =BB99+BD99 | =IF(BE99<0,BE99,"") |
| 100 | Woodland and forest - Other woodland; mixed | Woodland and forest | =VLOOKUP($AU100,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU100,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU100,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU100,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU100,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU100,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU100,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU100,AllHabsSummaryData,30,FALSE) | =BB100+BD100 | =IF(BE100,BE100,"") |
| 101 | Intertidal sediment - Littoral coarse sediment | Intertidal sediment | =VLOOKUP($AU101,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU101,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU101,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU101,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU101,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU101,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU101,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU101,AllHabsSummaryData,30,FALSE) | =BB101+BD101 | =IF(BE101<0,BE101,"") |
| 102 | Intertidal sediment - Littoral sand | Intertidal sediment | =VLOOKUP($AU102,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU102,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU102,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU102,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU102,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU102,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU102,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU102,AllHabsSummaryData,30,FALSE) | =BB102+BD102 | =IF(BE102<0,BE102,"") |
| 103 | Intertidal hard structures - Artificial hard structures with integrated greening of grey infrastructure (IGGI) | Intertidal hard structures | =VLOOKUP($AU103,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU103,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU103,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU103,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU103,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU103,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU103,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU103,AllHabsSummaryData,30,FALSE) | =BB103+BD103 | =IF(BE103<0,BE103,"") |
| 104 | Heathland and shrub - Willow scrub | Heathland and shrub | =VLOOKUP($AU104,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU104,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU104,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU104,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU104,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU104,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU104,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU104,AllHabsSummaryData,30,FALSE) | =BB104+BD104 | =IF(BE104<0,BE104,"") |
| 105 | Individual trees - Urban tree | Individual trees | =VLOOKUP($AU105,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU105,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU105,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU105,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU105,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU105,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU105,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU105,AllHabsSummaryData,30,FALSE) | =BB105+BD105 | =IF(BE105<0,BE105,"") |