I have been working on a spreadsheet for recipe planning using the GotMead Calculator. I am a bit math challenged (but I do use hydrometer) and thought if I could get my recipes in the "ballpark" it would be easier. If something is too dry I can back sweeten. If something is too sweet I can dilute but then may lose the body. I have the starting and target SG noted for each.
Is my logic on track? Is there any reason why this could not then be quickly and easily adjusted for 1 - 3 - 5 gallon batches? Basically I am holding the fruit constant and changing the amount of honey for dry, medium and sweet. Then to do a 3 or a 5 gallon batch I would just multiple the one gallon numbers.
I am unable to insert the table or jpeg. The first number is pounds of honey. The second number is pounds of fruit. So blackberry dry is 2 pounds honey and 3 pounds of fruit. I rounded up the GotMead calculator number for the fruit. I use Vinter's Fruit Bases so the fruit would be pretty constant
Dry
Flavor Honey Water Fruit Base
Traditional 2.5
Blackberry 2 3 lbs
Blueberry 2 3 lbs
Cherry 2 3 lbs
Cranberry 2 3 lbs
Eldeberry 2 4 lbs
Mulberry 2 3 lbs
Rasberry 2 5 lbs
Strawberry 2 4 lbs
Grape 2 2 lbs
Raisen 2 3 lbs
Peach 2 3 lbs
Plum 2 3 lbs
Og 1.035-1.080
ABV 3.5-7.5
FG (perception) .990-1.010
Medium
Flavor Honey Water Fruit Base
Traditional 3
Blackberry 2.5 3 lbs
Blueberry 2.5 3 lbs
Cherry 2.5 3 lbs
Cranberry 2.5 3 lbs
Eldeberry 2.5 4 lbs
Mulberry 2.5 3 lbs
Rasberry 2.5 5 lbs
Strawberry 2.5 4 lbs
Grape 2.5 2 lbs
Raisen 2.5 3 lbs
Peach 2.5 3 lbs
Plum 2.5 3 lbs
Og 1.080-1.120
ABV 7.5-14
FG (perception) 1.010-1.025
Sweet
Flavor Honey Water Fruit Base
Traditional 3.5
Blackberry 3 3 lbs
Blueberry 3 3 lbs
Cherry 3 3 lbs
Cranberry 3 3 lbs
Eldeberry 3 4 lbs
Mulberry 3 3 lbs
Rasberry 3 5 lbs
Strawberry 3 4 lbs
Grape 3 2 lbs
Raisen 3 3 lbs
Peach 3 3 lbs
Plum 3 3 lbs
Og 1.120-1.170
ABV 14-18
FG (perception) 1.025-1.050
Not sure what this will look like with I submit.
Thank for taking a minute to look.
Is my logic on track? Is there any reason why this could not then be quickly and easily adjusted for 1 - 3 - 5 gallon batches? Basically I am holding the fruit constant and changing the amount of honey for dry, medium and sweet. Then to do a 3 or a 5 gallon batch I would just multiple the one gallon numbers.
I am unable to insert the table or jpeg. The first number is pounds of honey. The second number is pounds of fruit. So blackberry dry is 2 pounds honey and 3 pounds of fruit. I rounded up the GotMead calculator number for the fruit. I use Vinter's Fruit Bases so the fruit would be pretty constant
Dry
Flavor Honey Water Fruit Base
Traditional 2.5
Blackberry 2 3 lbs
Blueberry 2 3 lbs
Cherry 2 3 lbs
Cranberry 2 3 lbs
Eldeberry 2 4 lbs
Mulberry 2 3 lbs
Rasberry 2 5 lbs
Strawberry 2 4 lbs
Grape 2 2 lbs
Raisen 2 3 lbs
Peach 2 3 lbs
Plum 2 3 lbs
Og 1.035-1.080
ABV 3.5-7.5
FG (perception) .990-1.010
Medium
Flavor Honey Water Fruit Base
Traditional 3
Blackberry 2.5 3 lbs
Blueberry 2.5 3 lbs
Cherry 2.5 3 lbs
Cranberry 2.5 3 lbs
Eldeberry 2.5 4 lbs
Mulberry 2.5 3 lbs
Rasberry 2.5 5 lbs
Strawberry 2.5 4 lbs
Grape 2.5 2 lbs
Raisen 2.5 3 lbs
Peach 2.5 3 lbs
Plum 2.5 3 lbs
Og 1.080-1.120
ABV 7.5-14
FG (perception) 1.010-1.025
Sweet
Flavor Honey Water Fruit Base
Traditional 3.5
Blackberry 3 3 lbs
Blueberry 3 3 lbs
Cherry 3 3 lbs
Cranberry 3 3 lbs
Eldeberry 3 4 lbs
Mulberry 3 3 lbs
Rasberry 3 5 lbs
Strawberry 3 4 lbs
Grape 3 2 lbs
Raisen 3 3 lbs
Peach 3 3 lbs
Plum 3 3 lbs
Og 1.120-1.170
ABV 14-18
FG (perception) 1.025-1.050
Not sure what this will look like with I submit.
Thank for taking a minute to look.