{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Vstupní data","Varianta A","Varianta B","Výsledné vyhodnocení","Ceny za PR","Ceny elektřiny na VDT","Ilustrace odchylek frekvence","Scénáře"],"not_rendered":{"charts":10,"images":18,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Vstupní data","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Vstupní data"]
[]
[null,"Instalovaný výkon (MW)",10]
[null,"Kapacita (MWh)",6.5]
[null,"Účinnost (%)",0.96]
[null,"Pořizovací cena Li-ion baterie  (Kč/KW)",{"$f":"1000*24.5","v":24500}]
[null,"Celková pořizovací cena Li-ion baterie (mil Kč), v ceně je zahrnuta instalace",{"$f":"10*C6/1000","v":245}]
[null,"Očekávaný výnos",0.08]
[null,"Plánovaná životnost (roků)",13]
[null,"Počet dní provozu za rok",353]
[null,"Průměrný příjem za poskytování PR (Kč/MW) za jednu hodinu",653]
[null,"Snížený příjem za poskytování PR (Kč/MW) za jednu hodinu (90% z průměrného)",{"$f":"C11*0.9","v":587.70000000000005}]
[null,"Příjem za poskytování služby naší baterií za jednu hodinu",{"$f":"C12*C3","v":5877}]
[null,"Příjem za poskytování služby naší baterií za rok (mil Kč)",{"$f":"C13*C10*24/1000000","v":49.789943999999998}]
[null,"Průměrný denní požadavek na výši kladné regulační energie (MWh)",10]
[null,"Průměrný denní požadavek na výši záporné regulační energie (MWh)",10]
[null,"Průměrná cena elektřiny na VDT (Kč/MWh)",{"$f":"'Ceny elektřiny na VDT'!B13","v":863.45587179292966}]
[null,"Cena kupované elektřiny v rámci bilaterální dohody",{"$f":"'Ceny elektřiny na VDT'!C24","v":1452.1902703595611}]
[null,"Cena prodávané elektřiny v rámci bilaterální dohody",{"$f":"'Ceny elektřiny na VDT'!C25","v":308.26535296481944}]
[null,"Cena rezervované kapacity přenosových zařízení (tis Kč/MW/měsíc)",{"$f":"78222/1000","v":78.221999999999994}]
[null,"Náklady za rezervovanou kapacitu přenosových zařízení (mil Kč/rok)",{"$f":"C20*10*12/1000","v":9.3866399999999999}]
[null,"Náklady na pojištění majetku (% z pořizovací ceny/rok)",0.01]
[null,"Náklady na provoz a údržbu  (% z pořizovací ceny/rok)",0.02]
[null,"Daňová odpisová skupina",3]
[null,"Účetní odpisy  (% z pořizovací ceny/rok)",{"$f":"100/13/100","v":7.6923076923076927E-2}]

{"sheet":"Varianta A","index":1,"n_rows":81,"n_cols":16,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["Varianta A: Recovery time 2 hodiny","rok",0,1,2,3,4,5,6,7,8,9,10,11,12,13]
["Měrné pořizovací náklady baterie","Kč/kW",{"$f":"'Vstupní data'!C6","v":24500}]
["Celková cena baterie","mil Kč",{"$f":"'Vstupní data'!C7","v":245}]
["Rezervovaný výkon","MW",10]
["Účinnost baterie","%",0.96]
["Nominální diskontní míra","%",{"$f":"'Vstupní data'!C8","v":0.08}]
["Míra meziroční inflace","%",0.02]
["Počet dní provozu v roce","dny",353]
["Počet hodin provozu v roce","hodiny",{"$f":"'Vstupní data'!C10*24","v":8472}]
["Výnosy"]
["Cena za poskytování služby PR","Kč/MWh",{"$f":"'Vstupní data'!$C$12","v":587.70000000000005},{"$f":"C11*(1+D12)","v":599.45400000000006},{"$f":"D11*(1+E12)","v":611.44308000000012},629.78637240000012,648.67996357200013,668.1403624791601,688.18457335353492,708.83011055414102,730.09501387076523,751.99786428688822,774.55780021549492,797.79453422195979,821.7283702486186,846.38022135607719]
["Předpokládaná nominální změna ceny","Kč/MWh",null,0.02,0.02,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[]
["Tržby za poskytování služby PR","mil Kč",null,{"$f":"$C$4*$C$9*D11/1000000","v":50.785742880000001},51.80145773760001,53.355501469728011,54.956166513819852,56.604851509234443,58.302997054511479,60.052086966146824,61.853649575131229,63.709259062385172,65.620536834256725,67.589152939284432,69.616827527462974,71.705332353286863]
["Průměrná cena elektřiny na VDT","Kč/MWh",{"$f":"'Vstupní data'!$C$17","v":863.45587179292966},{"$f":"C15*(1+D16)","v":889.35954794671761},{"$f":"D15*(1+E16)","v":916.04033438511919},{"$f":"E15*(1+F16)","v":952.68194776052394},{"$f":"F15*(1+G16)","v":990.78922567094492},{"$f":"G15*(1+H16)","v":1030.4207946977826},{"$f":"H15*(1+I16)","v":1071.637626485694},{"$f":"I15*(1+J16)","v":1114.5031315451217},{"$f":"J15*(1+K16)","v":1159.0832568069266},{"$f":"K15*(1+L16)","v":1217.0374196472728},{"$f":"L15*(1+M16)","v":1277.8892906296364},{"$f":"M15*(1+N16)","v":1341.7837551611183},{"$f":"N15*(1+O16)","v":1408.8729429191742},{"$f":"O15*(1+P16)","v":1479.3165900651329}]
["Předpokládaná nominální změna ceny","%",null,0.03,0.03,0.04,0.04,0.04,0.04,0.04,0.04,0.05,0.05,0.05,0.05,0.05]
[]
["Prodaná energie získaná poskytováním záporné regulace","MWh/den",null,{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6}]
["Prodaná energie získaná poskytováním záporné regulace","MWh/rok",null,{"$f":"D18*$C$8","v":3388.7999999999997},{"$f":"E18*$C$8","v":3388.7999999999997},3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997]
["Tržby za prodej energie získané s poskytování záporné regulace","mil Kč",null,{"$f":"D19*D15/1000000","v":3.013861636081836},3.1042774851642916,3.2284485845708635,3.3575865279536981,3.4918899890718453,3.6315655886347198,3.7768282121801082,3.9279013406673124,4.1242964077006778,4.3305112280857117,4.5470367894899972,4.7743886289644966,5.0131080604127218]
["Výnosy celkem","mil Kč",null,{"$f":"D14+D20","v":53.799604516081835},54.905735222764299,56.583950054298874,58.313753041773552,60.096741498306287,61.934562643146201,63.82891517832693,65.781550915798547,67.833555470085855,69.951048062342437,72.136189728774426,74.391216156427475,76.718440413699582]
["Náklady"]
["Průměrná cena elektřiny na VDT","Kč/MWh",{"$f":"'Vstupní data'!$C$17","v":863.45587179292966},{"$f":"C23*(1+D24)","v":889.35954794671761},{"$f":"D23*(1+E24)","v":916.04033438511919},{"$f":"E23*(1+F24)","v":952.68194776052394},{"$f":"F23*(1+G24)","v":990.78922567094492},{"$f":"G23*(1+H24)","v":1030.4207946977826},{"$f":"H23*(1+I24)","v":1071.637626485694},{"$f":"I23*(1+J24)","v":1114.5031315451217},{"$f":"J23*(1+K24)","v":1159.0832568069266},{"$f":"K23*(1+L24)","v":1217.0374196472728},{"$f":"L23*(1+M24)","v":1277.8892906296364},{"$f":"M23*(1+N24)","v":1341.7837551611183},{"$f":"N23*(1+O24)","v":1408.8729429191742},{"$f":"O23*(1+P24)","v":1479.3165900651329}]
["Předpokládaná nominální změna ceny","%",null,{"$f":"D16","v":0.03},{"$f":"E16","v":0.03},0.04,0.04,0.04,0.04,0.04,0.04,0.05,0.05,0.05,0.05,0.05]
["Energie dokoupená po poskytnutí kladné regulace","MWh/den",null,{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668}]
["Energie dokoupená po poskytnutí kladné regulace","MWh/rok",null,{"$f":"D25*$C$8","v":3677.0833333333339},{"$f":"E25*$C$8","v":3677.0833333333339},3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339]
["Náklady na vlastní spotřebu energie","mil Kč",null,{"$f":"D26*D23/1000000","v":3.2702491710957431},3.3683566462286163,3.5030909120777602,3.6432145485608709,3.7889431305033057,3.940500855723438,4.0981208899523756,4.26204572555047,4.4751480118279936,4.6989054124193927,4.9338506830403626,5.1805432171923806,5.4395703780520002]
["Náklady za rezervovanou kapacitu přenosových zařízení","mil Kč",null,{"$f":"'Vstupní data'!C21","v":9.3866399999999999},{"$f":"D28","v":9.3866399999999999},{"$f":"E28","v":9.3866399999999999},9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999]
["Provoz a údržba","% investice",{"$f":"'Vstupní data'!C23","v":0.02},{"$f":"C29*(1+D30)","v":2.0400000000000001E-2},{"$f":"D29*(1+E30)","v":2.0808000000000004E-2},{"$f":"E29*(1+F30)","v":2.1224160000000002E-2},{"$f":"F29*(1+G30)","v":2.1648643200000001E-2},2.2081616064000002E-2,2.2523248385280002E-2,2.2973713352985602E-2,2.3433187620045315E-2,{"$f":"K29*(1+L30)","v":2.3901851372446221E-2},{"$f":"L29*(1+M30)","v":2.4379888399895147E-2},{"$f":"M29*(1+N30)","v":2.4867486167893051E-2},2.5364835891250912E-2,2.5872132609075931E-2]
["Předpokládaný nominální růst ceny","%",null,{"$f":"C7","v":0.02},{"$f":"D30","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
["Náklady na provoz a údržbu","mil Kč",null,{"$f":"$C$3*C29","v":4.9000000000000004},{"$f":"$C$3*E29","v":5.0979600000000005},5.199919200000001,5.3039175840000006,5.4099959356800005,5.5181958543936007,5.6285597714814726,5.7411309669111024,5.8559535862493242,5.9730726579743108,6.0925341111337978,6.2143847933564738,6.3386724892236028]
["Pojištění majetku","% investice",null,{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01}]
["Náklady na pojištění majetku","mil Kč",null,{"$f":"C3*D32","v":2.4500000000000002},{"$f":"D33*(1+((E7)/100))","v":2.4500000000000002},2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002]
["Náklady celkem bez odpisů","mil Kč",null,{"$f":"+D27+D28+D31+D33","v":20.006889171095743},{"$f":"+E27+E28+E31+E33","v":20.302956646228616},20.539650112077759,20.78377213256087,21.035579066183306,21.295336710117038,21.563320661433849,21.839816692461572,22.167741598077317,22.508618070393702,22.863024794174159,23.231568010548852,23.6148828672756]
["Účetní odpisy","% investice",null,{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2}]
["Účetní odpisy","mil Kč",null,{"$f":"$C$3*D35","v":18.846153846153847},{"$f":"$C$3*E35","v":18.846153846153847},18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847]
["Náklady celkem","mil Kč",null,{"$f":"D36+D34","v":38.85304301724959},{"$f":"E36+E34","v":39.149110492382462},39.385803958231605,39.629925978714716,39.881732912337156,40.141490556270881,40.409474507587696,40.685970538615422,41.013895444231167,41.354771916547548,41.709178640328005,42.077721856702695,42.461036713429451]
["EBT","mil Kč",null,{"$f":"MAX(D21-D37,0)","v":14.946561498832246},15.756624730381837,17.198146096067269,18.683827063058835,20.21500858596913,21.79307208687532,23.419440670739235,25.095580377183126,26.819660025854688,28.596276145794889,30.42701108844642,32.31349429972478,34.257403700270132]
["Daň (19%)","mil Kč",null,{"$f":"D38*0.19","v":2.8398466847781267},{"$f":"E38*0.19","v":2.9937586987725493},3.2676477582527812,3.5499271419811786,3.840851631334135,4.1406836965063105,4.4496937274404544,4.7681602716647937,5.0957354049123911,5.4332924677010288,5.7811321068048196,6.1395639169477088,6.5089067030513252]
["EAT","mil Kč",null,{"$f":"D38-D39","v":12.106714814054119},{"$f":"E38-E39","v":12.762866031609288},13.930498337814488,15.133899921077656,16.374156954634994,17.652388390369008,18.96974694329878,20.327420105518332,21.723924620942299,23.162983678093859,24.645878981641602,26.173930382777073,27.748496997218808]
["Cash Flow","mil Kč",{"$f":"-C3","v":-245},{"$f":"D40+D36","v":30.952868660207965},31.609019877763135,32.776652183968338,33.980053767231503,35.220310800788837,36.498542236522852,37.815900789452627,39.173573951672182,40.570078467096145,{"$f":"M40+M36-M3","v":42.009137524247706},{"$f":"N40+N36","v":43.492032827795448},{"$f":"O40+O36","v":45.020084228930919},{"$f":"P40+P36","v":46.594650843372655}]
["Kumulovaný Cash Flow","mil Kč",{"$f":"C41","v":-245},{"$f":"C42+D41","v":-214.04713133979203},{"$f":"D42+E41","v":-182.4381114620289},-149.66145927806056,-115.68140551082905,-80.461094710040214,-43.962552473517363,-6.1466516840647358,33.026922267607446,73.597000734703585,115.60613825895129,159.09817108674673,204.11825531567766,250.71290615905031]
["Diskontovaný Cash Flow","mil Kč",{"$f":"-C3","v":-245},{"$f":"D41/((1+($C$6))^D1)","v":28.660063574266633},27.09963981289706,26.019163256338221,24.97635391854374,23.97035172532329,23.000272742966839,22.065214898831353,21.164263100825586,20.295139849607093,19.458358941285493,18.652987397592749,17.878094862709872,17.132756415934558]
["Kumulovaný diskontovaný Cash Flow","mil Kč",{"$f":"C43","v":-245},{"$f":"C44+D43","v":-216.33993642573336},{"$f":"D44+E43","v":-189.24029661283629},{"$f":"E44+F43","v":-163.22113335649806},-138.24477943795432,-114.27442771263102,-91.274154969664181,-69.208940070832824,-48.044676970007238,-27.749537120400145,-8.2911781791146524,10.361809218478097,28.239904081187969,45.372660497122524]
[]
["IRR",{"$f":"IRR(C41:P41)","v":0.10987934755983178}]
["NPV (mil Kč)",{"$f":"NPV(C6,D41,E41,F41,G41,H41,I41,J41,K41,L41,M41,N41,O41,P41)+C41","v":45.372660497122467}]
["Doba návratnosti (roky)",{"$f":"IF(COUNTIF(C42:P42,\"<0\")<14,COUNTIF(C42:P42,\"<0\"),\"x\")","v":8}]
["Diskontovaná doba návratnosti (roky)",{"$f":"IF(COUNTIF(C44:P44,\"<0\")<14,COUNTIF(C44:P44,\"<0\"),\"x\")","v":11}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Vývoj ceny za poskytování PR",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[{"$f":"Scénáře!C4","v":"základní "},null,null,{"$f":"Scénáře!D4","v":0.01},{"$f":"Scénáře!E4","v":0.01},{"$f":"Scénáře!F4","v":0.02},{"$f":"Scénáře!G4","v":0.02},{"$f":"Scénáře!H4","v":0.02},{"$f":"Scénáře!I4","v":0.02},{"$f":"Scénáře!J4","v":0.02},{"$f":"Scénáře!K4","v":0.02},{"$f":"Scénáře!L4","v":0.02},{"$f":"Scénáře!M4","v":0.02},{"$f":"Scénáře!N4","v":0.02},{"$f":"Scénáře!O4","v":0.02},{"$f":"Scénáře!P4","v":0.02}]
[{"$f":"Scénáře!C5","v":"příznivý"},null,null,{"$f":"Scénáře!D5","v":0.02},{"$f":"Scénáře!E5","v":0.02},{"$f":"Scénáře!F5","v":0.03},{"$f":"Scénáře!G5","v":0.03},{"$f":"Scénáře!H5","v":0.03},{"$f":"Scénáře!I5","v":0.03},{"$f":"Scénáře!J5","v":0.03},{"$f":"Scénáře!K5","v":0.03},{"$f":"Scénáře!L5","v":0.03},{"$f":"Scénáře!M5","v":0.03},{"$f":"Scénáře!N5","v":0.03},{"$f":"Scénáře!O5","v":0.03},{"$f":"Scénáře!P5","v":0.03}]
[{"$f":"Scénáře!C6","v":"nepříznivý"},null,null,{"$f":"Scénáře!D6","v":0},{"$f":"Scénáře!E6","v":0},{"$f":"Scénáře!F6","v":0.01},{"$f":"Scénáře!G6","v":0.01},{"$f":"Scénáře!H6","v":0.01},{"$f":"Scénáře!I6","v":0.01},{"$f":"Scénáře!J6","v":0.01},{"$f":"Scénáře!K6","v":0.01},{"$f":"Scénáře!L6","v":0.01},{"$f":"Scénáře!M6","v":0.01},{"$f":"Scénáře!N6","v":0.01},{"$f":"Scénáře!O6","v":0.01},{"$f":"Scénáře!P6","v":0.01}]
[]
["Vývoj ceny elektřiny na VDT",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[{"$f":"Scénáře!C9","v":"základní "},null,null,{"$f":"Scénáře!D9","v":0.03},{"$f":"Scénáře!E9","v":0.03},{"$f":"Scénáře!F9","v":0.04},{"$f":"Scénáře!G9","v":0.04},{"$f":"Scénáře!H9","v":0.04},{"$f":"Scénáře!I9","v":0.04},{"$f":"Scénáře!J9","v":0.04},{"$f":"Scénáře!K9","v":0.04},{"$f":"Scénáře!L9","v":0.05},{"$f":"Scénáře!M9","v":0.05},{"$f":"Scénáře!N9","v":0.05},{"$f":"Scénáře!O9","v":0.05},{"$f":"Scénáře!P9","v":0.05}]
[{"$f":"Scénáře!C10","v":"příznivý"},null,null,{"$f":"Scénáře!D10","v":0.01},{"$f":"Scénáře!E10","v":0.01},{"$f":"Scénáře!F10","v":0.02},{"$f":"Scénáře!G10","v":0.02},{"$f":"Scénáře!H10","v":0.02},{"$f":"Scénáře!I10","v":0.02},{"$f":"Scénáře!J10","v":0.02},{"$f":"Scénáře!K10","v":0.02},{"$f":"Scénáře!L10","v":0.03},{"$f":"Scénáře!M10","v":0.03},{"$f":"Scénáře!N10","v":0.03},{"$f":"Scénáře!O10","v":0.03},{"$f":"Scénáře!P10","v":0.03}]
[{"$f":"Scénáře!C11","v":"nepříznivý"},null,null,{"$f":"Scénáře!D11","v":0.05},{"$f":"Scénáře!E11","v":0.05},{"$f":"Scénáře!F11","v":0.06},{"$f":"Scénáře!G11","v":0.06},{"$f":"Scénáře!H11","v":0.06},{"$f":"Scénáře!I11","v":0.06},{"$f":"Scénáře!J11","v":0.06},{"$f":"Scénáře!K11","v":0.06},{"$f":"Scénáře!L11","v":7.0000000000000007E-2},{"$f":"Scénáře!M11","v":7.0000000000000007E-2},{"$f":"Scénáře!N11","v":7.0000000000000007E-2},{"$f":"Scénáře!O11","v":7.0000000000000007E-2},{"$f":"Scénáře!P11","v":7.0000000000000007E-2}]

{"sheet":"Varianta B","index":2,"n_rows":81,"n_cols":16,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["Varianta B: Recovery time 30 minut","rok",0,1,2,3,4,5,6,7,8,9,10,11,12,13]
["Měrné pořizovací náklady baterie","Kč/kW",{"$f":"'Vstupní data'!C6","v":24500}]
["Celková cena baterie","mil Kč",{"$f":"'Vstupní data'!C7","v":245}]
["Rezervovaný výkon","MW",10]
["Účinnost baterie","%",0.96]
["Nominální diskontní míra","%",{"$f":"'Vstupní data'!C8","v":0.08}]
["Míra meziroční inflace","%",0.02]
["Počet dní v roce","dny",353]
["Počet hodin v roce","hodiny",{"$f":"'Vstupní data'!C10*24","v":8472}]
["Výnosy"]
["Cena za poskytování služby PR","Kč/MWh",{"$f":"'Vstupní data'!$C$12","v":587.70000000000005},{"$f":"C11*(1+D12)","v":599.45400000000006},{"$f":"D11*(1+E12)","v":611.44308000000012},629.78637240000012,648.67996357200013,668.1403624791601,688.18457335353492,708.83011055414102,730.09501387076523,751.99786428688822,774.55780021549492,797.79453422195979,821.7283702486186,846.38022135607719]
["Předpokládaná nominální změna ceny","Kč/MWh",null,0.02,0.02,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[]
["Výnosy za poskytování služby PR","mil Kč",null,{"$f":"$C$4*$C$9*D11/1000000","v":50.785742880000001},{"$f":"$C$4*$C$9*E11/1000000","v":51.80145773760001},53.355501469728011,54.956166513819852,56.604851509234443,58.302997054511479,60.052086966146824,61.853649575131229,63.709259062385172,65.620536834256725,67.589152939284432,69.616827527462974,71.705332353286863]
["Cena prodávané elektřiny","Kč/MWh",{"$f":"'Vstupní data'!C19","v":308.26535296481944},{"$f":"C15*(1+D16)","v":317.51331355376402},{"$f":"D15*(1+E16)","v":327.03871296037693},{"$f":"E15*(1+F16)","v":340.12026147879203},{"$f":"F15*(1+G16)","v":353.72507193794371},{"$f":"G15*(1+H16)","v":367.87407481546148},{"$f":"H15*(1+I16)","v":382.58903780807998},{"$f":"I15*(1+J16)","v":397.89259932040318},{"$f":"J15*(1+K16)","v":413.8083032932193},{"$f":"K15*(1+L16)","v":434.49871845788027},{"$f":"L15*(1+M16)","v":456.22365438077429},{"$f":"M15*(1+N16)","v":479.03483709981305},{"$f":"N15*(1+O16)","v":502.98657895480375},{"$f":"O15*(1+P16)","v":528.13590790254398}]
["Předpokládaná nominální změna ceny","%",null,0.03,0.03,0.04,0.04,0.04,0.04,0.04,0.04,0.05,0.05,0.05,0.05,0.05]
[]
["Prodaná energie získaná poskytováním záporné regulace","MWh/den",null,{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6},{"$f":"'Vstupní data'!$C$16*$C$5","v":9.6}]
["Prodaná energie získaná poskytováním záporné regulace","MWh/rok",null,{"$f":"D18*$C$8","v":3388.7999999999997},{"$f":"E18*$C$8","v":3388.7999999999997},3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997,3388.7999999999997]
["Výnosy za prodej energie získané s poskytování záporné regulace","mil Kč",null,{"$f":"D19*D15/1000000","v":1.0759891169709954},1.1082687904801252,1.1525995420993302,1.1987035237833035,1.2466516647346357,1.2965177313240213,1.3483784405769823,1.4023135782000613,1.4724292571100646,1.5460507199655678,1.6233532559638464,1.7045209187620387,1.7897469647001409]
["Výnosy celkem","mil Kč",null,{"$f":"D14+D20","v":51.861731996970995},52.909726528080135,54.508101011827343,56.154870037603153,57.851503173969078,59.599514785835503,61.400465406723804,63.255963153331287,65.181688319495237,67.166587554222289,69.212506195248281,71.321348446225016,73.495079317987006]
["Náklady"]
["Cena kupované elektřiny","Kč/MWh",{"$f":"'Vstupní data'!C18","v":1452.1902703595611},{"$f":"C23*(1+D24)","v":1495.7559784703478},{"$f":"D23*(1+E24)","v":1540.6286578244583},{"$f":"E23*(1+F24)","v":1602.2538041374366},1666.3439563029342,1732.9977145550517,{"$f":"H23*(1+I24)","v":1802.3176231372538},{"$f":"I23*(1+J24)","v":1874.4103280627439},{"$f":"J23*(1+K24)","v":1949.3867411852536},{"$f":"K23*(1+L24)","v":2046.8560782445163},2149.198882156742,2256.6588262645791,{"$f":"N23*(1+O24)","v":2369.4917675778083},{"$f":"O23*(1+P24)","v":2487.9663559566989}]
["Předpokládaná nominální změna ceny","%",null,{"$f":"D16","v":0.03},{"$f":"E16","v":0.03},0.04,0.04,0.04,0.04,0.04,0.04,0.05,0.05,0.05,0.05,0.05]
["Energie dokoupená po poskytnutí kladné regulace","MWh/den",null,{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668},{"$f":"'Vstupní data'!$C$15/$C$5","v":10.416666666666668}]
["Energie dokoupená po poskytnutí kladné regulace","MWh/rok",null,{"$f":"D25*$C$8","v":3677.0833333333339},{"$f":"E25*$C$8","v":3677.0833333333339},3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339,3677.0833333333339]
["Náklady na vlastní spotřebu energie","mil Kč",null,{"$f":"D26*D23/1000000","v":5.5000193791670089},5.6650199605420193,5.8916207589637004,6.1272855893222484,6.3723770128951394,6.6272720934109444,6.8923629771473829,7.1680574962332777,7.5264603710449416,7.9027833895971877,8.2979225590770476,8.7128186870309001,9.1484596213824467]
["Náklady za rezervovanou kapacitu přenosových zařízení","mil Kč",null,{"$f":"'Vstupní data'!C21","v":9.3866399999999999},{"$f":"D28","v":9.3866399999999999},{"$f":"E28","v":9.3866399999999999},9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999,9.3866399999999999]
["Provoz a údržba","% investice",{"$f":"'Vstupní data'!C23","v":0.02},{"$f":"C29*(1+D30)","v":2.0400000000000001E-2},{"$f":"D29*(1+E30)","v":2.0808000000000004E-2},{"$f":"E29*(1+F30)","v":2.1224160000000002E-2},{"$f":"F29*(1+G30)","v":2.1648643200000001E-2},2.2081616064000002E-2,2.2523248385280002E-2,2.2973713352985602E-2,2.3433187620045315E-2,2.3901851372446221E-2,2.4379888399895147E-2,2.4867486167893051E-2,2.5364835891250912E-2,2.5872132609075931E-2]
["Předpokládaný nominální růst ceny","%",null,{"$f":"C7","v":0.02},{"$f":"D30","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
["Náklady na provoz a údržbu","mil Kč",null,{"$f":"$C$3*C29","v":4.9000000000000004},{"$f":"$C$3*E29","v":5.0979600000000005},5.199919200000001,5.3039175840000006,5.4099959356800005,5.5181958543936007,5.6285597714814726,5.7411309669111024,5.8559535862493242,5.9730726579743108,6.0925341111337978,6.2143847933564738,6.3386724892236028]
["Pojištění majetku","% investice",null,{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01},{"$f":"'Vstupní data'!$C$22","v":0.01}]
["Náklady na pojištění majetku","mil Kč",null,{"$f":"C3*D32","v":2.4500000000000002},{"$f":"D33*(1+((E7)/100))","v":2.4500000000000002},2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002,2.4500000000000002]
["Náklady celkem bez odpisů","mil Kč",null,{"$f":"+D27+D28+D31+D33","v":22.236659379167008},{"$f":"+E27+E28+E31+E33","v":22.599619960542018},22.9281799589637,23.267843173322248,23.61901294857514,23.982107947804543,24.357562748628855,24.745828463144381,25.219053957294264,25.712496047571499,26.227096670210845,26.763843480387372,27.323772110606047]
["Účetní odpisy","% investice",null,{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2},{"$f":"'Vstupní data'!$C$25","v":7.6923076923076927E-2}]
["Účetní odpisy","mil Kč",null,{"$f":"$C$3*D35","v":18.846153846153847},{"$f":"$C$3*E35","v":18.846153846153847},18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847,18.846153846153847]
["Náklady celkem","mil Kč",null,{"$f":"D36+D34","v":41.082813225320855},{"$f":"E36+E34","v":41.445773806695868},41.77433380511755,42.113997019476095,42.465166794728987,42.82826179395839,43.203716594782705,43.591982309298231,44.065207803448111,44.558649893725345,45.073250516364695,45.609997326541219,46.169925956759897]
["EBT","mil Kč",null,{"$f":"MAX(D21-D37,0)","v":10.77891877165014},11.463952721384267,12.733767206709793,14.040873018127058,15.386336379240092,16.771252991877112,18.196748811941099,19.663980844033055,21.116480516047126,22.607937660496944,24.139255678883586,25.711351119683798,27.325153361227109]
["Daň (19%)","mil Kč",null,{"$f":"D38*0.19","v":2.0479945666135269},{"$f":"E38*0.19","v":2.1781510170630107},2.4194157692748606,2.6677658734441412,2.9234039120556177,3.1865380684566516,3.457382274268809,3.7361563603662806,4.0121312980489536,4.295508155494419,4.5864585789878811,4.8851567127399216,5.1917791386331507]
["EAT","mil Kč",null,{"$f":"D38-D39","v":8.7309242050366134},{"$f":"E38-E39","v":9.2858017043212566},10.314351437434933,11.373107144682917,12.462932467184475,13.58471492342046,14.739366537672289,15.927824483666775,17.104349217998173,18.312429505002527,19.552797099895706,20.826194406943877,22.133374222593957]
["Cash Flow","mil Kč",{"$f":"-C3","v":-245},{"$f":"D40+D36","v":27.577078051190462},28.131955550475105,29.16050528358878,30.219260990836766,31.309086313338319,32.430868769574303,33.585520383826136,34.773978329820622,35.950503064152016,{"$f":"M40+M36-M3","v":37.158583351156373},{"$f":"N40+N36","v":38.398950946049553},{"$f":"O40+O36","v":39.672348253097724},{"$f":"P40+P36","v":40.979528068747804}]
["Kumulovaný Cash Flow","mil Kč",{"$f":"C41","v":-245},{"$f":"C42+D41","v":-217.42292194880955},{"$f":"D42+E41","v":-189.29096639833443},-160.13046111474566,-129.91120012390888,-98.602113810570557,-66.171245040996254,-32.585724657170118,2.1882536726505037,38.13875673680252,75.297340087958901,113.69629103400845,153.36863928710619,194.348167355854]
["Diskontovaný Cash Flow","mil Kč",{"$f":"-C3","v":-245},{"$f":"D41/((1+($C$6))^D1)","v":25.534331528880056},24.118617584426527,23.148549258551778,22.212058957712351,21.308438059337512,20.436948472017566,19.596828563843165,18.787298481948067,17.984202025698398,17.211613834707595,16.468651877308684,15.754435329100362,15.068087424925315]
["Kumulovaný diskontovaný Cash Flow","mil Kč",{"$f":"C43","v":-245},{"$f":"C44+D43","v":-219.46566847111995},{"$f":"D44+E43","v":-195.34705088669344},{"$f":"E44+F43","v":-172.19850162814166},-149.98644267042931,-128.67800461109181,-108.24105613907425,-88.644227575231085,-69.856929093283014,-51.87272706758462,-34.661113232877028,-18.192461355568344,-2.4380260264679823,12.630061398457332]
[]
["IRR",{"$f":"IRR(C41:P41)","v":8.8589587552841159E-2}]
["NPV (mil Kč)",{"$f":"NPV(C6,D41,E41,F41,G41,H41,I41,J41,K41,L41,M41,N41,O41,P41)+C41","v":12.630061398457315}]
["Doba návratnosti (roky)",{"$f":"IF(COUNTIF(C42:P42,\"<0\")<14,COUNTIF(C42:P42,\"<0\"),\"x\")","v":8}]
["Diskontovaná doba návratnosti (roky)",{"$f":"IF(COUNTIF(C44:P44,\"<0\")<14,COUNTIF(C44:P44,\"<0\"),\"x\")","v":13}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Vývoj ceny za poskytování PR",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[{"$f":"Scénáře!C4","v":"základní "},null,null,{"$f":"Scénáře!D4","v":0.01},{"$f":"Scénáře!E4","v":0.01},{"$f":"Scénáře!F4","v":0.02},{"$f":"Scénáře!G4","v":0.02},{"$f":"Scénáře!H4","v":0.02},{"$f":"Scénáře!I4","v":0.02},{"$f":"Scénáře!J4","v":0.02},{"$f":"Scénáře!K4","v":0.02},{"$f":"Scénáře!L4","v":0.02},{"$f":"Scénáře!M4","v":0.02},{"$f":"Scénáře!N4","v":0.02},{"$f":"Scénáře!O4","v":0.02},{"$f":"Scénáře!P4","v":0.02}]
[{"$f":"Scénáře!C5","v":"příznivý"},null,null,{"$f":"Scénáře!D5","v":0.02},{"$f":"Scénáře!E5","v":0.02},{"$f":"Scénáře!F5","v":0.03},{"$f":"Scénáře!G5","v":0.03},{"$f":"Scénáře!H5","v":0.03},{"$f":"Scénáře!I5","v":0.03},{"$f":"Scénáře!J5","v":0.03},{"$f":"Scénáře!K5","v":0.03},{"$f":"Scénáře!L5","v":0.03},{"$f":"Scénáře!M5","v":0.03},{"$f":"Scénáře!N5","v":0.03},{"$f":"Scénáře!O5","v":0.03},{"$f":"Scénáře!P5","v":0.03}]
[{"$f":"Scénáře!C6","v":"nepříznivý"},null,null,{"$f":"Scénáře!D6","v":0},{"$f":"Scénáře!E6","v":0},{"$f":"Scénáře!F6","v":0.01},{"$f":"Scénáře!G6","v":0.01},{"$f":"Scénáře!H6","v":0.01},{"$f":"Scénáře!I6","v":0.01},{"$f":"Scénáře!J6","v":0.01},{"$f":"Scénáře!K6","v":0.01},{"$f":"Scénáře!L6","v":0.01},{"$f":"Scénáře!M6","v":0.01},{"$f":"Scénáře!N6","v":0.01},{"$f":"Scénáře!O6","v":0.01},{"$f":"Scénáře!P6","v":0.01}]
[]
["Vývoj ceny elektřiny na VDT",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[{"$f":"Scénáře!C9","v":"základní "},null,null,{"$f":"Scénáře!D9","v":0.03},{"$f":"Scénáře!E9","v":0.03},{"$f":"Scénáře!F9","v":0.04},{"$f":"Scénáře!G9","v":0.04},{"$f":"Scénáře!H9","v":0.04},{"$f":"Scénáře!I9","v":0.04},{"$f":"Scénáře!J9","v":0.04},{"$f":"Scénáře!K9","v":0.04},{"$f":"Scénáře!L9","v":0.05},{"$f":"Scénáře!M9","v":0.05},{"$f":"Scénáře!N9","v":0.05},{"$f":"Scénáře!O9","v":0.05},{"$f":"Scénáře!P9","v":0.05}]
[{"$f":"Scénáře!C10","v":"příznivý"},null,null,{"$f":"Scénáře!D10","v":0.01},{"$f":"Scénáře!E10","v":0.01},{"$f":"Scénáře!F10","v":0.02},{"$f":"Scénáře!G10","v":0.02},{"$f":"Scénáře!H10","v":0.02},{"$f":"Scénáře!I10","v":0.02},{"$f":"Scénáře!J10","v":0.02},{"$f":"Scénáře!K10","v":0.02},{"$f":"Scénáře!L10","v":0.03},{"$f":"Scénáře!M10","v":0.03},{"$f":"Scénáře!N10","v":0.03},{"$f":"Scénáře!O10","v":0.03},{"$f":"Scénáře!P10","v":0.03}]
[{"$f":"Scénáře!C11","v":"nepříznivý"},null,null,{"$f":"Scénáře!D11","v":0.05},{"$f":"Scénáře!E11","v":0.05},{"$f":"Scénáře!F11","v":0.06},{"$f":"Scénáře!G11","v":0.06},{"$f":"Scénáře!H11","v":0.06},{"$f":"Scénáře!I11","v":0.06},{"$f":"Scénáře!J11","v":0.06},{"$f":"Scénáře!K11","v":0.06},{"$f":"Scénáře!L11","v":7.0000000000000007E-2},{"$f":"Scénáře!M11","v":7.0000000000000007E-2},{"$f":"Scénáře!N11","v":7.0000000000000007E-2},{"$f":"Scénáře!O11","v":7.0000000000000007E-2},{"$f":"Scénáře!P11","v":7.0000000000000007E-2}]

{"sheet":"Výsledné vyhodnocení","index":3,"n_rows":15,"n_cols":26,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,16,5,25],[10,16,10,25],[2,8,2,9],[2,11,2,12],[3,17,3,19],[3,20,3,22],[3,23,3,25]]}
["Výsledné vyhodnocení"]
[]
["Scénář předpokládaného vývoje ceny za poskytování služby PR:",null,null,null,null,null,null,null,"Varianta A",null,null,"Varianta B"]
[null,null,null,null,null,null,null,null,"IRR",{"$f":"'Varianta A'!B46","v":0.10987934755983178},null,"IRR",{"$f":"'Varianta B'!B46","v":8.8589587552841159E-2},null,null,null,"Scénář vývoje cen za PR","PR1",null,null,"PR2",null,null,"PR3"]
[null,null,null,null,null,null,null,null,"NPV (mil Kč)",{"$f":"'Varianta A'!B47","v":45.372660497122467},null,"NPV (mil Kč)",{"$f":"'Varianta B'!B47","v":12.630061398457315},null,null,null,"Scénář vývoje ceny elektřiny na VDT","VDT1","VDT2","VDT3","VDT1","VDT2","VDT3","VDT1","VDT2","VDT3"]
["Scénář předpokládaného vývoje průměrné ceny elektřiny na VDT:",null,null,null,null,null,null,null,"Doba návratnosti",{"$f":"'Varianta A'!B48","v":8},null,"Doba návratnosti",{"$f":"'Varianta B'!B48","v":8},null,null,null,"Varianta A"]
[null,null,null,null,null,null,null,null,"Diskontovaná doba návratnosti",{"$f":"'Varianta A'!B49","v":11},null,"Diskontovaná doba návratnosti",{"$f":"'Varianta B'!B49","v":13},null,null,null,"IRR",9.5923620768235379E-2,9.6077225260583127E-2,9.5745992628613094E-2,0.10987934755983178,0.11001946905829932,0.10971776628188008,8.1664453562908523E-2,8.1833760042554216E-2,8.1468100956456596E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPV (mil Kč)",23.052213443699543,23.287304596363867,22.779850542810493,45.372660497122467,45.607751649786735,45.100297596233361,2.2959545802087291,2.5310457328729399,2.0235916793196225]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doba návratnosti",8,8,8,8,8,8,8,8,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diskontovaná doba návratnosti",12,12,12,11,11,11,13,13,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Varianta B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRR",7.3048433447777339E-2,7.6000648760967709E-2,6.9540302266164186E-2,8.8589587552841159E-2,9.1243762386316554E-2,8.5456243277616681E-2,5.6926466335783334E-2,6.0238240249761252E-2,5.2961140575050823E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPV (mil Kč)",-9.6903856549654961,-5.6338297318993114,-14.390074802362506,12.630061398457315,16.686617321523556,7.930372251060362,-30.446644518456338,-26.390088595390097,-35.146333665853348]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doba návratnosti",9,9,9,8,8,9,10,9,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diskontovaná doba návratnosti","x","x","x",13,12,13,"x","x","x"]

{"sheet":"Ceny za PR","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Ceny za MW poskytované zálohy PR za hodinu"]
[]
[null,"Rok","Průměr (Kč)","Změna (%)"]
[null,2008,868,"x"]
[null,2009,869,{"$f":"C5/C4-1","v":1.1520737327188613E-3}]
[null,2010,872,{"$f":"C6/C5-1","v":3.4522439585731313E-3}]
[null,2011,465,-0.46674311926605505]
[null,2012,761,0.63655913978494616]
[null,2013,822,8.0157687253613608E-2]
[null,2014,732,-0.10948905109489049]
[null,2015,633,-0.13524590163934425]
[null,2016,653,3.1595576619273258E-2]

{"sheet":"Ceny elektřiny na VDT","index":5,"n_rows":25,"n_cols":26,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,0,2,2]]}
["Ceny elektřiny na VDT"]
[]
["Vývoj cen na VDT"]
["Rok","Vážený průměr cen (Kč/MWh)","změna (%)"]
[2008,1043.4615388977415,"x"]
[2009,496.30367591923141,{"$f":"B6/B5-1","v":-0.52436802180222108}]
[2010,1078.965264262589,{"$f":"B7/B6-1","v":1.17400216160837},1078.965264262589]
[2011,1062.3153827994433,-1.5431341503403195E-2,1062.3153827994433]
[2012,1092.9253313755339,2.8814370074757178E-2,1092.9253313755339]
[2013,1050.9384338291825,-3.8416986358535188E-2,1050.9384338291825]
[2014,969.44157326665663,-7.7546750541404363E-2,969.44157326665663]
[2015,976.45624066614369,7.2357814982602076E-3,976.45624066614369]
[2016,863.45587179292966,-0.11572496970895962,863.45587179292966]
[]
[]
[]
[]
[null,"VDT, 2016 - hodina","1.","2.","3.","4.","5.","6.","7.","8.","9.","10.","11.","12.","13.","14.","15.","16.","17.","18.","19.","20.","21.","22.","23.","24."]
[null,"Vážený průměr cen v hodině roku (Kč/MWh)",694.83777348057527,663.35961502288478,645.90175780992388,640.06430063075322,616.53070592963888,649.82258771190698,764.86825152960785,849.94953787195664,941.066151066001,968.126846906374,899.10566618384303,921.68127667801912,918.80470563340305,907.16543850293237,902.64432915245641,913.951639601642,853.94709431976173,926.22006802356179,935.40730669736411,964.1667021471826,868.48584106092278,854.79859359474005,799.50198317207855,736.0261764225545]
[]
[null,"Cena elektřiny v nejdražší hodině",{"$f":"MAX(C19:Z19)","v":968.126846906374}]
[null,"Cena elektřiny v nejlevnější hodině",{"$f":"MIN(C19:Z19)","v":616.53070592963888}]
[]
[null,"Cena kupované elektřiny",{"$f":"1.5*C21","v":1452.1902703595611}]
[null,"Cena prodávané elektřiny",{"$f":"0.5*C22","v":308.26535296481944}]

{"sheet":"Ilustrace odchylek frekvence","index":6,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Vyhodnoceno z dat odchylek frekvene anonymního patnáctidenního období, která mi k nahlédnutí a vypočtení odvozených hodnot laskavě poskytl inženýr Zdeněk Hruška"]
[]
[null,"Průměrné odchylky frekvence v námi sledovaném patnáctidenním období  (mHz)"]
[null,"kladná odchylka",5.44]
[null,"záporná odchylka",-9.42]
[null,"Odvozený průměrný požadavek na výši regulačního výkonu (% z Pmax)"]
[null,"záporný regulační výkon",{"$f":"-C4/200","v":-2.7200000000000002E-2}]
[null,"kladný regulační výkon",{"$f":"-C5/200","v":4.7100000000000003E-2}]
[null,"Průměrná výše energie dodávané a odebírané naší 10 MW baterií (MWh)"]
[null,"hodinová záporná energie",{"$f":"C7*10","v":-0.27200000000000002}]
[null,"hodinová kladná energie",{"$f":"C8*10","v":0.47100000000000003}]
[null,"denní záporná energie",{"$f":"C10*24","v":-6.5280000000000005}]
[null,"denní kladná energie",{"$f":"C11*24","v":11.304}]
[null,"poznámka: pro vyrovnání kladné odchylky frekvence, je třeba dodat záporný výkon a naopak"]

{"sheet":"Scénáře","index":7,"n_rows":11,"n_cols":19,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Scénáře vývojů cen"]
[]
[null,null,"Vývoj ceny za poskytování PR",1,2,3,4,5,6,7,8,9,10,11,12,13,null,"Varianta/Scénář","Zkratka"]
[null,null,"základní ",0.01,0.01,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,null,"Varianta A","A"]
[null,null,"příznivý",0.02,0.02,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,null,"Varianta B","B"]
[null,null,"nepříznivý",0,0,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,null,"Základní vývoj ceny za poskytování PR","PR1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Příznivý vývoj ceny za poskytování PR","PR2"]
[null,null,"Vývoj ceny elektřiny na VDT",1,2,3,4,5,6,7,8,9,10,11,12,13,null,"Nepříznivý vývoj ceny za poskytování PR","PR3"]
[null,null,"základní ",0.03,0.03,0.04,0.04,0.04,0.04,0.04,0.04,0.05,0.05,0.05,0.05,0.05,null,"Základní vývoj ceny elektřiny na VDT","VDT1"]
[null,null,"příznivý",0.01,0.01,0.02,0.02,0.02,0.02,0.02,0.02,0.03,0.03,0.03,0.03,0.03,null,"Příznivý vývoj ceny elektřiny na VDT","VDT2"]
[null,null,"nepříznivý",0.05,0.05,0.06,0.06,0.06,0.06,0.06,0.06,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,null,"Nepříznivý vývoj ceny elektřiny na VDT","VDT3"]