{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Bibliotekos knygų paėmimas"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Bibliotekos knygų paėmimas","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"merged":[[0,1,0,4],[0,5,0,6]]}
[null,"Bibliotekos knygų paėmimo lapas",{"$nulls":3},"DIENOS IKI TERMINO PABAIGOS ",null,10]
["Pradelsta","MOKINYS","KONTAKTINIS EL. PAŠTO ADRESAS","KONTAKTINIS TELEFONO NUMERIS","KNYGOS PAVADINIMAS","PASISKOLINIMO DATA","GRĄŽINIMO DATA","DIENOS"]
[{"$f":"IFERROR(((Knygos[[#This Row],[PASISKOLINIMO DATA]]+LikusiosDienos)<TODAY())*(LEN(Knygos[[#This Row],[GRĄŽINIMO DATA]])=0)*(LEN(Knygos[[#This Row],[PASISKOLINIMO DATA]])>0),0)","v":0},"Marija Simukaitė","kazkas@pavyzdys.com","555-0100","Namelis prerijose",{"$f":"DATE(YEAR(TODAY()),1,14)","v":"2018-01-14"},{"$f":"DATE(YEAR(TODAY()),1,21)","v":"2018-01-21"},{"$f":"IFERROR(IF(Knygos[[#This Row],[GRĄŽINIMO DATA]]=\"\",IF(Knygos[[#This Row],[PASISKOLINIMO DATA]]<>\"\", TODAY()-Knygos[[#This Row],[PASISKOLINIMO DATA]],\"\"),Knygos[[#This Row],[GRĄŽINIMO DATA]]-Knygos[[#This Row],[PASISKOLINIMO DATA]]), \"\")","v":7}]
[{"$f":"IFERROR(((Knygos[[#This Row],[PASISKOLINIMO DATA]]+LikusiosDienos)<TODAY())*(LEN(Knygos[[#This Row],[GRĄŽINIMO DATA]])=0)*(LEN(Knygos[[#This Row],[PASISKOLINIMO DATA]])>0),0)","v":0},"Antanas Arlauskas","kazkas@pavyzdys.com","555-0101","Šarlotės voratinklis",{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2018-02-15"},{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2018-02-18"},{"$f":"IFERROR(IF(Knygos[[#This Row],[GRĄŽINIMO DATA]]=\"\",IF(Knygos[[#This Row],[PASISKOLINIMO DATA]]<>\"\", TODAY()-Knygos[[#This Row],[PASISKOLINIMO DATA]],\"\"),Knygos[[#This Row],[GRĄŽINIMO DATA]]-Knygos[[#This Row],[PASISKOLINIMO DATA]]), \"\")","v":3}]
[{"$f":"IFERROR(((Knygos[[#This Row],[PASISKOLINIMO DATA]]+LikusiosDienos)<TODAY())*(LEN(Knygos[[#This Row],[GRĄŽINIMO DATA]])=0)*(LEN(Knygos[[#This Row],[PASISKOLINIMO DATA]])>0),0)","v":0},"Rimtautas Gapšys","kazkas@pavyzdys.com","555-0102","Mažasis Princas",{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),2,22)","v":"2018-02-22"},{"$f":"IFERROR(IF(Knygos[[#This Row],[GRĄŽINIMO DATA]]=\"\",IF(Knygos[[#This Row],[PASISKOLINIMO DATA]]<>\"\", TODAY()-Knygos[[#This Row],[PASISKOLINIMO DATA]],\"\"),Knygos[[#This Row],[GRĄŽINIMO DATA]]-Knygos[[#This Row],[PASISKOLINIMO DATA]]), \"\")","v":5}]
[{"$f":"IFERROR(((Knygos[[#This Row],[PASISKOLINIMO DATA]]+LikusiosDienos)<TODAY())*(LEN(Knygos[[#This Row],[GRĄŽINIMO DATA]])=0)*(LEN(Knygos[[#This Row],[PASISKOLINIMO DATA]])>0),0)","v":0},"Vainius Domkus","kazkas@pavyzdys.com","555-0103","Alisa stebuklų šalyje",{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),2,25)","v":"2018-02-25"},{"$f":"IFERROR(IF(Knygos[[#This Row],[GRĄŽINIMO DATA]]=\"\",IF(Knygos[[#This Row],[PASISKOLINIMO DATA]]<>\"\", TODAY()-Knygos[[#This Row],[PASISKOLINIMO DATA]],\"\"),Knygos[[#This Row],[GRĄŽINIMO DATA]]-Knygos[[#This Row],[PASISKOLINIMO DATA]]), \"\")","v":8}]
[{"$f":"IFERROR(((Knygos[[#This Row],[PASISKOLINIMO DATA]]+LikusiosDienos)<TODAY())*(LEN(Knygos[[#This Row],[GRĄŽINIMO DATA]])=0)*(LEN(Knygos[[#This Row],[PASISKOLINIMO DATA]])>0),0)","v":0},"Kotryna Antaitė","kazkas@pavyzdys.com","555-0104","Matilda",{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2018-02-18"},{"$f":"DATE(YEAR(TODAY()),2,28)","v":"2018-02-28"},{"$f":"IFERROR(IF(Knygos[[#This Row],[GRĄŽINIMO DATA]]=\"\",IF(Knygos[[#This Row],[PASISKOLINIMO DATA]]<>\"\", TODAY()-Knygos[[#This Row],[PASISKOLINIMO DATA]],\"\"),Knygos[[#This Row],[GRĄŽINIMO DATA]]-Knygos[[#This Row],[PASISKOLINIMO DATA]]), \"\")","v":10}]
[{"$f":"IFERROR(((Knygos[[#This Row],[PASISKOLINIMO DATA]]+LikusiosDienos)<TODAY())*(LEN(Knygos[[#This Row],[GRĄŽINIMO DATA]])=0)*(LEN(Knygos[[#This Row],[PASISKOLINIMO DATA]])>0),0)","v":1},"Rimantė Meirytė","kazkas@pavyzdys.com","555-0105","Narnijos kronikos",{"$f":"DATE(YEAR(TODAY()),1,23)","v":"2018-01-23"},null,{"$f":"IFERROR(IF(Knygos[[#This Row],[GRĄŽINIMO DATA]]=\"\",IF(Knygos[[#This Row],[PASISKOLINIMO DATA]]<>\"\", TODAY()-Knygos[[#This Row],[PASISKOLINIMO DATA]],\"\"),Knygos[[#This Row],[GRĄŽINIMO DATA]]-Knygos[[#This Row],[PASISKOLINIMO DATA]]), \"\")","v":164}]
[{"$f":"IFERROR(((Knygos[[#This Row],[PASISKOLINIMO DATA]]+LikusiosDienos)<TODAY())*(LEN(Knygos[[#This Row],[GRĄŽINIMO DATA]])=0)*(LEN(Knygos[[#This Row],[PASISKOLINIMO DATA]])>0),0)","v":0},"Vilija Stoškutė","kazkas@pavyzdys.com","555-0106","Piteris Penas",{"$f":"TODAY()","v":"2018-07-06"},null,{"$f":"IFERROR(IF(Knygos[[#This Row],[GRĄŽINIMO DATA]]=\"\",IF(Knygos[[#This Row],[PASISKOLINIMO DATA]]<>\"\", TODAY()-Knygos[[#This Row],[PASISKOLINIMO DATA]],\"\"),Knygos[[#This Row],[GRĄŽINIMO DATA]]-Knygos[[#This Row],[PASISKOLINIMO DATA]]), \"\")","v":0}]