Spreadsheet: phillip_m_love__31188__NICOR-rec
Sheet: 3-00

 | Fee | Supply |  |  |  |  | Sales |  |  |  |  | [NAME] | NICOR |  |  | Balancing fee based on daily value that is moving balance furthest from zero
Date | Type | Point | Deal # | Volume | Rate | Total | Point | Deal # | Volume | Rate | Total |  | Volume | Rate | Explanation | Supply = Delivery of Gas by HUB
2000-03-26 00:00:00 | Wheeling | NGPL | 111529 | 65 | 2.81 |  | NGPL | 111532 | 65 | 2.82 |  |  |  |  |  | Sales = Receipt of Gas by HUB
2000-03-27 00:00:00 | Wheeling | NGPL | 111529 | 110 | 2.81 |  | NGPL |  | 110 | 2.82 |  |  |  |  |  | [NAME] are pathed together
 | Total |  |  |  |  |  |  |  |  |  |  |  | 175 | 0.01 | Unify ties with invoice
2000-03-01 00:00:00 | Balancing | NBPL | 111529 | 7043 | 2.78
2000-03-11 00:00:00 | Balancing | NBPL | 111529 | 183 | 0
2000-03-02 00:00:00 | Balancing | NBPL | 111529 | 85 | 2.76
2000-03-03 00:00:00 | Balancing | NGPL | 111529 | 183 | 2.85
2000-03-04 00:00:00 | Balancing | NGPL | 111529 | 1041 | 2.75
2000-03-05 00:00:00 | Balancing | NGPL | 111529 | 1096 | 0
2000-03-06 00:00:00 | Balancing | NGPL | 111529 | 1222 | 0
2000-03-09 00:00:00 | Balancing | NGPL | 111529 | 12130 | 2.75
2000-03-10 00:00:00 | Balancing | NGPL | 111529 | 255 | 2.82
2000-03-12 00:00:00 | Balancing | NGPL | 111529 | 56 | 2.84
2000-03-13 00:00:00 | Balancing | NGPL | 111529 | 112 | 2.84
2000-03-16 00:00:00 | Balancing | NGPL | 111529 | 20000 | 2.84
2000-03-17 00:00:00 | Balancing | NGPL | 111529 | 5000 | 2.915
2000-03-19 00:00:00 | Balancing | NGPL | 111529 | 45 | 2.88
2000-03-20 00:00:00 | Balancing | NGPL | 111529 | 112 | 2.88
2000-03-21 00:00:00 | Balancing | NGPL | 111529 | 259 | 2.78
2000-03-28 00:00:00 | Balancing | NGPL | 111529 | 4092 | 2.89 |  |  |  |  |  |  |  |  | 0.06 | Fee based on net daily balance
3/18-3/20 | Balancing |  |  |  |  |  | NGPL | 111532 | 19104 | 2.82
3/25-3-27 | Balancing |  |  |  |  |  | NGPL | 111532 | 4619 | 2.82
2000-03-29 00:00:00 | Balancing |  |  |  |  |  | NGPL | 111532 | 13705 | 2.97
2000-03-30 00:00:00 | Balancing |  |  |  |  |  | NGPL | 111532 | 14863 | 2.96
2000-03-31 00:00:00 | Balancing |  |  |  |  |  | NGPL | 111532 | 955 | 2.9 |  |  | 53246 | 0.06 | Fee based on net daily balance
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Invoiced 60,123*.06= $3,607.38
2000-03-14 00:00:00 | Parking | NGPL | 111529 | 28000 | 2.87
2000-03-23 00:00:00 | Parking | NGPL | 111529 | 27843 | 2.82
2000-03-08 00:00:00 | Parking |  |  |  |  |  | NGPL | 111532 | 65000 | 2.82 |  |  | 65000 | 0.08 | Invoiced $5200
3/1-3/31 |  | Texok | 204639 | 310000 | 2.53 |  |  | 204863 | 310000 | 2.4975 |  |  | 310000 | 0.185 | $10,075 was not invoiced
2000-03-16 00:00:00 |  | [NAME] | 218529 | 50000 | 2.79 |  |  | 218495 | 50000 | 2.83
2001-03-01 00:00:00 | ???? | NGPL | 207883 | 10063 | 2.77
2000-03-01 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 12849 | 2.55
2000-03-02 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 2849 | 2.65
2000-03-03 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 10000 | 2.73
2000-03-08 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 12849 | 2.69
2000-03-09 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 12849 | 2.68
2000-03-10 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 12849 | 2.59
3/11-3/13 | ???? |  |  |  |  |  | Amarillo | 20737 | 38547 | 2.67
2000-03-14 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 5000 | 2.71
2000-03-15 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 12849 | 2.75
2000-03-16 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 12849 | 2.71
2000-03-17 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 12849 | 2.79
2000-03-21 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 2850 | 2.65
2000-03-21 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 1000 | 2.66
2000-03-22 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 12849 | 2.66
2000-03-23 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 2850 | 2.69
2000-03-23 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 10000 | 2.7
2000-03-28 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 2800 | 2.74
2000-03-31 00:00:00 | ???? |  |  |  |  |  | Amarillo | 20737 | 12849 | 2.72
3/09-3/31 | ???? |  |  |  |  |  | NGPL | 213190 | 230000 | 2.81
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total NICOR = $[NAME]