Spreadsheet: phillip_allen__28877__rockies
Sheet: FCST

 |  |  |  |  |  |  | ZCD | ZCD |  | ZCD |  |  |  |  |  |  | [NAME]
 | SUPPLY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CIG | WIC |  |  |  | TAKE-AWAY |  |  |  |  |  |  |  |  |  | Stranded Volume after ZERO COST Displacement
 | CIG |  |  |  |  |  | WIC |  |  |  |  |  |  |  |  |  | Laramie | [NAME] | Medicine | Other |  | CIG |  |  | WIC |  |  | PSCO |  |  | ZERO COST Displacement
 | King | Nat Buttes | [NAME] | Lost Creek | Wind Rvr | Powder Rvr | OT | Kanda | Baxter | Wapiti | Red Sand | Wamsutter | Rawlins | Rawlins East | Laramie | Medicine Bow | East | East | Bow | Rockies | TOTAL | Arrowhead | Chey S | [NAME] | Dull Knife | Rockport | Tomahawk | Seasonal | TOTAL | Excess Supply
 | 145 | 170 | 195 | 150-400 | 270 | 58 | 646 | 279 |  |  |  |  |  | 710 |  | 274-380-440-940* | 600 | 810 | 380-940* |  |  | 10 | 600 | 330 | 500 | 120 | 54 | 50/310 |  |  | 260 | 260
2000-07-01 00:00:00 | 50 | 141 | 195 | 0 | 270 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 | 260 | 400 |  | 0 | 5 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 0 | 270 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 | 275 | 400 |  | 0 | 5 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 100 | 180 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 | 290 | 410 |  | 0 | 5 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 120 | 180 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 430 |  | 305 | 5 |  | 10 | 450 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 140 | 180 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 450 |  | 320 | 8 |  | 10 | 600 | 150 | 500 | 60 | 54 | 310 |  |  |  | 0
 | 50 | 141 | 195 | 145 | 180 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 455 |  | 335 | 8 |  | 10 | 600 | 150 | 500 | 60 | 54 | 310 |  |  |  | 0
 | 50 | 141 | 195 | 150 | 180 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 460 |  | 350 | 8 |  | 10 | 600 | 150 | 500 | 60 | 54 | 310 |  |  |  | 0
 | 50 | 141 | 195 | 150 | 180 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 460 |  | 365 | 8 |  | 10 | 600 | 150 | 500 | 60 | 54 | 310 |  |  |  | 0
 | 50 | 141 | 195 | 150 | 190 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 470 |  | 380 | 8 |  | 10 | 600 | 150 | 500 | 60 | 54 | 310 |  |  |  | 0
 | 50 | 141 | 195 | 165 | 190 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 485 |  | 380 | 80 |  | 10 | 430 | 320 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 180 | 190 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 500 |  | 380 | 80 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 195 | 200 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 525 |  | 380 | 80 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 210 | 200 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 540 |  | 380 | 80 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 215 | 200 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 545 |  | 380 | 80 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 215 | 200 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 545 |  | 380 | 80 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 235 | 210 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 575 |  | 390 | 80 |  | 10 | 450 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 235 | 210 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 575 |  | 410 | 120 |  | 10 | 600 | 150 | 500 | 60 | 54 | 310
 | 50 | 141 | 195 | 235 | 210 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 575 |  | 460 | 120 |  | 10 | 600 | 150 | 500 | 60 | 54 | 310
 | 50 | 141 | 195 | 235 | 220 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 585 |  | 485 | 120 |  | 10 | 600 | 150 | 500 | 60 | 54 | 310
 | 50 | 141 | 195 | 235 | 220 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 585 |  | 510 | 120 |  | 10 | 600 | 150 | 500 | 60 | 54 | 310
 | 50 | 141 | 195 | 235 | 220 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 585 |  | 535 | 120 |  | 10 | 600 | 150 | 500 | 60 | 54 | 310
 | 50 | 141 | 195 | 235 | 220 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 585 |  | 560 | 160 |  | 10 | 430 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 235 | 230 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 595 |  | 585 | 160 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 235 | 230 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 595 |  | 610 | 160 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 235 | 230 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 595 |  | 635 | 160 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 235 | 240 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 600 |  | 660 | 160 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 305 | 270 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 600 |  | 685 | 160 |  | 10 | 400 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 315 | 270 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 600 |  | 710 | 160 |  | 10 | 450 | 330 | 500 | 120 | 54 | 50
 | 50 | 141 | 195 | 325 | 270 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 |  | 45 |  | 600 |  | 735 | 180 |  | 10 | 600 | 150 | 500 | 120 | 54 | 310
 | 50 | 141 | 195 | 325 | 270 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 | 447 | 45 |  | 600 | 617 | 760 | 180 |  | 10 | 600 | 150 | 500 | 120 | 54 | 310
 | 50 | 141 | 195 | 325 | 270 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 | 447 | 45 |  | 600 | 617 | 785 | 180 |  | 10 | 600 | 150 | 500 | 120 | 54 | 310
 | 50 | 141 | 195 | 325 | 270 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 | 447 | 45 |  | 600 | 617 | 810 | 180 |  | 10 | 600 | 150 | 500 | 120 | 54 | 310
 | 50 | 141 | 195 | 325 | 270 | 58 | 72 | 120 | 48 | 68 | 9 | 95 | 35 | 447 | 45 |  | 600 | 617 | 835 | 180 |  | 10 | 600 | 150 | 500 | 120 | 54 | 310
 | *Assumption that Medicine Bow will expand [NAME] capacity to 500 11/1/2001
HISTORICALS
 | CIG |  |  |  |  |  | WIC |  |  |  |  |  |  |  |  |  | Laramie | [NAME] | Medicine |  |  | CIG |  |  | WIC
 | King | Nat Buttes | [NAME] | Lost Creek | Wind Rvr | Powder Rvr | OT | Kanda | Baxter | Wapiti | Red Sand | Wamsutter | Rawlins | Rawlins East | Laramie | Medicine Bow | East | East | Bow |  | TOTAL | Arrowhead | Chey S | [NAME] | Dull Knife | Rockport | Tomahawk
1997-01-01 00:00:00 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USAGE FIGURES
 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.  Denver usage over the past two winters has averaged 930Mcf.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - winters have been very mild the past two years.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.  All time peak consumption has been 1.5Bcf
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.  Estimated [NAME] peak is 1.8Bcf
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.  Estimate for average load for an average winter is 1Bcf  - 1.2Bcf.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  | DENVER WX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 230 |  |  |  |  |  |  |  |  |  |  |  |  | norm | 37.6 | 29.6 | 28.2 | 32.3 | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 260
 | 2000-01-01 00:00:00