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).
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.
Statistics: Posted by mchrispen — Sat Jul 30, 2016 11:14 am
]]>
]]>
]]>
You just need to change the drop downs to read batch size (l) and Batch size (gal). Then change the cell below it to match these name changes.
Sent from my iPad using Tapatalk
Statistics: Posted by Big Monk — Sat Jul 30, 2016 8:15 am
]]>
I made a mistake. The dose rate should be 0.4 g/l.
You can change the labels to whatever you'd like. If it's full batch size then you can just relabel the columns.
You can unlock the sheet and make any edits you'd like. I put it out there for anyone. It's likely got a few errors. I copy pasted from the NaMeta section.
I can go in later tonight and make the appropriate edits.
Statistics: Posted by Big Monk — Fri Jul 29, 2016 8:48 pm
]]>
Ok - I am lost. I never used this feature I guess, despite using Excel for over 20 years.
Cannot find the rows/columns display to work out how the BTB section is working.
The dosage is based on batch size, not strike or boil volume. It throws an error when I simply try to change the g/l or mg/l to g/hl.
Statistics: Posted by mchrispen — Fri Jul 29, 2016 8:44 pm
]]>
Statistics: Posted by Big Monk — Fri Jul 29, 2016 8:28 pm
]]>
]]>
]]>
]]>
Spreadsheet was done in Excel (Office 365). I have not done any testing on any other platform.
Statistics: Posted by mchrispen — Fri Jul 29, 2016 4:01 pm
]]>
https://drive.google.com/open?id=0B8F3C ... 2xjbXZoaU0
This calculation is also in the water section of the Low O2 spreadsheet as well.
Statistics: Posted by Big Monk — Thu Jul 14, 2016 9:18 am
]]>
]]>
]]>
]]>