Completed

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

Habilidades: Entrada de datos, Procesamiento de datos, Excel

Ver más: 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

Información del empleador:
( 15 comentarios ) Castle Hill, Australia

Nº del proyecto: #17377289

Adjudicado a:

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 Más

$68 AUD en 1 día
(63 comentarios)
4.9

51 freelancers están ofertando el promedio de $125 para este trabajo

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 ( Más

$250 AUD en 3 días
(583 comentarios)
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 Más

$200 AUD en 3 días
(260 comentarios)
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 Más

$250 AUD en 2 días
(278 comentarios)
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 Más

$75 AUD en 2 días
(371 comentarios)
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 en 5 días
(140 comentarios)
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 Más

$140 AUD en 5 días
(132 comentarios)
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 en 3 días
(188 comentarios)
6.5
$120 AUD en 3 días
(137 comentarios)
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 Más

$277 AUD en 7 días
(149 comentarios)
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 Más

$250 AUD en 3 días
(66 comentarios)
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 Más

$94 AUD en 3 días
(52 comentarios)
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 Más

$120 AUD en 3 días
(41 comentarios)
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 en 3 días
(35 comentarios)
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 Más

$155 AUD en 3 días
(43 comentarios)
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 en 3 días
(39 comentarios)
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] Más

$130 AUD en 3 días
(7 comentarios)
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 Más

$155 AUD en 3 días
(11 comentarios)
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 Más

$100 AUD en 3 días
(15 comentarios)
3.8
$30 AUD en 3 días
(16 comentarios)
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 en 3 días
(9 comentarios)
3.5