Mẫu file Excel quản lý theo dòng thời gian.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	O
1	PROJECT TIMELINE
2								{42}					Project Timeline Template
3													© 2017 Vertex42 LLC
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
33	Concept Dev.	Market Analysis	1/1/17	1/15/17	Blue	1/1/17	15	0	0	0	0	0
34		Feasibility	1/15/17	2/5/17	Blue	1/15/17	22	0	0	0	0	0
35		Rough Prototypes	2/6/17	2/26/17	Blue	2/6/17	21	0	0	0	0	0
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