Keg Volume Calculator

[Norselord]

Not a problem - i am halfway to developing my own. It's not like Henry's law is a secret. Have the temperature compensated Henry's law coefficient as it relates to the Van'tHoff equations programmed in already. I'll run as an independent test of yours.

Scratch that - ill base it off of this:
https://www.researchgate.net/publication/277688911_Carbon_Dioxide_Solubility_in_Beer

 

[kaljade]

Not a problem - i am halfway to developing my own. It's not like Henry's law is a secret. Have the temperature compensated Henry's law coefficient as it relates to the Van'tHoff equations programmed in already. I'll run as an independent test of yours.

Read the carbonation calculator thread and you'll discover as I did that beer doesn't behave the same as water so your equation will have an error margin of about 5% at SG 1.015.

My calculator has been thoroughly tested by users on this site and it's about as accurate as it needs to be considering the accuracy of domestic scales and CO2 regulators. Good luck on your journey.

Cheers,

Kal

 

[Norselord]

Read the carbonation calculator thread and you'll discover as I did that beer doesn't behave the same as water so your equation will have an error margin of about 5% at SG 1.015.

My calculator has been thoroughly tested by users on this site and it's about as accurate as it needs to be considering the accuracy of domestic scales and CO2 regulators. Good luck on your journey.

Cheers,

Kal

an error of 5% is acceptable. Dialing in my pressure gauge to 10 or 10.5 or 20 or 21PSI is beyond the accuracy of my gauge.

 

[kaljade]

While working on incorporating this functionality into RPints, I discovered an error in one of the cells that calculates the weight of dissolved CO2 (so only slightly impacts it which is why I never noticed it before). I've fixed it now and uploaded a new version. Apologies for any inaccuracy caused.

Cheers,

Kal

I just thought, if you follow the link in this previous post and download the files, the formulas you want will be in the tap_form.php file (the ugly jQuery at the bottom of the file). I've put comments next to each of them so you should be able to get what you need from there.

Good luck on your quest!

Cheers,

Kal

 

[jbschuyler]

Hi all,

This is my second thread as thanks to the assistance of the amazing ajdelange in my first thread I was finally able to add the finishing touches to my long neglected Keg Volume Calculator (be advised that the Carbonation Calculator in my first thread is still very much a work in progress but for all intents and purposes here it is accurate enough).

If you just want the spreadsheet rather than reading on you can download my Keg Volume Calculator here.

Hey Kal,

Has your link to the Keg Volume Calculator changed or moved? I got a Google error when trying to access. Let me know. Thanks!

 

[cactusgarrett]

Ditto. I'd let to give this a shot if it's still alive.

 

[day_trippr]

[copied from my post on another thread]

We haven't heard from @kaljade since this past March, unfortunately, so no way to track down where he stashed the distributable copy.

That said, I have a prior version that has been working quite nicely, but it's not the same MD5 version as what is listed in the thread I linked.
My version was generated in Jan 9, 2019, which if you review the thread above you'll see where it likely fits with the changes. For sure, no major errors are extant - I use this all the time I with my sf800 meters rarely have more than a half pour error when a keg kicks (or should have). Lately it's really been within 3 to 4 ounces.

As Kal set me up with his program at the very beginning I don't think he'd be upset if I parked a copy of what I have on my Google Drive.

Let me know if the link doesn't work. Since Windows 10 and Google Drive have been mucking about there's a decent chance I bodged the link

https://drive.google.com/file/d/1bdULrHg0cYUK0Z0v64iQap8esF7XULTv/view?usp=sharing

Cheers!

 

[jbschuyler]

Thanks, @day_trippr!! Just downloaded and will give it a try!

 

[MaxStout]

Downloaded, Excel sheet works fine. Thanks, @day_trippr

 

[lakemeranbrewing]

Hi all,

This is my second thread as thanks to the assistance of the amazing ajdelange in my first thread I was finally able to add the finishing touches to my long neglected Keg Volume Calculator (be advised that the Carbonation Calculator in my first thread is still very much a work in progress but for all intents and purposes here it is accurate enough).

If you just want the spreadsheet rather than reading on you can download my Keg Volume Calculator here.

Otherwise, once again, thanks for stopping by!

So my journey began here on HomeBrewTalk.com in the RaspberryPints - Digital Taplist Solution thread (which I invite everyone who hasn't already seen it to take a look), which now that I have set up is absolutely fabulous for tracking keg volume under normal circumstances (if you start with a completely full keg and you have no phantom pours, premature kicks, etc), but what happens when circumstances go outside of the norm? Well you can join the rest of the planet that do not have flow meters on their kegs, or you can use the new and improved Keg Volume Calculator.

So the base formula comes from a post in the RaspberryPints thread by DrunkleJon:



So armed with that I just expanded it to include a VLOOKUP table to allow for water density changes according to temperature, so all you needed to do was weigh your keg (before and after), enter in the temperature and final gravity and it would do the rest. The only caveat was of course that it was based on the pressure being a standard atmosphere (pretty big caveat if you've read my first thread).

Enter version two: "to allow for pressure/altitude (not that it makes a huge difference on the volumes we are using, but for the sake of accuracy, scalability and to satisfy my inner pedant), and also to select between metric and imperial units.", so now we were getting closer with the exception of Henry's Law of course:



So the final piece in the puzzle was being able to allow for the weight of the dissolved CO2, which began an entirely new journey of incorrect assumptions, followed by the patient guidance of ajdelange (further details in the other thread so I won't bore you all with the details again), which brings me here.

So in a nutshell here's how it works:

• Calculate the weight of the beer less the keg
• Calculate the volume of pure water at the same weight and temperature
• Adjust based on absolute pressure: gauge pressure (at equilibrium) plus barometric pressure
• Adjust the volume based on the gravity of the beer
• Calculate the weight of CO2 dissolved in the beer
• Adjust the volume based on the weight of the dissolved CO2

Simple enough, so how do I use it?

1. Enter your measurements in column B
2. Select you units of measurement from the dropdowns in column C (see screenshot)
3. Note: Gauge pressure is only required if it is already force carbonated, if it's a new keg ensure row 6 is set to 0 psi/kPa

So, good people, please road test it for me and let me know if it is of value or not, and any suggestions/corrections/criticisms are always welcome.

More information on the above can be located at the following links:

Better Carbonation Calculator (hopefully) thread

[Version 2 Release] RaspberryPints - Digital Taplist Solution thread

Mass, Weight, Density or Specific Gravity of Water at Various Temperatures

http://www.wetnewf.org/pdfs/Brewing_articles/CO2 Volumes.pdf

Keg Volume Calculator

Hey, I know this is 7 years ago, but the keg volume calculator link doesn't seem to be working anymore. I would love access to this spreadsheet if it was still out there somewhere! Cheers for your work on this!

 

[Chorgey]

Hey, I know this is 7 years ago, but the keg volume calculator link doesn't seem to be working anymore. I would love access to this spreadsheet if it was still out there somewhere! Cheers for your work on this!

PM Sent

 

[kaljade]

Hey all, I've been keeping a fairly low profile for a bit as I had some unforeseen circumstances that put brewing on the back burner for a bit, thanks to @day_trippr for sharing the version you had (and no I definitely don't mind).
Unfortunately Google changed the policy on share links so all the old links broke but I can't update the old posts with the new links. Here's the new link for anyone who wants it: Keg Volume Calculator (this one hopefully won't break in the future, but when it comes to Google anything is possible).
Cheers,
Kal

 

[bracconiere]

i always thought the saying was a pint's a pound world round?

 

[kaljade]

The final version of this spreadsheet (dated 8/1/2019), is located here:
Not sure if it's the same version as the one @day_trippr has on his drive, but no further development has/will likely be done to it.

Cheers,

Kal

 

[day_trippr]

Hey Kal! Thanks for popping by.
The copy on my Google drive is the same.

Cheers!