conditionally charge a battery

[Steph66]

Hello,

I'm trying to build a model of a battery (2 MW storage capacity) that charges and discharges according to the values in column B and the production in column C. If B < Spot Avg, production is stored in the battery up to its maximum capacity (2 MW). If B > Spot Avg, production is sold directly without going into storage. Outside production hours (where C = 0), if the spot price is > Spot Sold, the battery capacity is sold at the price in column B at time t, the battery empties at 0 and the cycle starts again when there is production in C.

I don't know how to reproduce the process of adding battery capacities up to a certain value and then resetting it to 0 when the electricity is sold.
Could you help me?

hybrid storage.xlsx

[oEx]

I understand what you need, please look at the attachment.

[AliGW]

Administrative Note:

Please include formulae used in your post in addition to providing a workbook (for the benefit of members unable to download attachments).

Thanks.