First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!

Ask Your Question
0

Exporting Fault Currents from PSSE to Excel v34

asked Nov 23 '17

anonymous user

Anonymous

updated Nov 24 '17

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

1 answer

Sort by ยป oldest newest most voted
0

answered Nov 28 '17

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.

link

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.
Want to format code in your answer? Here is a one minute demo on Youtube

Add Answer

[hide preview]

Question Tools

1 follower

Stats

Asked: Nov 23 '17

Seen: 474 times

Last updated: Nov 28 '17