{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Program","Rozvaha","VZZ","Horizontální analýza","Vertikální analýza","Rozdílové ukazatele","Poměrové ukazatele","Soustavy ukazatelů","Regresní analýza"],"not_rendered":{"charts":6,"images":13,"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":"Program","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[5,3,26,9]]}

{"sheet":"Rozvaha","index":1,"n_rows":140,"n_cols":10,"rows_kept":140,"cut":false,"hidden":false,"merged":[[9,9,11,9],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[9,6,11,6],[3,3,4,9],[3,1,3,2],[8,1,8,2],[5,3,5,9],[6,3,6,9],[7,3,7,9],[8,3,8,9],[80,9,82,9],[9,1,11,1],[9,2,11,2],[9,3,11,3],[9,4,11,4],[9,5,11,5],[80,3,82,3],[80,4,82,4],[80,5,82,5],[80,6,82,6],[80,7,82,7],[80,8,82,8],[80,1,82,1],[80,2,82,2],[9,7,11,7],[9,8,11,8]]}
[]
[]
[]
[null,"ROZVAHA",null,"Obchodní firma a sídlo"]
[null,"v plném rozsahu"]
[null,"ke dni 31. prosince",null,"ISAN Radiátory, s.r.o"]
[null,"(v tisících Kč)",null,"Cejl 817/105"]
[null,"Identifikační číslo:",null,"Brno - Zábrdovice 602 00"]
[null,25334727,null,"Česká republika"]
[null,"Označení","AKTIVA","Číslo řádku ",2010,2011,2012,2013,2014,2015]
[]
[]
[null,null,"AKTIVA","001",157004,164001,180189,213068,246030,300409]
[null,"A.","Pohledávky za upsaný kapitál","002"]
[null,"B.","Dlouhodobý majetek","003",69422,81054,94185,110845,118018,142888]
[null,"B. I.","Dlouhodobý nehmotný majetek","004",1470,7896,8321,7086,6007,5192]
[null,"B. I.        1.","Zřizovací výdaje","005"]
[null,"2.","Nehmotné výsledky výzkumu a vývoje","006"]
[null,"3.","Software","007",680,338,1758,1493,1415,1344]
[null,"4.","Ocenitelná práva","008",790,6934,6563,5593,4592,3848]
[null,"5.","Goodwill","009"]
[null,"6.","Jiný dlouhodobý nehmotný majetek","010"]
[null,"7.","Nedokončený dlouhodobý nehmotný majetek","011",null,624]
[null,"8.","Poskytnuté zálohy na dlouhodobý nehmotný majetek","012"]
[null,"B. II.","Dlouhodobý hmotný majetek","013",59992,73158,85864,103759,112011,137696]
[null,"B. II.     1.","Pozemky","014",3900,3900,3900,3900,3900,3900]
[null,"2.","Stavby","015",125656,122865,122004,121872,119481,115330]
[null,"3.","Samostatné movité věci a soubory movitých věcí","016",8290,6396,4821,15754,18027,34064]
[null,"4.","Pěstitelské celky trvalých porostů","017"]
[null,"5.","Základní stádo a tažná zvířata","018"]
[null,"6.","Jiný dlouhodobý hmotný majetek","019",196,332,154,32,10,99]
[null,"7.","Nedokončený dlouhodobý hmotný majetek","020",536,1895,6380,2761,318,2460]
[null,"8.","Poskytnuté zálohy na dlouhodobý hmotný majetek","021",null,null,null,null,null,733]
[null,"9.","Oceňovací rozdíl k nabytému majetku","022",-78586,-62230,-51395,-40560,-29725,-18890]
[null,"B. III.","Dlouhodobý finanční majetek","023",7960]
[null,"B. III.     1.","Podíly v ovládaných a řízených osobách","024",7960]
[null,"2.","Podíly v účetních jednotkách pod podstatným vlivem","025"]
[null,"3.","Ostatní dlouhodobé cenné papíry a podíly","026"]
[null,"4.","Půjčky a úvěry ovl.a říz.osobám a úč.jedn.pod podst.vlivem","027"]
[null,"5.","Jiný dlouhodobý finanční majetek","028"]
[null,"6.","Pořizovaný dlouhodobý finanční majetek","029"]
[null,"7.","Poskytnuté zálohy na dlohodobý finanční majetek","030"]
[null,"C.","Obežná aktiva","031",84496,80133,83840,101028,127144,157293]
[null,"C. I.","Zásoby","032",42674,43344,40036,40988,49605,53584]
[null,"C. I.        1.","Materiál","033",18196,17265,18561,21939,27689,36399]
[null,"2.","Nedokončená výroba a polotovary","034",9443,11445,5927,7113,8332,8268]
[null,"3.","Výrobky","035",15024,14634,15494,11936,13584,8666]
[null,"4.","Zvířata","036"]
[null,"5.","Zboží","037"]
[null,"6.","Poskytnuté zálohy na zásoby","038",11,null,54,null,null,251]
[null,"C. II.","Dlouhodobé pohledávky","039",0,0,0,0,0,24595]
[null,"C. II.1.","Pohledávky z obchodních vztahů","040"]
[null,"2.","Pohledávky za ovládanými a řízenými osobami","041"]
[null,"3.","Pohledávky za účetními jednotkami pod podstatným vlivem","042"]
[null,"4.","Pohledávky za společníky, členy družstva a účastníky sdružení","043"]
[null,"5.","Dlouhodobé poskytnuté zálohy","044"]
[null,"6.","Dohadné účty aktivní","045"]
[null,"7.","Jiné pohledávky","046",null,null,null,null,null,24959]
[null,"8.","Odložená daňová pohledávka","047"]
[null,"C. III.","Krátkodobé pohledávky","048",34523,22051,30424,42591,56579,36599]
[null,"C. III.      1.","Pohledávky z obchodních vztahů","049",27986,15864,22102,23007,31709,30470]
[null,"2.","Pohledávky za ovládanými a řízenými osobami","050"]
[null,"3.","Pohledávky za účetními jednotkami pod podstatným vlivem","051"]
[null,"4.","Pohledávky za společníky, členy družstva a účastníky sdružení","052"]
[null,"5.","Sociální zabezpečení a zdravotní pojištění","053"]
[null,"6.","Stát - daňové pohledávky","054",5150,4946,6830,6945,7028,5227]
[null,"7.","Ostatní poskytnuté zálohy","055",1192,848,1026,495,1286,818]
[null,"8.","Dohadné účty aktivní","056"]
[null,"9.","Jiné pohledávky","057",195,393,466,12144,16556,84]
[null,"C. IV.","Krátkodobý finanční majetek","058",7299,14738,13380,17449,20960,42515]
[null,"C. IV.     1.","Peníze","059",257,179,137,460,451,85]
[null,"2.","Účty v bankách","060",7042,14559,13243,16989,20509,42430]
[null,"3.","Krátkodobé cenné papíry a podíly","061"]
[null,"4.","Pořizovaný krátkodobý finanční majetek","062"]
[null,"D. I.","Časové rozlišení","063",3086,2814,2164,1195,868,228]
[null,"D. I.        1.","Náklady příštích období","064",2832,2582,2164,1094,866,225]
[null,"2.","Komplexní náklady příštích období","065"]
[null,"3.","Příjmy příštích období","066",254,232,null,101,2,3]
[]
[]
[null,"Označení","PASIVA","Číslo řádku ",2010,2011,2012,2013,2014,2015]
[]
[]
[null,null,"PASIVA","067",157004,164001,180189,213068,246030,300409]
[null,"A.","Vlastní kapitál","068",58815,38494,61182,63949,88587,106004]
[null,"A. I.","Základní kapitál","069",13200,13200,13200,13200,13200,13200]
[null,"A. I.       1.","Základní kapitál","070",13200,13200,13200,13200,13200,13200]
[null,"2.","Vlastní akcie a vlastní obchodní podíly","071"]
[null,"3.","Změny základního kapitálu","072"]
[null,"A. II.","Kapitálové fondy","073",null,-2698]
[null,"A. II.      1.","Ážio","074"]
[null,"2.","Ostatní kapitálové fondy","075"]
[null,"3.","Oceňovací rozdíly z přecenění majetku a závazků","076",null,-2698]
[null,"4.","Oceňovací rozdíly z přecenění při přeměnách obchodních korp","077"]
[null,"5.","Rozdíly z přeměn obchodních korporací","078"]
[null,"6.","Rozdíly z ocenění při přeměnách obchodních korporací","079"]
[null,"A. III.","Fondy ze zisku","080",1954,1954,1954,1954,1954,1954]
[null,"A. III. 1.","Rezervní fond","081",1320,1320,1320,1320,1320,1320]
[null,"2.","Statutární a ostatní fondy","082",634,634,634,634,634,634]
[null,"A. IV.","Výsledek hospodaření min. let","083",31120,13661,25038,31028,46794,63433]
[null,"A. IV.    1.","Nerozdělený zisk minulých let","084",31120,13661,25038,31028,46794,63433]
[null,"2.","Neuhrazená ztráta minulých let","085"]
[null,"3.","Jiný výsledek hospodaření minulých let","086"]
[null,"A.V.","Výsledek hospodaření běžného účetního období","087",12541,12377,20990,17767,26639,27417]
[null,"B.","Cizí zdroje","088",96182,124761,117524,147447,155621,192783]
[null,"B. I.","Rezervy","089"]
[null,"1.","Rezervy podle zvláštních právních předpisů","090"]
[null,"2.","Rezerva na důchody a podobné závazky","091"]
[null,"3.","Rezerva na daň z příjmu","092"]
[null,"4.","Ostatní rezervy","093"]
[null,"B. II.","Dlouhodobé závazky","094",705,1756,576,759,868,9881]
[null,"B. II.    1.","Závazky z obchodních vztahů","095"]
[null,"2.","Závazky k ovládaným a řízeným osobám","096"]
[null,"3.","Závazky k účetním jednotkám pod podstatným vlivem","097"]
[null,"4.","Závazky ke společníkům, členům družstva a k účastníkům sdružení","098",null,null,null,null,null,9000]
[null,"5.","Dlouhodobé přijaté zálohy","099"]
[null,"6.","Vydané dluhopisy","100"]
[null,"7.","Dlouhodobé směnky k úhradě","101"]
[null,"8.","Dohadné účty pasivní","102"]
[null,"9.","Jiné závazky","103"]
[null,"10.","Odložený daňový závazek","104",705,1756,576,759,868,881]
[null,"B. III.","Krátkodobé závazky","105",62479,69523,61316,67967,71302,87290]
[null,"B. III.     1.","Závazky z obchodních vztahů","106",53539,48707,47801,52174,54711,65573]
[null,"2.","Závazky k ovládaným a řízeným osobám","107"]
[null,"3.","Závazky k účetním jednotkám pod podstatným vlivem","108"]
[null,"4.","Závazky ke společníkům, členům družstva a k účastníkům sdružení","109"]
[null,"5.","Závazky k zaměstnancům","110",4816,4721,5410,5822,7859,9990]
[null,"6.","Závazky ze sociálního zabezpečení a zdravotního pojištění","111",2817,2782,3063,3315,4619,5921]
[null,"7.","Stát - daňové závazky a dotace","112",710,1899,2541,982,3210,3531]
[null,"8.","Krátkodobé přijaté zálohy","113",558,8680,971,1031,861,2173]
[null,"9.","Vydané dluhopisy","114"]
[null,"10.","Dohadné účty pasivní","115",null,null,null,1]
[null,"11.","Jiné závazky","116",39,2734,1530,4642,42,102]
[null,"B. IV.","Bankovní úvěry a výpomoci","117",32998,53482,55632,78721,83451,95612]
[null,"B. IV.   1.","Bankovní úvěry dlouhodobé","118",12857,36912,30931,45265,42309,40875]
[null,"2.","Krátkodobé bankovní úvěry","119",20141,16570,24701,33456,41142,54737]
[null,"3.","Krátkodobé finanční výpomoci","120"]
[null,"C. I.","Časové rozlišení","121",2007,746,1483,1672,1822,1622]
[null,"C. I.       1.","Výdaje příštích období","122",1977,746,1483,1672,1822,1622]
[null,"2.","Výnosy příštích období","123",30]

{"sheet":"VZZ","index":2,"n_rows":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[[6,1,6,2],[7,1,7,2],[9,1,11,1],[9,2,11,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[8,1,8,2],[9,4,11,4],[9,5,11,5],[9,6,11,6],[9,7,11,7],[3,3,4,9],[9,8,11,8],[9,9,11,9],[5,3,5,9],[6,3,6,9],[7,3,7,9],[8,3,8,9],[9,3,11,3]]}
[]
[]
[]
[null,"VÝKAZ ZISKU A ZTRÁTY",null,"Obchodní firma a sídlo"]
[null,"druhové členění"]
[null,"ke dni 31. prosince",null,"ISAN Radiátory, s.r.o"]
[null,"(v tisicích Kč)",null,"Cejl 817/105"]
[null,"Identifikační číslo:",null,"Brno - Zábrdovice 602 00"]
[null,25334727,null,"Česká republika"]
[null,"Označení","Text","Číslo řádku ",2010,2011,2012,2013,2014,2015]
[]
[]
[null,"I.","Tržby za prodej zboží","01"]
[null,"A.","Náklady vynaložené na prodané zboží","02"]
[null,"+","Obchodní marže","03"]
[null,"II.","Výkony","04",337210,322482,355784,347121,413233,485025]
[null,"II. 1.","Tržby za prodej vlastních výrobků a služeb","05",333198,319777,359413,347988,409052,488508]
[null,"2.","Změna stavu zásob vlastní činnosti","06",3906,2669,-3641,-928,4019,-3498]
[null,"3.","Aktivace","07",106,36,12,61,162,15]
[null,"B.","Výkonová spotřeba","08",231014,221917,234914,221640,269881,306180]
[null,"B. 1.","Spotřeba materiálu a energie","09",181032,178526,193104,177850,217156,244513]
[null,"B. 2.","Služby","10",49982,43391,41810,43790,52725,61667]
[null,"+","Přidaná hodnota","11",106196,100565,120870,125481,143352,178845]
[null,"C.","Osobní náklady","12",86457,88013,89706,95451,106787,133991]
[null,"C. 1.","Mzdové náklady","13",64161,65291,66658,71087,78701,98488]
[null,"C. 2.","Odměny členům orgánů společnosti a družstva","14",120,48,null,null,805,1380]
[null,"C. 3.","Náklady na sociální zabezpečení a zdravotní pojištění","15",21788,22138,22485,23964,26828,33630]
[null,"C. 4.","Sociální náklady","16",388,536,563,400,453,493]
[null,"D.","Daně a poplatky","17",663,208,219,212,246,247]
[null,"E.","Odpisy dlohodobého nehmotného a hmotného majetku","18",-1750,-7331,-896,-75,1705,3658]
[null,"III.","Tržby z prodeje dlouhodobého majetku a materiálů","19",8584,2821,2332,3097,4052,4304]
[null,"III. 1.","Tržby z prodeje dlouhodobého majetku","20",5940,20,64,458,345,182]
[null,"III. 2.","Tržby z prodeje materiálu","21",2644,2801,2268,2639,3707,4122]
[null,"F.","Zůstatková cena prodaného dlouhodob.majetku a materiálů","22",6027,1003,1218,1235,1675,2028]
[null,"F. 1.","Zůstatková cena prodaného dlouhodob.majetku","23",4980,21,null,null,144]
[null,"F. 2.","Prodaný materiál","24",1047,982,1218,1235,1531,2028]
[null,"G.","Změna stavu rezerv a oprav.položek v provoz.oblasti a komplex.nákladů příštích období","25",399,-8787,-1135,62,331,85]
[null,"IV.","Ostatní provozní výnosy","26",1521,4132,1323,1061,1570,580]
[null,"H.","Ostatní provozní náklady","27",7864,12493,4855,3840,3224,6953]
[null,"V.","Převod provozních výnosů","28"]
[null,"I.","Převod provozních nákladů","29"]
[null,"*","Provozní výsledek hospodaření","30",16641,21919,30558,28914,35006,36767]
[null,"VI.","Tržby z prodeje cenných papírů a podílů","31",null,3200]
[null,"J.","Prodané cenné papíry a podíly","32",null,1660]
[null,"VII.","Výnosy z dlouhodobého fin.majetku","33"]
[null,"VII. 1.","Výnosy z podílů v ovládaných a říz.osobách a v účetních jednotkách pod podstatným vlivem","34"]
[null,"2.","Výnosy z ostatních dlouhodobých cenných papírů a podílů","35"]
[null,"3.","Výnosy z ostatního dlouhodobého finančního majetku","36"]
[null,"VIII.","Výnosy z krátkodobého finančního majetku","37"]
[null,"K.","Náklady z finančního majetku","38"]
[null,"IX.","Výnosy z přecenění majetkových cenných papírů a derivátů","39"]
[null,"L.","Náklady z přecenění cenných papírů a derivátů","40"]
[null,"M.","Změna stavu rezerv a oprav.položek ve finanční oblasti","41"]
[null,"X.","Výnosové úroky","42",6,4,9,236,626,550]
[null,"N.","Nákladové úroky","43",1065,1282,1478,1333,1549,1488]
[null,"XI.","Ostatní finanční výnosy","44",3599,2809,3126,5236,5729,1563]
[null,"O.","Ostatní finanční náklady","45",4350,7522,7403,10799,6713,3581]
[null,"XII.","Převod finančních výnosů","46"]
[null,"P.","Převod finančních nákladů","47"]
[null,"*","Finanční výsledek hospodaření","48",-1810,-4451,-5746,-6660,-1907,-2956]
[null,"Q.","Daň z příjmu za běžnou činnost","49",2290,5091,3822,4487,6460,6394]
[null,"Q. 1.","-splatná","50",2310,4040,5002,4304,6351,6382]
[null,"2.","-odložená","51",-20,1051,-1180,183,109,12]
[null,"**","Výsledek hospodaření za běžnou činnost","52",12541,12377,20990,17767,26639,27417]
[null,"XIII.","Mimořádné výnosy","53"]
[null,"R.","Mimořádné náklady","54"]
[null,"S.","Daň z příjmu mimořádné činnosti","55"]
[null,"S. 1.","-splatná","56"]
[null,"2.","-odložená","57"]
[null,"*","Mimořádný výsledek hospodaření","58"]
[null,"T.","Převod podílu na hospodářském výsledku společníkům","59"]
[null,"***","Výsledek hospodaření za účetní období","60",12541,12377,20990,17767,26639,27417]
[null,"***","Výsledek hospodaření za účetní období před zdaněním","61",14831,17468,24812,22254,33099,33811]

{"sheet":"Horizontální analýza","index":3,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,11,3,12],[5,1,13,1],[14,1,19,1],[3,1,4,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10]]}
[]
[]
[]
[null,"Položky rozvahy",null,2011,null,2012,null,2013,null,2014,null,2015]
[null,null,null,"abs. změna","% změna","abs. změna","% změna","abs. změna","% změna","abs. změna","% změna","abs. změna","% změna"]
[null,"AKTIVA","Aktiva celkem",{"$f":"Rozvaha!F13-Rozvaha!E13","v":6997},{"$f":"D6/Rozvaha!E13","v":4.4565743547935084E-2},{"$f":"Rozvaha!G13-Rozvaha!F13","v":16188},{"$f":"F6/Rozvaha!F13","v":9.8706715202956083E-2},{"$f":"Rozvaha!H13-Rozvaha!G13","v":32879},{"$f":"H6/Rozvaha!G13","v":0.18246951811708817},{"$f":"Rozvaha!I13-Rozvaha!H13","v":32962},{"$f":"J6/Rozvaha!H13","v":0.15470178534552351},{"$f":"Rozvaha!J13-Rozvaha!I13","v":54379},{"$f":"L6/Rozvaha!I13","v":0.2210258911514856}]
[null,null,"Dlouhodobý majetek",{"$f":"Rozvaha!F15-Rozvaha!E15","v":11632},{"$f":"D7/Rozvaha!E15","v":0.16755495376105559},{"$f":"Rozvaha!G15-Rozvaha!F15","v":13131},{"$f":"F7/Rozvaha!F15","v":0.16200310903841883},{"$f":"Rozvaha!H15-Rozvaha!G15","v":16660},{"$f":"H7/Rozvaha!G15","v":0.17688591601635079},{"$f":"Rozvaha!I15-Rozvaha!H15","v":7173},{"$f":"J7/Rozvaha!H15","v":6.4711985204564934E-2},{"$f":"Rozvaha!J15-Rozvaha!I15","v":24870},{"$f":"L7/Rozvaha!I15","v":0.21073056652375061}]
[null,null,"Dlouhodobý nehmotný majetek",{"$f":"Rozvaha!F16-Rozvaha!E16","v":6426},{"$f":"D8/Rozvaha!E16","v":4.371428571428571},{"$f":"Rozvaha!G16-Rozvaha!F16","v":425},{"$f":"F8/Rozvaha!F16","v":5.3824721377912867E-2},{"$f":"Rozvaha!H16-Rozvaha!G16","v":-1235},{"$f":"H8/Rozvaha!G16","v":-0.14841966109842566},{"$f":"Rozvaha!I16-Rozvaha!H16","v":-1079},{"$f":"J8/Rozvaha!H16","v":-0.15227208580299181},{"$f":"Rozvaha!J16-Rozvaha!I16","v":-815},{"$f":"L8/Rozvaha!I16","v":-0.13567504577992343}]
[null,null,"Dlouhodobý hmotný majetek",{"$f":"Rozvaha!F25-Rozvaha!E25","v":13166},{"$f":"D9/Rozvaha!E25","v":0.21946259501266835},{"$f":"Rozvaha!G25-Rozvaha!F25","v":12706},{"$f":"F9/Rozvaha!F25","v":0.17367888679296864},{"$f":"Rozvaha!H25-Rozvaha!G25","v":17895},{"$f":"H9/Rozvaha!G25","v":0.20841097549613341},{"$f":"Rozvaha!I25-Rozvaha!H25","v":8252},{"$f":"J9/Rozvaha!H25","v":7.9530450370570258E-2},{"$f":"Rozvaha!J25-Rozvaha!I25","v":25685},{"$f":"L9/Rozvaha!I25","v":0.22930783583755168}]
[null,null,"Oběžná aktiva",{"$f":"Rozvaha!F43-Rozvaha!E43","v":-4363},{"$f":"D10/Rozvaha!E43","v":-5.1635580382503314E-2},{"$f":"Rozvaha!G43-Rozvaha!F43","v":3707},{"$f":"F10/Rozvaha!F43","v":4.6260591766188713E-2},{"$f":"Rozvaha!H43-Rozvaha!G43","v":17188},{"$f":"H10/Rozvaha!G43","v":0.20500954198473281},{"$f":"Rozvaha!I43-Rozvaha!H43","v":26116},{"$f":"J10/Rozvaha!H43","v":0.25850259334046005},{"$f":"Rozvaha!J43-Rozvaha!I43","v":30149},{"$f":"L10/Rozvaha!I43","v":0.23712483483294533}]
[null,null,"Zásoby",{"$f":"Rozvaha!F44-Rozvaha!E44","v":670},{"$f":"D11/Rozvaha!E44","v":1.5700426489197169E-2},{"$f":"Rozvaha!G44-Rozvaha!F44","v":-3308},{"$f":"F11/Rozvaha!F44","v":-7.6319675156884453E-2},{"$f":"Rozvaha!H44-Rozvaha!G44","v":952},{"$f":"H11/Rozvaha!G44","v":2.37785992606654E-2},{"$f":"Rozvaha!I44-Rozvaha!H44","v":8617},{"$f":"J11/Rozvaha!H44","v":0.21023226310139553},{"$f":"Rozvaha!J44-Rozvaha!I44","v":3979},{"$f":"L11/Rozvaha!I44","v":8.0213688136276579E-2}]
[null,null,"Krátkodobé pohledávky",{"$f":"Rozvaha!F60-Rozvaha!E60","v":-12472},{"$f":"D12/Rozvaha!E60","v":-0.36126640210873912},{"$f":"Rozvaha!G60-Rozvaha!F60","v":8373},{"$f":"F12/Rozvaha!F60","v":0.37971067071788128},{"$f":"Rozvaha!H60-Rozvaha!G60","v":12167},{"$f":"H12/Rozvaha!G60","v":0.39991454115172231},{"$f":"Rozvaha!I60-Rozvaha!H60","v":13988},{"$f":"J12/Rozvaha!H60","v":0.32842619332722878},{"$f":"Rozvaha!J60-Rozvaha!I60","v":-19980},{"$f":"L12/Rozvaha!I60","v":-0.35313455522366954}]
[null,null,"Krátkodobý finanční majetek",{"$f":"Rozvaha!F70-Rozvaha!E70","v":7439},{"$f":"D13/Rozvaha!E70","v":1.0191807096862584},{"$f":"Rozvaha!G70-Rozvaha!F70","v":-1358},{"$f":"F13/Rozvaha!F70","v":-9.214276021169765E-2},{"$f":"Rozvaha!H70-Rozvaha!G70","v":4069},{"$f":"H13/Rozvaha!G70","v":0.30411061285500746},{"$f":"Rozvaha!I70-Rozvaha!H70","v":3511},{"$f":"J13/Rozvaha!H70","v":0.20121496933921715},{"$f":"Rozvaha!J70-Rozvaha!I70","v":21555},{"$f":"L13/Rozvaha!I70","v":1.0283874045801527}]
[null,null,"Časové rozlišení",{"$f":"Rozvaha!F75-Rozvaha!E75","v":-272},{"$f":"D14/Rozvaha!E75","v":-8.8139987038237194E-2},{"$f":"Rozvaha!G75-Rozvaha!F75","v":-650},{"$f":"F14/Rozvaha!F75","v":-0.23098791755508175},{"$f":"Rozvaha!H75-Rozvaha!G75","v":-969},{"$f":"H14/Rozvaha!G75","v":-0.4477818853974122},{"$f":"Rozvaha!I75-Rozvaha!H75","v":-327},{"$f":"J14/Rozvaha!H75","v":-0.27364016736401675},{"$f":"Rozvaha!J75-Rozvaha!I75","v":-640},{"$f":"L14/Rozvaha!I75","v":-0.73732718894009219}]
[null,"PASIVA","Pasiva celkem",{"$f":"Rozvaha!F84-Rozvaha!E84","v":6997},{"$f":"D15/Rozvaha!E84","v":4.4565743547935084E-2},{"$f":"Rozvaha!G84-Rozvaha!F84","v":16188},{"$f":"F15/Rozvaha!F84","v":9.8706715202956083E-2},{"$f":"Rozvaha!H84-Rozvaha!G84","v":32879},{"$f":"H15/Rozvaha!G84","v":0.18246951811708817},{"$f":"Rozvaha!I84-Rozvaha!H84","v":32962},{"$f":"J15/Rozvaha!H84","v":0.15470178534552351},{"$f":"Rozvaha!J84-Rozvaha!I84","v":54379},{"$f":"L15/Rozvaha!I84","v":0.2210258911514856}]
[null,null,"Vlastní kapitál",{"$f":"Rozvaha!F85-Rozvaha!E85","v":-20321},{"$f":"D16/Rozvaha!E85","v":-0.34550709852928674},{"$f":"Rozvaha!G85-Rozvaha!F85","v":22688},{"$f":"F16/Rozvaha!F85","v":0.58939055437210996},{"$f":"Rozvaha!H85-Rozvaha!G85","v":2767},{"$f":"H16/Rozvaha!G85","v":4.5225719983001539E-2},{"$f":"Rozvaha!I85-Rozvaha!H85","v":24638},{"$f":"J16/Rozvaha!H85","v":0.38527576662653051},{"$f":"Rozvaha!J85-Rozvaha!I85","v":17417},{"$f":"L16/Rozvaha!I85","v":0.19660898325939472}]
[null,null,"VH minulých let",{"$f":"Rozvaha!F100-Rozvaha!E100","v":-17459},{"$f":"D17/Rozvaha!E100","v":-0.56102185089974288},{"$f":"Rozvaha!G100-Rozvaha!F100","v":11377},{"$f":"F17/Rozvaha!F100","v":0.83280872556913843},{"$f":"Rozvaha!H100-Rozvaha!G100","v":5990},{"$f":"H17/Rozvaha!G100","v":0.23923636073168783},{"$f":"Rozvaha!I100-Rozvaha!H100","v":15766},{"$f":"J17/Rozvaha!H100","v":0.50812169653216455},{"$f":"Rozvaha!J100-Rozvaha!I100","v":16639},{"$f":"L17/Rozvaha!I100","v":0.35557977518485279}]
[null,null,"VH běžného účetního období",{"$f":"Rozvaha!F104-Rozvaha!E104","v":-164},{"$f":"D18/Rozvaha!E104","v":-1.3077107088748903E-2},{"$f":"Rozvaha!G104-Rozvaha!F104","v":8613},{"$f":"F18/Rozvaha!F104","v":0.69588753332794695},{"$f":"Rozvaha!H104-Rozvaha!G104","v":-3223},{"$f":"H18/Rozvaha!G104","v":-0.15354930919485468},{"$f":"Rozvaha!I104-Rozvaha!H104","v":8872},{"$f":"J18/Rozvaha!H104","v":0.49935273259413521},{"$f":"Rozvaha!J104-Rozvaha!I104","v":778},{"$f":"L18/Rozvaha!I104","v":2.9205300499267992E-2}]
[null,null,"Cizí zdroje",{"$f":"Rozvaha!F105-Rozvaha!E105","v":28579},{"$f":"D19/Rozvaha!E105","v":0.29713459898941591},{"$f":"Rozvaha!G105-Rozvaha!F105","v":-7237},{"$f":"F19/Rozvaha!F105","v":-5.8006909210410303E-2},{"$f":"Rozvaha!H105-Rozvaha!G105","v":29923},{"$f":"H19/Rozvaha!G105","v":0.25461182396787041},{"$f":"Rozvaha!I105-Rozvaha!H105","v":8174},{"$f":"J19/Rozvaha!H105","v":5.5436868841007278E-2},{"$f":"Rozvaha!J105-Rozvaha!I105","v":37162},{"$f":"L19/Rozvaha!I105","v":0.23879810565412124}]
[null,null,"Krátkodobé závazky",{"$f":"Rozvaha!F122-Rozvaha!E122","v":7044},{"$f":"D20/Rozvaha!E122","v":0.11274188127210742},{"$f":"Rozvaha!G122-Rozvaha!F122","v":-8207},{"$f":"F20/Rozvaha!F122","v":-0.11804726493390677},{"$f":"Rozvaha!H122-Rozvaha!G122","v":6651},{"$f":"H20/Rozvaha!G122","v":0.10847087220301389},{"$f":"Rozvaha!I122-Rozvaha!H122","v":3335},{"$f":"J20/Rozvaha!H122","v":4.9067930024865009E-2},{"$f":"Rozvaha!J122-Rozvaha!I122","v":15988},{"$f":"L20/Rozvaha!I122","v":0.22422933438052228}]

{"sheet":"Vertikální analýza","index":4,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,1,4,2],[5,1,14,1],[15,1,22,1]]}
[]
[]
[]
[null,"Položky rozvahy",null,2011,2012,2013,2014,2015]
[null,null,null,"% podíl","% podíl","% podíl","% podíl","% podíl"]
[null,"AKTIVA","Aktiva celkem",1,1,1,1,1]
[null,null,"Dlouhodobý majetek",{"$f":"Rozvaha!F15/Rozvaha!F13","v":0.4942286937274773},{"$f":"Rozvaha!G15/Rozvaha!G13","v":0.52270116377803311},{"$f":"Rozvaha!H15/Rozvaha!H13","v":0.52023297726547391},{"$f":"Rozvaha!I15/Rozvaha!I13","v":0.47968946876397189},{"$f":"Rozvaha!J15/Rozvaha!J13","v":0.47564487082610707}]
[null,null,"Dlouhodobý nehmotný majetek",{"$f":"Rozvaha!F16/Rozvaha!F13","v":4.8146047889951887E-2},{"$f":"Rozvaha!G16/Rozvaha!G13","v":4.6179289523777811E-2},{"$f":"Rozvaha!H16/Rozvaha!H13","v":3.3256988379296748E-2},{"$f":"Rozvaha!I16/Rozvaha!I13","v":2.4415721659960168E-2},{"$f":"Rozvaha!J16/Rozvaha!J13","v":1.7283104034832512E-2}]
[null,null,"Dlouhodobý hmotný majetek",{"$f":"Rozvaha!F25/Rozvaha!F13","v":0.44608264583752538},{"$f":"Rozvaha!G25/Rozvaha!G13","v":0.47652187425425524},{"$f":"Rozvaha!H25/Rozvaha!H13","v":0.48697598888617716},{"$f":"Rozvaha!I25/Rozvaha!I13","v":0.45527374710401169},{"$f":"Rozvaha!J25/Rozvaha!J13","v":0.45836176679127455}]
[null,null,"Oběžná aktiva",{"$f":"Rozvaha!F43/Rozvaha!F13","v":0.488612874311742},{"$f":"Rozvaha!G43/Rozvaha!G13","v":0.46528922409248069},{"$f":"Rozvaha!H43/Rozvaha!H13","v":0.47415848461524018},{"$f":"Rozvaha!I43/Rozvaha!I13","v":0.51678250619843114},{"$f":"Rozvaha!J43/Rozvaha!J13","v":0.52359616389655439}]
[null,null,"Zásoby",{"$f":"Rozvaha!F44/Rozvaha!F13","v":0.26429107139590613},{"$f":"Rozvaha!G44/Rozvaha!G13","v":0.22218892385217742},{"$f":"Rozvaha!H44/Rozvaha!H13","v":0.19237051082283591},{"$f":"Rozvaha!I44/Rozvaha!I13","v":0.20162175344470187},{"$f":"Rozvaha!J44/Rozvaha!J13","v":0.17837015535486619}]
[null,null,"Dlouhodobé pohledávky",{"$f":"Rozvaha!F51/Rozvaha!F13","v":0},{"$f":"Rozvaha!G51/Rozvaha!G13","v":0},{"$f":"Rozvaha!H51/Rozvaha!H13","v":0},{"$f":"Rozvaha!I51/Rozvaha!I13","v":0},{"$f":"Rozvaha!J51/Rozvaha!J13","v":8.1871714895359327E-2}]
[null,null,"Krátkodobé pohledávky",{"$f":"Rozvaha!F60/Rozvaha!F13","v":0.1344564972164804},{"$f":"Rozvaha!G60/Rozvaha!G13","v":0.16884493504042977},{"$f":"Rozvaha!H60/Rozvaha!H13","v":0.19989393057615409},{"$f":"Rozvaha!I60/Rozvaha!I13","v":0.22996789009470389},{"$f":"Rozvaha!J60/Rozvaha!J13","v":0.12183057098821939}]
[null,null,"Krátkodobý finanční majetek",{"$f":"Rozvaha!F70/Rozvaha!F13","v":8.9865305699355497E-2},{"$f":"Rozvaha!G70/Rozvaha!G13","v":7.4255365199873469E-2},{"$f":"Rozvaha!H70/Rozvaha!H13","v":8.1894043216250212E-2},{"$f":"Rozvaha!I70/Rozvaha!I13","v":8.5192862659025329E-2},{"$f":"Rozvaha!J70/Rozvaha!J13","v":0.14152372265810945}]
[null,null,"Časové rozlišení",{"$f":"Rozvaha!F75/Rozvaha!F13","v":1.7158431960780728E-2},{"$f":"Rozvaha!G75/Rozvaha!G13","v":1.2009612129486261E-2},{"$f":"Rozvaha!H75/Rozvaha!H13","v":5.6085381192858622E-3},{"$f":"Rozvaha!I75/Rozvaha!I13","v":3.5280250375970411E-3},{"$f":"Rozvaha!J75/Rozvaha!J13","v":7.5896527733856174E-4}]
[null,"PASIVA","Pasiva celkem",1,1,1,1,1]
[null,null,"Vlastní kapitál",{"$f":"Rozvaha!F85/Rozvaha!F84","v":0.23471808098731106},{"$f":"Rozvaha!G85/Rozvaha!G84","v":0.33954347934668599},{"$f":"Rozvaha!H85/Rozvaha!H84","v":0.30013422944787582},{"$f":"Rozvaha!I85/Rozvaha!I84","v":0.3600658456285819},{"$f":"Rozvaha!J85/Rozvaha!J84","v":0.35286559324121447}]
[null,null,"VH minulých let",{"$f":"Rozvaha!F100/Rozvaha!F84","v":8.3298272571508708E-2},{"$f":"Rozvaha!G100/Rozvaha!G84","v":0.13895409819689325},{"$f":"Rozvaha!H100/Rozvaha!H84","v":0.14562487093322318},{"$f":"Rozvaha!I100/Rozvaha!I84","v":0.19019631752225338},{"$f":"Rozvaha!J100/Rozvaha!J84","v":0.21115545805884645}]
[null,null,"VH běžného účetního období",{"$f":"Rozvaha!F104/Rozvaha!F84","v":7.5469052017975505E-2},{"$f":"Rozvaha!G104/Rozvaha!G84","v":0.1164887978733441},{"$f":"Rozvaha!H104/Rozvaha!H84","v":8.3386524489834232E-2},{"$f":"Rozvaha!I104/Rozvaha!I84","v":0.10827541356745113},{"$f":"Rozvaha!J104/Rozvaha!J84","v":9.1265574599962054E-2}]
[null,null,"Cizí zdroje",{"$f":"Rozvaha!F105/Rozvaha!F84","v":0.76073316626118137},{"$f":"Rozvaha!G105/Rozvaha!G84","v":0.65222627352391105},{"$f":"Rozvaha!H105/Rozvaha!H84","v":0.69201851052246233},{"$f":"Rozvaha!I105/Rozvaha!I84","v":0.63252855342844372},{"$f":"Rozvaha!J105/Rozvaha!J84","v":0.64173510114543841}]
[null,null,"Rezervy",{"$f":"Rozvaha!F106/Rozvaha!F84","v":0},{"$f":"Rozvaha!G106/Rozvaha!G84","v":0},{"$f":"Rozvaha!H106/Rozvaha!H84","v":0},{"$f":"Rozvaha!I106/Rozvaha!I84","v":0},{"$f":"Rozvaha!J106/Rozvaha!J84","v":0}]
[null,null,"Dlouhodobé závazky",{"$f":"Rozvaha!F111/Rozvaha!F84","v":1.0707251785050092E-2},{"$f":"Rozvaha!G111/Rozvaha!G84","v":3.1966435242994857E-3},{"$f":"Rozvaha!H111/Rozvaha!H84","v":3.5622430397807274E-3},{"$f":"Rozvaha!I111/Rozvaha!I84","v":3.5280250375970411E-3},{"$f":"Rozvaha!J111/Rozvaha!J84","v":3.2891824146413721E-2}]
[null,null,"Krátkodobé závazky",{"$f":"Rozvaha!F122/Rozvaha!F84","v":0.42391814684056806},{"$f":"Rozvaha!G122/Rozvaha!G84","v":0.34028714294435286},{"$f":"Rozvaha!H122/Rozvaha!H84","v":0.31899205887322357},{"$f":"Rozvaha!I122/Rozvaha!I84","v":0.2898101857497053},{"$f":"Rozvaha!J122/Rozvaha!J84","v":0.2905705221880836}]

{"sheet":"Rozdílové ukazatele","index":5,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,2,4,7],[3,1,22,1],[15,2,16,7],[9,2,10,7]]}
[]
[]
[]
[null,"ROZDÍLOVÉ UKAZATELE","Č I S T Ý     P R A C O V N Í     K A P I T Á L"]
[]
[null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,null,"Oběžná aktiva",{"$f":"Rozvaha!F43","v":80133},{"$f":"Rozvaha!G43","v":83840},{"$f":"Rozvaha!H43","v":101028},{"$f":"Rozvaha!I43","v":127144},{"$f":"Rozvaha!J43","v":157293}]
[null,null,"Krátkodobé závazky",{"$f":"Rozvaha!F122","v":69523},{"$f":"Rozvaha!G122","v":61316},{"$f":"Rozvaha!H122","v":67967},{"$f":"Rozvaha!I122","v":71302},{"$f":"Rozvaha!J122","v":87290}]
[null,null,"ČPK",{"$f":"D7-D8","v":10610},{"$f":"E7-E8","v":22524},{"$f":"F7-F8","v":33061},{"$f":"G7-G8","v":55842},{"$f":"H7-H8","v":70003}]
[null,null,"Č I S T É     P O H O T O V O S T N Í     P R O S T Ř E D K Y "]
[]
[null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,null,"Pohotové fin. prostředky",{"$f":"Rozvaha!F70","v":14738},{"$f":"Rozvaha!G70","v":13380},{"$f":"Rozvaha!H70","v":17449},{"$f":"Rozvaha!I70","v":20960},{"$f":"Rozvaha!J70","v":42515}]
[null,null,"Okamžité splatné závazky",{"$f":"Rozvaha!F122","v":69523},{"$f":"Rozvaha!G122","v":61316},{"$f":"Rozvaha!H122","v":67967},{"$f":"Rozvaha!I122","v":71302},{"$f":"Rozvaha!J122","v":87290}]
[null,null,"ČPP",{"$f":"D13-D14","v":-54785},{"$f":"E13-E14","v":-47936},{"$f":"F13-F14","v":-50518},{"$f":"G13-G14","v":-50342},{"$f":"H13-H14","v":-44775}]
[null,null,"Č I S T Ý    P E N Ě Ž N Ě - P O H L E D Á V K O V Ý     F I N.    FOND"]
[]
[null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,null,"Oběžná aktiva",{"$f":"Rozvaha!F43","v":80133},{"$f":"Rozvaha!G43","v":83840},{"$f":"Rozvaha!H43","v":101028},{"$f":"Rozvaha!I43","v":127144},{"$f":"Rozvaha!J43","v":157293}]
[null,null,"Zásoby",{"$f":"Rozvaha!F44","v":43344},{"$f":"Rozvaha!G44","v":40036},{"$f":"Rozvaha!H44","v":40988},{"$f":"Rozvaha!I44","v":49605},{"$f":"Rozvaha!J44","v":53584}]
[null,null,"Nelikvidní pohledávky",{"$f":"Rozvaha!F51","v":0},{"$f":"Rozvaha!G51","v":0},{"$f":"Rozvaha!H51","v":0},{"$f":"Rozvaha!I51","v":0},{"$f":"Rozvaha!J51","v":24595}]
[null,null,"Kr. závazky",{"$f":"Rozvaha!F122","v":69523},{"$f":"Rozvaha!G122","v":61316},{"$f":"Rozvaha!H122","v":67967},{"$f":"Rozvaha!I122","v":71302},{"$f":"Rozvaha!J122","v":87290}]
[null,null,"ČPPF",{"$f":"D19-D20-D21-D22","v":-32734},{"$f":"E19-E20-E21-E22","v":-17512},{"$f":"F19-F20-F21-F22","v":-7927},{"$f":"G19-G20-G21-G22","v":6237},{"$f":"H19-H20-H21-H22","v":-8176}]

{"sheet":"Poměrové ukazatele","index":6,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[[24,2,25,7],[31,2,32,7],[37,2,38,7],[24,1,55,1],[3,1,21,1],[16,2,17,7],[49,2,50,7],[17,10,52,10],[3,11,4,16],[9,11,10,16],[3,10,14,10],[3,2,4,7],[9,2,10,7],[17,11,18,16],[23,11,24,16],[29,11,30,16],[35,11,36,16],[47,11,48,16],[41,11,42,16],[43,2,44,7]]}
[]
[]
[]
[null,"L I K V I D I T A ","O K A M Ž I T Á     L I K V I D I T A ",null,null,null,null,null,null,null,"ZADLUŽENOST ","C E L K O V Á     Z A D L U Ž E  N O S T "]
[]
[null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015},null,null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,null,"Krátkodobý fin. majetek",{"$f":"Rozvaha!F70","v":14738},{"$f":"Rozvaha!G70","v":13380},{"$f":"Rozvaha!H70","v":17449},{"$f":"Rozvaha!I70","v":20960},{"$f":"Rozvaha!J70","v":42515},null,null,null,"Cizí zdroje",{"$f":"Rozvaha!F105","v":124761},{"$f":"Rozvaha!G105","v":117524},{"$f":"Rozvaha!H105","v":147447},{"$f":"Rozvaha!I105","v":155621},{"$f":"Rozvaha!J105","v":192783}]
[null,null,"Krátkodobé závazky",{"$f":"Rozvaha!F122+Rozvaha!F137","v":69523},{"$f":"Rozvaha!G122+Rozvaha!G137","v":61316},{"$f":"Rozvaha!H122+Rozvaha!H137","v":67967},{"$f":"Rozvaha!I122+Rozvaha!I137","v":71302},{"$f":"Rozvaha!J122+Rozvaha!J137","v":87290},null,null,null,"Celková aktiva",{"$f":"Rozvaha!F13","v":164001},{"$f":"Rozvaha!G13","v":180189},{"$f":"Rozvaha!H13","v":213068},{"$f":"Rozvaha!I13","v":246030},{"$f":"Rozvaha!J13","v":300409}]
[null,null,"Okamžitá likvidita",{"$f":"D7/D8","v":0.21198739985328596},{"$f":"E7/E8","v":0.218213843042599},{"$f":"F7/F8","v":0.25672752953639266},{"$f":"G7/G8","v":0.29396089871251857},{"$f":"H7/H8","v":0.48705464543475768},null,null,null,"Celková zadluženost",{"$f":"M7/M8","v":0.76073316626118137},{"$f":"N7/N8","v":0.65222627352391105},{"$f":"O7/O8","v":0.69201851052246233},{"$f":"P7/P8","v":0.63252855342844372},{"$f":"Q7/Q8","v":0.64173510114543841}]
[null,null,"P O H O T O V Á      L I K V I D I  T A ",null,null,null,null,null,null,null,null,"K O E F I C I E N T     S A M O F I N A N C O V Á N Í "]
[]
[null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015},null,null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,null,"Oběžná aktiva",{"$f":"Rozvaha!F43","v":80133},{"$f":"Rozvaha!G43","v":83840},{"$f":"Rozvaha!H43","v":101028},{"$f":"Rozvaha!I43","v":127144},{"$f":"Rozvaha!J43","v":157293},null,null,null,"Vlastní kapitál",{"$f":"Rozvaha!F85","v":38494},{"$f":"Rozvaha!G85","v":61182},{"$f":"Rozvaha!H85","v":63949},{"$f":"Rozvaha!I85","v":88587},{"$f":"Rozvaha!J85","v":106004}]
[null,null,"Zásoby",{"$f":"Rozvaha!F44","v":43344},{"$f":"Rozvaha!G44","v":40036},{"$f":"Rozvaha!H44","v":40988},{"$f":"Rozvaha!I44","v":49605},{"$f":"Rozvaha!J44","v":53584},null,null,null,"Celková aktiva",{"$f":"Rozvaha!F13","v":164001},{"$f":"Rozvaha!G13","v":180189},{"$f":"Rozvaha!H13","v":213068},{"$f":"Rozvaha!I13","v":246030},{"$f":"Rozvaha!J13","v":300409}]
[null,null,"Krátkodobé závazky",{"$f":"Rozvaha!F122+Rozvaha!F137","v":69523},{"$f":"Rozvaha!G122+Rozvaha!G137","v":61316},{"$f":"Rozvaha!H122+Rozvaha!H137","v":67967},{"$f":"Rozvaha!I122+Rozvaha!I137","v":71302},{"$f":"Rozvaha!J122+Rozvaha!J137","v":87290},null,null,null,"Koeficient samofinancování",{"$f":"M13/M14","v":0.23471808098731106},{"$f":"N13/N14","v":0.33954347934668599},{"$f":"O13/O14","v":0.30013422944787582},{"$f":"P13/P14","v":0.3600658456285819},{"$f":"Q13/Q14","v":0.35286559324121447}]
[null,null,"Pohotová likvidita",{"$f":"(D13-D14)/D15","v":0.52916301080218053},{"$f":"(E13-E14)/E15","v":0.71439754713288539},{"$f":"(F13-F14)/F15","v":0.88336987067253225},{"$f":"(G13-G14)/G15","v":1.0874730021598271},{"$f":"(H13-H14)/H15","v":1.1880971474395692}]
[null,null,"B Ě Ž N Á      L I K V I D I  T A "]
[null,null,null,null,null,null,null,null,null,null,"A K  T I V I T A ","O B R A T     C E L K O V Ý CH     A K T I V"]
[null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,null,"Oběžná aktiva",{"$f":"Rozvaha!F43","v":80133},{"$f":"Rozvaha!G43","v":83840},{"$f":"Rozvaha!H43","v":101028},{"$f":"Rozvaha!I43","v":127144},{"$f":"Rozvaha!J43","v":157293},null,null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,null,"Krátkodobé závazky",{"$f":"Rozvaha!F122+Rozvaha!F137","v":69523},{"$f":"Rozvaha!G122+Rozvaha!G137","v":61316},{"$f":"Rozvaha!H122+Rozvaha!H137","v":67967},{"$f":"Rozvaha!I122+Rozvaha!I137","v":71302},{"$f":"Rozvaha!J122+Rozvaha!J137","v":87290},null,null,null,"Roční tržby",{"$f":"VZZ!F13+VZZ!F17","v":319777},{"$f":"VZZ!G13+VZZ!G17","v":359413},{"$f":"VZZ!H13+VZZ!H17","v":347988},{"$f":"VZZ!I13+VZZ!I17","v":409052},{"$f":"VZZ!J13+VZZ!J17","v":488508}]
[null,null,"Běžná likvidita",{"$f":"D20/D21","v":1.152611366022755},{"$f":"E20/E21","v":1.3673429447452541},{"$f":"F20/F21","v":1.4864272367472451},{"$f":"G20/G21","v":1.7831757874954419},{"$f":"H20/H21","v":1.8019589872837667},null,null,null,"Celková aktiva",{"$f":"Rozvaha!F13","v":164001},{"$f":"Rozvaha!G13","v":180189},{"$f":"Rozvaha!H13","v":213068},{"$f":"Rozvaha!I13","v":246030},{"$f":"Rozvaha!J13","v":300409}]
[null,null,null,null,null,null,null,null,null,null,null,"Obrat celkových aktiv",{"$f":"M21/M22","v":1.9498478667813002},{"$f":"N21/N22","v":1.9946445121511303},{"$f":"O21/O22","v":1.6332250736853962},{"$f":"P21/P22","v":1.662610250782425},{"$f":"Q21/Q22","v":1.6261430250092375}]
[null,null,null,null,null,null,null,null,null,null,null,"O B R A T      S T Á L Ý CH     A K T I V "]
[null,"R E N T A B I L I T A ","R E N T A B I L I T A    V L O Ž E N É H O     K A P I  T Á L U "]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015},null,null,null,"Roční tržby",{"$f":"VZZ!F13+VZZ!F17","v":319777},{"$f":"VZZ!G13+VZZ!G17","v":359413},{"$f":"VZZ!H13+VZZ!H17","v":347988},{"$f":"VZZ!I13+VZZ!I17","v":409052},{"$f":"VZZ!J13+VZZ!J17","v":488508}]
[null,null,"Zisk před zdaněním",{"$f":"VZZ!F73","v":17468},{"$f":"VZZ!G73","v":24812},{"$f":"VZZ!H73","v":22254},{"$f":"VZZ!I73","v":33099},{"$f":"VZZ!J73","v":33811},null,null,null,"Stálá aktiva",{"$f":"Rozvaha!F15","v":81054},{"$f":"Rozvaha!G15","v":94185},{"$f":"Rozvaha!H15","v":110845},{"$f":"Rozvaha!I15","v":118018},{"$f":"Rozvaha!J15","v":142888}]
[null,null,"Nákladové úroky",{"$f":"VZZ!F55","v":1282},{"$f":"VZZ!G55","v":1478},{"$f":"VZZ!H55","v":1333},{"$f":"VZZ!I55","v":1549},{"$f":"VZZ!J55","v":1488},null,null,null,"Obrat stálých aktiv",{"$f":"M27/M28","v":3.9452340415031952},{"$f":"N27/N28","v":3.8160322769018422},{"$f":"O27/O28","v":3.1394108890793451},{"$f":"P27/P28","v":3.4660136589333832},{"$f":"Q27/Q28","v":3.4188175354123511}]
[null,null,"Celkový kapitál",{"$f":"Rozvaha!F84","v":164001},{"$f":"Rozvaha!G84","v":180189},{"$f":"Rozvaha!H84","v":213068},{"$f":"Rozvaha!I84","v":246030},{"$f":"Rozvaha!J84","v":300409},null,null,null,"O B R A T    Z Á S O B "]
[null,null,"ROI",{"$f":"(D28+D29)/D30","v":0.11432857116724898},{"$f":"(E28+E29)/E30","v":0.145902358079572},{"$f":"(F28+F29)/F30","v":0.11070174779882479},{"$f":"(G28+G29)/G30","v":0.14082835426573995},{"$f":"(H28+H29)/H30","v":0.11750313738935918}]
[null,null,"R E N T A B I L I T A    C E L K O V É H O     V L O Ž E N É H O     K A P I  T Á L U ",null,null,null,null,null,null,null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,null,null,null,null,null,null,null,null,null,null,"Roční tržby",{"$f":"VZZ!F13+VZZ!F17","v":319777},{"$f":"VZZ!G13+VZZ!G17","v":359413},{"$f":"VZZ!H13+VZZ!H17","v":347988},{"$f":"VZZ!I13+VZZ!I17","v":409052},{"$f":"VZZ!J13+VZZ!J17","v":488508}]
[null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015},null,null,null,"Zásoby",{"$f":"Rozvaha!F44","v":43344},{"$f":"Rozvaha!G44","v":40036},{"$f":"Rozvaha!H44","v":40988},{"$f":"Rozvaha!I44","v":49605},{"$f":"Rozvaha!J44","v":53584}]
[null,null,"EBIT",{"$f":"VZZ!F72+VZZ!F61+VZZ!F67+VZZ!F55","v":18750},{"$f":"VZZ!G72+VZZ!G61+VZZ!G67+VZZ!G55","v":26290},{"$f":"VZZ!H72+VZZ!H61+VZZ!H67+VZZ!H55","v":23587},{"$f":"VZZ!I72+VZZ!I61+VZZ!I67+VZZ!I55","v":34648},{"$f":"VZZ!J72+VZZ!J61+VZZ!J67+VZZ!J55","v":35299},null,null,null,"Obrat zásob",{"$f":"M33/M34","v":7.3776531930601701},{"$f":"N33/N34","v":8.9772454790688379},{"$f":"O33/O34","v":8.489997072313848},{"$f":"P33/P34","v":8.2461848603971379},{"$f":"Q33/Q34","v":9.1166766198865332}]
[null,null,"Celková aktiva",{"$f":"Rozvaha!F13","v":164001},{"$f":"Rozvaha!G13","v":180189},{"$f":"Rozvaha!H13","v":213068},{"$f":"Rozvaha!I13","v":246030},{"$f":"Rozvaha!J13","v":300409},null,null,null,"D O B A     O B R A T U     Z Á S O B "]
[null,null,"ROA",{"$f":"D35/D36","v":0.11432857116724898},{"$f":"E35/E36","v":0.145902358079572},{"$f":"F35/F36","v":0.11070174779882479},{"$f":"G35/G36","v":0.14082835426573995},{"$f":"H35/H36","v":0.11750313738935918}]
[null,null,"R E N T A B I L I T A     V L A S T N Í H O     K A P I T Á L U",null,null,null,null,null,null,null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,null,null,null,null,null,null,null,null,null,null,"Zásoby",{"$f":"Rozvaha!F44","v":43344},{"$f":"Rozvaha!G44","v":40036},{"$f":"Rozvaha!H44","v":40988},{"$f":"Rozvaha!I44","v":49605},{"$f":"Rozvaha!J44","v":53584}]
[null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015},null,null,null,"Tržby",{"$f":"VZZ!F13+VZZ!F17","v":319777},{"$f":"VZZ!G13+VZZ!G17","v":359413},{"$f":"VZZ!H13+VZZ!H17","v":347988},{"$f":"VZZ!I13+VZZ!I17","v":409052},{"$f":"VZZ!J13+VZZ!J17","v":488508}]
[null,null,"EAT",{"$f":"VZZ!F72","v":12377},{"$f":"VZZ!G72","v":20990},{"$f":"VZZ!H72","v":17767},{"$f":"VZZ!I72","v":26639},{"$f":"VZZ!J72","v":27417},null,null,null,"Doba obratu zásob",{"$f":"M39/(M40/360)","v":48.796004715786317},{"$f":"N39/(N40/360)","v":40.101387540239223},{"$f":"O39/(O40/360)","v":42.40284147729232},{"$f":"P39/(P40/360)","v":43.65655222318923},{"$f":"Q39/(Q40/360)","v":39.48807389029453}]
[null,null,"Vlastní kapitál",{"$f":"Rozvaha!F85","v":38494},{"$f":"Rozvaha!G85","v":61182},{"$f":"Rozvaha!H85","v":63949},{"$f":"Rozvaha!I85","v":88587},{"$f":"Rozvaha!J85","v":106004},null,null,null,"D O B A     O B R A T U      P O H L E D Á V E K "]
[null,null,"ROE",{"$f":"D41/D42","v":0.32153062814984151},{"$f":"E41/E42","v":0.34307476055048869},{"$f":"F41/F42","v":0.27783077139595613},{"$f":"G41/G42","v":0.30071003646133182},{"$f":"H41/H42","v":0.25864118335157166}]
[null,null,"R E N T A B I L I T A     T R Ž E B ",null,null,null,null,null,null,null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,null,null,null,null,null,null,null,null,null,null,"Pohledávky",{"$f":"Rozvaha!F51+Rozvaha!F60","v":22051},{"$f":"Rozvaha!G51+Rozvaha!G60","v":30424},{"$f":"Rozvaha!H51+Rozvaha!H60","v":42591},{"$f":"Rozvaha!I51+Rozvaha!I60","v":56579},{"$f":"Rozvaha!J51+Rozvaha!J60","v":61194}]
[null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015},null,null,null,"Tržby",{"$f":"VZZ!F13+VZZ!F17","v":319777},{"$f":"VZZ!G13+VZZ!G17","v":359413},{"$f":"VZZ!H13+VZZ!H17","v":347988},{"$f":"VZZ!I13+VZZ!I17","v":409052},{"$f":"VZZ!J13+VZZ!J17","v":488508}]
[null,null,"EAT",{"$f":"VZZ!F72","v":12377},{"$f":"VZZ!G72","v":20990},{"$f":"VZZ!H72","v":17767},{"$f":"VZZ!I72","v":26639},{"$f":"VZZ!J72","v":27417},null,null,null,"Doba obratu pohledávek",{"$f":"M45/(M46/360)","v":24.824674695178203},{"$f":"N45/(N46/360)","v":30.473689042967283},{"$f":"O45/(O46/360)","v":44.061174523259425},{"$f":"P45/(P46/360)","v":49.794255987013877},{"$f":"Q45/(Q46/360)","v":45.096170380014243}]
[null,null,"Tržby",{"$f":"VZZ!F13+VZZ!F17","v":319777},{"$f":"VZZ!G13+VZZ!G17","v":359413},{"$f":"VZZ!H13+VZZ!H17","v":347988},{"$f":"VZZ!I13+VZZ!I17","v":409052},{"$f":"VZZ!J13+VZZ!J17","v":488508},null,null,null,"D O B A     O B R A T U     Z Á V A Z K Ů"]
[null,null,"ROS",{"$f":"D47/D48","v":3.8705097614900381E-2},{"$f":"E47/E48","v":5.8400781273910518E-2},{"$f":"F47/F48","v":5.1056358265227537E-2},{"$f":"G47/G48","v":6.5123749547734769E-2},{"$f":"H47/H48","v":5.6123952934240585E-2}]
[null,null,"R E N T A B I L I T A    D L O U H O D O B Ě     I N V E S  T O V A N É H O    K A P I T Á L U",null,null,null,null,null,null,null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,null,null,null,null,null,null,null,null,null,null,"Závazky",{"$f":"Rozvaha!F111+Rozvaha!F122","v":71279},{"$f":"Rozvaha!G111+Rozvaha!G122","v":61892},{"$f":"Rozvaha!H111+Rozvaha!H122","v":68726},{"$f":"Rozvaha!I111+Rozvaha!I122","v":72170},{"$f":"Rozvaha!J111+Rozvaha!J122","v":97171}]
[null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015},null,null,null,"Tržby",{"$f":"VZZ!F13+VZZ!F17","v":319777},{"$f":"VZZ!G13+VZZ!G17","v":359413},{"$f":"VZZ!H13+VZZ!H17","v":347988},{"$f":"VZZ!I13+VZZ!I17","v":409052},{"$f":"VZZ!J13+VZZ!J17","v":488508}]
[null,null,"EBIT",{"$f":"VZZ!F72+VZZ!F61+VZZ!F67+VZZ!F55","v":18750},{"$f":"VZZ!G72+VZZ!G61+VZZ!G67+VZZ!G55","v":26290},{"$f":"VZZ!H72+VZZ!H61+VZZ!H67+VZZ!H55","v":23587},{"$f":"VZZ!I72+VZZ!I61+VZZ!I67+VZZ!I55","v":34648},{"$f":"VZZ!J72+VZZ!J61+VZZ!J67+VZZ!J55","v":35299},null,null,null,"Doba obratu závazků",{"$f":"M51/(M52/360)","v":80.244795591928124},{"$f":"N51/(N52/360)","v":61.993083166162606},{"$f":"O51/(O52/360)","v":71.098313734956378},{"$f":"P51/(P52/360)","v":63.515641043192559},{"$f":"Q51/(Q52/360)","v":71.608980815053187}]
[null,null,"Dlouhodobé závazky",{"$f":"Rozvaha!F111+Rozvaha!F135+Rozvaha!F106","v":38668},{"$f":"Rozvaha!G111+Rozvaha!G135+Rozvaha!G106","v":31507},{"$f":"Rozvaha!H111+Rozvaha!H135+Rozvaha!H106","v":46024},{"$f":"Rozvaha!I111+Rozvaha!I135+Rozvaha!I106","v":43177},{"$f":"Rozvaha!J111+Rozvaha!J135+Rozvaha!J106","v":50756}]
[null,null,"Vlastní kapitál",{"$f":"Rozvaha!F85","v":38494},{"$f":"Rozvaha!G85","v":61182},{"$f":"Rozvaha!H85","v":63949},{"$f":"Rozvaha!I85","v":88587},{"$f":"Rozvaha!J85","v":106004}]
[null,null,"ROCE",{"$f":"D53/(D54+D55)","v":0.24299525673258859},{"$f":"E53/(E54+E55)","v":0.28363667749139598},{"$f":"F53/(F54+F55)","v":0.21447991779800496},{"$f":"G53/(G54+G55)","v":0.26295498011596491},{"$f":"H53/(H54+H55)","v":0.22517861699413116}]

{"sheet":"Soustavy ukazatelů","index":7,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[11,10,11,11],[10,10,10,11],[31,1,32,2],[28,1,29,2],[22,1,23,2],[25,1,26,2],[31,10,32,11],[28,10,29,11],[25,10,26,11],[22,10,23,11],[19,1,20,2],[16,1,17,2],[13,1,14,2],[19,10,20,11],[16,10,17,11],[13,10,14,11],[3,1,4,7],[9,10,9,11],[5,10,5,11],[6,10,6,11],[7,10,7,11],[8,10,8,11],[3,10,4,16],[9,1,9,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[10,1,10,2],[11,1,11,2]]}
[]
[]
[]
[null,"A L T M A N Ů V     M O D E L ",null,null,null,null,null,null,null,null,"I N D E X       D Ů V Ě R Y H O D N O S T I     I N 0 5 "]
[]
[null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015},null,null,null,null,{"$f":"Rozvaha!F10","v":2011},{"$f":"Rozvaha!G10","v":2012},{"$f":"Rozvaha!H10","v":2013},{"$f":"Rozvaha!I10","v":2014},{"$f":"Rozvaha!J10","v":2015}]
[null,"A",null,{"$f":"D15/D33","v":6.4694727471173955E-2},{"$f":"E15/E33","v":0.1250020811481278},{"$f":"F15/F33","v":0.15516642574201664},{"$f":"G15/G33","v":0.22697232044872576},{"$f":"H15/H33","v":0.23302564170847079},null,null,"A",null,{"$f":"M15/M18","v":1.3145213648495924},{"$f":"N15/N18","v":1.5332102379088526},{"$f":"O15/O18","v":1.445048051164147},{"$f":"P15/P18","v":1.580956297671908},{"$f":"Q15/Q18","v":1.5582753666039018}]
[null,"B",null,{"$f":"D18/D33","v":8.3298272571508708E-2},{"$f":"E18/E33","v":0.13895409819689325},{"$f":"F18/F33","v":0.14562487093322318},{"$f":"G18/G33","v":0.19019631752225338},{"$f":"H18/H33","v":0.21115545805884645},null,null,"B",null,{"$f":"M21/M24","v":14.625585023400935},{"$f":"N21/N24","v":17.787550744248986},{"$f":"O21/O24","v":17.694673668417103},{"$f":"P21/P24","v":22.367979341510651},{"$f":"Q21/Q24","v":23.72244623655914}]
[null,"C",null,{"$f":"D21/D33","v":0.11432857116724898},{"$f":"E21/E33","v":0.145902358079572},{"$f":"F21/F33","v":0.11070174779882479},{"$f":"G21/G33","v":0.14082835426573995},{"$f":"H21/H33","v":0.11750313738935918},null,null,"C",null,{"$f":"M21/M15","v":0.11432857116724898},{"$f":"N21/N15","v":0.145902358079572},{"$f":"O21/O15","v":0.11070174779882479},{"$f":"P21/P15","v":0.14082835426573995},{"$f":"Q21/Q15","v":0.11750313738935918}]
[null,"D",null,{"$f":"D24/D30","v":0.3085419321743173},{"$f":"E24/E30","v":0.52059153874953201},{"$f":"F24/F30","v":0.4337083833513059},{"$f":"G24/G30","v":0.56924836622306763},{"$f":"H24/H30","v":0.54986176166985679},null,null,"D",null,{"$f":"M27/M15","v":1.9498478667813002},{"$f":"N27/N15","v":1.9946445121511303},{"$f":"O27/O15","v":1.6332250736853962},{"$f":"P27/P15","v":1.662610250782425},{"$f":"Q27/Q15","v":1.6261430250092375}]
[null,"E",null,{"$f":"D27/D33","v":1.9865610575545272},{"$f":"E27/E33","v":2.0075864786418705},{"$f":"F27/F33","v":1.6477603394221563},{"$f":"G27/G33","v":1.6790797870178433},{"$f":"H27/H33","v":1.6404701590165407},null,null,"E",null,{"$f":"M30/M33","v":0.93077253667545556},{"$f":"N30/N33","v":0.97469104944371465},{"$f":"O30/O33","v":0.9961054198751762},{"$f":"P30/P33","v":1.1307317420226957},{"$f":"Q30/Q33","v":1.1074866046596774}]
[null,"Z-skóre",null,{"$f":"0.717*D7+0.847*D8+3.107*D9+0.42*D10+0.998*D11","v":2.5843341740341734},{"$f":"0.717*E7+0.847*E8+3.107*E9+0.42*E10+0.998*E11","v":2.8828589918685963},{"$f":"0.717*F7+0.847*F8+3.107*F9+0.42*F10+0.998*F11","v":2.405171263099275},{"$f":"0.717*G7+0.847*G8+3.107*G9+0.42*G10+0.998*G11","v":2.676195072664235},{"$f":"0.717*H7+0.847*H8+3.107*H9+0.42*H10+0.998*H11","v":2.5791414645494029},null,null,"IN05",null,{"$f":"0.13*M7+0.04*M8+3.97*M9+0.21*M10+0.09*M11","v":1.703033186225327},{"$f":"0.13*N7+0.04*N8+3.97*N9+0.21*N10+0.09*N11","v":1.9966492642756826},{"$f":"0.13*O7+0.04*O8+3.97*O9+0.21*O10+0.09*O11","v":1.7677558854120567},{"$f":"0.13*P7+0.04*P8+3.97*P9+0.21*P10+0.09*P11","v":2.1102460682391135},{"$f":"0.13*Q7+0.04*Q8+3.97*Q9+0.21*Q10+0.09*Q11","v":2.0591249322279395}]
[]
[null,"ČPK",null,2011,2012,2013,2014,2015,null,null,"Aktiva",null,2011,2012,2013,2014,2015]
[null,null,null,{"$f":"Rozvaha!F43-Rozvaha!F122","v":10610},{"$f":"Rozvaha!G43-Rozvaha!G122","v":22524},{"$f":"Rozvaha!H43-Rozvaha!H122","v":33061},{"$f":"Rozvaha!I43-Rozvaha!I122","v":55842},{"$f":"Rozvaha!J43-Rozvaha!J122","v":70003},null,null,null,null,{"$f":"Rozvaha!F13","v":164001},{"$f":"Rozvaha!G13","v":180189},{"$f":"Rozvaha!H13","v":213068},{"$f":"Rozvaha!I13","v":246030},{"$f":"Rozvaha!J13","v":300409}]
[]
[null,"Nerozdělený zisk",null,2011,2012,2013,2014,2015,null,null,"Cizí kapitál            ",null,2011,2012,2013,2014,2015]
[null,null,null,{"$f":"Rozvaha!F101","v":13661},{"$f":"Rozvaha!G101","v":25038},{"$f":"Rozvaha!H101","v":31028},{"$f":"Rozvaha!I101","v":46794},{"$f":"Rozvaha!J101","v":63433},null,null,null,null,{"$f":"Rozvaha!F105","v":124761},{"$f":"Rozvaha!G105","v":117524},{"$f":"Rozvaha!H105","v":147447},{"$f":"Rozvaha!I105","v":155621},{"$f":"Rozvaha!J105","v":192783}]
[]
[null,"EBIT",null,2011,2012,2013,2014,2015,null,null,"EBIT",null,2011,2012,2013,2014,2015]
[null,null,null,{"$f":"VZZ!F72+VZZ!F61+VZZ!F67+VZZ!F55","v":18750},{"$f":"VZZ!G72+VZZ!G61+VZZ!G67+VZZ!G55","v":26290},{"$f":"VZZ!H72+VZZ!H61+VZZ!H67+VZZ!H55","v":23587},{"$f":"VZZ!I72+VZZ!I61+VZZ!I67+VZZ!I55","v":34648},{"$f":"VZZ!J72+VZZ!J61+VZZ!J67+VZZ!J55","v":35299},null,null,null,null,{"$f":"VZZ!F72+VZZ!F61+VZZ!F67+VZZ!F55","v":18750},{"$f":"VZZ!G72+VZZ!G61+VZZ!G67+VZZ!G55","v":26290},{"$f":"VZZ!H72+VZZ!H61+VZZ!H67+VZZ!H55","v":23587},{"$f":"VZZ!I72+VZZ!I61+VZZ!I67+VZZ!I55","v":34648},{"$f":"VZZ!J72+VZZ!J61+VZZ!J67+VZZ!J55","v":35299}]
[]
[null,"Vlastní kapitál",null,2011,2012,2013,2014,2015,null,null,"Nákladové úroky",null,2011,2012,2013,2014,2015]
[null,null,null,{"$f":"Rozvaha!F85","v":38494},{"$f":"Rozvaha!G85","v":61182},{"$f":"Rozvaha!H85","v":63949},{"$f":"Rozvaha!I85","v":88587},{"$f":"Rozvaha!J85","v":106004},null,null,null,null,{"$f":"VZZ!F55","v":1282},{"$f":"VZZ!G55","v":1478},{"$f":"VZZ!H55","v":1333},{"$f":"VZZ!I55","v":1549},{"$f":"VZZ!J55","v":1488}]
[]
[null,"Celkový obrat",null,2011,2012,2013,2014,2015,null,null,"Celkové výnosy ",null,2011,2012,2013,2014,2015]
[null,null,null,{"$f":"VZZ!F13+VZZ!F17+VZZ!F31+VZZ!F43","v":325798},{"$f":"VZZ!G13+VZZ!G17+VZZ!G31+VZZ!G43","v":361745},{"$f":"VZZ!H13+VZZ!H17+VZZ!H31+VZZ!H43","v":351085},{"$f":"VZZ!I13+VZZ!I17+VZZ!I31+VZZ!I43","v":413104},{"$f":"VZZ!J13+VZZ!J17+VZZ!J31+VZZ!J43","v":492812},null,null,null,null,{"$f":"VZZ!F13+VZZ!F17","v":319777},{"$f":"VZZ!G13+VZZ!G17","v":359413},{"$f":"VZZ!H13+VZZ!H17","v":347988},{"$f":"VZZ!I13+VZZ!I17","v":409052},{"$f":"VZZ!J13+VZZ!J17","v":488508}]
[]
[null,"Účetní hodnota celkových dluhů",null,2011,2012,2013,2014,2015,null,null,"Oběžná aktiva",null,2011,2012,2013,2014,2015]
[null,null,null,{"$f":"Rozvaha!F105","v":124761},{"$f":"Rozvaha!G105","v":117524},{"$f":"Rozvaha!H105","v":147447},{"$f":"Rozvaha!I105","v":155621},{"$f":"Rozvaha!J105","v":192783},null,null,null,null,{"$f":"Rozvaha!F43","v":80133},{"$f":"Rozvaha!G43","v":83840},{"$f":"Rozvaha!H43","v":101028},{"$f":"Rozvaha!I43","v":127144},{"$f":"Rozvaha!J43","v":157293}]
[]
[null,"Aktiva",null,2011,2012,2013,2014,2015,null,null,"Krátkodobé závazky a úvěry",null,2011,2012,2013,2014,2015]
[null,null,null,{"$f":"Rozvaha!F13","v":164001},{"$f":"Rozvaha!G13","v":180189},{"$f":"Rozvaha!H13","v":213068},{"$f":"Rozvaha!I13","v":246030},{"$f":"Rozvaha!J13","v":300409},null,null,null,null,{"$f":"Rozvaha!F122+Rozvaha!F136+Rozvaha!F137","v":86093},{"$f":"Rozvaha!G122+Rozvaha!G136+Rozvaha!G137","v":86017},{"$f":"Rozvaha!H122+Rozvaha!H136+Rozvaha!H137","v":101423},{"$f":"Rozvaha!I122+Rozvaha!I136+Rozvaha!I137","v":112444},{"$f":"Rozvaha!J122+Rozvaha!J136+Rozvaha!J137","v":142027}]

{"sheet":"Regresní analýza","index":8,"n_rows":58,"n_cols":25,"rows_kept":58,"cut":false,"hidden":false,"merged":[[40,18,41,24],[49,18,49,20],[52,18,52,20],[53,18,53,20],[40,2,41,8],[52,2,52,4],[20,10,20,12],[40,10,41,16],[49,10,49,12],[52,10,52,12],[16,10,16,12],[17,10,17,12],[18,10,18,12],[3,18,4,24],[15,18,15,20],[18,18,18,20],[3,2,4,8],[15,2,15,4],[5,7,5,8],[3,10,4,16],[12,10,12,12],[13,10,13,12],[15,10,15,12],[55,10,55,12],[57,10,57,12],[42,23,42,24],[50,18,50,20],[54,18,54,20],[55,18,55,20],[57,18,57,20],[42,15,42,16],[50,10,50,12],[53,10,53,12],[42,7,42,8],[49,2,49,4],[50,2,50,4],[53,2,53,4],[54,10,54,12],[54,2,54,4],[55,2,55,4],[57,2,57,4],[5,23,5,24],[12,18,12,20],[13,18,13,20],[16,18,16,20],[17,18,17,20],[5,15,5,16],[20,2,20,4],[12,2,12,4],[13,2,13,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[20,18,20,20]]}
[]
[]
[]
[null,null,"Č I S T Ý     P R A C O V N Í     K A P I T Á L     ( Č P K )",null,null,null,null,null,null,null,"R E  N T A B I L I T A    C E L K O V É H O   V L O Ž E N É H O    K A P I TÁ L U",null,null,null,null,null,null,null,"O B R A T    C E L K O V Ý CH    A K  T I V "]
[]
[null,null,"i","Roky","yi (kč)","1di(y)","ki(y)","Regresní přímka",null,null,"i","Roky","yi (%)","1di(y)","ki(y)","Regresní přímka",null,null,"i","Roky","yi","1di(y)","ki(y)","Regresní přímka"]
[null,null,1,2011,10610,"-","-",{"$f":"F19+F18","v":7987.2},null,null,1,2011,13.37,"-","-",{"$f":"N19+N18","v":15.071999999999989},null,null,1,2011,1.9,"-","-",{"$f":"V19+V18","v":1.9400000000000004}]
[null,null,2,2012,22524,{"$f":"E8-E7","v":11914},{"$f":"E8/E7","v":2.1229029217719133},{"$f":"(F19*2)+F18","v":23197.599999999999},null,null,2,2012,16.96,{"$f":"M8-M7","v":3.5900000000000016},{"$f":"M8/M7","v":1.268511593118923},{"$f":"(N19*2)+N18","v":14.572999999999993},null,null,2,2012,2,{"$f":"U8-U7","v":0.10000000000000009},{"$f":"U8/U7","v":1.0526315789473684},{"$f":"(V19*2)+V18","v":1.8500000000000003}]
[null,null,3,2013,33061,{"$f":"E9-E8","v":10537},{"$f":"E9/E8","v":1.4678121115254839},{"$f":"(F19*3)+F18","v":38408},null,null,3,2013,13.57,{"$f":"M9-M8","v":-3.3900000000000006},{"$f":"M9/M8","v":0.80011792452830188},{"$f":"(N19*3)+N18","v":14.073999999999998},null,null,3,2013,1.6,{"$f":"U9-U8","v":-0.39999999999999991},{"$f":"U9/U8","v":0.8},{"$f":"(V19*3)+V18","v":1.76}]
[null,null,4,2014,55842,{"$f":"E10-E9","v":22781},{"$f":"E10/E9","v":1.689059617071474},{"$f":"(F19*4)+F18","v":53618.400000000001},null,null,4,2014,14.23,{"$f":"M10-M9","v":0.66000000000000014},{"$f":"M10/M9","v":1.0486366985998525},{"$f":"(N19*4)+N18","v":13.575000000000003},null,null,4,2014,1.7,{"$f":"U10-U9","v":9.9999999999999867E-2},{"$f":"U10/U9","v":1.0625},{"$f":"(V19*4)+V18","v":1.67}]
[null,null,5,2015,70003,{"$f":"E11-E10","v":14161},{"$f":"E11/E10","v":1.2535904874467247},{"$f":"(F19*5)+F18","v":68828.800000000003},null,null,5,2015,12.24,{"$f":"M11-M10","v":-1.9900000000000002},{"$f":"M11/M10","v":0.86015460295151092},{"$f":"(N19*5)+N18","v":13.076000000000008},null,null,5,2015,1.6,{"$f":"U11-U10","v":-9.9999999999999867E-2},{"$f":"U11/U10","v":0.94117647058823539},{"$f":"(V19*5)+V18","v":1.5799999999999996}]
[]
[null,null,"Průměr první diference",null,null,{"$f":"(E11-E7)/4","v":14848.25},null,null,null,null,"Průměr první diference",null,null,{"$f":"(M11-M7)/4","v":-0.28249999999999975},null,null,null,null,"Průměr první diference",null,null,{"$f":"(U11-U7)/4","v":-7.4999999999999956E-2}]
[null,null,"Průměrný koeficient růstu",null,null,{"$f":"(E11/E7)^(1/4)","v":1.6026929151113902},null,null,null,null,"Průměrný koeficient růstu",null,null,{"$f":"(M11/M7)^(1/4)","v":0.97816586373344894},null,null,null,null,"Průměrný koeficient růstu",null,null,{"$f":"(U11/U7)^(1/4)","v":0.95794725088714938}]
[]
[null,null,"Výběrový průměr x",null,null,3,null,null,null,null,"Výběrový průměr x",null,null,3,null,null,null,null,"Výběrový průměr x",null,null,3]
[null,null,"Výběrový průměr y",null,null,{"$f":"SUM(E7:E11)/5","v":38408},null,null,null,null,"Výběrový průměr y",null,null,{"$f":"SUM(M7:M11)/5","v":14.073999999999998},null,null,null,null,"Výběrový průměr y",null,null,{"$f":"SUM(U7:U11)/5","v":1.7600000000000002}]
[null,null,"b1",null,null,{"$f":"(SUM(E7:E11)-15*F19)/(5)","v":-7223.2},null,null,null,null,"b1",null,null,{"$f":"(SUM(M7:M11)-15*N19)/(5)","v":15.570999999999984},null,null,null,null,"b1",null,null,{"$f":"(SUM(U7:U11)-15*V19)/(5)","v":2.0300000000000007}]
[null,null,"b2",null,null,{"$f":"(((E7+2*E8+3*E9+4*E10+5*E11)-5*3*F17)/(55-(5*3*3)))","v":15210.4},null,null,null,null,"b2",null,null,{"$f":"(((M7+2*M8+3*M9+4*M10+5*M11)-5*3*N17)/(55-(5*3*3)))","v":-0.49899999999999523},null,null,null,null,"b2",null,null,{"$f":"(((U7+2*U8+3*U9+4*U10+5*U11)-5*3*V17)/(55-(5*3*3)))","v":-9.0000000000000219E-2}]
[]
[null,null,"Rovnice přímky",null,null,"η(𝒳)",{"$f":"F18","v":-7223.2},{"$f":"F19","v":15210.4},"x",null,"Rovnice přímky",null,null,"η(𝒳)",{"$f":"N18","v":15.570999999999984},{"$f":"N19","v":-0.49899999999999523},"x",null,"Rovnice přímky",null,null,"η(𝒳)",{"$f":"V18","v":2.0300000000000007},{"$f":"V19","v":-9.0000000000000219E-2},"x"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"C E L K O V Á     Z A D L U Ž E N O S T ",null,null,null,null,null,null,null,"O K A M Ž I T Á     L I K V I D I T A ",null,null,null,null,null,null,null,"A L T M A N Ů V     I N D E X    ( Z - S C O R E )"]
[]
[null,null,"i","Roky","yi (kč)","1di(y)","ki(y)","Regresní přímka",null,null,"i","Roky","yi (j)","1di(y)","ki(y)","Regresní přímka",null,null,"i","Roky","yi (kč)","1di(y)","ki(y)","Regresní přímka"]
[null,null,1,2011,76.069999999999993,"-","-",{"$f":"F56+F55","v":72.736000000000018},null,null,1,2011,0.2,"-","-",{"$f":"N56+N55","v":0.15999999999999998},null,null,1,2011,2.6440000000000001,"-","-",{"$f":"V56+V55","v":2.7465999999999995}]
[null,null,2,2012,65.22,{"$f":"E45-E44","v":-10.849999999999994},{"$f":"E45/E44","v":0.8573682134875773},{"$f":"(F56*2)+F55","v":70.159000000000006},null,null,2,2012,0.2,{"$f":"M45-M44","v":0},{"$f":"M45/M44","v":1},{"$f":"(N56*2)+N55","v":0.22999999999999998},null,null,2,2012,2.956,{"$f":"U45-U44","v":0.31199999999999983},{"$f":"U45/U44","v":1.118003025718608},{"$f":"(V56*2)+V55","v":2.7090999999999994}]
[null,null,3,2013,69.2,{"$f":"E46-E45","v":3.980000000000004},{"$f":"E46/E45","v":1.0610242256976388},{"$f":"(F56*3)+F55","v":67.582000000000008},null,null,3,2013,0.3,{"$f":"M46-M45","v":9.9999999999999978E-2},{"$f":"M46/M45","v":1.4999999999999998},{"$f":"(N56*3)+N55","v":0.30000000000000004},null,null,3,2013,2.4830000000000001,{"$f":"U46-U45","v":-0.47299999999999986},{"$f":"U46/U45","v":0.83998646820027068},{"$f":"(V56*3)+V55","v":2.6715999999999998}]
[null,null,4,2014,63.25,{"$f":"E47-E46","v":-5.9500000000000028},{"$f":"E47/E46","v":0.91401734104046239},{"$f":"(F56*4)+F55","v":65.004999999999995},null,null,4,2014,0.3,{"$f":"M47-M46","v":0},{"$f":"M47/M46","v":1},{"$f":"(N56*4)+N55","v":0.37},null,null,4,2014,2.681,{"$f":"U47-U46","v":0.19799999999999995},{"$f":"U47/U46","v":1.0797422472815144},{"$f":"(V56*4)+V55","v":2.6340999999999997}]
[null,null,5,2015,64.17,{"$f":"E48-E47","v":0.92000000000000171},{"$f":"E48/E47","v":1.0145454545454546},{"$f":"(F56*5)+F55","v":62.427999999999983},null,null,5,2015,0.5,{"$f":"M48-M47","v":0.2},{"$f":"M48/M47","v":1.6666666666666667},{"$f":"(N56*5)+N55","v":0.44000000000000006},null,null,5,2015,2.5939999999999999,{"$f":"U48-U47","v":-8.7000000000000188E-2},{"$f":"U48/U47","v":0.9675494218575158},{"$f":"(V56*5)+V55","v":2.5965999999999996}]
[]
[null,null,"Průměr první diference",null,null,{"$f":"(E48-E44)/4","v":-2.9749999999999979},null,null,null,null,"Průměr první diference",null,null,{"$f":"(M48-M44)/4","v":7.4999999999999997E-2},null,null,null,null,"Průměr první diference",null,null,{"$f":"(U48-U44)/4","v":-1.2500000000000067E-2}]
[null,null,"Průměrný koeficient růstu",null,null,{"$f":"(E48/E44)^(1/4)","v":0.95836215574438677},null,null,null,null,"Průměrný koeficient růstu",null,null,{"$f":"(M48/M44)^(1/4)","v":1.2574334296829355},null,null,null,null,"Průměrný koeficient růstu",null,null,{"$f":"(U48/U44)^(1/4)","v":0.99523841344448849}]
[]
[null,null,"Výběrový průměr x",null,null,3,null,null,null,null,"Výběrový průměr x",null,null,3,null,null,null,null,"Výběrový průměr x",null,null,3]
[null,null,"Výběrový průměr y",null,null,{"$f":"SUM(E44:E48)/5","v":67.582000000000008},null,null,null,null,"Výběrový průměr y",null,null,{"$f":"SUM(M44:M48)/5","v":0.3},null,null,null,null,"Výběrový průměr y",null,null,{"$f":"SUM(U44:U48)/5","v":2.6715999999999998}]
[null,null,"b1",null,null,{"$f":"(SUM(E44:E48)-15*F56)/(5)","v":75.313000000000031},null,null,null,null,"b1",null,null,{"$f":"(SUM(M44:M48)-15*N56)/(5)","v":8.9999999999999941E-2},null,null,null,null,"b1",null,null,{"$f":"(SUM(U44:U48)-15*V56)/(5)","v":2.7840999999999996}]
[null,null,"b2",null,null,{"$f":"(((E44+2*E45+3*E46+4*E47+5*E48)-5*3*F54)/(55-(5*3*3)))","v":-2.5770000000000097},null,null,null,null,"b2",null,null,{"$f":"(((M44+2*M45+3*M46+4*M47+5*M48)-5*3*N54)/(55-(5*3*3)))","v":7.0000000000000021E-2},null,null,null,null,"b2",null,null,{"$f":"(((U44+2*U45+3*U46+4*U47+5*U48)-5*3*V54)/(55-(5*3*3)))","v":-3.7499999999999999E-2}]
[]
[null,null,"Rovnice přímky",null,null,"η(𝒳)",{"$f":"F55","v":75.313000000000031},{"$f":"F56","v":-2.5770000000000097},"x",null,"Rovnice přímky",null,null,"η(𝒳)",{"$f":"N55","v":8.9999999999999941E-2},{"$f":"N56","v":7.0000000000000021E-2},"x",null,"Rovnice přímky",null,null,"η(𝒳)",{"$f":"V55","v":2.7840999999999996},{"$f":"V56","v":-3.7499999999999999E-2},"x"]