Good topic

,
This was one of the messy areas we had to sort out for the BIABacus. You can see some of the problems and solutions in
this thread. The good news is that the powers that be have just given me an okay to post the following which is the result of the above thread and a lot more

.
BIABrewer Temporary Priming Calculator.xlsx
Note that this file should only be posted on BIABrewer for now.
The file is a cut and paste of some bits of the BIABAcus. (Note: The first two input cells will appear in the 'Fermentation and Conditioning' section of the BIABacus so don't get too used to this layout

).
[center]
How to Use[/center]
To determine the amount of priming sugar you should use, three questions require answering...
1. What temperature did you actively ferment the wort at?
One of the many things Yeasty mentioned in his excellent post above was temperature. Basically, the warmer the temperature, the less CO2 can be held in solution in the 'fermented wort'. Just keep your answer here simple. If the last few days of active fermentation were around 18C then type that in. If you did a diacetyl rest on a lager at 15 C for a few days, then type that in.
2. What Volumes of CO2 are Required for your beer style?
Please
do not distribute this style spreadsheet publicly. It is not finished so just use it as a temporary measure.
Temporary BIABrewer BJCP Guidelines.xlsx
Use the above temporary spreadsheet to determine what level of CO2 you should be priming at. (Far right of spreadsheet.)
3. Individual Bottling, Bulk Priming or Natural Keg Carbonation?
If you are priming bottles individually, type in your bottle capacity.
If you are bulk priming, type in the volume you transferred to your secondary fermentation vessel or bulk priming vessel.
If you are naturally carbonating a keg, type in the volume you were able to transfer to your keg.
[center]
The Logic[/center]
The formulas used here are the most advanced we could find and line up nicely with advanced, dedicated priming calculators. (Don't use primitive ones that don't take into account active fermentation temp!).
One thing I can't remember whether we ended up with a logical answer to in the other thread was why a naturally carbonated keg would require less 'sugar' than a bottle. Lots of things were discussed and I can't remember any one of them being a great answer. It's probably a combination of variables such as more surface area, continual pressure, etc. The formula adjustment we have used matches 'accepted' keg priming levels recommended by brewers here so whilst we don't fully understand the logic, all's good

.
You do not have the required permissions to view the files attached to this post.
If you have found
the above or anything else of value on BIABrewer.info, consider supporting us by
getting some BIPs!