ElyxAI

Excel for a laboratory manager: which result is outside the limits

The laboratory workbook on this page is the list you open before the morning read of sample results. One row is one sample. You type the sample, the method word, the low limit, the high limit, and the result. The window says in when the result sits on or between the two limits, out when it is outside them, and check when the low limit is above the high limit. This file is not a defect rate. That rate answers defects divided by the quantity made. This list answers which result is outside the limits you typed. It is not a control chart, and it is not a meter log. You type the result. The sheet does not invent a limit. The guide below builds that sample log. Elyx writes the window in the workbook you already keep. You still type the limits and the result. The trial lasts 7 days, with no card.

1 workflows

Frequently asked questions

What goes on a sample result log?

One row per sample: low limit, high limit, result, and a window of in, out, or check.

Is this a defect rate?

No. A defect rate divides a defect count by a quantity made. This sheet uses one result and two limits.

Does the sheet decide the limits?

No. You type the low limit, the high limit, and the result. The window only compares those three cells.

Essential
Popular