Rob1 Oh…..just looked at your water report. Alkalinity is listed at an average of 54mg/l.
So if you follow the instructions on the spreadsheet this will be a fairly simple task for you.
“EDIT VALUES IN YELLOW CELLS ONLY UNLESS YOU KNOW THE ALKALINITY AND HARDNESS AS CaCO3 TO ENTER IN CELLS B15 & B16”
So you just need to edit B15 and B16…..along with inputting the max temp (Minima probably about 125c but you can go higher or lower).
Hi Rob, thanks for pitching in. I apologise in advance if you’ve answered some of the queries that follow.
So, what I’ve done, using your suggestions, is increase the temperature to 125, I’d put the brewer temperature, 93 not the steam boiler temp since I thought that was what was needed. Then I’ve created two spreadsheets, one with the numbers for the tap water and another for numbers using the Zero Water jug. However, I’m not sure I’m putting numbers in the right place, I imagine it seems obvious to you but it’s not for me, hope you can bear with me. For the tap water figures I’ve put zero for cells B3 to B6 and I’ve put in B9, calcium, as 47.73 and Magnesium, cell B10 as 5.09 as per my water report. Temp as 125 and TDS, cell B13, is 100, not 140 that I had before. I’ve put the Alkalinity in B15 as 54, as you point out that’s what’s in the water report. Hardness, Cell B16 is calculated from the Ca Mg figures and comes out as 140.155
Then for the Zero Water jug, I’ve left all B3 to B10 the same since they don’t seem to be used if I put in figures for cells B15 and B16, which are 32.22 and 103.82 respectively - those figures are from my API test but have I done the right thing? They’re the KH and GH ppm figures from the test (I did the scaling up as you recommended).
My next problem is that, if what I’ve done above is correct, then I don’t know how to interpret the results! What do cells B18 to B24 mean and what do I now do with my tap and zero jug water; do I add 64g per litre of zero water as @dutchy101 suggests or do I mix 3 parts of my tap water to 1 part zero water as @MWJB says, or do I do something else? I don’t know what the Calculations figures mean and those figures don’t seem to be referenced in the Water Remineralisation page.
Sorry guys to be needing so much hand holding