Data Reporting

Create (for round one) an Excel (Libre Office, whatever) file with bottle identifier, maybe not going to go numbers, website (for the sake of the barcode encoding), rando key, which will allow a review to happen without blatantly asking for script kids to show up, and data.
Transform this into a set of static wordpress pages.
Client (used in the sense of person holding bottle, quite often me) scans barcode.
Goes to static page that’s hardcoded into the bottle.
If the rando is in the request, and the rando is right for the bottle, and the rando isn’t used yet…
Give the form for review collection.
Else, just the static page, with the review, quick links for previous bottle pages.
(Need to look into form submission stuff, also a shutoff switch would be good, safe data collection is good days collection)
The review info should be radio buttons or dropdowns, potentially reviewer name, if I take in the name make it clear that their name is only for looking at trends or something. Might skip the name, a username maybe?

The static pages should be generated based on the data available. Probably a timeline kind of graph.
Start with the recipe / source. Name if available.
Next is boiling. This will be a graph of temperature versus time with dots showing when stuff happened.
Next still be a graph of temperature versus time for fermentation (look at temperature ye git!), again add points of interest for interesting points. When I start collecting it, other data can live on here as well, pressure, atmospheric alcohol, ambient temperature, ambient pressure. O2 and CO2 would be fun, but if I remember not cheap. Light levels would be interesting, as might NIR if I get that going.
Next would be the same graph for aging. A lot of the spare data would be wasted, but there might still be value.
I need to have a way to easily identify all the data I don’t collect, or data collection for lazy data collection. As in I only had the first couple temperatures dir the boil because I broke the thermometer. Ideally a dot style graph, and maybe our clear that connecting lines are entirely guesses.
Right. 41 days until bottling.