A table that has values spilling over to the next cell when it reaches a certain value.

[visi]

Hello,

I'm trying to come up with a way that will populate a table after each cell reaches a certain value.
My first column has rows with the total time required to perform a certain operation. The columns after that, represent operators that should be picking up a certain amount of tasks that do not exceed a set time.

Let's assume that the first row (total operation) has a total of 550 sec. The second column (1st operator) should assign a a value of no more than 200 sec. The third column (2nd operator) another 200 and the fourth column (3rd operator) another 150. So as to create a spill over effect.
The second row has a different operator with a different time. Let's say 300. These tasks should be picked up by a fourth operator with a value of 200 and then a fifth with 100. All in all I would like the table to populate as below. Any help is greatly appreciated!


xxxxxxxxxxxxxxxxxxxxxx operator1 operator2 operator3 operator4 operator5
operation 1 550 xxxxxxxxxxxxx200 xxxxxx200 xxxxxx150
operation 2 300 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx200 xxxxxxx100

Please ignore the "x". I used those to make sure that the rows aligned with the columns

[dilipandey]

HI visi,

See the attached workbook where yellow cell has the value to distribute and same are distributed over green cells using formulas.
values spilling.xlsx

Regards,
DILIPandey
<click on below * if this helps>