{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Souhrn","Majetek","Závazky a vlastní kapitál"],"not_rendered":{"charts":2,"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Souhrn","index":0,"n_rows":7,"n_cols":5,"rows_kept":7}
[{"$nulls":4}," "]
[null,null,{"$f":"\"Rok \" & YEAR(TODAY())-1","v":"Rok 2018"},{"$f":"\"Rok \" & YEAR(TODAY())","v":"Rok 2019"}]
[]
[null,"Souhrn rozvahy","Rok 1","Rok 2"]
[null,"Aktiva celkem",{"$f":"Tabulka_KrátkodobýMajetek[[#Totals],[Rok 1]]+Tabulka_DlouhodobýMajetek[[#Totals],[Rok 1]]+Tabulka_DalšíMajetek[[#Totals],[Rok 1]]","v":{"v":9545,"d":"9,545.00 Kč"}},{"$f":"Tabulka_KrátkodobýMajetek[[#Totals],[Rok 2]]+Tabulka_DlouhodobýMajetek[[#Totals],[Rok 2]]+Tabulka_DalšíMajetek[[#Totals],[Rok 2]]","v":{"v":12735,"d":"12,735.00 Kč"}}]
[null,"Závazky a vlastní kapitál celkem",{"$f":"Tabulka_AktuálníZávazky[[#Totals],[Rok 1]]+Tabulka_DlouhodobéZávazky[[#Totals],[Rok 1]]+Tabulka_VlastníKapitál[[#Totals],[Rok 1]]","v":{"v":8540,"d":"8,540.00 Kč"}},{"$f":"Tabulka_AktuálníZávazky[[#Totals],[Rok 2]]+Tabulka_DlouhodobéZávazky[[#Totals],[Rok 2]]+Tabulka_VlastníKapitál[[#Totals],[Rok 2]]","v":{"v":6227,"d":"6,227.00 Kč"}}]
[null,"Rozvaha",{"$f":"C5-C6","v":{"v":1005,"d":"1,005.00 Kč"}},{"$f":"D5-D6","v":{"v":6508,"d":"6,508.00 Kč"}}]

{"sheet":"Majetek","index":1,"n_rows":21,"n_cols":5,"rows_kept":21}
[{"$nulls":4}," "]
[null,null,{"$f":"Předcházející_rok","v":"Rok 2018"},{"$f":"Aktuální_rok","v":"Rok 2019"}]
[null,"Krátkodobý majetek","Rok 1","Rok 2"]
[null,"Hotovost",{"v":1000,"d":"1,000.00 Kč"},{"v":1700,"d":"1,700.00 Kč"}]
[null,"Investice",{"v":1500,"d":"1,500.00 Kč"},{"v":2550,"d":"2,550.00 Kč"}]
[null,"Zásoby",{"v":650,"d":"650.00 Kč"},{"v":1250,"d":"1,250.00 Kč"}]
[null,"Pohledávky",{"v":150,"d":"150.00 Kč"},{"v":230,"d":"230.00 Kč"}]
[null,"Náklady příštích období",{"v":1230,"d":"1,230.00 Kč"},{"v":950,"d":"950.00 Kč"}]
[null,"Ostatní",{"v":120,"d":"120.00 Kč"},{"v":120,"d":"120.00 Kč"}]
[null,"Krátkodobý majetek celkem",{"$f":"SUBTOTAL(109,Tabulka_KrátkodobýMajetek[Rok 1])","v":{"v":4650,"d":"4,650.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka_KrátkodobýMajetek[Rok 2])","v":{"v":6800,"d":"6,800.00 Kč"}}]
[]
[null,"Dlouhodobý majetek","Rok 1","Rok 2"]
[null,"Nemovitosti a vybavení",{"v":2500,"d":"2,500.00 Kč"},{"v":2500,"d":"2,500.00 Kč"}]
[null,"Zdokonalení předmětu nájmu",{"v":450,"d":"450.00 Kč"},{"v":350,"d":"350.00 Kč"}]
[null,"Vlastní kapitál a další investice",{"v":1250,"d":"1,250.00 Kč"},{"v":1600,"d":"1,600.00 Kč"}]
[null,"Minus celkové odpisy",{"v":545,"d":"545.00 Kč"},{"v":1295,"d":"1,295.00 Kč"}]
[null,"Dlouhodobý majetek celkem",{"$f":"SUBTOTAL(109,Tabulka_DlouhodobýMajetek[Rok 1])","v":{"v":4745,"d":"4,745.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka_DlouhodobýMajetek[Rok 2])","v":{"v":5745,"d":"5,745.00 Kč"}}]
[]
[null,"Další majetek","Rok 1","Rok 2"]
[null,"Goodwill",{"v":150,"d":"150.00 Kč"},{"v":190,"d":"190.00 Kč"}]
[null,"Další majetek celkem",{"$f":"SUBTOTAL(109,Tabulka_DalšíMajetek[Rok 1])","v":{"v":150,"d":"150.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka_DalšíMajetek[Rok 2])","v":{"v":190,"d":"190.00 Kč"}}]

{"sheet":"Závazky a vlastní kapitál","index":2,"n_rows":19,"n_cols":5,"rows_kept":19}
[{"$nulls":4}," "]
[null,null,{"$f":"Předcházející_rok","v":"Rok 2018"},{"$f":"Aktuální_rok","v":"Rok 2019"}]
[null,"Krátkodobé závazky","Rok 1","Rok 2"]
[null,"Závazky",{"v":180,"d":"180.00 Kč"},{"v":252,"d":"252.00 Kč"}]
[null,"Časově rozlišené mzdy",{"v":250,"d":"250.00 Kč"},{"v":370,"d":"370.00 Kč"}]
[null,"Časově rozlišené odměny",{"v":240,"d":"240.00 Kč"},{"v":190,"d":"190.00 Kč"}]
[null,"Splatná daň z příjmu",{"v":120,"d":"120.00 Kč"},{"v":130,"d":"130.00 Kč"}]
[null,"Nezasloužené výnosy",{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"}]
[null,"Ostatní",{"v":250,"d":"250.00 Kč"},{"v":235,"d":"235.00 Kč"}]
[null,"Krátkodobé závazky celkem",{"$f":"SUBTOTAL(109,Tabulka_AktuálníZávazky[Rok 1])","v":{"v":1040,"d":"1,040.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka_AktuálníZávazky[Rok 2])","v":{"v":1177,"d":"1,177.00 Kč"}}]
[]
[null,"Dlouhodobé závazky","Rok 1","Rok 2"]
[null,"Splatná hypotéka",{"v":1500,"d":"1,500.00 Kč"},{"v":1900,"d":"1,900.00 Kč"}]
[null,"Dlouhodobé závazky celkem",{"$f":"SUBTOTAL(109,Tabulka_DlouhodobéZávazky[Rok 1])","v":{"v":1500,"d":"1,500.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka_DlouhodobéZávazky[Rok 2])","v":{"v":1900,"d":"1,900.00 Kč"}}]
[]
[null,"Vlastní kapitál","Rok 1","Rok 2"]
[null,"Investiční kapitál",{"v":5500,"d":"5,500.00 Kč"},{"v":2500,"d":"2,500.00 Kč"}]
[null,"Kumulovaný nerozdělený zisk",{"v":500,"d":"500.00 Kč"},{"v":650,"d":"650.00 Kč"}]
[null,"Vlastní kapitál celkem",{"$f":"SUBTOTAL(109,Tabulka_VlastníKapitál[Rok 1])","v":{"v":6000,"d":"6,000.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka_VlastníKapitál[Rok 2])","v":{"v":3150,"d":"3,150.00 Kč"}}]