I’m going to be working on breaking out the water section of our Low Oxygen spreadsheet into its own spreadsheet and I want to solicit some group feedback/content requests.
We have had good luck getting very consistent and accurate pH actuals versus pH estimates with our sheet. The issue is that some people may be using other brewing software such as BeerSmith, Brewers friend, etc and may want to take advantage of the water section without the rest of our sheet.
I still plan on keeping some aspects of the main sheet, like the Low Oxygen color reduction, etc. and in fact, most of the Low Oxygen specific stuff in the main sheet is water specific, i.e. Meta, so that stuff will be present.
We currently have capabilities for Lactic, Phosphoric, Sauergut, Antioxin SBT (trifecta), NaMeta, etc.
We currently have it setup for No Sparge but part of the release and subsequent troubleshooting/adaptation would be to solicit feedback and incorporate sparging into the mix.
One of the most recent implementations was the ability to enter DI pH of base Malts and calculate off of that instead of color. Specialty Malts will still use the color based calcs.
In order to prevent any confusion concerning the accuracy of the sheet, as well as not misrepresent our findings, I’ll say that we have found our calculations to be very consistent and very accurate. This is using an Extech pH110, with 0.01 resolution and advertised 0.01 accuracy. We have seen estimates within +- 0.01 of actual in repeated trials. We have not taken into account any additional tolerances from buffer solutions, etc. I’m hoping to solicit data from those who use these calcs as well to build up a data set.
So I’ll open it up while I start re-writing this as a solo spreadsheet and hopefully you guys have comments, requests, etc.