Excel Energy Consumption of Power Meters report

DCIM_Support · ‎2020-07-03

We have Modbus TCP Power Meter (PM850) with correct DDF files, that integrated in DCE. Also have DCO with licensed Insight, ITO and ITPowerControl. How can we generate excel report by by different period of time thru Insight modul with historical data of energy consumption (kWh) of PM ?

I see two ways:

Associate PM850 in DCO with meteredPDU. But when i do that way - i only can get Power Data (W), or Current (A). Maybe you can show me other genome, that allow me to bind energy sensor from DCE ? Then generate some energy consumption report in Insight.
Generate dayly report of energy consumption in DCE to CSV file (f.e. to some FTP server). Then find way to take this data to Insight - specify Data Sorce - CSV-file. But how to work with Insight deeper than on a template level? Can i get data from several csv-files by period request from DCO ?

DCIM_Support · ‎2020-07-03

Hi antoncheg, thanks for posting. Lets see who can be of assistance here. @community any ideas? Kind regards Ditte

DCIM_Support · ‎2020-07-03

Hi Anton,

It seems you are looking for a customized solution, that could be offered as a service. However for the options/terms/details I think it would be best that you discuss this directly with Guillame Vigneron ( Vigneron Guillaume ) , thanks.

Kind regards

DCIM_Support · ‎2020-07-03

Thank you for direct a contact, who can help us. But he do not response to ouer letters. Maybe you can advise some other SE employee who can help us make this service. Thank you!

DCIM_Support · ‎2020-07-03

Hi Anton Guillaume is certainly the best path for you to progress your requirement. Can you add some more detail about your requirement? I believe DCE can be configured to produce a monthly report of the monitored kWh with the start and end values. You should be then able to use any reporting tool including SXW Insight that can read the DCE text file and produce a report. There are of course some things to be mindful of about this solution. E.g. is the PM850 environment static or does it change? Changes to meters or registers? You may also be able to use SXW Insight to read the DCE data via the API, eliminating the intermediate step. In any event, a firming understanding of your requirement will be helpful. Cheers Ed

DCIM_Support · ‎2020-07-03

Hi, Ed! The PM850 environment planned to be static. It will be prefer to getting data from DCE to SXW Insight through API. Thank You!

DCIM_Support · ‎2020-07-03

Anton, let's see what Guillaume Vigneron Guillaume comes back with. I expect what ever way you go, there will be customisation required, engineering effort and I therefore fee based. You could also reach our to Ajay Nagar who may be able to assist depending on your location. Let me know how you go.

DCIM_Support · ‎2020-07-03

Hi Anton

It's been a while for this thread. Did you get your requirement met? If so, could u post a summary of your experience?. If not, would you like to reactivate it?

Cheers

Ed

DCIM_Support · ‎2020-07-03

Hi, Ed

At last we refused this idea. And chose to install PME Server to collect energy data from PM.

Thank you for your attention!

DCIM_Support · ‎2020-07-03

Hi anton.myshanov,

Ed is correct, the way to go in your case is to develop a custom report that will cross data between DCO and DCE (using DCE API).

May I ask if all the measurements are coming from DCE or if you expect to use ITO measurements? (since you mentioned the license).

At that point of time, I'm not sure if you need technical assistance or if you need someone to develop the report for you. In the second case please contact me directly via email (guillaume.vigneron@schneider-electric.com).

DCIM_Support · ‎2020-07-03

Thanx for answer, Guillaume! PM850 mounted on main inputs and main consumptions of energy - engeneer systems like chillers. At the first step we planed to use just data from PM850. To see what impact will provide energy conservation measures on energy consumption in the past month. Second step is to interpretate consumption of servers (data from ITO). But this data can be generate in separate report. I send you e-mail but do not get response. Please check you spam box. BR!

DCIM_Support · ‎2020-07-03

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.