Membership questions? Log in issues? Email info@brewersassociation.org

Author Topic: Feedback on New Water Spreadsheet  (Read 8433 times)

Offline homoeccentricus

  • Brewmaster General
  • *******
  • Posts: 2009
  • A twerp from Antwerp
Re: Feedback on New Water Spreadsheet
« Reply #30 on: January 13, 2017, 12:04:50 pm »
I saw that you have a way to put "trifecta" additions in there, but how about...uh..bifecta?  For those of us without brewtan B, will the sheet be able to do meta+AA ?  The last couple batches I have been doing that combination...

Sure! We already currently have a table that receives percentages of the 3 as user inputs and calculates their contributions. I can either adapt that to the g/gal and g total convention or keep the table and you can customize the percentages.

Salts/pH side of things, this is the feature I'm most interested in. I'm moving toward two different blends of trifecta - one for ales and one for lagers. Maybe even make yeast-specific blends.

There will be a "trifecta" blend table. Also it won't be as comprehensive as BW as far as salts are concerned but will contain:

Calcium Chloride, Gypsum, Epsom, Canning Salt, Mash bicarbonate, kettle bicarbonate, mash NaMeta, sparge NaMeta, Absorbic Acid, Brewtan B, Gallotannins and Antioxin SBT.

You can get a feel for how it will be laid out here:
Absorbic acid?
Frank P.

Staggering on the shoulders of giant dwarfs.

Offline homoeccentricus

  • Brewmaster General
  • *******
  • Posts: 2009
  • A twerp from Antwerp
Re: Feedback on New Water Spreadsheet
« Reply #31 on: January 13, 2017, 12:05:32 pm »
Sorry, it's funny.
Frank P.

Staggering on the shoulders of giant dwarfs.

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #32 on: January 13, 2017, 12:09:18 pm »
Yeah! I haven't finished formatting yet and typing the whole name fills the cell.

Offline homoeccentricus

  • Brewmaster General
  • *******
  • Posts: 2009
  • A twerp from Antwerp
Re: Feedback on New Water Spreadsheet
« Reply #33 on: January 13, 2017, 12:16:21 pm »
Sorry, it's ascorbic.
Frank P.

Staggering on the shoulders of giant dwarfs.

Big Monk

  • Guest
Feedback on New Water Spreadsheet
« Reply #34 on: January 13, 2017, 01:37:43 pm »
Sorry, it's ascorbic.

Nice catch. Already fixed it.

Sheet is completely populated. Now for a round of calculation checks. Then error checking. Then I'll have it proofed next week for release before the end of January.

Offline natebriscoe

  • Assistant Brewer
  • ***
  • Posts: 195
Re: Feedback on New Water Spreadsheet
« Reply #35 on: January 14, 2017, 03:44:07 pm »
Will the new sheet be able to go below 25ppm smb?

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #36 on: January 14, 2017, 04:14:00 pm »
Will the new sheet be able to go below 25ppm smb?

Absolutely. Additions will be in the g/gal form like all other minerals. I'll have comments on those cells relating g/gal to ppm.

Offline natebriscoe

  • Assistant Brewer
  • ***
  • Posts: 195
Re: Feedback on New Water Spreadsheet
« Reply #37 on: January 14, 2017, 04:15:49 pm »
Will the new sheet be able to go below 25ppm smb?

Absolutely. Additions will be in the g/gal form like all other minerals. I'll have comments on those cells relating g/gal to ppm.
Awesome. The current full sheet doesn't, does it?

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #38 on: January 14, 2017, 05:01:01 pm »
It doesn't. This sheet will be strictly for water. I have a major revision planned for the main sheet but that won't be ready for a while. This will be a water only sheet.

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #39 on: January 16, 2017, 06:31:58 pm »
I should have the new standalone calculator out this week, along with a users manual and corresponding blog post at lowoxygenbrewing.com.

I'm just working out some kinks and checking the calculations for accuracy.

Offline brewinhard

  • Official Poobah of No Life. (I Got Ban Hammered by Drew)
  • *********
  • Posts: 3272
Re: Feedback on New Water Spreadsheet
« Reply #40 on: January 17, 2017, 04:39:13 pm »
I should have the new standalone calculator out this week, along with a users manual and corresponding blog post at lowoxygenbrewing.com.

I'm just working out some kinks and checking the calculations for accuracy.

Thanks for all the hard work Derrick. Was tinkering around with the initial sheet and found it a little difficult to use.
Liking the way the new spreadsheet looks and am looking forward to checking it out.
Can you please post here when it's up and ready for use?

Big Monk

  • Guest
Feedback on New Water Spreadsheet
« Reply #41 on: January 17, 2017, 04:46:32 pm »
I should have the new standalone calculator out this week, along with a users manual and corresponding blog post at lowoxygenbrewing.com.

I'm just working out some kinks and checking the calculations for accuracy.

Thanks for all the hard work Derrick. Was tinkering around with the initial sheet and found it a little difficult to use.
Liking the way the new spreadsheet looks and am looking forward to checking it out.
Can you please post here when it's up and ready for use?

Thanks man.

Keep in mind: this is a water only sheet.

I do plan on a full revision of the main sheet sometime soon though.

Big Monk

  • Guest
« Last Edit: January 18, 2017, 01:12:36 pm by Big Monk »

Offline Stevie

  • Official Poobah of No Life. (I Got Ban Hammered by Drew)
  • *********
  • Posts: 6858
Re: Feedback on New Water Spreadsheet
« Reply #43 on: January 18, 2017, 02:21:30 pm »
Question - I have my recipe entered, got it to show a strike volume of 4 gallons, entered .35g/gal for gypsum and the result is 1.27. Should be 1.4

What am I missing?

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #44 on: January 18, 2017, 02:24:31 pm »
Question - I have my recipe entered, got it to show a strike volume of 4 gallons, entered .35g/gal for gypsum and the result is 1.27. Should be 1.4

What am I missing?

It subtracts Boil off