Ask Your Question

How to get ASCC result in excel file

asked 2021-01-11 04:11:59 -0600

lfplan2 gravatar image

I have system of 3000 buses and I want to have the ASCC result in KVA & Amp either in excel or in output bar. Please help me regarding this. i don't know the python or commands etc.

edit retag flag offensive close merge delete

1 answer

Sort by » oldest newest most voted

answered 2021-01-12 18:29:36 -0600

jconto gravatar image

updated 2021-01-18 17:58:05 -0600

I posted a python code at my googledrivesite to export short circuit result to excel. Download “”. 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.)

edit flag offensive delete link more


While am running the script am getting the below error File "C:\Program Files (x86)\PTI\PSSE33\EXAMPLE\", line 88, in main if os.environ['PYTHONCODE']: File "C:\Python27\lib\", line 425, in __getitem__ return[key.upper()] KeyError: 'PYTHONCODE'

Berwin gravatar imageBerwin ( 2021-01-14 12:45:58 -0600 )edit

Can you please help to fix this. Or can you please help with running procedure for this script to get the results. Thanks

Berwin gravatar imageBerwin ( 2021-01-14 12:46:51 -0600 )edit

Edit the file "" and replace line 110, if os.environ['PYTHONCODE']: with: if 'PYTHONCODE' in os.environ:

jconto gravatar imagejconto ( 2021-01-15 08:20:09 -0600 )edit

The error got fixed, however I couldn't get any excel output file. And at the output bar it shows that "ASCC results not available." Also can you please help how to export IEC Fault calculation results to Excel?

Berwin gravatar imageBerwin ( 2021-01-15 08:42:07 -0600 )edit

The default run expects to find the case "savnw.sav" in the working directory. For other data, edit the scexcel.ini and update it. The module "" contains code to call IEC runs but exporting to excel might required tuning the function "export_ascc2excel".

jconto gravatar imagejconto ( 2021-01-15 09:24:44 -0600 )edit

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


Asked: 2021-01-11 04:11:59 -0600

Seen: 540 times

Last updated: Jan 18 '21