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
5/16/200811026363911.132.114
5/15/20081310153012-1.1-1.1-2.2-1.1
5/14/200831016303692.12.11617
5/13/20089152634351.19.264.125
5/12/2008791016277.1-5.1-1.218-2.3
5/11/200810131718315.17.116.111-9.1
5/10/2008202729323819.33.2112
5/9/20082829323414125.12626
5/8/20084833373823.11.212.15
5/7/200892326273311.15.1-6.111
5/6/20084102427332132.2-22.1-17.1
5/5/20083781122319-30.1-6.2-6.2
5/4/2008451315248-3.14-10.1-1.2
5/3/20081212425381664.122-2.1
5/2/20083142331392-5.12.2-1.11
5/1/200852631383923.13.288
4/30/2008361318232558-3.2
4/29/200851122242811.13.118-1.2-26.2
4/28/200832426303149.11.14.18
4/27/20081421232636829.2-20.116
4/26/2008491126372.1-4.1-5.14.111
4/25/2008261317194-15.1-15.1-5.1-4.2
4/24/2008341516301-22.12-1.1-9.1
4/23/200831016383931-3.115.14
4/22/2008910151826145.17-13.1-8.3
4/21/20082111920364.1-31.1-34.217
4/20/200831617203122.132-1.2-3.1
4/19/2008142024333910.114.1-7.213
4/18/2008351633353.1-22.1-12.161
4/17/2008121031351-3.1137.1-1.1
4/16/2008171235391-5.116214
4/15/200813153037617-2.1-2.114
4/14/200822627293618.1-2.15.13
4/13/20082153032341023.1-1.18
4/12/200824273233395.22.1449
4/11/200871522253611.1311.125
4/10/200861327303168.14.124-13.1
4/9/200811418252945.2-2.24-2.1
4/8/2008915323338210.17.11.14
4/7/2008182324293327.321.1-12.1148
4/6/20089162627362.115.310.24.120
4/5/200818202534323-6.1-2.2-2.1
4/4/20086910143813.110-3.2-3.2-21.1
4/3/200822528343931.29.2143
4/2/20084813252756-3.2-1.1-3.1
4/1/200810142532375.242193
3/31/2008271222392249.1-8.13
3/30/2008132025273353.175.1-2.124
3/29/2008231521375-4.1-8.123
3/28/200841427313929-2.113-2.18