Related Topics and Links:

Function Wizard - Data Sources

General Spreadsheets

Data Entry Tips for Functions

Defined Names

In the spreadsheet module for Synthesis Workbooks and general spreadsheets in Weibull++/ALTA and RGA folios, you can create variable names that reference specific spreadsheet cells. The names can then be used in any formula or function within the same workbook.

For example, say you want to obtain the reliability of a Weibull++ data set. The operating time is stored in cell B5 of the spreadsheet:

=RELIABILITY(“Weibull!Bulb!Data1!”$B$5))

You can create a defined name for the operating time to make the formula easier to understand and maintain. In this case, the formula might be rewritten as:

=RELIABILITY(“Weibull!Bulb!Data1!”OpTime)

You can then use the defined name OpTime in any other formula in the workbook that requires the operating time.

Syntax Rules for Names

Managing Names

To view and manage defined names:

You can then use the New, Edit, or Delete commands in the window to create or modify the names.

Defining Names

There are several ways to define a name.

Define a Name via the Name Manager

This method applies to both Synthesis Workbooks and general spreadsheets.

  1. Select a cell or range of cells.

  2. Create a new name:

  3. Type a name into the Name field. In the Scope drop-down list, choose whether this name will be used for the entire workbook or a specific sheet. The Comment field is optional.

    The selected cell/range will already be defined in the Refers to field, but you can click into the spreadsheet and select different cells, if desired.

Define a Name via the Name Box (Synthesis Workbook Only)

This method applies only to the spreadsheet module of Synthesis Workbooks. Select the cell or range of cells, click the Name box and type a name. Press Enter to create the name.

Define a Name via the Selection Command (Synthesis Workbook Only)

If the fields are already labeled in the spreadsheet, you can use them to create names.

  1. Select the cells of interest (including the row or column labels), then choose Formulas > Defined Names >  Create from Selection.

 

  1. In the window, select the location of the labels. Click OK.

 

© 1992-2018. HBM Prenscia Inc. ALL RIGHTS RESERVED.

E-mail Link