CS Week Data for ParetoTOTALDefect Types/Event OccurrenceDefect Types/Event OccurrenceTOTAL10Defect 1Defect 41311Defect 2Defect 31212Defect 3Defect 21113Defect 4Defect 1100Defect 5000Defect 6000Defect 7000Defect 8000Defect 9000Defect 1000

InstructionsThe "Check Sheet-Weekly" worksheet can be printed for use by individuals in their data collectionOnce 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 recordersand entered into this template so that the data can be analyzed overall to find the defect with the most occurencesThe following charts will automatically be generated:Histogram: shows the number of defects over timeBar Chart: shows the number/count of defectsPareto Chart: displays the 80/20 rule for defectsTo 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 stepsSelect the rows to be hidden by clicking on the row headerClick "Format" from the menu bar, then choose "Row" then "Hide"

Check Sheet-WeeklyProject Name:Name of Data Recorder:Location:Data Collection Dates:Defect Types/Event OccurrenceDatesTOTALSundayMondayTuesdayWednesdayThursdayFridaySaturdaytotalDefect 1101010Defect 2111111Defect 3121212Defect 4131313Defect 500Defect 600Defect 700Defect 800Defect 900Defect 1000total1011121300046TOTAL1011121300046

Histogram10111213000

Counts

Bar Chart10111213000000

=Counts

Pareto Chart13121110000000

Counts