I'm building an Excel template for meal planning. Anyone else done that and willing to share tips? I want it to be as fancy as possible!

like
Posting as :
works at
You are currently posting as works at

So I set one up to handle my holiday meals.

My first tab is a list of all the dishes I might possibly prepare. I've got it set up in a way that categorizes by Dish Name, Type of Dish (think entree, side, dessert, drink, or snack), Whether or not it's being served for the holiday. If it's a recipe that is available online, I've got a recipe location column. Lastly, I have a column that I input the number of servings I intend to make.

Basically the two most important inputs for this sheet are do I plan on serving it and how much do I plan on making.

My next tab is my ingredient list. It's got the dish name, whether it's being served, the ingredients necessary, how much, the unit of measure for the ingredient. From the first page I bring in the total number of servings and converts all the ingredient measurements to a standard unit of measure (either oz or eaches).

My third tab lists all the ingredients, how they are purchased, and does a conversion to that standard unit of measure of oz or eaches.

My fourth tab is a conversion of a distinct list of the units of measure that the recipes call for to oz (so think 128oz instead of 1 Gallon, or .5oz instead of a tablespoon).

My final tab is my shopping list. Based on my input on my Menu tab (First Tab), I get an output of how much of each ingredient I need to buy. I then go through my fridge and pantry to figure out how much I already have and subtract that from what I need to buy, and then round up to the nearest whole purchase quantity based on the data in my third tab.

Since I normally purchase my groceries online and pick them up, I include an additional column on my shopping list to note whether the item was available for purchase or not. If not, I know what I'm missing and I need to go look for

Anyway, I hope that helps stoke some creative juices for you!

like

My goodness… that’s some prep work. I use jhrecipes.com to store my recipes. Then, before going to buy groceries I write down which recipes I feel like making and what ingredients I need that I don’t have. Most of the times it’s just a few main ingredients that I have to write down (meat, fish, etc.) because I always buy some “base ingredients” (tomatoes, potatoes, onions, peppers, garlic) I use often and for which I don’t need a list.

What’s your goal with this? Just asking because I feel like there are plenty of apps out there that may already solve what you’re trying to do

Related Posts

Hi, I am living in pg near gtp office whose rent is very high. So searching for a single sharing room in a 2bhk flat or in a good pg with decent rent. So is there anyone searching for female roommate near gtp Kormangala or do anyone living in good pg with decent rent. Please DM me. Also searching for some North indian friends to hang out.

like

Will UST provide 100% of variable pay or what is the percentage they give us and when will they provide like end of the year

Not enough people understand mountain driving etiquette - if you see a conga line of cars behind you it’s because you’re slow and you should pull over at the next available turnout and let them pass.

like

I'm on a boat!

like
likeuplifting
likefunny

26 no debt, working in a bridge role and planning on leaving ASAP due to instability. Mom has cancer.
Considering grad school but I want no debt.
Would it be a bad idea to take out a mortgage loan and buy a quad pled in the event of a loss of income I can at least still take care of the family?

like

Max out 401k before contributing to taxable brokerage? Roth IRA is already maxed out.

like

Larsen & Toubro Hi Folks,

Kindly share your thoughts about Lnt infotech Bangalore work culture, projects and how it is compared to IBM.

LTI is expanding the Cloud BU by hiring new people for .net Azure tech stack and paying better compared to other service based MNC.


Larsen & Toubro Infotech Larsen & Toubro

like

Hello Fishes !
Anyone from SAP functional in the group?
Have some queries regarding the type of project VOIS have in Pune location .. Do we have implementation or support project?
What is the scope of learning opportunity and growth perspective?

like

Hi Folks,
I got offer as infrastructure consultant in TW, what type of projects and clients TW have fro DevOps and cloud work? Pune location.

like

Location constraint:

I have got a very good offer that i cannot deny, but location is Hyderabad, I want this in Bangalore location. I am not onboarded yet, spoke to HR , he said it is not a big problem,
Thoughtworks is very flexible.

Currently it is WFH, but once it is back to office.. I dont want to relocate. How easy it is relocate from Hyderabad to Bangalore, Thoughtworks

like

Hi Fishes, Help me to choose between SAP LABS and Walmart. Both are paying same in fixed. Yoe - 5 SAP Walmart

like

What is resource management group?

Do pharma agencies intentionally over-promote / inflate titles so you’re stuck and not really qualified to leave?

like

I feel like everyone thinks I suck & I’m the only one who doesn’t know it. I’m the lowest level creative on my team so it’s hard to tell. Do you work with someone like this? Any advice youd give them?

like

One thing they don't prepare you for when you're getting into advertising is the extent to which being a cheerleader propels you. I'm not a misanthrope, but I'm definitely not naturally wired for cheerleading and it for sure has had an adverse impact on my career.

likesmarthelpfulfunny

Trying to have faith but my recent cycle netted 16 eggs, 8 fertilized and only 2 made it to day 5 for testing. There were 3 others that just didn’t mature. This is my third cycle and I’ve been pretty positive up until today. It’s especially hard to get this news in the middle of a work day. Just tired, still bloated and not feeling all that hopeful as we enter this LONG wait until we get the results next week. I hate feeling like this knowing my chances are getting slimmer by the day.

like

What are some good practices during the sales phase of a potential project to execute before the contract is signed? Seems obvious but would love some ideas on standard operating procedures that help with seamlessly handing over a signed contract to the account team. For example, speaking to the potential client explicitly about their role in staying on schedule, reviewing scope creep consequences, etc.

like

Hi Fishes,

I am B.tech graduate and currently working in BPO sector in Accenture. I am looking to switch to an IT profile but having zero experience in IT sector. Please suggest how can I switch.

Additional Posts in Excel Genius

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Would anyone be willing to teach me vlookup?

like

Anyone know what these badges are?

Post Photo
likefunny

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

What are your top Excel ninja tricks? Ones that few people know...

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

How do I compare two sheets to make sure they are identical?

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal