Please or to access all these features

AIBU?

Share your dilemmas and get honest opinions from other Mumsnetters.

To think that I am a very sad human being but I'm going to ask anyway....

135 replies

stillawip · 02/03/2024 17:28

Hi everyone,
I have lots of cookbooks, and whenever I have something to use up in the fridge, I would like to be able to go straight to a recipe in one of my books that uses that ingredient. Or, if I want to cook a particular dish (say apple pie), I want to be able to find out quickly which of my books have a recipe for apple pie in, rather than trawling them all. So, being the sad human being that I am, some years ago I started to make an index on Microsoft Excel of all the recipes in my favourite books, and then categorising them under appropriate headings (so for apple pie it would appear if I looked under 'Apples', 'Desserts - Sweet pies' and 'Desserts - Fruit' ) thus making it easy for me to search. The list has now grown like Topsy & I would love to know how to automate what I am doing a bit more, but I don't know what that would be called!! How could I do that?

Do I need a catalogue function? An index? A drop-down list? Any ideas?!

YABU - you are a very sad human being and you should go & lie down in a darkened room for at least a year.
YANBU - this is a genius idea & here's my suggestion

OP posts:
Thread gallery
5
curlymam · 02/03/2024 20:08

My husband uses an app called Stashcook which does a lot of what you're looking for.

SevenSeasOfRhye · 02/03/2024 20:06

BIWI · 02/03/2024 19:55

Easy @SevenSeasOfRhye - cheese fondue, made with the Primula, Peroni and marge, and you dunk the corned beef into it.

<I'm here all week>

The Samsung fridge would clearly be redundant in your kitchen!

Ohthere · 02/03/2024 20:04

That sounds like the kind of thing I start with enthusiasm and then leave unused… I have an app called crouton (paid for but quite cheap), think you can take photos of recipes and it AIs it all into the app for you.

CaptainMyCaptain · 02/03/2024 20:00

NothingVenturedAndAllThat · 02/03/2024 17:33

OP this is the best thing I've read on the internet. What I want is the ability to plug in the ingredients I have and an app will produce a recipe that uses them all up!

Just Google what you have in the fridge + recipes. I do this quite often.

BookwormDadUK · 02/03/2024 19:59

Seems like @MEgirl has you covered, but as an Excel superfan, I want to heartily commend this project! It's a fantastic idea. Our many cookbooks gather dust; I'm definitely stealing your strategy.

BIWI · 02/03/2024 19:55

Easy @SevenSeasOfRhye - cheese fondue, made with the Primula, Peroni and marge, and you dunk the corned beef into it.

<I'm here all week>

SevenSeasOfRhye · 02/03/2024 19:54

Rosiiee · 02/03/2024 19:32

Oh my goodness! Have you seen the new Samsung fridge? It’s absolutely ridiculous. It scans the inside of your fridge and gives you a recipe with the ingredients that are about to expire!!

😁I wonder what it would do with the meagre contents of mine - two small bottles of Peroni, Primula cheese spread, margarine and corned beef? (I go shopping on Sundays).

BIWI · 02/03/2024 19:53

This is like trying to read a foreign language! Grin
I truly admire your endeavour @stillawip

tkwal · 02/03/2024 19:52

I voted YANBU but I don't have a constructive suggestion other than take a course , or find someone who already designs apps. I love the idea

Ready4ActionRyderSir · 02/03/2024 19:46

Import your excel file into AirTable.

thank me later!

Mumtobabyhavoc · 02/03/2024 19:38

Two old fashioned suggestions:
Post it flags on the pages of the actual books and
and a proper recipe box with favourite recipes written out on cards. The boxes come with card dividers with simple categories written on them.
I'm using my mum's and I've added to it.

Raccaccoonie · 02/03/2024 19:38

Thanks op! You need a relational database, I think Access would do the trick.

Papillon23 · 02/03/2024 19:37

I feel like what you need is a database with "tags" so i.e. you would take Apple and Blackberry Crumble and you'd tag it with "dessert" "hot" "apple" and "blackberry" or whatever.

Then when you searched "apple" everything with that tag would come back.

No idea how you actually set one of those up mind...

Collywobblewobbles · 02/03/2024 19:37

If it were me I'd probably keep using filters.

Select the recipe I want in column a, then in column b you can select which categories you want to narrow it down to.

The result would be all, for example, all 'apple sauce' recipes in 'dessert category'.

I would use conditional formatting for categories, too. So that for all desserts the row is highlighted one colour (say blue), all main courses, pink, etc.

Then I'd see at a glance what options there are.

GhostOrchid · 02/03/2024 19:36

What @CatherinedeBourgh said. You need to a more granular taxonomy.

name of recipe, book, page number, type (eg meat, fish, dessert), and then maybe 3 tags like apples, pastry, pie

pickledandpuzzled · 02/03/2024 19:36

stillawip · 02/03/2024 19:29

Yes, but I want recipes from my own books, rather than random ones from the internet...no idea why, but it just seems like a waste of money to have bought all these books & not use them!! 😂

Yeah I got rid of all my books 🤣
I buy them, read them for a couple of months, then pass them along.

CatherinedeBourgh · 02/03/2024 19:33

I'm a bit confused, why do you have multiple entries of the recipes?

I would have separate columns for each of the categories, instead of having them all in the same column. Then you can sort by category/ingredient by simply sorting by the relevant column, and it will have all the recipes which contain that ingredient/are in that category all together.

Could that work for you?

Rosiiee · 02/03/2024 19:32

Oh my goodness! Have you seen the new Samsung fridge? It’s absolutely ridiculous. It scans the inside of your fridge and gives you a recipe with the ingredients that are about to expire!!

Marmite27 · 02/03/2024 19:30

I second Access.

We used to use it at work, but a less than literate manage made us change to excel. I’m just waiting for the day it crashes and the data is unrecoverable to say I told you so!

GhostOrchid · 02/03/2024 19:30

The info in column B should be in separate columns.

CatherinedeBourgh · 02/03/2024 19:29

Well, it depends on exactly how you've built your spreadsheet, but assuming you have the ingredients in separate columns you would be able to do it. But a PP's statement about having to be a hardcore excel user makes me wonder if trying it will have you cursing me (I've put in enough all nighters struggling with excel for it to be second nature to me, but I'll have a meltdown when other software packages won't do what I want them to, so no blame there)

stillawip · 02/03/2024 19:29

pickledandpuzzled · 02/03/2024 19:24

I google ’beetroot, apples, celery, recipe’

Never fails.

Yes, but I want recipes from my own books, rather than random ones from the internet...no idea why, but it just seems like a waste of money to have bought all these books & not use them!! 😂

OP posts:
stillawip · 02/03/2024 19:27

OK, so I will try and attach a screenshot of one of the pages....I think what I'm asking is, when I type in the name of a recipe, is there a way I can easily select all the relevant categories (second column) & my computer magically create all the multiple entries for that recipe & put them in those categories? Rather than me having to type 5 lines per recipe, each one for a different category? Does that make sense?

To think that I am a very sad human being but I'm going to ask anyway....
OP posts:
pickledandpuzzled · 02/03/2024 19:24

I google ’beetroot, apples, celery, recipe’

Never fails.

burnoutbabe · 02/03/2024 19:21

I am thinking filters won't work for say apple pie as column 1 May have apple or for another recipie you decide flour is ingredient 1.