{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Pohyby na kreditnej karte"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Pohyby na kreditnej karte","index":0,"n_rows":10,"n_cols":7,"rows_kept":10}
[null,"Názov kreditnej karty"]
[null,"Do tabuľky nižšie zadajte platby ako záporné čísla."]
[null,"Dátum","Popis","Suma","Meno obchodníka","Poplatky za transakciu","Zostatok\n(nezahŕňa úrok)"]
[null,{"$f":"TODAY()-5","v":"2018-06-24"},"Aktuálny zostatok",{"v":45,"d":"45.00 EUR"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(Údaje[[#Headers],[Zostatok\n(nezahŕňa úrok)]])=1,Údaje[[#This Row],[Poplatky za transakciu]]+Údaje[[#This Row],[Suma]],SUM(INDEX(Údaje[Suma],1,1):Údaje[[#This Row],[Suma]],INDEX(Údaje[Poplatky za transakciu],1,1):Údaje[[#This Row],[Poplatky za transakciu]])), \"\")","v":{"v":45,"d":"45.00 EUR"}}]
[null,{"$f":"TODAY()-4","v":"2018-06-25"},"Platba za jún",{"v":-34,"d":"-34.00 EUR"},"Woodgrove Bank",{"v":2,"d":"2.00 EUR"},{"$f":"IFERROR(IF(ROW()-ROW(Údaje[[#Headers],[Zostatok\n(nezahŕňa úrok)]])=1,Údaje[[#This Row],[Poplatky za transakciu]]+Údaje[[#This Row],[Suma]],SUM(INDEX(Údaje[Suma],1,1):Údaje[[#This Row],[Suma]],INDEX(Údaje[Poplatky za transakciu],1,1):Údaje[[#This Row],[Poplatky za transakciu]])), \"\")","v":{"v":13,"d":"13.00 EUR"}}]
[null,{"$f":"TODAY()-3","v":"2018-06-26"},"Rám obrázka",{"v":45,"d":"45.00 EUR"},"Northwind Traders",null,{"$f":"IFERROR(IF(ROW()-ROW(Údaje[[#Headers],[Zostatok\n(nezahŕňa úrok)]])=1,Údaje[[#This Row],[Poplatky za transakciu]]+Údaje[[#This Row],[Suma]],SUM(INDEX(Údaje[Suma],1,1):Údaje[[#This Row],[Suma]],INDEX(Údaje[Poplatky za transakciu],1,1):Údaje[[#This Row],[Poplatky za transakciu]])), \"\")","v":{"v":58,"d":"58.00 EUR"}}]
[null,{"$f":"TODAY()-2","v":"2018-06-27"},"Víno",{"v":600,"d":"600.00 EUR"},"Coho Winery",{"v":20,"d":"20.00 EUR"},{"$f":"IFERROR(IF(ROW()-ROW(Údaje[[#Headers],[Zostatok\n(nezahŕňa úrok)]])=1,Údaje[[#This Row],[Poplatky za transakciu]]+Údaje[[#This Row],[Suma]],SUM(INDEX(Údaje[Suma],1,1):Údaje[[#This Row],[Suma]],INDEX(Údaje[Poplatky za transakciu],1,1):Údaje[[#This Row],[Poplatky za transakciu]])), \"\")","v":{"v":678,"d":"678.00 EUR"}}]
[null,{"$f":"TODAY()-1","v":"2018-06-28"},"Letenka na Maui",{"v":469,"d":"469.00 EUR"},"Blue Yonder Airlines",null,{"$f":"IFERROR(IF(ROW()-ROW(Údaje[[#Headers],[Zostatok\n(nezahŕňa úrok)]])=1,Údaje[[#This Row],[Poplatky za transakciu]]+Údaje[[#This Row],[Suma]],SUM(INDEX(Údaje[Suma],1,1):Údaje[[#This Row],[Suma]],INDEX(Údaje[Poplatky za transakciu],1,1):Údaje[[#This Row],[Poplatky za transakciu]])), \"\")","v":{"v":1147,"d":"1,147.00 EUR"}}]
[null,{"$f":"TODAY()","v":"2018-06-29"},"Výber finančných prostriedkov",{"v":654,"d":"654.00 EUR"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(Údaje[[#Headers],[Zostatok\n(nezahŕňa úrok)]])=1,Údaje[[#This Row],[Poplatky za transakciu]]+Údaje[[#This Row],[Suma]],SUM(INDEX(Údaje[Suma],1,1):Údaje[[#This Row],[Suma]],INDEX(Údaje[Poplatky za transakciu],1,1):Údaje[[#This Row],[Poplatky za transakciu]])), \"\")","v":{"v":1801,"d":"1,801.00 EUR"}}]
[null,"Celková hodnota",null,{"$f":"SUBTOTAL(109,Údaje[Suma])","v":{"v":1779,"d":"1,779.00 EUR"}},null,{"$f":"SUBTOTAL(109,Údaje[Poplatky za transakciu])","v":{"v":22,"d":"22.00 EUR"}}]