1 | Num Metrics: Specify the number of metrics you deal with for your process or department. You can specify up to 20 metrics on one tool. If you have more metrics, you must pick the most important ones to track here. |
2 | Update Period: Specify the frequency of measurement of the metrics. Currently, the frequency that can be specified is Weekly, Biweekly (once every two weeks), Monthly, and Quarterly. Ensure that the measurement frequency is sufficient to take corrective action if the metrics are off-track. Note that only one frequency can be specified for the entire worksheet. If one metric is measured quarterly while another metric is calculated monthly, then you need to use the most frequently measured metric as the frequency for the entire worksheet. The quarterly metric values will not change monthly but will be fixed for each quarter. |
3 | Metric:
For each metric, you need to specify the measured metric type. There are four types of metrics: Largest, Nominal, Smallest, and Text. The largest type of metrics is those for which the largest value is the best. An example of this type of metric is "Revenue." Larger revenue is better for the organization. The next type of metric is "Nominal". Nominal metrics are those metrics for which an optimal value exists. Any values that are too large or too small away from the nominal value are not good for the organization. An example of a nominal metric is temperature. For example, the ideal temperature may be between 18 and 24 degrees Centigrade. If the temperature is too high or too low, it is not optimal for the occupants. The third metric type is the "Smallest." For this metric type, the smallest possible value is the best for the organization. An example of the smallest metric is the defect rate. Smaller defect rates are better for the organization. Finally, the fourth type of metric is called "Text". This discrete-type metric can only take a limited set of discrete values. An example of the discrete metric is the project phase - say "Plan," "Do," "Check," or "Act." |
4 | Thresholds: After specifying the metric type, you need to select the transition points for each metric that will change the color of the actual values. For example, if you specify the most significant type metric, the lowest set point is automatically set at -infinity, and the highest set point is automatically set at +infinity. The second transition point defines the transition from red to yellow, and the third transition defines the transition from yellow to green. For example, if the transition points for the most significant type metric are -inf, +5, +10, +inf. Then, any actual values less than +5 will have a red color, any values between 5 and 10 will have a yellow color, and any values greater than ten will be shown in green color if the transition points are defined as -inf, +50%, +100%, +inf. Then, the color transition values depend on the plan values specified on the worksheet. Suppose the plan value defined on the worksheet is +200. Then the transition points are -inf, 100 (50% of 200), 200 (100% of 200), and +inf. So, any values less than 100 are colored in red, all values between 100 and 200 are colored in yellow, and all values greater than 200 are colored in green. |
5 | 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. |
6 | Help Button: Click on this button to view the help file for this topic. |
7 | Cancel Button: Click on this button to cancel any changes and exit the dialog box. |
8 | 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. |
9 | 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. |
Type | Red Color | Yellow Color | Green Color |
---|---|---|---|
Largest | A < t2 | t2 ≤ A < t3 | A ≥ t3 |
Smallest | A > t3 | t2 < A ≤ t3 | A ≤ t2 |
Nominal | A > t4 or A < t1 | t1 ≤ A < t2 or t3 < A ≤ t4 | t2 ≤ A ≤ t3 |
Text | A = t3 | A = t2 | A = t1 |
1 | Item: The items on the checklist are listed on the left |
2 | Status: The status of whether the checklist has been answered is listed on the right. |
1 | Item: The left-hand side shows the major tabs and the items checked within each section |
2 | Status: The right-hand side shows the status of the checks. |
3 | 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. |
© Rapid Sigma Solutions LLP. All rights reserved.