Spreadsheet: daren_farmer__5516__HPL's Calc Sheet AUGUST_2000
Sheet: Sheet1

Texoma Summary Sheet Texoma Processing
CONTRACT:  96033214
Prepared by:  [NAME]   (713) 345-7480
Houston Pipe Line Company
PRODUCTION MONTH, 2000: |  |  |  | 2000-08-01 00:00:00
CURRENT MONTH INDEX - HSC (MID) |  |  |  | 3.86
Customer: Pan Energy Marketing Company
Company: | Houston Pipe Line Company
 |  |  |  |  |  |  |  |  |  | HSC = | 3.86 |  |  |  |  | 0.05
 | T1 Gas |  |  |  |  |  |  |  | T1 Transaction |  |  |  |  |  | T2 Cash out Calculation |  |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  | Over delivery | Over delivery |  |  | Total Redelivery | Total Fuel | Total
 |  |  | T2 103% | Daily Sales | 103% T1 |  | Over-Del | T1 sales | T1 | HSC -.04 | GD mid | Dollars | Dollars | Dollars | HSC | HSC | Diff | Diff | Dollars | Dollars |  |  | at PG&E | at PG&E | Dollars
 | Total Sales | Total Pur | TOTAL | GD-.02 |  |  | Quantity |  | GD - .02 |  | less $0.02 | [NAME] | HSC Sale | T1 | GDP mid | [NAME] less | due | Due | Due | Due |  | Purchases |  |  | Fuel
 | T1 | T2 | VOL |  |  |  |  |  | Volume |  |  |  |  |  |  | 0.05 | Company | Customer | Company | Customer |  |  | Volume | Volume | 0.01
2000-08-01 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.81
2000-08-02 00:00:00 | 23853 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.82 |  |  |  |  |  |  |  | 72
2000-08-03 00:00:00 | 8036 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.115
2000-08-04 00:00:00 | 7503 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.255
2000-08-05 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.29
2000-08-06 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.29
2000-08-07 00:00:00 | 22336 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.29
2000-08-08 00:00:00 | 896 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.425
2000-08-09 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.49
2000-08-10 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.49
2000-08-11 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.45
2000-08-12 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.46
2000-08-13 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.46
2000-08-14 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.46
2000-08-15 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.44
2000-08-16 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.26
2000-08-17 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.265
2000-08-18 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.38
2000-08-19 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.405
2000-08-20 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.405
2000-08-21 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.405
2000-08-22 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.645
2000-08-23 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.83
2000-08-24 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.69
2000-08-25 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.465
2000-08-26 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.545
2000-08-27 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.545
2000-08-28 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.545
2000-08-29 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.63
2000-08-30 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.645
2000-08-31 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.63
 |  |  |  |  |  |  |  | T1 Sales Volume |  |  | T2 Purchase Volume |  |  |  |  | Volume | Cashout Due
 |  |  |  |  |  |  |  | T1 Excess of 103% |  |  | T2 Purchase Over-delivery |  |  |  |  | Difference | [NAME] (Duke)
 |  |  |  |  |  |  |  | T1 Over-delivery |  |  | Purchase |  |  |  | Difference
 |  |  |  |  |  |  |  | Total  Sales |  |  | Less Fuel
 |  |  |  |  |  |  |  |  |  |  | Total Purchase
 | Transaction T2
 |  | Index |  | Index |  | Duke | Index |  | Index |  | Index |  | Index |  | Index | Total | Total
 | Fuel | HSC | Oak Hill | HSC | PGE | allocations | HSC | [NAME] | HSC | [NAME] | HSC | Mobil Bea | HSC | Carthage tail | HSC | Purchases | Dollars
 | Cotton | -0.05 |  | -0.05 | Carth Tail |  | -0.06 | Interfin | -0.05 | Sabine | -0.05 | Cipco | -0.0375 |  | -0.0825 | [NAME]
2000-08-01 00:00:00 | 0 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-02 00:00:00 | 8574 |  |  |  | 16997 |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  | 2000-08-01 00:00:00 | Sales |  | Purchases | Net
2000-08-03 00:00:00 | 8590 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  | Exchange | 246059.36 |  | 1091023.66
2000-08-04 00:00:00 | 7994 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-05 00:00:00 | 7930 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  | Spot | 0 |  | 105800.86
2000-08-06 00:00:00 | 7721 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-07 00:00:00 | 7132 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | Net Due Duke
2000-08-08 00:00:00 | 7665 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-09 00:00:00 | 7507 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-10 00:00:00 | 7965 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-11 00:00:00 | 7813 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-12 00:00:00 | 7398 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-13 00:00:00 | 7944 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-14 00:00:00 | 7717 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-15 00:00:00 | 7700 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-16 00:00:00 | 7800 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-17 00:00:00 | 8701 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-18 00:00:00 | 8021 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-19 00:00:00 | 7557 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-20 00:00:00 | 7718 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-21 00:00:00 | 7454 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-22 00:00:00 | 8210 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-23 00:00:00 | 7546 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-24 00:00:00 | 7940 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-25 00:00:00 | 7828 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-26 00:00:00 | 7526 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-27 00:00:00 | 7851 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-28 00:00:00 | 7608 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-29 00:00:00 | 9233 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-30 00:00:00 | 8855 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
2000-08-31 00:00:00 | 8981 |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg. Price