0

How to calculate data in PSS/E and export it to Excel?

Hello, I am using an IEEE 39 bus system for my purpose. I want to calculate some data after disturbance like voltage(PU), the rate of change of frequency, Ymatrix, inertiaconstants, load_present, angles of voltages & admittance ....to export from PSS/E to Excel. Yes I should use Python but I don't Know enough about it, so what the suitable scripts ? And what do you advice me to be greater in PSS/E and Python? Please help me,I'm very confused where to look. Kind Regards

Yasmine's avatar
5
Yasmine
asked 2015-04-22 18:11:46 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

0

To extract data from .out files to excel datasheet I use this script in python: (simply copy the code between the lines made of '#' to a .py extension file and run it, you should change the path to pss/e bin path and should run it from the same folder of your .out file, alse change the variable "name" to the name of your .out (in this case the file was "x.out" ))

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

import os,sys

sys.path.insert(0,'C:\Program Files (x86)\PTI\PSSEXplore33\PSSBIN')

os.environ['PATH'] = 'C:\Program Files (x86)\PTI\PSSEXplore33\PSSBIN'+';'+os.environ['PATH']

import excelpy

import dyntools

import time

name='x';

data=str(time.localtime().tmmday)+" do "+str(time.localtime().tmmon);

outfile = dyntools.CHNF(name+'.out')

shorttitle, chaniddict, chandatadict = outfile.getdata()

xlsfile=name+'.xlsx';

xl = excelpy.workbook(xlsfile, mode='w');

outfile.xlsout(sheet=name,overwritesheet=True);

xl.close();

xl.save();

xl.close();

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

tiagosantos's avatar
1
tiagosantos
answered 2015-04-30 03:49:44 -0500, updated 2015-04-30 03:51:07 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

Your Answer

Login/Signup to Answer