Spreadsheet: chris_germany__1816__2000ces10
Sheet: CGAS

 | CityGate Load |  |  |  | A+B+C |  | Storage |  | Total |  |  | [NAME] | [NAME] | Transport |  |  |  |  |  |  |  |  |  | GD Purch from NP |  |  |  |  | GD Sales to NP
 | CES Retail | [NAME] | Dayton |  | Total |  | Net |  | Sales |  | Capacity | Gross | Net | Req'd |  |  |  | 1st of Month | [NAME] | Total Req |  | Undertakes |  | Gas Daily | Amount |  | [NAME] |  | Gas Daily | Amount
1 | 26517 | 0 | 0 |  |  |  | 3904 |  |  |  | 142945 | 4462 | 4363 |  |  |  |  | 51762 | 3904 |  |  |  |  | 5.32 |  |  |  |  | 5.32
 | 26139 |  |  |  |  |  |  |  |  |  |  | 4581 | 4480 |  |  |  |  |  |  |  |  |  |  | 5.32 |  |  |  |  | 5.32
 | 26139 |  |  |  |  |  |  |  |  |  |  | 4581 | 4480 |  |  |  |  |  |  |  |  |  |  | 5.395 |  |  |  |  | 5.395
 | 31010 |  |  |  |  |  |  |  |  |  |  | 6137 | 6002 |  |  |  |  |  |  |  |  |  |  | 5.415 |  |  |  |  | 5.415
 | 37063 |  |  |  |  |  |  |  |  |  |  | 9070 | 8871 |  |  |  |  |  |  |  |  |  |  | 5.44 |  |  |  |  | 5.44
 | 68651 |  |  |  |  |  |  |  |  |  |  | 18169 | 17772 |  |  |  |  |  |  |  |  |  |  | 5.485 |  |  |  |  | 5.485
 | 80147 |  |  |  |  |  |  |  |  |  |  | 26981 | 26392 |  |  |  |  |  |  |  |  |  |  | 5.285 |  |  |  |  | 5.285
 | 81455 |  |  |  |  |  |  |  |  |  |  | 27330 | 26735 |  |  |  |  |  |  |  |  |  |  | 5.285 |  |  |  |  | 5.285
 | 69723 |  |  |  |  |  |  |  |  |  |  | 16584 | 16221 |  |  |  |  |  |  |  |  |  |  | 5.285 |  |  |  |  | 5.285
 | 59895 |  |  |  |  |  |  |  |  |  |  | 15560 | 15220 |  |  |  |  |  |  |  |  |  |  | 5.28 |  |  |  |  | 5.28
 | 52457 |  |  |  |  |  |  |  |  |  |  | 17559 | 17175 |  |  |  |  |  |  |  |  |  |  | 5.3 |  |  |  |  | 5.3
 | 43374 |  |  |  |  |  |  |  |  |  |  | 11980 | 11718 |  |  |  |  |  |  |  |  |  |  | 5.355 |  |  |  |  | 5.355
 | 31609 |  |  |  |  |  |  |  |  |  |  | 7389 | 7227 |  |  |  |  |  |  |  |  |  |  | 5.775 |  |  |  |  | 5.775
 | 26139 |  |  |  |  |  |  |  |  |  |  | 4540 | 4440 |  |  |  |  |  |  |  |  |  |  | 5.635 |  |  |  |  | 5.635
 | 33089 |  |  |  |  |  |  |  |  |  |  | 8862 | 8670 |  |  |  |  |  |  |  |  |  |  | 5.635 |  |  |  |  | 5.635
 | 36772 |  |  |  |  |  |  |  |  |  |  | 6718 | 6570 |  |  |  |  |  |  |  |  |  |  | 5.635 |  |  |  |  | 5.635
 | 43013 |  |  |  |  |  |  |  |  |  |  | 12462 | 12189 |  |  |  |  |  |  |  |  |  |  | 5.56 |  |  |  |  | 5.56
 | 51174 |  |  |  |  |  |  |  |  |  |  | 18591 | 18184 |  |  |  |  |  |  |  |  |  |  | 5.5 |  |  |  |  | 5.5
 | 39020 |  |  |  |  |  |  |  |  |  |  | 7095 | 6940 |  |  |  |  |  |  |  |  |  |  | 5.63 |  |  |  |  | 5.63
 | 31206 |  |  |  |  |  |  |  |  |  |  | 5806 | 5679 |  |  |  |  |  |  |  |  |  |  | 5.245 |  |  |  |  | 5.245
 | 30982 |  |  |  |  |  |  |  |  |  |  | 1289 | 1261 |  |  |  |  |  |  |  |  |  |  | 5.065 |  |  |  |  | 5.065
 | 35476 |  |  |  |  |  |  |  |  |  |  | 4178 | 4087 |  |  |  |  |  |  |  |  |  |  | 5.065 |  |  |  |  | 5.065
 | 27496 |  |  |  |  |  |  |  |  |  |  | 1153 | 1127 |  |  |  |  |  |  |  |  |  |  | 5.065 |  |  |  |  | 5.065
 | 27088 |  |  |  |  |  |  |  |  |  |  | 2854 | 2791 |  |  |  |  |  |  |  |  |  |  | 5.04 |  |  |  |  | 5.04
 | 29146 |  |  |  |  |  |  |  |  |  |  | 7432 | 7269 |  |  |  |  |  |  |  |  |  |  | 5.05 |  |  |  |  | 5.05
 | 26229 |  |  |  |  |  |  |  |  |  |  | 4581 | 4480 |  |  |  |  |  |  |  |  |  |  | 4.825 |  |  |  |  | 4.825
 | 26354 |  |  |  |  |  |  |  |  |  |  | 1833 | 1792 |  |  |  |  |  |  |  |  |  |  | 4.8 |  |  |  |  | 4.8
 | 71649 |  |  |  |  |  |  |  |  |  |  | 31124 | 30444 |  |  |  |  |  |  |  |  |  |  | 4.695 |  |  |  |  | 4.695
 | 72347 |  |  |  |  |  |  |  |  |  |  | 26304 | 25730 |  |  |  |  |  |  |  |  |  |  | 4.695 |  |  |  |  | 4.695
 | 65704 |  |  |  |  |  |  |  |  |  |  | 24173 | 23643 |  |  |  |  |  |  |  |  |  |  | 4.695 |  |  |  |  | 4.695
 | 52265 |  |  |  |  |  |  |  |  |  |  | 21488 | 21019 |  |  |  |  |  |  |  |  |  |  | 4.855 |  |  |  |  | 4.855
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Volume |  | Rate | Comment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 244242 |  |  | Deal 456638  Gas Daily buyback from New Power
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 244242 |  |  | Deal 456630  FOM Index sale to New Power
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pricing reconciliation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Volume | Price | Amount |  | Comment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.7041 |  |  | FOM Volume
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.7041 |  |  | Undertakes - these volumes should be backed out of the Citygate deal.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] - should be included in the Citygate deal [Price = $5.0595 + $.1466]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Due to skill (or luck) this volume ties to the volume in column B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Double Transport
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 360866 | 0.1466 |  |  | Variable cost for gas delivered to storage to keep net withdrawals at 0.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -352971 |  |  |  | GRI and ACA refund for storage gas delivered to Citygate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total dollars
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total dollars divided by Citygate volume.