You are right. I have it and have tried to go through and use it and it did confused the heck out of me haha. It's quite a bit of info, and having been removed from chemistry for, oh 13ish years, it's an overwhelming crash course, that's for sure. I understood some of it and I am attempting to cram a lot of learning into a short time as I need to pick up my water today, so I'm just lost on the part where CaCl is one number in some places and two separate numbers elsewhere.
I've since lessened my confusion a little bit by actually finding out how many ppm a gram or tsp of the minerals adds... That was one confusing part is the labels on these don't actually list that, just "how much to add per gallon".
Thanks for the tip(s).
Take all the chemistry out of it and do the following:
1.) plug in your water values (or use DO/distilled)
2.) plug in your grain bill
3.) save a copy of this document for each recipe/iteration
4.) calculate your expected mash volume, sparge volume and desired water ion levels (you can use the custom selection to do this easily)
5.) play with the values for adding in SO4 (usually gypsum, but I do a little epsom for Mg too), Cl (usually calcium chloride, but i add a little canning salt for Na too) and if a dark beer, consider chalk/baking soda additions for mash pH control
Step 5 is kind of like a puzzle, where you add a little of this, a little of that and try to hit all the values you'd like while keeping mash pH in a respectable range.
While understanding all the chemistry is better than not, you don't need to since the spreadsheet is doing all the work for you!
RE the CaCl2 part, its because the ions dissociate in water, so what is stable as a solid in salt form (the 1 number), really plays 2 parts in beer in liquid form. Hope that makes sense!