For the next kit, use line 108, and alter the formulas accordingly. What should happen is that the spreadsheet will automatically fill in the values for colour and bitterness on the main page. Go to column "C" and enter this formula: =F107*1.3/8.5, then hit enter. Now go back to column "B" and enter the following formula: =E107*1.3/8.5, then hit enter. Enter the kit's name on line 107 in column "A." Enter 130 in column "E." Enter 420 in column "F". On the kit tab / page, find a empty line at the bottom of the list of kits. On the above page you can see that the colour is 130 EBC, and the bitterness is 420 IBU. Let's use the Bewitched Amber kit as an example: To add the craft fermenter kits to Ian's spreadsheet, look along the bottom of the main page and click on the tab that says "kits." Go to Coopers website and, for each craft kit, look on it's "more info" page to get the colour and bitterness numbers for the can. This leaves your Template unchanged next time you go to use it. When I am designing a recipe I click on "Template," put in my grain and hop amounts etc on the main page, and then use the "Save As" function to name the recipe and save it. In Ian's program I have a recipe called "Template," and that is where I make any additions or changes to the program.
Brewers friend vs beersmith how to#
In case you decide to proceed, I will try to explain how to add the craft kits. I think it is worth trying to fix the bitterness values and add the craft kits. If you are using kits it is tough to beat Ian's spread sheet. I have not tried Beersmith, but if one is all grain, it seems the overwhelming choice of many home brewers, and it is probably what I would choose.įor BIABers, doesn't AHB have a calculator geared to BIAB? Not sure if its free.
Brewers friend vs beersmith free#
As long as you aren't interested in saving your recipes, its free I like that it will give the grain bill percentages, as well as the starter calculator. Now that I have moved on to partial mashes, I supplement IanH's SS with the Brewer's Friend calculator online. I am not all that confident in the IBU numbers it gives, although they seem better since I "fixed" the kit formula. The other thing is that for hop boils it doesn't explain how to use the hop concentration factor button. The IBU values it gives for the kits are much lower than what you get using Coopers formula, but that too can be changed. The one thing that is not so good at it is the IBU calculation. It is great for figuring out your OG and FG, and attenuation. As others have mentioned, you can customize it, add the grains your LHBS sells, etc. I have been using IanH's spreadsheet for years.