[1C Việt Nam] Quản lý timeline công việc.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	PROJECT TIMELINE
2								{42}
3														Project Start	1/1/17			columns used to create the chart
4													CATEGORY	TASK	START	END	COLOR	Start	Blue	Red	Green	Brown	Orange	Purple
5
6													Concept Dev.	Market Analysis	1/1/17	1/15/17	Blue	1/1/17	0	0	0	0	0	0
7														Feasibility	1/15/17	2/5/17	Blue	1/15/17	0	0	0	0	0	0
8														Rough Prototypes	2/6/17	2/26/17	Blue	2/6/17	0	0	0	0	0	0
9														Cost Estimates	1/20/17	3/1/17	Blue	1/20/17	0	0	0	0	0	0
10													System Design	Architectures	2/1/17	2/15/17	Red	2/1/17	0	0	0	0	0	0
11														Sub-systems	2/5/17	2/22/17	Red	2/5/17	0	0	0	0	0	0
12														Refine Design	2/23/17	3/5/17	Red	2/23/17	0	0	0	0	0	0
13														Make-buy analysis	3/6/17	3/9/17	Red	3/6/17	0	0	0	0	0	0
14													Detail Design	Complete Definition	3/10/17	4/9/17	Green	3/10/17	0	0	0	0	0	0
15														Materials	3/10/17	3/20/17	Green	3/10/17	0	0	0	0	0	0
16														Tooling	3/20/17	4/9/17	Green	3/20/17	0	0	0	0	0	0
17														Quality Control Def.	4/10/17	4/15/17	Green	4/10/17	0	0	0	0	0	0
18													Test & Refine	Field Testing	3/20/17	4/4/17	Brown	3/20/17	0	0	0	0	0	0
19														Regulations	3/20/17	4/19/17	Brown	3/20/17	0	0	0	0	0	0
20														Refine Processes	4/5/17	4/20/17	Brown	4/5/17	0	0	0	0	0	0
21													Produce	Key Customers	4/21/17	4/26/17	Orange	4/21/17	0	0	0	0	0	0
22														Evaluate	4/21/17	5/2/17	Orange	4/21/17	0	0	0	0	0	0
23														Begin Full Production	5/3/17	5/3/17	Orange	5/3/17	0	0	0	0	0	0
24													Other	Economic Analysis	1/1/17	2/28/17	Purple	1/1/17	0	0	0	0	0	0
25														Legal / Regulatory	1/1/17	4/19/17	Purple	1/1/17	0	0	0	0	0	0
26														Sales Plan / Train	3/1/17	4/29/17	Purple	3/1/17	0	0	0	0	0	0
27															Insert new rows above this one
28
29
30		Project Start	1/1/17			columns used to create the chart
31	CATEGORY	TASK	START	END	COLOR	Start	Blue	Red	Green	Brown	Orange	Purple		MILESTONE LABEL	DATE	Margin Bottom	Margin Top
33	Concept Dev.	Market Analysis	1/1/17	1/15/17	Blue	1/1/17	15	0	0	0	0	0		Milestone 2	4/1/17	25%	95%
34		Feasibility	1/15/17	2/5/17	Blue	1/15/17	22	0	0	0	0	0		Milestone 3	5/4/17	10%	95%
35		Rough Prototypes	2/6/17	2/26/17	Blue	2/6/17	21	0	0	0	0	0		Milestone 4		30%	95%
36		Cost Estimates	1/20/17	3/1/17	Blue	1/20/17	41	0	0	0	0	0
37	System Design	Architectures	2/1/17	2/15/17	Red	2/1/17	0	15	0	0	0	0
38		Sub-systems	2/5/17	2/22/17	Red	2/5/17	0	18	0	0	0	0
39		Refine Design	2/23/17	3/5/17	Red	2/23/17	0	11	0	0	0	0
40		Make-buy analysis	3/6/17	3/9/17	Red	3/6/17	0	4	0	0	0	0
41	Detail Design	Complete Definition	3/10/17	4/9/17	Green	3/10/17	0	0	31	0	0	0
42		Materials	3/10/17	3/20/17	Green	3/10/17	0	0	11	0	0	0
43		Tooling	3/20/17	4/9/17	Green	3/20/17	0	0	21	0	0	0
44		Quality Control Def.	4/10/17	4/15/17	Green	4/10/17	0	0	6	0	0	0
45	Test & Refine	Field Testing	3/20/17	4/4/17	Brown	3/20/17	0	0	0	16	0	0
46		Regulations	3/20/17	4/19/17	Brown	3/20/17	0	0	0	31	0	0
47		Refine Processes	4/5/17	4/20/17	Brown	4/5/17	0	0	0	16	0	0
48	Produce	Key Customers	4/21/17	4/26/17	Orange	4/21/17	0	0	0	0	6	0
49		Evaluate	4/21/17	5/2/17	Orange	4/21/17	0	0	0	0	12	0
50		Begin Full Production	5/3/17	5/3/17	Orange	5/3/17	0	0	0	0	1	0
51	Other	Economic Analysis	1/1/17	2/28/17	Purple	1/1/17	0	0	0	0	0	59
52		Legal / Regulatory	1/1/17	4/19/17	Purple	1/1/17	0	0	0	0	0	109
53		Sales Plan / Train	3/1/17	4/29/17	Purple	3/1/17	0	0	0	0	0	60
54			Insert new rows above this one
55
56
57
58		MILESTONE LABEL	DATE	Margin Bottom	Margin Top
59		Milestone 1	3/2/17	50%	95%
60		Milestone 2	4/1/17	25%	95%
61		Milestone 3	5/4/17	10%	95%
62		Milestone 4		30%	95%
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
101