German Brewing

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.

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

My fermentation's never see higher than 45f.

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.

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.

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

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.