Spreadsheet: monique_sanchez__28328__Mike_NCD_Reconciliation_05_30
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 | 0 |  | 0 | 0 | 0 | 0.15
 | 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.19
 | NGI/CHI. GATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.19
 | NNG Demarc | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.19
 | IF-PAN/TX/OK | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.11
NW | AECOUS | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.141
 | SUMAS-US/IM | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.24
 | IF-CIG/WIC | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.15
 | IF-CIG/RKYMTN | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.15
 | IF-CIG/CHEYENN | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.18
 | IF-CIG/NW-GR | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.26
 | IF-NWPL_ROCKY_M | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.26
 | IF-KERN/OPAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.26
 | IF-QUESTAR | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.26
 | NW-STANFIELD | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.3
SW | IF-ELPO/PERMIAN | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.17
 | IF-TW/PERMIAN | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.17
 | IF-ELPO/SJ | 0 | 0 | 0 | 1.6495 | 0 | 0 | 1.6495 |  | 0 | 0 | 0 | 0.36
 | IF-EPSJ(BONDAD) | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.36
 | IM-TW/SJ | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.36
 | TW-THOREAU | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.36
 | WAHA KCBT | 0 | 0 | 0 | -1.6495 | 0 | 0 | -1.6495 |  | 0 | 0 | 0 | 0.18
CALI | NGI-MALIN | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.3
 | NGI-PGE/CG | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.34
 | NGI-MOJAVE | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -3.86
 | PGE/TOPOCK | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -3.86
 | NGI-SOCAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.8099999999999987
 | NGI-SOCAL(KRS) | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.8099999999999987
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
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 | 0 |  | Financial Curveshift_BOM |  | 0 | 965969.5 |  | -7665888 | 8631857.5
 | Chicago/PEPL/Demarc | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Financial Curveshift_Liquidated Day |  | 965969.5
 | Waha | 0 | 0 | 0 | -1.6495 | 0 | 0 | -1.6495
 | Perm, San Juan | 0 | 0 | 0 | 1.6495 | 0 | 0 | 1.6495 |  | TDS-New Deals |  | -163625.96 |  |  | -2729534 | 2565908.04
 | Aeco, Sumas, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | TDS-CurveShift |  | -57237796 |  |  | -57237796 | 0
 | Rockies | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Financial Index Curve Changes |  | 0
 | CA/ Scal, CG, Malin | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | First of Month Indices Estimate
 |  |  |  |  |  |  |  |  |  | [NAME]. Financial
 | Flow adjusted position | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | TOTAL Financial |  |  | -56435452.46 |  | -67633218 | 11197765.54 | -67602204 | Actual Financial P&L
 |  |  |  |  |  |  |  |  |  | Physical_BOM |  | 0 | 82869.35891100022 |  | -41932 | 124801.3589110002
Flow % |  |  |  |  |  |  |  |  |  | Physical_Liquidated Day |  | 82869.35891100022
0.9 | San Juan | Transport detail |  |  |  | LOTS |  |  |  | New Deals |  |  |  |  | -69274 | 69274
0.9 | Permian | [NAME] |  | 19576 | 1 | 1.9576 |  |  |  | Changed Deals |  |  |  |  | -1105278 | 1105278
0.9 | Socal | Socal TOP |  | 24761 | 1 | 2.4761 |  |  |  | Long term [NAME] |  | -4170210.174000003 |  |  | -5545811 | 1375600.825999997
 |  | Socal KRS/BAJA OFF |  | 20000 | 1 | 2 |  |  |  | Physical Index Curve Changes |  | 0 |  |  | 140080 | -140080
 |  | Mojave TOP |  | 15947 | 1 | 1.5947 |  |  |  | Physical Index New Deals |  | 140056.22 |  |  | 140079 | -22.77999999999884
 |  | Socal TOP/Pasadena |  | 2486 | 1 | 0.2486 |  |  |  | TOTAL Physical |  |  | -3947284.595089003 |  | -6482136 | 2336309.404910997 | -6283594 | Actual Physical P&L
 |  | Socal KRS / Pasadena |  | 3866 | 1 | 0.3866 |  |  |  | TOTAL GD-WEST |  |  | -60382737.055089
 |  |  |  |  |  | 8.663599999999999 |  |  |  |  |  | YEAR TO DATE PHY&FIN | -219522002
Transport Rates
El Paso |  | GDA |  | Transwestern |  | GDA |  |  |  |  |  | TOTAL GD-NEW | -279904739.055089
San Juan |  | 3.09 |  | San Juan |  | 3.11
Permian |  | 3.77 |  | East of Thoreau |  | 3.2
San Juan-Border |  |  |  | Citizens
Commodity |  | 0.0261 |  | Commodity |  | 0.0253
Fuel (3.88%) |  | 0.119892 |  | Fuel (4.5%) |  | 0.120668
Total Variable |  | 0.145992 |  | Total Variable |  | 0.145968
Permian-Border |  |  |  | [NAME] to EOT
Commodity |  | 0.0435 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.146276 |  | Fuel (1.56%) |  | 0.048516
Total Variable |  | 0.189776 |  | Total Variable |  | 0.06611600000000001
San Juan-Waha |  |  |  | San Juan to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.119892 |  | Fuel (1.31%) |  | 0.04074100000000001
Total Variable |  | 0.125192 |  | Total Variable |  | 0.058341
Permian-Waha |  |  |  | Thoreau to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0165
Fuel (1.55%) |  | 0.058435 |  | Fuel (1.31%) |  | 0.04074100000000001
Total Variable |  | 0.063735 |  | Total Variable |  | 0.05724100000000001
San Juan-AZ/Nev |  |  |  | West Texas to EOT
Commodity |  | 0.0289 |  | Commodity |  | 0
Fuel (3.88%) |  | 0.119892 |  | Fuel (1.31%) |  | 0.04192000000000001
Total Variable |  | 0.148792 |  | Total Variable |  | 0.04192000000000001
Permian-AZ/Nev |  |  |  | IB Link to SJ Pool
Commodity |  | 0.0316 |  | Commodity |  | 0.0011
Fuel (3.88%) |  | 0.146276 |  | Fuel (.25%) |  | 0.007775000000000001
Total Variable |  | 0.177876 |  | Total Variable |  | 0.008875000000000001
Permian-Waha IT |  |  |  | IB Link to EP I/C
Commodity |  | 0.045 |  | Commodity |  | 0.0033
Fuel (1.55%) |  | 0.058435 |  | Fuel (.25%) |  | 0.007775000000000001
 |  | 0.103435 |  | Total Variable |  | 0.011075
Reservation |  |  |  | IB Link to EP I/C IT
 |  |  |  | Commodity |  | 0.04
9KUB | 5.8 | Monthly |  | Fuel (.25%) |  | 0.007775000000000001
9KUC | 5.8 | Monthly |  | Total Variable |  | 0.047775
24568 | 0.2125
24654 | 0.2125
26740 | 0.05
24924 | 0.06
26519 | 0.1031
26520 | 0.2082