Extracting Bus-Level Load Data and Exporting to Excel for LMP Analysis in SAInt

General
1

Hi everyone,

I am working on a production cost modeling project in SAInt for a 39-bus system with DC power flow and unit commitment/economic dispatch enabled. My study focuses on increasing solar penetration and evaluating its impact on nodal LMPs, curtailment, and system operation.

As part of this analysis, I want to better understand the load distribution across the network and how it influences LMP behavior when additional renewable generation is introduced.

Specifically, I have the following questions:

  1. How can I identify the load at each bus (node) in the network?
    I understand that this information may be accessible through the command window, but I am looking for a structured way to view or extract bus-level load data across the system.

  2. Is there a way to export bus-level load data (preferably time-series, if available) to Excel from SAInt?
    This would help in comparing load distribution with LMP variations across scenarios.

  3. Best practice for analysis:
    I plan to add additional solar generation at selected nodes and compare the resulting LMPs with a baseline case (lower solar penetration).
    Is it appropriate to directly compare nodal LMPs across scenarios in this way, or are there recommended workflows within SAInt for performing such comparative analysis?

Any guidance on how to extract and export bus-level load data, as well as best practices for linking load distribution to LMP analysis, would be greatly appreciated.

Thank you!

2

Hello @riyansh_16

Thank you for your questions and for using SAInt.

This is a good project to use SAInt for.

Once you have loaded the network and the scenario, you can look up the demands through the model explorer tab (left of the SAInt GUI). Electric Demands are abbreviated as “EDEM“. You can view the load’s attributes.

Also, for the profile of these demands, in model explorer, you can navigate to profiles, which when you upload the desired scenario, you will be able to view the profile and it hourly values.

Yes you can export results to an excel sheet. I recommend you to follow these two brief guides:

You can use the integrated planner to feed results forward from one scenario to another for comparison. However, this is limited for two scenarios.

Our recommendation would be to export the results for each scenario, and use any tool you are comfortable with to conduct your analysis (i.e Excel, python, R, etc)

Thank you for your questions and feel free to reach out again.

2 Likes