I’m trying to create a report in Excel. It will have bus voltages that deviated more than +/- 0.03 pu in a Single Contingency analysis (ACCC). I plan on using the pssexcel.accc command to bring the ACCC file data to Excel then manipulate the data to get what I want.

Currently I’ve

1. Configured the SUB,MON,CON,DFX files (Note: For the MON file I uncheck the Bus Voltage Range and Check the Bus Voltage Deviation with DROP and RISE set to 0.03 pu.)
2. Run psspy.acccwithdsp_2(...) to get a ACCC file
3. Run pssexcel.accc(...) to send the ACCC results to Excel

This sends the ACCC file to Excel, but once you look into the results you find missing data for RISE Voltage Deviation. In the Excel file only voltage deviation for DROP 0.03 pu is recorded and you only know this if you calculate the actual deviation.

I ran the same ACCC file using pssarrays.acccmultiplerunreport2(...) and this TXT report includes the DROP and RISE bus voltages which tells me the ACCC file is fine, it's how the pssexcel.accc() reads it.

Ideas? Does the pssexcel.accc command not allow bus deviation in the MON file? Is there a special function for voltage deviation instead of voltage range?

I figured it out, you need to Import psspy and initialize PSSe before Import pssexcel. PSSEXCEL won't run until the PSS/e is open and running in the terminal.

I have followed all of the tutorial on this site for setting up and running load flows in PSSe 33. I have a .acc file and I'm trying to import this data to Excel 2010. `en....

ACCC file location

ACCFILE = r"""H:......\sample_N-1.acc""" import psspy, redirect, pssexcel #end imports

pssexcel accc file import

pssexcel.accc( accfile = ACCFILE, string=['s','e','b'], colabel='', stype='contingency', busmsm=0.5, sysmsm=5.0, rating='a', namesplit=True, xlsfile='Book1.xls', sheet='', overwritesheet=True, show=True, ratecon='b', baseflowvio=False, basevoltvio=False, flowlimit=100.0, flowchange=0.0, voltchange=0.0 )

The output is: File ".\pssexcel.py", line 1140, in accc File ".\pssexcel.py", line 253, in openworkbook_worksheets File ".\excelpy.py", line 1892, in workbook File ".\excelpy.py", line 194, in init TypeError: float() argument must be a string or a number`

Any suggestions? I have the win23api in the PSSE33\PSSBIN folder.