Format and Filter Data

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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.

Введення даних Інтелектуальний аналіз даних Обробка даних Excel

ID Проекту: #7990260

Про проект

28 заявок(-ки) Дистанційний проект Остання активність Jul 4, 2015

Доручено:

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 Більше

$30 AUD за 1 день
(33 відгуків(-и))
5.2

28 фрілансерів(-и) готові виконати цю роботу у середньому за $40

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 за 1 день
(175 відгуків(и))
7.0
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 Більше

$30 AUD за 1 день
(85 відгуків(и))
6.2
najimru

A proposal has not yet been provided

$30 AUD за 3 дні(-в)
(45 відгуків(и))
6.3
facebooklikes007

A proposal has not yet been provided

$50 AUD за 2 дні(-в)
(135 відгуків(и))
6.6
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 Більше

$88 AUD за 1 день
(83 відгуків(и))
6.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 Більше

$30 AUD за 1 день
(109 відгуків(и))
6.2
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 Більше

$25 AUD за 1 день
(64 відгуків(и))
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 за 1 день
(34 відгуків(и))
5.5
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 Більше

$25 AUD за 1 день
(27 відгуків(и))
4.8
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 Більше

$166 AUD за 1 день
(19 відгуків(и))
4.2
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 Більше

$30 AUD за 3 дні(-в)
(44 відгуків(и))
4.6
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 Більше

$30 AUD за 1 день
(22 відгуків(и))
4.3
AccuPro

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

$100 AUD за 3 дні(-в)
(6 відгуків(и))
3.2
abdfahim

Hi, I am used to handling large excel files and process them using formulas and VBA. If you want, I can do this for you. Thanks.

$30 AUD за 7 дні(-в)
(2 відгуків(и))
2.8
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 за 1 день
(2 відгуків(и))
2.2
swapnildhake

Hello, I can get the thing done for you. If you would like to try it on your own, you can try "RIGHT" function to fetch year and month. You can use "SUBSTITUTE" function to get the date (by substituting month and y Більше

$35 AUD за 1 день
(4 відгуків(и))
1.7
azmansulaiman

Hi I am from Malaysia,I am a dedicated worker. I can works for long hours on computer and have a good skill in Words and Excel also in English language

$25 AUD за 1 день
(0 відгуків(и))
0.0
zlajamilovanovic

Hello, Being an annalist, part of my job is working with Excel and databases so I can guarantee quality work. I and am almost fluid in English and have 10 mb/s internet connection. Hope to discuss details of the proj Більше

$30 AUD за 3 дні(-в)
(0 відгуків(и))
0.0
crazyamrin

Can negotiate and complete the work according to your timeline as well if the project is awarded to me.

$35 AUD за 2 дні(-в)
(0 відгуків(и))
0.0
kipltd

Hi, We have coded several crawlers and data processing tools using excel and custom codes. Your task is very easy and I would like to help you with this task. Have a nice day, Radu

$10 AUD за 2 дні(-в)
(0 відгуків(и))
0.0