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.

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.

RECOMMENDED COURSE

Data Management and Reporting

Data Management is the key success of construction projects reporting. This self-study course will teach you using a step by step case…

• 1,674 students
• WhatsApp support group
• Certificate

View course

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

Mini Schedule Planned VS Actual Excel Sheet 1.42 MB 9682 downloads

This File is included in the following course(s)

Basic Planning Course

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

---

Keep in Touch

Join our Email Newsletters and receive FREE weekly useful content!

Your Name

Email

---

Related posts:

How to connect Primavera P6 to Power BI (Full Guide) Understanding Merge Hotspot, Diverge Hotspot, and Logic Hotspot in Project Scheduling How does the planning department balance the management triangle How to Copy Progress Updates from one Project to another Work what you love to enjoy working