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