Combinatorics

Комбинаторика в 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).

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).

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).

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).

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).

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).

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.

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).

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.