{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Evidencia transakcií"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Evidencia transakcií","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"merged":[[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[null,"Evidencia transakcií"]
[null,"LEGENDA",{"$nulls":5},"AKTUÁLNY ZOSTATOK"]
[null,"DK = debetná karta",null,"AP = automatická platba ",{"$nulls":3},{"$f":"AKTUÁLNY_ZOSTATOK","v":{"v":3311,"d":"3,311.00 EUR"}}]
[null,"BANKOMAT = výber z bankomatu",null,"PF = online platba faktúry"]
[null,"AV = automatický vklad ",null,"PR = online prevod alebo prevod pomocou telefónu"]
[null,"ŠEK/KÓD","DÁTUM","TRANSAKCIA","POPIS","VÝBER","VKLAD","ZOSTATOK"]
[null,null,{"$f":"TODAY()-19","v":"2018-05-27"},"Banka","Počiatočný zostatok",null,{"v":2000,"d":"2,000.00 EUR"},{"$f":"IFERROR(EvidenciaTransakcií[[#This Row],[VKLAD]], \"\")","v":{"v":2000,"d":"2,000.00 EUR"}}]
[null,1001,{"$f":"TODAY()-11","v":"2018-06-04"},"Umelecká škola","Luciin umelecký kurz – 6 týždňov",{"v":100,"d":"100.00 EUR"},null,{"$f":"IFERROR(IF(ISBLANK(EvidenciaTransakcií[[#This Row],[VÝBER]]),H7+EvidenciaTransakcií[[#This Row],[VKLAD]],H7-EvidenciaTransakcií[[#This Row],[VÝBER]]), \"\")","v":{"v":1900,"d":"1,900.00 EUR"}}]
[null,"AV",{"$f":"TODAY()-11","v":"2018-06-04"},"Výplata",null,null,{"v":1500,"d":"1,500.00 EUR"},{"$f":"IFERROR(IF(ISBLANK(EvidenciaTransakcií[[#This Row],[VÝBER]]),H8+EvidenciaTransakcií[[#This Row],[VKLAD]],H8-EvidenciaTransakcií[[#This Row],[VÝBER]]), \"\")","v":{"v":3400,"d":"3,400.00 EUR"}}]
[null,"DK",{"$f":"TODAY()-8","v":"2018-06-07"},"Videopožičovňa","Prenájom filmu + 10 EUR vrátenie peňazí",{"v":16,"d":"16.00 EUR"},null,{"$f":"IFERROR(IF(ISBLANK(EvidenciaTransakcií[[#This Row],[VÝBER]]),H9+EvidenciaTransakcií[[#This Row],[VKLAD]],H9-EvidenciaTransakcií[[#This Row],[VÝBER]]), \"\")","v":{"v":3384,"d":"3,384.00 EUR"}}]
[null,"BANKOMAT",{"$f":"TODAY()-5","v":"2018-06-10"},null,"Hotovosť na večeru v reštaurácii",{"v":50,"d":"50.00 EUR"},null,{"$f":"IFERROR(IF(ISBLANK(EvidenciaTransakcií[[#This Row],[VÝBER]]),H10+EvidenciaTransakcií[[#This Row],[VKLAD]],H10-EvidenciaTransakcií[[#This Row],[VÝBER]]), \"\")","v":{"v":3334,"d":"3,334.00 EUR"}}]
[null,"PF",{"$f":"TODAY()","v":"2018-06-15"},"Telekomunikačná spoločnosť",null,{"v":23,"d":"23.00 EUR"},null,{"$f":"IFERROR(IF(ISBLANK(EvidenciaTransakcií[[#This Row],[VÝBER]]),H11+EvidenciaTransakcií[[#This Row],[VKLAD]],H11-EvidenciaTransakcií[[#This Row],[VÝBER]]), \"\")","v":{"v":3311,"d":"3,311.00 EUR"}}]
[null,"Spolu",null,{"$f":"CONCATENATE(\"Počet transakcií: \",SUBTOTAL(103,EvidenciaTransakcií[TRANSAKCIA]))","v":"Počet transakcií: 5"},null,{"$f":"SUBTOTAL(109,EvidenciaTransakcií[VÝBER])","v":{"v":189,"d":"189.00 EUR"}},{"$f":"SUBTOTAL(109,EvidenciaTransakcií[VKLAD])","v":{"v":3500,"d":"3,500.00 EUR"}},{"$f":"EvidenciaTransakcií[[#Totals],[VKLAD]]-EvidenciaTransakcií[[#Totals],[VÝBER]]","v":{"v":3311,"d":"3,311.00 EUR"}}]