How to get ASCC result in excel file

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

jconto
2851 ●11 ●33 ●42

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

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

edit flag offensive 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 ( 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 ( 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 ( 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 ( 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 ( 2021-01-15 09:24:44 -0500 )edit

see more comments

1 answer

Comments

Your Answer

Question Tools

Stats

Related questions