{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Evidenčna knjižica"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Evidenčna knjižica","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,"Evidenčna knjižica"]
[null,"LEGENDA",{"$nulls":5},"TRENUTNA BILANCA"]
[null,"DK = debetna kartica",null,"SPLA = samodejno plačilo ",{"$nulls":3},{"$f":"TRENUTNA_BILANCA","v":{"v":3311,"d":"3,311.00 €"}}]
[null,"BAN = dvig z bančnega avtomata",null,"SR = plačilo spletnega računa"]
[null,"SPOL = samodejni polog ",null,"SP = spletni ali telefonski prenos"]
[null,"ČEK/KODA","DATUM","TRANSAKCIJA","OPIS","DVIG","POLOG","BILANCA"]
[null,null,{"$f":"TODAY()-19","v":"2018-05-27"},"Vzorčna banka","Začetna bilanca",null,{"v":2000,"d":"2,000.00 €"},{"$f":"IFERROR(Evidenčna_knjižica[[#This Row],[POLOG]], \"\")","v":{"v":2000,"d":"2,000.00 €"}}]
[null,1001,{"$f":"TODAY()-11","v":"2018-06-04"},"Umetniška šola","Tinin tečaj risanja – 6 tednov",{"v":100,"d":"100.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(Evidenčna_knjižica[[#This Row],[DVIG]]),H7+Evidenčna_knjižica[[#This Row],[POLOG]],H7-Evidenčna_knjižica[[#This Row],[DVIG]]), \"\")","v":{"v":1900,"d":"1,900.00 €"}}]
[null,"AD",{"$f":"TODAY()-11","v":"2018-06-04"},"Plača",null,null,{"v":1500,"d":"1,500.00 €"},{"$f":"IFERROR(IF(ISBLANK(Evidenčna_knjižica[[#This Row],[DVIG]]),H8+Evidenčna_knjižica[[#This Row],[POLOG]],H8-Evidenčna_knjižica[[#This Row],[DVIG]]), \"\")","v":{"v":3400,"d":"3,400.00 €"}}]
[null,"DC",{"$f":"TODAY()-8","v":"2018-06-07"},"Izposoja videov","Izposoja filma + 10 € vračilo",{"v":16,"d":"16.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(Evidenčna_knjižica[[#This Row],[DVIG]]),H9+Evidenčna_knjižica[[#This Row],[POLOG]],H9-Evidenčna_knjižica[[#This Row],[DVIG]]), \"\")","v":{"v":3384,"d":"3,384.00 €"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2018-06-10"},null,"Gotovina za kosilo v restavraciji",{"v":50,"d":"50.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(Evidenčna_knjižica[[#This Row],[DVIG]]),H10+Evidenčna_knjižica[[#This Row],[POLOG]],H10-Evidenčna_knjižica[[#This Row],[DVIG]]), \"\")","v":{"v":3334,"d":"3,334.00 €"}}]
[null,"BP",{"$f":"TODAY()","v":"2018-06-15"},"Telefonsko podjetje",null,{"v":23,"d":"23.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(Evidenčna_knjižica[[#This Row],[DVIG]]),H11+Evidenčna_knjižica[[#This Row],[POLOG]],H11-Evidenčna_knjižica[[#This Row],[DVIG]]), \"\")","v":{"v":3311,"d":"3,311.00 €"}}]
[null,"Skupni zneski",null,{"$f":"CONCATENATE(\"Število transakcij: \",SUBTOTAL(103,Evidenčna_knjižica[TRANSAKCIJA]))","v":"Število transakcij: 5"},null,{"$f":"SUBTOTAL(109,Evidenčna_knjižica[DVIG])","v":{"v":189,"d":"189.00 €"}},{"$f":"SUBTOTAL(109,Evidenčna_knjižica[POLOG])","v":{"v":3500,"d":"3,500.00 €"}},{"$f":"Evidenčna_knjižica[[#Totals],[POLOG]]-Evidenčna_knjižica[[#Totals],[DVIG]]","v":{"v":3311,"d":"3,311.00 €"}}]