
Closed
Posted
Paid on delivery
I’m putting together an all-in-one meal-planning spreadsheet and need someone who knows Excel inside-out (formulas, VBA, or Power Query—whatever you think works best) to turn the concept into a polished, user-friendly workbook. Here’s what the file must handle: • A searchable recipe database that lets me tag each dish as Vegetarian/Vegan, Gluten-free, Low-carb/Keto, or Non-Veg. • Automatic shopping-list generation: I choose recipes for the week and the workbook compiles quantities of every ingredient, grouped by aisle/category. • Nutritional information calculation for each recipe and for the full plan (calories, macros, plus space for any extra metrics you suggest). • Embedded pictures and clickable web links for every recipe so I can jump straight to the original source or share visually. Acceptance criteria 1. All features work without errors in the latest desktop Excel release (Windows). 2. No external add-ins required; everything runs through native Excel tools, VBA, or Power Query. 3. Filtering by dietary category instantly updates recipe lists, nutrient totals, and shopping lists. 4. Workbook is clearly laid out, locked where needed, and carries brief in-sheet instructions so anyone can use it without asking me questions. Once the core build is complete I’ll run a week of real-world testing; any little tweaks that pop up during that week are part of the scope. Deliver the unlocked master file plus a copy protected against accidental formula edits. If you’ve built similar planners or inventory systems before, I’d love to see a sample screenshot or two in your bid.
Project ID: 40398795
7 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
7 freelancers are bidding on average ₹1,529 INR for this job

With over a decade of experience in data analysis and project management, I am confident that I can deliver the meal planner workbook you need seamlessly. Being highly proficient in Excel, including VBA and Power Query, I can construct a user-friendly spreadsheet that checks off all your requirements to a tee. Filtering is key for any nutritional management system, and I'm an expert at designing databases with well-considered sorting functions. In conclusion, when you choose me for this project, not only do you benefit from my extensive technical skills but also from my passion for creating solutions that empower businesses, just as your all-in-one meal-planning spreadsheet will do. Let's connect to discuss how I can assist you further in achieving your goals with this unique project.
₹1,050 INR in 7 days
6.8
6.8

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Kindly check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Payment after completion.
₹4,000 INR in 2 days
5.1
5.1

Hello, I’d be a strong fit for this project. Building **advanced Excel systems that are functional, polished, and easy for real people to use** is exactly the kind of work I specialize in. Your meal-planning workbook can absolutely be built as an all-in-one solution using **native Excel + formulas + VBA + Power Query** (no add-ins required). ## What I will deliver: ### 1. Searchable Recipe Database • Tag recipes as Vegetarian / Vegan / Gluten-Free / Keto / Non-Veg • Search by name, ingredient, or category • Recipe images + clickable source links ### 2. Weekly Meal Planner • Select recipes for each day/week • Dropdown-driven clean interface • Auto-updating totals ### 3. Automatic Shopping List • Consolidates ingredients from selected recipes • Combines duplicate ingredients • Groups by aisle/category (Produce, Dairy, Pantry, etc.) • Printable format ### 4. Nutrition Dashboard Per recipe + full weekly plan: • Calories • Protein / Carbs / Fat • Fiber / Sugar / Sodium (optional) • Macro summary charts ### 5. User-Friendly Workbook • Clean layout • Locked formulas where needed • Instruction tab • Protected copy + unlocked master copy --- ## Why I’m a strong fit: ✔ Advanced Excel formulas, VBA, Power Query ✔ Experience building trackers/planners ✔ Strong UI sense inside spreadsheets ✔ Reliable post-delivery tweak support ---
₹1,050 INR in 7 days
0.2
0.2

This isn’t a spreadsheet—it’s a mini meal-planning engine that must stay error-proof. Most planners break when filters, nutrition, and shopping lists all depend on each other. The key is structuring data once, then letting everything update from it. I’d build this using a normalized recipe database + Power Query for clean data flow. Formulas and optional VBA will handle dynamic selections without slowing the workbook. Core system will include: • Searchable recipe database with dietary tags and filters • Weekly planner that dynamically pulls selected recipes • Auto-generated shopping list grouped by category/aisle • Nutrition engine calculating per recipe + total macros • Embedded images + clickable source links UX will be clean and guided, with locked formula zones and simple instructions. I’ve built Excel systems where multiple dependent features update instantly without breaking. ✔️ Designed dynamic Excel dashboards with Power Query + formulas ✔️ Built inventory/planner systems with auto-aggregation logic ✔️ Structured error-proof sheets with protected logic layers ✔️ Optimized large workbooks for speed and usability Key insight: separating raw data, calculations, and output views prevents 90% of Excel issues. That’s what keeps everything stable as you scale recipes. Would you prefer a fully no-VBA version for portability, or are you open to light VBA for smoother UX? — Dikshant
₹1,050 INR in 7 days
0.0
0.0

Ready to show my work! The screenshot available represents a high-level design prototype of the system’s dashboard and workflow. It’s meant to demonstrate the final structure, user experience, and capabilities of the Excel-based solution. The actual implementation is being built in Excel using Power Query, structured tables, and automation layers to match this design. Regards,
₹1,000 INR in 7 days
0.0
0.0

Mumbai, India
Payment method verified
Member since Jun 28, 2025
₹1500-12500 INR
₹1500-12500 INR
₹600-1500 INR
₹1500-12500 INR
₹1500-12500 INR
₹12500-37500 INR
$25-50 USD / hour
€30-250 EUR
$30-250 CAD
£20-250 GBP
$30-250 USD
£10-20 GBP
₹600-1500 INR
$8-15 USD / hour
$250-750 USD / hour
₹750-1250 INR / hour
₹600-1500 INR
$10-2000 USD
₹1500-12500 INR
$25-50 AUD / hour
₹600-1500 INR
₹1500-12500 INR
$8-15 USD / hour
€8-30 EUR
₹750-1250 INR / hour