I am making a scenario in excel where Electric vehicles are being charged in a given time range. i have a neighborhood loads and the load of EV at specific times. the cable capacity is 50 kW (means the combined load of EV and household should not exceed this value). is there a formula, which checks if the combined load of EV and household is below 50 kW, then leaves it unchanged. if it is more than 50KW then shifts the EV load to next row and checks for the condition again if satisfied it is less then 50kw it adds it here otherwise shift to the next row until the condition is satisfied.
I have attached the sample excel file for clarification. more text in the file explains the case
any help would be appreciated
I have attached the sample excel file for clarification. more text in the file explains the case
any help would be appreciated