Revision history [back]
 | 1 | initial version |
To get the max value in row with excelpy
My goal ：To get the max value in row with excelpy
My thought : Is it possible to read the results in excel then I can do the max(row 3) 、max(row 4) ?
Is there any solution?
Thank you so much for reading my question.
My Code：
.
.
ierr,buses = psspy.abusint(1,1,string='NUMBER')
ierr,volts = psspy.abusreal(1,1,string='PU')
x1.set_range(2,'b',zip(*buses),True)
x1.set_range(3,'b',zip(*volts),True)
.
.
.
for x in range(len( bus number))
z=x+4
.
.
.
ierr,volts_1 = psspy.abusreal(1,1,string='PU')
x1.set_range(z,'b',zip(*volts_1),True)
del z
Result in Excel：
a b c d e f g h i
1
2 1 2 3 4 5 6 7 8 (buses number)
3 10 5 30 85 50 60 75 80 (85) (volts) (max number in row 3 is 85)
4 90 60 20 10 5 6 8 12 (90) (volts) (max number in row 4 is 90)
5 6 10 ................................ (volts)
6 ................................... (volts)
| | 2 | No.2 Revision |
To get the max value in row with excelpy
My goal ：To get the max value in row with excelpy
My thought : Is it possible to read the results in excel then I can do the max(row 3) 、max(row 4) ?
Is there any solution?
Thank you so much for reading my question.
My Code：
.
.
ierr,buses = psspy.abusint(1,1,string='NUMBER')
ierr,volts = psspy.abusreal(1,1,string='PU')
x1.set_range(2,'b',zip(*buses),True)
x1.set_range(3,'b',zip(*volts),True)
.
.
.
for x in range(len( bus number))
z=x+4
.
.
.
ierr,volts_1 = psspy.abusreal(1,1,string='PU')
x1.set_range(z,'b',zip(*volts_1),True)
del z
Result in Excel：
a b c d e f g h i
1
2 1 2 3 4 5 6 7 8 (buses number)
3 10 5 30 85 50 60 75 80 (85) (volts) (max number in row 3 is 85)
4 90 60 20 10 5 6 8 12 (90) (volts) (max number in row 4 is 90)
5 6 10 ................................ (volts)
6 ................................... (volts)
| | 3 | No.3 Revision |
To get the max value in row with excelpy
My goal ：To get the max value in row with excelpy
My thought : Is it possible to read the results in excel then I can do the max(row 3) 、max(row 4) ?
Is there any solution?
Thank you so much for reading my question.
My Code：
.
.
ierr,buses = psspy.abusint(1,1,string='NUMBER')
ierr,volts = psspy.abusreal(1,1,string='PU')
x1.set_range(2,'b',zip(*buses),True)
x1.set_range(3,'b',zip(*volts),True)
.
.
.
for x in range(len( bus number))
z=x+4
.
.
.
ierr,volts_1 = psspy.abusreal(1,1,string='PU')
x1.set_range(z,'b',zip(*volts_1),True)
del z
Result in Excel：
a b c d e f g h i
1
2 1 2 3 4 5 6 7 8 (buses number)
3 10 5 30 85 50 60 75 80 (85) (volts) (max number in row 3 is 85)
4 90 60 20 10 5 6 8 12 (90) (volts) (max number in row 4 is 90)
5 6 10 ................................ (volts)
6 ................................... (volts)
| | 4 | No.4 Revision |
To get the max value in row with excelpy
My goal ：To get the max value in row with excelpy
My thought : Is it possible to read the results in excel then I can do the max(row 3) 、max(row 4) ?
Is there any solution?
Thank you so much for reading my question.
My Code：
.
.
ierr,buses = psspy.abusint(1,1,string='NUMBER')
ierr,volts = psspy.abusreal(1,1,string='PU')
x1.set_range(2,'b',zip(*buses),True)
x1.set_range(3,'b',zip(*volts),True)
.
.
.
for x in range(len( bus number))
z=x+4
.
.
.
ierr,volts_1 = psspy.abusreal(1,1,string='PU')
x1.set_range(z,'b',zip(*volts_1),True)
del z
Result in Excel：
a b c d e f g h i
1
2 1 2 3 4 5 6 7 8 (buses number)
3 10 5 30 85 50 60 75 80 (85) (volts) (max number in row 3 is 85)
4 90 60 20 10 5 6 8 12 (90) (volts) (max number in row 4 is 90)
5 6 10 ................................ (volts)
6 ................................... (volts)
| | 5 | No.5 Revision |
To get the max value in row with excelpy
My goal ：To get the max value in row with excelpy
My thought : Is it possible to read the results in excel then I can do the max(row 3) 、max(row 4) ?
Is there any solution?
Thank you so much for reading my question.
My Code：
.
.
ierr,buses = psspy.abusint(1,1,string='NUMBER')
ierr,volts = psspy.abusreal(1,1,string='PU')
x1.set_range(2,'b',zip(*buses),True)
x1.set_range(3,'b',zip(*volts),True)
.
.
.
for x in range(len( bus number))
z=x+4
.
.
.
ierr,volts_1 = psspy.abusreal(1,1,string='PU')
x1.set_range(z,'b',zip(*volts_1),True)
del z
Result in Excel：
a b c d e f g h i
1
2 1 2 3 4 5 6 7 8 (buses number)
3 10 5 30 85 50 60 75 80 (85) (volts) (max number in row 3 is 85)
4 90 60 20 10 5 6 8 12 (90) (volts) (max number in row 4 is 90)
5 6 10 ................................ (volts)
6 ................................... (volts)
| | 6 | No.6 Revision |
To get the max value in row with excelpy
My goal ：To get the max value in row with excelpy
My thought : Is it possible to read the results in excel then I can do the max(row 3) 、max(row 4) ?
Is there any solution?
Thank you so much for reading my question.
My Code：
.
.
ierr,buses = psspy.abusint(1,1,string='NUMBER')
ierr,volts = psspy.abusreal(1,1,string='PU')
x1.set_range(2,'b',zip(*buses),True)
x1.set_range(3,'b',zip(*volts),True)
.
.
.
for x in range(len( bus number))
z=x+4
.
.
.
ierr,volts_1 = psspy.abusreal(1,1,string='PU')
x1.set_range(z,'b',zip(*volts_1),True)
del z
Result in Excel：
a b c d e f g h i
1
2 1 2 3 4 5 6 7 8 (buses number)
3 10 5 30 85 50 60 75 80 (85) (volts) (max number value in row 3 is 85)
4 90 60 20 10 5 6 8 12 (90) (volts) (max number value in row 4 is 90)
5 6 10 ................................ (volts)
6 ................................... (volts)
| | 7 | No.7 Revision |
To get the max value in row with excelpy
My goal ：To get the max value in row with excelpy
My thought : Is it possible to read the results in excel then I can do the max(row 3) 、max(row 4) ?
Is there any solution?
Thank you so much for reading my question.
My Code：
.
.
ierr,buses = psspy.abusint(1,1,string='NUMBER')
ierr,volts = psspy.abusreal(1,1,string='PU')
x1.set_range(2,'b',zip(*buses),True)
x1.set_range(3,'b',zip(*volts),True)
.
.
.
for x in range(len( bus number))
z=x+4
.
.
.
ierr,volts_1 = psspy.abusreal(1,1,string='PU')
x1.set_range(z,'b',zip(*volts_1),True)
del z
Result in Excel：
a b c d e f g h i
1
2 1 2 3 4 5 6 7 8 (buses number)
3 10 5 30 85 50 60 75 80 (85) (volts) (max value in row 3 is 85)
4 90 60 20 10 5 6 8 12 (90) (volts) (max value in row 4 is 90)
5 6 10 ................................ .............................. (volts)
6 ................................... ......................................... (volts)
