# PFMEA Worksheet with Automatic RPN

> Source: https://netray.co/tools/pfmea-worksheet-with-rpn-excel
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Fill a process FMEA row by row. RPN is calculated from S, O and D and the worst risk is summarised for you.

## Category

quality

## Industry

Discrete Manufacturing

## Audience

- Quality engineer
- Process engineer
- Supplier quality

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Process step

**Key:** step

**Type:** text

#### Potential failure mode

**Key:** mode

**Type:** text

#### Potential effect

**Key:** effect

**Type:** text

#### Severity (S)

**Key:** sev

**Type:** number

**Help:** 1 to 10

#### Potential cause

**Key:** cause

**Type:** text

#### Occurrence (O)

**Key:** occ

**Type:** number

**Help:** 1 to 10

#### Current controls

**Key:** control

**Type:** text

#### Detection (D)

**Key:** det

**Type:** number

**Help:** 1 to 10

#### RPN

**Key:** rpn

**Type:** number

**Expr:** sev * occ * det

**Format:** integer

#### Recommended action

**Key:** action

**Type:** text

#### Owner

**Key:** owner

**Type:** text

#### Target date

**Key:** due

**Type:** date

**Rows:**

#### OP20 CNC turn bore

**Mode:** Bore oversize

**Effect:** Bearing fit loose, field noise

**Sev:** 7

**Cause:** Tool wear not compensated

**Occ:** 5

**Control:** First-off and hourly bore gauge check

**Det:** 4

**Action:** Add tool life counter and auto offset

**Owner:** Process eng

**Due:** 2026-11-15

#### OP30 Deburr

**Mode:** Burr left on cross hole

**Effect:** Seal damage at assembly

**Sev:** 8

**Cause:** Operator skips cross hole

**Occ:** 4

**Control:** Visual check at OP40

**Det:** 6

**Action:** Poka-yoke brush fixture with presence sensor

**Owner:** Mfg eng

**Due:** 2026-12-01

#### OP50 Torque fastener

**Mode:** Under torque

**Effect:** Joint loosens, loss of function

**Sev:** 9

**Cause:** Driver out of calibration

**Occ:** 3

**Control:** Torque tool with angle monitoring

**Det:** 3

**Action:** Calibration interval review

**Owner:** Quality

**Due:** 2026-11-30

#### OP60 Final inspect

**Mode:** Wrong label applied

**Effect:** Customer receives mixed part

**Sev:** 6

**Cause:** Manual label selection

**Occ:** 3

**Control:** Scanner verify against work order

**Det:** 2

**Action:** None required

**Owner:** Quality

**Due:** 2026-12-15

**Totals:**

#### Highest RPN

**Key:** rpn

**Agg:** max

**Format:** integer

#### Average RPN

**Key:** rpn

**Agg:** avg

**Format:** integer

#### Lines

**Key:** step

**Agg:** count

**Format:** integer

**Summary:**

#### Gap between highest and average RPN

**Key:** spread

**Expr:** max_rpn - avg_rpn

**Format:** integer

**Description:** A large gap means one or two lines dominate the risk.

**Notes:** Rate S, O and D on 1 to 10 scales agreed by your team. The RPN has known weaknesses: always review high severity lines (9 or 10) regardless of RPN. Use the sort and export controls to hand the sheet to your customer or auditor.

## Content

**Intro:** A process FMEA lists how each manufacturing step can fail, what that does to the customer, and what you already do to prevent or catch it. This worksheet calculates RPN as you type so you can see where to act first. Export it to Excel or PDF when the team review is done.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per process step, failure mode and cause combination. Describe the failure mode as a loss of the step's intent, such as bore oversize or missing weld. Record the effect on the next operation and on the end customer, then rate severity for the worst effect. Rate occurrence for the cause and detection for the current control that would catch the cause or the failure mode before it ships. Edit the example rows or delete them and start fresh.

**Bullets:**

- One failure mode can have several causes, each on its own row
- Rate detection on current controls only, not planned ones
- Fill the action columns for every line above your risk threshold
- Re-rate S, O and D after an action is verified, not before

#### The RPN formula and its limits

**Body:** The classic risk priority number is severity times occurrence times detection, giving a value from 1 to 1000. It ranks lines so the team knows where to look first. The weakness is that very different combinations give the same number: S9, O2, D2 gives 36 while S3, O4, D3 also gives 36, yet the first involves a possible safety effect. Many customers now use severity-first rules or the AIAG-VDA action priority method instead. Use RPN as a sorting aid, never as the only reason to close a line.

#### Reading the result

**Body:** Sort the table by RPN and work from the top, but also scan the severity column. Any line with severity 9 or 10 needs an action or a documented justification, whatever its RPN. Compare the highest RPN with the average: if one line towers over the rest, fix it first and re-rate. Set a threshold with your customer, such as action required above 100, and record it in your FMEA procedure so audits find a consistent rule.

#### Common mistakes and ERP links

**Body:** Teams often fill the sheet alone at a desk, rate detection on inspection that does not exist, or lower occurrence without evidence. Use real scrap, rework and nonconformance data to support occurrence ratings. In ERP or MES, link each process step to the routing operation so a failure mode points to the right work center, and pull defect history from quality records to justify the ratings. Keep the PFMEA, process flow and control plan aligned when any one of them changes.

**Cta:** If your defect and scrap history lives in your ERP, Netray can help pull it into FMEA reviews so occurrence ratings rest on data. This tool works fully without us.

**Faq:**

#### What is a good RPN value?

**Answer:** There is no universal limit. Many companies use 100 as an action trigger, others use a Pareto of the top lines. What matters is a documented rule agreed with your customer, plus mandatory review of any line with severity 9 or 10.

#### Is RPN still used in the AIAG-VDA method?

**Answer:** The 2019 AIAG-VDA handbook replaced RPN with action priority, rated High, Medium or Low. Many plants still keep an RPN column for legacy customers or internal trending, so this worksheet supports both ways of working.

#### How many rows should a PFMEA have?

**Answer:** As many as the process needs. A simple machined part might have 20 to 40 lines, a complex assembly several hundred. Prefer clear cause level rows over a short sheet that hides real failure paths.

#### Can I save my work?

**Answer:** Everything runs in your browser. Export to Excel, CSV or PDF before closing the page to keep your data, then re-enter or paste it later.

## Search terms

pfmea template excel, pfmea worksheet, process fmea rpn calculator, pfmea format, fmea rpn calculation, process failure mode and effects analysis template, pfmea example, free pfmea template

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json