I decided to give my brewing water calculator a face lift and also add some new features that brewers were looking for. The face lift happened mostly on the “basic” page, which is now more intuitively grouped into the sections for
- base water
- mash and grist info
- salts and acids
- resulting water profile and mash pH prediction
These are other things I changed or added:
- changed the treatment of undissolved chalk such that it only contributes half its calcium since it contributes only half its alkalinity. Chalk’s solubility in mash seems to be limited and what does not dissolve and contribute to a rise in alkalinity should not contribute calcium ions either.
- salt additions can now be made in g and mg/l. You can select the unit
- the salts to be added can be reported in g and tsp. The latter is useful if your scale breaks down or you don’t own one yet.
- lactic acid and phosphoric acid are supported. Are there many brewers who are actually using hydrochloric or sulfuric acid? I may add support for those later.
- water boiling for alkalinity reduction has been added to the “advanced page”. This was easy to add since I already supported lime treatment
- pH shift estimation for the major water treatment steps
- salts can be added to all the water or strike water only. If they are only added to the strike water, the resulting water profile for the strike water or the overall water can be reported.
But a number of features remained the same:
- The basic and advanced pages are still there. Anything entered in the basic page will automatically carry over into the advanced page. The idea is to support a wide variety of users.
- the tall and narrow formatting remained in order to better support its use on mobile devices
- I avoided macros or the use of fancy functionality in hope that this spreadsheet can be supported by mobile devices
- the SRM based mash pH prediction is still there. Compared to some tests I’m running with grist based mash pH prediction, it does surprisingly well and is actually more accurate in most cases.
- support for SI and US units. Under the hood it uses SI units almost exclusively. There is a spreadsheet version that is preloaded with US units even though this changes only 2 fields.
The new Kaiser_water_calculator.xls can be found in the Ingredients section on my site.
If you find bugs or have suggestions for improvements let me know here or send e-mail to “kai at braukaiser dot com”.