{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Řídicí panel","Přehled výdajů","Údaje o osobních výdajích"],"not_rendered":{"charts":1,"images":1,"defined_names":5,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Řídicí panel","index":0,"n_rows":1,"n_cols":6,"rows_kept":1,"merged":[[0,2,0,4],[2,3,2,4]]}
[null,null,"Řídicí panel osobních výdajů",null,null,"na přehled výdajů >"]

{"sheet":"Přehled výdajů","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[0,1,0,3]]}
[null,"Přehled výdajů",{"$nulls":3},"< na řídicí panel"]
[null,"Datum","Kategorie","Podkategorie","Částka","Poznámka"]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2022-03-02"},"Bydlení","Internet",{"v":29,"d":"29.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2022-03-02"},"Bydlení","Pevná linka",{"v":39,"d":"39.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2022-03-04"},"Bydlení","Elektřina",{"v":62,"d":"62.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2022-03-04"},"Zábava","Posilovna",{"v":29,"d":"29.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2022-03-06"},"Každodenní","Oblečení",{"v":42,"d":"42.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2022-03-06"},"Doprava","Jízdenka MHD",{"v":21,"d":"21.00 Kč"},"Měsíční jízdenka na březen"]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2022-04-02"},"Doprava","Benzín",{"v":54,"d":"54.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2022-04-02"},"Každodenní","Kadeřník",{"v":12,"d":"12.00 Kč"}]
[null,"2022-04-02","Každodenní","Čaj/káva",{"v":12,"d":"12.00 Kč"}]
[null,"2022-04-02","Každodenní","Cukrovinky",{"v":2.75,"d":"2.75 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2022-04-04"},"Bydlení","Internet",{"v":29,"d":"29.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2022-04-04"},"Bydlení","Pevná linka",{"v":39,"d":"39.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2022-04-04"},"Bydlení","Elektřina",{"v":62,"d":"62.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2022-04-04"},"Každodenní","Kontaktní čočky",{"v":29,"d":"29.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2022-04-06"},"Každodenní","Oblečení",{"v":42,"d":"42.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2022-04-06"},"Doprava","Jízdenka MHD",{"v":21,"d":"21.00 Kč"},"Měsíční jízdenka na duben"]
[null,{"$f":"DATE(YEAR(TODAY()),5,1)","v":"2022-05-01"},"Doprava","Benzín",{"v":54,"d":"54.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2022-06-01"},"Každodenní","Kadeřník",{"v":12,"d":"12.00 Kč"}]
[null,{"$f":"DATE(YEAR(TODAY()),7,1)","v":"2022-07-01"},"Zábava","Kino",{"v":21,"d":"21.00 Kč"},"Klasický filmový večer"]
[null,{"$f":"DATE(YEAR(TODAY()),8,1)","v":"2022-08-01"},"Každodenní","Cukrovinky",{"v":2.75,"d":"2.75 Kč"}]

{"sheet":"Údaje o osobních výdajích","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"hidden":true,"merged":[[0,1,0,3],[1,1,1,3]]}
[null,"údaje o osobních výdajích"]
[null,"Níže uvedená tabulka představuje zdroj dat pro kontingenční graf Osobní výdaje v řídicím panelu. Veškeré změny, které provedete, můžou mít za následek vizuální změny kontingenčního grafu nebo chyby."]
[null,"Součet z Částka","Popisky sloupců"]
[null,"Popisky řádků","Zábava","Doprava","Každodenní","Bydlení","Celkový součet"]
[null,"III",29,21,42,130,222]
[null,"IV",null,75,97.75,130,302.75]
[null,"V",null,54,null,null,54]
[null,"VI",null,null,12,null,12]
[null,"VII",21,{"$nulls":3},21]
[null,"VIII",null,null,2.75,null,2.75]
[null,"Celkový součet",50,150,154.5,260,614.5]