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

Online The Beerery

  • Senior Brewmaster
  • ******
  • Posts: 1556
    • View Profile
Low Oxygen Brewing Sheet
« on: October 19, 2016, 07:52:55 PM »
Monk and I released a piece we have been working on for quite some time. This sheet is quite amazing and has been built from the ground up to help people put this all together. I am going to link the post from GBF, but we can certainly discuss any and all questions here.

http://www.lowoxygenbrewing.com/uncategorized/low-oxygen-brewing-spreadsheet/
« Last Edit: November 03, 2016, 03:38:35 PM by The Beerery »

Big Monk

  • Guest
Re: Low Oxygen Brewing Sheet
« Reply #1 on: October 19, 2016, 11:45:07 PM »
I'll be working on commenting the sheet out a bit more than it is now for ease of use.

Offline Phil_M

  • Senior Brewmaster
  • ******
  • Posts: 1706
  • Southern Maryland
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #2 on: October 20, 2016, 03:09:03 AM »
Looking forward to trying this, thanks.
Corn is a fine adjunct in beer.

And don't buy stale beer.

Big Monk

  • Guest
Re: Low Oxygen Brewing Sheet
« Reply #3 on: October 20, 2016, 11:07:18 AM »
If you have any questions please feel free to post them here.

Offline homoeccentricus

  • Brewmaster General
  • *******
  • Posts: 2008
  • A twerp from Antwerp
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #4 on: October 20, 2016, 12:11:55 PM »
When is the metric version coming out ;)
Frank P.

Staggering on the shoulders of giant dwarfs.

Big Monk

  • Guest
Low Oxygen Brewing Sheet
« Reply #5 on: October 20, 2016, 12:13:55 PM »
When is the metric version coming out ;)

While maintaining a Metric and a Standard version would be a burden, I can certainly throw together a Metric version.

Luckily Excels "CONVERT" function should make quick work of this but I'd have to really go deep and make sure all the required variables are accounted for.

I would of course be relying on those who use metric to keep me honest.
« Last Edit: October 20, 2016, 12:15:54 PM by Big Monk »

Online The Beerery

  • Senior Brewmaster
  • ******
  • Posts: 1556
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #6 on: October 20, 2016, 01:29:57 PM »
When is the metric version coming out ;)

Oh come on! You should be able to do those conversions on the fly!  8)

In the last few years my brain has basically be turned into a massive converter because of this..Plato, sg, Brix, l, HL,gram, gallon, bbls, mg/l, ppm, lion and tigers and bears oh my.

Offline homoeccentricus

  • Brewmaster General
  • *******
  • Posts: 2008
  • A twerp from Antwerp
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #7 on: October 20, 2016, 01:40:52 PM »
When is the metric version coming out ;)

Oh come on! You should be able to do those conversions on the fly!  8)

In the last few years my brain has basically be turned into a massive converter because of this..Plato, sg, Brix, l, HL,gram, gallon, bbls, mg/l, ppm, lion and tigers and bears oh my.

It's the ounces that are killing me.
Frank P.

Staggering on the shoulders of giant dwarfs.

Big Monk

  • Guest
Re: Low Oxygen Brewing Sheet
« Reply #8 on: October 20, 2016, 01:43:51 PM »
When is the metric version coming out ;)

Oh come on! You should be able to do those conversions on the fly!  8)

In the last few years my brain has basically be turned into a massive converter because of this..Plato, sg, Brix, l, HL,gram, gallon, bbls, mg/l, ppm, lion and tigers and bears oh my.

It's the ounces that are killing me.

For the hops? Take a look at the heading and you'll find a drop down for switching between g and oz.

For the malt? Take a look at the convertor just below the hop section and you can convert the oz portion of the individual grains to g.

Offline macbrews

  • Assistant Brewer
  • ***
  • Posts: 160
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #9 on: October 20, 2016, 02:03:38 PM »
Thanks for all of your work on this.  I’ll give it a go

Big Monk

  • Guest
Re: Low Oxygen Brewing Sheet
« Reply #10 on: October 20, 2016, 03:44:46 PM »
Thanks for all of your work on this.  I’ll give it a go

Cool. Report back when you do.

Offline Stevie

  • Official Poobah of No Life.
  • *
  • Posts: 6858
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #11 on: October 20, 2016, 03:57:06 PM »
Converting has to be a tough task. Not only are the weights and volumes different, but malt color as well. Good luck Derek

Big Monk

  • Guest
Re: Low Oxygen Brewing Sheet
« Reply #12 on: October 20, 2016, 04:56:10 PM »
It's easier than you would think. Excel has a built in function called CONVERT.

So converting to metric would be just going through and seeing where cells would be affected by changes in inputs and then convert the inputs from metric to standard.

What I may do is make a separate sheet within the spreadsheet for metric.

Big Monk

  • Guest
Low Oxygen Brewing Sheet
« Reply #13 on: October 21, 2016, 03:52:19 PM »
Recognizing that the full spreadsheet is a useful tool but also realizing that it contains a very comprehensive set of features, I have put together a quick reference spreadsheet for those who wish to use their current software.

All of this info is in the Low O2 spreadsheet but it should be noted that the Low O2 spreadsheet does not support sparging.


Offline HoosierBrew

  • Global Moderator
  • I must live here
  • *****
  • Posts: 13030
  • Indianapolis,IN
    • View Profile
Re: Low Oxygen Brewing Sheet
« Reply #14 on: October 23, 2016, 05:57:57 PM »
Question - I downloaded a prior GBF reference spreadsheet a few weeks ago that was SMB additions only for mash and sparge. Are those numbers fairly accurate, and if so, the new software is just more comprehensive and user friendly? Or are those numbers not as reliable?
Jon H.