Ukończone

Aggregate and combine a large excel data spread across multiple documents

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

Umiejętności: Wprowadzanie danych, Przetwarzanie danych, Excel

Zobacz więcej: combine rows excel based data, data analysis large excel data, multiple choice data excel, how to consolidate data in excel from multiple worksheets, copy data from multiple worksheets into one, consolidate worksheets wizard, combine multiple excel sheets into one sheet 2010, combine multiple excel sheets into one sheet, how to pull data from multiple worksheets in excel, combine multiple worksheets into one, combine multiple excel sheets into one macro, data entry, data processing, excel, visual basic for apps, microsoft excel, copy paste excel data spread, excel macro analyze multiple choice data, excel consolidate data spread sheet, excel data entry multiple choice

O pracodawcy:
( 15 ocen ) Castle Hill, Australia

Numer ID Projektu: #17377289

Przyznany użytkownikowi:

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 e Więcej

$68 AUD w 1 dzień
(63 ocen)
4.9

51 freelancerów złożyło ofertę na kwotę $125 do tego projektu

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Więcej

$250 AUD w ciągu 3 dni
(583 Oceny)
8.2
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 confiden Więcej

$200 AUD w ciągu 3 dni
(260 Oceny)
7.6
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. ZE Więcej

$250 AUD w ciągu 2 dni
(278 Oceny)
7.5
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 ta Więcej

$75 AUD w ciągu 2 dni
(371 Oceny)
7.3
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 w ciągu 5 dni
(140 Oceny)
6.9
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 k Więcej

$140 AUD w ciągu 5 dni
(132 Oceny)
6.6
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 w ciągu 3 dni
(188 Oceny)
6.5
$120 AUD w ciągu 3 dni
(137 Oceny)
6.2
koolsidz

My Credentials: 20+ of VB Experience. [login to view URL] [login to view URL] Please see my reviews. I have not disappointed ANYONE TILL date. I plan to Więcej

$277 AUD w ciągu 7 dni
(149 Oceny)
6.5
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 yo Więcej

$250 AUD w ciągu 3 dni
(66 Oceny)
5.6
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 Więcej

$94 AUD w ciągu 3 dni
(52 Oceny)
5.3
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 det Więcej

$120 AUD w ciągu 3 dni
(41 Oceny)
5.1
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 w ciągu 3 dni
(35 Oceny)
5.0
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 Więcej

$155 AUD w ciągu 3 dni
(43 Oceny)
4.8
shaily1227

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

$50 AUD w ciągu 3 dni
(39 Oceny)
4.4
RushService

Feel fee to contact me for Aggregate and combine a large excel [login to view URL] me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the [login to view URL] Więcej

$130 AUD w ciągu 3 dni
(7 Oceny)
4.2
NeetuSinghal

Hi, I have 9 yrs of experience in data analytics with [login to view URL] in Operational Research. Data Analytics - I ahve done data modeling since last 9 years a and created more than 200 models. Experience in analytical Więcej

$155 AUD w ciągu 3 dni
(11 Oceny)
3.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 a Więcej

$100 AUD w ciągu 3 dni
(15 Oceny)
3.8
$30 AUD w ciągu 3 dni
(16 Oceny)
4.0
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 w ciągu 3 dni
(9 Oceny)
3.5