Spreadsheet: mike_grigsby__27698__Mike_NCD_Reconciliation_05_09
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 | -124.52 | -124.52 |  | 83202.00000000033 | 0 | 83202.00000000033 | -0.07000000000000028
 | 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.07000000000000028
 | NGI/CHI. GATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.07000000000000028
 | NNG Demarc | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.07000000000000028
 | IF-PAN/TX/OK | 0 | 0 | 0 | 0 | 0 | -286 | -286 |  | 191100.0000000008 | 0 | 191100.0000000008 | -0.07000000000000028
NW | AECOUS | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.04600000000000026
 | SUMAS-US/IM | 1e-08 | 0 | 1e-08 | 0 | 0 | 0 | 1e-08 |  | 0 | 0 | 0 | 0
 | IF-CIG/WIC | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.33
 | IF-CIG/RKYMTN | 2.200000000000001e-07 | 0 | 2.200000000000001e-07 | 0 | 0 | -11 | -10.99999978 |  | 34650 | -0.0006930000000000004 | 34649.99930700001 | -0.33
 | IF-CIG/CHEYENN | 0 | 0 | 0 | 0 | 0 | -33 | -33 |  | 56700 | 0 | 56700 | -0.18
 | IF-CIG/NW-GR | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.09999999999999964
 | IF-NWPL_ROCKY_M | -334.95860838 | 7.30596086 | -327.65264752 | 0 | 0 | 0 | -327.65264752 |  | 0 | 312759.3453600003 | 312759.3453600003 | -0.1
 | IF-KERN/OPAL | -0.09226912000000002 | 0 | -0.09226912000000002 | 0 | 0 | -291.5 | -291.59226912 |  | 278250 | 88.0750690909092 | 278338.0750690912 | -0.1
 | IF-QUESTAR | 3.970155420000001 | -7.30596086 | -3.335805439999999 | 0 | 0 | 0 | -3.335805439999999 |  | 0 | 3184.177920000001 | 3184.177920000001 | -0.1
 | NW-STANFIELD | 22.24599432000001 | -21.92444474 | 0.3215495800000099 | 0 | 0 | 0 | 0.3215495800000099 |  | 0 | -767.3342250000278 | -767.3342250000278 | -0.25
SW | IF-ELPO/PERMIAN | -243.93815996 | -42.88424008 | -286.82240004 | 0 | 0 | 1001 | 714.17759996 |  | -382200 | 109514.0072880001 | -272685.9927120003 | -0.04
 | IF-TW/PERMIAN | 3.390490840000001 | 0 | 3.390490840000001 | 0 | 0 | 0 | 3.390490840000001 |  | 0 | -1294.551048000002 | -1294.551048000002 | -0.04
 | IF-ELPO/SJ | -123.4792849399999 | -176.34708212 | -299.8263670599999 | 36.289 | 0 | -231 | -494.53736706 |  | 396900 | 452805.1124940003 | 849705.1124940006 | -0.18
 | IF-EPSJ(BONDAD) | 85.01163505999997 | -72.70743458 | 12.30420047999998 | 0 | 0 | 0 | 12.30420047999998 |  | 0 | -21140.85355199999 | -21140.85355199999 | -0.18
 | IM-TW/SJ | 21.51321106 | -22.39911344 | -0.885902380000001 | 0 | 0 | 0 | -0.885902380000001 |  | 0 | 1522.141362000009 | 1522.141362000009 | -0.18
 | TW-THOREAU | -0.4374827600000002 | 8.21154994 | 7.774067179999999 | 0 | 0 | 0 | 7.774067179999999 |  | 0 | -13357.26088200001 | -13357.26088200001 | -0.18
 | WAHA KCBT | 0 | 123.46855026 | 123.46855026 | -36.289 | 0 | -429 | -341.82044974 |  | 225224.9999999988 | -45769.26388649976 | 179455.7361134991 | -0.05499999999999972
CALI | NGI-MALIN | -283.9700083000001 | 13.4263437 | -270.5436646000001 | 0 | 0 | 66 | -204.5436646000001 |  | -157500 | 645615.5632500001 | 488115.5632500001 | -0.25
 | NGI-PGE/CG | 110.92174444 | 174.99526088 | 285.9170053199999 | 0 | 0 | 55 | 340.9170053199999 |  | -367500 | -1910445.44463818 | -2277945.444638179 | -0.6999999999999993
 | NGI-MOJAVE | 0 | 34.88268168 | 34.88268168 | 0 | 0 | 0 | 34.88268168 |  | 0 | -199782.6314399999 | -199782.6314399999 | -0.6
 | PGE/TOPOCK | 13.1244806 | -171.20884814 | -158.08436754 | 0 | 0 | 0 | -158.08436754 |  | 0 | 754493.5723499998 | 754493.5723499998 | -0.5
 | NGI-SOCAL | 140.37725659 | 152.48677664 | 292.86403323 | 0 | 0 | 330 | 622.86403323 |  | -1417500 | -1257984.142737953 | -2675484.14273795 | -0.4499999999999993
 | NGI-SOCAL(KRS) | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -0.4499999999999993
 |  | -586.3208449000001 | -5.684341886080801e-14 | -586.3208449000001 | 0 | 0 | 45.98 | -540.3408449000004 |  | -1058673 | -1170559.48800954 | -2229232.488009537
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 | -124.52 | -124.52 |  | Financial Curveshift_BOM |  | -1058673 | -1194218 |  | -1199029 | 4811.000000003027
 | Chicago/PEPL/Demarc | 0 | 0 | 0 | 0 | 0 | -286 | -286 |  | Financial Curveshift_Liquidated Day |  | -135545
 | Waha | 0 | 123.46855026 | 123.46855026 | -36.289 | 0 | -429 | -341.82044974
 | Perm, San Juan | -257.9395907 | -306.12632028 | -506.631454318 | 36.289 | 0 | 770 | 299.657545682 |  | TDS-New Deals |  | -8900.01 |  |  | -8900 | -0.01000000000021828
 | Aeco, Sumas, [NAME] | 22.24599433000001 | -21.92444474 | 0.3215495900000099 | 0 | 0 | 0 | 0.3215495900000099 |  | TDS-CurveShift |  | 8407804 |  |  | 8227574 | 180230
 | Rockies | -331.08072186 | 0 | -331.08072186 | 0 | 0 | -335.5 | -666.58072186 |  | Financial Index Curve Changes |  | 0
 | CA/ Scal, CG, Malin | -19.54652667000011 | 204.58221476 | -95.50817655400013 | 0 | 0 | 451 | 355.4918234459999 |  | First of Month Indices Estimate
 |  |  |  |  |  |  |  |  |  | [NAME]. Financial
 | Flow adjusted position | -586.3208449000001 | 0 | -809.4302528820001 | 0 | 0 | 45.98 | -763.4502528820001 |  | TOTAL Financial |  |  | 7204685.990000003 |  | 7019645 | 185040.990000003 | 7001759 | Actual Financial P&L
 |  |  |  |  |  |  |  |  |  | Physical_BOM |  | -1170559.48800954 | -1205835.073426313 |  | -2125879 | 920043.9265736872
Flow % |  |  |  |  |  |  |  |  |  | Physical_Liquidated Day |  | -35275.58541677269
0.9 | San Juan | Transport detail |  |  |  | LOTS |  |  |  | New Deals |  |  |  |  | 46327 | -46327
0.9 | Permian | [NAME] |  | 19576 | 22 | 43.0672 |  |  |  | Changed Deals |  |  |  |  | 634289 | -634289
0.9 | Socal | Socal TOP |  | 24761 | 22 | 54.4742 |  |  |  | Long term [NAME] |  | 0 |  |  | -859518 | 859518
 |  | Socal KRS/BAJA OFF |  | 20000 | 22 | 44 |  |  |  | Physical Index Curve Changes |  | 0 |  |  |  | 0
 |  | Mojave TOP |  | 15947 | 22 | 35.0834 |  |  |  | Physical Index New Deals |  | -373.18 |  |  | -373 | -0.1800000000000068
 |  | Socal TOP/Pasadena |  | 2486 | 22 | 5.4692 |  |  |  | TOTAL Physical |  |  | -1206208.253426313 |  | -2305154 | 1042162.746573687 | -2248371 | Actual Physical P&L
 |  | Socal KRS / Pasadena |  | 3866 | 22 | 8.5052 |  |  |  | TOTAL GD-WEST |  |  | 5998477.736573691
 |  |  |  |  |  | 190.5992 |  |  |  |  |  | YEAR TO DATE PHY&FIN | -84559313
Transport Rates
El Paso |  | GDA |  | Transwestern |  | GDA |  |  |  |  |  | TOTAL GD-NEW | -78560835.2634263
San Juan |  | 3.5 |  | San Juan |  | 3.52
Permian |  | 4.06 |  | East of Thoreau |  | 3.61
San Juan-Border |  |  |  | Citizens
Commodity |  | 0.0261 |  | Commodity |  | 0.0253
Fuel (3.88%) |  | 0.1358 |  | Fuel (4.5%) |  | 0.136576
Total Variable |  | 0.1619 |  | Total Variable |  | 0.161876
Permian-Border |  |  |  | [NAME] to EOT
Commodity |  | 0.0435 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.157528 |  | Fuel (1.56%) |  | 0.054912
Total Variable |  | 0.201028 |  | Total Variable |  | 0.072512
San Juan-Waha |  |  |  | San Juan to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0176
Fuel (3.88%) |  | 0.1358 |  | Fuel (1.31%) |  | 0.046112
Total Variable |  | 0.1411 |  | Total Variable |  | 0.063712
Permian-Waha |  |  |  | Thoreau to EOT
Commodity |  | 0.0053 |  | Commodity |  | 0.0165
Fuel (1.55%) |  | 0.06293 |  | Fuel (1.31%) |  | 0.046112
Total Variable |  | 0.06823 |  | Total Variable |  | 0.062612
San Juan-AZ/Nev |  |  |  | West Texas to EOT
Commodity |  | 0.0289 |  | Commodity |  | 0
Fuel (3.88%) |  | 0.1358 |  | Fuel (1.31%) |  | 0.047291
Total Variable |  | 0.1647 |  | Total Variable |  | 0.047291
Permian-AZ/Nev |  |  |  | IB Link to SJ Pool
Commodity |  | 0.0316 |  | Commodity |  | 0.0011
Fuel (3.88%) |  | 0.157528 |  | Fuel (.25%) |  | 0.0088
Total Variable |  | 0.189128 |  | Total Variable |  | 0.0099
Permian-Waha IT |  |  |  | IB Link to EP I/C
Commodity |  | 0.045 |  | Commodity |  | 0.0033
Fuel (1.55%) |  | 0.06293 |  | Fuel (.25%) |  | 0.0088
 |  | 0.10793 |  | Total Variable |  | 0.0121
Reservation |  |  |  | IB Link to EP I/C IT
 |  |  |  | Commodity |  | 0.04
9KUB | 5.8 | Monthly |  | Fuel (.25%) |  | 0.0088
9KUC | 5.8 | Monthly |  | Total Variable |  | 0.0488
24568 | 0.2125
24654 | 0.2125
26740 | 0.05
24924 | 0.06
26519 | 0.1031
26520 | 0.2082