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
- Colour : 130EBC
- Bitterness : 420IBU
- 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"
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