Spreadsheet: mike_grigsby__27697__Mike_NCD_Reconciliation_05_07
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 | -120.7466666666667 | -120.7466666666667 |  | 277717.3333333328 | 0 | 277717.3333333328 | -0.23
 | 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.225
 | NGI/CHI. GATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.225
 | NNG Demarc | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.2250000000000005
 | IF-PAN/TX/OK | 0 | 0 | 0 | 0 | 0 | -277.3333333333333 | -277.3333333333333 |  | 624000.0000000014 | 0 | 624000.0000000014 | -0.2250000000000005
NW | AECOUS | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.225
 | SUMAS-US/IM | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.225
 | IF-CIG/WIC | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.05499999999999972
 | IF-CIG/RKYMTN | -2.133333333333334e-07 | 0 | -2.133333333333334e-07 | 0 | 0 | -10.66666666666667 | -10.66666688 |  | 5866.666666666635 | 0.0001173333333333328 | 5866.666783999968 | -0.05499999999999972
 | IF-CIG/CHEYENN | 0 | 0 | 0 | 0 | 0 | -32 | -32 |  | 17599.99999999991 | 0 | 17599.99999999991 | -0.05499999999999972
 | IF-CIG/NW-GR | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.085
 | IF-NWPL_ROCKY_M | -324.5953273600001 | 7.079921493333334 | -317.5154058666667 | 0 | 0 | 0 | -317.5154058666667 |  | 0 | 269888.0949866666 | 269888.0949866666 | -0.085
 | IF-KERN/OPAL | -0.08196323555555553 | 0 | -0.08196323555555553 | 0 | 0 | -282.6666666666667 | -282.7486299022223 |  | 240266.6666666666 | 69.66875022222217 | 240336.3354168888 | -0.085
 | IF-QUESTAR | 3.847322453333333 | -7.079921493333334 | -3.232599040000001 | 0 | 0 | 0 | -3.232599040000001 |  | 0 | 2747.709184 | 2747.709184 | -0.085
 | NW-STANFIELD | 21.55772479999998 | -21.24612373333333 | 0.3116010666666504 | 0 | 0 | 0 | 0.3116010666666504 |  | 0 | -4128.714133333124 | -4128.714133333124 | -1.325
SW | IF-ELPO/PERMIAN | -236.3909410222223 | -41.55744277333334 | -277.9483837955556 | 0 | 0 | 970.6666666666666 | 692.718282871111 |  | -2766400 | 792152.8938173339 | -1974247.106182667 | -0.285
 | IF-TW/PERMIAN | 2.54368447111111 | 0 | 2.54368447111111 | 0 | 0 | 0 | 2.54368447111111 |  | 0 | -7249.500742666668 | -7249.500742666668 | -0.285
 | IF-ELPO/SJ | -85.37382300444443 | -171.56090944 | -256.9347324444444 | 44.5365 | 0 | -245.3333333333333 | -457.7315657777777 |  | 674666.6666666664 | 597703.5142222219 | 1272370.180888888 | -0.275
 | IF-EPSJ(BONDAD) | 82.38145666666667 | -70.45793621333334 | 11.92352045333332 | 0 | 0 | 0 | 11.92352045333332 |  | 0 | -32789.68124666665 | -32789.68124666665 | -0.275
 | IM-TW/SJ | 19.61109959111111 | -21.03626944 | -1.425169848888888 | 0 | 0 | 0 | -1.425169848888888 |  | 0 | 3919.217084444448 | 3919.217084444448 | -0.275
 | TW-THOREAU | -7.419079253333335 | 7.364761039999999 | -0.05431821333333531 | 0 | 0 | 0 | -0.05431821333333531 |  | 0 | 149.3750866666778 | 149.3750866666778 | -0.275
 | WAHA KCBT | 0 | 120.24128312 | 120.24128312 | -44.5365 | 0 | -416 | -340.29521688 |  | 998399.999999997 | -193567.8794879995 | 804832.1205119975 | -0.2399999999999993
CALI | NGI-MALIN | -275.1842517333333 | 13.01094570666667 | -262.1733060266666 | 0 | 0 | 64 | -198.1733060266666 |  | -848000 | 3473796.304853333 | 2625796.304853333 | -1.325
 | NGI-PGE/CG | 105.56290112 | 169.5810752 | 275.14397632 | 0 | 0 | 53.33333333333334 | 328.4773096533333 |  | -493333.3333333337 | -2545081.780960002 | -3038415.114293335 | -0.9250000000000007
 | NGI-MOJAVE | 0 | 33.80344512 | 33.80344512 | 0 | 0 | 0 | 33.80344512 |  | 0 | -312681.8673600003 | -312681.8673600003 | -0.9250000000000007
 | PGE/TOPOCK | 12.71842154666667 | -165.91181056 | -153.1933890133333 | 0 | 0 | 0 | -153.1933890133333 |  | 0 | 1110652.070346669 | 1110652.070346669 | -0.7250000000000014
 | NGI-SOCAL | 136.0341181866667 | 147.7689819733334 | 283.80310016 | 0 | 0 | 320 | 603.80310016 |  | -80000.00000000114 | -70950.775040001 | -150950.7750400021 | -0.02500000000000036
 | NGI-SOCAL(KRS) | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.02500000000000036
 |  | -544.7886569866668 | 2.842170943040401e-14 | -544.7886569866669 | 0 | 0 | 23.25333333333322 | -521.5353236533331 |  | -1349216.000000006 | 3084628.649478221 | 1735412.649478216
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 | -120.7466666666667 | -120.7466666666667 |  | Financial Curveshift_BOM |  | -1349216.000000006 | -1997466.666666673 |  | -1682118 | -315348.666666673
 | Chicago/PEPL/Demarc | 0 | 0 | 0 | 0 | 0 | -277.3333333333333 | -277.3333333333333 |  | Financial Curveshift_Liquidated Day |  | -648250.6666666671
 | Waha | 0 | 120.24128312 | 120.24128312 | -44.5365 | 0 | -416 | -340.29521688
 | Perm, San Juan | -224.6476025511112 | -297.2477968266667 | -469.5994397991112 | 44.5365 | 0 | 725.3333333333333 | 300.2703935342221 |  | TDS-New Deals |  | 133989.78 |  |  | 21167 | 112822.78
 | Aeco, Sumas, [NAME] | 21.55772479999998 | -21.24612373333333 | 0.3116010666666504 | 0 | 0 | 0 | 0.3116010666666504 |  | TDS-CurveShift |  | -19136390 |  |  | -19480470 | 344080
 | Rockies | -320.8299683555556 | 0 | -320.8299683555556 | 0 | 0 | -325.3333333333334 | -646.1633016888891 |  | Financial Index Curve Changes |  | 0
 | CA/ Scal, CG, Malin | -20.86881088000004 | 198.25263744 | -94.48027921066667 | 0 | 0 | 437.3333333333334 | 342.8530541226667 |  | First of Month Indices Estimate
 |  |  |  |  |  |  |  |  |  | [NAME]. Financial
 | Flow adjusted position | -544.788656986667 | 0 | -764.3568031786668 | 0 | 0 | 23.25333333333333 | -741.1034698453335 |  | TOTAL Financial |  |  | -20999866.88666667 |  | -21141421 | 141554.1133333258 | -21130456 | Actual Financial P&L
 |  |  |  |  |  |  |  |  |  | Physical_BOM |  | 3084628.649478221 | 2954982.842169611 |  | 3330854 | -375871.1578303888
Flow % |  |  |  |  |  |  |  |  |  | Physical_Liquidated Day |  | -129645.8073086102
0.9 | San Juan | Transport detail |  |  |  | LOTS |  |  |  | New Deals |  |  |  |  | -147912 | 147912
0.9 | Permian | [NAME] |  | 19576 | 27 | 52.8552 |  |  |  | Changed Deals |  |  |  |  | -559818 | 559818
0.9 | Socal | Socal TOP |  | 24761 | 27 | 66.8547 |  |  |  | Long term [NAME] |  | 492797.9800000068 |  |  | 830811 | -338013.0199999932
 |  | Socal KRS/BAJA OFF |  | 20000 | 27 | 54 |  |  |  | Physical Index Curve Changes |  | 0 |  |  | 0 | 0
 |  | Mojave TOP |  | 15947 | 27 | 43.0569 |  |  |  | Physical Index New Deals |  | -106671.78 |  |  | 6158 | -112829.78
 |  | Socal TOP/Pasadena |  | 2486 | 27 | 6.7122 |  |  |  | TOTAL Physical |  |  | 3341109.042169618 |  | 3460093 | -269587.9578303816 | 3610697 | Actual Physical P&L
 |  | Socal KRS / Pasadena |  | 3866 | 27 | 10.4382 |  |  |  | TOTAL GD-WEST |  |  | -17658757.84449705
 |  |  |  |  |  | 233.9172 |  |  |  |  |  | YEAR TO DATE PHY&FIN
Transport Rates
El Paso |  | GDA |  | Transwestern |  | GDA |  |  |  |  |  | TOTAL GD-NEW | -22349125
San Juan |  | 3.7 |  | San Juan |  | 3.72
Permian |  | 4.04 |  | East of Thoreau |  | 3.81
San Juan-Border |  |  |  | Citizens
Commodity |  | 0.0261 |  | Commodity |  | 0.0253
Fuel (3.88%) |  | 0.14356 |  | Fuel (4.5%) |  | 0.144336
Total Variable |  | 0.16966 |  | Total Variable |  | 0.169636
Permian-Border |  |  |  | [NAME] to EOT
Commodity |  | 0.0435 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.156752 |  | Fuel (1.56%) |  | 0.058032
Total Variable |  | 0.200252 |  | Total Variable |  | 0.075632
San Juan-Waha |  |  |  | San Juan to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.14356 |  | Fuel (1.31%) |  | 0.048732
Total Variable |  | 0.14886 |  | Total Variable |  | 0.066332
Permian-Waha |  |  |  | Thoreau to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0165
Fuel (1.55%) |  | 0.06262 |  | Fuel (1.31%) |  | 0.048732
Total Variable |  | 0.06792 |  | Total Variable |  | 0.06523200000000001
San Juan-AZ/Nev |  |  |  | West Texas to EOT
Commodity |  | 0.0289 |  | Commodity |  | 0
Fuel (3.88%) |  | 0.14356 |  | Fuel (1.31%) |  | 0.049911
Total Variable |  | 0.17246 |  | Total Variable |  | 0.049911
Permian-AZ/Nev |  |  |  | IB Link to SJ Pool
Commodity |  | 0.0316 |  | Commodity |  | 0.0011
Fuel (3.88%) |  | 0.156752 |  | Fuel (.25%) |  | 0.009300000000000001
Total Variable |  | 0.188352 |  | Total Variable |  | 0.0104
Permian-Waha IT |  |  |  | IB Link to EP I/C
Commodity |  | 0.045 |  | Commodity |  | 0.0033
Fuel (1.55%) |  | 0.06262 |  | Fuel (.25%) |  | 0.009300000000000001
 |  | 0.10762 |  | Total Variable |  | 0.0126
Reservation |  |  |  | IB Link to EP I/C IT
 |  |  |  | Commodity |  | 0.04
9KUB | 5.8 | Monthly |  | Fuel (.25%) |  | 0.009300000000000001
9KUC | 5.8 | Monthly |  | Total Variable |  | 0.0493
24568 | 0.2125
24654 | 0.2125
26740 | 0.05
24924 | 0.06
26519 | 0.1031
26520 | 0.2082