Spreadsheet: phillip_allen__28877__rockies
Sheet: ROX Fcst

 |  |  |  |  |  |  |  | 0.01 | 0.01 |  |  |  |  |  |  |  |  |  |  |  |  | 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
 |  | 1998-01-01 00:00:00 | 3265.989747465438 |  | 1961.834548387097 | 1013.680225806452 | 6241.504521658986 | 1190 | 581 | -211.7444193548387 | 2439.251933333333 | 781.9847419354838 | 723.8095238095239 | 775 | 6702.79061843318 | -261.2860967741935 | -200 | -461.2860967741935 | 0 | 16846419
 |  |  | 3250.633071428572 |  | 2055.607178571428 | 1046.735321428571 | 6352.975571428572 | 1140 | 607 | 89.11960714285715 | 2695.591071428571 | 777.8357857142856 | 900.6 | 775 | 6806.90725 | -253.9316785714286 | -200 | -453.9316785714286 | 4.547473508864641e-13 | 9736332
 |  |  | 3092.30117405914 |  | 2062.461580645161 | 1001.394548387097 | 6156.157303091398 | 1000 | 484 | 125.0150625 | 2630.448096774193 | 765.3091612903225 | 863.0833333333334 | 775 | 6392.825528897849 | -36.66822580645161 | -200 | -236.6682258064516 | 4.831690603168681e-13 | 8599617
 |  |  | 3175.203107692307 |  | 2274.446733333333 | 888.3640666666666 | 6338.013907692308 | 833 | 400 | 131.0422333333333 | 2724.8116 | 786.9457333333332 | 961.6923076923076 | 775 | 6350.407407692307 | 37.6065 | -50 | -12.3935 | 7.815970093361102e-13 | 9727812
 |  |  | 3125.821376276881 |  | 2185.59629032258 | 905.0786774193548 | 6216.496344018817 | 612 | 258 | 229.36803125 | 2639.696161290322 | 786.0456333333333 | 992.375 | 775 | 5833.748763373655 | 232.7475806451613 | 150 | 382.7475806451613 | 0 | 16942987
 |  |  | 2982.157563218391 |  | 2292.0657 | 892.6633333333333 | 6166.886596551724 | 400 | 233 | 225.7726333333333 | 2767.021896551724 | 771.902 | 995 | 775 | 5716.151263218391 | 275.7353333333333 | 175 | 450.7353333333333 | 0 | 25215047
 |  |  | 3057.452400697011 |  | 2216.488258064516 | 844.2200841514726 | 6118.160742913 | 419 | 226 | 174.9715151515151 | 2708.32764516129 | 739.0167741935484 | 995 | 775 | 5687.372904203323 | 230.7878387096774 | 200 | 430.7878387096774 | 0 | 32369470
 |  |  | 3183.55648541435 |  | 2184.118258064516 | 788.8248609566184 | 6156.499604435484 | 452 | 194 | -1.1240625 | 2665.2268 | 694.3116129032259 | 972 | 775 | 5753.662475403226 | 227.8371290322581 | 175 | 402.8371290322581 | -5.684341886080801e-13 | 39432421
 |  |  | 3103.828577945402 |  | 2305.413833333333 | 804.0211666666667 | 6213.263577945402 | 366 | 233 | 45.79853125 | 2726.780275862069 | 739.2556333333333 | 966.2 | 775 | 5760.437377945402 | 277.8262 | 175 | 452.8262 | 0 | 47767207
 |  |  | 3261.738763440862 |  | 2293.50429032258 | 778.0827419354839 | 6333.325795698926 | 452 | 355 | -216.3526451612903 | 2703.975903225807 | 666.4371935483872 | 963.6666666666667 | 775 | 6132.432408602152 | 125.8933870967742 | 75 | 200.8933870967742 | 6.536993168992922e-13 | 51669902 | 35580267
 |  |  | 3414.251 |  | 2191.474333333334 | 493.1952000000001 | 6098.920533333334 | 767 | 467 | -378.3422 | 2622.663933333333 | 366.922 | 757.5625 | 800 | 6159.490633333334 | -90.5701 | 30 | -60.5701 | 8.526512829121202e-14 | 48952799 | 36480267
 |  |  | 3501.617494623656 |  | 2138.246419354839 | 565.7274516129032 | 6205.591365591399 | 1065 | 645 | -472.4292258064517 | 2573.007741935484 | 406.6975483870968 | 699.3333333333334 | 800 | 6661.467849462366 | -305.8764838709678 | -150 | -455.8764838709678 | 1.080024958355352e-12 | 39470628 | 31830267
 |  |  | 3418.835717357911 |  | 2336.928806451613 | 464.0028387096775 | 6219.767362519201 | 1161 | 548 | -390.8969354838709 | 2781.457548387097 | 376.6010322580645 | 723.8095238095239 | 800 | 6781.765039938556 | -361.9976774193548 | -200 | -561.9976774193549 | 0 | 28248700 | 25630267
 |  |  | 3612.287783549783 |  | 2309.593964285715 | 457.2059285714285 | 6379.087676406926 | 1143 | 571 | -383.4156785714286 | 2699.522545454545 | 395.4324166666667 | 814 | 800 | 6806.37064069264 | -227.2829642857143 | -200 | -427.2829642857143 | 0 | 21884777 | 20030267
 |  |  | 3607.653046689304 |  | 2366.492161290323 | 406.7395806451613 | 6380.884788624788 | 1032 | 484 | -385.4628709677419 | 2758.2525 | 402.7456129032258 | 913.6315789473684 | 800 | 6776.092562818336 | -195.2077741935484 | -200 | -395.2077741935484 | 0 | 15833336 | 13830267
 |  |  | 3426.116933333334 |  | 2386.790766666667 | 795.0557 | 6607.9634 | 800 | 400 | -176.5474 | 2768.227933333333 | 793.8439666666667 | 962.125 | 775 | 6675.7443 | -17.7809 | -50 | -67.7809 | -6.536993168992922e-13 | 15299909 | 12330267
 |  |  | 3410.734493358633 |  | 2241.419161290322 | 758.6965806451612 | 6410.850235294116 | 581 | 226 | -155.7209032258065 | 2622.008709677419 | 797.4382580645162 | 991.5882352941176 | 775 | 6148.756106261859 | 132.0941290322581 | 130 | 262.0941290322581 | -9.663381206337363e-13 | 19394827 | 16360267
 |  |  | 3395.421114285715 |  | 2332.585433333333 | 858.3423333333334 | 6586.348880952381 | 400 | 233 | -263.767 | 2748.505466666667 | 808.6015 | 994.2857142857142 | 775 | 6223.159680952382 | 212.8062 | 150.383 | 363.1892 | 0 | 25779013 | 20871757
 |  |  | 3402.415548387097 |  | 2167.042741935484 | 891.1546451612903 | 6460.612935483872 | 452 | 226 | -174.3976451612903 | 2575.216548387097 | 823.7635483870968 | 995 | 775 | 6021.377741935485 | 258.116 | 181.1191935483871 | 439.2351935483871 | 4.547473508864641e-13 | 33780609 | 26486452
 |  |  | 3245.94906451613 |  | 2305.467322580645 | 895.7345161290323 | 6447.150903225807 | 484 | 226 | -133.9403870967742 | 2708.451387096774 | 816.758129032258 | 995 | 775 | 6139.149903225807 | 159.2203225806452 | 148.7806774193548 | 308.001 | 0 | 38716439 | 31098653
 |  |  | 3226.883551724138 |  | 2307.631206896552 | 850.8595666666666 | 6385.374325287356 | 390 | 233 | -191.1027333333333 | 2705.30775862069 | 805.0401333333333 | 995 | 775 | 6094.450625287356 | 164.6751666666667 | 126.2485333333333 | 290.9237 | 0 | 43656694 | 34886109
 |  |  | 3409.071677419355 |  | 2269.078419354839 | 811.2469677419355 | 6489.39706451613 | 452 | 323 | -419.4062903225807 | 2597.602161290322 | 833.0861290322581 | 950 | 787.2496451612903 | 6362.344225806452 | 56.29670967741936 | 70.75612903225806 | 127.0528387096774 | 9.094947017729282e-13 | 45401892 | 37079549
 |  |  | 3662.450566666666 |  | 2263.4116 | 844.4517666666666 | 6770.313933333333 | 800 | 467 | -369.9330333333333 | 2637.081 | 743.1389 | 950 | 812.6655666666666 | 6779.818499999999 | -41.0957 | 31.59113333333334 | -9.504566666666665 | 1.598721155460225e-13 | 44169021 | 38027283
 |  |  | 3682.989419354839 |  | 2205.197451612903 | 895.9904838709678 | 6784.17735483871 | 1065 | 645 | -439.482064516129 | 2653.097 | 770.1974193548386 | 950 | 855.1724838709678 | 7377.948967741936 | -437.2886129032258 | -156.483 | -593.7716129032258 | 0 | 30613074 | 33176310
 |  |  | 3789.867709677419 |  | 2175.165580645161 | 916.5590322580645 | 6881.592322580645 | 1161 | 551 | -483.8690322580645 | 2667.249290322581 | 754.7896129032258 | 950 | 851.6942903225806 | 7419.602225806451 | -346.1610322580645 | -191.8488709677419 | -538.0099032258064 | 0 | 19882082 | 27228995
 |  |  | 3834.920310344828 |  | 2176.387517241379 | 976.0964827586207 | 6987.404310344827 | 1100 | 515 | -448.5073103448276 | 2700.963724137931 | 807.9293448275862 | 950 | 841.4564482758619 | 7363.856827586206 | -280.1044827586207 | -96.34803448275862 | -376.4525172413793 | 0 | 11759052 | 24434902
 |  |  | 3792.19129032258 |  | 2197.259677419355 | 970.4873548387097 | 6959.938322580644 | 1032 | 490 | -457.1522903225807 | 2717.890580645161 | 823.9342903225806 | 950 | 806.0187419354838 | 7276.995903225806 | -93.33016129032258 | -223.7274193548387 | -317.0575806451613 | 0 | 8865817 | 17499352
 |  |  | 3802.252192592592 |  | 2178.550666666667 | 770.875 | 6751.677859259258 | 700 | 309 | -429.1636333333333 | 2674.6213 | 749.4585925925926 | 980 | 800.6498666666665 | 6642.893392592592 | 167.4504 | -58.66593333333334 | 108.7844666666667 | -6.252776074688882e-13 | 13889329 | 15739374
 |  |  | 3810.025774193549 |  | 2074.120967741936 | 1020.237032258064 | 6904.383774193549 | 581 | 226 | -417.7527741935484 | 2665.59864516129 | 851.844064516129 | 1150 | 778.6916129032257 | 6670.887096774194 | 201.2051290322581 | 32.29154838709677 | 233.4966774193549 | 5.115907697472721e-13 | 20126688 | 16740412
 |  |  | 3822.1005 |  | 2045.6734 | 973.9242666666667 | 6841.698166666667 | 500 | 233 | -357.2803333333333 | 2607.173733333334 | 847.4194 | 1150 | 780.1911333333333 | 6475.064600000001 | 205.6530333333334 | 160.9805333333333 | 366.6335666666666 | 0 | 26296279 | 21569828
 |  |  | 3882.388516129032 |  | 2075.247677419355 | 1015.787193548387 | 6973.423387096775 | 450 | 225 | -370.0274193548387 | 2681.214967741936 | 875.4233548387097 | 1175 | 775.2091612903225 | 6551.874903225807 | 247.622 | 173.9264838709677 | 421.5484838709677 | 0 | 33972561 | 26961549
 |  |  | 3906.045290322581 |  | 2086.876903225806 | 972.6534516129033 | 6965.575645161291 | 500 | 225 | -328.979 | 2690.344612903226 | 859.6444516129033 | 1175 | 805.8899677419354 | 6584.858032258065 | 222.1284193548387 | 158.5891935483871 | 380.7176129032258 | 0 | 40858542 | 31877814
 |  |  | 3923.3866 |  | 2110.9359 | 1004.872866666667 | 7039.195366666667 | 500 | 250 | -437.5290666666667 | 2761.519333333334 | 809.3564666666666 | 1175 | 832.9814999999999 | 6766.386366666667 | 204.131 | 68.678 | 272.809 | 0 | 46112621 | 33938154 | 2060340
 |  |  | 3998.151141824248 |  | 2190.815612903226 | 977.0585161290322 | 7166.025270856507 | 700 | 350 | -463.4551612903226 | 2727.822387096774 | 840.9454354838709 | 1200 | 867.874448275862 | 7150.097432146829 | -33.58180645161291 | 49.50964516129032 | 15.92783870967742 | 0 | 45071585 | 35472953 | 1534799
 |  |  | 3918.203254269294 |  | 2014.9467 | 1034.330642857143 | 6967.480597126438 | 1100 | 600 | -478.4724137931034 | 2570.322166666666 | 883.7420500000001 | 1000 | 821.979 | 7454.51563045977 | -344.3453 | -142.6897333333334 | -487.0350333333333 | 6.821210263296962e-13 | 34741226 | 31192261 | -4280692
 |  |  |  |  |  |  |  | 1300 | 650 |  |  |  | 920 |  |  |  |  |  |  |  |  | -3594741
 |  |  |  | 0 |  |  |  | 1200 | 700 |  |  |  | 950
 |  |  |  | 20 | 2150 | 1000 |  | 1000 | 650 | -475 | 2700 | 850 | 950 | 900 |  | -170 | -110
 |  |  |  | 20 | 2150 | 1000 |  | 850 | 500 | -475 | 2700 | 850 | 1050 | 825 |  | 10 | 0
 |  |  |  | 20 | 2100 | 950 |  | 750 |  | -475 | 2700 | 850 | 1050 | 800 |  | 210 | 37
 |  |  |  | 20 | 2100 | 950 |  | 600 |  | -475 | 2700 | 850 | 1200 | 800 |  | 200 | 150
 |  |  |  | 20 | 2100 | 950 |  | 525 |  | -475 | 2700 | 850 | 1200 | 800 |  | 275 | 165
 |  |  |  | 20 | 2100 | 950 |  | 500 |  | -475 | 2700 | 850 | 1200 | 800 |  | 450 | 45
 |  |  |  | 10 | 2100 | 950 |  | 525 |  | -475 | 2700 | 850 | 1200 | 800 |  | 400 | 50
 |  |  |  | 10 | 2100 | 950 |  | 525 |  | -475 | 2700 | 850 | 1200 | 825 |  | 150 | 20
 |  |  |  | 10 | 2100 | 950 |  | 710 |  | -475 | 2700 | 850 | 1200 | 825 |  | 0 | 0
 |  |  |  | 10 | 2100 | 1000 |  | 1000 | 620 | -475 | 2700 | 850 | 1200 | 850 |  | -350 | -150
 |  |  |  | 10 | 2100 | 1000 |  | 1200 | 630 | -475 | 2700 | 850 | 1200 | 900 |  | -450 | -200
 |  |  |  | 20 | 2100 | 1000 |  | 1200 | 700 | -475 | 2700 | 850 | 1200 | 950 |  | -500 | -210
 |  |  |  | 20 | 2100 | 1000 |  | 1050 | 700 | -475 | 2700 | 850 | 1200 | 900 |  | -300 | -190
 |  |  |  | 20 | 2100 | 1000 |  | 950 | 550 | -475 | 2700 | 850 | 1200 | 850 |  | -80 | -100
 |  | 2002-04-01 00:00:00