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:

	A	B	C	D	E
1	M1	M2	M3	M4	M5
2	0%	20%	40%	60%	100%

<tbody>
</tbody>

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:

	A	B	C	D	E
1	M1	M2	M3	M4	M5
2	50%	100%	100%	100%	100%

<tbody>
</tbody>

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

Any help would be great!

Thanks,

chankw