Motor register workbook
A free Excel file for every electric motor on your site, one line each: where it is, what the nameplate says, which bearings it takes, how it is protected, and when it is next due for service. Overdue motors turn red on their own.
What is in it
| Tab | What it does |
|---|---|
| Register | One row per motor, 500 rows ready. A summary line on top counts motors, installed kW, and how many are overdue or due in the next 30 days. Filters on every column; the tag and the headings stay in view as you scroll. |
| Spares | The bearings you keep on the shelf, how many, and your minimum. It counts how many motors in the register take each bearing, and flags the ones to reorder. |
| Lists | The choices behind the drop-downs: criticality, status, mounting, IP, IE class, duty, starter. Add your own and the drop-downs pick them up. |
| How to fill it | Every column, and where to find it on the nameplate. |
The columns
Columns shown in grey work themselves out from the others, so there is nothing to type in them.
| Where it is | Tag, Location / line, Drives, Criticality, Status |
|---|---|
| Nameplate | Maker, Type / model, Serial no., Power, Unit, kW, Volts, Amps (FLA), Hz, rpm, Poles, Frame, Mounting, IP / enclosure, Ins. class, Efficiency, Duty, SF |
| Bearings | DE bearing, NDE bearing, Grease |
| Protection | Starter, Overload set (A), Overload check, Cable, Breaker / fuse |
| Service | Installed, Last service, Every (months), Next due, Due?, Notes |
- kW: from the plate's power, converting HP at 0.7457 so that a mixed IEC and NEMA site still sorts and adds up.
- Poles: from rpm and frequency. 2,915 rpm at 50 Hz is a 2-pole motor; 1,750 rpm at 60 Hz is a 4-pole.
- Overload check: flags a relay set more than 25% above the plate current, or well below it.
- Next due and Due?: last service plus the interval in months, then Overdue, Due in 30 days, or OK against today's date.
Filling it in
Start with the tags and locations only — one walk round with a clipboard. Fill in the rest the next time you are at each motor, beginning with the A-critical ones: those are the motors to keep a spare for. If you aren't sure what a line on the plate means, the nameplate guide goes through each one, and the IEC and NEMA frame charts turn a frame size into shaft and foot dimensions.
The first three rows are worked examples: type over them. One is overdue and one has its overload set for the wrong voltage, so you can see the flags working.
Why a spreadsheet
Most sites already keep one; it's usually missing the bearings and the service dates. This one keeps a fixed layout — one motor per row, a unique tag in the first column — so it can be sorted, filtered, printed and later imported into a maintenance system without retyping. We're building a maintenance planner that will read this file.
Hear when the planner is ready
The Shop Sheet, once a month: one new printable chart, and one standards gotcha that catches people out — the kind of wrong number a forum thread or an AI answer gives with total confidence. No sales emails.