Announcing 'Mash Made Easy', a mash pH adjustment assistant

[Silver_Is_Money]

The IBU sheet fixes are getting to be a bit of a nightmare. I just killed another bug and uploaded MME version 5.81 to my website.

 

[Silver_Is_Money]

Announcing the release of 'Mash Made Easy' version 5.90 in both the Standard and Metric formats.

A major change has been made to the "Base Malt DI_pH" drop down selector switch to make it far easier and more intuitive to understand, and also to remove base malts from the realm of DI_pH's which vary with color, and as opposed to going off of color, assign "Base" malt DI_pH directly from the sub-category selected via the "drop down" cell seen in the lower right hand corner (where the DI_pH will be seen in conjunction with the base malt sub-category of your choosing).

Added a "Final Gravity" calculation on the "IBU Calculator" sheet. Also added Alcohol By Volume (ABV).

Since this is a major revision issue, all users are recommended to transition to version 5.90.

As always, the download is free, the spreadsheet is both free and complete, and it can be accessed at the web link seen below.

 

[pers]

A major change has been made to the "Base Malt DI_pH" drop down selector switch to make it far easier and more intuitive to understand, and also to remove base malts from the realm of DI_pH's which vary with color, and as opposed to going off of color, assign "Base" malt DI_pH directly from the sub-category selected via the "drop down" cell seen in the lower right hand corner (where the DI_pH will be seen in conjunction with the base malt sub-category of your choosing).

What should this selection be if your recipe contains multiple base malts? I'm doing a 10lb/1lb maris otter/vienna mix so I'm guessing use M. Otter, G. Promise, 5.75. But what about a recipe that had a 50/50 mix of maris otter/American 2-row?

 

[Silver_Is_Money]

But what about a recipe that had a 50/50 mix of maris otter/American 2-row?

Either choose one of the "drop down" DI_pH selections that lies between the two, or alternately (for more precision) you can manually enter a DI_pH for one of them, or for each of them, via the manual DI_pH override option.

For example:

If the drop down selector is set for 2-Row Brewers, then manually enter 5.75 for the Maris Otter.

Or if the drop down selector is set for Maris Otter, then manually enter 5.60 for the 2-Row Brewers.

The same could also be done for the case of your mix of Vienna and Maris Otter.

Anytime that a (non-zero) value is present within the manual override column, the manually entered DI_pH value takes precedence.

 

[Silver_Is_Money]

The base malt DI_pH drop down selector generalizes base malt categories/names as to their anticipated DI_pH. Your individual lot of any given base malt may vary noticeably from such a "canned" generalization, and may thereby require that a "drop down" selection with a lower or higher DI_pH is chosen in order to dial in MME more effectively. Or with experience you may fine tune MME's mash pH predictions to an even greater degree via utilizing the DI_pH manual override option (which is openly available to override for all malt classes, and is not restricted to only base malts).

Other manual overrides exist for:
-------------------------------------
1) The strength of your individual lot of acid malt
2) The downward pH shift you experience for a given level of mineralization. (some say 50-60% and some say 100%, or between)
3) The grist buffering value
4) The percentage of the computed output which is derived from the default logarithm based output, and the percentage which is based upon a linear calculation.

All of this is intended to permit MME to have great flexibility with regard to dialing it in, whereby to match your measured reality. I would advise that you alter these only one at a time, and only in small increments (or that you simply leave them as they were initially set when you first downloaded the spreadsheet). The object is always to make MME conform to measurement, and never to presume that your hard and factual measurement is questionable and that your reality must somehow have to be twisted in order to make it conform to MME.

 

[Silver_Is_Money]

Announcing the release of 'Mash Made Easy' version 6.00 in both the standard and metric formats.

This is a major update with significant new features, and all existing users should replace any previous edition with this one!

Major changes include:

1) Adds a radically new 'cut and paste' mineral profile capability which totally eliminates the typical "hunt and peck" mineralization for those who both desire the aid of mineralization profiles and build their brewing water via adding minerals to water which is based upon either distilled or RO. The use of these mineral profiles is totally optional. See the "Mineralization Assistant" sheet for details and simple instructions.

2) Adds Baking Soda (Sodium Bicarbonate, NaHCO3) and Slaked Lime (Calcium Hydroxide, Ca(OH)2) to the standard selection of user addable minerals, recognizing the end users occasional need to introduce either sodium ions, calcium ions, or alkalinity via the addition of these two minerals, either alone or in combination.

(both of the above features were added in direct response to end user requests)

As always, Mash Made Easy is free and complete. Find it at the web link seen below.

 

[Silver_Is_Money]

Announcing the release of 'Mash Made Easy' version 6.10 in both the standard and metric formats.

Changes include:

1) Adds a priming calculator with (drop-down switchable) "conservative" and "aggressive" sugar addition calculations reminiscent of the differing outputs seen for two quite popular online priming calculators.

2) Adds a color converter calculator which permits the user to determine color equivalence across Lovibond, SRM, and EBC.

As always, Mash Made Easy is free and complete. Find it at the web link seen below.

 

[Silver_Is_Money]

Announcing the release of 'Mash Made Easy' version 6.20 in both the standard and metric formats.

Changes include:

1) Adds two new acids for use in either (or both) acidifying the mash and acidifying sparge water.
a) CRS (also known as AMS)
b) Citric Acid

2) Fixes a situational error in sparge water acidification which first appeared in version 6.00.

It is strongly recommended to upgrade to version 6.20, even if only due to change/fix #2 above.

As always, 'Mash Made Easy' is free and complete. Find it at the web link seen below.

 

[Silver_Is_Money]

Version 6.25 is up. Correcting OG and remaining boil volume issues found on the IBU Calculator sheet/page.

 

[Silver_Is_Money]

Version 6.30 is now up on my website.

Fixes an error in IBU calculations which significantly impacts predicted IBU determination for high OG beers, but also has a degree of impact upon IBU determination for more normal gravity beers.

 

[Silver_Is_Money]

Announcing the release of 'Mash Made Easy' version 6.40 in both the standard and metric formats.

Major change:

Greatly simplifies the operation of the "IBU Calculator" worksheet by replacing cumbersome and confusing "gravity points" by an entry of the batches anticipated original gravity (O.G.) reading. Reformatted the data entry location on the IBU Calculator page for greater ease of operation also.

As always, the 'MME' spreadsheet is completely free and fully functional, and can be downloaded at the website link listed below.

 

[Bigdaddyale]

Announcing the release of 'Mash Made Easy' version 6.40 in both the standard and metric formats.


As always, the 'MME' spreadsheet is completely free and fully functional, and can be downloaded at the website link listed below.

I can't seem to find the " website link listed below"

 

[Big Monk]

I can't seem to find the " website link listed below"

In his signature.

 

[Bigdaddyale]

In his signature.

ahh
I must have turned off that feature and forgot about it because I can't see signatures

 

[Big Monk]

ahh
I must have turned off that feature and forgot about it because I can't see signatures

Are you in the app? Sign in traditionally.

 

[Bigdaddyale]

Are you in the app? Sign in traditionally.

I fixed it. I changed the settings on my profile page. At some point, I must have disabled the viewing of signatures.

 

[Silver_Is_Money]

Mash Made Easy version 6.45 is now up on my website. A minor change with respect to internal acid malt addition calculation leads to minor output difference for same. No other changes from version 6.40.

 

[Big Monk]

Just spitballing here:

For matching volumes and total grain amount, I get the following deltas WRT The Brewing Engine and MME:

Strike = 21.43 l
Grain = 5.44 kg

99.25% Euro Pils (5.80 pH DI)/0.75% Sauermalz w/ pHz = 5.70:

TBE = 40.8g Sauermalz
MME = 49.02g Sauermalz

99% Euro Pils (5.80 pH DI)/1% Sauermalz w/ pHz = 5.675:

TBE = 54.4g Sauermalz
MME = 63.69g Sauermalz

97% Euro Pils (5.80 pH DI)/3% Sauermalz w/ pHz = 5.453:

TBE = 163.2g Sauermalz
MME = 169.88g Sauermalz

96% Euro Pils (5.80 pH DI)/4% Sauermalz w/ pHz = 5.175:

TBE = 326.4g Sauermalz
MME = 305.99g Sauermalz

This is assuming 3% Lactic Acid content of Sauermalz in your sheet which seems to be stock. Obviously changing that changes the values.

 

[Silver_Is_Money]

Just spitballing here:

I just applied this same exercise to MpH 3.0 (modified only to permit the base malt to reach DIpH 5.80) and I was shocked by how much additional acid malt it computed for each targeted pHz setting vs either your spreadsheet or mine. The differences I witnessed make us appear very close overall by comparison.

I wonder how the other current/popular mash pH assistant software choices perform with this comparison?

 

[Big Monk]

I just applied this same exercise to MpH 3.0 (modified only to permit the base malt to reach DIpH 5.80) and I was shocked by how much additional acid malt it computed for each targeted pHz setting vs either your spreadsheet or mine. The differences I witnessed make us appear very close overall by comparison.

I wonder how the other current/popular mash pH assistant software choices perform with this comparison?

The only issue I have what what you've done is that changing the acid % value changes the values considerably from my estimations. That's not to say that my estimation is the only one or even the best.

For instance:

Strike = 21.43 l
Grain = 5.44 kg

_________________________________________________________________
99.25% Euro Pils (5.80 pH DI)/0.75% Sauermalz w/ pHz = 5.70:

TBE = 40.8g Sauermalz
MME (3% Acid) = 49.02g Sauermalz
(Δ (%) by weight: 16.77%)

99% Euro Pils (5.80 pH DI)/1% Sauermalz w/ pHz = 5.675:

TBE = 54.4g Sauermalz
MME (3% Acid) = 63.69g Sauermalz
(Δ (%) by weight: 14.59%)

97% Euro Pils (5.80 pH DI)/3% Sauermalz w/ pHz = 5.453:

TBE = 163.2g Sauermalz
MME (3% Acid) = 169.88g Sauermalz
(Δ (%) by weight: 3.93%)

96% Euro Pils (5.80 pH DI)/4% Sauermalz w/ pHz = 5.175:

TBE = 326.4g Sauermalz
MME (3% Acid) = 305.99g Sauermalz
(Δ (%) by weight: -6.67%)

_________________________________________________________________
99.25% Euro Pils (5.80 pH DI)/0.75% Sauermalz w/ pHz = 5.70:

TBE = 40.8g Sauermalz
MME (2% Acid) = 73.53g Sauermalz
(Δ (%) by weight: 44.51%)

99% Euro Pils (5.80 pH DI)/1% Sauermalz w/ pHz = 5.675:

TBE = 54.4g Sauermalz
MME (2% Acid) = 91.87g Sauermalz
(Δ (%) by weight: 40.79%)

97% Euro Pils (5.80 pH DI)/3% Sauermalz w/ pHz = 5.453:

TBE = 163.2g Sauermalz
MME (2% Acid) = 254.82g Sauermalz
(Δ (%) by weight: 35.95%)

96% Euro Pils (5.80 pH DI)/4% Sauermalz w/ pHz = 5.175:

TBE = 326.4g Sauermalz
MME (2% Acid) = 458.98g Sauermalz
(Δ (%) by weight: 28.89%)

_________________________________________________________________
99.25% Euro Pils (5.80 pH DI)/0.75% Sauermalz w/ pHz = 5.70:

TBE = 40.8g Sauermalz
MME (4% Acid) = 36.76g Sauermalz
(Δ (%) by weight: -10.99%)

99% Euro Pils (5.80 pH DI)/1% Sauermalz w/ pHz = 5.675:

TBE = 54.4g Sauermalz
MME (4% Acid) = 45.94g Sauermalz
(Δ (%) by weight: -18.42%)

97% Euro Pils (5.80 pH DI)/3% Sauermalz w/ pHz = 5.453:

TBE = 163.2g Sauermalz
MME (4% Acid) = 127.41g Sauermalz
(Δ (%) by weight: -28.09%)

96% Euro Pils (5.80 pH DI)/4% Sauermalz w/ pHz = 5.175:

TBE = 326.4g Sauermalz
MME (4% Acid) = 229.49g Sauermalz
(Δ (%) by weight: -42.23%)

 

[Silver_Is_Money]

I find it a bit odd that you chose to radically vary the strength of the acid malt for MME while not also doing the very same thing within your spreadsheet. Since the default for MME is 3% (as equivalence to lactic acid), and end users would be advised to only vary this strength value very cautiously and minimally by which to better dial in a specific lot of (likely atypical) acid malt (as opposed to radically making changes as you have done), what relevance is there in your doing this?

Additionally, if you recall, I once had the permitted range of acid malt strength adjustments allowable to be made by the end user locked in at a span that was much narrower than at present (2.4% to 3.5% as I recall), but upon your direct urging I opened up the span of permitted user adjustment.

 

[Big Monk]

I find it a bit odd that you chose to radically vary the strength of the acid malt for MME while not also doing the very same thing within your spreadsheet.

It wasn't a choice. I model Sauermalz as malt. I don't have a reliance on Acid % so I have no mechanism in which to alter it.

Additionally, if you recall, I once had the permitted range of acid malt strength adjustments allowable to be made by the end user locked in at a span that was much narrower than at present (2.4% to 3.5% as I recall), but upon your direct urging I opened up the span of permitted user adjustment.

Right. My next suggestion would be to set the Acid % at a static value if you plan on using this new correction. When I made my suggestion to you previously, it was in order to give people options for manually doing what you did with the correction factor.

I'm still not entirely sold your correction works in reality but in order to eliminate any error, i would lock the range down again or just use 3%.

 

[Silver_Is_Money]

"Mash Made Easy' version 6.50 is now up on my website in the standard and metric formats.

Changes include:

1) Former malt category (drop down) "Munich/Specialty" is now called "Munich / Biscuit".
2) New malt category "Melanoidin / Honey (malt)" has been introduced to account for these specific malts greater overall acidity with respect to their Lovibond/EBC color.
3) Base malt DI_pH modifiers (drop down selector) have been altered/simplified.
4) The permitted acid malt strength modification range has been tightened (in accord with the above conversation/comparison).

This should be seen as a major upgrade, and all users are urged to transition to this new version.

NOTE: If you copy and paste, be sure to select a drop down in column 'B' for any malts impacted by changes #1 and #2 above. If you do not see the downstream columns for a grist components DI_pH and post Ca++/Mg++ addition pH properly populated with numerical pH values, the solution to this will be to re-select a new/altered malt category via drop down in column 'B' of the same row. Munich, Melanoidin, and Specialty will all require this adjustment (only) if you copy/paste recipes. If you do not copy/paste this will be a non-issue for you.

 

[Silver_Is_Money]

Version 6.51 with the following minor revisions is now up on my website.

1) Adds a Base Malt DI_pH "drop down" selection option titled "Generic 2-Row", with a DI mash pH value of 5.60.
2) Reverts the default Pilsner base malt DI mash pH value back to previous 5.80 (from 5.82).
3) Neatens up the "IBU Calculator" interface

There is no urgent need to upgrade to this minor revision issue unless you want to keep up with the very latest modifications.

 

[Silver_Is_Money]

Recommended settings changes to be made for 'Mash Made Easy' by all users:

1) Change the grist buffer value from 0.67 to 0.60
2) Change the Kolbach % from 100% to 70%

The current version 6.51 as revised at 8:45 AM EST this morning on my website has these two settings changes made, and also corrected a typo error which I discovered. The easiest way to assure that your copy has the most up to date default settings is to simply download a revised copy. If you had downloaded 6.51 earlier than 8:45 AM today, please either make the two requested revisions or download a fresh copy.

 

[darynsd]

Hi Larry- Is the liquid CaCl2 calculation on MME 6.50 working properly? I'm not sure I'm smart enough to work out the chloride ion contribution myself, but I have to divide the volume of liquid CaCl2 by ~10 to get the same chloride concentration in the finished water as Bru'n Water calculates. The other mineral levels are pretty similar between the two. Of course, it could just be pilot error on my part...

 

[Silver_Is_Money]

Hi Larry- Is the liquid CaCl2 calculation on MME 6.50 working properly? I'm not sure I'm smart enough to work out the chloride ion contribution myself, but I have to divide the volume of liquid CaCl2 by ~10 to get the same chloride concentration in the finished water as Bru'n Water calculates. The other mineral levels are pretty similar between the two. Of course, it could just be pilot error on my part...

I just checked MME and it is giving correct calcium and chloride ppm results for liquid CaCl2 solutions. BW entry is per gallon, and MME entry is per total volume of mash water, so perhaps that may be where the difference is coming from.

 

[darynsd]

I may be a bit thick here, so help me out. I have a solution of CaCl2 with a SG of 1.100 or 10.9% w/w. BW says I should add 5.8 gm total of this liquid to my mash water. MME uses volume measurement for liquid. Based on the equation AJ provided in a sticky, a solution with this SG should weigh 0.1245 gm/ml so 5.8/.1245= 46.6ml.

I enter this volume on the MME mash pH tab and then look at the Calcium Chloride selector tab. For liquid type with SG of 1.100, it confirms the gm/ml as 0.12 but says the "equivalent Anhydrous" is 5.80gm. Surely this is not correct, right? It's actually the weight of the 10.9% w/w liquid. It also calculates the Ca++ to be 95.16 and Cl- to be 168.17ppm.

If I change the type to be prills/crystal at 100% concentration and revise the amount on the mash pH tab to be 5.8gm, the Ca++ is 95.03ppm and Cl- is 168.18ppm. If I change BW to use Anhydrous, it gives similar concentrations -so I'm thinking MME really does think 46.6ml of this dilute solution is the equivalent of 5.8gm of Anhydrous CaCL2?

 

[Silver_Is_Money]

Actually MME calculates 46.6 mL of SG= 1.1000 solution to be internally 0.1245 grams/mL, though it only displays the rounded 0.12.

46.6 mL x .1245 g/mL= 5.8 g.

This should be fully correct. We apparently need @ajdelange to confirm if 46.6 mL of SG= 1.1000 calcium chloride solution delivers 5.8 grams of calcium chloride as the anhydride. If it does, then MME is correct. If not I will need to make an adjustment.

 

[Silver_Is_Money]

Try this calculator:
http://www.endmemo.com/chem/chemsolution.php

Set it for anhydrous CaCl2, with MW = 110.984 g/L
Then enter 5.8 anhydrous grams and 46.6 mL while leaving the molar concentration field empty, and hit calculate.

Molarity = 1.1214546 is the result

We know that 110.984 grams made up to 1 liter = 1.000 Molarity, so:

1.121456 molarity x 110.984 grams/mole = 124.464 grams of anhydrous calcium chloride added to 1 liter

124.464 g. / 1000 mL = .124464 grams/mL

.124464 g/mL x 46.6 mL = 5.8000 grams of pure anhydrous calcium chloride

Unless I'm still missing something, this online calculator seems to confirm that MME is on the money correct.