| On-off-site |
|
On-site
|
|
| Habitat |
|
Lowland dry acid grassland
|
|
| Broad Habitat |
|
Grassland
|
🛈
table("Habitat")[Habitat=$self/Habitat]/Broad_Habitat
|
| Distinctiveness Category |
|
V.High
|
🛈
table("Habitat")[Habitat=$self/Habitat]/Distinctiveness_Category
|
| Distinctiveness Score |
|
8
|
🛈
table("Habitat")[Habitat=$self/Habitat]/Distinctiveness_Score
|
| Existing area conditional |
|
0
|
🛈
if($self/Distinctiveness_Category='V.High')
then sum(table('Habitat_Baseline')[On-off-site= $self/On-off-site][Habitat = $self/Habitat]/Area_retained )
+ sum(table('Habitat_Baseline')[On-off-site= $self/On-off-site][Habitat = $self/Habitat]/Area_enhanced)
else sum(table('Habitat_Baseline')[On-off-site= $self/On-off-site][Habitat = $self/Habitat]/Area)
|
| Existing area |
|
0
|
🛈
sum(table('Habitat_Baseline')[On-off-site= $self/On-off-site][Habitat = $self/Habitat]/Area)
|
| Existing units |
|
0
|
🛈
sum(table('Habitat_Baseline')[On-off-site= $self/On-off-site ][ Habitat = $self/Habitat]/Total_habitat_units)
|
| Existing area retained |
|
0
|
🛈
sum(table('Habitat_Baseline')[On-off-site= $self/On-off-site ][ Habitat = $self/Habitat]/Area_retained)
|
| Existing units retained |
|
0
|
🛈
sum(table('Habitat_Baseline')[On-off-site= $self/On-off-site ][ Habitat = $self/Habitat]/Baseline_units_retained)
|
| Existing area enhanced |
|
0
|
🛈
sum(table('Habitat_Baseline')[On-off-site= $self/On-off-site ][ Habitat = $self/Habitat]/Area_enhanced)
|
| Existing units enhanced |
|
0
|
🛈
sum(table('Habitat_Baseline')[On-off-site= $self/On-off-site][ Habitat = $self/Habitat]/Baseline_units_enhanced)
|
| Existing area lost |
|
0
|
🛈
sum(table('Habitat_Baseline')[On-off-site= $self/On-off-site ][ Habitat = $self/Habitat]/Area_lost)
|
| Existing units lost |
|
0
|
🛈
sum(table('Habitat_Baseline')[On-off-site= $self/On-off-site ][ Habitat = $self/Habitat]/Units_lost)
|
| Proposed area creation |
|
0
|
🛈
sum(table('Habitat_Creation')[On-off-site= $self/On-off-site ][ Habitat = $self/Habitat]/Area)
|
| Proposed units creation |
|
0
|
🛈
sum(table('Habitat_Creation')[On-off-site= $self/On-off-site ][ Habitat = $self/Habitat]/Habitat_units_delivered)
|
| Proposed area enhancement |
|
0
|
🛈
sum(table('Habitat_Enhancement')[On-off-site= $self/On-off-site ][ Proposed_Habitat = $self/Habitat]/Area)
|
| Proposed units enhancement |
|
0
|
🛈
sum(table('Habitat_Enhancement')[On-off-site= $self/On-off-site ][ Proposed_Habitat = $self/Habitat]/Habitat_units_delivered)
|
| Total proposed area |
|
0
|
🛈
$self/Existing_area_retained +
$self/Proposed_area_creation +
$self/Proposed_area_enhancement
|
| Total proposed units |
|
0
|
🛈
$self/Existing_units_retained +
$self/Proposed_units_creation +
$self/Proposed_units_enhancement
|
| Net area change |
|
0
|
🛈
$self/Total_proposed_area - $self/Existing_area
|
| Net units change |
|
0
|
🛈
$self/Total_proposed_units - $self/Existing_units
|