camerond12's profile - activity

Thank you!!

I think that this overwritesheet = true option will overwrite latest sheet if it is called more than once during simulation.

In my case, I am re running the script rather than using the dyntools command more than once in the same script.

To overcome this, I check for and delete existing excel file in directory by adding the following code just before using dyntools.CHNF.xlsout(..)

if os.path.exists(xlsoutput):
   try:
      os.remove(xlsoutput)
   except WindowsError:
      print 'file is open'

Hello,

I am using dyntools to output data to excel.

dyntools.CHNF.xlsout(xlsresult, channels=[], show=False, xlsfile=xlsoutput, outfile=outfile, overwritesheet = True)

This is the code I am using, I believe that overwritesheet = True should overwite sheet1 every time I run the script.

I currently need to delete the old excel sheet every time I re run my script or else the excel workbook will create new sheets of the same data, which causes the file to become huge.

What should I do?

Thanks

Found out that this is an issue in version 34.3.0 and was fixed in 34.3.1

Also, there is an option under [Edit->Preferences...], [Diagram] tab, [Case - Diagram Interactions] tab, [Use available Geophysical Information when auto-placing items]. Make sure this option is checked when working with location files.

Definitely agree with you. However, using aflowint to return from/to bus number's seems to give the bus numbers in a random order, i.e. using aflowreal will give you (1, 2, 3, 4) however the bus numbers returned from aflowint will be (d, c, a, b). Is there a way to appropriately link the two?

Hello,

I am using the API command psspy.aflowreal to get active power flow of branches in a subsystem. Problem is, using this command does not indicate which value belongs to which 'to and from' bus number.

For example, aflowreal returns:

[10, -9, 20, -21, 30, -29]

Where I'm trying to get:

[ [10, (bus1, bus2)], [-9, (bus2, bus1)], [20, (bus2, bus3)], .... ]

Does anybody have an idea of how I can implement this in my script??

Thanks!!

My main goal is to create an SLD for an area (NSW for example), and update buses and branches based on their geographical location.

Currently, my steps to achieving this are as follows:

1. Get all bus numbers and their latititude and longitude on excel

   1.1 Scale latitude and longitudes based on a constant (divide by 100 for example)

2. Map these busses and lats/longs to csv file in this format:

   GEOPHYSICAL

   /BusID, X location, Y location

   100, 50.863N, 90.423W

   101, 50.345N, 80.564W

3. Save this csv file as .loc (location file)

4. Open this .loc file in PSSE

5. Right click sld drawing and click update bus locations.

Im testing this method by creating an sld of around 5 buses and then exporting their *.loc file. I then change a few values on the *.loc file and import it back to the same psse case. My troubles arise when I right click the SLD and click on "update geographical bus locations", where either nothing will happen, or PSSE crashes.

If anybody can shed some light onto why this is happening, I'd be very thankful.

Hello,

Going through the API, I have noticed that there are a bunch of functions which return a value. An example of this would be the function 'abusint', where in the script, you can store something as 'bus = abusint(...)'.

My question is if there is a way to do this for the functions that don't specify that they return a value.

My specific case includes the fnsl function. From my understanding, calling this function executes the newton load flow study and outputs the results in the python terminal. Is there a way to store these results in my own variable so that I can reference them and store them into excel?

There is a case where executing a fault study analysis and exporting the results to excel was done using the pssarrays class, (object = pssarrays.iecs_currents) and this would return an object which you could access in python and grab its results for different cases (3phase, line to line etc...)

How can you do this using the API functions such as fnsl and others?

Thanks a tonne in advance!

Hello,

Going through the API, I have noticed that there are a bunch of functions which return a value. An example of this would be the function 'abusint', where in the script, you can store something as 'bus = abusint(...)'.

My question is if there is a way to do this for the functions that don't specify that they return a value.

My specific case includes the fnsl function. From my understanding, calling this function executes the newton load flow study and outputs the results in the python terminal. Is there a way to store these results in my own variable so that I can reference them and store them into excel?

There is a case where executing a fault study analysis and exporting the results to excel was done using the pssarrays class, (object = pssarrays.iecs_currents) and this would return an object which you could access in python and grab its results for different cases (3phase, line to line etc...)

How can you do this using the API functions such as fnsl and others?

Thanks a tonne in advance!

Hi

How do you export 3ph fault currents to excel.

Im using:

robj = pssarrays.iecs_currents(sid=sid, all=0, flt3ph=1)

to run the study and store the results in the object robj. How do i get the values within this object for multiple buses, and insert them into excel just like you would for bus numbers for example...

ierr, busses = psspy.abusint(sid=sid, flag=flag, "NUMBER")...... workbook.set_range(2, 'a', zip(*busses))

Thank you

Hi,

So I'm extremely new to both Python and PSSE and am trying to figure out how I can extract the fault currents for busses using Python. My end goal is to export this data to excel, however, I'm confused with how to actually store the data I'm looking for into my variables.

I've been using this previous thread as a guideline.

https://psspy.org/psse-help-forum/que...

Where can I find the methods that the object provided in the link above ( rlst = pssarrays.ascccurrents(subsystem, 0, 1, 1, 0, 0, 1, 0, 1, 0, 1, 0, 1, 2, 2, 1, 1, 1, '', '', '') ) contains?

Thanks!