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:
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.
3- Define the week start day, weekend, and holidays in the Settings sheet.
4- Fill the actual data in the Actuals sheet:
5- Go to Schedule sheet, from data click refresh all
6- Use Filters / Hide the empty columns and you are ready to go : )
Download the Mini Schedule Planned VS Actual Excel Sheet:
Do you need to create similar sheets by yourself? I recommend the following 2 courses: