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.
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 !
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
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
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
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.
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
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.
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
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
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
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.
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.
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.