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
3/9/2010151718273881-6.1-2.110
3/8/2010111724293711.210.25.1221
3/7/201081227343718.2522.1-5.1
3/6/2010271033361616-2.25-6.1
3/5/20105232728346.121.29.1-5.1-1.1
3/4/20101013253439425.288.12
3/3/201011821242613-2.115-16.2
3/2/201011235373951015.231
3/1/201015213033393.27.17.28.11
2/28/201010182836391.212.12.23.111
2/27/2010351037381-33.1-4.216.127
2/26/2010391517289-7.1-3.1-2.210
2/25/20101611193616-1.1-3.162
2/24/201061725273425.12.1-3.216
2/23/20101015163136313.2-25.1-2.111
2/22/20106112125306-1.14.299
2/21/201011273132334.310.11.1151
2/20/201010121431334.1181.1-5.1
2/19/201091217193112.2-16.111-1.1-8.1
2/18/2010271920215-11.1-3.1-27.1-4.2
2/17/201034811397-35.1-4.1-8.28
2/16/201061018242843.1-1.2-10.1-26.2
2/15/2010181926333511-4.11.111
2/14/2010181921293311.212.1-17.19-17.2
2/13/20102810253051-5.15-21.1
2/12/2010681423362.12.1-16.1-1.36
2/11/2010232627313722.12.24.271
2/10/201036815376-4.1-3.1-4.28
2/9/20101112226397-4.1-14.11012
2/8/20102101725346.115-5.165
2/7/201078913271133-2.2-4.1
2/6/20106152432365.1611.1-6.1
2/5/2010111324293212.2174.11616
2/4/2010389313528.13.1563
2/3/2010121718273435.119.1-3.111
2/2/2010121925371116717
2/1/201016824352-8.1-2.1-6.13
1/31/201012152736386.1-3.14.11.1-10.1
1/30/20101892636824-1.222.1-2.1
1/29/20109161731356.110.11315.12
1/28/2010152133363913.26.23.22.17
1/27/2010714192735110.12-4.1-9.1
1/26/201072224253671.2-21.14.17
1/25/201051219223327.11.122.11
1/24/201061011193339-8.1-3.2-14.1
1/23/201059273034354.17-12.1
1/22/2010122021257-19.114.1-12.2-8.2
1/21/2010619283839714.3125.13
1/20/201052328293228.23.214-25.2
1/19/2010713162736322126