{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Kortelė","Duomenys","Archyvas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Kortelė","index":0,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,1,3,6],[3,11,3,12],[16,2,16,6]]}
[null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"2019-01-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,1,null,{"$f":"IFERROR(VLOOKUP(C5,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\")","v":"-"},1,{"$f":"IFERROR(HLOOKUP(VLOOKUP(C5,Duomenys!$B$2:$D$51,3,FALSE),Duomenys!$F$1:$BC$51,VLOOKUP(C6,Duomenys!$B$2:$D$51,3,FALSE)+1,FALSE),0)","v":0},{"$f":"IF(D5=\"-\",\"\",IFERROR(VLOOKUP(C6,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,4]
[null,2,null,{"$f":"IFERROR(VLOOKUP(C6,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\")","v":"-"},2,{"$f":"IFERROR(HLOOKUP(VLOOKUP(C6,Duomenys!$B$2:$D$51,3,FALSE),Duomenys!$F$1:$BC$51,VLOOKUP(C7,Duomenys!$B$2:$D$51,3,FALSE)+1,FALSE),0)","v":0},{"$f":"IF(D6=\"-\",\"\",IFERROR(VLOOKUP(C7,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,5]
[null,3,null,{"$f":"IFERROR(VLOOKUP(C7,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(HLOOKUP(VLOOKUP(C7,Duomenys!$B$2:$D$51,3,FALSE),Duomenys!$F$1:$BC$51,VLOOKUP(C8,Duomenys!$B$2:$D$51,3,FALSE)+1,FALSE),0)","v":0},{"$f":"IF(D7=\"-\",\"\",IFERROR(VLOOKUP(C8,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,6]
[null,4,null,{"$f":"IFERROR(VLOOKUP(C8,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(HLOOKUP(VLOOKUP(C8,Duomenys!$B$2:$D$51,3,FALSE),Duomenys!$F$1:$BC$51,VLOOKUP(C9,Duomenys!$B$2:$D$51,3,FALSE)+1,FALSE),0)","v":0},{"$f":"IF(D8=\"-\",\"\",IFERROR(VLOOKUP(C9,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,7]
[null,5,null,{"$f":"IFERROR(VLOOKUP(C9,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(HLOOKUP(VLOOKUP(C9,Duomenys!$B$2:$D$51,3,FALSE),Duomenys!$F$1:$BC$51,VLOOKUP(C10,Duomenys!$B$2:$D$51,3,FALSE)+1,FALSE),0)","v":0},{"$f":"IF(D9=\"-\",\"\",IFERROR(VLOOKUP(C10,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,8]
[null,6,null,{"$f":"IFERROR(VLOOKUP(C10,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(HLOOKUP(VLOOKUP(C10,Duomenys!$B$2:$D$51,3,FALSE),Duomenys!$F$1:$BC$51,VLOOKUP(C11,Duomenys!$B$2:$D$51,3,FALSE)+1,FALSE),0)","v":0},{"$f":"IF(D10=\"-\",\"\",IFERROR(VLOOKUP(C11,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,9]
[null,7,null,{"$f":"IFERROR(VLOOKUP(C11,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(HLOOKUP(VLOOKUP(C11,Duomenys!$B$2:$D$51,3,FALSE),Duomenys!$F$1:$BC$51,VLOOKUP(C12,Duomenys!$B$2:$D$51,3,FALSE)+1,FALSE),0)","v":0},{"$f":"IF(D11=\"-\",\"\",IFERROR(VLOOKUP(C12,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,10]
[null,8,null,{"$f":"IFERROR(VLOOKUP(C12,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(HLOOKUP(VLOOKUP(C12,Duomenys!$B$2:$D$51,3,FALSE),Duomenys!$F$1:$BC$51,VLOOKUP(C13,Duomenys!$B$2:$D$51,3,FALSE)+1,FALSE),0)","v":0},{"$f":"IF(D12=\"-\",\"\",IFERROR(VLOOKUP(C13,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\"))","v":""}]
[null,9,null,{"$f":"IFERROR(VLOOKUP(C13,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(HLOOKUP(VLOOKUP(C13,Duomenys!$B$2:$D$51,3,FALSE),Duomenys!$F$1:$BC$51,VLOOKUP(C14,Duomenys!$B$2:$D$51,3,FALSE)+1,FALSE),0)","v":0},{"$f":"IF(D13=\"-\",\"\",IFERROR(VLOOKUP(C14,Duomenys!$B$2:$C$51,$D$1,FALSE),\"-\"))","v":""}]
[null,10]
[null,null,null,null,{"$f":"SUM(E5:E13)","v":3},{"$f":"SUM(F5:F14)","v":0}]
[]
[null,null,"Reikia, jog paspaudus mygtuką „NAUJAS“, data B4 ir 10 eilučių C5:G14 reikšmės būtu perrašytos į lapą „Archyvas“ pirmą eilutę, panašiai kaip surašiau rankutėmis. Toliau įrašytu šios dienos datą ir ištrintu du stulpelius, tai C5:C14 ir E5:E14.   Sekantį kartą paspaudus mygtuką „NAUJAS“, vyktu ta pati procedūra, tik jau į antrą „Archyvas“ eilutę."]

{"sheet":"Duomenys","index":1,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,1,2,3,4,5,6,7,8,9]
[1,"Butas","Soukankaari 12A - 2  02360 Espoo",1,null,0,51,45,58,53,49,45,50]
[2,"Dažų pard.","Pekontie 1, 01900 Nurmijärvi",2,null,51,0,10,8,12,8,14,2]
[3,"Dažų gamykl.","Järventaustantie 141, 01810 Nurmijärvi",3,null,45,10,0,17,15,9,7,11]
[4,"Motociklai","Vanha Rajamäentie 173, 05200 Nurmijärvi",4,null,58,8,17,0,16,15,18,9]
[5,"Namas 89","Ilmolantie 89, 01860 Nurmijärvi",5,null,53,12,15,16,0,19,11,13]
[6,"Namas 3","Ruokosuonkuja 3, 04350 Tuusula",6,null,49,8,9,15,19,0,15,8]
[7,"Namas 9","Tiiramäentie 9, 01800 Nurmijärvi",7,null,45,14,7,18,11,15,0,15]
[8,"Offisas 29","Ilveskaari 29, 01900 Nurmijärvi",8,null,50,2,9,9,13,7,15,0]
[9,null,null,9]
[10,null,null,10]
[11,null,null,11]
[12,null,null,12]
[13,null,null,13]
[14,null,null,14]
[15,null,null,15]
[16,null,null,16]
[17,null,null,17]
[18,null,null,18]
[19,null,null,19]
[20,null,null,20]
[21,null,null,21]
[22,null,null,22]
[23,null,null,23]
[24,null,null,24]
[25,null,null,25]
[26,null,null,26]
[27,null,null,27]
[28,null,null,28]
[29,null,null,29]
[30,null,null,30]
[31,null,null,31]
[32,null,null,32]
[33,null,null,33]
[34,null,null,34]
[35,null,null,35]
[36,null,null,36]
[37,null,null,37]
[38,null,null,38]
[39,null,null,39]
[40,null,null,40]
[41,null,null,41]
[42,null,null,42]
[43,null,null,43]
[44,null,null,44]
[45,null,null,45]
[46,null,null,46]
[47,null,null,47]
[48,null,null,48]
[49,null,null,49]
[50,null,null,50]

{"sheet":"Archyvas","index":2,"n_rows":1,"n_cols":55,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["2019-01-21","Butas","Soukankaari 12A - 2  02360 Espoo",null,53,"Ilmolantie 89, 01860 Nurmijärvi","Namas 89","Ilmolantie 89, 01860 Nurmijärvi",3,13,"Ilveskaari 29, 01900 Nurmijärvi","Offisas 29","Ilveskaari 29, 01900 Nurmijärvi",2,2,"Pekontie 1, 01900 Nurmijärvi","Dažų pard.","Pekontie 1, 01900 Nurmijärvi",3,10,"Järventaustantie 141, 01810 Nurmijärvi","Dažų gamykl.","Järventaustantie 141, 01810 Nurmijärvi",null,0,"-",null,"-",null,0,"",null,"-",null,0,"",null,"-",null,0,"",null,"-",null,0,"",null,null,null,null,null,null,null,8,78]