(another) free brewing calculator :)

[erockomania]

Dahk Brewing Calc 2.0.1.xlsx


Hi guys, this is my latest excel sheet. I guess it's not doing it any justice to call it a brew calc as it's more of a planner.

I have all the stuff I normally use when brewing on here. It has your typical stuff like IBUs, ABV, SRM, etc... but it also has a batch size calc (upscale and downsize your batches based on your original recipe), evaporation rate calc, strike water calc, malt extract calcs, drop down menus for all hops and grain varieties, auto-filling stats, and other useful things. I use it for every all grain or extract batch I do and my numbers usually jibe pretty well. I figured some of you might get some use out of it as well. Most formulas and info are from either the Wiki here on site or Designing Great Beers.

 

[Sheldon]

Links says its no longer active.

 

[erockomania]

Sorry. It seems some of the free file storage sites are a racket. Try now

 

[Sheldon]

works now, will download later and play with it. thanks

 

[Heckle]

free storage sites that are easy to use.

www.megaupload.com
www.fileserve.com
www.hotfile.com
www.rapidshare.com

 

[cheezydemon3]

Very cool!

Thanks.

 

[erockomania]

free storage sites that are easy to use.

www.megaupload.com
www.fileserve.com
www.hotfile.com
www.rapidshare.com

Thank you!

FILESERVE - Dahk Brewing Calc 1.5.xlsx File size: 62.24 KB
HOTFILE - Dahk_Brewing_Calc_1.5.xlsx.html

 

[erockomania]

Very cool!

Thanks.

Thanks! I hope you can get some use out of it!

 

[Sudtirol]

I'll give it a try thanks!

 

[erockomania]

I'll give it a try thanks!

Cool, let me know what you think!

 

[worstbrewing]

Hey, I've uploaded this file to my own server for easy downloads, hope this helps! Let me know if you update it and I can be sure to update the copy available.
File: http://www.worstbrewing.com/useful/Dahk_Brewing_Calc_1.5.zip

 

[erockomania]

Hey, I've uploaded this file to my own server for easy downloads, hope this helps! Let me know if you update it and I can be sure to update the copy available.
File: http://www.worstbrewing.com/useful/Dahk_Brewing_Calc_1.5.zip

Very cool, thanks man! I've updated the file to version 1.6 with significant additions.

New File here:
Dahk Brewing Calc 1.6.xlsx

 

[worstbrewing]

Now serving at http://www.worstbrewing.com/useful/Dahk_Brewing_Calc_1.6.zip
Enjoy!

 

[erockomania]

Thanks, worstbrewing, for putting this on your server. Very cool of you!

 

[worstbrewing]

No problem! I know it can be a pain dealing with some of the free options out there, but I end up putting these on there anyway so I can access them when I'm not at my PC, I figure I may as well share! If there are other small tools, etc anyone wants hosted, let me know. I don't get much traffic so I have plenty of bandwidth and storage at the moment. Eventually I'd like to organize them, but for now I'll likely just put them into the "useful" directory. Cheers!

 

[ash1300ad]

Download link blocked at work, tagged for later

 

[builderguy]

All the fields are protected...I can't enter anything and the sheet is password protected so I can't "unprotect"

 

[erockomania]

The the black fields (autocalc'd) are protected because they contain formulas. All the grey fields are the fields you should be entering the info. The way I suggest filling it out is from from the top down (grain amounts, hop amounts, select grains(drop down menu), select hops(drop down menu), select yeast(drop down menu), type assumed brewhouse efficiency, assumed FG) and then everything will be calculated for you.

Let me know if that doesn't work. PM me if you want the password.

 

[worstbrewing]

New version: http://www.worstbrewing.com/useful/Dahk_Brewing_Calc_1.7.zip

 

[ShakerD]

I like it and would like to use it but when I try to change the type of grain or hop, the drop down menu appears but won't let me select a different choice. It just pops up the password error.

 

[erockomania]

Hmm. Try clicking on the far right of those fields. A drip down icon should appear. The cells are locked as to not screw up the drop down but the drop down should still be available. If not, let me know and I'll save a new version with those cells unprotected to avoid confusion. Sorry!

And thanks again, worstbrewing!

 

[ShakerD]

I tried again but same thing. Do you want to PM me the password so I can unlock it?

It does let me select it but won't allow it to change.

 

[erockomania]

I suppose there must be some weirdness between versions and OSs so I'll just post the password for all, here....

pass: dahk

*Please beware that if you type in any fields that are currently protected, you may erase the formulas and things won't calculate as they should...

 

[mattd2]

Hey erockomania, looks like a nice spreadsheet you have made. Got one suggestion for the next release, dont hide all the stuff from rows 102-331 - it's all good info that could be helpful when making recipes (what the grains contribute to the final beer), etc.

Cheers

 

[erockomania]

Yea, I was going to try and figure a way to get them into the spreadsheet. I hid it because if any of it's moved improperly, it'll screw up the spreadsheet drop downs.:cross:

 

[mattd2]

Yea, I was going to try and figure a way to get them into the spreadsheet. I hid it because if any of it's moved improperly, it'll screw up the spreadsheet drop downs.:cross:

Maybe move all the "vital" info to another sheet and protect that sheet from anyone meddling with it

 

[erockomania]

Maybe move all the "vital" info to another sheet and protect that sheet from anyone meddling with it

That's doable

 

[erockomania]

Done

Dahk_Brewing_Calc_1.8.xlsx

Moved the data to their own sheets and only protected the black cells. This should be more compatible now.

No password to unprotect.

 

[worstbrewing]

Uploaded: http://www.worstbrewing.com/useful/Dahk_Brewing_Calc 1.8.zip

 

[erockomania]

Uploaded: http://www.worstbrewing.com/useful/Dahk_Brewing_Calc 1.8.zip

Dude, you are the man

 

[ShakerD]

Awesome Man Thanks

A+

 

[erockomania]

New version. This is one easier to understand. I've consolidated some aspects of the sheet and made it a little easier on the eyes.

Dahk Brewing Calc 2.0.1.xlsx

 

[worstbrewing]

Uploaded: http://www.worstbrewing.com/useful/Dahk_Brewing_Calc 2.0.1.zip

 

[Didje]

Just downloaded this and will play around with it over the weekend. It looks very promising. Thanks for taking the time to put this together! Have a (homemade)beer on me!

 

[erockomania]

Cool, let me know if it works out for you