Ask Your Question

How to get psse output to Excel?

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

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.

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

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

jconto gravatar image

Please check the posting 'How to get value of active power flow on a branch?' Use the (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 more


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 ( 2016-09-12 05:46:31 -0600 )edit

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

jconto gravatar imagejconto ( 2016-09-12 19:38:35 -0600 )edit

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

hasa_kh gravatar imagehasa_kh ( 2016-09-13 11:59:50 -0600 )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

1 follower


Asked: 2016-09-10 01:03:25 -0600

Seen: 3,622 times

Last updated: Sep 10 '16