# Reliability Centered Maintenance (RCM) Worksheet > Source: https://netray.co/tools/reliability-centered-maintenance-rcm-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Editable RCM and FMEA style worksheet that links functions, failure modes and effects to a risk rating and a task selection. ## Category maintenance ## Industry Manufacturing ## Audience - Reliability engineer - Maintenance manager - Maintenance planner ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Function **Key:** function **Type:** text #### Functional failure **Key:** functional_failure **Type:** text #### Failure mode **Key:** failure_mode **Type:** text #### Effect of failure **Key:** effect **Type:** text #### Severity (1-10) **Key:** severity **Type:** number #### Occurrence (1-10) **Key:** occurrence **Type:** number #### Detection (1-10) **Key:** detection **Type:** number **Help:** 10 = hard to detect before failure. #### Risk priority (RPN) **Key:** rpn **Type:** number **Expr:** severity * occurrence * detection **Format:** integer #### Selected task **Key:** task **Type:** select **Options:** - Condition monitoring - Scheduled restoration - Scheduled discard - Failure finding - Run to failure - Redesign #### Task interval (days) **Key:** interval_days **Type:** number **Unit:** days **Rows:** **Function:** Pump 150 m3/h of cooling water at 4 bar **Functional failure:** Delivers no flow **Failure mode:** Drive end bearing seizes **Effect:** Furnace trips on low flow, 4 h outage **Severity:** 8 **Occurrence:** 4 **Detection:** 3 **Task:** Condition monitoring **Interval days:** 14 **Function:** Pump 150 m3/h of cooling water at 4 bar **Functional failure:** Delivers low flow **Failure mode:** Impeller worn by cavitation **Effect:** Reduced cooling, higher scrap **Severity:** 5 **Occurrence:** 3 **Detection:** 5 **Task:** Condition monitoring **Interval days:** 90 **Function:** Hold standby pump ready **Functional failure:** Standby does not start **Failure mode:** Auto-start relay failed **Effect:** No backup when duty pump fails **Severity:** 8 **Occurrence:** 2 **Detection:** 8 **Task:** Failure finding **Interval days:** 30 **Function:** Convey product at 40 m/min **Functional failure:** Belt stops **Failure mode:** Gearbox oil starvation **Effect:** Line stops, 2 h repair **Severity:** 6 **Occurrence:** 3 **Detection:** 4 **Task:** Scheduled restoration **Interval days:** 180 **Function:** Convey product at 40 m/min **Functional failure:** Belt tracks off **Failure mode:** Idler roller seized **Effect:** Edge damage, minor stop **Severity:** 3 **Occurrence:** 5 **Detection:** 2 **Task:** Run to failure **Interval days:** 0 **Totals:** #### Highest RPN **Key:** rpn **Agg:** max **Format:** integer #### Average RPN **Key:** rpn **Agg:** avg **Format:** integer #### Failure modes analysed **Key:** rpn **Agg:** count **Format:** integer **Summary:** #### Gap between highest and average RPN **Key:** spread **Expr:** max_rpn - avg_rpn **Format:** integer **Description:** A large gap shows a few modes dominate the risk. **Notes:** Add one row per failure mode. After selecting a task, rescore occurrence and detection to confirm the task actually reduces risk. RPN is a ranking aid, not an absolute measure, and many teams also rank by severity first. This worksheet follows the structure of the RCM questions in SAE JA1011 without reproducing the standard. ## Content **Intro:** RCM asks what each asset must do, how it can fail and what is the right task to deal with each failure, if any. This worksheet is a practical record of that analysis, with a risk score to help decide where to spend effort first. **Sections:** #### How to use it **Body:** Start with one asset or system. Write its function in measurable terms, such as flow, speed or pressure. For each function list the ways it can fail, then the specific failure modes behind each, and the effect on safety, environment, production and cost. Score severity, occurrence and detection from 1 to 10 and the sheet computes the RPN. Then choose a task for each mode and set an interval. Rescore after the planned task to see whether it truly lowers risk, and export the result to Excel. #### Task selection logic **Body:** RCM does not assume that every failure needs preventive work. Condition monitoring fits failures that give warning before they occur. Scheduled restoration or discard suits wear out failures with a known age pattern. Failure finding checks hidden functions such as standby equipment and protective devices. Run to failure is valid when consequences are minor and repair is cheap. Redesign is for failures that no task can control. These choices follow the general decision logic described in SAE JA1011 and the wider RCM literature. **Bullets:** - Condition monitoring: warning exists and can be detected - Restoration or discard: clear wear out age - Failure finding: hidden protective functions - Run to failure: low consequence, cheap fix - Redesign: no effective task #### Reading the scores **Body:** RPN ranks failure modes so you start with the biggest risks. Do not treat the number as exact: a mode with severity 9 deserves attention even if its RPN is modest. In the example, the bearing seizure ranks highest because it trips a furnace, while the idler roller is left to run to failure. Revisit occurrence ratings with real work order history, and use cause codes in your ERP or CMMS to support them. #### Common mistakes **Body:** Analysing components instead of functions, writing vague failure modes such as pump fails, skipping hidden failures, and assigning time based tasks when failures are random. A full RCM study also needs operators and maintainers in the room. Treat the output as a living record and update it when failures reveal missing modes. The results feed PM schedules, spares decisions and inspection routes. **Cta:** Netray can mine your ERP and CMMS work order history for repeat failure modes and cause codes, so your RCM scoring is based on recorded failures rather than memory. **Faq:** #### What is the difference between RCM and FMEA? **Answer:** FMEA lists failure modes, effects and risk. RCM goes further by defining functions and selecting the maintenance task or design change that deals with each failure. This worksheet combines both. #### How do I choose the maintenance task for a failure mode? **Answer:** Ask whether the failure gives warning, whether it is age related and whether it is hidden. Use condition monitoring for detectable warnings, restoration or discard for age related wear, and failure finding for hidden functions. #### Is a high RPN always more important than a high severity? **Answer:** No. RPN multiplies three ratings, so a safety critical mode with high severity and low occurrence can score low. Review severity separately and treat safety and environmental modes first. #### How long does an RCM analysis take? **Answer:** A single system can take from a few hours to several days with a small team, depending on complexity. Start with the most critical assets and use history to speed up the work. ## Search terms rcm worksheet, reliability centered maintenance worksheet, rcm template excel, rcm failure mode worksheet, maintenance task selection worksheet, fmea for maintenance template, rcm decision logic, equipment failure mode analysis template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json