Spreadsheet: phillip_m_love__31188__NICOR-rec
Sheet: May01

 | 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
2001-05-01 00:00:00 | Balancing | Alliance | 255905 | 8576 | 5.03
2001-05-02 00:00:00 | Balancing | NGPL | 255905 | 224 | 4.67 |  |  |  |  |  |  |  |  |  |  | Sales = Receipt of Gas by HUB
2001-05-03 00:00:00 | Balancing | NGPL | 255905 | 5335 | 4.66
2001-05-03 00:00:00 | Balancing | NGPL | 255905 | 1 | 4.66
2001-05-10 00:00:00 | Balancing | NIG | 255905 | 426 | 4.23
2001-05-11 00:00:00 | Balancing | NIG | 255905 | 2974 | 4.22
2001-05-17 00:00:00 | Balancing | NIG | 255905 | 68438 | 4.55
2001-05-18 00:00:00 | Balancing | NIG | 255905 | 54347 | 4.24
5/19-5/21 | Balancing | NIG | 255905 | 48549 | 4.187
2001-05-22 00:00:00 | Balancing | NIG | 255905 | 5029 | 4.2
2001-05-05 00:00:00 | Balancing |  |  |  |  |  | NIG | 257324 | 556 | 4.615
2001-05-06 00:00:00 | Balancing |  |  |  |  |  | NIG | 257324 | 556 | 4.615
2001-05-07 00:00:00 | Balancing |  |  |  |  |  | NIG | 257324 | 556 | 4.615
2001-05-08 00:00:00 | Balancing |  |  |  |  |  | Alliance | 257324 | 1500 | 4.44
2001-05-09 00:00:00 | Balancing |  |  |  |  |  | NBPL | 257324 | 1636 | 4.35
2001-05-10 00:00:00 | Balancing |  |  |  |  |  | NBPL | 257324 | 1636 | 4.23
2001-05-12 00:00:00 | Balancing |  |  |  |  |  | NBPL | 257324 | 123 | 4.35
2001-05-12 00:00:00 | Balancing |  |  |  |  |  | NIG | 257324 | 1465 | 4.35
2001-05-13 00:00:00 | Balancing |  |  |  |  |  | NBPL | 257324 | 123 | 4.35
2001-05-13 00:00:00 | Balancing |  |  |  |  |  | NIG | 257324 | 1465 | 4.35
2001-05-14 00:00:00 | Balancing |  |  |  |  |  | NBPL | 257324 | 123 | 4.35
2001-05-14 00:00:00 | Balancing |  |  |  |  |  | NIG | 257324 | 1465 | 4.35
2001-05-16 00:00:00 | Balancing |  |  |  |  |  | NIG | 257324 |  | 4.54
2001-05-23 00:00:00 | Balancing |  |  |  |  |  | NIG | 257324 |  | 4.1
2001-05-31 00:00:00 | Balancing |  |  |  |  |  | NIG | 257324 | 3226 | 3.744
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | billed $13,536.51
2001-05-31 00:00:00 | loan |  |  |  |  |  | NIG | 257324 | 112586 | 3.744 |  | billed @ $.055
2001-05-30 00:00:00 | loan | NGPL | 255905 | 112586 | 3.893 |  |  |  |  |  |  |  |  |  | billed $7,318.09
2001-05-01 00:00:00 | AP&D |  |  |  |  |  | NIG | 761914 | 11614 | 4.84
2001-05-02 00:00:00 | AP&D | NGPL | 765129 | 25000 | 4.67
2001-05-04 00:00:00 | AP&D |  |  |  |  |  | NBPL | 257324 | 4926 | 4.57
2001-05-04 00:00:00 | AP&D |  |  |  |  |  | NIG | 257324 | 20025 | 4.57
2001-05-08 00:00:00 | AP&D |  |  |  |  |  | NBPL | 257324 | 25000 | 4.44
2001-05-16 00:00:00 | AP&D |  |  |  |  |  | NIG | 257324 | 25000 | 4.54
2001-05-17 00:00:00 | AP&D | NGPL | 255905 | 25000 | 4.55
2001-05-18 00:00:00 | AP&D | NGPL | 255905 | 25000 | 4.24
5/19-5/21 | AP&D | NGPL | 255905 | 75000 | 4.187 |  | NIG | 257324 | 25000 | 4.1
2001-05-24 00:00:00 | AP&D | NGPL | 255905 | 23539 | 4.21
2001-05-25 00:00:00 | AP&D | NGPL | 255905 | 18299 | 4.21
5/26-5/29 | AP&D | NGPL | 255905 | 89560 | 3.893
2001-05-30 00:00:00 | AP&D | NGPL | 255905 | 25000 | 3.893
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | nothing billed by Nicor
2001-05-01 00:00:00 | Wheeling |  |  |  |  |  | NBPL | 761848 | 31881 | 4.84 |  | billed @$.05
2001-05-01 00:00:00 | Wheeling |  |  |  |  |  | NIG | 761864 | 8809 | 4.84 |  | billed @$.015
2001-05-02 00:00:00 | Wheeling |  |  |  |  |  | NBPL | 761848 | 5140 | 4.67 |  | billed @$.05
2001-05-05 00:00:00 | Wheeling |  |  |  |  |  | NBPL | 761848 | 20923 | 4.615 |  | billed @$.03
2001-05-06 00:00:00 | Wheeling |  |  |  |  |  | NBPL | 761848 | 20923 | 4.615 |  | billed @$.03
2001-05-07 00:00:00 | Wheeling |  |  |  |  |  | NBPL | 761848 | 20923 | 4.615 |  | billed @$.03
2001-05-08 00:00:00 | Wheeling |  |  |  |  |  | NBPL | 761848 | 5323 | 4.44 |  | billed @$.03
2001-05-01 00:00:00 | Wheeling | NGPL | 761851 | 40690 | 4.89
2001-05-02 00:00:00 | Wheeling | NIG | 761851 | 5140 | 4.72
2001-05-05 00:00:00 | Wheeling | NGPL | 772984 | 20923 | 4.645
2001-05-06 00:00:00 | Wheeling | NGPL | 772984 | 20923 | 4.645
2001-05-07 00:00:00 | Wheeling | NGPL | 772984 | 20923 | 4.645
2001-05-08 00:00:00 | Wheeling | NGPL | 775442 | 5323 | 4.47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | billed $4,025.95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total $24,880.55