FMEA Worksheet and RPN Calculator

Rate each failure mode for severity, occurrence and detection, get an RPN that sorts the worksheet, and track the reduction after actions are taken.

The interactive tool loads here when JavaScript runs.

About this tool

What is the FMEA worksheet?

This is a Failure Mode and Effects Analysis worksheet in the browser. For each component or process step you record a potential failure mode, its effect, cause and current controls, then rate Severity, Occurrence and Detection from 1 to 10. The tool multiplies the three into a Risk Priority Number (RPN) and sorts every row from highest RPN to lowest.

Each row also has Post-Action Ratings. When a row is added they start equal to the current ratings, so the worksheet shows no improvement until you record one; after you take action, set the new severity, occurrence and detection and the row shows the new RPN next to the old one. The FMEA Summary reports total items, average RPN, the count of rows at RPN 120 or above, and the average RPN reduction.

Export and Import move the worksheet as JSON, and Download as Image saves the summary card. The worksheet is saved in this browser as you edit, and the Share button copies the tool's address only, not your data. Everything runs in your browser.

  • RPN = Severity x Occurrence x Detection, recalculated on every change
  • Worksheet sorted by RPN with Low, Medium, High and Critical badges
  • Post-action ratings with new RPN and average reduction
  • JSON export and import (RPNs are recomputed on import) and summary image download
  • Sample checkout-process FMEA
Read the guide: FMEA and RPN Explained: Severity, Occurrence, Detection

Updated

How to use the FMEA worksheet

  1. Fill in the Analysis Title, Process/Product Name, Prepared By and Date.
  2. Click Add Failure Mode. Enter the component or process step and the potential failure mode (both required), plus effect, cause and current controls.
  3. Choose Severity, Occurrence and Detection from 1 to 10; the RPN updates as you choose. Add recommended actions, responsibility and target date, then click Add Item.
  4. Click a row to expand it. After actions are taken, set New Severity, New Occurrence and New Detection and describe the Actions Taken; the new RPN appears beside the original.
  5. Use Export to save the worksheet as JSON, Import to load one, and Download as Image to capture the summary. Load Sample shows an e-commerce checkout FMEA.

Worked example

The built-in e-commerce checkout sample

Input

Payment Gateway, Transaction timeout: S8 x O4 x D3
Cart Session, Cart data loss: S6 x O5 x D4
Inventory Check, Stock discrepancy: S9 x O3 x D5
Post-action: 8x2x2, 6x2x3, 9x1x2

Output

Sorted: Inventory Check 135 (High), Cart Session 120 (High), Payment Gateway 96 (Medium)
New RPNs: 18, 36, 32
Summary: Average RPN 117, High or Critical (RPN 120+) 2, Avg RPN Reduction -88

The average reduction is ((135-18) + (120-36) + (96-32)) / 3 = 265 / 3, rounded to 88. Note that the inventory row carries severity 9; under AIAG-VDA Action Priority it would need action because of that severity even if its RPN were low.

Background and insight

FMEA began as a US military procedure, MIL-P-1629, in 1949. NASA used it in the Apollo programme, and the automotive industry adopted it in the 1970s; the AIAG manual and SAE J1739 made it standard practice for suppliers. Design FMEA (DFMEA) looks at how a product can fail; Process FMEA (PFMEA) looks at how a manufacturing or business process can fail.

The classic scoring is RPN = Severity x Occurrence x Detection, each on a 1 to 10 scale, giving 1 to 1000. Detection runs backwards from the other two: 1 means the current controls will almost certainly catch the failure, 10 means it will almost certainly reach the customer. The RPN bands in this tool (under 80 Low, 80 to 119 Medium, 120 to 199 High, 200 and above Critical) are the tool's own guide, not part of any standard.

RPN has well-known flaws. Different combinations give the same number: 9 x 2 x 5 and 3 x 6 x 5 both make 90, but a severity 9 failure (a safety or legal issue) deserves attention that a severity 3 one does not. For that reason the joint AIAG and VDA FMEA Handbook, first published in 2019, replaced RPN with Action Priority, a lookup table that weighs severity first and rates each row High, Medium or Low. If you work to that handbook, use RPN here as a sorting aid and apply AP from the handbook's tables.

Common use cases

  • Manufacturing PFMEA

    Quality engineers rate each process step for failure risk before a production launch or a line change.

  • Software and service reliability

    Engineering teams rate failure modes in a checkout, payment or data pipeline and plan safeguards.

  • Medical and lab processes

    Process owners review where a sample, record or dose could go wrong and what currently catches it.

  • Supplier quality reviews

    Buyers and supplier quality engineers record a vendor's failure modes and track corrective actions.

Tips and limitations

  • Agree the 1 to 10 rating criteria with the team first; most RPN arguments are really disagreements about the scale.
  • Act on any severity 9 or 10 failure regardless of its RPN. Multiplying can hide a safety or regulatory problem behind a low occurrence score.
  • Lowering severity usually needs a design change. Most actions reduce occurrence (prevent the cause) or detection (catch it sooner).
  • Remember that a lower detection number is better. A test that catches every failure is a 1, not a 10.
  • Reloading keeps the worksheet in this browser, but it is not synced, so export the JSON after each session.

Sources and further reading

  1. AIAG & VDA FMEA Handbook, Automotive Industry Action Group. The 2019 joint handbook that replaced RPN with Action Priority
  2. J1739: Potential Failure Mode and Effects Analysis (FMEA) Including Design FMEA, Supplemental FMEA-MSR, and Process FMEA, SAE International. The SAE standard for Design and Process FMEA
  3. Failure Modes and Effects Analysis (FMEA) Tool, Institute for Healthcare Improvement. An FMEA worksheet adapted for healthcare and service processes

Frequently asked questions

How is RPN calculated in FMEA?

RPN is Severity multiplied by Occurrence multiplied by Detection, each rated from 1 to 10, so it ranges from 1 to 1000. A failure rated severity 8, occurrence 4 and detection 3 has an RPN of 96. This tool recalculates it every time a rating changes and sorts the worksheet by it.

What is a good RPN threshold for action?

There is no universal threshold. Many teams act above 100 or 120, and this tool flags 120 and above as High and 200 and above as Critical, but those cut-offs are a convention. Always act on severity 9 or 10 failures whatever the RPN, and focus on the top of the sorted list.

Has RPN been replaced in the AIAG-VDA FMEA handbook?

Yes. The AIAG and VDA FMEA Handbook, first published in 2019, replaced RPN with Action Priority, which uses lookup tables to rate each failure High, Medium or Low, giving severity the most weight. RPN is still widely used outside that handbook and remains a handy sorting aid.

Why does a higher detection score mean more risk?

Because the detection scale rates how likely the failure is to escape your controls. A 1 means current controls will almost certainly catch it before it reaches the customer, and a 10 means there is effectively no way to detect it. Improving detection lowers the number.

What is the difference between DFMEA and PFMEA?

Design FMEA (DFMEA) examines how a product design can fail to meet its function, while Process FMEA (PFMEA) examines how a manufacturing or business process can fail to produce the intended result. The scoring is the same; this worksheet works for either.

Why does a new FMEA row show no RPN reduction?

Post-action ratings start equal to the current ratings when you add a row, because no action has been taken yet. Expand the row and set New Severity, New Occurrence and New Detection once actions are in place; the new RPN and the average reduction then update.

Does the Share button include my FMEA data?

No. Share copies the address of the FMEA tool only. To give someone your worksheet, click Export and send them the JSON file, which they can load with Import.

Is there an in-depth guide to the FMEA worksheet?

Yes. “FMEA and RPN Explained: Severity, Occurrence, Detection” covers the background, how it works, common pitfalls and worked examples. Read the full guide.