Spreadsheet: michelle_lokay__26675__Reliant
Sheet: Deal

[NAME] for May 2001
K# 27496
 |  |  |  |  |  |  |  |  |  |  | Contract |  | Transwestern System Rate Calc.
 | Gas Daily | Gas Daily |  |  |  |  |  |  |  |  | Demand | Contract System Rates * |  | Revenues
Date | TX intras, [NAME] | [NAME] | FUEL | Transport | Sharing | TW Rate |  | [NAME] | Revenue |  | [NAME] | Demand | Commodity | Demand | Commodity | Total
2001-05-01 00:00:00 | 4.645 | 4.56 |  | 0.1 | 0.5 |  | 0.2122 | 17928 |  |  | 30000 | 0.105 | 0.0104
2001-05-02 00:00:00 | 4.485 | 4.425 |  | 0.1 | 0.5 |  | 0.2122 | 20881 |  |  | 30000 | 0.105 | 0.0104
2001-05-03 00:00:00 | 4.47 | 4.24 |  | 0.1 | 0.5 |  | 0.2122 | 30000 |  |  | 30000 | 0.105 | 0.0104
2001-05-04 00:00:00 | 4.4 | 4.125 |  | 0.1 | 0.5 |  | 0.2122 | 24019 |  |  | 30000 | 0.105 | 0.0104
2001-05-05 00:00:00 | 4.395 | 3.96 |  | 0.1 | 0.5 |  | 0.2122 | 3440 |  |  | 30000 | 0.105 | 0.0104
2001-05-06 00:00:00 | 4.395 | 3.96 |  | 0.1 | 0.5 |  | 0.2122 | 10031 |  |  | 30000 | 0.105 | 0.0104
2001-05-07 00:00:00 | 4.395 | 3.96 |  | 0.1 | 0.5 |  | 0.2122 | 17367 |  |  | 30000 | 0.105 | 0.0104
2001-05-08 00:00:00 | 4.245 | 3.89 |  | 0.1 | 0.5 |  | 0.2122 | 0 |  |  | 30000 | 0.105 | 0.0104
2001-05-09 00:00:00 | 4.13 | 3.715 |  | 0.1 | 0.5 |  | 0.2122 | 30000 |  |  | 30000 | 0.105 | 0.0104
2001-05-10 00:00:00 | 4.055 | 3.63 |  | 0.1 | 0.5 |  | 0.2122 | 23884 |  |  | 30000 | 0.105 | 0.0104
2001-05-11 00:00:00 | 4.07 | 3.52 |  | 0.1 | 0.5 |  | 0.2122 | 24490 |  |  | 30000 | 0.105 | 0.0104
2001-05-12 00:00:00 | 4.165 | 3.315 |  | 0.1 | 0.5 |  |  | 8614 |  |  | 30000 | 0.105 | 0.0104
2001-05-13 00:00:00 | 4.165 | 3.315 |  | 0.1 | 0.5 |  |  | 13139 |  |  | 30000 | 0.105 | 0.0104
2001-05-14 00:00:00 | 4.165 | 3.315 |  | 0.1 | 0.5 |  |  | 9968 |  |  | 30000 | 0.105 | 0.0104
2001-05-15 00:00:00 | 4.225 | 3.295 |  | 0.1 | 0.5 |  |  | 29289 |  |  | 30000 | 0.105 | 0.0104
2001-05-16 00:00:00 | 4.37 | 3.29 |  | 0.1 | 0.5 |  |  | 19098 |  |  | 30000 | 0.105 | 0.0104
2001-05-17 00:00:00 | 4.37 | 3.26 |  | 0.1 | 0.5 |  |  | 30000 |  |  | 30000 | 0.105 | 0.0104
2001-05-18 00:00:00 | 4.065 | 2.99 |  | 0.1 | 0.5 |  |  | 347 |  |  | 30000 | 0.105 | 0.0104
2001-05-19 00:00:00 | 3.985 | 2.705 |  | 0.1 | 0.5 |  |  | 14415 |  |  | 30000 | 0.105 | 0.0104
2001-05-20 00:00:00 | 3.985 | 2.705 |  | 0.1 | 0.5 |  |  | 10000 |  |  | 30000 | 0.105 | 0.0104
2001-05-21 00:00:00 | 3.985 | 2.705 |  | 0.1 | 0.5 |  |  | 17412 |  |  | 30000 | 0.105 | 0.0104
2001-05-22 00:00:00 | 4.035 | 3.195 |  | 0.1 | 0.5 |  |  | 28846 |  |  | 30000 | 0.105 | 0.0104
2001-05-23 00:00:00 | 3.92 | 3.445 |  | 0.1 | 0.5 |  | 0.2122 | 30000 |  |  | 30000 | 0.105 | 0.0104
2001-05-24 00:00:00 | 3.995 | 3.485 |  | 0.1 | 0.5 |  | 0.2122 | 30000 |  |  | 30000 | 0.105 | 0.0104
2001-05-25 00:00:00 | 4.02 | 3.5 |  | 0.1 | 0.5 |  | 0.2122 | 19966 |  |  | 30000 | 0.105 | 0.0104
2001-05-26 00:00:00 | 3.64 | 2.86 |  | 0.1 | 0.5 |  |  | 30000 |  |  | 30000 | 0.105 | 0.0104
2001-05-27 00:00:00 | 3.64 | 2.86 |  | 0.1 | 0.5 |  |  | 28041 |  |  | 30000 | 0.105 | 0.0104
2001-05-28 00:00:00 | 3.64 | 2.86 |  | 0.1 | 0.5 |  |  | 25244 |  |  | 30000 | 0.105 | 0.0104
2001-05-29 00:00:00 | 3.64 | 2.86 |  | 0.1 | 0.5 |  |  | 25409 |  |  | 30000 | 0.105 | 0.0104
2001-05-30 00:00:00 | 3.73 | 2.995 |  | 0.1 | 0.5 |  |  | 24178 |  |  | 30000 | 0.105 | 0.0104
2001-05-31 00:00:00 | 3.525 | 2.795 |  | 0.1 | 0.5 |  |  | 14747 |  |  | 30000 | 0.105 | 0.0104
Total
*Can't go below rate of .2122
 |  |  |  |  |  |  |  |  |  |  |  | Difference between Total amt. Due to System Rates
 |  |  |  |  |  |  |  |  |  |  |  | Total Amt due TW, $
 |  |  |  |  |  |  |  |  |  |  |  | Reservation Charge, $
 |  |  |  |  |  |  |  |  |  |  |  | Commodity Costs, $
 |  |  |  |  |  |  |  |  |  |  |  | Difference to Model Calculation