FILTERS i

Refresh?

This shape represents a slicer. This shape represents a slicer.

Slicers are supported in Excel Slicers are supported in Excel Timeline
2010 or later. 2010 or later.

If the shape was modified in an If the shape was modified in an

earlier version of Excel, or if the earlier version of Excel, or if the
workbook was saved in Excel workbook was saved in Excel

SUMMARY
2003 or earlier, the slicer cannot 2003 or earlier, the slicer cannot
be used. be used.

This shape represents a slicer. This shape represents a slicer.

Slicers are supported in Excel Slicers are supported in Excel
2010 or later. 2010 or later.

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

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

If the shape was modified in an If the shape was modified in an

earlier version of Excel, or if the earlier version of Excel, or if the
workbook was saved in Excel workbook was saved in Excel
2003 or earlier, the slicer cannot 2003 or earlier, the slicer cannot
be used. be used.
SUMMARY TABLE .
PROJECT PORTFOLIO MANAGEMENT

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

If the shape was modified in an earlier version of Excel, or if the workbook was saved in
Excel 2003 or earlier, the slicer cannot be used.
4 Task Status Task Progress
PROJECTS
Not Started 14
15
MILESTONES In progress 29
49%
Completed 17
60
TASKS

12/21/2019
12/1/2019

1/10/2020

1/30/2020
Your P1_ Task 2
Your P1_ Task 4
Your P1_ Task 6
Your P1_ Task 11
Project 1

Your P1_ Task 13

Your P1_ Task 8
Your P1_ Task 14
4. Production

Your P1_ Task 16

Your P1_ Task 18
Your P1_ Task 20
Your P2_ Task 2
Your P2_ Task 6
Your P2_ Task 8
Project 2

Your P2_ Task 10

Your P2_ Task 12
Your P2_ Task 14
4. Production

Your P2_ Task 16

Your P2_ Task 18
Your P2_ Task 20
Your P2_ Task 2
Your P2_ Task 4
Project 3

Your P2_ Task 6

Your P2_ Task 8
Your P1_ Task 15
Your P1_ Task 17
Milestone 1

Your P2_ Task 10

Your P1_ Task 19
Project 4

Your P2_ Task 1

Your P2_ Task 3
Your P2_ Task 5
 Your P2_ Task 6

Project
Your P2_ Task 8
Your P1_ Task 15
Your P1_ Task 17

Milestone 1
Your P2_ Task 10
Your P1_ Task 19

Project 4
Your P2_ Task 1
Your P2_ Task 3
Your P2_ Task 5

Press 'Alt+F5' Keys to Refersh the Dashboard // OR // Goto 'PivotTable Analyze' Tab and Press 'Refresh' Command

Project Milestone Task Responsible

Project 1 1. Design Your P1_ Task 1 Person 1
Your P1_ Task 2 Person 2
Your P1_ Task 3 Person 3
Your P1_ Task 4 Person 4
Your P1_ Task 5 Person 1
Your P1_ Task 6 Person 2
2. Develop Your P1_ Task 10 Person 2
Your P1_ Task 11 Person 3
Your P1_ Task 12 Person 4
Your P1_ Task 13 Person 1
Your P1_ Task 7 Person 3
Your P1_ Task 8 Person 4
Your P1_ Task 9 Person 1
3. Test Your P1_ Task 14 Person 2
Your P1_ Task 15 Person 3
Your P1_ Task 16 Person 4
Your P1_ Task 17 Person 1
4. Production Your P1_ Task 18 Person 2
Your P1_ Task 19 Person 3
Your P1_ Task 20 Person 4
Project 2 1. Design Your P2_ Task 1 Person 5
Your P2_ Task 2 Person 6
Your P2_ Task 5 Person 7
Your P2_ Task 6 Person 8
2. Develop Your P2_ Task 7 Person 2
Your P2_ Task 8 Person 3
Your P2_ Task 9 Person 4
Your P2_ Task 10 Person 5
Your P2_ Task 11 Person 6
Your P2_ Task 12 Person 7
Your P2_ Task 13 Person 8
3. Test Your P2_ Task 14 Person 2
Your P2_ Task 15 Person 3
Your P2_ Task 16 Person 4
Your P2_ Task 17 Person 5
4. Production Your P2_ Task 18 Person 6
 Your P2_ Task 19 Person 7
Your P2_ Task 20 Person 8
Project 3 MS1 Your P2_ Task 1 Person 1
Your P2_ Task 2 Person 2
Your P2_ Task 3 Person 3
Your P2_ Task 4 Person 4
Your P2_ Task 5 Person 5
MS2 Your P2_ Task 6 Person 6
Your P2_ Task 7 Person 7
Your P2_ Task 8 Person 8
MS3 Your P1_ Task 14 Person 4
Your P1_ Task 15 Person 5
Your P1_ Task 16 Person 6
Your P1_ Task 17 Person 7
Your P2_ Task 9 Person 9
Your P2_ Task 10 Person 10
Project 4 Milestone 1 Your P1_ Task 18 Person 8
Your P1_ Task 19 Person 9
Milestone 2 Your P1_ Task 20 Person 10
Your P2_ Task 1 Person 8
Milestone 3 Your P2_ Task 2 Person 9
Your P2_ Task 3 Person 10
Milestone 4 Your P2_ Task 4 Person 8
Your P2_ Task 5 Person 10
 Dashboard Team Portfolios Project

Change the filters and Refresh PivotTable to apply

Task Efforts (Hours) Task Finance Man days: 1645 Completed: 844 days R

Actual 3960 Actual 153640

Baseline 4110 Baseline $375,000

Planned 3990 Planned $394,300

0% 10% 20% 30% 40% 50% 60% 70
1/10/2020

1/30/2020

2/19/2020

3/10/2020

3/30/2020

4/19/2020

5/9/2020
ss 'Refresh' Command
ACTUAL TIMELINES
Actual Status Start End Duration Completed Pending
Completed 1/29/2020 12/20/2019 81 81 0
In progress 1/26/2020 11/12/2019 42 21 21
Completed 1/28/2020 10/9/2019 5 5 0
Completed 2/2/2020 10/10/2019 7 7 0
In progress 2/12/2020 10/28/2019 14 6 8
Completed 2/7/2020 10/30/2019 21 21 0
Completed 3/17/2020 12/13/2019 26 26 0
In progress 3/18/2020 11/26/2019 10 10 0
Completed 3/15/2020 12/12/2019 22 22 0
In progress 3/13/2020 12/30/2019 44 22 22
In progress 2/13/2020 10/29/2019 10 4 6
Completed 2/26/2020 11/12/2019 14 14 0
Not Started 3/15/2020 12/26/2019 42 0 42
In progress 3/24/2020 1/7/2020 46 21 25
Not Started 3/18/2020 12/2/2019 16 0 16
In progress 3/20/2020 12/13/2019 22 6 16
In progress 3/18/2020 12/2/2019 12 1 11
Not Started 3/18/2020 1/6/2020 51 0 51
Not Started 3/12/2020 12/25/2019 38 0 38
Not Started 3/20/2020 11/27/2019 5 0 5
Completed 1/30/2020 12/20/2019 81 81 0
In progress 1/25/2020 11/12/2019 42 21 21
In progress 2/11/2020 10/28/2019 14 6 8
Not Started 2/7/2020 10/30/2019 21 0 21
Completed 2/15/2020 10/29/2019 10 10 0
In progress 2/28/2020 11/12/2019 14 4 10
In progress 3/12/2020 12/26/2019 42 13 29
Completed 3/18/2020 12/13/2019 26 26 0
In progress 3/12/2020 11/26/2019 10 10 0
Completed 3/22/2020 12/12/2019 22 22 0
In progress 3/13/2020 12/30/2019 44 22 22
In progress 3/23/2020 1/7/2020 46 21 25
In progress 3/12/2020 12/2/2019 16 8 8
In progress 3/22/2020 12/13/2019 22 2 20
In progress 3/19/2020 12/2/2019 12 7 5
Not Started 3/17/2020 1/6/2020 51 0 51
Not Started 3/13/2020 12/25/2019 38 0 38
Not Started 3/21/2020 11/27/2019 5 0 5
Completed 1/25/2020 12/20/2019 81 81 0
In progress 1/30/2020 11/12/2019 42 21 21
Completed 2/1/2020 10/9/2019 5 5 0
In progress 1/30/2020 10/10/2019 7 3 4
In progress 2/14/2020 10/28/2019 14 6 8
Not Started 2/5/2020 10/30/2019 21 0 21
Completed 2/19/2020 10/29/2019 10 10 0
In progress 2/29/2020 11/12/2019 14 4 10
In progress 3/23/2020 1/7/2020 46 21 25
Not Started 3/14/2020 12/2/2019 16 0 16
In progress 3/22/2020 12/13/2019 22 17 5
In progress 3/18/2020 12/2/2019 12 1 11
In progress 3/9/2020 12/26/2019 42 13 29
Completed 3/14/2020 12/13/2019 26 26 0
Not Started 3/17/2020 1/6/2020 51 0 51
Not Started 3/16/2020 12/25/2019 38 0 38
Not Started 3/21/2020 11/27/2019 5 0 5
Completed 1/28/2020 12/20/2019 81 81 0
In progress 1/29/2020 11/12/2019 42 21 21
Completed 1/31/2020 10/9/2019 5 5 0
In progress 2/2/2020 10/10/2019 7 3 4
In progress 2/14/2020 10/28/2019 14 6 8
 Projects Tasks

Completed: 844 days Remaining: 801 days

40% 50% 60% 70% 80% 90% 100%

5/29/2020
5/9/2020
 Budget Efforts
Progress Planned Budget Baseline Budget Actual Spent Planned Hours
100% $8,300 $8,000 554700% 85
50% $4,500 $4,000 118100% 100
100% $4,200 $4,000 78300% 85
100% $9,500 $9,000 320900% 55
40% $10,200 $10,000 327200% 100
100% $3,300 $3,000 61300% 55
100% $10,400 $10,000 228400% 100
95% $10,200 $10,000 865800% 40
100% $6,500 $6,000 173600% 40
50% $3,100 $3,000 58000% 70
40% $3,300 $3,000 82500% 40
100% $5,400 $5,000 76500% 55
0% $8,400 $8,000 86000% 40
45% $2,500 $2,000 74000% 40
0% $7,100 $7,000 561800% 100
25% $9,500 $9,000 202100% 70
10% $10,500 $10,000 794700% 40
0% $5,500 $5,000 119000% 70
0% $3,200 $3,000 49600% 85
0% $5,300 $5,000 321300% 85
100% $8,200 $8,000 554700% 70
50% $4,500 $4,000 118100% 100
40% $10,500 $10,000 327200% 55
0% $3,200 $3,000 61300% 40
100% $3,300 $3,000 82500% 40
25% $5,100 $5,000 76500% 70
30% $8,500 $8,000 86000% 55
100% $10,200 $10,000 228400% 40
98% $10,300 $10,000 865800% 85
100% $6,100 $6,000 173600% 85
50% $3,100 $3,000 58000% 55
45% $2,500 $2,000 74000% 40
50% $7,500 $7,000 561800% 40
10% $9,500 $9,000 202100% 40
60% $10,300 $10,000 794700% 70
0% $5,100 $5,000 119000% 100
0% $3,400 $3,000 49600% 40
0% $5,300 $5,000 321300% 55
100% $8,100 $8,000 554700% 40
50% $4,500 $4,000 118100% 55
100% $4,500 $4,000 78300% 40
45% $9,200 $9,000 320900% 85
40% $10,100 $10,000 327200% 40
0% $3,300 $3,000 61300% 55
100% $3,500 $3,000 82500% 100
25% $5,400 $5,000 76500% 85
45% $2,100 $2,000 74000% 70
0% $7,400 $7,000 561800% 55
75% $9,100 $9,000 202100% 85
10% $10,400 $10,000 794700% 55
30% $8,100 $8,000 86000% 100
100% $10,200 $10,000 228400% 100
0% $5,300 $5,000 119000% 40
0% $3,500 $3,000 49600% 100
0% $5,500 $5,000 321300% 100
100% $8,200 $8,000 554700% 40
50% $4,400 $4,000 118100% 100
100% $4,500 $4,000 78300% 70
45% $9,400 $9,000 320900% 40
40% $10,100 $10,000 327200% 100
Baseline Hours Actual Hours (empty)
100 70
85 40
100 100
40 40
40 70
70 85
70 70
100 55
85 55
55 85
40 70
55 40
70 40
55 70
85 40
70 100
70 40
70 55
85 40
40 100
70 40
40 100
70 85
55 85
70 55
40 70
40 40
55 100
100 55
40 40
40 100
100 55
40 85
70 55
100 40
70 85
85 70
70 70
85 70
55 100
55 40
70 40
55 100
40 40
85 70
100 55
70 85
70 85
55 70
85 70
85 40
70 40
40 40
70 100
85 55
70 100
100 85
85 70
85 55
55 55
 + Project Team Dashboard

ID Name Role Tasks

1 Person 1 6
2 Person 2 8
3 Person 3 8
4 Person 4 9
5 Person 5 5
6 Person 6 5
7 Person 7 5
8 Person 8 7
9 Person 9 3
10 Person 10 4
Dashboard Team Portfolios Projects Tasks

Completed Pending Progress

2 4 50%
3 5 61%
2 6 51%
3 6 51%
2 3 60%
0 5 45%
2 3 50%
1 6 31%
0 3 27%
2 2 60%
 + Portfolios Dashboard Team Portfolios

ID Portfolio Name Manager Planned Budget

1 Portfolio 1 Person 1 $181,800

2 Portfolio 2 Person 2 $116,600
3 Portfolio 3 Person 3 $95,900
4 Portfolio 4 Person 1 $0
5 Portfolio 5 Person 2 $0
6 Portfolio 6 Person 5 $0

Total 6 $394,300
Portfolios Projects Tasks

FORMULA

Projects Projects Projects Projects

Actual Spent
Count Completed Pending Progress

$70,429 3 0 3 47%
$47,546 3 0 3 48%
$35,665 1 1 0 51%
$0 1 0 1
$0 1 0 1
$0 1 0 1

$153,640 10 1 9 49%
 + Projects

ID Project Name Portfolio

1 Project 1 Portfolio 1
2 Project 2 Portfolio 2
3 Project 3 Portfolio 3
4 Project 4 Portfolio 1
5 Project 5 Portfolio 5
6 Project 6 Portfolio 6
7 Project 7 Portfolio 2
8 Project 8 Portfolio 4
9 Project 9 Portfolio 1
10 Project 10 Portfolio 2
 Dashboard Team Portfolios Projects Tasks

FORMULA

Manager Status Planned Budget Actual Spent Tasks Count

Person 1 In progress $130,900 $51,538 20

Person 2 In progress $116,600 $47,546 18
Person 3 Completed $95,900 $35,665 14
Person 1 In progress $50,900 $18,891 8
Person 2 In progress $0 $0 0
Person 5 In progress $0 $0 0
Person 6 In progress $0 $0 0
Person 1 In progress $0 $0 0
Person 2 In progress $0 $0 0
Person 3 In progress $0 $0 0
 Tasks

Tasks Tasks Tasks

Completed Pending Progress

7 13 53%
4 14 48%
4 10 51%
2 6 42%
0 0
0 0
0 0
0 0
0 0
0 0
 + 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
 Dashboard Team Portfolios Projects Tasks

PLANNED

Planned Planned End Planned

Task Responsible
Start Date Date Hours
Your P1_ Task 1 Person 1 4/14/2020 5/30/2020 85
Your P1_ Task 2 Person 2 4/15/2020 5/18/2020 100
Your P1_ Task 3 Person 3 4/22/2020 4/26/2020 85
Your P1_ Task 4 Person 4 2/24/2020 5/19/2020 55
Your P1_ Task 5 Person 1 2/29/2020 4/6/2020 100
Your P1_ Task 6 Person 2 3/15/2020 3/24/2020 55
Your P1_ Task 7 Person 3 3/7/2020 3/27/2020 40
Your P1_ Task 8 Person 4 3/15/2020 3/22/2020 55
Your P1_ Task 9 Person 1 3/29/2020 4/11/2020 40
Your P1_ Task 10 Person 2 4/13/2020 5/26/2020 100
Your P1_ Task 11 Person 3 4/12/2020 5/10/2020 40
Your P1_ Task 12 Person 4 4/10/2020 4/19/2020 40
Your P1_ Task 13 Person 1 4/21/2020 5/12/2020 70
Your P1_ Task 14 Person 2 4/15/2020 5/24/2020 40
Your P1_ Task 15 Person 3 4/22/2020 6/7/2020 100
Your P1_ Task 16 Person 4 4/14/2020 5/1/2020 70
Your P1_ Task 17 Person 1 4/20/2020 5/6/2020 40
Your P1_ Task 18 Person 2 4/20/2020 4/26/2020 70
Your P1_ Task 19 Person 3 4/14/2020 6/3/2020 85
Your P1_ Task 20 Person 4 4/15/2020 5/23/2020 85
Your P2_ Task 1 Person 5 19/04/2020 23/04/2020 70
Your P2_ Task 2 Person 6 28/02/2020 16/05/2020 100
Your P2_ Task 5 Person 7 27/02/2020 09/04/2020 55
Your P2_ Task 6 Person 8 01/03/2020 09/03/2020 40
Your P2_ Task 7 Person 2 03/03/2020 05/03/2020 40
Your P2_ Task 8 Person 3 15/03/2020 24/03/2020 70
Your P2_ Task 9 Person 4 05/03/2020 30/03/2020 55
Your P2_ Task 10 Person 5 20/03/2020 25/03/2020 40
Your P2_ Task 11 Person 6 29/03/2020 05/04/2020 85
Your P2_ Task 12 Person 7 10/04/2020 26/05/2020 85
Your P2_ Task 13 Person 8 17/04/2020 06/05/2020 55
Your P2_ Task 14 Person 2 23/04/2020 06/06/2020 40
Your P2_ Task 15 Person 3 12/04/2020 01/05/2020 40
Your P2_ Task 16 Person 4 17/04/2020 08/05/2020 40
Your P2_ Task 17 Person 5 15/04/2020 28/04/2020 70
Your P2_ Task 18 Person 6 15/04/2020 03/06/2020 100
Your P2_ Task 19 Person 7 15/04/2020 25/05/2020 40
Your P2_ Task 20 Person 8 22/04/2020 23/04/2020 55
Your P2_ Task 1 Person 1 27/02/2020 15/05/2020 40
Your P2_ Task 2 Person 2 29/02/2020 08/04/2020 55
Your P2_ Task 3 Person 3 02/03/2020 09/03/2020 40
Your P2_ Task 4 Person 4 28/02/2020 05/03/2020 85
Your P2_ Task 5 Person 5 11/03/2020 22/03/2020 40
Your P2_ Task 6 Person 6 05/02/2020 25/02/2020 55
Your P2_ Task 7 Person 7 19/02/2020 28/02/2020 100
Your P2_ Task 8 Person 8 29/02/2020 11/03/2020 85
Your P2_ Task 9 Person 9 09/03/2020 19/04/2020 100
Your P2_ Task 10 Person 10 14/03/2020 13/04/2020 100
Your P1_ Task 14 Person 4 23/03/2020 02/05/2020 70
Your P1_ Task 15 Person 5 14/03/2020 28/03/2020 55
Your P1_ Task 16 Person 6 22/03/2020 08/04/2020 85
Your P1_ Task 17 Person 7 18/03/2020 31/03/2020 55
Your P1_ Task 18 Person 8 17/03/2020 03/05/2020 40
Your P1_ Task 19 Person 9 16/03/2020 22/04/2020 100
Your P1_ Task 20 Person 10 21/03/2020 24/03/2020 100
Your P2_ Task 1 Person 8 28/01/2020 15/04/2020 40
Your P2_ Task 2 Person 9 29/01/2020 12/03/2020 100
Your P2_ Task 3 Person 10 31/01/2020 05/02/2020 70
Your P2_ Task 4 Person 8 02/02/2020 03/02/2020 40
Your P2_ Task 5 Person 10 14/02/2020 25/02/2020 100
 Tasks

ED BASELINE ACTUAL

Planned Baseline Baseline End Baseline Baseline Actual Start Actual End
Budget Start Date Date Hours Budget Date Date
$8,300 1/29/2020 4/15/2020 100 $8,000 10/1/2019 12/20/2019
$4,500 1/26/2020 3/7/2020 85 $4,000 10/2/2019 11/12/2019
$4,200 1/28/2020 2/6/2020 100 $4,000 10/5/2019 10/9/2019
$9,500 2/2/2020 2/4/2020 40 $9,000 10/4/2019 10/10/2019
$10,200 2/12/2020 2/21/2020 40 $10,000 10/15/2019 10/28/2019
$3,300 2/7/2020 2/29/2020 70 $3,000 10/10/2019 10/30/2019
$3,300 2/13/2020 2/25/2020 40 $3,000 10/20/2019 10/29/2019
$5,400 2/26/2020 3/9/2020 55 $5,000 10/30/2019 11/12/2019
$8,400 3/15/2020 4/26/2020 70 $8,000 11/15/2019 12/26/2019
$10,400 3/17/2020 4/11/2020 70 $10,000 11/18/2019 12/13/2019
$10,200 3/18/2020 3/22/2020 100 $10,000 11/17/2019 11/26/2019
$6,500 3/15/2020 4/10/2020 85 $6,000 11/21/2019 12/12/2019
$3,100 3/13/2020 4/23/2020 55 $3,000 11/17/2019 12/30/2019
$2,500 3/24/2020 5/7/2020 55 $2,000 11/23/2019 1/7/2020
$7,100 3/18/2020 4/1/2020 85 $7,000 11/17/2019 12/2/2019
$9,500 3/20/2020 4/6/2020 70 $9,000 11/22/2019 12/13/2019
$10,500 3/18/2020 4/1/2020 70 $10,000 11/21/2019 12/2/2019
$5,500 3/18/2020 5/7/2020 70 $5,000 11/17/2019 1/6/2020
$3,200 3/12/2020 4/20/2020 85 $3,000 11/18/2019 12/25/2019
$5,300 3/20/2020 3/28/2020 40 $5,000 11/23/2019 11/27/2019
$8,200 30/01/2020 18/04/2020 70 $8,000 01/10/2019 20/12/2019
$4,500 25/01/2020 09/03/2020 40 $4,000 02/10/2019 12/11/2019
$10,500 11/02/2020 25/02/2020 70 $10,000 15/10/2019 28/10/2019
$3,200 07/02/2020 26/02/2020 55 $3,000 10/10/2019 30/10/2019
$3,300 15/02/2020 21/02/2020 70 $3,000 20/10/2019 29/10/2019
$5,100 28/02/2020 10/03/2020 40 $5,000 30/10/2019 12/11/2019
$8,500 12/03/2020 23/04/2020 40 $8,000 15/11/2019 26/12/2019
$10,200 18/03/2020 06/04/2020 55 $10,000 18/11/2019 13/12/2019
$10,300 12/03/2020 25/03/2020 100 $10,000 17/11/2019 26/11/2019
$6,100 22/03/2020 12/04/2020 40 $6,000 21/11/2019 12/12/2019
$3,100 13/03/2020 23/04/2020 40 $3,000 17/11/2019 30/12/2019
$2,500 23/03/2020 04/05/2020 100 $2,000 23/11/2019 07/01/2020
$7,500 12/03/2020 30/03/2020 40 $7,000 17/11/2019 02/12/2019
$9,500 22/03/2020 09/04/2020 70 $9,000 22/11/2019 13/12/2019
$10,300 19/03/2020 02/04/2020 100 $10,000 21/11/2019 02/12/2019
$5,100 17/03/2020 30/04/2020 70 $5,000 17/11/2019 06/01/2020
$3,400 13/03/2020 23/04/2020 85 $3,000 18/11/2019 25/12/2019
$5,300 21/03/2020 23/03/2020 70 $5,000 23/11/2019 27/11/2019
$8,100 25/01/2020 17/04/2020 85 $8,000 01/10/2019 20/12/2019
$4,500 30/01/2020 13/03/2020 55 $4,000 02/10/2019 12/11/2019
$4,500 01/02/2020 08/02/2020 55 $4,000 05/10/2019 09/10/2019
$9,200 30/01/2020 06/02/2020 70 $9,000 04/10/2019 10/10/2019
$10,100 14/02/2020 22/02/2020 55 $10,000 15/10/2019 28/10/2019
$3,300 05/02/2020 25/02/2020 40 $3,000 10/10/2019 30/10/2019
$3,500 19/02/2020 28/02/2020 85 $3,000 20/10/2019 29/10/2019
$5,400 29/02/2020 11/03/2020 100 $5,000 30/10/2019 12/11/2019
$8,100 09/03/2020 19/04/2020 85 $8,000 15/11/2019 26/12/2019
$10,200 14/03/2020 13/04/2020 70 $10,000 18/11/2019 13/12/2019
$2,100 23/03/2020 02/05/2020 70 $2,000 23/11/2019 07/01/2020
$7,400 14/03/2020 28/03/2020 70 $7,000 17/11/2019 02/12/2019
$9,100 22/03/2020 08/04/2020 55 $9,000 22/11/2019 13/12/2019
$10,400 18/03/2020 31/03/2020 85 $10,000 21/11/2019 02/12/2019
$5,300 17/03/2020 03/05/2020 40 $5,000 17/11/2019 06/01/2020
$3,500 16/03/2020 22/04/2020 70 $3,000 18/11/2019 25/12/2019
$5,500 21/03/2020 24/03/2020 85 $5,000 23/11/2019 27/11/2019
$8,200 28/01/2020 15/04/2020 70 $8,000 01/10/2019 20/12/2019
$4,400 29/01/2020 12/03/2020 100 $4,000 02/10/2019 12/11/2019
$4,500 31/01/2020 05/02/2020 85 $4,000 05/10/2019 09/10/2019
$9,400 02/02/2020 03/02/2020 85 $9,000 04/10/2019 10/10/2019
$10,100 14/02/2020 25/02/2020 55 $10,000 15/10/2019 28/10/2019
 ACTUAL FORMULA

Actual Actual Planned Baseline

Actual Hours Actual Spent
Status Progress Progress Progress
70 $5,547 Completed 100% 100% 100%
40 $1,181 In progress 50% 100% 100%
100 $783 Completed 100% 100% 100%
40 $3,209 Completed 100% 100% 100%
70 $3,272 In progress 40% 100% 100%
85 $613 Completed 100% 100% 100%
70 $825 In progress 40% 100% 100%
40 $765 Completed 100% 100% 100%
40 $860 Not Started 0% 100% 100%
70 $2,284 Completed 100% 100% 100%
55 $8,658 In progress 95% 100% 100%
55 $1,736 Completed 100% 100% 100%
85 $580 In progress 50% 100% 100%
70 $740 In progress 45% 100% 100%
40 $5,618 Not Started 0% 100% 100%
100 $2,021 In progress 25% 100% 100%
40 $7,947 In progress 10% 100% 100%
55 $1,190 Not Started 0% 100% 100%
40 $496 Not Started 0% 100% 100%
100 $3,213 Not Started 0% 100% 100%
40 554700% Completed 100% 100% 100%
100 118100% In progress 50% 100% 100%
85 327200% In progress 40% 100% 100%
85 61300% Not Started 0% 100% 100%
55 82500% Completed 100% 100% 100%
70 76500% In progress 25% 100% 100%
40 86000% In progress 30% 100% 100%
100 228400% Completed 100% 100% 100%
55 865800% In progress 98% 100% 100%
40 173600% Completed 100% 100% 100%
100 58000% In progress 50% 100% 100%
55 74000% In progress 45% 100% 100%
85 561800% In progress 50% 100% 100%
55 202100% In progress 10% 100% 100%
40 794700% In progress 60% 100% 100%
85 119000% Not Started 0% 100% 100%
70 49600% Not Started 0% 100% 100%
70 321300% Not Started 0% 100% 100%
70 554700% Completed 100% 100% 100%
100 118100% In progress 50% 100% 100%
40 78300% Completed 100% 100% 100%
40 320900% In progress 45% 100% 100%
100 327200% In progress 40% 100% 100%
40 61300% Not Started 0% 100% 100%
70 82500% Completed 100% 100% 100%
55 76500% In progress 25% 100% 100%
40 86000% In progress 30% 100% 100%
40 228400% Completed 100% 100% 100%
85 74000% In progress 45% 100% 100%
85 561800% Not Started 0% 100% 100%
70 202100% In progress 75% 100% 100%
70 794700% In progress 10% 100% 100%
40 119000% Not Started 0% 100% 100%
100 49600% Not Started 0% 100% 100%
55 321300% Not Started 0% 100% 100%
100 554700% Completed 100% 100% 100%
85 118100% In progress 50% 100% 100%
70 78300% Completed 100% 100% 100%
55 320900% In progress 45% 100% 100%
55 327200% In progress 40% 100% 100%
 Plan Plan Baseline
Portfolio Manager Balance
Duration Completed Duration
Portfolio 1 Person 1 $2,753 47 47 78
Portfolio 1 Person 1 $3,319 34 34 42
Portfolio 1 Person 1 $3,417 5 5 10
Portfolio 1 Person 1 $6,291 86 86 3
Portfolio 1 Person 1 $6,928 38 38 10
Portfolio 1 Person 1 $2,687 10 10 23
Portfolio 1 Person 1 $2,475 21 21 13
Portfolio 1 Person 1 $4,635 8 8 13
Portfolio 1 Person 1 $7,540 14 14 43
Portfolio 1 Person 1 $8,116 44 44 26
Portfolio 1 Person 1 $1,542 29 29 5
Portfolio 1 Person 1 $4,764 10 10 27
Portfolio 1 Person 1 $2,520 22 22 42
Portfolio 1 Person 1 $1,760 40 40 45
Portfolio 1 Person 1 $1,482 47 47 15
Portfolio 1 Person 1 $7,479 18 18 18
Portfolio 1 Person 1 $2,553 17 17 15
Portfolio 1 Person 1 $4,310 7 7 51
Portfolio 1 Person 1 $2,704 51 51 40
Portfolio 1 Person 1 $2,087 39 39 9
Portfolio 2 Person 2 $2,653 5 5 80
Portfolio 2 Person 2 $3,319 79 79 45
Portfolio 2 Person 2 $7,228 43 43 15
Portfolio 2 Person 2 $2,587 9 9 20
Portfolio 2 Person 2 $2,475 3 3 7
Portfolio 2 Person 2 $4,335 10 10 12
Portfolio 2 Person 2 $7,640 26 26 43
Portfolio 2 Person 2 $7,916 6 6 20
Portfolio 2 Person 2 $1,642 8 8 14
Portfolio 2 Person 2 $4,364 47 47 22
Portfolio 2 Person 2 $2,520 20 20 42
Portfolio 2 Person 2 $1,760 45 45 43
Portfolio 2 Person 2 $1,882 20 20 19
Portfolio 2 Person 2 $7,479 22 22 19
Portfolio 2 Person 2 $2,353 14 14 15
Portfolio 2 Person 2 $3,910 50 50 45
Portfolio 2 Person 2 $2,904 41 41 42
Portfolio 2 Person 2 $2,087 2 2 3
Portfolio 3 Person 3 $2,553 79 79 84
Portfolio 3 Person 3 $3,319 40 40 44
Portfolio 3 Person 3 $3,717 8 8 8
Portfolio 3 Person 3 $5,991 7 7 8
Portfolio 3 Person 3 $6,828 12 12 9
Portfolio 3 Person 3 $2,687 21 21 21
Portfolio 3 Person 3 $2,675 10 10 10
Portfolio 3 Person 3 $4,635 12 12 12
Portfolio 3 Person 3 $7,240 42 42 42
Portfolio 3 Person 3 $7,916 31 31 31
Portfolio 3 Person 3 $1,360 41 41 41
Portfolio 3 Person 3 $1,782 15 15 15
Portfolio 3 Person 3 $7,079 18 18 18
Portfolio 3 Person 3 $2,453 14 14 14
Portfolio 1 Person 1 $4,110 48 48 48
Portfolio 1 Person 1 $3,004 38 38 38
Portfolio 1 Person 1 $2,287 4 4 4
Portfolio 1 Person 1 $2,653 79 79 79
Portfolio 1 Person 1 $3,219 44 44 44
Portfolio 1 Person 1 $3,717 6 6 6
Portfolio 1 Person 1 $6,191 2 2 2
Portfolio 1 Person 1 $6,828 12 12 12
 ACTUAL

Baseline Actual Actual

Start End Duration Completed
Completed Duration Completed
78 81 81 Err:504 Err:504 Err:504 Err:504
42 42 21 Err:504 Err:504 Err:504 Err:504
10 5 5 Err:504 Err:504 Err:504 Err:504
3 7 7 Err:504 Err:504 Err:504 Err:504
10 14 6 Err:504 Err:504 Err:504 Err:504
23 21 21 Err:504 Err:504 Err:504 Err:504
13 10 4 Err:504 Err:504 Err:504 Err:504
13 14 14 Err:504 Err:504 Err:504 Err:504
43 42 0 Err:504 Err:504 Err:504 Err:504
26 26 26 Err:504 Err:504 Err:504 Err:504
5 10 10 Err:504 Err:504 Err:504 Err:504
27 22 22 Err:504 Err:504 Err:504 Err:504
42 44 22 Err:504 Err:504 Err:504 Err:504
45 46 21 Err:504 Err:504 Err:504 Err:504
15 16 0 Err:504 Err:504 Err:504 Err:504
18 22 6 Err:504 Err:504 Err:504 Err:504
15 12 1 Err:504 Err:504 Err:504 Err:504
51 51 0 Err:504 Err:504 Err:504 Err:504
40 38 0 Err:504 Err:504 Err:504 Err:504
9 5 0 Err:504 Err:504 Err:504 Err:504
80 81 81 Err:504 Err:504 Err:504 Err:504
45 42 21 Err:504 Err:504 Err:504 Err:504
15 14 6 Err:504 Err:504 Err:504 Err:504
20 21 0 Err:504 Err:504 Err:504 Err:504
7 10 10 Err:504 Err:504 Err:504 Err:504
12 14 4 Err:504 Err:504 Err:504 Err:504
43 42 13 Err:504 Err:504 Err:504 Err:504
20 26 26 Err:504 Err:504 Err:504 Err:504
14 10 10 Err:504 Err:504 Err:504 Err:504
22 22 22 Err:504 Err:504 Err:504 Err:504
42 44 22 Err:504 Err:504 Err:504 Err:504
43 46 21 Err:504 Err:504 Err:504 Err:504
19 16 8 Err:504 Err:504 Err:504 Err:504
19 22 2 Err:504 Err:504 Err:504 Err:504
15 12 7 Err:504 Err:504 Err:504 Err:504
45 51 0 Err:504 Err:504 Err:504 Err:504
42 38 0 Err:504 Err:504 Err:504 Err:504
3 5 0 Err:504 Err:504 Err:504 Err:504
84 81 81 Err:504 Err:504 Err:504 Err:504
44 42 21 Err:504 Err:504 Err:504 Err:504
8 5 5 Err:504 Err:504 Err:504 Err:504
8 7 3 Err:504 Err:504 Err:504 Err:504
9 14 6 Err:504 Err:504 Err:504 Err:504
21 21 0 Err:504 Err:504 Err:504 Err:504
10 10 10 Err:504 Err:504 Err:504 Err:504
12 14 4 Err:504 Err:504 Err:504 Err:504
42 42 13 Err:504 Err:504 Err:504 Err:504
31 26 26 Err:504 Err:504 Err:504 Err:504
41 46 21 Err:504 Err:504 Err:504 Err:504
15 16 0 Err:504 Err:504 Err:504 Err:504
18 22 17 Err:504 Err:504 Err:504 Err:504
14 12 1 Err:504 Err:504 Err:504 Err:504
48 51 0 Err:504 Err:504 Err:504 Err:504
38 38 0 Err:504 Err:504 Err:504 Err:504
4 5 0 Err:504 Err:504 Err:504 Err:504
79 81 81 Err:504 Err:504 Err:504 Err:504
44 42 21 Err:504 Err:504 Err:504 Err:504
6 5 5 Err:504 Err:504 Err:504 Err:504
2 7 3 Err:504 Err:504 Err:504 Err:504
12 14 6 Err:504 Err:504 Err:504 Err:504
AL

Pending Progress Efforts VALID

Err:504 Err:504 Err:504 1

Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1
Err:504 Err:504 Err:504 1