# Thread: Delaying production Thanks: 0 Likes:  1 Post #5298454 (1)

1. ## Delaying production

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:

 Month Base Production Delay in starting production (months) Production Accounting for delay 0 200 6 0 1 150 0 2 125 0 3 100 0 4 75 0 5 50 0 6 25 200 7 12 150 8 8 125 9 4 100 10 2 75 11 1 50 [...251] [...25]

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.

3. ## Re: Delaying production

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

4. ## Re: Delaying production

Hi,

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

Code:
`=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

5. ## Re: Delaying production

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

6. ## Re: Delaying production

Originally Posted by homeworker
Hi Matty, thank you for this - formula worked perfectly!

Matty