Find Jobs
Hire Freelancers

Reduce the time resolution from 1 minute to 1 hour for some large numeroical data sets in Excel Spreadsheets

$30-250 AUD

Completed
Posted over 9 years ago

$30-250 AUD

Paid on delivery
I have four Excel Spreadsheets containing some very large data sets. The data are collected at 1 minute intervals for four years (ie. over half a million data entries in each case). Each entry is recorded with a date and time (eg. 29/04/2014 11:47:00 PM). I need to have the resolution of this data reduced from 1 minute to 1 hour. To do that, all values within a particular hour (eg. 11:00:00 to 11:59:00) should be averaged to give a new hourly value. The data sets are obviously far to large to do this manually. It is expected that the task will need to be completely automated. An example of what these data currently look like is provided as an image in the attached file. New spreadsheets are required with the reduced resolution data.
Project ID: 6729620

About the project

32 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work. Rgds Rohit Pithisaria
$155 AUD in 3 days
4.9 (25 reviews)
4.6
4.6
32 freelancers are bidding on average $98 AUD for this job
User Avatar
Hi, I'll be happy to help you with this project. I take pride in accuracy, timely completion and support within reasonable time after completion. Please feel free to message me if you need to discuss any questions
$115 AUD in 1 day
4.8 (114 reviews)
6.5
6.5
User Avatar
A proposal has not yet been provided
$147 AUD in 1 day
4.8 (142 reviews)
6.5
6.5
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$94 AUD in 0 day
4.9 (76 reviews)
5.9
5.9
User Avatar
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 contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$50 AUD in 1 day
4.9 (55 reviews)
5.7
5.7
User Avatar
Hi, I am an excel expert. I can help you with this project,indeed it will not be done manually,but automatically. Contact me please. Kind regards, Dragos!
$50 AUD in 0 day
5.0 (35 reviews)
4.8
4.8
User Avatar
hi there can you please share a part of the file, so I can do sample for you? hope we will discuss about this project. thank you Shumon
$50 AUD in 3 days
4.9 (38 reviews)
4.6
4.6
User Avatar
Hello, Thank you for explaining the project in details and also for sharing the screen shot of the data structure. I have understood the requirement. I need to design a macro that shall iterate through the records, take all data within an hour range, calculate the average of the data that are there from column 2 and on and produce a single row of data from them. These single row outputs need to be produced in a new sheet. The time range shall also change in the output from single minutes to an hour. I do have experience with working with large data sets in excel, and I am well aware of techniques to apply that are required when dealing with large data sets. Some macros may take hours to do a work but an efficiently designed macro shall do that in minutes. If you want I can explain the techniques I'll use to make the process less time-consuming and efficient. All of my completed works here in Freelancer are about using VBA to write macros that manipulate data in various ways and manners. So far in all cases my clients have been happy with the service I provided them. I use VBA to cleanse spreadsheets, format data (based on logics) and move/manipulate them over worksheets, workbooks or office applications. Please feel free to send me a message if you would want to discuss more. With thanks & best regards Raad
$38 AUD in 1 day
4.9 (18 reviews)
4.0
4.0
User Avatar
I have gone through the description. Give me that spreadsheet. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start and finish it FAST. (tasleemnaz is my Skype ID) Tasleem Naz (Female)
$200 AUD in 2 days
4.9 (14 reviews)
3.6
3.6
User Avatar
Hello I am glad to see your project again. I can do this project. I planned to load all data to SQL Server and then create query to aggregate data from 1 minute to 1 hour. Waiting for your response.
$111 AUD in 1 day
5.0 (13 reviews)
3.4
3.4
User Avatar
Dear Employer! Thanks you for posting the project. Please give me a chance to work together with you! You will be satisfied with my work results. Yours Sincerely!
$50 AUD in 1 day
5.0 (2 reviews)
3.1
3.1
User Avatar
Hello. Could u send the file? Or Sample please. I'll create a program for this but no program, only data. When u need it? What's u'r budget for this!?
$30 AUD in 2 days
5.0 (6 reviews)
2.9
2.9
User Avatar
Your project looks easy. Please, contact me and send me a sample of your file. I'm ready to start...
$30 AUD in 1 day
5.0 (6 reviews)
2.4
2.4
User Avatar
Can you send me on of these file to can understand fully what you want? I can solve it fast if i get what;s about and i have solution.
$40 AUD in 1 day
5.0 (3 reviews)
1.2
1.2
User Avatar
Hello, I am interested in this project. It sounds very interesting. I can do this task accurately (using the VBA macro). I've done many similar projects (eg. reduce data from the stock exchange - daily to weekly). If you want I can send a sample of work (I need a file). Thank you very much Jan Krzyzak
$40 AUD in 3 days
5.0 (2 reviews)
1.1
1.1
User Avatar
Dear, Happy to find new opportunity:), hope you will be fine, please come to inbox and discuss further about this project, I will complete it soon by using some formulas.... I can do it very well more than your expectations. Please give me chance and I sure you will be next willing to work with me with your first preference. I understand this work, negotiate with me don’t ignore me as normal candidates. Thanks
$55 AUD in 1 day
5.0 (2 reviews)
1.1
1.1
User Avatar
Hi, This will be quite an easy task I just have to filter the data by date and time to easily change it. I am very proficient in Excel and have used it during my whole working career. If you have any queries, please feel free to contact me. Regards, Jessica
$133 AUD in 2 days
5.0 (2 reviews)
1.0
1.0
User Avatar
Hi, I can complete your task within one day. I am certified in advanced excel. Kindly let me know so I can start working immediatly on your requirement. Thank you
$111 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am proficient in Excel. I have worked more than 2 years as Excel and VBA trainer. In addition, I am excellent in Excel formula and functions.
$111 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i can do this work better and i hope you will like my work and remember me in your all work and i must try to very better
$111 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, I am excel working expert i can do this work can you give me one chance to work with you. Thanks, Nasir
$155 AUD in 1 day
0.0 (1 review)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
19
Member since Nov 29, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.