Kind of Lost Kind of Lost ·OR Tools ·Project Scheduler ·3-week look-ahead ·Support

3 week look ahead template — free Excel download

A three-week look-ahead is the short-range schedule a superintendent or foreman actually runs the site from: the next fifteen working days, activity by activity, with the trade on each one and whatever still stands in its way. This free spreadsheet does the tedious part. You type a start date and a number of days for each activity; the finish dates, the bars and a daily headcount for every trade fill themselves in.

Download the 3-week look-ahead template (.xlsx)

No email, no signup. One sheet, fifteen working days, room for 30 activities.

What is in the file

It uses only ordinary functions — WORKDAY, SUMIFS, IF, CHOOSE, WEEKDAY — and no macros or array formulas, so it opens in Excel, LibreOffice or Google Sheets.

Running the weekly look-ahead meeting with it

  1. Roll the window. Change the week-1 date to the coming Monday, delete what finished, and add whatever now falls inside week 3.
  2. Ask the readiness question row by row. Are the materials on site or confirmed? Is the inspection booked? Has the trade before it finished, and is there access? Anything answered No gets a name and a date in the needs column before the meeting ends.
  3. Read the crew panel. A red day means you either move an activity that has room to slip, or you find more people. Settling that now is far cheaper than discovering it on the morning.
  4. Treat the weeks differently. Week 1 is a commitment, week 2 should be close, and week 3 is the forecast that tells you what to order and book today.

The example already in it

The file opens on three weeks of a house renovation, Monday 19 October to Friday 6 November 2026: windows and doors, rough electrical and plumbing, roofing, insulation, exterior painting and the first days of drywall. Those dates are not invented. They are what the free scheduler returns for its 21-task renovation sample once the job is fitted to a general crew of three, which is why that row of the crew panel touches three and never goes over. Roofing starts on Friday the 23rd because that is when the crew comes off windows and doors. The notes on the roofing, insulation, painting and drywall rows are marked as examples — overwrite all of it with your own job.

Where the dates should come from

A look-ahead is a slice of the master schedule, and it is only as trustworthy as that schedule. Typed by hand, nothing checks that the dates respect the order of the work or the size of your crews. The better route is to plan the whole job in the free resource leveling scheduler — up to 60 tasks, using the Gantt chart template as input — and let it fit the job to your people. Then copy the activities that fall in the next three weeks, with their solved start dates, into this sheet.

To be clear about what exists: the scheduler has no button that exports a look-ahead, so that copy is manual, and this file cannot be uploaded to the scheduler — its layout is different from the template the solver reads. The construction planning and scheduling page walks through the full-job side of it.

What this sheet will not do

There is no dependency logic: start dates are typed, so if the activity before one slips, you move it yourself. It assumes a Monday-to-Friday week, so Saturday work does not appear in the grid. And it does not track percent complete. Those limits are deliberate — a look-ahead that is quick to update each week gets updated each week.

Common questions

How is a look-ahead different from the project schedule? The master schedule covers the whole job at the level of phases and milestones and is revised now and then. The look-ahead covers three weeks at the level of crews and deliveries, and it is redone every week.

Why three weeks rather than two or six? It is a common convention: far enough out to order materials and book inspections in time, near enough that the dates are still believable. Some teams run two or four.

Can I change the length? Yes. Copy the last day column of the grid and of the crew panel to the right, one column per extra working day, and extend the two shaded ranges under Conditional Formatting → Manage Rules to match.

Does it work in Google Sheets? Upload the .xlsx to Google Drive and open it with Sheets; every function it uses exists there.