{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Peněžní deník"],"not_rendered":{"charts":1,"images":2,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Peněžní deník","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"merged":[[3,1,11,2],[12,1,12,2]]}
[null,"Peněžní deník"]
[null,"Do této buňky zadejte číslo svého bankovního účtu."]
[null,{"$f":"CONCATENATE(\"Aktuální zůstatek : \"&TEXT(PeněžníDeník[[#Totals],[Zůstatek]],\"# ##0,00 Kč\"))","v":"Aktuální zůstatek : 2 730,84 Kč"}]
[]
[{"$nulls":4},"Č. transakce","Datum","Popis","Kategorie","Výběr","Vklad","Zůstatek"]
[{"$nulls":5},{"$f":"TODAY()-60","v":"2018-03-10"},"Počáteční zůstatek","Vklad",null,{"v":2916.73,"d":"2,916.73 Kč"},{"$f":"PočátečníZůstatek","v":{"v":2916.73,"d":"2,916.73 Kč"}}]
[{"$nulls":4},2251,{"$f":"TODAY()-59","v":"2018-03-11"},"Nákup potravin","Potraviny",{"v":205.61,"d":"205.61 Kč"},null,{"$f":"Zůstatek","v":{"v":2711.12,"d":"2,711.12 Kč"}}]
[{"$nulls":4},67112449,{"$f":"TODAY()-45","v":"2018-03-25"},"Hypotéka na dům","Hypotéka",{"v":961.77,"d":"961.77 Kč"},null,{"$f":"Zůstatek","v":{"v":1749.35,"d":"1,749.35 Kč"}}]
[{"$nulls":4},"Kreditní karta",{"$f":"TODAY()-40","v":"2018-03-30"},"Kavárna","Jiné",{"v":3.65,"d":"3.65 Kč"},null,{"$f":"Zůstatek","v":{"v":1745.6999999999998,"d":"1,745.70 Kč"}}]
[{"$nulls":4},2252,{"$f":"TODAY()-35","v":"2018-04-04"},"Plyn a elektřina","Služby",{"v":145.33,"d":"145.33 Kč"},null,{"$f":"Zůstatek","v":{"v":1600.37,"d":"1,600.37 Kč"}}]
[{"$nulls":4},"Bankomat",{"$f":"TODAY()-30","v":"2018-04-09"},"Výběr hotovosti","Jiné",{"v":50,"d":"50.00 Kč"},null,{"$f":"Zůstatek","v":{"v":1550.37,"d":"1,550.37 Kč"}}]
[{"$nulls":4},68240158,{"$f":"TODAY()-25","v":"2018-04-14"},"Platební karta","Platební karta",{"v":936.48,"d":"936.48 Kč"},null,{"$f":"Zůstatek","v":{"v":613.8899999999999,"d":"613.89 Kč"}}]
[null,"Souhrn",{"$nulls":3},{"$f":"TODAY()-20","v":"2018-04-19"},"Výplata","Vklad",null,{"v":2365.82,"d":"2,365.82 Kč"},{"$f":"Zůstatek","v":{"v":2979.71,"d":"2,979.71 Kč"}}]
[null,"Kategorie","Celkem",null,null,{"$f":"TODAY()-15","v":"2018-04-24"},"Investice do podílových fondů","Investice",{"v":200,"d":"200.00 Kč"},null,{"$f":"Zůstatek","v":{"v":2779.71,"d":"2,779.71 Kč"}}]
[null,"Vklad",{"$f":"KategorieCelkem","v":{"v":5282.55,"d":"5,282.55 Kč"}},null,2253,{"$f":"TODAY()","v":"2018-05-09"},"Telefon","Služby",{"v":48.87,"d":"48.87 Kč"},null,{"$f":"Zůstatek","v":{"v":2730.84,"d":"2,730.84 Kč"}}]
[null,"Platební karta",{"$f":"KategorieCelkem","v":{"v":936.48,"d":"936.48 Kč"}},null,"Celkem",{"$nulls":3},{"$f":"SUBTOTAL(109,PeněžníDeník[Výběr])","v":{"v":2551.71,"d":"2,551.71 Kč"}},{"$f":"SUBTOTAL(109,PeněžníDeník[Vklad])","v":{"v":5282.55,"d":"5,282.55 Kč"}},{"$f":"PeněžníDeník[[#Totals],[Vklad]]-PeněžníDeník[[#Totals],[Výběr]]","v":{"v":2730.84,"d":"2,730.84 Kč"}}]
[null,"Investice",{"$f":"KategorieCelkem","v":{"v":200,"d":"200.00 Kč"}}]
[null,"Potraviny",{"$f":"KategorieCelkem","v":{"v":205.61,"d":"205.61 Kč"}}]
[null,"Služby",{"$f":"KategorieCelkem","v":{"v":194.20000000000002,"d":"194.20 Kč"}}]
[null,"Pojištění",{"$f":"KategorieCelkem","v":{"v":0,"d":"0.00 Kč"}}]
[null,"Hypotéka",{"$f":"KategorieCelkem","v":{"v":961.77,"d":"961.77 Kč"}}]
[null,"Jiné",{"$f":"KategorieCelkem","v":{"v":53.65,"d":"53.65 Kč"}}]