Data processing - Excel work to make menus

In Progress Posted Feb 26, 2014 Paid on delivery
In Progress

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.

Data Processing Excel Virtual Assistant

Project ID: #5488897

About the project

19 proposals Remote project Active Feb 26, 2014

Awarded to:

Toperfection

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

€4 EUR / hour
(144 Reviews)
8.0

19 freelancers are bidding on average €4/hour for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementaiton.

€6 EUR / hour
(335 Reviews)
7.8
Anamika97

Hi, I can do this job efficiently. I have more than 7 years of experience in this filed. I am flexible about working time and money. I believe work speaks better than words. Hope to have a positive response. Good day, More

€5 EUR / hour
(204 Reviews)
6.6
sknadeem123

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

€4 EUR / hour
(79 Reviews)
6.4
binaryromel

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.

€4 EUR / hour
(115 Reviews)
6.3
gillian1607

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

€4 EUR / hour
(21 Reviews)
5.7
wkcompany

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

€4 EUR / hour
(20 Reviews)
4.1
dayondonjunrie22

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

€6 EUR / hour
(5 Reviews)
4.1
cimemi

Hello, I am very experienced with Excel and, due to very good math skills, I will be able to perform your task in a timely manner. Furthermore, because of my own health (diabetiker), I am confronted with this typ More

€6 EUR / hour
(2 Reviews)
3.8
permana22sl

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

€2 EUR / hour
(16 Reviews)
3.5
shukrana2014

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

€4 EUR / hour
(3 Reviews)
2.4
atn05

Hello, I am interested in the job. I have a Master's Degree in Mathematics and an Advanced Diploma in Computer Applications. I have worked in the IT industry previously and also worked with several clients from Euro More

€4 EUR / hour
(1 Review)
2.0
nksundaram

Experienced computer and internet user. Experienced Excel user. Will try my best to come with some way of automating this

€5 EUR / hour
(2 Reviews)
2.2
krishp118

My biggest strength are: I can work with SEO, CSS, PHP, MySQL, Photoshop, HTML, Word Press, Database insertion with Amazon. I have good commanding over English. I am reliable and hard working, can work under pressur More

€4 EUR / hour
(2 Reviews)
2.3
preetikhosla

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.

€2 EUR / hour
(0 Reviews)
0.0
beeO

I can do the job for you. I'm familiar with Excel and any kind of calculation. I'm looking forward to win this.

€6 EUR / hour
(0 Reviews)
0.0
shighitec

Hi, This mail is to introduce us to you and to express our keen desire to associate with you. We are India based IT service provider having proven ability to address diverse IT requirements of our clients around More

€4 EUR / hour
(0 Reviews)
0.0
kaveetamortee

A proposal has not yet been provided

€4 EUR / hour
(0 Reviews)
0.0
keneilweM791231

Hi I am a part-time caterer & have a certificate in advanced excel so I can do this job. Regards Keneilwe

€5 EUR / hour
(0 Reviews)
0.0