{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Přehled","Aktiva","Pasiva","výpočty"],"not_rendered":{"charts":4,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Přehled","index":0,"n_rows":16,"n_cols":8,"rows_kept":16}
[]
[null,"PŘEHLED",{"$nulls":4},"PŘEHLED ČISTÉHO JMĚNÍ"," "]
{"$rows_empty":8}
[null,{"$f":"ČistéJmění","v":{"v":1596000,"d":"1,596,000 Kč"}},null,{"$f":"AktivaCelkem","v":{"v":3808000,"d":"3,808,000 Kč"}},null,null,{"$f":"PasivaCelkem","v":{"v":2212000,"d":"2,212,000 Kč"}}]
[null,"ČISTÉ JMĚNÍ",null,"AKTIVA CELKEM",null,null,"PASIVA CELKEM"]
[{"$nulls":3},"HOTOVOST",null,null,"NEZAJIŠTĚNÁ"]
[{"$nulls":3},"INVESTICE",null,null,"ZAJIŠTĚNÁ"]
[{"$nulls":3},"PENZE"]
[{"$nulls":3},"OSOBNÍ"]

{"sheet":"Aktiva","index":1,"n_rows":24,"n_cols":10,"rows_kept":24,"merged":[[11,1,12,1],[13,1,14,1],[14,2,14,4],[14,6,14,8],[25,2,25,4],[25,6,25,8]]}
[]
[null,"AKTIVA",{"$nulls":5},"PŘEHLED ČISTÉHO JMĚNÍ",null," "]
[]
[null,null," ","HOTOVOST","HODNOTA",null," ","OSOBNÍ","HODNOTA"]
[{"$nulls":3},"POKLADNÍ HOTOVOST",{"v":20000,"d":"20,000"},null,null,"HLAVNÍ BYDLIŠTĚ",{"v":2330000,"d":"2,330,000"}]
[{"$nulls":3},"KONTOKORENT",{"v":25000,"d":"25,000"},null,null,"DRUHÉ BYDLIŠTĚ"]
[{"$nulls":3},"SPOŘICÍ ÚČTY",{"v":40000,"d":"40,000"},null,null,"SBÍRKY"]
[{"$nulls":3},"ÚČTY PENĚŽNÍHO TRHU",{"v":33000,"d":"33,000"},null,null,"AUTOMOBILY",{"v":320000,"d":"320,000"}]
[{"$nulls":3},"ÚČTY FONDŮ PENĚŽNÍHO TRHU",{"v":70000,"d":"70,000"},null,null,"BYTOVÉ VYBAVENÍ",{"v":100000,"d":"100,000"}]
[{"$nulls":3},"VKLADOVÉ CERTIFIKÁTY",{"$nulls":3},"KOŽEŠINY A ŠPERKY"]
[{"$nulls":3},"STÁTNÍ DLUHOPISY",{"$nulls":3},"JINÝ MAJETEK",{"v":15000,"d":"15,000"}]
[null,{"$f":"AktivaCelkem","v":{"v":3808000,"d":"3,808,000 Kč"}},null,"ODKUPNÍ HODNOTA ŽIVOTNÍHO POJIŠTĚNÍ",{"v":245000,"d":"245,000"}]
[{"$nulls":3},"MEZISOUČET",{"$f":"SUBTOTAL(109,tblHotovost[HODNOTA])","v":{"v":433000,"d":"433,000"}},null,null,"MEZISOUČET",{"$f":"SUBTOTAL(109,tblOsobní[HODNOTA])","v":{"v":2765000,"d":"2,765,000"}}]
[null,"PASIVA CELKEM"]
[]
[]
[null,null," ","INVESTICE","HODNOTA",null," ","PENZE","HODNOTA"]
[{"$nulls":3},"AKCIE",{"v":150000,"d":"150,000"},null,null,"DŮCHOD"]
[{"$nulls":3},"OBLIGACE",{"$nulls":3},"INDIVIDUÁLNÍ DŮCHODOVÉ ÚČTY"]
[{"$nulls":3},"INVESTICE DO PODÍLOVÝCH FONDŮ",{"$nulls":3},"PENZIJNÍ SPOŘENÍ OSVČ"]
[{"$nulls":3},"ZISKY Z PODÍLNICTVÍ",{"$nulls":3},"PENZIJNÍ PŘIPOJIŠTĚNÍ",{"v":460000,"d":"460,000"}]
[{"$nulls":3},"JINÉ INVESTICE",{"$nulls":3},"ZJEDNODUŠENÁ ZAMĚSTNANECKÁ PENZE"]
[{"$nulls":7},"ZAMĚSTNANECKÉ AKCIE"]
[{"$nulls":3},"MEZISOUČET",{"$f":"SUBTOTAL(109,tblInvestice[HODNOTA])","v":{"v":150000,"d":"150,000"}},null,null,"MEZISOUČET",{"$f":"SUBTOTAL(109,tblPenze[HODNOTA])","v":{"v":460000,"d":"460,000"}}]

{"sheet":"Pasiva","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"PASIVA",{"$nulls":5},"PŘEHLED ČISTÉHO JMĚNÍ",null," "]
[]
[null,null," ","NEZAJIŠTĚNÁ","DLUH",null," ","ZAJIŠTĚNÁ","DLUH"]
[{"$nulls":3},"KREDITNÍ KARTY",{"v":12000,"d":"12,000"},null,null,"Půjčky auto",{"v":145000,"d":"145,000"}]
[{"$nulls":3},"ÚVĚROVÉ ÚČTY",{"v":30000,"d":"30,000"},null,null,"Půjčky karavan"]
[{"$nulls":3},"STUDENTSKÉ PŮJČKY",{"v":175000,"d":"175,000"},null,null,"Půjčky vybavení"]
[{"$nulls":3},"VÝŽIVNÉ PARTNER",{"$nulls":3},"Hypotéky dům",{"v":1440000,"d":"1,440,000"}]
[{"$nulls":3},"VÝŽIVNÉ DĚTI",{"$nulls":3},"Půjčky ručené nemovitostí",{"v":210000,"d":"210,000"}]
[{"$nulls":3},"DAŇOVÁ POVINNOST",{"v":80000,"d":"80,000"},null,null,"Ostatní půjčky"]
[{"$nulls":3},"JINÉ",{"v":60000,"d":"60,000"},null,null,"Daňová povinnost",{"v":40000,"d":"40,000"}]
[null,{"$f":"PasivaCelkem","v":{"v":2212000,"d":"2,212,000 Kč"}},{"$nulls":5},"Ostatní",{"v":20000,"d":"20,000"}]
[{"$nulls":3},"MEZISOUČET",{"$f":"SUBTOTAL(109,tblNezajištěné[DLUH])","v":{"v":357000,"d":"357,000"}},null,null,"MEZISOUČET",{"$f":"SUBTOTAL(109,tblZajištěné[DLUH])","v":{"v":1855000,"d":"1,855,000"}}]
[null,"AKTIVA CELKEM"]

{"sheet":"výpočty","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"hidden":true}
[]
[null,"*** Tento list by měl zůstat skrytý ***"]
{"$rows_empty":8}
[null,{"$f":"tblHotovost[[#Headers],[HOTOVOST]]","v":"HOTOVOST"},{"$f":"SUM(tblHotovost[HODNOTA])","v":{"v":433000,"d":"433,000 Kč"}}]
[null,{"$f":"tblInvestice[[#Headers],[INVESTICE]]","v":"INVESTICE"},{"$f":"SUM(tblInvestice[HODNOTA])","v":{"v":150000,"d":"150,000 Kč"}}]
[null,{"$f":"tblPenze[[#Headers],[PENZE]]","v":"PENZE"},{"$f":"SUM(tblPenze[HODNOTA])","v":{"v":460000,"d":"460,000 Kč"}}]
[null,{"$f":"tblOsobní[[#Headers],[OSOBNÍ]]","v":"OSOBNÍ"},{"$f":"SUM(tblOsobní[HODNOTA])","v":{"v":2765000,"d":"2,765,000 Kč"}}]
[null,"Aktiva celkem",{"$f":"SUM(tblHotovost[HODNOTA],tblInvestice[HODNOTA],tblPenze[HODNOTA],tblOsobní[HODNOTA])","v":{"v":3808000,"d":"3,808,000 Kč"}}]
[]
[]
[null,{"$f":"tblNezajištěné[[#Headers],[NEZAJIŠTĚNÁ]]","v":"NEZAJIŠTĚNÁ"},{"$f":"SUM(tblNezajištěné[DLUH])","v":{"v":357000,"d":"357,000 Kč"}}]
[null,{"$f":"tblZajištěné[[#Headers],[ZAJIŠTĚNÁ]]","v":"ZAJIŠTĚNÁ"},{"$f":"SUM(tblZajištěné[DLUH])","v":{"v":1855000,"d":"1,855,000 Kč"}}]
[null,"Pasiva celkem",{"$f":"SUM(tblNezajištěné[DLUH],tblZajištěné[DLUH])","v":{"v":2212000,"d":"2,212,000 Kč"}}]
[]
[]
[null,"Přehled čistého jmění",{"$f":"C15-C20","v":{"v":1596000,"d":"1,596,000 Kč"}}]