Revision history [back]

Hi,

I am new to Python and was wondering how I could create a program to run all my simulations. Currently I am manually changing the load and generator values for each hourly simulation.

I have several weeks worth left to do and was wondering if someone could please show me how to initiate this program to grab the results from excel, load into PSSE then export the results into a single spreadsheet?

Sincere thanks for any assistance as I am running behind schedule.

Hi,

I am new to Python and was wondering how I could create a program to run all my simulations. Currently I am manually changing the load and generator values for each hourly simulation.

I have several weeks worth left to do and was wondering if someone could please show me how to initiate this program to grab the results from excel, load into PSSE then export the results into a single spreadsheet?

Sincere thanks for any assistance as I am running behind schedule.

Hi,

I am new to Python and was wondering how I could create a program to run all my simulations. Currently I am manually changing the load and generator values for each hourly simulation.

I have several weeks worth left to do and was wondering if someone could please show me how to initiate this program to grab the results from excel, load into PSSE then export the results into a single spreadsheet?

Sincere thanks for any assistance as I am running behind schedule.

Hi,

I am new to Python and was wondering how I could create a program to run all my simulations. Currently I am manually changing the load and generator values for each hourly simulation.

I have several weeks worth left to do and was wondering if someone could please show me how to initiate this program to grab the results from excel, load into PSSE then export the results into a single spreadsheet?

Sincere thanks for any assistance as I am running behind schedule.

(edit)

Thanks for the reply but still having trouble with importing the values and exporting the bus voltage results to PSSE.

The following data is what I am trying to enter into PSSE from excel A B C 3 LOAD MW LOAD MMVAR 4 104 0.33234344 0.08304855 5 106 0.6118356 0.087272 6 109 2.287867032 0.760106028 7 203 0.58799224 0.14693205 8 212 0.68831505 0.098181 9 216 2.57621391 0.855904515 10 217 0.35180547 0.0501814 11 308 0.86920592 0.2172039 12 309 2.8361988 0.9422802 13 311 0.4588767 0.065454

LOAD, MW,  MMVAR
104, 0.33234344, 0.08304855
106, 0.6118356, 0.087272
109, 2.287867032, 0.760106028
203, 0.58799224, 0.14693205
212, 0.68831505, 0.098181
216, 2.57621391, 0.855904515
217, 0.35180547, 0.0501814
308, 0.86920592, 0.2172039
309, 2.8361988, 0.9422802
311, 0.4588767, 0.065454

Then the gen data is below these entries as follows:

A B C 
MW 18 WG A 1.0189575 19 WG B 1.0189575 20 WG B 1.0189575 21 DG 111 0.48 22 DG 112 0.48 23 DG 113 0.48 24 WG 207 1.5624015 25 DG 210 2.2 26 WG 214 1.5624015 27 WG 215 1.5624015 28 PV 304 0 29 DG 307 0.8 30 DG 310 0.8
0.8

Any further whelp would be greatly appreciated!

The excel file is saved as EP401Simulation ResultsUR Algorithm3.0.xlsx

Hi,

I am new to Python and was wondering how I could create a program to run all my simulations. Currently I am manually changing the load and generator values for each hourly simulation.

I have several weeks worth left to do and was wondering if someone could please show me how to initiate this program to grab the results from excel, load into PSSE then export the results into a single spreadsheet?

Sincere thanks for any assistance as I am running behind schedule.

(edit)

Thanks for the reply but still having trouble with importing the values and exporting the bus voltage results to PSSE.

The following data is what I am trying to enter into PSSE from excel

LOAD, MW,  MMVAR
104, 0.33234344, 0.08304855
106, 0.6118356, 0.087272
109, 2.287867032, 0.760106028
203, 0.58799224, 0.14693205
212, 0.68831505, 0.098181
216, 2.57621391, 0.855904515
217, 0.35180547, 0.0501814
308, 0.86920592, 0.2172039
309, 2.8361988, 0.9422802
311, 0.4588767, 0.065454

Then the gen data is below these entries as follows:

A B C 
MW 18 WG A 1.0189575 19 WG B 1.0189575 20 WG B 1.0189575 21 DG 111 0.48 22 DG 112 0.48 23 DG 113 0.48 24 WG 207 1.5624015 25 DG 210 WG A, 1.0189575
WG B, 1.0189575
WG B, 1.0189575
DG 111, 0.48
DG 112, 0.48
DG 113, 0.48
WG 207, 1.5624015
DG 210, 2.2 26 WG 214 1.5624015 27 WG 215 1.5624015 28 
WG 214, 1.5624015
WG 215, 1.5624015
PV 304 0 29 DG 307 0.8 30 DG 310 304, 0
DG 307, 0.8
DG 310, 0.8

Any further whelp would be greatly appreciated!

The excel file is saved as EP401Simulation ResultsUR Algorithm3.0.xlsx