Project-Management-Dashboard.xlsx

	B	C	D	E	F	G	H	K	L	M	N	O	P	Q	S	T	U	V	W	X	Y
1	PROJECT	TASK	ASIGNEE	START DATE	DAYS REQUIRED	END DATE	PROGRESS	Projects		Resources		TODAY IS:
2	RED Project	Task RED 1	Mike	20/1/2023	2	22/1/2023	100%	RED Project		Mike		11/3/2023	*) Change to formula =TODAY()
3	RED Project	Task RED 2	Bob	22/1/2023	6	28/1/2023	100%	ORANGE Project		Sarah
4	RED Project	Task RED 3	Whitney	23/1/2023	17	9/2/2023	100%	BLUE Project		Bob
5	RED Project	Task RED 4	Jordan	25/1/2023	11	5/2/2023	100%	PINK Project		Jordan
6	ORANGE Project	Task ORANGE 1	Mike	12/2/2023	10	22/2/2023	100%	SILVER Project		Danny
7	ORANGE Project	Task ORANGE 2	Bob	13/2/2023	10	23/2/2023	100%	BROWN Project		Morgan
8	ORANGE Project	Task ORANGE 3	Whitney	14/2/2023	14	28/2/2023	100%	VIOLET Project		Whitney
9	ORANGE Project	Task ORANGE 4	Sarah	15/2/2023	3	18/2/2023	100%
10	ORANGE Project	Task ORANGE 5	Jordan	16/2/2023	15	3/3/2023	100%
11	ORANGE Project	Task ORANGE 6	Sarah	19/2/2023	5	24/2/2023	100%
12	ORANGE Project	Task ORANGE 7	Danny	20/2/2023	2	22/2/2023	100%	UNFINISHED TASKS							OVERDUE TASKS
13	ORANGE Project	Task ORANGE 8	Sarah	1/3/2023	4	5/3/2023	100%	PROJECT	TASK	ASIGNEE	START DATE	DAYS REQUIRED	END DATE	PROGRESS	PROJECT	TASK	ASIGNEE	START DATE	DAYS REQUIRED	END DATE	PROGRESS
14	ORANGE Project	Task ORANGE 9	Danny	3/3/2023	1	4/3/2023	90%	ORANGE Project	Task ORANGE 9	Danny	3/3/2023	1	4/3/2023	90%	ORANGE Project	Task ORANGE 9	Danny	3/3/2023	1	4/3/2023	90%
15	ORANGE Project	Task ORANGE 10	Morgan	5/3/2023	1	6/3/2023	85%	ORANGE Project	Task ORANGE 10	Morgan	5/3/2023	1	6/3/2023	85%	ORANGE Project	Task ORANGE 10	Morgan	5/3/2023	1	6/3/2023	85%
16	BLUE Project	Task BLUE 1	Danny	18/2/2023	1	19/2/2023	100%	PINK Project	Task PINK 1	Bob	25/2/2023	14	11/3/2023	80%	PINK Project	Task PINK 4	Sarah	5/3/2023	2	7/3/2023	90%
17	BLUE Project	Task BLUE 2	Danny	24/2/2023	6	2/3/2023	100%	PINK Project	Task PINK 3	Jordan	4/3/2023	7	11/3/2023	75%	SILVER Project	Task SILVER 2	Danny	5/3/2023	2	7/3/2023	50%
18	BLUE Project	Task BLUE 3	Mike	24/2/2023	8	4/3/2023	100%	PINK Project	Task PINK 4	Sarah	5/3/2023	2	7/3/2023	90%	SILVER Project	Task SILVER 3	Mike	5/3/2023	4	9/3/2023	80%
19	PINK Project	Task PINK 1	Bob	25/2/2023	14	11/3/2023	80%	SILVER Project	Task SILVER 2	Danny	5/3/2023	2	7/3/2023	50%	VIOLET Project	Task VIOLET 1	Morgan	6/3/2023	2	8/3/2023	30%
20	PINK Project	Task PINK 2	Whitney	1/3/2023	6	7/3/2023	100%	SILVER Project	Task SILVER 3	Mike	5/3/2023	4	9/3/2023	80%
21	PINK Project	Task PINK 3	Jordan	4/3/2023	7	11/3/2023	75%	SILVER Project	Task SILVER 4	Whitney	8/3/2023	14	22/3/2023	15%
22	PINK Project	Task PINK 4	Sarah	5/3/2023	2	7/3/2023	90%	SILVER Project	Task SILVER 5	Morgan	9/3/2023	5	14/3/2023	60%
23	SILVER Project	Task SILVER 1	Sarah	25/2/2023	3	28/2/2023	100%	BROWN Project	Task BROWN 2	Sarah	8/3/2023	4	12/3/2023	35%
24	SILVER Project	Task SILVER 2	Danny	5/3/2023	2	7/3/2023	50%	BROWN Project	Task BROWN 3	Jordan	12/3/2023	7	19/3/2023	0%
25	SILVER Project	Task SILVER 3	Mike	5/3/2023	4	9/3/2023	80%	BROWN Project	Task BROWN 4	Morgan	17/3/2023	5	22/3/2023	0%
26	SILVER Project	Task SILVER 4	Whitney	8/3/2023	14	22/3/2023	15%	VIOLET Project	Task VIOLET 1	Morgan	6/3/2023	2	8/3/2023	30%
27	SILVER Project	Task SILVER 5	Morgan	9/3/2023	5	14/3/2023	60%	VIOLET Project	Task VIOLET 2	Mike	9/3/2023	3	12/3/2023	50%
28	BROWN Project	Task BROWN 1	Morgan	3/3/2023	1	4/3/2023	100%	VIOLET Project	Task VIOLET 3	Bob	12/3/2023	10	22/3/2023	0%
29	BROWN Project	Task BROWN 2	Sarah	8/3/2023	4	12/3/2023	35%	VIOLET Project	Task VIOLET 4	Sarah	14/3/2023	12	26/3/2023	0%
30	BROWN Project	Task BROWN 3	Jordan	12/3/2023	7	19/3/2023	0%	VIOLET Project	Task VIOLET 5	Whitney	24/3/2023	5	29/3/2023	0%
31	BROWN Project	Task BROWN 4	Morgan	17/3/2023	5	22/3/2023	0%	VIOLET Project	Task VIOLET 6	Jordan	25/3/2023	16	10/4/2023	0%
32	VIOLET Project	Task VIOLET 1	Morgan	6/3/2023	2	8/3/2023	30%	VIOLET Project	Task VIOLET 7	Danny	8/3/2023	5	13/3/2023	0%
33	VIOLET Project	Task VIOLET 2	Mike	9/3/2023	3	12/3/2023	50%
34	VIOLET Project	Task VIOLET 3	Bob	12/3/2023	10	22/3/2023	0%
35	VIOLET Project	Task VIOLET 4	Sarah	14/3/2023	12	26/3/2023	0%
36	VIOLET Project	Task VIOLET 5	Whitney	24/3/2023	5	29/3/2023	0%
37	VIOLET Project	Task VIOLET 6	Jordan	25/3/2023	16	10/4/2023	0%
38	VIOLET Project	Task VIOLET 7	Danny	8/3/2023	5	13/3/2023	0%
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