Ask Your Question
0

Exporting Fault Currents from PSSE to Excel v34

asked 2017-11-23 16:53:04 -0600

anonymous user

Anonymous

updated 2017-11-23 20:43:51 -0600

Hi

How do you export 3ph fault currents to excel.

Im using:

robj = pssarrays.iecs_currents(sid=sid, all=0, flt3ph=1)

to run the study and store the results in the object robj. How do i get the values within this object for multiple buses, and insert them into excel just like you would for bus numbers for example...

ierr, busses = psspy.abusint(sid=sid, flag=flag, "NUMBER")...... workbook.set_range(2, 'a', zip(*busses))

Thank you

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

answered 2017-11-28 09:06:08 -0600

perolofl gravatar image

Here is a script to make calculation for a previously selected subsystem and export peak current with method B (ipb) to excel.

import excelpy
import pssarrays
sid = 0
all = 0
cur = 'ipb'
psspy.short_circuit_coordinates(0)
robj = pssarrays.iecs_currents(sid=sid, all=all, flt3ph=1)
res1 = []
for i,ibus in enumerate(robj['fltbus']):
    res1.append(abs(robj['flt3ph'][i][cur]))

testxls = excelpy.workbook("test1.xls")
testxls.set_cell((1,'a'),'IBUS')
testxls.set_cell((1,'b'),cur)
testxls.set_range(2, 'a', zip(robj['fltbus']))
testxls.set_range(2, 'b', zip(res1))
testxls.save()
testxls.close()

Set all = 1 to calculate for all buses in system.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

[hide preview]

Question Tools

1 follower

Stats

Asked: 2017-11-23 16:53:04 -0600

Seen: 459 times

Last updated: Nov 28 '17