{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Čeku žurnāls"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Čeku žurnāls","index":0,"n_rows":13,"n_cols":8,"rows_kept":13}
[null,"Čeku žurnāls"]
[null,"APZĪMĒJUMS",{"$nulls":5},"PAŠREIZĒJĀ BILANCE"]
[null,"DC = debetkarte",null,"AP  = automātisks maksājums ",{"$nulls":3},{"$f":"PAŠREIZĒJĀ_BILANCE","v":{"v":3311,"d":"3,311.00 EUR"}}]
[null,"ATM = naudas izņemšana no bankomāta",null,"BP = rēķinu apmaksa tiešsaistē"]
[null,"AD = automātiska iemaksa ",null,"TR = pārskaitījums tiešsaistē vai pa tālruni"]
[null,"ČEKS/KODS","DATUMS","DARĪJUMS","APRAKSTS","IZŅEMTĀ SUMMA","NOGULDĪJUMS","BILANCE"]
[null,null,{"$f":"TODAY()-19","v":"2022-03-18"},"Woodgrove Bank","Sākuma bilance",null,{"v":2000,"d":"2,000.00 EUR"},{"$f":"IFERROR(Čeku_žurnāls[[#This Row],[NOGULDĪJUMS]], \"\")","v":{"v":2000,"d":"2,000.00 EUR"}}]
[null,1001,{"$f":"TODAY()-11","v":"2022-03-26"},"School of Fine Art","Antras zīmēšanas lekcijas — 6 nedēļas",{"v":100,"d":"100.00 EUR"},null,{"$f":"IFERROR(IF(ISBLANK(Čeku_žurnāls[[#This Row],[IZŅEMTĀ SUMMA]]),H7+Čeku_žurnāls[[#This Row],[NOGULDĪJUMS]],H7-Čeku_žurnāls[[#This Row],[IZŅEMTĀ SUMMA]]), \"\")","v":{"v":1900,"d":"1,900.00 EUR"}}]
[null,"AD",{"$f":"TODAY()-11","v":"2022-03-26"},"Alga",null,null,{"v":1500,"d":"1,500.00 EUR"},{"$f":"IFERROR(IF(ISBLANK(Čeku_žurnāls[[#This Row],[IZŅEMTĀ SUMMA]]),H8+Čeku_žurnāls[[#This Row],[NOGULDĪJUMS]],H8-Čeku_žurnāls[[#This Row],[IZŅEMTĀ SUMMA]]), \"\")","v":{"v":3400,"d":"3,400.00 EUR"}}]
[null,"DC",{"$f":"TODAY()-8","v":"2022-03-29"},"Southridge Video","Filmas iznomāšana + 10 EUR skaidras naudas atlikums",{"v":16,"d":"16.00 EUR"},null,{"$f":"IFERROR(IF(ISBLANK(Čeku_žurnāls[[#This Row],[IZŅEMTĀ SUMMA]]),H9+Čeku_žurnāls[[#This Row],[NOGULDĪJUMS]],H9-Čeku_žurnāls[[#This Row],[IZŅEMTĀ SUMMA]]), \"\")","v":{"v":3384,"d":"3,384.00 EUR"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2022-04-01"},null,"Skaidra nauda pusdienām",{"v":50,"d":"50.00 EUR"},null,{"$f":"IFERROR(IF(ISBLANK(Čeku_žurnāls[[#This Row],[IZŅEMTĀ SUMMA]]),H10+Čeku_žurnāls[[#This Row],[NOGULDĪJUMS]],H10-Čeku_žurnāls[[#This Row],[IZŅEMTĀ SUMMA]]), \"\")","v":{"v":3334,"d":"3,334.00 EUR"}}]
[null,"BP",{"$f":"TODAY()","v":"2022-04-06"},"The Phone Company",null,{"v":23,"d":"23.00 EUR"},null,{"$f":"IFERROR(IF(ISBLANK(Čeku_žurnāls[[#This Row],[IZŅEMTĀ SUMMA]]),H11+Čeku_žurnāls[[#This Row],[NOGULDĪJUMS]],H11-Čeku_žurnāls[[#This Row],[IZŅEMTĀ SUMMA]]), \"\")","v":{"v":3311,"d":"3,311.00 EUR"}}]
[null,"Kopā",null,{"$f":"CONCATENATE(\"Darījumu skaits: \",SUBTOTAL(103,Čeku_žurnāls[DARĪJUMS]))","v":"Darījumu skaits: 5"},null,{"$f":"SUBTOTAL(109,Čeku_žurnāls[IZŅEMTĀ SUMMA])","v":{"v":189,"d":"189.00 EUR"}},{"$f":"SUBTOTAL(109,Čeku_žurnāls[NOGULDĪJUMS])","v":{"v":3500,"d":"3,500.00 EUR"}},{"$f":"Čeku_žurnāls[[#Totals],[NOGULDĪJUMS]]-Čeku_žurnāls[[#Totals],[IZŅEMTĀ SUMMA]]","v":{"v":3311,"d":"3,311.00 EUR"}}]