Mini Schedule Planned VS Actual Excel Sheet

  • Date August 18, 2021

Spread Excel sheets that calculate the planned values based on planned start and planned finish. Furthermore, it compares the planned values to the actual values per week.

How to use this excel sheet?

A- Watch this video:

or

B- Follow these steps:

1- Fill the data in the data sheet:

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

blank

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

blank

4- Fill the actual data in the Actuals sheet:

blank

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

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

blank

 

Download the Mini Schedule Planned VS Actual Excel Sheet: Mini-Schedule Template R1

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

Tag:, ,

author avatar
Hany Ismail, MSC, PMP

Hany Ismael is the founder and CEO of Planning Engineer Est. in Egypt. He has started his career back in 2003 as a site engineer, technical office engineer, planning engineer, planning manager, and finally planning department manager where he has been involved in several mega construction projects in Egypt and Saudi Arabia. In 2016, he established his own company in Egypt “Planning Engineer Est.” Hany gained his MSc degree in project management from Liverpool University-UK 2013-2016, PMP certified from PMI-USA 2010, and BSc Civil Engineer Tanta University-Egypt 2003. Hany provided more than 3,500 hours of planning and project management training on his website planningengineer.net, YouTube channel, and offline courses since 2011. He enjoys teaching project management in simple and practical way, and he developed several planning tools, techniques and courses.

You may also like

3 weeks look ahead schedule
3 weeks look ahead schedule excel sheet
24 July, 2021
img_0176.png
Excel Power Query in Planning
14 October, 2020
2019-11-05_8-05-12
Split Primavera P6 Schedule into 2 Schedules – Problem and solution
6 November, 2019

Leave A Reply