i want to implement a battery system for a renewable plant of energy who feeds a machine. For example, The machine requires 1000 kw/h or the energy closest to that amount. If the energy generated exceeds 1000 kw/h, the surplus could be used to charge the battery, which, let’s say, is 100 kw. If the energy produced is less than 1000 kw/h and there is energy in the battery, the energy from the battery should be used to power the machine. An example generated energy dataset could be the following:

data set energia
Path Hour 1 Hour 2 Hour 3 Hour 4 Hour 5 Hour 6 … Hour 8760
1 950,0 947,1 982,4 1013,5 1003,0 1087,7
2 1046,9 947,9 981,9 1031,9 984,8 931,8
3 996,1 1031,0 978,8 972,7 826,8 952,0
4 943,4 1015,2 1007,2 994,8 1017,4 979,8

Where should I obtain a new energy and battery charge level data set as follows:

data set Bateria
Path Hour 1 Hour 2 Hour 3 Hour 4 Hour 5 Hour 6
1 0,0 0,0 0,0 13,5 16,5 100,0
2 46,9 0,0 0,0 31,9 16,7 0,0
3 0,0 31,0 9,8 0,0 0,0 0,0
4 0,0 15,2 22,3 17,2 34,6 14,4

Nuevo data set Energia
Path Hour 1 Hour 2 Hour 3 Hour 4 Hour 5 Hour 6
1 950,0 947,1 982,4 1013,5 1003,0 1087,7
2 1046,9 994,8 981,9 1031,9 1000,0 948,5
3 996,1 1031,0 1000,0 982,5 826,8 952,0
4 943,4 1015,2 1007,2 1000,0 1017,4 1000,0

Nuevo data set Energia
Path Hour 1 Hour 2 Hour 3 Hour 4 Hour 5 Hour 6 1 950,0 947,1 982,4 1013,5 1003,0 1087,7 2 1046,9 994,8 981,9 1031,9 1000,0 948,5 3 996,1 1031,0 1000,0 982,5 826,8 952,0 4 943,4 1015,2 1007,2 1000,0 1017,4 1000,0

I am doing the simulation for each of the hours in 1 year (8760) with a thousand possible paths of energy generation values. I am currently making a for for each column where I check the conditions, but I want to make the process as efficient as possible. I would believe that parallelization is not an option since the analysis is sequential and conditional, although I don’t know.

THANKS FOR THE HELP!!!

I am doing the simulation for each of the hours in 1 year (8760) with a thousand possible paths of energy generation values. I am currently making a for for each column where I check the conditions, but I want to make the process as efficient as possible. I would believe that parallelization is not an option since the analysis is sequential and conditional, although I don’t know.