Bottle Spunding

[Big Monk]

I was speaking with Techbrau about building my lodo system and he brought up the topic of Bottle Spunding. I did some back of the envelope calcs really quick based on Kai's numbers and came up with the following:



The above shot is just the GBF paper Helles recipe in my spreadsheet.



The above shot shows the residual CO2.



Above is the equation assuming 78% AA and a peak temperature of 52F.

Any thoughts? Keep me honest if any of this seems off.

[Bryan R]

We are all at 82+% AA and my carbing happens at 40f. Otherwise nice work.

[Big Monk]

[Bryan R]

My fermentation's never see higher than 45f.

[Bryan R]

if you used an excel type spreadsheet, you could use your FFT test to determine your FG, and use that as the variable to determine transfer. Since transferring and spunding I find my FFt's to always be wicked close to my normal batches.

[Big Monk]

[Taswegian]

I've been brewing 25L batches (done four LoDO batches now) so I bottle some after the keg is filled. My method for the bottles:
- Use PET bottles (the brown ones that are made for beer)
- Get to know what proper carbonation feels like when you squeeze the bottle
- Bottle with about 1P of gravity left (enough to over-carbonate the beer)
- Check the bottles every day or two; loosen (then replace) the lid to release pressure if it's over-carbonated.
This works nicely, and from experience these bottles can handle WAY more carbonation than heavy glass bottles. It is a bit time consuming, but OK for small amounts of beer.

[Big Monk]

[Bryan R]

Did you pull the download of this? I would like to play with it. Thanks

[Big Monk]

Here is the correct link. I had some edits and didnt update the link:

https://drive.google.com/open?id=0B8F3C ... 2xjbXZoaU0

I need to comment it out a bit as some of the behind the scenes stuff that can be manipulated is not so obvious.

Just unhide the hidden sheets for the Data/Analysis pages.