Announcing the release of 'Mash Made Easy' version 10.90

Homebrew Talk - Beer, Wine, Mead, & Cider Brewing Discussion Forum

Help Support Homebrew Talk:

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Mash Made Easy version 10.90 is now available as a free download on my website in both Standard/US and the fully Metric editions.

Changes since version 10.85:

1) Corrects and improves upon internal BC (Buffering Capacity) computation for malts/grains which have pHDI's of less than 5.40, and for the specific case whereby the user selects a Mash pH target of other than 5.40. Since version 10.80, grist components BC's within MME are (individually and collectively) dynamic and variable with respect to the users selected Mash pH target, and the directional magnitude of this dynamic/variable change in BC for specifically what would nominally be considered "acidic" grist components (with respect to the Mash pH target) was discovered to be formerly incorrect. If you have typically mashed at a targeted 5.40 pH, then you were never impacted by this error, which has now been fixed with version 10.90. If you typically brew light colored beers, you were not formerly likely to have been significantly (if at all) impacted, since such 'acidic' malts/grains are minimized or absent. But if/when you brew darker beers you will significantly benefit from this correction.

2) The IBU's module for the Standard/US version now bases Hop weight inputs upon ounces (as opposed to grams) per a user request for this modification.

NOTE: The BC calculation modification for "acidic" malts/grains (as per #1 above) makes this what I would consider to be a "critical fix" edition, and all users are thereby urged to upgrade from earlier editions whereby to benefit from this critical and significant improvement.
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Within the typical mash pH range the goal of dynamic BC's is to better follow the titration curve whereby to compute the required acidic or basic mEq's so as to hit the Mash pH target. This diagrammed example shows a base malt, with pH increasing from left to right along the 'X' Axis, and mEq's increasing from top to bottom along the 'Y' Axis. The blue line indicates where a static BC would compute mEq's.

Titration.png

If we were instead looking at this chart as if for an acidic malt with a pHDI of 4.9 the 'blue' arrows on the "mEq's of titrant" line (the 'Y' Axis) indicating mEq's of basic titrant to be added (whereby to raise the pH by decreasing the inherent acidity) would be reversed from what is seen here, whereby the mEq's for this case would be increasing from bottom to top.

The difference between the curved line and the blue line within the chart represents the error in presuming linearity. It would be either the case of mEq undershoot or overshoot if linearity was to be presumed. As can be seen, if both the BC was initially computed to a target of pH 5.4, and the users desired mash pH target is 5.4, then linearity predicts the correct mEq's. But for the case of Mashing to a target of 5.6 or 5.2 a presumption of linearity would potentially be significantly off.
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Some of the public domain available malt titration data indicates that 5.7 pH was the target and at least one set of data was generated for malts which were all titrated to pH 7.0. Such data is effectively useless in my opinion. And attempts whereby to 're-nominalize' any to all of such data to pH 5.4 are highly suspect as to accuracy in achieving the intended goal of 5.4 target pH nominalization.
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Notice via the diagram that if the math model was static and linear, an attempt to mash at 5.6 pH would yield a mash at 5.5 pH, and an attempt to mash at 5.2 pH would yield a mash at 5.3 pH.
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
NOTE: I just made a couple minor changes and put them up as new version 10.95 on my website. There is no real urgency to transition to version 10.95 from version 10.90 unless you want to keep up with my latest version.

Changes since version 10.90:
1) The former "Crystal/Carapils" grist component entry drop down selection has been broken out into separate entries under the titles of "Caramel/Crystal" and "Carapils/Carafoam". This change is for the end users grist component entry clarity only. The math modeling behind these malts remains unchanged.
2) The pHDI of Wheat and Rye malt has been reduced slightly from 6.1 to 6.0, and for the flaked versions of same the pHDI has been reduced slightly from 6.6 to 6.5. The effect of this change will be slight.
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
As a side note, I've noticed that some data I received upon request from Briess (about 4-5 years ago) indicates that they believe their White Wheat malt to have a pHDI of 5.89 (call it 5.9), and their Red Wheat malt to have a pHDI of 5.8. Most other (primarily UK and European) sources tend to indicate 6.0 or 6.1 pHDI for wheat malts. In general the Briess pHDI data for many of their offerings (with the exception of the Caramel's) seem to often be a smidge lower in pHDI than for similar category overseas malts. If your malted Wheat is sourced from specifically Briess you may want to enter their 5.8 or 5.9 pHDI's as manual DI-pH overrides within MME. But beware that YMMV when taking this step since off shore (to the USA) maltsters data more generally agrees with the 'default' valuations I've used within MME.

The greatest oddity of them all (as gleaned from admittedly scarce Briess provided data) may be for Briess's "run of the mill" (so to speak) 2-Row Brewers Malt, for which their data clusters around ~5.58 as the average pHDI for this particular malt. 5.58 for a 'standard' 1.8-1.9 Lovibond 2-Row base malt definitely stands out as an oddity which is pronouncedly to the low side among such 1.8L-1.9L base malts in general.
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Of course, now that I've had some time to think about this, when you add the extremes of the deionized water mash pH data for Wheat Malt and divide by 2, the average becomes a pHDI of 5.95.

(5.8 + 6.1)/2 = 5.95

So with that, I've just taken the liberty to make this very slight (and highly averaging) change to MME on my website. No version change was applied....
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
After a couple minor cosmetic relocations intended to aid the end user, plus the elimination of antiquated as useless 'RA' feedback, version 11.00 of MME is now available for download on my website. No computational level changes vs. the previous version 10.95.
 

Komodo

Well-Known Member
Joined
May 3, 2011
Messages
430
Reaction score
93
Location
Bloomington
On opening MME, the colors were all super dark, rendering it unusable. I'm on a Mac with Excel 2008, and assuming this may have something to do with it. I was able to modify the color palette to get it close to what I saw on the website, but not all the cells. There are also a couple instances of text in cells being cut off, can supply screen shots if needed.
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
On opening MME, the colors were all super dark, rendering it unusable. I'm on a Mac with Excel 2008, and assuming this may have something to do with it. I was able to modify the color palette to get it close to what I saw on the website, but not all the cells. There are also a couple instances of text in cells being cut off, can supply screen shots if needed.
The MME spreadsheet is intended only to function properly in LibreOffice running on any OS, and later versions of Excel running under Windows.

I believe there is a LibreOffice version for Mac. LibreOffice is free. I would strongly suggest that you download and install it. My latest build utilized LibreOffice 7.2.2, but any version in the 7's should suffice.
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Last edited:
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
If you can locate and install the font sets listed in the link within my post above then MME may work properly on a Mac using Excel, but I can offer no guarantee. The far and away better bet is to simply install LibreOffice, plus these fonts for it, if for some reason they are not included in the default install. I hope you find a solution that meets your satisfaction.
 

Komodo

Well-Known Member
Joined
May 3, 2011
Messages
430
Reaction score
93
Location
Bloomington
Thanks! I appreciate that. BTW - no complaints here, just wanting to help.
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Thanks! I appreciate that. BTW - no complaints here, just wanting to help.
Sorry if my options did not suffice, but I'm a retiree living on a fixed income. Seeking specific MME related cures for the respected Mac OS platform while it is utilizing a well aged 2008 edition of Excel is beyond my meager means.
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
How to install the DejaVu Sans Condensed font set on a Mac:

In Mac OS X/OS X/macOS and Other OS, There are three ways to install .ttf, .otf, .ttc, .dfont fonts:

A. Double click the file and click the "Install".

B. Open "Font" software under "Application" and choose the font you want to install.

C. Copy font file to "/Library/Fonts" and restart your computer. Early days, some software needs to copy the file to "/System/Library/Fonts".


Edit: The default download on the linked website is for Windows. Click on the button for Mac OS so the check mark moves to Mac before downloading. This button is located just below the orange "Download It Now" button.
 
Last edited:
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
@Komodo, I'm interested in knowing if adding the requisite font set(s) to your 2008 version of Excel for Mac OS solved your issue with the text within MME not fitting properly into the text cells. Or if you decided to simply install LibreOffice, and if that solved the issue. Or if you had to install the appropriate font set(s) even for LibreOffice...
 

Komodo

Well-Known Member
Joined
May 3, 2011
Messages
430
Reaction score
93
Location
Bloomington
@Komodo, I'm interested in knowing if adding the requisite font set(s) to your 2008 version of Excel for Mac OS solved your issue with the text within MME not fitting properly into the text cells. Or if you decided to simply install LibreOffice, and if that solved the issue. Or if you had to install the appropriate font set(s) even for LibreOffice...
The font did indeed fix the text being cut off within cells. Thanks again!
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
The font did indeed fix the text being cut off within cells. Thanks again!
This is encouraging. If anyone is similarly experiencing the text fit issue in Excel for Windows, or even within LibreOffice, the very same font fix should solve the problem.
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
big change from the previous version as far as ph and acids, can you share what changed roughly?
There should be no changes in output from the previous to the current, as only cosmetic changes were made. What previous and current versions are you referring to, and are you using the US or Metric version? Are you doing any copy and paste from one version to another?
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Can you provide snapshots? Very little change has occurred at the output end over multiple updates. Certainly nothing 'large'.

If you are copying cells with underlying formulas or drop down links, and you are not properly accounting for this via using 'Paste Special', you may be dragging formulas or altered 'category selectors' across from one version to another, which can indeed be seriously problematic. It is ALWAYS best to copy, and then use 'Paste Special' while permitting only the criteria for allowing the transmission of "numbers" and "text" to occur.

Once I see snapshots I should be better able to assess where things have gone wrong for you.
 
Last edited:
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Changes from one version to the next are always detailed on my website.
 

bobtheUKbrewer2

Well-Known Member
Joined
Dec 17, 2008
Messages
351
Reaction score
33
Neither of the download links open for me as I can only use .xls files - any chance of saving as .xls and putting a link on here, please ?
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Neither of the download links open for me as I can only use .xls files - any chance of saving as .xls and putting a link on here, please ?
Some functions derived post the older .xls format era would potentially be rendered inoperable upon my saving it in that mode, and it would likely break MME at various junctures to attempt it. Can you use the 'universal' .ods format instead?

Might I suggest that you simply install LibreOffice 7.2.2 instead?
 

bobtheUKbrewer2

Well-Known Member
Joined
Dec 17, 2008
Messages
351
Reaction score
33
thanks Larry. I am 76 and have never heard of .ods or Libre - but I was a metallurgist now I am a brewer so I will go and have a search around.
 

thehaze

Well-Known Member
Joined
Jun 28, 2017
Messages
2,196
Reaction score
989
Location
Iasi, Romania
Hi there. I am trying out Mash Made Easy v.11 for an Imperial Stout. I cannot see the Estimated Batch Colour EBC of the beer, due to the fact that the EBC box is completely black.

Is there anything I can do about it? Thanks.
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Try running MME within a different brand of (or year of) spreadsheet. What are your spreadsheet details/vitals?
 
OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Hi there. I am trying out Mash Made Easy v.11 for an Imperial Stout. I cannot see the Estimated Batch Colour EBC of the beer, due to the fact that the EBC box is completely black.

Is there anything I can do about it? Thanks.
I'd like to reach out to others here for assistance whereby to ask if the final batch color cell is doing both of these two things listed below, and to also ask what type/version of operating system you are running, and which type/version of spreadsheet you are using:
1) Is the Estimated Batch Color cell reflecting a ballpark representation of finished beer color?
2) Within the same cell is the numerical value of this colors SRM or EBC visible?
 

thehaze

Well-Known Member
Joined
Jun 28, 2017
Messages
2,196
Reaction score
989
Location
Iasi, Romania
Windows 10 Home 21H1 / OS build 19043.1348
Microsoft Excel 2102 for Microsoft 365 MSO ( 16.0.13801.21002 ) 64-bit
 

Attachments

OP
Silver_Is_Money

Silver_Is_Money

Larry Sayre, Developer of 'Mash Made Easy'
Joined
Dec 31, 2016
Messages
5,938
Reaction score
1,862
Location
N/E Ohio
Well that's not supposed to happen! Would you consider running it within LibreOffice 7? I'm currently developing and building MME with LibreOffice 7.2.2.
 
Top