Excel VBA expert needed to help design automation program for food order generation for a customizable meal delivery company
$30-250 CAD
In Progress
Posted about 5 years ago
$30-250 CAD
Paid on delivery
I am looking to automate a major part of my business using excel VBA’s
Here are the major aspects of my order
Order Intake
-customer personal information (name , address, contact info. Etc )
-Customer membership type ( small, medium, large)
-Customer preferences (select from the list)
-Customer comments/notes
Recipe Intake
-Nutritioonal information ( calories, protein, fat, carbohydrates, ….)
-food cost
-food prep instruction
-Recipe scaling
Individual Order Generation
-to generate a 4 week meal plan based on 3 part combinations of menu selected by each item
-to filter through all combinations based on customer prefernces, nutritional information and food cost
Total Order generation
-To generate weekly totals for orders
-to generate shopping and prep list based on the orders
Details
This program is to generate an excel sheet of all possible combination outcomes resulting from user selected allowed items from user selected allowed categories. Each selected Item will have its own value for 8 pre-defined characteristic values.
The program allows for filtering of combination result based on user-defined limits for each of these values.
-In practice, the program is meant to generate a 4 week meal plan for individuals based on their preferred selection of ingredients and their preferred range of nutritional values.
This program also takes a total of all orders for all clients for each week and generates a weekly prep and shopping list that will be scalable.
-Each meal is put together by combining 2-6 categories. The categories are as follows Meat, Vegetables, Carbohydrates, Sauces, Spices, and Garnishes
-Each category will have its own unique recipes/items.
The user will check off all their preferred recipes/items from each category.
-Each recipes/items will have the following values assigned to it Total Cost, Calories, Protein, Fat, Carbohydrates, Cholesterol, Fiber, Sodium There also needs to be multiplier 1/3, ½ , 1, 2, 3 for each category.
This multiplier option effectively multiplies the assigned values of each recipes selected from each category. This is for example if somebody wants to double the meat but half the vegetables.
-The user next will define a preferred range for each of these values (Cost, Calories, Protein, Fat, Carbohydrates, Cholesterol, Fiber, Sodium)
Based on these restrictions the program will generate an excel sheet of all possible meal combinations.
This excel sheet will display two main sets of information section for each combination meal
• One displaying the actual combinations that visually make the meal Meat+ Vegetable+ Carbohydrate + Sauce + Spice + Garnish
• One displaying the combined nutritional value such as Total Cost, Calories, Protein, Fat, Carbohydrates, Cholesterol, Fiber, Sodium
Hello,
I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile.
Please visit : https://www.freelancer.com/u/schoudhary1553
I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you.
Kinds Regards,
Sandeep
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered seventy five excel vba projects in the last one year.
Willing to take up your project. Thank you, Regards.
1. Expert in Excel , all excel functions, formulas, pivot tables and charts, macros , vlookup, VBA,
2. Also an creating dasboards, BI tools
3. Project will be delivered on time with good quality.
4. Expert in referencing. Assurance on 0% plagiarism.
5. Will assist even after completion until client satisfaction
Hi. From your project declaration, its the kind of task that I have been experienced well. I have been experienced in programming including Excel macro since 2000. During 2006-2013, I had been working as a senior developer for Financial system developed in MS Access which use VBA for coding constantly.
Until now, I code Excel macro/VBA and experienced extremely.
I can complete your task within your requested time frame. Ready to start.
Hope to hear from you back soon.
Regards, Alta
I am a finance student with much more excel background so i can do it more professionally
Relevant Skills and Experience
I had done so many work related to this since 2014
I am a reliable, dedicated and hard working person with varied experience.
I possess excellent administrative skills and am a conscientious and thorough person wanting to provide a service that you are happy with.
I offer traditional PA services such as presentation creation, word processing, data entry, transcription and audio typing, invoicing, credit control, project management and event management. .
I pay high attention to detail and can assure you that my work will always be of the highest quality.
I am confident working on new challenges and can guarantee that your project will be returned on time and of high quality.
I look forward to working with new clients in the future. I will doing same project