Posting this up here as a BETA version. Please feel free to comment on improvements or potential errors in calculations.
Thanks to Big Monk for sending over the interface page. I did change some of the calculations (such as 76 sulfate + 24 sodium), tried to remove some dependencies (i.e. - working Mash and Sparge with different Metric or US Std volumes would break the Total Water Addition calc).
- Interface_LoDO.png (125.72 KiB) Viewed 10163 times
To use, you can choose variables from the dropdowns looking at SMB or BTB concentrations. If you work in Liters, select that from the RED text area. SMB and BTB are independent calculators. Total Water Addition will allow you to more accurately see water chem impact accounting for any dilution from lauter. The rest of the spreadsheet remains as previously posted. SMB dosages are based on the LODO/Helles paper. The BTB are taken from Ajinomoto BrewTan B product guide, linked on the BrewTan B worksheet.
If you wish to modify the calculations or setup your own dropdown values - you can simply unlock the worksheet. I prefer to use the actual reference dosages so there is a 1:1 correlation to data sheets. You can, of course, modify this how you would like.
- LoDO Dosage Reference V4_BETA.xlsx
- (74.14 KiB) Downloaded 1951 times