Fermé

Consolidate Excel Data

I have one spreadsheet that has 15-minute data for 30 separate meters for more than 1 year of time.

The goal of the project is to combine all those meters into a single meter, being supported by a single PV system and Battery system.

What I need is a single data set of all the separate meters added up by each 15-minute interval.

The result will be a single 15-minute interval load profile for the facility as a whole.

The file is TOO big to upload, so I am including the Google Drive link:

XML FILE: ([login to view URL])

XLS FILE: ([login to view URL])

Compétences : Excel, Saisie de Données, Traitement de Données, Word, Visual Basic

Concernant le client :
( 0 commentaires ) Reston, United States

Nº du projet : #33951393

40 freelances font une offre moyenne de 457 $ pour ce travail

(535 Commentaires)
8.4
(332 Commentaires)
7.4
(255 Commentaires)
7.1
daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(175 Commentaires)
7.1
(103 Commentaires)
6.6
(42 Commentaires)
6.7
(184 Commentaires)
6.7
AwaisChaudhry

Hi, How are you? I just saw your job posting and I felt that I can help you with this job considering the experience I have with Word, Excel, Data Processing, Visual Basic and Data Entry. Please check my portfolio: h Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(6 Commentaires)
6.1
liveexperts123

..........................................................................................................

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(9 Commentaires)
6.2
hamidr2020

Hello, I have checked the file and offer my services to consolidate 15-minute data for 30 separate meters for more than 1 year of time into a single data set as per your requirements. We can discuss further details ove Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(60 Commentaires)
5.5
(5 Commentaires)
4.9
(22 Commentaires)
4.5
(8 Commentaires)
3.6
(3 Commentaires)
3.3
(1 Évaluation)
3.2
(10 Commentaires)
3.2
cheungkc

Expression of interest The sample xlsx file is 56 MB consisting about 1 million rows of one meter. Good for 30 meter worth of data. Please clarify "combine all those meters into a single meter, being supported by a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(7 Commentaires)
3.2
Maplegroupcom

Hi, I have read your project description. I can Consolidate Excel for you as per your requirement. I will sure give you 100% good quality work with unlimited revisions and changes till your satisfaction. I have ski Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
2.8
Lusy903

Dear hiring manager, I am interested in applying to this job, I have professional experience with ICRC as Relay IT/ Helpdesk, I worked for UN as Information Management Associate, currently a DevOps intern at EPAM Syste Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(4 Commentaires)
1.9
hungng945

Hi I've read the project description carefully. I'm an expert in Excel VBA. Hope you contact me to discuss project more detail. Best regards!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
1.0