Delaying production

homeworker

New Member
Joined
Jun 21, 2019
Messages
3
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:

MonthBase ProductionDelay in starting production (months)Production Accounting for delay
020060
11500
21250
31000
4750
5500
625200
712150
88125
94100
10275
11150
[...251][...25]

<tbody>
</tbody>

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!!
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,287
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top