Đã Đóng

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])

Kĩ năng: Excel, Nhập liệu, Xử lí dữ liệu, Word, Visual Basic

Về khách hàng:
( 0 nhận xét ) Reston, United States

ID dự án: #33951393

40 freelancer chào giá trung bình$457 cho công việc này

(535 Nhận xét)
8.4
(332 Nhận xét)
7.4
(255 Nhận xét)
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 Thêm

$250 USD trong 1 ngày
(175 Nhận xét)
7.1
(103 Nhận xét)
6.6
(42 Nhận xét)
6.7
(184 Nhận xét)
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 Thêm

$750 USD trong 12 ngày
(6 Nhận xét)
6.1
liveexperts123

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

$1500 USD trong 7 ngày
(9 Nhận xét)
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 Thêm

$250 USD trong 2 ngày
(60 Nhận xét)
5.5
(5 Nhận xét)
4.9
(22 Nhận xét)
4.5
(8 Nhận xét)
3.6
(3 Nhận xét)
3.3
(1 Nhận xét)
3.2
(10 Nhận xét)
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 Thêm

$500 USD trong 7 ngày
(7 Nhận xét)
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 Thêm

$500 USD trong 1 ngày
(3 Nhận xét)
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 Thêm

$500 USD trong 7 ngày
(4 Nhận xét)
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!

$250 USD trong 2 ngày
(1 Nhận xét)
1.0