How is PPC calculated?

If you've downloaded one of our free Power BI dashboards, you may have questions about how the PPC (Percent Plan Complete) is being calculated.

What is PPC?

PPC shows you what percentage of your planned work actually got done between two dates (usually last week and this week). There are two ways to measure it:

PPC (Task Day)

This method looks at how many work days you completed as planned.

Example:

Let's say you have three tasks:

• Task A: 3-day task, all days planned for the reference week

• Task B: 2-day task, all days planned for the reference week

• Task C: 4-day task, with 2 days planned for the reference week and 2 days the following week

What actually happened:

• Task A: ✓ All 3 days completed during the reference week

• Task B: ✗ Slipped—only 1 of the 2 planned days completed during the reference week

• Task C: ✗ Slipped—only 1 of the 2 planned days completed during the reference week

How we calculate it:

• Task A: 3 / 3 days = 100% PPC

• Task B: 1 / 2 days = 50% PPC

• Task C: 1 / 2 days = 50% PPC

Total PPC = Average(100%, 50%, 50%) = 66%

PPC (Task)

This method only counts tasks that were completely finished on schedule.

Example:

Let's say you have three tasks:

• Task A: Final day planned to occur in the reference week

• Task B: Final day planned to occur in the reference week

• Task C: Final day planned to occur in the reference week

What actually happened:

• Task A: ✓ Final day of task occurred in the reference week

• Task B: ✗ Slipped—final day pushed to the following week

• Task C: ✓ Final day of task occurred in the reference week

How we calculate it:

• Task A: Completed = 100% PPC

• Task B: Not Completed = 0% PPC

• Task C: Completed = 100% PPC

Total PPC = Average(100%, 0%, 100%) = 66%