Index

B

Gain site reference

C

Off-site units baseline

D

SRM Off-site units baseline

E

Off-site units retained

F

SRM Off-site units retained

G

Off-site units enhanced

H

SRM Off-site units enhanced

I

Off-site units created

J

SRM Off-site units created

K

Off-site unit change per gain site (pre-SRM)

L

SRM

M

Off-site unit change per gain site (post-SRM)

7 =IFERROR(_xlfn.UNIQUE(_xlfn._xlws.FILTER(A7:A747,A7:A747<>0)),"") =IF(B7="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF11:AF258,B7,'D-1 Off-Site Habitat Baseline'!T11:T258)) =IF(B7="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B7,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B7="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B7,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B7="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B7,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B7="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B7,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B7="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B7,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B7="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B7,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B7="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B7,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B7="","",(I7+G7+E7)-(C7)) =IF(ISBLANK(B7),"",IFERROR(_xlfn.XLOOKUP(B7,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B7,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B7="","", IF(K7<0,"Error - gain sites must be postive ▲", (J7+H7+F7)-(D7)))
8 =IF(B8="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF12:AF259,B8,'D-1 Off-Site Habitat Baseline'!T12:T259)) =IF(B8="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B8,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B8="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B8,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B8="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B8,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B8="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B8,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B8="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B8,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B8="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B8,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B8="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B8,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B8="","",(I8+G8+E8)-(C8)) =IF(ISBLANK(B8),"",IFERROR(_xlfn.XLOOKUP(B8,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B8,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B8="","", IF(K8<0,"Error - gain sites must be postive ▲", (J8+H8+F8)-(D8)))
9 =IF(B9="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF13:AF260,B9,'D-1 Off-Site Habitat Baseline'!T13:T260)) =IF(B9="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B9,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B9="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B9,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B9="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B9,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B9="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B9,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B9="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B9,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B9="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B9,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B9="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B9,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B9="","",(I9+G9+E9)-(C9)) =IF(ISBLANK(B9),"",IFERROR(_xlfn.XLOOKUP(B9,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B9,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B9="","", IF(K9<0,"Error - gain sites must be postive ▲", (J9+H9+F9)-(D9)))
10 =IF(B10="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF14:AF261,B10,'D-1 Off-Site Habitat Baseline'!T14:T261)) =IF(B10="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B10,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B10="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B10,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B10="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B10,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B10="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B10,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B10="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B10,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B10="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B10,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B10="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B10,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B10="","",(I10+G10+E10)-(C10)) =IF(ISBLANK(B10),"",IFERROR(_xlfn.XLOOKUP(B10,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B10,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B10="","", IF(K10,"Error - gain sites must be postive ▲", (J10+H10+F10)-(D10)))
11 =IF(B11="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF15:AF262,B11,'D-1 Off-Site Habitat Baseline'!T15:T262)) =IF(B11="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B11,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B11="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B11,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B11="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B11,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B11="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B11,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B11="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B11,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B11="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B11,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B11="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B11,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B11="","",(I11+G11+E11)-(C11)) =IF(ISBLANK(B11),"",IFERROR(_xlfn.XLOOKUP(B11,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B11,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B11="","", IF(K11<0,"Error - gain sites must be postive ▲", (J11+H11+F11)-(D11)))
12 =IF(B12="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF16:AF263,B12,'D-1 Off-Site Habitat Baseline'!T16:T263)) =IF(B12="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B12,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B12="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B12,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B12="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B12,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B12="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B12,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B12="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B12,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B12="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B12,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B12="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B12,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B12="","",(I12+G12+E12)-(C12)) =IF(ISBLANK(B12),"",IFERROR(_xlfn.XLOOKUP(B12,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B12,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B12="","", IF(K12<0,"Error - gain sites must be postive ▲", (J12+H12+F12)-(D12)))
13 =IF(B13="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF17:AF264,B13,'D-1 Off-Site Habitat Baseline'!T17:T264)) =IF(B13="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B13,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B13="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B13,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B13="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B13,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B13="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B13,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B13="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B13,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B13="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B13,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B13="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B13,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B13="","",(I13+G13+E13)-(C13)) =IF(ISBLANK(B13),"",IFERROR(_xlfn.XLOOKUP(B13,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B13,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B13="","", IF(K13<0,"Error - gain sites must be postive ▲", (J13+H13+F13)-(D13)))
14 =IF(B14="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF18:AF265,B14,'D-1 Off-Site Habitat Baseline'!T18:T265)) =IF(B14="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B14,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B14="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B14,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B14="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B14,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B14="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B14,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B14="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B14,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B14="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B14,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B14="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B14,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B14="","",(I14+G14+E14)-(C14)) =IF(ISBLANK(B14),"",IFERROR(_xlfn.XLOOKUP(B14,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B14,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B14="","", IF(K14<0,"Error - gain sites must be postive ▲", (J14+H14+F14)-(D14)))
15 =IF(B15="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF19:AF266,B15,'D-1 Off-Site Habitat Baseline'!T19:T266)) =IF(B15="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B15,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B15="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B15,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B15="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B15,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B15="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B15,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B15="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B15,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B15="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B15,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B15="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B15,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B15="","",(I15+G15+E15)-(C15)) =IF(ISBLANK(B15),"",IFERROR(_xlfn.XLOOKUP(B15,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B15,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B15="","", IF(K15<0,"Error - gain sites must be postive ▲", (J15+H15+F15)-(D15)))
16 =IF(B16="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF20:AF267,B16,'D-1 Off-Site Habitat Baseline'!T20:T267)) =IF(B16="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B16,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B16="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B16,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B16="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B16,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B16="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B16,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B16="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B16,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B16="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B16,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B16="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B16,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B16="","",(I16+G16+E16)-(C16)) =IF(ISBLANK(B16),"",IFERROR(_xlfn.XLOOKUP(B16,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B16,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B16="","", IF(K16<0,"Error - gain sites must be postive ▲", (J16+H16+F16)-(D16)))
17 =IF(B17="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF21:AF268,B17,'D-1 Off-Site Habitat Baseline'!T21:T268)) =IF(B17="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B17,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B17="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B17,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B17="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B17,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B17="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B17,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B17="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B17,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B17="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B17,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B17="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B17,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B17="","",(I17+G17+E17)-(C17)) =IF(ISBLANK(B17),"",IFERROR(_xlfn.XLOOKUP(B17,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B17,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B17="","", IF(K17<0,"Error - gain sites must be postive ▲", (J17+H17+F17)-(D17)))
18 =IF(B18="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF22:AF269,B18,'D-1 Off-Site Habitat Baseline'!T22:T269)) =IF(B18="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B18,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B18="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B18,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B18="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B18,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B18="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B18,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B18="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B18,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B18="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B18,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B18="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B18,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B18="","",(I18+G18+E18)-(C18)) =IF(ISBLANK(B18),"",IFERROR(_xlfn.XLOOKUP(B18,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B18,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B18="","", IF(K18<0,"Error - gain sites must be postive ▲", (J18+H18+F18)-(D18)))
19 =IF(B19="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF23:AF270,B19,'D-1 Off-Site Habitat Baseline'!T23:T270)) =IF(B19="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B19,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B19="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B19,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B19="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B19,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B19="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B19,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B19="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B19,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B19="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B19,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B19="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B19,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B19="","",(I19+G19+E19)-(C19)) =IF(ISBLANK(B19),"",IFERROR(_xlfn.XLOOKUP(B19,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B19,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B19="","", IF(K19<0,"Error - gain sites must be postive ▲", (J19+H19+F19)-(D19)))
20 =IF(B20="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF24:AF271,B20,'D-1 Off-Site Habitat Baseline'!T24:T271)) =IF(B20="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B20,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B20="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B20,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B20="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B20,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B20="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B20,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B20="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B20,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B20="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B20,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B20="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B20,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B20="","",(I20+G20+E20)-(C20)) =IF(ISBLANK(B20),"",IFERROR(_xlfn.XLOOKUP(B20,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B20,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B20="","", IF(K20,"Error - gain sites must be postive ▲", (J20+H20+F20)-(D20)))
21 =IF(B21="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF25:AF272,B21,'D-1 Off-Site Habitat Baseline'!T25:T272)) =IF(B21="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B21,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B21="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B21,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B21="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B21,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B21="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B21,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B21="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B21,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B21="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B21,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B21="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B21,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B21="","",(I21+G21+E21)-(C21)) =IF(ISBLANK(B21),"",IFERROR(_xlfn.XLOOKUP(B21,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B21,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B21="","", IF(K21<0,"Error - gain sites must be postive ▲", (J21+H21+F21)-(D21)))
22 =IF(B22="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF26:AF273,B22,'D-1 Off-Site Habitat Baseline'!T26:T273)) =IF(B22="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B22,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B22="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B22,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B22="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B22,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B22="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B22,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B22="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B22,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B22="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B22,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B22="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B22,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B22="","",(I22+G22+E22)-(C22)) =IF(ISBLANK(B22),"",IFERROR(_xlfn.XLOOKUP(B22,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B22,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B22="","", IF(K22<0,"Error - gain sites must be postive ▲", (J22+H22+F22)-(D22)))
23 =IF(B23="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF27:AF274,B23,'D-1 Off-Site Habitat Baseline'!T27:T274)) =IF(B23="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B23,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B23="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B23,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B23="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B23,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B23="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B23,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B23="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B23,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B23="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B23,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B23="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B23,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B23="","",(I23+G23+E23)-(C23)) =IF(ISBLANK(B23),"",IFERROR(_xlfn.XLOOKUP(B23,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B23,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B23="","", IF(K23<0,"Error - gain sites must be postive ▲", (J23+H23+F23)-(D23)))
24 =IF(B24="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF28:AF275,B24,'D-1 Off-Site Habitat Baseline'!T28:T275)) =IF(B24="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B24,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B24="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B24,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B24="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B24,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B24="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B24,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B24="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B24,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B24="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B24,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B24="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B24,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B24="","",(I24+G24+E24)-(C24)) =IF(ISBLANK(B24),"",IFERROR(_xlfn.XLOOKUP(B24,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B24,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B24="","", IF(K24<0,"Error - gain sites must be postive ▲", (J24+H24+F24)-(D24)))
25 =IF(B25="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF29:AF276,B25,'D-1 Off-Site Habitat Baseline'!T29:T276)) =IF(B25="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B25,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B25="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B25,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B25="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B25,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B25="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B25,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B25="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B25,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B25="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B25,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B25="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B25,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B25="","",(I25+G25+E25)-(C25)) =IF(ISBLANK(B25),"",IFERROR(_xlfn.XLOOKUP(B25,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B25,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B25="","", IF(K25<0,"Error - gain sites must be postive ▲", (J25+H25+F25)-(D25)))
26 =IF(B26="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF30:AF277,B26,'D-1 Off-Site Habitat Baseline'!T30:T277)) =IF(B26="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B26,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B26="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B26,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B26="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B26,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B26="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B26,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B26="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B26,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B26="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B26,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B26="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B26,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B26="","",(I26+G26+E26)-(C26)) =IF(ISBLANK(B26),"",IFERROR(_xlfn.XLOOKUP(B26,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B26,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B26="","", IF(K26<0,"Error - gain sites must be postive ▲", (J26+H26+F26)-(D26)))
27 =IF(B27="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF31:AF278,B27,'D-1 Off-Site Habitat Baseline'!T31:T278)) =IF(B27="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B27,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B27="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B27,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B27="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B27,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B27="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B27,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B27="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B27,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B27="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B27,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B27="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B27,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B27="","",(I27+G27+E27)-(C27)) =IF(ISBLANK(B27),"",IFERROR(_xlfn.XLOOKUP(B27,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B27,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B27="","", IF(K27<0,"Error - gain sites must be postive ▲", (J27+H27+F27)-(D27)))
28 =IF(B28="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF32:AF279,B28,'D-1 Off-Site Habitat Baseline'!T32:T279)) =IF(B28="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B28,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B28="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B28,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B28="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B28,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B28="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B28,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B28="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B28,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B28="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B28,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B28="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B28,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B28="","",(I28+G28+E28)-(C28)) =IF(ISBLANK(B28),"",IFERROR(_xlfn.XLOOKUP(B28,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B28,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B28="","", IF(K28<0,"Error - gain sites must be postive ▲", (J28+H28+F28)-(D28)))
29 =IF(B29="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF33:AF280,B29,'D-1 Off-Site Habitat Baseline'!T33:T280)) =IF(B29="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B29,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B29="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B29,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B29="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B29,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B29="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B29,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B29="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B29,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B29="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B29,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B29="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B29,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B29="","",(I29+G29+E29)-(C29)) =IF(ISBLANK(B29),"",IFERROR(_xlfn.XLOOKUP(B29,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B29,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B29="","", IF(K29<0,"Error - gain sites must be postive ▲", (J29+H29+F29)-(D29)))
30 =IF(B30="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF34:AF281,B30,'D-1 Off-Site Habitat Baseline'!T34:T281)) =IF(B30="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B30,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B30="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B30,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B30="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B30,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B30="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B30,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B30="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B30,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B30="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B30,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B30="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B30,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B30="","",(I30+G30+E30)-(C30)) =IF(ISBLANK(B30),"",IFERROR(_xlfn.XLOOKUP(B30,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B30,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B30="","", IF(K30,"Error - gain sites must be postive ▲", (J30+H30+F30)-(D30)))
31 =IF(B31="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF35:AF282,B31,'D-1 Off-Site Habitat Baseline'!T35:T282)) =IF(B31="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B31,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B31="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B31,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B31="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B31,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B31="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B31,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B31="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B31,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B31="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B31,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B31="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B31,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B31="","",(I31+G31+E31)-(C31)) =IF(ISBLANK(B31),"",IFERROR(_xlfn.XLOOKUP(B31,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B31,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B31="","", IF(K31<0,"Error - gain sites must be postive ▲", (J31+H31+F31)-(D31)))
32 =IF(B32="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF36:AF283,B32,'D-1 Off-Site Habitat Baseline'!T36:T283)) =IF(B32="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B32,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B32="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B32,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B32="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B32,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B32="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B32,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B32="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B32,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B32="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B32,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B32="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B32,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B32="","",(I32+G32+E32)-(C32)) =IF(ISBLANK(B32),"",IFERROR(_xlfn.XLOOKUP(B32,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B32,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B32="","", IF(K32<0,"Error - gain sites must be postive ▲", (J32+H32+F32)-(D32)))
33 =IF(B33="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF37:AF284,B33,'D-1 Off-Site Habitat Baseline'!T37:T284)) =IF(B33="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B33,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B33="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B33,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B33="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B33,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B33="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B33,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B33="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B33,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B33="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B33,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B33="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B33,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B33="","",(I33+G33+E33)-(C33)) =IF(ISBLANK(B33),"",IFERROR(_xlfn.XLOOKUP(B33,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B33,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B33="","", IF(K33<0,"Error - gain sites must be postive ▲", (J33+H33+F33)-(D33)))
34 =IF(B34="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF38:AF285,B34,'D-1 Off-Site Habitat Baseline'!T38:T285)) =IF(B34="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B34,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B34="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B34,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B34="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B34,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B34="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B34,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B34="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B34,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B34="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B34,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B34="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B34,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B34="","",(I34+G34+E34)-(C34)) =IF(ISBLANK(B34),"",IFERROR(_xlfn.XLOOKUP(B34,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B34,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B34="","", IF(K34<0,"Error - gain sites must be postive ▲", (J34+H34+F34)-(D34)))
35 =IF(B35="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF39:AF286,B35,'D-1 Off-Site Habitat Baseline'!T39:T286)) =IF(B35="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B35,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B35="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B35,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B35="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B35,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B35="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B35,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B35="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B35,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B35="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B35,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B35="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B35,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B35="","",(I35+G35+E35)-(C35)) =IF(ISBLANK(B35),"",IFERROR(_xlfn.XLOOKUP(B35,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B35,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B35="","", IF(K35<0,"Error - gain sites must be postive ▲", (J35+H35+F35)-(D35)))
36 =IF(B36="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF40:AF287,B36,'D-1 Off-Site Habitat Baseline'!T40:T287)) =IF(B36="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B36,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B36="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B36,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B36="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B36,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B36="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B36,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B36="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B36,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B36="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B36,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B36="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B36,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B36="","",(I36+G36+E36)-(C36)) =IF(ISBLANK(B36),"",IFERROR(_xlfn.XLOOKUP(B36,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B36,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B36="","", IF(K36<0,"Error - gain sites must be postive ▲", (J36+H36+F36)-(D36)))
37 =IF(B37="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF41:AF288,B37,'D-1 Off-Site Habitat Baseline'!T41:T288)) =IF(B37="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B37,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B37="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B37,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B37="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B37,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B37="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B37,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B37="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B37,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B37="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B37,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B37="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B37,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B37="","",(I37+G37+E37)-(C37)) =IF(ISBLANK(B37),"",IFERROR(_xlfn.XLOOKUP(B37,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B37,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B37="","", IF(K37<0,"Error - gain sites must be postive ▲", (J37+H37+F37)-(D37)))
38 =IF(B38="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF42:AF289,B38,'D-1 Off-Site Habitat Baseline'!T42:T289)) =IF(B38="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B38,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B38="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B38,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B38="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B38,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B38="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B38,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B38="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B38,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B38="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B38,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B38="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B38,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B38="","",(I38+G38+E38)-(C38)) =IF(ISBLANK(B38),"",IFERROR(_xlfn.XLOOKUP(B38,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B38,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B38="","", IF(K38<0,"Error - gain sites must be postive ▲", (J38+H38+F38)-(D38)))
39 =IF(B39="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF43:AF290,B39,'D-1 Off-Site Habitat Baseline'!T43:T290)) =IF(B39="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B39,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B39="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B39,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B39="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B39,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B39="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B39,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B39="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B39,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B39="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B39,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B39="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B39,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B39="","",(I39+G39+E39)-(C39)) =IF(ISBLANK(B39),"",IFERROR(_xlfn.XLOOKUP(B39,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B39,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B39="","", IF(K39<0,"Error - gain sites must be postive ▲", (J39+H39+F39)-(D39)))
40 =IF(B40="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF44:AF291,B40,'D-1 Off-Site Habitat Baseline'!T44:T291)) =IF(B40="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B40,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B40="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B40,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B40="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B40,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B40="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B40,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B40="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B40,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B40="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B40,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B40="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B40,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B40="","",(I40+G40+E40)-(C40)) =IF(ISBLANK(B40),"",IFERROR(_xlfn.XLOOKUP(B40,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B40,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B40="","", IF(K40,"Error - gain sites must be postive ▲", (J40+H40+F40)-(D40)))
41 =IF(B41="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF45:AF292,B41,'D-1 Off-Site Habitat Baseline'!T45:T292)) =IF(B41="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B41,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B41="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B41,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B41="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B41,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B41="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B41,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B41="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B41,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B41="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B41,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B41="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B41,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B41="","",(I41+G41+E41)-(C41)) =IF(ISBLANK(B41),"",IFERROR(_xlfn.XLOOKUP(B41,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B41,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B41="","", IF(K41<0,"Error - gain sites must be postive ▲", (J41+H41+F41)-(D41)))
42 =IF(B42="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF46:AF293,B42,'D-1 Off-Site Habitat Baseline'!T46:T293)) =IF(B42="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B42,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B42="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B42,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B42="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B42,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B42="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B42,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B42="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B42,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B42="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B42,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B42="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B42,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B42="","",(I42+G42+E42)-(C42)) =IF(ISBLANK(B42),"",IFERROR(_xlfn.XLOOKUP(B42,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B42,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B42="","", IF(K42<0,"Error - gain sites must be postive ▲", (J42+H42+F42)-(D42)))
43 =IF(B43="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF47:AF294,B43,'D-1 Off-Site Habitat Baseline'!T47:T294)) =IF(B43="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B43,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B43="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B43,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B43="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B43,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B43="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B43,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B43="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B43,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B43="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B43,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B43="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B43,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B43="","",(I43+G43+E43)-(C43)) =IF(ISBLANK(B43),"",IFERROR(_xlfn.XLOOKUP(B43,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B43,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B43="","", IF(K43<0,"Error - gain sites must be postive ▲", (J43+H43+F43)-(D43)))
44 =IF(B44="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF48:AF295,B44,'D-1 Off-Site Habitat Baseline'!T48:T295)) =IF(B44="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B44,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B44="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B44,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B44="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B44,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B44="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B44,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B44="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B44,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B44="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B44,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B44="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B44,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B44="","",(I44+G44+E44)-(C44)) =IF(ISBLANK(B44),"",IFERROR(_xlfn.XLOOKUP(B44,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B44,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B44="","", IF(K44<0,"Error - gain sites must be postive ▲", (J44+H44+F44)-(D44)))
45 =IF(B45="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF49:AF296,B45,'D-1 Off-Site Habitat Baseline'!T49:T296)) =IF(B45="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B45,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B45="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B45,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B45="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B45,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B45="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B45,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B45="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B45,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B45="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B45,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B45="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B45,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B45="","",(I45+G45+E45)-(C45)) =IF(ISBLANK(B45),"",IFERROR(_xlfn.XLOOKUP(B45,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B45,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B45="","", IF(K45<0,"Error - gain sites must be postive ▲", (J45+H45+F45)-(D45)))
46 =IF(B46="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF50:AF297,B46,'D-1 Off-Site Habitat Baseline'!T50:T297)) =IF(B46="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B46,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B46="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B46,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B46="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B46,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B46="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B46,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B46="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B46,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B46="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B46,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B46="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B46,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B46="","",(I46+G46+E46)-(C46)) =IF(ISBLANK(B46),"",IFERROR(_xlfn.XLOOKUP(B46,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B46,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B46="","", IF(K46<0,"Error - gain sites must be postive ▲", (J46+H46+F46)-(D46)))
47 =IF(B47="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF51:AF298,B47,'D-1 Off-Site Habitat Baseline'!T51:T298)) =IF(B47="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B47,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B47="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B47,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B47="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B47,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B47="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B47,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B47="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B47,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B47="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B47,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B47="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B47,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B47="","",(I47+G47+E47)-(C47)) =IF(ISBLANK(B47),"",IFERROR(_xlfn.XLOOKUP(B47,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B47,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B47="","", IF(K47<0,"Error - gain sites must be postive ▲", (J47+H47+F47)-(D47)))
48 =IF(B48="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF52:AF299,B48,'D-1 Off-Site Habitat Baseline'!T52:T299)) =IF(B48="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B48,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B48="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B48,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B48="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B48,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B48="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B48,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B48="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B48,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B48="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B48,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B48="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B48,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B48="","",(I48+G48+E48)-(C48)) =IF(ISBLANK(B48),"",IFERROR(_xlfn.XLOOKUP(B48,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B48,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B48="","", IF(K48<0,"Error - gain sites must be postive ▲", (J48+H48+F48)-(D48)))
49 =IF(B49="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF53:AF300,B49,'D-1 Off-Site Habitat Baseline'!T53:T300)) =IF(B49="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B49,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B49="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B49,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B49="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B49,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B49="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B49,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B49="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B49,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B49="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B49,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B49="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B49,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B49="","",(I49+G49+E49)-(C49)) =IF(ISBLANK(B49),"",IFERROR(_xlfn.XLOOKUP(B49,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B49,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B49="","", IF(K49<0,"Error - gain sites must be postive ▲", (J49+H49+F49)-(D49)))
50 =IF(B50="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF54:AF301,B50,'D-1 Off-Site Habitat Baseline'!T54:T301)) =IF(B50="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B50,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B50="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B50,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B50="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B50,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B50="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B50,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B50="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B50,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B50="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B50,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B50="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B50,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B50="","",(I50+G50+E50)-(C50)) =IF(ISBLANK(B50),"",IFERROR(_xlfn.XLOOKUP(B50,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B50,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B50="","", IF(K50,"Error - gain sites must be postive ▲", (J50+H50+F50)-(D50)))
51 =IF(B51="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF55:AF302,B51,'D-1 Off-Site Habitat Baseline'!T55:T302)) =IF(B51="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B51,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B51="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B51,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B51="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B51,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B51="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B51,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B51="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B51,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B51="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B51,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B51="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B51,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B51="","",(I51+G51+E51)-(C51)) =IF(ISBLANK(B51),"",IFERROR(_xlfn.XLOOKUP(B51,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B51,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B51="","", IF(K51<0,"Error - gain sites must be postive ▲", (J51+H51+F51)-(D51)))
52 =IF(B52="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF56:AF303,B52,'D-1 Off-Site Habitat Baseline'!T56:T303)) =IF(B52="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B52,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B52="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B52,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B52="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B52,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B52="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B52,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B52="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B52,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B52="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B52,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B52="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B52,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B52="","",(I52+G52+E52)-(C52)) =IF(ISBLANK(B52),"",IFERROR(_xlfn.XLOOKUP(B52,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B52,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B52="","", IF(K52<0,"Error - gain sites must be postive ▲", (J52+H52+F52)-(D52)))
53 =IF(B53="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF57:AF304,B53,'D-1 Off-Site Habitat Baseline'!T57:T304)) =IF(B53="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B53,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B53="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B53,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B53="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B53,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B53="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B53,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B53="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B53,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B53="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B53,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B53="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B53,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B53="","",(I53+G53+E53)-(C53)) =IF(ISBLANK(B53),"",IFERROR(_xlfn.XLOOKUP(B53,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B53,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B53="","", IF(K53<0,"Error - gain sites must be postive ▲", (J53+H53+F53)-(D53)))
54 =IF(B54="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF58:AF305,B54,'D-1 Off-Site Habitat Baseline'!T58:T305)) =IF(B54="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B54,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B54="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B54,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B54="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B54,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B54="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B54,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B54="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B54,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B54="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B54,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B54="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B54,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B54="","",(I54+G54+E54)-(C54)) =IF(ISBLANK(B54),"",IFERROR(_xlfn.XLOOKUP(B54,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B54,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B54="","", IF(K54<0,"Error - gain sites must be postive ▲", (J54+H54+F54)-(D54)))
55 =IF(B55="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF59:AF306,B55,'D-1 Off-Site Habitat Baseline'!T59:T306)) =IF(B55="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B55,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B55="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B55,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B55="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B55,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B55="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B55,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B55="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B55,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B55="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B55,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B55="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B55,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B55="","",(I55+G55+E55)-(C55)) =IF(ISBLANK(B55),"",IFERROR(_xlfn.XLOOKUP(B55,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B55,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B55="","", IF(K55<0,"Error - gain sites must be postive ▲", (J55+H55+F55)-(D55)))
56 =IF(B56="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF60:AF307,B56,'D-1 Off-Site Habitat Baseline'!T60:T307)) =IF(B56="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B56,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B56="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B56,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B56="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B56,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B56="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B56,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B56="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B56,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B56="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B56,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B56="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B56,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B56="","",(I56+G56+E56)-(C56)) =IF(ISBLANK(B56),"",IFERROR(_xlfn.XLOOKUP(B56,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B56,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B56="","", IF(K56<0,"Error - gain sites must be postive ▲", (J56+H56+F56)-(D56)))
57 =IF(B57="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF61:AF308,B57,'D-1 Off-Site Habitat Baseline'!T61:T308)) =IF(B57="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B57,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B57="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B57,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B57="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B57,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B57="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B57,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B57="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B57,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B57="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B57,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B57="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B57,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B57="","",(I57+G57+E57)-(C57)) =IF(ISBLANK(B57),"",IFERROR(_xlfn.XLOOKUP(B57,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B57,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B57="","", IF(K57<0,"Error - gain sites must be postive ▲", (J57+H57+F57)-(D57)))
58 =IF(B58="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF62:AF309,B58,'D-1 Off-Site Habitat Baseline'!T62:T309)) =IF(B58="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B58,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B58="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B58,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B58="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B58,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B58="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B58,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B58="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B58,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B58="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B58,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B58="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B58,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B58="","",(I58+G58+E58)-(C58)) =IF(ISBLANK(B58),"",IFERROR(_xlfn.XLOOKUP(B58,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B58,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B58="","", IF(K58<0,"Error - gain sites must be postive ▲", (J58+H58+F58)-(D58)))
59 =IF(B59="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF63:AF310,B59,'D-1 Off-Site Habitat Baseline'!T63:T310)) =IF(B59="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B59,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B59="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B59,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B59="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B59,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B59="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B59,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B59="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B59,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B59="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B59,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B59="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B59,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B59="","",(I59+G59+E59)-(C59)) =IF(ISBLANK(B59),"",IFERROR(_xlfn.XLOOKUP(B59,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B59,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B59="","", IF(K59<0,"Error - gain sites must be postive ▲", (J59+H59+F59)-(D59)))
60 =IF(B60="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF64:AF311,B60,'D-1 Off-Site Habitat Baseline'!T64:T311)) =IF(B60="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B60,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B60="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B60,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B60="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B60,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B60="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B60,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B60="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B60,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B60="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B60,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B60="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B60,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B60="","",(I60+G60+E60)-(C60)) =IF(ISBLANK(B60),"",IFERROR(_xlfn.XLOOKUP(B60,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B60,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B60="","", IF(K60,"Error - gain sites must be postive ▲", (J60+H60+F60)-(D60)))
61 =IF(B61="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF65:AF312,B61,'D-1 Off-Site Habitat Baseline'!T65:T312)) =IF(B61="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B61,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B61="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B61,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B61="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B61,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B61="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B61,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B61="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B61,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B61="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B61,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B61="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B61,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B61="","",(I61+G61+E61)-(C61)) =IF(ISBLANK(B61),"",IFERROR(_xlfn.XLOOKUP(B61,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B61,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B61="","", IF(K61<0,"Error - gain sites must be postive ▲", (J61+H61+F61)-(D61)))
62 =IF(B62="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF66:AF313,B62,'D-1 Off-Site Habitat Baseline'!T66:T313)) =IF(B62="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B62,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B62="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B62,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B62="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B62,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B62="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B62,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B62="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B62,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B62="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B62,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B62="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B62,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B62="","",(I62+G62+E62)-(C62)) =IF(ISBLANK(B62),"",IFERROR(_xlfn.XLOOKUP(B62,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B62,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B62="","", IF(K62<0,"Error - gain sites must be postive ▲", (J62+H62+F62)-(D62)))
63 =IF(B63="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF67:AF314,B63,'D-1 Off-Site Habitat Baseline'!T67:T314)) =IF(B63="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B63,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B63="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B63,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B63="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B63,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B63="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B63,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B63="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B63,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B63="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B63,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B63="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B63,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B63="","",(I63+G63+E63)-(C63)) =IF(ISBLANK(B63),"",IFERROR(_xlfn.XLOOKUP(B63,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B63,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B63="","", IF(K63<0,"Error - gain sites must be postive ▲", (J63+H63+F63)-(D63)))
64 =IF(B64="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF68:AF315,B64,'D-1 Off-Site Habitat Baseline'!T68:T315)) =IF(B64="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B64,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B64="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B64,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B64="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B64,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B64="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B64,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B64="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B64,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B64="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B64,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B64="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B64,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B64="","",(I64+G64+E64)-(C64)) =IF(ISBLANK(B64),"",IFERROR(_xlfn.XLOOKUP(B64,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B64,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B64="","", IF(K64<0,"Error - gain sites must be postive ▲", (J64+H64+F64)-(D64)))
65 =IF(B65="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF69:AF316,B65,'D-1 Off-Site Habitat Baseline'!T69:T316)) =IF(B65="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B65,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B65="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B65,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B65="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B65,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B65="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B65,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B65="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B65,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B65="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B65,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B65="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B65,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B65="","",(I65+G65+E65)-(C65)) =IF(ISBLANK(B65),"",IFERROR(_xlfn.XLOOKUP(B65,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B65,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B65="","", IF(K65<0,"Error - gain sites must be postive ▲", (J65+H65+F65)-(D65)))
66 =IF(B66="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF70:AF317,B66,'D-1 Off-Site Habitat Baseline'!T70:T317)) =IF(B66="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B66,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B66="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B66,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B66="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B66,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B66="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B66,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B66="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B66,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B66="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B66,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B66="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B66,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B66="","",(I66+G66+E66)-(C66)) =IF(ISBLANK(B66),"",IFERROR(_xlfn.XLOOKUP(B66,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B66,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B66="","", IF(K66<0,"Error - gain sites must be postive ▲", (J66+H66+F66)-(D66)))
67 =IF(B67="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF71:AF318,B67,'D-1 Off-Site Habitat Baseline'!T71:T318)) =IF(B67="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B67,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B67="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B67,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B67="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B67,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B67="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B67,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B67="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B67,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B67="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B67,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B67="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B67,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B67="","",(I67+G67+E67)-(C67)) =IF(ISBLANK(B67),"",IFERROR(_xlfn.XLOOKUP(B67,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B67,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B67="","", IF(K67<0,"Error - gain sites must be postive ▲", (J67+H67+F67)-(D67)))
68 =IF(B68="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF72:AF319,B68,'D-1 Off-Site Habitat Baseline'!T72:T319)) =IF(B68="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B68,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B68="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B68,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B68="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B68,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B68="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B68,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B68="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B68,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B68="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B68,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B68="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B68,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B68="","",(I68+G68+E68)-(C68)) =IF(ISBLANK(B68),"",IFERROR(_xlfn.XLOOKUP(B68,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B68,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B68="","", IF(K68<0,"Error - gain sites must be postive ▲", (J68+H68+F68)-(D68)))
69 =IF(B69="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF73:AF320,B69,'D-1 Off-Site Habitat Baseline'!T73:T320)) =IF(B69="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B69,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B69="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B69,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B69="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B69,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B69="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B69,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B69="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B69,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B69="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B69,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B69="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B69,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B69="","",(I69+G69+E69)-(C69)) =IF(ISBLANK(B69),"",IFERROR(_xlfn.XLOOKUP(B69,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B69,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B69="","", IF(K69<0,"Error - gain sites must be postive ▲", (J69+H69+F69)-(D69)))
70 =IF(B70="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF74:AF321,B70,'D-1 Off-Site Habitat Baseline'!T74:T321)) =IF(B70="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B70,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B70="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B70,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B70="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B70,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B70="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B70,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B70="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B70,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B70="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B70,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B70="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B70,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B70="","",(I70+G70+E70)-(C70)) =IF(ISBLANK(B70),"",IFERROR(_xlfn.XLOOKUP(B70,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B70,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B70="","", IF(K70,"Error - gain sites must be postive ▲", (J70+H70+F70)-(D70)))
71 =IF(B71="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF75:AF322,B71,'D-1 Off-Site Habitat Baseline'!T75:T322)) =IF(B71="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B71,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B71="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B71,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B71="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B71,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B71="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B71,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B71="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B71,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B71="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B71,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B71="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B71,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B71="","",(I71+G71+E71)-(C71)) =IF(ISBLANK(B71),"",IFERROR(_xlfn.XLOOKUP(B71,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B71,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B71="","", IF(K71<0,"Error - gain sites must be postive ▲", (J71+H71+F71)-(D71)))
72 =IF(B72="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF76:AF323,B72,'D-1 Off-Site Habitat Baseline'!T76:T323)) =IF(B72="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B72,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B72="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B72,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B72="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B72,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B72="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B72,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B72="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B72,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B72="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B72,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B72="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B72,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B72="","",(I72+G72+E72)-(C72)) =IF(ISBLANK(B72),"",IFERROR(_xlfn.XLOOKUP(B72,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B72,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B72="","", IF(K72<0,"Error - gain sites must be postive ▲", (J72+H72+F72)-(D72)))
73 =IF(B73="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF77:AF324,B73,'D-1 Off-Site Habitat Baseline'!T77:T324)) =IF(B73="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B73,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B73="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B73,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B73="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B73,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B73="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B73,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B73="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B73,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B73="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B73,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B73="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B73,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B73="","",(I73+G73+E73)-(C73)) =IF(ISBLANK(B73),"",IFERROR(_xlfn.XLOOKUP(B73,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B73,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B73="","", IF(K73<0,"Error - gain sites must be postive ▲", (J73+H73+F73)-(D73)))
74 =IF(B74="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF78:AF325,B74,'D-1 Off-Site Habitat Baseline'!T78:T325)) =IF(B74="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B74,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B74="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B74,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B74="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B74,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B74="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B74,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B74="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B74,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B74="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B74,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B74="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B74,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B74="","",(I74+G74+E74)-(C74)) =IF(ISBLANK(B74),"",IFERROR(_xlfn.XLOOKUP(B74,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B74,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B74="","", IF(K74<0,"Error - gain sites must be postive ▲", (J74+H74+F74)-(D74)))
75 =IF(B75="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF79:AF326,B75,'D-1 Off-Site Habitat Baseline'!T79:T326)) =IF(B75="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B75,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B75="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B75,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B75="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B75,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B75="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B75,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B75="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B75,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B75="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B75,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B75="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B75,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B75="","",(I75+G75+E75)-(C75)) =IF(ISBLANK(B75),"",IFERROR(_xlfn.XLOOKUP(B75,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B75,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B75="","", IF(K75<0,"Error - gain sites must be postive ▲", (J75+H75+F75)-(D75)))
76 =IF(B76="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF80:AF327,B76,'D-1 Off-Site Habitat Baseline'!T80:T327)) =IF(B76="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B76,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B76="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B76,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B76="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B76,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B76="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B76,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B76="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B76,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B76="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B76,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B76="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B76,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B76="","",(I76+G76+E76)-(C76)) =IF(ISBLANK(B76),"",IFERROR(_xlfn.XLOOKUP(B76,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B76,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B76="","", IF(K76<0,"Error - gain sites must be postive ▲", (J76+H76+F76)-(D76)))
77 =IF(B77="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF81:AF328,B77,'D-1 Off-Site Habitat Baseline'!T81:T328)) =IF(B77="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B77,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B77="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B77,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B77="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B77,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B77="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B77,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B77="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B77,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B77="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B77,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B77="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B77,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B77="","",(I77+G77+E77)-(C77)) =IF(ISBLANK(B77),"",IFERROR(_xlfn.XLOOKUP(B77,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B77,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B77="","", IF(K77<0,"Error - gain sites must be postive ▲", (J77+H77+F77)-(D77)))
78 =IF(B78="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF82:AF329,B78,'D-1 Off-Site Habitat Baseline'!T82:T329)) =IF(B78="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B78,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B78="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B78,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B78="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B78,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B78="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B78,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B78="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B78,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B78="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B78,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B78="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B78,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B78="","",(I78+G78+E78)-(C78)) =IF(ISBLANK(B78),"",IFERROR(_xlfn.XLOOKUP(B78,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B78,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B78="","", IF(K78<0,"Error - gain sites must be postive ▲", (J78+H78+F78)-(D78)))
79 =IF(B79="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF83:AF330,B79,'D-1 Off-Site Habitat Baseline'!T83:T330)) =IF(B79="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B79,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B79="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B79,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B79="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B79,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B79="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B79,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B79="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B79,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B79="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B79,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B79="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B79,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B79="","",(I79+G79+E79)-(C79)) =IF(ISBLANK(B79),"",IFERROR(_xlfn.XLOOKUP(B79,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B79,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B79="","", IF(K79<0,"Error - gain sites must be postive ▲", (J79+H79+F79)-(D79)))
80 =IF(B80="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF84:AF331,B80,'D-1 Off-Site Habitat Baseline'!T84:T331)) =IF(B80="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B80,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B80="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B80,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B80="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B80,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B80="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B80,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B80="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B80,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B80="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B80,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B80="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B80,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B80="","",(I80+G80+E80)-(C80)) =IF(ISBLANK(B80),"",IFERROR(_xlfn.XLOOKUP(B80,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B80,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B80="","", IF(K80,"Error - gain sites must be postive ▲", (J80+H80+F80)-(D80)))
81 =IF(B81="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF85:AF332,B81,'D-1 Off-Site Habitat Baseline'!T85:T332)) =IF(B81="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B81,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B81="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B81,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B81="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B81,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B81="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B81,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B81="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B81,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B81="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B81,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B81="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B81,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B81="","",(I81+G81+E81)-(C81)) =IF(ISBLANK(B81),"",IFERROR(_xlfn.XLOOKUP(B81,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B81,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B81="","", IF(K81<0,"Error - gain sites must be postive ▲", (J81+H81+F81)-(D81)))
82 =IF(B82="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF86:AF333,B82,'D-1 Off-Site Habitat Baseline'!T86:T333)) =IF(B82="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B82,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B82="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B82,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B82="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B82,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B82="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B82,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B82="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B82,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B82="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B82,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B82="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B82,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B82="","",(I82+G82+E82)-(C82)) =IF(ISBLANK(B82),"",IFERROR(_xlfn.XLOOKUP(B82,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B82,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B82="","", IF(K82<0,"Error - gain sites must be postive ▲", (J82+H82+F82)-(D82)))
83 =IF(B83="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF87:AF334,B83,'D-1 Off-Site Habitat Baseline'!T87:T334)) =IF(B83="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B83,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B83="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B83,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B83="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B83,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B83="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B83,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B83="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B83,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B83="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B83,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B83="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B83,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B83="","",(I83+G83+E83)-(C83)) =IF(ISBLANK(B83),"",IFERROR(_xlfn.XLOOKUP(B83,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B83,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B83="","", IF(K83<0,"Error - gain sites must be postive ▲", (J83+H83+F83)-(D83)))
84 =IF(B84="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF88:AF335,B84,'D-1 Off-Site Habitat Baseline'!T88:T335)) =IF(B84="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B84,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B84="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B84,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B84="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B84,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B84="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B84,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B84="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B84,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B84="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B84,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B84="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B84,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B84="","",(I84+G84+E84)-(C84)) =IF(ISBLANK(B84),"",IFERROR(_xlfn.XLOOKUP(B84,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B84,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B84="","", IF(K84<0,"Error - gain sites must be postive ▲", (J84+H84+F84)-(D84)))
85 =IF(B85="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF89:AF336,B85,'D-1 Off-Site Habitat Baseline'!T89:T336)) =IF(B85="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B85,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B85="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B85,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B85="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B85,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B85="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B85,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B85="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B85,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B85="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B85,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B85="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B85,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B85="","",(I85+G85+E85)-(C85)) =IF(ISBLANK(B85),"",IFERROR(_xlfn.XLOOKUP(B85,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B85,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B85="","", IF(K85<0,"Error - gain sites must be postive ▲", (J85+H85+F85)-(D85)))
86 =IF(B86="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF90:AF337,B86,'D-1 Off-Site Habitat Baseline'!T90:T337)) =IF(B86="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B86,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B86="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B86,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B86="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B86,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B86="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B86,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B86="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B86,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B86="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B86,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B86="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B86,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B86="","",(I86+G86+E86)-(C86)) =IF(ISBLANK(B86),"",IFERROR(_xlfn.XLOOKUP(B86,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B86,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B86="","", IF(K86<0,"Error - gain sites must be postive ▲", (J86+H86+F86)-(D86)))
87 =IF(B87="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF91:AF338,B87,'D-1 Off-Site Habitat Baseline'!T91:T338)) =IF(B87="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B87,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B87="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B87,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B87="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B87,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B87="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B87,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B87="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B87,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B87="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B87,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B87="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B87,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B87="","",(I87+G87+E87)-(C87)) =IF(ISBLANK(B87),"",IFERROR(_xlfn.XLOOKUP(B87,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B87,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B87="","", IF(K87<0,"Error - gain sites must be postive ▲", (J87+H87+F87)-(D87)))
88 =IF(B88="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF92:AF339,B88,'D-1 Off-Site Habitat Baseline'!T92:T339)) =IF(B88="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B88,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B88="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B88,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B88="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B88,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B88="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B88,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B88="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B88,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B88="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B88,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B88="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B88,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B88="","",(I88+G88+E88)-(C88)) =IF(ISBLANK(B88),"",IFERROR(_xlfn.XLOOKUP(B88,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B88,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B88="","", IF(K88<0,"Error - gain sites must be postive ▲", (J88+H88+F88)-(D88)))
89 =IF(B89="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF93:AF340,B89,'D-1 Off-Site Habitat Baseline'!T93:T340)) =IF(B89="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B89,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B89="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B89,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B89="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B89,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B89="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B89,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B89="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B89,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B89="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B89,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B89="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B89,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B89="","",(I89+G89+E89)-(C89)) =IF(ISBLANK(B89),"",IFERROR(_xlfn.XLOOKUP(B89,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B89,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B89="","", IF(K89<0,"Error - gain sites must be postive ▲", (J89+H89+F89)-(D89)))
90 =IF(B90="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF94:AF341,B90,'D-1 Off-Site Habitat Baseline'!T94:T341)) =IF(B90="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B90,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B90="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B90,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B90="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B90,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B90="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B90,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B90="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B90,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B90="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B90,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B90="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B90,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B90="","",(I90+G90+E90)-(C90)) =IF(ISBLANK(B90),"",IFERROR(_xlfn.XLOOKUP(B90,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B90,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B90="","", IF(K90,"Error - gain sites must be postive ▲", (J90+H90+F90)-(D90)))
91 =IF(B91="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF95:AF342,B91,'D-1 Off-Site Habitat Baseline'!T95:T342)) =IF(B91="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B91,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B91="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B91,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B91="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B91,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B91="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B91,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B91="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B91,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B91="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B91,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B91="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B91,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B91="","",(I91+G91+E91)-(C91)) =IF(ISBLANK(B91),"",IFERROR(_xlfn.XLOOKUP(B91,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B91,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B91="","", IF(K91<0,"Error - gain sites must be postive ▲", (J91+H91+F91)-(D91)))
92 =IF(B92="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF96:AF343,B92,'D-1 Off-Site Habitat Baseline'!T96:T343)) =IF(B92="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B92,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B92="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B92,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B92="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B92,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B92="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B92,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B92="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B92,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B92="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B92,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B92="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B92,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B92="","",(I92+G92+E92)-(C92)) =IF(ISBLANK(B92),"",IFERROR(_xlfn.XLOOKUP(B92,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B92,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B92="","", IF(K92<0,"Error - gain sites must be postive ▲", (J92+H92+F92)-(D92)))
93 =IF(B93="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF97:AF344,B93,'D-1 Off-Site Habitat Baseline'!T97:T344)) =IF(B93="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B93,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B93="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B93,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B93="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B93,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B93="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B93,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B93="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B93,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B93="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B93,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B93="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B93,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B93="","",(I93+G93+E93)-(C93)) =IF(ISBLANK(B93),"",IFERROR(_xlfn.XLOOKUP(B93,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B93,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B93="","", IF(K93<0,"Error - gain sites must be postive ▲", (J93+H93+F93)-(D93)))
94 =IF(B94="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF98:AF345,B94,'D-1 Off-Site Habitat Baseline'!T98:T345)) =IF(B94="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B94,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B94="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B94,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B94="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B94,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B94="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B94,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B94="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B94,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B94="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B94,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B94="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B94,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B94="","",(I94+G94+E94)-(C94)) =IF(ISBLANK(B94),"",IFERROR(_xlfn.XLOOKUP(B94,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B94,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B94="","", IF(K94<0,"Error - gain sites must be postive ▲", (J94+H94+F94)-(D94)))
95 =IF(B95="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF99:AF346,B95,'D-1 Off-Site Habitat Baseline'!T99:T346)) =IF(B95="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B95,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B95="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B95,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B95="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B95,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B95="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B95,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B95="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B95,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B95="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B95,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B95="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B95,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B95="","",(I95+G95+E95)-(C95)) =IF(ISBLANK(B95),"",IFERROR(_xlfn.XLOOKUP(B95,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B95,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B95="","", IF(K95<0,"Error - gain sites must be postive ▲", (J95+H95+F95)-(D95)))
96 =IF(B96="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF100:AF347,B96,'D-1 Off-Site Habitat Baseline'!T100:T347)) =IF(B96="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B96,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B96="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B96,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B96="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B96,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B96="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B96,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B96="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B96,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B96="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B96,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B96="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B96,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B96="","",(I96+G96+E96)-(C96)) =IF(ISBLANK(B96),"",IFERROR(_xlfn.XLOOKUP(B96,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B96,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B96="","", IF(K96<0,"Error - gain sites must be postive ▲", (J96+H96+F96)-(D96)))
97 =IF(B97="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF101:AF348,B97,'D-1 Off-Site Habitat Baseline'!T101:T348)) =IF(B97="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B97,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B97="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B97,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B97="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B97,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B97="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B97,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B97="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B97,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B97="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B97,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B97="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B97,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B97="","",(I97+G97+E97)-(C97)) =IF(ISBLANK(B97),"",IFERROR(_xlfn.XLOOKUP(B97,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B97,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B97="","", IF(K97<0,"Error - gain sites must be postive ▲", (J97+H97+F97)-(D97)))
98 =IF(B98="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF102:AF349,B98,'D-1 Off-Site Habitat Baseline'!T102:T349)) =IF(B98="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B98,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B98="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B98,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B98="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B98,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B98="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B98,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B98="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B98,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B98="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B98,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B98="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B98,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B98="","",(I98+G98+E98)-(C98)) =IF(ISBLANK(B98),"",IFERROR(_xlfn.XLOOKUP(B98,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B98,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B98="","", IF(K98<0,"Error - gain sites must be postive ▲", (J98+H98+F98)-(D98)))
99 =IF(B99="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF103:AF350,B99,'D-1 Off-Site Habitat Baseline'!T103:T350)) =IF(B99="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B99,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B99="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B99,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B99="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B99,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B99="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B99,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B99="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B99,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B99="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B99,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B99="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B99,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B99="","",(I99+G99+E99)-(C99)) =IF(ISBLANK(B99),"",IFERROR(_xlfn.XLOOKUP(B99,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B99,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B99="","", IF(K99<0,"Error - gain sites must be postive ▲", (J99+H99+F99)-(D99)))
100 =IF(B100="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF104:AF351,B100,'D-1 Off-Site Habitat Baseline'!T104:T351)) =IF(B100="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B100,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B100="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B100,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B100="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B100,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B100="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B100,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B100="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B100,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B100="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B100,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B100="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B100,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B100="","",(I100+G100+E100)-(C100)) =IF(ISBLANK(B100),"",IFERROR(_xlfn.XLOOKUP(B100,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B100,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B100="","", IF(K100,"Error - gain sites must be postive ▲", (J100+H100+F100)-(D100)))
101 =IF(B101="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF105:AF352,B101,'D-1 Off-Site Habitat Baseline'!T105:T352)) =IF(B101="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B101,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B101="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B101,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B101="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B101,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B101="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B101,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B101="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B101,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B101="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B101,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B101="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B101,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B101="","",(I101+G101+E101)-(C101)) =IF(ISBLANK(B101),"",IFERROR(_xlfn.XLOOKUP(B101,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B101,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B101="","", IF(K101<0,"Error - gain sites must be postive ▲", (J101+H101+F101)-(D101)))
102 =IF(B102="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF106:AF353,B102,'D-1 Off-Site Habitat Baseline'!T106:T353)) =IF(B102="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B102,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B102="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B102,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B102="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B102,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B102="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B102,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B102="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B102,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B102="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B102,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B102="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B102,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B102="","",(I102+G102+E102)-(C102)) =IF(ISBLANK(B102),"",IFERROR(_xlfn.XLOOKUP(B102,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B102,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B102="","", IF(K102<0,"Error - gain sites must be postive ▲", (J102+H102+F102)-(D102)))
103 =IF(B103="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF107:AF354,B103,'D-1 Off-Site Habitat Baseline'!T107:T354)) =IF(B103="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B103,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B103="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B103,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B103="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B103,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B103="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B103,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B103="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B103,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B103="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B103,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B103="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B103,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B103="","",(I103+G103+E103)-(C103)) =IF(ISBLANK(B103),"",IFERROR(_xlfn.XLOOKUP(B103,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B103,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B103="","", IF(K103<0,"Error - gain sites must be postive ▲", (J103+H103+F103)-(D103)))
104 =IF(B104="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF108:AF355,B104,'D-1 Off-Site Habitat Baseline'!T108:T355)) =IF(B104="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B104,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B104="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B104,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B104="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B104,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B104="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B104,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B104="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B104,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B104="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B104,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B104="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B104,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B104="","",(I104+G104+E104)-(C104)) =IF(ISBLANK(B104),"",IFERROR(_xlfn.XLOOKUP(B104,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B104,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B104="","", IF(K104<0,"Error - gain sites must be postive ▲", (J104+H104+F104)-(D104)))
105 =IF(B105="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF109:AF356,B105,'D-1 Off-Site Habitat Baseline'!T109:T356)) =IF(B105="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B105,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B105="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B105,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B105="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B105,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B105="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B105,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B105="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B105,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B105="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B105,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B105="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B105,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B105="","",(I105+G105+E105)-(C105)) =IF(ISBLANK(B105),"",IFERROR(_xlfn.XLOOKUP(B105,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B105,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B105="","", IF(K105<0,"Error - gain sites must be postive ▲", (J105+H105+F105)-(D105)))
106 =IF(B106="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF110:AF357,B106,'D-1 Off-Site Habitat Baseline'!T110:T357)) =IF(B106="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B106,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B106="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B106,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B106="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B106,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B106="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B106,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B106="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B106,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B106="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B106,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B106="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B106,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B106="","",(I106+G106+E106)-(C106)) =IF(ISBLANK(B106),"",IFERROR(_xlfn.XLOOKUP(B106,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B106,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B106="","", IF(K106<0,"Error - gain sites must be postive ▲", (J106+H106+F106)-(D106)))
107 =IF(B107="","",SUMIF('D-1 Off-Site Habitat Baseline'!AF111:AF358,B107,'D-1 Off-Site Habitat Baseline'!T111:T358)) =IF(B107="","",SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,B107,'D-1 Off-Site Habitat Baseline'!$Q$11:$Q$258)) =IF(B107="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B107,'D-1 Off-Site Habitat Baseline'!$X$11:$X$258)) =IF(B107="","", SUMIF('D-1 Off-Site Habitat Baseline'!$AF$11:$AF$258,'Off-site gain site summary'!$B107,'D-1 Off-Site Habitat Baseline'!$AY$11:$AY$258)) =IF(B107="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B107,'D-3 Off-Site Habitat Enhancment'!$AQ$12:$AQ$258)) =IF(B107="","",SUMIF('D-3 Off-Site Habitat Enhancment'!$AU$12:$AU$258,'Off-site gain site summary'!B107,'D-3 Off-Site Habitat Enhancment'!$AP$12:$AP$258)) =IF(B107="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B107,'D-2 Off-Site Habitat Creation'!$AB$11:$AB$256)) =IF(B107="","",SUMIF('D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'Off-site gain site summary'!B107,'D-2 Off-Site Habitat Creation'!$AA$11:$AA$256)) =IF(B107="","",(I107+G107+E107)-(C107)) =IF(ISBLANK(B107),"",IFERROR(_xlfn.XLOOKUP(B107,'D-2 Off-Site Habitat Creation'!$AF$11:$AF$256,'D-2 Off-Site Habitat Creation'!$Z$11:$Z$256),IFERROR(_xlfn.XLOOKUP(B107,'D-1 Off-Site Habitat Baseline'!AF$11:AF$258,'D-1 Off-Site Habitat Baseline'!S$11:S$258)," "))) =IF(B107="","", IF(K107<0,"Error - gain sites must be postive ▲", (J107+H107+F107)-(D107)))