Author Topic: Low Oxygen Brewing Sheet  (Read 5060 times)

Offline homoeccentricus

  • Brewmaster General
  • *******
  • Posts: 2008
  • A twerp from Antwerp
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #30 on: October 25, 2016, 04:42:39 PM »
what are greek character (pi? nu?) mash and greek character (pi? nu?) brewhouse? Same as Beersmith Est Mash Eff (98 here, don't know why) and BH efficiency (70 here)?
Frank P.

Staggering on the shoulders of giant dwarfs.

Big Monk

  • Guest
Re: Low Oxygen Brewing Sheet
« Reply #31 on: October 25, 2016, 05:17:34 PM »
Yes η is typically used in technical applications for efficiency.

Big Monk

  • Guest
Re: Low Oxygen Brewing Sheet
« Reply #32 on: October 26, 2016, 12:23:11 AM »
what are greek character (pi? nu?) mash and greek character (pi? nu?) brewhouse? Same as Beersmith Est Mash Eff (98 here, don't know why) and BH efficiency (70 here)?

98% mash efficiency?

Offline homoeccentricus

  • Brewmaster General
  • *******
  • Posts: 2008
  • A twerp from Antwerp
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #33 on: October 26, 2016, 11:50:29 AM »
98% mash efficiency?

Never mind, it's a number that BS generates after you have brewed and have entered some actual numbers.
Frank P.

Staggering on the shoulders of giant dwarfs.

Big Monk

  • Guest
Re: Low Oxygen Brewing Sheet
« Reply #34 on: November 21, 2016, 02:26:37 PM »
I revised the spreadsheet to add back sparge water calculations and wrote a quick little writeup at the site detailing it:

http://www.lowoxygenbrewing.com/uncategorized/how-to-sparge-with-the-low-oxygen-brewing-spreadsheet/

Offline natebriscoe

  • Assistant Brewer
  • ***
  • Posts: 195
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #35 on: January 08, 2017, 02:19:12 AM »
So, I am missing something on the spreadsheet (well many things), how are we adjusting malt ph's? Is it supposed to calculate off target OG or known %s? Think I am looking at from the wrong angle.

Sent from my SM-G930V using Tapatalk


Big Monk

  • Guest
Low Oxygen Brewing Sheet
« Reply #36 on: January 08, 2017, 02:38:15 AM »
So, I am missing something on the spreadsheet (well many things), how are we adjusting malt ph's? Is it supposed to calculate off target OG or known %s? Think I am looking at from the wrong angle.

Sent from my SM-G930V using Tapatalk

As for malt pH, you need to remove all pH altering substances, set the malt to 100% of the grain bill and then enter an override value that gives you the distilled water pH of the malt.



« Last Edit: January 08, 2017, 03:03:39 AM by Big Monk »

Offline natebriscoe

  • Assistant Brewer
  • ***
  • Posts: 195
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #37 on: January 08, 2017, 03:45:17 AM »
So, I am missing something on the spreadsheet (well many things), how are we adjusting malt ph's? Is it supposed to calculate off target OG or known %s? Think I am looking at from the wrong angle.

Sent from my SM-G930V using Tapatalk

As for malt pH, you need to remove all pH altering substances, set the malt to 100% of the grain bill and then enter an override value that gives you the distilled water pH of the malt.


So this override is adjusting the L to get to the predicted mash ph? Or is the ph entered somewhere?   

Big Monk

  • Guest
Re: Low Oxygen Brewing Sheet
« Reply #38 on: January 08, 2017, 03:55:55 AM »
So, I am missing something on the spreadsheet (well many things), how are we adjusting malt ph's? Is it supposed to calculate off target OG or known %s? Think I am looking at from the wrong angle.

Sent from my SM-G930V using Tapatalk

As for malt pH, you need to remove all pH altering substances, set the malt to 100% of the grain bill and then enter an override value that gives you the distilled water pH of the malt.


So this override is adjusting the L to get to the predicted mash ph? Or is the ph entered somewhere?

You are manually inputting this number to manipulate the estimated pH. It's a hot labor intensive but essentially identical to the way you do it in BW, except that beer color isn't subsequently affected.

The next revision of the spreadsheet that I  am working on is an attempt to divorce the base Malts from the DeLange/Kai color type calcs.

Offline natebriscoe

  • Assistant Brewer
  • ***
  • Posts: 195
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #39 on: January 08, 2017, 03:59:36 AM »
So, I am missing something on the spreadsheet (well many things), how are we adjusting malt ph's? Is it supposed to calculate off target OG or known %s? Think I am looking at from the wrong angle.

Sent from my SM-G930V using Tapatalk

As for malt pH, you need to remove all pH altering substances, set the malt to 100% of the grain bill and then enter an override value that gives you the distilled water pH of the malt.


So this override is adjusting the L to get to the predicted mash ph? Or is the ph entered somewhere?

You are manually inputting this number to manipulate the estimated pH. It's a hot labor intensive but essentially identical to the way you do it in BW, except that beer color isn't subsequently affected.

The next revision of the spreadsheet that I  am working on is an attempt to divorce the base Malts from the DeLange/Kai color type calcs.
As I increase the L(ph) my predicted mash ph actually goes up.

Big Monk

  • Guest
Low Oxygen Brewing Sheet
« Reply #40 on: January 08, 2017, 04:02:22 AM »
So, I am missing something on the spreadsheet (well many things), how are we adjusting malt ph's? Is it supposed to calculate off target OG or known %s? Think I am looking at from the wrong angle.

Sent from my SM-G930V using Tapatalk

As for malt pH, you need to remove all pH altering substances, set the malt to 100% of the grain bill and then enter an override value that gives you the distilled water pH of the malt.


So this override is adjusting the L to get to the predicted mash ph? Or is the ph entered somewhere?

You are manually inputting this number to manipulate the estimated pH. It's a hot labor intensive but essentially identical to the way you do it in BW, except that beer color isn't subsequently affected.

The next revision of the spreadsheet that I  am working on is an attempt to divorce the base Malts from the DeLange/Kai color type calcs.
As I increase the L(ph) my predicted mash ph actually goes up.

Right. Increasing the value makes your pH more basic, decreasing more acidic.

Say you have Weyermann Pils with 5.9 pH. You want to increase the malt override. That way you need more acid to get to your desired pH.

You have to remember that BW assumes 5.75 pH as a baseline. Anything above or below that requires some adjustment.
« Last Edit: January 08, 2017, 04:12:35 AM by Big Monk »

Offline natebriscoe

  • Assistant Brewer
  • ***
  • Posts: 195
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #41 on: January 08, 2017, 04:17:32 AM »
So, I am missing something on the spreadsheet (well many things), how are we adjusting malt ph's? Is it supposed to calculate off target OG or known %s? Think I am looking at from the wrong angle.

Sent from my SM-G930V using Tapatalk

As for malt pH, you need to remove all pH altering substances, set the malt to 100% of the grain bill and then enter an override value that gives you the distilled water pH of the malt.


So this override is adjusting the L to get to the predicted mash ph? Or is the ph entered somewhere?

You are manually inputting this number to manipulate the estimated pH. It's a hot labor intensive but essentially identical to the way you do it in BW, except that beer color isn't subsequently affected.

The next revision of the spreadsheet that I  am working on is an attempt to divorce the base Malts from the DeLange/Kai color type calcs.
As I increase the L(ph) my predicted mash ph actually goes up.

Right. Increasing the value makes your pH more basic, decreasing more acidic.

Say you have Weyermann Pils with 5.9 pH. You want to increase the malt override. That way you need more acid to get to your desired pH.

You have to remember that BW assumes 5.75 pH as a baseline. Anything above or below that requires some adjustment.
So a ph of 5.9 would need to be adjusted to 8.5? What about a low ph say 5.5? Can't seem adjust it out.

Big Monk

  • Guest
Low Oxygen Brewing Sheet
« Reply #42 on: January 08, 2017, 04:18:48 AM »
So, I am missing something on the spreadsheet (well many things), how are we adjusting malt ph's? Is it supposed to calculate off target OG or known %s? Think I am looking at from the wrong angle.

Sent from my SM-G930V using Tapatalk

As for malt pH, you need to remove all pH altering substances, set the malt to 100% of the grain bill and then enter an override value that gives you the distilled water pH of the malt.


So this override is adjusting the L to get to the predicted mash ph? Or is the ph entered somewhere?

You are manually inputting this number to manipulate the estimated pH. It's a hot labor intensive but essentially identical to the way you do it in BW, except that beer color isn't subsequently affected.

The next revision of the spreadsheet that I  am working on is an attempt to divorce the base Malts from the DeLange/Kai color type calcs.
As I increase the L(ph) my predicted mash ph actually goes up.

Right. Increasing the value makes your pH more basic, decreasing more acidic.

Say you have Weyermann Pils with 5.9 pH. You want to increase the malt override. That way you need more acid to get to your desired pH.

You have to remember that BW assumes 5.75 pH as a baseline. Anything above or below that requires some adjustment.
So a ph of 5.9 would need to be adjusted to 8.5? What about a low ph say 5.5? Can't seem adjust it out.

You want to go negative for more acidic pH.

Bryan and I use a custom version of the sheet that was designed for his use in The Beerery. I also have a streamlined version that I call the "BLAM" edition specifically for Trappist beers.

I believe what I'm going to do is revise a stripped down version for general use that keeps all the really good Low Oxygen stuff and integrated water stuff but removes some of the unnecessary bits and makes it easier to use.
« Last Edit: January 08, 2017, 04:24:37 AM by Big Monk »

Offline natebriscoe

  • Assistant Brewer
  • ***
  • Posts: 195
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #43 on: January 08, 2017, 04:29:19 AM »
So, I am missing something on the spreadsheet (well many things), how are we adjusting malt ph's? Is it supposed to calculate off target OG or known %s? Think I am looking at from the wrong angle.

Sent from my SM-G930V using Tapatalk

As for malt pH, you need to remove all pH altering substances, set the malt to 100% of the grain bill and then enter an override value that gives you the distilled water pH of the malt.


So this override is adjusting the L to get to the predicted mash ph? Or is the ph entered somewhere?

You are manually inputting this number to manipulate the estimated pH. It's a hot labor intensive but essentially identical to the way you do it in BW, except that beer color isn't subsequently affected.

The next revision of the spreadsheet that I  am working on is an attempt to divorce the base Malts from the DeLange/Kai color type calcs.
As I increase the L(ph) my predicted mash ph actually goes up.

Right. Increasing the value makes your pH more basic, decreasing more acidic.

Say you have Weyermann Pils with 5.9 pH. You want to increase the malt override. That way you need more acid to get to your desired pH.

You have to remember that BW assumes 5.75 pH as a baseline. Anything above or below that requires some adjustment.
So a ph of 5.9 would need to be adjusted to 8.5? What about a low ph say 5.5? Can't seem adjust it out.

You want to go negative for more acidic pH.

Bryan and I use a custom version of the sheet that was designed for his use in The Beerery. I also have a streamlined version that I call the "BLAM" edition specifically for Trappist beers.

I believe what I'm going to do is revise a stripped down version for general use that keeps all the really good Low Oxygen stuff and integrated water stuff but removes some of the unnecessary bits and makes it easier to use.
How about setting the targeted gravity? It seems to only want to calculate by efficiency.

Big Monk

  • Guest
Low Oxygen Brewing Sheet
« Reply #44 on: January 08, 2017, 04:30:57 AM »
So, I am missing something on the spreadsheet (well many things), how are we adjusting malt ph's? Is it supposed to calculate off target OG or known %s? Think I am looking at from the wrong angle.

Sent from my SM-G930V using Tapatalk

As for malt pH, you need to remove all pH altering substances, set the malt to 100% of the grain bill and then enter an override value that gives you the distilled water pH of the malt.


So this override is adjusting the L to get to the predicted mash ph? Or is the ph entered somewhere?

You are manually inputting this number to manipulate the estimated pH. It's a hot labor intensive but essentially identical to the way you do it in BW, except that beer color isn't subsequently affected.

The next revision of the spreadsheet that I  am working on is an attempt to divorce the base Malts from the DeLange/Kai color type calcs.
As I increase the L(ph) my predicted mash ph actually goes up.

Right. Increasing the value makes your pH more basic, decreasing more acidic.

Say you have Weyermann Pils with 5.9 pH. You want to increase the malt override. That way you need more acid to get to your desired pH.

You have to remember that BW assumes 5.75 pH as a baseline. Anything above or below that requires some adjustment.
So a ph of 5.9 would need to be adjusted to 8.5? What about a low ph say 5.5? Can't seem adjust it out.

You want to go negative for more acidic pH.

Bryan and I use a custom version of the sheet that was designed for his use in The Beerery. I also have a streamlined version that I call the "BLAM" edition specifically for Trappist beers.

I believe what I'm going to do is revise a stripped down version for general use that keeps all the really good Low Oxygen stuff and integrated water stuff but removes some of the unnecessary bits and makes it easier to use.
How about setting the targeted gravity? It seems to only want to calculate by efficiency.

That's correct. PBG is set by mash η and OG by Brewhouse η.

Blue-ish cells are user inputs. Pinkish cells are calculated. Maroon are dropdowns.