Spreadsheet: monique_sanchez__28319__Mike_NCD_Reconciliation_05_29
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 | 0.34 | 0.34 |  | -543.999999999999 | 0 | -543.999999999999 | -0.16
 | 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.2
 | NGI/CHI. GATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.2
 | NNG Demarc | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.2
 | IF-PAN/TX/OK | 0 | 0 | 0 | 0 | 0 | -31 | -31 |  | 49599.9999999999 | 0 | 49599.9999999999 | -0.16
NW | AECOUS | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.3380000000000001
 | SUMAS-US/IM | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | IF-CIG/WIC | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.2
 | IF-CIG/RKYMTN | -1e-08 | 0 | -1e-08 | 0 | 0 | -2.45 | -2.45000001 |  | 4900 | 2.000000000000002e-05 | 4900.000020000005 | -0.2
 | IF-CIG/CHEYENN | 0 | 0 | 0 | 0 | 0 | -3 | -3 |  | 5999.999999999992 | 0 | 5999.999999999992 | -0.2
 | IF-CIG/NW-GR | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.2
 | IF-NWPL_ROCKY_M | -15.51098603 | 0.28471404 | -15.22627199 | 0 | 0 | 0 | -15.22627199 |  | 0 | 30452.54397999995 | 30452.54397999995 | -0.2
 | IF-KERN/OPAL | 0 | 0 | 0 | 0 | 0 | -20.75 | -20.75 |  | 41499.99999999994 | 0 | 41499.99999999994 | -0.2
 | IF-QUESTAR | 0.18087363 | -0.28471404 | -0.10384041 | 0 | 0 | 0 | -0.10384041 |  | 0 | 207.6808200000002 | 207.6808200000002 | -0.2
 | NW-STANFIELD | 1.01349029 | -0.99884101 | 0.01464927999999999 | 0 | 0 | 0 | 0.01464927999999999 |  | 0 | -29.29856000000018 | -29.29856000000018 | -0.2
SW | IF-ELPO/PERMIAN | -11.04863834 | -0.00288999 | -11.05152833 | 0 | 0 | 46 | 34.94847167 |  | -91999.99999999988 | 22103.05665999997 | -69896.94333999991 | -0.2
 | IF-TW/PERMIAN | 0.15446508 | 0 | 0.15446508 | 0 | 0 | 0 | 0.15446508 |  | 0 | -308.9301599999996 | -308.9301599999996 | -0.2
 | IF-ELPO/SJ | -5.10701461 | -9.98492222 | -15.09193683 | 3.299 | 0 | -15 | -26.79293683 |  | 30000 | 26884.87366000002 | 56884.87366000005 | -0.2
 | IF-EPSJ(BONDAD) | 3.90388086 | -1.52760989 | 2.37627097 | 0 | 0 | 0 | 2.37627097 |  | 0 | -4752.541940000005 | -4752.541940000005 | -0.2
 | IM-TW/SJ | 2.46376798 | -2.46895003 | -0.005182049999999716 | 0 | 0 | 0 | -0.005182049999999716 |  | 0 | 10.36409999999887 | 10.36409999999887 | -0.2
 | TW-THOREAU | -0.00498274 | 0.03776921 | 0.03278647 | 0 | 0 | 0 | 0.03278647 |  | 0 | -65.57294000000005 | -65.57294000000005 | -0.2
 | WAHA KCBT | 0 | 5.62502056 | 5.62502056 | -3.299 | 0 | -19.5 | -17.17397944 |  | 39000 | -7951.041120000006 | 31048.95888000003 | -0.2
CALI | NGI-MALIN | -12.93719856 | 0.61168174 | -12.32551682 | 0 | 0 | 3 | -9.325516819999999 |  | -6000.000000000005 | 24651.03364000002 | 18651.03364000001 | -0.2
 | NGI-PGE/CG | 4.962813855 | 7.97239161 | 12.935205465 | 0 | 0 | 1 | 13.935205465 |  | -29500 | -381588.5612175 | -411088.5612175 | -2.95
 | NGI-MOJAVE | 0 | 1.58919661 | 1.58919661 | 0 | 0 | 0 | 1.58919661 |  | 0 | 23837.94915 | 23837.94915 | 1.5
 | PGE/TOPOCK | 0.59792936 | -7.79988899 | -7.20195963 | 0 | 0 | 0 | -7.20195963 |  | 0 | -108029.39445 | -108029.39445 | 1.5
 | NGI-SOCAL | 8.38845076 | 6.9470424 | 15.33549316 | 0 | 0 | 9.5 | 24.83549316 |  | -137750 | -222364.6508200001 | -360114.6508200002 | -1.45
 | NGI-SOCAL(KRS) | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -1.45
 |  | -22.943148475 | 2.664535259100376e-15 | -22.943148475 | 0 | 0 | -31.86 | -54.80314847500003 |  | -94794.00000000006 | -596942.4891775001 | -691736.4891775002
After 11:00? (Y/N) |  | Physical | Transport | Subtotal | T Model | GD Index | [NAME] | Net |  | TRADING ESTIMATE |  |  |  |  | Actuals | Delta | Explanation
y | [NAME] 6 | 0 | 0 | 0 | 0 | 0 | 0.34 | 0.34 |  | Financial Curveshift_BOM |  | -94794.00000000006 | 792367 |  | -417598 | 1209965
 | Chicago/PEPL/Demarc | 0 | 0 | 0 | 0 | 0 | -31 | -31 |  | Financial Curveshift_Liquidated Day |  | 887161
 | Waha | 0 | 5.62502056 | 5.62502056 | -3.299 | 0 | -19.5 | -17.17397944
 | Perm, San Juan | -9.638521770000002 | -13.94660292 | -21.208405271 | 3.299 | 0 | 31 | 13.090594729 |  | TDS-New Deals |  | -629026.2 |  |  | -591587 | -37439.20000000007
 | Aeco, Sumas, [NAME] | 1.01349029 | -0.99884101 | 0.01464927999999999 | 0 | 0 | 0 | 0.01464927999999999 |  | TDS-CurveShift |  | -47563788 |  |  | -47493427 | -70361
 | Rockies | -15.33011241 | 0 | -15.33011241 | 0 | 0 | -26.2 | -41.53011241 |  | Financial Index Curve Changes |  | 0
 | CA/ Scal, CG, Malin | 1.011995415000001 | 9.32042337 | -4.441798073 | 0 | 0 | 13.5 | 9.058201926999999 |  | First of Month Indices Estimate
 |  |  |  |  |  |  |  |  |  | [NAME]. Financial
 | Flow adjusted position | -22.943148475 | 0 | -35.340645914 | 0 | 0 | -31.86 | -67.200645914 |  | TOTAL Financial |  |  | -47400447.2 |  | -48502612 | 1102164.8 | -48382461 | Actual Financial P&L
 |  |  |  |  |  |  |  |  |  | Physical_BOM |  | -596942.4891775001 | -1003375.616275 |  | -1099617 | 96241.38372499973
Flow % |  |  |  |  |  |  |  |  |  | Physical_Liquidated Day |  | -406433.1270975001
0.9 | San Juan | Transport detail |  |  |  | LOTS |  |  |  | New Deals |  |  |  |  | -623813 | 623813
0.9 | Permian | [NAME] |  | 19576 | 2 | 3.9152 |  |  |  | Changed Deals |  |  |  |  | 356705 | -356705
0.9 | Socal | Socal TOP |  | 24761 | 2 | 4.9522 |  |  |  | Long term [NAME] |  | -18195597.765 |  |  | -17528863 | -666734.7649999969
 |  | Socal KRS/BAJA OFF |  | 20000 | 2 | 4 |  |  |  | Physical Index Curve Changes |  | 0 |  |  | -35972 | 35972
 |  | Mojave TOP |  | 15947 | 2 | 3.1894 |  |  |  | Physical Index New Deals |  | -33757.39 |  |  | -155535 | 121777.61
 |  | Socal TOP/Pasadena |  | 2486 | 2 | 0.4972 |  |  |  | TOTAL Physical |  |  | -19232730.771275 |  | -19087095 | -2599549.771274999 | -16633181 | Actual Physical P&L
 |  | Socal KRS / Pasadena |  | 3866 | 2 | 0.7732 |  |  |  | TOTAL GD-WEST |  |  | -66633177.971275 |  | 2440348 | Prompr Month Value
 |  |  |  |  |  | 17.3272 |  |  |  |  |  | YEAR TO DATE PHY&FIN | -154506359
Transport Rates
El Paso |  | GDA |  | Transwestern |  | GDA |  |  |  |  |  | TOTAL GD-NEW | -221139536.971275
San Juan |  | 2.73 |  | San Juan |  | 2.75
Permian |  | 3.6 |  | East of Thoreau |  | 2.84
San Juan-Border |  |  |  | Citizens
Commodity |  | 0.0261 |  | Commodity |  | 0.0253
Fuel (3.88%) |  | 0.105924 |  | Fuel (4.5%) |  | 0.1067
Total Variable |  | 0.132024 |  | Total Variable |  | 0.132
Permian-Border |  |  |  | [NAME] to EOT
Commodity |  | 0.0435 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.13968 |  | Fuel (1.56%) |  | 0.0429
Total Variable |  | 0.18318 |  | Total Variable |  | 0.0605
San Juan-Waha |  |  |  | San Juan to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.105924 |  | Fuel (1.31%) |  | 0.036025
Total Variable |  | 0.111224 |  | Total Variable |  | 0.05362500000000001
Permian-Waha |  |  |  | Thoreau to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0165
Fuel (1.55%) |  | 0.0558 |  | Fuel (1.31%) |  | 0.036025
Total Variable |  | 0.0611 |  | Total Variable |  | 0.052525
San Juan-AZ/Nev |  |  |  | West Texas to EOT
Commodity |  | 0.0289 |  | Commodity |  | 0
Fuel (3.88%) |  | 0.105924 |  | Fuel (1.31%) |  | 0.037204
Total Variable |  | 0.134824 |  | Total Variable |  | 0.037204
Permian-AZ/Nev |  |  |  | IB Link to SJ Pool
Commodity |  | 0.0316 |  | Commodity |  | 0.0011
Fuel (3.88%) |  | 0.13968 |  | Fuel (.25%) |  | 0.006875
Total Variable |  | 0.17128 |  | Total Variable |  | 0.007975
Permian-Waha IT |  |  |  | IB Link to EP I/C
Commodity |  | 0.045 |  | Commodity |  | 0.0033
Fuel (1.55%) |  | 0.0558 |  | Fuel (.25%) |  | 0.006875
 |  | 0.1008 |  | Total Variable |  | 0.010175
Reservation |  |  |  | IB Link to EP I/C IT
 |  |  |  | Commodity |  | 0.04
9KUB | 5.8 | Monthly |  | Fuel (.25%) |  | 0.006875
9KUC | 5.8 | Monthly |  | Total Variable |  | 0.046875
24568 | 0.2125
24654 | 0.2125
26740 | 0.05
24924 | 0.06
26519 | 0.1031
26520 | 0.2082