{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Library book checkout"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Library book checkout","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"merged":[[0,1,0,4],[0,5,0,6]]}
[null,"Library book checkout sheet",{"$nulls":3},"DAYS UNTIL OVERDUE: ",null,10]
["Overdue","STUDENT","CONTACT EMAIL","CONTACT PHONE","BOOK TITLE","DATE BORROWED","DATE RETURNED","DAYS"]
[{"$f":"IFERROR(((Books[[#This Row],[DATE BORROWED]]+DayAllowance)<TODAY())*(LEN(Books[[#This Row],[DATE RETURNED]])=0)*(LEN(Books[[#This Row],[DATE BORROWED]])>0),0)","v":0},"Maria Cameron","maria@example.com","555-0100","Fiction novel",{"$f":"DATE(YEAR(TODAY()),1,14)","v":"2022-01-14"},{"$f":"DATE(YEAR(TODAY()),1,21)","v":"2022-01-21"},{"$f":"IFERROR(IF(Books[[#This Row],[DATE RETURNED]]=\"\",IF(Books[[#This Row],[DATE BORROWED]]<>\"\", TODAY()-Books[[#This Row],[DATE BORROWED]],\"\"),Books[[#This Row],[DATE RETURNED]]-Books[[#This Row],[DATE BORROWED]]), \"\")","v":7}]
[{"$f":"IFERROR(((Books[[#This Row],[DATE BORROWED]]+DayAllowance)<TODAY())*(LEN(Books[[#This Row],[DATE RETURNED]])=0)*(LEN(Books[[#This Row],[DATE BORROWED]])>0),0)","v":0},"Stephen Deming","stephen@example.com","555-0101","Autobiography",{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2022-02-15"},{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2022-02-18"},{"$f":"IFERROR(IF(Books[[#This Row],[DATE RETURNED]]=\"\",IF(Books[[#This Row],[DATE BORROWED]]<>\"\", TODAY()-Books[[#This Row],[DATE BORROWED]],\"\"),Books[[#This Row],[DATE RETURNED]]-Books[[#This Row],[DATE BORROWED]]), \"\")","v":3}]
[{"$f":"IFERROR(((Books[[#This Row],[DATE BORROWED]]+DayAllowance)<TODAY())*(LEN(Books[[#This Row],[DATE RETURNED]])=0)*(LEN(Books[[#This Row],[DATE BORROWED]])>0),0)","v":0},"Karel Florian","karel@example.com","555-0102","Science & technology textbook",{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2022-02-17"},{"$f":"DATE(YEAR(TODAY()),2,22)","v":"2022-02-22"},{"$f":"IFERROR(IF(Books[[#This Row],[DATE RETURNED]]=\"\",IF(Books[[#This Row],[DATE BORROWED]]<>\"\", TODAY()-Books[[#This Row],[DATE BORROWED]],\"\"),Books[[#This Row],[DATE RETURNED]]-Books[[#This Row],[DATE BORROWED]]), \"\")","v":5}]
[{"$f":"IFERROR(((Books[[#This Row],[DATE BORROWED]]+DayAllowance)<TODAY())*(LEN(Books[[#This Row],[DATE RETURNED]])=0)*(LEN(Books[[#This Row],[DATE BORROWED]])>0),0)","v":0},"Scott Haberkorn","scott@example.com","555-0103","Math textbook",{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2022-02-17"},{"$f":"DATE(YEAR(TODAY()),2,25)","v":"2022-02-25"},{"$f":"IFERROR(IF(Books[[#This Row],[DATE RETURNED]]=\"\",IF(Books[[#This Row],[DATE BORROWED]]<>\"\", TODAY()-Books[[#This Row],[DATE BORROWED]],\"\"),Books[[#This Row],[DATE RETURNED]]-Books[[#This Row],[DATE BORROWED]]), \"\")","v":8}]
[{"$f":"IFERROR(((Books[[#This Row],[DATE BORROWED]]+DayAllowance)<TODAY())*(LEN(Books[[#This Row],[DATE RETURNED]])=0)*(LEN(Books[[#This Row],[DATE BORROWED]])>0),0)","v":0},"Lola Jacobsen","lola@example.com","555-0104","Fiction novel",{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2022-02-18"},{"$f":"DATE(YEAR(TODAY()),2,28)","v":"2022-02-28"},{"$f":"IFERROR(IF(Books[[#This Row],[DATE RETURNED]]=\"\",IF(Books[[#This Row],[DATE BORROWED]]<>\"\", TODAY()-Books[[#This Row],[DATE BORROWED]],\"\"),Books[[#This Row],[DATE RETURNED]]-Books[[#This Row],[DATE BORROWED]]), \"\")","v":10}]
[{"$f":"IFERROR(((Books[[#This Row],[DATE BORROWED]]+DayAllowance)<TODAY())*(LEN(Books[[#This Row],[DATE RETURNED]])=0)*(LEN(Books[[#This Row],[DATE BORROWED]])>0),0)","v":1},"Melissa Kerr","melissa@example.com","555-0105","Fiction novel",{"$f":"DATE(YEAR(TODAY()),1,23)","v":"2022-01-23"},null,{"$f":"IFERROR(IF(Books[[#This Row],[DATE RETURNED]]=\"\",IF(Books[[#This Row],[DATE BORROWED]]<>\"\", TODAY()-Books[[#This Row],[DATE BORROWED]],\"\"),Books[[#This Row],[DATE RETURNED]]-Books[[#This Row],[DATE BORROWED]]), \"\")","v":291}]
[{"$f":"IFERROR(((Books[[#This Row],[DATE BORROWED]]+DayAllowance)<TODAY())*(LEN(Books[[#This Row],[DATE RETURNED]])=0)*(LEN(Books[[#This Row],[DATE BORROWED]])>0),0)","v":0},"Sharon Salavaria","sharon@example.com","555-0106","Periodicals",{"$f":"TODAY()","v":"2022-11-10"},null,{"$f":"IFERROR(IF(Books[[#This Row],[DATE RETURNED]]=\"\",IF(Books[[#This Row],[DATE BORROWED]]<>\"\", TODAY()-Books[[#This Row],[DATE BORROWED]],\"\"),Books[[#This Row],[DATE RETURNED]]-Books[[#This Row],[DATE BORROWED]]), \"\")","v":0}]