Workbook Tab

English | | Deutsch

The Workbook tab is visible when you are working with an Analysis Workbook.

Note: In Version 10, Analysis Workbooks have been replaced with Synthesis Workbooks. You can continue to use your old Analysis Workbooks or convert them to the new format on a case-by-case basis.

Worksheet

Insert Sheet adds a new sheet to the workbook.

Delete Sheet deletes the current sheet. There is no undo for delete.

Select Sheet opens the Select Sheet window where you can select which sheet to work with.

Move/Copy Sheet opens the Move or Copy Sheet window, which allows you to move or copy any of the sheets within the current workbook. Select the sheet that you want to move the current sheet in front of or select (move to end) to move the current sheet to the end of all the sheets in the workbook. Select Create a copy to create a copy of the current sheet.

Actions

Function Wizard opens the Function Wizard, which helps you to build functions in Analysis Workbooks. These functions can return results ranging from mathematical values (e.g., sine, pi or averages) to reliability metrics based on associated data sheets (e.g., reliability, probability of failure, expected number of failures, etc.).

Spreadsheet View and Report View allow you to toggle between the two views. The spreadsheet view displays the grid and the column/row headings, while the report view hides them and displays the Analysis Workbook in the format in which it will be printed.

Recalculate recalculates formulas when relevant values change in any of the referenced recalculated data sources.

Defined Names opens the Defined Names window, which allows you to create and manage variable names that can be referenced in any function. You can define a name for any spreadsheet cell or data source.

Associate Data Sources allows you to define or change up to four default data sources that can be referenced by functions in this Analysis Workbook.

Save as Template allows you to save the current report as a template so that you can reuse its settings.

Convert to Synthesis Workbook converts the Analysis Workbook to a Synthesis Workbook spreadsheet. Note that any images or charts in the Analysis Workbook will not be converted.

E-mail Link