Services

Quality Data, From Supplier CoA to Customer CoA

Four pieces of one system. Most clients start with customer CoA generation on a single product line, then build out from there.

Book a Free Call →

Quality data has a path through every plant: it arrives on a supplier's certificate or comes off your own lab bench, someone checks it against spec, and it leaves on a certificate to your customer. In most plants a person carries it by hand at every step.

We automate the carrying and keep the judgment with your people. Each service below is one stage of that path, and they share a single lot-keyed record — so the number your reviewer approved is the number your customer sees.

01

Most commonfirst project

Customer CoA Generation

The Right Certificate, Every Shipment, in One Click

Each customer wants their own template, parameter list, and limits — and a wrong value on a certificate is a customer complaint at best. We generate customer-specific CoAs straight from approved lot data, so the person shipping doesn't have to be the person who knows every customer's requirements.

What We Build

  • Templates per customer and product, in your existing document format
  • Generate-and-email in a single action
  • Qualification check: blocked unless that customer, product, and supplier pairing is approved
  • Blocked unless every parameter has an approved value
  • Immutable issued CoAs — corrections are new versions

What Changes for Your Team

  • Sales or shipping can issue a CoA without pulling in QC
  • No copying values from spreadsheets into Word
  • A searchable history of every certificate ever sent

What You Get

  • Certificates that can only contain approved data
  • An exact copy of what each customer received, on file
  • A new customer template added without new code
02

Supplier CoA & Lab Data Intake

Stop Transcribing Certificates by Hand

Supplier CoAs arrive as PDFs and spreadsheets in every layout imaginable. Production logs and lab results live somewhere else again. We pick them up on a schedule, read each one against that supplier's known format, and stage the values for review — with a link back to the exact document they came from.

What We Build

  • Scheduled pickup from email, shared drives, and file drops
  • A parser per supplier format, locked against its expected rows and units
  • Alerts when a supplier changes their layout or drops a value
  • Matching supplier lots to your own lot numbers
  • Import of production logs and in-house lab results

What Changes for Your Team

  • Nobody retypes a supplier certificate
  • A mis-read is caught at the door, not on a customer CoA
  • Every value can be traced to its source page

What You Get

  • Supplier data staged for review within minutes of arriving
  • A clear record of which documents arrived, and which didn't
  • A repeatable process for onboarding each new supplier format
03

Review & Approval Workflow

Automate the Paperwork, Keep the Judgment

Automation shouldn't mean nobody looked. Every lot's data waits in one queue for your quality reviewer, with out-of-spec values already flagged. One approval per lot moves it into the record; anything that stalls — a lot that won't match, a document that won't parse — becomes a numbered exception that someone closes with a comment.

What We Build

  • A single review queue: exceptions, blocked lots, pending approvals
  • Out-of-spec flags against your spec and each customer's limits
  • Attributable approve/reject decisions, one per lot
  • Exceptions that stay attached to their documents for audit
  • Sign-in per person — no shared logins

What Changes for Your Team

  • Review time goes to the lots that need attention
  • "Who approved this?" has an answer, with a timestamp
  • A dead feed is visible, not silent

What You Get

  • Nothing downstream can use data that hasn't been approved
  • An audit trail you can hand to a customer or registrar
  • Fewer surprises at release time
04

SPC & Process Monitoring

Control Charts on Data You Can Trust

SPC is only as good as the data feeding it — and when feeding it means typing, charts fall behind. Once approved data lives in one record, control charts, capability, and trend reports come almost for free. We can feed the SPC package you have, migrate its history, or replace it when you're ready.

What We Build

  • Automatic feeds into your existing SPC software
  • History migration from legacy SPC and spreadsheets
  • Control charts, Cpk/Ppk, and run-rule alerts
  • Supplier performance and lot-to-lot trending
  • DOE and root-cause analysis support

Tools We Use

  • Python
  • SQL / PostgreSQL
  • JMP
  • Power BI
  • Your existing SPC package

What You Get

  • Charts that are current without anyone keying data
  • Early warning on supplier and process drift
  • Capability numbers ready for customer and audit requests

How Every Engagement Works

Common Questions

Do we have to replace our ERP or SPC software?

No. We build alongside what you run. The system reads from your existing sources and can feed your current SPC package. Replacing anything is a later, separate decision — and only if it makes sense.

Where does the system run?

Wherever you prefer: a server or virtual machine on site, or a cloud account you own. It runs in standard containers, so moving it later is straightforward.

What if a supplier changes their CoA format?

The system notices. Each supplier format is locked against its expected rows and units, so a changed layout raises an exception instead of being mis-read. Adding the new layout is a small, routine change.

Do you work on hourly or fixed-fee?

Both. Assessments and first-line builds are fixed-fee — you know what you're paying before we start. Ongoing support is a fixed monthly fee. Large custom projects may use time-and-materials with a not-to-exceed cap.

What's your payment structure?

50% at engagement start, 25% at midpoint, 25% on delivery. Monthly support is billed in advance.

Not Sure Where to Start?

Start with a free 30-minute call. Tell us how a CoA gets made at your plant today, and we'll tell you which piece to automate first.

Or email us directly: hello@foundrydatagroup.com