Spreadsheet: phillip_m_love__30528__NG_Discounting
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | <--- Before |  | After --->
Post ID | [NAME] | Book Cd | Book Type | [NAME] |  | Post ID | Financial | Physical | Total |  | Post ID | Financial | Physical | Total
1205501 | C | A | M | ONTARIO Phys. JUL |  | 1208530 |  | 614864.0759 |  |  | 1208531 |  | 616492.7082
1205510 | P | A | M | T-Port (Physical) -JUl |  | 1208532 |  | 566326.2804 |  |  | 1208533 |  | 567826.3326
1205502 | 4 | 3 | P | Intra-Ontario |  | 1208534 | 5293912.3786 | 2480904.2428 |  |  | 1208535 | 5293912.3786 | 2473298.977
1205511 | G | O | P | IntraOnt - CentralTrans(price) |  | 1208536 | 5830853.4978 | -7458214.9203 |  |  | 1208537 | 5830853.4978 | -7428265.4474
1205515 | 4 | 7 | P | FT-ONTARIO (PRICE,BASIS, INDEX) |  | 1208538 | 0 |  |  |  | 1208539 | 0
1205503 | 4 | 3 | D | Intra-Ontario |  | 1208540 | 19952292.7817 | 1716318.2586 |  |  | 1208541 | 19952292.7817 | 1710890.9412
1205512 | G | O | D | IntraOnt - CentralTrans(basis) |  | 1208542 | 13696371.7738 | 254209.5615 |  |  | 1208543 | 13696371.7738 | 253186.5716
1205516 | 4 | 7 | D | FT-ONTARIO (PRICE,BASIS, INDEX) |  | 1208544 | -27273.6122 |  |  |  | 1208545 | -27273.6122
1205504 | 4 | 3 | I | Intra-Ontario |  | 1208546 |  | 5.0242 |  |  | 1208547 |  | 5.0084
1205513 | G | O | I | IntraOnt - CentralTrans(index) |  | 1208548 |  | -73557.4086 |  |  | 1208549 |  | -73262.3757
1205517 | 4 | 7 | I | FT-ONTARIO (PRICE,BASIS, INDEX) |  | 1208550 |  |  |  |  | 1208551
1205507 | 4 | 3 | M | INTRA-ONTARIO - GAS DAILY w/o Liquidate Day |  | 1208552 | -859018.1781 |  |  |  | 1208553 | -859018.1781
1205508 | W | 9 | M | INTRA-ONT-CAD - GAS DAILY w/o Liquidate Day |  | 1208554 | 1716653.6822 |  |  |  | 1208555 | 1716653.6822
1205514 | G | O | M | INTRA-ONTARIO Transport hedges |  | 1208556 | 259063 |  |  |  | 1208557 | 259063
1205484 | G | G | P | FT-Cent |  | 1208558 | 5808113.1141 | 211413.5234 |  |  | 1208559 | 5808113.1141 | 210832.6539
1205485 | G | G | D | FT-Cent |  | 1208560 | 1245585.0867 | 2609079.3921 |  |  | 1208561 | 1245585.0867 | 2602809.3783
1205486 | G | G | I | FT-Cent |  | 1208562 |  | 529984.6076 |  |  | 1208563 |  | 528268.5804
1205487 | G | G | M | GAS DAILY / SWAPS AND OPTIONS:  FT-CENT |  | 1208564 | -770403.3493 |  |  |  | 1208565 | -770403.3493
1205489 | E | G | P | GD-Central |  | 1208566 | 8213928.1368 | 506167.2504 |  |  | 1208567 | 8213928.1368 | 504659.3497
1205490 | E | G | D | GD-Central |  | 1208568 | -52124063.1252 | 46807032.5253 |  |  | 1208569 | -52124063.1252 | 46628769.703
1205491 | I | G | I | GD-Central |  | 1208570 |  | 188119.3121 |  |  | 1208571 |  | 184322.2867
1205492 | E | G | M | GAS DAILY CENTRAL/ SWAPS AND OPTIONS -Gas Daily |  | 1208572 | -402979.1872 | 21783.4784 |  |  | 1208573 | -402979.1872 | 21783.4784
1205493 | E | G | M | GD-Central |  | 1208574 | -226838.0858 | 3381.5003 |  |  | 1208575 | -226838.0858 | 3381.5003
1205494 | E | G | M | GAS DAILY CENTRAL/ SWAPS AND OPTIONS -Gas Daily |  | 1208576 | -249814.2349 | 21783.4784 |  |  | 1208577 | -249814.2349 | 21783.4784
1205495 | 6 | [ | M | GD-Central (GDCAD) |  | 1208578 | 1246884.8607 |  |  |  | 1208579 | 1246884.8607
1205974 | 5 | 6 | P | Market CG |  | 1208580 | 1342131.2494 | 0 |  |  | 1208581 | 1342131.2494 | 0
1205975 | 5 | 6 | D | Market CG |  | 1208582 | 0 | -781.2022000000001 |  |  | 1208583 | 0 | -779.7157000000001
1205976 | 5 | 6 | I | Market CG |  | 1208584 |  | 14861.7035 |  |  | 1208585 |  | 14833.4253
1205977 | 5 | 6 | M | CENTRAL / GAS DAILY-Market CG -SEP |  | 1208586 | -206536.52 |  |  |  | 1208587 | -206536.52
1205979 | P | A | M | Market CG Transport - JULY |  | 1208588 |  | 96420.5932 |  |  | 1208589 |  | 96676.0014
1205981 | P | A | M | Accrued Hedged Omicron - Market CG |  | 1208590 |  |  |  |  | 1208591
1205982 | E | R | M | Central Desk Financial Omicron Options Value |  | 1208592 |  |  |  |  | 1208593
1205908 | 5 | 5 | P | Market Mich |  | 1208594 | 556204.0631 | 31034.7208 |  |  | 1208595 | 556204.0631 | 30833.1064
1205909 | 5 | 5 | D | Market Mich |  | 1208596 | -93803.8866 | -22484.7026 |  |  | 1208597 | -93803.8866 | -22358.9627
1205910 | 5 | 5 | I | Market Mich |  | 1208598 |  | 572.5158 |  |  | 1208599 |  | 571.4263000000001
1205911 | 5 | 5 | M | CENTRAL / GAS DAILY-Market Mich - SEP |  | 1208600 | 76122.372 |  |  |  | 1208601 | 76122.372
1205913 | P | A | M | Market Mich Transport - JULY |  | 1208602 |  | 13735.2377 |  |  | 1208603 |  | 13771.616
1205915 | P | A | M | Accrued Hedged Omicron - Market Mich |  | 1208604 |  |  |  |  | 1208605
1205601 | 5 | 1 | P | Gulf NGPL Price |  | 1208606 | 126478.1287 |  |  |  | 1208607 | 126478.1287
1205602 | 5 | 1 | D | Gulf NGPL Basis |  | 1208608 |  |  |  |  | 1208609
1205603 | 5 | 1 | I | Gulf NGPL Index |  | 1208610 |  |  |  |  | 1208611
1205604 | 7 | 0 | P | NGPL Strg Price |  | 1208612 | -2465124.736 | 3535717.2347 |  |  | 1208613 | -2465124.736 | 3523227.574
1205605 | 7 | 0 | D | [NAME] |  | 1208614 | -37755.3372 | -120399.3499 |  |  | 1208615 | -37755.3372 | -119987.1252
1205606 | 7 | 0 | I | [NAME] Index |  | 1208616 |  | 11341.5937 |  |  | 1208617 |  | 11299.6539
1205607 | 5 | 0 | P | Gulf Price |  | 1208618 | 1763710.5848 | 0 |  |  | 1208619 | 1763710.5848 | 0
1205608 | 5 | 0 | D | Gulf Basis |  | 1208620 | -127062.7653 | 8482.189 |  |  | 1208621 | -127062.7653 | 8466.049500000001
1205609 | 5 | 0 | I | Gulf Index |  | 1208622 |  | 4358.0584 |  |  | 1208623 |  | 4347.8069
1205610 | 5 | 1 | M | CENTRAL / GAS DAILY-Gulf NGPL |  | 1208624 |  |  |  |  | 1208625
1205611 | 7 | 0 | M | CENTRAL / GAS DAILY-NGPL Storage |  | 1208626 |  |  |  |  | 1208627
1205612 | 5 | 0 | M | CENTRAL / GAS DAILY-Gulf |  | 1208628 | 93988.3162 |  |  |  | 1208629 | 93988.3162
1205616 | P | A | M | Gulf 2 Transport - SEPTEMBER |  | 1208630 |  |  |  |  | 1208631
1205617 | P | A | M | Gulf Transport - SEPTEMBER |  | 1208632 |  | -422176.2055 |  |  | 1208633 |  | -423294.4413
1205676 | 5 | 4 | P | Management Price |  | 1208634 | 12455254.9362 |  |  |  | 1208635 | 12455254.9362
1205677 | 5 | 4 | D | Management Basis |  | 1208636 | 543163.7897 |  |  |  | 1208637 | 543163.7897
1205678 | 5 | 4 | I | Management Index |  | 1208638 |  |  |  |  | 1208639
1205679 | 5 | 4 | M | CENTRAL / GAS DAILY-Management |  | 1208640 | -17980.031 |  |  |  | 1208641 | -17980.031
1206331 | 5 | 8 | P | Midcon North |  | 1208642 | 0 | 0 |  |  | 1208643 | 0 | 0
1206332 | 5 | 8 | D | Midcon North |  | 1208644 | 56420.031 | -37820.031 |  |  | 1208645 | 56420.031 | -37748.0686
1206333 | 5 | 8 | I | Midcon North |  | 1208646 |  | 18212.4923 |  |  | 1208647 |  | 18177.8382
1206337 | 5 | 8 | M | CENTRAL / GAS DAILY-Midcon North |  | 1208648 | -45979.024 |  |  |  | 1208649 | -45979.024
1206341 | P | A | M | Midcon North Transport |  | 1208650 |  | -340193.9067 |  |  | 1208651 |  | -341094.9892
1206343 | E | R | M | 1185307Intramonth Book Central Desk Financial Omicron Options Value CENTRAL |  | 1208652 | 1407.1048 |  |  |  | 1208653 | 1407.1048
1206345 | P | A | M | Intra Month Book Central Desk Accrued Hedged [NAME] North |  | 1208654 |  |  |  |  | 1208655
1206348 | 6 | : | M | [NAME] (GDCAD) |  | 1208656 | 174128.5301 |  |  |  | 1208657 | 174128.5301
1206334 | 5 | 7 | P | Midcon South |  | 1208658 | 4230165.5799 | 2021672.1968 |  |  | 1208659 | 4230165.5799 | 2017247.5469
1206335 | 5 | 7 | D | Midcon South |  | 1208660 | 21499.9746 | 79945.2659 |  |  | 1208661 | 21499.9746 | 79803.9073
1206336 | 5 | 7 | I | Midcon South |  | 1208662 |  | 73045.5719 |  |  | 1208663 |  | 72831.064
1206338 | 5 | 7 | M | CENTRAL / GAS DAILY-Midcon South |  | 1208664 | 197424.5126 |  |  |  | 1208665 | 197424.5126
1206342 | P | A | M | Midcon South Transport |  | 1208666 |  | -232139.0824 |  |  | 1208667 |  | -232753.9716
1206344 | P | A | M | Intra Month Book Central Desk Accrued Hedged [NAME] South |  | 1208668 |  |  |  |  | 1208669
1206460 | G | G | P | FT - Central |  | 1208670 | -293078266.4901 | -459734931.5577 |  |  | 1208671 | -293078266.4901 | -457844566.6697
1206461 | G | G | D | FT - Central |  | 1208672 | 54212740.2402 | -47286306.2409 |  |  | 1208673 | 54212740.2402 | -47103262.5232
1206462 | I | G | I | FT - Central |  | 1208674 |  | 23221262.402 |  |  | 1208675 |  | 23136790.0828
1206463 | G | D | M | GAS DAILY / SWAPS AND OPTIONS:  FT-CENTRAL |  | 1208676 | 0 |  |  |  | 1208677 | 0
1206466 | G | 1 | P | FT-Ont-Central |  | 1208678 |  | 2398991.3824 |  |  | 1208679 |  | 2392249.5561
1206467 | G | 2 | P | FT-Ontario |  | 1208680 | 9524666.1921 | 241128557.9681 |  |  | 1208681 | 9524666.1921 | 240236165.1325
1206468 | G | 2 | D | FT-Ontario |  | 1208682 | 2072781.73 | -13256733.9177 |  |  | 1208683 | 2072781.73 | -13218323.45
1206469 | G | 2 | I | FT-Ontario |  | 1208684 |  | 31905179.7711 |  |  | 1208685 |  | 31792234.0936
1206470 | G | 2 | M | GAS DAILY / SWAPS AND OPTIONS - FT-ONT-Central |  | 1208686 | -946455.6803 | 33875.5389 |  |  | 1208687 | -946455.6803 | 33727.2107
1206472 | G | 3 | M | GAS DAILY / SWAPS AND OPTIONS - FT-ONT-Central |  | 1208688 | 1161256.5902 |  |  |  | 1208689 | 1161256.5902
1206453 | P | A | M | Aruba -Transport |  | 1208690 |  | 957733.5614 |  |  | 1208691 |  | 960270.3537
1206454 | G | # | P | FT - Peoples |  | 1208692 | -72193.4249 | -14057637.6806 |  |  | 1208693 | -72193.4249 | -14008962.7307
1206455 | G | # | D | FT - Peoples |  | 1208694 | 38096262.731 | 28866218.7624 |  |  | 1208695 | 38096262.731 | 28767197.0199
1206456 | G | # | I | FT - Peoples |  | 1208696 |  | -53473890.0327 |  |  | 1208697 |  | -53288750.7843
1206457 | P | A | P | Aruba-SPLY |  | 1208698 | -4573420.6235 | 8457324.2907 |  |  | 1208699 | -4573420.6235 | 8431612.5845
1206459 | G | # | M | FT - Peoples |  | 1208700 | 907402.2766 | 10881828.2042 |  |  | 1208701 | 907402.2766 | 10881828.2042
1206477 | 5 | 9 | P | New |  | 1208702 | -263445.3931 | -1545197.7918 |  |  | 1208703 | -263445.3931 | -1540045.1038
1206478 | 5 | 9 | D | New |  | 1208704 | -98477.3288 | 88990.4761 |  |  | 1208705 | -98477.3288 | 88705.7449
1206479 | 5 | 9 | I | New |  | 1208706 |  | 0 |  |  | 1208707 |  | 0
1206481 | 5 | 9 | M | New |  | 1208708 |  |  |  |  | 1208709