BrewCipher 3.3

BrewCipher 3.3 spreadsheet is now up for download. There are two links at the bottom of this post. The first is for the .xls version (for excel users). The second is .xlsm which is more compatible with Apache Open Office. I'm linking them separately due to a hopefully temporary google docs/drive bug that makes directory displays not work correctly for users who are not logged in. If downloading the .xls version, make sure to select File --> Download from the menu.

New in Version 3.3:
- Added a Metric/U.S. standard selection option
- Added a Plato/Specific Gravity selection option
- Added a Hop Utilization Multiplier parameter to the modified Tinseth formula. If you measure your actual IBUs and consistently get results higher or lower than the model predicts, you can set this multiplier to dial-in the model.
- More Extracts in ingredients to better support Extract Brewers
- Enhanced Brew-In-A-Bag support...if BIAB is selected on Brewhouse Parameters tab, it forces the total water volume to the initial mash infusion (without having to fiddle with the water to grain ratio input).
- Tweaked Hot Liquor Tank deadspace parameters/processing so that the water (water chem) tab can see the whole volume (including deadspace loss) for Sparge Acidification calculations. (If you have been using the HLT deadspace parameters, please read the comments with the new, modified ones.)

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
- Hop Utilization Multiplier parameter to fine tune hop utilization to your system ​

- 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
- 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 Specific Gravity Values
- Choice of U.S. standard measurements or Metric
- Choice of Plato or SG gravity measurements

BrewCipher_V3.3.xls
BrewCipher_V3.3.xlsm