+ Reply to Thread
Results 1 to 3 of 3

What is the maximum value given a fixed contstraint?

  1. #1
    Registered User
    Join Date
    09-16-2007
    Posts
    2

    What is the maximum value given a fixed contstraint?

    I have a spreadsheet that I need to find the max score given a cost constraint. I have 4 pages of data. Each page is a different type. Type 1 consists of 26 names (I must use one). Type 2 consists of 26 names (I must use two). Type 3 consists of 53 names (I must use two). Type 4 consists of 87 names (I must use two). Each of the names has an independent score and cost. If I were to calculate this manually, I would have 348,484,624,800 combinations. I don't have that kind of time. lol. Besides some of those combinations would be above the cost constraint. Can someone please help me?

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Please attach here a sample file in zip format for better consideration.

  3. #3
    Registered User
    Join Date
    09-16-2007
    Posts
    2

    Attachement

    Here is the zip of the file I am working on. Thank you for your help and consideration.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1