0

How to get ASCC result in excel file

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.

lfplan2's avatar
1
lfplan2
asked 2021-01-11 04:11:59 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

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

jconto's avatar
2.9k
jconto
answered 2021-01-12 18:29:36 -0500, updated 2021-01-18 17:58:05 -0500
edit flag offensive 0 remove flag delete 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's avatar Berwin (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's avatar Berwin (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's avatar jconto (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's avatar Berwin (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's avatar jconto (2021-01-15 09:24:44 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer