Spreadsheet: john_griffith__15567__Diff between new blend and old blend vols and correl
Sheet: New Value with Vol changes

LONGTERMPLREPORT
$F$3
$C$7 |  |  |  | Type | LongTermPLReport
$F$4 |  |  |  | Group | 1
 |  |  |  | CENTRAL REGION
 |  | Leg |  |  |  | [NAME] | Asset Value | Demand Costs | Today's P&L | Yesterday's P&L | P&L Change |  | Intrinsic Value | Extrinsic Value
 |  |  |  | Pipeline | Path | Delivery Pt
 |  | 1 |  | NBPL | Ventura to Chicago | IF-NNG/VENT Basis Mid | 16261938.0973 | 20673840.5428 | -4411902.445500001 | -3296202.66 | -1115699.785500001 |  | 13371460.9981 | 2890477.0993
 |  |  |  |  |  | NGI/CHI. GATE Basis Mid
 |  | 2 |  | NBPL | Monchy to Chicago | IF-MONCHY Basis Mid | 773352.7222 | 1806131.3859 | -1032778.6637 | -1172631.96 | 139853.2962999998 |  | 522823.7752 | 250528.947
 |  |  |  |  |  | NGI/CHI. GATE Basis Mid
 |  | 3 |  | NGPL | NGPL/TX OK to NGPL/LA | IF-NGPLTXOK Basis Mid | 151206.3996 | 131741.3828 | 19465.01680000001 | 10507.09 | 8957.926800000012 |  | 0 | 151206.3996
 |  |  |  |  |  | IF-NGPL/LA Basis Mid
 |  | 4 |  | TRKL | CES - W/LA to Consumers | IF-TRUNKL/LA Basis Mid | 143501.1806 | 111340.2547 | 32160.92589999999 | 16001.97 | 16158.95589999999 |  | 97618.7139 | 45882.4668
 |  |  |  |  |  | MICH/CONS Basis Mid
 |  | 7 |  | TRKL | CES - E/LA to Consumers | IF-TRUNKL/LA Basis Mid | 996936.0532 | 664255.9597 | 332680.0935 | 224370.44 | 108309.6535 |  | 862436.2199 | 134499.8333
 |  |  |  |  |  | MICH/CONS Basis Mid
 |  | 25 |  | NBPL | Monchy to Chicago | IF-MONCHY Basis Mid | 5068397.7747 | 7998585.8169 | -2930188.0422 | -2809381.15 | -120806.8922000001 |  | 5027595.7748 | 40801.9999
 |  |  |  |  |  | NGI/CHI. GATE Basis Mid
 |  | 26 |  | NBPL | Monchy to Chicago | IF-MONCHY Basis Mid | 328293.7455 | 368381.9128 | -40088.16729999997 | -40021.83 | -66.33729999997013 |  | 328292.1657 | 1.5798
 |  |  |  |  |  | NGI/CHI. GATE Basis Mid
 |  |  |  |  |  | REGION SUB-TOTAL | 23723625.9731 | 31754277.2556 | -8030651.282500001 | -7067358.1 | -963293.1825000015 |  | 20210227.6476 | 3513398.3257
 |  |  |  | DENVER REGION
 |  | Leg |  |  |  | [NAME] | Asset Value | Demand Costs | Today's P&L | Yesterday's P&L | P&L Change |  | Intrinsic Value | Extrinsic Value
 |  |  |  | Pipeline | Path | Delivery Pt
 |  | 48 |  | NBPL | Wy Wellhead to Wy MktZone | WY/Wellhead Basis Mid | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
 |  |  |  |  |  | WY/MktZone Basis Mid
 |  | 49 |  | NBPL | Wy Wellhead to Wy MktZone | WY/Wellhead Basis Mid | 7984672.5643 | 7626758.6509 | 357913.9134 | 225794.98 | 132118.9334 |  | 7626758.6509 | 357913.9134
 |  |  |  |  |  | WY/MktZone Basis Mid
 |  |  |  |  |  | REGION SUB-TOTAL | 7984672.5643 | 7626758.6509 | 357913.9134 | 225794.98 | 132118.9334 |  | 7626758.6509 | 357913.9134
 |  |  |  | EAST  REGION
 |  | Leg |  |  |  | [NAME] | Asset Value | Demand Costs | Today's P&L | Yesterday's P&L | P&L Change |  | Intrinsic Value | Extrinsic Value
 |  |  |  | Pipeline | Path | Delivery Pt
 |  | 17 |  | CGT | Rayne to Leach | IF-COLGUL/RAYNE Basis Mid | 2414803.6109 | 3878540.6423 | -1463737.0314 | -847723.6 | -616013.4313999998 |  | 1412405.9482 | 1002397.6627
 |  |  |  |  |  | IF-CGT/APPALAC Basis Mid
 |  | 19 |  | 0 | Onshore to Rayne | IF-COLGULF/LA Basis Mid | 2366912.4479 | 1614102.6859 | 752809.7620000001 | 712677.4 | 40132.36200000008 |  | 2007935.0537 | 358977.3941
 |  |  |  |  |  | IF-COLGUL/RAYNE Basis Mid
 |  | 20 |  | 0 | Onshore to Rayne | IF-COLGULF/LA Basis Mid | 1949388.0171 | 1326865.9116 | 622522.1055000001 | 598901.93 | 23620.17550000001 |  | 1717322.441 | 232065.5762
 |  |  |  |  |  | IF-COLGUL/RAYNE Basis Mid
 |  | 21 |  | CGLF | Rayne to Leach | IF-COLGUL/RAYNE Basis Mid | 1690550.3993 | 2256929.5838 | -566379.1845000002 | -215673.08 | -350706.1045000002 |  | 1053139.0412 | 637411.3581
 |  |  |  |  |  | IF-CGT/APPALAC Basis Mid
 |  | 24 |  | 0 | Rayne to Leach | IF-COLGUL/RAYNE Basis Mid | 1763263.0017 | 1442240.2504 | 321022.7512999999 | 566578.16 | -245555.4087000001 |  | 1120249.5985 | 643013.4032
 |  |  |  |  |  | IF-CGT/APPALAC Basis Mid
 |  | 28 |  | 0 | Rayne to Leach | IF-COLGUL/RAYNE Basis Mid | 684328.3222 | 89072.2038 | 595256.1184 | 607146.62 | -11890.50159999996 |  | 516561.3593 | 167766.9629
 |  |  |  |  |  | IF-CGT/APPALAC Basis Mid
 |  | 43 |  | 0 | Onshore to Rayne | IF-COLGULF/LA Basis Mid | 283765.1179 | 103760.6731 | 180004.4448 | 150226.21 | 29778.23480000001 |  | 111556.4362 | 172208.6817
 |  |  |  |  |  | IF-COLGUL/RAYNE Basis Mid
 |  | 44 |  | 0 | Rayne to Leach | IF-COLGULF/LA Basis Mid | 1440141.3503 | 216445.4552 | 1223695.8951 | 1247653.36 | -23957.46490000002 |  | 1133028.7714 | 307112.5789
 |  |  |  |  |  | IF-CGT/APPALAC Basis Mid
 |  | 45 |  | 0 | Rayne to Leach | IF-COLGULF/LA Basis Mid | 7064.5812 | 2063.9103 | 5000.670899999999 | 5269.72 | -269.0491000000011 |  | 6292.486 | 772.0951
 |  |  |  |  |  | IF-CGT/APPALAC Basis Mid
 |  | 50 |  | FGT | FGT/Zone 1 to FGT/MKT | IF-FGT/Z1 Basis Mid | 418861.5586 | 427106.5442 | -8244.985600000015 | -8240.91 | -4.075600000014674 |  | 414803.3551 | 4058.2035
 |  |  |  |  |  | IF-FGT/MKT Basis Mid
 |  | 51 |  | FGT | FGT/Zone 2 to FGT/MKT | IF-FGT/Z2 Basis Mid | 455509.2854 | 510852.9254 | -55343.64 | -55538.95 | 195.3099999999831 |  | 448584.6486 | 6924.6367
 |  |  |  |  |  | IF-FGT/MKT Basis Mid
 |  | 52 |  | FGT | FGT/Zone 3 to FGT/MKT | IF-FGT/Z3 Basis Mid | 237376.6564 | 248447.5976 | -11070.9412 | -11097.86 | 26.91879999999946 |  | 234817.6165 | 2559.0399
 |  |  |  |  |  | IF-FGT/MKT Basis Mid
 |  | 53 |  | FGT | FGT/Zone 1 to FGT/MKT | IF-FGT/Z1 Basis Mid | 224299.6374 | 162190.9293 | 62108.70810000002 | 61993.83 | 114.8781000000163 |  | 221673.7458 | 2625.8916
 |  |  |  |  |  | IF-FGT/MKT Basis Mid
 |  | 54 |  | FGT | FGT/Zone 2 to FGT/MKT | IF-FGT/Z2 Basis Mid | 244020.9429 | 194137.6275 | 49883.31539999999 | 49620.52 | 262.7953999999954 |  | 239536.9621 | 4483.9808
 |  |  |  |  |  | IF-FGT/MKT Basis Mid
 |  | 55 |  | FGT | FGT/Zone 3 to FGT/MKT | IF-FGT/Z3 Basis Mid | 128176.608 | 94201.8024 | 33974.80559999999 | 33891.63 | 83.17559999999503 |  | 126523.2983 | 1653.3097
 |  |  |  |  |  | IF-FGT/MKT Basis Mid
 |  |  |  |  |  | REGION SUB-TOTAL | 14308461.5372 | 12566958.7428 | 1741502.7944 | 2895684.98 | -1154182.1856 |  | 10764430.7619 | 3544030.775100001
 |  |  |  | WEST/ALLEN REGION
 |  | Leg |  |  |  | [NAME] | Asset Value | Demand Costs | Today's P&L | Yesterday's P&L | P&L Change |  | Intrinsic Value | Extrinsic Value
 |  |  |  | Pipeline | Path | Delivery Pt
 |  | 27 |  | 0 | Stanfield to Malin | NW STANF/1st-GD Basis Mid | 2187539.0984 | 172802.3174 | 2014736.781 | 2292130.97 | -277394.1890000002 |  | 2062385.0742 | 125154.0242
 |  |  |  |  |  | NGI-MALIN Basis Mid
 |  | 46 |  | EPNG | SJ/Permian to Socal | IF-ELPO/SJ Basis Mid | 12756449.412 | 1794842.8577 | 10961606.5543 | 11533483.48 | -571876.9256999996 |  | 12190656.7924 | 565792.6196
 |  |  |  |  |  | NGI-SOCAL Basis Mid
 |  | 47 |  | EPNG | SJ to Topock | IF-ELPO/SJ Basis Mid | 39066626.3241 | 5496706.2517 | 33569920.0724 | 35321293.16 | -1751373.087599993 |  | 37333886.4267 | 1732739.8975
 |  |  |  |  |  | NGI-SOCAL Basis Mid
 |  | 56 |  | PGE | PGE/Topock to PGE City Gate | NGI-PGE/TOPOCK Basis Mid | 4414965.583 | 3579918.4088 | 835047.1741999998 | 841272.63 | -6225.455800000229 |  | 4403126.3265 | 11839.2565
 |  |  |  |  |  | NGI-PGE/CG Basis Mid
 |  | 57 |  | PGE | PGE/Topock to Kern River Station | NGI-PGE/TOPOCK Basis Mid | 698057.1559 | 1185882.7699 | -487825.6139999999 | -489616.01 | 1790.396000000066 |  | 698057.0859 | 0.07
 |  |  |  |  |  | NGI-SOCAL(KRS) Basis Mid
 |  |  |  |  |  | REGION SUB-TOTAL | 59123637.5734 | 12230152.6055 | 46893484.9679 | 49498564.23 | -2605079.262099992 |  | 56688111.7057 | 2435525.8678
 |  |  |  | WEST/HOLST REGION
 |  | Leg |  |  |  | [NAME] | Asset Value | Demand Costs | Today's P&L | Yesterday's P&L | P&L Change |  | Intrinsic Value | Extrinsic Value
 |  |  |  | Pipeline | Path | Delivery Pt
 |  | 9 |  | PGT | [NAME] to Malin | CGPR-KINGSGATE Basis Mid | 29013195.0289 | 17691453.5133 | 11321741.5156 | 16121937.74 | -4800196.224400001 |  | 27212450.9297 | 1800744.0992
 |  |  |  |  |  | NGI-MALIN Basis Mid
 |  | 10 |  | EPNG | ELPO/SJ to Valero | IF-ELPO/SJ Basis Mid | 1924797.3307 | 1303067.2632 | 621730.0675000001 | 844430.97 | -222700.9024999999 |  | 1031530.2715 | 893267.0592
 |  |  |  |  |  | IF-WAHA-TX Basis Mid
 |  |  |  |  |  | REGION SUB-TOTAL | 30937992.3596 | 18994520.7765 | 11943471.5831 | 16966368.71 | -5022897.1269 |  | 28243981.2012 | 2694011.1584
 |  |  |  |  |  |  | 136078390.0076 | 83172668.0313 | 52905721.9763 | 62519054.8 | -9613332.823699994 |  | 123533509.9673 | 12544880.0404