Spreadsheet: phillip_m_love__31188__NICOR-rec
Sheet: 7-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
7/1-7/5 | Wheeling | NGPL | 320145 | 521430 | 4.355 |  |  | 320143 | 521430 | 4.35 |  |  |  | 0.005 |  | Sales = Receipt of Gas by HUB
2000-07-06 00:00:00 | Wheeling | NGPL | 320145 | 49156 | 4.205 |  |  | 320143 | 49156 | 4.2 |  |  |  | 0.005 |  | [NAME] are pathed together
2000-07-07 00:00:00 | Wheeling | NGPL | 320145 | 69881 | 4.045 |  |  | 320143 | 69881 | 4.04 |  |  |  | 0.005
7/8-7/10 | Wheeling | NGPL | 320145 | 262035 | 4.045 |  |  | 320143 | 262035 | 4.04 |  |  |  | 0.005
2000-07-11 00:00:00 | Wheeling | NGPL | 320145 | 53869 | 4.195 |  |  | 320143 | 53869 | 4.19 |  |  |  | 0.005
2000-07-12 00:00:00 | Wheeling | NGPL | 320145 | 93979 | 4.205 |  |  | 320143 | 93979 | 4.2 |  |  |  | 0.005
2000-07-13 00:00:00 | Wheeling | NGPL | 320145 | 38867 | 4.345 |  |  | 320143 | 38867 | 4.34 |  |  |  | 0.005
2000-07-14 00:00:00 | Wheeling | NGPL | 320145 | 118858 | 4.105 |  |  | 320143 | 118858 | 4.1 |  |  |  | 0.005
7/15-7/17 | Wheeling | NGPL | 320145 | 244914 | 4.215 |  |  | 320143 | 244914 | 4.21 |  |  |  | 0.005
2000-07-18 00:00:00 | Wheeling | NGPL | 320145 | 93845 | 4.105 |  |  | 320143 | 93845 | 4.1 |  |  |  | 0.005
2000-07-19 00:00:00 | Wheeling | NGPL | 320145 | 90617 | 4.025 |  |  | 320143 | 90617 | 4.02 |  |  |  | 0.005
2000-07-20 00:00:00 | Wheeling | NGPL | 320145 | 100935 | 4.105 |  |  | 320143 | 100935 | 4.1 |  |  |  | 0.005
2000-07-21 00:00:00 | Wheeling | NGPL | 320145 | 86932 | 3.915 |  |  | 320143 | 86932 | 3.91 |  |  |  | 0.005
7/22-7/24 | Wheeling | NGPL | 320145 | 363789 | 3.935 |  |  | 320143 | 363789 | 3.93 |  |  |  | 0.005
2000-07-25 00:00:00 | Wheeling | NGPL | 320145 | 101249 | 3.765 |  |  | 320143 | 101249 | 3.76 |  |  |  | 0.005
2000-07-26 00:00:00 | Wheeling | NGPL | 320145 | 115780 | 3.675 |  |  | 320143 | 115780 | 3.67 |  |  |  | 0.005
2000-07-27 00:00:00 | Wheeling | NGPL | 320145 | 103903 | 3.665 |  |  | 320143 | 103903 | 3.66 |  |  |  | 0.005
2000-07-28 00:00:00 | Wheeling | NGPL | 320145 | 119903 | 3.825 |  |  | 320143 | 119903 | 3.82 |  |  |  | 0.005
7/29-7/31 | Wheeling | NGPL | 320145 | 287967 | 3.965 |  |  | 320143 | 287967 | 3.96 |  |  |  | 0.005
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Inv'd $14,589.55
2000-07-07 00:00:00 | Balancing | NBPL | 255905 | 10000 | 4.05 |  |  |  |  |  |  |  | 9692
2000-07-11 00:00:00 | Balancing | NBPL | 255905 | 9363 | 4.19 |  |  |  |  |  |  |  | 9363
2000-07-12 00:00:00 | Balancing | NBPL | 255905 | 1812 | 4.2 |  |  |  |  |  |  |  | 1812
7/1-7/5 | Balancing | NGPL | 255905 | 12525 | 4.34 |  |  |  |  |  |  |  | 12525
2000-07-06 00:00:00 | Balancing | NGPL | 255905 | 3351 | 4.2 |  |  |  |  |  |  |  | 3351
7/8-7/10 | Balancing | NGPL | 255905 | 4710 | 4.04 |  |  |  |  |  |  |  | 4710
2000-07-11 00:00:00 | Balancing | NGPL | 255905 | 21317 | 4.19 |  |  |  |  |  |  |  | 21317
2000-07-12 00:00:00 | Balancing | NGPL | 255905 | 6355 | 4.2 |  |  |  |  |  |  |  | 6355
7/14-7/17 | Balancing | NGPL | 255905 | 6585 | 0 |  |  |  |  |  |  |  | 6585
2000-07-19 00:00:00 | Balancing | NGPL | 255905 | 856 | 4 |  |  |  |  |  |  |  | 856
2000-07-21 00:00:00 | Balancing | NGPL | 255905 | 152 | 3.91 |  |  |  |  |  |  |  | 152
7/22-7/24 | Balancing | NGPL | 255905 | 3153 | 3.93 |  |  |  |  |  |  |  | 3153
2000-07-25 00:00:00 | Balancing | NGPL | 255905 | 770 | 3.74 |  |  |  |  |  |  |  | 770
2000-07-29 00:00:00 | Balancing | NGPL | 255905 | 2 | 3.82 |  |  |  |  |  |  |  | 2
2000-07-30 00:00:00 | Balancing | NGPL | 255905 | 227 | 3.82 |  |  |  |  |  |  |  | 227
 |  |  |  |  |  |  | NGPL | 320143 | 50000 | 4.35 |  |  | 50000
7/1-7/5 | Balancing |  |  |  |  |  | NGPL | 257324 | 2400 | 4.34 |  |  | 2400
7/1-7/5 | Balancing |  |  |  |  |  | NGPL | 257324 | 20200 | 4.2 |  |  | 20200
2000-07-06 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 308 | 4.05 |  |  | 0
2000-07-07 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 493 | 4.35 |  |  | 493
2000-07-13 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 2238 | 4.19 |  |  | 2238
7/15-7/17 | Balancing |  |  |  |  |  | NGPL | 257324 | 643 | 4.12 |  |  | 643
2000-07-20 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 2157 | 3.93 |  |  | 2157
2000-07-21 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 4454 | 3.68 |  |  | 4454
2000-07-26 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 1588 | 3.67 |  |  | 1588
2000-07-27 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 1862 | 3.82 |  |  | 1862
2000-07-28 00:00:00 | Balancing |  |  |  |  |  |  |  |  |  |  |  |  |  | Inv'd $7,983.18
 | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inv'd $11,625.00
7/01-7/5 | Demand | NGPL | 320145 | 0 | 11625 | 11625
 | Total
 |  |  |  |  |  |  | NBPL | 316844 | 186000 | 4.42
7/1-7/31 | ????