So all the equipment in the second row the same i.e. the hire in Week 27 be used among the ten hired in Week 28. Correct?

What is it you are trying to do? Are you trying to optimize hires?

Let's look at the second row:

Week 27: hire 1
Week 28: hire 9 more
Week 29: 2 surplus
Week 30: 2 surplus
Week 31: hire in week 27 ends, 2 surplus
Week 32: hire 9
Week 33: -
Week 34: one surplus
Week 35: one surplus
Week 36: hire 10
Week 37: 3 surplus
Week 38: 6 surplus
Week 39: 10 surplus

See attached for visual. It doesn't really do anything. Just trying to get a better feel for what's going on.

Attached Files

test.xlsx (11.5 KB, 13 views)