Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainManufacturing & OperationsPreventive Maintenance Schedule

SpreadsheetManufacturing & OperationsFree

Preventive Maintenance Schedule

Every PM task with its interval, last done and next due date, overdue and due-this-week flags, and a completion log that tracks PM compliance.

Shown with sample data

Colour

Preventive Maintenance Schedule

Every PM task with its interval, last done and next due date, overdue and due-this-week flags, and a completion log that tracks PM compliance.

Overdue tasks
3
Due this week
2
Hours due in 7 days
6
Including overdue
PM compliance
71%
Jobs done by their due date
Jobs logged
7
Parts cost
$301
Labour hours
7.5
Est. hours over time
Nov 9, 2026Oct 1, 2026

Latest: 2

How to use it

  1. 1List every PM task with its own Task ID, asset, area, interval in days and assigned technician.
  2. 2Type the date each task was last done; Next due and Status calculate for you.
  3. 3Plan the week from tasks marked Overdue and Due this week.
  4. 4When a job is finished, log it on the Completion log and update Last done on the schedule.
  5. 5Review PM compliance monthly; aim for 90% or more completed on time.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Breakdowns cost far more than planned maintenance. List each PM task by asset with its interval in days and the date it was last done; the schedule works out the next due date, days left and whether it is Overdue, Due this week or Scheduled. Log each completed job with hours and parts cost, and the PM compliance KPI shows how many jobs were done on time, the measure every maintenance manager is asked for.

Who it’s for

  • Plants without a CMMS
  • Building and facility maintenance
  • Weekly maintenance planning meetings
  • Audits that ask for maintenance records

What’s included

  • PM schedule sheet: Every PM task with its next due date and status.
  • Completion log sheet: Each completed PM job with hours, parts and findings.

How to use it

  1. 1List every PM task with its own Task ID, asset, area, interval in days and assigned technician.
  2. 2Type the date each task was last done; Next due and Status calculate for you.
  3. 3Plan the week from tasks marked Overdue and Due this week.
  4. 4When a job is finished, log it on the Completion log and update Last done on the schedule.
  5. 5Review PM compliance monthly; aim for 90% or more completed on time.

Tips

  • Base intervals on the manufacturer’s manual first, then adjust with your own failure history.
  • Many plants count a PM as on time if it is done within 10% of its interval; change the On time rule to match yours.
  • Note findings on every job. Repeated findings on the same asset are a signal to change the interval or the task.

Questions

How is the next due date calculated?

Next due = Last done + Interval (days). Use 7 for weekly, 30 for monthly, 91 for quarterly, 182 for semi-annual and 365 for annual tasks.

What is PM compliance?

The share of scheduled PM jobs completed on or before their due date in the period. It shows whether the maintenance plan is actually being followed.

Should PMs be time-based or usage-based?

Time-based suits assets that age regardless of use (fire systems, HVAC filters). Usage-based (hours, cycles, miles) suits production equipment; convert usage to an approximate interval in days for this schedule.

Related searchespreventive maintenance schedulepm schedule templatemaintenance planner excelplanned maintenance schedulepm compliancemaintenance checklist schedule

Details

Format
Spreadsheet
Category
Manufacturing & Operations
Sheets
2
Setup
25 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetManufacturing & OperationsFree

Preventive Maintenance Schedule

Every PM task with its interval, last done and next due date, overdue and due-this-week flags, and a completion log that tracks PM compliance.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Manufacturing & Operations
Sheets
2
Setup
25 min
Level
Intermediate
Price
Free

Your copy is private to you.

More manufacturing & operations templates

View all
Equipment Maintenance Log3 sheets

Overdue

1

Due in 14 days

3

Maintenance spend

$2,875

ABCD
1EquipmentLocationTypeInterval (days)
2Commercial espresso machineFront counterKitchen90
3Walk-in fridgeKitchenRefrigeration180
4DishwasherKitchenKitchen120
5HVAC unitRoofBuilding180
Assets
SpreadsheetManufacturing & Operations

Equipment Maintenance Log

Preventive maintenance due dates from each asset's service history, with overdue alerts, repair and downtime tracking, and maintenance cost by asset and month.

10 min setupPreview
Weekly Production Schedule3 sheets

Attainment

100%

Yield

99%

Downtime

160

ABCD
1DateLineOrder #Product
2Nov 5Line 1MO-871Sourdough loaf 800g
3Nov 5Line 2MO-872Granola bar 40g
4Nov 5Line 3MO-873Oat cookies 12pk
5Nov 6Line 1MO-874Seeded rolls 6pk
Schedule
SpreadsheetManufacturing & Operations

Weekly Production Schedule

Plan production orders by line, day and shift, then record output, scrap and downtime to see attainment, yield and performance by line and day.

10 min setupPreview
OEE Calculator2 sheets

Average OEE

79%

Availability

90%

Performance

90%

ABCD
1DateLineShiftPlanned minutes
2Nov 3Line 1Day450
3Nov 3Line 1Night450
4Nov 3Line 2Day450
5Nov 3Line 2Night450
Shifts
SpreadsheetManufacturing & Operations

OEE Calculator

Overall Equipment Effectiveness by shift: availability, performance and quality, and where time is lost.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ