Build Excel Meal Planner Workbook
Budget: ₹600 – ₹1,500 INR
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.
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.