Find Jobs
Hire Freelancers

Ausführung von Excel-Arbeiten

€30-250 EUR

Completed
Posted over 7 years ago

€30-250 EUR

Paid on delivery
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.
Project ID: 11363784

About the project

6 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
6 freelancers are bidding on average €151 EUR for this job
User Avatar
I am good in working with spreadsheets and creating reports i have 2 years experience with the past employer
€144 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
My Accuracy and timeliness ............................................................................................................................................................................................
€277 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€144 EUR in 6 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Heidelberg, Germany
5.0
3
Member since Feb 10, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.