Spike Brewing 12.5 Conical Fermenter Giveaway - Enter Now!

Home Brew Forums > Home Brewing Beer > Brew Science > Water Profile question

Reply
 
LinkBack Thread Tools
Old 12-22-2013, 11:22 AM   #21
BackAlley
Feedback Score: 0 reviews
Recipes 
 
Join Date: Mar 2013
Posts: 267
Liked 19 Times on 18 Posts
Likes Given: 1

Default

AJ do you offer your spreadsheet?

__________________
BackAlley is offline
 
Reply With Quote Quick reply to this message
Old 12-22-2013, 03:23 PM   #22
ajdelange
Senior Member
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 5,849
Liked 568 Times on 468 Posts
Likes Given: 16

Default

I assume you mean the one for mash pH prediction. It isn't very refined at this point. I was giving a presentation on my technique for estimating mash pH and when the previous speaker illustrated his presentation with a spreadsheet I thought 'I should do that too' and cobbled it up during the rest of his talk. I've added a few things since then, though. It's at http://wetnewf.org/pdfs/Brewing_articles/MashpH.xlsx and be sure to download the slides from my presentation so you'll understand how it works. It's really great for showing you which parts of your mash contribute and absorb protons.

Don't get too excited about razor sharp pH predictions though. If I make a test mash with malts for which I have complete data it works really well, unsurprisingly enough. But if you try to use it to predict mash pH with a malt I haven't measured in detail you can get results that are way off. This whole thread is built on an unreasonable prediction, based on malts of the same color that I have measured, of mash pH by Bru'n water which obviously bases its prediction on different malts.

As I've only measured 4 malts at this point there aren't many beers you can model. To allow you to play around a bit I have taken Kai Troester's data and derived the average buffering capacity over the range he measured. You can use this as an approximation to the first of the three coefficients my model requires and probably get a fair prediction in many cases. You can even interpolate values of this first coefficient between colors as given in Kai's data but there is no reason to expect that the prediction will be any better than any other one that tries to do this based on malt color.

Put another way, my model is robust but the data you will have to put into it, other than for the 4 malts I have measured, isn't. So at this point I really think the value is more in that it will show you about where the protons flow than in its pH predictions.

__________________
ajdelange is offline
 
Reply With Quote Quick reply to this message
Old 12-23-2013, 09:38 AM   #23
BackAlley
Feedback Score: 0 reviews
Recipes 
 
Join Date: Mar 2013
Posts: 267
Liked 19 Times on 18 Posts
Likes Given: 1

Default

Thanks AJ. All caveats are noted. I do measure pH and don't just rely on the estimates.

__________________
BackAlley is offline
 
Reply With Quote Quick reply to this message
Old 01-29-2014, 01:03 AM   #24
MadGus
Junior Member
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
MadGus's Avatar
Recipes 
 
Join Date: Dec 2008
Location: Richmond, Virginia
Posts: 132
Liked 5 Times on 4 Posts
Likes Given: 1

Default Water Profile question

Off topic, but had to post.

Had dinner and a flight of beers at Mad Fox tonight.

Simply awesome. Great beer, great food, very reasonable prices.

Nice work, AJ!

__________________

Primary: Liberal Wheat 5.14
Secondary: Air
Bottle Conditioning: Gingerbread Stout 12.13
Kegged: IPA 3.14, Gluten Free Dos-Equis Clone 1.14
Commercial Tap: Legend Brown Ale
In Bottles: Hopslam, eSCB Holiday Ale 8.13

On Deck: Bourbon Cru 6.14

Gallons in 2014: 33

MadGus is offline
 
Reply With Quote Quick reply to this message
Reply


Quick Reply
Message:
Options
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Water Profile Question of course NorsemenRugby58 Brew Science 16 01-03-2012 05:51 PM
Water Profile Question Haldedrums Brew Science 5 12-28-2011 11:56 PM
Water Profile Question Haldedrums Brew Science 0 10-11-2011 01:23 PM
Water profile question for an IPA xjncoguyx All Grain & Partial Mash Brewing 4 03-30-2010 01:01 AM
Water Profile Question?? MashStirBrew Recipes/Ingredients 2 05-01-2008 05:59 AM