QC LIMS Demo: Test the Sample, Trace the Lot, Certify the Batch

Take a coatings batch from lab request to signed certificate of analysis, and trace a drifting result to its raw material lot.
1:42

The problem: QC results that stop at the test

A QC result is only useful if you can see where it came from. When tests, lots and certificates live in separate systems, a drifting result is hard to trace and slow to act on.

A drifting viscosity result in QC may come from a raw material lot, a process change or the test itself. When tests, lots and certificates sit in separate places, working that out means manual cross-checking.

‍

What this demo shows

  1. Start from a lab request for a coatings batch.
  2. Test the sample and catch a drifting result.
  3. Trace the result back to a raw material lot.
  4. Issue a signed certificate of analysis.

‍

Why it matters

Don't wait for a report to discover a process drifting out of control. Control charts with run rules flag the trend, and lot data shows the common cause.

Certifying the batch from locked, signed results connects the certificate to the testing behind it.

‍

See it with your own data

This video is part of QC LIMS. To see how it would work with your own formulations and records, request a demo. Our team replies within 30 minutes during business hours.

Read the transcript

Uncountable is one platform for R&D and quality. This is how its LIMS runs QC from the first lab request to the certificate of analysis. QC work starts with a lab request. It names the batch, the tests to run, who leads the work, and when it is due. The sample comes in with a barcode label.

One scan pulls up its batch. The product spec is already assigned, so each result is checked as it is entered. Green is in spec. Red is out. The full viscosity curve is stored with the batch, too. Not only one summary number. A retest goes in as a new replicate under the first result.

It fails, too. Both values stay on record, and the experiment check marks the batch as failing. Is it a one-off? The control chart plots each batch against the mean, the three sigma lines, and the spec limits. A run rule flags six batches climbing in a row. So, what changed? Plot the same results by raw material lot.

Every climbing batch used the same resin lot. The next batch uses a different resin lot, and every result comes back green. The experiment check passes. QC locks the passing batch and signs it with a PIN. After that, no changes are allowed. Pick the spec and the batch, and one click fills the certificate of analysis.

Nobody retypes a number. From the first request to the certificate, every sample, result, and lot stays connected in Uncountable.

FAQs

What does a QC LIMS workflow look like in Uncountable?

It starts with a lab request naming the batch, tests, lead and due date. Samples are scanned, results are checked against the product spec as they're entered, and passing batches are locked, signed and certified.

How do I trace a drifting QC result?

Control charts with run rules flag the trend. Plot the same results by raw material lot to find the common cause, such as a shared resin lot.

How is the certificate of analysis created?

Pick the spec and the signed batch, and one click fills the certificate of analysis. Nobody retypes a number.