Input data from Excel to PSSE

edit

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.

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

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.