I'm not sure if it is of any use, but that batch spreadsheet was designed to be used in conjunction with another spreadsheet called "Brew Summaries-4". If you're interested, I've culled all unecessary files and zipped up the directory, and it can be
downloaded from here (one of my own servers).
Guarantees: I guarantee all files are free from any trojans, viruses and malware. However, even though I've been using this for over 18 months, I can't promise it will work for you, but it should (on a Windows system with Excel 2007 or better). If there are any problems, Beersmith know where I live!
Instructions: Unzip the file to wherever you like. Place a shortcut of the file "Brew Summaries-4.xlsx" on the desktop and use this as a starting point to get to what you want. The name of the brew is a link to the relevant batch spreadsheet (so for new brews you'll need to right-click the name and insert a hyperlink).
Since the spreadsheets are linked, when you open or exit the Brew Summaries file, it will ask you if you wish to update or save the current spreadsheet -- this is your option but I always choose "yes". If you have any concerns, you should disable any macros from running (even though there are absolutely none in any of the spreadsheets or files.
I'm sure it should be easy to follow and you'll see which columns have formulae and which require an entry in them.
Feel free to edit, disassemble, delete or modify in any way you'd like.
Cheers