Excel template
PFMEA Excel Template
AIAG-VDA PFMEA with the full Action Priority table, action tracker and dashboard
PFMEA template for Excel with the full AIAG-VDA Action Priority table (all 1,000 S-O-D combinations): 9 tabs, 300 failure chains, 7-step structure with 4M, a linked action tracker, a special characteristics list for the Control Plan and a live dashboard. No RPN thresholds, no macros.
- Full AIAG-VDA Action Priority table, all 1,000 S-O-D combinations, no RPN cut-off
- AP before and after actions; the new AP counts once the action is Completed
- 300 failure chains in the 7-step structure with 4M work elements
- Every action appears in the tracker automatically with days overdue
- High AP without an action or rationale is flagged red
- Special characteristics list for the Control Plan (IATF 16949 clause 8.3.3.3)
Secure checkout by Polar. Digital download: at checkout you agree to immediate delivery and waive the 14-day withdrawal right, so downloads are not refunded. Support: info@qmbench.com.
Free alternativeTry the free online tool firstThe free FMEA Worksheet on QM Bench runs in your browser with a PDF report. The template is for a file you keep, edit and fill with your own data.Open the free toolWhat is inside
- 1
Start Here
The 7 steps mapped to the workbook, quick start and the built-in rules.
- 2
Dashboard
Failure chains, High AP initial vs current, open and overdue actions, High AP without action, AP chart, actions by status, S x O risk matrix and process step overview.
- 3
Planning & Team
Step 1: PFMEA header, 5T plan (InTent, Timing, Team, Tasks, Tools), analysis boundaries, team, your special-characteristic symbols and approvals.
- 4
PFMEA
Steps 2 to 6 in 300 rows: structure, functions, failure chain, controls, S-O-D, AP, special characteristic, actions, owner, target date, status, evidence, new S-O-D and new AP.
- 5
Action Tracker
All actions listed automatically (up to 150) with days overdue and new AP, filter by owner or status.
- 6
Special Characteristics
Every CC / SC chain with product and process characteristic, class, controls and current AP.
- 7
Rating Scales
Severity (plant, ship-to plant, end user), occurrence based on prevention controls, detection based on method maturity and opportunity.
- 8
AP Table
The full Action Priority table used by every formula.
- 9
Revision History
Step 7: revision log with linked documents.
Try the template in your browser
The same AIAG-VDA Action Priority table as the Excel file. Change severity, occurrence or detection and watch the AP turn High, Medium or Low.
DemoIllustrative preview with example data, not the template itself. The Excel file has more rows, tabs, charts and checks.
| Process step | Failure mode | S | Cause | O | Current control | D | AP | RPN |
|---|---|---|---|---|---|---|---|---|
| M | 96 | |||||||
| H | 245 | |||||||
| L | 54 | |||||||
| M | 144 |
RPN is shown for reference only; AIAG-VDA prioritises by AP.
The workbook adds structure, function and failure analysis columns, optimization with the new S / O / D and AP, an action tracker, rating tables and a dashboard.
Real Action Priority
The complete AP table, not a simplified formula or an RPN cut-off. S10 / O2 / D3 is LOW and S8 / O4 / D7 is HIGH, exactly as the handbook table says.
Actions that track themselves
Every prevention and detection action from the worksheet appears in the tracker with owner, due date and days overdue. No double entry, and High AP without an action or rationale turns red.
From PFMEA to Control Plan
The special characteristics tab lists every CC / SC chain with its controls and current AP, ready to transfer to the Control Plan.
Honest scope
Process FMEA only: no DFMEA or FMEA-MSR, no structure tree graphics and no automatic Control Plan. Rating criteria are condensed summaries; use your licensed AIAG & VDA FMEA Handbook. Not affiliated with AIAG or VDA.
Who it is for
- Process and manufacturing engineers in automotive supply chains
- Quality engineers and FMEA facilitators preparing APQP / PPAP
- Suppliers moving from AIAG 4th edition RPN to AIAG-VDA Action Priority
- Plants preparing for an IATF 16949 or customer audit
Not included
- Design FMEA (DFMEA) and FMEA-MSR
- Structure tree or process flow graphics
- Automatic Control Plan generation (special characteristics list only)
- The AIAG & VDA FMEA Handbook itself; rating criteria are condensed summaries
Details
- Format
- Microsoft Excel .xlsx, 9 tabs
- Works in
- Excel 2010 or newer, Microsoft 365 (Windows, Mac), LibreOffice Calc
- Macros
- None
- Rows
- 300 failure chains, 150 tracked actions
- Standard
- AIAG & VDA FMEA Handbook 2019, IATF 16949 8.3.3.3, 9.1.1.1, 10.2.3
- Sample data
- Water pump line: 9 operations, 23 failure chains, 13 actions
- Delivery
- Instant download after payment
Frequently asked questions
›Where do I buy it?
Here on QM Bench with the Buy button: secure card checkout by Polar with a receipt, and the Excel file arrives by e-mail right after payment.
›Is there a free alternative?
Yes. The free FMEA worksheet on QM Bench calculates Action Priority in your browser with a PDF. The Excel template adds the 7-step structure, 300 rows, the action tracker and the dashboard in a file you keep.
›Does it use RPN?
RPN is shown for information only. Priority comes from the full AIAG-VDA Action Priority table.
›Can I get a refund?
No. It is a digital download: at checkout you agree to immediate delivery and waive the 14-day right of withdrawal, and the file stays with you. If something does not work as described, write to info@qmbench.com and you will get help or a corrected file.
Get the PFMEA Excel Template
Instant download by e-mail after payment. Paste your measurements and read the verdict.
Buy now · €17.99Or try the free online tool first →