Kettle Volume Spreadsheets

[jiesu]

So I have noticed a few of you brewers have some snazy little kettle volume spreadsheets in your brew house that basically
tell you the Liter-age of your brewpot at a certain cm depth of liquid. I am certainly not a Mathematical kind of guy and find it a struggle
on brew day to try and find the calculators online then convert between different units and such so I was wondering if one of you would be
able to share your formula laden spreadsheets with a fellow brewer. Provided It is easy for me to put my own kettle dimensions into the
spreadsheet.

Thanks Brewers!


Jake

 

[therook]

So I have noticed a few of you brewers have some snazy little kettle volume spreadsheets in your brew house that basically
tell you the Liter-age of your brewpot at a certain cm depth of liquid. I am certainly not a Mathematical kind of guy and find it a struggle
on brew day to try and find the calculators online then convert between different units and such so I was wondering if one of you would be
able to share your formula laden spreadsheets with a fellow brewer. Provided It is easy for me to put my own kettle dimensions into the
spreadsheet.

Thanks Brewers!


Jake

Jake, all i did was pour a litre at a time and take a measurement. Put this on a sheet of paper and use it as a reference on brew day....... to easy :icon_cheers:

Rook

 

[Screwtop]

If your kettle is a cylinder like mine and not a Keggle.

View attachment Kettle_Volumes_and_Printable_Chart.xlsx

Input your values, sheet 2 has a printable chart for use in the brewery using a ss ruler as a dipstick

Screwy

 

[Gulf]

For a cylinder:

V = R²h

Where V is volume, is Pi (3.142), R is the radius of your pot (internal diameter divide 2) and h is the height.
So if you measure your kettle's internal diameter (and divide it by two to get its radius) and the depth of the liquid (height) you can determine the volume of liquid you have.
Alternatively, you can re-arrange the equation to give the depth (height) for a given volume:

h = V/R²

What I did was calculate h for 5 Litres, and mark increments of that on my mash paddle to give 5, 10, 15, 20... 60L marks. I can then use my mash paddle as a dipstick to get an idea of volume in the kettle.

Note: Units are important! Litres are equal to cubic decimetres (10cmx10cmx10cm), so if you want V to be in Litres, you'll need to make your height measurements in decimetres (1dm=10cm=100mm).

 

[MarkBastard]

Don't forget hot water expands.

 

[Frank]

Here's mine:
View attachment AHB_Kettle_volume.xlsx
Just change the diameter of your pot in the shaded square, then use a SS ruler like Screwtop on brew day.

 

[jiesu]

AHHH beautiful gents thankyou very much exactly what i needed Happy Brewing!