|
Index |
AJ Off-site habitat group |
AK Existing area |
AL Existing value |
AM Proposed area off-site |
AN Proposed value off-site |
AO Off-site area change |
AP Off-site unit change |
|---|---|---|---|---|---|---|---|
| 21 | Cropland | =SUMIF($B:$B,$AJ21,S:S) | =SUMIF($B:$B,$AJ21,T:T) | =SUMIF($B:$B,$AJ21,AA:AA) | =SUMIF($B:$B,$AJ21,AB:AB) | =SUMIF($B:$B,$AJ21,AC:AC) | =SUMIF($B:$B,$AJ21,AD:AD) |
| 22 | Grassland | =SUMIF($B:$B,$AJ22,S:S) | =SUMIF($B:$B,$AJ22,T:T) | =SUMIF($B:$B,$AJ22,AA:AA) | =SUMIF($B:$B,$AJ22,AB:AB) | =SUMIF($B:$B,$AJ22,AC:AC) | =SUMIF($B:$B,$AJ22,AD:AD) |
| 23 | Heathland and shrub | =SUMIF($B:$B,$AJ23,S:S) | =SUMIF($B:$B,$AJ23,T:T) | =SUMIF($B:$B,$AJ23,AA:AA) | =SUMIF($B:$B,$AJ23,AB:AB) | =SUMIF($B:$B,$AJ23,AC:AC) | =SUMIF($B:$B,$AJ23,AD:AD) |
| 24 | Lakes | =SUMIF($B:$B,$AJ24,S:S) | =SUMIF($B:$B,$AJ24,T:T) | =SUMIF($B:$B,$AJ24,AA:AA) | =SUMIF($B:$B,$AJ24,AB:AB) | =SUMIF($B:$B,$AJ24,AC:AC) | =SUMIF($B:$B,$AJ24,AD:AD) |
| 25 | Sparsely vegetated land | =SUMIF($B:$B,$AJ25,S:S) | =SUMIF($B:$B,$AJ25,T:T) | =SUMIF($B:$B,$AJ25,AA:AA) | =SUMIF($B:$B,$AJ25,AB:AB) | =SUMIF($B:$B,$AJ25,AC:AC) | =SUMIF($B:$B,$AJ25,AD:AD) |
| 26 | Urban | =SUMIF($B:$B,$AJ26,S:S) | =SUMIF($B:$B,$AJ26,T:T) | =SUMIF($B:$B,$AJ26,AA:AA) | =SUMIF($B:$B,$AJ26,AB:AB) | =SUMIF($B:$B,$AJ26,AC:AC) | =SUMIF($B:$B,$AJ26,AD:AD) |
| 27 | Wetland | =SUMIF($B:$B,$AJ27,S:S) | =SUMIF($B:$B,$AJ27,T:T) | =SUMIF($B:$B,$AJ27,AA:AA) | =SUMIF($B:$B,$AJ27,AB:AB) | =SUMIF($B:$B,$AJ27,AC:AC) | =SUMIF($B:$B,$AJ27,AD:AD) |
| 28 | Woodland and forest | =SUMIF($B:$B,$AJ28,S:S) | =SUMIF($B:$B,$AJ28,T:T) | =SUMIF($B:$B,$AJ28,AA:AA) | =SUMIF($B:$B,$AJ28,AB:AB) | =SUMIF($B:$B,$AJ28,AC:AC) | =SUMIF($B:$B,$AJ28,AD:AD) |
| 29 | Intertidal sediment | =SUMIF($B:$B,$AJ29,S:S) | =SUMIF($B:$B,$AJ29,T:T) | =SUMIF($B:$B,$AJ29,AA:AA) | =SUMIF($B:$B,$AJ29,AB:AB) | =SUMIF($B:$B,$AJ29,AC:AC) | =SUMIF($B:$B,$AJ29,AD:AD) |
| 30 | Coastal saltmarsh | =SUMIF($B:$B,$AJ30,S:S) | =SUMIF($B:$B,$AJ30,T:T) | =SUMIF($B:$B,$AJ30,AA:AA) | =SUMIF($B:$B,$AJ30,AB:AB) | =SUMIF($B:$B,$AJ30,AC:AC) | =SUMIF($B:$B,$AJ30,AD:AD) |
| 31 | Rocky shore | =SUMIF($B:$B,$AJ31,S:S) | =SUMIF($B:$B,$AJ31,T:T) | =SUMIF($B:$B,$AJ31,AA:AA) | =SUMIF($B:$B,$AJ31,AB:AB) | =SUMIF($B:$B,$AJ31,AC:AC) | =SUMIF($B:$B,$AJ31,AD:AD) |
| 32 | Coastal lagoons | =SUMIF($B:$B,$AJ32,S:S) | =SUMIF($B:$B,$AJ32,T:T) | =SUMIF($B:$B,$AJ32,AA:AA) | =SUMIF($B:$B,$AJ32,AB:AB) | =SUMIF($B:$B,$AJ32,AC:AC) | =SUMIF($B:$B,$AJ32,AD:AD) |
| 33 | Intertidal hard structures | =SUMIF($B:$B,$AJ33,S:S) | =SUMIF($B:$B,$AJ33,T:T) | =SUMIF($B:$B,$AJ33,AA:AA) | =SUMIF($B:$B,$AJ33,AB:AB) | =SUMIF($B:$B,$AJ33,AC:AC) | =SUMIF($B:$B,$AJ33,AD:AD) |
| 34 | Individual trees | =SUMIF($B:$B,$AJ34,S:S) | =SUMIF($B:$B,$AJ34,T:T) | =SUMIF($B:$B,$AJ34,AA:AA) | =SUMIF($B:$B,$AJ34,AB:AB) | =SUMIF($B:$B,$AJ34,AC:AC) | =SUMIF($B:$B,$AJ34,AD:AD) |
| 35 | Watercourse footprint | =SUMIF($B:$B,$AJ35,S:S) | =SUMIF($B:$B,$AJ35,T:T) | =SUMIF($B:$B,$AJ35,AA:AA) | =SUMIF($B:$B,$AJ35,AB:AB) | =SUMIF($B:$B,$AJ35,AC:AC) | =SUMIF($B:$B,$AJ35,AD:AD) |