Probability calculator

I need a calculator that can populate a table with a series of combinations. It is a permutation calculator, and is to be used for picking winning combinations of numbers for a tipping competition, as well as pricing analysis. In short a what if calculator based on a set of variables, able to recognise some data selections can not work together. Required to be done in excel Must be able to calculate all possible outcomes from a series of data sets, and then automatically populate another sheet that has pricing information for each combination. Concept - 5 football games each with three outcomes - win lose draw, how many 5 result combinationbs are there (show them in a table) noting only one outcome from each game is able to form part of the 5 result combination in each possible outcome. ie game one, cannot have all three results in a valid comibation. Each combination must have a result from each game in the data set. Then with the odds for each game known, the potential payout for each possible combination is then shown.