{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["项目跟踪器","设置"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"项目跟踪器","index":0,"n_rows":13,"n_cols":15,"rows_kept":13}
[null,"项目跟踪器"]
[null,null,"要标记的超过/不足百分比： ",{"v":0.25,"d":"25%"}]
[]
[null,"项目","类别","责任人","估计开始","估计完成","估计工时（小时）","估计工期（天）","实际开始","实际完成","超过/不足实际工时​​（小时）的标记图标","实际工时（小时）","超过/不足实际工期​​（天）的标记图标","实际工期（天）","备注"]
[null,"项目 1","类别 1","员工 1",{"$f":"TODAY()-65","v":"2023-02-14"},{"$f":"TODAY()-5","v":"2023-04-15"},210,{"$f":"IF(COUNTA(项目跟踪器!$E5,项目跟踪器!$F5)<>2,\"\",DAYS360(项目跟踪器!$E5,项目跟踪器!$F5,FALSE))","v":61},{"$f":"TODAY()-65","v":"2023-02-14"},{"$f":"TODAY()","v":"2023-04-20"},{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工时（小时）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工时（小时）]]-ProjectTracker[[#This Row],[估计工时（小时）]])/ProjectTracker[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":1},300,{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工期（天）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工期（天）]]-ProjectTracker[[#This Row],[估计工期（天）]])/ProjectTracker[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(项目跟踪器!$I5,项目跟踪器!$J5)<>2,\"\",DAYS360(项目跟踪器!$I5,项目跟踪器!$J5,FALSE))","v":66}]
[null,"项目 2","类别 2","员工 4",{"$f":"TODAY()-41","v":"2023-03-10"},{"$f":"TODAY()-10","v":"2023-04-10"},400,{"$f":"IF(COUNTA(项目跟踪器!$E6,项目跟踪器!$F6)<>2,\"\",DAYS360(项目跟踪器!$E6,项目跟踪器!$F6,FALSE))","v":30},{"$f":"TODAY()-41","v":"2023-03-10"},{"$f":"TODAY()-7","v":"2023-04-13"},{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工时（小时）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工时（小时）]]-ProjectTracker[[#This Row],[估计工时（小时）]])/ProjectTracker[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},390,{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工期（天）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工期（天）]]-ProjectTracker[[#This Row],[估计工期（天）]])/ProjectTracker[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(项目跟踪器!$I6,项目跟踪器!$J6)<>2,\"\",DAYS360(项目跟踪器!$I6,项目跟踪器!$J6,FALSE))","v":33}]
[null,"项目 3","类别 1","员工 2",{"$f":"TODAY()-100","v":"2023-01-10"},{"$f":"TODAY()-40","v":"2023-03-11"},500,{"$f":"IF(COUNTA(项目跟踪器!$E7,项目跟踪器!$F7)<>2,\"\",DAYS360(项目跟踪器!$E7,项目跟踪器!$F7,FALSE))","v":61},{"$f":"TODAY()-100","v":"2023-01-10"},{"$f":"TODAY()-27","v":"2023-03-24"},{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工时（小时）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工时（小时）]]-ProjectTracker[[#This Row],[估计工时（小时）]])/ProjectTracker[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},500,{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工期（天）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工期（天）]]-ProjectTracker[[#This Row],[估计工期（天）]])/ProjectTracker[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(项目跟踪器!$I7,项目跟踪器!$J7)<>2,\"\",DAYS360(项目跟踪器!$I7,项目跟踪器!$J7,FALSE))","v":74}]
[null,"项目 4","类别 2","员工 3",{"$f":"TODAY()-90","v":"2023-01-20"},{"$f":"TODAY()-80","v":"2023-01-30"},250,{"$f":"IF(COUNTA(项目跟踪器!$E8,项目跟踪器!$F8)<>2,\"\",DAYS360(项目跟踪器!$E8,项目跟踪器!$F8,FALSE))","v":10},{"$f":"TODAY()-90","v":"2023-01-20"},{"$f":"TODAY()-71","v":"2023-02-08"},{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工时（小时）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工时（小时）]]-ProjectTracker[[#This Row],[估计工时（小时）]])/ProjectTracker[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},276,{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工期（天）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工期（天）]]-ProjectTracker[[#This Row],[估计工期（天）]])/ProjectTracker[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":1},{"$f":"IF(COUNTA(项目跟踪器!$I8,项目跟踪器!$J8)<>2,\"\",DAYS360(项目跟踪器!$I8,项目跟踪器!$J8,FALSE))","v":18}]
[null,"项目 5","类别 3","员工 2",{"$f":"TODAY()-90","v":"2023-01-20"},{"$f":"TODAY()-50","v":"2023-03-01"},300,{"$f":"IF(COUNTA(项目跟踪器!$E9,项目跟踪器!$F9)<>2,\"\",DAYS360(项目跟踪器!$E9,项目跟踪器!$F9,FALSE))","v":41},{"$f":"TODAY()-90","v":"2023-01-20"},{"$f":"TODAY()-44","v":"2023-03-07"},{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工时（小时）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工时（小时）]]-ProjectTracker[[#This Row],[估计工时（小时）]])/ProjectTracker[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},310,{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工期（天）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工期（天）]]-ProjectTracker[[#This Row],[估计工期（天）]])/ProjectTracker[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(项目跟踪器!$I9,项目跟踪器!$J9)<>2,\"\",DAYS360(项目跟踪器!$I9,项目跟踪器!$J9,FALSE))","v":47}]
[null,"项目 6","类别 4","员工 4",{"$f":"TODAY()-60","v":"2023-02-19"},{"$f":"TODAY()-50","v":"2023-03-01"},500,{"$f":"IF(COUNTA(项目跟踪器!$E10,项目跟踪器!$F10)<>2,\"\",DAYS360(项目跟踪器!$E10,项目跟踪器!$F10,FALSE))","v":12},{"$f":"TODAY()-60","v":"2023-02-19"},{"$f":"TODAY()-45","v":"2023-03-06"},{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工时（小时）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工时（小时）]]-ProjectTracker[[#This Row],[估计工时（小时）]])/ProjectTracker[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},510,{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工期（天）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工期（天）]]-ProjectTracker[[#This Row],[估计工期（天）]])/ProjectTracker[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":1},{"$f":"IF(COUNTA(项目跟踪器!$I10,项目跟踪器!$J10)<>2,\"\",DAYS360(项目跟踪器!$I10,项目跟踪器!$J10,FALSE))","v":17}]
[null,"项目 7","类别 5","员工 1",{"$f":"TODAY()-44","v":"2023-03-07"},{"$f":"TODAY()-20","v":"2023-03-31"},750,{"$f":"IF(COUNTA(项目跟踪器!$E11,项目跟踪器!$F11)<>2,\"\",DAYS360(项目跟踪器!$E11,项目跟踪器!$F11,FALSE))","v":24},{"$f":"TODAY()-44","v":"2023-03-07"},{"$f":"TODAY()-15","v":"2023-04-05"},{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工时（小时）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工时（小时）]]-ProjectTracker[[#This Row],[估计工时（小时）]])/ProjectTracker[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},790,{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工期（天）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工期（天）]]-ProjectTracker[[#This Row],[估计工期（天）]])/ProjectTracker[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(项目跟踪器!$I11,项目跟踪器!$J11)<>2,\"\",DAYS360(项目跟踪器!$I11,项目跟踪器!$J11,FALSE))","v":28}]
[null,"项目 8","类别 2","员工 1",{"$f":"TODAY()-39","v":"2023-03-12"},{"$f":"TODAY()","v":"2023-04-20"},450,{"$f":"IF(COUNTA(项目跟踪器!$E12,项目跟踪器!$F12)<>2,\"\",DAYS360(项目跟踪器!$E12,项目跟踪器!$F12,FALSE))","v":38},{"$f":"TODAY()-45","v":"2023-03-06"},{"$f":"TODAY()-5","v":"2023-04-15"},{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工时（小时）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工时（小时）]]-ProjectTracker[[#This Row],[估计工时（小时）]])/ProjectTracker[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},430,{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工期（天）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工期（天）]]-ProjectTracker[[#This Row],[估计工期（天）]])/ProjectTracker[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(项目跟踪器!$I12,项目跟踪器!$J12)<>2,\"\",DAYS360(项目跟踪器!$I12,项目跟踪器!$J12,FALSE))","v":39}]
[null,"项目 9","类别 4","员工 1","2016-02-05","2016-06-09",250,{"$f":"IF(COUNTA(项目跟踪器!$E13,项目跟踪器!$F13)<>2,\"\",DAYS360(项目跟踪器!$E13,项目跟踪器!$F13,FALSE))","v":124},"2016-03-05","2016-05-05",{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工时（小时）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工时（小时）]]-ProjectTracker[[#This Row],[估计工时（小时）]])/ProjectTracker[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},200,{"$f":"IFERROR(IF(ProjectTracker[[#This Row],[实际工期（天）]]=0,\"\",IF(ABS((ProjectTracker[[#This Row],[实际工期（天）]]-ProjectTracker[[#This Row],[估计工期（天）]])/ProjectTracker[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":1},{"$f":"IF(COUNTA(项目跟踪器!$I13,项目跟踪器!$J13)<>2,\"\",DAYS360(项目跟踪器!$I13,项目跟踪器!$J13,FALSE))","v":60}]

{"sheet":"设置","index":1,"n_rows":10,"n_cols":3,"rows_kept":10}
[null,"设置"]
[]
[]
[null,"类别名称","员工姓名"]
[null,"类别 1","员工 1"]
[null,"类别 2","员工 2"]
[null,"类别 3","员工 3"]
[null,"类别 4","员工 4"]
[null,"类别 5","员工 5"]
[null,"类别 6","员工 6"]