I’m looking to get some data on the municipal water in the Village of Cottage Grove. Has anyone done an official water analysis of the water supply in the Village of Cottage Grove that you would be willing to share?
The hardness and alkalinity numbers there are 298 and 236 mg/L respectively. That’s the same unit as ppm CaCO3 which can use to fill in your spreadsheet. That will get you the residual alkalinity (163) as well as guesses of calcium and magnesium levels. (The sheet uses 70% Ca/30% Mg contributions to hardness; Madison Mg percentages look to be higher than that.)
This does not give you sulfate numbers which you may care about for hoppy beers. Note some people smarter than I claim that it doesn’t make any difference.
Resurrecting this to see if anyone has similar info for Middleton. Seems like the water in Madison and likely Middleton is a pain for brewing certain beers. Hope someone can point me to the info. Thanks