Spreadsheet: phillip_m_love__31188__NICOR-rec
Sheet: June01

 | 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
6/2-6/4 | Balancing | NGPL | 255905 | 260523 | 3.74 |  |  |  |  |  |  |  |  |  |  | Sales = Receipt of Gas by HUB
2001-06-08 00:00:00 | Balancing | NGPL | 255905 | 50371 | 3.74
2001-06-21 00:00:00 | Balancing | NGPL | 255905 | 24400 | 3.8
2001-06-02 00:00:00 | Balancing |  |  |  |  |  | NBPL | 825874 | 15204 | 3.75
2001-06-03 00:00:00 | Balancing |  |  |  |  |  | NBPL | 825874 | 15204 | 3.75
2001-06-04 00:00:00 | Balancing |  |  |  |  |  | NBPL | 825874 | 15204 | 3.75
2001-06-05 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 25000 | 4.01
2001-06-06 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 2864 | 4.08
2001-06-07 00:00:00 | Balancing |  |  |  |  |  | NBPL | 257324 | 13920 | 3.85
2001-06-07 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 2846 | 3.85
2001-06-22 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 13174 | 3.68
2001-06-26 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 10000 | 3.543
2001-06-27 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 19325 | 3.418
2001-06-28 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 9270 | 3.375
2001-06-28 00:00:00 | Balancing |  |  |  |  |  | NBPL | 257324 | 10000 | 3.375
2001-06-29 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 20412 | 3.18
2001-06-30 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 20402 | 3.18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nicor billed $24,816.87
6/2-6/4 | AP&D | NGPL | 255905 | 75000 | 3.74
2001-06-12 00:00:00 | AP&D | NGPL | 255905 | 20384 | 3.9
2001-06-14 00:00:00 | AP&D | NGPL | 255905 | 1119 | 4.17
2001-06-15 00:00:00 | AP&D | NGPL | 255905 | 8235 | 3.91
2001-06-27 00:00:00 | AP&D | NGPL | 255905 | 25000 | 3.418
2001-06-01 00:00:00 | AP&D |  |  |  |  |  | NGPL | 257324 | 24622 | 3.79
2001-06-05 00:00:00 | AP&D |  |  |  |  |  | NGPL | 257324 | 25000 | 4.01
2001-06-06 00:00:00 | AP&D |  |  |  |  |  | NGPL | 257324 | 25000 | 4.08
2001-06-07 00:00:00 | AP&D |  |  |  |  |  | NGPL | 257324 | 25000 | 3.85
2001-06-08 00:00:00 | AP&D |  |  |  |  |  | NBPL | 257324 | 12325 | 3.74
6/9-6/11 | AP&D |  |  |  |  |  | NBPL | 257324 | 2592 | 3.65
6/9-6/11 | AP&D |  |  |  |  |  | NGPL | 257324 | 15129 | 3.65
2001-06-13 00:00:00 | AP&D |  |  |  |  |  | NGPL | 257324 | 24998 | 4.035
2001-06-16 00:00:00 | AP&D |  |  |  |  |  | NGPL | 257324 | 6807 | 3.08
2001-06-17 00:00:00 | AP&D |  |  |  |  |  | NGPL | 257324 | 6807 | 3.08
2001-06-18 00:00:00 | AP&D |  |  |  |  |  | NGPL | 257324 | 6807 | 3.08
2001-06-19 00:00:00 | AP&D |  |  |  |  |  | NGPL | 257324 | 18315 | 3.879
2001-06-20 00:00:00 | AP&D |  |  |  |  |  | Alliance | 257324 | 10982 | 3.955
2001-06-20 00:00:00 | AP&D |  |  |  |  |  | NGPL | 257324 | 1138 | 3.955
2001-06-21 00:00:00 | AP&D |  |  |  |  |  | NBPL | 257324 | 11734 | 3.8
2001-06-22 00:00:00 | AP&D |  |  |  |  |  | Alliance | 257324 | 7747 | 3.68
2001-06-22 00:00:00 | AP&D |  |  |  |  |  | NGPL | 257324 | 3873 | 3.68
6/23-6/25 | AP&D |  |  |  |  |  | NGPL | 257324 | 25170 | 3.675
2001-06-26 00:00:00 | AP&D |  |  |  |  |  | NGPL | 257324 | 25000 | 3.543
2001-06-28 00:00:00 | AP&D |  |  |  |  |  | NBPL | 257324 | 25000 | 3.375
2001-06-29 00:00:00 | AP&D |  |  |  |  |  | NBPL | 257324 | 25000 | 3.18
2001-06-30 00:00:00 | AP&D |  |  |  |  |  | NBPL | 257324 | 25000 | 3.18
2001-06-30 00:00:00 | Balancing | ???? | no deal |  |  |  | no deal |  |  |  |  |  |  |  | ***Nicor billed  30,695 @ $ .06 = $1,995.18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total bill $26,812.05