+ Reply to Thread
Results 1 to 6 of 6

Combinations? Or Permutations? I need scenario's for 6 kolomns.

  1. #1
    Registered User
    Join Date
    05-12-2015
    Location
    BELGIUM BRUSSELS
    MS-Off Ver
    MICROSOFT OFFICE 2013
    Posts
    10

    Combinations? Or Permutations? I need scenario's for 6 kolomns.

    Hello,

    For a schoolwork I need to figure out some scenario's.
    For each scenario I have to make a list of all possible scenario's for the following 6 kolomns. I'll try to explain it with an example:

    scenario 1:
    indexRP=5
    indexRQ=5
    indexRP=5
    indexRQ=5
    indexRP=7
    indexRQ=5

    scenario 2 :
    indexRP=4
    indexRQ=5
    indexRP=5
    indexRQ=5
    indexRP=7
    indexRQ=5

    scenario 3 :
    indexRP=4
    indexRQ=4
    indexRP=5
    indexRQ=5
    indexRP=7
    indexRQ=5
    And following.
    But the 7 needs to stay the same. The other values need to fluctuate between 5 and 3

    I would greatly appreciate some help

  2. #2
    Registered User
    Join Date
    05-12-2015
    Location
    BELGIUM BRUSSELS
    MS-Off Ver
    MICROSOFT OFFICE 2013
    Posts
    10

    Re: Combinations? Or Permutations? I need scenario's for 6 kolomns.

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19



    A B C
    1 0 0 0
    2 0 0 =if(C1+1>3,0,C1+1)
    3 0 0 =if(C2+1>3,0,C2+1)
    4 0 0 =if(C3+1>3,0,C3+1)
    5 0 =if(B1+1>3,0,B1+1) =if(C4+1>3,0,C4+1)
    6 0 =if(B2+1>3,0,B2+1) =if(C5+1>3,0,C5+1)
    7 0 =if(B3+1>3,0,B3+1) =if(C6+1>3,0,C6+1)
    8 0 =if(B4+1>3,0,B4+1) =if(C7+1>3,0,C7+1)
    9 0 =if(B5+1>3,0,B5+1) =if(C8+1>3,0,C8+1)
    10 0 =if(B6+1>3,0,B6+1) =if(C9+1>3,0,C9+1)
    11 0 =if(B7+1>3,0,B7+1) =if(C10+1>3,0,C10+1)
    12 0 =if(B8+1>3,0,B8+1) =if(C11+1>3,0,C11+1)
    13 0 =if(B9+1>3,0,B9+1) =if(C12+1>3,0,C12+1)
    14 0 =if(B10+1>3,0,B10+1) =if(C13+1>3,0,C13+1)
    15 0 =if(B11+1>3,0,B11+1) =if(C14+1>3,0,C14+1)
    16 0 =if(B12+1>3,0,B12+1) =if(C15+1>3,0,C15+1)
    17 =if(A1+1>3,0,A1+1) =if(B13+1>3,0,B13+1) =if(C16+1>3,0,C16+1)
    18 =if(A2+1>3,0,A2+1) =if(B14+1>3,0,B14+1) =if(C17+1>3,0,C17+1)
    19 =if(A3+1>3,0,A3+1) =if(B15+1>3,0,B15+1) =if(C18+1>3,0,C18+1)
    Perhaps somthing like this ? But how do I keep the 7 then? And how do I do this with 6 kolomns?

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,088

    Re: Combinations? Or Permutations? I need scenario's for 6 kolomns.

    And you cannot build the set of combinations manually?
    See attached
    Attached Files Attached Files
    Last edited by PCI; 05-18-2015 at 03:44 PM.
    - Battle without fear gives no glory - Just try

  4. #4
    Registered User
    Join Date
    05-12-2015
    Location
    BELGIUM BRUSSELS
    MS-Off Ver
    MICROSOFT OFFICE 2013
    Posts
    10

    Re: Combinations? Or Permutations? I need scenario's for 6 kolomns.

    3 3 3 3 3 3
    3 3 3 3 3 4
    3 3 3 3 3 5
    3 3 3 3 4 3
    3 3 3 3 4 4
    3 3 3 3 4 5
    3 3 3 3 5 3
    3 3 3 3 5 4
    3 3 3 3 5 5
    3 3 3 4 3 3
    3 3 3 4 3 4
    3 3 3 4 3 5
    3 3 3 4 4 3
    3 3 3 4 4 4
    3 3 3 4 4 5
    3 3 3 4 5 3
    3 3 3 4 5 4
    3 3 3 4 5 5
    3 3 3 5 3 3
    3 3 3 5 3 4
    3 3 3 5 3 5
    3 3 3 5 4 3
    3 3 3 5 4 4
    3 3 3 5 4 5
    3 3 3 5 5 3
    3 3 3 5 5 4
    3 3 3 5 5 5
    3 3 4 3 3 3
    3 3 4 3 3 4
    3 3 4 3 3 5
    3 3 4 3 4 3
    3 3 4 3 4 4
    3 3 4 3 4 5
    3 3 4 3 5 3
    3 3 4 3 5 4
    3 3 4 3 5 5
    4
    Well I have been trying but it takes a lot of time, and i don't know if i make some errors.

  5. #5
    Registered User
    Join Date
    05-12-2015
    Location
    BELGIUM BRUSSELS
    MS-Off Ver
    MICROSOFT OFFICE 2013
    Posts
    10

    Re: Combinations? Or Permutations? I need scenario's for 6 kolomns.

    I can only see a link to the topic i just posted in the attachment

  6. #6
    Registered User
    Join Date
    05-12-2015
    Location
    BELGIUM BRUSSELS
    MS-Off Ver
    MICROSOFT OFFICE 2013
    Posts
    10

    Re: Combinations? Or Permutations? I need scenario's for 6 kolomns.

    Ok, Now I see it, THANK YOU SO MUCH ! !!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Permutations and combinations
    By WELLO in forum Excel General
    Replies: 0
    Last Post: 11-28-2012, 11:59 AM
  2. combinations/permutations
    By KBownds in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-23-2012, 11:18 AM
  3. Combinations/Permutations???
    By seneca in forum Excel General
    Replies: 2
    Last Post: 02-16-2010, 01:49 PM
  4. Permutations/Combinations
    By svs9j in forum Excel General
    Replies: 0
    Last Post: 02-05-2010, 04:33 PM
  5. Combinations, Permutations
    By scantor145 in forum Excel General
    Replies: 1
    Last Post: 11-29-2005, 09:30 AM

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