The Weekly Maintenance Schedule in Excel: Plan a Week Your Crew Can Actually Do

Every plant has a maintenance schedule. Most of them are fiction. The list says twelve jobs will happen this week; the crew has hours for seven; and by Thursday everyone quietly agrees to stop looking at the list. The schedule didn't fail because people were lazy — it failed because it never respected capacity.

You don't need scheduling software to fix that. You need a grid, honest hour estimates, and one weekly ritual. Excel handles all three.

The shape that works: technicians across, days down

Skip the giant to-do list. Build a board: one column per technician, one row per working day (or the reverse — pick one and stay consistent). Each cell holds the jobs that person does that day, written as WO number — short title (est. hours).

Two rules make this shape powerful:

1. Every job gets an hour estimate. Not a perfect one — a defensible one. "About 2 hours" beats a blank every time, because blanks are what let a day silently absorb 14 hours of work.
2. Every cell gets a capacity line. If your techs have 8 working hours, plan to 6. Breakdowns, parts runs, and "hey, while you're here" eat the other two whether you plan them or not. A schedule at 100% capacity is a schedule that's already late.

Put a simple =SUM() of estimates at the bottom of each day and color it: green under 6, amber to 8, red over. That one conditional format is your overbooking alarm — it turns "I think Tuesday is heavy" into "Tuesday is 9.5 hours on a 6-hour plan."

Feed it from two lists, not from memory

The board is only the front page. Behind it, keep two sheets:

• The backlog — every open work order with priority, asset, and estimated hours. This is where unscheduled work waits visibly, instead of in your head.
• The PM list — recurring jobs with their next-due dates. Anything due this week gets pulled onto the board first, before corrective work fills the space. If PMs only get scheduled "when there's time," there is never time — and you pay for it in breakdowns.

Scheduling then becomes a mechanical act: PMs due this week → high-priority corrective → whatever else fits under the capacity line. Anything that doesn't fit stays in the backlog for next week, on purpose, instead of pretending.

The Monday ritual (15 minutes)

A schedule is a living document or it's wallpaper. Once a week, same time:

1. Close out last week. Anything finished gets marked done, with actual hours next to the estimate. (Those actuals are how your estimates get honest over time.)
2. Roll forward what slipped. Unfinished jobs move — deliberately, to a day with room — not by default to "someday."
3. Pull the new week. PMs due, then priority work, until each day hits its capacity line. Stop there. Really.

Fifteen minutes. The plants that do this consistently outperform plants with expensive software they don't ritualize.

Three failure modes to watch

• The invisible overbook. Someone adds "one quick job" to Wednesday without an estimate. Multiply by five and Wednesday is fiction again. Rule: no estimate, no cell.
• The hero column. One tech's column is always red while another's is always green. That's not a scheduling problem, it's an assignment habit — the board just finally makes it visible.
• Emergency amnesia. Breakdowns will happen; that's why you planned to 6 hours, not 8. When one blows up a day, move the displaced jobs on the board so the loss is explicit instead of silent.

Where a template helps

You can build all of this yourself — the board, the backlog, the PM list, the capacity sums. If you'd rather skip an afternoon of setup, the CMMS Lite workbook below has the work-order log and PM schedule ready to run; add the weekly board tab on top and you have the full system.

And when the board outgrows the spreadsheet — two people editing at once, techs who need it on a phone, drag-to-reschedule instead of cut-and-paste — that's exactly what maintenance scheduling software does: the same technician-by-day board with capacity and overload warnings computed for you, fed automatically by your work orders and preventive maintenance.

Want the whole loop without the formulas? Start a free 30-day MaintainFlow trial — the planner board is built in.