Spreadsheet: richard_shapiro__32618__Summary of ca_audio_pivot
Sheet: Summary

Sources and Notes:
CONFIDENTIAL ATTY CLIENT WORK PRODUCT
Source: California Audit data base
This table includes all EPMI transactions with physical delivery in California, both short-term and long-term
Financial transactions (e.g. financial swaps) are excluded
ZP-26 is a zone located between NP-15 and SP-15
EPMI Trades with all [NAME] Parties with Deliveries in California
CP_NM | (All)
From_Region | (All)
Total Volume MWh |  | year1 | [NAME]
 |  | 2000 |  |  |  |  |  |  |  |  |  |  |  | 2000 Total | 2001 |  |  |  |  |  |  | 2001 YTD Total | Grand Total
To_Region | Transaction_Type | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
NP-15 | P | 778455.2000020202 | 711573.0599972568 | 703011.2575117089 | 874048.6799463034 | 1156833.209994325 | 1548402.13000679 | 2247991.720008492 | 2806062.00998326 | 3137259.559973687 | 3631323.900011051 | 4568901.540053487 | 4389069.489990963 | 26552931.75747935 | 2797363.330001708 | 2626092.949985504 | 2935672.670001373 | 2517240.079996109 | 2707856.959999617 | 3160560.010002136 | 1760477 | 18505262.99998645 | 45058194.75746579
 | S | -781141.4465133641 | -649324.87712753 | -697755.5174809191 | -822123.1000489555 | -1132008.349897856 | -1503458.063536942 | -2204367.590186484 | -2852810.500032138 | -3239485.519798828 | -3900639.516335649 | -4789649.369976187 | -4595929.630082043 | -27168693.4810169 | -2852963.680608746 | -2620922.099995084 | -2930190.47000476 | -2628991.000001311 | -2876760 | -3293952 | -1785851 | -18989630.2506099 | -46158323.73162679
 | T | -1900.09002161026 | -66433.1700270772 | -9924.739977819845 | -57534.57999992371 | -29929.05998264998 | -53468.68902164325 | -49213.11989548802 | 38972.39011938125 | 94841.49983979203 | 266339.2116626874 | 206008.9697827231 | 205098.7899616957 | 542857.4124400672 | 49823.46078978851 | 7644.989989979193 | -5592.609921634197 | 84484.2399995327 | 123788.7599996962 | -20800 | 31718 | 271066.8408573624 | 813924.2532974295
NP-15 Total |  | -4586.336532954127 | -4184.987157350406 | -4668.999947030097 | -5609.000102575868 | -5104.19988618046 | -8524.62255179463 | -5588.990073479712 | -7776.099929496646 | -7384.459985349327 | -2976.404661910608 | -14738.86013997719 | -1761.350129384547 | -72904.31109748222 | -5776.88981724903 | 12815.83998039924 | -110.4099250212312 | -27266.68000566959 | -45114.28000068665 | -154191.9899978638 | 6344 | -213300.409766091 | -286204.7208635695
SP-15 | P | 469875.6099996753 | 665615.3899946511 | 811080.3499962464 | 1326374.940008163 | 1441476.749995876 | 1575109.230020139 | 2961200.940012474 | 3478616.720046991 | 3951631.189977547 | 2859877.599996127 | 2806995.080078082 | 3240454.350108147 | 25588308.15023412 | 2795299.519976929 | 2739704.48005268 | 3100285.579998236 | 2841110.56005621 | 3055769.290015817 | 3754157.030004382 | 2170523.399998665 | 20456849.86010292 | 46045158.01033704
 | S | -474652.8300015647 | -735216.1999828238 | -815123.4199554883 | -1387750.060033916 | -1473411.070096476 | -1601577.550712366 | -2984586.739963332 | -3277549.090089845 | -3753466.455220329 | -2508173.219269628 | -2540300.480006719 | -3022896.169938939 | -24574703.28527142 | -2734013.050115466 | -2761663.309969205 | -3098443.409998089 | -2699755.700001433 | -2854119 | -3518864 | -2031894 | -19698752.47008419 | -44273455.75535561
 | T | -214.90997838974 | 67354.44997761585 | 1736.459979994223 | 47351.12004988268 | 15559.54998466 | 18325.7452070713 | 7123.039980173111 | -204635.2501289323 | -199060.9254807867 | -352264.3114615679 | -266599.6397870462 | -257491.5999500751 | -1122816.271607401 | -132001.4106647372 | -9566.739982225 | -1452.930071055889 | -91300.2399995327 | -130753.7599996962 |  | -31718 | -396793.080717247 | -1519609.352324648
SP-15 Total |  | -4992.129980279133 | -2246.360010556877 | -2306.609979247674 | -14023.99997586943 | -16374.7701159399 | -8142.575485154986 | -16262.759970685 | -3567.620171785355 | -896.1907235682011 | -559.9307350683957 | 94.9602843169123 | -39933.41978086717 | -109211.4066447038 | -70714.94080327451 | -31525.56989875063 | 389.2399290911853 | 50054.62005524337 | 70896.53001612052 | 235293.0300043821 | 106911.3999986649 | 361304.3093014769 | 252092.9026567806
ZP-26 | P |  | 8000 | 10800 | 6033.939999748021 | 16789.23999977112 | 1051 | 42697.47001266479 | 56630 | 26274 |  | 425 |  | 168700.6500121839 | 825.3300000112504 |  |  |  |  |  |  | 825.3300000112504 | 169525.9800121952
 | S |  | -5286.359999563545 | -16911.27999970317 | -7731.400001503527 | -20391.75001144409 | -19663.94543457031 | -79508.06999397278 | -86560.7299900055 | -80828.42549324036 | -20563.6798210144 | -18994.67000102997 | -19518.80995559692 | -375959.1207016446 | -18792.87000178173 | -1471.749992961064 | -1255.539992690086 | -132 |  |  |  | -21652.15998743288 | -397611.2806890775
 | T |  | -2713.639951149002 | 5044.279997825623 | 1697.459950041026 | 3602.509997989982 | 18612.94381457195 | 36810.59991958737 | 29929.86000955105 | 54554.42564099468 | 20564.09979888052 | 18569.67000432312 | 19518.80998265743 | 206191.0191652738 | 17969.07999463007 | 1471.749992245808 | 1255.539992690086 | -665 | -352 |  |  | 19679.36997956596 | 225870.3891448397
ZP-26 Total |  |  | 4.928745329380035e-05 | -1067.000001877546 | -5.171447992324829e-05 | -1.368299126625061e-05 | -0.00161999836564064 | -6.172060966491699e-05 | -0.8699804544448853 | 0.0001477543264627457 | 0.4199778661131859 | 3.293156623840332e-06 | 2.706050872802734e-05 | -1067.451524186879 | 1.539992859587073 | -7.152557373046875e-07 | 0 | -797 | -352 |  |  | -1147.460007855669 | -2214.911532042548
Grand Total |  | -9578.46651323326 | -6431.347118619829 | -8042.609928155318 | -19633.00013015978 | -21478.97001580335 | -16667.19965694798 | -21851.75010588532 | -11344.59008173645 | -8280.650561163202 | -3535.915419112891 | -14643.89985236712 | -41694.76988319121 | -183183.1692663711 | -76490.29062766396 | -18709.72991906665 | 278.8300040699542 | 21990.94004957378 | 25430.25001543388 | 81101.04000651836 | 113255.3999986649 | 146856.4395275321 | -36326.72973882779
EPMI Trades with Dynegy Power Marketing, Inc. with Deliveries in California
CP_NM | Dynegy Power Marketing, Inc.
From_Region | (All)
Total Volume MW |  | year1 | [NAME]
 |  | 2000 |  |  |  |  |  |  |  |  |  |  |  | 2000 Total | 2001 |  |  |  |  |  |  | 2001 YTD Total | Grand Total
To_Region | Transaction_Type | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
NP-15 | P | 18800 | 14800 | 15600 | 10000 | 11200 | 14800 | 19400 | 8600 | 38000 | 750 | 6275 | 50000 | 208225 | 113600 | 108600 | 110200 | 20200 | 26975 | 29010 | 12440 | 421025 | 629250
 | S | -800 | -11000 | -2800 | -6800 | -2400 | -18000 | -40168 | -33200 | -55200 | -22050 | -29600 | -11400 | -233418 | -77900 | -107140 | -121313 | -37998 | -40600 | -69252 | -4424 | -458627 | -692045
NP-15 Total |  | 18000 | 3800 | 12800 | 3200 | 8800 | -3200 | -20768 | -24600 | -17200 | -21300 | -23325 | 38600 | -25193 | 35700 | 1460 | -11113 | -17798 | -13625 | -40242 | 8016 | -37602 | -62795
SP-15 | P | 30550 | 84125 | 44800 | 10925 | 22650 | 18260 | 76675 | 96575 | 162100 | 156600 | 108800 | 76984 | 889044 | 59650 | 62240 | 88400 | 101335 | 70892 | 97934 | 85720 | 566171 | 1455215
 | S | -2400 | -1600 |  | -10400 | -4520 | -21600 | -83200 | -85600 | -136000 | -70050 | -53385 | -65400 | -534155 | -18143 | -32484 | -63728 | -76417 | -86231 | -148788 | -90549 | -516340 | -1050495
SP-15 Total |  | 28150 | 82525 | 44800 | 525 | 18130 | -3340 | -6525 | 10975 | 26100 | 86550 | 55415 | 11584 | 354889 | 41507 | 29756 | 24672 | 24918 | -15339 | -50854 | -4829 | 49831 | 404720
ZP-26 | P |  |  |  |  |  |  |  | 21600 |  |  |  |  | 21600 |  |  |  |  |  |  |  |  | 21600
ZP-26 Total |  |  |  |  |  |  |  |  | 21600 |  |  |  |  | 21600 |  |  |  |  |  |  |  |  | 21600
Grand Total |  | 46150 | 86325 | 57600 | 3725 | 26930 | -6540 | -27293 | 7975 | 8900 | 65250 | 32090 | 50184 | 351296 | 77207 | 31216 | 13559 | 7120 | -28964 | -91096 | 3187 | 12229 | 363525
EPMI Trades with all [NAME] Parties with Deliveries in California MINUS Trades with Dynegy Power Marketing, Inc.
CP_NM | (All)
From_Region | (All)
Total Volume MW |  | year1 | [NAME]
 |  | 2000 |  |  |  |  |  |  |  |  |  |  |  | 2000 Total | 2001 |  |  |  |  |  |  | 2001 YTD Total | Grand Total
To_Region | Transaction_Type | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
NP-15 | P
 | S
 | T
NP-15 Total
SP-15 | P
 | S
 | T
SP-15 Total
ZP-26 | P
 | S
 | T
ZP-26 Total
Grand Total