partigyle4.xls


.		Volume	% of Volume
.	Beer1 Quad or Tripel	5	66.67%	2/3	Shows that this is a standard 2/3 & 1/3 partigyle split
.	Beer2 Dubbel	2.5	33.33%	1/3
.	Total	7.5	100.00%
.
.	Quad-Target Recipe
.	Target Kettle Volume	7
.		Weight	PPG	OG	PPG*#	%
.	Belgian Pale	12	37.000	63.429	444	61.60%
.	Belgian Munich	2	38.000	10.857	76	10.54%
.	Belgian CaraMunich	1.25	33.000	5.893	41.25	5.72%	What we would brew stand alone
.	Belgian Special B	2.25	30.000	9.643	67.5	9.37%
.	Total	17.5	We don't include these points in our mash calculations
.	Belgian Candi	2	46.000	13.143	92	12.76%
.	Total Points			90	720.75	100.00%
.	Total OG Potential			1.090
.	Mash @ 60% efficiency		Points	54
.	Mash @ 75% efficiency		Points	67
.	Mash @ 70% efficiency		Points	63
.	Actual Points		Pre	67	Post	94


.	Actual OG Estimate		Pre	1.067	Post	1.094
.
.	Tripel-Target Recipe
.	Target Kettle Volume	7
.		Weight	PPG	OG	PPG*#	%
.	Belgian Pale	18	37.000	95.143	666	88.80%
.			We don't include these points in our mash calculations				What we would brew stand alone
.	Turbinado Sugar	2	42.000	12.000	84	11.20%
.	Total Points			95	750	100.00%
.	Total OG			1.095
.	Mash @ 60% efficiency			57
.	Mash @ 75% efficiency			71
.	Mash @ 70% efficiency			67
.	Actual Points			69	Post	97
.	Actual OG Estimate			1.069	Post	1.097
.
.	Assume 60% Efficiency for Both
.		OG	Plato	Volume	Vol X Plato	Combined Plato	Combined OG
.	Quad Mash	1.054	42.6	7.000	298.200
.	½ Dubbel	1.043	44.6	3.500	156.100			How much sugars do we need from each tun?


.	Totals			10.500		43.267	1.050
.	Tripel Mash	1.057	42.1	7.000	294.700
.	½ Dubbel	1.043	44.6	3.500	156.100
.	Totals			10.500		42.933	1.053
.
.	So for the Quad, we need 10.5 gallons of 1.050 wort			Points=	50
.	So for the Tripel, we need 10.5 gallons of 1.053 wort			Points=	53			1+FG=(OG-1)*(1-att)
.
.								1.048 og	Attenuation widget Eqs
.								75 att
.								1.012 FG
.
.	Quad-Adjusted
.	Target Kettle Volume	10.5
.		Weight	PPG	OG	PPG*#	%
.	Belgian Pale	15	37.000	52.857	555	58.51%
.	Belgian Munich	3	38.000	10.857	114	12.02%
.	Belgian CaraMunich	2.5	33.000	7.857	82.5	8.70%
.	Belgian Special B	3.5	30.000	10.000	105	11.07%
.	Belgian Candi	2	46.000	8.762	92	9.70%


.	Total Points	(no sugars)		82	948.5			1.081	Og
.	Total OG			1.082				0.081		Attenuation widget
.	Target			50				0.750	Att
.	Mash @ 60% efficiency			49	Close enough, maxed #			0.250
.	Add in sugars, Total points			58				0.020
.	OG after boil=	81
.	SG	1.081	FG	1.020	ABV	7.93030333333334	The recipe adjusted to give us sugars for 1.5 beers.
.
.	Tripel-Adjusted
.	Target Kettle Volume	10.5
.		Weight	PPG	OG	PPG*#	%
.	Belgian Pale	23	37.000	81.048	851	91.02%
.	Turbinado Sugar	2	42.000	8.000	84	8.98%
.	Total Points	(no sugars)		81	935	100.00%		1.079	Og
.	Total OG			1.081				0.079		Attenuation widget
.	Target			49				0.750	Att
.	Mash @ 60% efficiency			49				0.250
.	Add in sugars, Total points			57				0.020
.	Og After boil=	79
.	SG	1.079	FG	1.020	ABV	7.79843000000001	The recipe adjusted to give us sugars for 1.5 beers.


.
.	Dubbel
.	Target Kettle Volume	7
.		Weight	PPG	OG	PPG*#	%
.	Points from Gyle	8.1	37	42.814	299.7	89.41%
.	Belgian Aromatic	0.5	36.000	2.571	18	5.37%		1.076	Og
.	Belgian Biscuit	0.5	35.000	2.500	17.5	5.22%		0.076		Attenuation widget
.	Belgian Candi	1	46.000	6.571	46	13.72%		0.750	Att
.	Total Points	(yes sugars)		54.457	335.2	100.00%		0.250
.	Total OG			1.054				0.019
.	OG after boil=	76
.	SG	1.076	FG	1.019	ABV	7.4146	The resulting Dubble recipe
.
.
.	This is just fiddling with the sugars to boost ABV if we want
.	We can adjust the Quad with more sugar as it is less than 10% above.
.	Quad-Adjusted
.	Target Kettle Volume	10.5
.		Weight	PPG	OG	PPG*#	%
.	Belgian Pale	15	37.000	52.857	555	54.55%


.	Belgian Munich	3	38.000	10.857	114	11.20%
.	Belgian CaraMunich	2.5	33.000	7.857	82.5	8.11%
.	Belgian Special B	3.5	30.000	10.000	105	10.32%
.	Belgian Candi	3.5	46.000	15.333	161	15.82%
.	Total Points	(no sugars)		82	1017.5	100.00%	1.090	Og
.	Total OG			1.082			0.090		Attenuation widget
.	Target			50			0.750	Att
.	Mash @ 60% efficiency			49	Close enough, maxed #		0.250
.	Add in sugars, Total points			64			0.023
.	OG after boil=	90
.	SG	1.090	FG	1.023	ABV	8.84075333333334
.
.	We can adjust the Tripel with more sugar as it is less than 10% above.
.	Tripel-Adjusted
.	Target Kettle Volume	10.5
.		Weight	PPG	OG	PPG*#	%
.	Belgian Pale	23	37.000	81.048	851	85.27%
.	Turbinado Sugar	3.5	42.000	14.000	147	14.73%
.	Total Points	(no sugars)		81	998	100.00%	1.088	Og
.	Total OG			1.081			0.088		Attenuation widget


.	Target			49			0.750	Att
.	Mash @ 60% efficiency			49			0.250
.	Add in sugars, Total points			63			0.022
.	Og After boil=	88
.	SG	1.088	FG	1.022	ABV	8.60408
.	It looks like our tuns are our limits on getting three really big beers. We can go with these beers I think though, and hope we get even better efficiency and/or attenuation.