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:
* GT 1.1
* GT 1.2
* GT 1.3
* GT 2.1
* GT 2.2
* GT 2.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
51 freelancerów złożyło ofertę na kwotę $125 do tego projektu
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
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.
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.