Take a look at the boiled Edinburgh profile in Bru'n Water...
Given the problems I found with the Black Malty profile in the other thread I thought that might be a good idea. With the boiled Edinburg thread the calcium and magnesium requirements are in line with what can be provided by the neutral salts but the demanded sodium level cannot be met with sodium chloride alone as to do so would put the chloride over. In this profile we, therefore, need lots of sodium bicarbonate. If we let the synthesis algorithm run allowing it to alter pH it shifts it to 8.38 because at that pH bicarbonate has no proton deficit and we can use as much as we like. The penalty is, of course, the proton deficit wrt the mash tun pH and acid will have to be used later to cover that.
mg/L Synth
CaCl2.2H2O 0.04
NaCl 64.51
MgCl2.6H2O 31.09
CaSO4.2H20 135.55
MgSO4.7H20 165.12
Liters/Liter 0.00
CaCO3 0.00
NaHCO3 108.25
CO2 0.00
HCl 0.00
Ca(OH)2 0.01
Na2CO3.H2O 0.00
Sodium Lactate 0.00
Potassium Lactate 0.00
Lactic 0.00
Sulfuric 0.00
Weights Errors, % Errors, mg/L Target Realized
1 -0.0010% 0.00 Calcium 33 32.9997
1 0.0005% 0.00 Magnesium 20 20.0001
0 -4.4127% -0.06 mmol Carbo 1.34800 1.2885
0 -4.4127% -3.56 Bicarbonate 80.64 77.0856
1 -0.0025% 0.00 Sulfate 140 139.9964
1 -0.0026% 0.00 Chloride 50.00 49.9987
0 0.0000% 0.00 Nitrate 0 0.0000
0 0.0000% 0.00 Nitrite 0 0.0000
1 -0.0011% 0.00 Sodium 55.0000 54.9994
0 0.0000% 0.00 Potassium 0.00 0.0000
0 0.0000% 0.00 Fe(II) 0 0.0000
0 0.0000% 0.00 Fe(III) 0 0.0000
0 0.0000% 0.00 Ammon.
Wt'd RMSE Wt'd RMSE,% RMSE, mg/L
7.69792E-06 0.0018% 0.9871 Target pH 8.3815
Wts ≠ 0 RMSE, (Wt ≠ 0) RMSE, (Wt ≠ 0)
5 0.0018% 0.0017
Alk, as CaCO3 Max (Wt ≠ 0) %
65.84 0.0026%
mg/L Synth mg/L Src
To make it at pH 8 requires some acid
mg/L Synth
CaCl2.2H2O 3.19
NaCl 74.61
MgCl2.6H2O 9.19
CaSO4.2H20 117.00
MgSO4.7H20 191.68
Liters/Liter 0.00
CaCO3 0.00
NaHCO3 93.74
CO2 0.00
HCl 0.00
Ca(OH)2 6.40
Na2CO3.H2O 0.00
Sodium Lactate 0.00
Potassium Lactate 0.00
Lactic 17.51 -0.1944 mEq/L 0.063983553 ml/gal
Sulfuric 0.00
but not an excessive amount and the fit is very good
1 -0.0002% 0.00 Calcium 33 32.9999
1 -0.0001% 0.00 Magnesium 20 20.0000
0 -17.2280% -0.23 mmol Carbo 1.34800 1.1158
0 -17.2280% -13.78 Bicarbonate 80.00 66.2216
1 -0.0003% 0.00 Sulfate 140 139.9996
1 0.0000% 0.00 Chloride 50.00 50.0000
0 0.0000% 0.00 Nitrate 0 0.0000
0 0.0000% 0.00 Nitrite 0 0.0000
1 0.0002% 0.00 Sodium 55.0000 55.0001
0 0.0000% 0.00 Potassium 0.00 0.0000
0 0.0000% 0.00 Fe(II) 0 0.0000
0 0.0000% 0.00 Fe(III) 0 0.0000
0 0.0000% 0.00 Ammon.
Wt'd RMSE Wt'd RMSE,% RMSE, mg/L
7.69086E-07 0.0002% 3.8233 Target pH 8.0000
Wts ≠ 0 RMSE, (Wt ≠ 0) RMSE, (Wt ≠ 0)
5 0.0002% 0.0002
Alk, as CaCO3 Max (Wt ≠ 0) %
56.16 0.0003%
Again, we don't want it at 8, we want it at mash pH say 5.4
CaCl2.2H2O 0.00
NaCl 67.68
MgCl2.6H2O 25.63
CaSO4.2H20 130.93
MgSO4.7H20 171.74
Liters/Liter 0.00
CaCO3 0.00
NaHCO3 103.69
CO2 0.00
HCl 0.00
Ca(OH)2 2.01
Na2CO3.H2O 0.00
Sodium Lactate 0.00
Potassium Lactate 0.00
Lactic 109.02 -1.1766 mEq/L 0.398306245 mL/gal
Sulfuric 0.00
which requires more acid, of course, because he synthesis at pH 8 has alkalinity of 56. Note that this isn't the specified alkalinity of the table entry for this water (alk = 66). That's because the water in the table doesn't exist.
Thus we see that this profile suffers from the same problems as the Black Malty but not nearly to the same extent.
It seems clearer that the way to fix this table is remove the bicarbonate column which is useless info as its entry is just an artifice to obtain electrical balance without regard as to whether the profile can actually be made and replace it with the mEq/L acid required to make the profile at pH 8 (which we assume is the pH for all entries in this table). The alkalinity column should then be changed to indicate the alkalinity of the real profile i.e. the one the brewer can actually produce. It would also, of course, be very useful if the recipes which produce the realizable profiles in DI water, including the requisite acid, were given.
A quick check of the Edinburg profile (not boiled) reveals that it can be made perfectly (with less than 2% error in the bicarb even) at pH 8 using CO2 as the acid with limestone. This is natures acid and the ideal acid and we usually have some sort of trouble if we try to substitute another acid in a synthesis. The fact is that much of the cation content of a natural water is there as the bicarbonate. It's complicated.