ABCDEFGHIJKLMNOPQRSTUVW
1
2
Inputs (enter these)
3
Sample Brix (Bxf)8.4
4
Reported ABV0.078
5
Refrac Correction Factor1.04
6
7
Cacluations: Use solver or manually adjust cell C8 to minimize cell D8
8
Estimated OG in Brix uncorrected17.80.00
9
RIi (corrected Bxi)17.1
10
Rlf (corrected Bxf)8.1
11
12
Results
13
OG1.070
14
FG1.014
15
17
ABW from ABV & calc FG6.11%
18
ABW from Bxf and est Bxi6.11%
19
square of difference for solver0.00
20
21
Per 12 Fluid Ounces
22
Alcohol Calories153
23
Carb Calories84
24
Total Calories238
25
Carbohydrate Grams21
26
27
Sean Terrill's Linear FG Equation
28
FG = 1.0000 – 0.00085683*RIi + 0.0034941*RIf
29
STL coef 1-0.00085683
30
STL coef 20.0034941
31
32
ABW from Rli and Rlf published equation
33
ABW = 0.67062*Rli - 0.66091*Rlf +1.00
34
35
OG calculation from Brewer's Friend attributed to BYO, same equation used in Sean Terrill's spreadsheet
36
SG = (Brix / (258.6-((Brix / 258.2)*227.1))) + 1
37
38
ABV = (ABW * (FG / .794) )
39
40
Beersmith equation per 12 oz
41
Calories From Alcohol
42
= 1881.22 * Final_Gravity * (Original_Gravity – Final_Gravity)/(1.775 – Original_Gravity)
43
Calories From Carbohydrates
44
= 3550 * Final_Gravity * ((0.1808 * Original_Gravity) + (0.8192 * Final_Gravity) – 1.0004)
45
Total Calories
46
= Calories_From_Alcohol + Calories_From_Carbohydrates
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
101