i

Project Management Dashboard

Refresh?

This shape represents a slicer. Slicers are This shape represents a slicer. Slicers are
supported in Excel 2010 or later. supported in Excel 2010 or later.
FILTERS

If the shape was modified in an earlier version If the shape was modified in an earlier version
of Excel, or if the workbook was saved in Excel of Excel, or if the workbook was saved in
2003 or earlier, the slicer cannot be used. Excel 2003 or earlier, the slicer cannot be used.

Tasks Progress Man days: 152 Completed: 0

SUMMARY

0%

0% 10% 20% 30% 40% 50%

.

10/12/2019

10/22/2019

11/1/2019
GANTT CHART

2. Develop

Your P1_ Task 9

3. Test

Your P1_ Task 15

Project 1

Your P1_ Task 18

 3. Test
Your P1_ Task 15

Project 1
Your P1_ Task 18

4. Production
Your P1_ Task 19

Your P1_ Task 20

Project Milestone Task

.

Project 1 2. Develop Your P1_ Task 9

3. Test Your P1_ Task 15
DATA TABLE

4. Production Your P1_ Task 18

Your P1_ Task 19
Your P1_ Task 20
shboard Dashboard Team

hape represents a slicer. Slicers are This shape represents a slicer. Slicers are supported in Excel 2010 or
ted in Excel 2010 or later. later.

hape was modified in an earlier version If the shape was modified in an earlier version of Excel, or if the
el, or if the workbook was saved in workbook was saved in Excel 2003 or earlier, the slicer cannot be used.
2003 or earlier, the slicer cannot be used.

Man days: 152 Completed: 0 days Pending: 152 days Finance

$28,000

$11,377

% 20% 30% 40% 50% 60% 70% 80% 90% 100% Budget Spent
10/22/2019

11/11/2019

11/21/2019

12/11/2019

12/21/2019

12/31/2019
11/1/2019

12/1/2019
Start Date End Date Progress Status Budget
15/11/2019 26/12/2019 0% Not Started $8,000
17/11/2019 02/12/2019 0% Not Started $7,000
17/11/2019 06/01/2020 0% Not Started $5,000
18/11/2019 25/12/2019 0% Not Started $3,000
23/11/2019 27/11/2019 0% Not Started $5,000
 Team Projects Tasks

n Excel 2010 or This shape represents a slicer. Slicers are

supported in Excel 2010 or later.

cel, or if the If the shape was modified in an earlier version

cer cannot be used. of Excel, or if the workbook was saved in
Excel 2003 or earlier, the slicer cannot be
used.

ance Tasks Status

Not Started 5
28,000

In progress 0
$11,377

Completed 0
Budget Spent
12/21/2019

12/31/2019

1/10/2020

1/20/2020
Spent Duration Completed Pending (empty)
$860 42 0 42
$5,618 16 0 16
$1,190 51 0 51
$496 38 0 38
$3,213 5 0 5
 + Project Team Dashboard Team Projects Tasks

ID Name Role Tasks Completed Pending Progress

1 Slamet 8 2 6 #DIV/0!
2 Jimy 0 0 0 #DIV/0!
3 Person 3 8 2 6 51%
4 Person 4 9 3 6 51%
5 Person 5 5 2 3 60%
6 Person 6 5 0 5 45%
7 Person 7 5 2 3 50%
8 Person 8 7 1 6 31%
9 Person 9 3 0 3 27%
10 Person 10 4 2 2 60%
Tasks
 + Projects Dashboard Team Projects Tasks

ID Project Name Manager Tasks Completed Pending Progress

1 Rotary Die Cut Slamet 0 0 0
2 Project 2 Person 2 18 4 14 48%
3 Project 3 Person 3 14 4 10 51%
4 Project 4 Person 1 8 2 6 42%
5 Project 5 Person 2 0 0 0
6 Project 6 Person 5 0 0 0
7 Project 7 Person 6 0 0 0
8 Project 8 Person 1 0 0 0
9 Project 9 Person 2 0 0 0
10 Project 10 Person 3 0 0 0
Tasks
 + Tasks

WBS Project Milestone

1 Project 1 1. Design
2 Project 1 1. Design
3 Project 1 1. Design
4 Project 1 1. Design
5 Project 1 1. Design
6 Project 1 1. Design
7 Project 1 2. Develop
8 Project 1 2. Develop
9 Project 1 2. Develop
10 Project 1 2. Develop
11 Project 1 2. Develop
12 Project 1 2. Develop
13 Project 1 2. Develop
14 Project 1 3. Test
15 Project 1 3. Test
16 Project 1 3. Test
17 Project 1 3. Test
18 Project 1 4. Production
19 Project 1 4. Production
20 Project 1 4. Production
21 Project 2 1. Design
22 Project 2 1. Design
23 Project 2 1. Design
24 Project 2 1. Design
25 Project 2 2. Develop
26 Project 2 2. Develop
27 Project 2 2. Develop
28 Project 2 2. Develop
29 Project 2 2. Develop
30 Project 2 2. Develop
31 Project 2 2. Develop
32 Project 2 3. Test
33 Project 2 3. Test
34 Project 2 3. Test
35 Project 2 3. Test
36 Project 2 4. Production
37 Project 2 4. Production
38 Project 2 4. Production
39 Project 3 MS1
40 Project 3 MS1
41 Project 3 MS1
42 Project 3 MS1
43 Project 3 MS1
44 Project 3 MS2
45 Project 3 MS2
46 Project 3 MS2
47 Project 3 MS3
48 Project 3 MS3
49 Project 3 MS3
50 Project 3 MS3
51 Project 3 MS3
52 Project 3 MS3
53 Project 4 Milestone 1
54 Project 4 Milestone 1
55 Project 4 Milestone 2
56 Project 4 Milestone 2
57 Project 4 Milestone 3
58 Project 4 Milestone 3
59 Project 4 Milestone 4
60 Project 4 Milestone 4
Task Responsible Start Date End Date

Your P1_ Task 1 Person 1 10/1/2019 12/20/2019

Your P1_ Task 2 Person 2 10/2/2019 11/12/2019
Your P1_ Task 3 Person 3 10/5/2019 10/9/2019
Your P1_ Task 4 Person 4 10/4/2019 10/10/2019
Your P1_ Task 5 Person 1 10/15/2019 10/28/2019
Your P1_ Task 6 Person 2 10/10/2019 10/30/2019
Your P1_ Task 7 Person 3 10/20/2019 10/29/2019
Your P1_ Task 8 Person 4 10/30/2019 11/12/2019
Your P1_ Task 9 Person 1 11/15/2019 12/26/2019
Your P1_ Task 10 Person 2 11/18/2019 12/13/2019
Your P1_ Task 11 Person 3 11/17/2019 11/26/2019
Your P1_ Task 12 Person 4 11/21/2019 12/12/2019
Your P1_ Task 13 Person 1 11/17/2019 12/30/2019
Your P1_ Task 14 Person 2 11/23/2019 1/7/2020
Your P1_ Task 15 Person 3 11/17/2019 12/2/2019
Your P1_ Task 16 Person 4 11/22/2019 12/13/2019
Your P1_ Task 17 Person 1 11/21/2019 12/2/2019
Your P1_ Task 18 Person 2 11/17/2019 1/6/2020
Your P1_ Task 19 Person 3 11/18/2019 12/25/2019
Your P1_ Task 20 Person 4 11/23/2019 11/27/2019
Your P2_ Task 1 Person 5 01/10/2019 20/12/2019
Your P2_ Task 2 Person 6 02/10/2019 12/11/2019
Your P2_ Task 5 Person 7 15/10/2019 28/10/2019
Your P2_ Task 6 Person 8 10/10/2019 30/10/2019
Your P2_ Task 7 Person 2 20/10/2019 29/10/2019
Your P2_ Task 8 Person 3 30/10/2019 12/11/2019
Your P2_ Task 9 Person 4 15/11/2019 26/12/2019
Your P2_ Task 10 Person 5 18/11/2019 13/12/2019
Your P2_ Task 11 Person 6 17/11/2019 26/11/2019
Your P2_ Task 12 Person 7 21/11/2019 12/12/2019
Your P2_ Task 13 Person 8 17/11/2019 30/12/2019
Your P2_ Task 14 Person 2 23/11/2019 07/01/2020
Your P2_ Task 15 Person 3 17/11/2019 02/12/2019
Your P2_ Task 16 Person 4 22/11/2019 13/12/2019
Your P2_ Task 17 Person 5 21/11/2019 02/12/2019
Your P2_ Task 18 Person 6 17/11/2019 06/01/2020
Your P2_ Task 19 Person 7 18/11/2019 25/12/2019
Your P2_ Task 20 Person 8 23/11/2019 27/11/2019
Your P2_ Task 1 Person 1 01/10/2019 20/12/2019
Your P2_ Task 2 Person 2 02/10/2019 12/11/2019
Your P2_ Task 3 Person 3 05/10/2019 09/10/2019
Your P2_ Task 4 Person 4 04/10/2019 10/10/2019
Your P2_ Task 5 Person 5 15/10/2019 28/10/2019
Your P2_ Task 6 Person 6 10/10/2019 30/10/2019
Your P2_ Task 7 Person 7 20/10/2019 29/10/2019
Your P2_ Task 8 Person 8 30/10/2019 12/11/2019
Your P2_ Task 9 Person 9 15/11/2019 26/12/2019
Your P2_ Task 10 Person 10 18/11/2019 13/12/2019
Your P1_ Task 14 Person 4 23/11/2019 07/01/2020
Your P1_ Task 15 Person 5 17/11/2019 02/12/2019
Your P1_ Task 16 Person 6 22/11/2019 13/12/2019
Your P1_ Task 17 Person 7 21/11/2019 02/12/2019
Your P1_ Task 18 Person 8 17/11/2019 06/01/2020
Your P1_ Task 19 Person 9 18/11/2019 25/12/2019
Your P1_ Task 20 Person 10 23/11/2019 27/11/2019
Your P2_ Task 1 Person 8 01/10/2019 20/12/2019
Your P2_ Task 2 Person 9 02/10/2019 12/11/2019
Your P2_ Task 3 Person 10 05/10/2019 09/10/2019
Your P2_ Task 4 Person 8 04/10/2019 10/10/2019
Your P2_ Task 5 Person 10 15/10/2019 28/10/2019
 Dashboard Team

Progress Status Budget Spent Balance Duration

100% Completed $8,000 $5,547 $2,453 81

50% In progress $4,000 $1,181 $2,819 42
100% Completed $4,000 $783 $3,217 5
100% Completed $9,000 $3,209 $5,791 7
40% In progress $10,000 $3,272 $6,728 14
100% Completed $3,000 $613 $2,387 21
40% In progress $3,000 $825 $2,175 10
100% Completed $5,000 $765 $4,235 14
0% Not Started $8,000 $860 $7,140 42
100% Completed $10,000 $2,284 $7,716 26
95% In progress $10,000 $8,658 $1,342 10
100% Completed $6,000 $1,736 $4,264 22
50% In progress $3,000 $580 $2,420 44
45% In progress $2,000 $740 $1,260 46
0% Not Started $7,000 $5,618 $1,382 16
25% In progress $9,000 $2,021 $6,979 22
10% In progress $10,000 $7,947 $2,053 12
0% Not Started $5,000 $1,190 $3,810 51
0% Not Started $3,000 $496 $2,504 38
0% Not Started $5,000 $3,213 $1,787 5
100% Completed $8,000 $5,547 $2,453 81
50% In progress $4,000 $1,181 $2,819 42
40% In progress $10,000 $3,272 $6,728 14
0% Not Started $3,000 $613 $2,387 21
100% Completed $3,000 $825 $2,175 10
25% In progress $5,000 $765 $4,235 14
30% In progress $8,000 $860 $7,140 42
100% Completed $10,000 $2,284 $7,716 26
98% In progress $10,000 $8,658 $1,342 10
100% Completed $6,000 $1,736 $4,264 22
50% In progress $3,000 $580 $2,420 44
45% In progress $2,000 $740 $1,260 46
50% In progress $7,000 $5,618 $1,382 16
10% In progress $9,000 $2,021 $6,979 22
60% In progress $10,000 $7,947 $2,053 12
0% Not Started $5,000 $1,190 $3,810 51
0% Not Started $3,000 $496 $2,504 38
0% Not Started $5,000 $3,213 $1,787 5
100% Completed $8,000 $5,547 $2,453 81
50% In progress $4,000 $1,181 $2,819 42
100% Completed $4,000 $783 $3,217 5
45% In progress $9,000 $3,209 $5,791 7
40% In progress $10,000 $3,272 $6,728 14
0% Not Started $3,000 $613 $2,387 21
100% Completed $3,000 $825 $2,175 10
25% In progress $5,000 $765 $4,235 14
30% In progress $8,000 $860 $7,140 42
100% Completed $10,000 $2,284 $7,716 26
45% In progress $2,000 $740 $1,260 46
0% Not Started $7,000 $5,618 $1,382 16
75% In progress $9,000 $2,021 $6,979 22
10% In progress $10,000 $7,947 $2,053 12
0% Not Started $5,000 $1,190 $3,810 51
0% Not Started $3,000 $496 $2,504 38
0% Not Started $5,000 $3,213 $1,787 5
100% Completed $8,000 $5,547 $2,453 81
50% In progress $4,000 $1,181 $2,819 42
100% Completed $4,000 $783 $3,217 5
45% In progress $9,000 $3,209 $5,791 7
40% In progress $10,000 $3,272 $6,728 14
 Team Projects Tasks

Completed Pending VALID

81 0 1
21 21 1
5 0 1
7 0 1
6 8 1
21 0 1
4 6 1
14 0 1
0 42 1
26 0 1
10 0 1
22 0 1
22 22 1
21 25 1
0 16 1
6 16 1
1 11 1
0 51 1
0 38 1
0 5 1
81 0 1
21 21 1
6 8 1
0 21 1
10 0 1
4 10 1
13 29 1
26 0 1
10 0 1
22 0 1
22 22 1
21 25 1
8 8 1
2 20 1
7 5 1
0 51 1
0 38 1
0 5 1
81 0 1
21 21 1
5 0 1
3 4 1
6 8 1
0 21 1
10 0 1
4 10 1
13 29 1
26 0 1
21 25 1
0 16 1
17 5 1
1 11 1
0 51 1
0 38 1
0 5 1
81 0 1
21 21 1
5 0 1
3 4 1
6 8 1