Find Jobs
Hire Freelancers

Data cleaning in excel

$30-250 USD

Closed
Posted almost 6 years ago

$30-250 USD

Paid on delivery
I have a data file in which team members evaluate each other in terms of leadership. Items need to be manually sorted in excel before we can use it for our statistical analysis. Regarding the Excel sheet: - Each row includes survey responses from a single person over three days - there are columns that mention the persons' names and teams - In the current (survey) format, a set of columns describes how the team members evaluated each other’s' leadership values. The first column of the set is the rating they gave themselves. The second column is the name of the first team member they rated in the original survey form. The third column contains the rating the person gave the first member they rated in the survey. From here, it continues with all the remaining team members. Task: Rather than the structure "1) own rating 2) first other name 3) first other rating 4) second other name 5) second other rating...." we need the values a person received in their own row. For this, we need new columns in the excel sheet with this information: 1) own rating 2) first rating another team member gave this person 3) "second rating another team member gave this person..." Moreover, there are some problems in the data that I would like you to highlight. For example, if there are two rows for the same name of a team member, highlight them. Similarly, some team members evaluate people who we don’t have in our data sheet. Please highlight their names and ratings, too. There are around 100 teams and 546 team members who evaluated each other over 3 days. The task should thus not take more than a few hours of excel coding. Note: we I already had an assistant code some of the items in the gray area at the right side of the excerpt I am attaching. These exist for a fair share of the items but should be redone since we noticed a lot of mistakes. These attachments should help clarifying the task: 1) Screenshot of original survey item 2) Excerpt of the actual excel data sheet. Column A: team name, Column B: team member name, Column C-Z: Leadership ratings of day 1, Column AA-AV: Leadership ratings of day 2, AW-BP: Leadership ratings of day 3, Column BQ: Space holder, Column BR-CX: previously done ratings (these have to be redone, too) 3) Demo of how the data coding should work (yellow is what one can expect in the original sheet, green is what we need.
Project ID: 16634067

About the project

47 proposals
Remote project
Active 6 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
47 freelancers are bidding on average $117 USD for this job
User Avatar
Hi there..... Warm Greetings We came along with your request for Data cleaning in excel and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Data Entry, Excel We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$180 USD in 3 days
4.9 (404 reviews)
8.3
8.3
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD in 5 days
5.0 (469 reviews)
8.0
8.0
User Avatar
Hi, I m inetrested. I ll code the macro for this process. Feel free to talk in french if you want. Thanks ************************
$100 USD in 2 days
4.9 (310 reviews)
7.9
7.9
User Avatar
Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can do data cleaning in excel. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$200 USD in 3 days
4.9 (429 reviews)
8.1
8.1
User Avatar
Hi, there. My name's Paris Pallas and I'm an experienced Excel developer. I've completed a series of macro-enabled spreadsheets that enhance efficiency and simplify processes regarding daily tasks. Feel free to have a look at my portfolio and get an idea of my work quality and feedback given by clients of mine. I'd be thankful if you would let me know if I can be of any help. I'm looking forward to hearing from you. Regards
$140 USD in 3 days
4.9 (339 reviews)
8.0
8.0
User Avatar
Dear Client, I have vast experience in excel, I can help you in this data cleaning project. Please provide me the opportunity to carry out this project. Roy
$150 USD in 3 days
4.9 (460 reviews)
7.3
7.3
User Avatar
Each row includes survey responses from a single person over three days - there are columns that mention the persons' names and teams - In the current (survey) format, a set of columns describes how the team members evaluated each other’s' leadership values. The first column of the set is the rating they gave themselves. The second column is the name of the first team member they rated in the original survey form. The third column contains the rating the person gave the first member they rated in the survey. From here, it continues with all the remaining team members.
$65 USD in 3 days
4.9 (375 reviews)
7.0
7.0
User Avatar
Greetings! By using formulas, I have already completed the Grey section. I can share the updated file immediately. If awarded, I can complete the remaining 2 actions as well (highlighting two rows for the same name of a team member and team members in rating not in data set). Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 22 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi
$50 USD in 1 day
5.0 (215 reviews)
7.0
7.0
User Avatar
Dear Employer, I'm ready to work on data cleaning in excel project. Relevant Skills Excel, VBA Milestones 96 USD - code writing 24 USD - userfriendly interface I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations.
$121 USD in 2 days
5.0 (116 reviews)
6.6
6.6
User Avatar
Hi, AS per given details it is excel related task. I have good experience in excel related work. I am expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. If you are looking for any kind of work, I am the Right person for you. I have vast experience in lead generation, internet research, market research, data entry, data processing and all kind of backend support. I can give you best quality output with fast turn around time in competitive price. Best Regards Prakash
$50 USD in 3 days
4.9 (77 reviews)
6.1
6.1
User Avatar
Hi, Thanks for posting your requirement. I have an extensive knowledge of data processing, visualization, reporting and analysis using excel, VBA, macros and other technologies like Power BI. Please check our portfolio for works completed in past. I have understood your requirement and can surely assist you with this development. Let's connect to discuss in detail. Regards, Pranshu Agarwal
$30 USD in 1 day
4.8 (22 reviews)
5.5
5.5
User Avatar
A proposal has not yet been provided
$105 USD in 3 days
5.0 (14 reviews)
5.5
5.5
User Avatar
Hi.. I saw your project and want to help with it if you will accept my proposal.I can give you an assurance of a good job. Thanks.
$70 USD in 3 days
4.9 (22 reviews)
4.6
4.6
User Avatar
Good Day Sir I appreciate your time very importantly i won't accept your project before i made one sample to ensure, project will done in time & high quality i have 7 years working with Database administration ( Oracle, MySQL and MS Access ) Excel worksheets Word documents PDF Data entry copy typing JavaScript Power Point Photoshop Illustrator HTML5 CSS3
$78 USD in 3 days
5.0 (19 reviews)
4.5
4.5
User Avatar
A proposal has not yet been provided
$66 USD in 5 days
5.0 (2 reviews)
1.3
1.3
User Avatar
Hi Sir I hope You're doing Great. I really wanna work with you. I can Provide High quality work. Since i have 3 years of experience. I'm so excited to work with You. Thank You so much.
$35 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am Enthusiastic and dedicated, I’m seeking a project where I can grow, develop, and make an impact. With a strong skill set and relevant experience, I believe I can bring creative ideas and successful solutions to the table. Take a look through my CV site to find out more about what I have to offer - or get in touch to discuss how I can help you on your next project.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an IT Analyst with very good background in Excel functions :)
$155 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will give the best result by using my past experience and excellent academics skills on your project. You chat with me and let's get started Relevant Skills and Experience Create pivot tables and modify spreadsheets to achieve analytical goals. spreadsheets and maintain data currency to ensure accurate data availability for managers and decision-makers.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Will give you the best whatever u require
$120 USD in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWITZERLAND
St Gallen, Switzerland
5.0
9
Payment method verified
Member since Apr 5, 2018

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.