exporting dynamic simulation results to excel using python
Hello all!
Does anybody know how to export the contents of the CHANNELs after a dynamic simulation to excel, using python commands?
thanks; and best regards!
Pieter
First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!
Hello all!
Does anybody know how to export the contents of the CHANNELs after a dynamic simulation to excel, using python commands?
thanks; and best regards!
Pieter
You can try use 'dyntools' module. the function CHNF will read the dynamic simulation result files. then you can use 'xlsout' function to export to excel.
import os import sys sys.path.append('C:/Program Files (x86)/PTI/PSSEUniversity33/pssbin') sys.path.append('C:/Program Files (x86)/PTI/PSSEUniversity33/psslib')
import dyntools
achnf = dyntools.CHNF(outfile1); achnf.xlsout(self, channels='', show=True, xlsfile='', outfile='', sheet='', overwritesheet=True);
Thank you sir! It worked great! Dyntools is indeed the way to export channel data. For xlsout, pywin32 module must be installed. This didn't work for me, but i found another command to export the channel data to a txt file: chnfobj.txtout(channels=[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22], txtfile='outfile.txt')
In my case, i first did a dynamic simulation (before exporting the channel data to txt file), and before starting the dyn simulation, assigned the generator speed deviations, SPEED, to chans 1 till 22. I had 22 generators. Chan 1 corresponded to SPEED of generator 1013, chan 2 to gen 2035 annd so on
Asked: 2013-11-18 04:18:45 -0500
Seen: 3,018 times
Last updated: Nov 19 '13
How do I export short circuit data(.sc) to an excel file using pss/e and python?
API for changing tap position in dynamic simulation
Variables in dynamic simulation
Exporting data to Excel without using Python
Dynamic simulation in a for loop using PSSE35
How to ramp the value of exciter output voltage in dynamic simulation?
How can I export limit check results to excel?
IEEE 39 BUS DYNAMIC SIMULATION IN PSSE
How to manually implement load dropping (exact MW amount) during dynamic simulation?