|
Index |
A Watercourse type |
B Group |
C Distinctiveness |
D Trading Notes |
E Existing length baseline on-site |
F Existing units baseline on-site |
G Existing length retained on-site |
H Existing Units retained on-site |
I Existing length lost on-site |
J Existing units lost baseline on-site |
K Proposed length creation on-site post development |
L Proposed units creation on-site post development |
M Proposed length enhancement on-site post development |
N Proposed units enhancement on-site post development |
O Total proposed length on-site post development |
P Total proposed units on-site post development |
Q Net length change on-site |
R Net unit change on-site |
S Existing length off-site |
T Existing units off-site |
U Retained length off-site |
V Retained units off-site |
W Proposed length creation off-site |
X Proposed units creation off-site |
Y Proposed length enhancement off-site |
Z Proposed units Enhancement off-site |
AA Total proposed length off-site |
AB Total proposed units off-site |
AC Off-site net length change |
AD Off-site net unit change |
AE Overall length change |
AF Overall unit change |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 172 | ='G-7 WaterC' Data'!B4 | Watercourses | ='G-7 WaterC' Data'!C4 | ='G-7 WaterC' Data'!AU4 | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A172,'C-1 On-Site WaterC' Baseline'!$E$10:$E$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A172,'C-1 On-Site WaterC' Baseline'!$R$10:$R$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A172,'C-1 On-Site WaterC' Baseline'!$U$10:$U$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A172,'C-1 On-Site WaterC' Baseline'!$W$10:$W$257)+SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A172,'C-1 On-Site WaterC' Baseline'!$AT$10:$AT$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A172,'C-1 On-Site WaterC' Baseline'!$Y$10:$Y$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A172,'C-1 On-Site WaterC' Baseline'!$Z$10:$Z$257) | =SUMIF('C-2 On-Site WaterC' Creation'!$C$10:$C$257,'G-2 Habitat groups'!A172,'C-2 On-Site WaterC' Creation'!$D$10:$D$257) | =SUMIF('C-2 On-Site WaterC' Creation'!$C$10:$C$257,'G-2 Habitat groups'!A172,'C-2 On-Site WaterC' Creation'!$Z$10:$Z$257) | =SUMIF('C-3 On-Site WaterC' Enhancement'!$N$12:$N$257,'G-2 Habitat groups'!A172,'C-3 On-Site WaterC' Enhancement'!$Q$12:$Q$257) | =SUMIF('C-3 On-Site WaterC' Enhancement'!$N$12:$N$257,'G-2 Habitat groups'!A172,'C-3 On-Site WaterC' Enhancement'!$AM$12:$AM$257) | =G172+K172+M172 | =H172+L172+N172 | =O172-E172 | =P172-F172 | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A172,'F-1 Off-Site WaterC' Baseline'!$E$10:$E$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A172,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A172,'F-1 Off-Site WaterC' Baseline'!$X$10:$X$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A172,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)+SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A172,'F-1 Off-Site WaterC' Baseline'!$AT$10:$AT$257) | =SUMIF('F-2 Off-Site WaterC' Creation'!$C$12:$C$259,'G-2 Habitat groups'!A172,'F-2 Off-Site WaterC' Creation'!$D$12:$D$259) | =SUMIF('F-2 Off-Site WaterC' Creation'!$C$12:$C$259,'G-2 Habitat groups'!A172,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259) | =SUMIF('F-3 Off-Site WaterC Enhancement'!$N$12:$N$259,'G-2 Habitat groups'!A172,'F-3 Off-Site WaterC Enhancement'!$Q$12:$Q$259) | =SUMIF('F-3 Off-Site WaterC Enhancement'!$N$12:$N$259,'G-2 Habitat groups'!A172,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$259) | =U172+W172+Y172 | =V172+X172+Z172 | =AA172-S172 | =AB172-T172 | =Q172+AC172 | =R172+AD172 |
| 173 | ='G-7 WaterC' Data'!B5 | Watercourses | ='G-7 WaterC' Data'!C5 | ='G-7 WaterC' Data'!AU5 | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A173,'C-1 On-Site WaterC' Baseline'!$E$10:$E$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A173,'C-1 On-Site WaterC' Baseline'!$R$10:$R$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A173,'C-1 On-Site WaterC' Baseline'!$U$10:$U$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A173,'C-1 On-Site WaterC' Baseline'!$W$10:$W$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A173,'C-1 On-Site WaterC' Baseline'!$Y$10:$Y$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A173,'C-1 On-Site WaterC' Baseline'!$Z$10:$Z$257) | =SUMIF('C-2 On-Site WaterC' Creation'!$C$10:$C$257,'G-2 Habitat groups'!A173,'C-2 On-Site WaterC' Creation'!$D$10:$D$257) | =SUMIF('C-2 On-Site WaterC' Creation'!$C$10:$C$257,'G-2 Habitat groups'!A173,'C-2 On-Site WaterC' Creation'!$Z$10:$Z$257) | =SUMIF('C-3 On-Site WaterC' Enhancement'!$N$12:$N$257,'G-2 Habitat groups'!A173,'C-3 On-Site WaterC' Enhancement'!$Q$12:$Q$257) | =SUMIF('C-3 On-Site WaterC' Enhancement'!$N$12:$N$257,'G-2 Habitat groups'!A173,'C-3 On-Site WaterC' Enhancement'!$AM$12:$AM$257) | =G173+K173+M173 | =H173+L173+N173 | =O173-E173 | =P173-F173 | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A173,'F-1 Off-Site WaterC' Baseline'!$E$10:$E$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A173,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A173,'F-1 Off-Site WaterC' Baseline'!$X$10:$X$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A173,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257) | =SUMIF('F-2 Off-Site WaterC' Creation'!$C$12:$C$259,'G-2 Habitat groups'!A173,'F-2 Off-Site WaterC' Creation'!$D$12:$D$259) | =SUMIF('F-2 Off-Site WaterC' Creation'!$C$12:$C$259,'G-2 Habitat groups'!A173,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259) | =SUMIF('F-3 Off-Site WaterC Enhancement'!$N$12:$N$259,'G-2 Habitat groups'!A173,'F-3 Off-Site WaterC Enhancement'!$Q$12:$Q$259) | =SUMIF('F-3 Off-Site WaterC Enhancement'!$N$12:$N$259,'G-2 Habitat groups'!A173,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$259) | =U173+W173+Y173 | =V173+X173+Z173 | =AA173-S173 | =AB173-T173 | =Q173+AC173 | =R173+AD173 |
| 174 | ='G-7 WaterC' Data'!B6 | Watercourses | ='G-7 WaterC' Data'!C6 | ='G-7 WaterC' Data'!AU6 | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A174,'C-1 On-Site WaterC' Baseline'!$E$10:$E$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A174,'C-1 On-Site WaterC' Baseline'!$R$10:$R$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A174,'C-1 On-Site WaterC' Baseline'!$U$10:$U$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A174,'C-1 On-Site WaterC' Baseline'!$W$10:$W$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A174,'C-1 On-Site WaterC' Baseline'!$Y$10:$Y$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A174,'C-1 On-Site WaterC' Baseline'!$Z$10:$Z$257) | =SUMIF('C-2 On-Site WaterC' Creation'!$C$10:$C$257,'G-2 Habitat groups'!A174,'C-2 On-Site WaterC' Creation'!$D$10:$D$257) | =SUMIF('C-2 On-Site WaterC' Creation'!$C$10:$C$257,'G-2 Habitat groups'!A174,'C-2 On-Site WaterC' Creation'!$Z$10:$Z$257) | =SUMIF('C-3 On-Site WaterC' Enhancement'!$N$12:$N$257,'G-2 Habitat groups'!A174,'C-3 On-Site WaterC' Enhancement'!$Q$12:$Q$257) | =SUMIF('C-3 On-Site WaterC' Enhancement'!$N$12:$N$257,'G-2 Habitat groups'!A174,'C-3 On-Site WaterC' Enhancement'!$AM$12:$AM$257) | =G174+K174+M174 | =H174+L174+N174 | =O174-E174 | =P174-F174 | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A174,'F-1 Off-Site WaterC' Baseline'!$E$10:$E$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A174,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A174,'F-1 Off-Site WaterC' Baseline'!$X$10:$X$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A174,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257) | =SUMIF('F-2 Off-Site WaterC' Creation'!$C$12:$C$259,'G-2 Habitat groups'!A174,'F-2 Off-Site WaterC' Creation'!$D$12:$D$259) | =SUMIF('F-2 Off-Site WaterC' Creation'!$C$12:$C$259,'G-2 Habitat groups'!A174,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259) | =SUMIF('F-3 Off-Site WaterC Enhancement'!$N$12:$N$259,'G-2 Habitat groups'!A174,'F-3 Off-Site WaterC Enhancement'!$Q$12:$Q$259) | =SUMIF('F-3 Off-Site WaterC Enhancement'!$N$12:$N$259,'G-2 Habitat groups'!A174,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$259) | =U174+W174+Y174 | =V174+X174+Z174 | =AA174-S174 | =AB174-T174 | =Q174+AC174 | =R174+AD174 |
| 175 | ='G-7 WaterC' Data'!B7 | Watercourses | ='G-7 WaterC' Data'!C7 | ='G-7 WaterC' Data'!AU6 | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A175,'C-1 On-Site WaterC' Baseline'!$E$10:$E$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A175,'C-1 On-Site WaterC' Baseline'!$R$10:$R$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A175,'C-1 On-Site WaterC' Baseline'!$U$10:$U$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A175,'C-1 On-Site WaterC' Baseline'!$W$10:$W$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A175,'C-1 On-Site WaterC' Baseline'!$Y$10:$Y$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A175,'C-1 On-Site WaterC' Baseline'!$Z$10:$Z$257) | =SUMIF('C-2 On-Site WaterC' Creation'!$C$10:$C$257,'G-2 Habitat groups'!A175,'C-2 On-Site WaterC' Creation'!$D$10:$D$257) | =SUMIF('C-2 On-Site WaterC' Creation'!$C$10:$C$257,'G-2 Habitat groups'!A175,'C-2 On-Site WaterC' Creation'!$Z$10:$Z$257) | =SUMIF('C-3 On-Site WaterC' Enhancement'!$N$12:$N$257,'G-2 Habitat groups'!A175,'C-3 On-Site WaterC' Enhancement'!$Q$12:$Q$257) | =SUMIF('C-3 On-Site WaterC' Enhancement'!$N$12:$N$257,'G-2 Habitat groups'!A175,'C-3 On-Site WaterC' Enhancement'!$AM$12:$AM$257) | =G175+K175+M175 | =H175+L175+N175 | =O175-E175 | =P175-F175 | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A175,'F-1 Off-Site WaterC' Baseline'!$E$10:$E$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A175,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A175,'F-1 Off-Site WaterC' Baseline'!$X$10:$X$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A175,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257) | =SUMIF('F-2 Off-Site WaterC' Creation'!$C$12:$C$259,'G-2 Habitat groups'!A175,'F-2 Off-Site WaterC' Creation'!$D$12:$D$259) | =SUMIF('F-2 Off-Site WaterC' Creation'!$C$12:$C$259,'G-2 Habitat groups'!A175,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259) | =SUMIF('F-3 Off-Site WaterC Enhancement'!$N$12:$N$259,'G-2 Habitat groups'!A175,'F-3 Off-Site WaterC Enhancement'!$Q$12:$Q$259) | =SUMIF('F-3 Off-Site WaterC Enhancement'!$N$12:$N$259,'G-2 Habitat groups'!A175,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$259) | =U175+W175+Y175 | =V175+X175+Z175 | =AA175-S175 | =AB175-T175 | =Q175+AC175 | =R175+AD175 |
| 176 | ='G-7 WaterC' Data'!B8 | Watercourses | ='G-7 WaterC' Data'!C8 | ='G-7 WaterC' Data'!AU7 | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A176,'C-1 On-Site WaterC' Baseline'!$E$10:$E$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A176,'C-1 On-Site WaterC' Baseline'!$R$10:$R$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A176,'C-1 On-Site WaterC' Baseline'!$U$10:$U$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A176,'C-1 On-Site WaterC' Baseline'!$W$10:$W$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A176,'C-1 On-Site WaterC' Baseline'!$Y$10:$Y$257) | =SUMIF('C-1 On-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A176,'C-1 On-Site WaterC' Baseline'!$Z$10:$Z$257) | =SUMIF('C-2 On-Site WaterC' Creation'!$C$10:$C$257,'G-2 Habitat groups'!A176,'C-2 On-Site WaterC' Creation'!$D$10:$D$257) | =SUMIF('C-2 On-Site WaterC' Creation'!$C$10:$C$257,'G-2 Habitat groups'!A176,'C-2 On-Site WaterC' Creation'!$Z$10:$Z$257) | =SUMIF('C-3 On-Site WaterC' Enhancement'!$N$12:$N$257,'G-2 Habitat groups'!A176,'C-3 On-Site WaterC' Enhancement'!$Q$12:$Q$257) | =SUMIF('C-3 On-Site WaterC' Enhancement'!$N$12:$N$257,'G-2 Habitat groups'!A176,'C-3 On-Site WaterC' Enhancement'!$AM$12:$AM$257) | =G176+K176+M176 | =H176+L176+N176 | =O176-E176 | =P176-F176 | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A176,'F-1 Off-Site WaterC' Baseline'!$E$10:$E$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A176,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A176,'F-1 Off-Site WaterC' Baseline'!$X$10:$X$257) | =SUMIF('F-1 Off-Site WaterC' Baseline'!$D$10:$D$257,'G-2 Habitat groups'!A176,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257) | =SUMIF('F-2 Off-Site WaterC' Creation'!$C$12:$C$259,'G-2 Habitat groups'!A176,'F-2 Off-Site WaterC' Creation'!$D$12:$D$259) | =SUMIF('F-2 Off-Site WaterC' Creation'!$C$12:$C$259,'G-2 Habitat groups'!A176,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259) | =SUMIF('F-3 Off-Site WaterC Enhancement'!$N$12:$N$259,'G-2 Habitat groups'!A176,'F-3 Off-Site WaterC Enhancement'!$Q$12:$Q$259) | =SUMIF('F-3 Off-Site WaterC Enhancement'!$N$12:$N$259,'G-2 Habitat groups'!A176,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$259) | =U176+W176+Y176 | =V176+X176+Z176 | =AA176-S176 | =AB176-T176 | =Q176+AC176 | =R176+AD176 |