Populate source Table with set of numbers

 

 

I am trying to make player batting cards for a game that uses a three dice, 10-39 numbering sytem with 216 possible results.  I have two tables-one representing my source table-(chances each dice number will be rolled out of 216 chances) a second table that represents set of numbers and result of a players individual batting card.  My question is how can I get excel to populate the card result row on my source table based on the data (on card chances/216) from the players card totals.  For example HB has one chance and matching it to 19 on the source table is pretty simple. It becomes more complex when an F=27 and more than one value from the source table is needed.  Also working out the many number options.  Thanks for any help in advance and I do have a worksheet if this would help. 

I have a Source Table as seen below:

Dice Roll 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
Chance/216 2 3 4 5 6 6 4 3 2 1 4 6 8 10 12 12 8 6 4 2 6 9 12 15 18 18 12 9 6 3
Card Result                                                            

I also have a set of numbers that the players card is based upon as seen below:

RESULT ON PLAYER’S CARD HB 2A BB 1D 3 E 2M 1 1+ 1M 2 HR SO FM SF 1A GA DP MS G F
ON CARD CHANCES/216 1 2 3 4 4 4 5 7 8 8 8 8 9 10 15 16 18 18 19 22 27
                                                           

By: Mike

Leave a Reply

Your email address will not be published. Required fields are marked *