KS/SNB BIG IPL

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1

2	The 2-Row Malt on this Spreadsheet Last Updated On
3
4	Target Beer Style		Scott's IPL		Dia. inches of Kettle		100	2.54	meters
5	Target Beer Gravity		19.5	plato	Inches at Pre-boil		42	1.0668	meters
6	Target Beer Color		11	SRM	Inches at End of Boil		42	1.0668	meters
7	Target Beer Bitter		80	IBU	Liters at Boil Start		5405.555388
8	Barrels at End of Boil		44.22183202		Liters at End of Boil		5405.555388
9
10	Grist Profile		Extract	SRM	Kilograms	Pounds	% of total	Extract	SRM
11	Malt Type		kg per liter	Per Liter	To Use	To Use	grist bill	Donation	Donation
12						58.18181818
13	2-row		81	1.8	1451.495584	3200	86.25%	21.75005783	4.033610321
14	Carapils		77.5	1.5	45.359237	100	2.7%	0.650320016	0.105041935
15	Crystal 15L		78	15	90.718474	200	5.39%	1.309031258	2.100838709
16	Caramunich III		74.4	58	0	0	0%	0	0
17	Caramel 40		82.9	40	0	0	0%	0	0
18	Caramel 60		78.2	60	0	0	0%	0	0
19	Caramel 80		74.4	80	0	0	0%	0	0
20	Victory		73	28	90.718474	200	5.39%	1.225118998	3.921565589
21	Brown Rice DME		75	2	4.5359237	10	0.27%	0.062934195	0.014005591	= was 10%
22	Black Malt		25	450	0	0	0%	0	0
23	Rolled Oats		60	1.5	0	0	0%	0	0
24	Malted Rye		60	3.5	0	0	0%	0	0
25	G.W. Lt. Peated Malt		82.1	4	0	0	0%	0	0
26			Total Weight of Grist>		1682.827693	3768.181818		24.9974623	10.17506215
27					Brewhouse Efficiency Percentage ==>			78.00%
28					Anticipated Gravity After Brewhouse Yield ==>			19.5
29	Hop Profile
30	Hop Additions ==>		Bittering	Bittering	Middle	Aroma	Aroma	DRY-HOP	DRY-HOP		Bittering		Middle	Aroma	Aroma	DRY-HOP	DRY-HOP
31	Hop Variety:		Columbus	simcoe	Centennial	simcoe	Centennial	Amarillo	Cascade		Columbus		Centennial	simcoe	Centennial	Amarillo	Cascade
32	Weight in Pounds		8.8		3.9	5	8.6	5.5	5.5		140		61.78	80	137.88	88	88
33	Weight in Grams:		2307.108574	2013.99232	1755.050451	1476.927702	3917.069122	Simcoe	Columbus							Simcoe	Columbus
34	% Alpha Acids:		14.2	12.2	15.4	12.2	9.2	6	6							96	96
35	% Utilization:		33	33	30	30	30	^ Increase to 8.4
36	Liters at End of Boil:		5405.555388	5405.555388	5405.555388	5405.555388	5405.555388				Bittering	Middle	Aroma	Aroma	DRY-HOP	DRY-HOP
37	Bittering Units		20	15	15	10	20	Quick Utility Chart:			Columbus	Centennial	simcoe	Centennial	Amarillo	Cascade	Simcoe	Columbus
38			3.75					90 mins =	30%		0.11	0.05	0.06	0.11	0.07	0.07	0.08	0.08
39	IBU Total:	80						60 mins =	20%
40								30 mins =	12%
41								15 mins =	8%
42	Mashing Specifics							End boil =	5%
43	142 mash temp		150 rest		3 to 1 liquor to grist ratio			2-hour conversion			Bittering	Bittering	Middle	Middle	Aroma	Aroma	DRY-HOP	DRY-HOP
44											Columbus	simcoe	Centennial	simcoe	Columbus	Centennial	Columbus	Cascade
45	Brewing Specifics										0.7	0.7	0.75	0.75	0.75	0.75	1	1
46	100-minute boil time																Amarillo	Simcoe
47																	1	1
48	Fermenting Specifics
49	yeast type	house		58 ferm temp		a.e.3.1
50											Bittering	Bittering	Middle	Middle	Aroma	Aroma	DRY-HOP	DRY-HOP	DRY-HOP 2	DRY-HOP 2
51											Columbus	simcoe	Centennial	simcoe	Columbus	Centennial	Columbus	Cascade	Amarillo	Simcoe
52											0.14	0.14	0.15	0.15	0.15	0.15	0.2	0.2	0.2	0.2
53
54
55
56											Karl Strauss				SNB Brewing
57											Use	Type	Oz per Gallon		Use	Type	Oz per Gallon
58											Bittering	Columbus	0.11		Bittering	Columbus	0.14
59											Middle	Centennial	0.05		Bittering	simcoe	0.14
60											Aroma	simcoe	0.06		Middle	Centennial	0.15
61											Aroma	Centennial	0.11		Middle	simcoe	0.15
62											DRY-HOP	Amarillo	0.07		Aroma	Columbus	0.15
63											DRY-HOP	Cascade	0.07		Aroma	Centennial	0.15
64											DRY-HOP	Simcoe	0.08		DRY-HOP	Columbus	0.2
65											DRY-HOP	Columbus	0.08		DRY-HOP	Cascade	0.2
66															DRY-HOP 2	Amarillo	0.2
67															DRY-HOP 2	Simcoe	0.2
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