Spreadsheet: phillip_m_love__31188__NICOR-rec
Sheet: 9-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
9/2-9/3 | Wheeling | NBPL | 255905 | 831 | 4.88 |  | NGPL | 257324 | 831 | 4.88 |  |  | 831 | 0.0025 | Rate needs to adjusted | Sales = Receipt of Gas by HUB
2000-09-01 00:00:00 | Wheeling | NGPL | 359365 | 83119 | 4.865 |  | NBPL | 359362 | 83119 | 4.86 |  |  | 83119 | 0.0025 |  | [NAME] are pathed together
9/2-9/5 | Wheeling | NGPL | 359365 | 628964 | 4.795 |  | NBPL | 359362 | 628964 | 4.79 |  |  | 628964 | 0.0025
2000-09-06 00:00:00 | Wheeling | NGPL | 359365 | 95313 | 4.915 |  | NBPL | 359362 | 95313 | 4.91 |  |  | 95313 | 0.0025
2000-09-07 00:00:00 | Wheeling | NGPL | 359365 | 59372 | 5.015 |  | NBPL | 359362 | 59372 | 5.01 |  |  | 59372 | 0.0025
2000-09-08 00:00:00 | Wheeling | NGPL | 359365 | 117600 | 4.955 |  | NBPL | 359362 | 117600 | 4.95 |  |  | 117600 | 0.0025
9/9-9/11 | Wheeling | NGPL | 359365 | 244176 | 4.895 |  | NBPL | 359362 | 244176 | 4.89 |  |  | 244176 | 0.0025
2000-09-12 00:00:00 | Wheeling | NGPL | 359365 | 114843 | 5.095 |  | NBPL | 359362 | 114843 | 5.09 |  |  | 114843 | 0.0025
2000-09-13 00:00:00 | Wheeling | NGPL | 359365 | 94087 | 5.125 |  | NBPL | 359362 | 94087 | 5.12 |  |  | 94087 | 0.0025
2000-09-14 00:00:00 | Wheeling | NGPL | 359365 | 80847 | 5.205 |  | NBPL | 359362 | 80847 | 5.2 |  |  | 80847 | 0.0025
2000-09-15 00:00:00 | Wheeling | NGPL | 359365 | 90945 | 5.215 |  | NBPL | 359362 | 90945 | 5.21 |  |  | 90945 | 0.0025
9/16-9/18 | Wheeling | NGPL | 359365 | 371481 | 5.415 |  | NBPL | 359362 | 371481 | 5.4 |  |  | 371481 | 0.0025
2000-09-19 00:00:00 | Wheeling | NGPL | 359365 | 61632 | 5.215 |  | NBPL | 359362 | 61632 | 5.21 |  |  | 61633 | 0.0025
2000-09-20 00:00:00 | Wheeling | NGPL | 359365 | 157846 | 5.385 |  | NBPL | 359362 | 157846 | 5.38 |  |  | 157846 | 0.0025
2000-09-21 00:00:00 | Wheeling | NGPL | 359365 | 121275 | 5.425 |  | NBPL | 359362 | 121275 | 5.42 |  |  | 121275 | 0.0025
2000-09-22 00:00:00 | Wheeling | NGPL | 359365 | 150074 | 5.335 |  | NBPL | 359362 | 150074 | 5.33 |  |  | 150074 | 0.0025
9/23-925 | Wheeling | NGPL | 359365 | 271905 | 5.325 |  | NBPL | 359362 | 271905 | 5.32 |  |  | 271905 | 0.0025
2000-09-26 00:00:00 | Wheeling | NGPL | 359365 | 39284 | 5.255 |  | NBPL | 359362 | 39284 | 5.25 |  |  | 39284 | 0.0025
2000-09-27 00:00:00 | Wheeling | NGPL | 359365 | 55424 | 5.455 |  | NBPL | 359362 | 55424 | 5.45 |  |  | 55424 | 0.0025
2000-09-28 00:00:00 | Wheeling | NGPL | 359365 | 13937 | 5.515 |  | NBPL | 359362 | 13937 | 5.51 |  |  | 13937 | 0.0025
2000-09-29 00:00:00 | Wheeling | NGPL | 359365 | 106018 | 5.375 |  | NBPL | 359362 | 106018 | 5.37 |  |  | 106018 | 0.0025
2000-09-30 00:00:00 | Wheeling | NGPL | 359365 | 142055 | 5.305 |  | NBPL | 359362 | 142055 | 5.3 |  |  | 142055 | 0.0025
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Inv'd $7,752.57
2000-09-06 00:00:00 | Balancing | NGPL | 359365 | 15327 | 4.915 |  |  |  |  |  |  |  | 15327 | 0.09
2000-09-07 00:00:00 | Balancing | NGPL | 359365 | 19493 | 5.015 |  |  |  |  |  |  |  | 19493 | 0.09
2000-09-08 00:00:00 | Balancing | NGPL | 359365 | 17500 | 4.955 |  |  |  |  |  |  |  | 17500 | 0.09
9/9-9/11 | Balancing | NGPL | 359365 | 52500 | 4.895 |  |  |  |  |  |  |  | 52500 | 0.09
2000-09-12 00:00:00 | Balancing | NGPL | 359365 | 15607 | 5.095 |  |  |  |  |  |  |  | 15607 | 0.09
2000-09-13 00:00:00 | Balancing | NGPL | 359365 | 16878 | 5.125 |  |  |  |  |  |  |  | 16878 | 0.09
2000-09-14 00:00:00 | Balancing | NGPL | 359365 | 17500 | 5.205 |  |  |  |  |  |  |  | 17500 | 0.09
2000-09-01 00:00:00 | Balancing | NBPL | 255905 | 124 | 4.88 |  |  |  |  |  |  |  | 124 | 0.09
9/23-9/25 | Balancing | NBPL | 255905 | 3 | 5.32 |  |  |  |  |  |  |  | 3 | 0.09
2000-09-05 00:00:00 | Balancing | NGPL | 255905 | 164 | 4.88 |  |  |  |  |  |  |  | 5000 | 0.09
2000-09-06 00:00:00 | Balancing | NGPL | 255905 | 5000 | 4.91 |  |  |  |  |  |  |  | 5000 | 0.09
2000-09-08 00:00:00 | Balancing | NGPL | 255905 | 2063 | 4.94 |  |  |  |  |  |  |  | 2063 | 0.09
9/9-9/11 | Balancing | NGPL | 255905 | 2611 | 4.89 |  |  |  |  |  |  |  | 2611 | 0.09
2000-09-14 00:00:00 | Balancing | NGPL | 255905 | 2131 | 5.2 |  |  |  |  |  |  |  | 2131 | 0.09
2000-09-15 00:00:00 | Balancing | NGPL | 255905 | 2076 | 5.21 |  |  |  |  |  |  |  | 2076 | 0.09
9/16-9/18 | Balancing | NGPL | 255905 | 1529 | 5.4 |  |  |  |  |  |  |  | 1529 | 0.09
2000-09-19 00:00:00 | Balancing | NGPL | 255905 | 5402 | 5.21 |  |  |  |  |  |  |  | 5401 | 0.09
2000-09-20 00:00:00 | Balancing | NGPL | 255905 | 1744 | 5.38 |  |  |  |  |  |  |  | 1744 | 0.09
2000-09-21 00:00:00 | Balancing | NGPL | 255905 | 3177 | 5.42 |  |  |  |  |  |  |  | 3177 | 0.09
9/22-9/25 | Balancing | NGPL | 255905 | 1141 | 5.32 |  |  |  |  |  |  |  | 1141 | 0.09
2000-09-26 00:00:00 | Balancing | NGPL |  |  |  |  |  |  |  |  |  |  | 348 | 0.09
2000-09-27 00:00:00 | Balancing | NGPL | 255905 | 3164 | 5.45 |  |  |  |  |  |  |  | 3164 | 0.09
2000-09-29 00:00:00 | Balancing | NGPL | 255905 | 222 | 5.37 |  |  |  |  |  |  |  | 222 | 0.09
2000-09-30 00:00:00 | Balancing | NGPL | 255905 | 9 | 5.3 |  |  |  |  |  |  |  | 9 | 0.09
9/1-9/5 | Balancing |  |  |  |  |  | NGPL | 257324 | 5338 | 4.88 |  |  | 5338
2000-09-27 00:00:00 | Balancing |  |  |  |  |  | NGPL | 257324 | 3826 | 5.435 |  |  | 3826
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Inv'd 212,969 @.09 = $19,167.21
2000-09-06 00:00:00 | Parking |  |  |  |  |  | NBPL | 359362 | 15327 | 4.91 |  |  | 15327 | 0
2000-09-07 00:00:00 | Parking |  |  |  |  |  | NBPL | 359362 | 19493 | 5.01 |  |  | 19493 | 0
2000-09-08 00:00:00 | Parking |  |  |  |  |  | NBPL | 359362 | 17500 | 4.95 |  |  | 17500 | 0
9/9-9/11 | Parking |  |  |  |  |  | NBPL | 359362 | 52500 | 4.89 |  |  | 52500 | 0
2000-09-12 00:00:00 | Parking |  |  |  |  |  | NBPL | 359362 | 15607 | 5.09 |  |  | 15607 | 0
2000-09-13 00:00:00 | Parking |  |  |  |  |  | NBPL | 359362 | 16878 | 5.12 |  |  | 16878 | 0
2000-09-14 00:00:00 | Parking |  |  |  |  |  | NBPL | 359362 | 17500 | 5.2 |  |  | 17500 | 0
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Inv'd 200,000@.06 = $12,000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for late payback on parking
2000-09-07 00:00:00 | ??? |  |  |  |  |  | NGPL | 257324 | 180 | 5.02
2000-09-12 00:00:00 | ??? |  |  |  |  |  | NGPL | 257324 | 1893 | 5.09
2000-09-13 00:00:00 | ??? |  |  |  |  |  | NGPL | 257324 | 622 | 5.12
2000-09-07 00:00:00 | ??? |  |  |  |  |  | NBPL | 391000 | 50000 | 5.035
9/23-9/25 | ??? |  |  |  |  |  | Zone L | 411030 | 30000 | 5.115
9/23-9/25 | ??? |  |  |  |  |  | Zone L | 411030 | 30000 | 5.09
2000-09-26 00:00:00 | ??? |  |  |  |  |  | Zone L | 411030 | 6500 | 5.0475
2000-09-26 00:00:00 | ??? |  |  |  |  |  | Zone L | 411030 | 5000 | 5.02
9/23-9/25 | ??? |  |  |  |  |  | Zone L | 411030 | 49500 | 5.11
9/23-9/25 | ??? |  |  |  |  |  | Midcon | 411459 | 30000 | 5.035
2000-09-26 00:00:00 | ??? |  |  |  |  |  | Midcon | 411459 | 5000 | 4.995
2000-09-26 00:00:00 | ??? |  |  |  |  |  | Midcon | 411459 | 5000 | 4.99 |  |  |  |  | Inv'd $22,500 for reservation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total $61,419.78