Excel workbook (.xlsx)
Preventive Maintenance Planner – Excel Template (PM Schedule, Overdue Tracker, 12-Month Workload by Craft)
Recurring maintenance tasks with next due dates, OVERDUE / DUE SOON flags, a 12-month plan grid and a monthly hours-per-craft workload chart. No macros, no subscription.

Description
A CMMS-lite for small teams and contractors. List your recurring tasks once, enter the date each time a job is done, and the planner keeps track of what is due.
What it does
- PM plan (500 tasks): asset / tag, task, location, craft, priority, interval in days, weeks, months or years, estimated hours, last done (or first due for new tasks) and responsible person.
- Next due date and days to due, with status OK / DUE SOON / OVERDUE (warning window adjustable).
- 12-month plan grid: how many times each task falls due in each month, starting from the current month (or a month you choose). Overdue tasks are planned in the first month and repeat from there.
- Monthly workload: tasks and planned hours per month, in total and per craft (Instrument, Electrical, Mechanical, Analyser, Contractor, all renamable), with a stacked column chart.
- KPIs: tasks, overdue, due soon and hours per year.
What's included
Preventive_Maintenance_Planner.xlsx
- Instructions sheet - Blank PM Plan and Monthly Workload sheets - EXAMPLE versions with 22 typical instrumentation / E&I / mechanical / contractor tasks - Lists (crafts, priorities, interval units)
Example_PM_Planner_PREVIEW.pdf
Who it's for
Maintenance supervisors, instrument and E&I technicians, small plants without a CMMS, and service contractors who plan recurring work for their clients.
Compatibility
Excel 2016 / 2019 / 2021 / 365 (Windows / Mac), LibreOffice Calc 7+. No macros. Formula cells are protected without a password. The file has frozen headers, filters, dropdowns and A4 print setup.
Note
Statuses are based on today's date and update automatically. Intervals in the example are illustrative. Use manufacturer, regulatory and SIL-verification intervals for real plans.
Licence
Single user / single company. Reselling or redistributing the template is not allowed.
---
More in Excel templates
- Instrument Calibration Certificate & Log – Excel Template (4-20 mA / HART, As-Found / As-Left)
- Loop Check & Commissioning Pack – Excel Template (AI / AO Control Valve / DI / DO Loop Sheets, Punch List, Progress Dashboard)
- Instrument Index & I/O List – Excel Template (ISA Tag List, Tag Validation, I/O Count & Spare Capacity)