Register Now!

Wine Making & Grape Growing Forum > Wine Making > Tutorials, Calculators, Wine Logs & Yeast Charts > Potential Alchohol and Sugar Additions


Help Support Winemaking Talk by donating using the link above or becoming a Supporting Member.
Reply
 
Thread Tools Search this Thread
Old 12-15-2016, 06:39 PM   #1
renegade66
Junior Member
 
Dec 2016
Posts: 12


A while back i made a spreadsheet that tracks the alcohol in my wine during fermentation as i enter SG readings along the way. This works great when i let a wine go to dry to the final SG readings and therefore the final alcohol.

I am trying to redo the spreadsheet to take into account sugar additions along the way in the fermentation but i am stuck at how the total alcohol is calculated.

Lets say i start with an OG of 1.080 and i let this ferment down to 1.024 which gives an Alcohol of about 7.00 percent. At this point i add enough grams of sugar to bring the SG back up to 1.080 and let it ferment back down to 1.00 what would the formula be for calculation of alcohol in this case.

In my original spreadsheet it work with no additions. i am dealing with a ginger wine i made with a OG of 1.100 but there were 3 additions of 500g of sugar along the way during fermentation. I took SG readings before and after each addition and the yeast died at 1.040 final SG. I know i cannot use 1.100 and 1.040 as the numbers to get total alcohol.

 
Reply With Quote
Old 12-15-2016, 06:55 PM   #2
Stressbaby
Just a Member
 
Stressbaby's Avatar
 
Aug 2012
Posts: 1,500
Liked 479 Times on 344 Posts
Likes Given: 258


It is proportionate to the total drop in SG.
1.080 -> 1.024 = 0.056.
1.080 -> 1.000 = 0.080.
0.080 + 0.056 = 0.136 -> 17.85% using ABV = (OG-FG)*131.25
__________________
http://relatitude.blogspot.com/

ffemt128 Likes This 
Reply With Quote
Old 12-16-2016, 04:34 PM   #3
sour_grapes
Victim of the Invasion of the Avatar Snatchers
 
sour_grapes's Avatar
 
Sep 2013
Posts: 6,830
Liked 3387 Times on 2143 Posts
Likes Given: 3697


The problem is that the VOLUME also changes when you add sugar. You need to calculate how much alcohol you had at each step (which you can get by ABV*volume). Then divide the total alcohol by the final volume. Alternately, you could just use Fermcalc.
__________________
Paul
Art should be like a holiday: something to give a man the opportunity to see things differently and to change his point of view. -Paul Klee, painter (1879-1940)
My "bucket list" (AKA, what I've made so far....)

 
Reply With Quote
Old 12-16-2016, 07:26 PM   #4
renegade66
Junior Member
 
Dec 2016
Posts: 12

Quote:
Originally Posted by sour_grapes View Post
The problem is that the VOLUME also changes when you add sugar. You need to calculate how much alcohol you had at each step (which you can get by ABV*volume). Then divide the total alcohol by the final volume. Alternately, you could just use Fermcalc.

I am adding in volume correction to my spreadsheet, slowly working out the required formulas. Since in my case i used sugar in grams, i am using 1kg of sugar is 0.63L in liquid volume. I downloaded Fermcalc and find it very useful. My spreadsheet is for tracking a fermentation with multiple daily readings that are graphed to show progress.

Likely too much info but i like all the data but its still a work in progress
Blackberry Merlot Data.png   Blackberry Merlot.png   data screen update.png  

 
Reply With Quote
Old 12-16-2016, 10:27 PM   #5
sour_grapes
Victim of the Invasion of the Avatar Snatchers
 
sour_grapes's Avatar
 
Sep 2013
Posts: 6,830
Liked 3387 Times on 2143 Posts
Likes Given: 3697


Looks very nice.

By the way, when I have included the change in volume, as referred to above, it has been a fairly small correction to the ABV. That is, IIRC, doing the calculation correctly changes the result only about 0.5% or less compared to the approximate method Stressbaby outlined above.
__________________
Paul
Art should be like a holiday: something to give a man the opportunity to see things differently and to change his point of view. -Paul Klee, painter (1879-1940)
My "bucket list" (AKA, what I've made so far....)

Johny99 Likes This 
Reply With Quote
Old 12-17-2016, 08:51 AM   #6
DoctorCAD
Senior Member
 
Jan 2012
Posts: 1,713
Liked 484 Times on 361 Posts
Likes Given: 11


Or you could just guess that your ABV is around 14% and call it a day.

Wine is a relaxing hobby, why complicate it...JMO.
__________________
Water, sugar and yeast does not make wine!
Just say no to hooch.

2
People Like This 
Reply With Quote
Old 12-17-2016, 09:30 AM   #7
renegade66
Junior Member
 
Dec 2016
Posts: 12

Quote:
Originally Posted by DoctorCAD View Post
Or you could just guess that your ABV is around 14% and call it a day.

Wine is a relaxing hobby, why complicate it...JMO.

Lol, this is my way of relaxing, I am an Electronic Engineer by trade The more sensors and readings the happier I am and the graphs i get allow
me to reproduce a batch when i want to without surprises.

 
Reply With Quote
Old 12-29-2016, 06:37 PM   #8
traveler94
Member
 
Oct 2016
Posts: 36
Liked 10 Times on 5 Posts
Likes Given: 7


Quote:
Originally Posted by renegade66 View Post
Lol, this is my way of relaxing, I am an Electronic Engineer by trade The more sensors and readings the happier I am and the graphs i get allow
me to reproduce a batch when i want to without surprises.
When I want to monitor my wine I take my turkey baster (wine thief) draw out an ounce from a carboy, sit in the silence and say to myself, what a wonderful thing.

4
People Like This 
Reply With Quote
Old 04-08-2017, 07:25 PM   #9
Graves
Junior Member
 
Oct 2016
Posts: 11
Liked 14 Times on 4 Posts


A friend told me he added 10 pounds of sugar to 5 gallon batchs of wine. How much yeast would that require?

 
Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads
Thread Thread Starter Wine Making Forum Replies Last Post
Potential alcohol & non-sugar Brix acorn Beginners Wine Making Forum 7 02-09-2015 03:29 PM
Maths for Sugar Additions iVivid General Wine Making Forum 4 11-21-2013 12:54 PM
So Without A Hydrometer Does More Sugar = More Alchohol? critterhunter Beginners Wine Making Forum 10 11-12-2010 05:32 PM
Too much alchohol? bittnerart Beginners Wine Making Forum 1 09-09-2008 08:13 PM
Other % of Alchohol????? MichaelZ Kit Winemaking 14 02-28-2007 06:33 PM


Forum Jump