dcsimg
www.webdeveloper.com
Results 1 to 4 of 4

Thread: Can anyone offer code to solve this problem?

Hybrid View

  1. #1
    Join Date
    Aug 2013
    Posts
    2

    Can anyone offer code to solve this problem?

    I am hoping to find a simple code or even a function to include in excel to figure out this problem below, any ideas are welcomed and please keep in mind that I am a newbie.

    I am not sure what a correct term would be (so if you know, please tell me), but I will describe the situation. There is a total number of people from the list that must be selected, each person costs X and will produce Y. I want to be able to list many people with their cost(X) and production(Y) to offer the maximum total production(Y) for a total cost(X) which stays within the limits given.

    Example, 3 people must be selected from below and the total cost must be 10.0 or less.

    Person A costs 8 and will produce 10
    Person B costs 7 and will produce 9
    Person C costs 6 and will produce 15
    Person D costs 3 and will produce 9
    Person E costs 2 and will produce 5
    Person F costs 1 and will produce 3
    Person G costs 1 and will produce 1

    in this example Person C, D and F total 10 and will produce 27.

    I hope the way I am explaining this is correct and if anyone can offer any sort of help with this, I really look forward to hearing from you, thank you in advance.
    Alan

  2. #2
    Join Date
    Jun 2008
    Location
    Europe
    Posts
    1,114
    This is very simple and basic excel.

    This is how a headcount section of a budget will work.
    Simply make a 'key' in the top corner of a sheet in excel, then call the cells and do the math.
    Excel is not something that relates to this forum, get a basic book on it, what you describe is basically child's play for the most inexperienced beginner with MS Excel.

  3. #3
    Join Date
    Aug 2013
    Posts
    2
    Quote Originally Posted by donatello View Post
    This is very simple and basic excel.

    This is how a headcount section of a budget will work.
    Simply make a 'key' in the top corner of a sheet in excel, then call the cells and do the math.
    Excel is not something that relates to this forum, get a basic book on it, what you describe is basically child's play for the most inexperienced beginner with MS Excel.
    Thank you for your help Donatello. One final question, is it possible (and what's it called) if I wanted to take 1 name from "group 1" and three people from "group 2" - but still keep eveyone under a "total cost" and still result in the highest "production"

  4. #4
    Join Date
    Jun 2008
    Location
    Europe
    Posts
    1,114
    Yes of course,
    this is all part of the 'headcount' sheet of a normal budget.

    Here's an example.
    You will have to learn excel.

    http://dropdowncombobox.com/demo/Excel-Demo.xlsx

    You can change the non-shaded areas and it will calculate your costs.
    The way to find an optimal is to use a function called 'Goal Seeking". This is very advanced Excel.

    Good luck.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles