- updated link, again
I've finished the most recent upgrade. I've added quite a few more features and have rearranged for a cleaner/more functional layout. The last version was great, but this one is much better imo. A lot of that comes from all the suggestions/thoughts/etc... from users here in the previous thread (General Beer Discussion thread) and via pm and email. There was a lot of great feedback and I've done my best to incorporate as much of it as I could while still staying true to my vision of this project. I'm hoping there will be another round of great feedback here as well so this thing can keep moving forward and improving. All told it's become a fun project for me and I don't plan on stopping it anytime soon. You'll find that it's about as automated as it can be while still giving the user full control over almost everything.
Some of the new features:
1. Added a kegging calculator/how to which coincides with the bottle priming calculator/how to.
2. All ingredients are in drop downs now. The malts and other fermentables all prefill with max points/yield and color for each one. I also included the functionality for you to change those figures if you'd like and the ability for the user to add ingredients to those lists as well.
3. The Recipe Sheet tab and Brewday tab have been separated to clean it up. You can still design a recipe with all the ingredients on the same page for easy review. Once you're done with designing the recipe you'll have a dedicated tab to your brewday where all the math is taken care of for you so you can concentrate on brewing and measuring.
Please don't hesitate to ask questions and offer feedback. Your feedback last time around is what pushed this version to where it is now. Thanks to all that helped with feedback, testing, questions, etc... MX1 and NorCalAngler were nice enough to test this thing while I was developing it so thank you both for taking the time to do so as it really helped.
For those that have not used this in the past, here is a brief description of what you'd find if you download:
This workbook should allow you to design your beers and take them from the recipe design stage all the way to first taste while giving you the ability to do things optimally to produce the best beer you can. Each tab contains how to information based upon best practices found within the homebrewing community. You should find everything easy to use, automated where possible, and designed to help you concentrate on brewing and brewing well rather than math. If you use the Brewday tab properly it will do all the brewday math for you so you can just concentrate on your process and measurements. You will be able to track everything you need to track in order to replicate or troubleshoot the beer in the future.
Hope you enjoy it.