Ausführung von Excel-Arbeiten

€30-250 EUR

Suoritettu

Julkaistu

yli 7 vuotta sitten

€30-250 EUR

Maksettu toimituksen yhteydessä

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

Projektin tunnus (ID): 11363784

Tietoa projektista

6 ehdotukset

Etäprojekti

Aktiivinen 8 vuotta sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

Myönnetty käyttäjälle:

@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 päivässä

0,0

(0 arvostelua)

0,0

6 freelancerit tarjoavat keskimäärin €151 EUR tätä projektia

@loyidtony

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

€144 EUR 3 päivässä

0,0

(0 arvostelua)

0,0

@Antonyeducation

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

€277 EUR 3 päivässä

0,0

(0 arvostelua)

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 päivässä