{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["待辦事項清單"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"待辦事項清單","index":0,"n_rows":7,"n_cols":9,"rows_kept":7,"merged":[[1,1,1,8]]}
[{"$nulls":8},{"$f":"YEAR(TODAY())","v":2017}]
[null,"待辦事項清單"]
[null,"工作","優先順序 ","狀態 ","開始日期 ","到期日 ","完成百分比","完成/逾期？","備註"]
[null,"工作 1","一般","尚未開始",{"$f":"DATE(行事曆_年份, 11, 29)","v":"2017-11-29"},{"$f":"待辦事項清單[[#This Row],[開始日期 ]]+9","v":"2017-12-08"},{"v":0,"d":"0%"},{"$f":"IF(AND(待辦事項清單[[#This Row],[狀態 ]]=\"完成\",待辦事項清單[[#This Row],[完成百分比]]=1),1,IF(ISBLANK(待辦事項清單[[#This Row],[到期日 ]]),-1,IF(AND(待辦事項清單[[#This Row],[狀態 ]]<>\"完成\",TODAY()>待辦事項清單[[#This Row],[到期日 ]]),0,-1)))","v":-1}]
[null,"工作 2","高","完成",{"$f":"DATE(行事曆_年份, 11, 19)","v":"2017-11-19"},{"$f":"待辦事項清單[[#This Row],[開始日期 ]]+30","v":"2017-12-19"},{"v":1,"d":"100%"},{"$f":"IF(AND(待辦事項清單[[#This Row],[狀態 ]]=\"完成\",待辦事項清單[[#This Row],[完成百分比]]=1),1,IF(ISBLANK(待辦事項清單[[#This Row],[到期日 ]]),-1,IF(AND(待辦事項清單[[#This Row],[狀態 ]]<>\"完成\",TODAY()>待辦事項清單[[#This Row],[到期日 ]]),0,-1)))","v":1}]
[null,"工作 3","低","進行中",{"$f":"DATE(行事曆_年份, 11, 9)","v":"2017-11-09"},{"$f":"待辦事項清單[[#This Row],[開始日期 ]]+45","v":"2017-12-24"},{"v":0.5,"d":"50%"},{"$f":"IF(AND(待辦事項清單[[#This Row],[狀態 ]]=\"完成\",待辦事項清單[[#This Row],[完成百分比]]=1),1,IF(ISBLANK(待辦事項清單[[#This Row],[到期日 ]]),-1,IF(AND(待辦事項清單[[#This Row],[狀態 ]]<>\"完成\",TODAY()>待辦事項清單[[#This Row],[到期日 ]]),0,-1)))","v":-1}]
[null,"工作 4","一般","尚未開始",{"$f":"DATE(行事曆_年份, 12, 29)","v":"2017-12-29"},{"$f":"待辦事項清單[[#This Row],[開始日期 ]]+55","v":"2018-02-22"},{"v":0,"d":"0%"},{"$f":"IF(AND(待辦事項清單[[#This Row],[狀態 ]]=\"完成\",待辦事項清單[[#This Row],[完成百分比]]=1),1,IF(ISBLANK(待辦事項清單[[#This Row],[到期日 ]]),-1,IF(AND(待辦事項清單[[#This Row],[狀態 ]]<>\"完成\",TODAY()>待辦事項清單[[#This Row],[到期日 ]]),0,-1)))","v":-1}]