|Posted: June 27, 2015, 4:29 pm - IP Logged|
I got into the Cal Fantasy 5 about a year ago. I have spent many hours breaking down the game history in Excel. I have developed a Workbook that let's me select numbers based on the Games Out "GO" for each number.
I group the Games Out into 4 Quadrants Q1=(1-5) Q2=(6-10) Q3=(11-15) Q4=(16-20) (numbers with GO greater than 20 are rounded to 20) I created a 4 digit combination counting the number from each Quadrant, ie: 3-1-1-0 , (3 from Q1)-(1 from Q2)-(1 from Q3)-(0 from Q4). I have also reconstructed the Games out for each number in all of the games from about Game #1000. This lets me look at how many numbers were in each Quadrant for each game (referred to as "Count"). Filters then let me see how many numbers were picked from each Quadrant for any Count. For example Game #7900 had 20 numbers in Q1, 8 numbers in Q2, 4 numbers in Q3 and 7 numbers in Q4. The Games Out Quad Combination ("GOQC") for that game was 3-0-2-0.
I can select numbers based on a "GOQC" There are only 56 combinations possible. 15 of these combinations have been picked less than 10 times. the top 15 of the combinations have been picked 75% of the time.
I don't want to start of with to much info so I will close by saying that even with all this data This game is still totally random.
This is my current Video Game of choice
Any one out there addicted to Excel like me?