Help Support Aussie Homebrewer by donating:

  1. We have implemented the ability to gift someone a Supporting Membership now! When you access the Upgrade page there is now a 'Gift' button. Once you click that you can enter a username to gift an account Upgrade to. Great way to help support this forum plus give some kudos to anyone who has helped you.
    Dismiss Notice

Kit And Extract Beer Spreadsheet

Discussion in 'Kits & Extracts' started by ianh, 3/2/09.

 

  1. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    687
    Likes Received:
    92
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 9/9/15
    You only have to boil if adding hops. The boil time depends on the time selected to obtain a certain bitterness.
     
  2. burrster

    Well-Known Member

    Joined:
    9/8/13
    Messages:
    155
    Likes Received:
    25
    Gender:
    Male
    Location:
    Adelaide
    Posted 28/9/15
    Hi Willbrewry. If you are only adding the can and the 1kg of dry malt you don't need to do a boil. The boil is so you can do hops additions.You Also need to boil any wort from steeped grain, to kill any potential nasty's, but in this case would not need to add extract unless you were making hop additions.

    Hope that helps
     
  3. Zoiks

    Member

    Joined:
    13/10/15
    Messages:
    9
    Likes Received:
    5
    Posted 21/10/15
    Hi,
    I am trying to use the spreadsheet to work some 'half size' batches.

    From what I understand a half can of kit w/ 10L of water should be equal to a full can @20L.

    The spreadsheet only recognises full cans when it calculates bitterness and colour. Changing the weight of the kit only seems to change OG etc.

    Is this a known issue?
     
  4. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    687
    Likes Received:
    92
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 21/10/15
    Hi Zoiks

    If you want to play around with half cans you need to change the data on the Kits worksheet. For Black Rock and Coopers you need to change the EBC and IBU values in columns E & F using other Kits change values in columns B & C. If doing it on a regular basis just add new lines for the half kits.

    cheers

    Ian
     
  5. Zoiks

    Member

    Joined:
    13/10/15
    Messages:
    9
    Likes Received:
    5
    Posted 21/10/15
    Ian thanks for the reply. I have actually just spent a few minutes making some changes that accounts for these shenanigans. Would you like me to flick them through to you on an email?

    I also noticed that you had the coopers kit ibu/ebc calcs at x*1.25/23 should this be be x*1.75/23?
     
    1 person likes this.
  6. GibboQLD

    Well-Known Member

    Joined:
    6/10/14
    Messages:
    195
    Likes Received:
    67
    Gender:
    Male
    Posted 15/12/15
    Coopers have added the can EBC/IBU numbers to their online store for the new range. Should be as easy as inserting new rows, copying down the formulas and changing the description / can values:
    Code:
                                    Can EBC    Can IBU
    Coopers 86 Days Pilsner            55        490
    Coopers Bootmaker Pale Ale        130        560
    Coopers Brew A IPA                230        830
    Coopers Devil's Half Ruby Porter  650        590
    Coopers Family Secret Amber Ale   420        500
    Coopers Innkeeper's Daughter       90        610
    Coopers Preacher's Hefe Wheat      65        340
    
     
  7. Morrie

    Active Member

    Joined:
    28/2/16
    Messages:
    42
    Likes Received:
    6
    Gender:
    Male
    Location:
    Mackay
    Posted 3/4/16
    Hi Brewers - I'm new to AHB and have been told about IanH's spreadsheet. Where is the best place to download the latest version of it and will it work on a Mac computer?
     
  8. burrster

    Well-Known Member

    Joined:
    9/8/13
    Messages:
    155
    Likes Received:
    25
    Gender:
    Male
    Location:
    Adelaide
    Posted 3/4/16
    Hi Morrie. Page one of this thread has the link for the file.
     
  9. ChefKing

    Well-Known Member

    Joined:
    25/7/13
    Messages:
    92
    Likes Received:
    11
    Gender:
    Male
    Location:
    Port Douglas
    Posted 4/4/16
    Has anyone got a copy of the excel spread sheet with the new coopers range added?
     
  10. Gigantorus

    Well-Known Member

    Joined:
    1/10/14
    Messages:
    401
    Likes Received:
    169
    Gender:
    Male
    Location:
    Bris-Vegas
    Posted 5/4/16
    2 people like this.
  11. Morrie

    Active Member

    Joined:
    28/2/16
    Messages:
    42
    Likes Received:
    6
    Gender:
    Male
    Location:
    Mackay
    Posted 5/4/16
    Thanks guys this is great for me as I am doing TC kits.
     
    1 person likes this.
  12. ChefKing

    Well-Known Member

    Joined:
    25/7/13
    Messages:
    92
    Likes Received:
    11
    Gender:
    Male
    Location:
    Port Douglas
    Posted 12/6/16
    Hi All,

    I am just inputting some data for a new brew and I can not find where the tab is for BE1, BE2 & BE3?

    Any help would be much appreciated thanks...
     
  13. Digga

    Well-Known Member

    Joined:
    11/2/15
    Messages:
    464
    Likes Received:
    126
    Gender:
    Male
    Posted 13/6/16
    The brew enhancers are a mix of malt dextrose and maltodextrin so if you input the amount of each ingredient then you will get the desired outcome.
     
    1 person likes this.
  14. GibboQLD

    Well-Known Member

    Joined:
    6/10/14
    Messages:
    195
    Likes Received:
    67
    Gender:
    Male
    Posted 13/6/16
    You can manually add them to the adjuncts page (after calculating EBC/Potential/Fermentability), but since there are a few niggly bugs in one or two of the formulas, your recipe's FG won't be calculated correctly.

    I've been meaning to get in touch with IanH and pick his brain over correcting them in a new version (plus adding some new features), but haven't had time between kids/work/uni.
     
    1 person likes this.
  15. ChefKing

    Well-Known Member

    Joined:
    25/7/13
    Messages:
    92
    Likes Received:
    11
    Gender:
    Male
    Location:
    Port Douglas
    Posted 13/6/16
    Yeah, read & understood... Shame cus I do use the range of BE now and then to smash a brew through on the quick!
     
  16. GibboQLD

    Well-Known Member

    Joined:
    6/10/14
    Messages:
    195
    Likes Received:
    67
    Gender:
    Male
    Posted 14/6/16
    I'll flick you a PM a bit later to help you get them into your calc.
     
  17. Fl1pp3r

    New Member

    Joined:
    18/7/13
    Messages:
    2
    Likes Received:
    0
    Posted 24/6/16
    This spreadsheet rocks! It makes it very easy to see how close to a style I'm getting, the balance chart is my new best friend.

    Is there a way to get your saved recipes to be selectable in the brews tab to auto populate some of the columns?

    Once again awesome work, must of taken ages to put this together.
     
  18. Dickster86

    Member

    Joined:
    1/8/16
    Messages:
    19
    Likes Received:
    0
    Gender:
    Male
    Posted 18/8/16
    This is awesome. Thankyou. And thanks to gigantorus for letting me know about it
     
  19. Chris79

    Well-Known Member

    Joined:
    18/7/16
    Messages:
    163
    Likes Received:
    23
    Gender:
    Male
    Location:
    Northmead, NSW
    Posted 9/9/16
    Enjoying using this spreadsheet. When I have a grain to, most suppliers will say the EBC rating, but how to I determine what OG to add for that grain? Cheers
     
  20. Lionman

    Well-Known Member

    Joined:
    8/4/13
    Messages:
    864
    Likes Received:
    307
    Gender:
    Male
    Location:
    Perth NOR
    Posted 19/9/16
    You can bring your saved recipes to the main tab by using the 'Get Recipe' button. Make sure to save anything on the main tab that hasn't been saved yet first by using the 'Save Recipe' button.

    The brew tab represents a particular brew day that you executed a recipe, in order to auto-populate the brew tab use the 'Make Recipe' button on the main tab. Note this button will only work if all the ingredients are listed in the inventory tab, so make sure all the ingredients you have in stock are listed here.

    Is this what you mean?
     

Share This Page