First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!

Ask Your Question
0

How to get psse output to Excel?

asked Sep 10 '16

hasa_kh gravatar image

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.

1 answer

Sort by » oldest newest most voted
0

answered Sep 10 '16

jconto gravatar image

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.

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 gravatar imagehasa_kh (Sep 12 '16)

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

jconto gravatar imagejconto (Sep 13 '16)

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

hasa_kh gravatar imagehasa_kh (Sep 13 '16)

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.
Want to format code in your answer? Here is a one minute demo on Youtube

Add Answer

[hide preview]

Question Tools

2 followers

Stats

Asked: Sep 10 '16

Seen: 4,066 times

Last updated: Sep 10 '16