Mash Residual Alkalinity Spreadsheet Now Available

[howtobrew]

Hey Guys,
I have posted my Mash pH/Residual Alkalinity Spreadsheet at Howtobrew.com at the bottom of page 15-3 below the nomograph.

Currently, this version does not provide for salt additions to the sparge water, but you can fudge it by inputing that volume into the mash section. Later I will have seperate sheets for Mash water and sparge water, but for now, I only have acid additions to lower sparge water to pH 6. You can do either salt or acid additions or both to the mash.

the links are:
http://howtobrew.com/section3/Palmers_Mash_RA_1.2.xls
http://howtobrew.com/section3/Palmers_Metric_RA_1.3.xls

It's Excel and works on both Macs and PCs.
Hope you find it useful,
John

[Homegrown Hops]

John,
I am going to have some fun with those spreadsheets. Thanks for posting them.

HH

[Ozbrewer]

more toys to make me stress more about my water


You bastard


Thanks for the metric version....your not a real brewer unless you work in metric

[BrotherhoodBrew]

Looks great but I seem to have one problem. Alot of the things thise is looking for I can't seem to find on my water report. Here is a link to the water report I have

http://www.ci.carrollton.tx.us/developm ... Report.pdf

Do I need to request some other type of report to get all these items?

[brbrewmaster]

I was wondering why in the spreadsheet there is no calculation for adding phosphoric acid to the mash water? I like to add CaCl2 + 85% phosphoric acid.

Charlie

[howtobrew]

Brotherhood brew: You need to call the water department and get the numbers for Calcium, and Magnesium. At a minimum you need the Calcium number, we can calculate the Mg from the Total Hardness and the Ca, and then put all three values into the spreadsheet. Those 3 are the basis of RA

Brbrewmaster: The reason I don't include Phosphoric for mash correction is that it removes calcium from solution which changes the playing field. I don't have that equation and it's dependence on pH available yet, so until it is, I don't include it. If you use phosphoric then you can test it with a pH meter, but right now I can't calculate its effect.

Good Brewing,
John

[Speyedr]

Thanks John,

What's the difference in version 1.1. to 1.2? I brewed last weekend using 1.1 and now I am worried that my Belgian Blond will taste like French Piss, and I am not into that, no matter what that French girl says...

Seriously though, any big difference?

Rob

[howtobrew]

No calculation errors, just eliminated a divide by zero error if your water was not alkaline., and added some more color calculator cells. No differences to your results.
The metric change did the same things, but then I had to go to 1.3 because I forgot to re-label the cells as Liters instead of gallons, and to make the color unit EBC instead of SRM.
Cheers,
John