Water_for_Coffee_Crafter
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQR
1
2
DO NOT ASK ME FOR THE SHEET'S EDIT PERMISSION. YOU CAN ONLY USE THIS WATER CRAFTER AFTER HAVING DONE "FILE => MAKE A COPY" IN GOOGLE SHEETS.
3
This will allow you to edit your own copy of the spreadsheet.
4
5
This sheet allows you to craft your own recipe starting with tap water instead of distilled water. Hover your mouse over a cell to get more information.
6
Generally, cells in blue are automated (don't edit them), and cells with a bright red font can be edited. Ignore the section "Intermediate Variables".
7
8
This calculator assumes you have access to all ingredients listed below; If some of those are not accessible to you, you'll need a different water crafter.
9
Also make sure you have the correct hydrate forms; they look different. See my blog post linked below for more on that, and Amazon links.
10
11
Epsom Salt (MgSO4•7H2O)
12
Magnesium Chloride Hexahydrate (MgCl2•6H2O)
13
Calcium Chloride anhydrous (CaCl2)
14
Baking Soda (NaHCO3)
15
Potassium Bicarbonate (KHCO3)
16
17
Make sure you get food grade ingredients, not lab grade or pharma grade.
18
19
There are a few exceptions of missing minerals where you can still use the spreadsheet below. Here's a list with how to do it:
20
21
(1) NO ACCESS TO MgSO4: Set your target [SO4-] to your tap water [SO4-]
22
(2) NO ACCESS TO NaHCO3: Set your target [Na+] to your tap water [Na+]
23
(3) NO ACCESS TO NEITHER MgSO4 OR MgCl2: Set your target Mg/Ca = 0
24
(4) NO ACCESS TO CaCl2: Set your target Mg/Ca = 99999
25
26
If you are lacking other combinations of minerals, use the other tabs below that contain different versions of this calculator
27
28
You can specify your tap water's and desired brew water's Magnesium/Calcium ratio of ions to determine whether Mg or Ca form your water hardness.
29
If you don't specify it and instead use three dots ... then the calculator will instead look for your specified [Mg] and [Ca] concentrations.
30
If you use [Mg] and [Ca] make sure the associated GH (just to the right) is consistent with what you asked for in the specified bre water GH.
31
If your tap water has more GH, KH, SO4 or Na than your target brew water, you cannot use this water crafter (and you are generally screwed).
32
If you encounter any negative number anywhere, you are asking the water crafter to do something impossible (e.g. reduce your tap water's hardness by adding minerals).
33
34
By default the crafter is set to make 500 mL of the Rao/Perger brew water with a dosage of 4 g/L of brew water, starting from distilled water.
35
36
You can adjust the desired concentrate volume and dosage in the "Target Concentrate" section. The "Resulting Recipe" section will
37
list the ingredients you need for your concentrate. You can use the post linked here as a guide for crafting your concentrate;
38
I highly recommend using a mg-precision jewel scale, they can be quite cheap.
39
40
If you prefer having more than one concentrate (one for GH and one for KH) for flexibility, I recommend using this web tool by Barista Hustle:
41
https://baristahustle.com/blog/diy-water-recipes-redux
42
43
Tap WaterIntermediate VariablesVerifications
44
GH0ppm as CaCO3VC_VB4.00E-03(no units)GH87.5ppm as CaCO3
45
KH0ppm as CaCO3VT_VC2.49E+02(no units)KH40.5ppm as CaCO3
46
Mg/Ca0(no units)=>[Mg2+]0.0mg/LC_Epsom2.50E+04mg/LMg/Ca2.2(no units)
47
[SO4-]0mg/L[Ca2+]0.0mg/LC_CaCl27.58E+03mg/L[SO4-]39.0mg/L
48
[Na+]0mg/L=>Na/Ca0.0(no units)
C_MgCl2•6H2O
9.91E+03mg/L[Na+]9.4mg/L
49
[Mg2+]...mg/L=>GH...ppm as CaCO3C_NaHCO38.59E+03mg/L[Mg2+]14.6mg/L
50
[Ca2+]...mg/LMg/Ca...(no units)C_KHCO31.00E+04mg/L[Ca2+]10.9mg/L
51
fac5.00E-04(no units)C[SO4-]9.75E+03mg/L
52
Target Brew Watertap_ca0.00E+00mg/LC[Na+]2.35E+03mg/L
53
GH87.5ppm as CaCO3tap_mg0.00E+00mg/LC[Mg2+]3.65E+03mg/L
54
KH40.5ppm as CaCO3C[Ca2+]2.74E+03mg/L
55
Mg/Ca2.2(no units)=>[Mg2+]14.6mg/LC[HCO3-]1.23E+04mg/L
56
[SO4-]39mg/L[Ca2+]10.9mg/LC_GH2.19E+04ppm as CaCO3
57
[Na+]9.4mg/L=>Na/Ca1.5(no units)C_KH1.01E+04ppm as CaCO3
58
[Mg2+]...mg/L=>GH...ppm as CaCO3
59
[Ca2+]...mg/LMg/Ca...(no units)
60
61
Target Concentrate
62
Volume500mL
63
Dose4g/L
64
65
Resulting Recipe
66
Epsom Salt12.51gUse "File => Make a Copy" to edit this spreadsheet
67
CaCl23.79gSee this blogpost for help on crafting a minerals concentrate
68
MgCl2•6H2O4.96gSee this post for a video on preparing and using a concentrate
69
NaHCO34.29g
70
KHCO35.01g
71
Loading...