Carbonation calculator

	A	B	D	E	G
1	To calculate the amount of sugar solution needed
2
3	Take these figures from Brewfather		enter your figures from Brewfather in the green cells
4	Sugar quantity	34.0 g
5	Bottling volume	5.7 L
6
7	Add an extra bottle or two if you like
8	Extra bottle	0.5 L	add a bit extra if needed
9
10	Dont fiddle with this bit
11	Concentration g/L	5.94 g/L	this is the concentration of sugar to wort
12
13	Use these figures to make your solution
14	Sugar req'd	37.0 g	add this amount of sugar to a measuing cylinder or similar
15	Top up water to	62.2 mL	top up with boiling water to this volume
16
17	The table below shows the solution required for any volume of bottle
18	You can change the bottle volumes to your own sizes and if you enter the quantity of bottles in the 'bottle' column it will work out the total volume you actually bottled.
19
20	Bottle volume	Sugar Solution	Bottle quantity	Volume
21	500 ml	5.00 ml		0 ml
22	330 ml	3.30 ml		0 ml
23	525 ml	5.25 ml	20	10500 ml	525ml is a brimmed 500ml bottle and
24	345 ml	3.45 ml	1	345 ml	345ml is a brimmed 330ml bottle
25	215 ml	2.15 ml		0 ml
26	100 ml	1.00 ml		0 ml
27
28			total volume	10.85 L
29
30
31
32
33
34
35
36
37
38
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