smart meter on CYME

[Asi Angel]

I am working on performing load flow analysis using CYME software, and I want to utilize smart meter data to generate accurate load profiles for each customer or load point. I have exported the smart meter data (e.g., hourly or sub-hourly consumption) into Excel files. Could you guide me through the process of how to:

1. Properly format and organize this smart meter data in Excel for import into CYME?
2. Link or associate each load profile from the Excel data with the corresponding loads or nodes in my CYME network model?
3. Apply these profiles to run a load flow analysis using CYME’s time-varying or profile-based simulation capabilities?
4. Visualize or extract the results from CYME after applying these smart meter-based profiles?

Any best practices, templates, or tools that facilitate this workflow would also be appreciated.