{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Išlaidų suvestinė","Išlaidų žurnalas"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Išlaidų suvestinė","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"Išlaidų suvestinė",null,null,"Norėdami tinkinti šį šabloną pagal savo poreikius, išlaidų suvestinės lentelės antraštėje pakeiskite kategorijų pavadinimus. Jei norite įtraukti papildomų kategorijų, nukopijuokite paskutinį lentelės stulpelį ir įklijuokite jį nukopijuoto stulpelio dešinėje. Kai keičiate kategorijos pavadinimą, formulės bus atnaujinamos automatiškai. Įsitikinkite, ar šioje lentelėje yra tiek pat eilučių, kaip ir išlaidos žurnalo darbalapyje."]
[null,"Data","Automobilio draudimas","Biuro reikmenys","Elektra","Būsto paskola","Telefonas","1 tuščias","2 tuščias","3 tuščias","4 tuščias"]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A1),1),\"\")","v":"2018-04-06"},{"$f":"IFERROR(INDIRECT(\"Registras[@Suma]\")*(INDIRECT(\"Registras[@Kategorija]\")=KategorijosPavadinimas),\"\")","v":0},0,0,{"v":1200,"d":"1,200.00 EUR"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A2),1),\"\")","v":"2018-04-11"},0,0,{"v":85,"d":"85.00 EUR"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A3),1),\"\")","v":"2018-04-16"},{"v":100,"d":"100.00 EUR"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A4),1),\"\")","v":"2018-04-21"},0,0,0,{"v":1200,"d":"1,200.00 EUR"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A5),1),\"\")","v":"2018-04-26"},0,0,0,{"v":99,"d":"99.00 EUR"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A6),1),\"\")","v":"2018-05-01"},0,0,0,0,{"v":68,"d":"68.00 EUR"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A7),1),\"\")","v":"2018-05-06"},{"v":100,"d":"100.00 EUR"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A8),1),\"\")","v":"2018-05-11"},0,{"v":345,"d":"345.00 EUR"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A9),1),\"\")","v":"2018-05-16"},0,0,0,{"v":1200,"d":"1,200.00 EUR"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A10),1),\"\")","v":"2018-05-21"},0,0,{"v":74,"d":"74.00 EUR"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A11),1),\"\")","v":"2018-05-26"},0,0,0,0,{"v":123,"d":"123.00 EUR"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A12),1),\"\")","v":"2018-05-31"},0,{"v":99,"d":"99.00 EUR"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A13),1),\"\")","v":"2018-06-05"},{"v":100,"d":"100.00 EUR"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A14),1),\"\")","v":"2018-06-10"},0,0,0,{"v":1200,"d":"1,200.00 EUR"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Registras[],ROW(A15),1),\"\")","v":"2018-06-15"},0,{"v":128,"d":"128.00 EUR"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,IšlaidųSuvestinė[Automobilio draudimas])","v":{"v":300,"d":"300.00 EUR"}},{"$f":"SUBTOTAL(109,IšlaidųSuvestinė[Biuro reikmenys])","v":{"v":572,"d":"572.00 EUR"}},{"$f":"SUBTOTAL(109,IšlaidųSuvestinė[Elektra])","v":{"v":159,"d":"159.00 EUR"}},{"$f":"SUBTOTAL(109,IšlaidųSuvestinė[Būsto paskola])","v":{"v":4899,"d":"4,899.00 EUR"}},{"$f":"SUBTOTAL(109,IšlaidųSuvestinė[Telefonas])","v":{"v":191,"d":"191.00 EUR"}},{"$f":"SUBTOTAL(109,IšlaidųSuvestinė[1 tuščias])","v":0},{"$f":"SUBTOTAL(109,IšlaidųSuvestinė[2 tuščias])","v":0},{"$f":"SUBTOTAL(109,IšlaidųSuvestinė[3 tuščias])","v":0},{"$f":"SUBTOTAL(109,IšlaidųSuvestinė[4 tuščias])","v":0}]

{"sheet":"Išlaidų žurnalas","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"Išlaidų žurnalas"]
[null,"Data","Numeris","Aprašas","Kategorija","Suma"]
[null,{"$f":"TODAY()-70","v":"2018-04-06"},"100","Woodgrove Bank","Būsto paskola",{"v":1200,"d":"1,200.00 EUR"}]
[null,{"$f":"TODAY()-65","v":"2018-04-11"},101,"Elektra ir šiukšlių išvežimas","Elektra",{"v":85,"d":"85.00 EUR"}]
[null,{"$f":"TODAY()-60","v":"2018-04-16"},102,"Humongous Insurance","Automobilio draudimas",{"v":100,"d":"100.00 EUR"}]
[null,{"$f":"TODAY()-55","v":"2018-04-21"},103,"Woodgrove Bank","Būsto paskola",{"v":1200,"d":"1,200.00 EUR"}]
[null,{"$f":"TODAY()-50","v":"2018-04-26"},104,"Elektra ir šiukšlių išvežimas","Būsto paskola",{"v":99,"d":"99.00 EUR"}]
[null,{"$f":"TODAY()-45","v":"2018-05-01"},105,"Telekomunikacijų įmonė","Telefonas",{"v":68,"d":"68.00 EUR"}]
[null,{"$f":"TODAY()-40","v":"2018-05-06"},106,"Humongous Insurance","Automobilio draudimas",{"v":100,"d":"100.00 EUR"}]
[null,{"$f":"TODAY()-35","v":"2018-05-11"},107,"Litware, Inc.","Biuro reikmenys",{"v":345,"d":"345.00 EUR"}]
[null,{"$f":"TODAY()-30","v":"2018-05-16"},110,"Woodgrove Bank","Būsto paskola",{"v":1200,"d":"1,200.00 EUR"}]
[null,{"$f":"TODAY()-25","v":"2018-05-21"},111,"Elektra ir šiukšlių išvežimas","Elektra",{"v":74,"d":"74.00 EUR"}]
[null,{"$f":"TODAY()-20","v":"2018-05-26"},108,"Telekomunikacijų įmonė","Telefonas",{"v":123,"d":"123.00 EUR"}]
[null,{"$f":"TODAY()-15","v":"2018-05-31"},109,"Litware, Inc.","Biuro reikmenys",{"v":99,"d":"99.00 EUR"}]
[null,{"$f":"TODAY()-10","v":"2018-06-05"},112,"Humongous Insurance","Automobilio draudimas",{"v":100,"d":"100.00 EUR"}]
[null,{"$f":"TODAY()-5","v":"2018-06-10"},113,"Woodgrove Bank","Būsto paskola",{"v":1200,"d":"1,200.00 EUR"}]
[null,{"$f":"TODAY()","v":"2018-06-15"},114,"Litware, Inc.","Biuro reikmenys",{"v":128,"d":"128.00 EUR"}]
[null,"Iš viso",{"$nulls":3},{"$f":"SUBTOTAL(109,Registras[Suma])","v":{"v":6121,"d":"6,121.00 EUR"}}]