Spreadsheet: theresa_staab__39643__Independent email
Sheet: Detail

Independent | Contact: | [NAME] |  |  | Enron North America |  |  |  |  |  |  |  | 2001-12-06 14:22:01.170000
2001-11-01 00:00:00 | PH: | [PHONE]
 | FAX: | [PHONE] |  |  | [NAME] | [PHONE]
Btu factor: | 0.9369968710343024
Transportation | 0.35 | per Mcf
IF CIG Rockies | 2.54
IF NGPL Midcont. | 3.04
 |  | Index Discount/Premium | Crestone Transport /Mmbtu | [NAME] | WIC Med.Bow Fuel (0.68%*CIGindex) | [NAME] | [NAME] (0%*NGPL index) | Total Receipts Fee Adjustment* | Total Net Back
Net Backs: | CIG GD | -0.02 | -0.373533798051698 | 0 | 0 | 0 | 0 | -0.01769366896941446 | -0.4112
 | IF NGPL Midcont. | 0.01 | -0.373533798051698 | -0.1347 | -0.017272 | -0.1226 | 0 | -0.01769366896941446 | -0.6558
 | IF CIG Rockies | 0.125 | -0.373533798051698 | -0.1347 | -0.017272 |  |  | -0.01769366896941446 | -0.4182
 |  | Over 80% of Production | CIG GD Volume MMBtu | 80% of Production up to 10,000/Day | NGPL Volume MMBtu | 80% of Production Less 10,000/Day | CIG Volume MMBtu |  | Allocated Fuel MMBtu (max 6.5%) | Total Production MMBtu | $ CIG GD | $ NGPL | $ [NAME] | Total Payment
 | CIG GD Rockies | CIG GD les Netback |  | NGPL less Netback |  | CIG less Netback
2001-11-01 00:00:00 | 2.67 | 2.2588 | 2608 | 2.3842 | 10000 | 2.1218 | 434 |  | -589 | 13631 | 5890.9504 | 23842 | 920.8611999999999 | 30653.8116
2001-11-02 00:00:00 | 2.36 | 1.9488 | 2551 | 2.3842 | 10000 | 2.1218 | 204 |  | -589 | 13344 | 4971.3888 | 23842 | 432.8472 | 29246.236
2001-11-03 00:00:00 | 2.015 | 1.6038 | 2485 | 2.3842 | 9939 | 2.1218 | 0 |  | -583 | 13007 | 3985.443 | 23696.5638 | 0 | 27682.0068
2001-11-04 00:00:00 | 2.015 | 1.6038 | 2596 | 2.3842 | 10000 | 2.1218 | 382 |  | -616 | 13594 | 4163.464800000001 | 23842 | 810.5276 | 28815.9924
2001-11-05 00:00:00 | 2.015 | 1.6038 | 2542 | 2.3842 | 10000 | 2.1218 | 168 |  | -601 | 13311 | 4076.8596 | 23842 | 356.4624 | 28275.322
2001-11-06 00:00:00 | 2.16 | 1.7488 | 2496 | 2.3842 | 9986 | 2.1218 | 0 |  | -608 | 13090 | 4365.004800000001 | 23808.6212 | 0 | 28173.626
2001-11-07 00:00:00 | 2.135 | 1.7238 | 2520 | 2.3842 | 10000 | 2.1218 | 79 |  | -615 | 13214 | 4343.976 | 23842 | 167.6222 | 28353.5982
2001-11-08 00:00:00 | 2.13 | 1.7188 | 2579 | 2.3842 | 10000 | 2.1218 | 314 |  | -607 | 13500 | 4432.785199999999 | 23842 | 666.2452 | 28941.0304
2001-11-09 00:00:00 | 1.935 | 1.5238 | 2607 | 2.3842 | 10000 | 2.1218 | 426 |  | -616 | 13649 | 3972.5466 | 23842 | 903.8868 | 28718.4334
2001-11-10 00:00:00 | 1.7 | 1.2888 | 2587 | 2.3842 | 10000 | 2.1218 | 346 |  | -624 | 13557 | 3334.1256 | 23842 | 734.1428 | 27910.2684
2001-11-11 00:00:00 | 1.7 | 1.2888 | 2618 | 2.3842 | 10000 | 2.1218 | 472 |  | -631 | 13721 | 3374.0784 | 23842 | 1001.4896 | 28217.568
2001-11-12 00:00:00 | 1.7 | 1.2888 | 2602 | 2.3842 | 10000 | 2.1218 | 407 |  | -623 | 13632 | 3353.4576 | 23842 | 863.5726 | 28059.0302
2001-11-13 00:00:00 | 1.52 | 1.1088 | 2605 | 2.3842 | 10000 | 2.1218 | 420 |  | -624 | 13649 | 2888.424 | 23842 | 891.156 | 27621.58
2001-11-14 00:00:00 | 1.595 | 1.1838 | 2575 | 2.3842 | 10000 | 2.1218 | 299 |  | -612 | 13486 | 3048.285 | 23842 | 634.4182 | 27524.7032
2001-11-15 00:00:00 | 1.84 | 1.4288 | 2660 | 2.3842 | 10000 | 2.1218 | 638 |  | -630 | 13928 | 3800.608 | 23842 | 1353.7084 | 28996.3164
2001-11-16 00:00:00 | 1.435 | 1.0238 | 2678 | 2.3842 | 10000 | 2.1218 | 710 |  | -636 | 14024 | 2741.7364 | 23842 | 1506.478 | 28090.2144
2001-11-17 00:00:00 | 1.135 | 0.7238 | 2712 | 2.3842 | 10000 | 2.1218 | 848 |  | -647 | 14207 | 1962.9456 | 23842 | 1799.2864 | 27604.232
2001-11-18 00:00:00 | 1.135 | 0.7238 | 2649 | 2.3842 | 10000 | 2.1218 | 594 |  | -626 | 13869 | 1917.3462 | 23842 | 1260.3492 | 27019.6954
2001-11-19 00:00:00 | 1.135 | 0.7238 | 2721 | 2.3842 | 10000 | 2.1218 | 886 |  | -635 | 14242 | 1969.4598 | 23842 | 1879.9148 | 27691.3746
2001-11-20 00:00:00 | 1.535 | 1.1238 | 2734 | 2.3842 | 10000 | 2.1218 | 937 |  | -635 | 14306 | 3072.4692 | 23842 | 1988.1266 | 28902.5958
2001-11-21 00:00:00 | 2.205 | 1.7938 | 2796 | 2.3842 | 10000 | 2.1218 | 1184 |  | -644 | 14624 | 5015.4648 | 23842 | 2512.2112 | 31369.676
2001-11-22 00:00:00 | 1.43 | 1.0188 | 2805 | 2.3842 | 10000 | 2.1218 | 1218 |  | -649 | 14672 | 2857.734 | 23842 | 2584.3524 | 29284.0864
2001-11-23 00:00:00 | 1.43 | 1.0188 | 2791 | 2.3842 | 10000 | 2.1218 | 1162 |  | -648 | 14601 | 2843.4708 | 23842 | 2465.5316 | 29151.0024
2001-11-24 00:00:00 | 1.43 | 1.0188 | 2777 | 2.3842 | 10000 | 2.1218 | 1109 |  | -649 | 14535 | 2829.2076 | 23842 | 2353.0762 | 29024.2838
2001-11-25 00:00:00 | 1.43 | 1.0188 | 2760 | 2.3842 | 10000 | 2.1218 | 1042 |  | -650 | 14452 | 2811.888 | 23842 | 2210.9156 | 28864.8036
2001-11-26 00:00:00 | 1.43 | 1.0188 | 2725 | 2.3842 | 10000 | 2.1218 | 902 |  | -642 | 14269 | 2776.23 | 23842 | 1913.8636 | 28532.0936
2001-11-27 00:00:00 | 1.88 | 1.4688 | 2652 | 2.3842 | 10000 | 2.1218 | 609 |  | -654 | 13915 | 3895.2576 | 23842 | 1292.1762 | 29029.4338
2001-11-28 00:00:00 | 2.16 | 1.7488 | 2451 | 2.3842 | 9806 | 2.1218 | 0 |  | -615 | 12872 | 4286.308800000001 | 23379.4652 | 0 | 27665.774
2001-11-29 00:00:00 | 2.38 | 1.9688 | 0 | 2.3842 | 0 | 2.1218 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
2001-11-30 00:00:00 | 2.025 | 1.6138 | 0 | 2.3842 | 0 | 2.1218 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | -0.4112 | 0 | 2.3842 | 0 | 2.1218 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 73882 |  | 279731 |  | 15790 |  | -17498 | 386901 | 98980.9166 | 666934.6502 | 33503.222 | 799418.7888
 |  |  |  |  |  |  |  | actual fuel | -0.04522603973626328
 |  |  |  |  |  |  |  |  |  | avg. $/Mmbtu | 1.339716258357922 | 2.3842 | 2.1218 | 2.164083098404723
*Total Receipts Fee Adjustment is calculated by applying the Field Services Fee to the fuel volume and then dividing that dollar amount(fee times fuel volume) by the volume purchased.