Help Manual

Contents






Sigma Magic Help Version 15

Project Filter

Overview

The Project Filter tool can be used to determine the right approach to solve a particular problem based on your responses to specific questions. This tool determines if the project should be solved using the Lean approach, Six Sigma approach, or using Project Management methodology. Besides, if several projects need to be selected, this tool can help filter the projects and select the most important project for execution.

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

Inputs

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

Setup

A sample screenshot of the setup menu is shown below.
inputs
1
Analysis Type: Specify the tool format for this analysis. This selection is not enabled since there is only one format available.
1
Num Projects: Specify the number of projects. This information is used to reformat your worksheet and create a table for data entry. Note that any data below this table will be cleared.
3
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.
4
Help Button: Click on this button to view the help file for this topic.
5
Cancel Button: Click on this button to cancel all changes to the settings and exit this dialog box.
6
OK Button: Click on this button to save all changes and compute the outputs for this analysis.

AHP Weights

A sample screenshot of the AHP Weights menu is shown below. Based on the relative weights specified by the user for two factors, the software translates them into an overall score for each factor. These weights can then be used to determine the overall score of each project.
inputs
1
Factors: There are 4 factors for this analysis - impact, time, cost, and others. The other factor could be any other factor that is important to the company that is not covered by the first three. For example, the other factor could be a risk. Impact refers to the impact of the project for example benefits. What is the overall financial impact of the project? Time could refer to the duration required for the completion of the project. The cost could refer to the number of resources required to complete the project.
2
Weights: Enter a score for the relative importance of each factor compared to the other factor on a scale of 1-10. Compare each row vs. column element and assign a relative importance score between the two. All the diagonal elements compare the same factors so the relative weight for them is 1. For the non-diagonal elements, assign a score between the two factors. For example, if you are comparing impact vs. cost which factor is more important? You then need to come up with a score for how much more important is impact compared to cost. If we assign a score of 2 then we would enter a value of 2 for the impact row. The other non-diagonal element is left blank. Similarly, now compare impact and time and so on. Continue to perform these pairwise comparisons until all elements of the matrix are filled out.
4
Update AHP: Click on this button to compute the overall weights using the AHP process. These weights are then used to score the projects.


Worksheet

Enter the following data in the worksheet for each potential project in your area:
  • Enter a number for each project or a project ID.
  • Enter the project title (short one-line description of the project)
  • Specify if this project supports the company strategy on a scale of "Low", "Medium", or "High"
  • Specify if the right sponsor (at the right level in the organization) is available to sponsor the project.
  • Specify is the right team leader and team members are available to work on this project
  • Specify the approach to be used for determining the solution. In some cases, the solution may already be known, in other cases, we may need to perform some data analysis to determine the right solution.
  • On a scale of 0-10 specify the expected benefits, expected duration, and expected risks for the project. A score of 0 may indicate no benefits, a very long project duration, or very high risk. A score of 10 may be for very large benefits, very short project duration, or very little risk.

Charts

If you click on the Charts button, you will see the following dialog box. Charts
1
Title: The system will automatically pick a title for your chart. However, if you would like to override that with your own title you can specify a title for your chart here. Note that this input is optional.
2
Sub Title: The system will automatically pick a subtitle for your chart. However, if you would like to override that with your own subtitle you can specify a subtitle for your chart here. Note that this input is optional.
3
X Label: The system will automatically pick a label for the x-axis. However, if you would like to override that with your own label for the x-axis you can specify a different label here. Note that this input is optional.
4
Y Label: The system will automatically pick a label for the y-axis. However, if you would like to override that with your own label for the y-axis you can specify a different label here. Note that this input is optional.
5
X Axis: The system will automatically pick a scale for the x-axis. However, if you would like to override that with your values for the x-axis, you can specify them here. The format for this input is to specify the minimum, increment, and maximum values separated by a semi-colon. For example, if you specify 10;20 then the minimum x-axis scale is set at 10 and the maximum x-axis scale is set at 20. If you specify 10;2;20, then the x-axis increment is set at 2. Note that this input is currently disabled and you will not be able to change this setting.
6
Y Axis: The system will automatically pick a scale for the y-axis. However, if you would like to override that with your values for the y-axis, you can specify them here. The format for this input is to specify the minimum, increment, and maximum values separated by a semi-colon. For example, if you specify 10;20 then the minimum y-axis scale is set at 10 and the maximum y-axis scale is set at 20. If you specify 10;2;20, then, in addition to minimum and maximum values, the y-axis increment is set at 2. Note that this input is currently disabled and you will not be able to change this setting.
7
Horizontal Lines: If you want to add a few extra horizontal reference lines on top of your chart you can specify the values here. The format for this input is numeric values separated by semi-colon. For example, if you specify 12;15 then two horizontal lines are plotted at Y = 12 and Y = 15 respectively. Note that this input is currently disabled and you will not be able to change this setting.
8
Vertical Lines: If you want to add a few extra vertical reference lines on top of your chart you can specify the values here. The format for this input is numeric values separated by semi-colon. For example, if you specify 2;5 then two vertical lines are plotted at X = 2 and X = 5 respectively. Note that this input is currently disabled and you will not be able to change this setting.

Verify

If you click on the Verify button, the software will perform some checks on the data you have entered. A sample screenshot of the dialog box is shown in the figure below. Verify The objective of this analysis as well as any checks that are performed is listed in this dialog box. For example, the software may check 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, then they are shown as a green-colored checkmark. If the verification checks fail, then they are shown as a red-colored cross. If the verification checks result in a warning, they are shown in the orange color exclamation mark and finally, any checks that are required to be performed by the user are shown as blue info icons.

Outputs

Click on Compute Outputs to update the output calculations. A sample screenshot of the worksheet is shown below. outputs
>
Notes: The results of this analysis are shown in the figure by placement of the bubble on the output figure. For each project, the recommended methodology to use to attack the project is listed under the methodology column. A relative score for the attractiveness of the project is shown in the score column. Projects with a higher score are more attractive to the organization compared to a project with lower score.
>
Graph: The graph shows the relative placement of the project on a benefit-effort matrix. Select projects that require low resources and have high benefits.