Combinatorics

Combinations without repetition in EXCEL

Calculate in MS EXCEL the number of combinations of n elements by k. With formulas, you'll list all combinations of (an English translation of the term: Combinations without repetition).

Permutations (sequence) with repetition in EXCEL

Calculate in MS EXCEL number of permutations with repetitions of n on k (sample return). Also use the formulas out on a sheet corresponding options for Placements (English translation of the term: sequence with repetition or permutations with repetition).

Combinatorics in EXCEL

a Review article in which the main function MS EXCEL to calculate the number of permutations, combinations and placements. Options considered are combinations without repetitions and repetitions (sample return).

Combinations with repetition in EXCEL

Calculate in MS EXCEL the number of Combinations with repetitions of n on k (sample return). Also use the formulas out on a sheet corresponding to combinations of (an English translation of the term: combinations with repetition).

Permutations with repetition: Combinatorics in EXCEL

Calculate in MS EXCEL number of permutations with repetitions of n elements. Using formulas will list all such permutations (English translation of the term: permutations of multisets).

Permutations without repetition: Combinatorics in EXCEL

Calculate in MS EXCEL number of permutations of n elements. With formulas, you'll sheet all versions of the permutations (English translation of the term: permutation).

Combine elements of different sets in EXCEL

Let there be several sets {A1, A2, A3, A4 ...}, {B1, B2, B3, ...}, {C1, C2, ...}, the number of elements which can be different. You want to make all the possible combinations of elements of these sets so that in combination present only one item from each set: (A1, B1, C1), (A1, B2, C1), (A1, B2, C2), ... Also calculate in MS EXCEL, the number of such combinations.

Partial permutation (sequence without repetition) in EXCEL

Calculate in MS EXCEL number of permutations of n with k and using the formulas we derive for the sheet corresponding options for placements (English translation of the term: partial permutation or sequence without repetition).

Сutting-stock problem in EXCEL

want to cut the wire into pieces of a certain length, so that the amount of waste was minimal. The problem solve by brute force all possible combinations of cutting.