Consolidate Excel Data

Job ID: 33951393

Budget: $250 – $750 USD

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: (https://drive.google.com/file/d/1jvj1USvdf24Qpf6X3fOxT4P_aJrISi8K/view?usp=sharing)

XLS FILE: (https://docs.google.com/spreadsheets/d/1nsQ0sHwkeI2-SwxZo_Ee2Z8SFy8g8zlQ/edit?usp=sharing&ouid=110911367454630976052&rtpof=true&sd=true)
Related categories: Visual Basic Data Processing Data Entry Excel Word