Hey guys... this is what I use to do all my extract/specialty grain brewing. I made this basic brew calculator simply because I like to do random small batches for experimentation and if I find a recipe I like and want to do a larger batch, this will calculate everything for me. It also has a brewing log and a nice ABV calc with temp calibration. I hope you can use it as I find it very helpful for getting rough projections for ABV and such. All the yellow fields are where you input the data... the other fields are all set with formulas. I THINK it looks self explanatory but if you have questions on how it works please ask me.
for Excel '97
*also, I added an "Original Batch Size" option to make things easier
If you can think of anything that might be helpful or looks wrong, please bring it to my attention. *Projected ABV% is based batch size and an 80% efficiency of LME. It tends to work out just about right every time if I use that %, so I worked it into the formula*
It should look exactly like this (for some reason some decimal points where in the wrong places on a system at work... file conversion issue, I guess)