In Progress

Do some Excel Work -- 2

I have 2 CSV files that i would like combined into a single XLS and re-formatted. Use the May file for historical data, and then supplement this with the August data i.e. August file only to be used from May-Aug 2017. I would like all columns clear in the XLS e.g., date, time in bed, sleep quality, notes (all notes need to be separated so it's easy to identify notes on each date). In terms of outputs, I would like a simple line chart showing sleep quality over time, and a summary table showing number of days each note was recorded eg how often have i 'worked out', 'drank coffee', etc. Expect this to take 2-3 hours. Main tasks are: 1) text to columns; 2) columns to be displayed are: date, sleep quality, time in bed, bedtime, wake-up time (End), notes (all notes to be separated in separate columns) with ticks for night when they are applicable; 3) hide redundant columns; 4) ensure all dates, numbers correctly formatted

Skills: Data Processing, Excel

See more: php excel chart xls, csv chart excel, excel csv chart

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #14889840

Awarded to:

rumarahman

Hi, I am an expert excel worker and I do programming on VBA Excel to gather data from internet automatically. So that I am the suitable one you are searching for, Sir. Thanks. Relevant Skills and Experience Web Sear More

£10 GBP in 1 day
(15 Reviews)
4.5

20 freelancers are bidding on average £16 for this job

Venkylancing

HI there, i can do this job, please let me know, i will do as per your needs provided. thank you Anu Relevant Skills and Experience I am good at excels and dash boards Proposed Milestones £20 GBP - final

£20 GBP in 1 day
(143 Reviews)
6.4
datasolutionind

I have 10 years experience of Quality Controller & Team Leader in an outsourcing company. Relevant Skills and Experience I have 10 years experience of Quality Controller & Team Leader in an outsourcing company. Propo More

£20 GBP in 1 day
(75 Reviews)
6.0
rohitpithisaria

Hi... I am an excel expert. I have completed more than 100 project in excel. Relevant Skills and Experience Excel VBA Proposed Milestones £18 GBP - Milestone 1

£18 GBP in 1 day
(78 Reviews)
6.0
goodluck1234

Hello I am highly interested to do your project . I am able to refresh this with your full satisfaction . I am confident about the work . Relevant Skills and Experience excel Proposed Milestones £15.5 GBP - .

£15 GBP in 0 days
(5 Reviews)
3.7
£18 GBP in 1 day
(1 Review)
2.4
shakerhany

Please read, I am ready to start working on your project now, please contact me, no need to pay anything, if you are not happy with the outcome, Relevant Skills and Experience I have more than 8 years of experience in More

£18 GBP in 1 day
(9 Reviews)
2.5
£13 GBP in 1 day
(2 Reviews)
1.7
£11 GBP in 1 day
(0 Reviews)
0.0
harshalwalls

A proposal has not yet been provided

£17 GBP in 1 day
(0 Reviews)
0.0
uuusi

Dear employer, I can provide you 100% error free work within a very short interval of time. Please join me in the inbox for more discussions. Thanks. Relevant Skills and Experience PROFESSIONAL DATA ENTRY FACILITATO More

£18 GBP in 1 day
(0 Reviews)
0.0
arbabvw

Dear Client, I am a PhD researcher with 15 years experience in Excel. I can help you properly format the data (Splitting, cleaning, interpretation). I can do this job effectively and efficiently. Relevant Skills and More

£18 GBP in 1 day
(0 Reviews)
0.0
Ahaleem123

i have good command over Ms Excel. Do let me know Relevant Skills and Experience Ms Excel Proposed Milestones £15 GBP - upon completion

£15 GBP in 1 day
(0 Reviews)
0.0
£18 GBP in 1 day
(0 Reviews)
0.0
Raju161311106

Relevant Skills and Experience excel,data entry,ms word Proposed Milestones £18 GBP - default milestones

£18 GBP in 1 day
(0 Reviews)
0.0
£11 GBP in 1 day
(0 Reviews)
0.0
prashant3232

A proposal has not yet been provided

£10 GBP in 1 day
(0 Reviews)
0.0
sahinahmed92

Bit submitted Relevant Skills and Experience I can work with excel and have managing my fathers business with excel sheets. Proposed Milestones £15 GBP - updating the data in excel sheet is enough Stay tuned, I'm s More

£15 GBP in 2 days
(0 Reviews)
0.0
mrjoshlucas

A proposal has not yet been provided

£10 GBP in 1 day
(0 Reviews)
0.0
whitewayweb

I am interested in working on this project. I have done a similar type of work and will surely complete this project as per your expectations. Stay tuned, I'm still working on this proposal.

£18 GBP in 2 days
(0 Reviews)
0.0