Help Manual


Sigma Magic Help Version 17

Design Scorecard


Design Scorecard can be used to document the current status of the project CTQs. Design Scorecards are typically used in a Design for Six Sigma project to document the most critical CTQs and whether we can meet the requirements.

This tool can be added to your active workbook by clicking on Project and then selecting Design Scorecard.


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


A sample screenshot of the setup menu is shown below.
Num Metrics: Specify the number of metrics you want to display on the design scorecard. This information will be used to format the worksheet. The number of metrics dictates the number of rows on your worksheet.
Highlight Rows: In this dialog box, specify how you want to highlight the rows. You can avoid highlighting any rows or specify that you want to highlight those rows that either meet the goal or do not meet the goal.
View Example: Click on this button to open the example file. You can view the example to get an idea of how to fill out this tool, or you can use the example as a starting point and modify it to meet your project needs.
Help Button: Click on this button to open the help file on this topic.
Cancel Button: Click on this button to exit without saving any changes.
Create Design: If this is your first time using this template, click this button to format the worksheet template. You can also update the worksheet format any time, but remember that you may lose any data entered on this worksheet. Once you are happy with the worksheet template layout, you must enter any required data on the worksheet. When the data entered into the worksheet is complete, you can click on Analysis Setup and then Compute Outputs to generate analysis results.
Analyze Design: Click on this button to save all changes and compute the outputs for this analysis. Review the results of your analysis and make changes to your inputs if required to update analysis results.


Enter the following information in the worksheet:
  • Enter the information for critical CTQs, the capability metric (Cpk, Sigma Level, or DPMO), and the goal for the process capability metric.
  • As information becomes available, enter the predicted capability (typically during the design and optimization phase of a DFSS project) or the measured capability (typically during the Verify phase of the DFSS project).


If you click the Verify button, the software will perform some checks on the data you entered. A sample screenshot of the dialog box is shown in the figure below. Verify The software checks if you have correctly specified the input options and entered the required data on the worksheet. The results of the analysis checks are listed on the right. If the checks are passed, they are shown as green checkmarks. If the verification checks fail, they are shown as a red cross. If the verification checks result in a warning, they are shown in the orange exclamation mark. Finally, any checks that are required to be performed by the user are shown as blue info icons.
Item: The left-hand side shows the major tabs and the items checked within each section
Status: The right-hand side shows the status of the checks.
Overall Status: The overall status of all the checks for the given analysis is shown here. The overall status check shows a green thumps-up sign if everything is okay and a red thumps-down sign if any checks have not passed. Note that you cannot proceed with generating analysis results for some analyses if the overall status is not okay.


Click on Compute Outputs to update the output calculations. A sample screenshot of the worksheet is shown below. Design Scorecard Example The Goal Met column highlights if the goal for a given CTQ has been met. The comments area will highlight the number of CTQs that meet the goal. If there are no error messages, the following sample message is displayed. outputs 2


Here are a few pointers regarding this analysis:
  • This worksheet does not use the 1.5 Sigma Shift. Instead, you can specify if your Sigma Level is measured Short Term or Long Term.


The following examples are in the Examples folder.
  • Develop a Design Scorecard for the training effectiveness project defined in the attached file (Design Scorecard 1.xlsx)

© Rapid Sigma Solutions LLP. All rights reserved.