Wyrmwood
Well-Known Member
So I wrote this up to help me measure volumes, specifically strike and sparge water as well as pre boil and post boil volumes. Although I had measured out pre-defined depths, I wanted to be able to know specifically for a given volume, the height in a container and the opposite. Someone's probably done this before, but I thought I'd post it in case anyone found it useful. With a metal yardstick, I can find all my volumes.
For example, my trusty brew target software tells me I need 4.828 gallons of water for my initial infusion and 3.3 gallons for my sparge. So I enter the volume in the h for v row, for the column I've already entered my bucket dimensions, and it tells me I need to fill the bucket to 9 and 5/8 inches. Afterward, I fill the bucket to 6 and 13/16 inches for the sparge. Once I'm done sparging, I measure my pre boil volume at 10 9/16 inches in my kettle, so I plug that into v for h in the kettle row/column and get 6.59 gal. After the boil, I measure it at 8 and 1/2 inches and plug that into v for h for the kettle and get 5.21 gal. I also measured the displacement of my kettlescreen and temp guage, so I can correct for them.
The first tab is just using general numbers, the second tab is the same, only with the volumes rounded to the nearest 100th and the measurements rounded to the nearest 1/16th of an inch.
Don't type in the yellow boxes, those are the formulas and populate based on your input in the white boxes.
I'll add my cornies to this (once they are empty again...).
https://dl.dropbox.com/u/701389/beer/ContainerVolumesByDepth.xlsx
For example, my trusty brew target software tells me I need 4.828 gallons of water for my initial infusion and 3.3 gallons for my sparge. So I enter the volume in the h for v row, for the column I've already entered my bucket dimensions, and it tells me I need to fill the bucket to 9 and 5/8 inches. Afterward, I fill the bucket to 6 and 13/16 inches for the sparge. Once I'm done sparging, I measure my pre boil volume at 10 9/16 inches in my kettle, so I plug that into v for h in the kettle row/column and get 6.59 gal. After the boil, I measure it at 8 and 1/2 inches and plug that into v for h for the kettle and get 5.21 gal. I also measured the displacement of my kettlescreen and temp guage, so I can correct for them.
The first tab is just using general numbers, the second tab is the same, only with the volumes rounded to the nearest 100th and the measurements rounded to the nearest 1/16th of an inch.
Don't type in the yellow boxes, those are the formulas and populate based on your input in the white boxes.
I'll add my cornies to this (once they are empty again...).
https://dl.dropbox.com/u/701389/beer/ContainerVolumesByDepth.xlsx