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
SnakesAndArrows · 02/03/2024 19:16

Genius. I can’t help much, but I am cheering you on.

I’ve just learned to use Sharepoint lists, which are quite awesome, and may be what you need. I assume you’re using your spreadsheet like a fancy table and don’t use formulae or anything?

GhostOrchid · 02/03/2024 19:08

I’m not quite sure what you’re asking? To search your data more quickly or to speed up populating it.

if the former so you can, for example, just retrieve those recipes that use apples, then filtering your data is v easy as a pp said. But it slightly depends on how you’ve structured your spreadsheet.

Or it’s easy to resort alphabetically.

And I am pretty shit at Excel.

Singleandproud · 02/03/2024 19:07

I would use one note instead,
1 section per book
1 Page per recipe

Take a photo of the page with the recipe on it too
You could copy or embed your excel sheet too.

Scab99 · 02/03/2024 19:02

Omg we speak the same love language. Marry me?????

Keepithidden · 02/03/2024 18:55

MEgirl · 02/03/2024 18:46

If you PM me I can help you. I'm an IT trainer.

This is what you need OP, a professional!

Raccaccoonie · 02/03/2024 18:54

I'm trying to envisage your current sheet op... is it simply a list of books and the dish names, or have you got columns for each ingredient? If so how do you list each ingredient for each dish?

This is right up my street Grin But i have a core of several favourite recipes and tend to remember what's in them and what books they are in as I've made them thousands of times!

MEgirl · 02/03/2024 18:46

If you PM me I can help you. I'm an IT trainer.

stillawip · 02/03/2024 17:54

Collywobblewobbles · 02/03/2024 17:49

That’s very helpful, thank you - I will have a read ❤️

OP posts:
stillawip · 02/03/2024 17:51

ANiceCuppaTeaandBiscuit · 02/03/2024 17:49

Build yourself an app with Microsoft powerapps? Surprisingly easy

What?? Build an app??? I mean, you’re very kind but you are SERIOUSLY overestimating my computer skills!!! 😘

OP posts:
ANiceCuppaTeaandBiscuit · 02/03/2024 17:49

Build yourself an app with Microsoft powerapps? Surprisingly easy

AnotherSurvivor · 02/03/2024 17:48

I use Recipe Keeper app. I think it's a one-off cost of £13. You can upload recipes from a photo or website, so there's probably a way of getting data from excel. You can search for an ingredient and it will give you a list of your recipes containing that ingredient.
The free version only stores 20 recipes, not enough to be useful but you could see if you like it before you buy it.

Collywobblewobbles · 02/03/2024 17:48

stillawip · 02/03/2024 17:45

Could i?! What’s that?!

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

spiderplant56 · 02/03/2024 17:48

My husband did something similar but in reverse. He input all our recipes into a spreadsheet then each week we would select the meals we wanted for the next week and it would create a shopping list for us . No idea what excel wizardry he used though!

Nothingbuttheglory · 02/03/2024 17:47

I just Google it.

stillawip · 02/03/2024 17:46

Love51 · 02/03/2024 17:40

The easiest thing would be Ctrl+F surely?

Hmmm, sadly not as it wouldn’t tell me the ingredients in a recipe…

OP posts:
Collywobblewobbles · 02/03/2024 17:46

stillawip · 02/03/2024 17:44

I don’t know, do I?! I have no idea what those are, sorry! 🤣

Probably not then lol

If you look at the menu that goes across the top of rather spreadsheet, under 'data' you'll see 'filter' - icon looks like a metal funnel.

Highlight the row with you column headings on and then click the data filter button.

stillawip · 02/03/2024 17:45

CatherinedeBourgh · 02/03/2024 17:42

You could make it into a pivot table?

Could i?! What’s that?!

OP posts:
stillawip · 02/03/2024 17:44

Collywobblewobbles · 02/03/2024 17:42

Do you use data filters on your spreadsheet op?

They're easy to add and I don't mind helping you.

You can then filter by items in each column.

Edited

I don’t know, do I?! I have no idea what those are, sorry! 🤣

OP posts:
shellyleppard · 02/03/2024 17:43

No ideas but thank you for sharing!!!!! I have too many cookbooks and often get sidetracked trying to find a particular recipe.....so well done on being so organised x

Collywobblewobbles · 02/03/2024 17:43

stillawip · 02/03/2024 17:43

A database! Ooh, maybe that’s what I’m doing, is it?!

Yep :)

stillawip · 02/03/2024 17:43

Keepithidden · 02/03/2024 17:39

If you can get hold of a copy of Microsoft Access then that may work better. It's a database software so probably more akin to what you're looking for. Also, because it's Microsoft it should able to transfer all the info without any hassle.

I've been through similar before and been told off by an IT engineer for using Excel as a database! I'm still not sure of the difference between a spreadsheet and a database are though!

A database! Ooh, maybe that’s what I’m doing, is it?!

OP posts:
CatherinedeBourgh · 02/03/2024 17:42

You could make it into a pivot table?

Collywobblewobbles · 02/03/2024 17:42

Do you use data filters on your spreadsheet op?

They're easy to add and I don't mind helping you.

You can then filter by items in each column.

stillawip · 02/03/2024 17:41

Inspirationfailure · 02/03/2024 17:35

There is an app/website called eat your books.
i think it basically does this for you (though you have to pay)

Oh yes, I have tried that but it didn’t really work for me as I didn’t want to use their categories, eg ‘Cooking ahead’, & if I had leftover bay leaves I’d bin them, not look for a recipe filed under ‘Bay leaves’. I mean, I may be sad but I’m not a lunatic…

OP posts: