{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Peminjaman Buku Perpustakaan"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Peminjaman Buku Perpustakaan","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"merged":[[0,1,0,4],[0,5,0,6]]}
[null,"Lembar Peminjaman Buku Perpustakaan",{"$nulls":3},"HARI HINGGA AKHIR PEMINJAMAN: ",null,10]
["Terlambat","SISWA","EMAIL KONTAK","TELEPON KONTAK","JUDUL BUKU","TANGGAL PEMINJAMAN","TANGGAL PENGEMBALIAN","HARI"]
[{"$f":"IFERROR(((Buku[[#This Row],[TANGGAL PEMINJAMAN]]+JumlahHariPeminjaman)<TODAY())*(LEN(Buku[[#This Row],[TANGGAL PENGEMBALIAN]])=0)*(LEN(Buku[[#This Row],[TANGGAL PEMINJAMAN]])>0),0)","v":0},"Maria Carla","seseorang@contoh.com","555-010","Sepuluh Anak Negro",{"$f":"DATE(YEAR(TODAY()),1,14)","v":"2018-01-14"},{"$f":"DATE(YEAR(TODAY()),1,21)","v":"2018-01-21"},{"$f":"IFERROR(IF(Buku[[#This Row],[TANGGAL PENGEMBALIAN]]=\"\",IF(Buku[[#This Row],[TANGGAL PEMINJAMAN]]<>\"\", TODAY()-Buku[[#This Row],[TANGGAL PEMINJAMAN]],\"\"),Buku[[#This Row],[TANGGAL PENGEMBALIAN]]-Buku[[#This Row],[TANGGAL PEMINJAMAN]]), \"\")","v":7}]
[{"$f":"IFERROR(((Buku[[#This Row],[TANGGAL PEMINJAMAN]]+JumlahHariPeminjaman)<TODAY())*(LEN(Buku[[#This Row],[TANGGAL PENGEMBALIAN]])=0)*(LEN(Buku[[#This Row],[TANGGAL PEMINJAMAN]])>0),0)","v":0},"Sigit Damianto","seseorang@contoh.com","555-011","Supernova: Kesatria, Putri, & Bintang Jatuh",{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2018-02-15"},{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2018-02-18"},{"$f":"IFERROR(IF(Buku[[#This Row],[TANGGAL PENGEMBALIAN]]=\"\",IF(Buku[[#This Row],[TANGGAL PEMINJAMAN]]<>\"\", TODAY()-Buku[[#This Row],[TANGGAL PEMINJAMAN]],\"\"),Buku[[#This Row],[TANGGAL PENGEMBALIAN]]-Buku[[#This Row],[TANGGAL PEMINJAMAN]]), \"\")","v":3}]
[{"$f":"IFERROR(((Buku[[#This Row],[TANGGAL PEMINJAMAN]]+JumlahHariPeminjaman)<TODAY())*(LEN(Buku[[#This Row],[TANGGAL PENGEMBALIAN]])=0)*(LEN(Buku[[#This Row],[TANGGAL PEMINJAMAN]])>0),0)","v":0},"Kevin Firmansyah","seseorang@contoh.com","555-012","The Hunger Games",{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),2,22)","v":"2018-02-22"},{"$f":"IFERROR(IF(Buku[[#This Row],[TANGGAL PENGEMBALIAN]]=\"\",IF(Buku[[#This Row],[TANGGAL PEMINJAMAN]]<>\"\", TODAY()-Buku[[#This Row],[TANGGAL PEMINJAMAN]],\"\"),Buku[[#This Row],[TANGGAL PENGEMBALIAN]]-Buku[[#This Row],[TANGGAL PEMINJAMAN]]), \"\")","v":5}]
[{"$f":"IFERROR(((Buku[[#This Row],[TANGGAL PEMINJAMAN]]+JumlahHariPeminjaman)<TODAY())*(LEN(Buku[[#This Row],[TANGGAL PENGEMBALIAN]])=0)*(LEN(Buku[[#This Row],[TANGGAL PEMINJAMAN]])>0),0)","v":0},"Sandi Heryanto","seseorang@contoh.com","555-013","Great Expectations",{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),2,25)","v":"2018-02-25"},{"$f":"IFERROR(IF(Buku[[#This Row],[TANGGAL PENGEMBALIAN]]=\"\",IF(Buku[[#This Row],[TANGGAL PEMINJAMAN]]<>\"\", TODAY()-Buku[[#This Row],[TANGGAL PEMINJAMAN]],\"\"),Buku[[#This Row],[TANGGAL PENGEMBALIAN]]-Buku[[#This Row],[TANGGAL PEMINJAMAN]]), \"\")","v":8}]
[{"$f":"IFERROR(((Buku[[#This Row],[TANGGAL PEMINJAMAN]]+JumlahHariPeminjaman)<TODAY())*(LEN(Buku[[#This Row],[TANGGAL PENGEMBALIAN]])=0)*(LEN(Buku[[#This Row],[TANGGAL PEMINJAMAN]])>0),0)","v":0},"Lola Julianti","seseorang@contoh.com","555-014","Kisah Pi",{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2018-02-18"},{"$f":"DATE(YEAR(TODAY()),2,28)","v":"2018-02-28"},{"$f":"IFERROR(IF(Buku[[#This Row],[TANGGAL PENGEMBALIAN]]=\"\",IF(Buku[[#This Row],[TANGGAL PEMINJAMAN]]<>\"\", TODAY()-Buku[[#This Row],[TANGGAL PEMINJAMAN]],\"\"),Buku[[#This Row],[TANGGAL PENGEMBALIAN]]-Buku[[#This Row],[TANGGAL PEMINJAMAN]]), \"\")","v":10}]
[{"$f":"IFERROR(((Buku[[#This Row],[TANGGAL PEMINJAMAN]]+JumlahHariPeminjaman)<TODAY())*(LEN(Buku[[#This Row],[TANGGAL PENGEMBALIAN]])=0)*(LEN(Buku[[#This Row],[TANGGAL PEMINJAMAN]])>0),0)","v":1},"Menik Kartika","seseorang@contoh.com","555-015","Harry Potter dan Tawanan Azkaban",{"$f":"DATE(YEAR(TODAY()),1,23)","v":"2018-01-23"},null,{"$f":"IFERROR(IF(Buku[[#This Row],[TANGGAL PENGEMBALIAN]]=\"\",IF(Buku[[#This Row],[TANGGAL PEMINJAMAN]]<>\"\", TODAY()-Buku[[#This Row],[TANGGAL PEMINJAMAN]],\"\"),Buku[[#This Row],[TANGGAL PENGEMBALIAN]]-Buku[[#This Row],[TANGGAL PEMINJAMAN]]), \"\")","v":164}]
[{"$f":"IFERROR(((Buku[[#This Row],[TANGGAL PEMINJAMAN]]+JumlahHariPeminjaman)<TODAY())*(LEN(Buku[[#This Row],[TANGGAL PENGEMBALIAN]])=0)*(LEN(Buku[[#This Row],[TANGGAL PEMINJAMAN]])>0),0)","v":0},"Sinta Saraswati","seseorang@contoh.com","555-016","Crime and Punishment",{"$f":"TODAY()","v":"2018-07-06"},null,{"$f":"IFERROR(IF(Buku[[#This Row],[TANGGAL PENGEMBALIAN]]=\"\",IF(Buku[[#This Row],[TANGGAL PEMINJAMAN]]<>\"\", TODAY()-Buku[[#This Row],[TANGGAL PEMINJAMAN]],\"\"),Buku[[#This Row],[TANGGAL PENGEMBALIAN]]-Buku[[#This Row],[TANGGAL PEMINJAMAN]]), \"\")","v":0}]