Spreadsheet: matthew_lenhart__26138__Book1
Sheet: Sheet6

PG&E |  |  |  |  |  |  |  |  |  |  |  |  | 2000-09-12 00:00:00
San Francisco | 74 | 74 | 74 | 74 | 74 | 74 | 74 | 74 | 74 | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 73
 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 55
Sacramento | 88 | 88 | 88 | 88 | 89 | 89 | 89 | 89 | 89 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 91 | 91
 | 56 | 56 | 56 | 56 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 58 | 58
 | 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-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-08-28 00:00:00 | 2000-08-27 00:00:00 | 2000-08-26 00:00:00 | 2000-08-25 00:00:00 | 2000-08-24 00:00:00 | 2000-08-23 00:00:00 | Month toDate | Prior Yr. [NAME].
 | 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-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-08-28 00:00:00 | 2000-08-27 00:00:00 | 2000-08-26 00:00:00 | 2000-08-25 00:00:00 | 2000-08-24 00:00:00 | 2000-08-23 00:00:00 | 2000-09-01 00:00:00 | 1999-09-01 00:00:00
System Demand
On-Sys Deliv | 2555000 | 2530000 | 2408000 | 2348000 | 2516000 | 2596000 | 2618000 | 2631000 | 2272000 | 2161000 | 2306000 | 2488000 | 2561000 | 2617000 | 2710000 | 2761000 | 2512000 | 2596000 | 2758000 | 2741000 | 2714000 | 2452416.666666667 | 1983586.206896552
KRS | 421000 | 413000 | 421000 | 410000 | 415000 | 392000 | 406000 | 388000 | 370000 | 375000 | 374000 | 373000 | 466000 | 468000 | 454000 | 424000 | 448000 | 428000 | 447000 | 451000 | 447000 | 396500 | 269862.0689655172
SWG | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4103.448275862069
Total Deliveries | 2980000 | 2947000 | 2833000 | 2762000 | 2935000 | 2992000 | 3028000 | 3023000 | 2646000 | 2540000 | 2684000 | 2865000 | 3031000 | 3089000 | 3168000 | 3189000 | 2964000 | 3028000 | 3209000 | 3196000 | 3165000 | 2852916.666666667 | 2257551.724137931
Fuel & LUAF | 40000 | 41000 | 39000 | 39000 | 38000 | 38000 | 36000 | 38000 | 39000 | 38000 | 33000 | 38000 | 41000 | 41000 | 39000 | 40000 | 39000 | 38000 | 39000 | 39000 | 39000 | 38083.33333333334 | 40241.37931034483
PG&E Storage Inj | 0 | 0 | 1000 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 85310.3448275862
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36000 | 37000 | 34000 | 0 | 0 | 0 | 0 | 41896.55172413793
Total Demand | 3082000 | 3048000 | 2927000 | 2861000 | 3010000 | 3031000 | 3066000 | 3066000 | 2690000 | 2584000 | 2723000 | 2909000 | 3072000 | 3130000 | 3207000 | 3264000 | 3041000 | 3101000 | 3248000 | 3235000 | 3204000 | 2916416.666666667 | 2447137.931034483
Supply
Malin | 1843000 | 1842000 | 1845000 | 1840000 | 1754000 | 1846000 | 1827000 | 1845000 | 1857000 | 1793000 | 1400000 | 1844000 | 1850000 | 1849000 | 1825000 | 1840000 | 1837000 | 1833000 | 1817000 | 1838000 | 1835000 | 1794666.666666667 | 1851896.551724138
CA Prod | 16000 | 162000 | 161000 | 162000 | 161000 | 161000 | 160000 | 163000 | 163000 | 163000 | 165000 | 165000 | 165000 | 162000 | 169000 | 164000 | 164000 | 162000 | 165000 | 162000 | 162000 | 150166.6666666667 | 131758.6206896552
Kern River GT | 0 | 26000 | 38000 | 20000 | 0 | 0 | 1000 | 0 | 29000 | 39000 | 20000 | 16000 | 84000 | 22000 | 3000 | 13000 | 14000 | 12000 | 3000 | 19000 | 5000 | 15750 | 19655.17241379311
TW | 270000 | 280000 | 76000 | 74000 | 22000 | 46000 | 91000 | 291000 | 276000 | 268000 | 272000 | 279000 | 294000 | 277000 | 272000 | 260000 | 278000 | 250000 | 299000 | 188000 | 255000 | 187083.3333333333 | 75413.79310344828
EPNG | 587000 | 556000 | 527000 | 566000 | 586000 | 518000 | 421000 | 393000 | 427000 | 435000 | 438000 | 406000 | 561000 | 603000 | 554000 | 618000 | 549000 | 536000 | 531000 | 525000 | 539000 | 488333.3333333333 | 305206.8965517241
Total Baja | 857000 | 862000 | 641000 | 660000 | 608000 | 564000 | 513000 | 684000 | 732000 | 742000 | 730000 | 701000 | 939000 | 902000 | 829000 | 891000 | 841000 | 798000 | 833000 | 732000 | 799000 | 691166.6666666666 | 400275.8620689655
Total Redwood | 1422000 | 1429000 | 1424000 | 1430000 | 1339000 | 1454000 | 1421000 | 1457000 | 1487000 | 1418000 | 1026000 | 1471000 | 1384000 | 1381000 | 1371000 | 1416000 | 1389000 | 1405000 | 1370000 | 1387000 | 1388000 | 1398166.666666667 | 1592103.448275862
KRS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10068.96551724138
PG&E Storage W/D | 141000 | 17000 | 0 | 119000 | 361000 | 393000 | 426000 | 79000 | 0 | 13000 | 185000 | 111000 | 178000 | 395000 | 316000 | 328000 | 282000 | 414000 | 131000 | 379000 | 424000 | 153750 | 56310.34482758621
Wild Goose W/D | 102000 | 99000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 90000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16750 | 1551.724137931034
Total Supply | 3167000 | 3041000 | 2770000 | 2936000 | 3030000 | 3077000 | 3020000 | 2848000 | 2801000 | 2786000 | 2533000 | 2890000 | 3222000 | 3405000 | 3192000 | 3222000 | 3124000 | 3207000 | 3017000 | 3202000 | 3309000 | 2908250 | 2441275.862068966
[NAME] | 85000 | -7000 | -157000 | 75000 | 20000 | 46000 | -46000 | -218000 | 111000 | 202000 | -190000 | -19000 | 150000 | 275000 | -15000 | -42000 | 83000 | 106000 | -231000 | -33000 | 105000 | -8166.666666666511 | -5862.068965516984
Net PG&E Inj/(W/D) | -141000 | -17000 | 1000 | -119000 | -361000 | -393000 | -426000 | -79000 | 5000 | -13000 | -185000 | -111000 | -178000 | -395000 | -316000 | -328000 | -282000 | -414000 | -131000 | -379000 | -424000 | -153250
Net Wild Goose Inj/(W/D) | -102000 | -99000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -90000 | 0 | 0 | 36000 | 37000 | 34000 | 0 | 0 | 0 | -16750
Net Inj/(W/D)-NoCal | -243000 | -116000 | 1000 | -119000 | -361000 | -393000 | -426000 | -79000 | 5000 | -13000 | -185000 | -111000 | -268000 | -395000 | -316000 | -292000 | -245000 | -380000 | -131000 | -379000 | -424000 | -170000
 | System Demand |  |  |  |  |  |  |  | Supply |  |  |  |  |  |  |  |  |  |  |  |  | 4000000 | 67500000 |  |  |  |  |  |  |  |  |  | 4000000 | 67500000
 | On System Deliveries | Kern River Station | SWG | Total Deliveries | Fuel & LUAF | PG&E Storage Injection | Wild Goose Injection | Total Demand | Malin | California Production | Kern River GT | TW | EPNG | Total Baja | Kern River Station | Total Redwood | Supply less W/D | PG&E Storage W/D | Wild Goose Storage W/D | Total System Supply | Inventory Change | Wild Goose Mo. Balance | PG&E Mo. Balance | Total Storage Inventory |  |  |  |  |  |  |  |  | Wild Goose Mo. Balance | PG&E Mo. Balance | Total Storage Inventory
1999-09-01 00:00:00 | 1983586.206896552 | 269862.0689655172 | 4103.448275862069 | 2257551.724137931 | 40241.37931034483 | 85310.3448275862 | 41896.55172413793 | 2447137.931034483 | 1851896.551724138 | 131758.6206896552 | 19655.17241379311 | 75413.79310344828 | 305206.8965517241 | 400275.8620689655 | 10068.96551724138 | 1592103.448275862 | 2394000 | 56310.34482758621 | 1551.724137931034 | 2441275.862068966 | -5862.068965516984 | 12099000 | 88920000 | 101019000 | 2383413.793103448 | 69344.82758620688 |  |  |  |  |  | 1999-03-01 00:00:00 | 4000000 | 68072000 | 72072000
1999-10-01 00:00:00 | 2175451.612903226 | 213838.7096774194 | 7161.290322580645 | 2396451.612903226 | 42354.83870967742 | 91967.74193548386 | 18903.22580645161 | 2580000 | 1840387.096774193 | 139935.4838709677 | 65354.83870967742 | 125096.7741935484 | 393516.1290322581 | 583967.7419354839 | 16322.58064516129 | 1642870.967741936 | 2580612.903225806 | 19451.61290322581 | 10645.16129032258 | 2593935.483870968 | 13935.48387096776 | 12355000 | 91168000 | 103523000 | 2563838.70967742 | 80774.1935483871 |  |  |  |  |  | 1999-04-01 00:00:00 | 4833000 | 76038000 | 80871000
1999-11-01 00:00:00 | 2223551.724137931 | 142137.9310344828 | 12241.37931034483 | 2377931.034482758 | 41827.58620689655 | 67034.4827586207 | 23758.62068965517 | 2539758.620689655 | 1751724.137931034 | 138862.0689655172 | 110827.5862068966 | 162620.6896551724 | 328517.2413793103 | 601965.5172413792 | 30206.89655172414 | 1639793.103448276 | 2522758.620689655 | 35793.10344827586 | 13206.89655172414 | 2530275.862068966 | -9482.758620689623 | 12661000 | 92074000 | 104735000 | 2481275.862068966 | 41793.10344827587 |  |  |  |  |  | 1999-05-01 00:00:00 | 6090000 | 82686000 | 88776000
1999-12-01 00:00:00 | 2764258.064516129 | 154516.1290322581 | 18903.22580645161 | 2937677.419354838 | 43322.58064516129 | 35193.54838709677 | 3096.774193548387 | 2995225.806451613 | 1727290.322580645 | 151129.0322580645 | 169096.7741935484 | 183000 | 353387.0967741936 | 705483.8709677419 | 28903.22580645161 | 1601677.419354839 | 2612806.451612903 | 344354.8387096774 | 90258.06451612903 | 2978354.838709678 | -16870.96774193551 | 9959000 | 82490000 | 92449000 | 2543741.935483871 | -396322.5806451613 |  |  |  |  |  | 1999-06-01 00:00:00 | 7764000 | 89246000 | 97010000
2000-01-01 00:00:00 | 2630774.193548387 | 108193.5483870968 | 16000 | 2754967.741935484 | 41451.6129032258 | 123677.4193548387 | 52129.03225806452 | 2827870.967741936 | 1680451.612903226 | 153064.5161290323 | 104419.3548387097 | 134774.1935483871 | 327516.1290322581 | 566709.6774193549 | 33580.64516129033 | 1605838.709677419 | 2433806.451612903 | 485258.064516129 | 123193.5483870968 | 2846677.419354839 | 18806.45161290327 | 7756000 | 71281000 | 79037000 | 2238225.806451613 | -432645.1612903226 |  |  |  |  |  | 1999-07-01 00:00:00 | 9704000 | 91285000 | 100989000
2000-02-01 00:00:00 | 2454206.896551724 | 177827.5862068966 | 15896.55172413793 | 2647931.034482758 | 41172.41379310345 | 240655.1724137931 | 68551.72413793103 | 2749413.793103448 | 1744103.448275862 | 157586.2068965517 | 154724.1379310345 | 134758.6206896552 | 285344.8275862069 | 574827.5862068965 | 24413.79310344828 | 1590689.655172414 | 2500931.034482758 | 495620.6896551724 | 89655.1724137931 | 2767793.103448276 | 18379.31034482783 | 7144000 | 63887000 | 71031000 | 2182517.24137931 | -276068.9655172414 |  |  |  |  |  | 1999-08-01 00:00:00 | 10929000 | 88079000 | 99008000
2000-03-01 00:00:00 | 2118096.774193549 | 201903.2258064516 | 13000 | 2333000 | 41677.41935483871 | 355612.9032258064 | 85290.32258064517 | 2602774.193548387 | 1790838.709677419 | 160483.8709677419 | 143516.1290322581 | 179000 | 256774.1935483871 | 579290.3225806451 | 22483.87096774194 | 1611419.35483871 | 2553096.774193548 | 267225.8064516129 | 37838.70967741936 | 2603032.258064516 | 258.0645161294378 | 8615000 | 66627000 | 75242000 | 2297967.741935484 | 135838.7096774193 |  |  |  |  |  | 1999-09-01 00:00:00 | 12099000 | 88920000 | 101019000
2000-04-01 00:00:00 | 1763166.666666667 | 188166.6666666667 | 12800 | 1964133.333333333 | 37033.33333333334 | 273633.3333333333 | 57933.33333333334 | 2296666.666666667 | 1774266.666666667 | 160066.6666666667 | 51200 | 74666.66666666667 | 246733.3333333333 | 372600 | 0 | 1586100 | 2306933.333333333 | 0 | 0 | 2306766.666666667 | 10100 | 10353000 | 74836000 | 85189000 | 2306766.666666667 | 331566.6666666666 |  |  |  |  |  | 1999-10-01 00:00:00 | 12355000 | 91168000 | 103523000
2000-05-01 00:00:00 | 1902387.096774193 | 264806.4516129032 | 6935.483870967741 | 2174129.032258064 | 33709.67741935484 | 201032.2580645161 | 48225.8064516129 | 2449709.677419355 | 1864774.193548387 | 155580.6451612903 | 45322.58064516129 | 132290.3225806452 | 237677.4193548387 | 415290.3225806451 | 0 | 1599967.741935484 | 2435645.161290323 | 0 | 8245.161290322581 | 2443322.580645161 | -6387.096774193458 | 11592400 | 81068000 | 92660400 | 2435077.419354839 | 241012.9032258065 |  |  |  |  |  | 1999-11-01 00:00:00 | 12661000 | 92074000 | 104735000
2000-06-01 00:00:00 | 2096666.666666667 | 337066.6666666667 | 5000 | 2438733.333333333 | 36233.33333333334 | 152400 | 7833.333333333333 | 2627133.333333333 | 1852566.666666667 | 147166.6666666667 | 28800 | 259700 | 299700 | 588200 | 0 | 1515500 | 2587933.333333333 | 0 | 24896.66666666667 | 2614200 | -12933.33333333349 | 11080500 | 85640000 | 96720500 | 2589303.333333333 | 135336.6666666667 |  |  |  |  |  | 1999-12-01 00:00:00 | 9959000 | 82490000 | 92449000
2000-07-01 00:00:00 | 2189483.870967742 | 368161.2903225807 | 4000 | 2561645.161290323 | 36354.83870967742 | 78419.35483870968 | 31548.38709677419 | 2699935.483870968 | 1844354.838709677 | 143193.5483870968 | 6709.677419354839 | 244806.4516129032 | 363129.0322580645 | 614645.1612903227 | 0 | 1476193.548387097 | 2602193.548387097 | 67322.58064516129 | 20193.54838709677 | 2703161.290322581 | 3225.806451613083 | 11432500 | 85984000 | 97416500 | 2615645.161290323 | 22451.61290322582 |  |  |  |  |  | 2000-01-01 00:00:00 | 7756000 | 71281000 | 79037000
2000-08-01 00:00:00 | 2553161.290322581 | 422451.6129032258 | 4000 | 2979612.903225807 | 38580.64516129033 | 0 | 3451.612903225806 | 3021677.419354839 | 1851806.451612903 | 160516.1290322581 | 10096.77419354839 | 241612.9032258065 | 504967.7419354839 | 756677.4193548388 | 0 | 1429354.838709678 | 2769000 | 221064.5161290323 | 5935.483870967741 | 2999838.709677419 | -21838.70967741963 | 11355500 | 79131000 | 90486500 |  |  |  |  |  |  |  | 2000-02-01 00:00:00 | 7144000 | 63887000 | 71031000
2000-09-01 00:00:00 | 2452416.666666667 | 396500 | 4000 | 2852916.666666667 | 38083.33333333334 | 500 | 0 | 2916416.666666667 | 1794666.666666667 | 150166.6666666667 | 15750 | 187083.3333333333 | 488333.3333333333 | 691166.6666666666 | 0 | 1398166.666666667 | 2636000 | 153750 | 16750 | 2908250 | -8166.666666666511 | 11154500 | 77292000 | 88446500 |  |  |  |  |  |  |  | 2000-03-01 00:00:00 | 8615000 | 66627000 | 75242000
 |  |  |  |  |  | 1998 |  | 1999 |  | 2000 |  |  |  |  |  |  |  |  |  | Spreads |  | Variable Rates |  |  |  |  |  |  |  |  |  | 2000-04-01 00:00:00 | 10353000 | 74836000 | 85189000
30 Year Avg. | Sac | San Fran | PG&E Stg. [NAME]. |  | OFO | LI | HI | LI | HI | LI | HI |  | Actual 98 | Forecast/Actual 99 | Forecas 00 |  |  |  |  | Socal/City Gate | Malin/City Gate | Socal/City Gate | Malin/City Gate |  |  |  |  |  |  |  |  | 2000-05-01 00:00:00 | 11592400 | 81068000 | 92660400
Jan | 45.2 | 51.1 | Total | 96000000 | Jan | 0 | 0 | 0 | 4 | 0 | 4 | Jan |  | 2841 | 2670 | Residential |  |  | 2000-09-12 00:00:00 | 0 | 0 | 0.040764 | 0.025575 |  |  |  |  |  |  |  |  | 2000-06-01 00:00:00 | 11080500 | 85640000 | 96720500
Feb | 50.7 | 54.4 | Core | 40000000 | Feb | 0 | 0 | 1 | 0 | 0 | 2 | Feb |  | 2537 | 2621 | Industrial |  |  | 2000-09-11 00:00:00 | -0.06500000000000039 | 0.635 | 0.040764 | 0.025575 |  |  |  |  |  |  |  |  | 2000-07-01 00:00:00 | 11432500 | 85984000 | 97416500
Mar | 53.6 | 54.9 | Non Core | 6000000 | Mar | 0 | 0 | 1 | 0 | 0 | 4 | Mar |  | 2296 | 2216 | Electric Gen. |  |  | 2000-09-10 00:00:00 | -0.06500000000000039 | 0.635 | 0.040764 | 0.025575 |  |  |  |  |  |  |  |  | 2000-08-01 00:00:00 | 11355500 | 79131000 | 90486500
Apr | 58.3 | 56 | Base Level | 50000000 | Apr | 1 | 4 | 1 | 0 | 0 | 1 | Apr | 1770 | 1990 | 1931 | Fuel |  |  | 2000-09-09 00:00:00 | -0.06500000000000039 | 0.635 | 0.040764 | 0.025575 |  |  |  |  |  |  |  |  | 2000-09-01 00:00:00 | 11154500 | 77292000 | 88446500
May | 65.3 | 56.6 | [NAME] | 695000 | May | 1 | 4 | 0 | 2 | 0 | 2 | May | 1578 | 1730 | 1868 | Total |  |  | 2000-09-08 00:00:00 | -0.09499999999999975 | 0.415 | 0.040764 | 0.025575 |  |  |  |  |  |  |  |  | 2000-10-01 00:00:00 | 11154500 | 77292000 | 88446500
Jun | 71.6 | 58.4 | [NAME] | 257000 | Jun | 0 | 6 | 0 | 9 | 0 | 1 | Jun | 1504 | 1598 | 1870 |  |  |  | 2000-09-07 00:00:00 | -0.07500000000000018 | 0.375 | 0.040764 | 0.025575 |  |  |  |  |  |  |  |  | 2000-11-01 00:00:00 | 11154500 | 77292000 | 88446500
Jul | 75.7 | 59.1 | *change daily based on pressure |  | Jul | 0 | 3 | 0 | 9 | 0 | 4 | Jul | 1744 | 1742 | 1986 | Extrapolated Storage Numbers |  |  | 2000-09-06 00:00:00 | -0.35 | 0.4700000000000006 | 0.040764 | 0.025575 |  |  |  |  |  |  |  |  | 2000-12-01 00:00:00 | 11154500 | 77292000 | 88446500
Aug | 75.1 | 60.1 | [NAME]. [NAME]. |  | Aug | 2 | 2 | 2 | 6 |  |  | Aug | 2188 | 2100 |  | [NAME] | PG&E Storage |  | 2000-09-05 00:00:00 | -0.35 | 0.3450000000000006 | 0.040764 | 0.025575
Sep | 71.5 | 62.3 | Total | 17000000 | Sep | 4 | 3 | 1 | 0 |  |  | Sep | 2015 | 2216 |  | 11147750 | 83378750 |  | 2000-09-04 00:00:00 | -0.35 | 0.3450000000000006 | 0.040764 | 0.025575
Oct | 64.2 | 62 | Base | 3000000 | Oct | 1 | 3 | 3 | 1 |  |  | Oct | 2151 | 2035
Nov | 53.3 | 57.2 | [NAME] | 200000 | Nov | 2 | 3 | 0 | 3 |  |  | Nov | 2591 | 2405
Dec | 45.3 | 51.7 | [NAME] | 80000 | Dec | 5 | 0 | 1 | 1 |  |  | Dec | 3125 | 2900
 |  |  |  |  |  |  |  |  |  | 2000-09-29 00:00:00