OFFLINE TOOL / ATTRIBUTE CHARTS V1.4
STABILITY / 007OFFLINE

Attribute control charts

P, NP, C, U and Laney P′ / U′ charts with tests for special causes, from counts pasted from Excel or CSV.

Input

Paste, open a CSV, TSV, TXT or XLSX file (up to 20 MB), or drop it on the field. Files are read in this browser only.

Columns

Found by the header names, or in the order Count, Size, Subgroup. Change them if they are wrong.

Lot   Inspected  Defectives
L-01  206        9
L-02  157        5
L-03  180        2
Long format
1 row = 1 measurement

Columns: tab, ; or ,
Decimals: 12,5 or 12.5

Paste measurements to start.

One row per subgroup: the count of defectives or defects, the subgroup size (units inspected) and, if you like, a label such as the lot or date. Size and Subgroup may be left out: choose “(none)”.

Chart

Control limits

p̄ as a proportion: 0.035 for 3.5 %.

Live monitoring
Watch

Not watching. Choose a file or folder.

A file is read when its size and time have not changed for two checks; rows are added to the data above. In this offline file, choose the file or folder again each time you open it.

Tests for special causes

Attribute charts use tests 1–4. With unequal sizes they run on the standardized values, so a count that grows only because the subgroup grew is not a trend.

Runs in this browser. Data is not uploaded or stored.

Results

—

    Method