{"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 ADDRESS","CONTACT PHONE NUMBER","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},"Lucy Brown","someone@example.com","0121 496 0123","Little House on the Prairie",{"$f":"DATE(YEAR(TODAY()),1,14)","v":"2018-01-14"},{"$f":"DATE(YEAR(TODAY()),1,21)","v":"2018-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},"Ben Miller","someone@example.com","0121 496 0234","Charlotte’s Web",{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2018-02-15"},{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2018-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},"Greg Smith","someone@example.com","0121 496 0345","The Phantom Tollbooth",{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),2,22)","v":"2018-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},"Sam Andrews","someone@example.com","0121 496 0456","Mrs Frisby and the Rats of Nimh",{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),2,25)","v":"2018-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},"Holly Jacobs","someone@example.com","0121 496 0567","Matilda",{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2018-02-18"},{"$f":"DATE(YEAR(TODAY()),2,28)","v":"2018-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},"Sarah Davis","someone@example.com","0121 496 0678","The Chronicles of Narnia",{"$f":"DATE(YEAR(TODAY()),1,23)","v":"2018-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":164}]
[{"$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},"Melissa Cooper","someone@example.com","0121 496 0789","The Witch of Blackbird Pond",{"$f":"TODAY()","v":"2018-07-06"},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}]