• Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
Have any question?
(00) 201277767728
[email protected]
RegisterLogin

Login with your site account

Lost your password?

Not a member yet? Register now

Register a new account

Are you a member? Login now

Planning Engineer Est.
  • Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
      • Cart

        0

    Excel in Planning

    • Home
    • Blog
    • Excel in Planning
    • Mini Schedule Planned VS Actual Excel Sheet

    Mini Schedule Planned VS Actual Excel Sheet

    • Posted by Hany Ismail, MSC, PMP
    • Categories Excel in Planning
    • Date August 18, 2021
    • Comments 0 comment

    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: 

    Icon

    Mini-Schedule Template R2

    1 file(s) 258.00 KB
    Download

    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:excel sheet, Mini Schedule, Planned VS Actual

    • Share:
    Hany Ismail, MSC, PMP
    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.

    Previous post

    3 weeks look ahead schedule excel sheet
    August 18, 2021

    Next post

    Productivity Rates for Construction Projects
    October 4, 2021

    You may also like

    Materials Procurement Scheduling in a Baseline Programme
    Materials Procurement Scheduling in a Baseline Programme
    7 May, 2022
    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

    Leave A Reply Cancel reply

    You must be logged in to post a comment.

    Cart

    0

    Planning Courses

    Cost Control for Construction Projects

    Cost Control for Construction Projects

    $299.00
    Power Bi Monitoring and Controlling with P6

    Power Bi Monitoring and Controlling with P6

    $299.00
    Advanced Planning 3 Courses Package

    Advanced Planning 3 Courses Package

    $499.00
    Data Management and Reporting

    Data Management and Reporting

    $199.00
    Primavera Online Basic Course -Arabic

    Primavera Online Basic Course -Arabic

    $99.00
    Professional Planning Engineer (PPE)

    Professional Planning Engineer (PPE)

    $335.00
    Claims Management and (EOT)

    Claims Management and (EOT)

    $175.00
    Primavera Online Basic Course -English

    Primavera Online Basic Course -English

    $99.00

    Follow Us:

    About Us | Contact Us | Terms of Service | Privacy Policy | Refund Policy

    Copyright ©2012- 2018 planningengineer.net | All materials, unless otherwise noted, were developed originally for Planning Engineer Website. In the event that there is still a problem or error with copyrighted material, the break of the copyright is unintentional and noncommercial and the material will be removed immediately upon presented proof.

    • Planning Courses
    • Planning Jobs
    • Planning Blog
    Posting....