Tracking tools · guide
Maintenance tracker: the guide
Preventive maintenance fails on the schedule, not the wrench. A plant that knows what is due this week, and marks it done when it is, keeps its levelers, doors, and lift trucks running; the tracker is the whiteboard that does the arithmetic.
Why this number matters
Most plants under a few hundred people run maintenance from a whiteboard, a spreadsheet, and the memory of one person. It works until that person is on vacation during the week the compressor's 2,000-hour service comes due, or until the leveler that was supposed to be inspected quarterly has not been touched in a year and drops a lift truck. A computerized maintenance management system fixes this and costs five figures a year plus a month of setup, which is why most plants never get one. The tracker is the part of a CMMS that matters on a plant floor: a list of equipment, a PM task per machine with an interval, a view of what is due, a button that marks it done and writes the log, and a work log that captures what broke, how long it was down, and what it cost.
Intervals are the design decision. Dock levelers, doors, and restraints run on the calendar: quarterly, semi-annual, before the season. Lift trucks, compressors, and generators run on the meter: every 250 or 500 hours, whatever the dealer's schedule says. The tracker takes both, and a task with both comes due at whichever arrives first. Entering the last-done date and meter when the task is created is what makes the first due dates true; without them, everything is due today and the list is noise.
PM compliance, the share of tasks done on or before their due date over the last 90 days, is the one number that tells whether the schedule is a plan or a wish. Downtime hours and repair cost by machine, from the log, are what justify replacing the door that eats a spring every quarter instead of fixing it again. The records live in the browser, with a backup file for the shared drive, because the first goal is to be running in an afternoon on the computer in the maintenance office.
How it is figured
- A PM task belongs to one asset and has a calendar interval in days, a meter interval in hours, cycles, or miles, or both; it is due at the earlier of the two.
- Due date = last done + interval days; due meter = meter at last service + interval; the meter is read from the asset, so updating the asset's meter updates every task on it.
- Mark done writes a log entry with the date, the meter, the hours down, and the cost, and resets the task's last-done.
- PM compliance = PM log entries in the last 90 days done on or before their due date ÷ all PM entries due in that window.
- Downtime and cost by asset are sums over the log for the period shown; the dashboard lists overdue, due this week, and down equipment.
A worked example
The example plant on the first screen has four dock positions, a lift truck fleet, a compressor, and the HVLS fans. Each leveler carries a quarterly inspection, each door a semi-annual service, each truck the dealer's 250-hour PM against its meter, and the compressor a 2,000-hour service. Load it, look at how the tags, the intervals, and the last-done readings are set, then clear it and build your own the same way.
The tool's starting values, and what it returns for them:
| Equipment | Levelers, doors, seals, restraints, lift trucks, a compressor, HVLS fans |
| PM intervals | Quarterly and semi-annual by calendar; 250 h and 2,000 h by meter |
| Last done | Dates and meter readings entered per task |
| Dashboard | Overdue, due this week, down equipment, PM compliance |
| PM list | Every task with its asset, interval, last done, and next due |
| Work log | Date, asset, task, hours down, cost, notes |
| Reports | Downtime and cost by asset; CSV export; printable week |
How to set it up in an afternoon
- Load the example plant and look at how a dock and a lift truck fleet are set up: tags, locations, meters, and the PM tasks with their intervals.
- Clear it and add your equipment, or download the CSV template, fill it from the fixed-asset list, and import it. Tags like FL-01 and DL-03 make the floor and the list agree.
- Add the PM tasks from the manuals: the dealer's hour schedule for lift trucks, quarterly leveler inspections, semi-annual door service, the compressor's hour service, heaters before the season. Put the last-done date and meter in so the first due dates are right.
- Every Monday, open the dashboard, print the due list, and work it. Mark tasks done as they finish; log repairs with the hours down and what they cost.
- Every Friday, download a backup to the shared drive.
Tools: the equipment manuals, the dealer's service schedule, the fixed-asset list, one computer in the maintenance office
Mistakes that catch people
- Creating tasks without the last-done date and meter, so the whole plant is overdue on day one and nobody trusts the list.
- Calendar intervals on meter equipment: a lift truck that ran 600 hours in a quarter is 350 hours past its PM when the calendar says it is fine.
- Logging repairs without the downtime, which is the number that later justifies replacing the machine.
- Letting the one person who knows the schedule keep it in their head; the tracker only helps when it is the record.
- Never backing up. The records live in one browser; the Friday backup to the shared drive is part of the routine.
Rules of thumb
- Levelers and restraints quarterly; doors, seals, and shelters twice a year; bumpers at every leveler visit; lift trucks by the dealer's hours plus a documented daily check.
- A PM compliance below about 80% means the schedule is too big for the crew or the intervals are wrong; fix the plan before adding tasks.
- If a machine's repair cost in a year passes about half its replacement cost, put it on the capital list.
When to stop calculating and make a call
- More than one person needs to work the list at once from different computers: that is the point where a multi-user CMMS earns its subscription.
- Regulated equipment (fire protection, elevators, pressure vessels, cleanroom certification) needs records in a form the inspector accepts.
- A machine is down and the cause is not obvious: the log tells the service tech what has already been tried.
Questions people ask
- Where is my data stored?
- In your browser on your computer, in local storage. It is not uploaded anywhere. Download a backup file from the Backup tab and keep it on the shared drive; restore it on any computer to continue. Clearing the browser's site data erases it, so back up before you do that.
- Can two people use it?
- Each browser keeps its own copy, so pass the backup file between them, or keep it on one shared computer in the maintenance office. A multi-user version with sign-in is the next step up.
- How are meter-based PMs handled?
- Give the task an interval in hours, cycles, or miles and the meter reading at the last service. Update the equipment's meter when you walk the floor or log work; the tracker flags the task when it comes due, or when the calendar interval does, whichever is first.
- What counts as PM compliance?
- The share of PM tasks in the last 90 days that were marked done on or before their due date.
- What should be on the PM list for a dock?
- Levelers quarterly (hydraulics, lip hinges, grease, pit clean-out), doors twice a year (springs, cables, rollers, tracks, bottom seal), seals and shelters at the same visit, restraints quarterly, bumpers at every leveler visit, lift trucks by the dealer's hour schedule and a documented daily inspection.
Standards and sources
- OSHA 29 CFR 1910.178(q): powered industrial truck maintenance and the daily examination
- Dock equipment makers' owner's manuals: inspection and service intervals for levelers, restraints, doors, and seals
- Line Item Supply: loading dock safety checklist
This guide and the tool are planning aids. The equipment maker, the engineer of record, the accountant, or the code official confirms the final number for your building.