Mar 14 2022 07:29 AM - edited Mar 14 2022 07:41 AM
Hello.
I'm a student on a budget, and I've been trying to make my life easier, by creating a "foodplanner" spreadsheet in Excel, that will help me save money, and save time planning.
Thing is; I don't have the skill or the experience to figure out how to solve the conundrum, that my idea(s) for what I would like this spreadsheet to be able to do, has generated.
So, I thought I'd pass my thoughts through here, and see what advice the kind, and clever people of the internet would grant me.
The idea is making a spreadsheet that will allow me to enter recipes; list the pricing of each recipe and the individual ingredients; easily pick which recipes you would like to make, for each day of a particular week, and have the spreadsheet automatically consider and figure out, what ingredients you will need to purchase, based on what ingredients you already have in your kitchen (essentially have it make a shopping list, based on the recipes picked)- and, of course, do more simple things like write out the total cost etc.
Also, it would be so cool, if the spreadsheet could calculate which of the recipes/dishes use the same ingredients, and have it come up with foodplan-suggestions, based on those ingredient synergies- let's call them. That way, it would be easier to make a foodplan, optimized for saving money!
I understand that this would probably require a bunch of manually fed data; the recipes, ingredients, store prices, which ingredients you already have, and how much of it you have left etc.
For the recipes and their ingredients, I thought to use a nice little cook-book I bought when I moved out.
For the store prices of the ingredients, I will have to do some field work in my local grocery store- buy the wares for the recipes, and enter the data into the spreadsheet.
I will also manually need to monitor which ingredients I already have, and how much of it I have left; enter this into the spreadsheet as well, and update it every week.
Thoughts and suggestions on how to solve this in a good way?
Kind regards.
- BK :)
Mar 15 2022 06:36 AM
It wouldn't be easy that's for sure.
just thinking out loud per say
Maybe if you load a few recipes
you could workout what recipes use the same ingredients
as for how much you have left well that would probably best best done manually . hmm maybe if you had a tab with ingredients and had a start figure and a couple of columns for how much you use and then delete the figures when you replenish,
Me I think I'd first list all the ingredients you have and have a start amount ie white sugar 300gm etc
I'd try keep measurements the same. Then do a couple of recipes on a separate tab each and list the ingredients and how much you need. then I would maybe have it search your ingredient list for the item and see if you have enough. Some conditional formatting who help with that. like highlight the ingredient if you don't have it or make the vale red if there's not enough. then on the recipe list you could have a column that tells you what to buy when it went below a certain level.
for me it would be coffee 2 new jars 1 open if i get to 1 new and 1 open I buy another jar. same with sugar.
Mar 15 2022 07:58 AM
Mar 15 2022 09:05 AM
Mar 17 2022 01:12 AM
Mar 17 2022 03:12 AM - edited Mar 24 2022 07:27 PM
Nice
Upload it so we can have a look and make sure it's in English
Mar 24 2022 12:20 AM - edited Mar 24 2022 12:22 AM
Hey, I can make spreadsheet as you want..I just want some more information regarding the same..Kindly contact me on my whatsapp no.+918855834107 so that I can help you at my full knowledge.