0

How to get psse output to Excel?

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.

hasa_kh's avatar
3
hasa_kh
asked 2016-09-10 01:03:25 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

0

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.

jconto's avatar
2.9k
jconto
answered 2016-09-10 17:09:15 -0500
edit flag offensive 0 remove flag 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's avatar hasa_kh (2016-09-12 05:46:31 -0500) edit

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

jconto's avatar 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's avatar hasa_kh (2016-09-13 11:59:50 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer