Ask Your Question
0

How to get ASCC result in excel file

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

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
1

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

jconto gravatar image

updated 2021-01-15 15:32:35 -0500

I posted a python code at my googledrivesite to export short circuit result to excel. Download “SCexcel_20210115.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 15, 2021, correcting reported bug.)

edit flag offensive delete link more

Comments

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

Berwin gravatar imageBerwin ( 2021-01-14 12:45:58 -0500 )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 -0500 )edit

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

jconto gravatar imagejconto ( 2021-01-15 08:20:09 -0500 )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 -0500 )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 "sctools.py" 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 -0500 )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

Stats

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

Seen: 53 times

Last updated: 2 days ago