{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sissemaksed","Väljamaksed"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Sissemaksed","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,3,2]]}
[null,"kuupõhine\npangakonto\nväljavõte",null,"KUU","EELMINE SALDO","SISSEMAKSED KOKKU"]
[{"$nulls":3},{"$f":"UPPER(TEXT(TODAY(),\"mmmm\"))","v":"MAY"},{"v":2525.54,"d":"2,525.54 €"},{"$f":"Sissemakse_kokku","v":{"v":5400,"d":"5,400.00 €"}}]
[{"$nulls":3},"AASTA","LÕPPSALDO","VÄLJAMAKSED KOKKU"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2018},{"$f":"IFERROR(Lõppsaldo+Sissemakse_kokku-Väljamaksed_kokku, \"\")","v":{"v":6550.54,"d":"6,550.54 €"}},{"$f":"Väljamaksed_kokku","v":{"v":1375,"d":"1,375.00 €"}}]
[null,"sissemaksed"]
[null,"sissemakse nr","kuupäev","summa","kirjeldus","vastavusse viidud"]
[null,{"$f":"ROW()-ROW(Sissemaksed[[#Headers],[sissemakse nr]])","v":1},{"$f":"TODAY()-15","v":"2018-05-02"},{"v":1500,"d":"1,500.00 €"},"töö 1, tšekk 1","jah"]
[null,{"$f":"ROW()-ROW(Sissemaksed[[#Headers],[sissemakse nr]])","v":2},{"$f":"TODAY()-10","v":"2018-05-07"},{"v":1200,"d":"1,200.00 €"},"töö 2, tšekk 1","jah"]
[null,{"$f":"ROW()-ROW(Sissemaksed[[#Headers],[sissemakse nr]])","v":3},{"$f":"TODAY()-5","v":"2018-05-12"},{"v":1500,"d":"1,500.00 €"},"töö 1, tšekk 2","jah"]
[null,{"$f":"ROW()-ROW(Sissemaksed[[#Headers],[sissemakse nr]])","v":4},{"$f":"TODAY()","v":"2018-05-17"},{"v":1200,"d":"1,200.00 €"},"töö 2, tšekk 2","jah"]
[null,"KOKKU",null,{"$f":"SUBTOTAL(109,Sissemaksed[summa])","v":{"v":5400,"d":"5,400.00 €"}}]

{"sheet":"Väljamaksed","index":1,"n_rows":8,"n_cols":6,"rows_kept":8}
[null,"väljamaksed"]
[null,"liik","kuupäev","summa","põhjus","vastavusse viidud"]
[null,"tšekk 1001",{"$f":"TODAY()-8","v":"2018-05-09"},{"v":150,"d":"150.00 €"},"elekter","jah"]
[null,"tšekk 1002",{"$f":"TODAY()-6","v":"2018-05-11"},{"v":150,"d":"150.00 €"},"vesi/kanalisatsioon/prügi","jah"]
[null,"tšekk 1003",{"$f":"TODAY()-4","v":"2018-05-13"},{"v":850,"d":"850.00 €"},"eluasemelaen","jah"]
[null,"deebetkaart",{"$f":"TODAY()-2","v":"2018-05-15"},{"v":125,"d":"125.00 €"},"toidukaubad","jah"]
[null,"pangaautomaat",{"$f":"TODAY()","v":"2018-05-17"},{"v":100,"d":"100.00 €"},"sularaha","jah"]
[null,"KOKKU",null,{"$f":"SUBTOTAL(109,Tšekid[summa])","v":{"v":1375,"d":"1,375.00 €"}}]