permutations/combinations

  1. M

    How to display these combinations

    <colgroup><col span="2"><col span="2"></colgroup><tbody> 0 0 0 0 1 1 1 1 2 2 2 2 3 3 3 3 4 4 4 4 5 5 5 5 6 6 6 6 7 7 7 7 8 8 8 8 9 9 9 9 </tbody> Code: Function ListPermut(num As Integer) 'Permutations without repetition Dim c As Long, r As Long, p As Long Dim rng() As...
  2. P

    VBA Task Order Permutations with constraints and compatibility

    Good Evening, I am trying to create a list of logical schedule permutations. I have a list of 50 tasks, some can be done in parallel some may require other tasks to finish before they can begin. I am trying to write a VBA macro which goes generates a list of LOGICAL/FEASIBLE task order...
  3. D

    Limited Repeating Permutation Macro

    I have found some threads that are close to this question, but none that I have been able to modify for my needs. The question is this: Say I have 3 object types a,b and c, where each has a quantity of x,y and z respectively. I need to load all of the possible permutations into a matrix (not...
  4. A

    Combinatorics problem (VBA code)

    Hi guys. Is it possible for us to process a combinatorics problem from Excel? For example, say I have 2 columns A & B. Column A contains 100 orders of quantities of items from 1-10 (with repetitions), and Column B contains rate per unit of that item. Let's say I set a parameter in which I say...
  5. A

    How To: Permutations from columns with various data

    I have to come up with a list of part numbers for my company and I have to come up with all the permutations for part numbers. I started to think that this was a simple manual task until I laid it out and realized the total number of permutations that would be listed. I'm asking for some help...
  6. E

    Permutation

    Hi guys, I wonder if someone could help me with this query. I wish to get all the possible unique combinations out of this table. From Single column to Wireless/None column. So there should always be 7 combination for every turn. The order of these categories is very important so I can't have a...
  7. A

    Can I identify a specific permutation of responses to a survey and display it?

    I very much appreciate any and all help in accomplishing this objective as follows: I have an online survey which has 9 list box questions. The only options for each question is "A" or "B". When the form is submitted I will have one row with some "9 column permutation" of "A's" and "B's". Each...
  8. G

    All possible combinations with repeats allowed

    Hello Everybody, I'm looking for a way to have excel display (make a list) of all possible 9 digits/spaces combinations using three letters: CMU, where the letters can be repeated. I searched this forum and the internet. I've google it different ways and I still haven't figure out the answer...
  9. G

    permutations

    I would like to make a function based off a number, that arranges the digits 1 through 9 in all possible combinations. Example: 1 2 3 4 5 6 7 8 9 1 1 2 3 4 5 6 7 9 8 2 1 2 3 4 5 6 8 7 9 3 1 2 3 4 5 6 8 9 7 4 1 2 3 4 5 6 9 7 8 5 1 2 3 4 5 6 9 8 7 6 1 2 3 4 5 7 6 8 9 7 1 2 3 4 5 7...
  10. G

    Combinations

    I want a formula to work out every 9-digit number, that uses only the values 1,2,3 and 4. (I don't mind having the numbers in separate cells) Like this: 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 3 1 1 1 1 1 1 1 1 4 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 2 2 1 1 1 1 1 1 1 2 3 1 1 1 1 1 1 1...
  11. S

    reverse distribution of excel totals

    I have an Excel problem, that I need help with.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have the following table. I require 25 man days of work to be done at a given location. I calculate that I will need to make 10 visits to that...

Some videos you may like

This Week's Hot Topics

Top