Jump to content
Hey.gringo

Recipe difficulty rating

Recommended Posts

Hello, just had a suggestion for the website would have made my life a bit easier and may help others too. 

I’ve now got a craft fv and am planning to do 2 recipes at a time, a 23L and a 8.5L. I’m usually steeping some grains and doing a short boil so plan is to do that as usual and pick another non boil recipe to get going during that dead time. 

Ive had to go through and save recipes locally to put them in these boil/no boil categories. Was thinking on the recipe page it’d be useful to have a filter for difficulty easy/moderate/difficult. 

Sure all these things are thought through by smarter people than me, just a suggestion. 

 

Cheers

Neil

Share this post


Link to post
Share on other sites

Agreed.  It was supposed to be in there but I think either the geeks ran out of time in order to meet "go live" or we ran out of allocated funds.

Next iteration, with any luck?!

  • Thanks 1

Share this post


Link to post
Share on other sites
On 7/22/2018 at 6:18 AM, Hey.gringo said:

Hello, just had a suggestion for the website would have made my life a bit easier and may help others too. 

I’ve now got a craft fv and am planning to do 2 recipes at a time, a 23L and a 8.5L. I’m usually steeping some grains and doing a short boil so plan is to do that as usual and pick another non boil recipe to get going during that dead time. 

Ive had to go through and save recipes locally to put them in these boil/no boil categories. Was thinking on the recipe page it’d be useful to have a filter for difficulty easy/moderate/difficult. 

Sure all these things are thought through by smarter people than me, just a suggestion. 

 

Cheers

Neil

 

Hey Gringo

Check out the attached spreadsheet.  

If you know how to use Auto Filter just select the 'Blanks' option in columns Grains1 and Grains2 and there will be a list of the 109 'no boil' recipes.  

You can further filter it according to brew volume by selecting the 8.5, 9.0, 9.5, 10 litre check boxes in the Volume column which will further reduce the list to 51 recipes.  

For the large fermenter simply uncheck the 8.5, 9.0, 9.5, 10 litre check boxes in the Volume column which will then list the 58 recipes with volumes of 18 liters or more. 

Filtering the Grains columns is much more accurate than using the Difficulty levels as the Difficulty levels are not specific to the use of Grains.

PS : If you don't know how to use Auto Filter I can give you a brief guide.
 

Cooper's Recipes.xlsx

Edited by James of Bayswater
Forgot the tutorial
  • Like 1

Share this post


Link to post
Share on other sites

This is awesome! Thanks v much for sharing! 

I'm not great with excel so don't know exactly what you mean by auto filter but just selecting from those drop down menus seems to do the job if thats what you meant? Great having all the yeast/kit hops and different make up of BE1 etc all in 1 place too : )

Good work!!

Share this post


Link to post
Share on other sites

Yeah, the drop down menus are the auto filters.   

To turn them off and return the sheet to its original state  choose Data from the top menu and Filter (at least that's what you do in 2007 Excel)  And to bring the arrows back do the same thing, Data from the top menu and select Filter.

It's worth experimenting with the filters.  If click an arrow and choose Number Filters you get a lot of different options like Greater Than and Less Than,  Between, etc that allows you for customize the filter.  If you apply many filters and don't seem to be able to get back to the full list just turn the filters off.

None of it is protected so you can change anything.  I have made a couple of errors.  For example you will find I have used Mexican Cerveza and just Cerveza in the base kit descriptions, and bother Preacher's Hefe Wheat and just Hefe Wheat.  To fix it choose the Base Kit filter/ uncheck Select All/ tick the check boxes for both Cerveza and Mexican Cerveza/ then manually make them read the same so that the auto filter will catch them .  Do the same for the Wheats. 

There are no quantities because they are in the recipes and they are accessed by just clicking on the recipe name on the spreadsheet. 

Cheers.

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×