operating and management h/w
mbstudent
asq_pareto_and_charts.xlsCS Week Data for Pareto
| TOTAL | Defect Types/ Event Occurrence | Defect Types/ Event Occurrence | TOTAL | |
| 0 | Defect 1 | 0 | 0 | |
| 0 | Defect 2 | 0 | 0 | |
| 0 | Defect 3 | 0 | 0 | |
| 0 | Defect 4 | 0 | 0 | |
| 0 | Defect 5 | 0 | 0 | |
| 0 | Defect 6 | 0 | 0 | |
| 0 | Defect 7 | 0 | 0 | |
| 0 | Defect 8 | 0 | 0 | |
| 0 | Defect 9 | 0 | 0 | |
| 0 | Defect 10 | 0 | 0 |
Instructions
| The "Check Sheet-Weekly" worksheet can be printed for use by individuals in their data collection | |||
| Once data is collected on printed forms, type either the combined data or data for each individual into this Excel worksheet. | |||
| If Data is entered for each individual data recorder, use one of these templates for each individual | |||
| **To determine the overall defect rates, it is recommended that all data be combined from all data recorders | |||
| and entered into this template so that the data can be analyzed overall to find the defect with the most occurences | |||
| The following charts will automatically be generated: | |||
| Histogram: shows the number of defects over time | |||
| Bar Chart: shows the number/count of defects | |||
| Pareto Chart: displays the 80/20 rule for defects | |||
| To modify this template: | |||
| The check sheet is designed to record up to 10 defects or events. If less defects are desired to be recorded, | |||
| hide the corresponding rows in the "Check Sheet-Weekly" worksheet by following these steps | |||
| Select the rows to be hidden by clicking on the row header | |||
| Click "Format" from the menu bar, then choose "Row" then "Hide" |
Check Sheet-Weekly
| Project Name: | |||||||||
| Name of Data Recorder: | |||||||||
| Location: | |||||||||
| Data Collection Dates: | |||||||||
| Defect Types/ Event Occurrence | Dates | TOTAL | |||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | total | ||
| Defect 1 | 0 | 0 | |||||||
| Defect 2 | 0 | 0 | |||||||
| Defect 3 | 0 | 0 | |||||||
| Defect 4 | 0 | 0 | |||||||
| Defect 5 | 0 | 0 | |||||||
| Defect 6 | 0 | 0 | |||||||
| Defect 7 | 0 | 0 | |||||||
| Defect 8 | 0 | 0 | |||||||
| Defect 9 | 0 | 0 | |||||||
| Defect 10 | 0 | 0 | |||||||
| total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Histogram
| Sunday |
| Monday |
| Tuesday |
| Wednesday |
| Thursday |
| Friday |
| Saturday |
Counts
0
0
0
0
0
0
0
Bar Chart
| Defect 1 |
| Defect 2 |
| Defect 3 |
| Defect 4 |
| Defect 5 |
| Defect 6 |
| Defect 7 |
| Defect 8 |
| Defect 9 |
| Defect 10 |
=
Counts
0
0
0
0
0
0
0
0
0
0
Pareto Chart
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
Counts
0
0
0
0
0
0
0
0
0
0
