Aggregate and combine a large excel data spread across multiple documents

$30-250 AUD

Completed

Posted

almost 6 years ago

$30-250 AUD

Paid on delivery

Data from the operation of some gas turbines has been submitted to us spread across multiple excel documents where each file covers one month. Also, the data is stored in 5 minute intervals. I require the following work done to the data: * The data needs to be aggregated from 5 minute intervals, to hourly intervals using an average over the period. * The data which is currently stored in one file per month, needs to be combined so that one file contains all the data for the year. For reference, the site has 9 gas turbines arranged into 3 blocks as follows: Block 1 * GT 1.1 * GT 1.2 * GT 1.3 Block 2 * GT 2.1 * GT 2.2 * GT 2.3 Block 3 * GT 3.1 * GT 3.2 * GT 3.3 The data files are stored in two 140MB RAR files, which can be accessed using the links below: [login to view URL]!AtiaE40JkzFehvwymGxe9YrLkEy3bA [login to view URL]!AtiaE40JkzFehvwz2WATCqCmUyVf8w

Data Entry

Data Processing

Excel

Project ID: 17377289

About the project

49 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

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:

@sourabhg98

Hello, This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer specializing in creating customized excel spreadsheets for businesses and people. Currently I am at the post of FORUM EXPERT at [login to view URL] with over 400 questions answered. I am bidding on this project only after studying the details and checking the rar files you have uploaded. I can easily provide you a single sheet which has all the data aggregated on hourly basis. One question though, there are several columns in the GT sheets, so we need to average all the columns right? I look forward to a prompt and positive response from your side :) I assure the best quality of work and at the lowest prices, with free one month support for the work done by me. Please feel free to ask any questions or queries you may have. Best Sourabh

$68 AUD in 1 day

5.0

(151 reviews)

6.1

49 freelancers are bidding on average $126 AUD for this job

@schoudhary1553

Hi there, Warm Greetings We came along with your request for Aggregate and combine a large excel data spread across multiple documents and we reviewed your project description. We'd like to help you with confidence and satisfying results. We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Data Entry, Data Processing, Excel We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !

$200 AUD in 3 days

4.9

(409 reviews)

8.2

@KulfiSoftwares

Excel expert.. I can most accurately, quickly and neatly organize your data as requested... I have worked on several projects like this one before, with the help of my excel skills I can do this most efficiently. ZERO ERROR GUARANTEED!! Please read my 350+ reviews. I am here to impress you with my work.

$250 AUD in 2 days

4.9

(354 reviews)

7.8

@paris2785

Hi, there. My name's Paris Pallas, I'm an experienced Excel developer and able to work with you on this specific task you've published. By reading your brief a recent project of mine came to my mind instantly. The keyword that flashed in my mind was 5 minutes interval which, by the way, was exactly the interval in my previous project. I developed a macro (wrote code) that read data and grouped in 1-hour intervals by bringing average, sum or other grouping formulas. I can send a limited edition of my project to prove this if you'd like. Just ask for it. I'm looking forward to hearing from you soon. Paris Pallas

$140 AUD in 5 days

4.9

(299 reviews)

7.8

@SBITServices

Hello , I have checked the images & files in given linkand read your project description and understood your requirement. I have 2.5 years experience in Excel advanced concepts like VBA, Macros, Pivot table, Vlookup, Charts, Data analyser etc.. I can complete task within time with 100% accuracy. With Regards, Bhaskar

$75 AUD in 2 days

4.9

(510 reviews)

7.6

@shaily1227

Hello! I am good in excel and want to try it for sure, Looking forward to your positive response. Thanks.

$50 AUD in 3 days

4.9

(195 reviews)

6.8

@antoinepal

Hello, I am an experienced Data Analyst with advanced skills in Excel. I can give you quality work, just give me the opportunity to show you what i can do. Thanks!

$111 AUD in 3 days

4.9

(62 reviews)

6.9

@hdlong66

Hello, You need help to aggregate and combine a large excel data spread across multiple documents. I've prepared a sample for your review. I'm ready to start. Best regards, Hoang

$150 AUD in 5 days

5.0

(166 reviews)

7.0

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

$250 AUD in 3 days

5.0

(149 reviews)

6.8

@best4best

Hi, There are 216 files (36*6). I am an Excel expert and ready to process the data as per your requirement. Regards Soni

$250 AUD in 3 days

5.0

(211 reviews)

6.7

@mariusalex86

Hello. I understand the requirements of this project and I am interested to work on it. I am a reliable freelancer, focused on quality and accuracy. Good knowledge of Excel. Kindly consider my proposal. Thank you.

$250 AUD in 3 days

5.0

(109 reviews)

6.0

@lightingdavid

Hello. I have good skills in Excel/VBA. I have read your project description carefully and i can do it perfectly. Contact me please. Thanks....................................

$200 AUD in 1 day

4.8

(91 reviews)

5.9

@archanaoswal

I have excellent command on MS Excel and can write a macro to aggregate the data to hourly intervals and save yearly data in one file. I have completed complex projects in Excel before. For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites. - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs. - Built a POS and inventory management system. - Built a hotel price comparison that pulls data using the website's API. You can see the reviews of the same in my profile. Thanks, Archana

$120 AUD in 3 days

4.8

(84 reviews)

5.8

@SayTechSolution

Hi there? hope you are having a great day! I have read your project brief and can see that you would like to hire some one who can combine and organize data from 5 multiple sheet to one. I'm much interested to work on this project and wiling to start it immediately, would love to speak with you to discuss further. Kind Regards Subhash

$155 AUD in 3 days

4.9

(52 reviews)

5.4

@mail2vimalarora

Hi, I have gone through your project requirement of combining various excel files into limited files and can help you in getting it done quickly and efficiently. being experienced in working on several such excel related projects, i can take it to complete soon. Waiting for your response further. Thanks.

$94 AUD in 3 days

4.8

(81 reviews)

5.6

@abdulkarim97

Hello sir I saw your project now and I understand what you want so if you give me your project then I will give you quality work so please message me for quality work

$200 AUD in 3 days

4.9

(22 reviews)

4.6

@lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas, functions, graphs, pivot tables and Macros using VBA. I am already downloading the data! I perfectly know what you need, we just have to set the details and I’ll start working immediately The most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.

$100 AUD in 3 days

5.0

(15 reviews)

3.8

@cranius

Hi there, I downloaded the files to check and I am able to do the merge for you using VBA script. I can deliver it to you this week. I am at your disposal to discuss on chat. Thanks for the attention.

$99 AUD in 3 days

5.0

(11 reviews)

3.9

@Salesj23

hi there I have vast experience in working with excel spreadsheet using vba code and also the gui interface as per what needs to be done on the job provided I can apply and modify the excel sheet with the hourly intervals that you need also convert all into one file I can work on all your files and also the folders and applying the necessary changes that you need in less than a day with the changes as per the way you want Hope we can discuss further and I do your work

$70 AUD in 2 days

4.7

(11 reviews)

3.6

@EmanNegm0

I can do it perfectly and on time just send to me to start working now .

$30 AUD in 1 day

4.9

(11 reviews)

3.4

@nishantha041

Dear sir, I went through your project description and i can develop user friendly excel vba to achieve the task you mentioned. I’ll guarantee to support you even after the solution delivery. Thank you

$60 AUD in 3 days