Delaying production

[homeworker]

Hi there, I have a large excel model with multiple assumptions behind it. It works on a 250 month basis so is quite large and there are several types of production curves in the model.

What I want to do is to be able to set a delay on when the production starts for each production curve. So there is a variable assumption (production starts [x] months after capital cost is incurred) and I want the model to then take the beginning of the production curve in month [x] then use production from month [x + 1] and so on.

I've attached a simplified table of what I'm trying to achieve:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Base Production[/TD]
[TD]Delay in starting production (months)[/TD]
[TD]Production Accounting for delay[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]200[/TD]
[TD]6[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]150[/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]125[/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]100[/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]75[/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]25[/TD]
[TD][/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]12[/TD]
[TD][/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]125[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD][...251][/TD]
[TD][/TD]
[TD][/TD]
[TD][...25][/TD]
[/TR]
</tbody>[/TABLE]

The simple logic is: IF the month is less than the delay then take no production. IF the month is equal to the delay then take the first month's production. Then take the second month's production. Then the third etc. The problem I have is how do I do this without having to enter each formula manually as I have 10x production types and 250 months per production type.

Any help gratefully received!!

 

[homeworker]

bump. any help gratefully received!

 

[mole999]

my only though would be to have a delay sheet built so changes there are then part of the model calculation always referenced. I don't understand the problem enough to say more

 

[Matty]

Hi,

Assuming your data resides in range A1:D13, try:

=IF(ROWS(D$2:D2)<=C$2,0,INDEX(B$2:B$13,ROWS(D$2:D2)-C$2))

In D2, copied down.

Cheers,

Matty

 

[homeworker]

Hi Matty, thank you for this - formula worked perfectly!

 

[Matty]

Hi Matty, thank you for this - formula worked perfectly!

No problem. Glad you're sorted.

Matty