Hi, I'm experimenting with interfacing Excel and PSSE V33, I'm trying to change only MW load of a specific region without changing the pre-assigned generation. I've tried different combinations for psspy.scal2 arguments but still not being able to change MW loads only. Is there a way to read off an excel sheet and assign that value as a new total of Load-MW? The excel import piece is working fine, just need the proper arguments for psspy.scal2 and PSSE documentation dos not provide any examples. Below is my code, please help:

______Importing Load Data________

import excelpy xlsfile = r"C:\Users\mhandy\OneDrive - Eversource Energy\Desktop\Loads.xlsx" testxls = excelpy.workbook(xlsfile,"test",mode='r') row=1 col=1 region1 = testxls.get_cell((row,col));

______Allocating Load - PSSE Recording________

psspy.bsys(0,0,[0.0, 765.],0,[],0,[],0,[],1,[101]) psspy.scal2(0,0,1,[0,0,0,0,0],[0.0,0.0,0.0,0.0,0.0,0.0,0.0]) psspy.scal2(0,1,2,[0,1,0,1,0],[region1,0,0,0,0,0,0]) # I want to use the preassigned generation without modifying it. psspy.fdns([0,0,0,1,1,0,99,0])

testxls.close()

Hi, I'm experimenting with interfacing Excel and PSSE V33, I'm trying to change only MW load of a specific region without changing the pre-assigned generation. I've tried different combinations for psspy.scal2 arguments but still not being able to change MW loads only. Is there a way to read off an excel sheet and assign that value as a new total of Load-MW? The excel import piece is working fine, just need the proper arguments for psspy.scal2 and PSSE documentation dos not provide any examples. Below is my code, please help:

______Importing Load Data________

import excelpy xlsfile = r"C:\Users\mhandy\OneDrive - Eversource Energy\Desktop\Loads.xlsx" testxls = excelpy.workbook(xlsfile,"test",mode='r') row=1 col=1 region1 = testxls.get_cell((row,col));

______Allocating Load - PSSE Recording________

psspy.bsys(0,0,[0.0, 765.],0,[],0,[],0,[],1,[101]) psspy.scal2(0,0,1,[0,0,0,0,0],[0.0,0.0,0.0,0.0,0.0,0.0,0.0]) psspy.scal2(0,1,2,[0,1,0,1,0],[region1,0,0,0,0,0,0]) # I want to use the preassigned generation without modifying it. it.

psspy.fdns([0,0,0,1,1,0,99,0])

testxls.close()