BrewingTechniques

Technical Communications

Republished from BrewingTechniques' November/December 1993.

Correction: Water Treatment Calculations Table Update

A critical factor was omitted from a table of "Cell names and equations for calculations" in the article "Water Treatment: Philosophy, Approach, and Calculations" (BrewingTechniques 1 [3], 36-39 [1993]). Cells E16-E21 should have added in the ionic concentration from column "C" in Figure 1 of that article. The correct table appears at right.

Also, cell E18 in Figure 1 should read "40.8."

BrewingTechniques regrets the errors and thanks the readers who brought them to our attention.
-- Editor


Cell Names and Equations for Calculations
CellNameRepresents
F7 GAL Volume of water needed (in gallons)
F8 DF Dilution factor (range of 0.0-1.0)
F16 CS Calcium sulfate added (in grams)
F17 CL Calcium chloride added (in grams)
F18 CC Calcium carbonate added (in grams)
F19 MS Magnesium sulfate added (in grams)
F20 NL Sodium chloride added (in grams)
F21 HCLHydrochloric acid added (milliliters of 0.1 M)
F22 HPPhosphoric acid added (milliliters of 0.1 M)
F23 HLACLactic acid added (milliliters of 0.1 M)
CellEquation
F9 =GAL*(1-DF)
F10 =GAL*DF
C16 =B16*(1-DF); Copy this equation down through C21
E16 =C16+ROUND
(264.2*(0.232*CS+0.272*CL+0.4*CC)/GAL,1)
E17 =C17+ROUND
((264.2*0.6*CC-0.7926*(HCL+1.5*HP+HLAC))/GAL,1)
E18 =C18+ROUND
(264.2*(0.558*CS+0.39*MS)/GAL,1)
E19 =C19+ROUND
(264.2*0.099*MS/GAL,1)
E20 =C20+ROUND
(264.2*0.3934*NL/GAL,1)
E21 =C21+ROUND
((264.2*(0.483*CL+0.607*NL)+0.936*HCL)/GAL,1)

[Home]  [BrewingTechniques Library]  [Contact Us]  [Order]