{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Vklady","Výběry"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Vklady","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,3,2]]}
[null,"měsíční\nbankovní\nvýpis",null,"MĚSÍC","PŘEDCHOZÍ ZŮSTATEK","VKLADY CELKEM"]
[{"$nulls":3},{"$f":"UPPER(TEXT(TODAY(),\"mmmm\"))","v":"KVĚTEN"},{"v":2525.54,"d":"2,525.54 Kč"},{"$f":"Vklady_celkem","v":{"v":5400,"d":"5,400.00 Kč"}}]
[{"$nulls":3},"ROK","KONEČNÝ ZŮSTATEK","VÝBĚRY CELKEM"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2018},{"$f":"IFERROR(KonečnýZůstatek+Vklady_celkem-Výběry_celkem, \"\")","v":{"v":6550.54,"d":"6,550.54 Kč"}},{"$f":"Výběry_celkem","v":{"v":1375,"d":"1,375.00 Kč"}}]
[null,"vklady"]
[null,"č. vkladu","datum","částka","popis","odsouhlaseno"]
[null,{"$f":"ROW()-ROW(Vklady[[#Headers],[č. vkladu]])","v":1},{"$f":"TODAY()-15","v":"2018-05-01"},{"v":1500,"d":"1,500.00 Kč"},"zaměstnání 1, výplata 1","ano"]
[null,{"$f":"ROW()-ROW(Vklady[[#Headers],[č. vkladu]])","v":2},{"$f":"TODAY()-10","v":"2018-05-06"},{"v":1200,"d":"1,200.00 Kč"},"zaměstnání 2, výplata 1","ano"]
[null,{"$f":"ROW()-ROW(Vklady[[#Headers],[č. vkladu]])","v":3},{"$f":"TODAY()-5","v":"2018-05-11"},{"v":1500,"d":"1,500.00 Kč"},"zaměstnání 1, výplata 2","ano"]
[null,{"$f":"ROW()-ROW(Vklady[[#Headers],[č. vkladu]])","v":4},{"$f":"TODAY()","v":"2018-05-16"},{"v":1200,"d":"1,200.00 Kč"},"zaměstnání 2, výplata 2","ano"]
[null,"CELKEM",null,{"$f":"SUBTOTAL(109,Vklady[částka])","v":{"v":5400,"d":"5,400.00 Kč"}}]

{"sheet":"Výběry","index":1,"n_rows":8,"n_cols":6,"rows_kept":8}
[null,"výběry"]
[null,"typ","datum","částka","účel","odsouhlaseno"]
[null,"složenka 1001",{"$f":"TODAY()-8","v":"2018-05-08"},{"v":150,"d":"150.00 Kč"},"elektřina","ano"]
[null,"složenka 1002",{"$f":"TODAY()-6","v":"2018-05-10"},{"v":150,"d":"150.00 Kč"},"vodné/stočné/odpady","ano"]
[null,"složenka 1003",{"$f":"TODAY()-4","v":"2018-05-12"},{"v":850,"d":"850.00 Kč"},"hypotéka","ano"]
[null,"platba",{"$f":"TODAY()-2","v":"2018-05-14"},{"v":125,"d":"125.00 Kč"},"potraviny","ano"]
[null,"bankomat",{"$f":"TODAY()","v":"2018-05-16"},{"v":100,"d":"100.00 Kč"},"hotovost","ano"]
[null,"CELKEM",null,{"$f":"SUBTOTAL(109,Složenky[částka])","v":{"v":1375,"d":"1,375.00 Kč"}}]