{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Tšekiregister"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Tšekiregister","index":0,"n_rows":13,"n_cols":8,"rows_kept":13}
[null,"Tšekiregister"]
[null,"LEGEND",{"$nulls":5},"HETKESALDO"]
[null,"DK = deebetkaart",null,"AM = automaatne makse ",{"$nulls":3},{"$f":"HETKESALDO","v":{"v":3311,"d":"3,311.00 €"}}]
[null,"ATM = väljamakse pangaautomaadist",null,"AT = veebiarve tasumine"]
[null,"AS = automaatne sissemakse ",null,"ÜK = ülekanne veebis või telefoni teel"]
[null,"TŠEKK/KOOD","KUUPÄEV","TEHING","KIRJELDUS","VÄLJAMAKSE","SISSEMAKSE","SALDO"]
[null,null,{"$f":"TODAY()-19","v":"2022-03-12"},"Metsasalu pank","Algsaldo",null,{"v":2000,"d":"2,000.00 €"},{"$f":"IFERROR(Tšekiregister[[#This Row],[SISSEMAKSE]], \"\")","v":{"v":2000,"d":"2,000.00 €"}}]
[null,1001,{"$f":"TODAY()-11","v":"2022-03-20"},"Kunstikool","Lilli kunstikursus – 6 nädalat",{"v":100,"d":"100.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(Tšekiregister[[#This Row],[VÄLJAMAKSE]]),H7+Tšekiregister[[#This Row],[SISSEMAKSE]],H7-Tšekiregister[[#This Row],[VÄLJAMAKSE]]), \"\")","v":{"v":1900,"d":"1,900.00 €"}}]
[null,"AS",{"$f":"TODAY()-11","v":"2022-03-20"},"Palk",null,null,{"v":1500,"d":"1,500.00 €"},{"$f":"IFERROR(IF(ISBLANK(Tšekiregister[[#This Row],[VÄLJAMAKSE]]),H8+Tšekiregister[[#This Row],[SISSEMAKSE]],H8-Tšekiregister[[#This Row],[VÄLJAMAKSE]]), \"\")","v":{"v":3400,"d":"3,400.00 €"}}]
[null,"DK",{"$f":"TODAY()-8","v":"2022-03-23"},"Videolaenutus","Filmilaenutus + 10 € tagatisraha",{"v":16,"d":"16.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(Tšekiregister[[#This Row],[VÄLJAMAKSE]]),H9+Tšekiregister[[#This Row],[SISSEMAKSE]],H9-Tšekiregister[[#This Row],[VÄLJAMAKSE]]), \"\")","v":{"v":3384,"d":"3,384.00 €"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2022-03-26"},null,"Raha väljas söömiseks",{"v":50,"d":"50.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(Tšekiregister[[#This Row],[VÄLJAMAKSE]]),H10+Tšekiregister[[#This Row],[SISSEMAKSE]],H10-Tšekiregister[[#This Row],[VÄLJAMAKSE]]), \"\")","v":{"v":3334,"d":"3,334.00 €"}}]
[null,"AT",{"$f":"TODAY()","v":"2022-03-31"},"Telefoniettevõte",null,{"v":23,"d":"23.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(Tšekiregister[[#This Row],[VÄLJAMAKSE]]),H11+Tšekiregister[[#This Row],[SISSEMAKSE]],H11-Tšekiregister[[#This Row],[VÄLJAMAKSE]]), \"\")","v":{"v":3311,"d":"3,311.00 €"}}]
[null,"Kogusummad",null,{"$f":"CONCATENATE(\"Tehingute arv: \",SUBTOTAL(103,Tšekiregister[TEHING]))","v":"Tehingute arv: 5"},null,{"$f":"SUBTOTAL(109,Tšekiregister[VÄLJAMAKSE])","v":{"v":189,"d":"189.00 €"}},{"$f":"SUBTOTAL(109,Tšekiregister[SISSEMAKSE])","v":{"v":3500,"d":"3,500.00 €"}},{"$f":"Tšekiregister[[#Totals],[SISSEMAKSE]]-Tšekiregister[[#Totals],[VÄLJAMAKSE]]","v":{"v":3311,"d":"3,311.00 €"}}]