How to get psse output to Excel?

asked 2016-09-10 01:03:25 -0500

hasa_kh
3 ●1 ●1 ●2

hello, I'm using psse 33 for my studies. I want to get the steady state branch loading to MS Excel. The output I get from psse output bar contains a lot of details. But I want only 'from bus number' , 'to bus number' and the 'branch loading(MW)'. Please help. Thank You.

answered 2016-09-10 17:09:15 -0500

jconto
2691 ●10 ●30 ●41

Please check the posting 'How to get value of active power flow on a branch?' Use the brnflows_csv.py (located in the "example" folder of the PSSe installation folder) to get the branches flows. You can open the csv file in excel and delete those columns not needed.

edit flag offensive delete link

Comments

Thank You. Your Answer was very helpful. Only problem is the number of decimal places (it is 2 decimal places in the 'csv' file) but I want the MW flow in 4 decimal places. On the diagram it is in 4 decimal places but not in the 'csv' output. Please help.

hasa_kh ( 2016-09-12 05:46:31 -0500 )edit

In lines 203-204 change .2F to .4F

jconto ( 2016-09-12 19:38:35 -0500 )edit

Thank you. The 2F wasn't in lines 203-204. Anyway I changed it to 4F.

hasa_kh ( 2016-09-13 11:59:50 -0500 )edit

add a comment

How to get psse output to Excel?

1 answer

Comments

Your Answer

Question Tools

Stats

Related questions