Spreadsheet: vkaminski__40666__SimResults
Sheet: Data

Distributions |  |  |  |  |  |  |  |  |  |  |  | 10-Percentile Price Slices
Load | History |  | Simulation |  |  | Price | History |  | Simulation |  |  | History
MW Bins | Distribution | Count | Distribution | Count |  | Price Bins | Distribution | Count | Distribution | Count |  | Hour | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
18000 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | Percentile
19000 | 0 | 0 | 0 | 0 |  | 5 | 0 | 0 | 0 | 0 |  | 0-10 | 22.39719166666667 | 24.53750833333334 | 26.012425 | 26.71811666666667 | 27.43929166666667 | 27.17030833333334 | 27.45770833333333 | 27.8417 | 28.32545833333333 | 28.32280833333333 | 27.81956666666667 | 26.9402 | 26.52230833333333 | 27.1349 | 27.085775 | 25.55168333333333
20000 | 0 | 0 | 0.0001875 | 6 |  | 10 | 0.001008064516129032 | 2 | 3.125e-05 | 1 |  | 10-20 | 21.81678333333333 | 25.01711666666667 | 26.97459166666667 | 27.75164166666667 | 28.63996666666667 | 28.84479166666667 | 29.68476666666666 | 30.65094999999999 | 31.9476 | 32.73330833333333 | 31.68974166666667 | 30.10524999999999 | 29.32196666666667 | 28.87284166666667 | 28.564 | 27.22711666666666
21000 | 0.0005040322580645161 | 1 | 0.00053125 | 17 |  | 15 | 0.002520161290322581 | 5 | 0.00634375 | 203 |  | 20-30 | 21.257325 | 25.18405833333334 | 26.72095 | 28.6246 | 30.123875 | 30.66359166666667 | 31.67885833333333 | 33.54928333333334 | 36.09569166666666 | 37.01925833333333 | 35.66618333333333 | 32.66285000000001 | 31.00349166666667 | 30.27073333333333 | 30.14065 | 28.19454166666667
22000 | 0.003024193548387097 | 6 | 0.00475 | 152 |  | 20 | 0.0126008064516129 | 25 | 0.04875 | 1560 |  | 30-40 | 23.34365384615385 | 26.85903846153846 | 27.8251 | 29.14187692307692 | 30.67824615384616 | 31.30409230769231 | 32.51356923076922 | 35.96023846153847 | 38.9822923076923 | 39.89888461538462 | 38.81600769230769 | 35.30358461538462 | 31.76357692307693 | 31.09902307692308 | 30.76242307692308 | 29.09935384615384
23000 | 0.01612903225806452 | 32 | 0.01534375 | 491 |  | 25 | 0.04133064516129032 | 82 | 0.11553125 | 3697 |  | 40-50 | 25.6039076923077 | 28.78200769230769 | 30.12672307692308 | 31.31146153846153 | 32.41610769230769 | 33.07784615384615 | 34.80270769230768 | 37.70123846153847 | 41.55481538461539 | 43.40816923076924 | 42.14182307692307 | 36.90096923076923 | 33.72336923076924 | 33.68637692307693 | 33.32326923076923 | 30.90099230769231
24000 | 0.03629032258064516 | 72 | 0.0355625 | 1138 |  | 30 | 0.2610887096774194 | 518 | 0.164875 | 5276 |  | 50-60 | 23.66615384615384 | 27.27593076923077 | 29.22076923076922 | 30.48497692307692 | 32.03741538461539 | 33.03601538461539 | 35.8967 | 40.87802307692308 | 47.66733076923078 | 50.2190923076923 | 47.82989999999999 | 40.93110000000001 | 35.5223 | 33.61936153846154 | 33.34113846153846 | 30.48449230769231
25000 | 0.06804435483870967 | 135 | 0.06278125 | 2009 |  | 35 | 0.2661290322580645 | 528 | 0.15990625 | 5117 |  | 60-70 | 24.00115384615385 | 28.72207692307693 | 29.82538461538462 | 32.49449230769231 | 35.19782307692308 | 38.16197692307694 | 44.97474615384616 | 54.2131 | 60.41468461538462 | 63.2587 | 59.80062307692307 | 50.45894615384616 | 43.99646153846155 | 38.07129999999999 | 37.22142307692307 | 32.4597
26000 | 0.07560483870967742 | 150 | 0.08696875 | 2783 |  | 40 | 0.1164314516129032 | 231 | 0.11753125 | 3761 |  | 70-80 | 25.44204166666667 | 29.32633333333333 | 30.69615 | 33.82496666666666 | 37.86716666666667 | 43.15606666666665 | 52.38185833333333 | 63.99274166666666 | 80.338825 | 88.01338333333332 | 85.12103333333333 | 69.328675 | 53.70244166666667 | 45.80126666666666 | 45.28905 | 35.24841666666666
27000 | 0.08921370967741936 | 177 | 0.1060625 | 3394 |  | 45 | 0.06098790322580645 | 121 | 0.084625 | 2708 |  | 80-90 | 27.5855 | 29.76391666666666 | 31.33404166666666 | 33.3219 | 39.34756666666667 | 48.27944166666668 | 69.58878333333334 | 88.61391666666668 | 123.8940833333333 | 133.9579916666667 | 131.3859583333333 | 104.3443333333333 | 72.33215 | 56.23513333333333 | 53.61714999999999 | 38.083925
28000 | 0.1275201612903226 | 253 | 0.12153125 | 3889 |  | 50 | 0.04989919354838709 | 99 | 0.0650625 | 2082 |  | 90-100 | 29.642275 | 32.011025 | 35.780125 | 43.89625833333333 | 72.85494166666666 | 84.64915833333333 | 107.0951666666667 | 137.808725 | 161.984775 | 167.4807416666667 | 165.0419083333333 | 138.1237083333333 | 103.8142666666667 | 89.62431666666667 | 79.56106666666666 | 47.334375
29000 | 0.1376008064516129 | 273 | 0.1315 | 4208 |  | 60 | 0.04183467741935484 | 83 | 0.07759375 | 2483
30000 | 0.1209677419354839 | 240 | 0.1239375 | 3966 |  | 70 | 0.02872983870967742 | 57 | 0.04903125 | 1569 |  | Simulation
31000 | 0.1123991935483871 | 223 | 0.10146875 | 3247 |  | 80 | 0.02217741935483871 | 44 | 0.03215625 | 1029 |  | Hour | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
32000 | 0.07963709677419355 | 158 | 0.07940625 | 2541 |  | 90 | 0.02066532258064516 | 41 | 0.0210625 | 674 |  | Percentile
33000 | 0.05241935483870968 | 104 | 0.0575625 | 1842 |  | 100 | 0.0126008064516129 | 25 | 0.0135625 | 434 |  | 0-10 | 18.61862405412195 | 19.87848173585356 | 21.13833941758516 | 22.39819709931676 | 23.56029765795311 | 24.52291356799084 | 25.28008922581784 | 25.82586902782203 | 26.15429737039126 | 26.25966274188269 | 26.02610879271603 | 25.41112458460756 | 24.57556618653256 | 23.72465505333671 | 23.06361263986574 | 22.79766040096524
34000 | 0.05040322580645161 | 100 | 0.0375 | 1200 |  | 120 | 0.01512096774193548 | 30 | 0.0184375 | 590 |  | 10-20 | 20.80930982810411 | 22.69657654743667 | 24.58384326676925 | 26.47110998610177 | 28.36363629847783 | 30.18216791034345 | 31.79993399180257 | 33.09016371295915 | 33.9260862439171 | 34.18909960400432 | 33.62610535868886 | 32.21859385061963 | 30.32904763578424 | 28.41406258931248 | 26.93023458633421 | 26.33415950197924
35000 | 0.01713709677419355 | 34 | 0.019125 | 612 |  | 140 | 0.01008064516129032 | 20 | 0.0106875 | 342 |  | 20-30 | 21.70209701932498 | 23.90652355934591 | 26.11095009936683 | 28.31537663938774 | 30.76177970433922 | 33.47181762799401 | 36.11501312361536 | 38.36088890446652 | 39.87896768381081 | 40.38589887508748 | 39.52522721756134 | 37.36266101607317 | 34.46229100954411 | 31.5240342180813 | 29.24780766179171 | 28.33352836078247
36000 | 0.01008064516129032 | 20 | 0.01025 | 328 |  | 160 | 0.02469758064516129 | 49 | 0.00615625 | 197 |  | 30-40 | 22.36864842887431 | 24.67543291353657 | 26.98221739819886 | 29.28900188286113 | 32.19210744850847 | 35.87253585847655 | 39.70730813629103 | 43.0734453054778 | 45.34796838956247 | 46.04791923501918 | 44.73471011333867 | 41.64047355104218 | 37.5986089590278 | 33.54850731976708 | 30.42955961573152 | 29.18115682939263
37000 | 0.003024193548387097 | 6 | 0.00425 | 136 |  | 180 | 0.006048387096774193 | 12 | 0.0029375 | 94 |  | 40-50 | 22.98655838825253 | 25.44656489465336 | 27.90657140105416 | 30.36657790745494 | 33.62461980890444 | 37.96917275422261 | 42.63589712406633 | 46.86045329909241 | 49.87850165995791 | 51.02852125233432 | 49.68636617620219 | 46.03209163986714 | 41.04346481343799 | 35.95353163416041 | 31.99533803928027 | 30.40192996604329
38000 | 0 | 0 | 0.00103125 | 33 |  | 200 | 0.004032258064516129 | 8 | 0.002 | 64 |  | 50-60 | 22.91254159911376 | 25.40317708331686 | 27.89381256751996 | 30.38444805172298 | 34.28589554520895 | 40.16961732593146 | 46.77658879689658 | 52.84778536111048 | 57.12418242157914 | 58.56947047182897 | 56.498841724023 | 51.47701595871246 | 44.85927516979496 | 38.20350574512707 | 33.06759407256499 | 31.00942653996496
39000 | 0 | 0 | 0.00025 | 8 |  | 250 | 0.002016129032258064 | 4 | 0.00215625 | 69 |  | 60-70 | 24.05489019560657 | 26.49723489960582 | 28.93957960360511 | 31.38192430760438 | 35.77913059649123 | 42.98978708802517 | 51.36948433151429 | 59.27381287626654 | 65.05836327158994 | 67.26269428206966 | 64.85555553060807 | 58.52852521230849 | 50.03851811554587 | 41.43580136645416 | 34.77064209116753 | 32.09330741581984
40000 | 0 | 0 | 0 | 0 |  | 300 | 0 | 0 | 0.00090625 | 29 |  | 70-80 | 23.66779875777214 | 26.33165356250858 | 28.99550836724503 | 31.65936317198145 | 37.19226355126567 | 46.87603932204733 | 58.32986684792919 | 69.17292249251393 | 77.02438261940446 | 79.8893735566923 | 76.58011476617041 | 68.12057165239088 | 56.82647970663466 | 45.40613844264743 | 36.56784737417483 | 33.01990601496258
41000 | 0 | 0 | 0 | 0 |  | 350 | 0 | 0 | 0.00021875 | 7 |  | 80-90 | 23.42567331966502 | 25.97819022523881 | 28.53070713081256 | 31.08322403638627 | 38.10019440710322 | 51.64890218162252 | 68.13359307021825 | 84.26382812870592 | 96.99796638519854 | 99.96806494941666 | 96.6874729970276 | 83.87548098225574 | 68.28766739607227 | 52.74068929020693 | 40.71744978933148 | 35.8930206716589
42000 | 0 | 0 | 0 | 0 |  | 400 | 0 | 0 | 0.00021875 | 7 |  | 90-100 | 22.37440225491522 | 25.07189687377979 | 27.76939149264436 | 30.46688611150877 | 42.47581239646897 | 68.19242607250006 | 100.2439632279213 | 132.6544310384947 | 158.44556533195 | 163.0701290764782 | 158.1094884631306 | 133.2792096529416 | 103.1583622226222 | 73.73160474683164 | 50.9326088827928 | 41.77447651036621
43000 | 0 | 0 | 0 | 0 |  | 450 | 0 | 0 | 0.000125 | 4
44000 | 0 | 0 | 0 | 0 |  | 500 | 0 | 0 | 0 | 0
45000 | 0 | 0 | 0 | 0 |  | 550 | 0 | 0 | 9.375e-05 | 3 |  | Price-Duration Curves
 |  |  |  |  |  | 600 | 0 | 0 | 0 | 0 |  | 0 | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.1 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.2 | 0.25 | 0.3 | 0.35 | 0.4 | 0.5 | 0.6 | 0.65 | 0.7 | 0.75 | 0.8 | 0.85 | 0.86 | 0.87 | 0.88 | 0.89 | 0.9 | 0.91 | 0.92 | 0.93 | 0.94 | 0.95 | 0.96 | 0.97 | 0.98 | 0.99 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 9.9971 | 18.155507 | 20.772764 | 22.886777 | 24.052876 | 24.886145 | 25.121302 | 25.688537 | 25.998912 | 26.208541 | 26.45342 | 26.763525 | 26.992292 | 27.003237 | 27.058088 | 27.347445 | 28.23836 | 29.0038 | 29.81991 | 30.510515 | 31.0344 | 32.9969 | 35.40158 | 37.4012 | 39.99559 | 44.01985 | 49.00584 | 59.34653499999999 | 62.51070999999994 | 64.997856 | 69.527628 | 72.36012800000005 | 75.62018000000003 | 80.49376 | 86.11700400000014 | 93.52677000000006 | 100.651642 | 114.004745 | 126.3867959999997 | 149.510264 | 153.670978 | 164.2746350000001 | 224.9955
 |  |  |  |  |  |  |  |  |  |  |  | 9.639646432662234 | 15.73797606391601 | 17.19304973572525 | 18.16457714669212 | 18.9909241047698 | 19.69903375710844 | 20.29069478742379 | 20.80079508019412 | 21.26813378476182 | 21.79959507646215 | 22.22849382721037 | 22.66832904995113 | 23.05480360947907 | 23.42562168824649 | 23.85147827802915 | 24.2143423346607 | 25.95030550723193 | 27.56186421685155 | 28.99181407362059 | 30.39602891214227 | 31.89451139485772 | 35.1628987580817 | 39.38126867999095 | 41.9536416568609 | 45.15418504241812 | 48.86573390559508 | 54.11269898069008 | 61.67819029647941 | 63.5324275162763 | 65.51691845411926 | 67.83041849223912 | 70.1327931999689 | 73.04411514612016 | 76.09861446375146 | 79.47255589777023 | 83.77006554843959 | 88.53022298753746 | 94.77198760250556 | 103.4273300196017 | 114.2434782441062 | 130.3100346953218 | 154.9351361109429 | 511.8496358482394