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.