|
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 113 | Cropland - Cereal crops | Cropland | =VLOOKUP($AU113,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU113,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU113,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU113,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU113,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU113,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU113,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU113,AllHabsSummaryData,30,FALSE) | =BB113+BD113 | =IF(BE113<0,BE113,"") |
| 114 | Cropland - Horticulture | Cropland | =VLOOKUP($AU114,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU114,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU114,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU114,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU114,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU114,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU114,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU114,AllHabsSummaryData,30,FALSE) | =BB114+BD114 | =IF(BE114<0,BE114,"") |
| 115 | Cropland - Intensive orchards | Cropland | =VLOOKUP($AU115,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU115,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU115,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU115,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU115,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU115,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU115,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU115,AllHabsSummaryData,30,FALSE) | =BB115+BD115 | =IF(BE115<0,BE115,"") |
| 116 | Cropland - Non-cereal crops | Cropland | =VLOOKUP($AU116,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU116,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU116,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU116,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU116,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU116,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU116,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU116,AllHabsSummaryData,30,FALSE) | =BB116+BD116 | =IF(BE116<0,BE116,"") |
| 117 | Cropland - Temporary grass and clover leys | Cropland | =VLOOKUP($AU117,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU117,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU117,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU117,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU117,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU117,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU117,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU117,AllHabsSummaryData,30,FALSE) | =BB117+BD117 | =IF(BE117<0,BE117,"") |
| 118 | Cropland - Winter stubble | Cropland | =VLOOKUP($AU118,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU118,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU118,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU118,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU118,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU118,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU118,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU118,AllHabsSummaryData,30,FALSE) | =BB118+BD118 | =IF(BE118<0,BE118,"") |
| 119 | Grassland - Modified grassland | Grassland | =VLOOKUP($AU119,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU119,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU119,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU119,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU119,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU119,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU119,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU119,AllHabsSummaryData,30,FALSE) | =BB119+BD119 | =IF(BE119<0,BE119,"") |
| 120 | Grassland - Bracken | Grassland | =VLOOKUP($AU120,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU120,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU120,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU120,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU120,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU120,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU120,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU120,AllHabsSummaryData,30,FALSE) | =BB120+BD120 | =IF(BE120,BE120,"") |
| 121 | Heathland and shrub - Rhododendron scrub | Heathland and shrub | =VLOOKUP($AU121,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU121,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU121,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU121,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU121,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU121,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU121,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU121,AllHabsSummaryData,30,FALSE) | =BB121+BD121 | =IF(BE121<0,BE121,"") |
| 122 | Lakes - Ornamental lake or pond | Lakes | =VLOOKUP($AU123,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU122,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU122,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU122,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU122,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU122,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU122,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU122,AllHabsSummaryData,30,FALSE) | =BB122+BD122 | =IF(BE122<0,BE122,"") |
| 123 | Sparsely vegetated land - Ruderal/ephemeral | Sparsely vegetated land | =VLOOKUP($AU124,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU123,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU123,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU123,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU123,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU123,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU123,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU123,AllHabsSummaryData,30,FALSE) | =BB123+BD123 | =IF(BE123<0,BE123,"") |
| 124 | Urban - Bioswale | Urban | =VLOOKUP($AU124,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU124,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU124,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU124,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU124,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU124,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU124,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU124,AllHabsSummaryData,30,FALSE) | =BB124+BD124 | =IF(BE124<0,BE124,"") |
| 125 | Urban - Allotments | Urban | =VLOOKUP($AU125,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU125,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU125,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU125,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU125,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU125,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU125,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU125,AllHabsSummaryData,30,FALSE) | =BB125+BD125 | =IF(BE125<0,BE125,"") |
| 126 | Urban - Facade-bound green wall | Urban | =VLOOKUP($AU126,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU126,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU126,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU126,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU126,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU126,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU126,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU126,AllHabsSummaryData,30,FALSE) | =BB126+BD126 | =IF(BE126<0,BE126,"") |
| 127 | Urban - Ground based green wall | Urban | =VLOOKUP($AU127,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU127,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU127,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU127,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU127,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU127,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU127,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU127,AllHabsSummaryData,30,FALSE) | =BB127+BD127 | =IF(BE127<0,BE127,"") |
| 128 | Urban - Ground level planters | Urban | =VLOOKUP($AU128,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU128,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU128,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU128,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU128,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU128,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU128,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU128,AllHabsSummaryData,30,FALSE) | =BB128+BD128 | =IF(BE128<0,BE128,"") |
| 129 | Urban - Other green roof | Urban | =VLOOKUP($AU129,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU129,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU129,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU129,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU129,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU129,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU129,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU129,AllHabsSummaryData,30,FALSE) | =BB129+BD129 | =IF(BE129<0,BE129,"") |
| 130 | Urban - Introduced shrub | Urban | =VLOOKUP($AU130,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU130,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU130,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU130,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU130,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU130,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU130,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU130,AllHabsSummaryData,30,FALSE) | =BB130+BD130 | =IF(BE130,BE130,"") |
| 131 | Urban - Rain garden | Urban | =VLOOKUP($AU131,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU131,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU131,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU131,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU131,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU131,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU131,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU131,AllHabsSummaryData,30,FALSE) | =BB131+BD131 | =IF(BE131<0,BE131,"") |
| 132 | Urban - Actively worked sand pit quarry or open cast mine | Urban | =VLOOKUP($AU132,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU132,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU132,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU132,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU132,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU132,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU132,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU132,AllHabsSummaryData,30,FALSE) | =BB132+BD132 | =IF(BE132<0,BE132,"") |
| 133 | ||||||||||||
| 134 | Urban - Bare ground | Urban | =VLOOKUP($AU134,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU134,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU134,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU134,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU134,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU134,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU134,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU134,AllHabsSummaryData,30,FALSE) | =BB134+BD134 | =IF(BE134<0,BE134,"") |
| 135 | Urban - Sustainable drainage system | Urban | =VLOOKUP($AU135,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU135,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU135,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU135,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU135,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU135,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU135,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU135,AllHabsSummaryData,30,FALSE) | =BB135+BD135 | =IF(BE135<0,BE135,"") |
| 136 | Urban - Vacant or derelict land | Urban | =VLOOKUP($AU136,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU136,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU136,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU136,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU136,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU136,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU136,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU136,AllHabsSummaryData,30,FALSE) | =BB136+BD136 | =IF(BE136<0,BE136,"") |
| 137 | Urban - Vegetated garden | Urban | =VLOOKUP($AU137,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU137,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU137,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU137,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU137,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU137,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU137,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU137,AllHabsSummaryData,30,FALSE) | =BB137+BD137 | =IF(BE137<0,BE137,"") |
| 138 | Woodland and forest - Other coniferous woodland | Woodland and forest | =VLOOKUP($AU138,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU138,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU138,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU138,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU138,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU138,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU138,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU138,AllHabsSummaryData,30,FALSE) | =BB138+BD138 | =IF(BE138<0,BE138,"") |
| 139 | Coastal saltmarsh - Artificial saltmarshes and saline reedbeds | Coastal saltmarsh | =VLOOKUP($AU139,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU139,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU139,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU139,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU139,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU139,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU139,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU139,AllHabsSummaryData,30,FALSE) | =BB139+BD139 | =IF(BE139<0,BE139,"") |
| 140 | Intertidal sediment - Artificial littoral coarse sediment | Intertidal sediment | =VLOOKUP($AU140,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU140,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU140,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU140,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU140,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU140,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU140,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU140,AllHabsSummaryData,30,FALSE) | =BB140+BD140 | =IF(BE140,BE140,"") |
| 141 | Intertidal sediment - Artificial littoral mud | Intertidal sediment | =VLOOKUP($AU141,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU141,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU141,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU141,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU141,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU141,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU141,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU141,AllHabsSummaryData,30,FALSE) | =BB141+BD141 | =IF(BE141<0,BE141,"") |
| 142 | Intertidal sediment - Artificial littoral sand | Intertidal sediment | =VLOOKUP($AU142,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU142,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU142,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU142,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU142,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU142,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU142,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU142,AllHabsSummaryData,30,FALSE) | =BB142+BD142 | =IF(BE142<0,BE142,"") |
| 143 | Intertidal sediment - Artificial littoral muddy sand | Intertidal sediment | =VLOOKUP($AU143,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU143,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU143,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU143,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU143,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU143,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU143,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU143,AllHabsSummaryData,30,FALSE) | =BB143+BD143 | =IF(BE143<0,BE143,"") |
| 144 | Intertidal sediment - Artificial littoral mixed sediments | Intertidal sediment | =VLOOKUP($AU144,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU144,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU144,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU144,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU144,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU144,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU144,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU144,AllHabsSummaryData,30,FALSE) | =BB144+BD144 | =IF(BE144<0,BE144,"") |
| 145 | Intertidal sediment - Artificial littoral seagrass | Intertidal sediment | =VLOOKUP($AU145,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU145,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU145,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU145,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU145,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU145,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU145,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU145,AllHabsSummaryData,30,FALSE) | =BB145+BD145 | =IF(BE145<0,BE145,"") |
| 146 | Intertidal sediment - Artificial littoral biogenic reefs | Intertidal sediment | =VLOOKUP($AU146,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU146,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU146,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU146,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU146,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU146,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU146,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU146,AllHabsSummaryData,30,FALSE) | =BB146+BD146 | =IF(BE146<0,BE146,"") |
| 147 | Intertidal hard structures - Artificial hard structures | Intertidal hard structures | =VLOOKUP($AU147,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU147,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU147,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU147,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU147,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU147,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU147,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU147,AllHabsSummaryData,30,FALSE) | =BB147+BD147 | =IF(BE147<0,BE147,"") |
| 148 | Intertidal hard structures - Artificial features of hard structures | Intertidal hard structures | =VLOOKUP($AU148,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU148,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU148,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU148,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU148,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU148,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU148,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU148,AllHabsSummaryData,30,FALSE) | =BB148+BD148 | =IF(BE148<0,BE148,"") |
| 149 | Heathland and shrub - Other sea buckthorn scrub | Heathland and shrub | =VLOOKUP($AU149,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU149,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU149,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU149,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU149,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU149,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU149,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU149,AllHabsSummaryData,30,FALSE) | =BB149+BD149 | =IF(BE149<0,BE149,"") |
| 150 | Urban - Intensive green roof | Urban | =VLOOKUP($AU150,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU150,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU150,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU150,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU150,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU150,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU150,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU150,AllHabsSummaryData,30,FALSE) | =BB150+BD150 | =IF(BE150,BE150,"") |
| 151 | Sparsely vegetated land - Tall forbs | Sparsely vegetated land | =VLOOKUP($AU151,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU151,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU151,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU151,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU151,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU151,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU151,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU151,AllHabsSummaryData,30,FALSE) | =BB151+BD151 | =IF(BE151<0,BE151,"") |