Consolidate Excel Data
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)
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)