LODO Sodium Metabisulfite Dosage Spreadsheet

Books, websites, links to documents of interest.

Moderator: Brandon

Brew4Fun
Posts: 40
Joined: Fri May 20, 2016 8:02 pm

Re: LODO Sodium Metabisulfite Dosage Spreadsheet

Postby Brew4Fun » Fri Jun 10, 2016 12:02 pm

User avatar
Brandon
German Brewing
Posts: 553
Joined: Tue Oct 13, 2015 8:38 pm
Location: Pennsylvania, USA
Contact:

Re: LODO Sodium Metabisulfite Dosage Spreadsheet

Postby Brandon » Fri Jun 10, 2016 1:08 pm

Visit our home at: and join us on Facebook at
Brew4Fun
Posts: 40
Joined: Fri May 20, 2016 8:02 pm

Re: LODO Sodium Metabisulfite Dosage Spreadsheet

Postby Brew4Fun » Fri Jun 10, 2016 2:04 pm

User avatar
Brandon
German Brewing
Posts: 553
Joined: Tue Oct 13, 2015 8:38 pm
Location: Pennsylvania, USA
Contact:

Re: LODO Sodium Metabisulfite Dosage Spreadsheet

Postby Brandon » Fri Jun 10, 2016 2:11 pm

Visit our home at: and join us on Facebook at
Brew4Fun
Posts: 40
Joined: Fri May 20, 2016 8:02 pm

Re: LODO Sodium Metabisulfite Dosage Spreadsheet

Postby Brew4Fun » Fri Jun 10, 2016 2:38 pm

User avatar
Big Monk
Assistant Brewer
Posts: 282
Joined: Mon Jun 06, 2016 7:29 am
Location: New York

Re: LODO Sodium Metabisulfite Dosage Spreadsheet

Postby Big Monk » Thu Jul 14, 2016 9:18 am

Here is a link to a down and dirty NaMeta dosage calculator:

https://drive.google.com/open?id=0B8F3C ... 2xjbXZoaU0

This calculation is also in the water section of the Low O2 spreadsheet as well.
“We are what we repeatedly do. Excellence, therefore, is not an act, but a habit.” Aristotle

"Messieurs, c’est les microbes qui auront le dernier mot." Louis Pasteur

Check us out at www.lowoxygenbrewing.com
User avatar
mchrispen
Apprentice Brewer
Posts: 167
Joined: Mon Apr 25, 2016 2:15 pm
Location: Austin, TX
Contact:

Re: LODO Sodium Metabisulfite Dosage Spreadsheet

Postby mchrispen » Fri Jul 29, 2016 4:01 pm

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 507 times
User avatar
Big Monk
Assistant Brewer
Posts: 282
Joined: Mon Jun 06, 2016 7:29 am
Location: New York

LODO Sodium Metabisulfite Dosage Spreadsheet

Postby Big Monk » Fri Jul 29, 2016 5:24 pm

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.
“We are what we repeatedly do. Excellence, therefore, is not an act, but a habit.” Aristotle

"Messieurs, c’est les microbes qui auront le dernier mot." Louis Pasteur

Check us out at www.lowoxygenbrewing.com
User avatar
mchrispen
Apprentice Brewer
Posts: 167
Joined: Mon Apr 25, 2016 2:15 pm
Location: Austin, TX
Contact:

Re: LODO Sodium Metabisulfite Dosage Spreadsheet

Postby mchrispen » Fri Jul 29, 2016 5:45 pm

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
User avatar
Big Monk
Assistant Brewer
Posts: 282
Joined: Mon Jun 06, 2016 7:29 am
Location: New York

Re: LODO Sodium Metabisulfite Dosage Spreadsheet

Postby Big Monk » Fri Jul 29, 2016 6:01 pm

“We are what we repeatedly do. Excellence, therefore, is not an act, but a habit.” Aristotle

"Messieurs, c’est les microbes qui auront le dernier mot." Louis Pasteur

Check us out at www.lowoxygenbrewing.com

Who is online

Users browsing this forum: No registered users and 8 guests