Coldbreak Brewing HERMS Giveaway!

HomeBrewSupply AMCYL Brew Kettle Giveaway!


Home Brew Forums > Home Brewing Beer > Brew Science > Problem with Bru'n Water and EZ Water spreadsheets
Reply
 
Thread Tools
Old 07-02-2012, 04:29 PM   #1
pensphreak
HBT_SUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2011
Location: Anaheim, CA
Posts: 98
Liked 2 Times on 2 Posts
Likes Given: 1

Default Problem with Bru'n Water and EZ Water spreadsheets

I put in (what I think) are the same values for an upcoming Oktoberfest that I'm brewing and the output from both of these spreadsheets is pretty different (5.49 vs 5.2 pH). Can someone take a look at my spreadsheets and tell me what I'm doing wrong?

Background: I'm brewing with 100% RO water and normally I just follow the primer (1g CaCL2/gal of water). I batch sparge with (in this case) 4.88gal of mash water and 5.69gal of sparge water.

Code:
Amt 	Name
5.00 g 	Calcium Chloride
5 lbs 	Pilsner (2 Row) Ger (2.0 SRM)
4 lbs 	Munich Malt (9.0 SRM)
3 lbs 	Vienna Malt (3.5 SRM)
1 lbs 	Caramunich Malt (56.0 SRM)
Here's my recipe: http://pensphreak.com/homebrew/Oktoberfest%202.0.html
Here's the 2 spreadsheets: Bru'n Water and EZ Water


Click image for larger version

Name:	2012-07-02_092332.jpg
Views:	479
Size:	22.8 KB
ID:	67116   Click image for larger version

Name:	2012-07-02_092301.jpg
Views:	447
Size:	31.7 KB
ID:	67117  
pensphreak is offline
 
Reply With Quote
Old 07-02-2012, 05:04 PM   #2
DSmith
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2011
Location: Robbinsdale, MN
Posts: 793
Liked 72 Times on 60 Posts
Likes Given: 12

Default

Your using the tools correctly. Been through at least 12 mashes looking at both calculators. For me, brewing with 100% RO water, EZ Water has been closer to what I measure with a calibrated pH meter with 0.01 pH resolution. No spreadsheet has been consistently accurate and it depends on the malt/brand used.

I advocate for a very small (100 gram total) mash with your brewing water to test for mash pH and change your acidification as needed. It can be done while heating mash water and have caught potential mash pH issues before committing to acidifying the mash. It takes a fine gram scale, coffee grinder, small thermos & calibrated pH meter. Testing the mash pH becomes a formality rather than a measurement that you need to react to with some corrective measure.


DSmith is offline
 
Reply With Quote
Old 07-02-2012, 06:14 PM   #3
mabrungard
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
mabrungard's Avatar
Recipes 
 
Join Date: Feb 2011
Location: Carmel, IN
Posts: 3,345
Liked 340 Times on 284 Posts
Likes Given: 30

Default

That RO water has little alkalinity and the CaCl addition pushes RA down pretty low. With the color of that grist, I'm not surprised with the prediction of a low mash pH. I hope you have a pH meter and can report back here with your result. From my experience, its much more likely that the mash pH is going to be low than high.
__________________
Martin B
Carmel, IN
BJCP National
Foam Blowers of Indiana (FBI)

Brewing Water Information at:
https://sites.google.com/site/brunwater/

Like Bru'n Water on Facebook for occasional discussions on brewing water and Bru'n Water
https://www.facebook.com/pages/Brun-...?ref=bookmarks
mabrungard is offline
 
Reply With Quote
Old 07-02-2012, 06:29 PM   #4
diegobonatto
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
diegobonatto's Avatar
Recipes 
 
Join Date: Feb 2011
Location: Porto Alegre, Rio Grande do Sul
Posts: 99
Liked 5 Times on 5 Posts

Default

Did you converted the color unit for Bru'n Water? As you showed in the Bru'n Water spreadsheet, you put the malt color in SRM (EBC) units instead off Lovibond. You can convert the units using the formula:
SRM=1.3546*Lovibond-0.76
diegobonatto is offline
 
Reply With Quote
Old 07-02-2012, 07:40 PM   #5
pensphreak
HBT_SUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2011
Location: Anaheim, CA
Posts: 98
Liked 2 Times on 2 Posts
Likes Given: 1

Default

Quote:
Originally Posted by mabrungard View Post
That RO water has little alkalinity and the CaCl addition pushes RA down pretty low. With the color of that grist, I'm not surprised with the prediction of a low mash pH. I hope you have a pH meter and can report back here with your result. From my experience, its much more likely that the mash pH is going to be low than high.
I converted it to Lovibond and it was closer, but still not 100% equal. On my last brew, I checked my pH (cheapo Milwaukee pH600) and it was 5.3. Bru'n said it would be 5.3 while EZ Water said it would be 5.46. So I'm thinking if I go with Bru'n Water again for my next brew (est. 5.3), I should be fine without any acid malt additions right?
pensphreak is offline
 
Reply With Quote
Old 07-02-2012, 07:51 PM   #6
diegobonatto
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
diegobonatto's Avatar
Recipes 
 
Join Date: Feb 2011
Location: Porto Alegre, Rio Grande do Sul
Posts: 99
Liked 5 Times on 5 Posts

Default

Quote:
Originally Posted by pensphreak View Post
I converted it to Lovibond and it was closer, but still not 100% equal. On my last brew, I checked my pH (cheapo Milwaukee pH600) and it was 5.3. Bru'n said it would be 5.3 while EZ Water said it would be 5.46. So I'm thinking if I go with Bru'n Water again for my next brew (est. 5.3), I should be fine without any acid malt additions right?
Yes, you will be fine without acid malt.
diegobonatto is offline
 
Reply With Quote
Old 07-02-2012, 07:58 PM   #7
pensphreak
HBT_SUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2011
Location: Anaheim, CA
Posts: 98
Liked 2 Times on 2 Posts
Likes Given: 1

Default

Quote:
Originally Posted by diegobonatto View Post
Yes, you will be fine without acid malt.
Hopefully my next batch pH matches Bru'n water again
pensphreak is offline
 
Reply With Quote
Old 07-02-2012, 08:13 PM   #8
DSmith
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2011
Location: Robbinsdale, MN
Posts: 793
Liked 72 Times on 60 Posts
Likes Given: 12

Default

No acid malt seems pretty safe for this recipe and 100% RO water. Even if your pH matches EZ Water, no acid malt doesn't make for that high of mash pH.

Please complete the thread with your measured room-temp pH with calibrated meter.
DSmith is offline
 
Reply With Quote
Old 07-02-2012, 10:24 PM   #9
ajdelange
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 7,721
Liked 1027 Times on 812 Posts
Likes Given: 30

Default

You shouldn't be surprised or concerned. Spreadsheets and calculators use models and while some models are better than others in particular situations the converse may be true in other situations. No model is perfect. In brewing there are simply too many degrees of freedom to allow for perfect prediction of mash pH.
ajdelange is online now
 
Reply With Quote
Old 07-06-2012, 08:57 PM   #10
pensphreak
HBT_SUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2011
Location: Anaheim, CA
Posts: 98
Liked 2 Times on 2 Posts
Likes Given: 1

Default

So I made a small change to the Bru'n water spreadsheet, and the expected pH was 5.4. My pH600 meter measured the mash right on at 5.4


Click image for larger version

Name:	IMG_2100.jpg
Views:	331
Size:	28.9 KB
ID:	67456  
pensphreak is offline
 
Reply With Quote
Reply


Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Which water profile in Bru'n Water should I pick for Bavarian Helles Liquisky Brew Science 5 05-21-2012 08:58 PM
Bru'n Water, noob Double-R Brew Science 3 04-21-2012 10:08 PM
Help with modifying water w/Bru'n Water DPB Brew Science 14 02-01-2012 05:38 PM
Help with modifying water w/Bru'n Water DPB Brew Science 0 01-26-2012 03:41 PM
Ward Water Report and Bru'n Water Sheet, now what? ToastedPenguin Brew Science 1 07-22-2011 07:58 PM


Forum Jump

Newest Threads

LATEST SPONSOR DEALS