Wyoming State Water Plan, Wyoming Water Development Office
Rafting on Snake River Lake Marie, Snowy Mountains Wyoming Wind River Range picture

Sample Spreadsheet Model

AVERAGE MONTHLY FLOW

Christina Lake
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Christina Lake Initial Storage 275 348 418 508 636 1,185 2,071 1,020 511 265 237 332
Virgin Inflow 73 70 90 128 549 904 391 165 126 113 95 80
Evaporation 0 0 0 0 0 (18) (51) (24) (3) 0 0 0
Reservoir Releases 0 0 0 0 0 0 (1,391) (650) (369) (141) 0 0
Christina Lake EOM Content 348 418 508 636 1,185 2,071 1,020 511 265 237 332 412
Little Popo Agie Creek
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Virgin Inflow 331 317 410 580 2,498 4,116 1,779 750 574 513 430 363
Release from Christina Lake 0 0 0 0 0 0 1,391 650 369 141 0 0
Flow at Confluence 331 317 410 580 2,498 4,116 3,170 1,400 943 654 430 363
Tributary Inflows
Alantic Creek Inflow 266 253 317 441 1,920 3,142 1,387 584 447 401 337 289
Louis Creek Inflow 193 185 240 339 1,464 2,414 1,043 439 336 300 251 212
Pass Creek Inflow 110 106 140 235 934 1,498 641 282 220 198 135 120
Canyon Creek Inflow 172 165 213 302 1,298 2,140 925 390 298 267 224 189
Diversion (7) (7) (7) (70) (134) (134) (70) (70) (70) (70) (7) (7)
Deep Creek Inflow 536 512 650 741 3,531 6,037 2,663 1,064 794 701 739 595
Return Flow 21 19 17 16 32 53 58 43 42 42 43 24
Flow in River 1,622 1,550 1,980 2,584 11,543 19,266 9,817 4,132 3,010 2,493 2,152 1,785
Main Stem Diversions
Diversion 0 0 0 (38) (76) (76) (38) (38) (38) (38) 0 0
Return 8 7 6 5 15 26 30 21 21 20 21 10
Diversion 0 0 0 (43) (86) (86) (43) (43) (44) (44) 0 0
Return 9 8 7 6 17 30 34 24 23 23 24 12
Diversion 0 0 0 (60) (119) (119) (60) (60) (60) (60) 0 0
Return 13 11 10 8 23 41 46 33 32 32 32 16
Diversion 0 0 0 (34) (63) (63) (32) (32) (32) (32) 0 0
Return 7 6 5 4 12 22 25 17 17 17 17 8
Little Popo Agie Outflow 1,659 1,582 2,008 2,432 11,266 19,041 9,779 4,054 2,929 2,411 2,246 1,831