Hey guys-
For those of you out there who are good with water I wanted to my water by you all to see if I have used the EZ Water Calculator spreadsheet appropriately. First off here is the recipe i am brewing which is an American Pale Ale:
12 gallons post boil
OG = 1.054
TG = 1.011
Color = 6.4 SRM
ABV = 5.64%
IBU = 37
Fermentables
16.8lbs Maris Otter
2.1lbs Munich Malt
1.05lbs Crystal 10L
1.05lbs Carapils
Cascade 9.1%AA - 60min - .65oz
Cascade 9.1%AA - 35min - 1.2oz
Cascade 9.1%AA - 15min - 1.2oz
Cascade 9.1%AA - 10min - .80oz
Cascade 9.1%AA - 05min - .70oz
I've brewed this beer many times with my cities water profile mentioned above. Here it is again for good measure (although tomorrow when i get over to my buddies place where i brew I am going to get a sample to send to Ward labs).
Calcium - 26 to 71 - AVG 53
Magnesium - 11 to 28 - AVG 22
Sodium - 58 to 98 - AVG 85
Chloride - 67 to 94 - AVG 88
Sulfate - 55 to 250 - AVG 168
Alkalinity - 63 to 130 - AVG 106
or as Bicarbonate - 129
Hardness (CaCO3) - 84 to 300 - AVG 217
PH - 7.5 to 8.6 - AVG 8
And here i have added this information into EZ Water Calculator to adjust to style:
How do i know if I have done the additions correctly? Palmer mentions Residual Alkalinity a LOT on the Waterganza shows and my residual alkalinity is -249 according to this spreadsheet, which seems weird. Obviously this is something i need to look into understanding more at this point.
I should mention that i am aware I did not dilute the water at all. I am not going to add anything to my water until i get reports back from Ward labs about the actual chemistry of my water. At that point I will make an educated decision about how to adjust the water so that i can brew lighter styles. Thanks for any input.