Reliability Matrix Builder — Equipment Criticality Scoring Tool (Excel + Quick-Start Guide)

Stop guessing which equipment deserves your maintenance hours.

Most plants treat every asset as equally critical — which means nothing is. The PM schedule ends up built on habit, fear, and whoever complained loudest at the last meeting.

The Reliability Matrix Builder fixes that. You score every asset on six dimensions — production impact, safety and environmental, repair cost and lead time, failure history, redundancy, and detectability — and the math tells you where your hours, your spares budget, and your condition monitoring actually belong. No subscription, no login, no cloud account. It's an Excel workbook. It runs on your machine and your data never leaves it.

What you get:

• A 7-tab Excel workbook (works in Excel; locked formulas, open input cells — you can't break the math by accident)
• Six weighted scoring dimensions with plain-language 1–5 definitions for every score, so the argument gets settled by the definition, not by who talks loudest
• An automatic criticality matrix and a ranked output sheet — tier, recommended PM band, and a spares flag for every asset, ready to bring to the planning meeting
• A fully worked 40-asset sawmill example so you can see exactly how it behaves before you touch your own plant
• Adjustable weights and tier thresholds — push safety higher for a food plant, push cost higher for a remote site
• A 14-page Quick-Start Guide that walks you through running the scoring session: who's in the room, how long it takes, the ground rules, and the three classic screw-ups to avoid

Who it's for: maintenance planners, reliability techs, and millwrights who'd rather defend a run-to-failure decision with a number than a hunch.

Built by Ryan McIntosh — Red Seal Journeyman Millwright, 30 years in pulp mills, sawmills, and heavy industry. Author of Wrench Time.

Want this facilitated — the scoring session run, the PM program rebuilt around the results, the whole thing wired into a CMMS? That's what I do: ryanmcintosh.ca