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

Ask Your Question
0

How to get ASCC result in excel file

asked Jan 11 '1

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.

1 answer

Sort by » oldest newest most voted
1

answered Jan 13 '1

jconto gravatar image

updated Jan 18 '1

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.)

link

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 (Jan 14 '1)

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 (Jan 14 '1)

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

jconto gravatar imagejconto (Jan 15 '1)

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 (Jan 15 '1)

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 (Jan 15 '1)

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: Jan 11 '1

Seen: 675 times

Last updated: Jan 18 '21