{"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,"專案","類別","指派對象","預估\n開始","預估\n完成","預估工時 (小時)","預估工期 (天數)","實際\n開始","實際\n完成","落後/超前實際工時 (小時) 的旗幟圖示","實際工時 (小時)","落後/超前實際工期 (天數) 的旗幟圖示","實際工期 (天數)","附註"]
[null,"專案 1","類別 1","員工 1",{"$f":"TODAY()-65","v":"2016-08-14"},{"$f":"TODAY()-5","v":"2016-10-13"},210,{"$f":"IF(COUNTA(專案追蹤器!$E5,專案追蹤器!$F5)<>2,\"\",DAYS360(專案追蹤器!$E5,專案追蹤器!$F5,FALSE))","v":59},{"$f":"TODAY()-65","v":"2016-08-14"},{"$f":"TODAY()","v":"2016-10-18"},{"$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":"2016-09-07"},{"$f":"TODAY()-10","v":"2016-10-08"},400,{"$f":"IF(COUNTA(專案追蹤器!$E6,專案追蹤器!$F6)<>2,\"\",DAYS360(專案追蹤器!$E6,專案追蹤器!$F6,FALSE))","v":31},{"$f":"TODAY()-41","v":"2016-09-07"},{"$f":"TODAY()-7","v":"2016-10-11"},{"$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":"2016-07-10"},{"$f":"TODAY()-40","v":"2016-09-08"},500,{"$f":"IF(COUNTA(專案追蹤器!$E7,專案追蹤器!$F7)<>2,\"\",DAYS360(專案追蹤器!$E7,專案追蹤器!$F7,FALSE))","v":58},{"$f":"TODAY()-100","v":"2016-07-10"},{"$f":"TODAY()-27","v":"2016-09-21"},{"$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":71}]
[null,"專案 4","類別 2","員工 3",{"$f":"TODAY()-90","v":"2016-07-20"},{"$f":"TODAY()-80","v":"2016-07-30"},250,{"$f":"IF(COUNTA(專案追蹤器!$E8,專案追蹤器!$F8)<>2,\"\",DAYS360(專案追蹤器!$E8,專案追蹤器!$F8,FALSE))","v":10},{"$f":"TODAY()-90","v":"2016-07-20"},{"$f":"TODAY()-71","v":"2016-08-08"},{"$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":18}]
[null,"專案 5","類別 3","員工 2",{"$f":"TODAY()-90","v":"2016-07-20"},{"$f":"TODAY()-50","v":"2016-08-29"},300,{"$f":"IF(COUNTA(專案追蹤器!$E9,專案追蹤器!$F9)<>2,\"\",DAYS360(專案追蹤器!$E9,專案追蹤器!$F9,FALSE))","v":39},{"$f":"TODAY()-90","v":"2016-07-20"},{"$f":"TODAY()-44","v":"2016-09-04"},{"$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":44}]
[null,"專案 6","類別 4","員工 4",{"$f":"TODAY()-60","v":"2016-08-19"},{"$f":"TODAY()-50","v":"2016-08-29"},500,{"$f":"IF(COUNTA(專案追蹤器!$E10,專案追蹤器!$F10)<>2,\"\",DAYS360(專案追蹤器!$E10,專案追蹤器!$F10,FALSE))","v":10},{"$f":"TODAY()-60","v":"2016-08-19"},{"$f":"TODAY()-45","v":"2016-09-03"},{"$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":14}]
[null,"專案 7","類別 5","員工 1",{"$f":"TODAY()-44","v":"2016-09-04"},{"$f":"TODAY()-20","v":"2016-09-28"},750,{"$f":"IF(COUNTA(專案追蹤器!$E11,專案追蹤器!$F11)<>2,\"\",DAYS360(專案追蹤器!$E11,專案追蹤器!$F11,FALSE))","v":24},{"$f":"TODAY()-44","v":"2016-09-04"},{"$f":"TODAY()-15","v":"2016-10-03"},{"$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":"2016-09-09"},{"$f":"TODAY()","v":"2016-10-18"},450,{"$f":"IF(COUNTA(專案追蹤器!$E12,專案追蹤器!$F12)<>2,\"\",DAYS360(專案追蹤器!$E12,專案追蹤器!$F12,FALSE))","v":39},{"$f":"TODAY()-45","v":"2016-09-03"},{"$f":"TODAY()-5","v":"2016-10-13"},{"$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}
[null,"設定"]
[]
[]
[null,"類別名稱","員工名稱"]
[null,"類別 1","員工 1"]
[null,"類別 2","員工 2"]
[null,"類別 3","員工 3"]
[null,"類別 4","員工 4"]
[null,"類別 5","員工 5"]
[null,"類別 6","員工 6"]