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

answered 2021-01-12 18:27:11 -0500

jconto
1911 ●8 ●25 ●32

I posted a python code at my googledrivesite to export short circuit result to excel. Download “SCexcel.zip”. Check the readme file for more information and how to run it. Edit the input data file to customize the study.

answered 2021-01-11 03:55:01 -0500

lfplan2
1 ●1 ●2 ●3

updated 2021-01-11 03:55:59 -0500

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

answered 2017-06-01 09:21:25 -0500

nelak
1 ●1 ●2 ●3

updated 2017-06-01 09:21:44 -0500

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.

answered 2017-06-06 11:54:47 -0500

kcruz
1 ●1

updated 2017-06-06 11:55:20 -0500

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