
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
B- Follow these steps:
You can download this Excel Sheet so you can go through the steps.
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 Mini Schedule Planned VS Actual Excel Sheet with the steps to share with your colleagues:
Do you need to create similar sheets by yourself? I recommend the following 2 courses: