 |
 |
|
 |
 |
|
 |
 |
 |
The spreadsheet module in Synthesis Workbooks provides functionality similar to Microsoft Excel (with built-in functions and complete in-cell formula support), and it can be used to integrate data and/or results from multiple analyses at the same time.
To export all sheets in the spreadsheet module to a Microsoft Excel file, choose Home > Report > Send to Excel.
To build and insert functions that utilize a referenced analysis (data source), see Function Wizard - Data Sources.
To add math, date, logic and other functions, see Function Wizard - Formulas.
To display the formulas instead of the calculated results in the worksheet cells, choose Formulas > Formula Auditing > Show Formulas.
You can toggle the formula display on and off.
By default, the spreadsheet automatically recalculates all formulas whenever you open the workbook or when the cells that a formula depends on have changed. However, if your spreadsheet contains a large number of formulas, the recalculation process may take more time and every change may require you to wait several seconds or minutes for the application to recalculate all values. In this case, you can control when calculation occurs by changing the setting to manual calculations.
To use manual calculations, choose Formulas > Calculation > Calculation Options, and then choose the Manual option. To change the settings back to automatic calculations, choose the Automatic option.
To recalculate all formulas when in Manual mode, choose Formulas > Calculate > Calculate Now.
The Calculate Now command can also be used to refresh the spreadsheet. A spreadsheet needs to be refreshed whenever its referenced data source(s) has been recalculated. This ensures that the spreadsheet reflects the most current results.
To create your own custom chart, first select the cells that contain the relevant data, then go to Document > Charts and choose a chart type and style. (See Custom Charts in Synthesis Workbooks.)
To create variable names that reference specific spreadsheet cells, see Defined Names.
© 1992-2019. HBM Prenscia Inc. ALL RIGHTS RESERVED.
 |
E-mail Link |