Data processing - Excel work to make menus
€2-6 EUR / hour
I have up to 120 daily manu plans with ingredients, that I need to modify in terms of amounts.
I have 7 different calory balances that a daily menu needs to reach by adjusting the amount of ingredients up or down. I have created an elaborate excel tool that helps with this, so it is really just a trial and error in excel following a few basic rules. I have created an extensive video tutorial what needs to be done:
[login to view URL]
The project can be described as:
1) Copy some content from one excel to the other
2) adjust the amounts of individual food items up or down and see if certain numbers improve or become worse
3) Play arround until you are very close to the desired numbers
4) Copy these settings to somewhere else
5) play around to get the numbers really close again...
6) repeat the above.
Basic rules (will make sense after watching the tutorial):
1) if you have bread and honey and you increase the amount fo honey, try to increase the amount of bread in a similar fashion (3x as much honey is 3x as much bread)
2) Someone will have to eat this... so dont give the person 1.5 L of fruit juice to dring for breakfast... the optimal amounts are given by the program... try not to go higher than 3x that amount or lower than 0.3x that amount
3) If you cant get it to work after some trying.. leave that one menu out.. we dont need all calory balances for all menus.
This is Excel intensive.. so please dont bid if you are not familiar in excel.
This wil take many hours.. I will require the menus in batches of 5 menues per shipment continuously.
Project ID: #5488897
About the project
Awarded to:
Dear GeneticsLab, Hope you are well. I have reviewed the video in full, though the visibility of screen was not very clear,but still it was sufficient. So the point is we need to maintain balance between Carbohydrate More
19 freelancers are bidding on average €4/hour for this job
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementaiton.
i was video and want to start work on this , please give me opportunity to work with you , i glade to work with you , thanks
Hi there, I'm exert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, FARZANA PINKY.
Hello, I am an economist by education and I work as a translator and data entry clerk. Due to the nature of my work, I acquired considerable experience in data processing, I am a quick thinker and I developed a kee More
Sir I'm expert on Data Entry and Web Research and Excel. I have done many project like this . I will give you best quality and service. Hope positive reply from you. I'm ready to start now . Thanks
Hello Client, I would be greatly pleased to join your job posting involving these skills. I am very good in data handling with my skills and expertise in product entry and data entry into application, contact sourci More
Dear, I'm serious person, I can do the task accurately and perfectly. I understood this project's requirements exactly. I am representing my bid as a core interest and available to further discussion. I am waiting for More
Hi, I was laughing after reading your basic rules. Btw I am really interested to start this project and I am experienced on excel also. I am ready to deliver 5 menue per day. I may need 2 hour per day. Let;s discuss m More
Experienced computer and internet user. Experienced Excel user. Will try my best to come with some way of automating this
hi i m expert in it . and finding the jobs like this. i have lot of experince in it but the thing is that i m new to this site so my rating is low give me chance to prove my self.
I can do the job for you. I'm familiar with Excel and any kind of calculation. I'm looking forward to win this.
Hi I am a part-time caterer & have a certificate in advanced excel so I can do this job. Regards Keneilwe