the database & spreadsheet system that tracks the California's Fantasy 5 for an educated way to play and win.

LottoMining.com the place for data tables and filters to play repeating patterns in five draw lotto games.

 

Strategy

BI: Business Intelligence

DB: Database lesson and free code

Links:

> Pivot table of counts of X draws back  > all possible pairs  > 2 & 3 repeat from X back  

The five right most columns of this table records the replacement of a particular number ( where it was last picked and in which relative position).  On those days you generally DON'T want to play.

One of the lead developer's favorites:The Daily Dashboard shows a pivot table overview of numbers repeating from the 5 rightmost columns below--great for spotting trends from day to day!!

DateDraw 1Draw 2Draw 3Draw 4Draw 5Replace 1Replace 2Replace 3Replace 4Replace 5
7/2/200835132434210-1.15.1-3.1
7/1/20081131620259-17.117-15.1-3.1
6/30/20083912333612.166151
6/29/2008822263436111.124.13.117
6/28/20088111825371123-2.114
6/27/2008471421242-3.1-17.2-4.15
6/26/2008101125273410.131351
6/25/2008417182334134.11.11.1-11.1
6/24/20087912182312.1-1.12-14.1-7.2
6/23/20089112135394211.13.14
6/22/2008151221244-1.1-1.1-2.3-4.1
6/21/200851217273113.12-4.1-1.2-2.1
6/20/200821272930354.31.13.1-5.14
6/19/20089122731396159.11.121
6/18/20081322243110232515-9.2
6/17/20088172329385.2210.112.12
6/16/20086102021359-14.111-15.17
6/15/200815173033381.143.115.14
6/14/2008131516343734831
6/13/20089192532376.12.17.243
6/12/200847830369.1-8.1411.1-27.1
6/11/2008131719343824.1143.115
6/10/200814151827374123.129.13
6/9/200813153132356.231.195
6/8/200815831343-10.1-14.26.1-4.1
6/7/2008691723378.111-2.1113
6/6/2008141516232514.26-5.1-2.1-10.1
6/5/20081172026291411.1-26.22.1-5.2
6/4/200871223343511.1-4.1-28.1613
6/3/2008241324266-4.11-12.1-2.1
6/2/200810111328311-12.1-5.116.122
6/1/2008101621263016.12.111.1-16.12
5/31/200812152932332.113.11.17-2.2
5/30/20084616293038322
5/29/200851233343925.13.16.15.16
5/28/200821319293022.22.2313
5/27/2008491625384.12-6.16.117
5/26/20082312131921140-6.231
5/25/2008891729377-5.147.15
5/24/2008272232341-7.119.22-11.1
5/23/200824143339144-21.1-15.14
5/22/2008162432353221612-2.1
5/21/200811161721252.22.2104-1.2
5/20/20089132535372.1917.17.1-12.1
5/19/2008141116393-11.114.1-5.13
5/18/2008891518291.1-5.13.1-1.1-8.2
5/17/200878182128586.1-14.218
5/16/200811026363911.132.114
5/15/20081310153012-1.1-1.1-2.2-1.1
5/14/200831016303692.12.11617