Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula for a resource planning model that will round up if a given number is odd to the next whole number of team size.
Solved by E. E. in 22 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
05/02/2018 - 09:31
hello
User
05/02/2018 - 09:31
hi how are you?
Excelchat Expert
05/02/2018 - 09:32
hi, good, so can you share the file please
User
05/02/2018 - 09:32
one sec
Excelchat Expert
05/02/2018 - 09:32
sure
User
05/02/2018 - 09:34
can you see it?
Excelchat Expert
05/02/2018 - 09:34
yes
User
05/02/2018 - 09:35
basically, i am trying to create a staffing model
User
05/02/2018 - 09:35
if the number of campaigns is odd (row 3)
User
05/02/2018 - 09:36
then the number of resources required should round up so the staffing is the same as the next highest even number
User
05/02/2018 - 09:36
so, the total number of resources required would be the same for 1 and 2 campaigns, 3 and 4 campaigns, 5 and 6 campaigns, etc
User
05/02/2018 - 09:37
however i cant seem to figure it out
Excelchat Expert
05/02/2018 - 09:37
let me see
User
05/02/2018 - 09:38
thanks
Excelchat Expert
05/02/2018 - 09:39
can you create a scenario where the odd number comes and you need to round up
User
05/02/2018 - 09:40
sure
User
05/02/2018 - 09:40
if there is one campaign, there should still be 8 total resources required (8)
User
05/02/2018 - 09:41
this is because the team size is always 8
Excelchat Expert
05/02/2018 - 09:42
what is the campaigns per team's role here?
User
05/02/2018 - 09:42
that is their capacity
User
05/02/2018 - 09:42
so, each team can handle 2 campaigns
User
05/02/2018 - 09:42
however, if there is an odd number of campaigns, like 1, a full team is still required
User
05/02/2018 - 09:43
so that should be 8 in this example
Excelchat Expert
05/02/2018 - 09:44
Ok so basically what you need is same resource for 1&2...3&4...5&6...and so on?
User
05/02/2018 - 09:44
yes exactly
Excelchat Expert
05/02/2018 - 09:46
https://docs.google.com/spreadsheets/d/1xoJPNPT4-tixp4Zexzt_wUgYMLru1LgedeOSkmWcoCU/edit#gid=0
Excelchat Expert
05/02/2018 - 09:46
Check
Excelchat Expert
05/02/2018 - 09:47
https://docs.google.com/spreadsheets/d/1xoJPNPT4-tixp4Zexzt_wUgYMLru1LgedeOSkmWcoCU/edit?usp=sharing
Excelchat Expert
05/02/2018 - 09:47
click on the second link please
User
05/02/2018 - 09:48
nice how did you do that?
Excelchat Expert
05/02/2018 - 09:48
first i checked the team number with ISODD function
Excelchat Expert
05/02/2018 - 09:49
then I embeded the result in a IF
Excelchat Expert
05/02/2018 - 09:49
If ISODD then I increased the value of the cell by 1 such that it acts like an even
Excelchat Expert
05/02/2018 - 09:49
And IF not then as it is
User
05/02/2018 - 09:50
ah got it
Excelchat Expert
05/02/2018 - 09:50
:)
User
05/02/2018 - 09:50
thank you
User
05/02/2018 - 09:50
this was really helpful
Excelchat Expert
05/02/2018 - 09:50
If you leave please end the chat from your end and give me ratings
Excelchat Expert
05/02/2018 - 09:50
thanks
User
05/02/2018 - 09:51
will do thanks
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.