Maintenance · Updated 3 October 2026
How to use a preventive maintenance planner in Excel
Build an asset task schedule, enter completion dates and use formula-driven due dates and overdue alerts in the blank PM workbook.
Start with one task per row
The free planner starts with blank records. Enter an Asset ID, asset name, location and a specific maintenance task. Keep separate tasks in separate rows so each can have its own frequency, date and owner. A general instruction such as 'service machine' is difficult to verify; describe the inspection or service action and its acceptance requirement in your local procedure.
Choose the frequency from equipment evidence
Use the equipment manual and your approved maintenance strategy to establish frequency. Consider operating conditions and failure history when reviewing it. The workbook uses a calendar interval in days; it does not calculate runtime-based or condition-based maintenance triggers. Keep those tasks in a system that tracks the relevant meter or condition.
Understand the next due date
Before completion is recorded, the next due date follows the planned date. After an actual completion date is entered, the formula adds the entered interval in days. This is a completion-based schedule. If your site requires fixed dates regardless of late completion, use a schedule designed for that policy instead of assuming the two methods are equivalent.
The dashboard classifies dates as overdue, due this week or scheduled. Its week alert means due within the next seven days, including today. A row without the date information needed for the calculation appears as missing schedule.
Review exceptions and record the outcome
Filter the Records sheet by due status, check that an owner is assigned and record findings after the work. Retain work-order evidence and approvals in your maintenance process. A due-date dashboard tracks scheduling; it does not confirm that a task was performed correctly or that an equipment condition is acceptable.