EZ Water Adjustment spreadsheet - Page 14 - Home Brew Forums

Register Now!
Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Adjustment spreadsheet

Reply
 
Thread Tools
Old 01-15-2010, 04:29 AM   #131
GilaMinumBeer
HBT_LIFETIMESUPPORTER.png
 
GilaMinumBeer's Avatar
Recipes 
 
Jan 2008
Posts: 58,524
Liked 7470 Times on 6120 Posts


Okay. The spreadsheet as is adjusts based on 33%HCl (Hydrochloric Acid) or 88%C3H603 (Lactic Acid) and adjust RA accordingly.

BUT, I use a 75% H3PO4 (Phosphoric Acid). What do I need to change in the formulas to calculate this addition properly? Or, to just add H3PO4 as an option of the acids?

 
Reply With Quote
Old 01-15-2010, 12:26 PM   #132
-TH-
 
-TH-'s Avatar
Recipes 
 
Oct 2008
Zeeland, Michigan
Posts: 905
Liked 91 Times on 53 Posts


Quote:
Originally Posted by GilaMinumBeer View Post
Okay. The spreadsheet as is adjusts based on 33%HCl (Hydrochloric Acid) or 88%C3H603 (Lactic Acid) and adjust RA accordingly.

BUT, I use a 75% H3PO4 (Phosphoric Acid). What do I need to change in the formulas to calculate this addition properly? Or, to just add H3PO4 as an option of the acids?
Palmer's spreadsheet instructions say this:

"I do not recommend the use of Phosphoric Acid because it removes calcium from the water as well, and changes the water profile that you are trying to adjust. The amount of calcium removed is complex and I donít have a feedback loop in the spreadsheet to accommodate the effect."

I may have to avoid this one as well. However if you want to dig up some more info on the subject and it turns out to be not too complicated, I could possibly incorporate it.
__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com

 
Reply With Quote
Old 01-15-2010, 02:13 PM   #133
GilaMinumBeer
HBT_LIFETIMESUPPORTER.png
 
GilaMinumBeer's Avatar
Recipes 
 
Jan 2008
Posts: 58,524
Liked 7470 Times on 6120 Posts


Quote:
Originally Posted by -TH- View Post
Palmer's spreadsheet instructions say this:

"I do not recommend the use of Phosphoric Acid because it removes calcium from the water as well, and changes the water profile that you are trying to adjust. The amount of calcium removed is complex and I donít have a feedback loop in the spreadsheet to accommodate the effect."

I may have to avoid this one as well. However if you want to dig up some more info on the subject and it turns out to be not too complicated, I could possibly incorporate it.
Yeah. My problem is that my starting pH is so base that the amount of Lactic or Citric Acid I need to balance it results in a sour twinge to the water.

Thought about HCl but, too many here were too adamant about Phosphoric and I had troubles finding a good product for brewing. So, I settled on a gallon of the ole' H3PO4. I can always add Calcium.

 
Reply With Quote
Old 01-16-2010, 04:26 PM   #134
hopvine
Recipes 
 
Mar 2009
Holland, MI
Posts: 261
Liked 6 Times on 5 Posts


I'm starting with RO water. The Bicarbonate and Alkalinity levels of the water are both 0, however depending on whether I have Bicarbonate or Alkalinity selected in my "Starting Water Profile", my Residual Alkalinity changes drastically (from 87 with Bicarbonate set to zero, to 129 with Alkalinity set to zero). Why does this change? Which value should I believe?

 
Reply With Quote
Old 01-18-2010, 01:02 PM   #135
-TH-
 
-TH-'s Avatar
Recipes 
 
Oct 2008
Zeeland, Michigan
Posts: 905
Liked 91 Times on 53 Posts


Thank you hopvine! There was indeed a calculation error. I have fixed it now so please re-download and try again.
__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com

 
Reply With Quote
Old 01-18-2010, 04:25 PM   #136
RonRock
Always Ready
HBT_LIFETIMESUPPORTER.png
 
RonRock's Avatar
Recipes 
 
Jul 2008
Underwood, Iowa
Posts: 1,263
Liked 8 Times on 8 Posts


Quote:
Originally Posted by -TH- View Post
Thank you hopvine! There was indeed a calculation error. I have fixed it now so please re-download and try again.

Does this effect all users of the spreadsheet? Should we update?

 
Reply With Quote
Old 01-18-2010, 04:27 PM   #137
ShortSnoutBrewing
Kwanesum Chinook Illahee
HBT_LIFETIMESUPPORTER.png
 
ShortSnoutBrewing's Avatar
Recipes 
 
Oct 2007
Portland, OR
Posts: 3,213
Liked 19 Times on 17 Posts


Uh oh...brewed a batch this weekend starting with RO water and this spread sheet....

 
Reply With Quote
Old 01-18-2010, 04:58 PM   #138
-TH-
 
-TH-'s Avatar
Recipes 
 
Oct 2008
Zeeland, Michigan
Posts: 905
Liked 91 Times on 53 Posts


Quote:
Originally Posted by RonRock View Post
Does this effect all users of the spreadsheet? Should we update?
I would recommend all users update. The spreadsheet was miscalculating the alkalinity of the salt additions if you had "Alkalinity from CaCO3" checked in the starting water. If you had "Bicarbonate" selected (the default), there was no error.
__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com

 
Reply With Quote
Old 01-19-2010, 08:50 AM   #139
gxm
Recipes 
 
Jul 2008
Portland, OR
Posts: 550
Liked 9 Times on 7 Posts


Thanks for the spreadsheet, TH. This makes much more sense to me than the nomographs

 
Reply With Quote
Old 01-21-2010, 07:21 PM   #140
-TH-
 
-TH-'s Avatar
Recipes 
 
Oct 2008
Zeeland, Michigan
Posts: 905
Liked 91 Times on 53 Posts


1-21-10: I re-wrote the instructions and changed the labels & colors of some of the fields to make things a little easier to understand for first-time users. But those of you who already use it might want to check it out too. If not, at least make sure you are at Version 1.6 or higher because there was a bug in previous versions.
__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com

 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Water Modification Videos, TH's Spreadsheet Bobby_M Brew Science 234 08-22-2011 03:44 PM
First try at water adjustment carp Brew Science 5 10-14-2009 12:32 AM
Water Adjustment? jgardner6 General Beer Discussion 5 08-11-2009 02:33 AM
Devising water recipes using Palmer's spreadsheet SpanishCastleAle General Techniques 0 02-22-2009 01:12 PM
water adjustment positiverpr Recipes/Ingredients 2 10-14-2008 03:09 PM


Forum Jump