**Question description:**

*This user has given permission to use the problem statement for this blog.*

Hi. I'm trying to model the roll out of an activity over a number of years. The total number to be rolled out is fixed. Say at 10,000. So if the roll out period is 5 years, then it'll be 2000 per year. But if I want to change the 5 to a 4, all 10k will have been rolled out in years 1-4, and year 5 will have no roll out (and no cost associated with roll out).
If the roll out is 6 months, they are all rolled out in y1. I'm trying to find a way of modelling this. Can you help?

Solved by D. E. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
06/09/2017 - 02:29

Hi, Thank you for using Got It Pro. I’m happy to be able to help you today.

User
06/09/2017 - 02:31

ok what do you want from me?

User
06/09/2017 - 02:32

This is easy enough. But what if I want to change the 5 to a 4?

Excelchat Expert
06/09/2017 - 02:33

Sure on it

User
06/09/2017 - 02:33

How do I make it so that years 1-4 give me 2500, and y5 0

Excelchat Expert
06/09/2017 - 02:35

ok Try now

User
06/09/2017 - 02:36

ok that works for roll out periods of over 1. What if its 6 months?

User
06/09/2017 - 02:36

By the way, v impressive

User
06/09/2017 - 02:36

!

Excelchat Expert
06/09/2017 - 02:36

we'll have to divide the intervals into the least value you want to roll out with

User
06/09/2017 - 02:38

Ok

User
06/09/2017 - 02:38

So I couldn'ave have intervals of a year if I wanted to reserve the option of putting in .5 yeras as a roll out period?

Excelchat Expert
06/09/2017 - 02:38

you could

Excelchat Expert
06/09/2017 - 02:39

but it will give the same result as 1 year

User
06/09/2017 - 02:39

ok I think that should probably be ok

User
06/09/2017 - 02:39

So talk me through what you've done?

Excelchat Expert
06/09/2017 - 02:39

sure

Excelchat Expert
06/09/2017 - 02:40

first thing

Excelchat Expert
06/09/2017 - 02:40

row 6

Excelchat Expert
06/09/2017 - 02:40

is to adjust the number of years shown

Excelchat Expert
06/09/2017 - 02:40

I used an embedded if statement

Excelchat Expert
06/09/2017 - 02:40

1st one to check the the number of years if larger than the roll out period then enter 0

Excelchat Expert
06/09/2017 - 02:40

second one is because it's a sequence

Excelchat Expert
06/09/2017 - 02:41

so the next cell after 0 will return 0+1 which is smaller than the roll out period and will show a value

Excelchat Expert
06/09/2017 - 02:41

which will result in a sequence like in row9

Excelchat Expert
06/09/2017 - 02:42

so to break that I used another if statement if the cell before you is 0 then enter 0

Excelchat Expert
06/09/2017 - 02:42

next is the amount rolled out

Excelchat Expert
06/09/2017 - 02:42

you got the concept right when you did it yourself

User
06/09/2017 - 02:42

ok but I want to model all 5 years regardless. i.e. I don't want year 5 to disappear if roll out is over 4 years. Will that happen?

Excelchat Expert
06/09/2017 - 02:42

but you needed to insert some boundaries

Excelchat Expert
06/09/2017 - 02:42

no that will not happen

Excelchat Expert
06/09/2017 - 02:43

you could just enter in D6 =C6+1

Excelchat Expert
06/09/2017 - 02:43

and drage

Excelchat Expert
06/09/2017 - 02:43

drag*

Excelchat Expert
06/09/2017 - 02:43

no need for the if statements then

Excelchat Expert
06/09/2017 - 02:43

only thing is when you enter a value larger than 5

Excelchat Expert
06/09/2017 - 02:43

you will have to redrag to add 6 to the range

User
06/09/2017 - 02:43

This is awesome. HOw does this work? Can I save this chat? I haven't got everything and will need to go over it afer our time is up!

Excelchat Expert
06/09/2017 - 02:44

does this make sense?

Excelchat Expert
06/09/2017 - 02:44

first off you can extend the session 20 minutes

Excelchat Expert
06/09/2017 - 02:44

you will be given the option when we hit the 2 minute mark

Excelchat Expert
06/09/2017 - 02:44

then as for the chat history let me check now with the technical team and get back to you

User
06/09/2017 - 02:45

Sort of. How does the service work? This is m y first time

Excelchat Expert
06/09/2017 - 02:45

ok first time is free

Excelchat Expert
06/09/2017 - 02:46

then you can buy credits

User
06/09/2017 - 02:46

and then?

Excelchat Expert
06/09/2017 - 02:46

as for the chat history it won't be accessible nor the file if you do not download it

Excelchat Expert
06/09/2017 - 02:47

everything is deleted to maintain the customer's confidentiality of data and anonymity

User
06/09/2017 - 02:48

Ok. so I've downloaded now. Have 2 mins left. I will probably need to come back with another question before long. Have been given an assignment which is a bit beyond my skill set!

User
06/09/2017 - 02:48

So I buy credits, is that right?

Excelchat Expert
06/09/2017 - 02:48

yes

Excelchat Expert
06/09/2017 - 02:48

you can buy one session for $3.99

Excelchat Expert
06/09/2017 - 02:48

you have the option to extend the session

Excelchat Expert
06/09/2017 - 02:48

1 session (16 credits) for $3.99 3 sessions (48 credits) for $9.99 15 sessions (240 credits) for $44.99

User
06/09/2017 - 02:48

And how much time will 3.99 give me?

User
06/09/2017 - 02:49

or credits / time.

Excelchat Expert
06/09/2017 - 02:49

16 credits give one question

Excelchat Expert
06/09/2017 - 02:49

or one session

User
06/09/2017 - 02:49

ok I guess I can look into this by myself. About to run out of time. Many thanks for your time! awesome service

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*