Spreadsheet: mike_grigsby__27702__Mike_NCD_Reconciliation_05_11
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 | -113.2 | -113.2 |  | 43016 | 0 | 43016 | -0.04
 | 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.04
 | NGI/CHI. GATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.04
 | NNG Demarc | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.04000000000000092
 | IF-PAN/TX/OK | 0 | 0 | 0 | 0 | 0 | -260 | -260 |  | 98800.00000000009 | 0 | 98800.00000000009 | -0.04
NW | AECOUS | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.07299999999999995
 | SUMAS-US/IM | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.07000000000000028
 | IF-CIG/WIC | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.04999999999999982
 | IF-CIG/RKYMTN | 0 | 0 | 0 | 0 | 0 | -10 | -10 |  | 4749.999999999983 | 0 | 4749.999999999983 | -0.04999999999999982
 | IF-CIG/CHEYENN | 0 | 0 | 0 | 0 | 0 | -30 | -30 |  | 14249.99999999995 | 0 | 14249.99999999995 | -0.04999999999999982
 | IF-CIG/NW-GR | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.05000000000000027
 | IF-NWPL_ROCKY_M | -304.607641 | 6.6439596 | -297.9636814 | 0 | 0 | 0 | -297.9636814 |  | 0 | 141532.7486650007 | 141532.7486650007 | -0.05000000000000027
 | IF-KERN/OPAL | -0.9946045999999998 | 0 | -0.9946045999999998 | 0 | 0 | -265 | -265.9946046 |  | 125875.0000000007 | 472.4371850000024 | 126347.4371850007 | -0.05000000000000027
 | IF-QUESTAR | 3.610415199999999 | -6.6439596 | -3.033544400000001 | 0 | 0 | 0 | -3.033544400000001 |  | 0 | 1440.933590000008 | 1440.933590000008 | -0.05000000000000027
 | NW-STANFIELD | 20.23026000000001 | -19.9378462 | 0.2924138000000092 | 0 | 0 | 0 | 0.2924138000000092 |  | 0 | -555.586220000012 | -555.586220000012 | -0.2
SW | IF-ELPO/PERMIAN | -222.2265221999999 | -38.998451 | -261.2249731999999 | 0 | 0 | 910 | 648.7750268000001 |  | -259350.0000000022 | 74449.1173620006 | -184900.8826380016 | -0.03000000000000025
 | IF-TW/PERMIAN | 3.083274590000001 | 0 | 3.083274590000001 | 0 | 0 | 0 | 3.083274590000001 |  | 0 | -878.7332581500075 | -878.7332581500075 | -0.03000000000000025
 | IF-ELPO/SJ | -81.2771078 | -160.368076 | -241.6451838 | 32.99 | 0 | -220 | -428.6551838 |  | 292600 | 277511.3944540002 | 570111.3944540004 | -0.14
 | IF-EPSJ(BONDAD) | 77.30863579000003 | -59.9527834 | 17.35585239000002 | 0 | 0 | 0 | 17.35585239000002 |  | 0 | -23083.28367870004 | -23083.28367870004 | -0.14
 | IM-TW/SJ | 19.5638752 | -19.7429036 | -0.1790284 | 0 | 0 | 0 | -0.1790284 |  | 0 | 238.1077719999994 | 238.1077719999994 | -0.14
 | TW-THOREAU | -0.3978418000000002 | 0.674342 | 0.2765001999999998 | 0 | 0 | 0 | 0.2765001999999998 |  | 0 | -367.745266 | -367.745266 | -0.14
 | WAHA KCBT | 0 | 112.280927 | 112.280927 | -32.99 | 0 | -390 | -310.709073 |  | 92624.99999999802 | -18831.5951624996 | 73793.40483749843 | -0.02499999999999947
CALI | NGI-MALIN | -258.2391694 | 12.2097676 | -246.0294018 | 0 | 0 | 60 | -186.0294018 |  | -114000 | 467455.8634200003 | 353455.8634200002 | -0.2
 | NGI-PGE/CG | 99.22405472999999 | 159.1387448 | 258.36279953 | 0 | 0 | 50 | 308.36279953 |  | -190000 | -981778.6382140008 | -1171778.638214001 | -0.4
 | NGI-MOJAVE | 0 | 31.721923 | 31.721923 | 0 | 0 | 0 | 31.721923 |  | 0 | -12054.33074000001 | -12054.33074000001 | -0.04
 | PGE/TOPOCK | 11.9352566 | -155.6954234 | -143.7601668 | 0 | 0 | 0 | -143.7601668 |  | 0 | 54628.86338400005 | 54628.86338400005 | -0.04
 | NGI-SOCAL | 127.6575162 | 138.6697792 | 266.3272954 | 0 | 0 | 300 | 566.3272953999999 |  | 285000.000000004 | 253010.9306300036 | 538010.9306300075 | 0.1000000000000014
 | NGI-SOCAL(KRS) | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0.1000000000000014
 |  | -505.1295984899999 | 8.526512829121202e-14 | -505.1295984899999 | 0 | 0 | 31.8 | -473.3295984899999 |  | 393566.0000000006 | 233190.483922655 | 626756.4839226556
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 | -113.2 | -113.2 |  | Financial Curveshift_BOM |  | 393566.0000000006 | 834032 |  | 60886 | 773146
 | Chicago/PEPL/Demarc | 0 | 0 | 0 | 0 | 0 | -260 | -260 |  | Financial Curveshift_Liquidated Day |  | 440466
 | Waha | 0 | 112.280927 | 112.280927 | -32.99 | 0 | -390 | -310.709073
 | Perm, San Juan | -203.9456862199999 | -278.387872 | -433.7821277589999 | 32.99 | 0 | 690 | 289.2078722410001 |  | TDS-New Deals |  |  |  |  |  | 0
 | Aeco, Sumas, [NAME] | 20.23026000000001 | -19.9378462 | 0.2924138000000092 | 0 | 0 | 0 | 0.2924138000000092 |  | TDS-CurveShift |  | -68369175 |  |  | -68366764 | -2411
 | Rockies | -301.9918304 | 0 | -301.9918304 | 0 | 0 | -305 | -606.9918304 |  | Financial Index Curve Changes |  | 0
 | CA/ Scal, CG, Malin | -19.42234187000003 | 186.0447912 | -88.50102168999997 | 0 | 0 | 410 | 321.49897831 |  | First of Month Indices Estimate
 |  |  |  |  |  |  |  |  |  | [NAME]. Financial
 | Flow adjusted position | -505.1295984899999 | 0 | -711.7016390489998 | 0 | 0 | 31.8 | -679.9016390489999 |  | TOTAL Financial |  |  | -67535143 |  | -68305878 | 770735 | -67478023 | Actual Financial P&L
 |  |  |  |  |  |  |  |  |  | Physical_BOM |  | 233190.483922655 | 191946.359273055 |  | 421059 | -229112.640726945
Flow % |  |  |  |  |  |  |  |  |  | Physical_Liquidated Day |  | -41244.12464960005
0.9 | San Juan | Transport detail |  |  |  | LOTS |  |  |  | New Deals |  |  |  |  | 427437 | -427437
0.9 | Permian | [NAME] |  | 19576 | 20 | 39.152 |  |  |  | Changed Deals |  |  |  |  | -568958 | 568958
0.9 | Socal | Socal TOP |  | 24761 | 20 | 49.522 |  |  |  | Long term [NAME] |  | -15643725.47999999 |  |  | -14803723 | -840002.4799999855
 |  | Socal KRS/BAJA OFF |  | 20000 | 20 | 40 |  |  |  | Physical Index Curve Changes |  | 0 |  |  |  | 0
 |  | Mojave TOP |  | 15947 | 20 | 31.894 |  |  |  | Physical Index New Deals |  |  |  |  |  | 0
 |  | Socal TOP/Pasadena |  | 2486 | 20 | 4.972 |  |  |  | TOTAL Physical |  |  | -15451779.12072693 |  | -14524185 | -973500.12072693 | -14478279 | Actual Physical P&L
 |  | Socal KRS / Pasadena |  | 3866 | 20 | 7.732 |  |  |  | TOTAL GD-WEST |  |  | -82986922.12072693
 |  |  |  |  |  | 173.272 |  |  |  |  |  | YEAR TO DATE PHY&FIN
Transport Rates
El Paso |  | GDA |  | Transwestern |  | GDA |  |  |  |  |  | TOTAL GD-NEW | -168461173
San Juan |  | 3.4 |  | San Juan |  | 3.42
Permian |  | 4.12 |  | East of Thoreau |  | 3.51
San Juan-Border |  |  |  | Citizens
Commodity |  | 0.0261 |  | Commodity |  | 0.0253
Fuel (3.88%) |  | 0.13192 |  | Fuel (4.5%) |  | 0.132696
Total Variable |  | 0.15802 |  | Total Variable |  | 0.157996
Permian-Border |  |  |  | [NAME] to EOT
Commodity |  | 0.0435 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.159856 |  | Fuel (1.56%) |  | 0.053352
Total Variable |  | 0.203356 |  | Total Variable |  | 0.070952
San Juan-Waha |  |  |  | San Juan to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.13192 |  | Fuel (1.31%) |  | 0.044802
Total Variable |  | 0.13722 |  | Total Variable |  | 0.062402
Permian-Waha |  |  |  | Thoreau to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0165
Fuel (1.55%) |  | 0.06386 |  | Fuel (1.31%) |  | 0.044802
Total Variable |  | 0.06916 |  | Total Variable |  | 0.061302
San Juan-AZ/Nev |  |  |  | West Texas to EOT
Commodity |  | 0.0289 |  | Commodity |  | 0
Fuel (3.88%) |  | 0.13192 |  | Fuel (1.31%) |  | 0.045981
Total Variable |  | 0.16082 |  | Total Variable |  | 0.045981
Permian-AZ/Nev |  |  |  | IB Link to SJ Pool
Commodity |  | 0.0316 |  | Commodity |  | 0.0011
Fuel (3.88%) |  | 0.159856 |  | Fuel (.25%) |  | 0.00855
Total Variable |  | 0.191456 |  | Total Variable |  | 0.00965
Permian-Waha IT |  |  |  | IB Link to EP I/C
Commodity |  | 0.045 |  | Commodity |  | 0.0033
Fuel (1.55%) |  | 0.06386 |  | Fuel (.25%) |  | 0.00855
 |  | 0.10886 |  | Total Variable |  | 0.01185
Reservation |  |  |  | IB Link to EP I/C IT
 |  |  |  | Commodity |  | 0.04
9KUB | 5.8 | Monthly |  | Fuel (.25%) |  | 0.00855
9KUC | 5.8 | Monthly |  | Total Variable |  | 0.04855
24568 | 0.2125
24654 | 0.2125
26740 | 0.05
24924 | 0.06
26519 | 0.1031
26520 | 0.2082