Quality records

Quality records in a spreadsheet

Quality control in a spreadsheet, sign-offs in an email thread, and a report built by hand. It holds, until somebody asks what happened months ago.

What a quality record is

A quality record is the evidence that a check was done: what was measured, against what limit, who looked at it, what they decided, and when. It is written once and read later, by somebody who was not there.

That last part is the whole job, and it is the part a spreadsheet was never built for. A spreadsheet is very good at holding what somebody typed. It has nothing to say about whether the reading was right when it was typed, whether the cell was changed afterwards, or where the approval went.

Where the spreadsheet stops working

Most quality control spreadsheet templates are the same sheet: a row per check, a column for the reading, the limit, the initials and the date. It starts as an Excel quality tracking spreadsheet somebody built in an afternoon, and it is genuinely useful for a while. The quality management challenges a manufacturing line runs into are rarely about the template. They are about what the template cannot hold.

  • The reading is typed in afterwards

    The number on the line and the number in the cell are two different things, and only one of them was true at the time.

  • The approval is somewhere else

    The sheet says approved. Who approved it, what they were looking at and when, is in an email thread somebody has to find.

  • There are two copies, and neither is the record

    Two people, two laptops, two spreadsheets, and the one on the shared drive is neither of them.

  • A cell can be overwritten

    Nothing in the sheet says a value was changed, so the record of a bad batch can quietly become the record of a good one.

The report that is rebuilt every week

The manufacturing quality report template is the second spreadsheet. The numbers are pulled out of the first one, filtered, charted and pasted into it, and the finished report is only as current as the last time somebody did that. It says what the sheet said on the day it was built. It cannot say what changed in the sheet since.

The time that takes comes out of the quality manager's week, and it is time nobody is spending on the line.

What happens months later

The reason any of this matters arrives late. Somebody asks what happened on a batch months ago: which readings, against which limits, who signed, and in what order.

The sheet has the rows that were typed. The thread has the approvals that were sent. The shared drive has whichever versions it kept. Putting those back together into one account of what happened is a job, and it lands on the person who kept the spreadsheet.

What replaces it

Not a bigger spreadsheet, and not a better template. The record has to be written from the live value rather than typed in afterwards, and the approval has to be part of the record rather than beside it.

That is what Opcela Quality does. It subscribes to your OPC-UA tag values, asks a named person to approve when a tag value meets a condition, and records the approval. The reports and the signoff certificates come out of that record rather than being assembled from a spreadsheet, and nothing in the application edits or deletes an entry.

Tell us about your operations

Opcela Quality pilot programme

Only 5 FREEPilot Places

We are taking on 5 manufacturing sites to trial Opcela Quality: automated checks and handheld scanning in place of paper check sheets.

No charge for the software, set-up or training. Your site supplies the handheld scanners and IT access.

Only 5 places available, because that is all we can handle right now. Places are offered by fit, not first come first served.

Apply for a place