Template Library
RCM Worksheet Template
An Excel workbook for Reliability-Centered Maintenance: rank assets by criticality, then record functions, failure modes, consequences, and the maintenance task chosen for each.
The Criticality Ranking tab scores each asset on likelihood and consequence (1 to 5), then calculates the score, a High, Medium, or Low tier from cut-offs you can edit, and a rank. The RCM Analysis tab is an Excel Table that walks through the seven RCM questions row by row, with drop-down lists for the consequence category and task type.
For condition-based tasks the worksheet suggests a maximum check interval of half the P-F interval you enter. The Summary tab counts assets by tier, tasks by type, and failure modes by consequence, with a chart. Example rows for a cooling-water pump and a relief valve are included so you can see the formulas working before you replace them.
What Is Included in the Workbook
| Sheet | Purpose | What Teams Capture |
|---|---|---|
| How-To | Method guidance and disclaimer | Steps, notes, category definitions |
| Criticality Ranking | Asset ranking (Excel Table) | Asset, area, likelihood, consequence; score, tier, and rank calculate; editable tier cut-offs |
| RCM Analysis | Failure mode analysis (Excel Table) | Function, functional failure, failure mode, effect, consequence, task type and description, P-F interval, chosen interval, owner, status |
| Seven Questions | Reference | The seven RCM questions for quick reference in a workshop |
| Summary | Live rollup and chart | Assets by tier, tasks by type, failure modes by consequence |
Key Features Inside the Template
Criticality First
A scoring sheet with editable tier cut-offs helps a team decide which assets deserve a full analysis and which do not.
Task Selection by Consequence
Drop-downs for consequence category and task type keep the analysis consistent and make the program easy to summarize.
P-F Interval Guidance
Enter the P-F interval for a condition-monitoring task and the worksheet suggests a check interval of half of it.
Summary and Chart
See how many tasks are condition-based, failure-finding, or run to failure, and where hidden and safety consequences sit.
Best Use Cases
- Facilitated RCM workshops for critical pumps, compressors, turbines, and electrical equipment
- Reviewing an existing preventive maintenance program and removing tasks without a failure mode
- Documenting failure-finding tasks for protective devices
- Training reliability and maintenance teams in the RCM method
How to Use the Template Effectively
- List assets and score criticality as a team, then choose the highest-tier assets for analysis.
- For each asset, write the function with its performance standard, then list functional failures and failure modes.
- Record the effect and classify the consequence, including hidden failures.
- Choose the task type by consequence, and record the P-F interval where it applies.
- Review the program after failures and at least annually, and retire tasks that no longer earn their place.
Who Should Use This Template
- Reliability and maintenance engineers leading RCM studies
- Operations and maintenance planners reviewing a preventive maintenance program
- Asset managers building a criticality-based maintenance strategy
Common Mistakes to Avoid
- Analyzing every asset in full instead of starting with the critical few
- Choosing scheduled overhauls for random failures that do not depend on age
- Forgetting hidden failures in protective and standby equipment
- Treating the worksheet as finished, without feeding back real failure data
Important Notes
RCM Worksheet Template Frequently Asked Questions
How many assets should I analyze in detail?
Start with the highest-criticality assets, often a small fraction of the total. Use the Criticality Ranking sheet to choose them, and analyze lower-tier assets more simply, for example with a standard preventive maintenance template.
Can I change the criticality scale or tiers?
Yes. The tier cut-offs are in cells L5 and L6 of the Criticality Ranking sheet. If you use a different scale, adjust the drop-down ranges and the labels to match your organization's risk criteria.
Does this replace a formal RCM study?
No. It is a documentation aid that follows the RCM structure. A formal study conforming to a standard such as SAE JA1011 involves a trained facilitator, operating-context definitions, and a review process defined by your organization.