Hello,
I want to create a snapshot of the power system from metering data, so basically I have all load, generation, in excel file and import it in pss/e to create the case. How can i do this using python? I mean a simple way to import all my loads/generation(MW/Mvar) to the correct locations in the columns of my case in PSS/E.
I can do it with copy paste, but i am asking for a automated way to do this.
Thank you in advance.
If you want to do this with just python, you probably want to first read your Excel file with pandas (https://pandas.pydata.org/). When you have all the data read in, you need to use individual data changing commands (psspy.busdata3, branchdata3, etc.) to input it to your case.
Hi JConto,
I am not able to perform the actions you suggest, maybe you have some example or the script in IDV, because i tried running your example, but I can't get it how to enter the data in RDCH format, normally they should be imported from excel?
I have to say I am quite new in scripting and python ect, just used PSSE v.33 from its interface.
Thank you for your support
Thank you JConto, I was able to run the idv file. My question now is how do I make the rdchtest.idv read from excel the columns of P and Q for the Load?
Consider the following (in PSSe v.33): - Create an text file with the load and gen data, in RDCH format. Adjust the columns in the source file (excel?) to match the RDCH columns sequence. Say it is saved as rdchtest.idv
RDCH template
@! RDCHtest.idv - PSSe v.33
rdch
@! enter 1= to change, 0= to replace
1
@!BEGIN BUS DATA
0 / END OF BUS DATA, BEGIN LOAD DATA
<enter load data in this section>
0 / END OF LOAD DATA, BEGIN FIXED SHUNT DATA
0 / END OF FIXED SHUNT DATA, BEGIN GENERATOR DATA
<enter generator data in this section>
0 / END OF GENERATOR DATA, BEGIN BRANCH DATA
0 / END OF BRANCH DATA, BEGIN TRANSFORMER DATA
0 / END OF TRANSFORMER DATA, BEGIN AREA DATA
0 / END OF AREA DATA, BEGIN TWO-TERMINAL DC DATA
0 / END OF TWO-TERMINAL DC DATA, BEGIN VSC DC LINE DATA
0 / END OF VSC DC LINE DATA, BEGIN IMPEDANCE CORRECTION DATA
0 / END OF IMPEDANCE CORRECTION DATA, BEGIN MULTI-TERMINAL DC DATA
0 / END OF MULTI-TERMINAL DC DATA, BEGIN MULTI-SECTION LINE DATA
0 / END OF MULTI-SECTION LINE DATA, BEGIN ZONE DATA
0 / END OF ZONE DATA, BEGIN INTER-AREA TRANSFER DATA
0 / END OF INTER-AREA TRANSFER DATA, BEGIN OWNER DATA
0 / END OF OWNER DATA, BEGIN FACTS DEVICE DATA
0 / END OF FACTS DEVICE DATA, BEGIN SWITCHED SHUNT DATA
0 / END OF SWITCHED SHUNT DATA, BEGIN GNE DATA
0 / END OF GNE DATA
Q
RCDHtest.idv example, to change bus 101 name and Pl & Ql of load at bus 153, id '1' in case savnw.sav, located in the "example" folder of the PSSe installation directory:
MENU,OFF
RDCH
1
101,'NUCLEAR-A'
0 / END OF BUS DATA, BEGIN LOAD DATA
153,'1 ',,,, 220.0, 110.0
0 / END OF LOAD DATA, BEGIN FIXED SHUNT DATA
Q
Create a text file as a python script with the command to run an idv. Saved it as rdchrun.py:
psspy.runrspnsfile('rdchtest.idv')
Now, in PSSe load the case savnw.sav and run such py code. Changes should have made to the loaded case.
Asked: 2017-11-19 12:03:16 -0600
Seen: 2,980 times
Last updated: Dec 22 '17
whit loves you. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.