ABCDEFGHIJKLMN
1
2
3
Direct Dosing Recipe Picker & Calculator - v2.1
4
5
Created by Chris Abney but made possible by the fantastic work of Sagebush, David Seng, and Jonathan Gagné
6
7
TO USE THIS SPREADSHEET YOU MUST MAKE A COPY OF IT. GO TO "FILE > MAKE A COPY" IN GOOGLE SHEETS. THEN YOU WILL BE ABLE TO EDIT YOUR OWN COPY OF THE SHEET.
8
9
Visible Table Notes:
10
11
Easy Direct Dosing Recipe Picker: This sheet allows you to pick your recipe and desired water amount from the dropdowns. Don't change anything else on this sheet!
12
Easy Direct Dosing Recipe Chart: This sheet displays all of the recipes in a table for the water and solutions selected on the Recipe Picker page. Don't change anything else on this sheet!
13
Custom Direct Dosing Recipe Creator: This sheet lets you create your own Direct Dosing recipe by entering your desired water, hardness solution, buffer solution, and desired GH and KH. It will then tell you how much of each solution you need to dose into your selected water.
14
Custom Direct Dosing GH / KH Lookup: This sheet lets you check the GH and KH of any given water recipe. Just enter your water, solutions, and the grams used and it will tell you what your GH and KH is.
15
16
Hidden Data Table Notes:
17
18
Easy Recipe Data: This is the sheet that stores all the recipe data. If you would like to add your own recipes feel free to add them to the green table. After adding a new recipe you will need to add more rows to the Easy Direct Dosing Recipe Chart sheet and copy the formatting of the last formatted row. Other than that, the dropdowns and everything else auto-populates with the new recipe.
19
Data & Calculations: This sheet has lots of calculations, data, formulas, and variables used throughout the entire Spreadsheet. Don't edit any of this unless you really know what you're doing!
20
21
Contact Information:
22
23
You can reach me on the Espresso Aficionados Discord @Chris, as well as Instagram @chrisabney. Feel free to reach out if you've got any questions, ideas for improvement, or to let me know I screwed something up or made a typo!
24
25
Links and Resources:
26
27
Espresso Aficionados Discord
28
Jonathan Gagné - Water for Coffee Extraction
29
The Espresso School - DIY Coffee Brew Water Calculators
30
Espresso Aficionados - Water
31
Barista Hustle - DIY Water Recipes Redux
32
33
Credit:
34
35
Sagebush on Espresso Aficionados Discord
36
David Seng / The Espresso School
37
Jonathan Gagné
38
Huge thanks to y'all for doing the hard math and science! This wouldn't be possible without you!
39
40
Release Notes:
41
42
v2.1 - (11/19/21) - Renamed "Joe D Water" to "Fams 20/80".
43
v2.0 - (11/18/21) - This was the second release. Inspired by Sagebush's easy to understand calculations I rewrote the entire spreadsheet. I removed David Seng and Jonathan Gagné's copied spreadsheets and created my own with Sagebrush's calculations. I also added more Hardness and Buffer solutions, as well as added a Custom Recipe creator. I also added the ability to use any water amount in both Liters and Gallons.
44
v1.0 - (11/17/21) - This was the first release. I heavily used and copied David Seng and Jonathan Gagné's spreadsheets to make the intial version.
45
46