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
  2. Dismiss Notice

Kit And Extract Beer Spreadsheet

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

 

  1. Hostage_85

    Active Member

    Joined:
    28/10/13
    Messages:
    40
    Likes Received:
    7
    Gender:
    Male
    Location:
    Perth, WA
    Posted 27/9/16
    Hi Guys,

    Love the spreadsheet, Just a quick question.

    I think i Know the answer from searching this thread, but just want to double check.

    If my Hop boil is less than 8 litres, I should use the HCF but if its 8 litres or more, I should leave it as NO.
    Correct?
     
  2. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    687
    Likes Received:
    92
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 27/9/16
    There is very little data for boiling hops with small volumes hence the HCF. I would not use it with an 8 litre boil volume but suggest you try and increase your boil volume to 10 litres which can easily be done in say a BigW 19 litre pot.
     
    1 person likes this.
  3. Hostage_85

    Active Member

    Joined:
    28/10/13
    Messages:
    40
    Likes Received:
    7
    Gender:
    Male
    Location:
    Perth, WA
    Posted 28/9/16
    No worries,
    Well at the moment i'm only boiling with 4 litres. So I'll use the HCF for now.

    Thanks Ian
     
  4. Lewie17

    Member

    Joined:
    8/6/16
    Messages:
    12
    Likes Received:
    0
    Gender:
    Male
    Posted 12/2/17
    Anyone got any recipes they want to share using a Coopers Australian Pale Ale, that I can Import into the spreadsheet. This is my first time using the spreadsheet, is 4.1 the latest version?
     
  5. Lewie17

    Member

    Joined:
    8/6/16
    Messages:
    12
    Likes Received:
    0
    Gender:
    Male
    Posted 12/2/17
    Also has anyone added BE2 into the spreadsheet?
     
  6. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    687
    Likes Received:
    92
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 12/2/17
    4.1 is the latest version, found in the first post.
     
  7. Lionman

    Well-Known Member

    Joined:
    8/4/13
    Messages:
    864
    Likes Received:
    307
    Gender:
    Male
    Location:
    Perth NOR
    Posted 12/2/17
    BE2 (per 1KG packet) is made from
    500g Dextrose
    250g Maltodextrin
    250g Light Dry Malt Extract

    So you can just add these as separate items.
     
  8. meves

    New Member

    Joined:
    27/10/16
    Messages:
    1
    Likes Received:
    0
    Posted 12/2/17
    Hi all, I was gidfted the "Coopers Craft / Mr Beer" kit and I have been playing around with a few brews.

    Can someone tell me the best way to input information for the "Coopers Craft / Mr Beer" kits.

    All cans are designed for 8.5L batch and weigh 1.3kg, and coopers lists the cans to have the following values

    Churchills Nut Brown
    • Colour : 420EBC
    • Bitterness : 500IBU
    North West Pale Ale
    • Colour : 90EBC
    • Bitterness : 390IBU
    Bewitched Amber Ale
    • Colour : 340EBC
    • Bitterness : 295IBU
    LP IPA
    • Colour : 130EBC
    • Bitterness : 420IBU
    Diablo IPA
    • Colour : 230EBC
    • Bitterness : 560IBU
    Winter Dark Ale
    • Colour : 650EBC
    • Bitterness : 590IBU
    I have input the EBC and IBU details into columns E and F of the spread sheet, but it looks like the calcualtions are made from columns B and C, which are "for 23L"

    Any ideas?

     
  9. Lionman

    Well-Known Member

    Joined:
    8/4/13
    Messages:
    864
    Likes Received:
    307
    Gender:
    Male
    Location:
    Perth NOR
    Posted 12/2/17
    I believe you take the concentrated value, times it by the net weight of the tin and divide by the volume of dilution.

    So for the Nut Brown the IBU at a dilution of 23L would be

    500 x 1.3 รท 23 = 28.26IBU
     
  10. ChefKing

    Well-Known Member

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

    Love using the spreadsheet and getting precise numbers on my brews.

    I have been brewing a few of those Mangrove Jack's Craft pouches... I was wondering if there would be an update on the spreadsheet to include them?
     
  11. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    687
    Likes Received:
    92
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 17/2/17
    Hi Chef King, I won't be updating the spreadsheet as I stop extract brewing about six years ago. However you could add the Mangrove Jack pouches to the Kits list, their website tells you the values you get in 23 litres.
     
  12. Lionman

    Well-Known Member

    Joined:
    8/4/13
    Messages:
    864
    Likes Received:
    307
    Gender:
    Male
    Location:
    Perth NOR
    Posted 18/2/17
    As Ian has said, it's easy to add items to the spreadsheet. Just find the relevant tab. If toy want the new addition to appear in alphabetical order or the main page just insert a row in the appropriate position.
     
  13. kalbarluke

    Well-Known Member

    Joined:
    20/6/08
    Messages:
    421
    Likes Received:
    59
    Gender:
    Male
    Home Page:
    Posted 5/3/17
    Great spreadsheet ianh. I am using some Mangrove Jack yeasts and they are not on the spreadsheet. Here is a list of all the Mangrove Jack yeasts with their attenuation percentages in case anyone is using those yeasts.

    Linky
     
  14. Lewie17

    Member

    Joined:
    8/6/16
    Messages:
    12
    Likes Received:
    0
    Gender:
    Male
    Posted 26/3/17
    My comment in cell B1 on brew day has stopped updating. Any ideas to fix it?
     
  15. Lewie17

    Member

    Joined:
    8/6/16
    Messages:
    12
    Likes Received:
    0
    Gender:
    Male
    Posted 26/3/17
    The funniest thing just happened. I just selected the recipe and went Ctrl C and it updated the comment.
     
  16. yochris77

    Well-Known Member

    Joined:
    28/4/16
    Messages:
    79
    Likes Received:
    27
    Gender:
    Male
    Location:
    Redcliffe, QLD
    Posted 28/4/17
    Thanks Ian!
     
  17. frosty3

    New Member

    Joined:
    16/3/17
    Messages:
    3
    Likes Received:
    0
    Posted 25/5/17
    Thanks heaps for the speadsheet!!

    Just wondering if its only my excel and the macro but when I save a recipe using a kit it doesn't save the weight in kilos.
    The LME and DME and everything else works fine. If someone could let me know that would be awesome.

    Thanks
     
  18. Lionman

    Well-Known Member

    Joined:
    8/4/13
    Messages:
    864
    Likes Received:
    307
    Gender:
    Male
    Location:
    Perth NOR
    Posted 25/5/17
    Can you elaborate more on 'doesn't save the weights in kilos'?

    Are you hitting the save recipe button on the main tab?
     
  19. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    687
    Likes Received:
    92
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 25/5/17
    Hi frosty3 and welcome to the forum.

    It been a long time since I visited the spreadsheet but I would say that's normal. The Kit weight is on the KITS worksheet so the spreadsheet should pick it up from there when you use the Get Recipe button.

    cheers

    Ian
     
  20. frosty3

    New Member

    Joined:
    16/3/17
    Messages:
    3
    Likes Received:
    0
    Posted 26/5/17
    Ok so I have
    - Downloaded 2016 Kit & Extract Beer Designer V4.2
    - Opened it and enabled macros.
    - Click and selected any kit
    - Kit appears but no kit weight (see pics below)


    Screen Shot 2017-05-26 at 5.25.11 pm.png
    Screen Shot 2017-05-26 at 5.25.23 pm.png


    It seems not to be loading the kit weights. So just wondering if anyone else has this problem or just me.
    Thanks
     

Share This Page