cmdrico7812
Well-Known Member
So I'm attempting to do a few small 2-gallon all-grain batches. I've been doing PM 5 gallon batches for awhile now, but I don't have the equipment to go all-grain with high volume batches, so I want to do smaller AG batches on my stove top. To do so, I want to use the No Sparge method. I have How to Brew at home and have been researching the method extensively online.
Here is an explanation of the calculation I've been using: Skip the Sparge
I set up an excel sheet to do the calculations for me. From these calculations I input the following:
1. Calculated OG that I got from ProMash after entering the ingredients and scaling it to a 2 gallon batch, 1.078 (but enter it as just 78 per the instructions)
2. Total Grain Bill (5.7 pounds)
3. Recipe Volume (2 gallons)
4. Boil Volume (2.5 gallons, to account for evaporation during the boil)
From the calculation I need to get the following outputs:
1. Scale-up factor for the grain (so I calculate the new grain bill)
2. Volume of water to add for the mash
3. Volume of water to add during mash-out
(there are other outputs of the calculations but these are the three I need help with)
So when I input a recipe that I've calculated and scaled that has a relatively low OG, the results of the calculation seem to work out fine. However, when I try to enter the numbers as I've stated above (a high OG beer), I get a negative number for the volume of water to add during mash-out and I can't figure out why. Can someone help me with this, or does anyone have more experience with No Sparging than I?
Here is a link to the Excel file I'm using: NoSpargeCalculator
Can someone help me with these calculations? Thanks.
Here is an explanation of the calculation I've been using: Skip the Sparge
I set up an excel sheet to do the calculations for me. From these calculations I input the following:
1. Calculated OG that I got from ProMash after entering the ingredients and scaling it to a 2 gallon batch, 1.078 (but enter it as just 78 per the instructions)
2. Total Grain Bill (5.7 pounds)
3. Recipe Volume (2 gallons)
4. Boil Volume (2.5 gallons, to account for evaporation during the boil)
From the calculation I need to get the following outputs:
1. Scale-up factor for the grain (so I calculate the new grain bill)
2. Volume of water to add for the mash
3. Volume of water to add during mash-out
(there are other outputs of the calculations but these are the three I need help with)
So when I input a recipe that I've calculated and scaled that has a relatively low OG, the results of the calculation seem to work out fine. However, when I try to enter the numbers as I've stated above (a high OG beer), I get a negative number for the volume of water to add during mash-out and I can't figure out why. Can someone help me with this, or does anyone have more experience with No Sparging than I?
Here is a link to the Excel file I'm using: NoSpargeCalculator
Can someone help me with these calculations? Thanks.