SPECIES

State

Totals

All Time Totals

10 year totals

3 Year running averages

Birds per 1000 Party Hours

SPECIES

Rank

Birds per

1000 PHs

1992

1993

1994

1995

1996

1997

1998

1999

2000

2001

2002

2003

2004

2005

2006

2007

yrs

Ave

Low

High

yrs

Ave

Low

High

92-05

2006

1992

1993

1994

1995

1996

1997

1998

1999

2000

2001

2002

2003

2004

2005

2006

2007

92-94

93-95

94-96

95-97

96-98

97-99

98-00

99-01

00-02

2001-03

2002-04

2003-05

2004-06

2005-07

Snow Goose

=COUNTA(C5:Q5)

=SUM(C5:Q5)/15

=MIN(C5:Q5)

=MAX(C5:Q5)

=COUNTA(H5:Q5)

=SUM(H5:Q5)/10

=MIN(H5:Q5)

=MAX(H5:Q5)

0.771111111111111

=SUM(C5)/(C$272/1000)

=SUM(D5)/(D$272/1000)

=SUM(E5)/(E$272/1000)

=SUM(F5)/(F$272/1000)

=SUM(G5)/(G$272/1000)

=SUM(H5)/(H$272/1000)

=SUM(I5)/(I$272/1000)

=SUM(J5)/(J$272/1000)

=SUM(K5)/(K$272/1000)

=SUM(L5)/(L$272/1000)

=SUM(M5)/(M$272/1000)

=SUM(N5)/(N$272/1000)

=SUM(O5)/(O$272/1000)

=SUM(P5)/(P$272/1000)

=SUM(Q5)/(Q$272/1000)

=SUM(R5)/(R$272/1000)

Snow Goose

Canada Goose

3173

3379

3925

4440

4593

5014

4388

4663

4974

5197

4619

3783

4071

3585

3743

3832

=COUNTA(C7:Q7)

=SUM(C7:Q7)/15

=MIN(C7:Q7)

=MAX(C7:Q7)

=COUNTA(H7:Q7)

=SUM(H7:Q7)/10

=MIN(H7:Q7)

=MAX(H7:Q7)

3683.67777777778

3743

=SUM(C7)/(C$272/1000)

=SUM(D7)/(D$272/1000)

=SUM(E7)/(E$272/1000)

=SUM(F7)/(F$272/1000)

=SUM(G7)/(G$272/1000)

=SUM(H7)/(H$272/1000)

=SUM(I7)/(I$272/1000)

=SUM(J7)/(J$272/1000)

=SUM(K7)/(K$272/1000)

=SUM(L7)/(L$272/1000)

=SUM(M7)/(M$272/1000)

=SUM(N7)/(N$272/1000)

=SUM(O7)/(O$272/1000)

=SUM(P7)/(P$272/1000)

=SUM(Q7)/(Q$272/1000)

=SUM(R7)/(R$272/1000)

=AVERAGE(AC7,AD7,AE7)

=AVERAGE(AD7,AE7,AF7)

=AVERAGE(AE7,AF7,AG7)

=AVERAGE(AF7,AG7,AH7)

=AVERAGE(AG7,AH7,AI7)

=AVERAGE(AH7,AI7,AJ7)

=AVERAGE(AI7,AJ7,AK7)

=AVERAGE(AJ7,AK7,AL7)

=AVERAGE(AK7,AL7,AM7)

=AVERAGE(AL7,AM7,AN7)

=AVERAGE(AM7,AN7,AO7)

=AVERAGE(AN7,AO7,AP7)

=AVERAGE(AO7,AP7,AQ7)

=AVERAGE(AP7,AQ7,AR7)

Canada Goose

Brant

=COUNTA(C8:Q8)

=SUM(C8:Q8)/15

=MIN(C8:Q8)

=MAX(C8:Q8)

=COUNTA(H8:Q8)

=SUM(H8:Q8)/10

=MIN(H8:Q8)

=MAX(H8:Q8)

12.2622222222222

=SUM(C8)/(C$272/1000)

=SUM(D8)/(D$272/1000)

=SUM(E8)/(E$272/1000)

=SUM(F8)/(F$272/1000)

=SUM(G8)/(G$272/1000)

=SUM(H8)/(H$272/1000)

=SUM(I8)/(I$272/1000)

=SUM(J8)/(J$272/1000)

=SUM(K8)/(K$272/1000)

=SUM(L8)/(L$272/1000)

=SUM(M8)/(M$272/1000)

=SUM(N8)/(N$272/1000)

=SUM(O8)/(O$272/1000)

=SUM(P8)/(P$272/1000)

=SUM(Q8)/(Q$272/1000)

=SUM(R8)/(R$272/1000)

=AVERAGE(AC8,AD8,AE8)

=AVERAGE(AD8,AE8,AF8)

=AVERAGE(AE8,AF8,AG8)

=AVERAGE(AF8,AG8,AH8)

=AVERAGE(AG8,AH8,AI8)

=AVERAGE(AH8,AI8,AJ8)

=AVERAGE(AI8,AJ8,AK8)

=AVERAGE(AJ8,AK8,AL8)

=AVERAGE(AK8,AL8,AM8)

=AVERAGE(AL8,AM8,AN8)

=AVERAGE(AM8,AN8,AO8)

=AVERAGE(AN8,AO8,AP8)

=AVERAGE(AO8,AP8,AQ8)

=AVERAGE(AP8,AQ8,AR8)

Brant

Mute Swan

259

377

383

297

331

351

372

353

419

341

462

300

184

165

172

306

=COUNTA(C9:Q9)

=AVERAGE(C9:Q9)

=MIN(C9:Q9)

=MAX(C9:Q9)

=COUNTA(H9:Q9)

=SUM(H9:Q9)/10

=MIN(H9:Q9)

=MAX(H9:Q9)

256.175555555556

172

=SUM(C9)/(C$272/1000)

=SUM(D9)/(D$272/1000)

=SUM(E9)/(E$272/1000)

=SUM(F9)/(F$272/1000)

=SUM(G9)/(G$272/1000)

=SUM(H9)/(H$272/1000)

=SUM(I9)/(I$272/1000)

=SUM(J9)/(J$272/1000)

=SUM(K9)/(K$272/1000)

=SUM(L9)/(L$272/1000)

=SUM(M9)/(M$272/1000)

=SUM(N9)/(N$272/1000)

=SUM(O9)/(O$272/1000)

=SUM(P9)/(P$272/1000)

=SUM(Q9)/(Q$272/1000)

=SUM(R9)/(R$272/1000)

=AVERAGE(AC9,AD9,AE9)

=AVERAGE(AD9,AE9,AF9)

=AVERAGE(AE9,AF9,AG9)

=AVERAGE(AF9,AG9,AH9)

=AVERAGE(AG9,AH9,AI9)

=AVERAGE(AH9,AI9,AJ9)

=AVERAGE(AI9,AJ9,AK9)

=AVERAGE(AJ9,AK9,AL9)

=AVERAGE(AK9,AL9,AM9)

=AVERAGE(AL9,AM9,AN9)

=AVERAGE(AM9,AN9,AO9)

=AVERAGE(AN9,AO9,AP9)

=AVERAGE(AO9,AP9,AQ9)

=AVERAGE(AP9,AQ9,AR9)

Mute Swan

Wood Duck

135

273

347

309

280

310

304

398

316

388

289

281

418

353

357

535

=COUNTA(C10:Q10)

=SUM(C10:Q10)/15

=MIN(C10:Q10)

=MAX(C10:Q10)

=COUNTA(H10:Q10)

=SUM(H10:Q10)/10

=MIN(H10:Q10)

=MAX(H10:Q10)

287.84

357

=SUM(C10)/(C$272/1000)

=SUM(D10)/(D$272/1000)

=SUM(E10)/(E$272/1000)

=SUM(F10)/(F$272/1000)

=SUM(G10)/(G$272/1000)

=SUM(H10)/(H$272/1000)

=SUM(I10)/(I$272/1000)

=SUM(J10)/(J$272/1000)

=SUM(K10)/(K$272/1000)

=SUM(L10)/(L$272/1000)

=SUM(M10)/(M$272/1000)

=SUM(N10)/(N$272/1000)

=SUM(O10)/(O$272/1000)

=SUM(P10)/(P$272/1000)

=SUM(Q10)/(Q$272/1000)

=SUM(R10)/(R$272/1000)

=AVERAGE(AC10,AD10,AE10)

=AVERAGE(AD10,AE10,AF10)

=AVERAGE(AE10,AF10,AG10)

=AVERAGE(AF10,AG10,AH10)

=AVERAGE(AG10,AH10,AI10)

=AVERAGE(AH10,AI10,AJ10)

=AVERAGE(AI10,AJ10,AK10)

=AVERAGE(AJ10,AK10,AL10)

=AVERAGE(AK10,AL10,AM10)

=AVERAGE(AL10,AM10,AN10)

=AVERAGE(AM10,AN10,AO10)

=AVERAGE(AN10,AO10,AP10)

=AVERAGE(AO10,AP10,AQ10)

=AVERAGE(AP10,AQ10,AR10)

Wood Duck

Gadwall

=COUNTA(C11:Q11)

=SUM(C11:Q11)/15

=MIN(C11:Q11)

=MAX(C11:Q11)

=COUNTA(H11:Q11)

=SUM(H11:Q11)/10

=MIN(H11:Q11)

=MAX(H11:Q11)

7.62222222222222

=SUM(C11)/(C$272/1000)

=SUM(D11)/(D$272/1000)

=SUM(E11)/(E$272/1000)

=SUM(F11)/(F$272/1000)

=SUM(G11)/(G$272/1000)

=SUM(H11)/(H$272/1000)

=SUM(I11)/(I$272/1000)

=SUM(J11)/(J$272/1000)

=SUM(K11)/(K$272/1000)

=SUM(L11)/(L$272/1000)

=SUM(M11)/(M$272/1000)

=SUM(N11)/(N$272/1000)

=SUM(O11)/(O$272/1000)

=SUM(P11)/(P$272/1000)

=SUM(Q11)/(Q$272/1000)

=SUM(R11)/(R$272/1000)

=AVERAGE(AC11,AD11,AE11)

=AVERAGE(AD11,AE11,AF11)

=AVERAGE(AE11,AF11,AG11)

=AVERAGE(AF11,AG11,AH11)

=AVERAGE(AG11,AH11,AI11)

=AVERAGE(AH11,AI11,AJ11)

=AVERAGE(AI11,AJ11,AK11)

=AVERAGE(AJ11,AK11,AL11)

=AVERAGE(AK11,AL11,AM11)

=AVERAGE(AL11,AM11,AN11)

=AVERAGE(AM11,AN11,AO11)

=AVERAGE(AN11,AO11,AP11)

=AVERAGE(AO11,AP11,AQ11)

=AVERAGE(AP11,AQ11,AR11)

Gadwall

American Wigeon

=COUNTA(C12:Q12)

=SUM(C12:Q12)/15

=MIN(C12:Q12)

=MAX(C12:Q12)

=COUNTA(H12:Q12)

=SUM(H12:Q12)/10

=MIN(H12:Q12)

=MAX(H12:Q12)

1.19111111111111

=SUM(C12)/(C$272/1000)

=SUM(D12)/(D$272/1000)

=SUM(E12)/(E$272/1000)

=SUM(F12)/(F$272/1000)

=SUM(G12)/(G$272/1000)

=SUM(H12)/(H$272/1000)

=SUM(I12)/(I$272/1000)

=SUM(J12)/(J$272/1000)

=SUM(K12)/(K$272/1000)

=SUM(L12)/(L$272/1000)

=SUM(M12)/(M$272/1000)

=SUM(N12)/(N$272/1000)

=SUM(O12)/(O$272/1000)

=SUM(P12)/(P$272/1000)

=SUM(Q12)/(Q$272/1000)

=SUM(R12)/(R$272/1000)

=AVERAGE(AC12,AD12,AE12)

=AVERAGE(AD12,AE12,AF12)

=AVERAGE(AE12,AF12,AG12)

=AVERAGE(AF12,AG12,AH12)

=AVERAGE(AG12,AH12,AI12)

=AVERAGE(AH12,AI12,AJ12)

=AVERAGE(AI12,AJ12,AK12)

=AVERAGE(AJ12,AK12,AL12)

=AVERAGE(AK12,AL12,AM12)

=AVERAGE(AL12,AM12,AN12)

=AVERAGE(AM12,AN12,AO12)

=AVERAGE(AN12,AO12,AP12)

=AVERAGE(AO12,AP12,AQ12)

=AVERAGE(AP12,AQ12,AR12)

American Wigeon

American Black Duck

117

106

115

120

=COUNTA(C13:Q13)

=SUM(C13:Q13)/15

=MIN(C13:Q13)

=MAX(C13:Q13)

=COUNTA(H13:Q13)

=SUM(H13:Q13)/10

=MIN(H13:Q13)

=MAX(H13:Q13)

60.72

=SUM(C13)/(C$272/1000)

=SUM(D13)/(D$272/1000)

=SUM(E13)/(E$272/1000)

=SUM(F13)/(F$272/1000)

=SUM(G13)/(G$272/1000)

=SUM(H13)/(H$272/1000)

=SUM(I13)/(I$272/1000)

=SUM(J13)/(J$272/1000)

=SUM(K13)/(K$272/1000)

=SUM(L13)/(L$272/1000)

=SUM(M13)/(M$272/1000)

=SUM(N13)/(N$272/1000)

=SUM(O13)/(O$272/1000)

=SUM(P13)/(P$272/1000)

=SUM(Q13)/(Q$272/1000)

=SUM(R13)/(R$272/1000)

=AVERAGE(AC13,AD13,AE13)

=AVERAGE(AD13,AE13,AF13)

=AVERAGE(AE13,AF13,AG13)

=AVERAGE(AF13,AG13,AH13)

=AVERAGE(AG13,AH13,AI13)

=AVERAGE(AH13,AI13,AJ13)

=AVERAGE(AI13,AJ13,AK13)

=AVERAGE(AJ13,AK13,AL13)

=AVERAGE(AK13,AL13,AM13)

=AVERAGE(AL13,AM13,AN13)

=AVERAGE(AM13,AN13,AO13)

=AVERAGE(AN13,AO13,AP13)

=AVERAGE(AO13,AP13,AQ13)

=AVERAGE(AP13,AQ13,AR13)

American Black Duck

Mallard

2083

2589

2361

2618

2579

2846

2923

3022

2318

2825

2018

1460

2325

1974

1679

2064

=COUNTA(C14:Q14)

=SUM(C14:Q14)/15

=MIN(C14:Q14)

=MAX(C14:Q14)

=COUNTA(H14:Q14)

=SUM(H14:Q14)/10

=MIN(H14:Q14)

=MAX(H14:Q14)

1886.77777777778

1679

=SUM(C14)/(C$272/1000)

=SUM(D14)/(D$272/1000)

=SUM(E14)/(E$272/1000)

=SUM(F14)/(F$272/1000)

=SUM(G14)/(G$272/1000)

=SUM(H14)/(H$272/1000)

=SUM(I14)/(I$272/1000)

=SUM(J14)/(J$272/1000)

=SUM(K14)/(K$272/1000)

=SUM(L14)/(L$272/1000)

=SUM(M14)/(M$272/1000)

=SUM(N14)/(N$272/1000)

=SUM(O14)/(O$272/1000)

=SUM(P14)/(P$272/1000)

=SUM(Q14)/(Q$272/1000)

=SUM(R14)/(R$272/1000)

=AVERAGE(AC14,AD14,AE14)

=AVERAGE(AD14,AE14,AF14)

=AVERAGE(AE14,AF14,AG14)

=AVERAGE(AF14,AG14,AH14)

=AVERAGE(AG14,AH14,AI14)

=AVERAGE(AH14,AI14,AJ14)

=AVERAGE(AI14,AJ14,AK14)

=AVERAGE(AJ14,AK14,AL14)

=AVERAGE(AK14,AL14,AM14)

=AVERAGE(AL14,AM14,AN14)

=AVERAGE(AM14,AN14,AO14)

=AVERAGE(AN14,AO14,AP14)

=AVERAGE(AO14,AP14,AQ14)

=AVERAGE(AP14,AQ14,AR14)

Mallard

Hybrid

=COUNTA(C15:Q15)

=SUM(C15:Q15)/15

=MIN(C15:Q15)

=MAX(C15:Q15)

=COUNTA(H15:Q15)

=SUM(H15:Q15)/10

=MIN(H15:Q15)

=MAX(H15:Q15)

1.8

=SUM(C15)/(C$272/1000)

=SUM(D15)/(D$272/1000)

=SUM(E15)/(E$272/1000)

=SUM(F15)/(F$272/1000)

=SUM(G15)/(G$272/1000)

=SUM(H15)/(H$272/1000)

=SUM(I15)/(I$272/1000)

=SUM(J15)/(J$272/1000)

=SUM(K15)/(K$272/1000)

=SUM(L15)/(L$272/1000)

=SUM(M15)/(M$272/1000)

=SUM(N15)/(N$272/1000)

=SUM(O15)/(O$272/1000)

=SUM(P15)/(P$272/1000)

=SUM(Q15)/(Q$272/1000)

=SUM(R15)/(R$272/1000)

=AVERAGE(AC15,AD15,AE15)

=AVERAGE(AD15,AE15,AF15)

=AVERAGE(AE15,AF15,AG15)

=AVERAGE(AF15,AG15,AH15)

=AVERAGE(AG15,AH15,AI15)

=AVERAGE(AH15,AI15,AJ15)

=AVERAGE(AI15,AJ15,AK15)

=AVERAGE(AJ15,AK15,AL15)

=AVERAGE(AK15,AL15,AM15)

=AVERAGE(AL15,AM15,AN15)

=AVERAGE(AM15,AN15,AO15)

=AVERAGE(AN15,AO15,AP15)

=AVERAGE(AO15,AP15,AQ15)

=AVERAGE(AP15,AQ15,AR15)

Hybrid

Blue-winged Teal

=COUNTA(C16:Q16)

=SUM(C16:Q16)/15

=MIN(C16:Q16)

=MAX(C16:Q16)

=COUNTA(H16:Q16)

=SUM(H16:Q16)/10

=MIN(H16:Q16)

=MAX(H16:Q16)

1.99555555555556

=SUM(C16)/(C$272/1000)

=SUM(D16)/(D$272/1000)

=SUM(E16)/(E$272/1000)

=SUM(F16)/(F$272/1000)

=SUM(G16)/(G$272/1000)

=SUM(H16)/(H$272/1000)

=SUM(I16)/(I$272/1000)

=SUM(J16)/(J$272/1000)

=SUM(K16)/(K$272/1000)

=SUM(L16)/(L$272/1000)

=SUM(M16)/(M$272/1000)

=SUM(N16)/(N$272/1000)

=SUM(O16)/(O$272/1000)

=SUM(P16)/(P$272/1000)

=SUM(Q16)/(Q$272/1000)

=SUM(R16)/(R$272/1000)

=AVERAGE(AC16,AD16,AE16)

=AVERAGE(AD16,AE16,AF16)

=AVERAGE(AE16,AF16,AG16)

=AVERAGE(AF16,AG16,AH16)

=AVERAGE(AG16,AH16,AI16)

=AVERAGE(AH16,AI16,AJ16)

=AVERAGE(AI16,AJ16,AK16)

=AVERAGE(AJ16,AK16,AL16)

=AVERAGE(AK16,AL16,AM16)

=AVERAGE(AL16,AM16,AN16)

=AVERAGE(AM16,AN16,AO16)

=AVERAGE(AN16,AO16,AP16)

=AVERAGE(AO16,AP16,AQ16)

=AVERAGE(AP16,AQ16,AR16)

Blue-winged Teal

Northern Shoveler

=COUNTA(C17:Q17)

=SUM(C17:Q17)/15

=MIN(C17:Q17)

=MAX(C17:Q17)

=COUNTA(H17:Q17)

=SUM(H17:Q17)/10

=MIN(H17:Q17)

=MAX(H17:Q17)

0.975555555555556

=SUM(C17)/(C$272/1000)

=SUM(D17)/(D$272/1000)

=SUM(E17)/(E$272/1000)

=SUM(F17)/(F$272/1000)

=SUM(G17)/(G$272/1000)

=SUM(H17)/(H$272/1000)

=SUM(I17)/(I$272/1000)

=SUM(J17)/(J$272/1000)

=SUM(K17)/(K$272/1000)

=SUM(L17)/(L$272/1000)

=SUM(M17)/(M$272/1000)

=SUM(N17)/(N$272/1000)

=SUM(O17)/(O$272/1000)

=SUM(P17)/(P$272/1000)

=SUM(Q17)/(Q$272/1000)

=SUM(R17)/(R$272/1000)

=AVERAGE(AC17,AD17,AE17)

=AVERAGE(AD17,AE17,AF17)

=AVERAGE(AE17,AF17,AG17)

=AVERAGE(AF17,AG17,AH17)

=AVERAGE(AG17,AH17,AI17)

=AVERAGE(AH17,AI17,AJ17)

=AVERAGE(AI17,AJ17,AK17)

=AVERAGE(AJ17,AK17,AL17)

=AVERAGE(AK17,AL17,AM17)

=AVERAGE(AL17,AM17,AN17)

=AVERAGE(AM17,AN17,AO17)

=AVERAGE(AN17,AO17,AP17)

=AVERAGE(AO17,AP17,AQ17)

=AVERAGE(AP17,AQ17,AR17)

Northern Shoveler

Northern Pintail

=COUNTA(C18:Q18)

=SUM(C18:Q18)/15

=MIN(C18:Q18)

=MAX(C18:Q18)

=COUNTA(H18:Q18)

=SUM(H18:Q18)/10

=MIN(H18:Q18)

=MAX(H18:Q18)

0.697777777777778

=SUM(C18)/(C$272/1000)

=SUM(D18)/(D$272/1000)

=SUM(E18)/(E$272/1000)

=SUM(F18)/(F$272/1000)

=SUM(G18)/(G$272/1000)

=SUM(H18)/(H$272/1000)

=SUM(I18)/(I$272/1000)

=SUM(J18)/(J$272/1000)

=SUM(K18)/(K$272/1000)

=SUM(L18)/(L$272/1000)

=SUM(M18)/(M$272/1000)

=SUM(N18)/(N$272/1000)

=SUM(O18)/(O$272/1000)

=SUM(P18)/(P$272/1000)

=SUM(Q18)/(Q$272/1000)

=SUM(R18)/(R$272/1000)

=AVERAGE(AC18,AD18,AE18)

=AVERAGE(AD18,AE18,AF18)

=AVERAGE(AE18,AF18,AG18)

=AVERAGE(AF18,AG18,AH18)

=AVERAGE(AG18,AH18,AI18)

=AVERAGE(AH18,AI18,AJ18)

=AVERAGE(AI18,AJ18,AK18)

=AVERAGE(AJ18,AK18,AL18)

=AVERAGE(AK18,AL18,AM18)

=AVERAGE(AL18,AM18,AN18)

=AVERAGE(AM18,AN18,AO18)

=AVERAGE(AN18,AO18,AP18)

=AVERAGE(AO18,AP18,AQ18)

=AVERAGE(AP18,AQ18,AR18)

Northern Pintail

Green-winged Teal

=COUNTA(C19:Q19)

=SUM(C19:Q19)/15

=MIN(C19:Q19)

=MAX(C19:Q19)

=COUNTA(H19:Q19)

=SUM(H19:Q19)/10

=MIN(H19:Q19)

=MAX(H19:Q19)

1.91333333333333

=SUM(C19)/(C$272/1000)

=SUM(D19)/(D$272/1000)

=SUM(E19)/(E$272/1000)

=SUM(F19)/(F$272/1000)

=SUM(G19)/(G$272/1000)

=SUM(H19)/(H$272/1000)

=SUM(I19)/(I$272/1000)

=SUM(J19)/(J$272/1000)

=SUM(K19)/(K$272/1000)

=SUM(L19)/(L$272/1000)

=SUM(M19)/(M$272/1000)

=SUM(N19)/(N$272/1000)

=SUM(O19)/(O$272/1000)

=SUM(P19)/(P$272/1000)

=SUM(Q19)/(Q$272/1000)

=SUM(R19)/(R$272/1000)

=AVERAGE(AC19,AD19,AE19)

=AVERAGE(AD19,AE19,AF19)

=AVERAGE(AE19,AF19,AG19)

=AVERAGE(AF19,AG19,AH19)

=AVERAGE(AG19,AH19,AI19)

=AVERAGE(AH19,AI19,AJ19)

=AVERAGE(AI19,AJ19,AK19)

=AVERAGE(AJ19,AK19,AL19)

=AVERAGE(AK19,AL19,AM19)

=AVERAGE(AL19,AM19,AN19)

=AVERAGE(AM19,AN19,AO19)

=AVERAGE(AN19,AO19,AP19)

=AVERAGE(AO19,AP19,AQ19)

=AVERAGE(AP19,AQ19,AR19)

Green-winged Teal

Canvasback Duck

=COUNTA(C20:Q20)

=SUM(C20:Q20)/15

=MIN(C20:Q20)

=MAX(C20:Q20)

=COUNTA(H20:Q20)

=SUM(H20:Q20)/10

=MIN(H20:Q20)

=MAX(H20:Q20)

0.204444444444444

=SUM(C20)/(C$272/1000)

=SUM(D20)/(D$272/1000)

=SUM(E20)/(E$272/1000)

=SUM(F20)/(F$272/1000)

=SUM(G20)/(G$272/1000)

=SUM(H20)/(H$272/1000)

=SUM(I20)/(I$272/1000)

=SUM(J20)/(J$272/1000)

=SUM(K20)/(K$272/1000)

=SUM(L20)/(L$272/1000)

=SUM(M20)/(M$272/1000)

=SUM(N20)/(N$272/1000)

=SUM(O20)/(O$272/1000)

=SUM(P20)/(P$272/1000)

=SUM(Q20)/(Q$272/1000)

=SUM(R20)/(R$272/1000)

=AVERAGE(AC20,AD20,AE20)

=AVERAGE(AD20,AE20,AF20)

=AVERAGE(AE20,AF20,AG20)

=AVERAGE(AF20,AG20,AH20)

=AVERAGE(AG20,AH20,AI20)

=AVERAGE(AH20,AI20,AJ20)

=AVERAGE(AI20,AJ20,AK20)

=AVERAGE(AJ20,AK20,AL20)

=AVERAGE(AK20,AL20,AM20)

=AVERAGE(AL20,AM20,AN20)

=AVERAGE(AM20,AN20,AO20)

=AVERAGE(AN20,AO20,AP20)

=AVERAGE(AO20,AP20,AQ20)

=AVERAGE(AP20,AQ20,AR20)

Canvasback Duck

Ring-necked Duck

=COUNTA(C21:Q21)

=SUM(C21:Q21)/15

=MIN(C21:Q21)

=MAX(C21:Q21)

=COUNTA(H21:Q21)

=SUM(H21:Q21)/10

=MIN(H21:Q21)

=MAX(H21:Q21)

0.98

=SUM(C21)/(C$272/1000)

=SUM(D21)/(D$272/1000)

=SUM(E21)/(E$272/1000)

=SUM(F21)/(F$272/1000)

=SUM(G21)/(G$272/1000)

=SUM(H21)/(H$272/1000)

=SUM(I21)/(I$272/1000)

=SUM(J21)/(J$272/1000)

=SUM(K21)/(K$272/1000)

=SUM(L21)/(L$272/1000)

=SUM(M21)/(M$272/1000)

=SUM(N21)/(N$272/1000)

=SUM(O21)/(O$272/1000)

=SUM(P21)/(P$272/1000)

=SUM(Q21)/(Q$272/1000)

=SUM(R21)/(R$272/1000)

=AVERAGE(AC21,AD21,AE21)

=AVERAGE(AD21,AE21,AF21)

=AVERAGE(AE21,AF21,AG21)

=AVERAGE(AF21,AG21,AH21)

=AVERAGE(AG21,AH21,AI21)

=AVERAGE(AH21,AI21,AJ21)

=AVERAGE(AI21,AJ21,AK21)

=AVERAGE(AJ21,AK21,AL21)

=AVERAGE(AK21,AL21,AM21)

=AVERAGE(AL21,AM21,AN21)

=AVERAGE(AM21,AN21,AO21)

=AVERAGE(AN21,AO21,AP21)

=AVERAGE(AO21,AP21,AQ21)

=AVERAGE(AP21,AQ21,AR21)

Ring-necked Duck

Greater Scaup

=COUNTA(C22:Q22)

=SUM(C22:Q22)/15

=MIN(C22:Q22)

=MAX(C22:Q22)

=COUNTA(H22:Q22)

=SUM(H22:Q22)/10

=MIN(H22:Q22)

=MAX(H22:Q22)

2.53555555555556

=SUM(C22)/(C$272/1000)

=SUM(D22)/(D$272/1000)

=SUM(E22)/(E$272/1000)

=SUM(F22)/(F$272/1000)

=SUM(G22)/(G$272/1000)

=SUM(H22)/(H$272/1000)

=SUM(I22)/(I$272/1000)

=SUM(J22)/(J$272/1000)

=SUM(K22)/(K$272/1000)

=SUM(L22)/(L$272/1000)

=SUM(M22)/(M$272/1000)

=SUM(N22)/(N$272/1000)

=SUM(O22)/(O$272/1000)

=SUM(P22)/(P$272/1000)

=SUM(Q22)/(Q$272/1000)

=SUM(R22)/(R$272/1000)

=AVERAGE(AC22,AD22,AE22)

=AVERAGE(AD22,AE22,AF22)

=AVERAGE(AE22,AF22,AG22)

=AVERAGE(AF22,AG22,AH22)

=AVERAGE(AG22,AH22,AI22)

=AVERAGE(AH22,AI22,AJ22)

=AVERAGE(AI22,AJ22,AK22)

=AVERAGE(AJ22,AK22,AL22)

=AVERAGE(AK22,AL22,AM22)

=AVERAGE(AL22,AM22,AN22)

=AVERAGE(AM22,AN22,AO22)

=AVERAGE(AN22,AO22,AP22)

=AVERAGE(AO22,AP22,AQ22)

=AVERAGE(AP22,AQ22,AR22)

Greater Scaup

Lesser Scaup

=COUNTA(C23:Q23)

=SUM(C23:Q23)/15

=MIN(C23:Q23)

=MAX(C23:Q23)

=COUNTA(H23:Q23)

=SUM(H23:Q23)/10

=MIN(H23:Q23)

=MAX(H23:Q23)

0.897777777777778

=SUM(C23)/(C$272/1000)

=SUM(D23)/(D$272/1000)

=SUM(E23)/(E$272/1000)

=SUM(F23)/(F$272/1000)

=SUM(G23)/(G$272/1000)

=SUM(H23)/(H$272/1000)

=SUM(I23)/(I$272/1000)

=SUM(J23)/(J$272/1000)

=SUM(K23)/(K$272/1000)

=SUM(L23)/(L$272/1000)

=SUM(M23)/(M$272/1000)

=SUM(N23)/(N$272/1000)

=SUM(O23)/(O$272/1000)

=SUM(P23)/(P$272/1000)

=SUM(Q23)/(Q$272/1000)

=SUM(R23)/(R$272/1000)

=AVERAGE(AC23,AD23,AE23)

=AVERAGE(AD23,AE23,AF23)

=AVERAGE(AE23,AF23,AG23)

=AVERAGE(AF23,AG23,AH23)

=AVERAGE(AG23,AH23,AI23)

=AVERAGE(AH23,AI23,AJ23)

=AVERAGE(AI23,AJ23,AK23)

=AVERAGE(AJ23,AK23,AL23)

=AVERAGE(AK23,AL23,AM23)

=AVERAGE(AL23,AM23,AN23)

=AVERAGE(AM23,AN23,AO23)

=AVERAGE(AN23,AO23,AP23)

=AVERAGE(AO23,AP23,AQ23)

=AVERAGE(AP23,AQ23,AR23)

Lesser Scaup

Common Eider

=COUNTA(C24:Q24)

=SUM(C24:Q24)/15

=MIN(C24:Q24)

=MAX(C24:Q24)

=COUNTA(H24:Q24)

=SUM(H24:Q24)/10

=MIN(H24:Q24)

=MAX(H24:Q24)

0.342222222222222

=SUM(C24)/(C$272/1000)

=SUM(D24)/(D$272/1000)

=SUM(E24)/(E$272/1000)

=SUM(F24)/(F$272/1000)

=SUM(G24)/(G$272/1000)

=SUM(H24)/(H$272/1000)

=SUM(I24)/(I$272/1000)

=SUM(J24)/(J$272/1000)

=SUM(K24)/(K$272/1000)

=SUM(L24)/(L$272/1000)

=SUM(M24)/(M$272/1000)

=SUM(N24)/(N$272/1000)

=SUM(O24)/(O$272/1000)

=SUM(P24)/(P$272/1000)

=SUM(Q24)/(Q$272/1000)

=SUM(R24)/(R$272/1000)

=AVERAGE(AC24,AD24,AE24)

=AVERAGE(AD24,AE24,AF24)

=AVERAGE(AE24,AF24,AG24)

=AVERAGE(AF24,AG24,AH24)

=AVERAGE(AG24,AH24,AI24)

=AVERAGE(AH24,AI24,AJ24)

=AVERAGE(AI24,AJ24,AK24)

=AVERAGE(AJ24,AK24,AL24)

=AVERAGE(AK24,AL24,AM24)

=AVERAGE(AL24,AM24,AN24)

=AVERAGE(AM24,AN24,AO24)

=AVERAGE(AN24,AO24,AP24)

=AVERAGE(AO24,AP24,AQ24)

=AVERAGE(AP24,AQ24,AR24)

Common Eider

White-winged Scoter

=COUNTA(C25:Q25)

=SUM(C25:Q25)/15

=MIN(C25:Q25)

=MAX(C25:Q25)

=COUNTA(H25:Q25)

=SUM(H25:Q25)/10

=MIN(H25:Q25)

=MAX(H25:Q25)

0.482222222222222

=SUM(C25)/(C$272/1000)

=SUM(D25)/(D$272/1000)

=SUM(E25)/(E$272/1000)

=SUM(F25)/(F$272/1000)

=SUM(G25)/(G$272/1000)

=SUM(H25)/(H$272/1000)

=SUM(I25)/(I$272/1000)

=SUM(J25)/(J$272/1000)

=SUM(K25)/(K$272/1000)

=SUM(L25)/(L$272/1000)

=SUM(M25)/(M$272/1000)

=SUM(N25)/(N$272/1000)

=SUM(O25)/(O$272/1000)

=SUM(P25)/(P$272/1000)

=SUM(Q25)/(Q$272/1000)

=SUM(R25)/(R$272/1000)

=AVERAGE(AC25,AD25,AE25)

=AVERAGE(AD25,AE25,AF25)

=AVERAGE(AE25,AF25,AG25)

=AVERAGE(AF25,AG25,AH25)

=AVERAGE(AG25,AH25,AI25)

=AVERAGE(AH25,AI25,AJ25)

=AVERAGE(AI25,AJ25,AK25)

=AVERAGE(AJ25,AK25,AL25)

=AVERAGE(AK25,AL25,AM25)

=AVERAGE(AL25,AM25,AN25)

=AVERAGE(AM25,AN25,AO25)

=AVERAGE(AN25,AO25,AP25)

=AVERAGE(AO25,AP25,AQ25)

=AVERAGE(AP25,AQ25,AR25)

White-winged Scoter

Long-tailed Duck

=COUNTA(C26:Q26)

=SUM(C26:Q26)/15

=MIN(C26:Q26)

=MAX(C26:Q26)

=COUNTA(H26:Q26)

=SUM(H26:Q26)/10

=MIN(H26:Q26)

=MAX(H26:Q26)

2.36

=SUM(C26)/(C$272/1000)

=SUM(D26)/(D$272/1000)

=SUM(E26)/(E$272/1000)

=SUM(F26)/(F$272/1000)

=SUM(G26)/(G$272/1000)

=SUM(H26)/(H$272/1000)

=SUM(I26)/(I$272/1000)

=SUM(J26)/(J$272/1000)

=SUM(K26)/(K$272/1000)

=SUM(L26)/(L$272/1000)

=SUM(M26)/(M$272/1000)

=SUM(N26)/(N$272/1000)

=SUM(O26)/(O$272/1000)

=SUM(P26)/(P$272/1000)

=SUM(Q26)/(Q$272/1000)

=SUM(R26)/(R$272/1000)

=AVERAGE(AC26,AD26,AE26)

=AVERAGE(AD26,AE26,AF26)

=AVERAGE(AE26,AF26,AG26)

=AVERAGE(AF26,AG26,AH26)

=AVERAGE(AG26,AH26,AI26)

=AVERAGE(AH26,AI26,AJ26)

=AVERAGE(AI26,AJ26,AK26)

=AVERAGE(AJ26,AK26,AL26)

=AVERAGE(AK26,AL26,AM26)

=AVERAGE(AL26,AM26,AN26)

=AVERAGE(AM26,AN26,AO26)

=AVERAGE(AN26,AO26,AP26)

=AVERAGE(AO26,AP26,AQ26)

=AVERAGE(AP26,AQ26,AR26)

Long-tailed Duck

Bufflehead

=COUNTA(C27:Q27)

=SUM(C27:Q27)/15

=MIN(C27:Q27)

=MAX(C27:Q27)

=COUNTA(H27:Q27)

=SUM(H27:Q27)/10

=MIN(H27:Q27)

=MAX(H27:Q27)

2.04444444444444

=SUM(C27)/(C$272/1000)

=SUM(D27)/(D$272/1000)

=SUM(E27)/(E$272/1000)

=SUM(F27)/(F$272/1000)

=SUM(G27)/(G$272/1000)

=SUM(H27)/(H$272/1000)

=SUM(I27)/(I$272/1000)

=SUM(J27)/(J$272/1000)

=SUM(K27)/(K$272/1000)

=SUM(L27)/(L$272/1000)

=SUM(M27)/(M$272/1000)

=SUM(N27)/(N$272/1000)

=SUM(O27)/(O$272/1000)

=SUM(P27)/(P$272/1000)

=SUM(Q27)/(Q$272/1000)

=SUM(R27)/(R$272/1000)

=AVERAGE(AC27,AD27,AE27)

=AVERAGE(AD27,AE27,AF27)

=AVERAGE(AE27,AF27,AG27)

=AVERAGE(AF27,AG27,AH27)

=AVERAGE(AG27,AH27,AI27)

=AVERAGE(AH27,AI27,AJ27)

=AVERAGE(AI27,AJ27,AK27)

=AVERAGE(AJ27,AK27,AL27)

=AVERAGE(AK27,AL27,AM27)

=AVERAGE(AL27,AM27,AN27)

=AVERAGE(AM27,AN27,AO27)

=AVERAGE(AN27,AO27,AP27)

=AVERAGE(AO27,AP27,AQ27)

=AVERAGE(AP27,AQ27,AR27)

Bufflehead

Common Goldeneye

=COUNTA(C28:Q28)

=SUM(C28:Q28)/15

=MIN(C28:Q28)

=MAX(C28:Q28)

=COUNTA(H28:Q28)

=SUM(H28:Q28)/10

=MIN(H28:Q28)

=MAX(H28:Q28)

1.37777777777778

=SUM(C28)/(C$272/1000)

=SUM(D28)/(D$272/1000)

=SUM(E28)/(E$272/1000)

=SUM(F28)/(F$272/1000)

=SUM(G28)/(G$272/1000)

=SUM(H28)/(H$272/1000)

=SUM(I28)/(I$272/1000)

=SUM(J28)/(J$272/1000)

=SUM(K28)/(K$272/1000)

=SUM(L28)/(L$272/1000)

=SUM(M28)/(M$272/1000)

=SUM(N28)/(N$272/1000)

=SUM(O28)/(O$272/1000)

=SUM(P28)/(P$272/1000)

=SUM(Q28)/(Q$272/1000)

=SUM(R28)/(R$272/1000)

=AVERAGE(AC28,AD28,AE28)

=AVERAGE(AD28,AE28,AF28)

=AVERAGE(AE28,AF28,AG28)

=AVERAGE(AF28,AG28,AH28)

=AVERAGE(AG28,AH28,AI28)

=AVERAGE(AH28,AI28,AJ28)

=AVERAGE(AI28,AJ28,AK28)

=AVERAGE(AJ28,AK28,AL28)

=AVERAGE(AK28,AL28,AM28)

=AVERAGE(AL28,AM28,AN28)

=AVERAGE(AM28,AN28,AO28)

=AVERAGE(AN28,AO28,AP28)

=AVERAGE(AO28,AP28,AQ28)

=AVERAGE(AP28,AQ28,AR28)

Common Goldeneye

Hooded Merganser

=COUNTA(C29:Q29)

=SUM(C29:Q29)/15

=MIN(C29:Q29)

=MAX(C29:Q29)

=COUNTA(H29:Q29)

=SUM(H29:Q29)/10

=MIN(H29:Q29)

=MAX(H29:Q29)

27.3355555555556

=SUM(C29)/(C$272/1000)

=SUM(D29)/(D$272/1000)

=SUM(E29)/(E$272/1000)

=SUM(F29)/(F$272/1000)

=SUM(G29)/(G$272/1000)

=SUM(H29)/(H$272/1000)

=SUM(I29)/(I$272/1000)

=SUM(J29)/(J$272/1000)

=SUM(K29)/(K$272/1000)

=SUM(L29)/(L$272/1000)

=SUM(M29)/(M$272/1000)

=SUM(N29)/(N$272/1000)

=SUM(O29)/(O$272/1000)

=SUM(P29)/(P$272/1000)

=SUM(Q29)/(Q$272/1000)

=SUM(R29)/(R$272/1000)

=AVERAGE(AC29,AD29,AE29)

=AVERAGE(AD29,AE29,AF29)

=AVERAGE(AE29,AF29,AG29)

=AVERAGE(AF29,AG29,AH29)

=AVERAGE(AG29,AH29,AI29)

=AVERAGE(AH29,AI29,AJ29)

=AVERAGE(AI29,AJ29,AK29)

=AVERAGE(AJ29,AK29,AL29)

=AVERAGE(AK29,AL29,AM29)

=AVERAGE(AL29,AM29,AN29)

=AVERAGE(AM29,AN29,AO29)

=AVERAGE(AN29,AO29,AP29)

=AVERAGE(AO29,AP29,AQ29)

=AVERAGE(AP29,AQ29,AR29)

Hooded Merganser

Common Merganser

132

161

108

196

110

134

124

113

102

110

=COUNTA(C30:Q30)

=SUM(C30:Q30)/15

=MIN(C30:Q30)

=MAX(C30:Q30)

=COUNTA(H30:Q30)

=SUM(H30:Q30)/10

=MIN(H30:Q30)

=MAX(H30:Q30)

107.38

102

=SUM(C30)/(C$272/1000)

=SUM(D30)/(D$272/1000)

=SUM(E30)/(E$272/1000)

=SUM(F30)/(F$272/1000)

=SUM(G30)/(G$272/1000)

=SUM(H30)/(H$272/1000)

=SUM(I30)/(I$272/1000)

=SUM(J30)/(J$272/1000)

=SUM(K30)/(K$272/1000)

=SUM(L30)/(L$272/1000)

=SUM(M30)/(M$272/1000)

=SUM(N30)/(N$272/1000)

=SUM(O30)/(O$272/1000)

=SUM(P30)/(P$272/1000)

=SUM(Q30)/(Q$272/1000)

=SUM(R30)/(R$272/1000)

=AVERAGE(AC30,AD30,AE30)

=AVERAGE(AD30,AE30,AF30)

=AVERAGE(AE30,AF30,AG30)

=AVERAGE(AF30,AG30,AH30)

=AVERAGE(AG30,AH30,AI30)

=AVERAGE(AH30,AI30,AJ30)

=AVERAGE(AI30,AJ30,AK30)

=AVERAGE(AJ30,AK30,AL30)

=AVERAGE(AK30,AL30,AM30)

=AVERAGE(AL30,AM30,AN30)

=AVERAGE(AM30,AN30,AO30)

=AVERAGE(AN30,AO30,AP30)

=AVERAGE(AO30,AP30,AQ30)

=AVERAGE(AP30,AQ30,AR30)

Common Merganser

Red-breasted Merganser

=COUNTA(C31:Q31)

=SUM(C31:Q31)/15

=MIN(C31:Q31)

=MAX(C31:Q31)

=COUNTA(H31:Q31)

=SUM(H31:Q31)/10

=MIN(H31:Q31)

=MAX(H31:Q31)

3.58666666666667

=SUM(C31)/(C$272/1000)

=SUM(D31)/(D$272/1000)

=SUM(E31)/(E$272/1000)

=SUM(F31)/(F$272/1000)

=SUM(G31)/(G$272/1000)

=SUM(H31)/(H$272/1000)

=SUM(I31)/(I$272/1000)

=SUM(J31)/(J$272/1000)

=SUM(K31)/(K$272/1000)

=SUM(L31)/(L$272/1000)

=SUM(M31)/(M$272/1000)

=SUM(N31)/(N$272/1000)

=SUM(O31)/(O$272/1000)

=SUM(P31)/(P$272/1000)

=SUM(Q31)/(Q$272/1000)

=SUM(R31)/(R$272/1000)

=AVERAGE(AC31,AD31,AE31)

=AVERAGE(AD31,AE31,AF31)

=AVERAGE(AE31,AF31,AG31)

=AVERAGE(AF31,AG31,AH31)

=AVERAGE(AG31,AH31,AI31)

=AVERAGE(AH31,AI31,AJ31)

=AVERAGE(AI31,AJ31,AK31)

=AVERAGE(AJ31,AK31,AL31)

=AVERAGE(AK31,AL31,AM31)

=AVERAGE(AL31,AM31,AN31)

=AVERAGE(AM31,AN31,AO31)

=AVERAGE(AN31,AO31,AP31)

=AVERAGE(AO31,AP31,AQ31)

=AVERAGE(AP31,AQ31,AR31)

Red-breasted Merganser

Ruddy Duck

=COUNTA(C32:Q32)

=SUM(C32:Q32)/15

=MIN(C32:Q32)

=MAX(C32:Q32)

=COUNTA(H32:Q32)

=SUM(H32:Q32)/10

=MIN(H32:Q32)

=MAX(H32:Q32)

2.87111111111111

=SUM(C32)/(C$272/1000)

=SUM(D32)/(D$272/1000)

=SUM(E32)/(E$272/1000)

=SUM(F32)/(F$272/1000)

=SUM(G32)/(G$272/1000)

=SUM(H32)/(H$272/1000)

=SUM(I32)/(I$272/1000)

=SUM(J32)/(J$272/1000)

=SUM(K32)/(K$272/1000)

=SUM(L32)/(L$272/1000)

=SUM(M32)/(M$272/1000)

=SUM(N32)/(N$272/1000)

=SUM(O32)/(O$272/1000)

=SUM(P32)/(P$272/1000)</