Page 3 of 4
Re: LODO Sodium Metabisulfite Dosage Spreadsheet
Posted: Fri Jun 10, 2016 12:02 pm
by Brew4Fun
Re: LODO Sodium Metabisulfite Dosage Spreadsheet
Posted: Fri Jun 10, 2016 1:08 pm
by Brandon
Re: LODO Sodium Metabisulfite Dosage Spreadsheet
Posted: Fri Jun 10, 2016 2:04 pm
by Brew4Fun
Re: LODO Sodium Metabisulfite Dosage Spreadsheet
Posted: Fri Jun 10, 2016 2:11 pm
by Brandon
Re: LODO Sodium Metabisulfite Dosage Spreadsheet
Posted: Fri Jun 10, 2016 2:38 pm
by Brew4Fun
Re: LODO Sodium Metabisulfite Dosage Spreadsheet
Posted: Thu Jul 14, 2016 9:18 am
by Big Monk
Here is a link to a down and dirty NaMeta dosage calculator:
https://drive.google.com/open?id=0B8F3C ... 2xjbXZoaU0This calculation is also in the water section of the Low O2 spreadsheet as well.
Re: LODO Sodium Metabisulfite Dosage Spreadsheet
Posted: Fri Jul 29, 2016 4:01 pm
by mchrispen
Did some research on BrewTan B (BTB) and added a dosage calculator to the spreadsheet. Also added a custom sheet to calculate a targeted PPM for SMB - just set your desired PPM and the tables update. The other sheets have no changes. For the BTB, there are two recommended dosages - one for mash and one for boil in the whirlpool, based on finished beer volume. The recommendations differ slightly between mash and boil, and ranges (indicated in the comment) can be set independently. You can change your batch size as well.
Spreadsheet was done in Excel (Office 365). I have not done any testing on any other platform.
- MBS Reference Sheet V3.xlsx
- Excel for Office 365
- (76.71 KiB) Downloaded 524 times
LODO Sodium Metabisulfite Dosage Spreadsheet
Posted: Fri Jul 29, 2016 5:24 pm
by Big Monk
Have you thought about just making a calculator sheet as your main and having the tables as separate printable sheets?
Once you start doing calcs the tables seem to be reference only. A calculation sheet with basic user inputs would be more user friendly and intuitive.
Re: LODO Sodium Metabisulfite Dosage Spreadsheet
Posted: Fri Jul 29, 2016 5:45 pm
by mchrispen
Agreed, just haven't put in the time. Hope to talk to Martin about integrating SMB and BTB tables into Brun Water as an add on.
Sent from my iPhone using Tapatalk
Re: LODO Sodium Metabisulfite Dosage Spreadsheet
Posted: Fri Jul 29, 2016 6:01 pm
by Big Monk