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

{"sheet":"Registr šeků","index":0,"n_rows":13,"n_cols":8,"rows_kept":13}
[null,"Registr šeků"]
[null,"LEGENDA",{"$nulls":5},"AKTUÁLNÍ ZŮSTATEK"]
[null,"DK = Debetní Karta",null,"AP = Automatická Platba ",{"$nulls":3},{"$f":"AKTUÁLNÍ_ZŮSTATEK","v":{"v":3311,"d":"3,311.00 Kč"}}]
[null,"ATM = Bankomat",null,"OPF = Online Platba za Fakturu"]
[null,"AV = Automatický Vklad ",null,"PŘE = Online nebo Telefonický Převod"]
[null,"ŠEK / KÓD","DATUM","TRANSAKCE","POPIS","VÝBĚR","VKLAD","ZŮSTATEK"]
[null,null,{"$f":"TODAY()-19","v":"2022-03-18"},"Banka","Počáteční zůstatek",null,{"v":2000,"d":"2,000.00 Kč"},{"$f":"IFERROR(RegistrŠeků[[#This Row],[VKLAD]], \"\")","v":{"v":2000,"d":"2,000.00 Kč"}}]
[null,1001,{"$f":"TODAY()-11","v":"2022-03-26"},"Umělecká škola","Lenčin kurz dějin umění – 6 týdnů",{"v":100,"d":"100.00 Kč"},null,{"$f":"IFERROR(IF(ISBLANK(RegistrŠeků[[#This Row],[VÝBĚR]]),H7+RegistrŠeků[[#This Row],[VKLAD]],H7-RegistrŠeků[[#This Row],[VÝBĚR]]), \"\")","v":{"v":1900,"d":"1,900.00 Kč"}}]
[null,"AV",{"$f":"TODAY()-11","v":"2022-03-26"},"Výplata",null,null,{"v":1500,"d":"1,500.00 Kč"},{"$f":"IFERROR(IF(ISBLANK(RegistrŠeků[[#This Row],[VÝBĚR]]),H8+RegistrŠeků[[#This Row],[VKLAD]],H8-RegistrŠeků[[#This Row],[VÝBĚR]]), \"\")","v":{"v":3400,"d":"3,400.00 Kč"}}]
[null,"DK",{"$f":"TODAY()-8","v":"2022-03-29"},"Videopůjčovna","Půjčení videa + 10 Kč cashback",{"v":16,"d":"16.00 Kč"},null,{"$f":"IFERROR(IF(ISBLANK(RegistrŠeků[[#This Row],[VÝBĚR]]),H9+RegistrŠeků[[#This Row],[VKLAD]],H9-RegistrŠeků[[#This Row],[VÝBĚR]]), \"\")","v":{"v":3384,"d":"3,384.00 Kč"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2022-04-01"},null,"Výběr hotovosti na občerstvení",{"v":50,"d":"50.00 Kč"},null,{"$f":"IFERROR(IF(ISBLANK(RegistrŠeků[[#This Row],[VÝBĚR]]),H10+RegistrŠeků[[#This Row],[VKLAD]],H10-RegistrŠeků[[#This Row],[VÝBĚR]]), \"\")","v":{"v":3334,"d":"3,334.00 Kč"}}]
[null,"OPF",{"$f":"TODAY()","v":"2022-04-06"},"Telefonní společnost",null,{"v":23,"d":"23.00 Kč"},null,{"$f":"IFERROR(IF(ISBLANK(RegistrŠeků[[#This Row],[VÝBĚR]]),H11+RegistrŠeků[[#This Row],[VKLAD]],H11-RegistrŠeků[[#This Row],[VÝBĚR]]), \"\")","v":{"v":3311,"d":"3,311.00 Kč"}}]
[null,"Součty",null,{"$f":"CONCATENATE(\"Počet transakcí: \",SUBTOTAL(103,RegistrŠeků[TRANSAKCE]))","v":"Počet transakcí: 5"},null,{"$f":"SUBTOTAL(109,RegistrŠeků[VÝBĚR])","v":{"v":189,"d":"189.00 Kč"}},{"$f":"SUBTOTAL(109,RegistrŠeků[VKLAD])","v":{"v":3500,"d":"3,500.00 Kč"}},{"$f":"RegistrŠeků[[#Totals],[VKLAD]]-RegistrŠeků[[#Totals],[VÝBĚR]]","v":{"v":3311,"d":"3,311.00 Kč"}}]