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

Kit And Extract Beer Spreadsheet

Aussie Home Brewer

Help Support Aussie Home Brewer:

buttersd70

Beerbelly's bitch :)
Joined
28/11/07
Messages
3,550
Reaction score
8
Yeast attenuation as I understand it is a factor in FG which is part of the BV calc. Not sure what you are trying to do, can you point me in the right direction.

cheers

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

pmolou

Well-Known Member
Joined
17/3/08
Messages
408
Reaction score
1
awsome spreadsheet! just wondering is there a way so you can add more specialty malts like more than 2
 

chappo1970

Must remember to logout of AHB on Brew Days
Joined
14/1/09
Messages
5,903
Reaction score
14
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.
 

ianh

Well-Known Member
Joined
24/10/08
Messages
687
Reaction score
98
Location
Wynyard Tassie
Ian,
Where do you find the time to do real work? :p
Oh and do all that stuff Butters suggested :huh: Cheers.
Hi Chappo

I don't I'm retired

Got to understand the stuff Butters Suggests

cheers

Ian
 

ianh

Well-Known Member
Joined
24/10/08
Messages
687
Reaction score
98
Location
Wynyard Tassie
awsome spreadsheet! just wondering is there a way so you can add more specialty malts like more than 2
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
 

adam

Well-Known Member
Joined
14/11/04
Messages
74
Reaction score
0
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
 

ianh

Well-Known Member
Joined
24/10/08
Messages
687
Reaction score
98
Location
Wynyard Tassie
Hello ian, first of all great spreadsheet.

With LME etc additions can you designate when it is added? E.g. sometimes you'll add 1.5L pre-boil and boil your hops etc, but add another 1.5L at flame out. This affects the IBU.

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

ianh

Well-Known Member
Joined
24/10/08
Messages
687
Reaction score
98
Location
Wynyard Tassie
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
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
 

pmolou

Well-Known Member
Joined
17/3/08
Messages
408
Reaction score
1
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
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:
 

chappo1970

Must remember to logout of AHB on Brew Days
Joined
14/1/09
Messages
5,903
Reaction score
14
Got to understand the stuff Butters Suggests
Bawahhahahah! :lol:

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

AntCoop

Well-Known Member
Joined
27/7/08
Messages
53
Reaction score
0
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
 

chappo1970

Must remember to logout of AHB on Brew Days
Joined
14/1/09
Messages
5,903
Reaction score
14
:lol:

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

muckey

Where's my Beer?
Joined
18/2/08
Messages
860
Reaction score
2
you think his posts are bad, you should try talking to him on the phone
 

chappo1970

Must remember to logout of AHB on Brew Days
Joined
14/1/09
Messages
5,903
Reaction score
14
mmmmmmmmmmmmmmm, diacetyl. :icon_drool2:
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
 

chappo1970

Must remember to logout of AHB on Brew Days
Joined
14/1/09
Messages
5,903
Reaction score
14
You only have yourself to blame :huh:
 

ianh

Well-Known Member
Joined
24/10/08
Messages
687
Reaction score
98
Location
Wynyard Tassie
Just like to thank you ianh for putting this on the site.

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

Cheers Coops
Don't start using it just yet as it is still in the development stage, hopefully will be close with version 3

cheers

Ian
 

ianh

Well-Known Member
Joined
24/10/08
Messages
687
Reaction score
98
Location
Wynyard Tassie
I gunna have to go outside and have a smoke
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.
 
2

Latest posts

Top