Related Topics and Links:

Synthesis Workbooks

Data Entry Tips for Functions

General Spreadsheets

General Spreadsheets can be inserted into a Weibull++ life data folio, ALTA life-stress data folio or RGA growth data folio. They provide the same spreadsheet capabilities that are available in the spreadsheet module in Synthesis Workbooks, but are stored together with an analysis folio. You may prefer to use this reporting tool if you are performing custom calculations based on the data sheets in the same folio and you wish to keep the analyses together with their source data.

To add a General Spreadsheet to a folio, right-click the data sheet tab area (the area at the bottom of the window that shows the name of the data sheets in the folio) and choose Insert General Spreadsheet on the shortcut menu. This command also appears on the ribbon tab for the particular type of data folio. For example, to insert a general spreadsheet into a Weibull++ life data folio, you can choose Life Data > Folio Sheets > Insert General Spreadsheet.

Inserting Data Source Functions

To build and insert functions that utilize a referenced analysis (data source), click a cell in the general spreadsheet and choose Sheet > Sheet Actions > Function Wizard.

The following picture shows the most complex configuration as an example:

For the function arguments:

For the data source:

Inserting Math Functions

To add math, date, logic and other functions, click a cell in the general spreadsheet and choose Sheet > Sheet Actions > Insert Function.

Select a function from the drop-down list and click OK. You can enter inputs for the function arguments by either selecting the cells in the sheet or typing them directly into the appropriate field.

Referencing a Data Source

Some functions (e.g., AMEAN, D_COUNT, etc.) require you to reference a particular data source.

To reference a data source, use the following syntax, with the quotes and exclamation marks (!). You can only reference sheets in the same folio.

"Application!Folio!DataSheet"

In the following example, the data source is a data sheet called "Data1" in the Weibull++ folio called "Folio1".

 

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

E-mail Link