Spreadsheet Analysis

R2026b

Perform inductive systematic safety analysis by using spreadsheets

Use the Safety Analysis Manager to perform tabular safety analyses such as Failure Mode and Effects Analyses (FMEAs) and Functional Hazard Assessments (FHAs). Link the artifacts in your tables to model elements and faults, and design the analysis by writing callback scripts in MATLAB^®.

Apps

Safety Analysis Manager

Create and edit documents for safety analyses (Since R2023b)

Functions

expand all

Open and Close Safety Analysis Manager Documents

`close`	Close document in Safety Analysis Manager (Since R2023b)
`safetyAnalysisMgr.closeAllDocuments`	Close documents in Safety Analysis Manager (Since R2023b)
`safetyAnalysisMgr.closeManager`	Close Safety Analysis Manager (Since R2023b)
`safetyAnalysisMgr.fileType`	Determine type of Safety Analysis Manager file (Since R2026b)
`safetyAnalysisMgr.import`	Import Excel file into Safety Analysis Manager (Since R2023b)
`safetyAnalysisMgr.openDocument`	Open Safety Analysis Manager document (Since R2023b)
`safetyAnalysisMgr.openManager`	Open Safety Analysis Manager (Since R2023b)
`safetyAnalysisMgr.newDocument`	Create new document in Safety Analysis Manager (Since R2026b)
`safetyAnalysisMgr.newSpreadsheet`	Create new spreadsheet in Safety Analysis Manager (Since R2023b)

Adjust Safety Analysis Manager Spreadsheet Columns and Rows

`addColumn`	Add column to spreadsheet in Safety Analysis Manager (Since R2023b)
`addRow`	Add row to spreadsheet in Safety Analysis Manager (Since R2023b)
`deleteColumn`	Delete column in spreadsheet in Safety Analysis Manager (Since R2023b)
`deleteRow`	Delete row in spreadsheet in Safety Analysis Manager (Since R2023b)
`move`	Change the position of a row in a Safety Analysis Manager spreadsheet (Since R2026b)
`moveRow`	Change position of row in Safety Analysis Manager spreadsheet by row index (Since R2026b)
`setColumnLabel`	Adjust column label of spreadsheet in Safety Analysis Manager (Since R2023b)
`setColumnFormula`	Specify derived column formulas in spreadsheet in Safety Analysis Manager (Since R2023b)

Edit Safety Analysis Manager Spreadsheet Cell and Row Artifacts

`addFlag`	Add flag to Safety Analysis Manager spreadsheet cell or row (Since R2023b)
`clear`	Clear Safety Analysis Manager document flag (Since R2023b)
`clearFlags`	Clear flags in Safety Analysis Manager spreadsheet and fault tree document elements (Since R2023b)
`refreshDerivedValues`	Recalculate values in spreadsheet derived columns (Since R2024b)
`setValue`	Write values to spreadsheet cells (Since R2023b)

Edit Safety Analysis Manager Callbacks, Document Attributes, and Diagnostics

`addCallback`	Add custom callback to Safety Analysis Manager spreadsheets (Since R2024a)
`addDocumentAttribute`	Add document attribute to spreadsheet in Safety Analysis Manager (Since R2023b)
`deleteCallback`	Delete custom callback from Safety Analysis Manager documents (Since R2024a)
`deleteDocumentAttribute`	Delete document attributes in spreadsheet in Safety Analysis Manager (Since R2023b)
`enableCallback`	Enable or disable callbacks in Safety Analysis Manager spreadsheets (Since R2024a)
`renameCallback`	Rename custom callbacks in Safety Analysis Manager spreadsheets (Since R2024a)
`renameDocumentAttribute`	Rename document attributes in Safety Analysis Manager documents (Since R2023b)
`runAnalysis`	Execute callback script on Safety Analysis Manager document (Since R2023b)
`safetyAnalysisMgr.clearDiagnostics`	Clear diagnostics in Safety Analysis Manager (Since R2023b)
`setCallback`	Assign code to Safety Analysis Manager document callback (Since R2024a)
`setDocumentAttribute`	Set document attributes in Safety Analysis Manager documents (Since R2023b)

Get Safety Analysis Manager Artifacts

`find`	Find cells in Safety Analysis Manager spreadsheets containing specific values (Since R2023b)
`getCallback`	Retrieve spreadsheet callback code in Safety Analysis Manager (Since R2024a)
`getCell`	Retrieve spreadsheet cells (Since R2023b)
`getColumnLabels`	Retrieve column labels in spreadsheet in Safety Analysis Manager (Since R2023b)
`getColumnTypes`	Retrieve column types in spreadsheet in Safety Analysis Manager (Since R2024b)
`getColumnFormula`	Get derived column formula from spreadsheet in Safety Analysis Manager (Since R2023b)
`getCustomCallbackNames`	Retrieve names of custom callbacks in Safety Analysis Manager documents (Since R2026b)
`getDocumentAttribute`	Retrieve document attribute values in Safety Analysis Manager documents (Since R2023b)
`getDocumentAttributeProperties`	Retrieve document attribute properties in Safety Analysis Manager document (Since R2024b)
`getFlags`	Retrieve flags from Safety Analysis Manager documents (Since R2023b)
`getLinks`	Get links associated with spreadsheet cell or row in Safety Analysis Manager (Since R2023b)
`getRow`	Retrieve spreadsheet rows (Since R2024b)
`getSpreadsheet`	Retrieve spreadsheet containing specified cell (Since R2024a)
`isCallbackEnabled`	Determine whether custom callbacks are enabled (Since R2024a)
`safetyAnalysisMgr.getCurrentSelection`	Get current selection in Safety Analysis Manager document (Since R2023b)
`safetyAnalysisMgr.getCurrentDocument`	Get selected document in Safety Analysis Manager (Since R2026b)
`safetyAnalysisMgr.getDiagnostics`	Return diagnostics in Safety Analysis Manager (Since R2023b)
`safetyAnalysisMgr.getOpenDocuments`	Retrieve open documents in Safety Analysis Manager (Since R2023b)

Save Safety Analysis Manager Artifacts

`export`	Export Safety Analysis Manager spreadsheet to Excel (Since R2023b)
`safetyAnalysisMgr.saveDiagnostics`	Save diagnostics in Safety Analysis Manager to text file (Since R2023b)
`save`	Save Safety Analysis Manager document (Since R2023b)
`saveTemplate`	Save Safety Analysis Manager document as a template (Since R2023b)

Manage Safety Analysis Manager Spreadsheet Cell References

`addReference`	Add references to cells (Since R2024b)
`getReferencedValues`	Get referenced cell values (Since R2024b)
`getReferences`	Get referenced cells (Since R2024b)
`moveReference`	Change order of references (Since R2024b)
`removeReference`	Remove references in Safety Analysis Manager spreadsheets (Since R2024b)

Detect Changes in Safety Analysis Manager Documents

`accept`	Accept detected change in Safety Analysis Manager document (Since R2024b)
`acceptAllChanges`	Accept detected changes to linked artifacts in Safety Analysis Manager (Since R2024b)
`detectChanges`	Detect changes to linked artifacts in Safety Analysis Manager document (Since R2024b)
`getChanges`	Get changed artifacts linked to artifacts in Safety Analysis Manager (Since R2024b)
`navigate`	Navigate to elements in Safety Analysis Manager documents and changed artifacts (Since R2024b)

Objects

`CellReference`	Referenced cell in Safety Analysis Manager spreadsheet (Since R2024b)
`ChangeInformation`	Detected changes in Safety Analysis Manager (Since R2024b)
`DocumentFlag`	Flags in Safety Analysis Manager (Since R2023b)
`Spreadsheet`	Spreadsheet in Safety Analysis Manager (Since R2023b)
`SpreadsheetCell`	Cell in spreadsheet in Safety Analysis Manager (Since R2023b)
`SpreadsheetRow`	Spreadsheet row in Safety Analysis Manager (Since R2024b)

Topics

Create Columns and Rows in Safety Analysis Manager Spreadsheets
Create cells in Safety Analysis Manager spreadsheets by adding columns and rows.
Write Callbacks to Analyze Safety Analysis Manager Spreadsheets
Use MATLAB to define code that executes automatically or manually to analyze spreadsheets in the Safety Analysis Manager.
Create and Select Custom Callbacks for Safety Analysis Manager Spreadsheets
Specify callbacks to execute when analyzing spreadsheets. (Since R2024a)
Create and Register Templates in the Safety Analysis Manager
Create templates from existing documents to reuse common spreadsheet structures and settings across projects.
Import and Export Safety Analysis Manager Spreadsheets
Import Excel^® spreadsheets that you create for safety analysis into the Safety Analysis Manager.
Link Safety Analysis Manager Spreadsheet Cells and Rows to Requirements, Tests, and Faults
Define traceability between spreadsheet cells and rows and requirements, tests, faults, or conditionals.
Track Changes in Safety Analysis Manager Spreadsheets
Identify and manage changes to links and linked artifacts in Safety Analysis Manager spreadsheets contained in projects. (Since R2024b)
Create References in Derived Column Cells
Create references to cells to use cell information in derived columns. (Since R2024b)
Use Self-References in Derived Columns
Retrieve cell information within derived columns, their containing rows and spreadsheets, and use that information to change cell outputs. (Since R2024b)