Formula for game needed

There is a game I play that has 9 possible outcomes per round, and is played for 6 rounds. I have come up with a way to represent all 531,441 possible games, but I need a way to figure out the final score for each game representation.

Basically, I have a spreadsheet (made with Excel 2007) that contains rows of 6 cells. Each cell contains a number (from 1-9) to represent the outcome of that round. The row of 6 cells represents a full game. What I need is a formula for the 7th and 8th cells to represent the final score, by adding up the scores from each round, for each side.

A "1" represents a score of 3 being added to the score for player "A" and a score of 2 being added to the score for player "B."

A "2" represents a score of 5 being added to the score for player "B."

A "3" represents a score of 3 being held in reserve for the winner of the next round (NOTE: in the next round, the "winner" is the person given the most points that round... if they are given the same number of points, an additional 3 points is reserved for the winner of the next round).

A "4" represents a score of 5 being added to the score for player "A."

A "5" represents a score of 2 being added to the score for player "A" and a score of 5 being added to the score for player "B."

A "6" represents a score of 2 being added to the score for player "A," a score of 2 being added to the score for player "B," and a score of 3 being held in reserve for the winner of the next round.

A "7" represents a score of 5 being added to the score for player "A" and a score of 2 being added to the score for player "B."

An "8" represents a score of 2 being added to the score for player "A" and a score of 3 being added to the score for player "B."

A "9" represents a score of 2 being added to the score for player "A," a score of 2 being added to the score for player "B," and a score of 3 being held in reserve for the winner of the next round.

Any help would be appreciated.

DMW

A couple of questions to help me understand...

What is the difference between "6" and "9"?

What happens if in Round 6 Someone gets a "3" "6" or "9"?

Thanks,
John

Can you upload example and explain in it what you want to do?

Originally Posted by kraljb

A couple of questions to help me understand...

What is the difference between "6" and "9"?

Aside from the circumstances that led to each... absolutely nothing. The only difference is in the circumstances, not the score.

What happens if in Round 6 Someone gets a "3" "6" or "9"?

I forgot about that. Basically, any points already held in reserve - along with those that are about to be held for future rounds - simply disappear... they are not awarded to any player.

DMW

Originally Posted by zbor

Can you upload example and explain in it what you want to do?

Sure.

Suppose you have a formula in the 7th and 8th cells (after the 6 cells that represent how the game went) that show the scores for "player A" and "Player B." Suppose further that in the first six cells you find 7, 2, 9, 8, 5, and 7. With the 7 in the first cell, the score for "player A" vs. "player B" becomes 5:2. With the 2 in the second cell, the score becomes 5:7. With the 9 in the third cell, the score becomes 7:9, with the computer holding 3 extra points. with the 8 in the fourth cell, the score becomes 9:15 (because the 2:3 score addition, plus the extra 3 points for the winner makes a 2:6 score addition). With the 5 in the fifth cell, the score becomes 11:20. With the 7 in the last cell, the score becomes 16:22.

Does this help?

DMW