Spreadsheet: phillip_m_love__31188__NICOR-rec
Sheet: 10-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
10/1-10/2 | Wheeling | NGPL | 359365 | 197154 | 5.255 |  | NBPL | 424999 | 197154 | 5.25 |  |  | 197154 | 0.0025 | Prices need adjusting | Sales = Receipt of Gas by HUB
2000-10-03 00:00:00 | Wheeling | NGPL | 359365 | 90669 | 5.385 |  | NBPL | 424999 | 90669 | 5.38 |  |  | 90669 | 0.0025 |  | [NAME] are pathed together
2000-10-04 00:00:00 | Wheeling | NGPL | 359365 | 96829 | 5.405 |  | NBPL | 424999 | 96829 | 5.4 |  |  | 96829 | 0.0025
2000-10-05 00:00:00 | Wheeling | NGPL | 359365 | 57241 | 5.395 |  | NBPL | 424999 | 57241 | 5.39 |  |  | 57241 | 0.0025
2000-10-06 00:00:00 | Wheeling | NGPL | 359365 | 45969 | 5.405 |  | NBPL | 424999 | 45969 | 5.4 |  |  | 45969 | 0.0025
10/7-10/9 | Wheeling | NGPL | 359365 | 25632 | 5.245 |  | NBPL | 424999 | 25632 | 5.24 |  |  | 25632 | 0.0025
2000-10-10 00:00:00 | Wheeling | NGPL | 359365 | 40762 | 5.265 |  | NBPL | 424999 | 40762 | 5.26 |  |  | 40762 | 0.0025
2000-10-11 00:00:00 | Wheeling | NGPL | 359365 | 44726 | 5.245 |  | NBPL | 424999 | 44726 | 5.25 |  |  | 44726 | 0.0025
2000-10-12 00:00:00 | Wheeling | NGPL | 359365 | 88817 | 5.35 |  | NBPL | 424999 | 88817 | 5.35 |  |  | 88817 | 0.0025
2000-10-13 00:00:00 | Wheeling | NGPL | 359365 | 140851 | 5.725 |  | NBPL | 424999 | 140851 | 5.72 |  |  | 140851 | 0.0025
10/14-10/16 | Wheeling | NGPL | 359365 | 378303 | 5.58 |  | NBPL | 424999 | 378303 | 5.58 |  |  | 378303 | 0.0025
2000-10-17 00:00:00 | Wheeling | NGPL | 359365 | 88402 | 5.475 |  | NBPL | 424999 | 88402 | 5.47 |  |  | 88402 | 0.0025
2000-10-18 00:00:00 | Wheeling | NGPL | 359365 | 94186 | 5.415 |  | NBPL | 424999 | 94186 | 5.41 |  |  | 94186 | 0.0025
2000-10-19 00:00:00 | Wheeling | NGPL | 359365 | 137729 | 5.505 |  | NBPL | 424999 | 137729 | 5.5 |  |  | 137729 | 0.0025
2000-10-20 00:00:00 | Wheeling | NGPL | 359365 | 96708 | 5.165 |  | NBPL | 424999 | 96708 | 5.16 |  |  | 96708 | 0.0025
10/21-10/23 | Wheeling | NGPL | 359365 | 543450 | 4.975 |  | NBPL | 424999 | 543450 | 4.97 |  |  | 543450 | 0.0225
2000-10-24 00:00:00 | Wheeling | NGPL | 359365 | 147126 | 4.925 |  | NBPL | 424999 | 147126 | 4.92 |  |  | 147126 | 0.0025
2000-10-25 00:00:00 | Wheeling | NGPL | 359365 | 71296 | 4.975 |  | NBPL | 424999 | 71296 | 4.97 |  |  | 71296 | 0.0025
2000-10-26 00:00:00 | Wheeling | NGPL | 359365 | 163620 | 4.755 |  | NBPL | 424999 | 163620 | 4.75 |  |  | 163620 | 0.0025
2000-10-27 00:00:00 | Wheeling | NGPL | 359365 | 142598 | 4.715 |  | NBPL | 424999 | 142598 | 4.71 |  |  | 142598 | 0.0025
10/28-10/30 | Wheeling | NGPL | 359365 | 324663 | 4.585 |  | NBPL | 424999 | 324663 | 4.58 |  |  | 324663 | 0.0025
2000-10-31 00:00:00 | Wheeling | NGPL | 359365 | 101630 | 4.605 |  | NBPL | 424999 | 101630 | 4.6 |  |  | 101630 | 0.0025
10/21-10/23 | Wheeling | NGPL | 359365 | 60000 | 4.99 |  | Alliance | 446504 | 60000 | 4.97 |  |  | 60000 | 0.0025
10/1-10/2 | Wheeling |  |  |  |  |  | NGPL | 257324 | 32 | 5.15 |  |  | 32 | 0.0025 | Need to check for missing volumes
2000-10-03 00:00:00 | Wheeling |  |  |  |  |  | NGPL | 257324 | 381 | 5.38 |  |  | 381 | 0.0025
2000-10-04 00:00:00 | Wheeling |  |  |  |  |  | NGPL | 257324 | 654 | 5.4 |  |  | 654 | 0.0025 | Inv'd 3,012,359@.0025 = $7,530.90
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Inv'd 16,070 @.02 = $3,341.40
2000-10-03 00:00:00 | Balancing | NGPL | 255905 | 2 | 5.15
2000-10-05 00:00:00 | Balancing | NGPL | 255905 | 3 | 5.39
2000-10-11 00:00:00 | Balancing | NGPL | 255905 | 21569 | 5.25
2000-10-13 00:00:00 | Balancing | NGPL | 255905 | 9896 | 5.68
10/14-10/16 | Balancing | NGPL | 255905 | 13242 | 5.57
2000-10-17 00:00:00 | Balancing | NGPL | 255905 | 2959 | 5.47
2000-10-18 00:00:00 | Balancing | NGPL | 255905 | 710 | 5.41
2000-10-19 00:00:00 | Balancing | NGPL | 255905 | 719 | 5.48
10/21-10/22 | Balancing | NGPL | 255905 | 778 | 4.98
2000-10-23 00:00:00 | Balancing | NGPL | 255905 | 789 | 4.98
2000-10-24 00:00:00 | Balancing | NGPL | 255905 | 2163 | 4.93
2000-10-27 00:00:00 | Balancing | NGPL | 255905 | 3 | 4.715
10/1-10/2 | Balancing |  |  |  |  |  | NGPL | 257324 | 33464 | 5.15
2000-10-05 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 1000 | 5.39
2000-10-06 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 52 | 5.405
10/7-10/9 | Balancing |  |  |  |  |  | NGPL | 257324 | 630 | 5.24
2000-10-10 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 131 | 5.27
2000-10-18 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 1744 | 5.48
2000-10-20 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 1488 | 5.16
10/21-10/23 | Balancing |  |  |  |  |  | Alliance | 446504 | 60000 | 4.97 |  |  |  |  | Inv'd 259,180 @.09 = $23,326.20
10/21-10/24 | Balancing |  |  |  |  |  | Alliance | 446504 | -60000 | 4.97
 | Total
2000-10-31 00:00:00 | Parking | NBPL | 255905 | 3086 | 4.605
2000-10-31 00:00:00 | Parking | NGPL | 255905 | 76 | 4.605
2000-10-04 00:00:00 | ???? |  |  |  |  |  | LA Pool | 424792 | 10000 | 5.18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reservation Fee = $23,250.00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total $57,448.50