ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2
Instructions on how to use the spreadsheet
PotassiumTRUE
3
All cells requiring input are colored yellow (except the checkboxes)
NitrateFALSE
4
1) Choose which mineral water you want to recreate (click to show drop down list)
MgCl2TRUE
5
2) Click check boxes to include/exclude salts (depending on which salts are available)
Mg(OH)2FALSE
6
3) Compare composition of the artificial mineral water with the original water (deviations are indicated with darker color)
Ca(OH)2FALSE
7
4) If known, please enter the composition of your tapwater here and the recipe will be adjusted according to this. Add bicarbonate to balance charge.
MgCO3TRUE
8
5) CO2 level is not always given for the mineral water chosen. Adjust amount and notice how it affects the pH.
CaCO3TRUE
9
6) Carbonate water, let the carbonic acid dissolve magnesium and calcium salts, chill and enjoy!
10
11
Created by Arby Avanesian at empirical water. To learn more about water for coffee, visit empiricalwater.com/blogs/learn.
12
Analytical data for chosen mineral water
This calculator accounts for the 98% purity of calcium sulfate dihydrate and for the 99% purity of calcium chloride.
Composition of tap water used
MW
Rakkestad
13
blank
Compositional data for artificial mineral water
milliliters: mg/L mmol/LCa++40.078calcium 30.0
14
mg/L mmol/L Amount of salt to add for1 liter37,854.00calcium - - Mg++24.305
magnesium
 3.2
15
calcium#REF!#REF! mg/L mmol/L Saltmmol/Lmgmgmagnesium - - Na+22.99sodium 9.9
16
magnesium#REF!#REF!calcium 9.351 0.233 NaCl0.000000.000.00sodium - - K+39.098
potassium
 -
17
sodium#REF!#REF!magnesium 2.835 0.117 NaHCO30.4000033.60401272.05potassium - - HCO3-61.01
bicarbonate
 -
18
potassium#REF!#REF!sodium 9.196 0.400 KHCO30.000000.000.00bicarbonate - - SO4--96.06sulfate -
19
bicarbonate#REF!#REF!potassium - .000 - .000 MgCl2.6H2O0.000000.000.00sulfate - - Cl-35.45chloride 8.2
20
sulfate#REF!#REF!bicarbonate 24.404 0.400 Ca(NO3)2.4H2O0.000000.000.00chloride - - NO3-62.0049nitrate -
21
chloride#REF!#REF!chloride 12.797 0.361 MgSO4.7H2O0.1166528.751088.33nitrate - - CO244
22
nitrate#REF!#REF!sulfate 16.280 0.169 CaSO4.2H2O0.052839.10351.34NaCl58.44
23
carbon dioxide0 - nitrate - .000 - .000 Mg(OH)20.000000.000.00
positive charge equivalents
 - NaHCO384.01
24
pH#REF!carbon dioxide 10.000 0.227 Ca(OH)20.000000.000.00
negative charge equivalents
 - MgSO4.7H2O246.47
25
TDS#REF!calculated pH 6.598 MgCO30.000000.000.00CaSO4.2H2O172.17
26
TDS 74.864 CaCO30.000000.000.003Mg(OH)258.3197
27
positive charge equivalents
#REF! calculated P(CO2) 0.007 atm CaCl20.1805020.03765.95mg/L
mmol/L
Ca(OH)274.093
28
negative charge equivalents
#REF!
positive charge equivalents
 1.1000 Total salt0.7499891.483477.66calcium#REF!#REF!
Ca(NO3)2.4H2O
236.15
29
Red: cations and anions do not balance
negative charge equivalents
 1.1000
Carbonate Hardness (mg/L):
magnesium#REF!#REF!KHCO3100.115
30
(means that compositional data shown is incomplete)
Darker shading: failed to meet target
20.00sodium#REF!#REF!MgCl2.6H2O203.31
31
calculated conductivity
 132.65
µS/cm @25C
General Hardness (mg/L):
Permanent:Temporary:potassium#REF!#REF!CaCO3100.08
32
calc pressure#REF!
@19C? 2-4%
35.0015.0020.00bicarbonate#REF!#REF!MgCO384.31
33
Extra CO210 mg/L
GH:KH Ratio:
sulfate#REF!#REF!CaCl2110.98
34
1.750
Moles of hardness
chloride#REF!#REF!
35
Mineral water calculator by Martin Lersch
Ca:Mg Ratio:
from carbonates:
nitrate#REF!#REF!
36
Download from Khymos.org
2.0000.00%
37
Cl:SO4 Ratio:
38
2.130
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100