This Excel sheet helps you to make 3 weeks look-ahead by Excel. It automatically gives you one week before the Data Date and 3 weeks after.

Once you change the Data Date all the yellow dates will be adjusted according to your new Data Date.

Once you add the Planned Start and the Planned Finish it will show its bar chart.

And you should put the Actual Percentage manually, if you want to add more columns you can add them right before the yellow columns.

First Step

Open Primavera P6 to copy the Activities from it.

From “Group and Sort”, Delete the WBS.

 

After Deleting the WBS, Click on “Apply”.

These will be the activities without WBS.

“CTRL+A” then “CTRL+C” to copy all the activities and Paste them into the Excel sheet.

“CTRL+V” to paste them into Excel.

After Pasting it in Excel, From the “Data” choose “Filter” to filter the Activities you want to see its lookahead, then paste them into the Bar Chart sheet to see it.

Only copy the Activity ID and then “VLOOKUP” for the other elements.

After applying “VLOOKUP” for all the elements.

That means all the chosen activities started and won’t be finished after the data date.

As a Planning Engineer, you often need to include a 3-week look-ahead schedule in your reports. While some situations call for more complex templates, there are times when a simpler Excel template is enough.

Many of my trainees have asked for such a template, and now I’m sharing the one I use. It’s easy to understand and helps plan tasks and projects smoothly for the upcoming three weeks. It ensures a clear and organized schedule for effective project management.

This Excel spreadsheet facilitates a 3-week look-ahead capability, automating the generation of dates. It effortlessly provides the preceding week’s data and forecasts for the next three weeks after the specified “Data Date”.

---

This user-friendly tool streamlines the process of planning and scheduling, making it convenient to manage tasks and projects effectively with accurate timeframes.

---

Download the Excel Tool and How to use it, don’t forget to share it with your colleagues