Spreadsheet: mike_grigsby__27700__Mike_NCD_Reconciliation_05_10
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 | -118.86 | -118.86 |  | -113457.2727272723 | 0 | -113457.2727272723 | 0.09999999999999964
 | 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.09999999999999964
 | NGI/CHI. GATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.09999999999999964
 | NNG Demarc | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.1000000000000005
 | IF-PAN/TX/OK | 0 | 0 | 0 | 0 | 0 | -273 | -273 |  | -260590.9090909105 | 0 | -260590.9090909105 | 0.1000000000000005
NW | AECOUS | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.09699999999999998
 | SUMAS-US/IM | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.13
 | IF-CIG/WIC | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | IF-CIG/RKYMTN | 0 | 0 | 0 | 0 | 0 | -10.5 | -10.5 |  | 0 | 0 | 0 | 0
 | IF-CIG/CHEYENN | 0 | 0 | 0 | 0 | 0 | -31.5 | -31.5 |  | 30068.18181818185 | 0 | 30068.18181818185 | -0.1
 | IF-CIG/NW-GR | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.1
 | IF-NWPL_ROCKY_M | -319.7811823500001 | 6.97491774 | -312.8062646100001 | 0 | 0 | 0 | -312.8062646100001 |  | 0 | 298587.7980368185 | 298587.7980368185 | -0.1
 | IF-KERN/OPAL | -0.09228287999999997 | 0 | -0.09228287999999997 | 0 | 0 | -278.25 | -278.34228288 |  | 265602.272727273 | 88.08820363636367 | 265690.3609309093 | -0.1
 | IF-QUESTAR | 3.790262069999998 | -6.97491774 | -3.184655670000002 | 0 | 0 | 0 | -3.184655670000002 |  | 0 | 3039.898594090914 | 3039.898594090914 | -0.1
 | NW-STANFIELD | 21.23799782999999 | -20.93101815 | 0.3069796799999907 | 0 | 0 | 0 | 0.3069796799999907 |  | 0 | -439.5390872727075 | -439.5390872727075 | -0.1499999999999995
SW | IF-ELPO/PERMIAN | -232.88498457 | -40.94109621 | -273.82608078 | 0 | 0 | 955.5 | 681.67391922 |  | 820861.3636363704 | -235241.4966700929 | 585619.8669662775 | 0.09000000000000075
 | IF-TW/PERMIAN | 3.236862530000001 | 0 | 3.236862530000001 | 0 | 0 | 0 | 3.236862530000001 |  | 0 | 2780.759173499996 | 2780.759173499996 | 0.08999999999999986
 | IF-ELPO/SJ | -106.60655575 | -168.35655417 | -274.96310992 | 36.289 | 0 | -231 | -469.67410992 |  | -88200.00000000007 | -91130.11469672734 | -179330.1146967274 | 0.04
 | IF-EPSJ(BONDAD) | 81.15964121999998 | -62.93923503 | 18.22040618999998 | 0 | 0 | 0 | 18.22040618999998 |  | 0 | 6956.882363454548 | 6956.882363454548 | 0.04
 | IM-TW/SJ | 20.53841769 | -20.72636475 | -0.1879470599999991 | 0 | 0 | 0 | -0.1879470599999991 |  | 0 | -71.76160472727224 | -71.76160472727224 | 0.04
 | TW-THOREAU | -0.41765976 | 0.70793331 | 0.29027355 | 0 | 0 | 0 | 0.29027355 |  | 0 | 110.8317190909093 | 110.8317190909093 | 0.04
 | WAHA KCBT | 0 | 117.87402102 | 117.87402102 | -36.289 | 0 | -409.5 | -327.91497898 |  | -390886.3636363622 | 77876.61097363607 | -313009.7526627262 | 0.09999999999999964
CALI | NGI-MALIN | -271.1029391700001 | 12.81797769 | -258.28496148 | 0 | 0 | 63 | -195.28496148 |  | -90204.54545454514 | 369817.1039372715 | 279612.5584827263 | -0.1499999999999995
 | NGI-PGE/CG | 103.99727604 | 167.06598552 | 271.06326156 | 0 | 0 | 52.5 | 323.56326156 |  | -576306.8181818184 | -2975535.348488182 | -3551842.166670001 | -1.15
 | NGI-MOJAVE | 0 | 33.30209967 | 33.30209967 | 0 | 0 | 0 | 33.30209967 |  | 0 | -397354.5983352272 | -397354.5983352272 | -1.25
 | PGE/TOPOCK | 12.52979216999999 | -163.45114044 | -150.92134827 | 0 | 0 | 0 | -150.92134827 |  | 0 | 1800766.0873125 | 1800766.0873125 | -1.25
 | NGI-SOCAL | 134.01657024 | 145.57739154 | 279.59396178 | 0 | 0 | 315 | 594.59396178 |  | -1202727.272727274 | -1067540.581341819 | -2270267.854069093 | -0.4
 | NGI-SOCAL(KRS) | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.4
 |  | -550.3787846900002 | -5.684341886080801e-14 | -550.3787846900002 | 0 | 0 | 33.39 | -516.9887846900001 |  | -1605841.363636357 | -2207289.379910051 | -3813130.743546408
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 | -118.86 | -118.86 |  | Financial Curveshift_BOM |  | -1605841.363636357 | -1152686.181818176 |  | -1656371 | 503684.8181818244
 | Chicago/PEPL/Demarc | 0 | 0 | 0 | 0 | 0 | -273 | -273 |  | Financial Curveshift_Liquidated Day |  | 453155.1818181818
 | Waha | 0 | 117.87402102 | 117.87402102 | -36.289 | 0 | -409.5 | -327.91497898
 | Perm, San Juan | -234.9742786400001 | -292.25531685 | -474.1727170390001 | 36.289 | 0 | 724.5 | 286.6162829609999 |  | TDS-New Deals |  | 37021.45 |  |  | 5984 | 31037.45
 | Aeco, Sumas, [NAME] | 21.23799782999999 | -20.93101815 | 0.3069796799999907 | 0 | 0 | 0 | 0.3069796799999907 |  | TDS-CurveShift |  | 948367 |  |  | 714511 | 233856
 | Rockies | -316.0832031600002 | 0 | -316.0832031600001 | 0 | 0 | -320.25 | -636.33320316 |  | Financial Index Curve Changes |  | 0
 | CA/ Scal, CG, Malin | -20.55930072000007 | 195.31231398 | -93.07902366000008 | 0 | 0 | 430.5 | 337.4209763399999 |  | First of Month Indices Estimate
 |  |  |  |  |  |  |  |  |  | [NAME]. Financial
 | Flow adjusted position | -550.3787846900002 | 0 | -765.1539431590003 | 0 | 0 | 33.39 | -731.7639431590003 |  | TOTAL Financial |  |  | -167297.7318181756 |  | -935876 | 768578.2681818244 | -952123 | Actual Financial P&L
 |  |  |  |  |  |  |  |  |  | Physical_BOM |  | -2207289.379910051 | -2451404.544736233 |  | -2612709 | 161304.4552637669
Flow % |  |  |  |  |  |  |  |  |  | Physical_Liquidated Day |  | -244115.1648261821
0.9 | San Juan | Transport detail |  |  |  | LOTS |  |  |  | New Deals |  |  |  |  | -325465 | 325465
0.9 | Permian | [NAME] |  | 19576 | 22 | 43.0672 |  |  |  | Changed Deals |  |  |  |  | -799153 | 799153
0.9 | Socal | Socal TOP |  | 24761 | 22 | 54.4742 |  |  |  | Long term [NAME] |  | -1348894.58 |  |  | -2084118 | 735223.420000003
 |  | Socal KRS/BAJA OFF |  | 20000 | 22 | 44 |  |  |  | Physical Index Curve Changes |  | 0 |  |  |  | 0
 |  | Mojave TOP |  | 15947 | 22 | 35.0834 |  |  |  | Physical Index New Deals |  | 37021.59 |  |  | 43031 | -6009.41
 |  | Socal TOP/Pasadena |  | 2486 | 22 | 5.4692 |  |  |  | TOTAL Physical |  |  | -3763277.53473623 |  | -5778414 | 1974546.46526377 | -5737824 | Actual Physical P&L
 |  | Socal KRS / Pasadena |  | 3866 | 22 | 8.5052 |  |  |  | TOTAL GD-WEST |  |  | -3930575.266554406
 |  |  |  |  |  | 190.5992 |  |  |  |  |  | YEAR TO DATE PHY&FIN | -86495870
Transport Rates
El Paso |  | GDA |  | Transwestern |  | GDA |  |  |  |  |  | TOTAL GD-NEW | -86495870
San Juan |  | 3.54 |  | San Juan |  | 3.56
Permian |  | 4.15 |  | East of Thoreau |  | 3.65
San Juan-Border |  |  |  | Citizens
Commodity |  | 0.0261 |  | Commodity |  | 0.0253
Fuel (3.88%) |  | 0.137352 |  | Fuel (4.5%) |  | 0.138128
Total Variable |  | 0.163452 |  | Total Variable |  | 0.163428
Permian-Border |  |  |  | [NAME] to EOT
Commodity |  | 0.0435 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.16102 |  | Fuel (1.56%) |  | 0.055536
Total Variable |  | 0.20452 |  | Total Variable |  | 0.07313599999999999
San Juan-Waha |  |  |  | San Juan to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.137352 |  | Fuel (1.31%) |  | 0.046636
Total Variable |  | 0.142652 |  | Total Variable |  | 0.064236
Permian-Waha |  |  |  | Thoreau to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0165
Fuel (1.55%) |  | 0.06432500000000001 |  | Fuel (1.31%) |  | 0.046636
Total Variable |  | 0.069625 |  | Total Variable |  | 0.063136
San Juan-AZ/Nev |  |  |  | West Texas to EOT
Commodity |  | 0.0289 |  | Commodity |  | 0
Fuel (3.88%) |  | 0.137352 |  | Fuel (1.31%) |  | 0.047815
Total Variable |  | 0.166252 |  | Total Variable |  | 0.047815
Permian-AZ/Nev |  |  |  | IB Link to SJ Pool
Commodity |  | 0.0316 |  | Commodity |  | 0.0011
Fuel (3.88%) |  | 0.16102 |  | Fuel (.25%) |  | 0.0089
Total Variable |  | 0.19262 |  | Total Variable |  | 0.01
Permian-Waha IT |  |  |  | IB Link to EP I/C
Commodity |  | 0.045 |  | Commodity |  | 0.0033
Fuel (1.55%) |  | 0.06432500000000001 |  | Fuel (.25%) |  | 0.0089
 |  | 0.109325 |  | Total Variable |  | 0.0122
Reservation |  |  |  | IB Link to EP I/C IT
 |  |  |  | Commodity |  | 0.04
9KUB | 5.8 | Monthly |  | Fuel (.25%) |  | 0.0089
9KUC | 5.8 | Monthly |  | Total Variable |  | 0.0489
24568 | 0.2125
24654 | 0.2125
26740 | 0.05
24924 | 0.06
26519 | 0.1031
26520 | 0.2082