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/
I’ll be working on commenting the sheet out a bit more than it is now for ease of use.
Looking forward to trying this, thanks.
If you have any questions please feel free to post them here.
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.
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.
Thanks for all of your work on this. I’ll give it a go
Cool. Report back when you do.
Converting has to be a tough task. Not only are the weights and volumes different, but malt color as well. Good luck Derek
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.
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.
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?
I wrote the interface that Matt used for his tabular form SMB spreadsheet on the GBF.
I would use this new one over any other. It accounts for color and pH as well.
Ok thanks. I’ll download the software soon for the extra features, I was just curious if the additions were fairly accurate on the other one.
Yup. I put it together for those who want some key information to supplement their existing software before they try the full sheet.
Another thing I may try to incorporate into the smaller sheet is an infusion step mash calculator for those using coolers.
As promised:
Files is updated and currently in the folder.
