Spreadsheet: carol_st_clair__1490__Deals COB 052801 (to assign to mscg)
Sheet: merchant energy group cob 05280

month_dt | Date | source_system_nm | enron_entity | deal_num | idx_deal | pr_deal | buy_sell_flg | buy_volume | buy_exposure | sell_volume | sell_exposure | Net Volumes | Net Exposure | counterparty_legal_nm | product_cd | breakfld
5/1/2001 [NAME] |  | Power Books | EPMI | 200536.01 |  |  | B | 1200 | 27540 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL | MEGA ID#s
6/1/2001 [NAME] |  | Power Books | EPMI | 200536.01 |  |  | B | 18000 | 413100 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL | ABH260
7/1/2001 00:00:00 |  | Power Books | EPMI | 200536.01 |  |  | B | 18600 | 426870 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL | ABX491
8/1/2001 00:00:00 |  | Power Books | EPMI | 200536.01 |  |  | B | 18600 | 426870 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL | ABX154
9/1/2001 [NAME] |  | Power Books | EPMI | 200536.01 |  |  | B | 18000 | 413100 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL
10/1/2001 00:00:00 |  | Power Books | EPMI | 200536.01 |  |  | B | 18625 | 427443.75 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL
11/1/2001 00:00:00 |  | Power Books | EPMI | 200536.01 |  |  | B | 18000 | 413100 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL
12/1/2001 00:00:00 |  | Power Books | EPMI | 200536.01 |  |  | B | 18600 | 426870 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL
1/1/2002 [NAME] |  | Power Books | EPMI | 220051.01 |  |  | B | 8200 | 166050 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15 | MEGA ID#s
2/1/2002 [NAME] |  | Power Books | EPMI | 220051.01 |  |  | B | 7200 | 145800 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15 | ABB801
3/1/2002 [NAME] |  | Power Books | EPMI | 220051.01 |  |  | B | 8200 | 166050 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
4/1/2002 00:00:00 |  | Power Books | EPMI | 220051.01 |  |  | B | 7575 | 153393.75 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
5/1/2002 [NAME] |  | Power Books | EPMI | 220051.01 |  |  | B | 8200 | 166050 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
6/1/2002 [NAME] |  | Power Books | EPMI | 220051.01 |  |  | B | 8000 | 162000 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
7/1/2002 [NAME] |  | Power Books | EPMI | 220051.01 |  |  | B | 8200 | 166050 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
8/1/2002 00:00:00 |  | Power Books | EPMI | 220051.01 |  |  | B | 7800 | 157950 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
9/1/2002 00:00:00 |  | Power Books | EPMI | 220051.01 |  |  | B | 8400 | 170100 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
10/1/2002 [NAME] |  | Power Books | EPMI | 220051.01 |  |  | B | 7825 | 158456.25 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
11/1/2002 [NAME] |  | Power Books | EPMI | 220051.01 |  |  | B | 8000 | 162000 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
12/1/2002 00:00:00 |  | Power Books | EPMI | 220051.01 |  |  | B | 8600 | 174150 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
5/1/2001 [NAME] |  | Power Books | EPMI | 220052.01 |  |  | S |  | 0 | 400 | 7800 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15 | MEGA ID#s
6/1/2001 [NAME] |  | Power Books | EPMI | 220052.01 |  |  | S |  | 0 | 7600 | 148200 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15 | ABA429
7/1/2001 00:00:00 |  | Power Books | EPMI | 220052.01 |  |  | S |  | 0 | 8600 | 167700 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
8/1/2001 00:00:00 |  | Power Books | EPMI | 220052.01 |  |  | S |  | 0 | 7800 | 152100 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
9/1/2001 [NAME] |  | Power Books | EPMI | 220052.01 |  |  | S |  | 0 | 8400 | 163800 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
10/1/2001 00:00:00 |  | Power Books | EPMI | 220052.01 |  |  | S |  | 0 | 7825 | 152587.5 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
11/1/2001 00:00:00 |  | Power Books | EPMI | 220052.01 |  |  | S |  | 0 | 8000 | 156000 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
12/1/2001 00:00:00 |  | Power Books | EPMI | 220052.01 |  |  | S |  | 0 | 8600 | 167700 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
1/1/2002 [NAME] |  | Power Books | EPMI | 226189.01 |  |  | B | 8200 | 168100 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15 | MEGA ID #s
2/1/2002 [NAME] |  | Power Books | EPMI | 226189.01 |  |  | B | 7200 | 147600 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15 | AAU572
3/1/2002 [NAME] |  | Power Books | EPMI | 226189.01 |  |  | B | 8200 | 168100 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
4/1/2002 00:00:00 |  | Power Books | EPMI | 226189.01 |  |  | B | 7575 | 155287.5 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
5/1/2002 [NAME] |  | Power Books | EPMI | 226189.01 |  |  | B | 8200 | 168100 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
6/1/2002 [NAME] |  | Power Books | EPMI | 226189.01 |  |  | B | 8000 | 164000 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
7/1/2002 [NAME] |  | Power Books | EPMI | 226189.01 |  |  | B | 8200 | 168100 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
8/1/2002 00:00:00 |  | Power Books | EPMI | 226189.01 |  |  | B | 7800 | 159900 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
9/1/2002 00:00:00 |  | Power Books | EPMI | 226189.01 |  |  | B | 8400 | 172200 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
10/1/2002 [NAME] |  | Power Books | EPMI | 226189.01 |  |  | B | 7825 | 160412.5 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
11/1/2002 [NAME] |  | Power Books | EPMI | 226189.01 |  |  | B | 8000 | 164000 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
12/1/2002 00:00:00 |  | Power Books | EPMI | 226189.01 |  |  | B | 8600 | 176300 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
5/1/2001 [NAME] |  | Power Books | EPMI | 249547.01 |  |  | S |  | 0 | 400 | 7960 |  |  | Merchant Energy Group of the Americas, Inc. | POW-WSCC-S | POW-WSCC-S | MEGA ID#s
6/1/2001 [NAME] |  | Power Books | EPMI | 249547.01 |  |  | S |  | 0 | 7600 | 151240 |  |  | Merchant Energy Group of the Americas, Inc. | POW-WSCC-S | POW-WSCC-S | ABA338
7/1/2001 00:00:00 |  | Power Books | EPMI | 249547.01 |  |  | S |  | 0 | 8600 | 171140 |  |  | Merchant Energy Group of the Americas, Inc. | POW-WSCC-S | POW-WSCC-S
8/1/2001 00:00:00 |  | Power Books | EPMI | 249547.01 |  |  | S |  | 0 | 7800 | 155220 |  |  | Merchant Energy Group of the Americas, Inc. | POW-WSCC-S | POW-WSCC-S
9/1/2001 [NAME] |  | Power Books | EPMI | 249547.01 |  |  | S |  | 0 | 8400 | 167160 |  |  | Merchant Energy Group of the Americas, Inc. | POW-WSCC-S | POW-WSCC-S
10/1/2001 00:00:00 |  | Power Books | EPMI | 249547.01 |  |  | S |  | 0 | 7825 | 155717.5 |  |  | Merchant Energy Group of the Americas, Inc. | POW-WSCC-S | POW-WSCC-S
11/1/2001 00:00:00 |  | Power Books | EPMI | 249547.01 |  |  | S |  | 0 | 8000 | 159200 |  |  | Merchant Energy Group of the Americas, Inc. | POW-WSCC-S | POW-WSCC-S
12/1/2001 00:00:00 |  | Power Books | EPMI | 249547.01 |  |  | S |  | 0 | 8600 | 171140 |  |  | Merchant Energy Group of the Americas, Inc. | POW-WSCC-S | POW-WSCC-S
10/1/2001 00:00:00 |  | Power Books | EPMI | 329919.01 |  |  | B | 18400 | 539120 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SPP | POW-SPP | MEGA ID#s
11/1/2001 00:00:00 |  | Power Books | EPMI | 329919.01 |  |  | B | 16800 | 492240 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SPP | POW-SPP | ABL377
12/1/2001 00:00:00 |  | Power Books | EPMI | 329919.01 |  |  | B | 16000 | 468800 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SPP | POW-SPP
5/1/2001 [NAME] |  | Power Books | EPMI | 432048.01 |  |  | S |  | 0 | 1200 | 61200 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL | MEGA ID#s
6/1/2001 [NAME] |  | Power Books | EPMI | 432048.01 |  |  | S |  | 0 | 18000 | 918000 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL | ABW442
7/1/2001 00:00:00 |  | Power Books | EPMI | 432048.01 |  |  | S |  | 0 | 18600 | 948600 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL | ABW443
8/1/2001 00:00:00 |  | Power Books | EPMI | 432048.01 |  |  | S |  | 0 | 18600 | 948600 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL
9/1/2001 [NAME] |  | Power Books | EPMI | 432048.01 |  |  | S |  | 0 | 18000 | 918000 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL
10/1/2001 00:00:00 |  | Power Books | EPMI | 432048.01 |  |  | S |  | 0 | 18625 | 949875 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL
11/1/2001 00:00:00 |  | Power Books | EPMI | 432048.01 |  |  | S |  | 0 | 18000 | 918000 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL
12/1/2001 00:00:00 |  | Power Books | EPMI | 432048.01 |  |  | S |  | 0 | 18600 | 948600 |  |  | Merchant Energy Group of the Americas, Inc. | POW-MID-COL | POW-MID-COL
5/1/2001 [NAME] |  | Power Books | EPMI | 510554.01 |  |  | B | 1600 | 32400 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15 | MEGA ID #s
6/1/2001 [NAME] |  | Power Books | EPMI | 510554.01 |  |  | B | 30400 | 615600 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15 | ABZ708
7/1/2001 00:00:00 |  | Power Books | EPMI | 510554.01 |  |  | B | 34400 | 696600 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
8/1/2001 00:00:00 |  | Power Books | EPMI | 510554.01 |  |  | B | 31200 | 631800 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
9/1/2001 [NAME] |  | Power Books | EPMI | 510554.01 |  |  | B | 33600 | 680400 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
10/1/2001 00:00:00 |  | Power Books | EPMI | 510554.01 |  |  | B | 31300 | 633825 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
11/1/2001 00:00:00 |  | Power Books | EPMI | 510554.01 |  |  | B | 32000 | 648000 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
12/1/2001 00:00:00 |  | Power Books | EPMI | 510554.01 |  |  | B | 34400 | 696600 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
1/1/2002 [NAME] |  | Power Books | EPMI | 510554.01 |  |  | B | 32800 | 664200 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
2/1/2002 [NAME] |  | Power Books | EPMI | 510554.01 |  |  | B | 28800 | 583200 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
3/1/2002 [NAME] |  | Power Books | EPMI | 510554.01 |  |  | B | 32800 | 664200 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
4/1/2002 00:00:00 |  | Power Books | EPMI | 510554.01 |  |  | B | 30300 | 613575 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
5/1/2002 [NAME] |  | Power Books | EPMI | 510554.01 |  |  | B | 32800 | 664200 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
6/1/2002 [NAME] |  | Power Books | EPMI | 510554.01 |  |  | B | 32000 | 648000 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
7/1/2002 [NAME] |  | Power Books | EPMI | 510554.01 |  |  | B | 32800 | 664200 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
8/1/2002 00:00:00 |  | Power Books | EPMI | 510554.01 |  |  | B | 31200 | 631800 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
9/1/2002 00:00:00 |  | Power Books | EPMI | 510554.01 |  |  | B | 33600 | 680400 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
10/1/2002 [NAME] |  | Power Books | EPMI | 510554.01 |  |  | B | 31300 | 633825 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
11/1/2002 [NAME] |  | Power Books | EPMI | 510554.01 |  |  | B | 32000 | 648000 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
12/1/2002 00:00:00 |  | Power Books | EPMI | 510554.01 |  |  | B | 34400 | 696600 |  | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-SP15 | POW-SP15
 | Net Volumes & Exposure to be Assigned
 | TRANSACTIONS TO BE ASSIGNED TO MORGAN STANLY CAPITAL GROUP - ABOVE THIS LINE
7/1/2001 00:00:00 |  | Power Books | EPMI | 564748.01 OPT |  |  | S |  | 0 | 84000 | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-CINERGY | POW-CINERGY
8/1/2001 00:00:00 |  | Power Books | EPMI | 564748.01 OPT |  |  | S |  | 0 | 92000 | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-CINERGY | POW-CINERGY
7/1/2002 [NAME] |  | Power Books | EPMI | 564748.01 OPT |  |  | S |  | 0 | 88000 | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-CINERGY | POW-CINERGY
8/1/2002 00:00:00 |  | Power Books | EPMI | 564748.01 OPT |  |  | S |  | 0 | 88000 | 0 |  |  | Merchant Energy Group of the Americas, Inc. | POW-CINERGY | POW-CINERGY
6/1/2001 [NAME] |  | Power Books | EPMI | 564748.02 |  |  | S |  | 0 | 1 | 160000 |  |  | Merchant Energy Group of the Americas, Inc. | POW-CINERGY | POW-CINERGY