Ask Your Question

Jim's profile - activity

2012-08-11 06:28:23 -0500 received badge  Famous Question (source)
2012-08-08 01:23:41 -0500 received badge  Nice Question (source)
2012-08-05 15:25:09 -0500 received badge  Notable Question (source)
2012-08-03 20:12:38 -0500 received badge  Popular Question (source)
2012-08-02 15:40:40 -0500 received badge  Student (source)
2012-08-02 10:18:18 -0500 asked a question Easier way to change load and gen values and export to excel

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:

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
WG 215, 1.5624015
PV 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