BrewCipher V3.1 spreadsheet is now up for download. (V3.0 will also be up for while, in case there are any issues with V3.1.) New in Version 3.1: - Repitched Yeast Slurry calculations - Sparge Water Acidification, courtesy of utahbeerdude's model - Added column Displaying grain Percentages (of total grist) - Added Timed Addition (for non-hop ingredients) Area to Menu Tab - Freeform NotePad page - Generic Example Water Profiles Feature Recap... - Predicts attenuation based not only on yeast strain, but also on mash conditions and grain bill composition - Understands that simple sugars are 100% fermentable, and that they are not subject to mash efficiency or yeast strain factors - Understands that some gravity contributors are not fermentable at all - Accounts explicitly for wort and water losses, and adjusts total water (and related calculations) accordingly - Uses a correct Tinseth formula with Avg Boil Gravity in the 'bigness' factor rather than the pre-boil OG (which is both popular and wrong) - Incorporates optional Modified Tinseth Formula… - Limits IBUs to 110 (solubility limit) - Splices new utilization curve to Tinseth utilization curve above 65 IBUs, to more closely agree with actual vs theoretical IBUs measured - Adds bitterness contributions for post boil hop additions, modeled and extrapolated from the work of Mark G. Malowicki - Single infusion batches with single batch sparge, or mashout and lauter - Wort Oxygenation Recommendations - Lagering Days Recommendations - Highlights any Gravities, ABVs, IBUs, and SRMs that are not within BJCP style guidleines - Computes Diastatic Power for the Mash, and warns when the grist's DP is marginal or poor - Scales Grain Bill to any desired Original Gravity - Calculates Mash pH, results of Brewing Salt Additions, and Sparge Water Acidification. Includes example water profiles. - Predicts Mash Efficiency based on known Efficiency and change in grain weight and/or sparge to no-sparge or vice versa - Automatically computes Yeast Starter Volumes, including stepped starters. Also supports Repitches Yeast Slurries https://drive.google.com/folderview...jMC00YmM5LTgzN2UtYmNhYzk0ZTg0YWNm&usp=sharing Let me know if you see anything odd. Enjoy.
Thanks. Updates are likely to be fewer and farther between from here on out. One trick... enter your ingredient lookup additions in a different color font. Then you can easily sort by color for an easy copy and paste into the next version, so you'll have any new standard ingredients plus the ones you have accumulated.
Very good suggestion, I found myself copy and pasting your ingredients and my old ingredients into another workbook and using a vlookup formula to show what was and wasnt the same. Definitely going to use the color scheme from now on.
Vike - thoughts on the typical ABV calculator 131.25*(OG-FG) vs Kai's / Daniels formula ABV =(76.08 * (og-fg) / (1.775-og)) * (fg / 0.794). Just read this yesterday and the differences were greater than I would have imagined. No idea which to trust.
I've been using te brewers friend calculator with the more complicated formula for higher gravity beers.
I think the latter formula is technically more accurate over a wider range of ABVs. The simpler one is limited, and is the reason why some people tinker with the 131.25 constant in order to get better accuracy in the ranges where they tend to brew. I have thought about putting the more complex formula in BrewCipher. The reason I haven't is that it does give such a different answer in higher ABV ranges, and people have dialed in their expectations to the results of the simpler formula. But now that you mention it, I see no reason not to include both formulas, and get two answers... 'traditional' and 'improved.' I think I'll do that. Thanks!
Coming Soon... - Optional alternative (more accurate) ABV calculation - Post boil/fermentation actual OG, FG, Volume inputs, to Calculate actual (not just predicted/assumed) Apparent Attenuation, ABV, and Mash Efficiency - Hot Liquor Tank deadspace loss parameters - Refractometer calculations (with a twist) - Additional alternative file format for maximum compatibility with Apache OpenOffice I will probably hang the new version at the end of the month.
Anything specific that people have noticed not working? I've been using it with LibreOffice 4.0.2.2 and haven't noticed any issues, but now I'm curious if there's something I've just overlooked.
I use LibreOffice as well and have occasionally had the sheet hangup and had to close and reopen, but have not noticed other issues.
Not sure about LibreOffice. There's an issue with Appache OpenOffice where's its importer get's confused when it brings in an .xls document that has cells containing data validation. It seems to reproduce that validation in cells that aren't supposed to have it. The solution was to save the excel sheet in .xlsm format, which seems to do the trick. Apparently the .xls format (needed for backward compatibility with older versions of excel) makes the importer treat the file differently than the .xlsm version. Anyway, I'll be hanging both files. Another issue is with Macros. BrewCipher has a macro for scaling the grain bill up/down to hit a desired OG. If you enable macros in OO and run the macro, it errors, because the macro contains a method (SendKeys) that OO doesn't support. OO users can certainly use BrewCipher without using the macro...it's just a convenience feature. But I have an idea about how to work around this...not tested yet though.
