Skip to main content

Production QA Log 2014–2017: Four Years of Batch Records

The least-composed document the archive holds, which is exactly its value: the running QA log of flagship production, 2014–2017 — 155 stage records across roughly forty brews, measured at the tank, batch after batch. Nobody writes a log like this for an audience, and that is why it is worth reading.
Get the data

CSV, full precision: production-qa-log-2014-2017.csv · Archived copy: doi:10.5281/zenodo.21880028 · Cite: Production QA Log, flagship sorghum beer, 2014–2017. Bard's production records, republished by Gluten Free Brewer, 2026. https://glutenfreebrewer.com/research/production-data/production-qa-log-2014-2017 · Full terms and version history under Reuse.

This is the working quality log kept during contract production of the flagship golden lager. Each row is one sample at one stage of one brew: turbidity at two spin levels, pH, color, bitterness, gravities, real and apparent extract, RDF, pounds of extract, calories — and, on twenty-one rows, the words "Gliadin Negative."

Explore this data​

Sort, filter, compare samples side by side, and plot any two measures against each other. The full tables below remain the printable, citable record; this is the same data, interactive.

Interactive explorer155 stage records

Loading the explorer…

The dataset​

155 records, 2014–2017, full precision in the CSV. A representative brew (BBGL #5, June–July 2014) reads like this:

DateStageFTU 90pHOG °PABV %RDF %Note
06-04W—5.5216.1——
06-16R—3.6216.27.0266.1Gliadin Negative
06-30C2723.5116.16.9665.9
06-30F2263.7111.34.7365.1Gliadin Negative
07-03X1243.5711.24.6865.0Gliadin Negative

Reading notes​

  • The gluten testing is in the batch record — for one season. Twenty-one rows carry "Gliadin Negative": brews 3 and 5–10, three checkpoints each (R, F and X — fermentation, filtration, final), dated 2014-04-14 to 2014-10-24. No 2015, 2016 or 2017 row carries the note. Read this as the 2014 validation programme — seven batches tested at three stages while the trust chain was being proven — not as four years of continuous testing evidence; whatever testing followed was recorded off this log, if at all. And read each row for what it is: the log-keeper's entry of a test outcome, not a laboratory certificate — the certificates belong to the QA chain's records. (An earlier version of this note said "across the years… as routine"; the dates say one season — corrected 2026-09-04.)
  • The high-gravity dilution is visible in the data. OG sits near 16.5°P through the early stages, then drops to ~11°P between the C and F stages — the documented extract-era practice of fermenting strong and cutting to package strength, showing up in raw numbers years before the procedure document that describes it.
  • Turbidity tells the clarity story. Across the full log (the CSV), FTU values run to the thousands mid-process and land in the tens at the final stage — the excerpt above shows the tail of that fall (272 → 124) — the practical wort-clarity battle this site's whole evaluation argument turns on, measured batch by batch. One basis gap, named rather than papered over: the log records turbidity "at two spin levels" and heads the column FTU 90, and what the "90" designated — spin time, speed, or measurement geometry — did not survive in the record.
  • RDF holds a 65–68% band for four years — real consistency, though the log is honest about where it sits: at and just under the published spec (RDF 68 ± 1) rather than perfectly inside it. The log shows what production actually held; the spec shows what was promised — and the gap between them is data too.
  • Stage letters are as recorded. W, R, C, F, X were the log's own shorthand and the file does not define them. Reading the gravities: W is knockout wort (no alcohol yet) and X is the final packaged state — that much the numbers say; the rest is left as recorded rather than guessed.
  • One column is unlabeled in the source and is preserved as unlabeled_value, unexplained, because inventing a label would be worse than admitting one is missing.

What was removed​

The facility identifier column. This log was kept at a contract production facility; the facility is not named on this site, and its single-code column is the only thing withheld from the record. Tank codes, sample IDs, and every measurement are as written.

Record​

First published 2026-08-10 as v1.0. Corrections to date: none. This dataset is a frozen record — it changes only for corrections, and every correction is logged in this section with its date and what changed.

Where else this data lives: nowhere public — working QA logs never leave the brewery. This page is the exception, on purpose.

Reuse: download, cite, tell us​

→ Download as CSV — all 155 records, all columns, full precision.

Production QA Log, flagship sorghum beer, 2014–2017. Bard's production records, republished by Gluten Free Brewer, 2026. https://glutenfreebrewer.com/research/production-data/production-qa-log-2014-2017

Permanently archived on Zenodo under CC BY 4.0, site-independent. Archived copy of this version: doi:10.5281/zenodo.21880028 · all versions (always resolves to the latest): doi:10.5281/zenodo.21880027. A logged correction publishes a new version; the all-versions DOI keeps pointing at the current one.

Source and Validation Notes

Transcribed programmatically from the original workbook (two sheets, data spanning 2014–2017) using cell positions, not the text extraction — a column-drift quirk between sheets (the stage letter migrating between two columns) was resolved in parsing and both variants verified. Values are as recorded by the facility's QA bench; nothing has been recomputed. The gliadin notations record the log-keeper's entry, not a certificate — what that distinction means.

Research needed