Results 1 to 12 of 12

Creat Random List

Threaded View

  1. #1
    Registered User
    Join Date
    12-31-2008
    Location
    haifa, israel
    MS-Off Ver
    Excel 2007
    Posts
    36

    Creat Random List

    I need to create a file with random purchase list that have some restrictions.
    I’ve been working on this file for few days, but I couldn’t get desirable results.
    Attached a sample file that describes what I did. It build up as the final file (just the final file has many more items).
    I’ll try to explain what I need and how it works:
    There are 4 categories: Theater, Salon, Kitchen & garden.
    I need to create random lists of purchases (each list should be a line at the total sheet)
    there is budget limitation of $100000. Each category has minimum items that must be purchase (headlines are in red color, total of 9 items).
    The minimum items that can be on one list are 11 (9 red columns & another 2 random columns). Maximum are 15 items (9 + 6). Same item shouldn’t appear twice at the same list.
    This file chooses randomly 19 items and check if the list stands up the budget.
    There are 3 issues that I couldn’t solve by myself:
    1. I should define the file to stay within minimum & maximum items per list (11-15)
    2. Make sure it doesn’t go over the budget
    3. Stabilize the list the values will not change each time I’m doing changes to file
    I’ll really appreciate who ever can help me with those issues. If someone thinks he has other way that gives me same result it will also be great.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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