0

How do I export short circuit data(.sc) to an excel file using pss/e and python?

How do I export short circuit data(.sc) to an excel file using pss/e and python?

Kabir Singh's avatar
1
Kabir Singh
asked 2017-05-30 04:33:46 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

4 Answers

0

Hi

yes this is posible , is necesary use the ascc_currents ( you can see the API manual) this function return the short circuit current and you can save the result in a variable and that write in a excel file

In this example I a use for write the 3 phase fault and line to groun fault in a excel file:

rlst = pssarrays.ascc_currents(sid= system, all = 0, flt3ph = 1, fltlg = 1 )# take the short circuit result and save in the rlst variable

excelfile.setcell((filacont,4),rlst.flt3ph[i].ia.real/1000, numberFormat = '0.00') # here write the 3 phase fault ( rlst.flt3ph[i].ia.real/1000) in KA in a excel file ( for can use excel see in the API excelpy)

excelfile.setcell((filacont,5),rlst.fltlg[i].ia.real/1000, numberFormat = '0.00') # here write the line to groun fault ( rlst.fltlg[i].ia.real/1000) in KA in a excel file

kcruz's avatar
1
kcruz
answered 2017-06-06 11:54:47 -0500, updated 2017-06-06 11:55:20 -0500
edit flag offensive 0 remove flag delete link

Comments

Thank you. Will give it a try

Kabir Singh's avatar Kabir Singh (2017-06-26 06:34:04 -0500) edit
add a comment see more comments
0

I don't have an example for this portion but you would use the command ASCC_SCFILE, this imports your scfile.

I do have an example for running Short Circuit itself and exporting this data with the ASCCCURRENTS command. The parameters would be set according to your situation. rlst = pssarrays.ascccurrents(subsystem, 0, 1, 1, 0, 0, 1, 0, 1, 0, 1, 0, 1, 2, 2, 1, 1, 1, '', '', '')

This returns an object which you can access such as: print rlst.fltbus[0] print rlst.thevzpu[0].z1 print rlst.fltlg[0].ia print rlst.flt3ph[0].ia2

Hopefully this gives you a starting point.

nelak's avatar
1
nelak
answered 2017-06-01 09:21:25 -0500, updated 2017-06-01 09:21:44 -0500
edit flag offensive 0 remove flag delete link

Comments

Thank you.

Kabir Singh's avatar Kabir Singh (2017-06-26 06:34:54 -0500) edit
add a comment see more comments
0

Hello , I am unable to get the result. I am using ASCC analysis and I wish to get the result like

" Busnumber" "Busname" "FaultLevel (MVA)" "Fault Current (Amp)"

kindly help. I am new to psse. thanks

lfplan2's avatar
1
lfplan2
answered 2021-01-11 03:55:01 -0500, updated 2021-01-11 03:55:59 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments
0

I posted a python code at my googledrivesite to export short circuit result to excel. Download “SCexcel_20210118.zip”. Check the readme file for more information and how to run it. Edit the input data file to customize the study. (update on Jan 18, 2021.)

jconto's avatar
2.9k
jconto
answered 2021-01-12 18:27:11 -0500, updated 2021-01-18 18:02:24 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

Your Answer

Login/Signup to Answer