Help Manual

Contents






Sigma Magic Help Version 15

Summary Sheet

Overview

The Summary Sheet button can be used to view a summary of all the analysis you have performed in your workbook. To add this sheet to your workbook, click on the Summary button within the Setup menu. Main Menu

Usage

You can use the Summary menu icon to list a summary of all the analysis in your current workbook. The first time you add the summary sheet to your workbook it will add a new tab - usually at the beginning of your workbook. You can click on Compute Outputs at any time to refresh your summary sheet results at any time. A sample screenshot of the Summary Sheet is listed below. Open

Analysis Setup

Click on Analysis Setup to open the menu options for this tool.

Setup

A sample screenshot of the setup menu is shown below.
inputs page 1
1
Completed Analysis: The completed analysis shows the total number of worksheets in your current workbook that have completed the analysis and generated analysis results. This count only includes those analysis where all the inputs are complete and the outputs results have been generated.
2
Incomplete Analysis: The number of worksheets with incomplete analysis are shown here. The analysis may be incomplete if all the required inputs have not been specified or the inputs contains errors. These tools are usually work-in-progress where additional analysis options and/or data would be required to complete the analysis.
3
Refresh Status: Click on this button to refresh the summary sheet with the latest updates on the worksheets. By clicking on this button, the list of analysis sheets and their status are updated. You can also click on Compute Outputs to update these analysis results.
4
Update Analysis: You can click on this button to recompute the analysis outputs for all the worksheets in your current workbook. For example, let's say you have used an earlier version of the software to generate analysis results but have not updated your software version. You can click on this button to go through each of the sheets and update the analysis with the newer version. You can also use this if you have modified the data and would like each of the analysis to use the latest data.
5
Delete Incomplete: You can click on this button to delete all the worksheets that have incomplete or partially completed analysis. Only the worksheets with completed analysis will remain in your workbook.
6
Help Button: Click on this button to open the help file.
7
Cancel Button: You can click on this button to close the dialog box. No action is defined for the Cancel button.
8
OK Button: You can click on the OK button to close the dialog box. No action is defined for the OK button.

FAQ

This section contains some frequently asked questions. If you have other questions about this module, please contact technical support.
Can I add and/or delete the Summary Sheet at any time?

The Summary Sheet is an optional sheet that has been provided to help you get an overview of all the analysis you have performed in your workbook. However, this sheet is optional and can be deleted and/or readded at any time. Note that you can only have one Summary Sheet within each workbook.

Can I reorder the analysis listed in the Summary Sheet?

The Summary Sheet lists the analysis in the order of the sheets in your workbook. If you reorder the sheets by dragging and dropping the tabs around you will need to click on Compute Outputs button to update the order the analysis sheets on the Summary Sheet.

Can I rename the analysis sheet names listed in the Summary Sheet?

The Summary Sheet lists the analysis in the name of the sheet as defined within Excel. If you rename the tab then that name is used in the Summary Sheet under Sheet Name. To update the names within your Summary Sheet make sure to click on the Compute Outputs button.