Help Manual

Contents






Sigma Magic Help Version 17

Check Sheet

Overview

The check sheet tool captures data at any point to analyze potential problem areas or monitor process improvements. Data is critical to decision-making, and if there is no current automated way to collect the data, then a check sheet could be deployed to collect the data. A The operator can easily use the Check Sheet and provide data to make good business decisions. There are different types of data that you could potentially capture, such as:
  1. What: Type of the defect
  2. Where: Where does this defect occur (or you could specify part number)
  3. When: When does the defect occur (such as day of the month, day of the week, time of the day, etc.)
  4. Who: Who is responsible for either making or detecting the defect (this could be a department or person)


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

Inputs

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

Setup

A sample screenshot of the setup menu is shown below.
Input Dialog Box The checklist contains the following four topics.
OptionDescription
WhatThis is a required field, and there are a minimum of two categories required for this field. These could be, for example, the type of defects.
WhereThis is an optional field and captures where the defect occurs. It could be different part numbers or the location of a given part.
WhenThis is an optional field and captures when the defect occurs. It could be different days of the week, hours of the day, etc.
WhoThis is an optional field and captures who caused the defect. It could be the name of the person, department, or supplier.
1
Description: Provide a short description for each topic. You can leave it as the default or name something more meaningful for your project. Make sure that all the names you provide for different topics are unique.
2
Num Items: The number of categories for each topic should be specified in the dropdown box. If this box is marked as 0, we have ignored this topic in our analysis. The first topic, "What," is a required field and cannot be specified as 0.
3
Category Labels: For each topic, specify a subcategory. You will need to provide a label for each count. For example, if we have five subcategories for What and four subcategories for Where, we could have the following labels.
OptionDescriptionLabels
WhatDefectsScratches, Burn, Burr, Color, Thickness
WhereLocationLeft, Right, Top, Bottom
4
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.
5
Help Button: Click on this button to open the help file for this topic.
6
Cancel Button: Click on this button to cancel all changes and exit this dialog box.
7
OK Button: Click on this button to save all changes and compute analysis results.
Deploy the data collection sheet to the operators and ask them to collect it. The data could be collected and entered immediately when the defect is observed. You can transcribe the operator notes periodically or at the end of the shift onto the worksheet.
  • Select the What, Where, When, and Who as applicable from the dropdown boxes. Note that some of these columns may be hidden depending on the options you have specified in the input dialog box.
  • Specify the count associated with each row. If every defect is observed, the count column will just be 1's; if not, count the total number of defects corresponding to that row and enter the count here.

Charts

You will see the following dialog box if you click the Charts button. Charts
0
Pick Charts: Specify which charts you would like to generate for this analysis.
1
Title: The system will automatically pick a title for your chart. However, if you want to override that with your 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 want to override that with your subtitle, 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 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 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, 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, in addition to minimum and maximum values, the x-axis increment is set at 2. Note that this input is currently disabled, and you cannot 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, the minimum y-axis scale is set at 10, and the maximum y-axis 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 cannot change this setting.
7
Horizontal Lines: You can specify the values here to add a few horizontal reference lines to your chart. The format for this input is numeric values separated by semi-colon. For example, if you specify 12;15, two horizontal lines are plotted at Y = 12 and Y = 15, respectively. Note that this input is optional.
8
Vertical Lines: You can specify the values here to add a few extra vertical reference lines to your chart. The format for this input is numeric values separated by semi-colon. For example, if you specify 2;5, two vertical lines are plotted at X = 2 and X = 5, respectively. Note that this input is optional.

Verify

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-colored checkmarks. If the verification checks fail, they are shown as a red-colored cross. The verification checks are shown in the orange exclamation mark if the verification checks result in a warning. Finally, any checks required to be performed by the user are shown as blue info icons.
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.

Outputs

Click on Compute Outputs to update the output calculations. A sample screenshot of the worksheet is shown below. Check Sheet Example The following message is displayed upon successful completion of this analysis: Output Message The analysis provides a Pareto chart for each input column in the notes area. The Pareto charts are displayed in the charts area, along with a 2D check sheet. The 2D check sheet can help you identify the possible interaction between variables. The different possible 2D check-sheets are:
  1. What-Where Chart: This chart combines the display of the type of defects and where the defects occur. This chart can identify regions where the defects are maximum and regions where defects are minimum. This may give you a clue as to why this pattern is being observed.
  2. What-When Chart: This chart combines the display of the type of defects and when the defects occur. This chart can be used to identify if there is any pattern between the defects and when they occur.
  3. What-Who Chart: This chart combines the display of the type of defects and which causes the defects. This chart can be used to identify if there is any pattern between the defects and who is causing them.

Notes

Here are a few pointers regarding this analysis:
  • Pareto charts are created one variable at a time and, as such, total the defects across all other variables.
  • The What-Where, What-When, and What-Who charts only occur for a specific combination of inputs, and these charts only display if you have the appropriate column inputs in your data.

Examples

The following examples are in the Examples folder.
  • Select an assembly process for a product and create a check sheet to collect and summarize the data for the types of defects, where the defects occur, and who causes the defects. Assume that there are 10 types of defects, eight parts, and four operators (Chart Sheet 1.xlsx).