Spreadsheet: james_steffes__12981__Savings_Analysis
Sheet: 1-Yr Price Strips

 | Fforward Price of Electricity Indicative Prices as of 042701
 | Peak |  |  |  |  | [NAME] |  |  |  |  | Flat: All Hours
1-yr Strips | Mid-Columbia | California-Oregon Border (COB) | California Northern Zone (NP-15) | California Southern Zone (SP-15) | Palo Verde | Mid-Columbia | California-Oregon Border (COB) | California Northern Zone (NP-15) | California Southern Zone (SP-15) | Palo Verde | Mid-Columbia | California-Oregon Border (COB) | California Northern Zone (NP-15) | California Southern Zone (SP-15) | Palo Verde
2001-07-01 00:00:00 | 142.000000528991 | 141.999999735504 | 136.000000506639 | 130.000000484287 | 158 | 79.9999993615026 | 84.9999991209181 | 84.9999992636054 | 66.999999508435 | 64.9999995242025 | 113.333333322518 | 115.645160741663 | 112.419354770613 | 100.870967775022 | 114.999999780008
2001-08-01 00:00:00 | 169.999998100101 | 177.000000329688 | 154.99999826774 | 154.99999826774 | 179.999999329447 | 110.000000332411 | 115.000000050721 | 93.0000002487348 | 79.0000001444266 | 69.9999998968381 | 144.83870871365 | 151.000000212702 | 128.999999098479 | 123.129031312802 | 133.870967309321
2001-09-01 00:00:00 | 124.999999068677 | 128 | 124.999999068677 | 119.99999910593 | 120 | 97.9999992698431 | 109.999999384795 | 89.9999993294477 | 67.9999994933605 | 64.9999997072986 | 112.399999162555 | 119.599999712904 | 108.666665857037 | 95.7333326200644 | 94.3333331967394
2001-10-01 00:00:00 | 105.000001564621 | 110.000000409781 | 85.0000012665987 | 83.0000012367963 | 92.0000003427267 | 99.9999996160085 | 100.000000063043 | 79.9999996962456 | 64.9999998011268 | 55.0000000527272 | 102.903226553913 | 105.806451877279 | 82.9032264145151 | 75.4516135379672 | 76.4838711888559
2001-11-01 00:00:00 | 103 | 103.000000383704 | 67 | 62 | 62.0000002309679 | 89.999999473337 | 95.0000000719447 | 64.9999996093101 | 49.999999714084 | 45.0000000433064 | 97.2222219881498 | 99.4444446895892 | 66.1111109374712 | 56.6666665395929 | 54.4444445920073
2001-12-01 00:00:00 | 140 | 139.000000517815 | 82 | 65 | 56.0000002086162 | 99 | 122.00000010838 | 75 | 50 | 45.0000000436639 | 121.043010752688 | 131.139785274743 | 78.7634408602151 | 58.0645161290323 | 50.9139786269716
2002-01-01 00:00:00 | 125.999999530613 | 122.000000454485 | 89.9999996647238 | 64.9999997578561 | 56.0000002086162 | 85.9999994451135 | 100.000000083138 | 64.9999995770433 | 56.9999996196115 | 42.0000000381615 | 108.365590890769 | 112.30107555959 | 78.9784942497249 | 61.4731179764795 | 49.8279571227169
2002-02-01 00:00:00 | 95 | 101.999998860061 | 80 | 45 | 51.9999994188547 | 70.9999995889763 | 97.0000004060566 | 46.9999997491638 | 42.9999997355044 | 35.0000000993411 | 84.7142855381327 | 99.8571423797735 | 65.8571427496416 | 44.1428570295019 | 44.7142854247774
2002-03-01 00:00:00 | 64.9999997578561 | 75.9999991506338 | 54.999999795109 | 39.9999998509883 | 42.9999995194375 | 55.0000002768981 | 58.0000001731806 | 48.0000002451877 | 40.0000002162486 | 30.0000000770045 | 60.5913978361435 | 68.0645157304663 | 51.9139784881545 | 40.0000000120171 | 37.2688169695477
2002-04-01 00:00:00 | 57 | 60.9999993182718 | 43 | 40 | 42.9999995194375 | 46.0000002756714 | 46.0000001633246 | 41.0000002548883 | 38.0000002360658 | 30.0000000970536 | 52.3555556719502 | 54.6666663417386 | 42.1555556631751 | 39.1555556552278 | 37.511110874431
2002-05-01 00:00:00 | 47 | 53.0000001974403 | 43 | 44 | 43.0000001601874 | 38 | 39.0000003636247 | 41 | 38 | 30.0000002766709 | 43.0322580645161 | 46.8279572599517 | 42.1182795698925 | 41.3548387096774 | 37.2688174158415
2002-06-01 00:00:00 | 59.0000004395842 | 61.0000001136213 | 52.0000003874301 | 57.000000424683 | 63.0000001173466 | 49.0000003650784 | 46.9999997563427 | 44.0000003278255 | 45.0000003352761 | 44.9999997747364 | 54.5555559620261 | 54.7777777326086 | 48.4444448053836 | 51.6666670516133 | 54.9999999650754
2002-07-01 00:00:00 | 94.0000003501772 | 98.9999998155981 | 88.0000003278255 | 104.00000038743 | 109 | 74.999999202697 | 85.9999989546245 | 51.9999995249801 | 54.999999534793 | 54.9999994775507 | 85.6236557582774 | 93.2688166403302 | 72.1290322319474 | 82.397849473902 | 85.1935481567697
2002-08-01 00:00:00 | 124.999998603016 | 130.000000242143 | 105.999998815357 | 109.999998770654 | 133.999999500811 | 90.0000003123513 | 95.0000000372529 | 55.0000001060275 | 60.000000131818 | 74.9999999232017 | 110.322579964995 | 115.322580801383 | 84.6129025824128 | 89.0322574059809 | 109.258064194072
2002-09-01 00:00:00 | 92.999999307096 | 96 | 87.9999993443489 | 76.9999994263052 | 99 | 71.9999994635582 | 82.9999995348709 | 51.9999996125698 | 49.9999996274709 | 49.9999997855297 | 83.1999993801117 | 89.9333331162731 | 71.1999994695187 | 64.3999995201826 | 76.1333332332472
2002-10-01 00:00:00 | 61.0000009089708 | 56.0000002086162 | 51.0000007599592 | 48.0000007152557 | 48.0000001788139 | 46.9999998595852 | 50.0000000320948 | 40.9999998699014 | 36.9999998893875 | 40.0000000275098 | 55.1290327269704 | 53.483871102333 | 46.8064519996124 | 43.3870971431175 | 44.6451614056864
2002-11-01 00:00:00 | 47 | 48.0000001788139 | 42 | 40 | 35.0000001303851 | 37.9999997825362 | 40.0000000335276 | 34.999999797903 | 31.9999998174607 | 28.0000000244472 | 42.9999999033494 | 44.4444445586867 | 38.888888799068 | 36.4444443633159 | 31.8888889721905
2002-12-01 00:00:00 | 54 | 51.0000001899898 | 45 | 41 | 34.0000001266598 | 39 | 42.0000000397653 | 37 | 32 | 28.0000000265102 | 47.0645161290323 | 46.8387097979505 | 41.3010752688172 | 36.8387096774194 | 31.225806531967
2003-01-01 00:00:00 | 52.9999998025596 | 51.0000001899898 | 40.999999847263 | 39.499999852851 | 32.0000001192092 | 43.9999997082916 | 39.0000000347542 | 34.9999997671693 | 32.9999997810483 | 28.0000000218066 | 49.0322578255167 | 45.7096775409075 | 38.3548385216304 | 36.6344084233466 | 30.2365592160533
2003-02-01 00:00:00 | 50 | 46.999999474734 | 37 | 38.5 | 26.9999996982514 | 41.9999997491638 | 34.0000001074125 | 31.9999998075267 | 28.9999998317411 | 28.0000001247972 | 46.5714284639273 | 41.4285711744534 | 34.8571427746543 | 34.4285713564604 | 27.4285713096282
2003-03-01 00:00:00 | 45.9999998286366 | 41.9999995306134 | 36.9999998621642 | 36.4999998640269 | 26.9999996982514 | 34.0000001592789 | 32.0000000953129 | 30.0000001478758 | 27.0000001265463 | 25.000000094268 | 40.7096773937585 | 37.5913976290293 | 33.9139784827468 | 32.3118279367505 | 26.1182794427319
2003-04-01 00:00:00 | 36 | 38.999999564141 | 27 | 31.5 | 25.9999997094273 | 30.0000001811668 | 31.0000001162683 | 30.0000001917544 | 27.0000001641088 | 25.000000109798 | 33.4666667431592 | 35.6222220194836 | 28.2666667476296 | 29.6000000692904 | 25.5777776562505
2003-05-01 00:00:00 | 36 | 36.0000001341104 | 30 | 32.5 | 26.0000000968575 | 25 | 28.0000002638596 | 31 | 27 | 25.0000002439611 | 31.1505376344086 | 32.4731184708816 | 30.4408602150538 | 30.0752688172043 | 25.5591399466559
2003-06-01 00:00:00 | 40.0000002980232 | 44.0000000819563 | 33.0000002458691 | 40.5000003017485 | 36.0000000670552 | 32.0000002384185 | 36.9999998011626 | 35.0000002607703 | 34.0000002533197 | 34.9999998020939 | 36.4444447159767 | 40.888888846048 | 33.8888891413807 | 37.6111113913357 | 35.5555555048502
2003-07-01 00:00:00 | 57.0000002123415 | 63.9999998807907 | 57.0000002123415 | 67.500000251457 | 65 | 49.9999994491568 | 50.9999993926868 | 42.9999995534649 | 42.9999995892413 | 41.9999995513297 | 53.9139783705074 | 58.2688168699062 | 50.8279569111164 | 56.6989246906953 | 54.8602148559625
2003-08-01 00:00:00 | 79.9999991059303 | 81.0000001508742 | 67.9999992400407 | 79.4999991115182 | 79.9999997019767 | 62.0000001893538 | 60.000000027599 | 44.0000000961307 | 47.0000000792987 | 56.9999999454836 | 72.0645157126009 | 71.741935580398 | 57.4193544561664 | 65.1720425489269 | 69.8602148630927
2003-09-01 00:00:00 | 57.9999995678663 | 61 | 57.9999995678663 | 58.499999564141 | 55 | 54.999999590218 | 50.9999997052364 | 42.999999679625 | 42.999999679625 | 39.9999997788108 | 56.6666662444671 | 56.5555554245495 | 51.3333329508702 | 51.6111107265784 | 48.3333332350271
2003-10-01 00:00:00 | 45.0000006705522 | 45.000000167638 | 33.0000004917383 | 37.5000005587935 | 34.0000001266598 | 39.9999998567196 | 36.0000000257905 | 32.9999998676089 | 30.9999998979844 | 35.9829333528195 | 42.9032261357192 | 41.2258065597665 | 33.0000002300066 | 34.7741938300671 | 34.8315527698881
2003-11-01 00:00:00 | 38 | 40.0000001490116 | 29 | 30.5 | 30.0000001117587 | 30.999999829701 | 33.0000000319311 | 29.9999998227826 | 27.9999998400786 | 25.0000000239483 | 34.7333332538605 | 36.7333334277074 | 29.4666665839652 | 29.3333332587034 | 27.6666667374472
2003-12-01 00:00:00 | 41 | 44.0000001639127 | 31 | 31.5 | 30.0000001117587 | 36 | 36.000000029984 | 30 | 28 | 25.9050000204437 | 38.7956989247312 | 40.4731183844388 | 30.5591397849462 | 29.9569892473118 | 28.1946774908564
2004-01-01 00:00:00 | 47.999999821186 | 46.0000001713633 | 32.9999998770654 | 34.4999998714774 | 30.3487129689699 | 39.3048777886462 | 34.3048780801274 | 31.9999997840695 | 28.9999998074434 | 25.8855680968159 | 44.1666664520018 | 40.8440861311411 | 32.5591396210134 | 32.0752686604517 | 28.381089960816
2004-02-01 00:00:00 | 45 | 41.9999995306134 | 30 | 32.5 | 26.4721640910103 | 37.122710410601 | 29.3754579438777 | 29.9999998194667 | 28.9999998304992 | 26.030974574886 | 41.4688012185453 | 36.3407222675939 | 29.9999999190713 | 30.9310344067755 | 26.2743894803339
2004-03-01 00:00:00 | 41.6499998448416 | 37.6499995792285 | 29.9999998882412 | 31.4999998826533 | 26.4946100015586 | 29.330769377689 | 27.3820513781733 | 28.0000001570353 | 29.0000001619068 | 23.953752400773 | 36.4838709392615 | 33.3440858174957 | 29.161290323542 | 30.4516129029855 | 25.4290890721969
2004-04-01 00:00:00 | 31.65 | 34.6499996127561 | 29 | 31.5 | 25.7348204495248 | 25.3657896254408 | 26.3657895682184 | 30.0000001894016 | 32.0000002013617 | 24.0871780709345 | 28.9966667307417 | 31.1522220383957 | 29.4222223021918 | 31.7111111961305 | 25.0391492230089
2004-05-01 00:00:00 | 31.65 | 31.6500001179054 | 31 | 34.5 | 25.7565277344618 | 20.5779069767442 | 23.4383723056117 | 29 | 31 | 24.2222478782465 | 26.5306451612903 | 27.8532259681352 | 30.0752688172043 | 32.8817204301075 | 25.047129521373
2004-06-01 00:00:00 | 35.6500002656132 | 39.6500000738539 | 36.0000002682209 | 43.5000003241002 | 33.6178297446434 | 27.4710528362542 | 32.5763156050669 | 35.0000002607703 | 31.0000002309679 | 31.9312621359725 | 32.1966669065505 | 36.6633332981438 | 35.5777780428529 | 38.2222225069999 | 32.9057234209823
2004-07-01 00:00:00 | 52.000000193715 | 58.9999998901039 | 57.0000002123415 | 67.500000251457 | 56.4070206224779 | 45.3048775508636 | 46.3048774995046 | 39.9999995981684 | 40.9999996190436 | 37.4619014597222 | 49.0483869855763 | 53.4032255028505 | 49.5053762856631 | 55.8172042737264 | 48.0548713141662
2004-08-01 00:00:00 | 71.9999991953372 | 76.000000141561 | 69.999999217689 | 72.4999991897493 | 68.2461403097098 | 56.7560977385175 | 55.3048780746757 | 44.0000000893161 | 44.0000000807979 | 49.2159695983226 | 65.2795695208253 | 66.8763441765901 | 58.5376340105569 | 59.935483453545 | 59.8564951573778
2004-09-01 00:00:00 | 51.9999996125698 | 56 | 56.9999995753169 | 54.4999995939433 | 48.6516138633298 | 50.1249996265396 | 46.312499733176 | 40.9999996945262 | 38.9999997094273 | 36.3836312449098 | 51.1666662854453 | 51.694444325856 | 49.8888885171877 | 47.6111107563807 | 43.199177144032
2004-10-01 00:00:00 | 40.6500006057322 | 40.650000151433 | 35.0000005215406 | 36.5000005438923 | 32.1643168987294 | 35.1189023435752 | 31.3140244179451 | 32.9999998972365 | 30.9999999182708 | 33.4813175071696 | 38.2115594363942 | 36.5341398818308 | 34.1182798162023 | 34.075269085285 | 32.7449300701923
2004-11-01 00:00:00 | 33.65 | 35.6500001328066 | 29 | 30.5 | 29.0404090535125 | 26.5593748491257 | 28.5843750249012 | 28.9999998244456 | 27.9999998339917 | 25.0690099922254 | 30.4986110440559 | 32.5097223070709 | 28.9999999219759 | 29.3888888151074 | 27.2753428040516
2004-12-01 00:00:00 | 36.65 | 39.6500001477078 | 33 | 30.5 | 29.0658337361866 | 31.4237804878049 | 31.4237805148246 | 29 | 28 | 25.9320340865493 | 34.3459677419355 | 36.0233871912754 | 31.2365591397849 | 29.3978494623656 | 27.6842661487121
2005-01-01 00:00:00 | 45.4999998304992 | 43.5000001620501 | 32.9999998770654 | 34.4999998714774 | 31.1663169175414 | 38.0872090540306 | 33.430232592057 | 31.6627904874987 | 28.9999998108332 | 26.521125746663 | 42.0725804392288 | 38.8440861243114 | 32.3817202668357 | 31.9569890907495 | 29.0185403546621
2005-02-01 00:00:00 | 42.5 | 39.499999558553 | 30 | 32.5 | 27.8798106057305 | 36.2777775602622 | 28.4722223117327 | 30.3448273973732 | 28.9999998242905 | 26.6550285411509 | 39.8333332401124 | 34.7738093099158 | 30.1477831703028 | 30.9999999246959 | 27.354904006625
2005-03-01 00:00:00 | 39.4749998529441 | 35.474999603536 | 29.9999998882412 | 31.4999998826533 | 27.9042607914144 | 28.4000001437246 | 26.6500000969005 | 28.0000001570353 | 29.0000001619068 | 24.7719470120863 | 34.8306451361747 | 31.7741933588179 | 29.161290323542 | 30.4516129029855 | 26.5907098516961
2005-04-01 00:00:00 | 29.475 | 32.4749996370636 | 29 | 31.5 | 27.264074714755 | 24.4302633052398 | 25.6276316743785 | 30.0000001894016 | 32.0000002013617 | 24.8949864090671 | 27.3450000622123 | 29.5838887194855 | 29.4222223021918 | 31.7111111961305 | 26.2637929856868
2005-05-01 00:00:00 | 29.475 | 29.4750001098029 | 31 | 34.5 | 27.2877837316401 | 19.581976744186 | 22.6226746254687 | 29 | 31 | 25.0195166148605 | 24.9008064516129 | 26.3067205847882 | 30.0752688172043 | 32.8817204301075 | 26.239015064742
2005-06-01 00:00:00 | 33.4750002494082 | 37.4750000698026 | 36.0000002682209 | 43.5000003241002 | 33.9751552930052 | 26.5355265134945 | 31.8381577126314 | 35.0000002607703 | 31.0000002309679 | 32.0171037819919 | 30.545000227578 | 35.0949999634414 | 35.5777780428529 | 38.2222225069999 | 33.1484224327995
2005-07-01 00:00:00 | 58.0000002160668 | 56.4999998947605 | 57.0000002123415 | 67.500000251457 | 53.3562580321018 | 45.7267437307814 | 45.3255808741331 | 40.1279066010097 | 40.9999996522052 | 37.0378329544585 | 52.3252687228703 | 51.3333330357608 | 49.1989246716182 | 55.2473118023406 | 45.8111797703958
2005-08-01 00:00:00 | 72.9999991841614 | 73.5000001369044 | 69.999999217689 | 72.4999991897493 | 63.4336826764867 | 56.4551284165623 | 54.4358974569597 | 43.5641026880879 | 44.000000120069 | 47.7059595683932 | 66.0618275719424 | 65.5053764324115 | 58.9139780923724 | 60.5483866766576 | 56.8381858892217
2005-09-01 00:00:00 | 49.4999996311962 | 53.5 | 56.9999995753169 | 54.4999995939433 | 46.7809284225941 | 49.093749634223 | 45.46874973597 | 40.9999996945262 | 38.9999997094273 | 36.0631431254913 | 49.3194440769859 | 49.9305554382089 | 49.8888885171877 | 47.6111107563807 | 42.0174682905484
2005-10-01 00:00:00 | 38.4750005733221 | 38.4750001433305 | 35.0000005215406 | 36.5000005438923 | 32.7649314746107 | 34.1539633174813 | 30.5381097823166 | 32.9999998972365 | 30.9999999182708 | 33.4313633696292 | 36.5700271594568 | 34.9759409519158 | 34.1182798162023 | 34.075269085285 | 33.0587347831672
2005-11-01 00:00:00 | 31.475 | 33.4750001247041 | 29 | 30.5 | 30.1133642546798 | 25.5890623533167 | 27.801562523382 | 28.9999998244456 | 27.9999998339917 | 25.7996513248874 | 28.8590277125852 | 30.9534723018943 | 28.9999999219759 | 29.3888888151074 | 28.1961585081054
2005-12-01 00:00:00 | 34.475 | 37.4750001396053 | 33 | 30.5 | 30.1408035554769 | 30.4588414634146 | 30.6478658791961 | 29 | 28 | 26.5847404450369 | 32.704435483871 | 34.4651882613604 | 31.2365591397849 | 29.3978494623656 | 28.5730768078636
2006-01-01 00:00:00 | 43.9999998360872 | 42.2500001573935 | 33.249999876134 | 34.7499998705461 | 32.3294519716365 | 37.5930230100314 | 32.8081395678266 | 31.8232556027772 | 29.1499998099106 | 27.1212477949018 | 41.0376342068356 | 37.8844087020023 | 32.5903224164099 | 32.1607525306824 | 29.9213575673398
2006-02-01 00:00:00 | 41 | 38.2499995725229 | 30.25 | 32.75 | 29.4980630996249 | 35.8333331172665 | 27.8750000889413 | 30.5031607298373 | 29.1499998234833 | 27.2447019028812 | 38.7857141931142 | 33.8035712224165 | 30.3584974556446 | 31.2071427814929 | 28.532336872449
2006-03-01 00:00:00 | 38.1699998578057 | 34.3874996156897 | 30.2499998873099 | 31.749999881722 | 29.5201126625885 | 28.0005129635048 | 26.0852565060656 | 28.1576924654727 | 29.1500001625946 | 25.5379134553637 | 33.9053763214859 | 30.9059137955248 | 29.3725806458943 | 30.6596774188621 | 27.8501581563329
2006-04-01 00:00:00 | 28.17 | 31.3874996492174 | 29.25 | 31.75 | 28.9693718869811 | 23.8818751385808 | 24.9851563265343 | 29.7468751807697 | 32.1500001951819 | 25.6515178944423 | 26.2641667282581 | 28.5420137280249 | 29.4708334136754 | 31.9277778645253 | 27.4947701125194
2006-05-01 00:00:00 | 28.17 | 28.3875001057517 | 31.25 | 34.75 | 28.9907841270813 | 19.0310975609756 | 22.0708843543132 | 29.4396341463415 | 31.15 | 25.7664740782906 | 24.1410215053763 | 25.6027555271605 | 30.4518817204301 | 33.1629032258065 | 27.5693141055714
2006-06-01 00:00:00 | 32.1700002396852 | 36.387500067777 | 36.2500002700835 | 43.7500003259629 | 34.7549775925726 | 26.1321054578573 | 31.2717103468315 | 35.1578949987888 | 31.1500002320856 | 32.1180377538267 | 29.6206668873578 | 34.2274999633778 | 35.7888891555369 | 38.4300002863258 | 33.641602993991