Spreadsheet: lindy_donoho__21998__2000 2001 Rate Summary
Sheet: 2001

DAYS OF MONTH | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 365 |  |  |  |  |  | 365 | 365
 | 5 | 2
[NAME]
2001 FORECAST
MARGIN SUMMARY
H:\USER\JMOORE\[2001 Plan.xls]2001
2002-02-07 13:13:56.960000
 | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL | 1Qtr | 2Qtr | 3Qtr | 4Qtr
TOTAL DEMAND VOL WEST
WEST DEMAND REVENUE | 8948 | 13940 | 3508.2 | 8274.6 | 8917 | 8393.2 | 8902.2 | 8962 | 8684.6 | 9021.2 | 7634.5 | 8001
TOTAL DEMAND VOL EAST
EAST DEMAND REVENUE | 1401 | 1139 | 1687.1 | 1211.8 | 1321.2 | 1460.8 | 1473 | 1264.2 | 1184 | 1252 | 1530.6 | 1485.6 | 16410.3
TOTAL DEMAND VOL IGNACIO/BLANCO
IGNACIO DEMAND REVENUE | 747 | 636 | 766.6 | 874.1 | 896.5 | 807.9 | 812.6 | 864 | 870.5 | 627.2 | 732.1 | 744 | 9378.5
TOTAL DEMAND VOL SAN JUAN
TSPT MARGIN  PER  MMBTU
WEST: THOREAU
DEMAND | 0.3029823493609251 | 0.3029649595687331 | 0.3029945222154595 | 0.3029811320754717 | 0.3024602376654997 | 0.3059501202683884 | 0.3312701362244829 | 0.3442508990281138 | 0.3025833021340322 | 0.2857593546133652 | 0.2533831022633014 | 0.2702990805906508 | 0.2997570405571318
FTS | 0.02466868878411251 | 0.02471670272099685 | 0.02467289432914576 | 0.02882496425267054 | 0.02911824092590982 | 0.02865725443075999 | 0.02897686112413176 | 0.04525224961829582 | 0.02933431770641073 | 0.02981942743069733 | 0.02870218258624736 | 0.02859793191721916 | 0.02883365705692578
FR | 0.02555327760097967 | 0.0252987785749704 | 0.02543928665093102 | 0.02542955326460481 | 0.02430555555555556 | 0.02426666666666667 | 0.02478045387357621 | 0.02415914764797232 | 0.0253968253968254 | 0.02531592949783838 | 0.02580645161290323 | 0 | 0.02499652441886341
ITS | 1.756912442396313 | 0.0465316758260597 | 0.2205551387846962 | 0.2733138969873664 | 0.5892747072118348 | 0.5138254247217341 | 0.2817836812144212 | 0.233822091886608 | 0.1760665220535068 | 0.209936173883043 | 0.1234848484848485 | 0.2613561553653719 | 0.3523842823929313
WEST: EAST OF THOREAU
DEMAND | 0.2813013567140161 | 0.4425377622146702 | -0.01487766482563569 | 0.2683549409392106 | 0.2869853483305523 | 0.2683062880324544 | 0.2884601444224496 | 0.2860590320351339 | 0.290648228176318 | 0.2907965539353723 | 0.2573253420510958 | 0.2525180893078497 | 0.264864434375679
FTS | 0.02687640702631604 | 0.02740038897945749 | 0.02737935895709749 | 0.02712606837606838 | 0.02731227611904465 | 0.02733987844787283 | 0.02740125217452734 | 0.0322244097800663 | 0.0280624859518993 | 0.02803180439817578 | 0.02806802721088435 | 0.02780135823429542 | 0.0279269894330473
FR | 0.03421517237603842 | 0.03252996371101826 | 0.03297491039426523 | 0.0328125 | 0.03311827956989247 | 0.03333333333333333 | 0.0329593267882188 | 0.03297491039426523 | 0.03333333333333333 | 0.0329593267882188 | 0.03333333333333333 | 0.03225806451612903 | 0.03300686133484354
ITS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4032258064516129 | 0.375 | 0 | 0 | 0 | 0.001638428801393757
WEST:  IGNACIO
DEMAND | 0.1612903225806452 | 0.1565476190476191 | 0.1569354838709677 | 0.1591666666666667 | 0.1578494623655914 | 0.1576666666666667 | 0.1570430107526882 | 0.1572043010752688 | 0.1578333333333334 | 0.156505376344086 | 0.1568888888888889 | 0.161505376344086 | 0.1580621825457904
FTS | 0.01840410433178486 | 0.01886264344736105 | 0.01855943437914273 | 0.01858540255831452 | 0.01860817826518112 | 0.0186046511627907 | 0.01860827901275837 | 0.01860177587950995 | 0.01859205776173285 | 0.01852549948839464 | 0.0185122089721749 | 0.01849462365591398 | 0.0185829992693075
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
WEST:  SAN JUAN
DEMAND | 0.1658584580785719 | 0.7041396103896104 | 0.1684922788329481 | 0.1670668058455115 | 0.1699903333213992 | 0.1689905591866376 | 0.1778923741861285 | 0.1689858739194603 | 0.1691539578794481 | 0.1631065049320181 | 0.1637429882712902 | 0.1618698087695577 | 0.2096004310087666
FTS | 0.01863178223746207 | 0.01890781138595359 | 0.01893124796350603 | 0.01861365953109072 | 0.01858939311098961 | 0.01860240030971738 | 0.01859154929577465 | 0.02797636346023443 | 0.01858706467661692 | 0.01848415643733942 | 0.01849912739965096 | 0.01899789838876472 | 0.01942084142038198
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS | 0 | 0 | 0 | 0 | 0 | -0.01937984496124031 | 0 | 0 | 0.0962962962962963 | 0 | 0 | 0.09677419354838708 | -0.05429638854296387
EAST:  WEST OF THOREAU
DEMAND | 0.008064516129032258 | 0.007589285714285714 | 0.007495649846071477 | 0.02279166666666667 | 0.009919354838709678 | 0.01808333333333333 | 0.01612903225806452 | 0.01088709677419355 | 0.01429166666666667 | 0.0075 | 0.025 | 0.025 | 0.01444462505340351
FTS | 0.008961818173671076 | 0.0118468440007582 | 0.009925558312655087 | 0.01156462585034014 | 0 | 0.01165755919854281 | 0 | 0 | 0 | 0.01612903225806452 | 0.01047619047619048 | 0 | 0.008308794364263478
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS | 0 | 0 | 0.4066471163245357 | 0.2896825396825397 | 0 | 0.04985754985754986 | 0.08960573476702509 | 0 | 0 | 0 | 2.080952380952381 | 0 | 0.2086613585097324
EAST:  EAST TO EAST
DEMAND | 0.03029529821138107 | 0.03114834717103056 | 0.04861094747755602 | 0.02854255825011888 | 0.032999760375184 | 0.04750439367311072 | 0.0402595875492046 | 0.02954989544410545 | 0.02734779987944545 | 0.02880324316454917 | 0.04056962025316456 | 0.04224415405078843 | 0.03610580438793436
FTS | 0.009633807847773979 | 0.009368418685873176 | 0.009684098043144327 | 0.00955898813521379 | 0.01017443407371143 | 0.01011337868480726 | 0.01008379634764896 | 0.01049937003779773 | 0.0102056034941941 | 0.009741080850098982 | 0.009801876955161626 | 0.009482927278376855 | 0.009905951040605175
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS | 0.07579500948166416 | 0.08038585209003214 | 0.06523697963597046 | 0.07129094412331406 | 0.06743394391311396 | 0.05263888888888889 | 0.04904097646033129 | 0.05529953917050692 | 0.08717948717948718 | 0.05310173697270471 | 0.07358490566037736 | 0.05549774540409295 | 0.06660499766599721
EAST:  IGNACIO TO EAST
DEMAND | 0.207258064516129 | 0.20625 | 0.2070161290322581 | 0.2060833333333333 | 0.2066129032258064 | 0.2069166666666667 | 0.207258064516129 | 0.2070161290322581 | 0.207 | 0.2069354838709678 | 0.207 | 0.2070161290322581 | 0.2068698630136986
FTS | 0.01152553963537034 | 0.01696318310738374 | 0.01177963030083364 | 0.01107456140350877 | 0.01080727034550516 | 0.01095238095238095 | 0.01185335704004741 | 0.01218637992831541 | 0.01146953405017921 | 0.01259941024037173 | 0.01298701298701299 | 0 | 0.0119714499770724
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS | 0.218205622431538 | 0.2241843139959991 | 0.2903225806451613 | 0 | 0.217921146953405 | 0.2152173913043479 | 0.2580645161290323 | 0.2165898617511521 | 0 | 0 | 0 | 0 | 0.2203191509652231
EAST: SAN JUAN
DEMAND | 0.1803519061583578 | 0.1496428571428572 | 0.123258064516129 | 0.1432 | 0.1490322580645161 | 0.1194 | 0.1474193548387097 | 0.1494516129032258 | 0.1492 | 0.1491612903225806 | 0.1484759095378564 | 0.135 | 0.1457754031595246
FTS | 0.01102689017437924 | 0.01035101223489646 | 0.01076962153924308 | 0.0112225405921681 | 0.01132236701559496 | 0.01167279411764706 | 0.01161290322580645 | 0.01177468280113507 | 0.0118407960199005 | 0.01163045863506693 | 0.01175608326004104 | 0.01028576002561434 | 0.01133766212873494
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS | 0.2853012781497261 | 0.2128153536604241 | 0.2153443766346992 | 0.2166666666666666 | 0.2198641765704584 | 0.2148148148148148 | 0.2016129032258064 | 0.2580645161290323 | 0 | 0 | 0 | 0 | 0.2178916371018804
IGNACIO TO BLANCO HUB
DEMAND | 0.05027077937367554 | 0.04053701772679875 | 0.04565575700494467 | 0.04566909975669099 | 0.04569107605368496 | 0.04579075425790754 | 0.04348161963515169 | 0.04120821515676559 | 0.04818079096045198 | 0.0376158053354169 | 0.03886323268206039 | 0.04802354434762537 | 0.04425141550345795
FTS | 0.001083963104605827 | 0.001171051375780433 | 0.001095304882121151 | 0.001098505312443724 | 0.001096897787665307 | 0.001093951093951094 | 0.003297552360716355 | 0.003297094991980039 | 0.003632567849686848 | 0.001098997165086858 | 0.001099163679808841 | 0.001094861067892911 | 0.001691653479913248
FR | 0.002150537634408602 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.001111111111111111 | 0.001075268817204301 | 0.001101176056027838
ITS | 0.03112279001665777 | 0.1025463036001641 | 0.0935483870967742 | 0.1010416666666667 | 0.1028225806451613 | 0.1028985507246377 | 0.04268074691307098 | 0.0309815421769881 | 0.3458333333333333 | 0.09677419354838708 | 0 | 0.1035653650254669 | 0.04758164539277555
IGNACIO TO EL PASO BLANCO
DEMAND | 0.03868090849366267 | 0.04184050861579754 | 0.04189014343061254 | 0.05011556627474625 | 0.05382343288480472 | 0.04915698336750968 | 0.04398444888094988 | 0.05154985814857624 | 0.04989327041905404 | 0.03179786115007013 | 0.04301384451544196 | 0.03453287415879434 | 0.04431063736453483
FTS | 0.003290897665012122 | 0.00331977456919889 | 0.003304263858293853 | 0.003302703422559595 | 0.003305545487495469 | 0.003288121660501438 | 0.001096591428310335 | 0.001096798566849873 | 0.003304389773275446 | 0.003198214016956805 | 0.003198031980319803 | 0.003201911589008363 | 0.002875320258578113
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS | 0.03685835243773833 | 0.04799833723191387 | 0.05190783410138249 | 0.04727564102564103 | 0.057099856751709 | 0.04810547875064005 | 0.1209677419354839 | 0.1031928900592495 | 0.01626429479034307 | 0.0218148062195405 | 0.04290206648697215 | 0.02952928564467401 | 0.04298460734756034
SAN JUAN TO THOREAU:
DEMAND | 0.04266389177939646 | 0.03218125960061444 | 0.0265071106486299 | 0.03079569892473118 | 0.03204994797086368 | 0.02567741935483871 | 0.03350439882697947 | 0.03220939933259177 | 0.03203091455560327 | 0.03092707657528108 | 0.0324731182795699 | 0.0232258064516129 | 0.03117685395904694
FTS | 0.002194898981603454 | 0.001772349161807745 | 0.001556728813434863 | 0.003774190958002088 | 0.003864769526656884 | 0.003514111787493083 | 0.003691323339417181 | 0.004080294775866356 | 0.004188665962689194 | 0.004095736459782296 | 0.003018669075579644 | 0.001770301640112142 | 0.002978312586894787
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS | 0 | 0.04921788309410459 | 1.991935483870968 | 0.3219047619047619 | 0.2610887096774193 | -0.08992248062015504 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1998711367926992
SAN JUAN DEMAND REVENUE | 1516 | 1370 | 1516.458 | 1467.7 | 1516.458 | 1467.54 | 1514 | 1486.7 | 1483.3 | 1500.7 | 1498.2 | 1548.3 | 17885.356