Spreadsheet: matthew_lenhart__26081__Book1
Sheet: Sheet2

 |  |  | CERA Production |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 1000
 |  |  | Supply |  |  |  |  | Demand |  |  |  |  |  |  |  |  | Storage |  |  | Excess | Clay Basin | Denver Storage
 |  | Date | Rockies Receipts | Incr Rox Supply | SJ Rec- EPNG | SJ Rec- TW | Total Supply | Colorado Demand |  | Utah Demand | Kemmerer | San Juan Triangle | TW Triangle | East Outlet | Kern River | Total Demand | Clay Basin | Denver Storage | Total Storage | Supply | Balance | Balance
 | 31 | 2000-01-01 00:00:00 | 3789.867709677419 |  | 2175.165580645161 | 916.5590322580645 | 6881.592322580645 | 1161 |  | 551 | -483.8690322580645 | 2667.249290322581 | 754.7896129032258 | 950 | 912.6093870967743 | 7419.602225806451 | -346.1610322580645 | -191.8488709677419 | -538.0099032258064 | 0 | 19882082 | 27228995 | -5947315
 | 29 | 2000-02-01 00:00:00 | 3834.920310344828 |  | 2176.387517241379 | 976.0964827586207 | 6987.404310344827 | 1100 |  | 515 | -448.5073103448276 | 2700.963724137931 | 807.9293448275862 | 950 | 894.492448275862 | 7363.856827586206 | -280.1044827586207 | -96.34803448275862 | -376.4525172413793 | 0 | 11759052 | 24434902 | -2794093
 | 31 | 2000-03-01 00:00:00 | 3792.19129032258 |  | 2197.259677419355 | 970.4873548387097 | 6959.938322580644 | 1032 |  | 490 | -457.1522903225807 | 2717.890580645161 | 823.9342903225806 | 950 | 859.6460322580645 | 7276.995903225806 | -93.33016129032258 | -223.7274193548387 | -317.0575806451613 | 0 | 8865817 | 17499352 | -6935550
 | 30 | 2000-04-01 00:00:00 | 3802.252192592592 |  | 2178.550666666667 | 770.875 | 6751.677859259258 | 700 |  | 309 | -429.1636333333333 | 2674.6213 | 749.4585925925926 | 980 | 829.1951000000003 | 6642.893392592592 | 167.4504 | -58.66593333333334 | 108.7844666666667 | -6.252776074688882e-13 | 13889329 | 15739374 | -1759978
 | 31 | 2000-05-01 00:00:00 | 3810.025774193549 |  | 2074.120967741936 | 1020.237032258064 | 6904.383774193549 | 581 |  | 226 | -417.7527741935484 | 2665.59864516129 | 851.844064516129 | 1150 | 805.6302580645162 | 6670.887096774194 | 201.2051290322581 | 32.29154838709677 | 233.4966774193549 | 5.115907697472721e-13 | 20126688 | 16740412 | 1001038
 | 30 | 2000-06-01 00:00:00 | 3822.1005 |  | 2045.6734 | 973.9242666666667 | 6841.698166666667 | 500 |  | 233 | -357.2803333333333 | 2607.173733333334 | 847.4194 | 1150 | 796.6697999999998 | 6475.064600000001 | 205.6530333333334 | 160.9805333333333 | 366.6335666666666 | 0 | 26296279 | 21569828 | 4829416
 | 31 | 2000-07-01 00:00:00 | 3882.388516129032 |  | 2075.247677419355 | 1015.787193548387 | 6973.423387096775 | 450 |  | 225 | -370.0274193548387 | 2681.214967741936 | 875.4233548387097 | 1175 | 784.5493548387097 | 6551.874903225807 | 247.622 | 173.9264838709677 | 421.5484838709677 | 0 | 33972561 | 26961549 | 5391721
 | 31 | 2000-08-01 00:00:00 | 3906.045290322581 |  | 2086.876903225806 | 972.6534516129033 | 6965.575645161291 | 500 |  | 225 | -328.979 | 2690.344612903226 | 859.6444516129033 | 1175 | 815.0017741935484 | 6584.858032258065 | 222.1284193548387 | 158.5891935483871 | 380.7176129032258 | 0 | 40858542 | 31877814 | 4916265
 | 30 | 2000-09-01 00:00:00 | 3923.3866 |  | 2110.9359 | 1004.872866666667 | 7039.195366666667 | 500 |  | 250 | -437.5290666666667 | 2761.519333333334 | 809.3564666666666 | 1175 | 842.3808000000001 | 6766.386366666667 | 204.131 | 68.678 | 272.809 | 0 | 46112621 | 33938154 | 2060340
 | 31 | 2000-10-01 00:00:00 | 3998.151141824248 |  | 2190.815612903226 | 977.0585161290322 | 7166.025270856507 | 700 |  | 350 | -463.4551612903226 | 2727.822387096774 | 840.9454354838709 | 1200 | 877.7775172413791 | 7150.097432146829 | -33.58180645161291 | 49.50964516129032 | 15.92783870967742 | 0 | 45071585 | 35472953 | 1534799
 | 30 | 2000-11-01 00:00:00 | 4000 |  | 2014.9467 | 1028 | 7043 | 1100 |  | 600 | -478 | 2570.322166666666 | 883.7420500000001 | 1050 | 848.3237333333333 | 7530 | -344.3453 | -142.6897333333334 | -487.0350333333333 | 6.821210263296962e-13 | 34741226 | 31192261 | -4280692
 | 31 | 2000-12-01 00:00:00 | 4032.682335133054 |  | 2087.678974358974 | 1087.001482758621 | 7207.36279225065 | 1200 |  | 670 | -497.2827666666666 | 2614.920344827586 | 806.621 | 1000 | 928.8795517241379 | 7717.703663218392 | -394.3814838709678 | -115.9593870967742 | -510.340870967742 | 5.115907697472721e-13 | 22515400 | 27597520 | -3594741
 | 31 | 2001-01-01 00:00:00 | 4095.006763997034 |  | 2121.516548387097 | 1025.499806451613 | 7242.023118835744 | 1170 |  | 700 | -425.6332666666667 | 2663.346967741936 | 843.3977586206896 | 1000 | 992.3163193548387 | 7794.694312384131 | -422.4317741935484 | -130.2394193548387 | -552.6711935483871 | 0 | 9420015 | 23560098 | -4037422
29 | 28 | 2001-02-01 00:00:00 | 4271.220840526013 |  | 2118.977307692307 | 997.3971785714286 | 7387.595326789748 | 1150 |  | 640 | -491.4578928571428 | 2606.594423076923 | 843.9695 | 1020 | 956.0344074074075 | 7708.056223341473 | -154.6408965517242 | -165.82 | -320.4608965517241 | 0 | 5090069.896551724 | 18917138 | -4477140
 | 31 | 2001-03-01 00:00:00 | 4291.220840526013 | 20 | 2100 | 1000 | 7391.220840526013 | 1000 |  | 500 | -485 | 2620 | 850 | 1050 | 950 | 7455 | -10 | -150 | -160 | 96.22084052601258 | 4780069.896551724 | 14267138
 | 30 | 2001-04-01 00:00:00 | 4311.220840526013 | 20 | 2100 | 1025 | 7436.220840526013 | 700 |  | 350 | -485 | 2685 | 835 | 1150 | 925 | 7130 | 185 | 15 | 200 | 106.2208405260126 | 10330069.89655172 | 14717138
 | 31 | 2001-05-01 00:00:00 | 4331.220840526013 | 20 | 2100 | 1025 | 7456.220840526013 | 580 |  | 226 | -485 | 2685 | 835 | 1150 | 925 | 6886 | 300 | 170 | 470 | 100.2208405260126 | 19630069.89655172 | 19987138
 | 30 | 2001-06-01 00:00:00 | 4351.220840526013 | 20 | 2100 | 1025 | 7476.220840526013 | 500 | 68.94 | 233 | -485 | 2685 | 835 | 1150 | 925 | 6881.94 | 300 | 200 | 500 | 94.28084052601207 | 28630069.89655172 | 25987138
 | 31 | 2001-07-01 00:00:00 | 4371.220840526013 | 20 | 2100 | 1025 | 7496.220840526013 | 450 | 68.94 | 225 | -485 | 2685 | 835 | 1150 | 925 | 6823.94 | 300 | 200 | 500 | 172.2808405260121 | 37930069.89655173 | 32187138
 | 31 | 2001-08-01 00:00:00 | 4391.220840526013 | 20 | 2100 | 1025 | 7516.220840526013 | 500 | 68.94 | 225 | -485 | 2685 | 835 | 1150 | 925 | 6873.94 | 300 | 175 | 475 | 167.2808405260121 | 47230069.89655173 | 37612138
 | 30 | 2001-09-01 00:00:00 | 4411.220840526013 | 20 | 2100 | 1025 | 7536.220840526013 | 500 | 68.94 | 250 | -485 | 2685 | 835 | 1150 | 925 | 6898.94 | 300 | 0 | 300 | 337.2808405260121 | 56230069.89655173 | 37612138
 | 31 | 2001-10-01 00:00:00 | 4431.220840526013 | 20 | 2100 | 1025 | 7556.220840526013 | 700 | 68.94 | 350 | -485 | 2685 | 835 | 1150 | 925 | 7198.94 | 50 | 0 | 50 | 307.2808405260121 | 57780069.89655173 | 37612138
 | 30 | 2001-11-01 00:00:00 | 4451.220840526013 | 20 | 2100 | 1000 | 7551.220840526013 | 1050 | 68.94 | 620 | -475 | 2700 | 850 | 1100 | 950 | 7813.94 | -225 | -70 | -295 | 32.28084052601207 | 51030069.89655173 | 35512138
 | 31 | 2001-12-01 00:00:00 | 4471.220840526013 | 20 | 2100 | 1000 | 7571.220840526013 | 1200 | 68.94 | 700 | -475 | 2700 | 850 | 1100 | 950 | 8043.94 | -315 | -185 | -500 | 27.28084052601207 | 41265069.89655173 | 29777138
 | 31 | 2002-01-01 00:00:00 | 4511.220840526013 | 40 | 2100 | 1000 | 7611.220840526013 | 1150 | 68.94 | 700 | -475 | 2700 | 850 | 1100 | 950 | 7993.94 | -260 | -150 | -410 | 27.28084052601207 | 33205069.89655173 | 25127138
 | 28 | 2002-02-01 00:00:00 | 4551.220840526013 | 40 | 2100 | 1000 | 7651.220840526013 | 1050 | 68.94 | 650 | -475 | 2700 | 850 | 1100 | 950 | 7843.94 | -140 | -80 | -220 | 27.28084052601207 | 29285069.89655173 | 22887138
 | 31 | 2002-03-01 00:00:00 | 4591.220840526013 | 40 | 2100 | 1000 | 7691.220840526013 | 1000 | 68.94 | 550 | -475 | 2700 | 850 | 1100 | 950 | 7693.94 | 20 | -50 | -30 | 27.28084052601207 | 29905069.89655173 | 21337138
 | 30 | 2002-04-01 00:00:00 | 4631.220840526013 | 40 | 2050 | 1000 | 7681.220840526013 | 700 | 68.94 | 350 | -475 | 2700 | 850 | 1150 | 950 | 7243.94 | 210 | 100 | 310 | 127.2808405260121 | 36205069.89655173 | 24337138
 | 31 | 2002-05-01 00:00:00 | 4671.220840526013 | 40 | 2050 | 1000 | 7721.220840526013 | 580 | 78.84 | 225 | -475 | 2700 | 850 | 1150 | 1075 | 7133.84 | 300 | 200 | 500 | 87.38084052601243 | 45505069.89655173 | 30537138
 | 30 | 2002-06-01 00:00:00 | 4711.220840526013 | 40 | 2050 | 1000 | 7761.220840526013 | 500 | 78.84 | 235 | -475 | 2700 | 850 | 1150 | 1075 | 7063.84 | 300 | 200 | 500 | 197.3808405260124 | 54505069.89655173 | 36537138
 | 31 | 2002-07-01 00:00:00 | 4751.220840526013 | 40 | 2050 | 1000 | 7801.220840526013 | 450 | 78.84 | 225 | -475 | 2700 | 850 | 1150 | 1075 | 7003.84 | 75 | 25 | 100 | 697.3808405260124 | 56830069.89655173 | 37312138
 | 31 | 2002-08-01 00:00:00 | 4791.220840526013 | 40 | 2050 | 1000 | 7841.220840526013 | 500 | 78.84 | 225 | -475 | 2700 | 850 | 1325 | 1075 | 7228.84 | 0 | 0 | 0 | 612.3808405260124 | 56830069.89655173 | 37312138
 | 30 | 2002-09-01 00:00:00 | 4831.220840526013 | 40 | 2050 | 1000 | 7881.220840526013 | 500 | 78.84 | 250 | -475 | 2700 | 850 | 1325 | 1075 | 7253.84 | 0 | 0 | 0 | 627.3808405260124 | 56830069.89655173 | 37312138
 | 31 | 2002-10-01 00:00:00 | 4871.220840526013 | 40 | 2050 | 1000 | 7921.220840526013 | 700 | 78.84 | 350 | -475 | 2700 | 850 | 1325 | 1075 | 7553.84 | 0 | 0 | 0 | 367.3808405260124 | 56830069.89655173 | 37312138
 |  | 2002-11-01 00:00:00
 |  |  |  | [NAME] | This Fcst | Difference
 |  |  | 2001 | 4.18 BCF/d | 4.25 BCF/d | .29 BCF/d
 |  |  | 2002 | 4.7 BCF/d | 4.5 BCF/d | .3 BCF/d