Find Jobs
Hire Freelancers

Excel VBA expert needed to help design automation program for food order generation for a customizable meal delivery company

$30-250 CAD

En curso
Publicado hace más de 5 años

$30-250 CAD

Pagado a la entrega
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
ID del proyecto: 18482734

Información sobre el proyecto

8 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
8 freelancers están ofertando un promedio de $298 CAD por este trabajo
Avatar del usuario
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
$250 CAD en 4 días
4,9 (362 comentarios)
8,0
8,0
Avatar del usuario
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.000 CAD en 15 días
5,0 (115 comentarios)
6,4
6,4
Avatar del usuario
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
$155 CAD en 3 días
4,9 (140 comentarios)
6,4
6,4
Avatar del usuario
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
$300 CAD en 5 días
4,7 (70 comentarios)
5,7
5,7
Avatar del usuario
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
$244 CAD en 5 días
4,9 (20 comentarios)
5,1
5,1
Avatar del usuario
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
$155 CAD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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
$30 CAD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Port Coquitlam, Canada
5,0
3
Forma de pago verificada
Miembro desde feb 5, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.