Stages of a Staged Risk Assessment
A typical FMEA, HARA, or TARA proceeds through five stages. Each stage has a distinct intent and a distinct set of columns. The diagram below shows the progression.Stage 1 — Context and Risk Identification
The analyst captures the system context and lists the failure modes, hazards, or threats. Visible columns are the upstream context (function, item, system reference) and the initial description fields (failure mode, hazard, threat scenario). Classification and mitigation columns are hidden so the analyst is not tempted to fill them in before the identification work is complete.Stage 2 — Risk Classification
The risk team rates each identified risk. Visible columns are the classification parameters such as severity, occurrence, detection, ASIL, or CVSS metric vectors. Mitigation and residual columns remain hidden. This view is typically used in a workshop where multiple stakeholders agree on the initial ratings.Stage 3 — Mitigation Planning
Mitigation owners propose actions. The view exposes the task (downstream) columns — the linked mitigation item, owner, target date, and status — alongside the classification result so the planner can prioritize. Residual-risk fields are still hidden.Stage 4 — Residual Risk Assessment
After mitigations are agreed, analysts rate the residual risk. The view shows the residual severity, residual occurrence, residual detection, and the calculated residual RPN or risk index. The initial classification columns may also be visible side-by-side so the change is visible at a glance.Stage 5 — Final Review
The reviewer needs the complete picture. This view exposes every column, typically using the@all shorthand, so nothing is hidden during sign-off.
How Views Are Configured
Views are declared in theviews section of the sheet configuration. Each entry has a name and a list of columnIds to include. One view can be marked as the default with defaultView: true so it loads automatically when the sheet opens.
columnIds:
A “show everything except the downstream task block” view can therefore be expressed concisely:
Views Versus Filters
Views are about which columns are visible. They do not filter rows. Row-level scoping is handled by other mechanisms:
The same sheet can therefore be opened multiple times with the same view but different URL filters — for example, one tab showing only the highest-severity rows for a triage meeting, another tab showing all rows for a complete review.
The exact column IDs to put inside each
columnIds list depend on your specific sheet configuration. Open the configuration editor and copy the id value of each column you want to expose; the IDs are case-sensitive.