Big Monk
Trappist Please! 🍷
- Joined
- Dec 24, 2015
- Messages
- 2,192
- Reaction score
- 1,152
It can be locked to the creator and to a list of individuals the creator chooses.
You can open it read only and save the file with no protection. No bueno.
It can be locked to the creator and to a list of individuals the creator chooses.
This is very clearly great work & should be helpful to many.
My question would be whilst predicting the IBU of a given brew, how important is the prediction of alcohol?
One other thought, how well suited is this to Kit brews, particularly those modified with extra malt & enhancers?
Not important at all. IBU predictions all take place pre-fermentation, i.e. no alcohol present.
I'm not exactly sure what you are asking? Do you mean all grain batches with extra grains and sugars? If so, then it will accommodate them fine.
If you are talking about extract batches, it isn't suited at all, as this sheet if for all-grain brewing.
Did I answer both of these questions well enough?
Yes:
Not suited to brew made from extract kits (the so called K&K brews).
Pity about that, I wonder if modification could be made so that extract brewers could benefit also?
Regarding alcohol, I was trying to ask if it is useful to predict the ABV; after all it's not rocket science to be able to estimate from the amount of fermentables what the final ABV will be, within perhaps + or - 0.5%?
Thanks for the response.
It's not posted anywhere if that's what you mean but you can certainly have it if you want it. Send me a PM with and e-mail address. You can also have the basic functions that do the fundamental calculations such as the charge on water, the charge on malt, find mash pH etc.Very interesting, good job. Is A.J.'s data publicly available?
@RPIScotty: I am brewing on Sunday. Would love to give your work a try and would commit to quick feedback to you. Excited to try this. What is the mechanism for gaining access?
In the next week or so I am going to be posting a very stripped down version of the sheet. There are others that are now working on some stuff that I believe will turn out to be more solidly composed than my initial stab.
I plan to simplify the malt classes down to Base, Wheat/Rye, Roast, Crystal, etc. and give a generally more simplistic calculation structure.
Gee, I don't have an eye of newt function but I do have functions that use Newton's method. Is that close enough?Can I disable the LODO functions and/or trade them for eye of newt utilization functions?
I doubt that would help me in my ultimate quest to brew a thixotropic NEIPA.Gee, I don't have an eye of newt function but I do have functions that use Newton's method. Is that close enough?
Now I know I need to get a copy of Microsoft Office!
I personally think A.J.'s full sheet is the real way to go but mine has a certain look and format that can be adapted into other sheets.
Microsoft has free online office apps, similar to the google apps. They aren't full feature but maybe worth a shot.Now I know I need to get a copy of Microsoft Office!
Here is something I whipped up for people to use as they see fit. I'm calling it "Brewing Engine Lite" as it removes all the extra functions except for pH estimation. Available in % and Mass based grain input:
Remembering our discussions about which was preferred I decided the appropriate thing to do would be offer both in the same program. I wrote my demo sheet to take mass but added a button which normalizes all the masses to a value put into a separate cell. If yo want 2 pounds of this and 8 pounds of that you just enter 2 and 8 but if you want 20% of this and 80% of that you enter 20 and 80. Ultimately if you do this you need to determine 20% and 80% of what in order to know how much of each malt to buy or to experiment with wort strength vs total grain in an 80/20 blend. If you want to try 12 lbs total you enter 12 lbs in the total desired grains cell and press the normalize button. The invoked subroutine adds up all the masses, divides by 12 and multiplies each mass by that factor giving 2.4 lbs and 9.6 lbs. Note that this mode is not only viable for use with percentages but with proportions. If you have a recipe that produces 12 P beer and want to produce one with 14 P simply enter 14/12 times the total mass of the existing recipe grains into the desired mass cell and push the normalization button.
@RPIScotty thank you for sharing I'll make time to try it out over the next few weeks.@Silver_Is_Money @ScrewyBrewer @ajdelange
Background: I took my rather involved Brewing Engine and whittled it down to the bare necessities. I made it linear around pH_DI and a1 for simplicity and because a2 and a3 were only measured for a handful of malts. It's not perfect but it's a simple Gen II implementation that can be built upon.
I personally think A.J.'s full sheet is the real way to go but mine has a certain look and format that can be adapted into other sheets.
I say go for it! I purchased a 5 computer license for Office 2016 to share with the family.Now I know I need to get a copy of Microsoft Office!
I say go for it! I purchased a 5 computer license for Office 2016 to share with the family.
Ahh ok. I forgot you aren't using a Windows or a Mac computer.My early enthusiasm was getting the best of me. Unless MS has issued a version of Office that runs on Linux, that is.
Ahh ok. I forgot you aren't using a Windows or a Mac computer.
From what I've read macros are a lot more complicated to code in LibreOffice too.I sure wish that RPIScotty's spreadsheet would work in LibreOffice. I installed the non-linear Solver add-on. But the macros kick out on coding errors. Apparently LibreOffice wasn't legally able to fully duplicate Excel's macro coding. If I was savvy enough I could re-code them, but alas I am not that savvy.
I sure wish that RPIScotty's spreadsheet would work in LibreOffice. I installed the non-linear Solver add-on. But the macros kick out on coding errors. Apparently LibreOffice wasn't legally able to fully duplicate Excel's macro coding. If I was savvy enough I could re-code them, but alas I am not that savvy.
@RPIScotty: Thanks very much for making this public. I've opened the worksheet and followed the instructions to enable Solver as indicated in a blank worksheet. When I then open Brewing Engine Lite, the solve buttons do not generate spreadsheet changes when clicked. In addition the AltF11-Tools-References... menu item is dimmed. Any thoughts on how to get this working? Would love to provide any help to you that I can.
For all those who have previously downloaded BE Lite, please dispose of the copies you currently have and use these:
Mass-based Grain input:
http://www.********************/wp-...2/Brewing-Engine-Lite-v0.81M-UNPROTECTED.xlsm
Percentage-based Grain input:
http://www.********************/wp-...2/Brewing-Engine-Lite-v0.81P-UNPROTECTED.xlsm
There was an error in how the dQmalt function was calculating due to a conversion error from the Metric/English switch.
Thanks for sharing this. I'd like to test it out, but these links aren't working. Do you have an updated link?For all those who have previously downloaded BE Lite, please dispose of the copies you currently have and use these:
Mass-based Grain input:
http://www.********************/wp-...2/Brewing-Engine-Lite-v0.81M-UNPROTECTED.xlsm
Percentage-based Grain input:
http://www.********************/wp-...2/Brewing-Engine-Lite-v0.81P-UNPROTECTED.xlsm
There was an error in how the dQmalt function was calculating due to a conversion error from the Metric/English switch.
Thanks for sharing this. I'd like to test it out, but these links aren't working. Do you have an updated link?
Can't seem to get it to work on Excel for Mac. Probably due to Excel for Mac being essentially a stripped down version of MS Excel.Mass-Based Grain Input:
http://www.********************/wp-...2/Brewing-Engine-Lite-v0.81M-UNPROTECTED.xlsm
Percentage-Based Grain Input:
http://www.********************/wp-...2/Brewing-Engine-Lite-v0.81P-UNPROTECTED.xlsm
Can't seem to get it to work on Excel for Mac. Probably due to Excel for Mac being essentially a stripped down version of MS Excel.
Enter your email address to join: