Concluído

Format and Filter Data

I have an excel workbook comprised of raw data for the last 10 years split into 5 minute time periods.

The time and date is in Chicago time with the date written as a number with no seperators. For example the 17th July 2011 will be written as 110717. And the 18th July 2005 would be written as 50718

I firstly need the date formatted to dd/mm/yyyy and the time converted to sydney time. To do this you will need to take into account the daylight savings periods for both Sydney and Chicago.

Once this is done I need to isolate the data from the following two time periods each day.

- 9:50am - 10:20am (Sydney time)

- 4:00pm - 5:40pm (Sydney time)

The file is 23MB so I cant attach it here but will send it to you once the job has been accepted.

Habilidades: Processamento de Dados, Extração de Dados, Processamento de dados, Excel

Veja mais: it job sydney, it job in sydney, serial data filter, sample supplier data base format excel format, data entry format access, data sheet format, mysql data filter google map api, data sheet format excel, store data csv format, data encoder format, ajax mysql data filter, convrt data date format sql

Acerca do Empregador:
( 2 comentários ) Sydney, Australia

ID do Projeto: #7990260

Concedido a:

d2imatrix

Hi, Hi we are experts in data processing. For 23 mb data, it may not be handled in Excel and so you need some other software like SAS or SQL. Which we have. We will give you the final output in CSV. You just have to te Mais

$30 AUD em 1 dia
(18 Comentários)
4.8

29 freelancers estão ofertando em média $40 para esse trabalho

dataworker2009

Hello Sir, We are a well established company operated by experienced professionals and having good experience in various Domestic and international projects of web promotion, Market research, product adding on e-com Mais

$30 AUD em 1 dia
(516 Comentários)
7.8
nomannaumi

Hello there, thanks for the project you posted. I have read the project description and I think I will be able to take care of this project. I am very much interested in this project. Would like to discuss more. If you Mais

$30 AUD em 1 dia
(59 Comentários)
6.3
facebooklikes007

A proposal has not yet been provided

$50 AUD in 2 dias
(85 Comentários)
6.2
hdlong66

Hello, I am good at excel and able to complete this job quickly. Would you share the source file, please? I am ready to start immediately. Best regards, Hoang

$30 AUD em 1 dia
(74 Comentários)
5.8
nagybatonyi

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro conta Mais

$25 AUD em 1 dia
(55 Comentários)
5.7
pawankhurana

Hello, I've expertise in excel . I've read the details about the project. I assure you that the project will be completed with best quality. So waiting to hear positive response from your side. Thanks

$20 AUD em 1 dia
(31 Comentários)
5.0
teeares

The project no doubt is simple. However, the size of the file appears to be [login to view URL] provide a sample portion of the file, so that I can get a better idea. Please message for discussion

$66 AUD em 1 dia
(34 Comentários)
4.6
accurateG

Hello,I am interested in working on this [login to view URL] consider me.I assure you accurate and flawless [login to view URL] kindly provide me with file so that I can start [login to view URL] forward to get an opportunity to wo Mais

$75 AUD in 4 dias
(82 Comentários)
5.2
Rajni0802

Greetings, I'm interested in your proposed project and can do this task of formatting and filtering data as mentioned in the project instructions. Let's discuss further. I have skills in Web-research tasks and colle Mais

$30 AUD em 1 dia
(24 Comentários)
4.9
kevivu

Having more than than than 11 years of experience in banking /finance /accounting, business analysis, Data analysis, Web research, etc., Expert in MS EXCEL which includes Formulae, Macros (vba) , pivot, Graphs, sho Mais

$30 AUD em 1 dia
(16 Comentários)
4.2
coolomar1998

Feel free to contact [login to view URL] is not any issue as well. I have the team for rapid success rate along with quality work. We can manage each and every thing via private messages. Take a look on my 5 star feedback work Mais

$25 AUD em 1 dia
(14 Comentários)
3.9
saadrashad

i am ready to do the job. it will take time. just a little clearance needed. i am from pakistan. we dont have daylight saving time. so i want to know which period you are using daylight saving time so that i can put so Mais

$166 AUD em 1 dia
(9 Comentários)
3.7
citijayamala

Expert in excel, excel functions , macros, pivot tables and charts can format the date and time as per the required format. The bit amount is quoted as 88 as the file is 23 MB . the processing time will be very slow to Mais

$88 AUD em 1 dia
(14 Comentários)
3.8
ElaineTeo

I'm very well-verse in spreadsheets and Microsoft Excel, particularly strong in Formulas, V-Lookups, Pivoting, conditional formating, filtering and sorting.I also develop Professional Dashboards for Corporates with thi Mais

$30 AUD in 3 dias
(21 Comentários)
3.9
caleb1987

Hi Greetings we are experts in data entry and web research excel i really like to work on this project i can deliver you 100% good quality of work in time and in budget and also i have good experience in this kind Mais

$25 AUD em 1 dia
(12 Comentários)
3.5
milanmartinjuk

Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. As for my experience, you can see for yourself that I've worked here mainly as a content a Mais

$30 AUD em 1 dia
(13 Comentários)
3.2
AccuPro

Excel Expert. Job is complex. Can do. Best regards, AccuPro......................................................................

$100 AUD in 3 dias
(6 Comentários)
3.3
epdailo

this sounds like a real easy Excel solution, I can do this for the minimum rate. Practically free. please award this to me and it should only be a few minutes work.

$15 AUD em 1 dia
(2 Comentários)
2.2
najimru

A proposal has not yet been provided

$30 AUD in 3 dias
(1 Comentário)
2.1
sureshjoshuaj

I AM A LEADING PROVIDER IN ELANCE-ODESK WORKED 1400+ HOURS IN ELANCE-ODESK WITHIN A YEAR. IF YOU WANT TO CONSIDER AN EXPERIENCED PERSON WITH LOW COST AND HIGH QUALITY THAT IS ME!!! please click the link to see who Mais

$27 AUD em 1 dia
(2 Comentários)
1.9