|
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 |
BG Area Lost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | Grassland - Lowland dry acid grassland | Grassland | =VLOOKUP($AU5,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU5,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU5,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU5,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU5,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU5,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU5,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU5,AllHabsSummaryData,30,FALSE) | =BB5+BD5 | =IF(BE5<0,BE5,"") | =VLOOKUP($AU5,AllHabsSummaryData,9,FALSE) |
| 6 | Grassland - Lowland meadows | Grassland | =VLOOKUP($AU6,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU6,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU6,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU6,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU6,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU6,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU6,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU6,AllHabsSummaryData,30,FALSE) | =BB6+BD6 | =IF(BE6<0,BE6,"") | =VLOOKUP($AU6,AllHabsSummaryData,9,FALSE) |
| 7 | Grassland - Upland hay meadows | Grassland | =VLOOKUP($AU7,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU7,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU7,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU7,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU7,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU7,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU7,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU7,AllHabsSummaryData,30,FALSE) | =BB7+BD7 | =IF(BE7<0,BE7,"") | =VLOOKUP($AU7,AllHabsSummaryData,9,FALSE) |
| 8 | Heathland and shrub - Mountain heaths and willow scrub | Heathland and shrub | =VLOOKUP($AU8,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU8,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU8,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU8,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU8,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU8,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU8,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU8,AllHabsSummaryData,30,FALSE) | =BB8+BD8 | =IF(BE8<0,BE8,"") | =VLOOKUP($AU8,AllHabsSummaryData,9,FALSE) |
| 9 | Lakes - Aquifer fed naturally fluctuating water bodies | Lakes | =VLOOKUP($AU9,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU9,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU9,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU9,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU9,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU9,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU9,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU9,AllHabsSummaryData,30,FALSE) | =BB9+BD9 | =IF(BE9<0,BE9,"") | =VLOOKUP($AU9,AllHabsSummaryData,9,FALSE) |
| 10 | Sparsely vegetated land - Calaminarian grasslands | Sparsely vegetated land | =VLOOKUP($AU10,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU10,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU10,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU10,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU10,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU10,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU10,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU10,AllHabsSummaryData,30,FALSE) | =BB10+BD10 | =IF(BE10,BE10,"") | =VLOOKUP($AU10,AllHabsSummaryData,9,FALSE) |
| 11 | Sparsely vegetated land - Limestone pavement | Sparsely vegetated land | =VLOOKUP($AU11,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU11,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU11,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU11,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU11,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU11,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU11,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU11,AllHabsSummaryData,30,FALSE) | =BB11+BD11 | =IF(BE11<0,BE11,"") | =VLOOKUP($AU11,AllHabsSummaryData,9,FALSE) |
| 12 | Wetland - Blanket bog | Wetland | =VLOOKUP($AU12,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU12,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU12,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU12,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU12,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU12,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU12,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU12,AllHabsSummaryData,30,FALSE) | =BB12+BD12 | =IF(BE12<0,BE12,"") | =VLOOKUP($AU12,AllHabsSummaryData,9,FALSE) |
| 13 | Wetland - Depressions on peat substrates (H7150) | Wetland | =VLOOKUP($AU13,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU13,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU13,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU13,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU13,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU13,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU13,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU13,AllHabsSummaryData,30,FALSE) | =BB13+BD13 | =IF(BE13<0,BE13,"") | =VLOOKUP($AU13,AllHabsSummaryData,9,FALSE) |
| 14 | Wetland - Fens (upland and lowland) | Wetland | =VLOOKUP($AU14,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU14,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU14,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU14,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU14,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU14,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU14,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU14,AllHabsSummaryData,30,FALSE) | =BB14+BD14 | =IF(BE14<0,BE14,"") | =VLOOKUP($AU14,AllHabsSummaryData,9,FALSE) |
| 15 | Wetland - Lowland raised bog | Wetland | =VLOOKUP($AU15,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU15,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU15,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU15,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU15,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU15,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU15,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU15,AllHabsSummaryData,30,FALSE) | =BB15+BD15 | =IF(BE15<0,BE15,"") | =VLOOKUP($AU15,AllHabsSummaryData,9,FALSE) |
| 16 | Wetland - Oceanic valley mire[1] (D2.1) | Wetland | =VLOOKUP($AU16,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU16,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU16,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU16,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU16,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU16,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU16,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU16,AllHabsSummaryData,30,FALSE) | =BB16+BD16 | =IF(BE16<0,BE16,"") | =VLOOKUP($AU16,AllHabsSummaryData,9,FALSE) |
| 17 | Wetland - Purple moor grass and rush pastures | Wetland | =VLOOKUP($AU17,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU17,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU17,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU17,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU17,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU17,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU17,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU17,AllHabsSummaryData,30,FALSE) | =BB17+BD17 | =IF(BE17<0,BE17,"") | =VLOOKUP($AU17,AllHabsSummaryData,9,FALSE) |
| 18 | Wetland - Transition mires and quaking bogs (H7140) | Wetland | =VLOOKUP($AU18,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU18,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU18,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU18,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU18,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU18,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU18,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU18,AllHabsSummaryData,30,FALSE) | =BB18+BD18 | =IF(BE18<0,BE18,"") | =VLOOKUP($AU18,AllHabsSummaryData,9,FALSE) |
| 19 | Woodland and forest - Wood-pasture and parkland | Woodland and forest | =VLOOKUP($AU19,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU19,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU19,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU19,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU19,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU19,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU19,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU19,AllHabsSummaryData,30,FALSE) | =BB19+BD19 | =IF(BE19<0,BE19,"") | =VLOOKUP($AU19,AllHabsSummaryData,9,FALSE) |
| 20 | Rocky shore - High energy littoral rock - on peat, clay or chalk | Rocky shore | =VLOOKUP($AU20,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU20,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU20,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU20,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU20,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU20,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU20,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU20,AllHabsSummaryData,30,FALSE) | =BB20+BD20 | =IF(BE20,BE20,"") | =VLOOKUP($AU20,AllHabsSummaryData,9,FALSE) |
| 21 | Rocky shore - Moderate energy littoral rock - on peat, clay or chalk | Rocky shore | =VLOOKUP($AU21,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU21,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU21,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU21,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU21,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU21,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU21,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU21,AllHabsSummaryData,30,FALSE) | =BB21+BD21 | =IF(BE21<0,BE21,"") | =VLOOKUP($AU21,AllHabsSummaryData,9,FALSE) |
| 22 | Rocky shore - Low energy littoral rock - on peat, clay or chalk | Rocky shore | =VLOOKUP($AU22,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU22,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU22,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU22,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU22,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU22,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU22,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU22,AllHabsSummaryData,30,FALSE) | =BB22+BD22 | =IF(BE22<0,BE22,"") | =VLOOKUP($AU22,AllHabsSummaryData,9,FALSE) |
| 23 | Rocky shore - Features of littoral rock - on peat, clay or chalk | Rocky shore | =VLOOKUP($AU23,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU23,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU23,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU23,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU23,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU23,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU23,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU23,AllHabsSummaryData,30,FALSE) | =BB23+BD23 | =IF(BE23<0,BE23,"") | =VLOOKUP($AU23,AllHabsSummaryData,9,FALSE) |
| 24 | Intertidal sediment - Littoral seagrass on peat, clay or chalk | Intertidal sediment | =VLOOKUP($AU24,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU24,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU24,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU24,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU24,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU24,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU24,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU24,AllHabsSummaryData,30,FALSE) | =BB24+BD24 | =IF(BE24<0,BE24,"") | =VLOOKUP($AU24,AllHabsSummaryData,9,FALSE) |