|
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 156 | Urban - Artificial unvegetated, unsealed surface | Urban | =VLOOKUP($AU156,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU156,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU156,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU156,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU156,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU156,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU156,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU156,AllHabsSummaryData,30,FALSE) | =BB156+BD156 | =IF(BE156<0,BE156,"") |
| 157 | Urban - Built linear features | Urban | =VLOOKUP($AU157,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU157,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU157,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU157,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU157,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU157,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU157,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU157,AllHabsSummaryData,30,FALSE) | =BB157+BD157 | =IF(BE157<0,BE157,"") |
| 158 | Urban - Developed land; sealed surface | Urban | =VLOOKUP($AU158,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU158,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU158,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU158,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU158,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU158,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU158,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU158,AllHabsSummaryData,30,FALSE) | =BB158+BD158 | =IF(BE158<0,BE158,"") |
| 159 | Urban - Unvegetated garden | Urban | =VLOOKUP($AU159,AllHabsSummaryData,5,FALSE) | =VLOOKUP($AU159,AllHabsSummaryData,10,FALSE) | =VLOOKUP($AU159,AllHabsSummaryData,15,FALSE) | =VLOOKUP($AU159,AllHabsSummaryData,16,FALSE) | =VLOOKUP($AU159,AllHabsSummaryData,17,FALSE) | =VLOOKUP($AU159,AllHabsSummaryData,18,FALSE) | =VLOOKUP($AU159,AllHabsSummaryData,27,FALSE) | =VLOOKUP($AU159,AllHabsSummaryData,30,FALSE) | =BB159+BD159 | =IF(BE159<0,BE159,"") |