Analysis Summary

You can view a summary of all the analysis performed in your workbook by clicking on the Summary button on the main menu bar.

An example output of the summary page is shown below:

The summary sheet contains the following columns:

1. A brief description of the analysis. You can edit this description to provide a short one-line description of the analysis performed. To update the description, you can select the row and click on the Rename button on the main menu bar.
   
2. The worksheet link. You can click on this link to go to that worksheet. Once on the analysis worksheet, you can click on Analysis Setup to view the options used for the analysis or view the session and graph output of that analysis.
   
3. The status shows the state of the analysis. OK implies the analysis was successfully completed. The other states could be work-in-process, new, error, or if the analysis requires an update as the data has been changed.
   
4. The version number of the Sigma Magic software used to generate the analysis.
   
5. The data and time the analysis was completed.
   

When on this sheet, click on the Analysis Setup button to open the following dialog box:

This dialog box shows that there are 8 analysis that require an update - this could be either due to changes in the data or if a new version of the software is available. You can click on the update button to update all the analysis. If any analysis is incomplete, you can delete that worksheet from your project.

Note that using this option, you can update the entire workbook/project in one click and you don't have to go through each analysis to update them.

• Related Articles

• Summary Sheet

  Click the Summary button on the main menu bar to add the summary sheet to your workbook. Following is an example of the summary sheet. The summary sheet lists all the analyses you have performed in your project. In the above example, 19 different ...

• Duplicate Analysis

  Sometimes, we want to perform minor changes to an analysis to see the impact of the change on the analysis results. You don't have to re-do all the steps of adding a new analysis tool, specifying the data and analysis options etc. in order to do ...

• Specifying Analysis Setup

  If you want to specify the options for any analysis, you can click on the Analysis Setup button on the main menu bar. Depending on the worksheet that is currently active, the analysis setup will be displayed for that worksheet. For example, if you ...

• Main Menu Bar

  The software is an add-in within Microsoft Excel. When you open Microsoft Excel, you should see the software on the main menu bar. Click on the Sigma Magic button to load the software into memory. This will open the Sigma Magic menus as shown in the ...

• Tool Wizard

  You can add a new analysis template to your project using the tool wizard. Click on the Tool Wizard on the main menu bar. This will open a dialog box as shown in the figure below. You can click on the tool grouping at the left, such as "Stats," and ...