Spreadsheet: phillip_m_love__31188__NICOR-rec
Sheet: 1-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-01-05 00:00:00 | Wheeling | NBPL | 146570 | 687 | 2.26 |  |  | 146568 | 687 | 2.25 |  |  | 687 | 0.01 |  | Sales = Receipt of Gas by HUB
2000-01-14 00:00:00 | Wheeling | NBPL | 111529 | 7 | 2.3 |  | NGPL | 111532 | 15 | 2.3 |  |  | 15 | 0.01 | [NAME] need verifying | [NAME] are pathed together
1/15-1/18 | Wheeling | NBPL | 111529 | 20 | 0 |  | NGPL | 111532 | 20 | 2.35 |  |  | 20 | 0.01 | Rate needs to be added.
2000-01-01 00:00:00 | Wheeling | NGPL | 145511 | 43347 | 2.36 |  |  | 145505 | 43347 | 2.35 |  |  | 33347 | 0.01 | Need to adjust volumes
1/2-1/4 | Wheeling | NGPL | 145511 | 130041 | 2.36 |  |  | 145505 | 130041 | 2.35 |  |  | 100041 | 0.01 | Need to adjust volumes
1/6-1/7 | Wheeling | NGPL | 147167 | 19754 | 2.24 |  |  | 147166 | 19754 | 2.23 |  |  | 19754 | 0.01
1/12-1/13 | Wheeling | NGPL | 149255 | 7491 | 2.29 |  |  | 149253 | 7491 | 2.28 |  |  | 7491 | 0.01
1/15-1/18 | Wheeling |  |  |  |  |  | NGPL | 111532 | 339 | 2.35 |  |  | 339 | 0.01
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Invoiced $1,616.89
2000-01-05 00:00:00 | Balancing | NBPL | 111529 | 1576 | 2.25 |  |  |  |  |  |  |  | 1576
2000-01-01 00:00:00 | Balancing | NGPL | 111529 | 10000 | 2.35 |  |  |  |  |  |  |  | 8999
1/2-1/4 | Balancing | NGPL | 111529 | 30340 | 2.35 |  |  |  |  |  |  |  | 30340
2000-01-18 00:00:00 | Balancing | NGPL | 111529 | 1100 | 2.4 |  |  |  |  |  |  |  | 766
2000-01-11 00:00:00 | Balancing |  |  |  |  |  | NBPL | 111532 | 9877 | 2.25 |  |  | 9877
2000-01-12 00:00:00 | Balancing |  |  |  |  |  | NBPL | 111532 | 6903 | 2.29 |  |  | 6903
2000-01-13 00:00:00 | Balancing |  |  |  |  |  | NBPL | 111532 | 5360 | 2.28 |  |  | 5360
2000-01-06 00:00:00 | Balancing |  |  |  |  |  | NGPL | 111532 | 274 | 2.23 |  |  | 274
2000-01-07 00:00:00 | Balancing |  |  |  |  |  | NGPL | 111532 | 2270 | 2.25 |  |  | 2270
1/8-1/10 | Balancing |  |  |  |  |  | NGPL | 111532 | 14900 | 2.25 |  |  | 14900
2000-01-14 00:00:00 | Balancing |  |  |  |  |  | NGPL | 111532 | 6574 | 2.3 |  |  | 6574
1/15-1/18 | Balancing |  |  |  |  |  | NGPL | 111532 | 1213 | 2.35 |  |  | 1213
2000-01-19 00:00:00 | Balancing |  |  |  |  |  | NGPL | 111532 | 5598 | 2.4 |  |  | 5598
2000-01-20 00:00:00 | Balancing |  |  |  |  |  | NGPL | 111532 | 1378 | 2.52 |  |  | 1378
1/22-1/31 | Balancing |  |  |  |  |  | NGPL | 111532 | 1309 | 2.6 |  |  | 1309
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Invoiced 55,656@ $.085 = $4,730.76
1/1-1/31 | Park |  |  |  |  |  |  |  |  |  |  |  | 310000 | 0.01 | 10/99-7/00 park = $3,100
2000-01-21 00:00:00 | ???? | ANR | 152762 | 1943 | 2.03
2000-01-21 00:00:00 | ???? | PGLC | 152762 | 4000 | 2.03
2000-01-21 00:00:00 | ???? | NGPL | 152422 | 10000 | 2.51
1/22-1/31 | ???? | NGPL | 152422 | 50000 | 2.66
1/22-1/31 | ???? | NGPL | 152422 | 100000 | 2.51
2000-01-21 00:00:00 | ???? | NGPL | 152762 | 21938 | 2.03
 | Total
2000-01-21 00:00:00 | ???? |  |  |  |  |  | Amarillo | 152754 | 27881 | 2.5
2000-01-21 00:00:00 | ???? |  |  |  |  |  | Amarillo | 152782 | 919 | 2.515
1/08-1/10 | ???? |  |  |  |  |  | Midcon | 148074 | 30000 | 2.085
2000-01-13 00:00:00 | ???? |  |  |  |  |  | Midcon | 148074 | 5000 | 2.12
1/08-1/10 | ???? |  |  |  |  |  | [NAME] | 148065 | 30000 | 2.15
2000-01-11 00:00:00 | ???? |  |  |  |  |  | [NAME] | 148065 | 20000 | 2.155
2000-01-13 00:00:00 | ???? |  |  |  |  |  | [NAME] | 148065 | 15000 | 2.215
2000-01-25 00:00:00 | ???? |  |  |  |  |  | [NAME] | 148065 | 10000 | 2.19
2000-01-25 00:00:00 | ???? |  |  |  |  |  | NGPL | 154214 | 10000 | 2.645
2000-01-26 00:00:00 | ???? |  |  |  |  |  | Minooka | 148145 | 29631 | 2.22
2000-01-26 00:00:00 | ???? |  |  |  |  |  | Minooka | 154964 | 10000 | 2.82
2000-01-27 00:00:00 | ???? |  |  |  |  |  | Minooka | 154964 | 10000 | 2.81
2000-01-26 00:00:00 | ???? |  |  |  |  |  | Minooka | 154979 | 15000 | 2.8
2000-01-27 00:00:00 | ???? |  |  |  |  |  | Minooka | 154979 | 10000 | 2.8
 | Total
1/01-1/18 |  |  |  |  |  | -21264.3 |  |  |  |  |  |  |  |  | [NAME]
1/01-1/18 |  |  |  |  |  | 15689 |  |  |  |  |  |  |  |  | Reversal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nicor total invoice = $9,447.65