1. Overall Project Progress - Calculations


The Overall Project Calculations is based on the start and finish date of the Schedule, not the project dates, although generally it would be expected the dates of the schedule would align to the project dates.




There are there are two ways the Overall Project Progress is calculated:


1. Effort Based

Project schedules that have at least one task that has an effort value should show an overall progress bar that shows that current percent complete of the total schedule based off the total actual effort percentage complete.

ie. (actual effort / effort * 100) rounded to the nearest integer


Example: 

Schedule Progress Calculation – Today’s date 05/08/2021

Formula:

Calculations:

Step 1 – Planned to Date %

Task (Current Date – Start Date + 1) x 100

Task (Duration)

Duration = total number of calendar days between schedule start and finish dates


Overall Planned % To Date=

Sum of all Planned % Tasks with Effort Values

Number of Tasks with Effort Values

WBS 3
(05/08/2021 – 21/07/2021+ 1) x 100

(11/08/2021 – 21/07/2021)

 

(16/22) x 100        = 72.72%

                              = 73%

 

WBS

Task (Current Date-Start Date+ 1)

Task (Duration)

Planned%

1

8

8

100%

2

15

15

100%

3

16

22

73%

 

Overall

(100+100+73)

        3

= 91%


Step 2 – Actual to Date %

(Actual Effort/ Effort)  x 100 

 

Overall Actual % To Date=

Sum of All Actual Effort x 100

Sum of All Effort
rounded off to the nearest integer


WBS

Actual Effort

Effort

1

9

11

2

11

12

3

11

11

total

31

34


Overall

  31  

  34

= 0.9117647059

= 91%





2. Duration Based

Project schedules that have no tasks that have an effort value should show an overall progress bar that shows the current percentage complete based of the percentage complete column values.
ie. (Sum(% complete * duration) / total duration) * 100)



Example: 

Schedule Progress Calculation – Today’s date 02/06/2026

Formula:

Calculations:

Step 1 – Planned To Date

Task (Current Date - Start Date)

Task (Duration)

Duration = total number of working days between schedule start and finish dates

 

Overall Planned To Date=

Total of Task (Current Date - Start Date)

Total of Task (Duration)

WBS 3


Task (Current Date- Start Date + 1):
 (05/08/2021 – 21/07/2021+ 1)

= 16


Task (Duration):
 (11/08/2021 – 21/07/2021)

= 23

 

WBS

Task (Current Date-Start Date)

Task (Duration)

1

4

4

2

9

9

3

9

9

4

2

10

5

0

10

6

0

1

7

0

20

Total

24

63

 

For Future Tasks, Duration is set to 0 as it would be impossible to subtract a Future Date from the Current Date. 


Overall

  24   

  63

= 0.380952

= 38%

Step 2 – Percent Complete

Total (Task %Complete x Duration) 

Total (Duration)


 

WBS

Task %Complete

Duration

Task % Complete x Duration

1

1

4

4

2

1

9

9

3

1

9

9

4

0.09

10

0.9

5

0

10

0

6

0

1

0

7

0

20

0

total

63

22.9

 

 

Overall

  22.9   

  63

= 0.363492063

= 36%