Thanks @perolofl for pointing this out. Really appreciate.

Hello ays, There seems to be no option for summation of Mvar in the *.sld file in Summation label. Several other things are missing for complete reporting purpose. We had raised this matter in the UGM in India in 2015. PTI is of opinion that the purpose of this SLD file is not reporting, rather for ease of simulation. For reporting other options are available. Still, you could give a feedback to PTI on their website through the web query (fastest means of resolving a query).

Hello Jconto, Thank you so much for your help. It was great to find the whole list of arguments of excelpy in your python file. I was using the file and encountered this following error. Although it is not exactly linked, I would appreciate your guidance. I am using a piece of code and the value of AllLoad is returning as [Null]. I am not able to trace the error here. Also, I was trying to export the information to an excel using set_range function. Am I going in the right direction?

areas = [5201, 5301, 5401, 5501, 5601, 5701, 5801, 5902]

The PSSE Case has the areas as above

psspy.bsys(sid=0, numarea=len(areas), areas=areas) ierr, AllLoad = psspy.aareareal(sid=0,string='PLOAD') AllLoad xl.set_range(2, 4, AllLoad, fontStyle = 'Arial',fontColor = 'Red')

Also, the following code is giving an output in excel that is not really comprehendable to me: buses = [524003, 521011, 524001, 521001, 524005, 514001, 524006, 524007, 524009] psspy.bsys(sid=0, numbus=len(buses), buses=buses) ierr, volts = psspy.abusreal (sid=0,string='KV') volts

ierr, AllLoad = psspy.aareareal(sid=0,string='PLOAD')

AllLoad

xl.setrange(2, 4, volts, fontStyle = 'Arial',fontColor = 'Red') xl.setrange(3, 4, buses, fontStyle = 'Arial',fontColor = 'Red')

volts = 407.2868347 134.6368866 134.2896271 412.4360046 407.9005737 404.2839661 411.1826477 407.6182861 410.2168579 buses = 524003 521011 524001 521001 524005 514001 524006 524007 524009

Here, the buses Matrix is in the same order in which it has been entered. But, the voltage matrix seems to be undergoing some type of sorting based on Voltage Level. So the 400 kV buses do not correspond to it's voltage at output. Could you please explain the reason?

Hello Jconto. Thanks for your initiative in answering my query. However, I was not able to open the attachment. Could you please repost the attachment. Thanks, Rahul

I have a sheet containing Load and Generation data in Excel. I want to take the data by accessing the excel sheet and scale specific Zones and change machine generation values. Any leads?