{"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],[出借日期]]+允许的出借天数)<TODAY())*(LEN(书籍[[#This Row],[还书日期]])=0)*(LEN(书籍[[#This Row],[出借日期]])>0),0)","v":0},"柏隼","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],[出借日期]]+允许的出借天数)<TODAY())*(LEN(书籍[[#This Row],[还书日期]])=0)*(LEN(书籍[[#This Row],[出借日期]])>0),0)","v":0},"何石","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],[出借日期]]+允许的出借天数)<TODAY())*(LEN(书籍[[#This Row],[还书日期]])=0)*(LEN(书籍[[#This Row],[出借日期]])>0),0)","v":0},"孔西明","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],[出借日期]]+允许的出借天数)<TODAY())*(LEN(书籍[[#This Row],[还书日期]])=0)*(LEN(书籍[[#This Row],[出借日期]])>0),0)","v":0},"翁捷生","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],[出借日期]]+允许的出借天数)<TODAY())*(LEN(书籍[[#This Row],[还书日期]])=0)*(LEN(书籍[[#This Row],[出借日期]])>0),0)","v":0},"康霓","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],[出借日期]]+允许的出借天数)<TODAY())*(LEN(书籍[[#This Row],[还书日期]])=0)*(LEN(书籍[[#This Row],[出借日期]])>0),0)","v":1},"茅彩","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],[出借日期]]+允许的出借天数)<TODAY())*(LEN(书籍[[#This Row],[还书日期]])=0)*(LEN(书籍[[#This Row],[出借日期]])>0),0)","v":0},"林媚卉","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}]