In case you decide to proceed, I will try to explain how to add the craft kits. In Ian's program I have a recipe called "Template," and that is where I make any additions or changes to the program. 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. This leaves your Template unchanged next time you go to use it. 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. On the above page you can see that the colour is 130 EBC, and the bitterness is 420 IBU. On the kit tab / page, find a empty line at the bottom of the list of kits. Enter the kit's name on line 107 in column "A." Enter 130 in column "E." Enter 420 in column "F". Now go back to column "B" and enter the following formula: =E107*1.3/8.5, then hit enter. ![]() Go to column "C" and enter this formula: =F107*1.3/8.5, then hit enter. What should happen is that the spreadsheet will automatically fill in the values for colour and bitterness on the main page. ![]() ![]() For the next kit, use line 108, and alter the formulas accordingly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |