Tag Archives: data

Lately I’ve been writing an eBook on the subject of homebrewing. I decided a few years ago that I needed to write my own spreadsheet (as I do for a lot of things because I love Excel….) that would act as a recipe generator/formulator. Knowing full well that others have written a few beautiful programs like BeerSmith, ProMash and others like them, I decided that I needed to do my own calculations because I wanted my beer to be calculated at my own hand. I did so with success, but it took years to get it to the point of actually being very usable. Years. I will spend more time perfecting it, I’m sure, but what I like about it is the amount of data that is collected in the spreadsheet. Based off the information I have available through various books, internet pages that I’ve favorited, magazine articles, and of course colleagues who have provided their experience over the years, I was able to compile an immense amount of calculations and formulas regarding every aspect of making beer at home. And then a little extra for good measure. What a spreadsheet! What an accomplishment! My magnum opus. My creme de la creme. I had finally done it. Something to be proud of, something I made with my own experiences and something I could share with everyone.

Then it hit me, “What if someone else would like and all this data for their own calculations?” So I set out to write the biggest collection of brewing data, formulas and set of calculations I could imagine. I didn’t want to weigh it down with too much personal opinion, except where necessary, of course. Also, I’d want all that data sorted out by process step, so a chapter for mashing, one for boiling, another for fermenting, etc. And of course it would need a title. Something slightly tongue in cheek…

This is my shameless proclamation of the forthcoming title “The Grimoire ofHomebrewing”.

I’ve been writing it in my spare time and hope to have it finished before May 4th, National Homebrew Day. So please favorite this blog to keep up to date on it’s release. I guarantee you will be pleased with the amount of data, formulae, and calculations available.