Jump to content



Photo
* * * * * 17 votes

Kit And Extract Beer Spreadsheet


  • Please log in to reply
734 replies to this topic

#721 Hostage_85

Hostage_85

    Kit Master

  • Members
  • PipPip
  • 40 posts
  • Joined 29-October 13
  • Location:Perth, WA

Posted 27 September 2016 - 03:26 PM

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?



#722 ianh

ianh

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 655 posts
  • Joined 24-October 08
  • Location:Wynyard Tassie

Posted 28 September 2016 - 06:38 AM

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.



#723 Hostage_85

Hostage_85

    Kit Master

  • Members
  • PipPip
  • 40 posts
  • Joined 29-October 13
  • Location:Perth, WA

Posted 28 September 2016 - 11:58 AM

No worries,

Well at the moment i'm only boiling with 4 litres. So I'll use the HCF for now.

 

Thanks Ian



#724 Lewie17

Lewie17

    Amateur Brewer

  • Members
  • Pip
  • 9 posts
  • Joined 08-June 16
  • Location:Pakenham

Posted 12 February 2017 - 11:34 AM

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?



#725 Lewie17

Lewie17

    Amateur Brewer

  • Members
  • Pip
  • 9 posts
  • Joined 08-June 16
  • Location:Pakenham

Posted 12 February 2017 - 11:35 AM

Also has anyone added BE2 into the spreadsheet?



#726 ianh

ianh

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 655 posts
  • Joined 24-October 08
  • Location:Wynyard Tassie

Posted 12 February 2017 - 02:32 PM

4.1 is the latest version, found in the first post.



#727 Lionman

Lionman

    Partial Man

  • Members
  • PipPipPipPipPip
  • 118 posts
  • Joined 08-April 13
  • Location:Perth

Posted 12 February 2017 - 06:58 PM

Also has anyone added BE2 into the spreadsheet?


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.

#728 meves

meves

    Amateur Brewer

  • Members
  • Pip
  • 1 posts
  • Joined 27-October 16
  • Location:Adelaide

Posted 12 February 2017 - 09:27 PM

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?

 

 

G'day Ian -- top work on the spreadsheet, big fan!

 

I made a small addition/modification I thought I'd share - added a "default batch size" column to the "KITS" tab and added a conditional reference to F6/7 & G6/7 on the "MAIN" tab (use batch size if it isn't blank, otherwise default to 23L) to enable adding the Mr Beer Craft kits sold by Coopers.

 

Found these numbers on a retail site and I'm not sure how correct they are, but I ran them through the calc and the colour/IBU/ABV seemed pretty right. Here they are in case anyone else is looking to run the numbers and test them:

                              EBC   IBU   Weight   Batch (L)
Mr Beer Bewitched Amber Ale    30    30     1.3       8.5 
Mr Beer Winter Dark Ale        60    60     1.3       8.5
Mr Beer North West Pale Ale     8    43     1.3       8.5 
Mr Beer Diablo IPA             22    70     1.3       8.5 


#729 Lionman

Lionman

    Partial Man

  • Members
  • PipPipPipPipPip
  • 118 posts
  • Joined 08-April 13
  • Location:Perth

Posted 12 February 2017 - 11:39 PM

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?

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

#730 ChefKing

ChefKing

    Great Head

  • Members
  • PipPipPipPip
  • 91 posts
  • Joined 25-July 13
  • Location:Port Douglas, Queensland

Posted 17 February 2017 - 08:37 PM

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?



#731 ianh

ianh

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 655 posts
  • Joined 24-October 08
  • Location:Wynyard Tassie

Posted 18 February 2017 - 07:03 AM

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.



#732 Lionman

Lionman

    Partial Man

  • Members
  • PipPipPipPipPip
  • 118 posts
  • Joined 08-April 13
  • Location:Perth

Posted 18 February 2017 - 10:27 AM

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?


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.

#733 kalbarluke

kalbarluke

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 398 posts
  • Joined 20-June 08
  • Location:The Hills

Posted 05 March 2017 - 04:41 PM

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



#734 Lewie17

Lewie17

    Amateur Brewer

  • Members
  • Pip
  • 9 posts
  • Joined 08-June 16
  • Location:Pakenham

Posted 26 March 2017 - 12:51 PM

My comment in cell B1 on brew day has stopped updating. Any ideas to fix it?



#735 Lewie17

Lewie17

    Amateur Brewer

  • Members
  • Pip
  • 9 posts
  • Joined 08-June 16
  • Location:Pakenham

Posted 26 March 2017 - 12:55 PM

My comment in cell B1 on brew day has stopped updating. Any ideas to fix it?

 

The funniest thing just happened. I just selected the recipe and went Ctrl C and it updated the comment.