# Defect Check Sheet Worksheet (Tally by Day)

> Source: https://netray.co/tools/defect-check-sheet-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Tally defect types by day, get row and column totals, and feed the counts into a Pareto chart. Exports to Excel.

## Category

quality

## Industry

Manufacturing

## Audience

- Quality engineer
- Production supervisor
- Operator
- Six Sigma Green Belt

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Defect type

**Key:** defect

**Type:** text

#### Mon

**Key:** mon

**Type:** number

#### Tue

**Key:** tue

**Type:** number

#### Wed

**Key:** wed

**Type:** number

#### Thu

**Key:** thu

**Type:** number

#### Fri

**Key:** fri

**Type:** number

#### Total

**Key:** total

**Type:** number

**Expr:** mon + tue + wed + thu + fri

**Format:** integer

**Rows:**

**Defect:** Burr on edge

**Mon:** 12

**Tue:** 9

**Wed:** 14

**Thu:** 11

**Fri:** 8

**Defect:** Scratch

**Mon:** 5

**Tue:** 7

**Wed:** 4

**Thu:** 6

**Fri:** 3

**Defect:** Oversize bore

**Mon:** 2

**Tue:** 1

**Wed:** 6

**Thu:** 2

**Fri:** 1

**Defect:** Missing thread

**Mon:** 0

**Tue:** 1

**Wed:** 0

**Thu:** 2

**Fri:** 0

**Defect:** Wrong label

**Mon:** 1

**Tue:** 0

**Wed:** 1

**Thu:** 0

**Fri:** 2

**Totals:**

#### Mon total

**Key:** mon

**Agg:** sum

**Format:** integer

#### Tue total

**Key:** tue

**Agg:** sum

**Format:** integer

#### Wed total

**Key:** wed

**Agg:** sum

**Format:** integer

#### Thu total

**Key:** thu

**Agg:** sum

**Format:** integer

#### Fri total

**Key:** fri

**Agg:** sum

**Format:** integer

#### Week total

**Key:** total

**Agg:** sum

**Format:** integer

**Summary:**

#### Average defects per day

**Key:** daily

**Expr:** sum_total / 5

**Format:** decimal

#### Largest single defect count

**Key:** top

**Expr:** max_total

**Format:** integer

#### Largest defect share of total

**Key:** top_share

**Expr:** max_total / sum_total * 100

**Format:** percent

**Description:** Look for the vital few.

**Notes:** Record the lot size or units inspected each day on your export so you can convert counts to rates. Sort the final totals from highest to lowest to build a Pareto chart.

## Content

**Intro:** A check sheet is the simplest data tool in the Six Sigma toolbox: a form where counts are tallied as defects occur. This worksheet totals by row and by day so you can see patterns and take the counts straight to a Pareto.

**Sections:**

#### How to use the check sheet

**Body:** Agree defect categories before you start. Use clear operational definitions such as 'burr taller than 0.1 mm on edge A', not 'bad finish'. Add one row per defect type and enter the daily counts. If your shifts differ, duplicate the worksheet per shift. The sheet totals each row, each day and the week, and shows the largest defect's share of all defects. Write down units inspected beside the data so counts can become rates.

**Bullets:**

- Define each defect so two inspectors count the same thing
- Keep an 'Other' row but investigate if it grows large
- Collect at the point of detection, not from memory
- Record units inspected to get a defect rate

#### From check sheet to Pareto

**Body:** The weekly totals are the input to a Pareto chart. Sort defect types by total, compute each share and the cumulative share, and look for the few categories that account for roughly 80% of defects. Those are your project targets. Daily columns also reveal patterns: a spike on Wednesday may match a material lot, a tool change or a different operator, which a fishbone can then explore.

#### Common mistakes

**Body:** The usual problems are vague categories, tallying after the fact, and changing definitions mid-study. Counting defects without the units inspected makes weeks with different volumes look unfairly different. Stratify the data by shift, machine or operator when you suspect they matter, and keep the form simple enough that operators will actually use it. A check sheet nobody fills in reliably is worse than none.

**Cta:** If you would like defect counts captured directly from your ERP or MES inspection transactions, Netray can help automate that feed.

**Faq:**

#### What is a check sheet in quality?

**Answer:** A check sheet is a structured form for collecting data in real time at the place it is generated. It is one of the seven basic quality tools and usually produces counts by category, time or location.

#### How is it different from a tally sheet?

**Answer:** They are largely the same idea. Tally sheets emphasize marking counts as events occur. Check sheets may also include checklists or defect location diagrams. This worksheet is a tally-style check sheet.

#### How long should I collect data?

**Answer:** Collect long enough to see typical variation, often two to four weeks or several hundred units, depending on defect frequency. Rare defects need longer. Avoid drawing conclusions from one unusual day.

#### Can I change the days?

**Answer:** You can edit the row labels and values, but the columns are fixed to Monday through Friday here. For other periods, export to Excel and adjust the columns, or run one worksheet per week.

## Search terms

check sheet template, defect tally sheet excel, quality check sheet example, defect check sheet manufacturing, data collection sheet six sigma, tally sheet template, defect concentration check sheet, 7 QC tools check sheet

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json