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:

1- Data Management and Reporting

2- Cost Control for Construction Projects