Spreadsheet: larry_campbell__21456__Gas Deal Control
Sheet: Sheet1

Structurer | CityGate_NM | Buy/Sell | Phys | ServiceLevel_NM | Trans ID | Selling Index | SumOfMTM Income | Origination | SumOfVol_Expected | Originator | Meters | Term | First Flow | Last | ConType_NM | CntrParty_NM | New/Roll/Mod | Contract_Price | Deal Type | Price Book | Basis Book | Premium Book | Transport Book | Fuel Book | Special Book | ModDate | DealDate | Region_NM
 | CA-PG&E | Sell | Phys | Citygate - Core | 307135 | NGI-PGE/CG | 3038.841910141677 | 2879.23 | 20660 | [NAME] | 3 | 48 | 2000-05-01 00:00:00 | 2004-04-01 00:00:00 | Roll Over | Dry Creek Laundromat | 2 | 0.16 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 11:51:27.633000 | 2000-03-31 00:00:00 | West
 | CA-SOCAL Gas | Sell | Phys | Core Procurement | 307138 | NGI-SOCAL | 1693.375305954507 | 1710.4 | 22551 | Washington | 1 | 36 | 2000-06-01 00:00:00 | 2003-05-01 00:00:00 | Roll Over | [NAME] | 2 | 0.09 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 12:13:52.680000 | 2000-03-31 00:00:00 | West
 | CNG POOL | Buy | Fin | Firm | 307139 | NYMEX | 482.9980188134618 | 0 | 210000 | Vanderhorst | 0 | 7 | 2001-04-01 00:00:00 | 2001-10-01 00:00:00 | New | ECT - East | 1 | 0.1825 | Index | NO | YES | NO | NO | NO | NO | 2000-03-31 14:27:38.853000 | 2000-03-31 00:00:00 | None
 | CNG POOL | Buy | Fin | Firm | 307140 | NYMEX | -1184.369546790714 | 0 | 280000 | Vanderhorst | 0 | 7 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | New | ECT - East | 1 | 0.185 | Index | NO | YES | NO | NO | NO | NO | 2000-03-31 14:29:25.603000 | 2000-03-31 00:00:00 | None
 | CNG POOL | Buy | Fin | Firm | 307140 | NYMEX | 0 | 0 | 840000 | Vanderhorst | 0 | 21 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | New | ECT - East | 1 | 0.185 | Index | NO | YES | NO | NO | NO | NO | 2000-03-31 14:29:25.603000 | 2000-03-31 00:00:00 | None
 | CNG POOL | Buy | Fin | Firm | 307141 | NYMEX | -826.21501858694 | 0 | 210000 | Vanderhorst | 0 | 7 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | New | ECT - East | 1 | 0.185 | Index | NO | YES | NO | NO | NO | NO | 2000-03-31 14:31:15.197000 | 2000-03-31 00:00:00 | None
 | CNG POOL | Buy | Fin | Firm | 307141 | NYMEX | 0 | 0 | 630000 | Vanderhorst | 0 | 21 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | New | ECT - East | 1 | 0.185 | Index | NO | YES | NO | NO | NO | NO | 2000-03-31 14:31:15.197000 | 2000-03-31 00:00:00 | None
 | CNG POOL | Buy | Fin | Firm | 307142 | NYMEX | -640.488103257306 | 0 | 175000 | Vanderhorst | 0 | 7 | 2004-04-01 00:00:00 | 2004-10-01 00:00:00 | New | ECT - East | 1 | 0.185 | Index | NO | YES | NO | NO | NO | NO | 2000-03-31 14:32:41.040000 | 2000-03-31 00:00:00 | None
 | CNG POOL | Buy | Fin | Firm | 307142 | NYMEX | 0 | 0 | 525000 | Vanderhorst | 0 | 21 | 2004-04-01 00:00:00 | 2004-10-01 00:00:00 | New | ECT - East | 1 | 0.185 | Index | NO | YES | NO | NO | NO | NO | 2000-03-31 14:32:41.040000 | 2000-03-31 00:00:00 | None
 | IL-PGLC CG | Buy | Phys | SST - 20% Discount | 307134 | NGI/CHI. GATE | -9502.44825143793 | -9502.66 | 6206 | [NAME] | -1 | 12 | 2000-06-01 00:00:00 | 2001-05-01 00:00:00 | Modification | LPW Ltd. [NAME] | 3 | 1.6 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 11:48:48.853000 | 2000-03-31 00:00:00 | Central
 | IL-PGLC CG | Sell | Phys | SST - 20% Discount | 307133 | NGI/CHI. GATE | 1055.642524551581 | 1026.52 | 6206 | [NAME] | 1 | 12 | 2000-06-01 00:00:00 | 2001-05-01 00:00:00 | Roll Over | LPW Ltd. [NAME] | 2 | 0.16 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 11:47:39.260000 | 2000-03-31 00:00:00 | Central
 | NJ-ETOWN CG | Sell | Phys | Firm - Commercial | 307132 | NYMEX | 1329.961277437311 | 1295 | 2184 | Jethwa | 1 | 24 | 2000-05-01 00:00:00 | 2002-04-01 00:00:00 | New | [NAME] | 1 | 1.13 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 11:26:11.337000 | 2000-03-31 00:00:00 | None
 | NYMEX | Sell | Fin | Firm | 307143 | NYMEX | -2151.285925519314 | 0 | 920000 | [NAME] | 0 | 6 | 2000-05-01 00:00:00 | 2000-10-01 00:00:00 | New | ECT - Price | 1 | 2.965 | Fixed | YES | NO | NO | NO | NO | NO | 2000-03-31 14:32:53.430000 | 2000-03-31 00:00:00 | None
 | OH-Columbia of Ohio | Sell | Phys | Zone 7 Aggregation Service | 307137 | NYMEX | 705.0764903362449 | 563.54 | 10065 | Barnum | 2 | 18 | 2000-05-01 00:00:00 | 2001-10-01 00:00:00 | New | America's Body Co | 1 | 0.475 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 11:58:38.087000 | 2000-03-31 00:00:00 | None
 | OH-East Ohio Gas | Sell | Phys | Firm-Index Price | 307131 | NYMEX | 7267.215477429579 | 6357.04 | 77680 | Barnum | 1 | 18 | 2000-05-01 00:00:00 | 2001-10-01 00:00:00 | Roll Over | Erieview Metals | 2 | 0.43 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 11:19:15.540000 | 2000-03-31 00:00:00 | None
 | OH-East Ohio Gas | Sell | Phys | Firm-Index Price | 307136 | NYMEX | 1065.992420030284 | 860.47 | 17466 | Barnum | 3 | 18 | 2000-05-01 00:00:00 | 2001-10-01 00:00:00 | New | America's Body Co | 1 | 0.51 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 11:56:13.243000 | 2000-03-31 00:00:00 | None
 | TCO Pool | Sell | Phys | Firm | 307130 | NYMEX | 21019.04407855815 | 0 | 1070000 | Vanderhorst | 0 | 7 | 2000-04-01 00:00:00 | 2000-10-01 00:00:00 | Modification | Enserch Energy | 3 | 0.1625 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 10:50:58.433000 | 2000-03-31 00:00:00 | None
 | TRANSCO ZN6 Pool | Buy | Phys | Firm | 307144 | NYMEX | -822.849126893427 | 0 | 105000 | Vanderhorst | 0 | 7 | 2001-04-01 00:00:00 | 2001-10-01 00:00:00 | New | American Electric Power | 1 | 0.3 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 14:36:13.400000 | 2000-03-31 00:00:00 | None
 | TRANSCO ZN6 Pool | Buy | Phys | Firm | 307145 | NYMEX | -1428.990950865447 | 0 | 105000 | Vanderhorst | 0 | 7 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | New | ECT - East | 1 | 0.3075 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 14:37:53.950000 | 2000-03-31 00:00:00 | None
 | TRANSCO ZN6 Pool | Buy | Phys | Firm | 307147 | NYMEX | -1428.990950865447 | 0 | 105000 | Vanderhorst | 0 | 7 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | New | American Electric Power | 1 | 0.3075 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 14:52:13.947000 | 2000-03-31 00:00:00 | None
 | TRANSCO ZN6 Pool | Buy | Phys | Firm | 307150 | NYMEX | -2558.677421058764 | 0 | 175000 | Vanderhorst | 0 | 7 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | New | American Electric Power | 1 | 0.31 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 15:03:52.573000 | 2000-03-31 00:00:00 | None
 | TRANSCO ZN6 Pool | Buy | Phys | Firm | 307151 | NYMEX | -1619.635464248406 | 0 | 105000 | Vanderhorst | 0 | 7 | 2004-04-01 00:00:00 | 2004-10-01 00:00:00 | New | American Electric Power | 1 | 0.3125 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 15:05:39.307000 | 2000-03-31 00:00:00 | None
 | TRANSCO ZN6 Pool | Sell | Phys | Firm | 307146 | NYMEX | 1428.990950865446 | 0 | 105000 | Vanderhorst | 0 | 7 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | Modification | ECT - East | 3 | 0.3075 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 14:50:29.950000 | 2000-03-31 00:00:00 | None
EES_HOUSTON\thamilto | CA-PG&E | Buy | Fin | Citygate - Non Core | 307148 | NYMEX | 543.050643311733 | 0 | 180000 | West Desk | 0 | 6 | 2000-05-01 00:00:00 | 2000-10-01 00:00:00 | New | ECT - West | 1 | 0.3075 | Index | NO | YES | NO | NO | NO | NO | 2000-03-31 15:01:10.370000 | 2000-03-31 00:00:00 | None
EES_HOUSTON\thamilto | NV-SW Gas | Sell | Phys | [NAME] | 307152 | NGI-SOCAL | 1640.648785347294 | 914.48 | 42959 | Ponce | 0 | 12 | 2000-04-01 00:00:00 | 2001-03-01 00:00:00 | Roll Over | Hanson Aggregates Las Vegas | 2 | 0.03 | Index | NO | YES | YES | YES | YES | YES | 2000-03-31 15:06:36.417000 | 2000-03-31 00:00:00 | West
EES_HOUSTON\thamilto | TX-Lone Star Gas | Buy | Fin | Plus Fifty | 307149 | NYMEX | -8796.81686537668 | 0 | 1410000 | West Desk | 0 | 47 | 2000-05-01 00:00:00 | 2004-03-01 00:00:00 | New | ECT - West | 1 | 0 | Index | NO | YES | NO | NO | NO | NO | 2000-03-31 15:03:44.337000 | 2000-03-31 00:00:00 | None