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
MyLordWizardKing · 03/03/2024 13:26

If you decided to move from a spreadsheet, I wonder if a desktop wiki software be one way to achieve what you want to do?

I'm thinking you could make a page per book, with subpages for each recipe. The recipe page would be tagged with keywords that you can then search for when looking for a recipe. The additional benefit here is that you could easily record your own notes and comments on each recipe, if needed.

I might have misunderstood what you want to do but thought it was worth suggesting. I used to use one called Zim, for organising study notes.

Aria999 · 03/03/2024 12:54

Yeah, that’s why you’d need multiple columns with the same drop downs.

That's why I personally would choose to have multiple row for the same recipe instead.

stillawip · 03/03/2024 12:15

Oh it really is - every day is a school day for me! 🤣

OP posts:
SnakesAndArrows · 03/03/2024 11:20

burnoutbabe · 03/03/2024 11:14

Trouble with excel is that Apple may be ingredient 1 2 or 3. So you'd have to search all 3 ingredients column for it.

Excel less good when you have lots of "sane type of things" to include against one entry.

Yeah, that’s why you’d need multiple columns with the same drop downs. I am a total amateur though. Undoubtedly there’s a better way! Playing with Excel is such fun though. 🤣

stillawip · 03/03/2024 11:18

Lorks, you are all so clever!!!! Maybe I should start a Spreadsheet Appreciation Post 🤣🤣

OP posts:
burnoutbabe · 03/03/2024 11:14

Trouble with excel is that Apple may be ingredient 1 2 or 3. So you'd have to search all 3 ingredients column for it.

Excel less good when you have lots of "sane type of things" to include against one entry.

SnakesAndArrows · 03/03/2024 11:03

Oh hang on, I was on a completely different premise there. But the same principles apply. One term for each thing you want to search for. Don’t be afraid of multiple columns!

SnakesAndArrows · 03/03/2024 11:00

stillawip · 03/03/2024 10:23

OMG I've literally just done a drop-down list!!!! Never done one before. This may change my life....!!!
I mean, the drop down list has 7871 entries on it (yes, really, I may possibly have overthought my categories), but it's a start!!

You need to rationalise your categories and only have one term in each drop down item (e.g. “carrots” “aubergines” “ham”). Copy the column across to the right x however many ingredients you’re likely to find in the recipes and also want to search for (no salt for instance, no-one has leftover salt 😊).

Then you can then use the filters to select, say, “carrots” “aubergines” “ham” in turn in each of the first three columns and this will return only the recipes that include these three ingredients.

Conversely, you can write the book and the recipe in one column e.g. Mary Berry Easy CookBook Potato Galette because there’s no need to separate these terms.

Undoubtedly Powerapp is a better idea but getting to grips with terms in Excel is a good way to get your head around the whole concept.

zingally · 03/03/2024 10:46

I'm with you completely OP.

I'm from a family of harmless nerds, and we love a spreadsheet.

My mum has been tracking the weather on a spreadsheet for the best part of 20 years.

My sister has one for all the books she's read since she was in her late teens. She's over 40yo now.

I'm house hunting, and have a spreadsheet of houses I've seen, ranked and colour coded!

AsTheyPulledYouOutOfTheOxygenTent · 03/03/2024 10:38

I agree with the pp who said you need to split out the single column with lots of different categories, so you have one category for type of recipe (pudding/side dish/sauce etc), one for subtype (mousse, icecream/sorbet, pie etc) and one for key ingredient. Then you can filter one or many columns as required.
As pp said, the way to do that is to use the text to column tool, splitting by ":"

QueenofDrudgery · 03/03/2024 10:27

@stillawip honestly, go for the Recipe Keeper app. It covers your needs exactly.

  • add a new recipie.
- type it in, or import via a Web link, or scan from a photo of a recipie page on your shelf.
  • tag the recipie with as many categories as you want. Courses, eg lunch, dinner. Categories, casserole, chicken, slow cooker, complicated etc. Husband hates this, whatever!
When you import all of the recipie info comes in too (serving size, prep time, cook time, nutritional info, a photo). If you really want to you can build collection for example Christmas, so those recipes are separate from shepherd's pie everyday stuff.

Great, next there is a meal planner. Select how many days you want a plan for eg 6 dinners. Tell it if you don't want 'chicken' or anything you've cooked in the last 3 weeks. Accept or reject the selections until you're happy.

Use the meal planner to create a shopping list. It totals up 2 onions in one recipie with 1 in another, to tell you to buy 3 onions.

I keep a separate household shopping list there too. so I created a big 'master list" of usual household stuff, bread milk shampoo blah blah. I take a copy of that big list and copy it into that weeks recipie list and delete stuff that I don't need to buy, so now it contains the things I need for recipies and the other stuff. Easy to print the list out. Oh, and the list automatically puts stuff into categories, so dairy, canned goods, deli.

Recipies can have 'star' ratings, marked as a favourite, and have a notes section.

You can share a link to the recipie if someone else is cooking that night.

I think you want to find recipies based on ingredients. I searched 'cinnamon potato onion' and have 5 recipes that came back.

And, as if that isn't enough, you just mentioned something about the family favourite recipies to pass along to the kids. It will literally let you create your own pdf cookbook, that you could produce for child going to uni, or leaving home !

Honestly it's amazing, paid version is worth it over and over. Hope this helps :)

To think that I am a very sad human being but I'm going to ask anyway....
To think that I am a very sad human being but I'm going to ask anyway....
stillawip · 03/03/2024 10:23

LlynTegid · 03/03/2024 10:20

Drop down list is what I would choose in your shoes.

OMG I've literally just done a drop-down list!!!! Never done one before. This may change my life....!!!
I mean, the drop down list has 7871 entries on it (yes, really, I may possibly have overthought my categories), but it's a start!!

OP posts:
stillawip · 03/03/2024 10:21

zendeveloper · 03/03/2024 10:19

Yes, but you can feed them to ChatGPT and ask to catalogue for you, rather than do it manually.

Ooh, that scares me!!! ChatGPT? Isn't that something to do with AI? Knowing me, I'd create a monster....

OP posts:
LlynTegid · 03/03/2024 10:20

Drop down list is what I would choose in your shoes.

zendeveloper · 03/03/2024 10:19

GhostOrchid · 03/03/2024 10:17

OP doesn’t want to Google/ChaTGDP recipes for certain ingredients! She wants to catalogue the recipes in her existing collection, which is a great idea.

Yes, but you can feed them to ChatGPT and ask to catalogue for you, rather than do it manually.

GhostOrchid · 03/03/2024 10:17

OP doesn’t want to Google/ChaTGDP recipes for certain ingredients! She wants to catalogue the recipes in her existing collection, which is a great idea.

zendeveloper · 03/03/2024 10:10

I haven't read the whole thread, but has anyone suggested ChatGPT already?

I found it brilliant for tasks like this (admittedly, I don't use it for the list of ingredients, but rather to find a recipe that excludes certain ingredients and flavour profiles, as all my family is picky eaters and the resulting venn diagrams of who eats what are ridiculous). Also to adjust workout routines under similar inclusion / exclusion principle (this hurts, this is injured, write me a 30 mins workout programm).

Raccaccoonie · 03/03/2024 10:03

"Go on google"
"Go on recipe sites"

Bloody hell. Read the OP. She doesn't want to wade through thousands of decreasingly relevant Google results, she wants to categorise a specific set of recipes in specific books in a way that is useful to her.

SickofSoup · 03/03/2024 09:56

Power app. (Edited to add - create your own power app)

Alcyoneus · 03/03/2024 09:55

Doesn’t google just tell you this if you type that in? And with millions more up to day results

GhostOrchid · 03/03/2024 09:44

I’m not really sure what you mean by 5 different lines, but you need more columns than 3.

Every individual cell in your table needs to have one bit of data in it. You’ve put in 5 bits of data in column B. You need to split them out. That will make it easier and quicker to populate and easier to search.

stillawip · 03/03/2024 09:23

Ye, I did try Eat Your Books a few years ago, but it didn’t have lots of my books on it at the time, and I couldn’t work out how to copy & paste it into my format….but maybe I should revisit it now. 🙏🏼

OP posts:
ladyofshertonabbas · 03/03/2024 09:17

I used to do this. Subscribe to Eat Your Books. You tell it the books you have, creating one giant index of your books. It’s great.

stillawip · 03/03/2024 09:14

Ps it is my absolute dream that at some point in the future, my children will be heard to say “oh there’s nothing like mums apple pie/sticky toffee pudding/chocolate cake” and so sometimes we have Test Kitchen Sunday lunches, where I’ll find all the recipes in my books for apple pie/ sticky toffee pudding/ chocolate cake and then I’ll cook them all and we sit round the table and judge them all, vote which is the best and then that one becomes Mum’s Recipe, forever enshrined in family folklore. Told you I was sad!!!!!

OP posts:
stillawip · 03/03/2024 09:01

Btw, some of the other ideas (eg the Scrabble one) are utter genius and I have clearly found my tribe here. These things truly thrill me - my holiday packing list (covering various holiday scenarios with or without the dogs) genuinely stretches to 8 pages 🤣🤣🤣

OP posts: