|
Index |
O Gain site reference |
P Off-site units baseline |
Q SRM Off-site units baseline |
R Off-site units retained |
S SRM Off-site units retained |
T Off-site units enhanced |
U SRM Off-site units enhanced |
V Off-site units created |
W SRM Off-site units created |
X Off-site unit change per gain site (pre-SRM) |
Y SRM |
Z Off-site unit change per gain site (post-SRM) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7 | =IFERROR(_xlfn.UNIQUE(_xlfn._xlws.FILTER(N7:N745,N7:N745<>0)),"") | =IF(O7="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O7,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O7="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O7,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O7="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O7,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O7="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O7,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O7="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O7,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O7="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O7,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O7="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O7,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O7="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O7,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O7="","",(V7+T7+R7)-P7) | =IF(ISBLANK(O7),"", IFERROR(_xlfn.XLOOKUP(O7,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O7,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O7="","", IF(X7<0,"Error - gain sites must be postive ▲", (W7+U7+S7)-Q7)) |
| 8 | =IF(O8="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O8,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O8="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O8,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O8="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O8,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O8="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O8,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O8="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O8,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O8="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O8,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O8="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O8,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O8="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O8,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O8="","",(V8+T8+R8)-P8) | =IF(ISBLANK(O8),"", IFERROR(_xlfn.XLOOKUP(O8,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O8,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O8="","", IF(X8<0,"Error - gain sites must be postive ▲", (W8+U8+S8)-Q8)) | |
| 9 | =IF(O9="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O9,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O9="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O9,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O9="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O9,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O9="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O9,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O9="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O9,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O9="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O9,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O9="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O9,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O9="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O9,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O9="","",(V9+T9+R9)-P9) | =IF(ISBLANK(O9),"", IFERROR(_xlfn.XLOOKUP(O9,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O9,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O9="","", IF(X9<0,"Error - gain sites must be postive ▲", (W9+U9+S9)-Q9)) | |
| 10 | =IF(O10="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O10,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O10="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O10,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O10="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O10,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O10="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O10,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O10="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O10,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O10="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O10,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O10="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O10,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O10="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O10,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O10="","",(V10+T10+R10)-P10) | =IF(ISBLANK(O10),"", IFERROR(_xlfn.XLOOKUP(O10,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O10,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O10="","", IF(X10,"Error - gain sites must be postive ▲", (W10+U10+S10)-Q10)) | |
| 11 | =IF(O11="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O11,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O11="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O11,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O11="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O11,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O11="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O11,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O11="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O11,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O11="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O11,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O11="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O11,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O11="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O11,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O11="","",(V11+T11+R11)-P11) | =IF(ISBLANK(O11),"", IFERROR(_xlfn.XLOOKUP(O11,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O11,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O11="","", IF(X11<0,"Error - gain sites must be postive ▲", (W11+U11+S11)-Q11)) | |
| 12 | =IF(O12="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O12,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O12="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O12,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O12="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O12,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O12="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O12,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O12="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O12,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O12="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O12,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O12="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O12,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O12="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O12,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O12="","",(V12+T12+R12)-P12) | =IF(ISBLANK(O12),"", IFERROR(_xlfn.XLOOKUP(O12,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O12,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O12="","", IF(X12<0,"Error - gain sites must be postive ▲", (W12+U12+S12)-Q12)) | |
| 13 | =IF(O13="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O13,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O13="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O13,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O13="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O13,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O13="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O13,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O13="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O13,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O13="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O13,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O13="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O13,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O13="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O13,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O13="","",(V13+T13+R13)-P13) | =IF(ISBLANK(O13),"", IFERROR(_xlfn.XLOOKUP(O13,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O13,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O13="","", IF(X13<0,"Error - gain sites must be postive ▲", (W13+U13+S13)-Q13)) | |
| 14 | =IF(O14="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O14,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O14="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O14,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O14="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O14,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O14="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O14,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O14="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O14,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O14="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O14,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O14="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O14,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O14="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O14,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O14="","",(V14+T14+R14)-P14) | =IF(ISBLANK(O14),"", IFERROR(_xlfn.XLOOKUP(O14,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O14,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O14="","", IF(X14<0,"Error - gain sites must be postive ▲", (W14+U14+S14)-Q14)) | |
| 15 | =IF(O15="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O15,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O15="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O15,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O15="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O15,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O15="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O15,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O15="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O15,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O15="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O15,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O15="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O15,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O15="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O15,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O15="","",(V15+T15+R15)-P15) | =IF(ISBLANK(O15),"", IFERROR(_xlfn.XLOOKUP(O15,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O15,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O15="","", IF(X15<0,"Error - gain sites must be postive ▲", (W15+U15+S15)-Q15)) | |
| 16 | =IF(O16="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O16,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O16="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O16,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O16="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O16,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O16="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O16,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O16="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O16,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O16="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O16,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O16="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O16,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O16="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O16,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O16="","",(V16+T16+R16)-P16) | =IF(ISBLANK(O16),"", IFERROR(_xlfn.XLOOKUP(O16,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O16,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O16="","", IF(X16<0,"Error - gain sites must be postive ▲", (W16+U16+S16)-Q16)) | |
| 17 | =IF(O17="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O17,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O17="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O17,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O17="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O17,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O17="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O17,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O17="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O17,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O17="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O17,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O17="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O17,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O17="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O17,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O17="","",(V17+T17+R17)-P17) | =IF(ISBLANK(O17),"", IFERROR(_xlfn.XLOOKUP(O17,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O17,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O17="","", IF(X17<0,"Error - gain sites must be postive ▲", (W17+U17+S17)-Q17)) | |
| 18 | =IF(O18="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O18,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O18="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O18,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O18="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O18,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O18="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O18,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O18="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O18,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O18="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O18,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O18="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O18,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O18="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O18,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O18="","",(V18+T18+R18)-P18) | =IF(ISBLANK(O18),"", IFERROR(_xlfn.XLOOKUP(O18,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O18,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O18="","", IF(X18<0,"Error - gain sites must be postive ▲", (W18+U18+S18)-Q18)) | |
| 19 | =IF(O19="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O19,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O19="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O19,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O19="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O19,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O19="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O19,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O19="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O19,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O19="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O19,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O19="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O19,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O19="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O19,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O19="","",(V19+T19+R19)-P19) | =IF(ISBLANK(O19),"", IFERROR(_xlfn.XLOOKUP(O19,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O19,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O19="","", IF(X19<0,"Error - gain sites must be postive ▲", (W19+U19+S19)-Q19)) | |
| 20 | =IF(O20="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O20,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O20="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O20,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O20="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O20,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O20="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O20,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O20="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O20,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O20="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O20,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O20="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O20,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O20="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O20,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O20="","",(V20+T20+R20)-P20) | =IF(ISBLANK(O20),"", IFERROR(_xlfn.XLOOKUP(O20,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O20,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O20="","", IF(X20,"Error - gain sites must be postive ▲", (W20+U20+S20)-Q20)) | |
| 21 | =IF(O21="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O21,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O21="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O21,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O21="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O21,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O21="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O21,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O21="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O21,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O21="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O21,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O21="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O21,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O21="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O21,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O21="","",(V21+T21+R21)-P21) | =IF(ISBLANK(O21),"", IFERROR(_xlfn.XLOOKUP(O21,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O21,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O21="","", IF(X21<0,"Error - gain sites must be postive ▲", (W21+U21+S21)-Q21)) | |
| 22 | =IF(O22="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O22,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O22="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O22,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O22="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O22,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O22="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O22,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O22="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O22,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O22="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O22,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O22="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O22,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O22="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O22,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O22="","",(V22+T22+R22)-P22) | =IF(ISBLANK(O22),"", IFERROR(_xlfn.XLOOKUP(O22,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O22,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O22="","", IF(X22<0,"Error - gain sites must be postive ▲", (W22+U22+S22)-Q22)) | |
| 23 | =IF(O23="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O23,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O23="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O23,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O23="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O23,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O23="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O23,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O23="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O23,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O23="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O23,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O23="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O23,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O23="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O23,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O23="","",(V23+T23+R23)-P23) | =IF(ISBLANK(O23),"", IFERROR(_xlfn.XLOOKUP(O23,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O23,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O23="","", IF(X23<0,"Error - gain sites must be postive ▲", (W23+U23+S23)-Q23)) | |
| 24 | =IF(O24="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O24,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O24="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O24,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O24="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O24,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O24="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O24,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O24="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O24,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O24="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O24,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O24="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O24,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O24="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O24,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O24="","",(V24+T24+R24)-P24) | =IF(ISBLANK(O24),"", IFERROR(_xlfn.XLOOKUP(O24,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O24,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O24="","", IF(X24<0,"Error - gain sites must be postive ▲", (W24+U24+S24)-Q24)) | |
| 25 | =IF(O25="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O25,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O25="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O25,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O25="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O25,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O25="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O25,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O25="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O25,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O25="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O25,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O25="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O25,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O25="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O25,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O25="","",(V25+T25+R25)-P25) | =IF(ISBLANK(O25),"", IFERROR(_xlfn.XLOOKUP(O25,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O25,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O25="","", IF(X25<0,"Error - gain sites must be postive ▲", (W25+U25+S25)-Q25)) | |
| 26 | =IF(O26="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O26,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O26="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O26,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O26="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O26,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O26="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O26,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O26="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O26,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O26="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O26,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O26="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O26,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O26="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O26,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O26="","",(V26+T26+R26)-P26) | =IF(ISBLANK(O26),"", IFERROR(_xlfn.XLOOKUP(O26,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O26,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O26="","", IF(X26<0,"Error - gain sites must be postive ▲", (W26+U26+S26)-Q26)) | |
| 27 | =IF(O27="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O27,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O27="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O27,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O27="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O27,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O27="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O27,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O27="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O27,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O27="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O27,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O27="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O27,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O27="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O27,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O27="","",(V27+T27+R27)-P27) | =IF(ISBLANK(O27),"", IFERROR(_xlfn.XLOOKUP(O27,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O27,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O27="","", IF(X27<0,"Error - gain sites must be postive ▲", (W27+U27+S27)-Q27)) | |
| 28 | =IF(O28="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O28,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O28="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O28,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O28="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O28,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O28="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O28,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O28="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O28,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O28="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O28,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O28="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O28,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O28="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O28,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O28="","",(V28+T28+R28)-P28) | =IF(ISBLANK(O28),"", IFERROR(_xlfn.XLOOKUP(O28,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O28,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O28="","", IF(X28<0,"Error - gain sites must be postive ▲", (W28+U28+S28)-Q28)) | |
| 29 | =IF(O29="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O29,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O29="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O29,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O29="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O29,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O29="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O29,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O29="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O29,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O29="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O29,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O29="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O29,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O29="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O29,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O29="","",(V29+T29+R29)-P29) | =IF(ISBLANK(O29),"", IFERROR(_xlfn.XLOOKUP(O29,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O29,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O29="","", IF(X29<0,"Error - gain sites must be postive ▲", (W29+U29+S29)-Q29)) | |
| 30 | =IF(O30="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O30,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O30="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O30,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O30="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O30,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O30="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O30,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O30="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O30,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O30="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O30,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O30="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O30,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O30="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O30,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O30="","",(V30+T30+R30)-P30) | =IF(ISBLANK(O30),"", IFERROR(_xlfn.XLOOKUP(O30,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O30,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O30="","", IF(X30,"Error - gain sites must be postive ▲", (W30+U30+S30)-Q30)) | |
| 31 | =IF(O31="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O31,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O31="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O31,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O31="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O31,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O31="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O31,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O31="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O31,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O31="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O31,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O31="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O31,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O31="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O31,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O31="","",(V31+T31+R31)-P31) | =IF(ISBLANK(O31),"", IFERROR(_xlfn.XLOOKUP(O31,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O31,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O31="","", IF(X31<0,"Error - gain sites must be postive ▲", (W31+U31+S31)-Q31)) | |
| 32 | =IF(O32="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O32,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O32="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O32,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O32="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O32,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O32="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O32,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O32="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O32,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O32="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O32,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O32="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O32,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O32="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O32,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O32="","",(V32+T32+R32)-P32) | =IF(ISBLANK(O32),"", IFERROR(_xlfn.XLOOKUP(O32,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O32,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O32="","", IF(X32<0,"Error - gain sites must be postive ▲", (W32+U32+S32)-Q32)) | |
| 33 | =IF(O33="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O33,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O33="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O33,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O33="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O33,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O33="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O33,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O33="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O33,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O33="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O33,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O33="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O33,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O33="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O33,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O33="","",(V33+T33+R33)-P33) | =IF(ISBLANK(O33),"", IFERROR(_xlfn.XLOOKUP(O33,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O33,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O33="","", IF(X33<0,"Error - gain sites must be postive ▲", (W33+U33+S33)-Q33)) | |
| 34 | =IF(O34="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O34,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O34="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O34,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O34="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O34,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O34="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O34,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O34="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O34,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O34="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O34,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O34="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O34,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O34="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O34,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O34="","",(V34+T34+R34)-P34) | =IF(ISBLANK(O34),"", IFERROR(_xlfn.XLOOKUP(O34,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O34,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O34="","", IF(X34<0,"Error - gain sites must be postive ▲", (W34+U34+S34)-Q34)) | |
| 35 | =IF(O35="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O35,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O35="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O35,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O35="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O35,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O35="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O35,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O35="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O35,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O35="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O35,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O35="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O35,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O35="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O35,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O35="","",(V35+T35+R35)-P35) | =IF(ISBLANK(O35),"", IFERROR(_xlfn.XLOOKUP(O35,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O35,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O35="","", IF(X35<0,"Error - gain sites must be postive ▲", (W35+U35+S35)-Q35)) | |
| 36 | =IF(O36="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O36,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O36="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O36,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O36="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O36,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O36="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O36,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O36="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O36,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O36="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O36,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O36="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O36,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O36="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O36,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O36="","",(V36+T36+R36)-P36) | =IF(ISBLANK(O36),"", IFERROR(_xlfn.XLOOKUP(O36,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O36,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O36="","", IF(X36<0,"Error - gain sites must be postive ▲", (W36+U36+S36)-Q36)) | |
| 37 | =IF(O37="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O37,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O37="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O37,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O37="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O37,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O37="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O37,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O37="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O37,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O37="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O37,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O37="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O37,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O37="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O37,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O37="","",(V37+T37+R37)-P37) | =IF(ISBLANK(O37),"", IFERROR(_xlfn.XLOOKUP(O37,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O37,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O37="","", IF(X37<0,"Error - gain sites must be postive ▲", (W37+U37+S37)-Q37)) | |
| 38 | =IF(O38="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O38,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O38="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O38,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O38="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O38,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O38="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O38,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O38="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O38,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O38="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O38,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O38="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O38,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O38="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O38,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O38="","",(V38+T38+R38)-P38) | =IF(ISBLANK(O38),"", IFERROR(_xlfn.XLOOKUP(O38,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O38,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O38="","", IF(X38<0,"Error - gain sites must be postive ▲", (W38+U38+S38)-Q38)) | |
| 39 | =IF(O39="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O39,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O39="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O39,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O39="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O39,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O39="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O39,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O39="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O39,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O39="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O39,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O39="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O39,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O39="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O39,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O39="","",(V39+T39+R39)-P39) | =IF(ISBLANK(O39),"", IFERROR(_xlfn.XLOOKUP(O39,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O39,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O39="","", IF(X39<0,"Error - gain sites must be postive ▲", (W39+U39+S39)-Q39)) | |
| 40 | =IF(O40="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O40,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O40="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O40,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O40="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O40,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O40="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O40,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O40="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O40,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O40="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O40,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O40="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O40,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O40="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O40,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O40="","",(V40+T40+R40)-P40) | =IF(ISBLANK(O40),"", IFERROR(_xlfn.XLOOKUP(O40,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O40,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O40="","", IF(X40,"Error - gain sites must be postive ▲", (W40+U40+S40)-Q40)) | |
| 41 | =IF(O41="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O41,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O41="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O41,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O41="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O41,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O41="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O41,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O41="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O41,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O41="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O41,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O41="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O41,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O41="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O41,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O41="","",(V41+T41+R41)-P41) | =IF(ISBLANK(O41),"", IFERROR(_xlfn.XLOOKUP(O41,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O41,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O41="","", IF(X41<0,"Error - gain sites must be postive ▲", (W41+U41+S41)-Q41)) | |
| 42 | =IF(O42="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O42,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O42="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O42,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O42="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O42,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O42="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O42,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O42="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O42,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O42="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O42,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O42="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O42,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O42="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O42,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O42="","",(V42+T42+R42)-P42) | =IF(ISBLANK(O42),"", IFERROR(_xlfn.XLOOKUP(O42,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O42,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O42="","", IF(X42<0,"Error - gain sites must be postive ▲", (W42+U42+S42)-Q42)) | |
| 43 | =IF(O43="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O43,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O43="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O43,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O43="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O43,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O43="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O43,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O43="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O43,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O43="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O43,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O43="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O43,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O43="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O43,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O43="","",(V43+T43+R43)-P43) | =IF(ISBLANK(O43),"", IFERROR(_xlfn.XLOOKUP(O43,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O43,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O43="","", IF(X43<0,"Error - gain sites must be postive ▲", (W43+U43+S43)-Q43)) | |
| 44 | =IF(O44="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O44,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O44="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O44,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O44="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O44,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O44="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O44,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O44="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O44,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O44="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O44,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O44="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O44,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O44="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O44,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O44="","",(V44+T44+R44)-P44) | =IF(ISBLANK(O44),"", IFERROR(_xlfn.XLOOKUP(O44,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O44,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O44="","", IF(X44<0,"Error - gain sites must be postive ▲", (W44+U44+S44)-Q44)) | |
| 45 | =IF(O45="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O45,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O45="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O45,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O45="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O45,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O45="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O45,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O45="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O45,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O45="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O45,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O45="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O45,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O45="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O45,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O45="","",(V45+T45+R45)-P45) | =IF(ISBLANK(O45),"", IFERROR(_xlfn.XLOOKUP(O45,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O45,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O45="","", IF(X45<0,"Error - gain sites must be postive ▲", (W45+U45+S45)-Q45)) | |
| 46 | =IF(O46="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O46,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O46="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O46,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O46="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O46,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O46="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O46,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O46="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O46,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O46="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O46,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O46="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O46,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O46="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O46,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O46="","",(V46+T46+R46)-P46) | =IF(ISBLANK(O46),"", IFERROR(_xlfn.XLOOKUP(O46,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O46,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O46="","", IF(X46<0,"Error - gain sites must be postive ▲", (W46+U46+S46)-Q46)) | |
| 47 | =IF(O47="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O47,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O47="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O47,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O47="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O47,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O47="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O47,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O47="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O47,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O47="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O47,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O47="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O47,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O47="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O47,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O47="","",(V47+T47+R47)-P47) | =IF(ISBLANK(O47),"", IFERROR(_xlfn.XLOOKUP(O47,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O47,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O47="","", IF(X47<0,"Error - gain sites must be postive ▲", (W47+U47+S47)-Q47)) | |
| 48 | =IF(O48="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O48,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O48="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O48,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O48="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O48,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O48="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O48,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O48="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O48,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O48="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O48,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O48="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O48,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O48="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O48,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O48="","",(V48+T48+R48)-P48) | =IF(ISBLANK(O48),"", IFERROR(_xlfn.XLOOKUP(O48,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O48,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O48="","", IF(X48<0,"Error - gain sites must be postive ▲", (W48+U48+S48)-Q48)) | |
| 49 | =IF(O49="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O49,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O49="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O49,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O49="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O49,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O49="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O49,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O49="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O49,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O49="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O49,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O49="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O49,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O49="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O49,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O49="","",(V49+T49+R49)-P49) | =IF(ISBLANK(O49),"", IFERROR(_xlfn.XLOOKUP(O49,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O49,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O49="","", IF(X49<0,"Error - gain sites must be postive ▲", (W49+U49+S49)-Q49)) | |
| 50 | =IF(O50="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O50,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O50="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O50,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O50="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O50,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O50="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O50,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O50="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O50,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O50="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O50,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O50="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O50,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O50="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O50,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O50="","",(V50+T50+R50)-P50) | =IF(ISBLANK(O50),"", IFERROR(_xlfn.XLOOKUP(O50,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O50,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O50="","", IF(X50,"Error - gain sites must be postive ▲", (W50+U50+S50)-Q50)) | |
| 51 | =IF(O51="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O51,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O51="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O51,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O51="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O51,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O51="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O51,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O51="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O51,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O51="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O51,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O51="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O51,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O51="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O51,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O51="","",(V51+T51+R51)-P51) | =IF(ISBLANK(O51),"", IFERROR(_xlfn.XLOOKUP(O51,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O51,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O51="","", IF(X51<0,"Error - gain sites must be postive ▲", (W51+U51+S51)-Q51)) | |
| 52 | =IF(O52="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O52,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O52="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O52,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O52="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O52,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O52="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O52,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O52="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O52,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O52="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O52,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O52="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O52,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O52="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O52,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O52="","",(V52+T52+R52)-P52) | =IF(ISBLANK(O52),"", IFERROR(_xlfn.XLOOKUP(O52,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O52,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O52="","", IF(X52<0,"Error - gain sites must be postive ▲", (W52+U52+S52)-Q52)) | |
| 53 | =IF(O53="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O53,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O53="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O53,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O53="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O53,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O53="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O53,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O53="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O53,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O53="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O53,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O53="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O53,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O53="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O53,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O53="","",(V53+T53+R53)-P53) | =IF(ISBLANK(O53),"", IFERROR(_xlfn.XLOOKUP(O53,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O53,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O53="","", IF(X53<0,"Error - gain sites must be postive ▲", (W53+U53+S53)-Q53)) | |
| 54 | =IF(O54="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O54,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O54="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O54,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O54="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O54,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O54="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O54,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O54="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O54,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O54="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O54,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O54="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O54,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O54="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O54,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O54="","",(V54+T54+R54)-P54) | =IF(ISBLANK(O54),"", IFERROR(_xlfn.XLOOKUP(O54,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O54,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O54="","", IF(X54<0,"Error - gain sites must be postive ▲", (W54+U54+S54)-Q54)) | |
| 55 | =IF(O55="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O55,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O55="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O55,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O55="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O55,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O55="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O55,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O55="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O55,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O55="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O55,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O55="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O55,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O55="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O55,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O55="","",(V55+T55+R55)-P55) | =IF(ISBLANK(O55),"", IFERROR(_xlfn.XLOOKUP(O55,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O55,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O55="","", IF(X55<0,"Error - gain sites must be postive ▲", (W55+U55+S55)-Q55)) | |
| 56 | =IF(O56="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O56,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O56="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O56,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O56="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O56,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O56="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O56,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O56="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O56,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O56="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O56,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O56="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O56,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O56="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O56,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O56="","",(V56+T56+R56)-P56) | =IF(ISBLANK(O56),"", IFERROR(_xlfn.XLOOKUP(O56,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O56,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O56="","", IF(X56<0,"Error - gain sites must be postive ▲", (W56+U56+S56)-Q56)) | |
| 57 | =IF(O57="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O57,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O57="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O57,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O57="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O57,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O57="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O57,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O57="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O57,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O57="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O57,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O57="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O57,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O57="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O57,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O57="","",(V57+T57+R57)-P57) | =IF(ISBLANK(O57),"", IFERROR(_xlfn.XLOOKUP(O57,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O57,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O57="","", IF(X57<0,"Error - gain sites must be postive ▲", (W57+U57+S57)-Q57)) | |
| 58 | =IF(O58="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O58,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O58="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O58,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O58="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O58,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O58="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O58,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O58="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O58,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O58="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O58,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O58="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O58,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O58="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O58,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O58="","",(V58+T58+R58)-P58) | =IF(ISBLANK(O58),"", IFERROR(_xlfn.XLOOKUP(O58,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O58,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O58="","", IF(X58<0,"Error - gain sites must be postive ▲", (W58+U58+S58)-Q58)) | |
| 59 | =IF(O59="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O59,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O59="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O59,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O59="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O59,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O59="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O59,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O59="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O59,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O59="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O59,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O59="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O59,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O59="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O59,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O59="","",(V59+T59+R59)-P59) | =IF(ISBLANK(O59),"", IFERROR(_xlfn.XLOOKUP(O59,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O59,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O59="","", IF(X59<0,"Error - gain sites must be postive ▲", (W59+U59+S59)-Q59)) | |
| 60 | =IF(O60="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O60,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O60="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O60,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O60="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O60,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O60="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O60,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O60="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O60,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O60="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O60,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O60="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O60,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O60="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O60,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O60="","",(V60+T60+R60)-P60) | =IF(ISBLANK(O60),"", IFERROR(_xlfn.XLOOKUP(O60,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O60,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O60="","", IF(X60,"Error - gain sites must be postive ▲", (W60+U60+S60)-Q60)) | |
| 61 | =IF(O61="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O61,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O61="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O61,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O61="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O61,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O61="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O61,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O61="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O61,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O61="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O61,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O61="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O61,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O61="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O61,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O61="","",(V61+T61+R61)-P61) | =IF(ISBLANK(O61),"", IFERROR(_xlfn.XLOOKUP(O61,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O61,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O61="","", IF(X61<0,"Error - gain sites must be postive ▲", (W61+U61+S61)-Q61)) | |
| 62 | =IF(O62="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O62,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O62="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O62,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O62="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O62,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O62="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O62,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O62="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O62,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O62="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O62,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O62="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O62,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O62="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O62,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O62="","",(V62+T62+R62)-P62) | =IF(ISBLANK(O62),"", IFERROR(_xlfn.XLOOKUP(O62,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O62,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O62="","", IF(X62<0,"Error - gain sites must be postive ▲", (W62+U62+S62)-Q62)) | |
| 63 | =IF(O63="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O63,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O63="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O63,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O63="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O63,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O63="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O63,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O63="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O63,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O63="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O63,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O63="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O63,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O63="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O63,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O63="","",(V63+T63+R63)-P63) | =IF(ISBLANK(O63),"", IFERROR(_xlfn.XLOOKUP(O63,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O63,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O63="","", IF(X63<0,"Error - gain sites must be postive ▲", (W63+U63+S63)-Q63)) | |
| 64 | =IF(O64="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O64,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O64="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O64,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O64="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O64,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O64="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O64,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O64="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O64,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O64="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O64,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O64="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O64,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O64="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O64,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O64="","",(V64+T64+R64)-P64) | =IF(ISBLANK(O64),"", IFERROR(_xlfn.XLOOKUP(O64,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O64,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O64="","", IF(X64<0,"Error - gain sites must be postive ▲", (W64+U64+S64)-Q64)) | |
| 65 | =IF(O65="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O65,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O65="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O65,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O65="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O65,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O65="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O65,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O65="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O65,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O65="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O65,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O65="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O65,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O65="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O65,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O65="","",(V65+T65+R65)-P65) | =IF(ISBLANK(O65),"", IFERROR(_xlfn.XLOOKUP(O65,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O65,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O65="","", IF(X65<0,"Error - gain sites must be postive ▲", (W65+U65+S65)-Q65)) | |
| 66 | =IF(O66="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O66,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O66="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O66,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O66="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O66,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O66="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O66,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O66="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O66,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O66="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O66,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O66="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O66,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O66="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O66,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O66="","",(V66+T66+R66)-P66) | =IF(ISBLANK(O66),"", IFERROR(_xlfn.XLOOKUP(O66,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O66,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O66="","", IF(X66<0,"Error - gain sites must be postive ▲", (W66+U66+S66)-Q66)) | |
| 67 | =IF(O67="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O67,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O67="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O67,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O67="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O67,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O67="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O67,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O67="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O67,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O67="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O67,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O67="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O67,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O67="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O67,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O67="","",(V67+T67+R67)-P67) | =IF(ISBLANK(O67),"", IFERROR(_xlfn.XLOOKUP(O67,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O67,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O67="","", IF(X67<0,"Error - gain sites must be postive ▲", (W67+U67+S67)-Q67)) | |
| 68 | =IF(O68="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O68,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O68="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O68,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O68="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O68,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O68="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O68,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O68="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O68,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O68="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O68,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O68="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O68,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O68="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O68,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O68="","",(V68+T68+R68)-P68) | =IF(ISBLANK(O68),"", IFERROR(_xlfn.XLOOKUP(O68,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O68,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O68="","", IF(X68<0,"Error - gain sites must be postive ▲", (W68+U68+S68)-Q68)) | |
| 69 | =IF(O69="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O69,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O69="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O69,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O69="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O69,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O69="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O69,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O69="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O69,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O69="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O69,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O69="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O69,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O69="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O69,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O69="","",(V69+T69+R69)-P69) | =IF(ISBLANK(O69),"", IFERROR(_xlfn.XLOOKUP(O69,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O69,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O69="","", IF(X69<0,"Error - gain sites must be postive ▲", (W69+U69+S69)-Q69)) | |
| 70 | =IF(O70="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O70,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O70="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O70,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O70="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O70,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O70="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O70,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O70="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O70,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O70="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O70,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O70="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O70,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O70="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O70,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O70="","",(V70+T70+R70)-P70) | =IF(ISBLANK(O70),"", IFERROR(_xlfn.XLOOKUP(O70,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O70,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O70="","", IF(X70,"Error - gain sites must be postive ▲", (W70+U70+S70)-Q70)) | |
| 71 | =IF(O71="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O71,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O71="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O71,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O71="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O71,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O71="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O71,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O71="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O71,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O71="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O71,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O71="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O71,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O71="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O71,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O71="","",(V71+T71+R71)-P71) | =IF(ISBLANK(O71),"", IFERROR(_xlfn.XLOOKUP(O71,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O71,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O71="","", IF(X71<0,"Error - gain sites must be postive ▲", (W71+U71+S71)-Q71)) | |
| 72 | =IF(O72="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O72,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O72="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O72,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O72="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O72,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O72="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O72,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O72="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O72,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O72="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O72,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O72="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O72,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O72="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O72,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O72="","",(V72+T72+R72)-P72) | =IF(ISBLANK(O72),"", IFERROR(_xlfn.XLOOKUP(O72,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O72,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O72="","", IF(X72<0,"Error - gain sites must be postive ▲", (W72+U72+S72)-Q72)) | |
| 73 | =IF(O73="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O73,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O73="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O73,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O73="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O73,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O73="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O73,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O73="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O73,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O73="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O73,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O73="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O73,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O73="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O73,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O73="","",(V73+T73+R73)-P73) | =IF(ISBLANK(O73),"", IFERROR(_xlfn.XLOOKUP(O73,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O73,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O73="","", IF(X73<0,"Error - gain sites must be postive ▲", (W73+U73+S73)-Q73)) | |
| 74 | =IF(O74="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O74,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O74="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O74,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O74="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O74,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O74="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O74,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O74="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O74,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O74="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O74,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O74="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O74,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O74="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O74,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O74="","",(V74+T74+R74)-P74) | =IF(ISBLANK(O74),"", IFERROR(_xlfn.XLOOKUP(O74,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O74,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O74="","", IF(X74<0,"Error - gain sites must be postive ▲", (W74+U74+S74)-Q74)) | |
| 75 | =IF(O75="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O75,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O75="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O75,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O75="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O75,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O75="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O75,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O75="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O75,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O75="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O75,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O75="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O75,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O75="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O75,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O75="","",(V75+T75+R75)-P75) | =IF(ISBLANK(O75),"", IFERROR(_xlfn.XLOOKUP(O75,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O75,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O75="","", IF(X75<0,"Error - gain sites must be postive ▲", (W75+U75+S75)-Q75)) | |
| 76 | =IF(O76="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O76,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O76="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O76,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O76="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O76,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O76="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O76,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O76="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O76,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O76="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O76,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O76="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O76,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O76="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O76,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O76="","",(V76+T76+R76)-P76) | =IF(ISBLANK(O76),"", IFERROR(_xlfn.XLOOKUP(O76,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O76,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O76="","", IF(X76<0,"Error - gain sites must be postive ▲", (W76+U76+S76)-Q76)) | |
| 77 | =IF(O77="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O77,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O77="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O77,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O77="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O77,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O77="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O77,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O77="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O77,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O77="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O77,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O77="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O77,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O77="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O77,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O77="","",(V77+T77+R77)-P77) | =IF(ISBLANK(O77),"", IFERROR(_xlfn.XLOOKUP(O77,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O77,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O77="","", IF(X77<0,"Error - gain sites must be postive ▲", (W77+U77+S77)-Q77)) | |
| 78 | =IF(O78="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O78,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O78="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O78,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O78="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O78,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O78="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O78,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O78="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O78,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O78="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O78,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O78="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O78,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O78="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O78,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O78="","",(V78+T78+R78)-P78) | =IF(ISBLANK(O78),"", IFERROR(_xlfn.XLOOKUP(O78,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O78,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O78="","", IF(X78<0,"Error - gain sites must be postive ▲", (W78+U78+S78)-Q78)) | |
| 79 | =IF(O79="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O79,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O79="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O79,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O79="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O79,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O79="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O79,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O79="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O79,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O79="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O79,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O79="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O79,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O79="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O79,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O79="","",(V79+T79+R79)-P79) | =IF(ISBLANK(O79),"", IFERROR(_xlfn.XLOOKUP(O79,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O79,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O79="","", IF(X79<0,"Error - gain sites must be postive ▲", (W79+U79+S79)-Q79)) | |
| 80 | =IF(O80="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O80,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O80="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O80,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O80="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O80,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O80="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O80,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O80="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O80,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O80="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O80,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O80="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O80,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O80="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O80,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O80="","",(V80+T80+R80)-P80) | =IF(ISBLANK(O80),"", IFERROR(_xlfn.XLOOKUP(O80,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O80,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O80="","", IF(X80,"Error - gain sites must be postive ▲", (W80+U80+S80)-Q80)) | |
| 81 | =IF(O81="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O81,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O81="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O81,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O81="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O81,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O81="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O81,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O81="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O81,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O81="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O81,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O81="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O81,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O81="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O81,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O81="","",(V81+T81+R81)-P81) | =IF(ISBLANK(O81),"", IFERROR(_xlfn.XLOOKUP(O81,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O81,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O81="","", IF(X81<0,"Error - gain sites must be postive ▲", (W81+U81+S81)-Q81)) | |
| 82 | =IF(O82="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O82,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O82="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O82,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O82="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O82,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O82="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O82,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O82="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O82,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O82="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O82,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O82="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O82,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O82="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O82,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O82="","",(V82+T82+R82)-P82) | =IF(ISBLANK(O82),"", IFERROR(_xlfn.XLOOKUP(O82,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O82,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O82="","", IF(X82<0,"Error - gain sites must be postive ▲", (W82+U82+S82)-Q82)) | |
| 83 | =IF(O83="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O83,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O83="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O83,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O83="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O83,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O83="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O83,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O83="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O83,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O83="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O83,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O83="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O83,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O83="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O83,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O83="","",(V83+T83+R83)-P83) | =IF(ISBLANK(O83),"", IFERROR(_xlfn.XLOOKUP(O83,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O83,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O83="","", IF(X83<0,"Error - gain sites must be postive ▲", (W83+U83+S83)-Q83)) | |
| 84 | =IF(O84="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O84,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O84="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O84,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O84="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O84,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O84="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O84,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O84="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O84,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O84="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O84,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O84="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O84,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O84="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O84,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O84="","",(V84+T84+R84)-P84) | =IF(ISBLANK(O84),"", IFERROR(_xlfn.XLOOKUP(O84,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O84,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O84="","", IF(X84<0,"Error - gain sites must be postive ▲", (W84+U84+S84)-Q84)) | |
| 85 | =IF(O85="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O85,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O85="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O85,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O85="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O85,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O85="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O85,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O85="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O85,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O85="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O85,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O85="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O85,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O85="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O85,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O85="","",(V85+T85+R85)-P85) | =IF(ISBLANK(O85),"", IFERROR(_xlfn.XLOOKUP(O85,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O85,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O85="","", IF(X85<0,"Error - gain sites must be postive ▲", (W85+U85+S85)-Q85)) | |
| 86 | =IF(O86="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O86,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O86="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O86,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O86="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O86,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O86="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O86,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O86="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O86,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O86="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O86,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O86="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O86,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O86="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O86,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O86="","",(V86+T86+R86)-P86) | =IF(ISBLANK(O86),"", IFERROR(_xlfn.XLOOKUP(O86,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O86,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O86="","", IF(X86<0,"Error - gain sites must be postive ▲", (W86+U86+S86)-Q86)) | |
| 87 | =IF(O87="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O87,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O87="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O87,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O87="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O87,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O87="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O87,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O87="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O87,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O87="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O87,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O87="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O87,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O87="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O87,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O87="","",(V87+T87+R87)-P87) | =IF(ISBLANK(O87),"", IFERROR(_xlfn.XLOOKUP(O87,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O87,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O87="","", IF(X87<0,"Error - gain sites must be postive ▲", (W87+U87+S87)-Q87)) | |
| 88 | =IF(O88="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O88,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O88="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O88,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O88="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O88,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O88="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O88,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O88="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O88,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O88="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O88,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O88="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O88,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O88="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O88,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O88="","",(V88+T88+R88)-P88) | =IF(ISBLANK(O88),"", IFERROR(_xlfn.XLOOKUP(O88,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O88,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O88="","", IF(X88<0,"Error - gain sites must be postive ▲", (W88+U88+S88)-Q88)) | |
| 89 | =IF(O89="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O89,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O89="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O89,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O89="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O89,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O89="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O89,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O89="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O89,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O89="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O89,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O89="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O89,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O89="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O89,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O89="","",(V89+T89+R89)-P89) | =IF(ISBLANK(O89),"", IFERROR(_xlfn.XLOOKUP(O89,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O89,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O89="","", IF(X89<0,"Error - gain sites must be postive ▲", (W89+U89+S89)-Q89)) | |
| 90 | =IF(O90="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O90,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O90="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O90,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O90="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O90,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O90="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O90,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O90="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O90,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O90="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O90,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O90="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O90,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O90="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O90,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O90="","",(V90+T90+R90)-P90) | =IF(ISBLANK(O90),"", IFERROR(_xlfn.XLOOKUP(O90,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O90,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O90="","", IF(X90,"Error - gain sites must be postive ▲", (W90+U90+S90)-Q90)) | |
| 91 | =IF(O91="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O91,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O91="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O91,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O91="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O91,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O91="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O91,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O91="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O91,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O91="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O91,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O91="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O91,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O91="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O91,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O91="","",(V91+T91+R91)-P91) | =IF(ISBLANK(O91),"", IFERROR(_xlfn.XLOOKUP(O91,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O91,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O91="","", IF(X91<0,"Error - gain sites must be postive ▲", (W91+U91+S91)-Q91)) | |
| 92 | =IF(O92="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O92,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O92="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O92,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O92="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O92,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O92="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O92,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O92="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O92,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O92="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O92,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O92="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O92,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O92="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O92,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O92="","",(V92+T92+R92)-P92) | =IF(ISBLANK(O92),"", IFERROR(_xlfn.XLOOKUP(O92,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O92,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O92="","", IF(X92<0,"Error - gain sites must be postive ▲", (W92+U92+S92)-Q92)) | |
| 93 | =IF(O93="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O93,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O93="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O93,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O93="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O93,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O93="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O93,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O93="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O93,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O93="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O93,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O93="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O93,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O93="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O93,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O93="","",(V93+T93+R93)-P93) | =IF(ISBLANK(O93),"", IFERROR(_xlfn.XLOOKUP(O93,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O93,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O93="","", IF(X93<0,"Error - gain sites must be postive ▲", (W93+U93+S93)-Q93)) | |
| 94 | =IF(O94="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O94,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O94="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O94,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O94="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O94,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O94="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O94,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O94="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O94,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O94="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O94,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O94="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O94,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O94="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O94,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O94="","",(V94+T94+R94)-P94) | =IF(ISBLANK(O94),"", IFERROR(_xlfn.XLOOKUP(O94,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O94,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O94="","", IF(X94<0,"Error - gain sites must be postive ▲", (W94+U94+S94)-Q94)) | |
| 95 | =IF(O95="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O95,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O95="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O95,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O95="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O95,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O95="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O95,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O95="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O95,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O95="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O95,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O95="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O95,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O95="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O95,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O95="","",(V95+T95+R95)-P95) | =IF(ISBLANK(O95),"", IFERROR(_xlfn.XLOOKUP(O95,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O95,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O95="","", IF(X95<0,"Error - gain sites must be postive ▲", (W95+U95+S95)-Q95)) | |
| 96 | =IF(O96="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O96,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O96="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O96,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O96="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O96,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O96="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O96,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O96="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O96,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O96="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O96,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O96="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O96,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O96="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O96,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O96="","",(V96+T96+R96)-P96) | =IF(ISBLANK(O96),"", IFERROR(_xlfn.XLOOKUP(O96,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O96,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O96="","", IF(X96<0,"Error - gain sites must be postive ▲", (W96+U96+S96)-Q96)) | |
| 97 | =IF(O97="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O97,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O97="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O97,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O97="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O97,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O97="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O97,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O97="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O97,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O97="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O97,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O97="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O97,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O97="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O97,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O97="","",(V97+T97+R97)-P97) | =IF(ISBLANK(O97),"", IFERROR(_xlfn.XLOOKUP(O97,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O97,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O97="","", IF(X97<0,"Error - gain sites must be postive ▲", (W97+U97+S97)-Q97)) | |
| 98 | =IF(O98="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O98,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O98="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O98,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O98="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O98,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O98="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O98,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O98="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O98,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O98="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O98,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O98="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O98,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O98="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O98,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O98="","",(V98+T98+R98)-P98) | =IF(ISBLANK(O98),"", IFERROR(_xlfn.XLOOKUP(O98,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O98,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O98="","", IF(X98<0,"Error - gain sites must be postive ▲", (W98+U98+S98)-Q98)) | |
| 99 | =IF(O99="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O99,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O99="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O99,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O99="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O99,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O99="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O99,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O99="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O99,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O99="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O99,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O99="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O99,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O99="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O99,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O99="","",(V99+T99+R99)-P99) | =IF(ISBLANK(O99),"", IFERROR(_xlfn.XLOOKUP(O99,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O99,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O99="","", IF(X99<0,"Error - gain sites must be postive ▲", (W99+U99+S99)-Q99)) | |
| 100 | =IF(O100="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O100,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O100="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O100,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O100="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O100,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O100="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O100,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O100="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O100,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O100="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O100,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O100="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O100,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O100="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O100,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O100="","",(V100+T100+R100)-P100) | =IF(ISBLANK(O100),"", IFERROR(_xlfn.XLOOKUP(O100,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O100,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O100="","", IF(X100,"Error - gain sites must be postive ▲", (W100+U100+S100)-Q100)) | |
| 101 | =IF(O101="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O101,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O101="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O101,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O101="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O101,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O101="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O101,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O101="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O101,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O101="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O101,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O101="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O101,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O101="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O101,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O101="","",(V101+T101+R101)-P101) | =IF(ISBLANK(O101),"", IFERROR(_xlfn.XLOOKUP(O101,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O101,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O101="","", IF(X101<0,"Error - gain sites must be postive ▲", (W101+U101+S101)-Q101)) | |
| 102 | =IF(O102="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O102,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O102="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O102,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O102="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O102,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O102="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O102,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O102="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O102,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O102="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O102,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O102="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O102,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O102="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O102,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O102="","",(V102+T102+R102)-P102) | =IF(ISBLANK(O102),"", IFERROR(_xlfn.XLOOKUP(O102,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O102,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O102="","", IF(X102<0,"Error - gain sites must be postive ▲", (W102+U102+S102)-Q102)) | |
| 103 | =IF(O103="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O103,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O103="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O103,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O103="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O103,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O103="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O103,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O103="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O103,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O103="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O103,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O103="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O103,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O103="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O103,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O103="","",(V103+T103+R103)-P103) | =IF(ISBLANK(O103),"", IFERROR(_xlfn.XLOOKUP(O103,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O103,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O103="","", IF(X103<0,"Error - gain sites must be postive ▲", (W103+U103+S103)-Q103)) | |
| 104 | =IF(O104="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O104,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O104="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O104,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O104="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O104,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O104="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O104,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O104="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O104,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O104="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O104,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O104="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O104,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O104="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O104,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O104="","",(V104+T104+R104)-P104) | =IF(ISBLANK(O104),"", IFERROR(_xlfn.XLOOKUP(O104,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O104,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O104="","", IF(X104<0,"Error - gain sites must be postive ▲", (W104+U104+S104)-Q104)) | |
| 105 | =IF(O105="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O105,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O105="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O105,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O105="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O105,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O105="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O105,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O105="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O105,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O105="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O105,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O105="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O105,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O105="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O105,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O105="","",(V105+T105+R105)-P105) | =IF(ISBLANK(O105),"", IFERROR(_xlfn.XLOOKUP(O105,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O105,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O105="","", IF(X105<0,"Error - gain sites must be postive ▲", (W105+U105+S105)-Q105)) | |
| 106 | =IF(O106="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O106,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O106="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O106,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O106="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O106,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O106="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O106,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O106="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O106,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O106="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O106,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O106="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O106,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O106="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O106,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O106="","",(V106+T106+R106)-P106) | =IF(ISBLANK(O106),"", IFERROR(_xlfn.XLOOKUP(O106,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O106,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O106="","", IF(X106<0,"Error - gain sites must be postive ▲", (W106+U106+S106)-Q106)) | |
| 107 | =IF(O107="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,'Off-site gain site summary'!O107,'E-1 Off-Site Hedge Baseline'!Q$10:Q$257)) | =IF(O107="","",SUMIF('E-1 Off-Site Hedge Baseline'!AB$10:AB$257,O107,'E-1 Off-Site Hedge Baseline'!N$10:N$257)) | =IF(O107="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O107,'E-1 Off-Site Hedge Baseline'!$U$10:$U$257)) | =IF(O107="","",SUMIF('E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'Off-site gain site summary'!$O107,'E-1 Off-Site Hedge Baseline'!$AY$10:$AY$257)) | =IF(O107="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O107,'E-3 Off-Site Hedge Enhancement'!$AK$12:$AK$257)) | =IF(O107="","",SUMIF('E-3 Off-Site Hedge Enhancement'!$AO$12:$AO$257,'Off-site gain site summary'!$O107,'E-3 Off-Site Hedge Enhancement'!$AJ$12:$AJ$257)) | =IF(O107="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O107,'E-2 Off-Site Hedge Creation'!$Z$12:$Z$259)) | =IF(O107="","",SUMIF('E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'Off-site gain site summary'!$O107,'E-2 Off-Site Hedge Creation'!$Y$12:$Y$259)) | =IF(O107="","",(V107+T107+R107)-P107) | =IF(ISBLANK(O107),"", IFERROR(_xlfn.XLOOKUP(O107,'E-2 Off-Site Hedge Creation'!$AD$12:$AD$259,'E-2 Off-Site Hedge Creation'!$N$12:$N$259), IFERROR(_xlfn.XLOOKUP(O107,'E-1 Off-Site Hedge Baseline'!$AB$10:$AB$257,'E-1 Off-Site Hedge Baseline'!$P$10:$P$257), " "))) | =IF(O107="","", IF(X107<0,"Error - gain sites must be postive ▲", (W107+U107+S107)-Q107)) |