BrewCipher V3.2 spreadsheet is now up for download. (V3.1 will also be up for while, in case there are any issues with V3.2.) New in Version 3.2: - Optional alternative (more accurate) ABV calculation - Inputs for actual (measured) OG, FG, and Volume, returning actual (not just predicted/assumed) Apparent Attenuation, ABV, and Mash Efficiency - Hot Liquor Tank deadspace loss parameters - Additional alternative file format for maximum compatibility with Apache OpenOffice. (Download the .xlsm version if using OO.) - Refractometer calculations.* *Incorporated the great Sean Terrill's refractometer calculations, with an additional feature. Users of Sean's calculator know there's a thing called the Wort Correction Factor (WCF). The WCF accounts for that fact that Beer Wort contains several types of sugars, each with its own refractive index. (Refractometers are calibrated for sucrose only.) Sean's default WCF is 1.04, which he has found to work well with test batches, whose attenuation averaged 81%. You can change the 1.04 to something lower for more attenuable worts, or something higher for less attenuable worts, but the dilemma is what value to use. BrewCipher's implementation of Sean's formulae leverages the fact that BrewCipher has already calculated an expected attenuation, and scales the WCF accordingly. This WCF scaling result is (right now) purely theoretical. But for those who take both refractometer and hydrometer readings, it will be interesting to find out how well the automatic WCF scaling works as compared to the 1.04 default. Of course, you can also use 1.04 or any value you want. 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 - Calculates ABV with both traditional and improved formulae - Highlights any Gravities, ABVs, IBUs, and SRMs that are not within BJCP style guidelines - 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 Repitched Yeast Slurries - Corrects refractometer readings to calculate OG, FG, and ABV using Sean Terrill's formulae, adding a computed suggested Wort Correction Factor. https://drive.google.com/folderview...jMC00YmM5LTgzN2UtYmNhYzk0ZTg0YWNm&usp=sharing As always, let me know if you see anything odd. And keep the ideas coming. Enjoy.
I love the refractometer idea! May just finally break down and start using it in place of Brew Toad... I just like everything backed up on the cloud... Could you make this an online Numbers / Google spreadsheet? Joking. Awesome as always.
I had been using Hopville, got absorbed into BrewToad when they bought out Hopville, then switched to VikeMan's spreadsheet - it was a hugely beneficial change and the calculations in his spreadsheet are far more accurate. Aside from having to add a few hops, grains, and yeasts here and there, it has really helped me dial in my process and get a better handle on managing recipes. And that's not even mentioning the awesome features that BrewToad doesn't even touch like water chemistry, mash PH, brewhouse profile, etc. The convenience of the cloud is nice, but I would really recommend giving the spreadsheet a spin.
Quite the tour-de-force; nice job! A question: where does the 25 mil/mL minimum pitch rate for starters come from? Just curious. Thanks.
Mostly personal preference. It equates to one fresh pack/vial into 4 liters of starter wort. Above that, marginal utility really suffers (based on some curves I've seen), and it seems (to me) to be crazy large to go above that (volume) without stepping. I think Mr. Malty's built in minimum (without moving the slider) is 20 mil/mL, and Yeastcalc recommended (but didn't enforce) 25 mil/mL minimum. In any event, the parameter is user adjustable. I believe @Xul has used it with Libre Office.
As @VikeMan said, I have used it with LibreOffice for several batches now and I have yet to notice any problems or incompatibilities. He mentioned a few issues with OpenOffice, but they were features that I either hadn't used or had no problem with in LibreOffice. If you do run into any problems, give the new .xlsm format a shot.
