Spreadsheet: phillip_m_love__31188__NICOR-rec
Sheet: July01

 |  |  |  |  |  |  |  |  |  |  |  | Balancing fee based on daily value that is moving balance furthest from zero
 | Fee | Supply |  |  |  |  | Sales |  |  |  |  | [NAME] | NICOR |  |  | Supply = Delivery of Gas by HUB
Date | Type | Point | Deal # | Volume | Rate | Total | Point | Deal # | Volume | Rate | Total |  | Volume | Rate | Explanation | Sales = Receipt of Gas by HUB
2001-07-15 00:00:00 | Balancing | NBPL | 255905 | 19210 | 3.15 |  |  |  |  |  |  |  | 19210 | 0.065 | 9238 was charged fee
2001-07-16 00:00:00 | Balancing | NBPL | 255905 | 14563 | 3.15 |  |  |  |  |  |  |  | 14563 | 0.065
2001-07-17 00:00:00 | Balancing | NBPL | 255905 | 3520 | 3.07 |  |  |  |  |  |  |  | 3520 | 0.065
2001-07-18 00:00:00 | Balancing | NBPL | 255905 | 7161 | 3.13 |  |  |  |  |  |  |  | 7161 | 0.065
2001-07-31 00:00:00 | Balancing | NBPL | 255905 | 124 | 3.288 |  |  |  |  |  |  |  | 124 | 0.065
2001-07-24 00:00:00 | Balancing | NGPL | 255905 | 10017 | 3.01 |  |  |  |  |  |  |  | 10017 | 0.065
2001-07-26 00:00:00 | Balancing | NGPL | 255905 | 77222 | 3.035 |  |  |  |  |  |  |  | 77222 | 0.065 | 54791 was charged fee
7/28-7/30 | Balancing | NGPL | 255905 | 25305 | 3.01 |  |  |  |  |  |  |  | 25305 | 0.065
2001-07-31 00:00:00 | Balancing | NGPL | 255905 | 9055 | 3.288 |  |  |  |  |  |  |  | 9055 | 0.065
2001-07-31 00:00:00 | Balancing | NGPL | 461167 | 11832 | 3.29 |  |  |  |  |  |  |  | 11832 | 0.065 | 9042 was charged fee
7/1-7/2 | Balancing | NGPL | 255905 | 2366 | 2.95 |  |  |  |  |  |  |  | 2366 | 0
7/04-7/05 | Balancing | NGPL | 255905 | 168 | 2.94 |  |  |  |  |  |  |  | 168 | 0.065
7/1-7/2 | Balancing | NBPL | 255905 | 174 | 2.95 |  |  |  |  |  |  |  | 174 | 0
2001-07-13 00:00:00 | Balancing | NGPL | 255905 | 25405 | 3.3 |  |  |  |  |  |  |  | 18015 | 0
2001-07-24 00:00:00 | Balancing | NBPL | 255905 | 2 | 3.01 |  |  |  |  |  |  |  | 2 | 0.065
2001-07-26 00:00:00 | Balancing |  |  |  |  |  | NBPL | 257324 | 22431 | 3.031 |  |  | 22431 | 0
2001-07-27 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 4188 | 3.298 |  |  | 4188 | 0
2001-07-27 00:00:00 | Balancing |  |  |  |  |  | NBPL | 257324 | 2276 | 3.298 |  |  | 2276 | 0
2001-07-31 00:00:00 | Balancing |  |  |  |  |  | NBPL | 461162 | 10832 | 3.29 |  |  | 10832 | 0
2001-07-31 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 13 | 3.28 |  |  | 13 | 0
2001-07-31 00:00:00 | Balancing |  |  |  |  |  | Alliance | 461162 | 1000 | 3.29 |  |  | 1000 | 0
 | Balancing
 | Balancing
 | Balancing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Balancing Total:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25937.8
2001-07-06 00:00:00 | Loan |  |  |  |  |  | NNG | 257324 | 213 | 3.07
2001-07-06 00:00:00 | Loan |  |  |  |  |  | NBPL | 257324 | 2163 | 3.07
7/7-7/9 | Loan |  |  |  |  |  | NBPL | 257324 | 10869 | 2.95
2001-07-12 00:00:00 | Loan |  |  |  |  |  | NNG | 257324 | 5000 | 3.22
2001-07-12 00:00:00 | Loan |  |  |  |  |  | NNG | 257324 | 7300 | 3.22
2001-07-14 00:00:00 | Loan |  |  |  |  |  | NNG | 257324 | 1272 | 3.16
2001-07-17 00:00:00 | Loan |  |  |  |  |  | NNG | 257324 | 5000 | 3.077
2001-07-19 00:00:00 | Loan |  |  |  |  |  | NNG | 257324 | 2353 | 3.158
2001-07-20 00:00:00 | Loan |  |  |  |  |  | NNG | 257324 | 2629 | 3.01
2001-07-20 00:00:00 | Loan |  |  |  |  |  | NNG | 257324 | 8603 | 3.01
2001-07-25 00:00:00 | Loan |  |  |  |  |  | NNG | 257324 | 128 | 2.978
2001-07-27 00:00:00 | Loan |  |  |  |  |  | NNG | 257324 | 12661 | 3.298
2001-07-10 00:00:00 | Loan | NGPL | 255905 | 73416 | 3.04 |  |  |  |  |  |  |  | 73416 | 0.065
2001-07-03 00:00:00 | Loan | NGPL | 255905 | 58191 | 2.87 |  |  |  |  |  |  |  | 58191 | 0.1
2001-07-25 00:00:00 | Loan | NGPL | 255905 | 30940 | 2.978 |  |  |  |  |  |  |  | 30940 | 0.065
2001-07-11 00:00:00 | Loan | NGPL | 255905 | 53296 | 3.18 |  |  |  |  |  |  |  | 53296 | 0.065
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loan Total:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16066.48
2001-07-10 00:00:00 | Wheeling
7/4-7/5 | Wheeling |  |  |  |  |  | NBPL | 898491 | 86832 | 2.94 |  |  | 86832 | 0.02
2001-07-07 00:00:00 | Wheeling | NGPL | 461167 | 1615 | 2.95 |  | NBPL | 461162 | 1615 | 2.94 |  |  | 1615 | 0.01
2001-07-08 00:00:00 | Wheeling | NGPL | 461167 | 1615 | 2.95 |  | NBPL | 461162 | 1615 | 2.94 |  |  | 1615 | 0.01
2001-07-09 00:00:00 | Wheeling | NGPL | 461167 | 1615 | 2.95 |  | NBPL | 461162 | 1615 | 2.94 |  |  | 1615 | 0.01
2001-07-10 00:00:00 | Wheeling | NGPL | 461167 | 56094 | 3.065 |  | NBPL | 461162 | 56094 | 3.055 |  |  | 56094 | 0.02
2001-07-11 00:00:00 | Wheeling | NGPL | 461167 | 75988 | 3.19 |  | NBPL | 461162 | 75988 | 3.18 |  |  | 75988 | 0.01
2001-07-13 00:00:00 | Wheeling | NGPL | 461167 | 47665 | 3.31 |  | NNG | 257324 | 5000 | 3.313 |  |  | 5000 | 0.01
2001-07-13 00:00:00 | Wheeling |  |  |  |  |  |  |  |  |  |  |  | 29722 | 0.01
2001-07-14 00:00:00 | Wheeling | NGPL | 461167 | 19030 | 3.16 |  | NBPL | 461162 | 19030 | 3.15 |  |  | 19030 | 0.01
2001-07-15 00:00:00 | Wheeling | NGPL | 461167 | 19030 | 3.16 |  | NBPL | 461162 | 19030 | 3.15 |  |  | 19030 | 0.01
2001-07-16 00:00:00 | Wheeling | NGPL | 461167 | 19030 | 3.16 |  | NBPL | 461162 | 19030 | 3.15 |  |  | 19030 | 0.01
2001-07-18 00:00:00 | Wheeling | NGPL | 461167 | 51660 | 3.14 |  | NBPL | 461162 | 51660 | 3.13 |  |  | 51660 | 0.01
2001-07-19 00:00:00 | Wheeling | NGPL | 461167 | 12413 | 3.165 |  | NBPL | 461162 | 12413 | 3.155 |  |  | 12413 | 0.01
2001-07-24 00:00:00 | Wheeling | NGPl | 461167 | 40342 | 3.02 |  | NBPL | 461162 | 40342 | 3.01 |  |  | 40342 | 0.005 | Wheeling Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5427.41