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

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
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

Well-known Member
Joined
Feb 17, 2007
Messages
3,710
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,177
Messages
5,600,160
Members
414,367
Latest member
dw970906

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
Top