Spreadsheet: theresa_staab__39591__enron reconciliation
Sheet: Enron

Per [NAME]:
Original Deal is first 3,500 [NAME] at fixed $2.055
volume above 3,500 at applicable index
If not enough Questar volume @ 2.055 - use CIG volume
Original Verification #????? |  |  |  |  |  |  |  |  |  |  | As Corrected
 | Delivery |  |  |  |  |  |  |  | Questar | CIG |  |  |  |  | ($ Due Entity)
Entity | Period | Sitara # | Pipeline | Point | MMBtu | Price | $ [NAME] | $ Suspense | Index | Index | Point | MMBtu | Price | Total Amount | $ Due ENA
 |  |  |  |  |  |  |  |  | 0.05 | 0.05
Enervest San Juan | 1999-08-01 00:00:00 |  | QUE | Trail Unit MM | 722 | 2.12 | 1530.64 | 0 | 2.125 | 2.165 | Trail Unit MM | 722 | 2.055
 |  |  | QUE | Trail Unit MM | 1749 | 2.12 | 3707.88 | 0 |  |  | Trail Unit MM | 1749 | 2.055
 |  |  | QUE | Lower Nitchie | 56482 | 2.12 | 119741.84 |  |  |  | Lower Nitchie | 56482 | 2.055
 |  |  | QUE | South Baxter | 18058 | 2.125 | 38373.25 |  |  |  | South Baxter | 18058 | 2.055
 |  |  | QUE | South Baxter | 27527 | 2.12 | 58357.24 |  |  |  | South Baxter | 27527 | 2.055
 |  |  | QUE | Trail Unit MM | 14575 | 2.12 | 30899 |  |  |  | Trail Unit MM |  | 2.055
 |  |  | QUE | Trail Unit MM | 386 | 2.12 | 818.32 |  |  |  | Trail Unit MM | 386 | 2.055
 |  |  |  |  |  |  |  |  |  |  | Trail Unit MM | 10999
Days in Month: | 31 |  |  |  |  |  |  |  |  |  |  |  | 2.055
Fixed Volume: | 3500
Total Monthly Volume:
 |  |  |  |  |  |  | 253420.49 |  |  |  | CIG Short |  |  |  | -385
Original Verification #2779SU |  |  |  |  |  |  |  |  |  |  | As Corrected
 | Delivery |  |  |  |  |  |  |  | Questar | CIG |  |  |  |  | ($ Due Entity)
Entity | Period | Sitara # | Pipeline | Point | MMBtu | Price | $ [NAME] | $ Suspense | Index | Index | Point | MMBtu | Price | Total Amount | $ Due ENA
 |  |  |  |  |  |  |  |  | 0.05 | 0.01
Enervest San Juan | 1999-09-01 00:00:00 | 104326 | QUE | Lower Nitchie | 56100 | 2.48 | 139128 | 0 | 2.485 | 2.53 | Lower Nitchie | 56100 | 2.055
 |  | 109654 | CIG | [NAME] | 12390 | 2.055 | 25461.45 | 0 |  |  | [NAME] |  | 2.055
 |  | 104326 | QUE | South Baxter | 20298 | 2.48 | 50339.04 | 0 |  |  | South Baxter | 20298 | 2.055
 |  | 104326 | QUE | Trail Unit MM | 18570 | 2.48 | 46053.6 | 0 |  |  | Trail Unit MM |  | 2.53
 |  |  |  |  |  |  |  |  |  |  | Trail Unit MM | 8790 | 2.055
 |  |  |  |  |  |  |  |  |  |  | Trail Unit MM | 7422 | 2.055
 |  | 109654 | CIG | [NAME] | 8790 | 2.53 | 22238.7 | 0 |  |  | [NAME] | 8790 | 2.53
Days in Month: | 30 |  |  |  |  |  |  |  |  |  |  |  | 2.055
Fixed Volume: | 3500
Total Monthly Volume:
 |  |  |  |  |  |  | 288393.22
Original Verification #3484SU |  |  |  |  |  |  |  |  |  |  | As Corrected
 | Delivery |  |  |  |  |  |  |  | Questar | CIG |  |  |  |  | ($ Due Entity)
Entity | Period | Sitara # | Pipeline | Point | MMBtu | Price | $ [NAME] | $ Suspense | Index | Index | Point | MMBtu | Price | Total Amount | $ Due ENA
 |  |  |  |  |  |  |  |  | 0.01 | 0.01
Enervest San Juan | 1999-10-01 00:00:00 | 104326 | QUE | Lower Nitchie | 27962 | 2.34 | 65431.08 | 0 | 2.35 | 2.36 | Lower Nitchie | 27962 | 2.055
 |  | 104326 | QUE | South Baxter | 62411 | 2.34 | 146041.73 | 0 |  |  | South Baxter | 62411 | 2.055
 |  | 104326 | QUE | Trail Unit MM | 18352 | 2.34 | 42943.68 | 0 |  |  | Trail Unit MM |  | 2.055
 |  | 118311 | CIG | [NAME] | 31966 | 2.36 | 75439.76 | 0 |  |  | Trail Unit MM | 876
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 31966
 |  | 117739 | QUE | Lower Nitchie | 651 | 2.35 | 1529.85 | 0 |  |  | Lower Nitchie | 651 | 2.055
Days in Month: | 31
Fixed Volume: | 3500
Total Monthly Volume:
Original Verification #4511SU & 4507SU |  |  |  |  |  |  |  |  |  |  | As Corrected
 | Delivery |  |  |  |  |  |  |  | Questar | CIG |  |  |  |  | ($ Due Entity)
Entity | Period | Sitara # | Pipeline | Point | MMBtu | Price | $ [NAME] | $ Suspense | Index | Index | Point | MMBtu | Price | Total Amount | $ Due ENA
 |  |  |  |  |  |  |  |  |  | 0.015
Enervest San Juan | 1999-11-01 00:00:00 | 104326 | QUE | Lower Nitchie | 43200 | 2.82 | 121824 | 0 | 2.82 | 2.845 | Lower Nitchie | 43200 | 2.055
 |  | 104326 | QUE | South Baxter | 61926 | 2.82 | 174631.32 | 0 |  |  | South Baxter |  | 2.055
 |  |  |  |  |  |  |  |  |  |  | South Baxter | 17730 | 2.82
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 24999
 |  |  |  |  |  |  |  |  |  |  | Lower Nitchie | 1290 | 2.055
 |  |  |  |  |  |  |  |  |  |  | Vermillion Plt | 16314 | 2.055
 |  |  |  |  |  |  |  |  |  |  | Lower Nitchie
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Vermillion Plt
Enervest Energy L.P. |  | 124908 | CIG | [NAME] | 24999 | 2.845 | 71122.15
 |  | 124911 | QUE | Lower Nitchie | 1290 | 2.845 | 3670.05
 |  | 124911 | QUE | Vermillion Plt | 16314 | 2.845 | 46413.33
Days in Month: | 30
Fixed Volume: | 3500
Total Monthly Volume:
 |  |  |  |  |  |  | 414133.27
Original Verification - |  |  |  |  |  |  |  |  |  |  | As Corrected
 | Delivery |  |  |  |  |  |  |  | Questar | CIG |  |  |  |  | ($ Due Entity)
Entity | Period | Sitara # | Pipeline | Point | MMBtu | Price | $ [NAME] | $ Suspense | Index | Index | Point | MMBtu | Price | Total Amount | $ Due ENA
Enervest San Juan | 1999-12-01 00:00:00 | 132169 | QUE | Vermillion Plt | 14356 | 1.99 | 28568.44 | 0 | 1.99 | 2.04 | Vermillion Plt | 14356 | 1.99
 |  | 133509 | QUE | Lower Nitchie | 45725 | 2.0525 | 93850.56 | 0 |  |  | Lower Nitchie | 45725 | 2.055
 |  | 133509 | QUE | South Baxter | 60791 | 2.0525 | 124773.53 | 0 |  |  | South Baxter | 60791 | 2.055
 |  | 133509 | QUE | Vermillion Plt | 1984 | 2.0525 | 4070.16 | 0 |  |  | Vermillion Plt | 1984 | 2.055
 |  |  |  |  |  |  |  | 0
Days in Month: | 31
Fixed Volume: | 3500
Total Monthly Volume:
 |  |  |  |  |  |  | 0
Original Verification #6463SU |  |  |  |  |  |  |  |  |  |  | As Corrected
 | Delivery |  |  |  |  |  |  |  | Questar | CIG |  |  |  |  | ($ Due Entity)
Entity | Period | Sitara # | Pipeline | Point | MMBtu | Price | $ [NAME] | $ Suspense | Index | Index | Point | MMBtu | Price | Total Amount | $ Due ENA
Enervest San Juan | 2000-01-01 00:00:00 | 145139 | CIG | [NAME] | 31785 | 2.17 | 68973.45 | 0 | 2.175 | 2.17 | [NAME] | 31785 | 2.17
 |  | [NAME] |  | [NAME] |  |  | -402.5 | 0 |  |  | Questar | 108500 | 2.055
 |  |  |  |  |  |  |  |  |  |  | Questar | 36032 | 2.175
 |  |  |  |  |  |  |  |  |  |  |  |  | 2.83
 |  |  |  |  |  |  |  |  |  |  |  |  | 2.055
 |  |  |  |  |  |  |  |  |  |  |  |  | 2.055
Days in Month: | 31
Fixed Volume: | 3500
Total Monthly Volume:
 |  |  |  |  |  |  | 369477.32
Original Verification #8053SU |  |  |  |  |  |  |  |  |  |  | As Corrected
 | Delivery |  |  |  |  |  |  |  | Questar | CIG |  |  |  |  | ($ Due Entity)
Entity | Period | Sitara # | Pipeline | Point | MMBtu | Price | $ [NAME] | $ Suspense | Index | Index | Point | MMBtu | Price | Total Amount | $ Due ENA
 |  |  |  |  |  |  |  |  | 0.02
Enervest San Juan | 2000-02-01 00:00:00 | 156499 | CIG | [NAME] | 15641 | 2.34 | 36599.94 | 0 | 2.35 | 2.34 | [NAME] | 15641 | 2.34
 |  | [NAME] |  | [NAME] |  |  | -997.5 | 0 |  |  | Lower Nitchie |  | 2.055
 |  | 133509 | QUE | Lower Nitchie | 36830 | 2.0525 | 75593.58 |  |  |  | Lower Nitchie | 7905
 |  | 133509 | QUE | South Baxter | 54709 | 2.0525 | 112290.22 |  |  |  | South Baxter | 54709 | 2.055
 |  | 133509 | QUE | Vermillion Plt | 9723 | 2.0525 | 19956.46 |  |  |  | Vermillion Plt | 9723 | 2.055
 |  | 156518 | QUE | Lower Nitchie | 1529 | 2.35 | 3593.15 |  |  |  | Lower Nitchie | 1529 | 2.055
 |  | 156518 | QUE | Ques/WIC Kanda | 1044 | 2.35 | 2453.4 |  |  |  | Ques/WIC Kanda | 1044 | 2.055
 |  | 156518 | QUE | Ques/WIC Kanda | 346 | 2.35 | 813.1 |  |  |  | Ques/WIC Kanda | 346 | 2.055
 |  | 156518 | QUE | Vermillion Plt | 5224 | 2.35 | 12276.4 |  |  |  | Vermillion Plt | 5224 | 2.055
Days in Month: | 29
Fixed Volume: | 3500
Total Monthly Volume:
Original Verification #9891SU & 9892SU |  |  |  |  |  |  |  |  |  |  | As Corrected
 | Delivery |  |  |  |  |  |  |  | Questar | CIG |  |  |  |  | ($ Due Entity)
Entity | Period | Sitara # | Pipeline | Point | MMBtu | Price | $ [NAME] | $ Suspense | Index | Index | Point | MMBtu | Price | Total Amount | $ Due ENA
 |  |  |  |  |  |  |  |  | 0.0175
Enervest San Juan | 2000-03-01 00:00:00 | 133509 | QUE | Lower Nitchie | 41819 | 2.0525 | 85833.5 | 0 | 2.3175 | 2.31 | Lower Nitchie | 41819 | 2.055
 |  | 133509 | QUE | South Baxter | 53148 | 2.0525 | 109086.27 | 0 |  |  | South Baxter |  | 2.055
 |  | [NAME] | QUE | South Baxter |  |  | -463.86 |  |  |  | South Baxter | 2432
 |  | 133509 | QUE | Vermillion Plt | 6866 | 2.0525 | 14092.47 |  |  |  | Vermillion Plt | 6866 | 2.055
Enervest Energy |  | 205685 | CIG | [NAME] | 24893 | 2.31 | 57502.83 |  |  |  | [NAME] | 24893 | 2.31
 |  | 205731 | QUE | Vermillion Plt | 9099 | 2.3175 | 21086.93 |  |  |  | Vermillion Plt | 9099 | 2.055
Days in Month: | 31
Fixed Volume: | 3500
Total Monthly Volume:
 |  |  |  |  |  |  | 286501.49
Original Verification #9891SU & 9892SU (#13366SU Revised) |  |  |  |  |  |  |  |  |  |  | As Corrected
 | Delivery |  |  |  |  |  |  |  | Questar | CIG |  |  |  |  | ($ Due Entity)
Entity | Period | Sitara # | Pipeline | Point | MMBtu | Price | $ [NAME] | $ Suspense | Index | Index | Point | MMBtu | Price | Total Amount | $ Due ENA
Enervest San Juan | 2000-04-01 00:00:00 | 133509 | QUE | Lower Nitchie | 23430 | 2.0525 | 48090.08 | 0 | 2.62 | 2.675 | Lower Nitchie | 23430 | 2.055
 |  | 133509 | CIG | [NAME] | 4260 | 2.0525 | 8743.66 | 0 |  |  | [NAME] | 4260 | 2.675
 |  | 133509 | QUE | South Baxter | 60348 | 2.0525 | 123864.28 |  |  |  | South Baxter | 60348 | 2.055
 |  | [NAME] | QUE | South Baxter |  |  | -6321.7 |  |  |  | South Baxter
 |  | 133509 | QUE | Vermillion Plt | 15177 | 2.0525 | 31150.79 |  |  |  | Vermillion Plt | 15177 | 2.055
 |  | 230989 | CIG | [NAME] | 25890 | 2.65 | 68608.5 |  |  |  | [NAME] |  | 2.675
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 6045 | 2.055
 | Revised | 133509 | QUE | Lower Nitchie | 22536 | 2.0525 | 46255.14
 | Revised | Reverse 133509 | QUE | Lower Nitchie | -9372 | 2.0525 | -19236.03
 | Revised | Reverse 133509 | QUE | Lower Nitchie | -8591 | 2.0525 | -17633.03
 | Revised | Reverse 133509 | QUE | Lower Nitchie | -5467 | 2.0525 | -11221.02
 | Revised | 133509 | QUE | South Baxter | 58158 | 2.0525 | 119369.31
 | Revised | Reverse 133509 | QUE | South Baxter | -24744 | 2.0525 | -50787.06
 | Revised | Reverse 133509 | QUE | South Baxter | -22682 | 2.0525 | -46554.81
 | Revised | Reverse 133509 | QUE | South Baxter | -12922 | 2.0525 | -26522.41
 | Revised | 133509 | QUE | Vermillion Plt | 5664 | 2.0525 | 11625.36
 | Revised | Reverse 133509 | QUE | Vermillion Plt | -5665 | 2.0525 | -11627.41
Days in Month: | 30
Fixed Volume: | 3500
Total Monthly Volume:
 |  |  |  |  |  |  | 274135.61
Original Verification #12907SU & 12881SU |  |  |  |  |  |  |  |  |  |  | As Corrected
 | Delivery |  |  |  |  |  |  |  | Questar | CIG |  |  |  |  | ($ Due Entity)
Entity | Period | Sitara # | Pipeline | Point | MMBtu | Price | $ [NAME] | $ Suspense | Index | Index | Point | MMBtu | Price | Total Amount | $ Due ENA
Enervest San Juan | 2000-05-01 00:00:00 | 133509 | QUE | Lower Nitchie | 39798 | 2.0525 | 81685.41 | 0 | 2.62 | 2.61 | Lower Nitchie | 39798 | 2.055
 |  | 133509 | QUE | South Baxter | 33889 | 2.0525 | 69557.19 | 0 |  |  | South Baxter | 33889 | 2.055
 |  | 133509 | QUE | Vermillion Plt | 10059 | 2.0525 | 20646.1 |  |  |  | Vermillion Plt | 10059 | 2.055
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 24754 | 2.055
Enervest Energy |  | 254551 | CIG | [NAME] | 37776 | 2.61 | 98595.36 |  |  |  | [NAME] |  | 2.61
Days in Month: | 31
Fixed Volume: | 3500
Total Monthly Volume:
 |  |  |  |  |  |  | 277623.13
Original Verification #14867SU |  |  |  |  |  |  |  |  |  |  | As Corrected
 | Delivery |  |  |  |  |  |  |  | Questar | CIG |  |  |  |  | ($ Due Entity)
Entity | Period | Sitara # | Pipeline | Point | MMBtu | Price | $ [NAME] | $ Suspense | Index | Index | Point | MMBtu | Price | Total Amount | $ Due ENA
Enervest San Juan | 2000-06-01 00:00:00 | 133509 | CIG | [NAME] | 38391 | 2.0525 | 78797.53 | 0 | 3.41 | 3.62 | [NAME] |  | 2.055
 |  | 133509 | QUE | Lower Nitchie | 38382 | 2.0525 | 78779.06 | 0 |  |  | [NAME] | 8743 | 3.62
 |  | 133509 | QUE | South Baxter | 24446 | 2.0525 | 50175.42 | 0 |  |  | Lower Nitchie | 38382 | 2.055
 |  | 133509 | QUE | Vermillion Plt | 12524 | 2.0525 | 25705.51 | 0 |  |  | South Baxter | 24446 | 2.055
 |  |  |  |  |  |  |  |  |  |  | Vermillion Plt | 12524 | 2.055
Days in Month: | 30
Fixed Volume: | 3500
Total Monthly Volume:
Original Verification #16184SU & 16575SU |  |  |  |  |  |  |  |  |  |  | As Corrected
 | Delivery |  |  |  |  |  |  |  | Questar | CIG |  |  |  |  | ($ Due Entity)
Entity | Period | Sitara # | Pipeline | Point | MMBtu | Price | $ [NAME] | $ Suspense | Index | Index | Point | MMBtu | Price | Total Amount | $ Due ENA
Enervest San Juan | 2000-07-01 00:00:00 | 133509 | QUE | Lower Nitchie | 48546 | 2.0525 | 99640.67 | 0 | na | 3.86 | Lower Nitchie | 48546 | 2.055
 |  | 133509 | QUE | South Baxter | 26174 | 2.0525 | 53722.14 | 0 |  |  | South Baxter | 26174 | 2.055
 |  | 133509 | QUE | Vermillion Plt | 14415 | 2.0525 | 29586.79 | 0 |  |  | Vermillion Plt | 14415 | 2.055
 |  | 133509 | CIG | [NAME] | 19365 | 2.0525 | 39746.66 | 0 |  |  | [NAME] | 19365 | 2.055
Enervest Energy |  | 318194 | CIG | [NAME] | 15837 | 3.86 | 61130.82 |  |  |  | [NAME] | 15837 | 3.86
Days in Month: | 31
Fixed Volume: | 3500
Total Monthly Volume:
 |  |  |  |  |  |  |  |  |  |  |  |  | Net Due Enron
 |  |  |  |  |  |  |  |  |  |  |  |  | June 1999 Shortage |  | -780.44