|Posted: January 1, 2010, 12:50 pm - IP Logged|
I have been experimenting with a filter, Arithmetic Complexity in Fantasy 5. It also can be used in other lottery 6/xx type games. My question is this, can this formula be adapted to use for Play 3 & Play 4 type games. In 5/xx & 6/xx type games, the draws are in ascending order and the digits don't repeat. The way the formula is setup is below.
I'm hoping KY Floyd or Jadelottery or anyone else who knows will supply an answer.
|0||1|| || || ||1797|
|6||1346|| || ||2.29||0|
|5||3086|| ||44%|| || |
|5&6||2138|| ||69%|| || |
There are 163,896 combos in AC 6 and 96,738 in AC 5. The formula is
start with P5-P4, follow the example. To calc the Unique Values, use this formula =SUM(IF(COUNTIF(A17:J17,A17:J17)=0,"",1/COUNTIF(A17:J17,A17:J17))), enter in Excel as a array, CTRL-SHIFT-ENTER.
The AC formula is =K17-(5-1) K is referencing the Unique Value cell. It's a very powerful filter. If a person just concentrated on playing the combos in AC 6, which hits 180 times a year, approximately 15 times a month.