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
9/6/201091112192313.24-2.1-6.1-2.2
9/5/2010563132371-12.15.11-2.1
9/4/20105122332334.162.2-9.14
9/3/201032730373814.14.26.18
9/2/20103111721231-6.11.2-31.1-3.3
9/1/201037101517311-4.1-2.3-3.2
8/31/201025193133512.1-5.12.1-11.1
8/30/201015232729303.210.116.15-2.1
8/29/2010312172431121-6.26
8/28/2010310173037910-23.212-2.1
8/27/2010111215202810.1-2.1-2.1-29.1-3.1
8/26/201021932373868.121.21.141
8/25/2010121516293724.2-2.14.123
8/24/2010689283616.1-6.1-2.1-8.15
8/23/201015242529312.219.286.1-11.1
8/22/2010192226371-5.15.137
8/21/20101715161824-6.1-1.1-14.1-7.3
8/20/20102152333346-8.17.16.1-2.1
8/19/201034526368-11.1-8.1-5.11
8/18/201081019343657.1-3.138
8/17/20109111422298.14-1.1-4.1-9.1
8/16/201013142830357.21422.23.1-6.1
8/15/20107192534377.26.23123
8/14/2010218262733723.2-8.1-11.2
8/13/2010811222330462.113.1-3.3
8/12/2010151825313712.15.2-7.1-2.110
8/11/20103510222630-1.1-9.217-12.2
8/10/20105303135361224.35.113.12
8/9/20108913193911.1-10.1-9.2-14.15
8/8/201046729364.1-2.1-23.221
8/7/201021116183633.17-1.21
8/6/20106182729365.16.2122.13
8/5/2010172527313210.132.116.13-2.3
8/4/2010241124398.1-3.1-5.1-1.323
8/3/2010243233343611.34.22.115.12
8/2/2010101421313723.1-9.115.243
8/1/20104612333612.11443.111
7/31/2010131516182383.2-5.2-7.1-5.1
7/30/201091126323725.123.14.13
7/29/201058203133411.1105.17
7/28/2010111121535131-3.1-7.1
7/27/2010121226377-5.1-20.23113
7/26/201016171923322.14.12.1-5.23
7/25/2010511152228216-4.2-2.1-8.1
7/24/2010141618193112.19-1.126.14
7/23/201013182224321.13.18.14-1.1
7/22/20102131732331754.1-1.117
7/21/2010152332353614.110.113.19-5.1
7/20/2010141827311227-6.2-11.2
7/19/20101112024341-2.1-3.1-2.1-10.1