clean up a messy excel sheet

$10-40 USD

Selesai

Dibuat

lebih dari 9 tahun yang lalu

$10-40 USD

Dibayar ketika dikirim

Help me extract data from a sloppy, poorly-organized spreadsheet. Re-format the data into a nice, clean sheet. This is a BIG set of data, you’ll need to write a script, or use other automatic means to process it. Doing it by hand would be very tedious. Specifically: - Currently, data from 3 separate teams are side-by-side in "super columns" (separated by black bars) - Remove the totals and averages that are at the bottom of each "super column" - Combine these into one set of columns, adding a column called "team name" - Remove all the blank lines - Label “agent name” on each record (currently they are separated by colored bars, with the name listed on the first one) - Combine data from separate sheets together into one sheet. Add columns for “month”, and “year” (found in sheet name) See “sample [login to view URL]” and “sample [login to view URL]” to see what I want. To get the job, tell me how you will accomplish this. After selecting a worker, I will send the real data file in XLS or ODS format

Data Processing

Excel

ID Proyek: 6413408

Tentang proyek

5 proposal

Proyek remot

Aktif 10 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

Diberikan kepada:

@newhightech

I did the same project, by creating a Macro in Excel, to automating work if you wanna repeat the same work in the future. I can do this job for you in few time , I remain at your disposal for any remark, comment or discussion and wish you a great day. Please See my portfolio,

$35 USD dalam 3 hari

0,0

(0 ulasan)

0,0

5 freelancer menawar dengan rata-rata $30 USD untuk pekerjaan ini

@hdlong66

Hello. I've read your project description and your templates. I am able to do it quickly for you. Would you share your file, please? Kindly refer to my related projects: https://www.freelancer.com/projects/Data-Entry-Excel/Copy-spreadsheet-schedule-found-another.html https://www.freelancer.com/projects/Data-Analysis-Conditional-formatting.html https://www.freelancer.com/projects/Merge-Spreadsheets.html https://www.freelancer.com/projects/Data-Entry-Excel/Merge-Spreadsheets-into-one-that.html https://www.freelancer.com/projects/Excel-Data-Processing/some-Excel-Work.6080256.html https://www.freelancer.com/projects/Enhance-Spreadsheet.html https://www.freelancer.com/projects/Excel/Write-some-Software.5960899.html Wait for your response. Thank you and Best regards, Hoang

$40 USD dalam 1 hari

5,0

(26 ulasan)

4,2

@Ibrahim33

Hello Mr I am an experienced engineer, Professional English-Arabic translator, web designer , creative Arabic writer, Communication Specialist , web Research and data entry . My working skills High research capability. Ability to work under pressure. Open minded to new ideas and new technologies. Self-learning ability. I've the ability to work in different fields, even new fields where I gain my knowledge so fast through reading and research. Be sure your work will be done in perfect way and perfect time.

$30 USD dalam 1 hari

5,0

(4 ulasan)

2,4

@kher78

Give me a shot! As you will see I'm a new freelancer with a lot to prove. Let me prove my worth to you at risk...if I can't turn this within a day and get it back to you then you don't accept my bid. If I do then I would kindly ask that you accept my bid and provide me with a positive review. I think you will find my proposed price attractive :) Look forward to turning this spreadsheet around for you! I stand by waiting.

$15 USD dalam 0 hari

5,0

(1 ulasan)

1,0

@julianmartinez90

Hi, i'm a organized freak so i really would like to put an order to your speadsheets. I would do it with great calm and try to make everything look nice a well. I already look at the sample files and i think i can really make it out. Let me know.

$30 USD dalam 1 hari