|
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30 | Grassland - Traditional orchards | Grassland | =VLOOKUP($AU30,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU30,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU30,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU30,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU30,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU30,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU30,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU30,AllHabsSummaryData,30,FALSE) | =BB30+BD30 | =IF(BE30,BE30,"") |
| 31 | Grassland - Floodplain wetland mosaic and CFGM | Grassland | =VLOOKUP($AU31,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU31,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU31,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU31,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU31,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU31,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU31,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU31,AllHabsSummaryData,30,FALSE) | =BB31+BD31 | =IF(BE31<0,BE31,"") |
| 32 | Grassland - Lowland calcareous grassland | Grassland | =VLOOKUP($AU32,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU32,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU32,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU32,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU32,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU32,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU32,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU32,AllHabsSummaryData,30,FALSE) | =BB32+BD32 | =IF(BE32<0,BE32,"") |
| 33 | Grassland - Tall herb communities (H6430) | Grassland | =VLOOKUP($AU33,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU33,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU33,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU33,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU33,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU33,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU33,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU33,AllHabsSummaryData,30,FALSE) | =BB33+BD33 | =IF(BE33<0,BE33,"") |
| 34 | Grassland - Upland calcareous grassland | Grassland | =VLOOKUP($AU34,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU34,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU34,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU34,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU34,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU34,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU34,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU34,AllHabsSummaryData,30,FALSE) | =BB34+BD34 | =IF(BE34<0,BE34,"") |
| 35 | Heathland and shrub - Lowland Heathland | Heathland and shrub | =VLOOKUP($AU35,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU35,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU35,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU35,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU35,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU35,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU35,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU35,AllHabsSummaryData,30,FALSE) | =BB35+BD35 | =IF(BE35<0,BE35,"") |
| 36 | Heathland and shrub - Dunes with sea buckthorn (H2160) | Heathland and shrub | =VLOOKUP($AU36,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU36,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU36,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU36,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU36,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU36,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU36,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU36,AllHabsSummaryData,30,FALSE) | =BB36+BD36 | =IF(BE36<0,BE36,"") |
| 37 | Heathland and shrub - Upland heathland | Heathland and shrub | =VLOOKUP($AU37,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU37,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU37,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU37,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU37,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU37,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU37,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU37,AllHabsSummaryData,30,FALSE) | =BB37+BD37 | =IF(BE37<0,BE37,"") |
| 38 | ||||||||||||
| 39 | Lakes - High alkalinity lakes | Lakes | =VLOOKUP($AU39,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU39,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU39,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU39,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU39,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU39,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU39,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU39,AllHabsSummaryData,30,FALSE) | =BB39+BD39 | =IF(BE39<0,BE39,"") |
| 40 | Lakes - Low alkalinity lakes | Lakes | =VLOOKUP($AU40,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU40,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU40,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU40,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU40,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU40,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU40,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU40,AllHabsSummaryData,30,FALSE) | =BB40+BD40 | =IF(BE40,BE40,"") |
| 41 | Lakes - Marl lakes | Lakes | =VLOOKUP($AU41,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU41,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU41,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU41,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU41,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU41,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU41,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU41,AllHabsSummaryData,30,FALSE) | =BB41+BD41 | =IF(BE41<0,BE41,"") |
| 42 | Lakes - Moderate alkalinity lakes | Lakes | =VLOOKUP($AU42,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU42,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU42,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU42,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU42,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU42,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU42,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU42,AllHabsSummaryData,30,FALSE) | =BB42+BD42 | =IF(BE42<0,BE42,"") |
| 43 | Lakes - Peat lakes | Lakes | =VLOOKUP($AU43,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU43,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU43,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU43,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU43,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU43,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU43,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU43,AllHabsSummaryData,30,FALSE) | =BB43+BD43 | =IF(BE43<0,BE43,"") |
| 44 | Lakes - Ponds (priority habitat) | Lakes | =VLOOKUP($AU44,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU44,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU44,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU44,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU44,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU44,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU44,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU44,AllHabsSummaryData,30,FALSE) | =BB44+BD44 | =IF(BE44<0,BE44,"") |
| 45 | Lakes - Temporary lakes ponds and pools (H3170) | Lakes | =VLOOKUP($AU45,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU45,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU45,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU45,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU45,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU45,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU45,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU45,AllHabsSummaryData,30,FALSE) | =BB45+BD45 | =IF(BE45<0,BE45,"") |
| 46 | Sparsely vegetated land - Coastal sand dunes | Sparsely vegetated land | =VLOOKUP($AU46,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU46,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU46,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU46,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU46,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU46,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU46,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU46,AllHabsSummaryData,30,FALSE) | =BB46+BD46 | =IF(BE46<0,BE46,"") |
| 47 | Sparsely vegetated land - Coastal vegetated shingle | Sparsely vegetated land | =VLOOKUP($AU47,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU47,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU47,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU47,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU47,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU47,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU47,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU47,AllHabsSummaryData,30,FALSE) | =BB47+BD47 | =IF(BE47<0,BE47,"") |
| 48 | Sparsely vegetated land - Inland rock outcrop and scree habitats | Sparsely vegetated land | =VLOOKUP($AU48,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU48,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU48,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU48,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU48,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU48,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU48,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU48,AllHabsSummaryData,30,FALSE) | =BB48+BD48 | =IF(BE48<0,BE48,"") |
| 49 | Sparsely vegetated land - Maritime cliff and slopes | Sparsely vegetated land | =VLOOKUP($AU49,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU49,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU49,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU49,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU49,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU49,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU49,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU49,AllHabsSummaryData,30,FALSE) | =BB49+BD49 | =IF(BE49<0,BE49,"") |
| 50 | Urban - Open mosaic habitats on previously developed land | Urban | =VLOOKUP($AU50,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU50,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU50,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU50,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU50,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU50,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU50,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU50,AllHabsSummaryData,30,FALSE) | =BB50+BD50 | =IF(BE50,BE50,"") |
| 51 | Wetland - Reedbeds | Wetland | =VLOOKUP($AU51,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU51,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU51,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU51,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU51,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU51,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU51,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU51,AllHabsSummaryData,30,FALSE) | =BB51+BD51 | =IF(BE51<0,BE51,"") |
| 52 | Woodland and forest - Felled | Woodland and forest | =VLOOKUP($AU52,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU52,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU52,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU52,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU52,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU52,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU52,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU52,AllHabsSummaryData,30,FALSE) | =BB52+BD52 | =IF(BE52<0,BE52,"") |
| 53 | Woodland and forest - Lowland beech and yew woodland | Woodland and forest | =VLOOKUP($AU53,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU53,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU53,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU53,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU53,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU53,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU53,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU53,AllHabsSummaryData,30,FALSE) | =BB53+BD53 | =IF(BE53<0,BE53,"") |
| 54 | Woodland and forest - Lowland mixed deciduous woodland | Woodland and forest | =VLOOKUP($AU54,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU54,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU54,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU54,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU54,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU54,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU54,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU54,AllHabsSummaryData,30,FALSE) | =BB54+BD54 | =IF(BE54<0,BE54,"") |
| 55 | ||||||||||||
| 56 | Woodland and forest - Native pine woodlands | Woodland and forest | =VLOOKUP($AU56,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU56,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU56,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU56,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU56,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU56,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU56,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU56,AllHabsSummaryData,30,FALSE) | =BB56+BD56 | =IF(BE56<0,BE56,"") |
| 57 | Woodland and forest - Upland birchwoods | Woodland and forest | =VLOOKUP($AU57,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU57,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU57,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU57,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU57,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU57,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU57,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU57,AllHabsSummaryData,30,FALSE) | =BB57+BD57 | =IF(BE57<0,BE57,"") |
| 58 | Woodland and forest - Upland mixed ashwoods | Woodland and forest | =VLOOKUP($AU58,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU58,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU58,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU58,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU58,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU58,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU58,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU58,AllHabsSummaryData,30,FALSE) | =BB58+BD58 | =IF(BE58<0,BE58,"") |
| 59 | Woodland and forest - Upland oakwood | Woodland and forest | =VLOOKUP($AU59,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU59,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU59,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU59,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU59,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU59,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU59,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU59,AllHabsSummaryData,30,FALSE) | =BB59+BD59 | =IF(BE59<0,BE59,"") |
| 60 | Woodland and forest - Wet woodland | Woodland and forest | =VLOOKUP($AU60,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU60,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU60,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU60,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU60,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU60,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU60,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU60,AllHabsSummaryData,30,FALSE) | =BB60+BD60 | =IF(BE60,BE60,"") |
| 61 | Coastal lagoons - Coastal lagoons | Coastal lagoons | =VLOOKUP($AU61,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU61,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU61,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU61,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU61,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU61,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU61,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU61,AllHabsSummaryData,30,FALSE) | =BB61+BD61 | =IF(BE61<0,BE61,"") |
| 62 | Rocky shore - High energy littoral rock | Rocky shore | =VLOOKUP($AU62,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU62,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU62,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU62,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU62,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU62,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU62,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU62,AllHabsSummaryData,30,FALSE) | =BB62+BD62 | =IF(BE62<0,BE62,"") |
| 63 | Rocky shore - Moderate energy littoral rock | Rocky shore | =VLOOKUP($AU63,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU63,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU63,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU63,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU63,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU63,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU63,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU63,AllHabsSummaryData,30,FALSE) | =BB63+BD63 | =IF(BE63<0,BE63,"") |
| 64 | Rocky shore - Low energy littoral rock | Rocky shore | =VLOOKUP($AU64,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU64,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU64,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU64,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU64,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU64,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU64,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU64,AllHabsSummaryData,30,FALSE) | =BB64+BD64 | =IF(BE64<0,BE64,"") |
| 65 | Rocky shore - Features of littoral rock | Rocky shore | =VLOOKUP($AU65,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU65,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU65,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU65,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU65,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU65,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU65,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU65,AllHabsSummaryData,30,FALSE) | =BB65+BD65 | =IF(BE65<0,BE65,"") |
| 66 | Intertidal sediment - Littoral mud | Intertidal sediment | =VLOOKUP($AU66,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU66,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU66,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU66,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU66,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU66,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU66,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU66,AllHabsSummaryData,30,FALSE) | =BB66+BD66 | =IF(BE66<0,BE66,"") |
| 67 | Intertidal sediment - Littoral mixed sediments | Intertidal sediment | =VLOOKUP($AU67,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU67,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU67,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU67,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU67,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU67,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU67,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU67,AllHabsSummaryData,30,FALSE) | =BB67+BD67 | =IF(BE67<0,BE67,"") |
| 68 | Coastal saltmarsh - Saltmarshes and saline reedbeds | Coastal saltmarsh | =VLOOKUP($AU68,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU68,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU68,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU68,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU68,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU68,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU68,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU68,AllHabsSummaryData,30,FALSE) | =BB68+BD68 | =IF(BE68<0,BE68,"") |
| 69 | Intertidal sediment - Littoral biogenic reefs - Mussels | Intertidal sediment | =VLOOKUP($AU69,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU69,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU69,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU69,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU69,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU69,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU69,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU69,AllHabsSummaryData,30,FALSE) | =BB69+BD69 | =IF(BE69<0,BE69,"") |
| 70 | Intertidal sediment - Littoral biogenic reefs - Sabellaria | Intertidal sediment | =VLOOKUP($AU70,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU70,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU70,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU70,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU70,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU70,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU70,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU70,AllHabsSummaryData,30,FALSE) | =BB70+BD70 | =IF(BE70,BE70,"") |
| 71 | Intertidal sediment - Features of littoral sediment | Intertidal sediment | =VLOOKUP($AU71,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU71,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU71,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU71,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU71,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU71,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU71,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU71,AllHabsSummaryData,30,FALSE) | =BB71+BD71 | =IF(BE71<0,BE71,"") |
| 72 | Intertidal sediment - Littoral muddy sand | Intertidal sediment | =VLOOKUP($AU72,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU72,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU72,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU72,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU72,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU72,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU72,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU72,AllHabsSummaryData,30,FALSE) | =BB72+BD72 | =IF(BE72<0,BE72,"") |
| 73 | Intertidal sediment - Littoral seagrass | Intertidal sediment | =VLOOKUP($AU73,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU73,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU73,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU73,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU73,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU73,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU73,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU73,AllHabsSummaryData,30,FALSE) | =BB73+BD73 | =IF(BE73<0,BE73,"") |