Cycling / "start over" formula for different scenarios

[chankw]

Hi team,

I am building an analysis for output for a new machine.

I am having some trouble with creating a formula that is adaptable to different ramp-up scenarios , ideally without the use of VBA.

Scenario:

A machine completes 10 processes a month @ 100% efficiency, but ramp up over the 4 months as follows:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]M1[/TD]
[TD]M2[/TD]
[TD]M3[/TD]
[TD]M4[/TD]
[TD]M5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]0%[/TD]
[TD]20%[/TD]
[TD]40%[/TD]
[TD]60%[/TD]
[TD]100%[/TD]
[/TR]
</tbody>[/TABLE]

Once the machine reaches 100%, the next month it starts over at 0% (or cell A2) / at the beginning of the cycle and then continues the ramp up cycle again.

Is there a way to automate this "restart" so I can copy a formula across multiple months, without having to adjust the formula manually?

I need the automation because I want to build a scenario where the ramp up is actually two months, as follows:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]M1[/TD]
[TD]M2[/TD]
[TD]M3[/TD]
[TD]M4[/TD]
[TD]M5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]50%[/TD]
[TD]100%[/TD]
[TD]100%[/TD]
[TD]100%[/TD]
[TD]100%[/TD]
[/TR]
</tbody>[/TABLE]

The formula needs to recognize the different scenario and adjust accordingly.

Any help would be great!

Thanks,

chankw