BrewCipher 6

BrewCipher 6.0 spreadsheet, Hoppy Holihaze Edition, is now up for download.

New in Version 6.0:

- Updated MpH Water Models
-------- courtesy of utahbeerdude, from soon to be released MpH v4
-------- uses malt(ster) specific pH data for many malts/grains
-------- more accurate than other models, per real life mash data

- Fruit Addition Calculator
-------- predicts effective combined OG, FG, Attenuation, and ABV
-------- doesn't ignore the water content of the particular fruit/puree/juice (just sayin')

- pH Target Picker Tool
-------- helps you decide the mash pH you want, based on desired finished beer characteristics


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 curves 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
- First Wort Hopping
- User adjustable Pellet/Leaf/Cryo/CO2 Extract 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 guidelines, for 2008 and 2015 guidelines
- Computes Diastatic Power for the Mash, and warns when grist's DP is marginal or poor
- Scales Grain Bill to any desired Original Gravity
- Scales Hop Bills to any desired IBUs
- 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, alternate 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
- Carbonation Calculations
- Hydrometer Specify Gravity Temperature Correction
- Mash Tun Overload and Required Temperature Exceeding Boiling Warnings
- Kegging Beer Line Length calculations
- CO2 Hop Extract and Cryo Hop Support
- pH Target Picker Tool
- Fruit Additions
- 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, Google Sheets App, and the iOS Excel App. Download it from -> Google Drive <- or -> DropBox <-. Go ahead. Don't cost nothin'.

 

A quick word about the updated pH model... because it uses malt(ster) specific pH data for many malts/grains, it's important to not change the names of any of the pre-loaded malts/grains on the grainlookup tab. Go ahead and add grains and sort the rows (including the pre-loaded ones) to your heart's content, but leave the original names unchanged. If changed, more generic/default data for the grain type will be used (similar to other models). So it won't be disastrous, but it's better not to do it.

There are also notes to this effect on the grainlookup tab.

 

The reason it increases the pH when you add it to your grain bill is that you're adding more "base malt" (ignoring the lactic acid component for a moment). Then, when you add it in the acid section of the water tab, the acid component is accounted for.

I suspect a lot of people don't bother adding the acid malt into the grain bill section on the recipe tab, because they view acid malt as an acid addition, rather than a grain bill recipe thing. Which from a pH perspective is pretty much okay, because its (base malt) impact there will be very small. But pH aside, a reason you might want to also add it in the grain bill is that its gravity, color, and wort absorption contributions will also be counted. From a grain bill perspective, a couple ounces won't really matter much one way or the other, but larger additions might. So, my recommendation would be to go ahead and include it in both places.

 

@ECCS, I'm not sure whose attention you were trying to get, but I don't think 450North is a BA handle.

 

Heh, thanks. I hadn't heard that story. It doesn't surprise me...some pros miscalculate fruit OG/ABV contributions all the time. But the exploding cans thing (different beer) is ridiculous...adding sugars at packaging without knowing what kind of CO2 levels could ensue. Hopefully these guys get their shit together.

 

Yes. It assumes all the sugars in the fruit will ferment.

I assume you mean choosing "water" from the fruit dropdown. I threw that in so people could also use the tab as a dilution calculator, e.g. what happens to a recipe's OG/FG/ABV if you add "x" amount of water. You might use it if you're doing high gravity brewing. Or suppose you end up with a wort with a higher OG than expected and want to dilute it down to a more reasonable level. In this case, you'd play with the volume to add until you hit the desired OG. Stuff like that.

 

My foggy quasi-memory, or perhaps a freshly constructed rationalization, is that I originally set the minimum valid input to 100K in order to prevent unintended user screwups. But this was before Kveik strains became available. On the next incremental release, I'll change the minimum to 1 Cell/ml/Degree P. Thanks for the catch.

 

Sorry, no.

 

Any that you're particulary interested in?