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
stillawip · 03/03/2024 08:57

Apologies, curry & DVD night intervened. As did a couple of glasses of Majestic’s finest….ANYWAY, I am literally going to write all these suggestions down & try them all! The trouble is, I don’t really know what I want, so it’s tricky to enunciate!
I’ll try again tho….I want to type in ‘Apple pie’ and ‘Mary Berry (recipes) book’ in columns 1 and 3, but in Column 2 I’d like an easy way of ‘labelling’ the recipe (yes, a bit like gmails, as a PP said - thank you!) to, say, 5 different categories rather than having to type 5 different lines and manually type in each category. Clear as mud? Sorry!

OP posts:
Caerulea · 03/03/2024 00:16

Oh OP you are me (if I actually followed thru with ideas). I have tracked every game of Scrabble DH & I have played (& my sons too) down to each letter used with symbols & keys for tile type. All in a beautiful slim paperblanks book. I started this cos I was convinced I get more of the i tile than anyone else.

Should I ever need to I can recreate any game we've played step by step...which has ZERO purpose! Yours does & it's wonderful.

Mapleunicorn · 02/03/2024 23:35

I don’t have advice I’m afraid, but just wanted to say how much I absolutely love this. Cracking idea op

BestIsWest · 02/03/2024 23:32

Nothing to add to the advice at the moment as whiskey has been consumed but I retired last year after (many years) working with databases and when I can’t sleep, I think of a subject and try and design a database to fit it. I may use this as an example 😂

kittensinthekitchen · 02/03/2024 23:22

I think I know exactly what you are looking for.... is it a wife? I am free for the job, thanks 😍

ScottChegg · 02/03/2024 21:57

I use chat gpt for this. You have to refine your question a bit sometimes, and sometimes it gives stupid suggestions, like the time I asked it how to feed four people with one gammon steak and it basically suggested I cut it into four pieces and put it with some potatoes.😂 (Don't worry, I was using leftovers, I don't need a food bank.)

But it has also come up with some good ideas. Like the time I told it I had a leftover bit of pork mince, a bit of beef mince and some mashing potatoes and it told me to make Swedish meatballs, which I'd never had before and wouldn't have thought of. It also suggested a very tasty sounding tagine which I have yet to make.

I don't entirely trust the actual recipes it comes up with though so I usually take the suggestion and find one on the net with a good rating.

Iudncuewbccgrcb · 02/03/2024 21:33

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 have a Samsung smart fridge and it does make some meal suggestions based on what is in the fridge but I've found it's very americanised.

We mostly use it to watch Bluey on in the morning and for the family diary and somewhere to electronically save/display our favourite family photos.

It's fab but the meal planning bit is the thing I thought I would use the most and probably gets used the least.

saltinesandcoffeecups · 02/03/2024 21:07

Here’s what I would do….

  • 1 line per recipe

columns

  • Author,
  • Book title,
  • recipe name,
  • page number (if you have it),
  • type (dessert, main, side, appetizer, etc.) you can make this a drop down list -see data validation ,
  • Main ingredient From your example this might be apples

The next columns I’d start with lumping several things in one column. These can always be separated later if you want. Just make sure you separate with a comma

  • Secondary ingredients To start you can lump multiple ingredients together separated by a comma
  • pantry ingredients now we’re getting nit picky so you don’t have to do this one would be helpful is you know your out of flour for example -separate with a comma
  • spices same as above but can help you filter if a recipe has some exotic spices that you don’t usually have on hand separate with a comma

Other helpful columns but not necessary

  • Prep Time
  • rating
  • notes

An entry might look like this:
Jones, Mary|Cooking with Excel|Apple Crumble|273|Desert|Apple|rasberry,lemon,raisins|flour,salt,rolledoats|cinnamon,allspice,vanilla

Option 1:
Use the filter function to search on the main ingredient… apple
You can then use the same filter to exclude rolled oats if you know you’re out

Option 2:
create a pivot table
play around until you get what you want… but again you can use filters to include or exclude as needed

Staringatthemoon · 02/03/2024 21:03

Download MariaDB

Enter items into database
Use Mapping tool
Add metadata terms for searching ( desserts, sweet, bake, etc)
Create the interface you want (eg: click here for all desserts, show recipe x)

Cook

Distribute to those of us who know the above but are currently waiting on a Chinese takeaway as own cooking is so abysmal 😀

Aria999 · 02/03/2024 20:58

One other thing you can try it the MealBoard app.

It has categories and can be searched by ingredient.

When I add book recipes to it I add the ingredients but then just put the book and page number instead of the 'method'.

You can also upload online recipes to it.

Wholettherabbitsout · 02/03/2024 20:45

a bibliography program would work. Zotero is free. You could enter the references for each cookbook and then make folders/groups tagged for your favorite dishes.

JJathome · 02/03/2024 20:45

tripz · 02/03/2024 20:42

@stillawip I have this. It's called BBC Good Food. 🙂

Absolutely and if you use Alexa or have an echo show you can have them read out or shown.

name a chef, a book and google, Siri or Alexa will find the recipe for you.

JJathome · 02/03/2024 20:43

Op, just use google for recipes, no need for all this.

tripz · 02/03/2024 20:42

@stillawip I have this. It's called BBC Good Food. 🙂

Collywobblewobbles · 02/03/2024 20:41

Aria999 · 02/03/2024 20:21

I do excel modeling as a large part of my job.

I don't completely understand what you are trying to do either.

I think structurally what you want is a database as pp have said. but Microsoft access is not very user friendly compared to excel.

Is your problem with entering data or finding the results or both?

Pivot tables are actually very easy but would not really help you, I agree with pp that to find the data then the filter functionality should be fine.

You can use data validation to create a dropdown list which would let you select the ingredient each time instead of typing it in (in most recent Excel you can also type a few letters and it gives you the options from your dropdown list that contain that letter combination) but you would still need multiple lines (one for each ingredient).

Is the problem that when you enter multiple lines per recipe you are having to type e.g. the category again every time? There are lookup formulas you could use to avoid that, but tbh your best bet given you need things simple is probably just to copy paste any duplicates from the first row when you have added all the lines for that recipe.

I love the data validation tool

  1. filter
  2. conditional formatting
  3. data validation

And you're away!

EcstaticMarmalade · 02/03/2024 20:39

Side note but I had forgotten Microsoft Access existed.

saltinesandcoffeecups · 02/03/2024 20:36

Collywobblewobbles · 02/03/2024 17:48

Pivot tables are a nightmare unless you're a hardcore excel user!

Nah.. they’re easy just takes a little practice… oh and since it’s excel a fair bit of swearing

70isaLimitNotaTarget · 02/03/2024 20:35

While you're at it buy a soup maker .
I have made all manner of Soups Made From Random Things ( but we're a vegetarian house except DS )

Some work better than others ( the spinach soup was quite unusual best eaten in the dark but delicious )

Aria999 · 02/03/2024 20:32

And as pp said you want separate columns for your categories (desserts, pies) not split by colons.

If you want to split it out, insert enough columns to make space then go to the data menu; text to columns; delimited; and select : as the delimiter.

Snazzysausage · 02/03/2024 20:27

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!

Maybe the MyFridgeFood or Supercook app might be what you're looking for.

Aria999 · 02/03/2024 20:21

I do excel modeling as a large part of my job.

I don't completely understand what you are trying to do either.

I think structurally what you want is a database as pp have said. but Microsoft access is not very user friendly compared to excel.

Is your problem with entering data or finding the results or both?

Pivot tables are actually very easy but would not really help you, I agree with pp that to find the data then the filter functionality should be fine.

You can use data validation to create a dropdown list which would let you select the ingredient each time instead of typing it in (in most recent Excel you can also type a few letters and it gives you the options from your dropdown list that contain that letter combination) but you would still need multiple lines (one for each ingredient).

Is the problem that when you enter multiple lines per recipe you are having to type e.g. the category again every time? There are lookup formulas you could use to avoid that, but tbh your best bet given you need things simple is probably just to copy paste any duplicates from the first row when you have added all the lines for that recipe.

burnoutbabe · 02/03/2024 20:20

What about using gmail.

Email yourself recipies and you can tag them with many headers.

The search function is pretty good too!

(Thinking outside the box)

stillawip · 02/03/2024 20:16

OMG you are all so kind and supportive on my crazy plan, thank you so much!! I will attempt to investigate and understand all of your suggestions 💕

OP posts:
slithytoveisascientist · 02/03/2024 20:15

This could be built in air table I think