PDA

View Full Version : Free online tool - Electric Brewing Percent Setting Worksheet



StoutTanks
10-19-2016, 04:26 PM
Hi friends,
Just wanted to share with you a free tool we launched on our website. We built an excel calculator that can help you more precisely target your end volume by adjusting the percentage on your heating element.

http://conical-fermenter.com/Electric-Brewing-Percent-Setting-Worksheet.html

Hope you enjoy and we would love to hear your comments!

NS_Nano
10-26-2016, 11:03 AM
Thanks for posting this, but I am a little confused. The evaporation rate be strongly affected by kettle diameter, right? Does this assume a specific Stout tank?

StoutTanks
10-26-2016, 03:52 PM
Hi NSNano,

There are many factors that affect evaporation rate. We are assuming that the kettle will be able to successfully vent the steam generated by the boil. So, the evaporation rate is a calculation of the btu's that are input to the kettle, knowing how many btu's it takes to evaporate water. We recognize that different kettles will behave differently, but this ought to get you in the right ballpark if you are trying to evaporate a a certain amount of wort.

When I am brewing, I re-check the volume as the boil progresses and I tweak the power level to hit my desired ending volume.

In summary, it's a good tool to help you figure out how to set your electric element heating levels to achieve a desired evaporation rate and/or volume of wort to boil off. With use, you may very well determine that your kettle behaves a certain way, and you need to adjust the %'s up or down to get the desired results.

ChrisDino
12-03-2017, 06:13 AM
Try the tool for FREE
I like your tool, seems very useful. We have Stout BBT and various equipment. Any chance you would allow the % boil off rate to be variable (so it can be changed by the user)?

StoutTanks
12-04-2017, 12:21 PM
I like your tool, seems very useful. We have Stout BBT and various equipment. Any chance you would allow the % boil off rate to be variable (so it can be changed by the user)?

Hi Chris,

That's a great idea! We've updated the spreadsheet so you can now enter your own evaporation rate as a % and it will tell you the gallons/hr.

If you are not seeing the change when you download the spreadsheet, try again either in a private browser window or after clearing your cache.

Cheers,

John/Stout Tanks and Kettles, LLC
Portland, OR
support@stouttanks.com
503-372-9580

Silva
01-23-2018, 07:19 PM
Very nice tool. How about to show an example? Just to make it clear.

Best regards.

Wanson

madcowbrewing
07-11-2018, 01:59 PM
Shouldn't the Batch size be pre boil volume? Or does the spreadsheet calculate that?

StoutTanks
07-16-2018, 02:57 PM
Shouldn't the Batch size be pre boil volume? Or does the spreadsheet calculate that?

Hi Jason,

Thanks for the great question!

The spreadsheet does account for that. If you put in a 93 gallon batch size and 8% evaporation rate, it gives you an 8.1 gallons/hr evaporation. 8.1 gal + 93 gal. = 101.1 gallons. And 101.1 * 8% = 8.1 gallons.

Cheers,

John/Stout Tanks and Kettles, LLC
Portland, Oregon
stouttanks.com
503-372-9580

StoutTanks
07-23-2018, 03:09 PM
Free tool to help you make the best beer for 2018! We also offer plenty of brewing support. Give Stout Tanks and Kettles a call at 503-372-9580 and check out the launch of our new website. https://conical-fermenter.com/

StoutTanks
08-16-2018, 02:16 PM
Bump it now