{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["教師清單","清單資料"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"教師清單","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[0,1,0,2],[0,4,0,8],[2,9,6,9]]}
[null,"教師清單",null,"清單資料","此儲存格為 [狀態] 的色彩圖例：[尚未開始] 為內文樣式，[進行中] 為 R=91 G=133 B=49，[今天到期] 為 R=118 G=88 B=0，[保留] 為 R=109 G=66 B=111，[完成] 為刪除線、[取消] 為 R=191 G=191 B=191，而 [逾期] 為 R=191 G=33 B=28。"]
[null,"項目","類別","開始日","到期日","剩餘天數","狀態","附註"]
[null,"清理抽屜","辦公室",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,6)","v":"2018-04-06"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,16)","v":"2018-04-16"},{"$f":"IFERROR(IF(COUNT(清單[[#This Row],[開始日]]:清單[[#This Row],[到期日]])<>2,\"\",IF(OR(清單[[#This Row],[狀態]]=\"完成\",清單[[#This Row],[狀態]]=\"取消\",清單[[#This Row],[狀態]]=\"保留\"),\"\",清單[[#This Row],[到期日]]-TODAY())),\"\")","v":""},"完成",null,null,"此儲存格為狀態交叉分析篩選器。若要依據 [狀態] 篩選清單，請選取交叉分析篩選器中的狀態。按住 CTRL 可以選取多個選項。"]
[null,"訂購貼紙","辦公室用品",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,11)","v":"2018-04-11"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2018-04-21"},{"$f":"IFERROR(IF(COUNT(清單[[#This Row],[開始日]]:清單[[#This Row],[到期日]])<>2,\"\",IF(OR(清單[[#This Row],[狀態]]=\"完成\",清單[[#This Row],[狀態]]=\"取消\",清單[[#This Row],[狀態]]=\"保留\"),\"\",清單[[#This Row],[到期日]]-TODAY())),\"\")","v":""},"完成"]
[null,"拖地打蠟","其他",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()-1),DAY(TODAY())-25)","v":"2018-04-15"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,26)","v":"2018-04-26"},{"$f":"IFERROR(IF(COUNT(清單[[#This Row],[開始日]]:清單[[#This Row],[到期日]])<>2,\"\",IF(OR(清單[[#This Row],[狀態]]=\"完成\",清單[[#This Row],[狀態]]=\"取消\",清單[[#This Row],[狀態]]=\"保留\"),\"\",清單[[#This Row],[到期日]]-TODAY())),\"\")","v":""},"完成"]
[null,"製作姓名標籤","辦公室用品",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2018-04-21"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,1)","v":"2018-04-01"},{"$f":"IFERROR(IF(COUNT(清單[[#This Row],[開始日]]:清單[[#This Row],[到期日]])<>2,\"\",IF(OR(清單[[#This Row],[狀態]]=\"完成\",清單[[#This Row],[狀態]]=\"取消\",清單[[#This Row],[狀態]]=\"保留\"),\"\",清單[[#This Row],[到期日]]-TODAY())),\"\")","v":""},"保留"]
[null,"期中/期末書面報告評分","評量",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,26)","v":"2018-04-26"},{"$f":"TODAY()-5","v":"2018-05-05"},{"$f":"IFERROR(IF(COUNT(清單[[#This Row],[開始日]]:清單[[#This Row],[到期日]])<>2,\"\",IF(OR(清單[[#This Row],[狀態]]=\"完成\",清單[[#This Row],[狀態]]=\"取消\",清單[[#This Row],[狀態]]=\"保留\"),\"\",清單[[#This Row],[到期日]]-TODAY())),\"\")","v":-5},"逾期"]
[null,"同意書回條的電子郵件提醒","電話",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2018-05-01"},{"$f":"TODAY()","v":"2018-05-10"},{"$f":"IFERROR(IF(COUNT(清單[[#This Row],[開始日]]:清單[[#This Row],[到期日]])<>2,\"\",IF(OR(清單[[#This Row],[狀態]]=\"完成\",清單[[#This Row],[狀態]]=\"取消\",清單[[#This Row],[狀態]]=\"保留\"),\"\",清單[[#This Row],[到期日]]-TODAY())),\"\")","v":""},"取消"]
[null,"口頭報告評分","辦公室",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),7)","v":"2018-05-07"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),17)","v":"2018-05-17"},{"$f":"IFERROR(IF(COUNT(清單[[#This Row],[開始日]]:清單[[#This Row],[到期日]])<>2,\"\",IF(OR(清單[[#This Row],[狀態]]=\"完成\",清單[[#This Row],[狀態]]=\"取消\",清單[[#This Row],[狀態]]=\"保留\"),\"\",清單[[#This Row],[到期日]]-TODAY())),\"\")","v":7},"進行中"]
[null,"削鉛筆","辦公室用品",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),11)","v":"2018-05-11"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),10)","v":"2018-05-10"},{"$f":"IFERROR(IF(COUNT(清單[[#This Row],[開始日]]:清單[[#This Row],[到期日]])<>2,\"\",IF(OR(清單[[#This Row],[狀態]]=\"完成\",清單[[#This Row],[狀態]]=\"取消\",清單[[#This Row],[狀態]]=\"保留\"),\"\",清單[[#This Row],[到期日]]-TODAY())),\"\")","v":0},"進行中"]

{"sheet":"清單資料","index":1,"n_rows":13,"n_cols":3,"rows_kept":13}
[null,"清單資料","教師清單"]
[null,"類別"]
[null,"辦公室"]
[null,"辦公室用品"]
[null,"待購項目"]
[null,"電話"]
[null,"新想法"]
[null,"評量"]
[null,"團隊"]
[null,"介入"]
[null,"電腦"]
[null,"個人"]
[null,"其他"]