Hi there,


I working with equipment requirements and minimum time that one can hire, in this case on a 4-weekly cycle. For example in week 1 I need one piece and in weeks 2 to 4 I need 0, then I need 1 for the first 4 weeks. Then if I need 2 in week 5 and 1 in week 6, then I need 2 from week 5 to week 8. Is it possible to do a formula that works that out if my weeks are in columns and then my equipment types in rows like in the example below?
Many thanks for the help.

W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11
equipment by week 0 1 0 0 0 1 2 3 0 0 1