{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["図書館の書籍の貸出"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"図書館の書籍の貸出","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"merged":[[0,1,0,4],[0,5,0,6]]}
[null,"図書館の書籍の貸出シート",{"$nulls":3},"期限超過までの日数: ",null,10]
["期限超過","学生","連絡先のメール アドレス","連絡先電話番号","書籍のタイトル","貸出日付","返却日付","日数"]
[{"$f":"IFERROR(((書籍[[#This Row],[貸出日付]]+DayAllowance)<TODAY())*(LEN(書籍[[#This Row],[返却日付]])=0)*(LEN(書籍[[#This Row],[貸出日付]])>0),0)","v":0},"Maria Cameron","someone@example.com","555-0100","大草原の小さな家",{"$f":"DATE(YEAR(TODAY()),1,14)","v":"2018-01-14"},{"$f":"DATE(YEAR(TODAY()),1,21)","v":"2018-01-21"},{"$f":"IFERROR(IF(書籍[[#This Row],[返却日付]]=\"\",IF(書籍[[#This Row],[貸出日付]]<>\"\", TODAY()-書籍[[#This Row],[貸出日付]],\"\"),書籍[[#This Row],[返却日付]]-書籍[[#This Row],[貸出日付]]), \"\")","v":7}]
[{"$f":"IFERROR(((書籍[[#This Row],[貸出日付]]+DayAllowance)<TODAY())*(LEN(書籍[[#This Row],[返却日付]])=0)*(LEN(書籍[[#This Row],[貸出日付]])>0),0)","v":0},"Stephen Deming","someone@example.com","555-0101","シャーロットのおくりもの",{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2018-02-15"},{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2018-02-18"},{"$f":"IFERROR(IF(書籍[[#This Row],[返却日付]]=\"\",IF(書籍[[#This Row],[貸出日付]]<>\"\", TODAY()-書籍[[#This Row],[貸出日付]],\"\"),書籍[[#This Row],[返却日付]]-書籍[[#This Row],[貸出日付]]), \"\")","v":3}]
[{"$f":"IFERROR(((書籍[[#This Row],[貸出日付]]+DayAllowance)<TODAY())*(LEN(書籍[[#This Row],[返却日付]])=0)*(LEN(書籍[[#This Row],[貸出日付]])>0),0)","v":0},"Karel Florian","someone@example.com","555-0102","マイロのふしぎな冒険",{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),2,22)","v":"2018-02-22"},{"$f":"IFERROR(IF(書籍[[#This Row],[返却日付]]=\"\",IF(書籍[[#This Row],[貸出日付]]<>\"\", TODAY()-書籍[[#This Row],[貸出日付]],\"\"),書籍[[#This Row],[返却日付]]-書籍[[#This Row],[貸出日付]]), \"\")","v":5}]
[{"$f":"IFERROR(((書籍[[#This Row],[貸出日付]]+DayAllowance)<TODAY())*(LEN(書籍[[#This Row],[返却日付]])=0)*(LEN(書籍[[#This Row],[貸出日付]])>0),0)","v":0},"Scott Haberkorn","someone@example.com","555-0103","フリスビーおばさんとニムの家ねずみ",{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),2,25)","v":"2018-02-25"},{"$f":"IFERROR(IF(書籍[[#This Row],[返却日付]]=\"\",IF(書籍[[#This Row],[貸出日付]]<>\"\", TODAY()-書籍[[#This Row],[貸出日付]],\"\"),書籍[[#This Row],[返却日付]]-書籍[[#This Row],[貸出日付]]), \"\")","v":8}]
[{"$f":"IFERROR(((書籍[[#This Row],[貸出日付]]+DayAllowance)<TODAY())*(LEN(書籍[[#This Row],[返却日付]])=0)*(LEN(書籍[[#This Row],[貸出日付]])>0),0)","v":0},"Lola Jacobsen","someone@example.com","555-0104","マチルダは小さな大天才",{"$f":"DATE(YEAR(TODAY()),2,18)","v":"2018-02-18"},{"$f":"DATE(YEAR(TODAY()),2,28)","v":"2018-02-28"},{"$f":"IFERROR(IF(書籍[[#This Row],[返却日付]]=\"\",IF(書籍[[#This Row],[貸出日付]]<>\"\", TODAY()-書籍[[#This Row],[貸出日付]],\"\"),書籍[[#This Row],[返却日付]]-書籍[[#This Row],[貸出日付]]), \"\")","v":10}]
[{"$f":"IFERROR(((書籍[[#This Row],[貸出日付]]+DayAllowance)<TODAY())*(LEN(書籍[[#This Row],[返却日付]])=0)*(LEN(書籍[[#This Row],[貸出日付]])>0),0)","v":1},"Melissa Kerr","someone@example.com","555-0105","ナルニア国物語",{"$f":"DATE(YEAR(TODAY()),1,23)","v":"2018-01-23"},null,{"$f":"IFERROR(IF(書籍[[#This Row],[返却日付]]=\"\",IF(書籍[[#This Row],[貸出日付]]<>\"\", TODAY()-書籍[[#This Row],[貸出日付]],\"\"),書籍[[#This Row],[返却日付]]-書籍[[#This Row],[貸出日付]]), \"\")","v":162}]
[{"$f":"IFERROR(((書籍[[#This Row],[貸出日付]]+DayAllowance)<TODAY())*(LEN(書籍[[#This Row],[返却日付]])=0)*(LEN(書籍[[#This Row],[貸出日付]])>0),0)","v":0},"Sharon Salavaria","someone@example.com","555-0106","からすが池の魔女",{"$f":"TODAY()","v":"2018-07-04"},null,{"$f":"IFERROR(IF(書籍[[#This Row],[返却日付]]=\"\",IF(書籍[[#This Row],[貸出日付]]<>\"\", TODAY()-書籍[[#This Row],[貸出日付]],\"\"),書籍[[#This Row],[返却日付]]-書籍[[#This Row],[貸出日付]]), \"\")","v":0}]