Coopers Recipe Spreadsheet

[Waynealford]

15 minutes ago, Journeyman said:

Good question. 

I'd guess the 1.3L tins are all craft recipes and contain more than just the basic malt wort used in the more basic beers.

So yes, you can just use a 1.7L but you may not get the effect you expect without also adding to the recipe to match what went into the craft tin.
EDIT: To be a little more clear, I mean without adding the things missing from the 1.7L normal beer tins that are in the 1.3L craft ones, as well as the extras spec'ed in the spreadsheet.

So as an example, the Pavlova Pale Ale uses 1.3kg Mr Beer North West Pale Ale for 10L.  If I was to double it to 20L, I should use 2x1.3kg, or a single 1.7kg (noting that all the other ingredients would be doubled)???  And what about the yeast?  11.5g for that recipe, but Marilyn's secret uses 11g of yeast to make 23L?  I am obviously not understanding something...….

[Popo the Reprobate]

To do that exact recipe, you'd need the two cans. You could possibly make something similar using a big can but you'd have to come up with a recipe to get you close to the profile of the North West cans. The small and large cans are not really interchangeable in that way. 

Amount of yeast is based on the size and gravity of the batch. The bigger the batch, or bigger the gravity, the more yeast needed. Therefore, a strong small batch might require the same amount of yeast as a bigger batch that is lower in gravity.

[Journeyman]

Amount of yeast is not dependent on the volume of liquid but the amount of sugars. Even then, under-pitching (not adding enough yeast) will mostly mean a longer fermenting period as the yeast needs to multiply enough to deal with all the sugars. (malt is a sugar)

I would think the 1.7L Pale Ale tin will be different in ingredients to the craft Mr Beer one. I'm not sure where you might find a list of what is actually IN the tins but you might try looking in All Grain (AG) recipes for Pale Ales and see what they use. I'm guessing there will be different malts for the Mr Beer than for the Coopers Pale Ale 1.7L can.

You could certainly simply double everything - I wouldn't bother doubling the yeast though. 11.5g is enough for a 23L brew. 

This is probably straying away from the subject of this thread so maybe create a thread of your own in the Brewing Blether forum to ask further questions?

[Thirsty Jim]

1 hour ago, Waynealford said:

@James of Bayswater - first time stalker on this forum, and I notice you had the recipe converter in your initial spreadsheet.  I was curious regarding the extract volumes - 20-23L requires 1.7kg tins, but 8.5-10L requires 1.3kg tins (according to the Coopers recipes).  If I was to upsize an 8.5L recipe to a 23L vessel, would using a 1.7kg tin work, or would I have to use 2x1.3kg tins?

Sorry I don't have a specific recipe in mind, just a general question that I hope you can answer simply.

In my defense, I am only brewing my second batch now, haven't even tried my first batch of ginger beer, so be gentle!

G'day Wayne.

I think you have thought this through for yourself already.  To brew a 8.5 - 10 litre recipe to a larger volume double the ingredients to 17 - 20 litres and forget about my calculator.

In other words it is altogether easier to adjust your brew volume than to split up the ingredients proportionally.    But you've already worked that out for yourself.

Best of luck with your brewing but I don't think you'll need it.   You are asking all the right questions and figuring it out for yourself. 

 

 

PS :   I kind of regret the scaling calculator.  It has its uses but if you ever find yourself trying to measure out 628g of gloopy extract out of 1.7kg can simply to proportionally downsize a 23 litre recipe to 8.5 litres  I suggest you slap yourself across the back of the head and delete the damn thing .

 

 

 

[Shamus O'Sean]

Hi Team

Latest Coopers Recipe Spreadsheet is attached.  January 2020 ROTM added: Fair Drinkum Aussie Pale Ale & Nuclear Pale Ale

Coopers Beer Recipes V2.6.xlsx

Spreadsheet functionality. 

• You can click on the recipe name to jump to the recipe on the Coopers website (for those in au only)
• The little triangle icons beside each column title are auto-filters and can be used to sort the spreadsheet by the respective column
• You can also use the drop boxes of the variables in each column to show those variables you want to see.  
• For example, under Difficulty if you choose the Easy variable then only those recipes rated as Easy will be displayed
• Or under Can 1, if you choose OS Real Ale only those recipes that have the Original Series Real Ale (as the main recipe can) will be displayed.  Unfortunately I am not clever enough to be able to show those recipes where Can 2 is a Real Ale
• Any queries?  Post them to this thread.

Also adjusted Cog Work IPA EBC as raised by @kmar92.  I make the EBC as 24 as set out in the IanH spreadsheet below:

Cheers Shamus

[ChristinaS1]

Just noticed this thread for the first time and wanted to say a big thank you @Shamus O'Sean and for keeping it up-to-date too. What with living in Canada I can't see the monthly recipes, which sucks. But thanks your your spreadsheet, now I can see what is in them. 

Cheers,

Christina. 

[Journeyman]

2 hours ago, ChristinaS1 said:

What with living in Canada I can't see the monthly recipes, which sucks. 

The Opera browserhas a built-in VPN - you should be able to set it to Australia and then view the Coopers stuff in the browser.

[ChristinaS1]

@Journeyman I have no idea what a VPN is, and I don't use Opera. I can barley get around on the internet.

Cheers,

Christina.

[Journeyman]

1 hour ago, ChristinaS1 said:

@Journeyman I have no idea what a VPN is, and I don't use Opera. I can barley get around on the internet.

Cheers,

Christina.

 Are you an Apple user? It uses Safari to access the internet I think. Not sure what options there are there.

VPN = Virtual Private Network - basically your computer/phone accesses the internet by first logging onto a secure and random server located in various countries around the world. So your local computer/phone network address is shown to the world as one from that country. (that you choose) So if you are in Canada and want to access location-restricted content you can attach to a server in (say) Australia and Coopers would see your network address as Australian and allow you access.

People use them for porn, downloading movies and lots more - it's a good way to remain anonymous as you browse.

[ChristinaS1]

@Journeyman Yes, I am an Apple user, but I use Google Chrome as my browser. Don't know the first thing about how to find a secure server in Australia. Sounds complicated. I would not want to be bombarded by ads for porn or pirated movies. I just wish Coopers didn't block the recipes. They didn't used to. It doesn't really make sense to block them.

Cheers,

Christina.

Edited January 12, 2020 by ChristinaS1

[Journeyman]

3 minutes ago, ChristinaS1 said:

@Journeyman Yes, I am an Apple user, but I use Google Chrome as my browser. Don't know the first thing about how to find a secure server in Australia. Sounds complicated. I would not want to be bombarded by ads for porn or pirated movies. 

VPN's are not going to suddenly expose you to porn or pirate movie sites - that is strictly a choice people make IN a VPN environment.

They aren't that complex - usually you just click a country name and it connects you.

For Chrome, have a read here... https://beebom.com/free-chrome-vpn-extensions/

I guess we've gone a bit off topic now... le sigh. 

[Aussiekraut]

2 hours ago, ChristinaS1 said:

@Journeyman Yes, I am an Apple user, but I use Google Chrome as my browser. Don't know the first thing about how to find a secure server in Australia. Sounds complicated. I would not want to be bombarded by ads for porn or pirated movies. I just wish Coopers didn't block the recipes. They didn't used to. It doesn't really make sense to block them.

Cheers,

Christina.

We use ExpressVPN, so SWMBO can watch Eastenders on BBC and we can access Netflix in other countries. It costs a 10er a month or something like that and is easy as to use. They have various servers all over the world you can connect to. Works a treat on Macs, iPhones/iPads and Windows boxes.  

[Shamus O'Sean]

Hi Team

Latest Coopers Recipe Spreadsheet is attached.  February 2020 ROTM added: Citrus Sail Saison & Pufferfish Coco-Hefe.  See separate post for pdf's of these recipes.

Coopers Beer Recipes V2.7.xlsx

Spreadsheet functionality. 

• You can click on the recipe name to jump to the recipe on the Coopers website (for those in au only)
• The little triangle icons beside each column title are auto-filters and can be used to sort the spreadsheet by the respective column
• You can also use the drop boxes of the variables in each column to show those variables you want to see.  
• For example, under Difficulty if you choose the Easy variable then only those recipes rated as Easy will be displayed
• Or under Can 1, if you choose OS Real Ale only those recipes that have the Original Series Real Ale (as the main recipe can) will be displayed.  Unfortunately I am not clever enough to be able to show those recipes where Can 2 is a Real Ale
• Any queries?  Post them to this thread.

[iBooz2]

Good work @Shamus O'Sean much appreciated and the PDF's will help those OS for sure, great initiative.

i.e. https://community.diybeer.com/topic/14356-citrus-sail-saison-recipe-of-the-month/

Cheers - AL

5 hours ago, Shamus O'Sean said:

See separate post for pdf's of these recipes.

 

 

[Malter White]

You're a good man, @Shamus O'Sean.
The spreadsheet is most useful. Thanks for updating it constantly. And thanks goes also to @James of Bayswater for kicking it off.

[Shamus O'Sean]

Hi Team

Slight update to Coopers Recipe Spreadsheet.  @iBooz2 picked up that it had the wrong yeast for the Steam Beer.

Coopers Beer Recipes V2.7.1.xlsx

Spreadsheet functionality. 

• You can click on the recipe name to jump to the recipe on the Coopers website (for those in au only)
• The little triangle icons beside each column title are auto-filters and can be used to sort the spreadsheet by the respective column
• You can also use the drop boxes of the variables in each column to show those variables you want to see.  
• For example, under Difficulty if you choose the Easy variable then only those recipes rated as Easy will be displayed
• Or under Can 1, if you choose OS Real Ale only those recipes that have the Original Series Real Ale (as the main recipe can) will be displayed.  Unfortunately I am not clever enough to be able to show those recipes where Can 2 is a Real Ale
• Any queries?  Post them to this thread.

[iBooz2]

@Shamus O'Sean Thanks Shamus, was not trying to find fault in all your hard work bloke, big pat on the back for you, just curious.  There are quite a few little errors that I have noticed over the past few months in the Cooper's recipes and would have to back track a bit to remember where I found them but will post as they come to light again.  No big deal with them all, and as you say they too are probably just copy and paste errors.   I am sorry for creating more work for you, no blame intended mate.

It got me thinking, I might try to convert this spreadsheet into a database format (with your permission) which would be more graphical and we could run queries to sort or manipulate stuff to see it the way we want to.  Either an Access type DB or Web page DB format.  I am still trying to get my head around how to program all this and have everyone able to access the data but will muck around and see if I can come up with something usable.

Cheers - AL

[Shamus O'Sean]

52 minutes ago, iBooz2 said:

@Shamus O'Sean Thanks Shamus, was not trying to find fault in all your hard work bloke, big pat on the back for you, just curious.  There are quite a few little errors that I have noticed over the past few months in the Cooper's recipes and would have to back track a bit to remember where I found them but will post as they come to light again.  No big deal with them all, and as you say they too are probably just copy and paste errors.   I am sorry for creating more work for you, no blame intended mate.

It got me thinking, I might try to convert this spreadsheet into a database format (with your permission) which would be more graphical and we could run queries to sort or manipulate stuff to see it the way we want to.  Either an Access type DB or Web page DB format.  I am still trying to get my head around how to program all this and have everyone able to access the data but will muck around and see if I can come up with something usable.

Cheers - AL

Hi @iBooz2, I never took it that you were trying to do anything nefarious.  If I make a mistake I am happy to have it pointed out because then I can fix it.

I am not clever enough to go to the database level with the spreadsheet.  I just do what I know, so I can update it as new recipes come out.

I am happy for you to look into a database of recipes.  I would love a way for users to be able to say "I have got a Coopers Australian Pale Ale and some Galaxy hops and Crystal Grains - What can I brew"  I think that would be awesome.

[Malter White]

@iBooz2  @Shamus O'Sean
What's a database? What's a spreadsheet? What's a format?
You don't have to tell me what DB is. I know it's the old, low carb beer Coopers used to sell in the 70s and 80s.    

BTW, you don't have to answer my questions. I was just being an illiterate computer user.
Love what might be coming together here though with your two wise heads combining.

[Journeyman]

9 hours ago, Shamus O'Sean said:

Hi @iBooz2I am happy for you to look into a database of recipes.  I would love a way for users to be able to say "I have got a Coopers Australian Pale Ale and some Galaxy hops and Crystal Grains - What can I brew"  I think that would be awesome.

 

10 hours ago, iBooz2 said:

@Shamus O'Sean It got me thinking, I might try to convert this spreadsheet into a database format (with your permission) which would be more graphical and we could run queries to sort or manipulate stuff to see it the way we want to.  Either an Access type DB or Web page DB format.  I am still trying to get my head around how to program all this and have everyone able to access the data but will muck around and see if I can come up with something usable.

Cheers - AL

The IanH spreadsheet lets you do that @Shamus O'Sean - you can drop down the Can1 and filter by whatever you have, then either scan the list for the other ingredients or drop down those as well to filter by what you have.

@iBooz2 - the IanH SS might be a better start for a DB. It has the formulas and connections built in that you can convert to SQL or whichever you are using. I haven't touched Access for donkeys but I wouldn't like to try building such a DB in that - but then I hated it from day 1 so never bothered to learn it properly. I could do more with macros in Excel than I ever did in Access. (back then - it was about 20 - 25 years back)

I've attached the latest (I think) version of the SS.

2016 Kit & Extract Beer Designer V4.2.xls

[Thirsty Jim]

The beauty of my first spreadsheet was that it didn't go into detail.  The detail was contained on the Cooper's Recipe page which was hot-linked to the name of each brew on the spreadsheet. 

The whole idea was to identify the brews that contained common ingredients with the auto filters and then use the links to refer to the recipes for the details..   That meant a whole lot less transcription and data entry and therefore less errors.  There were still plenty of errors thanks to my fat fingers and failing eyesight but much less errors than if I had tried to incorporate the level of detail that Shamus has.  It took me four hours over two nights and a couple of bottles of suds to put it together - so no wonder there were errors.

Dropping the spreadsheet on the forum was as much about getting other eyes to proof read it as it was about sharing the goodies.   The spreadsheet is next to useless if it isn't correct so I am sure all corrections are welcome. 

But here's the thing.  I rarely use the spreadsheet these days.  I have reverted back to my default kit and kilo methods and like to keep my beer fairly simple.  Simple dry hopping is about as complicated as I get with my beer.   I like it that way.  

The one and only improvement I have made to my brewing is temperature control and only then because a suitable free fridge presented itself to me.   And that is positively as far down the rabbit hole that I am prepared to go.

It is, after all, only beer. 

(ducks for cover).

[iBooz2]

On 3/6/2020 at 12:18 PM, James of Bayswater said:

The beauty of my first spreadsheet was that it didn't go into detail.  The detail was contained on the Cooper's Recipe page which was hot-linked to the name of each brew on the spreadsheet. 

The whole idea was to identify the brews that contained common ingredients with the auto filters and then use the links to refer to the recipes for the details..   That meant a whole lot less transcription and data entry and therefore less errors.  There were still plenty of errors thanks to my fat fingers and failing eyesight but much less errors than if I had tried to incorporate the level of detail that Shamus has.  It took me four hours over two nights and a couple of bottles of suds to put it together - so no wonder there were errors.

Dropping the spreadsheet on the forum was as much about getting other eyes to proof read it as it was about sharing the goodies.   The spreadsheet is next to useless if it isn't correct so I am sure all corrections are welcome. 

But here's the thing.  I rarely use the spreadsheet these days.  I have reverted back to my default kit and kilo methods and like to keep my beer fairly simple.  Simple dry hopping is about as complicated as I get with my beer.   I like it that way.  

The one and only improvement I have made to my brewing is temperature control and only then because a suitable free fridge presented itself to me.   And that is positively as far down the rabbit hole that I am prepared to go.

It is, after all, only beer. 

(ducks for cover).

All good James, I know where you are coming from, maybe we are over complicating things a tad!

That said we should keep the SS going and update it as we go, it is a good resource.  Good luck with the newly acquired brew fridge too mate.

@Shamus O'Sean

Another correction needed maybe?

Pacific Summer Ale

Coopers recipe states Add half the Summer hops and boil for 15min.

Then add the remaining Summer hops and boil for 10min.

SS shows half the Summer hops for 10min boil then other half Summer hops for 15min boil.

Cheers - AL

[Shamus O'Sean]

12 minutes ago, iBooz2 said:

Pacific Summer Ale

Coopers recipe states Add half the Summer hops and boil for 15min.

Then add the remaining Summer hops and boil for 10min.

SS shows half the Summer hops for 10min boil then other half Summer hops for 15min boil.

Noted and corrected.  I left the first boil at 25 minutes and changed the second boil to 10 minutes.

Cheers

Coopers Beer Recipes V2.7.2.xlsx

[Shamus O'Sean]

Hi Team

Latest Coopers Recipe Spreadsheet is attached.  March 2020 ROTM added: Neon Haze Session IPA & Flashback West Coast IPA.  Click on the recipe links in red for pdf's of these recipes.

Coopers Beer Recipes V2.8.xlsx

Spreadsheet functionality. 

• You can click on the recipe name to jump to the recipe on the Coopers website (for those in au only)
• The little triangle icons beside each column title are auto-filters and can be used to sort the spreadsheet by the respective column
• You can also use the drop boxes of the variables in each column to show those variables you want to see.  
• For example, under Difficulty if you choose the Easy variable then only those recipes rated as Easy will be displayed
• Or under Can 1, if you choose OS Real Ale only those recipes that have the Original Series Real Ale (as the main recipe can) will be displayed.  Unfortunately I am not clever enough to be able to show those recipes where Can 2 is a Real Ale
• Any queries?  Post them to this thread.

[Thirsty Jim]

Or under Can 1, if you choose OS Real Ale only those recipes that have the Original Series Real Ale (as the main recipe can) will be displayed.  Unfortunately I am not clever enough to be able to show those recipes where Can 2 is a Real Ale

Why don't you just choose OS Real Ale with the Can 2 filter ?  I must be missing something...

BTW if you do choose OS Real Ale with the Can 2 filter it displays the Coopers Vintage Ales 2013 to 2017.  They are the only recipes that use Real Ale in a 2 can brew.