How is the next date calculated?

Date of the last job + the interval in days.

How do I mark a job as done?

Enter the job in the “Work log” and the schedule updates.

Can I print the schedule?

Yes, the “PM schedule” sheet is set up for printing.

No. The file works in Excel 2007 and later and in LibreOffice, and all calculations use ordinary formulas.

Planned Preventive Maintenance Schedule — Excel Template

Planned maintenance tracker: equipment list, service intervals, a log of completed work and a maintenance schedule, with overdue jobs highlighted.

490 ₽

≈ 5 USD

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

Equipment breaks down when maintenance is skipped. From the date of the last maintenance and the service interval, the workbook works out the next job, shows what is overdue and builds a schedule.

What is inside

“Equipment”: a list with service intervals and the person responsible.
“Work log”: what was done and when.
“PM schedule”: upcoming and overdue planned work, most urgent first.
“Summary”: costs and downtime by area.

Who it is for

Chief engineers, mechanics, maintenance and facilities managers, and managers of production sites and buildings.

What you get

An empty template and a filled-in sample with fictitious data, so you can see how the formulas and checks work. It is an Excel template built on ordinary formulas, not an accounting program. All fixes and new versions of the project are free.

Compatibility

Excel 2007 and later, LibreOffice. No macros. Service intervals are entered by you: follow the manufacturer’s documentation. The calculation is indicative. The file is in English.

Questions and answers

How is the next date calculated?: Date of the last job + the interval in days.
How do I mark a job as done?: Enter the job in the “Work log” and the schedule updates.
How much equipment can I track?: Up to 60 pieces.
Can I print the schedule?: Yes, the “PM schedule” sheet is set up for printing.
Do I need macros?: No. The file works in Excel 2007 and later and in LibreOffice, and all calculations use ordinary formulas.