{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Čekių registras"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Čekių registras","index":0,"n_rows":13,"n_cols":8,"rows_kept":13}
[null,"Čekių registras"]
[null,"LEGENDA",{"$nulls":5},"DABARTINIS LIKUTIS"]
[null,"DK = debeto kortelė",null,"AM = automatinis mokėjimas ",{"$nulls":3},{"$f":"DABARTINIS_LIKUTIS","v":{"v":3311,"d":"3,311.00 EUR"}}]
[null,"ATM = bankomatas",null,"MI = sąskaitos apmokėjimas internetu"]
[null,"AI = automatinis indėlis ",null,"PV = pavedimas internetu arba telefonu"]
[null,"ČEKIS / KODAS","DATA","OPERACIJA","APRAŠAS","IŠIMTA SUMA","ĮDĖTA SUMA","LIKUTIS"]
[null,null,{"$f":"TODAY()-19","v":"2022-03-19"},"Woodgrove Bank","Pradžios likutis",null,{"v":2000,"d":"2,000.00 EUR"},{"$f":"IFERROR(ČekiųRegistras[[#This Row],[ĮDĖTA SUMA]], \"\")","v":{"v":2000,"d":"2,000.00 EUR"}}]
[null,1001,{"$f":"TODAY()-11","v":"2022-03-27"},"Meno mokykla","Kotrynos meno klasė – 6 sav.",{"v":100,"d":"100.00 EUR"},null,{"$f":"IFERROR(IF(ISBLANK(ČekiųRegistras[[#This Row],[IŠIMTA SUMA]]),H7+ČekiųRegistras[[#This Row],[ĮDĖTA SUMA]],H7-ČekiųRegistras[[#This Row],[IŠIMTA SUMA]]), \"\")","v":{"v":1900,"d":"1,900.00 EUR"}}]
[null,"AI",{"$f":"TODAY()-11","v":"2022-03-27"},"Algos mokėjimo čekis",null,null,{"v":1500,"d":"1,500.00 EUR"},{"$f":"IFERROR(IF(ISBLANK(ČekiųRegistras[[#This Row],[IŠIMTA SUMA]]),H8+ČekiųRegistras[[#This Row],[ĮDĖTA SUMA]],H8-ČekiųRegistras[[#This Row],[IŠIMTA SUMA]]), \"\")","v":{"v":3400,"d":"3,400.00 EUR"}}]
[null,"DK",{"$f":"TODAY()-8","v":"2022-03-30"},"Vaizdo įrašų nuoma","Filmų nuoma + 10 EUR grąžinimas",{"v":16,"d":"16.00 EUR"},null,{"$f":"IFERROR(IF(ISBLANK(ČekiųRegistras[[#This Row],[IŠIMTA SUMA]]),H9+ČekiųRegistras[[#This Row],[ĮDĖTA SUMA]],H9-ČekiųRegistras[[#This Row],[IŠIMTA SUMA]]), \"\")","v":{"v":3384,"d":"3,384.00 EUR"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2022-04-02"},null,"Grynieji pinigai vakarienėms restorane",{"v":50,"d":"50.00 EUR"},null,{"$f":"IFERROR(IF(ISBLANK(ČekiųRegistras[[#This Row],[IŠIMTA SUMA]]),H10+ČekiųRegistras[[#This Row],[ĮDĖTA SUMA]],H10-ČekiųRegistras[[#This Row],[IŠIMTA SUMA]]), \"\")","v":{"v":3334,"d":"3,334.00 EUR"}}]
[null,"MI",{"$f":"TODAY()","v":"2022-04-07"},"Telekomunikacijų įmonė",null,{"v":23,"d":"23.00 EUR"},null,{"$f":"IFERROR(IF(ISBLANK(ČekiųRegistras[[#This Row],[IŠIMTA SUMA]]),H11+ČekiųRegistras[[#This Row],[ĮDĖTA SUMA]],H11-ČekiųRegistras[[#This Row],[IŠIMTA SUMA]]), \"\")","v":{"v":3311,"d":"3,311.00 EUR"}}]
[null,"Iš viso",null,{"$f":"CONCATENATE(\"Operacijų skaičius: \",SUBTOTAL(103,ČekiųRegistras[OPERACIJA]))","v":"Operacijų skaičius: 5"},null,{"$f":"SUBTOTAL(109,ČekiųRegistras[IŠIMTA SUMA])","v":{"v":189,"d":"189.00 EUR"}},{"$f":"SUBTOTAL(109,ČekiųRegistras[ĮDĖTA SUMA])","v":{"v":3500,"d":"3,500.00 EUR"}},{"$f":"ČekiųRegistras[[#Totals],[ĮDĖTA SUMA]]-ČekiųRegistras[[#Totals],[IŠIMTA SUMA]]","v":{"v":3311,"d":"3,311.00 EUR"}}]