Requests for more functionality ---> New Version BrewCipher3.6 spreadsheet, the Spring Training edition, is now up for download. New in Version 3.6: - Displays pre and post boil volumes in gravity rows on the Recipe Tab - First Wort Hopping support - User adjustable pellet/leaf hop bonus/penalty factor - Rager bittering model option - Displays the (Recipe Tab) non-hop boil additions on the BrewDay sheet - Changed the background color of editable cells to a light blue The color was changed due to some user requests. If you hate the new color, let me know. Otherwise, it's helping a couple people who can't otherwise use the sheet. 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 and Rager Formulas… - Limits IBUs to 110 (solubility limit) - Splices new utilization curve to Tinseth and Rager utilization curve above 65 IBUs, to more closely agree with actual vs theoretical IBUs measured - Adds bitterness contributions for post boil hop additions - Hop Utilization Multiplier parameter to fine tune hop utilization to your system - First Wort Hopping- User adjustable Pellet/Leaf Hop Bonuses/Penalties - Single infusion batches with single batch sparge, or mashout and lauter, or Brew-In-A-Bag - Wort Oxygenation Recommendations - Lagering Days Recommendations - Highlights any Gravities, ABVs, IBUs, and SRMs that are not within BJCP style guidlelines - Computes Diastatic Power for the Mash, and warns when grist's DP is marginal or poor - Scales Grain Bill to any desired Original Gravity - Calculates Mash pH and results of acid and Brewing Salt Additions, including Sparge Water acidification - User Storable Water Profile Input (feature works in Excel, but not Apache Open Office) - 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. Supports harvested yeast slurries. - Includes an optional, improved ABV calculation - Inputs for Post Boil/Post Fermentation gravity and volume data, to compute actual mash efficiency, attenuation, and ABV - Converts Refractometer readings to Specific Gravity Values - Choice of U.S. standard measurements or Metric - Choice of Plato or SG gravity measurements - Carbonation Calculations - More user selectable Brewhouse Parameters than you can shake a stick at (but the defaults will work pretty well for most people too) BrewCipher runs in Excel, Apache Open Office, and reportedly in the Google Sheets App. Download it from Google Drive or DropBox.
For those interested, it will also run bug free, and easy to use on your iOS platform, be it your iPhone, or iPad's. Download the free excel app, and this works just fine, with the exception of the scale button, but it's not an issue unless you are trying to take your recipe and scale it to something else. Thanks @VikeMan
Version 3.7 is up. Minor update, but potentially useful for some. Added scaling features for Boil Hops and for Post-Boil Hops, as well a ComboScale button that allows users to target specific post boil OG and IBUs at the same time. (Instead of having to iterate back and forth between the interrelated grains and hops manually, the ComboScale macro does it automatically.) Note: The scaling features work in MS Excel and MS Open Office, but not under the Google Sheets App, or the iOS Excel App. (Sorry, Excel macros just don't work in those Apps. But everything else does, and the macros are not necessary to use the sheet. It's just less convenient without them.) Also added a small number of ingredients. Download V3.7 from Google Drive or DropBox.
