{"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}]