{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Zadání","Data","Cash Flow","graf Cash Flow","Příjmy","Výdaje","CF - pro tisk"],"not_rendered":{"charts":10,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"graf Cash Flow","index":3,"reason":"not_a_worksheet"}],"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":"Zadání","index":0,"n_rows":109,"n_cols":27,"rows_kept":109,"cut":false,"hidden":false,"merged":[[82,5,82,15],[84,3,108,3],[22,1,22,12],[26,1,26,12],[43,1,43,26],[39,1,39,24],[35,1,35,26],[30,1,30,12]]}
[]
[null,"Volitelné parametry"]
[null,"cena elektřiny [Kč/kWh]",1.31]
[null,"eskalace ceny elektřiny [%]",2]
[null,"cena uhlí [Kč/q]",310]
[null,"eskalace ceny uhlí [%]",2]
[null,"začátek topné sezony [-]","2016-09-24"]
[null,"konec topné sezony [-]","2016-05-06"]
[null,"nominální diskotní míra [%]",3.53]
[null,"ekonomická životnost [rok]",25,"(1-25)"]
[]
[null,"NPV [Kč]",{"$f":"ROUND('Cash Flow'!C19+NPV(C9/100,OFFSET('Cash Flow'!D19,,,,Zadání!C10)),-3)","v":-192000}]
[]
[null,"IRR [%]",-11.973675189406899]
[null,"Cena elektřiny pro NPV=0 [Kč]",4.6856572649572596]
[]
[]
[]
[]
[]
[]
[]
[null,"Citlivostní analýza na eskalaci cen elektřiny"]
[null,null,0,1.25,2.5,3.75,5,6.25,7.5,8.75,10,11.25,12.5]
[null,{"$f":"$C$12","v":-192000},-207000,-198000,-188000,-175000,-159000,-140000,-118000,-90000,-56000,-14000,37000]
[]
[null,"Citlivostní analýza na cenu elektřiny"]
[null,null,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5]
[null,{"$f":"$C$12","v":-192000},-238000,-210000,-181000,-153000,-124000,-96000,-67000,-39000,-10000,18000,47000]
[]
[null,"Citlivostní analýza na eskalaci cen uhlí"]
[null,null,0,1.5,3,4.5,6,7.5,9,10.5,12,13.5,15]
[null,{"$f":"$C$12","v":-192000},-200000,-194000,-187000,-178000,-167000,-152000,-134000,-111000,-82000,-44000,4000]
[]
[]
[null,"Citlivostní analýza na cenu uhlí"]
[null,null,100,175,250,325,400,475,550,625,700,775,850,925,1000,1075,1150,1225,1300,1375,1450,1525,1600,1675,1750,1825,1900]
[null,{"$f":"C12","v":-192000},-219000,-209000,-200000,-190000,-180000,-171000,-161000,-152000,-142000,-132000,-123000,-113000,-104000,-94000,-84000,-75000,-65000,-56000,-46000,-37000,-27000,-17000,-8000,2000,11000]
[]
[null,"Ciltivostní analýza na diskotní míru"]
[null,null,-13,-12,-11,-10,-9,-8,-7,-6,-5,-4,-3,-2,-1,0,1,2,3,4,5,6,7,8,9]
[null,{"$f":"C12","v":-192000},31000,1000,-26000,-51000,-72000,-91000,-108000,-122000,-134000,-145000,-154000,-163000,-170000,-176000,-181000,-186000,-190000,-194000,-197000,-200000,-202000,-205000,-207000]
[]
[null,"Citlivostní analýza na dobu životnosti"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,{"$f":"C12","v":-192000},-250000,-245000,-240000,-237000,-232000,-228000,-223000,-221000,-216000,-216000,-212000,-210000,-206000,-202000,-217000,-215000,-211000,-208000,-205000,-206000,-203000,-200000,-197000,-195000,-192000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Cena elektřiny [Kč/kWh]"]
[null,null,null,null,{"$f":"C12","v":-192000},0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5]
[null,null,null,"Cena uhlí [Kč/q]",300,-239000,-211000,-182000,-154000,-125000,-97000,-68000,-40000,-11000,17000,45000]
[null,null,null,null,375,-230000,-201000,-173000,-144000,-116000,-87000,-59000,-30000,-2000,27000,55000]
[null,null,null,null,450,-220000,-192000,-163000,-135000,-106000,-78000,-49000,-21000,8000,36000,65000]
[null,null,null,null,525,-211000,-182000,-154000,-125000,-97000,-68000,-40000,-11000,17000,46000,74000]
[null,null,null,null,600,-201000,-173000,-144000,-116000,-87000,-59000,-30000,-2000,27000,55000,84000]
[null,null,null,null,675,-191000,-163000,-134000,-106000,-77000,-49000,-20000,8000,36000,65000,93000]
[null,null,null,null,750,-182000,-153000,-125000,-96000,-68000,-39000,-11000,18000,46000,75000,103000]
[null,null,null,null,825,-172000,-144000,-115000,-87000,-58000,-30000,-1000,27000,56000,84000,113000]
[null,null,null,null,900,-163000,-134000,-106000,-77000,-49000,-20000,8000,37000,65000,94000,122000]
[null,null,null,null,975,-153000,-125000,-96000,-68000,-39000,-11000,18000,46000,75000,103000,132000]
[null,null,null,null,1050,-143000,-115000,-86000,-58000,-29000,-1000,28000,56000,84000,113000,141000]
[null,null,null,null,1125,-134000,-105000,-77000,-48000,-20000,9000,37000,66000,94000,123000,151000]
[null,null,null,null,1200,-124000,-96000,-67000,-39000,-10000,18000,47000,75000,104000,132000,161000]
[null,null,null,null,1275,-115000,-86000,-58000,-29000,-1000,28000,56000,85000,113000,142000,170000]
[null,null,null,null,1350,-105000,-77000,-48000,-20000,9000,37000,66000,94000,123000,151000,180000]
[null,null,null,null,1425,-95000,-67000,-38000,-10000,19000,47000,75000,104000,132000,161000,189000]
[null,null,null,null,1500,-86000,-57000,-29000,0,28000,57000,85000,114000,142000,171000,199000]
[null,null,null,null,1575,-76000,-48000,-19000,9000,38000,66000,95000,123000,152000,180000,209000]
[null,null,null,null,1650,-67000,-38000,-10000,19000,47000,76000,104000,133000,161000,190000,218000]
[null,null,null,null,1725,-57000,-29000,0,28000,57000,85000,114000,142000,171000,199000,228000]
[null,null,null,null,1800,-47000,-19000,10000,38000,67000,95000,123000,152000,180000,209000,237000]
[null,null,null,null,1875,-38000,-9000,19000,48000,76000,105000,133000,162000,190000,219000,247000]
[null,null,null,null,1950,-28000,0,29000,57000,86000,114000,143000,171000,200000,228000,257000]
[null,null,null,null,2025,-19000,10000,38000,67000,95000,124000,152000,181000,209000,238000,266000]
[null,null,null,null,2100,-9000,19000,48000,76000,105000,133000,162000,190000,219000,247000,276000]

{"sheet":"Data","index":1,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,0,1,3],[1,9,1,12],[1,14,1,16]]}
[]
["Vyrobená elektřina během 0.tého roku",null,null,null,null,null,null,null,null,"Vyrobená elektřina v jednotlivých letech",null,null,null,null,"Příjmy 0. roku"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"elektřina","uhlí"]
[null,"měsíc","E [kWh]",null,null,null,null,null,null,null,"rok","E [kWh]",null,null,"ušetřeno část prvního měsíce [kWh]",{"$f":"INDEX(B5:C16,MONTH(Zadání!C7),2)/30*DAY(Zadání!C7)","v":434.40000000000003},{"$f":"INDEX(B5:C16,MONTH(Zadání!C7),2)/30*(30-DAY(Zadání!C7))","v":108.60000000000001}]
[null,"leden",174,null,null,null,null,null,null,null,1,{"$f":"C17*0.975","v":5619.9},null,null,"ušetřeno v průběhu [kWh]",{"$f":"ForC(MONTH(Zadání!C8)+4+1, MONTH(Zadání!C7)+4-1)","v":2067},{"$f":"ForC(MONTH(Zadání!C7)+4+1, MONTH(Zadání!C8)+4-1)","v":2445}]
[null,"únor",290,null,null,null,null,null,null,null,2,{"$f":"L5-($C$17/100*0.7)","v":5579.5519999999997},null,null,"ušetřeno část posledního měsíce [kWh]",{"$f":"INDEX(B5:C16,MONTH(Zadání!C8),2)/30*(30-DAY(Zadání!C8))","v":567.20000000000005},{"$f":"INDEX(B5:C16,MONTH(Zadání!C8),2)/30*DAY(Zadání!C8)","v":141.80000000000001}]
[null,"březen",542,null,null,null,null,null,null,null,3,5539.2039999999997]
[null,"duben",695,null,null,null,null,null,null,null,4,5498.8559999999998,null,null,"ušetřeno celkem [kWh]",{"$f":"SUM(P4:P6)","v":3068.6000000000004},{"$f":"SUM(Q4:Q6)","v":2695.4}]
[null,"květen",709,null,null,null,null,null,null,null,5,5458.5079999999998]
[null,"červen",699,null,null,null,null,null,null,null,6,5418.16]
[null,"červenec",700,null,null,null,null,null,null,null,7,5377.8119999999999,null,null,"ušetřená elektřina [Kč]",{"$f":"P8*Zadání!C3","v":4019.8660000000004}]
[null,"srpen",668,null,null,null,null,null,null,null,8,5337.4639999999999,null,null,"ušetřené uhlí [Kč]",{"$f":"Zadání!C5/(0.8*100*17.6*10^6/3600*10^-3)*Q8","v":2136.4107954545457}]
[null,"září",543,null,null,null,null,null,null,null,9,5297.116]
[null,"říjen",399,null,null,null,null,null,null,null,10,5256.768,null,null,"ušetřeno celkem [Kč]",{"$f":"SUM(P11:P12)","v":6156.2767954545461}]
[null,"listopad",195,null,null,null,null,null,null,null,11,5216.42]
[null,"prosinec",150,null,null,null,null,null,null,null,12,5176.0720000000001]
[null,"celkem",{"$f":"SUM(C5:C16)","v":5764},null,null,null,null,null,null,null,13,5135.7240000000002]
[null,null,null,null,null,null,null,null,null,null,14,5095.3760000000002]
[null,null,null,null,null,null,null,null,null,null,15,5055.0280000000002]
[null,null,null,null,null,null,null,null,null,null,16,5014.68]
[null,null,null,null,null,null,null,null,null,null,17,4974.3320000000003]
[null,null,null,null,null,null,null,null,null,null,18,4933.9840000000004]
[null,null,null,null,null,null,null,null,null,null,19,4893.6360000000004]
[null,null,null,null,null,null,null,null,null,null,20,4853.2880000000005]
[null,null,null,null,null,null,null,null,null,null,21,4812.9400000000005]
[null,null,null,null,null,null,null,null,null,null,22,4772.5920000000006]
[null,null,null,null,null,null,null,null,null,null,23,4732.2440000000006]
[null,null,null,null,null,null,null,null,null,null,24,4691.8960000000006]
[null,null,null,null,null,null,null,null,null,null,25,{"$f":"C17*0.802","v":4622.7280000000001}]

{"sheet":"Cash Flow","index":2,"n_rows":19,"n_cols":28,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Rok",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,"1) Příjmy"]
[null,"Dotace",{"$f":"35000+5000","v":40000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Ušetřené výdaje za elektřinu",0,{"$f":"FV(Zadání!$C$4/100,D3,,-Data!$P$11*0.975)","v":3997.7567370000006},{"$f":"FV(Zadání!$C$4/100,E3,,-Data!$P$11*0.968)","v":4048.4359916352},{"$f":"FV(Zadání!$C$4/100,F3,,-Data!$P$11*0.961)","v":4099.543313761008},{"$f":"FV(Zadání!$C$4/100,G3,,-Data!$P$11*0.954)","v":4151.0755543751948},{"$f":"FV(Zadání!$C$4/100,H3,,-Data!$P$11*0.947)","v":4203.0292672884434},{"$f":"FV(Zadání!$C$4/100,I3,,-Data!$P$11*0.94)","v":4255.4006984964735},{"$f":"FV(Zadání!$C$4/100,J3,,-Data!$P$11*0.933)","v":4308.1857752459073},{"$f":"FV(Zadání!$C$4/100,K3,,-Data!$P$11*0.926)","v":4361.3800947859218},{"$f":"FV(Zadání!$C$4/100,L3,,-Data!$P$11*0.919)","v":4414.9789127974382},{"$f":"FV(Zadání!$C$4/100,M3,,-Data!$P$11*0.912)","v":4468.9771314915006},{"$f":"FV(Zadání!$C$4/100,N3,,-Data!$P$11*0.905)","v":4523.3692873682057},{"$f":"FV(Zadání!$C$4/100,O3,,-Data!$P$11*0.898)","v":4578.1495386273837},{"$f":"FV(Zadání!$C$4/100,P3,,-Data!$P$11*0.891)","v":4633.3116522219798},{"$f":"FV(Zadání!$C$4/100,Q3,,-Data!$P$11*0.884)","v":4688.8489905449105},{"$f":"FV(Zadání!$C$4/100,R3,,-Data!$P$11*0.877)","v":4744.7544977398675},{"$f":"FV(Zadání!$C$4/100,S3,,-Data!$P$11*0.87)","v":4801.0206856264076},{"$f":"FV(Zadání!$C$4/100,T3,,-Data!$P$11*0.863)","v":4857.6396192293123},{"$f":"FV(Zadání!$C$4/100,U3,,-Data!$P$11*0.856)","v":4914.6029019020816},{"$f":"FV(Zadání!$C$4/100,V3,,-Data!$P$11*0.849)","v":4971.901660034071},{"$f":"FV(Zadání!$C$4/100,W3,,-Data!$P$11*0.842)","v":5029.5265273305795},{"$f":"FV(Zadání!$C$4/100,X3,,-Data!$P$11*0.835)","v":5087.4676286549338},{"$f":"FV(Zadání!$C$4/100,Y3,,-Data!$P$11*0.828)","v":5145.7145634213311},{"$f":"FV(Zadání!$C$4/100,Z3,,-Data!$P$11*0.821)","v":5204.2563885269201},{"$f":"FV(Zadání!$C$4/100,AA3,,-Data!$P$11*0.814)","v":5263.0816008113652},{"$f":"FV(Zadání!$C$4/100,AB3,,-Data!$P$11*0.802)","v":5289.2030377490546}]
[null,"Ušetřené výdaje za uhlí",0,{"$f":"FV(Zadání!$C$6/100,D3,,-Data!$P$12*0.975)","v":2124.6605360795461},{"$f":"FV(Zadání!$C$6/100,E3,,-Data!$P$12*0.968)","v":2151.5946942599999},{"$f":"FV(Zadání!$C$6/100,F3,,-Data!$P$12*0.961)","v":2178.7563545532407},{"$f":"FV(Zadání!$C$6/100,G3,,-Data!$P$12*0.954)","v":2206.1438433805074},{"$f":"FV(Zadání!$C$6/100,H3,,-Data!$P$12*0.947)","v":2233.7553292190437},{"$f":"FV(Zadání!$C$6/100,I3,,-Data!$P$12*0.94)","v":2261.5888169537689},{"$f":"FV(Zadání!$C$6/100,J3,,-Data!$P$12*0.933)","v":2289.642142066195},{"$f":"FV(Zadání!$C$6/100,K3,,-Data!$P$12*0.926)","v":2317.9129646563374},{"$f":"FV(Zadání!$C$6/100,L3,,-Data!$P$12*0.919)","v":2346.3987632932585},{"$f":"FV(Zadání!$C$6/100,M3,,-Data!$P$12*0.912)","v":2375.0968286897942},{"$f":"FV(Zadání!$C$6/100,N3,,-Data!$P$12*0.905)","v":2404.0042571968738},{"$f":"FV(Zadání!$C$6/100,O3,,-Data!$P$12*0.898)","v":2433.1179441127611},{"$f":"FV(Zadání!$C$6/100,P3,,-Data!$P$12*0.891)","v":2462.4345768024045},{"$f":"FV(Zadání!$C$6/100,Q3,,-Data!$P$12*0.884)","v":2491.950627621989},{"$f":"FV(Zadání!$C$6/100,R3,,-Data!$P$12*0.877)","v":2521.6623466436349},{"$f":"FV(Zadání!$C$6/100,S3,,-Data!$P$12*0.87)","v":2551.5657541750998},{"$f":"FV(Zadání!$C$6/100,T3,,-Data!$P$12*0.863)","v":2581.6566330691644},{"$f":"FV(Zadání!$C$6/100,U3,,-Data!$P$12*0.856)","v":2611.9305208173218},{"$f":"FV(Zadání!$C$6/100,V3,,-Data!$P$12*0.849)","v":2642.3827014221779},{"$f":"FV(Zadání!$C$6/100,W3,,-Data!$P$12*0.842)","v":2673.0081970429019},{"$f":"FV(Zadání!$C$6/100,X3,,-Data!$P$12*0.835)","v":2703.8017594078851},{"$f":"FV(Zadání!$C$6/100,Y3,,-Data!$P$12*0.828)","v":2734.7578609886509},{"$f":"FV(Zadání!$C$6/100,Z3,,-Data!$P$12*0.821)","v":2765.8706859288836},{"$f":"FV(Zadání!$C$6/100,AA3,,-Data!$P$12*0.814)","v":2797.1341207223304},{"$f":"FV(Zadání!$C$6/100,AB3,,-Data!$P$12*0.802)","v":2811.016702844835}]
[null,"Příjmy celkem",{"$f":"SUM(C5:C7)","v":40000},{"$f":"SUM(D5:D7)","v":6122.4172730795472},6200.0306858951999,6278.2996683142483,6357.2193977557017,6436.7845965074866,6516.9895154502428,6597.8279173121027,6679.2930594422596,6761.3776760906967,6844.0739601812948,6927.37354456508,7011.2674827401443,7095.7462290243839,7180.7996181668996,7266.4168443835024,7352.5864398015074,7439.2962522984762,7526.5334227194035,7614.2843614562489,7702.5347243734814,7791.2693880628194,7880.4724244099816,7970.1270744558042,8060.2157215336956,8100.2197405938896]
[]
[null,"2) Výdaje"]
[null,"Investiční výdaje",282103.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Reinvestice",0,0,0,0,0,0,0,0,0,0,{"$f":"FV(0.02,M3,,-4893)","v":5964.5396970343463},0,0,0,0,{"$f":"FV(0.02,M3,,-25472)","v":31050.225866106452},0,0,0,0,{"$f":"FV(0.02,W3,,-4893)","v":7270.7406085220873},0,0,0,0,0]
[null,"Čištění",0,{"$f":"FV(0.02,D3,,-580)","v":591.6},{"$f":"FV(0.02,E3,,-580)","v":603.43200000000002},615.50063999999998,627.81065279999996,640.366865856,653.17420317312008,666.23768723658225,679.56244098131401,693.15368980094024,707.01676359695909,721.15709886889817,735.5802408462763,750.29184566320168,765.29768257646583,780.60363622799491,796.21570895255502,812.1400231316062,828.38282359423818,844.95048006612296,861.84948966744548,879.08647946079429,896.6682090500102,914.60157323101032,932.89360469563053,0]
[null,"Pojištění",0,{"$f":"FV(0.02,D3,,-482)","v":491.64},{"$f":"FV(0.02,E3,,-482)","v":501.47280000000001},511.50225599999999,{"$f":"FV(0.02,G3,,-482)","v":521.73230111999999},532.16694714239998,542.81028608524798,553.66649180695288,564.739821643092,576.03461807595386,587.55531043747294,599.30641664622226,611.29254497914678,623.51839587872973,635.9887637963044,648.70853907223034,661.68270985367496,674.9163640507486,688.41469133176349,702.18298515839865,716.2266448615668,730.55117775879808,745.16220131397404,760.0654453402534,775.26675424705843,790.77208933199961]
[null,"Revize",0,0,0,0,{"$f":"FV(0.02,G3,,-1500)","v":1623.64824},0,0,0,{"$f":"FV(0.02,K3,,-1500)","v":1757.4890715033982},0,0,0,1902.3626918438179,0,0,0,2059.178557635918,0,0,0,2228.9210939675313,0,0,0,2412.6558742128377,0]
[null,"Demontáž",{"$f":"IF(Zadání!$C$10='Cash Flow'!C3,FV(0.02,C3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!D3,FV(0.02,D3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!E3,FV(0.02,E3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!F3,FV(0.02,F3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!G3,FV(0.02,G3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!H3,FV(0.02,H3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!I3,FV(0.02,I3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!J3,FV(0.02,J3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!K3,FV(0.02,K3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!L3,FV(0.02,L3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!M3,FV(0.02,M3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!N3,FV(0.02,N3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!O3,FV(0.02,O3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!P3,FV(0.02,P3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!Q3,FV(0.02,Q3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!R3,FV(0.02,R3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!S3,FV(0.02,S3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!T3,FV(0.02,T3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!U3,FV(0.02,U3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!V3,FV(0.02,V3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!W3,FV(0.02,W3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!X3,FV(0.02,X3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!Y3,FV(0.02,Y3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!Z3,FV(0.02,Z3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!AA3,FV(0.02,AA3,,-13000),0)","v":0},{"$f":"IF(Zadání!$C$10='Cash Flow'!AB3,FV(0.02,AB3,,-13000),0)","v":21327.877928041486}]
[null,"Výdaje celkem",{"$f":"SUM(C11:C16)","v":282103.05},1083.24,1104.9048,1127.002896,2773.1911939199999,1172.5338129984,1195.9844892583681,1219.9041790435351,3001.7913341278045,1269.1883078768942,7259.1117710687786,1320.4635155151204,3249.2354776692409,1373.8102415419314,1401.2864463727701,32479.538041406679,3517.076976442148,1487.0563871823547,1516.7975149260017,1547.1334652245216,11077.737837018631,1609.6376572195923,1641.8304103639844,1674.6670185712637,4120.8162331555268,22118.650017373486]
[]
[null,"Cash Flow",{"$f":"C8-C17","v":-242103.05},5039.1772730795474,5095.1258858951996,5151.2967723142483,3584.0282038357018,5264.2507835090864,5321.005026191875,5377.9237382685678,3677.5017253144551,5492.1893682138025,-415.03781088748383,5606.9100290499591,3762.0320050709033,5721.9359874824522,5779.5131717941294,-25213.121197023174,3835.5094633593594,5952.239865116122,6009.7359077934016,6067.1508962317275,-3375.2031126451493,6181.6317308432272,6238.6420140459977,6295.4600558845405,3939.3994883781688,-14018.430276779596]

{"sheet":"Příjmy","index":4,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"rok","příjmy [Kč]","poznámka"]
[null,0,40000,"dotace"]
[null,1,6190.9547097272734]
[null,2,6269.4369663551997]
[null,3,6364.9643079754078]
[null,4,6461.8049684738817]
[null,5,6559.9732696691044]
[null,6,6659.4835809247488]
[null,7,6760.3503153227466]
[null,8,6862.5879256642984]
[null,9,6966.210900293383]
[null,10,7071.233758737364]
[null,11,7177.6710471589859]
[null,12,7285.5373336139801]
[null,13,7394.8472031083074]
[null,14,7505.6152524489653]
[null,15,7617.8560848820025]
[null,16,7731.5843045113852]
[null,17,7846.8145104919904]
[null,18,7963.5612909900128]
[null,19,8081.8392169037606]
[null,20,8201.6628353376636]
[null,21,8323.0466628221584]
[null,22,8446.005178271902]
[null,23,8570.5528156745004]
[null,24,8696.7039565018968]
[null,25,8190.8976987501737]

{"sheet":"Výdaje","index":5,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"rok","výdaj [Kč]","poznámka"]
[null,0,282103.05,"Investiční výdaje"]
[null,1,1083.24]
[null,2,1104.9048]
[null,3,1127.002896]
[null,4,2773.1911939199999]
[null,5,1172.5338129984]
[null,6,1195.9844892583681]
[null,7,1219.9041790435351]
[null,8,3001.7913341278045]
[null,9,1269.1883078768942]
[null,10,7259.1117710687786]
[null,11,1320.4635155151204]
[null,12,3249.2354776692409]
[null,13,1373.8102415419314]
[null,14,1401.2864463727701]
[null,15,32479.538041406679]
[null,16,3517.076976442148]
[null,17,1487.0563871823547]
[null,18,1516.7975149260017]
[null,19,1547.1334652245216]
[null,20,11077.737837018631]
[null,21,1609.6376572195923]
[null,22,1641.8304103639844]
[null,23,1674.6670185712637]
[null,24,4120.8162331555268]
[null,25,20790.772089332]

{"sheet":"CF - pro tisk","index":6,"n_rows":17,"n_cols":30,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Rok",0,1,2,3,4,5,6,7,8,9,10,null,null,"Rok",11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
["1) Příjmy",null,null,null,null,null,null,null,null,null,null,null,null,null,"1) Příjmy"]
["Dotace",40000,0,0,0,0,0,0,0,0,0,0,null,null,"Dotace",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Ušetřené výdaje za elektřinu",0,3997.7567370000006,4048.4359916352,4099.543313761008,4151.0755543751948,4203.0292672884434,4255.4006984964735,4308.1857752459073,4361.3800947859218,4414.9789127974382,4468.9771314915006,null,null,"Ušetřené výdaje za elektřinu",4523.3692873682057,4578.1495386273837,4633.3116522219798,4688.8489905449105,4744.7544977398675,4801.0206856264076,4857.6396192293123,4914.6029019020816,4971.901660034071,5029.5265273305795,5087.4676286549338,5145.7145634213311,5204.2563885269201,5263.0816008113652,5289.2030377490546]
["Ušetřené výdaje za uhlí",0,2124.6605360795461,2151.5946942599999,2178.7563545532407,2206.1438433805074,2233.7553292190437,2261.5888169537689,2289.642142066195,2317.9129646563374,2346.3987632932585,2375.0968286897942,null,null,"Ušetřené výdaje za uhlí",2404.0042571968738,2433.1179441127611,2462.4345768024045,2491.950627621989,2521.6623466436349,2551.5657541750998,2581.6566330691644,2611.9305208173218,2642.3827014221779,2673.0081970429019,2703.8017594078851,2734.7578609886509,2765.8706859288836,2797.1341207223304,2811.016702844835]
["Příjmy celkem",40000,6122.4172730795472,6200.0306858951999,6278.2996683142483,6357.2193977557017,6436.7845965074866,6516.9895154502428,6597.8279173121027,6679.2930594422596,6761.3776760906967,6844.0739601812948,null,null,"Příjmy celkem",6927.37354456508,7011.2674827401443,7095.7462290243839,7180.7996181668996,7266.4168443835024,7352.5864398015074,7439.2962522984762,7526.5334227194035,7614.2843614562489,7702.5347243734814,7791.2693880628194,7880.4724244099816,7970.1270744558042,8060.2157215336956,8100.2197405938896]
[]
["2) Výdaje",null,null,null,null,null,null,null,null,null,null,null,null,null,"2) Výdaje"]
["Investiční výdaje",282103.05,0,0,0,0,0,0,0,0,0,0,null,null,"Investiční výdaje",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Reinvestice",0,0,0,0,0,0,0,0,0,0,5964.5396970343463,null,null,"Reinvestice",0,0,0,0,31050.225866106452,0,0,0,0,7270.7406085220873,0,0,0,0,0]
["Čištění",0,591.6,603.43200000000002,615.50063999999998,627.81065279999996,640.366865856,653.17420317312008,666.23768723658225,679.56244098131401,693.15368980094024,707.01676359695909,null,null,"Čištění",721.15709886889817,735.5802408462763,750.29184566320168,765.29768257646583,780.60363622799491,796.21570895255502,812.1400231316062,828.38282359423818,844.95048006612296,861.84948966744548,879.08647946079429,896.6682090500102,914.60157323101032,932.89360469563053,0]
["Pojištění",0,491.64,501.47280000000001,511.50225599999999,521.73230111999999,532.16694714239998,542.81028608524798,553.66649180695288,564.739821643092,576.03461807595386,587.55531043747294,null,null,"Pojištění",599.30641664622226,611.29254497914678,623.51839587872973,635.9887637963044,648.70853907223034,661.68270985367496,674.9163640507486,688.41469133176349,702.18298515839865,716.2266448615668,730.55117775879808,745.16220131397404,760.0654453402534,775.26675424705843,790.77208933199961]
["Revize",0,0,0,0,1623.64824,0,0,0,1757.4890715033982,0,0,null,null,"Revize",0,1902.3626918438179,0,0,0,2059.178557635918,0,0,0,2228.9210939675313,0,0,0,2412.6558742128377,0]
["Demontáž",0,0,0,0,0,0,0,0,0,0,0,null,null,"Demontáž",0,0,0,0,0,0,0,0,0,0,0,0,0,0,21327.877928041486]
["Výdaje celkem",282103.05,1083.24,1104.9048,1127.002896,2773.1911939199999,1172.5338129984,1195.9844892583681,1219.9041790435351,3001.7913341278045,1269.1883078768942,7259.1117710687786,null,null,"Výdaje celkem",1320.4635155151204,3249.2354776692409,1373.8102415419314,1401.2864463727701,32479.538041406679,3517.076976442148,1487.0563871823547,1516.7975149260017,1547.1334652245216,11077.737837018631,1609.6376572195923,1641.8304103639844,1674.6670185712637,4120.8162331555268,22118.650017373486]
[]
["Cash Flow",-242103.05,5039.1772730795474,5095.1258858951996,5151.2967723142483,3584.0282038357018,5264.2507835090864,5321.005026191875,5377.9237382685678,3677.5017253144551,5492.1893682138025,-415.03781088748383,null,null,"Cash Flow",5606.9100290499591,3762.0320050709033,5721.9359874824522,5779.5131717941294,-25213.121197023174,3835.5094633593594,5952.239865116122,6009.7359077934016,6067.1508962317275,-3375.2031126451493,6181.6317308432272,6238.6420140459977,6295.4600558845405,3939.3994883781688,-14018.430276779596]