You have a lot of bicarbonate, but also a lot of calcium, so your RA is about 40. That might be a little high for a pale ale but is about right for an amber. For really light beers you’ll need to dilute, and for dark beers you’ll want to add more carbonates.
The important ions in your brew water are: Ca, Mg, Na, Cl, SO4, Bicarbonate (HCO3). Alkalinity, hardness, and pH are also important.
Calcium (Ca) = 102 ppm. GOOD. Rec range is 50-150; optimum range is 50-100.
Magnesium (Mg) = 12 ppm. GOOD. Rec range is 10-30; optimum range is 10-20. Impt yeast nutrient.
Sodium (Na) = 44 ppm. LOW. Rec range is 0-150 ppm, 70-150 gives a nice malt flavor; >200 yields a salty taste.
Chloride (Cl) = 40 ppm. LOW. Rec range is 0-250. Levels > 250 may enhance beer sweetness.
Sulfate (SO4) = 76 ppm. OK. Range 50-150 yields normal bitterness; range 150-350 is very bitter.
Bicarbonate (HCO3) = 144 ppm. Depends on desired style. Rec ranges: 0-50 (pale beers), 50-150 (amber beers), 150-250 (dark, roasted beers).
Total Alkalinity (CaCO3) = 118 ppm. MODERATELY HARD. Ideally <50 unless balanced by Ca or acidity of dark malt. High alkalinity levels halt enzyme action and harm beer flavor by sharp, harsh hop flavors. 0-60 (soft), 61-120 (moderate), 121-180 (hard), >180 (very hard)
Total Hardness as CaCO3 = 305 ppm. HARD. Generally anything over 150 ppm is hard.
pH = 7.8. Alkaline.
Use water adjustment calculators. You will need to filter your tap water with an activated charcoal filter (not water softener!), and use a significant % of reverse osmosis water, and brew salt additions (particularly calcium chloride) to get better brewing water. But, trust me, learning about it and adjusting it will make the beer so much better tasting. Read the thread for resources that can help you.
Look under AHA FORUM, INGREDIENTS, POST YOUR WATER REPORT, PAGE 3
You can also use John Palmer’s Mash Residual Alkalinity Adjustment Worksheet Version 2.5 (US Units) online to figure out your Residual Alkalinity and your Chloride to Sulfate Balance (yours is very bitter).
Your hardness almost completely balances the alkalinity. It seems to be good water for about any ale (except the lightest ones maybe). When brewing light lagers you may want to soften it by dilution (50:50 would work) for a few batches to see if you prefer softer water in that case.
Most of the magnesium in the wort is actually coming from the malt. The source I have indicates 130 ppm. The lessens the importance of magnesium in the water. But its presence doesn’t cause problems either.
Thank you so much Richard for your detailed response!
Yes I’ve been reading quite a bit latley and finally chose to use the EZ water adjustment calculator from TH over @ HBT.
I’m excited to get busy learning as much as I can so I can make better beer.
I have been making decent all grain beer over the last 6 years.
The filter is going to be my next purchase.
As for my first water treated brew day. here is what I made 10 SRM IPA 88 IBU 1.071 OG 5.5 gallons
I used a known water source spring water and omitted the lactic in the boil
Interesting–I didn’t know the malt had such a high level of magnesium. How does so little of it end up in the wort?
Regardless of source, my understanding is that magnesium should remain at low levels 10-30 ppm in the final product.
Dave Miller and John Palmer’s books indicate that Mg levels >30 ppm begin to yield sharp,sour flavors, >50 ppm yield sour-bitter flavors, and >125 ppm have laxative and diuretic properties.
I don’t have data about typical Mg concentrations in brewing wort. Let me know if you do. Some of the magnesium is going to precipitate during mashing and boiling.
While I do understand the existence of a suggested upper limit for magnesium, in particular if lots of sulfate is available, I’m not so sure if there is actually a lower limit for magnesium in brewing water. I.e. is there an actual benefit to having 10 ppm Mg in the water as opposed to not have any. Though this matters little for existing brewing waters it may matter for those of us who build water from scratch and could just drop the addition of magnesium salts.