Initially the 1st amounts are "highlighted" to make it easier to locate on brewing day, but if you chose to scale the recipe or convert to a particular unit, the respective column will be highlighted and the others subdued. It has a place to enter all of the data for your grain bill, your mash rests, your hopping schedule and your yeast and fermentation schedule. Additionally, if you'd like to scale the recipe, just enter the new volume in the "Scale to" cell. So, the Excel template attached allows you to enter a recipe title, author, source, if it came from a website or book, and a batch size. Now, it's possible that my spreadsheet is not entirely accurate in it's calculations, but I feel like I have a much better idea of what's going on in the math. I wanted to better understand what was happening inside the calculations. to g and wanted to include that in my documentation for an easy brew day.ģ. Because I'm making small batches, I often change my units from lbs. I usually end up scaling my recipes to 1, 2.5 or 3 gallon recipes and wanted an easy way to do this without getting into the "profiles" I was using in BeerSmith (maybe someone knows an easier way of doing it, but I couldn't find one).Ģ. I put together a beer recipe spreadsheet to help me keep track of some items on brewing day and wanted to share it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |