KEMBAR78
Defect Tracking & Analysis Template | PDF | Microsoft Excel | Computing
Scribd
Upload
73 views12 pages

Defect Tracking & Analysis Template

This document contains a template for tracking defects and events over time. It includes a checklist worksheet to record up to 10 different defect types each week. The data can then be entered into the template worksheet. Charts will then automatically generate including a histogram of defects over time, a bar chart of counts, and a Pareto chart. Instructions are provided for modifying the number of defect types tracked and hiding rows if needed.

Uploaded by

Darwin Anderson G
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
73 views12 pages

Defect Tracking & Analysis Template

This document contains a template for tracking defects and events over time. It includes a checklist worksheet to record up to 10 different defect types each week. The data can then be entered into the template worksheet. Charts will then automatically generate including a histogram of defects over time, a bar chart of counts, and a Pareto chart. Instructions are provided for modifying the number of defect types tracked and hiding rows if needed.

Uploaded by

Darwin Anderson G
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 12

Defect Types/

Event Occurrence TOTAL

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!
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 wo
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 recor
and entered into this template so that the data can be analyzed overall to find the defect with the most o

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 reco
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"
heir data collection
for each individual into this Excel worksheet.
e templates for each individual
ata be combined from all data recorders
rall to find the defect with the most occurences

f less defects are desired to be recorded,


et by following these steps
Project Name:

Name of Data Recorder:

Location:

Data Collection Dates:

Ventas 2016
Productos/
Mes Enero Febrero Marzo Abril Mayo Junio Julio
TOTAL
016

Agosto Septiembre Octubre Noviembre Diciembre TOTAL


12

10

8
Counts

0
Enero Febrero Marzo Abril Mayo Junio Julio Agosto Septiemb Octubre Noviembr Diciembre
re e
12

10

8
Counts

0
12

10

8
Counts

0
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

You might also like