IBU Calculator Taylor.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Download this tool to customize any way that you like. In upper left, go to File, Download, Excel. Then play with it on your PC or device. Enjoy. ~ David M. Taylor
2
3	Taylor IBU Calculator v1.2 -- 2/11/2024				http://tinyurl.com/TaylorIBUCalculator
4								HopStand or Whirlpool
5		OG	1.062		FWH?	FALSE		HS Time	15		Final Volume	5
6
7	Sequential	oz or grams	Alpha	Boil Time	Boil Time Effective	Magic Factor	Taylor IBUs	Double-Check			oz & gallons	TRUE
8	1	0.38	10.7	60	64.5	3.44	14.0	14.0			grams & liters	FALSE
9	2	0.69	6.2	60	64.5	3.44	14.7	14.7
10	3	1.5	4.3	5	9.5	1.32	8.5	8.5
11	4	1.5	5.6	2	6.5	1.09	9.2	9.2
12	5				4.5	0.92	0.0	0.0
13	6				4.5	0.92	0.0	0.0
14	7				4.5	0.92	0.0	0.0
15	8				4.5	0.92	0.0	0.0
16	9				4.5	0.92	0.0	0.0
17	10				4.5	0.92	0.0	0.0
18	11				4.5	0.92	0.0	0.0
19	12				4.5	0.92	0.0	0.0
28					add an extra 0.9 because I said so		0.9
29					Total IBUs		47.4		BU:GU	0.76
30
31		Taylor Calculation, using Imperial (USA) units:
32
33			IBU = oz * AA% * sqrt[4.6(Boiltime+0.3Whirlpooltime,a.k.a.,HopStandtime)] / V
34
35			Where the times are in minutes, and the V is flameout volume in gallons.
36
37		Calculate for each hop addition, add them all together, and finally add an extra 0.9 for good measure (because I said so).
38
39
40		And in the UK and other places outside the USA that use SI units:
41
42			IBU = grams * AA% * sqrt[4.6(Boiltime+0.3Whirlpooltime,a.k.a.,HopStandtime)] / V / 7.5
43
44			Where the times are in minutes, and the V is flameout volume in liters.
45
46		Again, add together the results for each hop addition, then finally add 0.9 at the end (just because).
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
102
103
104
105
106
107
108