3-week lookahead schedule from MS Project or P6

Drop the master schedule - an .mpp or a Primavera .xer - and see only the work running in the next three weeks, counted from the file's data date. Switch to two or six weeks, then take it to the site meeting as an Excel sheet. No P6, no Project, nothing to install.

Drop a schedule here or

Your file is never saved. It is read in memory and gone as soon as the chart is drawn.

  • .mpp .xml .mpx .mpd .xer
  • up to 10 MB
  • no signup

What a lookahead is for

A master schedule of several hundred or a few thousand activities is the right tool for the planner and the wrong one for a foreman. On site the question is narrower: what is my crew doing in the next two or three weeks, and what has to be ready before it can start. So the lookahead gets cut out of the master schedule every week, usually by filtering and copying rows into a spreadsheet by hand. Here the file does that itself.

Which tasks make it in

  • Every unfinished task that runs at any point in the window - already under way, starting inside it, or long enough to span it.
  • Milestones that fall inside the window.
  • The phases above those tasks, so each line still shows which part of the job it belongs to.

Finished tasks are left out, and so is work that should have finished before the window opens: in a schedule that has not been updated for a while that would bury the lookahead. The Overdue filter shows that work on its own.

Where the window starts

A lookahead is counted from the date the schedule was last updated to, not from the day you happen to open it. If the file carries one, the window starts there: the data date of a P6 export, or the status date set in Microsoft Project. Without one it starts today. The filter button shows the exact dates, for example Next 3 weeks ยท 10 Apr - 30 Apr, and the chart scrolls to the start of the window.

Take it to the site meeting

With a lookahead on, Export to Excel becomes Export 3-week lookahead and the workbook holds only the window:

  • Lookahead - the tasks in the order of the schedule, with their phases, dates, durations, progress, resources and predecessors. The ID column is the row number from the full plan, so a line in the sheet can be found in Project or P6 straight away.
  • By resource - the same tasks listed under each assigned resource, with tasks that have nobody assigned at the end. A subcontractor set up as a resource gets their own block to hand over.

Grouping follows resources assigned in the schedule. Primavera activity codes, which some planners use for the subcontractor instead, are not read yet.

Without Primavera P6 or Microsoft Project

In P6 a lookahead is a filter and a layout someone has to build and keep; in Project it is a filter on the status date. Both need the program. Here the file opens in a browser on any computer, Mac included. And when you share the plan by link, whoever opens it can switch the lookahead on for themselves, so the foreman reads the current three weeks rather than last week's printout.

Common questions

Two, three or six weeks?
Three is the usual site rhythm: refreshed every week, so there is always one week of overlap. Two weeks suits a fast-moving fit-out, six weeks a long-lead procurement review. All three are in the Filter menu.
Can I start the window on another date?
Not from the page yet. Set the status date in Project, or reschedule in P6 to the data date you want, and the window follows the file.
Does it change my schedule?
No. Nothing is recalculated and nothing is written back: the dates come from the file exactly as Project or P6 saved them, and the file itself is never stored.
Is it free?
Yes - the lookahead and its Excel export cost nothing and need no account.

PDF of the chart isn't built yet

We're choosing what to build next, and your click counts as a vote for this one.

It would put the whole chart in one file, every task and bar, ready to print or send.

The Excel report isn't built yet

We're choosing what to build next, and your click counts as a vote for this one.

It would draw the timeline right in the cells and add a summary sheet with milestones and overdue tasks.

What changed

Shifts are counted in calendar days. The report lists what differs between the two files, not why it changed.

The change report is part of Pro

Download every change as an Excel workbook to send on: what was added, removed and edited, what moved and by how much, and how the critical path changed.

Pro is free during early access.

What will you do with this spreadsheet?

One click helps us decide what to build next.