The Is vs. Is Not analysis is a powerful problem-solving tool that works by making the team think about the problem in more detail - specifically what is and what is not the problem. It helps the team to focus its attention on the right problems that the team is facing and not digress to areas that are not important. This tool helps the team focus on what is in scope and what is not in scope.
You can use this tool when you are part of the way through a problem and you are stuck and not sure what you are trying to solve or having a hard time determining what is important. You can also use this tool when planning a solution to decide what to include and what to exclude from the solution. This analysis documents where, what, when, and who are associated with the problem. This is a good technique to use to pinpoint a problem and narrow down the search for a root cause.
To add the Is vs. Is Not tool to your worksheet, click on Project and then select Is - Is Not Analysis.
Click on Analysis Setup to open the menu options for this tool.
A sample screenshot of the checklist menu is shown below.
Checklist: The input dialog box contains a checklist that you can use to ensure the proper application of the is vs is not analysis. Click on the blue text to toggle the setting to respond to the question.
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 for this topic.
Cancel Button: Click on this button to cancel all changes and exit this dialog box.
OK Button: Click on this button to save all changes and compute analysis results.
On the worksheet, fill out the details about the problem you are trying to solve and highlight the differences for the various elements on what is and what is not the issue you are facing. Based on the differences between these two columns, try to identify the potential causes for these differences. Based on this analysis, try to shortlist the most important potential causes.
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.
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.
Click on Compute Outputs to generate the outputs from this analysis. A sample screenshot of the worksheet is shown below.
Following examples can be found in the Examples folder within the software.
Select a problem (such as a computer making a loud noise during operation) and create an Is-Is Not Analysis (Is vs Is Not Analysis v1.xlsm).