FMEA Worksheet

The FMEA Worksheet provides a spreadsheet-like grid view matching the AIAG-VDA standard form sheet layout. Edit failure modes inline, see Action Priority at a glance, and work the way FMEA practitioners expect.

Overview

The Worksheet is available in two places:

• Project-level — The Worksheet tab in the FMEA Workspace shows all failure modes across all analyses in one grid
• Analysis-level — Inside any DFMEA or PFMEA analysis, the Worksheet sub-tab shows failure modes for that analysis only

Default View

The Worksheet tab is the default view when opening an analysis, giving immediate visibility into all failure modes.

Column Layout

The grid follows the AIAG-VDA form sheet standard:

#	Column	Description
1	#	Row number
2	Structure Element	Component or process step from the Structure Tree
3	Function	Primary function of the element
4	Failure Mode	How the function can fail
5	Effect	Impact on customer or next operation
6	S	Severity rating (1-10)
7	Cause	Root cause of the failure
8	Prevention Controls	Controls that prevent the cause
9	O	Occurrence rating (1-10)
10	Detection Controls	Controls that detect the failure
11	D	Detection rating (1-10)
12	AP	Action Priority (High / Medium / Low)
13	Recommended Actions	Mitigation actions

Prevention vs Detection Controls

The Worksheet separates controls into two columns matching the AIAG-VDA format. Prevention Controls reduce the likelihood of a cause occurring. Detection Controls identify the failure mode or cause before the product reaches the customer.

Inline Editing

Click any editable cell to modify its value directly in the grid:

• Text cells (Failure Mode, Effect, Cause, Controls, Actions) — Click to enter edit mode, type your changes
• Rating cells (S, O, D) — Click and enter a number 1-10
• Tab moves to the next editable cell in the row
• Enter confirms the edit and moves down to the next row
• Changes are auto-saved after you leave a cell (debounced 500ms)

Action Priority Auto-Calculation

When you change any S, O, or D rating, the Action Priority recalculates automatically using the AIAG-VDA rules:

• High (S >= 9, or S >= 7 with O >= 4 or D >= 4)
• Medium (S >= 4, or S = 3 with O >= 6 or D >= 6)
• Low (all other combinations)

Row Color Coding

Rows are color-coded by Action Priority for quick visual scanning:

Priority	Background	Meaning
High	Red tint	Immediate action required
Medium	Amber tint	Action needed
Low	Green tint	Monitor, no immediate action

Navigation

• Sticky header — Column headers remain visible as you scroll down
• Sticky first column — Row numbers stay visible as you scroll right
• Horizontal scroll — The grid is wider than most screens; scroll right to see all columns
• Filtering — Use the filter controls above the grid to show/hide rows by analysis, priority, or structure element
• Collapse/Expand — Group rows by analysis or structure element

Filtering and Grouping

The toolbar above the worksheet provides:

• Analysis filter — Show failure modes from a specific analysis or all analyses
• Priority filter — Show only High, Medium, or Low priority rows
• Search — Find failure modes by keyword across all visible columns
• Group by — Organize rows by analysis or by structure element

Best Practices

1. Start with the Worksheet when reviewing an analysis — it gives the complete picture in one view
2. Focus on red rows first — High priority failure modes need immediate attention
3. Use Tab navigation to quickly move through a row filling in all fields
4. Split controls into Prevention and Detection columns for clearer risk assessment
5. Review across analyses using the project-level Worksheet to spot patterns

What's Next?

• Import & Export — Import existing FMEA spreadsheets or export the worksheet
• Control Plans — Generate Control Plans from your PFMEA worksheet data
• FMEA Ratings — Guidance on assigning S, O, D ratings
• Actions and Mitigation — Define actions for high-priority items