Luis Maldonado
New Member
Dear Friends,
I am trying to build a model that put a different prices every x years. In this case my input is the following:
Price To year
a1: 2 b1: 5
a2: 3 b2: 10
a3: 4 b3: 15
a4: 5 b4: 20
The desired outcome would be in a row where the first 5 years have price 2, from year 6 to 10 the price is 3, from year 11 to 15 the price is 4 and from year 16 to 20 the price is 5. It should look like this:
Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Cost 2 2 2 2 2 3 3 3 3 3 4 4 4 4 4 5 5 5 5 5
Below each year it should be the corresponding price for that year.
I am trying to automate this part but I am having trouble with the right formula to use. I would really appreciate your help.
I am trying to build a model that put a different prices every x years. In this case my input is the following:
Price To year
a1: 2 b1: 5
a2: 3 b2: 10
a3: 4 b3: 15
a4: 5 b4: 20
The desired outcome would be in a row where the first 5 years have price 2, from year 6 to 10 the price is 3, from year 11 to 15 the price is 4 and from year 16 to 20 the price is 5. It should look like this:
Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Cost 2 2 2 2 2 3 3 3 3 3 4 4 4 4 4 5 5 5 5 5
Below each year it should be the corresponding price for that year.
I am trying to automate this part but I am having trouble with the right formula to use. I would really appreciate your help.
