進捗管理(MATCHワークシート関数サンプル)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXY
1
作業項目担当者見積工数進捗残工数進捗初期値2016/09/012016/09/022016/09/032016/09/042016/09/052016/09/062016/09/07
2
3
作業1A1.001.01.0001.0
4
作業2B1.001.01.0000.51.0
5
作業3C2.000.51.0000.5
6
作業4A0.500.50.2500.5
7
作業5A0.501.00.5000.51.0
8
作業6B0.501.00.5001.0
9
作業7B0.500.50.2500.5
10
作業8C1.500.50.7501.0
11
12
13
A2.0083.33%1.75
14
B2.0050.00%1.75
15
C3.5050.00%1.75
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
シート1