Find Jobs
Hire Freelancers

Aggregate and combine a large excel data spread across multiple documents

$30-250 AUD

Terminado
Publicado hace más de 5 años

$30-250 AUD

Pagado a la entrega
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
ID del proyecto: 17377289

Información sobre el proyecto

49 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
5,0 (151 comentarios)
6,1
6,1
49 freelancers están ofertando un promedio de $126 AUD por este trabajo
Avatar del usuario
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 en 3 días
4,9 (409 comentarios)
8,2
8,2
Avatar del usuario
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 en 2 días
4,9 (354 comentarios)
7,8
7,8
Avatar del usuario
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 en 5 días
4,9 (299 comentarios)
7,8
7,8
Avatar del usuario
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 en 2 días
4,9 (510 comentarios)
7,6
7,6
Avatar del usuario
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
4,9 (195 comentarios)
6,8
6,8
Avatar del usuario
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 en 3 días
4,9 (62 comentarios)
6,9
6,9
Avatar del usuario
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
5,0 (166 comentarios)
7,0
7,0
Avatar del usuario
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
5,0 (149 comentarios)
6,8
6,8
Avatar del usuario
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
5,0 (211 comentarios)
6,7
6,7
Avatar del usuario
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 en 3 días
5,0 (109 comentarios)
6,0
6,0
Avatar del usuario
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 en 1 día
4,8 (91 comentarios)
5,9
5,9
Avatar del usuario
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 en 3 días
4,8 (84 comentarios)
5,8
5,8
Avatar del usuario
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 en 3 días
4,9 (52 comentarios)
5,4
5,4
Avatar del usuario
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 en 3 días
4,8 (81 comentarios)
5,6
5,6
Avatar del usuario
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 en 3 días
4,9 (22 comentarios)
4,6
4,6
Avatar del usuario
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 en 3 días
5,0 (15 comentarios)
3,8
3,8
Avatar del usuario
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
5,0 (11 comentarios)
3,9
3,9
Avatar del usuario
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 en 2 días
4,7 (11 comentarios)
3,6
3,6
Avatar del usuario
I can do it perfectly and on time just send to me to start working now .
$30 AUD en 1 día
4,9 (11 comentarios)
3,4
3,4
Avatar del usuario
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 en 3 días
5,0 (5 comentarios)
3,4
3,4

Sobre este cliente

Bandera de AUSTRALIA
Castle Hill, Australia
4,9
23
Forma de pago verificada
Miembro desde may 7, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.