|
Index |
AB Gain site reference |
AC Off-site units baseline |
AD SRM Off-site units baseline |
AE Off-site units retained |
AF SRM Off-site units retained |
AG Off-site units enhanced |
AH SRM Off-site units enhanced |
AI Off-site units created |
AJ SRM Off-site units created |
AK Off-site unit change per gain site (pre-SRM) |
AL SRM |
AM Off-site unit change per gain site (post-SRM) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7 | =IFERROR(_xlfn.UNIQUE(_xlfn._xlws.FILTER(AA7:AA748, AA7:AA748<>0)),"") | =IF(AB7="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB7,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB7="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB7,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB7="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB7,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB7="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB7,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB7="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB7,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB7="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB7,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB7="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB7,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB7="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB7,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB7="","",(AG7+AI7+AE7)-AC7) | =IF(ISBLANK(AB7),"", IFERROR(_xlfn.XLOOKUP(AB7,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB7,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB7="","", IF(AK7<0,"Error - gain sites must be postive ▲", (AH7+AJ7+AF7)-AD7)) |
| 8 | =IF(AB8="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB8,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB8="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB8,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB8="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB8,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB8="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB8,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB8="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB8,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB8="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB8,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB8="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB8,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB8="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB8,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB8="","",(AG8+AI8+AE8)-AC8) | =IF(ISBLANK(AB8),"", IFERROR(_xlfn.XLOOKUP(AB8,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB8,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB8="","", IF(AK8<0,"Error - gain sites must be postive ▲", (AH8+AJ8+AF8)-AD8)) | |
| 9 | =IF(AB9="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB9,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB9="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB9,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB9="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB9,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB9="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB9,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB9="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB9,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB9="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB9,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB9="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB9,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB9="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB9,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB9="","",(AG9+AI9+AE9)-AC9) | =IF(ISBLANK(AB9),"", IFERROR(_xlfn.XLOOKUP(AB9,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB9,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB9="","", IF(AK9<0,"Error - gain sites must be postive ▲", (AH9+AJ9+AF9)-AD9)) | |
| 10 | =IF(AB10="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB10,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB10="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB10,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB10="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB10,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB10="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB10,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB10="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB10,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB10="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB10,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB10="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB10,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB10="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB10,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB10="","",(AG10+AI10+AE10)-AC10) | =IF(ISBLANK(AB10),"", IFERROR(_xlfn.XLOOKUP(AB10,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB10,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB10="","", IF(AK10,"Error - gain sites must be postive ▲", (AH10+AJ10+AF10)-AD10)) | |
| 11 | =IF(AB11="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB11,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB11="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB11,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB11="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB11,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB11="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB11,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB11="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB11,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB11="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB11,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB11="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB11,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB11="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB11,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB11="","",(AG11+AI11+AE11)-AC11) | =IF(ISBLANK(AB11),"", IFERROR(_xlfn.XLOOKUP(AB11,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB11,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB11="","", IF(AK11<0,"Error - gain sites must be postive ▲", (AH11+AJ11+AF11)-AD11)) | |
| 12 | =IF(AB12="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB12,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB12="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB12,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB12="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB12,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB12="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB12,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB12="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB12,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB12="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB12,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB12="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB12,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB12="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB12,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB12="","",(AG12+AI12+AE12)-AC12) | =IF(ISBLANK(AB12),"", IFERROR(_xlfn.XLOOKUP(AB12,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB12,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB12="","", IF(AK12<0,"Error - gain sites must be postive ▲", (AH12+AJ12+AF12)-AD12)) | |
| 13 | =IF(AB13="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB13,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB13="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB13,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB13="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB13,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB13="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB13,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB13="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB13,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB13="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB13,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB13="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB13,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB13="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB13,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB13="","",(AG13+AI13+AE13)-AC13) | =IF(ISBLANK(AB13),"", IFERROR(_xlfn.XLOOKUP(AB13,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB13,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB13="","", IF(AK13<0,"Error - gain sites must be postive ▲", (AH13+AJ13+AF13)-AD13)) | |
| 14 | =IF(AB14="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB14,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB14="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB14,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB14="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB14,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB14="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB14,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB14="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB14,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB14="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB14,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB14="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB14,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB14="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB14,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB14="","",(AG14+AI14+AE14)-AC14) | =IF(ISBLANK(AB14),"", IFERROR(_xlfn.XLOOKUP(AB14,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB14,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB14="","", IF(AK14<0,"Error - gain sites must be postive ▲", (AH14+AJ14+AF14)-AD14)) | |
| 15 | =IF(AB15="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB15,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB15="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB15,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB15="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB15,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB15="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB15,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB15="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB15,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB15="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB15,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB15="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB15,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB15="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB15,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB15="","",(AG15+AI15+AE15)-AC15) | =IF(ISBLANK(AB15),"", IFERROR(_xlfn.XLOOKUP(AB15,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB15,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB15="","", IF(AK15<0,"Error - gain sites must be postive ▲", (AH15+AJ15+AF15)-AD15)) | |
| 16 | =IF(AB16="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB16,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB16="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB16,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB16="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB16,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB16="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB16,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB16="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB16,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB16="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB16,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB16="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB16,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB16="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB16,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB16="","",(AG16+AI16+AE16)-AC16) | =IF(ISBLANK(AB16),"", IFERROR(_xlfn.XLOOKUP(AB16,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB16,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB16="","", IF(AK16<0,"Error - gain sites must be postive ▲", (AH16+AJ16+AF16)-AD16)) | |
| 17 | =IF(AB17="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB17,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB17="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB17,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB17="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB17,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB17="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB17,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB17="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB17,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB17="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB17,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB17="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB17,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB17="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB17,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB17="","",(AG17+AI17+AE17)-AC17) | =IF(ISBLANK(AB17),"", IFERROR(_xlfn.XLOOKUP(AB17,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB17,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB17="","", IF(AK17<0,"Error - gain sites must be postive ▲", (AH17+AJ17+AF17)-AD17)) | |
| 18 | =IF(AB18="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB18,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB18="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB18,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB18="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB18,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB18="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB18,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB18="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB18,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB18="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB18,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB18="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB18,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB18="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB18,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB18="","",(AG18+AI18+AE18)-AC18) | =IF(ISBLANK(AB18),"", IFERROR(_xlfn.XLOOKUP(AB18,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB18,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB18="","", IF(AK18<0,"Error - gain sites must be postive ▲", (AH18+AJ18+AF18)-AD18)) | |
| 19 | =IF(AB19="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB19,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB19="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB19,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB19="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB19,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB19="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB19,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB19="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB19,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB19="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB19,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB19="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB19,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB19="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB19,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB19="","",(AG19+AI19+AE19)-AC19) | =IF(ISBLANK(AB19),"", IFERROR(_xlfn.XLOOKUP(AB19,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB19,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB19="","", IF(AK19<0,"Error - gain sites must be postive ▲", (AH19+AJ19+AF19)-AD19)) | |
| 20 | =IF(AB20="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB20,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB20="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB20,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB20="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB20,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB20="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB20,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB20="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB20,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB20="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB20,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB20="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB20,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB20="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB20,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB20="","",(AG20+AI20+AE20)-AC20) | =IF(ISBLANK(AB20),"", IFERROR(_xlfn.XLOOKUP(AB20,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB20,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB20="","", IF(AK20,"Error - gain sites must be postive ▲", (AH20+AJ20+AF20)-AD20)) | |
| 21 | =IF(AB21="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB21,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB21="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB21,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB21="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB21,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB21="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB21,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB21="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB21,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB21="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB21,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB21="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB21,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB21="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB21,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB21="","",(AG21+AI21+AE21)-AC21) | =IF(ISBLANK(AB21),"", IFERROR(_xlfn.XLOOKUP(AB21,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB21,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB21="","", IF(AK21<0,"Error - gain sites must be postive ▲", (AH21+AJ21+AF21)-AD21)) | |
| 22 | =IF(AB22="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB22,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB22="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB22,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB22="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB22,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB22="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB22,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB22="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB22,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB22="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB22,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB22="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB22,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB22="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB22,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB22="","",(AG22+AI22+AE22)-AC22) | =IF(ISBLANK(AB22),"", IFERROR(_xlfn.XLOOKUP(AB22,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB22,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB22="","", IF(AK22<0,"Error - gain sites must be postive ▲", (AH22+AJ22+AF22)-AD22)) | |
| 23 | =IF(AB23="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB23,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB23="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB23,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB23="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB23,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB23="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB23,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB23="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB23,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB23="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB23,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB23="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB23,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB23="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB23,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB23="","",(AG23+AI23+AE23)-AC23) | =IF(ISBLANK(AB23),"", IFERROR(_xlfn.XLOOKUP(AB23,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB23,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB23="","", IF(AK23<0,"Error - gain sites must be postive ▲", (AH23+AJ23+AF23)-AD23)) | |
| 24 | =IF(AB24="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB24,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB24="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB24,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB24="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB24,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB24="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB24,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB24="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB24,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB24="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB24,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB24="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB24,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB24="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB24,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB24="","",(AG24+AI24+AE24)-AC24) | =IF(ISBLANK(AB24),"", IFERROR(_xlfn.XLOOKUP(AB24,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB24,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB24="","", IF(AK24<0,"Error - gain sites must be postive ▲", (AH24+AJ24+AF24)-AD24)) | |
| 25 | =IF(AB25="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB25,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB25="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB25,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB25="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB25,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB25="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB25,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB25="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB25,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB25="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB25,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB25="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB25,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB25="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB25,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB25="","",(AG25+AI25+AE25)-AC25) | =IF(ISBLANK(AB25),"", IFERROR(_xlfn.XLOOKUP(AB25,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB25,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB25="","", IF(AK25<0,"Error - gain sites must be postive ▲", (AH25+AJ25+AF25)-AD25)) | |
| 26 | =IF(AB26="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB26,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB26="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB26,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB26="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB26,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB26="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB26,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB26="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB26,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB26="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB26,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB26="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB26,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB26="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB26,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB26="","",(AG26+AI26+AE26)-AC26) | =IF(ISBLANK(AB26),"", IFERROR(_xlfn.XLOOKUP(AB26,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB26,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB26="","", IF(AK26<0,"Error - gain sites must be postive ▲", (AH26+AJ26+AF26)-AD26)) | |
| 27 | =IF(AB27="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB27,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB27="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB27,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB27="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB27,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB27="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB27,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB27="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB27,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB27="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB27,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB27="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB27,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB27="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB27,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB27="","",(AG27+AI27+AE27)-AC27) | =IF(ISBLANK(AB27),"", IFERROR(_xlfn.XLOOKUP(AB27,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB27,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB27="","", IF(AK27<0,"Error - gain sites must be postive ▲", (AH27+AJ27+AF27)-AD27)) | |
| 28 | =IF(AB28="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB28,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB28="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB28,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB28="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB28,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB28="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB28,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB28="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB28,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB28="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB28,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB28="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB28,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB28="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB28,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB28="","",(AG28+AI28+AE28)-AC28) | =IF(ISBLANK(AB28),"", IFERROR(_xlfn.XLOOKUP(AB28,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB28,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB28="","", IF(AK28<0,"Error - gain sites must be postive ▲", (AH28+AJ28+AF28)-AD28)) | |
| 29 | =IF(AB29="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB29,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB29="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB29,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB29="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB29,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB29="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB29,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB29="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB29,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB29="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB29,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB29="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB29,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB29="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB29,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB29="","",(AG29+AI29+AE29)-AC29) | =IF(ISBLANK(AB29),"", IFERROR(_xlfn.XLOOKUP(AB29,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB29,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB29="","", IF(AK29<0,"Error - gain sites must be postive ▲", (AH29+AJ29+AF29)-AD29)) | |
| 30 | =IF(AB30="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB30,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB30="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB30,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB30="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB30,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB30="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB30,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB30="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB30,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB30="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB30,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB30="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB30,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB30="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB30,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB30="","",(AG30+AI30+AE30)-AC30) | =IF(ISBLANK(AB30),"", IFERROR(_xlfn.XLOOKUP(AB30,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB30,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB30="","", IF(AK30,"Error - gain sites must be postive ▲", (AH30+AJ30+AF30)-AD30)) | |
| 31 | =IF(AB31="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB31,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB31="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB31,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB31="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB31,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB31="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB31,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB31="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB31,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB31="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB31,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB31="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB31,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB31="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB31,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB31="","",(AG31+AI31+AE31)-AC31) | =IF(ISBLANK(AB31),"", IFERROR(_xlfn.XLOOKUP(AB31,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB31,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB31="","", IF(AK31<0,"Error - gain sites must be postive ▲", (AH31+AJ31+AF31)-AD31)) | |
| 32 | =IF(AB32="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB32,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB32="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB32,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB32="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB32,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB32="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB32,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB32="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB32,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB32="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB32,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB32="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB32,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB32="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB32,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB32="","",(AG32+AI32+AE32)-AC32) | =IF(ISBLANK(AB32),"", IFERROR(_xlfn.XLOOKUP(AB32,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB32,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB32="","", IF(AK32<0,"Error - gain sites must be postive ▲", (AH32+AJ32+AF32)-AD32)) | |
| 33 | =IF(AB33="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB33,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB33="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB33,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB33="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB33,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB33="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB33,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB33="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB33,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB33="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB33,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB33="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB33,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB33="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB33,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB33="","",(AG33+AI33+AE33)-AC33) | =IF(ISBLANK(AB33),"", IFERROR(_xlfn.XLOOKUP(AB33,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB33,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB33="","", IF(AK33<0,"Error - gain sites must be postive ▲", (AH33+AJ33+AF33)-AD33)) | |
| 34 | =IF(AB34="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB34,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB34="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB34,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB34="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB34,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB34="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB34,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB34="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB34,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB34="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB34,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB34="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB34,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB34="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB34,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB34="","",(AG34+AI34+AE34)-AC34) | =IF(ISBLANK(AB34),"", IFERROR(_xlfn.XLOOKUP(AB34,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB34,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB34="","", IF(AK34<0,"Error - gain sites must be postive ▲", (AH34+AJ34+AF34)-AD34)) | |
| 35 | =IF(AB35="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB35,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB35="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB35,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB35="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB35,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB35="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB35,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB35="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB35,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB35="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB35,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB35="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB35,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB35="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB35,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB35="","",(AG35+AI35+AE35)-AC35) | =IF(ISBLANK(AB35),"", IFERROR(_xlfn.XLOOKUP(AB35,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB35,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB35="","", IF(AK35<0,"Error - gain sites must be postive ▲", (AH35+AJ35+AF35)-AD35)) | |
| 36 | =IF(AB36="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB36,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB36="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB36,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB36="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB36,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB36="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB36,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB36="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB36,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB36="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB36,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB36="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB36,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB36="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB36,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB36="","",(AG36+AI36+AE36)-AC36) | =IF(ISBLANK(AB36),"", IFERROR(_xlfn.XLOOKUP(AB36,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB36,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB36="","", IF(AK36<0,"Error - gain sites must be postive ▲", (AH36+AJ36+AF36)-AD36)) | |
| 37 | =IF(AB37="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB37,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB37="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB37,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB37="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB37,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB37="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB37,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB37="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB37,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB37="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB37,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB37="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB37,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB37="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB37,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB37="","",(AG37+AI37+AE37)-AC37) | =IF(ISBLANK(AB37),"", IFERROR(_xlfn.XLOOKUP(AB37,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB37,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB37="","", IF(AK37<0,"Error - gain sites must be postive ▲", (AH37+AJ37+AF37)-AD37)) | |
| 38 | =IF(AB38="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB38,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB38="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB38,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB38="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB38,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB38="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB38,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB38="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB38,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB38="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB38,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB38="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB38,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB38="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB38,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB38="","",(AG38+AI38+AE38)-AC38) | =IF(ISBLANK(AB38),"", IFERROR(_xlfn.XLOOKUP(AB38,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB38,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB38="","", IF(AK38<0,"Error - gain sites must be postive ▲", (AH38+AJ38+AF38)-AD38)) | |
| 39 | =IF(AB39="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB39,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB39="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB39,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB39="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB39,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB39="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB39,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB39="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB39,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB39="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB39,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB39="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB39,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB39="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB39,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB39="","",(AG39+AI39+AE39)-AC39) | =IF(ISBLANK(AB39),"", IFERROR(_xlfn.XLOOKUP(AB39,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB39,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB39="","", IF(AK39<0,"Error - gain sites must be postive ▲", (AH39+AJ39+AF39)-AD39)) | |
| 40 | =IF(AB40="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB40,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB40="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB40,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB40="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB40,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB40="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB40,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB40="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB40,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB40="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB40,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB40="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB40,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB40="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB40,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB40="","",(AG40+AI40+AE40)-AC40) | =IF(ISBLANK(AB40),"", IFERROR(_xlfn.XLOOKUP(AB40,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB40,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB40="","", IF(AK40,"Error - gain sites must be postive ▲", (AH40+AJ40+AF40)-AD40)) | |
| 41 | =IF(AB41="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB41,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB41="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB41,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB41="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB41,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB41="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB41,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB41="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB41,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB41="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB41,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB41="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB41,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB41="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB41,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB41="","",(AG41+AI41+AE41)-AC41) | =IF(ISBLANK(AB41),"", IFERROR(_xlfn.XLOOKUP(AB41,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB41,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB41="","", IF(AK41<0,"Error - gain sites must be postive ▲", (AH41+AJ41+AF41)-AD41)) | |
| 42 | =IF(AB42="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB42,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB42="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB42,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB42="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB42,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB42="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB42,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB42="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB42,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB42="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB42,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB42="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB42,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB42="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB42,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB42="","",(AG42+AI42+AE42)-AC42) | =IF(ISBLANK(AB42),"", IFERROR(_xlfn.XLOOKUP(AB42,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB42,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB42="","", IF(AK42<0,"Error - gain sites must be postive ▲", (AH42+AJ42+AF42)-AD42)) | |
| 43 | =IF(AB43="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB43,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB43="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB43,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB43="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB43,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB43="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB43,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB43="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB43,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB43="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB43,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB43="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB43,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB43="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB43,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB43="","",(AG43+AI43+AE43)-AC43) | =IF(ISBLANK(AB43),"", IFERROR(_xlfn.XLOOKUP(AB43,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB43,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB43="","", IF(AK43<0,"Error - gain sites must be postive ▲", (AH43+AJ43+AF43)-AD43)) | |
| 44 | =IF(AB44="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB44,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB44="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB44,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB44="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB44,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB44="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB44,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB44="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB44,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB44="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB44,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB44="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB44,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB44="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB44,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB44="","",(AG44+AI44+AE44)-AC44) | =IF(ISBLANK(AB44),"", IFERROR(_xlfn.XLOOKUP(AB44,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB44,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB44="","", IF(AK44<0,"Error - gain sites must be postive ▲", (AH44+AJ44+AF44)-AD44)) | |
| 45 | =IF(AB45="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB45,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB45="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB45,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB45="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB45,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB45="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB45,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB45="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB45,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB45="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB45,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB45="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB45,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB45="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB45,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB45="","",(AG45+AI45+AE45)-AC45) | =IF(ISBLANK(AB45),"", IFERROR(_xlfn.XLOOKUP(AB45,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB45,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB45="","", IF(AK45<0,"Error - gain sites must be postive ▲", (AH45+AJ45+AF45)-AD45)) | |
| 46 | =IF(AB46="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB46,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB46="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB46,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB46="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB46,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB46="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB46,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB46="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB46,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB46="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB46,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB46="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB46,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB46="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB46,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB46="","",(AG46+AI46+AE46)-AC46) | =IF(ISBLANK(AB46),"", IFERROR(_xlfn.XLOOKUP(AB46,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB46,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB46="","", IF(AK46<0,"Error - gain sites must be postive ▲", (AH46+AJ46+AF46)-AD46)) | |
| 47 | =IF(AB47="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB47,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB47="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB47,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB47="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB47,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB47="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB47,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB47="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB47,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB47="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB47,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB47="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB47,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB47="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB47,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB47="","",(AG47+AI47+AE47)-AC47) | =IF(ISBLANK(AB47),"", IFERROR(_xlfn.XLOOKUP(AB47,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB47,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB47="","", IF(AK47<0,"Error - gain sites must be postive ▲", (AH47+AJ47+AF47)-AD47)) | |
| 48 | =IF(AB48="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB48,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB48="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB48,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB48="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB48,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB48="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB48,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB48="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB48,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB48="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB48,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB48="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB48,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB48="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB48,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB48="","",(AG48+AI48+AE48)-AC48) | =IF(ISBLANK(AB48),"", IFERROR(_xlfn.XLOOKUP(AB48,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB48,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB48="","", IF(AK48<0,"Error - gain sites must be postive ▲", (AH48+AJ48+AF48)-AD48)) | |
| 49 | =IF(AB49="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB49,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB49="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB49,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB49="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB49,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB49="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB49,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB49="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB49,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB49="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB49,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB49="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB49,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB49="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB49,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB49="","",(AG49+AI49+AE49)-AC49) | =IF(ISBLANK(AB49),"", IFERROR(_xlfn.XLOOKUP(AB49,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB49,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB49="","", IF(AK49<0,"Error - gain sites must be postive ▲", (AH49+AJ49+AF49)-AD49)) | |
| 50 | =IF(AB50="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB50,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB50="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB50,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB50="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB50,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB50="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB50,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB50="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB50,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB50="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB50,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB50="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB50,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB50="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB50,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB50="","",(AG50+AI50+AE50)-AC50) | =IF(ISBLANK(AB50),"", IFERROR(_xlfn.XLOOKUP(AB50,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB50,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB50="","", IF(AK50,"Error - gain sites must be postive ▲", (AH50+AJ50+AF50)-AD50)) | |
| 51 | =IF(AB51="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB51,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB51="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB51,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB51="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB51,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB51="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB51,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB51="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB51,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB51="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB51,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB51="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB51,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB51="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB51,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB51="","",(AG51+AI51+AE51)-AC51) | =IF(ISBLANK(AB51),"", IFERROR(_xlfn.XLOOKUP(AB51,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB51,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB51="","", IF(AK51<0,"Error - gain sites must be postive ▲", (AH51+AJ51+AF51)-AD51)) | |
| 52 | =IF(AB52="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB52,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB52="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB52,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB52="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB52,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB52="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB52,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB52="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB52,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB52="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB52,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB52="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB52,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB52="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB52,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB52="","",(AG52+AI52+AE52)-AC52) | =IF(ISBLANK(AB52),"", IFERROR(_xlfn.XLOOKUP(AB52,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB52,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB52="","", IF(AK52<0,"Error - gain sites must be postive ▲", (AH52+AJ52+AF52)-AD52)) | |
| 53 | =IF(AB53="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB53,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB53="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB53,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB53="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB53,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB53="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB53,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB53="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB53,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB53="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB53,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB53="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB53,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB53="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB53,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB53="","",(AG53+AI53+AE53)-AC53) | =IF(ISBLANK(AB53),"", IFERROR(_xlfn.XLOOKUP(AB53,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB53,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB53="","", IF(AK53<0,"Error - gain sites must be postive ▲", (AH53+AJ53+AF53)-AD53)) | |
| 54 | =IF(AB54="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB54,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB54="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB54,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB54="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB54,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB54="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB54,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB54="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB54,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB54="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB54,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB54="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB54,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB54="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB54,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB54="","",(AG54+AI54+AE54)-AC54) | =IF(ISBLANK(AB54),"", IFERROR(_xlfn.XLOOKUP(AB54,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB54,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB54="","", IF(AK54<0,"Error - gain sites must be postive ▲", (AH54+AJ54+AF54)-AD54)) | |
| 55 | =IF(AB55="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB55,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB55="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB55,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB55="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB55,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB55="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB55,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB55="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB55,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB55="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB55,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB55="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB55,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB55="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB55,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB55="","",(AG55+AI55+AE55)-AC55) | =IF(ISBLANK(AB55),"", IFERROR(_xlfn.XLOOKUP(AB55,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB55,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB55="","", IF(AK55<0,"Error - gain sites must be postive ▲", (AH55+AJ55+AF55)-AD55)) | |
| 56 | =IF(AB56="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB56,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB56="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB56,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB56="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB56,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB56="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB56,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB56="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB56,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB56="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB56,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB56="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB56,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB56="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB56,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB56="","",(AG56+AI56+AE56)-AC56) | =IF(ISBLANK(AB56),"", IFERROR(_xlfn.XLOOKUP(AB56,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB56,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB56="","", IF(AK56<0,"Error - gain sites must be postive ▲", (AH56+AJ56+AF56)-AD56)) | |
| 57 | =IF(AB57="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB57,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB57="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB57,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB57="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB57,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB57="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB57,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB57="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB57,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB57="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB57,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB57="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB57,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB57="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB57,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB57="","",(AG57+AI57+AE57)-AC57) | =IF(ISBLANK(AB57),"", IFERROR(_xlfn.XLOOKUP(AB57,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB57,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB57="","", IF(AK57<0,"Error - gain sites must be postive ▲", (AH57+AJ57+AF57)-AD57)) | |
| 58 | =IF(AB58="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB58,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB58="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB58,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB58="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB58,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB58="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB58,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB58="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB58,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB58="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB58,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB58="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB58,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB58="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB58,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB58="","",(AG58+AI58+AE58)-AC58) | =IF(ISBLANK(AB58),"", IFERROR(_xlfn.XLOOKUP(AB58,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB58,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB58="","", IF(AK58<0,"Error - gain sites must be postive ▲", (AH58+AJ58+AF58)-AD58)) | |
| 59 | =IF(AB59="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB59,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB59="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB59,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB59="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB59,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB59="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB59,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB59="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB59,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB59="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB59,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB59="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB59,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB59="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB59,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB59="","",(AG59+AI59+AE59)-AC59) | =IF(ISBLANK(AB59),"", IFERROR(_xlfn.XLOOKUP(AB59,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB59,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB59="","", IF(AK59<0,"Error - gain sites must be postive ▲", (AH59+AJ59+AF59)-AD59)) | |
| 60 | =IF(AB60="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB60,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB60="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB60,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB60="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB60,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB60="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB60,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB60="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB60,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB60="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB60,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB60="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB60,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB60="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB60,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB60="","",(AG60+AI60+AE60)-AC60) | =IF(ISBLANK(AB60),"", IFERROR(_xlfn.XLOOKUP(AB60,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB60,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB60="","", IF(AK60,"Error - gain sites must be postive ▲", (AH60+AJ60+AF60)-AD60)) | |
| 61 | =IF(AB61="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB61,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB61="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB61,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB61="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB61,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB61="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB61,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB61="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB61,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB61="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB61,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB61="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB61,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB61="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB61,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB61="","",(AG61+AI61+AE61)-AC61) | =IF(ISBLANK(AB61),"", IFERROR(_xlfn.XLOOKUP(AB61,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB61,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB61="","", IF(AK61<0,"Error - gain sites must be postive ▲", (AH61+AJ61+AF61)-AD61)) | |
| 62 | =IF(AB62="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB62,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB62="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB62,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB62="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB62,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB62="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB62,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB62="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB62,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB62="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB62,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB62="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB62,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB62="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB62,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB62="","",(AG62+AI62+AE62)-AC62) | =IF(ISBLANK(AB62),"", IFERROR(_xlfn.XLOOKUP(AB62,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB62,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB62="","", IF(AK62<0,"Error - gain sites must be postive ▲", (AH62+AJ62+AF62)-AD62)) | |
| 63 | =IF(AB63="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB63,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB63="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB63,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB63="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB63,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB63="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB63,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB63="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB63,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB63="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB63,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB63="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB63,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB63="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB63,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB63="","",(AG63+AI63+AE63)-AC63) | =IF(ISBLANK(AB63),"", IFERROR(_xlfn.XLOOKUP(AB63,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB63,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB63="","", IF(AK63<0,"Error - gain sites must be postive ▲", (AH63+AJ63+AF63)-AD63)) | |
| 64 | =IF(AB64="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB64,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB64="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB64,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB64="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB64,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB64="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB64,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB64="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB64,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB64="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB64,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB64="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB64,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB64="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB64,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB64="","",(AG64+AI64+AE64)-AC64) | =IF(ISBLANK(AB64),"", IFERROR(_xlfn.XLOOKUP(AB64,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB64,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB64="","", IF(AK64<0,"Error - gain sites must be postive ▲", (AH64+AJ64+AF64)-AD64)) | |
| 65 | =IF(AB65="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB65,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB65="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB65,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB65="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB65,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB65="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB65,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB65="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB65,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB65="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB65,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB65="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB65,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB65="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB65,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB65="","",(AG65+AI65+AE65)-AC65) | =IF(ISBLANK(AB65),"", IFERROR(_xlfn.XLOOKUP(AB65,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB65,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB65="","", IF(AK65<0,"Error - gain sites must be postive ▲", (AH65+AJ65+AF65)-AD65)) | |
| 66 | =IF(AB66="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB66,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB66="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB66,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB66="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB66,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB66="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB66,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB66="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB66,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB66="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB66,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB66="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB66,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB66="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB66,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB66="","",(AG66+AI66+AE66)-AC66) | =IF(ISBLANK(AB66),"", IFERROR(_xlfn.XLOOKUP(AB66,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB66,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB66="","", IF(AK66<0,"Error - gain sites must be postive ▲", (AH66+AJ66+AF66)-AD66)) | |
| 67 | =IF(AB67="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB67,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB67="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB67,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB67="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB67,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB67="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB67,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB67="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB67,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB67="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB67,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB67="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB67,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB67="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB67,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB67="","",(AG67+AI67+AE67)-AC67) | =IF(ISBLANK(AB67),"", IFERROR(_xlfn.XLOOKUP(AB67,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB67,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB67="","", IF(AK67<0,"Error - gain sites must be postive ▲", (AH67+AJ67+AF67)-AD67)) | |
| 68 | =IF(AB68="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB68,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB68="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB68,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB68="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB68,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB68="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB68,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB68="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB68,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB68="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB68,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB68="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB68,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB68="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB68,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB68="","",(AG68+AI68+AE68)-AC68) | =IF(ISBLANK(AB68),"", IFERROR(_xlfn.XLOOKUP(AB68,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB68,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB68="","", IF(AK68<0,"Error - gain sites must be postive ▲", (AH68+AJ68+AF68)-AD68)) | |
| 69 | =IF(AB69="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB69,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB69="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB69,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB69="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB69,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB69="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB69,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB69="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB69,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB69="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB69,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB69="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB69,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB69="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB69,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB69="","",(AG69+AI69+AE69)-AC69) | =IF(ISBLANK(AB69),"", IFERROR(_xlfn.XLOOKUP(AB69,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB69,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB69="","", IF(AK69<0,"Error - gain sites must be postive ▲", (AH69+AJ69+AF69)-AD69)) | |
| 70 | =IF(AB70="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB70,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB70="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB70,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB70="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB70,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB70="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB70,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB70="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB70,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB70="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB70,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB70="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB70,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB70="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB70,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB70="","",(AG70+AI70+AE70)-AC70) | =IF(ISBLANK(AB70),"", IFERROR(_xlfn.XLOOKUP(AB70,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB70,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB70="","", IF(AK70,"Error - gain sites must be postive ▲", (AH70+AJ70+AF70)-AD70)) | |
| 71 | =IF(AB71="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB71,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB71="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB71,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB71="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB71,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB71="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB71,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB71="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB71,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB71="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB71,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB71="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB71,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB71="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB71,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB71="","",(AG71+AI71+AE71)-AC71) | =IF(ISBLANK(AB71),"", IFERROR(_xlfn.XLOOKUP(AB71,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB71,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB71="","", IF(AK71<0,"Error - gain sites must be postive ▲", (AH71+AJ71+AF71)-AD71)) | |
| 72 | =IF(AB72="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB72,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB72="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB72,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB72="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB72,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB72="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB72,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB72="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB72,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB72="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB72,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB72="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB72,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB72="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB72,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB72="","",(AG72+AI72+AE72)-AC72) | =IF(ISBLANK(AB72),"", IFERROR(_xlfn.XLOOKUP(AB72,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB72,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB72="","", IF(AK72<0,"Error - gain sites must be postive ▲", (AH72+AJ72+AF72)-AD72)) | |
| 73 | =IF(AB73="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB73,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB73="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB73,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB73="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB73,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB73="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB73,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB73="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB73,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB73="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB73,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB73="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB73,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB73="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB73,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB73="","",(AG73+AI73+AE73)-AC73) | =IF(ISBLANK(AB73),"", IFERROR(_xlfn.XLOOKUP(AB73,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB73,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB73="","", IF(AK73<0,"Error - gain sites must be postive ▲", (AH73+AJ73+AF73)-AD73)) | |
| 74 | =IF(AB74="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB74,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB74="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB74,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB74="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB74,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB74="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB74,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB74="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB74,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB74="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB74,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB74="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB74,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB74="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB74,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB74="","",(AG74+AI74+AE74)-AC74) | =IF(ISBLANK(AB74),"", IFERROR(_xlfn.XLOOKUP(AB74,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB74,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB74="","", IF(AK74<0,"Error - gain sites must be postive ▲", (AH74+AJ74+AF74)-AD74)) | |
| 75 | =IF(AB75="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB75,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB75="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB75,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB75="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB75,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB75="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB75,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB75="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB75,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB75="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB75,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB75="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB75,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB75="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB75,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB75="","",(AG75+AI75+AE75)-AC75) | =IF(ISBLANK(AB75),"", IFERROR(_xlfn.XLOOKUP(AB75,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB75,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB75="","", IF(AK75<0,"Error - gain sites must be postive ▲", (AH75+AJ75+AF75)-AD75)) | |
| 76 | =IF(AB76="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB76,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB76="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB76,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB76="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB76,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB76="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB76,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB76="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB76,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB76="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB76,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB76="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB76,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB76="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB76,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB76="","",(AG76+AI76+AE76)-AC76) | =IF(ISBLANK(AB76),"", IFERROR(_xlfn.XLOOKUP(AB76,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB76,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB76="","", IF(AK76<0,"Error - gain sites must be postive ▲", (AH76+AJ76+AF76)-AD76)) | |
| 77 | =IF(AB77="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB77,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB77="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB77,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB77="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB77,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB77="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB77,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB77="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB77,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB77="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB77,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB77="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB77,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB77="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB77,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB77="","",(AG77+AI77+AE77)-AC77) | =IF(ISBLANK(AB77),"", IFERROR(_xlfn.XLOOKUP(AB77,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB77,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB77="","", IF(AK77<0,"Error - gain sites must be postive ▲", (AH77+AJ77+AF77)-AD77)) | |
| 78 | =IF(AB78="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB78,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB78="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB78,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB78="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB78,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB78="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB78,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB78="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB78,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB78="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB78,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB78="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB78,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB78="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB78,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB78="","",(AG78+AI78+AE78)-AC78) | =IF(ISBLANK(AB78),"", IFERROR(_xlfn.XLOOKUP(AB78,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB78,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB78="","", IF(AK78<0,"Error - gain sites must be postive ▲", (AH78+AJ78+AF78)-AD78)) | |
| 79 | =IF(AB79="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB79,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB79="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB79,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB79="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB79,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB79="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB79,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB79="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB79,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB79="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB79,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB79="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB79,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB79="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB79,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB79="","",(AG79+AI79+AE79)-AC79) | =IF(ISBLANK(AB79),"", IFERROR(_xlfn.XLOOKUP(AB79,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB79,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB79="","", IF(AK79<0,"Error - gain sites must be postive ▲", (AH79+AJ79+AF79)-AD79)) | |
| 80 | =IF(AB80="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB80,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB80="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB80,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB80="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB80,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB80="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB80,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB80="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB80,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB80="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB80,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB80="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB80,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB80="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB80,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB80="","",(AG80+AI80+AE80)-AC80) | =IF(ISBLANK(AB80),"", IFERROR(_xlfn.XLOOKUP(AB80,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB80,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB80="","", IF(AK80,"Error - gain sites must be postive ▲", (AH80+AJ80+AF80)-AD80)) | |
| 81 | =IF(AB81="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB81,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB81="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB81,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB81="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB81,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB81="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB81,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB81="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB81,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB81="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB81,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB81="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB81,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB81="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB81,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB81="","",(AG81+AI81+AE81)-AC81) | =IF(ISBLANK(AB81),"", IFERROR(_xlfn.XLOOKUP(AB81,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB81,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB81="","", IF(AK81<0,"Error - gain sites must be postive ▲", (AH81+AJ81+AF81)-AD81)) | |
| 82 | =IF(AB82="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB82,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB82="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB82,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB82="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB82,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB82="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB82,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB82="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB82,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB82="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB82,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB82="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB82,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB82="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB82,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB82="","",(AG82+AI82+AE82)-AC82) | =IF(ISBLANK(AB82),"", IFERROR(_xlfn.XLOOKUP(AB82,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB82,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB82="","", IF(AK82<0,"Error - gain sites must be postive ▲", (AH82+AJ82+AF82)-AD82)) | |
| 83 | =IF(AB83="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB83,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB83="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB83,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB83="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB83,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB83="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB83,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB83="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB83,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB83="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB83,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB83="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB83,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB83="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB83,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB83="","",(AG83+AI83+AE83)-AC83) | =IF(ISBLANK(AB83),"", IFERROR(_xlfn.XLOOKUP(AB83,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB83,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB83="","", IF(AK83<0,"Error - gain sites must be postive ▲", (AH83+AJ83+AF83)-AD83)) | |
| 84 | =IF(AB84="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB84,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB84="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB84,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB84="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB84,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB84="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB84,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB84="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB84,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB84="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB84,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB84="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB84,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB84="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB84,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB84="","",(AG84+AI84+AE84)-AC84) | =IF(ISBLANK(AB84),"", IFERROR(_xlfn.XLOOKUP(AB84,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB84,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB84="","", IF(AK84<0,"Error - gain sites must be postive ▲", (AH84+AJ84+AF84)-AD84)) | |
| 85 | =IF(AB85="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB85,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB85="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB85,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB85="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB85,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB85="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB85,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB85="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB85,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB85="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB85,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB85="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB85,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB85="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB85,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB85="","",(AG85+AI85+AE85)-AC85) | =IF(ISBLANK(AB85),"", IFERROR(_xlfn.XLOOKUP(AB85,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB85,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB85="","", IF(AK85<0,"Error - gain sites must be postive ▲", (AH85+AJ85+AF85)-AD85)) | |
| 86 | =IF(AB86="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB86,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB86="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB86,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB86="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB86,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB86="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB86,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB86="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB86,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB86="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB86,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB86="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB86,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB86="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB86,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB86="","",(AG86+AI86+AE86)-AC86) | =IF(ISBLANK(AB86),"", IFERROR(_xlfn.XLOOKUP(AB86,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB86,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB86="","", IF(AK86<0,"Error - gain sites must be postive ▲", (AH86+AJ86+AF86)-AD86)) | |
| 87 | =IF(AB87="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB87,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB87="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB87,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB87="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB87,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB87="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB87,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB87="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB87,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB87="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB87,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB87="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB87,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB87="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB87,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB87="","",(AG87+AI87+AE87)-AC87) | =IF(ISBLANK(AB87),"", IFERROR(_xlfn.XLOOKUP(AB87,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB87,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB87="","", IF(AK87<0,"Error - gain sites must be postive ▲", (AH87+AJ87+AF87)-AD87)) | |
| 88 | =IF(AB88="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB88,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB88="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB88,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB88="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB88,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB88="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB88,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB88="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB88,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB88="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB88,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB88="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB88,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB88="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB88,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB88="","",(AG88+AI88+AE88)-AC88) | =IF(ISBLANK(AB88),"", IFERROR(_xlfn.XLOOKUP(AB88,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB88,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB88="","", IF(AK88<0,"Error - gain sites must be postive ▲", (AH88+AJ88+AF88)-AD88)) | |
| 89 | =IF(AB89="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB89,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB89="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB89,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB89="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB89,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB89="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB89,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB89="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB89,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB89="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB89,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB89="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB89,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB89="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB89,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB89="","",(AG89+AI89+AE89)-AC89) | =IF(ISBLANK(AB89),"", IFERROR(_xlfn.XLOOKUP(AB89,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB89,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB89="","", IF(AK89<0,"Error - gain sites must be postive ▲", (AH89+AJ89+AF89)-AD89)) | |
| 90 | =IF(AB90="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB90,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB90="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB90,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB90="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB90,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB90="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB90,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB90="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB90,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB90="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB90,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB90="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB90,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB90="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB90,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB90="","",(AG90+AI90+AE90)-AC90) | =IF(ISBLANK(AB90),"", IFERROR(_xlfn.XLOOKUP(AB90,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB90,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB90="","", IF(AK90,"Error - gain sites must be postive ▲", (AH90+AJ90+AF90)-AD90)) | |
| 91 | =IF(AB91="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB91,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB91="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB91,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB91="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB91,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB91="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB91,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB91="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB91,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB91="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB91,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB91="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB91,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB91="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB91,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB91="","",(AG91+AI91+AE91)-AC91) | =IF(ISBLANK(AB91),"", IFERROR(_xlfn.XLOOKUP(AB91,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB91,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB91="","", IF(AK91<0,"Error - gain sites must be postive ▲", (AH91+AJ91+AF91)-AD91)) | |
| 92 | =IF(AB92="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB92,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB92="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB92,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB92="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB92,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB92="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB92,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB92="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB92,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB92="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB92,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB92="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB92,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB92="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB92,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB92="","",(AG92+AI92+AE92)-AC92) | =IF(ISBLANK(AB92),"", IFERROR(_xlfn.XLOOKUP(AB92,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB92,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB92="","", IF(AK92<0,"Error - gain sites must be postive ▲", (AH92+AJ92+AF92)-AD92)) | |
| 93 | =IF(AB93="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB93,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB93="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB93,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB93="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB93,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB93="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB93,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB93="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB93,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB93="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB93,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB93="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB93,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB93="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB93,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB93="","",(AG93+AI93+AE93)-AC93) | =IF(ISBLANK(AB93),"", IFERROR(_xlfn.XLOOKUP(AB93,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB93,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB93="","", IF(AK93<0,"Error - gain sites must be postive ▲", (AH93+AJ93+AF93)-AD93)) | |
| 94 | =IF(AB94="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB94,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB94="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB94,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB94="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB94,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB94="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB94,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB94="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB94,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB94="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB94,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB94="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB94,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB94="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB94,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB94="","",(AG94+AI94+AE94)-AC94) | =IF(ISBLANK(AB94),"", IFERROR(_xlfn.XLOOKUP(AB94,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB94,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB94="","", IF(AK94<0,"Error - gain sites must be postive ▲", (AH94+AJ94+AF94)-AD94)) | |
| 95 | =IF(AB95="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB95,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB95="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB95,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB95="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB95,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB95="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB95,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB95="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB95,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB95="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB95,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB95="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB95,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB95="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB95,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB95="","",(AG95+AI95+AE95)-AC95) | =IF(ISBLANK(AB95),"", IFERROR(_xlfn.XLOOKUP(AB95,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB95,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB95="","", IF(AK95<0,"Error - gain sites must be postive ▲", (AH95+AJ95+AF95)-AD95)) | |
| 96 | =IF(AB96="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB96,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB96="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB96,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB96="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB96,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB96="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB96,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB96="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB96,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB96="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB96,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB96="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB96,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB96="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB96,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB96="","",(AG96+AI96+AE96)-AC96) | =IF(ISBLANK(AB96),"", IFERROR(_xlfn.XLOOKUP(AB96,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB96,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB96="","", IF(AK96<0,"Error - gain sites must be postive ▲", (AH96+AJ96+AF96)-AD96)) | |
| 97 | =IF(AB97="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB97,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB97="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB97,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB97="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB97,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB97="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB97,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB97="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB97,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB97="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB97,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB97="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB97,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB97="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB97,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB97="","",(AG97+AI97+AE97)-AC97) | =IF(ISBLANK(AB97),"", IFERROR(_xlfn.XLOOKUP(AB97,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB97,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB97="","", IF(AK97<0,"Error - gain sites must be postive ▲", (AH97+AJ97+AF97)-AD97)) | |
| 98 | =IF(AB98="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB98,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB98="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB98,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB98="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB98,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB98="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB98,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB98="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB98,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB98="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB98,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB98="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB98,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB98="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB98,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB98="","",(AG98+AI98+AE98)-AC98) | =IF(ISBLANK(AB98),"", IFERROR(_xlfn.XLOOKUP(AB98,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB98,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB98="","", IF(AK98<0,"Error - gain sites must be postive ▲", (AH98+AJ98+AF98)-AD98)) | |
| 99 | =IF(AB99="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB99,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB99="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB99,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB99="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB99,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB99="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB99,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB99="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB99,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB99="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB99,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB99="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB99,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB99="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB99,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB99="","",(AG99+AI99+AE99)-AC99) | =IF(ISBLANK(AB99),"", IFERROR(_xlfn.XLOOKUP(AB99,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB99,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB99="","", IF(AK99<0,"Error - gain sites must be postive ▲", (AH99+AJ99+AF99)-AD99)) | |
| 100 | =IF(AB100="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB100,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB100="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB100,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB100="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB100,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB100="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB100,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB100="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB100,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB100="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB100,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB100="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB100,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB100="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB100,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB100="","",(AG100+AI100+AE100)-AC100) | =IF(ISBLANK(AB100),"", IFERROR(_xlfn.XLOOKUP(AB100,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB100,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB100="","", IF(AK100,"Error - gain sites must be postive ▲", (AH100+AJ100+AF100)-AD100)) | |
| 101 | =IF(AB101="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB101,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB101="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB101,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB101="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB101,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB101="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB101,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB101="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB101,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB101="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB101,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB101="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB101,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB101="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB101,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB101="","",(AG101+AI101+AE101)-AC101) | =IF(ISBLANK(AB101),"", IFERROR(_xlfn.XLOOKUP(AB101,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB101,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB101="","", IF(AK101<0,"Error - gain sites must be postive ▲", (AH101+AJ101+AF101)-AD101)) | |
| 102 | =IF(AB102="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB102,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB102="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB102,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB102="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB102,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB102="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB102,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB102="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB102,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB102="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB102,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB102="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB102,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB102="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB102,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB102="","",(AG102+AI102+AE102)-AC102) | =IF(ISBLANK(AB102),"", IFERROR(_xlfn.XLOOKUP(AB102,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB102,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB102="","", IF(AK102<0,"Error - gain sites must be postive ▲", (AH102+AJ102+AF102)-AD102)) | |
| 103 | =IF(AB103="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB103,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB103="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB103,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB103="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB103,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB103="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB103,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB103="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB103,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB103="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB103,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB103="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB103,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB103="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB103,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB103="","",(AG103+AI103+AE103)-AC103) | =IF(ISBLANK(AB103),"", IFERROR(_xlfn.XLOOKUP(AB103,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB103,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB103="","", IF(AK103<0,"Error - gain sites must be postive ▲", (AH103+AJ103+AF103)-AD103)) | |
| 104 | =IF(AB104="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB104,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB104="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB104,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB104="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB104,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB104="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB104,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB104="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB104,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB104="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB104,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB104="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB104,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB104="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB104,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB104="","",(AG104+AI104+AE104)-AC104) | =IF(ISBLANK(AB104),"", IFERROR(_xlfn.XLOOKUP(AB104,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB104,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB104="","", IF(AK104<0,"Error - gain sites must be postive ▲", (AH104+AJ104+AF104)-AD104)) | |
| 105 | =IF(AB105="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB105,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB105="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB105,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB105="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB105,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB105="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB105,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB105="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB105,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB105="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB105,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB105="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB105,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB105="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB105,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB105="","",(AG105+AI105+AE105)-AC105) | =IF(ISBLANK(AB105),"", IFERROR(_xlfn.XLOOKUP(AB105,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB105,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB105="","", IF(AK105<0,"Error - gain sites must be postive ▲", (AH105+AJ105+AF105)-AD105)) | |
| 106 | =IF(AB106="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB106,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB106="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB106,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB106="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB106,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB106="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB106,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB106="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB106,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB106="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB106,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB106="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB106,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB106="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB106,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB106="","",(AG106+AI106+AE106)-AC106) | =IF(ISBLANK(AB106),"", IFERROR(_xlfn.XLOOKUP(AB106,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB106,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB106="","", IF(AK106<0,"Error - gain sites must be postive ▲", (AH106+AJ106+AF106)-AD106)) | |
| 107 | =IF(AB107="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB107,'F-1 Off-Site WaterC' Baseline'!$U$10:$U$257)) | =IF(AB107="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB107,'F-1 Off-Site WaterC' Baseline'!$R$10:$R$257)) | =IF(AB107="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB107,'F-1 Off-Site WaterC' Baseline'!$Z$10:$Z$257)) | =IF(AB107="","",SUMIF('F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'Off-site gain site summary'!$AB107,'F-1 Off-Site WaterC' Baseline'!$BA$10:$BA$257)) | =IF(AB107="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB107,'F-3 Off-Site WaterC Enhancement'!$AP$12:$AP$257)) | =IF(AB107="","",SUMIF('F-3 Off-Site WaterC Enhancement'!$AT$12:$AT$257,'Off-site gain site summary'!$AB107,'F-3 Off-Site WaterC Enhancement'!$AO$12:$AO$257)) | =IF(AB107="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB107,'F-2 Off-Site WaterC' Creation'!$AC$12:$AC$259)) | =IF(AB107="","",SUMIF('F-2 Off-Site WaterC' Creation'!$AG$12:$AG$259,'Off-site gain site summary'!$AB107,'F-2 Off-Site WaterC' Creation'!$AB$12:$AB$259)) | =IF(AB107="","",(AG107+AI107+AE107)-AC107) | =IF(ISBLANK(AB107),"", IFERROR(_xlfn.XLOOKUP(AB107,'F-2 Off-Site WaterC' Creation'!$AG$12:$AG$258,'F-2 Off-Site WaterC' Creation'!$AA$12:$AA$258), IFERROR(_xlfn.XLOOKUP(AB107,'F-1 Off-Site WaterC' Baseline'!$AH$10:$AH$257,'F-1 Off-Site WaterC' Baseline'!$T$10:$T$257)," "))) | =IF(AB107="","", IF(AK107<0,"Error - gain sites must be postive ▲", (AH107+AJ107+AF107)-AD107)) |