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. buttersd70

    Beerbelly's bitch :)

    Joined:
    27/11/07
    Messages:
    3,550
    Likes Received:
    8
    Gender:
    Male
    Posted 5/2/09
    Reverse that, FG is a factor of attenuation. Attenuation is determined by wort compostition, yeast strain, and yeast health, nutrition, etc etc. But in the case of FG from 2 identical worts, but with different yeasts, the average attenuation of the strain would be the determining factor in the FG calculation.

    the BV calculation takes into account the FG, and the FG will vary depending on apparant attenuation (amongst other things)....so, in an example wort, if your using a low attenuator, eg 1469 with average attenuation of only 69%, compared to high attenuator, eg nottingham with 76%, it will effect the FG, which will affect the BV.

    This would be a handy thing for those brewers that are using yeasts that have attenuation averages available. Obvioulsy in a kit and bit scenario, the attenuation needs to be skewed in the calculations to take into account the relative fermentability of the individual ingredients. The way I do it is by calculating the percentage of the contribution to gravity of each ingredient...the malt component is assigned the attenuation of the actual yeast, simple fermentables are assigned 92%, and unfermentables are assigned 0.
     
  2. pmolou

    Well-Known Member

    Joined:
    17/3/08
    Messages:
    408
    Likes Received:
    1
    Gender:
    Male
    Home Page:
    Posted 5/2/09
    awsome spreadsheet! just wondering is there a way so you can add more specialty malts like more than 2
     
  3. chappo1970

    Must remember to logout of AHB on Brew Days

    Joined:
    14/1/09
    Messages:
    5,903
    Likes Received:
    14
    Gender:
    Male
    Home Page:
    Posted 5/2/09
    Ian,
    Where do you find the time to do real work? :p

    Cheers Mate GOLD MEDAL EFFORT!

    Hey Ian you don't have time to read this forum you keep going, don't stop on our behalf!


    Oh and do all that stuff Butters suggested :huh: Cheers.
     
  4. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    687
    Likes Received:
    96
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 5/2/09
    Hi Chappo

    I don't I'm retired

    Got to understand the stuff Butters Suggests

    cheers

    Ian
     
  5. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    687
    Likes Received:
    96
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 5/2/09
    Do you mean more LME as there are 3 specialty grain inputs.

    Thought people would do 1 or 2 LME's then add the Specialty Grains to add the required flavours and odours.

    If you mean LME will keep in mind.

    cheers

    Ian
     
  6. adam

    Well-Known Member

    Joined:
    14/11/04
    Messages:
    74
    Likes Received:
    0
    Gender:
    Male
    Home Page:
    Posted 5/2/09
    That is the best xls I've seen in my whole life!!!
    And as a kit and bits brewer, it is perfect for me.

    any chance of having the malt, dextrose additions etc increase by 50g instead of 100g - no biggy but will save me having to delete the contents of the cell and typing in say .25 etc.

    Cheers, Adam
     
  7. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    687
    Likes Received:
    96
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 5/2/09
    Hi Mark

    What the spreadsheet is trying to do is create a Boil gravity of 1.040, this is made up of the SG from any speciality grains and then either DME or LME is added to bring the boil SG up to 1.040.

    Normally one would add DME as it is easier to measure and needs to do Hot/Cold break. The spreadsheet gives an option to add either DME or LME depending on initial ingredients.

    But if adding LME you would add the amount specified to bring the Boil gravity up to BG 1.040 and then add the rest to the Fermenter.

    The spreadsheet then uses a %utilisation factors for the 1.040 BG and a Hop Concentration Factor because we K & E brewers tend to boil much smaller volumes than our AG counterparts. There are a number of ways to work out Hop Utilisation which give quite differening results, I feel the way the spreadsheet calculates it is more applicable to K & E brewing.

    What I am trying to do is create a standard set of conditions for the Hop utilisation, so if you do it this way this time when you do it again in a couple of months it will have a similar outcome.

    Hope that makes sense.

    cheers

    Ian
     
  8. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    687
    Likes Received:
    96
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 5/2/09
    Thanks Adam

    You have got to set an increment somewhere, so it was set at 100g for malt and dex, because of the range it needs to cover. If I set it to 50g then I would get people complaining it's not high enough because they need to hit it more to get a required amount.

    You can use the spinners to get it near enough to the value required and the type in a value just to tweak it. If you type in 0.25 it will still change by 0.1.

    I have more trouble with the hop weights than the malt and dex.

    cheers

    Ian
     
  9. pmolou

    Well-Known Member

    Joined:
    17/3/08
    Messages:
    408
    Likes Received:
    1
    Gender:
    Male
    Home Page:
    Posted 5/2/09
    yer i mean the specialties, can i say just copy paste the cell somewhere else to have more or is this not possible

    ps. i'm doing a real big dubbel so using lots of grains n bits :icon_drool2:
     
  10. chappo1970

    Must remember to logout of AHB on Brew Days

    Joined:
    14/1/09
    Messages:
    5,903
    Likes Received:
    14
    Gender:
    Male
    Home Page:
    Posted 6/2/09
    Bawahhahahah! :lol:

    I need to read his posts several times, sometimes myself!
     
  11. AntCoop

    Well-Known Member

    Joined:
    27/7/08
    Messages:
    53
    Likes Received:
    0
    Gender:
    Male
    Posted 6/2/09
    Just like to thank you ianh for putting this on the site.

    I'am starting to move into extract brewing from kits and this wil help greatly.

    Cheers Coops
     
  12. buttersd70

    Beerbelly's bitch :)

    Joined:
    27/11/07
    Messages:
    3,550
    Likes Received:
    8
    Gender:
    Male
    Posted 6/2/09
    Strangely enough, I need to read his posts multiple times, too.
     
  13. chappo1970

    Must remember to logout of AHB on Brew Days

    Joined:
    14/1/09
    Messages:
    5,903
    Likes Received:
    14
    Gender:
    Male
    Home Page:
    Posted 6/2/09
    :lol:

    Thanks Butters I just squirted beer up thru my nose... YOU PAY FOPR THAT MY BUTTERY FRIEND... you'll pay!
     
  14. muckey

    Where's my Beer?

    Joined:
    18/2/08
    Messages:
    860
    Likes Received:
    2
    Gender:
    Male
    Home Page:
    Posted 6/2/09
    you think his posts are bad, you should try talking to him on the phone
     
  15. buttersd70

    Beerbelly's bitch :)

    Joined:
    27/11/07
    Messages:
    3,550
    Likes Received:
    8
    Gender:
    Male
    Posted 6/2/09
    mmmmmmmmmmmmmmm, diacetyl. :icon_drool2:
     
  16. chappo1970

    Must remember to logout of AHB on Brew Days

    Joined:
    14/1/09
    Messages:
    5,903
    Likes Received:
    14
    Gender:
    Male
    Home Page:
    Posted 6/2/09
    That's now three times Butter Boy! Your forcing me into this I hope you understand but you left me with no other alternative.

    I gunna have to go outside and have a smoke
     
  17. buttersd70

    Beerbelly's bitch :)

    Joined:
    27/11/07
    Messages:
    3,550
    Likes Received:
    8
    Gender:
    Male
    Posted 6/2/09
    low..... :wacko: <_< ^_^
     
  18. chappo1970

    Must remember to logout of AHB on Brew Days

    Joined:
    14/1/09
    Messages:
    5,903
    Likes Received:
    14
    Gender:
    Male
    Home Page:
    Posted 6/2/09
    You only have yourself to blame :huh:
     
  19. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    687
    Likes Received:
    96
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 6/2/09
    Don't start using it just yet as it is still in the development stage, hopefully will be close with version 3

    cheers

    Ian
     
  20. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    687
    Likes Received:
    96
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 6/2/09
    Anybody who smokes 60 a day can't be smoking real cigarettes. Capstan Full Strength (Brown Packet) used to be 38 milligrams, a real cigarette.
     

Share This Page