Ok I'm just going to post the data I collected. I've included two charts which I think are the most interesting but you can obviously construct whatever you'd like from the data. I would have liked to overlay the two charts, but this doesn't seem possible with OpenOffice.
As per Hex's request, my methodology:
1 Welches white grape juice, with several inches of headspace plus sucrose (IG: 1.098, with an unmeasured combination of Hodgson Mill and Red Star active dry yeast. I assumed these yeasts to both be Saccharomyces cerevisiae, but possibly of different strains. This was done to try to improve the odds of getting an alcohol tolerant strain. Jug was left in room ~70F
The balloon was filled with water and then dumped into measuring cups and found to be almost exactly 1/2 cup or 115mL. The water probably stretched the balloon a bit, and some necking on the balloon would need to go around the mouth of the jug, so this was rounded down to 100mL. We're only looking for trend data here anyway.
When taking a CO2 reading, the balloon was pressed as flat as possible and allowed to inflate undisturbed. Time was called as soon the balloon stood upright. Two of these readings were taken, averaged, and then rounded to the nearest 5 seconds. The balloon method is too crude to assume anything more precise. This was done without moving the jug, making every effort not to jostle it which would release extra CO2, skewing the reading. Ambient temperature reading was taken at this time and used in the standard gas law equation to calculate mol CO2/sec: (n=(PV/RT))/sec
The jug was then moved to my bathroom sink area. Turkey baster, hydrometer, funnel and hydrometer testing tube are cleaned with antibacterial soap before every reading. Spinning or bobbing the hydrometer will remove bubbles from the hydrometer which can skew the reading. These Relative Density readings were used to calculate the ABV. The calculator at
Winemaking Conversion Calculators - grapestompers was used as well as a table included with the hydrometer. These compose our alcohol % and alternative alcohol % respectively. In comparing a few online calculators, it seems the table included with the hydrometer errs a little on the high side, while the online calculator, a bit to the conservative. It is a safe bet that the actual ABV lies somewhere between the two. Again though, we're really only looking at the trend data.
Without further ado the spreadsheet:
White Wine.xls
It's in .xls format. Let me know if there's any trouble, or if you'd like to know anything else I might have forgotten to mention here.
@HEX, I did take some photos, but I can't get them off my phone, it wont detect my microSD card, sorry. You're not missing out on anything you've not seen before, trust me.
