Voltage Check Report to Excel

asked 2018-02-22 05:38:36 -0500

PSSE_ABCD
11 ●10 ●12 ●12

Hi All

Does anyone have a python script which extracts the buses and their voltages which are outside +/- 5% and exports them to excel after doing a load flow?

Thanks

edit retag flag offensive close merge delete

add a comment

0

answered 2018-02-22 14:41:34 -0500

Ali
26 ●7 ●8 ●11

updated 2018-02-22 14:48:11 -0500

Something like this does the job. After calling this function, write the following line: volviol.to_csv('voltage.csv') and that should do it.

 def voltages_csv():
    # get a dataframe of all buses and their voltages; you need to write this function
    allBusData = AllBuses()
    volviol = []
    for index, iBus in allBusData.iterrows():
        busPu = iBus['pu']
        if not (0.95 <= busPu <= 1.05):
            volviol.append(iBus)
    volviolDF = pd.DataFrame(data=volviol)
    return volviolDF