Mini Schedule Planned VS Actual Excel Sheet

Automated Spread Excel sheets that calculate the planned values based on planned start and planned finish. And it will give you the total progress and the total planned per week. Furthermore, it compares the planned values to the actual values per week.

All you need is to take your activities from Primavera with their planned dates and put it in the form of an Excel sheet to calculate the weightage of each activity.

A-Watch the Full Video

Ready to take your skills to the next level? 🚀 Check out our Special Online Courses! 🚀
Gain valuable insights, boost your career, and learn from industry experts.

Planning Courses

B- Follow these steps:

You can download this Excel Sheet so you can go through the steps.

Mini-Schedule Template R2

1 file(s) 258.00 KB

Download

1- Fill in the data in the datasheet:

You copy your data from Primavera P6 and fill it in the Excel sheet to make your Mini Schedule.

2- Copy the Activity ID, Planned Start, and Planned Finish columns to the weeks_dist sheet.

Just copy them into the week sheet to make them appear in the schedule.

3- Define the week start day, weekend, and holidays in the Settings sheet.

You should mark the week start date, and the weekend date and enter the Holidays manually.

4- Fill the actual data in the Actuals sheet

Put the wanted activities in the sheet with the week’s number and the actual quantities for it.

5- Go to Schedule sheet, from data click refresh all

Refresh the data to see the actual and planned quantities for the chosen activities and the summation of the week’s total value.

6- Use Filters / Hide the empty columns and you are ready to go

The Mini Schedule is ready to be viewed.

Download the Resources of this Article