{"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-16"},{"$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-06"},{"$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-11"},{"$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":6},"进行中"]
[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":-1},"进行中"]

{"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,"其他"]