Ausführung von Excel-Arbeiten

€30-250 EUR

Завершено

Опублікований

over 7 years ago

€30-250 EUR

Оплачується при отриманні

I need to split up a budget according to the amount of people in that department. But not every person has the same factor and people need sorted to the departments. your task is to automate the calulation and make it so I can change the factors of the people and the mapping of departments by just editing a table. I have one big exel list with 80k lines. Each line is a person. I supply you with a sample dataset to understand the task better. the file has 3 sheets. sheet 1 is the list of people. the factors are given in the second sheet of the file and depend on two colums. In the third sheet of the file you see how to map the people to the departments. In sheet 4 you should desplay the results. I added some example values. I want you to create an exel file to calculate the values and so I can put the list of people in sheet 1 and change the mapping of deparment as well as the factors later on. so please do not use one large "if then " -statement as I do in the examplefile to calculate the factor for each line. make it so the statment refers to sheet 2 to compute the factors. I don't care if you use libre office or MS Office.

Data Entry

Data Processing

Excel

ID проекту: 11363784

Про проект

6 пропозицій(-ї)

Дистанційний проект

Активність 8 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@The24CarrotsInc

Greetings for the day. I have gone through your requirements & I am confident of helping you with this activity. We believe in building long term relationships with our customers. Thanks for your consideration. Awaiting for your reply. Thanks.

€77 EUR за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

6 фрілансерів(-и) готові виконати цю роботу у середньому за €151 EUR

@loyidtony

I am good in working with spreadsheets and creating reports i have 2 years experience with the past employer

€144 EUR за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@Antonyeducation

My Accuracy and timeliness ............................................................................................................................................................................................

€277 EUR за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@shafaqat11

Hello Sir, How are you? I have read the project and understand your requirement. I am a highly trained on Data Entry ,Research, Web search, Web scraping, Product Add, Any Type Of eCommerce Cart, Expert with great knowledge of Excel. I also can do manual/ automated data scraping work.I definitely have some questions when we discuss project. I worked with many different American Law years, Entrepreneurs and Email Marketing Company of some extensive and difficult email searching and lead generation jobs. Apart from this type of job I have experience in Administration related job, Internet research, Virtual Assistant, Business analysis, Other Excel, Data Entry, excel formula generation etc. Bset regards, Shafaqat Ali

€100 EUR за 5 дні(-в)