Check Sheet Example
Problem Statement
Your team wants to collect data from a particular process since no existing data is being collected. You decide to implement a checklist to collect the data. Design a check sheet with 10 types of defects, 8 part numbers and 4 operators.
How to perform analysis
Open Sigma Magic
- Click on the Sigma Magic button on the Excel toolbar.
- Click on the New button to create a new project.
Step 2: Add the analysis template
- Click on the Tool Wizard to add the analysis template.
- Click on Project and then Check Sheet.
Step 3: Specify analysis options
A new worksheet will be added to your workbook. Analysis Setup will be automatically opened, in the setup tab specify the following details.
If you need to make changes to the charts, specify the optional settings in the Charts tab.
Labels:
- Add a title for the chart.
- Label the X-axis and Y-axis appropriately.
Appearance:
- Adjust colors, font sizes, or other visual elements as needed.
- Enable/disable gridlines or background shading.
Click the Verify tab to ensure all the inputs are okay and shown in a green checkmark.
Step 4: Generate analysis result
Click OK and then click Compute Outputs to get the final results
Interpretating Results
Defect Tracking:
- The check sheet systematically records various defects occurring in different parts.
- It categorizes defects (Defect 1, Defect 2, etc.) and their corresponding locations (Part 1, Part 2) along with their frequency (Count).
Pareto Analysis of Defects:
- The Pareto Plot of Defects reveals that Defect 1 and Defect 4 contribute the most to overall defects.
- The cumulative percentage line helps identify which defects should be prioritized for resolution.
Pareto Analysis of Locations:
- The Pareto Plot of Location highlights that most defects occur in Part 1, followed by Part 2.
- This insight can help teams focus on quality control measures in the most defect-prone areas.
Frequency of Defects by Location:
- The What-Where Check Sheet provides a visual representation of defects mapped to their respective locations.
- Defect 1 is more frequent in Part 1, whereas Defect 4 is more prominent in Part 2.
Data-Driven Decision Making:
- This check sheet serves as a foundation for process improvement by identifying the most problematic defects and locations.
- The results indicate where corrective actions should be focused to reduce defects and improve quality.
Next Steps for Process Improvement:
- Root Cause Analysis (RCA) should be conducted on the major defects.
- Implement preventive measures such as quality control checks in high-defect areas.
- Monitor trends over time using similar check sheets to measure improvements.
Related Articles
Check Sheet Overview
A Check Sheet is a structured, prepared form used for collecting and analyzing data in a systematic manner. It is commonly used in projects to track defects, identify patterns, and support decision-making by capturing real-time data in an organized ...Check sheet frequently asked questions
What is a Check Sheet A Check Sheet is a tool in Sigma Magic used to collect data in a structured manner for quality control and process improvement. It is commonly used to track defects, errors, or occurrences over a period. What types of Check ...Matrix Plot Example
Problem Statement The following variables are data from three distributions (normal, rayleigh, and uniform). Can you check if the variables are correlated using a matrix plot? How to perform analysis Step 1: Open Sigma Magic Click on the Sigma Magic ...Time Study Example
Problem Statement Create a time study for the following case. The TAKT Time for this exercise is 52 sec. Process step Time 1 Time 2 Time 3 Notes Get part from the tub 8 7 10 NVA Load part onto the fixture 20 15 17 Get tape from dispenser 3 2 NVA Put ...Communication Example
Problem Statement You are developing a new mobile application for your company and would like to communicate about this to your stakeholders. You want to target two audiences. All employees notifying them of the development and users of the ...