Spreadsheet: matthew_lenhart__26083__Book1
Sheet: Socal

SoCal | 2001-03-19 00:00:00
 | Daily Supply & Demand
Sendout Forecast | 2001-03-25 00:00:00 | 2001-03-24 00:00:00 | 2001-03-23 00:00:00 | 2001-03-22 00:00:00 | 2001-03-21 00:00:00 | 2001-03-20 00:00:00 | 2001-03-19 00:00:00 | 2001-03-18 00:00:00 | 2001-03-17 00:00:00 | 2001-03-16 00:00:00
 | 2899176.718994581 | 2899176.718994581 | 2899176.718994581 | 2899176.718994581 | 2899176.718994581 | 2899176.718994581 | 2899176.718994581 | 2899176.718994581 | 2899176.718994581 | 2899176.718994581
Burbank | 72.5 | 67.05 | 62.95 | 63.5 | 67.45 | 67 | 65.5 | 60.55 | 59.55 | 57.45 | 64.5 | 62.5 | 62.55 | 60.1
 | 46.5 | 44.5 | 50 | 49.5 | 49.05 | 45.95 | 46.5 | 47.45 | 43.95 | 49.45 | 48.05 | 48.5 | 51 | 52.5
LAX | 70 | 63 | 61 | 60.1 | 64.9 | 64.9 | 63 | 59 | 60.1 | 59 | 61 | 61 | 63 | 60.1
 | 53.1 | 50 | 53.1 | 54 | 53.1 | 48.9 | 52 | 48.9 | 46.9 | 52 | 51.1 | 54 | 53.1 | 55
 | 2001-03-18 00:00:00 | 2001-03-17 00:00:00 | 2001-03-16 00:00:00 | 2001-03-15 00:00:00 | 2001-03-14 00:00:00 | 2001-03-13 00:00:00 | 2001-03-12 00:00:00 | 2001-03-11 00:00:00 | 2001-03-10 00:00:00 | 2001-03-09 00:00:00 | 2001-03-08 00:00:00 | 2001-03-07 00:00:00 | 2001-03-06 00:00:00 | 2001-03-05 00:00:00 | Mo. To Date | Prior Yr. [NAME].
 | 2001-03-18 00:00:00 | 2001-03-17 00:00:00 | 2001-03-16 00:00:00 | 2001-03-15 00:00:00 | 2001-03-14 00:00:00 | 2001-03-13 00:00:00 | 2001-03-12 00:00:00 | 2001-03-11 00:00:00 | 2001-03-10 00:00:00 | 2001-03-09 00:00:00 | 2001-03-08 00:00:00 | 2001-03-07 00:00:00 | 2001-03-06 00:00:00 | 2001-03-05 00:00:00 | 2001-03-01 00:00:00 | 2000-03-01 00:00:00
El Paso-Topock | 538000 | 538000 | 539000 | 540000 | 539000 | 539000 | 535000 | 535000 | 539000 | 529000 | 533000 | 538000 | 536000 | 540000 | 537111.1111111111 | 527709.6774193548
El Paso-Ehrenberg | 1235000 | 1235000 | 1240000 | 1235000 | 1228000 | 1227000 | 1245000 | 1245000 | 1243000 | 1252000 | 1244000 | 1259000 | 1198000 | 1187000 | 1223888.888888889 | 865516.1290322581
Kern/Mojave-Wheeler Ridge | 367000 | 353000 | 349000 | 374000 | 354000 | 373000 | 369000 | 363000 | 369000 | 374000 | 370000 | 371000 | 369000 | 383000 | 368722.2222222222 | 349645.1612903226
PG&E-KRS | 379000 | 395000 | 381000 | 407000 | 377000 | 373000 | 373000 | 394000 | 405000 | 380000 | 376000 | 404000 | 386000 | 370000 | 379055.5555555556 | 223225.8064516129
TW-North Needles | 797000 | 789000 | 790000 | 788000 | 783000 | 783000 | 790000 | 791000 | 779000 | 789000 | 783000 | 747000 | 779000 | 747000 | 779666.6666666666 | 684709.6774193548
California Prod | 324000 | 277000 | 311000 | 332000 | 331000 | 332000 | 324000 | 324000 | 326000 | 335000 | 326000 | 314000 | 313000 | 309000 | 319888.8888888889 | 249967.7419354839
Total Receipts | 3695000 | 3588000 | 3610000 | 3676000 | 3612000 | 3627000 | 3636000 | 3652000 | 3662000 | 3657000 | 3632000 | 3633000 | 3581000 | 3536000 | 3611388.888888889 | 2861806.451612903
Storage | 735000 | 484000 | 192000 | 263000 | 342000 | 337000 | 296000 | 330000 | 458000 | 99000 | 257000 | 287000 | 153000 | -105000 | 166388.8888888889 | 30258.06451612903
Total System Sendout | 2960000 | 3057000 | 3429000 | 3454000 | 3288000 | 3242000 | 3415000 | 3266000 | 3247000 | 3629000 | 3276000 | 3385000 | 3458000 | 3647000 | 3439222.222222222 | 2825354.838709678
Total Inventory | 0 | 15834000 | 15352000 | 15159000 | 14897000 | 14554000 | 14218000 | 13921000 | 13592000 | 13135000 | 13035000 | 12778000 | 12491000 | 12337000 | 2995000 | 938000
Inventory Prior Year | 46620000 | 46349000 | 45958000 | 45503000 | 45009000 | 44742000 | 44382000 | 43841000 | 43305000 | 43180000 | 43647000 | 44407000 | 45438000 | 46401000 | 49222000 | 44969000
Total Surplus | -46620000 | -30515000 | -30606000 | -30344000 | -30112000 | -30188000 | -30164000 | -29920000 | -29713000 | -30045000 | -30612000 | -31629000 | -32947000 | -34064000 | -33388000 | 4253000
Long (Short) Position Line Pack | 0 | 47000 | -11000 | -41000 | -18000 | 48000 | -75000 | 56000 | -43000 | -71000 | 99000 | -39000 | -30000 | -6000 | 5777.777777777985 | 6193.548387096729
NGI Socal High | 0 | 0 | 10.25 | 10.75 | 13 | 12.75 | 13.5 | 13.5 | 13.5 | 15 | 17.5 | 33 | 36 | 32.5
NGI Socal Mid | 0 | 0 | 9.47 | 9.5 | 10.93 | 11.71 | 12.23 | 12.23 | 12.23 | 12.87 | 14.14 | 23.9 | 29.5 | 27.35
NGI Socal Low | 0 | 0 | 8.9 | 8.6 | 9.8 | 9.93 | 10.5 | 10.5 | 10.5 | 10.75 | 10.5 | 12.5 | 19 | 18
 | El Paso-Topock | El Paso-Ehrenberg | Kern/Mojave-Wheeler Ridge | PG&E-KRS | TW-North Needles | California Prod | Total Receipts | Storage Daily Average | Total System Sendout | Month End Inventory | Storage Totals | [NAME] | [NAME]. | [NAME]. | [NAME]. | Socal/SJ | Socal/Perm
1998-10-01 00:00:00 | 503096.7741935484 | 874451.6129032258 | 267193.5483870968 | 226161.2903225806 | 643387.0967741936 | 199032.2580645161 | 2768677.419354839 | 521161.2903225807 | 2319483.870967742 | 93259000 | 16156000 | 4628000 | 2.205322580645162 | 1.694032258064516 | 1.777258064516129 | 0.5112903225806456 | 0.4280645161290328
1998-11-01 00:00:00 | 424533.3333333333 | 963900 | 218433.3333333333 | 187466.6666666667 | 648366.6666666666 | 186833.3333333333 | 2689633.333333333 | 184833.3333333333 | 2501400 | 98791000 | 5545000 | 3042000 | 2.353333333333334 | 1.973392857142857 | 1.991607142857143 | 0.3799404761904768 | 0.361726190476191
1998-12-01 00:00:00 | 432322.5806451613 | 1045580.64516129 | 161387.0967741935 | 59615.38461538462 | 650354.8387096775 | 191806.4516129032 | 2592000 | -571354.8387096775 | 3137766.666666667 | 81080000 | -17712000 | 4648000 | 2.123225806451613 | 1.698275862068965 | 1.683620689655173 | 0.4249499443826477 | 0.4396051167964399
1999-01-01 00:00:00 | 481806.4516129032 | 872161.2903225806 | 149258.064516129 | 100043.4782608696 | 605000 | 190096.7741935484 | 2443806.451612903 | -544838.7096774194 | 2987387.096774193 | 65284000 | -16890000 | 3964000 | 1.897419354838709 | 1.737068965517242 | 1.742931034482759 | 0.1603503893214677 | 0.1544883203559502
1999-02-01 00:00:00 | 515035.7142857143 | 681107.1428571428 | 215892.8571428571 | 139500 | 679678.5714285715 | 185607.1428571429 | 2485250 | -446642.8571428572 | 2933071.428571429 | 52783000 | -12506000 | 4011000 | 1.816964285714286 | 1.594642857142857 | 1.62875 | 0.2223214285714292 | 0.1882142857142861
1999-03-01 00:00:00 | 533161.2903225806 | 679548.3870967742 | 287225.8064516129 | 280806.4516129032 | 552806.4516129033 | 177774.1935483871 | 2578548.387096774 | -251032.2580645161 | 2835258.064516129 | 44969000 | -7782000 | 3609000 | 1.713387096774194 | 1.556290322580645 | 1.604354838709678 | 0.1570967741935481 | 0.1090322580645158
1999-04-01 00:00:00 | 508533.3333333333 | 685933.3333333334 | 309800 | 274400 | 585866.6666666666 | 179966.6666666667 | 2607766.666666667 | -205733.3333333333 | 2801266.666666667 | 38789000 | -6172000 | 3671000 | 2.080333333333333 | 1.911333333333333 | 1.961833333333334 | 0.1689999999999998 | 0.1184999999999994
1999-05-01 00:00:00 | 520870.9677419355 | 783225.8064516129 | 332709.6774193548 | 325322.5806451613 | 573419.3548387097 | 173580.6451612903 | 2773096.774193549 | 559161.2903225806 | 2214161.290322581 | 56057000 | 17334000 | 2733000 | 2.215161290322581 | 1.978548387096774 | 2.108387096774194 | 0.2366129032258064 | 0.1067741935483872
1999-06-01 00:00:00 | 530300 | 701233.3333333334 | 383666.6666666667 | 362200 | 613433.3333333334 | 246166.6666666667 | 2836966.666666667 | 412133.3333333333 | 2421600 | 68397000 | 12364000 | 3102000 | 2.292166666666667 | 2.023 | 2.150333333333334 | 0.269166666666667 | 0.141833333333333
1999-07-01 00:00:00 | 523064.5161290322 | 744774.1935483871 | 379000 | 362612.9032258064 | 663451.6129032258 | 249193.5483870968 | 2922032.258064516 | 282709.6774193548 | 2643096.774193549 | 77117000 | 8764000 | 3456000 | 2.341774193548388 | 2.009193548387097 | 2.193548387096774 | 0.3325806451612903 | 0.148225806451614
1999-08-01 00:00:00 | 515451.6129032258 | 569612.9032258064 | 483387.0967741936 | 267580.6451612903 | 626483.8709677419 | 264096.7741935484 | 2726483.870967742 | 18400 | 2706516.129032258 | 78044000 | 552000 | 3691000 | 2.721612903225806 | 2.39983870967742 | 2.648225806451614 | 0.3217741935483862 | 0.07338709677419253
1999-09-01 00:00:00 | 509566.6666666667 | 810300 | 417833.3333333333 | 254300 | 677400 | 259800 | 2928300 | 285233.3333333333 | 2645233.333333333 | 86618000 | 8557000 | 3168000 | 2.666333333333334 | 2.292833333333333 | 2.415 | 0.3735000000000013 | 0.251333333333335
1999-10-01 00:00:00 | 477806.4516129032 | 1037419.35483871 | 389774.1935483871 | 194419.3548387097 | 721645.1612903225 | 255903.2258064516 | 3061322.580645161 | 88129.03225806452 | 2964096.774193549 | 89228000 | 2732000 | 3387000 | 2.937419354838709 | 2.600161290322581 | 2.606451612903226 | 0.3372580645161283 | 0.3309677419354831
1999-11-01 00:00:00 | 513033.3333333333 | 943800 | 329066.6666666667 | 110800 | 722433.3333333334 | 261500 | 2880700 | 150933.3333333333 | 2738600 | 92944000 | 4528000 | 3360000 | 2.564166666666666 | 2.153166666666666 | 2.167833333333333 | 0.4109999999999991 | 0.3963333333333328
1999-12-01 00:00:00 | 469903.9032258064 | 936062.6451612903 | 161982.6129032258 | 137157.2580645161 | 695830.6451612903 | 265055.9677419355 | 2651193.548387097 | -463645.1612903226 | 3114903.225806451 | 78580000 | -14373000 | 3813000 | 2.465 | 2.232258064516129 | 2.237258064516129 | 0.2327419354838711 | 0.2277419354838708
2000-01-01 00:00:00 | 530096.7741935484 | 871548.3870967742 | 197064.5161290323 | 78225.80645161291 | 676967.7419354839 | 257645.1612903226 | 2611290.322580645 | -509516.1290322581 | 3123483.870967742 | 62970000 | -15795000 | 3783000 | 2.423709677419356 | 2.246451612903226 | 2.265483870967742 | 0.1772580645161295 | 0.1582258064516138
2000-02-01 00:00:00 | 535103.448275862 | 657034.4827586206 | 275965.5172413793 | 163931.0344827586 | 674586.2068965518 | 269068.9655172414 | 2575724.137931034 | -496482.7586206897 | 3069448.275862069 | 48405000 | -14398000 | 3904000 | 2.616896551724138 | 2.403793103448276 | 2.442931034482759 | 0.2131034482758625 | 0.1739655172413794
2000-03-01 00:00:00 | 527709.6774193548 | 865516.1290322581 | 349645.1612903226 | 223225.8064516129 | 684709.6774193548 | 249967.7419354839 | 2861806.451612903 | 30258.06451612903 | 2825354.838709678 | 49222000 | 938000 | 3871000 | 2.834838709677419 | 2.621451612903226 | 2.665322580645162 | 0.2133870967741922 | 0.1695161290322567
2000-04-01 00:00:00 | 531633.3333333334 | 778566.6666666666 | 461900 | 188200 | 608866.6666666666 | 245300 | 2811633.333333333 | 390966.6666666667 | 2422966.666666667 | 60911000 | 11729000 | 2976000 | 3.012833333333333 | 2.738833333333333 | 2.813333333333333 | 0.2740000000000005 | 0.1995000000000009
2000-05-01 00:00:00 | 522387.0967741936 | 651290.3225806452 | 490516.1290322581 | 264612.9032258064 | 663548.3870967742 | 229612.9032258065 | 2821935.483870968 | 152645.1612903226 | 2665677.419354839 | 65633000 | 4732000 | 3250000 | 3.624354838709676 | 3.178870967741935 | 3.364354838709677 | 0.4454838709677413 | 0.2599999999999993
2000-06-01 00:00:00 | 520966.6666666667 | 963266.6666666666 | 391066.6666666667 | 342500 | 696866.6666666666 | 252066.6666666667 | 3167033.333333333 | 68500 | 3097900 | 67650000 | 2055000 | 3760000 | 4.630666666666666 | 3.972 | 4.158500000000001 | 0.6586666666666665 | 0.4721666666666655
2000-07-01 00:00:00 | 522096.7741935484 | 1043258.064516129 | 392903.2258064516 | 381354.8387096774 | 708645.1612903225 | 246645.1612903226 | 3294193.548387097 | -37709.67741935484 | 3320806.451612903 | 66434000 | -1169000 | 3919000 | 4.615322580645161 | 3.650967741935483 | 3.991451612903226 | 0.9643548387096779 | 0.6238709677419352
2000-08-01 00:00:00 | 502709.6774193548 | 957451.6129032258 | 344000 | 424451.6129032258 | 711064.5161290322 | #REF! | 3210903.225806451 | -405161.2903225807 | 3616161.290322581 | 53831000 | -12560000 | 4016000 | 5.24241935483871 | 3.411129032258063 | 4.320483870967741 | 1.831290322580647 | 0.9219354838709695
2000-09-01 00:00:00 | 499333.3333333333 | 1093733.333333333 | 350100 | 397033.3333333333 | 705933.3333333334 | 265033.3333333333 | 3311333.333333333 | 118633.3333333333 | 3191666.666666667 | 57385000 | 3559000 | 3847000 | 6.007666666666665 | 4.189666666666668 | 4.902666666666667 | 1.817999999999998 | 1.105
2000-10-01 00:00:00 | 511612.9032258064 | 1165096.774193548 | 383838.7096774193 | 312290.3225806452 | 703612.9032258064 | 277483.8709677419 | 3353774.193548387 | 254967.7419354839 | 3104806.451612903 | 65292000 | 7904000 | 3459000 | 5.57790322580645 | 4.581935483870967 | 4.92193548387097 | 0.9959677419354831 | 0.6559677419354797
2000-11-01 00:00:00 | 510266.6666666667 | 1094700 | 269166.6666666667 | 194333.3333333333 | 648266.6666666666 | 306533.3333333333 | 3023266.666666667 | -491766.6666666667 | 3509000 | 50042000 | -14753000 | 4552000 | 9.680333333333335 | 5.240166666666667 | 5.4445 | 4.440166666666668 | 4.235833333333336
2000-12-01 00:00:00 | 527032.2580645161 | 1181935.483870968 | 391709.6774193548 | 303677.4193548387 | 737516.1290322581 | 297451.6129032258 | 3439322.580645161 | 4032.258064516129 | 3433677.419354839 | 50168000 | 125000 | 4014000 | 25.08274193548387 | 8.028548387096773 | 8.701451612903226 | 17.0541935483871 | 16.38129032258065
2001-01-01 00:00:00 | 533193.5483870967 | 1190032.258064516 | 422548.3870967742 | 330483.8709677419 | 756612.9032258064 | 288903.2258064516 | 3522741.935483871 | -710129.0322580645 | 4231161.29032258 | 28000000 | -22014000 | 5211000 | 12.68135483870968 | 8.141774193548388 | 8.026129032258064 | 4.539580645161289 | 4.655225806451613
2001-02-01 00:00:00 | 532214.2857142857 | 1200964.285714286 | 475821.4285714286 | 283178.5714285714 | 770892.8571428572 | 314785.7142857143 | 3577821.428571429 | -512535.7142857143 | 4093750 | 13953000 | -14351000 | 5177000 | 18.73528571428572 | 5.606607142857143 | 5.520535714285716 | 13.12867857142857 | 13.21475
2001-03-01 00:00:00 | 537111.1111111111 | 1223888.888888889 | 368722.2222222222 | 379055.5555555556 | 779666.6666666666 | 319888.8888888889 | 3611388.888888889 | 166388.8888888889 | 3439222.222222222 | N/A | 2995000 | 4131000 | 17.68125 | 5.065625 | 4.9940625 | 12.615625 | 12.6871875
Currently In Effect | [NAME] | [NAME]
 | 2000000 | 780000 |  | Inventory | 15834000 | 1999 | Est. Total [NAME] | 105000000 | Extrapolated Storage Number
Absolute Capacities | [NAME] | [NAME] |  | 0.7 | 40000000 | 1998 | Est. Total [NAME] | 112000000 | 2163055.555555556
 | 3000000 | 780000 |  | 0.9 | 25000000
Core Storage | W/D | Inj |  | Peak Day Min. | 20000000 |  | Core Cap | 70000000
 | 1985000 | 327000 |  |  |  |  | Non-Core Cap | 35000000
for prior year inv | 2000-03-18 00:00:00 | 2000-03-17 00:00:00 | 2000-03-16 00:00:00 | 2000-03-15 00:00:00 | 2000-03-14 00:00:00 | 2000-03-13 00:00:00 | 2000-03-12 00:00:00 | 2000-03-11 00:00:00 | 2000-03-10 00:00:00 | 2000-03-09 00:00:00 | 2000-03-08 00:00:00 | 2000-03-07 00:00:00 | 2000-03-06 00:00:00 | 2000-03-05 00:00:00 | 2000-03-01 00:00:00 | 1999-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-03-31 00:00:00