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))