Revision history [back]

Is there any way to convert a .sav to .xlxs using psspy?

I have a .sav file and I was wondering if there is any way to convert it from .sav to either .csv or .xlxs using psspy. I do know that there is a workaround in the PSS/E.

Load the file
Go to File>Export>SpreadSheet Tab to CSV file, but the problem is that it is not only somewhat cumbersome when having a bunch of .sav but also that such export does only convert a table (bus, machine, plant,... and not the entire .sav)

Is there a way this can be achieved? If not, do you know about a function in psspy that permits set a value of a particular quantity? For example: let's say I would like to change the bus base voltage (BASKV). The only way I know right now is by invoking:

ierr = bus_data_3(ibus, intgar, realar, name)

but, by using this function, psspy requires that all values within the arrays intgar and realar must be specified. Is there any setter, something like:

psspy.bus_data_set(ibus, quantity, value)

######################################

The curious thing is that psspy already in their retrieval package this function:

ierr, rarray = abusreal(sid, flag, string)

for retrieving the data of a custom quantity, ie:

Character STRING (NSTR)

NSTR of the following strings indicating the bus quantities desired (input; no default allowed). 'BASE' Bus base voltage, in kV 'PU' Actual bus voltage magnitude, in pu 'KV' Actual bus voltage magnitude, in kV (in pu if base voltage is 0.0) 'ANGLE' Bus voltage phase angle, in radians 'ANGLED' Bus voltage phase angle, in degrees 'NVLMHI' Normal high voltage limit, in pu 'NVLMLO' Normal low voltage limit, in pu 'EVLMHI' Emergency high voltage limit, in pu 'EVLMLO' Emergency low voltage limit, in pu 'MISMATCH' Bus mismatch, in MVA (0.0 if bus type code > 3) 'O_MISMATCH' Bus mismatch, in units determined by the power output option setting (0.0 if bus type code > 3)

Is there any way to convert a .sav to .xlxs using psspy?

I have a .sav file and I was wondering if there is any way to convert it from .sav to either .csv or .xlxs using psspy. I do know that there is a workaround in the PSS/E.

Load the file
Go to File>Export>SpreadSheet Tab to CSV file, but the problem is that it is not only somewhat cumbersome when having a bunch of .sav but also that such export does only convert a table (bus, machine, plant,... and not the entire .sav)

ierr = bus_data_3(ibus, intgar, realar, name)

but, by using this function, psspy requires that all values within the arrays intgar and realar must be specified. Is there any setter, something like:

psspy.bus_data_set(ibus, quantity, value)

######################################

The curious thing is that psspy already in their retrieval package this function:

ierr, rarray = abusreal(sid, flag, string)

~~for retrieving the data of a custom quantity, ie:~~

Character STRING (NSTR)

NSTR of the following strings indicating the bus quantities desired (input; no default allowed). 'BASE' Bus base voltage, Further explanation in kV 'PU' Actual bus voltage magnitude, in pu 'KV' Actual bus voltage magnitude, in kV (in pu if base voltage is 0.0) 'ANGLE' Bus voltage phase angle, in radians 'ANGLED' Bus voltage phase angle, in degrees 'NVLMHI' Normal high voltage limit, in pu 'NVLMLO' Normal low voltage limit, in pu 'EVLMHI' Emergency high voltage limit, in pu 'EVLMLO' Emergency low voltage limit, in pu 'MISMATCH' Bus mismatch, in MVA (0.0 if bus type code > 3) 'O_MISMATCH' Bus mismatch, in units determined by the power output option setting (0.0 if bus type code > 3)psspy.org/psse-help-forum/question/5827/how-to-set-a-custom-value-of-the-sav-file-using-psspy