Spreadsheet: matthew_lenhart__26138__Book1
Sheet: Sheet1

SoCal | 2000-09-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spreads
 | Daily Supply & Demand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Socal/Permian | Socal/San Juan | San Juan/Permian
Sendout Forecast | 2000-09-18 00:00:00 | 2000-09-17 00:00:00 | 2000-09-16 00:00:00 | 2000-09-15 00:00:00 | 2000-09-14 00:00:00 | 2000-09-13 00:00:00 | 2000-09-12 00:00:00 | 2000-09-11 00:00:00 | 2000-09-10 00:00:00 | 2000-09-09 00:00:00 |  |  |  |  |  |  | 2000-09-11 00:00:00 | 0 | 0 | 0
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  | 2000-09-10 00:00:00 | 0 | 0 | 0
Burbank | 94.5 | 82.5 | 78.5 | 78.5 | 78.5 | 89 | 82.5 | 78 | 62 | 62 | 78.5 | 78.5 | 80 | 75 |  |  | 2000-09-09 00:00:00 | 0 | 0 | 0
 | 60.5 | 60 | 60.5 | 60.5 | 60.5 | 57 | 58 | 59.5 | 76 | 76 | 63.5 | 63.5 | 62.5 | 64.5 |  |  | 2000-09-08 00:00:00 | 0 | 0 | 0
LAX | 95 | 72 | 77 | 77 | 77 | 92 | 83 | 77 | 63 | 63 | 76 | 76 | 76 | 68 |  |  | 2000-09-07 00:00:00 | 0 | 0 | 0
 | 58 | 58 | 61 | 61 | 61 | 60 | 60 | 61 | 76 | 76 | 66 | 66 | 65 | 64 |  |  | 2000-09-06 00:00:00 | 0 | 0 | 0
 | 2000-09-11 00:00:00 | 2000-09-10 00:00:00 | 2000-09-09 00:00:00 | 2000-09-08 00:00:00 | 2000-09-07 00:00:00 | 2000-09-06 00:00:00 | 2000-09-05 00:00:00 | 2000-09-04 00:00:00 | 2000-09-03 00:00:00 | 2000-09-02 00:00:00 | 2000-09-01 00:00:00 | 2000-08-31 00:00:00 | 2000-08-30 00:00:00 | 2000-08-29 00:00:00 | Mo. To Date | Prior Yr. [NAME]. | 2000-09-05 00:00:00 | 0 | 0 | 0
 | 2000-09-11 00:00:00 | 2000-09-10 00:00:00 | 2000-09-09 00:00:00 | 2000-09-08 00:00:00 | 2000-09-07 00:00:00 | 2000-09-06 00:00:00 | 2000-09-05 00:00:00 | 2000-09-04 00:00:00 | 2000-09-03 00:00:00 | 2000-09-02 00:00:00 | 2000-09-01 00:00:00 | 2000-08-31 00:00:00 | 2000-08-30 00:00:00 | 2000-08-29 00:00:00 | 2000-09-01 00:00:00 | 1999-09-01 00:00:00
El Paso-Topock | 528000 | 492000 | 510000 | 513000 | 465000 | 523000 | 510000 | 511000 | 514000 | 517000 | 534000 | 444000 | 526000 | 537000 | 510636.3636363636 | 509566.6666666667
El Paso-Ehrenberg | 1160000 | 1115000 | 1106000 | 1122000 | 1155000 | 1135000 | 1073000 | 989000 | 956000 | 1086000 | 1107000 | 946000 | 805000 | 832000 | 1091272.727272727 | 810300
Kern/Mojave-Wheeler Ridge | 381000 | 382000 | 369000 | 378000 | 373000 | 367000 | 390000 | 416000 | 434000 | 363000 | 417000 | 355000 | 325000 | 315000 | 388181.8181818182 | 417833.3333333333
PG&E-KRS | 420000 | 422000 | 410000 | 415000 | 393000 | 406000 | 388000 | 371000 | 376000 | 375000 | 373000 | 466000 | 467000 | 454000 | 395363.6363636364 | 254300
TW-North Needles | 729000 | 670000 | 665000 | 718000 | 702000 | 679000 | 702000 | 716000 | 719000 | 697000 | 704000 | 700000 | 703000 | 689000 | 700090.9090909091 | 677400
California Prod | 260000 | 263000 | 263000 | 245000 | 237000 | 254000 | 275000 | 286000 | 290000 | 281000 | 287000 | 281000 | 273000 | 270000 | 267363.6363636364 | 259800
Total Receipts | 3478000 | 3343000 | 3323000 | 3390000 | 3326000 | 3364000 | 3338000 | 3290000 | 3288000 | 3318000 | 3423000 | 3193000 | 3098000 | 3098000 | 3352818.181818182 | 2928300
Storage | 278000 | 597000 | 381000 | -29000 | -95000 | 105000 | 180000 | 817000 | 836000 | 795000 | 612000 | 112000 | -127000 | -320000 | 407000 | 285233.3333333333
Total System Sendout | 3200000 | 2822000 | 2989000 | 3343000 | 3410000 | 3314000 | 3080000 | 2573000 | 2320000 | 2549000 | 2891000 | 3089000 | 3236000 | 3391000 | 2953727.272727273 | 2645233.333333333
Total Inventory | 58308000 | 58030000 | 57434000 | 57177000 | 57082000 | 57177000 | 57070000 | 56889000 | 56072000 | 55237000 | 54442000 | 53831000 | 53718000 | 53845000 | 4477000 | 8557000
Inventory Prior Year | 81817000 | 81329000 | 81190000 | 81019000 | 80959000 | 80649000 | 80385000 | 79879000 | 79318000 | 78934000 | 78359000 | 78044000 | 77991000 | 78383000 | 86618000 | 77170000
Total Surplus | -23509000 | -23299000 | -23756000 | -23842000 | -23877000 | -23472000 | -23315000 | -22990000 | -23246000 | -23697000 | -23917000 | -24213000 | -24273000 | -24538000 | -28588000 | 9448000
Long (Short) Position Line Pack | 0 | -76000 | -47000 | 76000 | 11000 | -55000 | 78000 | -100000 | 132000 | -26000 | -80000 | -8000 | -11000 | 27000 | -7909.09090909129 | -2166.666666666977
 |  |  |  |  |  |  |  |  |  |  |  |  | Gas Daily Average |  |  | Indicies |  |  | Spreads
 | 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] | Socal | San Juan | Permian | NGI - Socal | IFGMR - San Juan | IFGMR - Permian | GDA Socal/San Juan | NGI Socal/ IFGMR San Juan | GDA Socal/ NGI Socal
1998-04-01 00:00:00 | 528500 | 678366.6666666666 | 385933.3333333333 | 323100 | 626100 | 202966.6666666667 | 2754000 | 170233.3333333333 | 2586866.666666667 | 28262000 | 5107000 | 3543000 | 2.519666666666666 | 2.172222222222222 | 2.252758620689655 | 2.37 | 2.06 | 2.12 | N/A | 0.31 | N/A
1998-05-01 00:00:00 | 523536.064516129 | 728308 | #[NAME]! | #[NAME]! | 672643.6 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | N/A | 0 | 0 | 2.160645161290323 | 1.866666666666667 | 1.951666666666667 | 2.34 | 2 | 2.1 | N/A | 0.34 | N/A
1998-06-01 00:00:00 | 524943.3793103448 | 597677.3103448276 | #[NAME]! | #[NAME]! | 676325.6333333333 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | N/A | 0 | 0 | 2.010833333333334 | 1.639833333333333 | 1.935333333333334 | 2.07 | 1.75 | 1.86 | N/A | 0.32 | N/A
1998-07-01 00:00:00 | 530440.9677419355 | 605879.7096774194 | #[NAME]! | #[NAME]! | 658084.3548387097 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | N/A | 0 | 0 | 2.324193548387097 | 1.854166666666667 | 2.103166666666667 | 2.22 | 1.86 | 2.18 | N/A | 0.36 | N/A
1998-08-01 00:00:00 | 514064.5161290322 | 981774.1935483871 | 242967.7419354839 | 303967.7419354839 | 693387.0967741936 | 256870.9677419355 | 2992935.483870968 | 82322.58064516129 | 2905967.741935484 | 74661000 | 2552000 | 3507000 | 2.223225806451614 | 1.725645161290322 | 1.770806451612903 | 2.3 | 1.81 | 1.9 | N/A | 0.49 | N/A
1998-09-01 00:00:00 | 515533.3333333333 | 732233.3333333334 | 310900 | 218666.6666666667 | 709000 | 245620.6896551724 | 2732233.333333333 | 184300 | 2551133.333333333 | 77170000 | 5529000 | 3576000 | 2.134833333333333 | 1.733793103448276 | 1.834827586206897 | 2.02 | 1.55 | 1.59 | N/A | 0.47 | N/A
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 | 2.03 | 1.67 | 1.82 | N/A | 0.36 | N/A
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 | 2.33 | 1.88 | 1.92 | 0.3799404761904768 | 0.45 | 0.02333333333333387
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 | 2.29 | 1.96 | 1.99 | 0.4249499443826477 | 0.33 | -0.1667741935483873
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 | 2.04 | 1.72 | 1.73 | 0.1603503893214677 | 0.32 | -0.1425806451612908
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 | 1.83 | 1.63 | 1.66 | 0.2223214285714292 | 0.2 | -0.01303571428571382
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 | 1.71 | 1.51 | 1.54 | 0.1570967741935481 | 0.2 | 0.003387096774193576
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 | 1.78 | 1.59 | 1.66 | 0.1689999999999998 | 0.19 | 0.3003333333333329
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 | 2.22 | 2.03 | 2.16 | 0.2366129032258064 | 0.19 | -0.004838709677419395
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 | 2.22 | 1.96 | 2.08 | 0.269166666666667 | 0.26 | 0.07216666666666649
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 | 2.38 | 2.05 | 2.17 | 0.3325806451612903 | 0.33 | -0.03822580645161233
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 | 2.58 | 2.26 | 2.46 | 0.3217741935483862 | 0.32 | 0.141612903225806
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 | 2.93 | 2.63 | 2.78 | 0.3735000000000013 | 0.3 | -0.263666666666666
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.941290322580645 | 2.609193548387097 | 2.615483870967742 | 2.71 | 2.37 | 2.42 | 0.3320967741935474 | 0.34 | 0.2312903225806449
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 | 3.07 | 2.84 | 2.87 | 0.4109999999999991 | 0.23 | -0.5058333333333342
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 | 2.37 | 2.08 | 2.08 | 0.2327419354838711 | 0.29 | 0.09499999999999975
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 | 0 | 0 | 0.1772580645161295 | 0 | 2.423709677419356
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 | 0 | 0 | 0.2131034482758625 | 0 | 2.616896551724138
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 | 0 | 0 | 0.2133870967741922 | 0 | 2.834838709677419
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 | 0 | 0 | 0.2740000000000005 | 0 | 3.012833333333333
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 | 0 | 0 | 0.4454838709677413 | 0 | 3.624354838709676
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 | 0 | 0 | 0.6586666666666665 | 0 | 4.630666666666666
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 | 0 | 0 | 0.9643548387096779 | 0 | 4.615322580645161
2000-08-01 00:00:00 | 502709.6774193548 | 957451.6129032258 | 344000 | 424451.6129032258 | 711064.5161290322 | 271290.3225806452 | 3210903.225806451 | -405161.2903225807 | 3616161.290322581 | 53831000 | -12560000 | 4016000 | 3.402096774193549 | 2.426451612903226 | 3.011774193548387 | 0 | 0 | 0 | 0.975645161290323 | 0 | 3.402096774193549
2000-09-01 00:00:00 | 510636.3636363636 | 1091272.727272727 | 388181.8181818182 | 395363.6363636364 | 700090.9090909091 | 267363.6363636364 | 3352818.181818182 | 407000 | 2953727.272727273 | N/A | 4477000 | 3410000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 29 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
Currently In Effect | [NAME] | [NAME] |  |  |  |  | Expected Demand | Winter Forecast | 2000-01-31 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
 | 2000000 | 780000 | 1999 | Est. Total [NAME] | 105000000 |  | Case 1 Demand | Total Receipts | 2611290.322580645 | 2575724.137931034 | 2861806.451612903 | 2811633.333333333 | 2821935.483870968 | 3167033.333333333 | 3294193.548387097 | 3352818.181818182 | 3200000 | 3200000 | 3000000 | 2700000
Absolute Capacities | [NAME] | [NAME] | 1998 | Est. Total [NAME] | 112000000 |  | [NAME] | Inj/WD | -509516.1290322581 | -496482.7586206897 | 30258.06451612903 | 390966.6666666667 | 152645.1612903226 | 68500 | -37709.67741935484 | 407000 | 100000 | 300000 | 200000 | -400000
 | 3000000 | 780000 |  |  |  |  | Expected Demand | System Sendout | 3123483.870967742 | 3069448.275862069 | 2825354.838709678 | 2422966.666666667 | 2665677.419354839 | 3097900 | 3320806.451612903 | 2953727.272727273 | 3100000 | 2900000 | 2800000 | 3100000
Core Storage | W/D | Inj |  | Core Cap | 70000000 |  |  | Ending Inventory | 62970000 | 48405000 | 49222000 | 60911000 | 65633000 | 67650000 | 66434000 | 66448000 | 69448000 | 78748000 | 84748000 | 72348000
 | 1985000 | 327000 |  | Non-Core Cap | 35000000
 |  |  |  |  |  |  |  | OFO | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Inventory | 58030000 |  |  | Extrapolated Storage Number |  |  |  | 1997 | 0 | 0 | 0 | 0 | 1 | 6 | 2 | 0 | 1 | 2 | 0 | 0
0.7 | 45000000 |  |  | 66448000 |  |  |  | 1998 | 0 | 0 | 0 | 0 | 4 | 2 | 0 | 4 | 0 | 1 | 0 | 0
0.9 | 30000000 |  |  |  |  |  |  | 1999 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 7 | 0 | 2 | 0
Peak Day Min. | 25000000 |  |  |  |  |  |  | 2000 | 0 | 0 | 2 | 2 | 3 | 2
for prior year inv | 1999-09-11 00:00:00 | 1999-09-10 00:00:00 | 1999-09-09 00:00:00 | 1999-09-08 00:00:00 | 1999-09-07 00:00:00 | 1999-09-06 00:00:00 | 1999-09-05 00:00:00 | 1999-09-04 00:00:00 | 1999-09-03 00:00:00 | 1999-09-02 00:00:00 | 1999-09-01 00:00:00 | 1999-08-31 00:00:00 | 1999-08-30 00:00:00 | 1999-08-29 00:00:00 | 1999-09-01 00:00:00 | 1998-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-10-01 00:00:00