Spreadsheet: mike_grigsby__27705__Mike_NCD_Reconciliation_05_14
Sheet: Sheet1

West Phys- GDWest |  |  | Transport | Sitara | [NAME]'s | Gas Daily | Gas Daily | Consolidated |  | Financial | Physical | Total | Curve
Intramonth Position |  | Physical | Positions | Total | Transport | Index | FP | Fiz & Fin |  | Curve Shift | Curve Shift | CurveShift | Delta
EAST | IF-HEHUB | 0 | 0 | 0 | 0 | 0 | -107.54 | -107.54 |  | -121456.9411764707 | 0 | -121456.9411764707 | 0.12
 | IF-HPL/SHPCHAN | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | IF-TZ6NY | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.12
 | NGI/CHI. GATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.12
 | NNG Demarc | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.1199999999999992
 | IF-PAN/TX/OK | 0 | 0 | 0 | 0 | 0 | -247 | -247 |  | -278964.7058823532 | 0 | -278964.7058823532 | 0.12
NW | AECOUS | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.09100000000000019
 | SUMAS-US/IM | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.12
 | IF-CIG/WIC | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | IF-CIG/RKYMTN | 1.7e-07 | 0 | 1.7e-07 | 0 | 0 | -9.5 | -9.49999983 |  | 0 | 0 | 0 | 0
 | IF-CIG/CHEYENN | 0 | 0 | 0 | 0 | 0 | -28.5 | -28.5 |  | 0 | 0 | 0 | 0
 | IF-CIG/NW-GR | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.04999999999999982
 | IF-NWPL_ROCKY_M | -259.8232337100001 | 5.64807405 | -254.1751596600001 | 0 | 0 | 0 | -254.1751596600001 |  | 0 | 119611.8398400007 | 119611.8398400007 | -0.05000000000000027
 | IF-KERN/OPAL | 0 | 0 | 0 | 0 | 0 | -251.75 | -251.75 |  | 118470.5882352947 | 0 | 118470.5882352947 | -0.05000000000000027
 | IF-QUESTAR | 3.069237799999999 | -5.64807405 | -2.578836250000001 | 0 | 0 | 0 | -2.578836250000001 |  | 0 | 1213.570000000007 | 1213.570000000007 | -0.05000000000000027
 | NW-STANFIELD | 17.19787813 | -16.94929529 | 0.248582840000001 | 0 | 0 | 0 | 0.248582840000001 |  | 0 | -467.9206399999966 | -467.9206399999966 | -0.2
SW | IF-ELPO/PERMIAN | -188.91624323 | -33.15284189 | -222.06908512 | 0 | 0 | 864.5 | 642.4309148799999 |  | 813647.0588235265 | -209006.1977599993 | 604640.8610635272 | 0.09999999999999964
 | IF-TW/PERMIAN | 2.621112200000001 | 0 | 2.621112200000001 | 0 | 0 | 0 | 2.621112200000001 |  | 0 | 2466.929129411778 | 2466.929129411778 | 0.1000000000000005
 | IF-ELPO/SJ | -69.09420603 | -136.32996388 | -205.42416991 | 28.0415 | 0 | -209 | -386.38266991 |  | -98352.94117647024 | -83474.1976047056 | -181827.1387811758 | 0.04999999999999982
 | IF-EPSJ(BONDAD) | 65.72058337999998 | -50.9662584 | 14.75432497999998 | 0 | 0 | 0 | 14.75432497999998 |  | 0 | 6943.21175529408 | 6943.21175529408 | 0.04999999999999982
 | IM-TW/SJ | 16.63137948 | -16.78357334 | -0.152193859999997 | 0 | 0 | 0 | -0.152193859999997 |  | 0 | -71.62063999999828 | -71.62063999999828 | 0.04999999999999982
 | TW-THOREAU | -0.3382080299999999 | 0.57326261 | 0.2350545800000001 | 0 | 0 | 0 | 0.2350545800000001 |  | 0 | 110.6139199999997 | 110.6139199999997 | 0.04999999999999982
 | WAHA KCBT | 0 | 95.45076003 | 95.45076003 | -28.0415 | 0 | -370.5 | -303.09073997 |  | -435882.3529411764 | 79305.0118 | -356577.3411411765 | 0.125
CALI | NGI-MALIN | -219.53082838 | 10.37960432 | -209.15122406 | 0 | 0 | 57 | -152.15122406 |  | -107294.1176470589 | 393696.4217600004 | 286402.3041129415 | -0.2
 | NGI-PGE/CG | 84.21379708999999 | 135.28490146 | 219.49869855 | 0 | 0 | 47.5 | 266.99869855 |  | -111764.7058823529 | -516467.526 | -628232.2318823528 | -0.25
 | NGI-MOJAVE | 0 | 26.96701687 | 26.96701687 | 0 | 0 | 0 | 26.96701687 |  | 0 | 30456.86611200003 | 30456.86611200003 | 0.12
 | PGE/TOPOCK | 10.1462409 | -132.35771107 | -122.21147017 | 0 | 0 | 0 | -122.21147017 |  | 0 | 770651.1530719998 | 770651.1530719998 | -0.67
 | NGI-SOCAL | 108.5225005 | 117.88409858 | 226.40659908 | 0 | 0 | 285 | 511.40659908 |  | -1609411.764705881 | -1278531.383039999 | -2887943.147745881 | -0.6
 | NGI-SOCAL(KRS) | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.6
 |  | -429.57998973 | -1.4210854715202e-14 | -429.5799897300002 | 0 | 0 | 30.21 | -399.3699897300002 |  | -1831009.882352943 | -683563.2282959974 | -2514573.11064894
After 11:00? (Y/N) |  | Physical | Transport | Subtotal | T Model | GD Index | [NAME] | Net |  | TRADING ESTIMATE |  |  |  |  | Actuals | Delta | Explanation
N | [NAME] 6 | 0 | 0 | 0 | 0 | 0 | -107.54 | -107.54 |  | Financial Curveshift_BOM |  | -1831009.882352943 | -1447872.088235295 |  | -1837045 | 389172.9117647046
 | Chicago/PEPL/Demarc | 0 | 0 | 0 | 0 | 0 | -247 | -247 |  | Financial Curveshift_Liquidated Day |  | 383137.7941176473
 | Waha | 0 | 95.45076003 | 95.45076003 | -28.0415 | 0 | -370.5 | -303.09073997
 | Perm, San Juan | -173.3755822300001 | -236.6593749 | -368.7610641250001 | 28.0415 | 0 | 655.5 | 314.7804358749999 |  | TDS-New Deals |  | -53846.65 |  |  | -370758 | 316911.35
 | Aeco, Sumas, [NAME] | 17.19787813 | -16.94929529 | 0.248582840000001 | 0 | 0 | 0 | 0.248582840000001 |  | TDS-CurveShift |  | -24270674 |  |  | -24297131 | 26457
 | Rockies | -256.7539957400001 | 0 | -256.7539957400001 | 0 | 0 | -289.75 | -546.5039957400002 |  | Financial Index Curve Changes |  | 0
 | CA/ Scal, CG, Malin | -16.64828988999999 | 158.15791016 | -75.37253348000004 | 0 | 0 | 389.5 | 314.12746652 |  | First of Month Indices Estimate
 |  |  |  |  |  |  |  |  |  | [NAME]. Financial
 | Flow adjusted position | -429.5799897300001 | 0 | -605.1882504750002 | 0 | 0 | 30.21 | -574.9782504750002 |  | TOTAL Financial |  |  | -25772392.73823529 |  | -26504934 | 732541.2617647052 | -26434544 | Actual Financial P&L
 |  |  |  |  |  |  |  |  |  | Physical_BOM |  | -683563.2282959974 | -872919.779338262 |  | -1467096 | 594176.220661738
Flow % |  |  |  |  |  |  |  |  |  | Physical_Liquidated Day |  | -189356.5510422647
0.9 | San Juan | Transport detail |  |  |  | LOTS |  |  |  | New Deals |  |  |  |  | 57065 | -57065
0.9 | Permian | [NAME] |  | 19576 | 17 | 33.2792 |  |  |  | Changed Deals |  |  |  |  | -594239 | 594239
0.9 | Socal | Socal TOP |  | 24761 | 17 | 42.0937 |  |  |  | Long term [NAME] |  | -15518809.82 |  |  | -14976371 | -542438.8200000022
 |  | Socal KRS/BAJA OFF |  | 20000 | 17 | 34 |  |  |  | Physical Index Curve Changes |  | 0 |  |  |  | 0
 |  | Mojave TOP |  | 15947 | 17 | 27.1099 |  |  |  | Physical Index New Deals |  | -986635.19 |  |  | 81247 | -1067882.19
 |  | Socal TOP/Pasadena |  | 2486 | 17 | 4.2262 |  |  |  | TOTAL Physical |  |  | -17378364.78933826 |  | -16899394 | -490593.7893382646 | -16887771 | Actual Physical P&L
 |  | Socal KRS / Pasadena |  | 3866 | 17 | 6.5722 |  |  |  | TOTAL GD-WEST |  |  | -43150757.52757356
 |  |  |  |  |  | 147.2812 |  |  |  |  |  | YEAR TO DATE PHY&FIN
Transport Rates
El Paso |  | GDA |  | Transwestern |  | GDA |  |  |  |  |  | TOTAL GD-NEW | -211783487
San Juan |  | 3.45 |  | San Juan |  | 3.47
Permian |  | 4.22 |  | East of Thoreau |  | 3.56
San Juan-Border |  |  |  | Citizens
Commodity |  | 0.0261 |  | Commodity |  | 0.0253
Fuel (3.88%) |  | 0.13386 |  | Fuel (4.5%) |  | 0.134636
Total Variable |  | 0.15996 |  | Total Variable |  | 0.159936
Permian-Border |  |  |  | [NAME] to EOT
Commodity |  | 0.0435 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.163736 |  | Fuel (1.56%) |  | 0.05413199999999999
Total Variable |  | 0.207236 |  | Total Variable |  | 0.07173199999999999
San Juan-Waha |  |  |  | San Juan to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.13386 |  | Fuel (1.31%) |  | 0.045457
Total Variable |  | 0.13916 |  | Total Variable |  | 0.063057
Permian-Waha |  |  |  | Thoreau to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0165
Fuel (1.55%) |  | 0.06541 |  | Fuel (1.31%) |  | 0.045457
Total Variable |  | 0.07071 |  | Total Variable |  | 0.061957
San Juan-AZ/Nev |  |  |  | West Texas to EOT
Commodity |  | 0.0289 |  | Commodity |  | 0
Fuel (3.88%) |  | 0.13386 |  | Fuel (1.31%) |  | 0.046636
Total Variable |  | 0.16276 |  | Total Variable |  | 0.046636
Permian-AZ/Nev |  |  |  | IB Link to SJ Pool
Commodity |  | 0.0316 |  | Commodity |  | 0.0011
Fuel (3.88%) |  | 0.163736 |  | Fuel (.25%) |  | 0.008675
Total Variable |  | 0.195336 |  | Total Variable |  | 0.009775
Permian-Waha IT |  |  |  | IB Link to EP I/C
Commodity |  | 0.045 |  | Commodity |  | 0.0033
Fuel (1.55%) |  | 0.06541 |  | Fuel (.25%) |  | 0.008675
 |  | 0.11041 |  | Total Variable |  | 0.011975
Reservation |  |  |  | IB Link to EP I/C IT
 |  |  |  | Commodity |  | 0.04
9KUB | 5.8 | Monthly |  | Fuel (.25%) |  | 0.008675
9KUC | 5.8 | Monthly |  | Total Variable |  | 0.048675
24568 | 0.2125
24654 | 0.2125
26740 | 0.05
24924 | 0.06
26519 | 0.1031
26520 | 0.2082