Ask Your Question

PSSE excel export failed

asked 2014-02-28 09:29:08 -0500

Tak gravatar image

I need some help.

I used the following script. PSSE succeeded in exporting acc file in excel when contingencies were small numbers. However, PSSE failed in exporting acc file in excel when contingencies were large numbers.

pssexcel.accc(caseset+'.acc', string=['s','e','b','','v','','',''],colabel='',stype='', busmsm=0.5,rating='a', namesplit=True,xlsfile=caseset, sheet='', overwritesheet=True, show=False,ratecon='c', baseflowvio=True, basevoltvio=True,flowlimit=100, flowchange=0.0, voltchange=0.0)

PSSE exported excel file contains a lot of 0 voltages. How do I export without having 0 voltages?

edit retag flag offensive close merge delete


Thank you for the answer. (2) will solve my problems. I need to find out how to stop exporting 0 voltages from islands. The problems is that Excel will overflow if PSSE exports 0 voltages.

Tak gravatar imageTak ( 2014-03-04 14:51:19 -0500 )edit

1 answer

Sort by ยป oldest newest most voted

answered 2014-03-01 03:06:30 -0500

MW gravatar image

updated 2014-03-01 04:10:29 -0500


The fact that pssexcel succeded in exporting to excel when you had results with relatively low flows makes me wonder if it's wrong with how the .sav file is setup before the load flow is executed. It's hard to say however without seeing what kind of output you are getting (flows and voltages). You say that you have high flows and low voltages, are they all 0 or 0.2 pu something? What do you mean with high flows, way over 150 %? For me that makes me think of two things that you ought to double check:

1) Your solution might've converged to the low voltage high flow solution or as my power system lecturer used to say "went past the "nose" of the PV-curve". You can see on this picture: www. that for one active power flow solution there are two different voltages (in theory atleast). One with voltages around 1 pu the other with low voltages and really high flows like 200% and upwards.

2) Do your contingencies contain alot of islands? That would also give you low or 0 voltages (assuming no generators in the islands or higher loads than generators). have you selected to export or not export results from islands (cannot remember if it is possible to do but check the API).

For me I've had some trouble with PSS/E converging to the low voltage high flow solution when I do major changes to my system in one go instead of taking it in steps. For example changing a phase shifting transformer from -30 to 30 degrees, instead I did it in steps of 10 or 20 degrees and it was fine. Hope this serves as some help.

edit flag offensive delete link more


2 cont.) You could just import your results into python lists and remove all the zeroes then plot it yourself with modules such as win32com or xlrd/xlwr. A bit of programming involved but not impossible at all. Just make sure all the 0 voltages actually are islands before though.

MW gravatar imageMW ( 2014-03-05 09:36:34 -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


Asked: 2014-02-28 09:29:08 -0500

Seen: 605 times

Last updated: Mar 01 '14