{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["项目跟踪器","设置"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"项目跟踪器","index":0,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"项目跟踪器"]
[null,null,"要标记的超过/不足百分比： ",0.25]
[]
[null,"项目","类别","责任人","估计\n开始","估计\n完成","估计工时（小时）","估计工期（天）","实际\n开始","实际\n完成","超过/不足实际工时​​（小时）的标记图标","实际工时（小时）","超过/不足实际工期​​（天）的标记图标","实际工期（天）","备注"]
[null,"项目 1","类别 1","员工 1",{"$f":"TODAY()-65","v":"2017-10-11"},{"$f":"TODAY()-5","v":"2017-12-10"},210,{"$f":"IF(COUNTA(项目跟踪器!$E5,项目跟踪器!$F5)<>2,\"\",DAYS360(项目跟踪器!$E5,项目跟踪器!$F5,FALSE))","v":59},{"$f":"TODAY()-65","v":"2017-10-11"},{"$f":"TODAY()","v":"2017-12-15"},{"$f":"IFERROR(IF(项目跟踪器[实际工时（小时）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工时（小时）]]-项目跟踪器[[#This Row],[估计工时（小时）]])/项目跟踪器[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":1},300,{"$f":"IFERROR(IF(项目跟踪器[实际工期（天）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工期（天）]]-项目跟踪器[[#This Row],[估计工期（天）]])/项目跟踪器[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(项目跟踪器!$I5,项目跟踪器!$J5)<>2,\"\",DAYS360(项目跟踪器!$I5,项目跟踪器!$J5,FALSE))","v":64}]
[null,"项目 2","类别 2","员工 4",{"$f":"TODAY()-41","v":"2017-11-04"},{"$f":"TODAY()-10","v":"2017-12-05"},400,{"$f":"IF(COUNTA(项目跟踪器!$E6,项目跟踪器!$F6)<>2,\"\",DAYS360(项目跟踪器!$E6,项目跟踪器!$F6,FALSE))","v":31},{"$f":"TODAY()-41","v":"2017-11-04"},{"$f":"TODAY()-7","v":"2017-12-08"},{"$f":"IFERROR(IF(项目跟踪器[实际工时（小时）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工时（小时）]]-项目跟踪器[[#This Row],[估计工时（小时）]])/项目跟踪器[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},390,{"$f":"IFERROR(IF(项目跟踪器[实际工期（天）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工期（天）]]-项目跟踪器[[#This Row],[估计工期（天）]])/项目跟踪器[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(项目跟踪器!$I6,项目跟踪器!$J6)<>2,\"\",DAYS360(项目跟踪器!$I6,项目跟踪器!$J6,FALSE))","v":34}]
[null,"项目 3","类别 1","员工 2",{"$f":"TODAY()-100","v":"2017-09-06"},{"$f":"TODAY()-40","v":"2017-11-05"},500,{"$f":"IF(COUNTA(项目跟踪器!$E7,项目跟踪器!$F7)<>2,\"\",DAYS360(项目跟踪器!$E7,项目跟踪器!$F7,FALSE))","v":59},{"$f":"TODAY()-100","v":"2017-09-06"},{"$f":"TODAY()-27","v":"2017-11-18"},{"$f":"IFERROR(IF(项目跟踪器[实际工时（小时）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工时（小时）]]-项目跟踪器[[#This Row],[估计工时（小时）]])/项目跟踪器[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},500,{"$f":"IFERROR(IF(项目跟踪器[实际工期（天）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工期（天）]]-项目跟踪器[[#This Row],[估计工期（天）]])/项目跟踪器[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(项目跟踪器!$I7,项目跟踪器!$J7)<>2,\"\",DAYS360(项目跟踪器!$I7,项目跟踪器!$J7,FALSE))","v":72}]
[null,"项目 4","类别 2","员工 3",{"$f":"TODAY()-90","v":"2017-09-16"},{"$f":"TODAY()-80","v":"2017-09-26"},250,{"$f":"IF(COUNTA(项目跟踪器!$E8,项目跟踪器!$F8)<>2,\"\",DAYS360(项目跟踪器!$E8,项目跟踪器!$F8,FALSE))","v":10},{"$f":"TODAY()-90","v":"2017-09-16"},{"$f":"TODAY()-71","v":"2017-10-05"},{"$f":"IFERROR(IF(项目跟踪器[实际工时（小时）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工时（小时）]]-项目跟踪器[[#This Row],[估计工时（小时）]])/项目跟踪器[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},276,{"$f":"IFERROR(IF(项目跟踪器[实际工期（天）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工期（天）]]-项目跟踪器[[#This Row],[估计工期（天）]])/项目跟踪器[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":1},{"$f":"IF(COUNTA(项目跟踪器!$I8,项目跟踪器!$J8)<>2,\"\",DAYS360(项目跟踪器!$I8,项目跟踪器!$J8,FALSE))","v":19}]
[null,"项目 5","类别 3","员工 2",{"$f":"TODAY()-90","v":"2017-09-16"},{"$f":"TODAY()-50","v":"2017-10-26"},300,{"$f":"IF(COUNTA(项目跟踪器!$E9,项目跟踪器!$F9)<>2,\"\",DAYS360(项目跟踪器!$E9,项目跟踪器!$F9,FALSE))","v":40},{"$f":"TODAY()-90","v":"2017-09-16"},{"$f":"TODAY()-44","v":"2017-11-01"},{"$f":"IFERROR(IF(项目跟踪器[实际工时（小时）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工时（小时）]]-项目跟踪器[[#This Row],[估计工时（小时）]])/项目跟踪器[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},310,{"$f":"IFERROR(IF(项目跟踪器[实际工期（天）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工期（天）]]-项目跟踪器[[#This Row],[估计工期（天）]])/项目跟踪器[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(项目跟踪器!$I9,项目跟踪器!$J9)<>2,\"\",DAYS360(项目跟踪器!$I9,项目跟踪器!$J9,FALSE))","v":45}]
[null,"项目 6","类别 4","员工 4",{"$f":"TODAY()-60","v":"2017-10-16"},{"$f":"TODAY()-50","v":"2017-10-26"},500,{"$f":"IF(COUNTA(项目跟踪器!$E10,项目跟踪器!$F10)<>2,\"\",DAYS360(项目跟踪器!$E10,项目跟踪器!$F10,FALSE))","v":10},{"$f":"TODAY()-60","v":"2017-10-16"},{"$f":"TODAY()-45","v":"2017-10-31"},{"$f":"IFERROR(IF(项目跟踪器[实际工时（小时）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工时（小时）]]-项目跟踪器[[#This Row],[估计工时（小时）]])/项目跟踪器[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},510,{"$f":"IFERROR(IF(项目跟踪器[实际工期（天）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工期（天）]]-项目跟踪器[[#This Row],[估计工期（天）]])/项目跟踪器[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":1},{"$f":"IF(COUNTA(项目跟踪器!$I10,项目跟踪器!$J10)<>2,\"\",DAYS360(项目跟踪器!$I10,项目跟踪器!$J10,FALSE))","v":15}]
[null,"项目 7","类别 5","员工 1",{"$f":"TODAY()-44","v":"2017-11-01"},{"$f":"TODAY()-20","v":"2017-11-25"},750,{"$f":"IF(COUNTA(项目跟踪器!$E11,项目跟踪器!$F11)<>2,\"\",DAYS360(项目跟踪器!$E11,项目跟踪器!$F11,FALSE))","v":24},{"$f":"TODAY()-44","v":"2017-11-01"},{"$f":"TODAY()-15","v":"2017-11-30"},{"$f":"IFERROR(IF(项目跟踪器[实际工时（小时）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工时（小时）]]-项目跟踪器[[#This Row],[估计工时（小时）]])/项目跟踪器[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},790,{"$f":"IFERROR(IF(项目跟踪器[实际工期（天）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工期（天）]]-项目跟踪器[[#This Row],[估计工期（天）]])/项目跟踪器[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(项目跟踪器!$I11,项目跟踪器!$J11)<>2,\"\",DAYS360(项目跟踪器!$I11,项目跟踪器!$J11,FALSE))","v":29}]
[null,"项目 8","类别 2","员工 1",{"$f":"TODAY()-39","v":"2017-11-06"},{"$f":"TODAY()","v":"2017-12-15"},450,{"$f":"IF(COUNTA(项目跟踪器!$E12,项目跟踪器!$F12)<>2,\"\",DAYS360(项目跟踪器!$E12,项目跟踪器!$F12,FALSE))","v":39},{"$f":"TODAY()-45","v":"2017-10-31"},{"$f":"TODAY()-5","v":"2017-12-10"},{"$f":"IFERROR(IF(项目跟踪器[实际工时（小时）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工时（小时）]]-项目跟踪器[[#This Row],[估计工时（小时）]])/项目跟踪器[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},430,{"$f":"IFERROR(IF(项目跟踪器[实际工期（天）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工期（天）]]-项目跟踪器[[#This Row],[估计工期（天）]])/项目跟踪器[[#This Row],[估计工期（天）]])>FlagPercent,1,0)),\"\")","v":0},{"$f":"IF(COUNTA(项目跟踪器!$I12,项目跟踪器!$J12)<>2,\"\",DAYS360(项目跟踪器!$I12,项目跟踪器!$J12,FALSE))","v":40}]
[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(项目跟踪器[实际工时（小时）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工时（小时）]]-项目跟踪器[[#This Row],[估计工时（小时）]])/项目跟踪器[[#This Row],[估计工时（小时）]])>FlagPercent,1,0)),\"\")","v":0},200,{"$f":"IFERROR(IF(项目跟踪器[实际工期（天）]=0,\"\",IF(ABS((项目跟踪器[[#This Row],[实际工期（天）]]-项目跟踪器[[#This Row],[估计工期（天）]])/项目跟踪器[[#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,"cut":false,"hidden":false,"merged":[]}
[null,"设置"]
[]
[]
[null,"类别名称","员工姓名"]
[null,"类别 1","员工 1"]
[null,"类别 2","员工 2"]
[null,"类别 3","员工 3"]
[null,"类别 4","员工 4"]
[null,"类别 5","员工 5"]
[null,"类别 6","员工 6"]