|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.|
|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.|
|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.|
|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.|
|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.|
|Help Button: Click on this button to open the help file.|
|Cancel Button: You can click on this button to close the dialog box. No action is defined for the Cancel button.|
|OK Button: You can click on the OK button to close the dialog box. No action is defined for the OK button.|
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.
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.
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.