PFMEA Toolkit (Excel) — AIAG-VDA 7-step Process FMEA with Action Priority calculated for you

RPN is gone. The AIAG-VDA handbook replaced it with Action Priority — and most PFMEA templates never caught up.

This toolkit is a working Process FMEA built for the current method: the AIAG & VDA 7-step approach (the harmonized handbook that most OEM customer-specific requirements now point to). Structure, function and failure analysis columns in flow order, prevention and detection controls kept apart the way the method demands, and an Action Priority column that answers itself — enter Severity, Occurrence and Detection, and the H / M / L letter appears, colour-coded, from the complete S-O-D logic. No more looking combinations up by hand, no more RPN thresholds to argue about.

And because a PFMEA is only as good as the documents either side of it, the workbook carries the whole chain: a process flow tab that feeds the PFMEA's step drop-down (the two documents cannot drift apart), and a control plan handoff tab that maps every special characteristic and detection control to control plan columns — the line-by-line consistency an IATF auditor reads first.

Built by working quality auditors, in plain English. No macros, no add-ins, no setup — open it and start on your next process.

What's inside

• The PFMEA sheet (AIAG-VDA 7-step format) — structure analysis (process item · step · 4M work element), function analysis, the FE–FM–FC failure chains, risk analysis with separate prevention and detection controls, and a full optimization block with owners, dates, status tracking and re-rated AP. Prints on A3 landscape.
• Action Priority, automated — S × O × D resolves to High / Medium / Low instantly, on current ratings and again after optimization. High and Medium lines colour themselves so the workload ranks itself.
• Linked process flow tab — enter your operations once; the PFMEA picks them from a drop-down. Same numbering discipline the control plan needs.
• Rating guidance — plain-language S, O and D band summaries and the AP obligations (must / should / could), written to orient you while you rate against your licensed handbook.
• A complete worked example — a welded pump bracket, flow plus thirteen PFMEA lines: a High closed to Low by error-proofing at the cause, a severity-9 line closed with the management-review note, a Medium with a documented no-action justification, a pending action deliberately not yet re-rated, and stable Lows. Every habit a good sheet needs, shown, not described.
• Control plan handoff — the mapping from PFMEA to control plan (prevention → control method, detection → evaluation + frequency, special characteristics → CP lines), filled in for the worked example and blank for yours. Pairs line-for-line with the free Qlause Control Plan Template — same part, same op numbers, so you can study the whole core-tools chain on one story.

Who it's for

Quality, manufacturing and process engineers building or updating PFMEAs in IATF 16949, VDA and AIAG environments — and any manufacturer who wants process risk analysed properly, with the current method rather than the 20-year-old form.

Why buy it

• See exactly what's inside before you buy — the sheets are previewed above.
• Instant download, secure checkout (Visa, Mastercard, PayPal).
• Single-organisation licence — use it across your whole site, no per-user fees.
• Plain Excel — works anywhere, nothing to install.

Start with the free half of the chain: the Process Flow Template and the Control Plan Template + article are free — this toolkit is the analysis engine that sits between them.

This workbook implements the AIAG-VDA method in Qlause's own format; it reproduces no handbook text, forms or tables. Rate against your licensed copy of the AIAG & VDA FMEA Handbook and follow your customer-specific requirements.