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 studies were conducted. The names of each analysis are shown in the Description column. The Worksheet contains a link to the analysis sheet. You can click on this link to take you to that worksheet. You can click the Summary button to return to the summary sheet. The Status column shows the status of each analysis. The version column shows the software version used to generate the analysis results, and the Last Updated column shows the date/time the analysis was completed.

Click the Analysis Setup button on the main menu bar when you are on the Summary sheet. The following dialog box is opened:

This dialog box shows that 19 analyses require an update. Click on the Update link, and all the analyses will be updated. The results of the updated summary sheet is shown below.

If you want to rename any description, select the row you want to rename and click on the rename tab on the main menu bar.

The Summary sheet gives us a quick overview of all the analyses that were performed for a given project and the status of each analysis. If your data changes for example, you can click on Compute Outputs button to update and refresh the Summary Sheet. It will help you focus on which of your analysis needs an update.

As an illustration, we have modified the Shift column in the Data Sheet. The following is a snapshot of the Summary Sheet after clicking the Compute Outputs button.

You can click on the Analysis Setup button to view a snapshot of the analysis sheets and then update them if required.

• Related Articles

• 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: A brief description ...

• Data Sheet

  While your data can be on any worksheet within a workbook, we recommend placing all data related to your project on the Data Sheet. A Data Sheet is a special worksheet that contains your data. To create a Data Sheet, click the Data button on the main ...

• Project Files

  You can save your projects in Excel workbooks. Click the New button on the main menu bar to start a new project. This will open a new Excel workbook with two specific worksheets. The first is the summary worksheet, which contains a summary of all the ...

• 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 ...

• Importing Data

  If your data is in another workbook, you can copy and paste your range or table from one workbook to another. Select your data or table, click on Ctrl-C to copy the data to the clipboard, go to the target workbook Data Sheet, and then click on Ctrl-V ...