Originally Posted by -TH-
how about a link???
No problem. Let me get it online and I'll update this with the link by the weekend.
Edit: I use Linux as my operating system, not Windows. Again, something I don't want to pay for. Plus, it's just so much more robust and reliable. Anyways, I used OpenOffice to make the spreadsheet. I have saved a version in Microshaft Excel format, but I can't offer guarantees that it will work and look exactly as the OpenOffice version does on my computer. However, OpenOffice is free and also available to Windows users.
Please remember that this is a work in progress. I am adding styles, grains, hops, yeast, and other information as I encounter something new in my own brews. So those sheets are not complete. I don't see the sense in doing all the work now when I can just add a few of the ones I need when I brew a batch that needs them. I'm constantly working on updating the design to make it "flow" better. The section labeled "Useful Variables" includes those things that I've thought useful since making the spreadsheet. They will go in the proper place in the next revision. That section will then be blank for more new useful variables. The general process is simple: fill in the areas in yellow. Everything else is calculated. The best way to add grains, hops, yeast, and styles is to insert a new row somewhere in the middle of the list, add the item, and then sort on the first column.
I'm including a blank template, a default template that I have filled with some typical values for my system, and a sample sheet of one of my recent brews that's mostly filled out (it's still in the primary). Enjoy!
The OpenOffice version
The Microshaft Excel version
By the way, it goes without saying that I did not "invent" any of this information. Well, maybe I've thought of some useful variables and formulas. But without the resources of a lot of people, web sites, and fellow homebrewers, it wouldn't exist. So if you see something familiar in here, thanks! But honestly, there aren't too many ways to represent the same information. So much of the variables and formulas will probably be similar to what you find online or in brewing software. Again, I just prefer the open source and free mentality. Things tend to be better that way. You know, it's a numbers game. More people can participate to make it better.
Oh, and if you change it or improve it, please share it back with me!