Can Arcs and Circles tell us anything to improve our Predictions?Prev TopicNext Topic

• AllenB

  

  California
  United States
  Member #167,122
  June 27, 2015
  1,635 Posts
  Offline
  Jan 27, 2016, 1:07 pm

  ▲▼
  In response to SergeM

  Quote: Originally posted by SergeM on Jan 27, 2016

  Burnouts with Excel are mostly due to not using the Visual Basic Editor. Also 64bits does much better than 32bits.

  I prefer my web version for pick 3 charts (HREF).

  For American workouts, I mostly dislike when you find the most recent drawing at the top. Most disturbing is the date format MM / DD / YYYY.

  Another disease was the consequent display of combinations as String. You can make Strings, but Excel works with cells.

  Thanks Doc; but, I think I will seek treatment for my disease at the Kola TiaLovesLotto Clinic
• AllenB

  

  California
  United States
  Member #167,122
  June 27, 2015
  1,635 Posts
  Offline
  Jan 27, 2016, 1:23 pm

  ▲▼

  I wanted to share something with you that I just ran out on the Last 100 Games of Ca Daily 4.

  I calculated the Draw Value of the mid point between the 3 previous Games for each number position.  (1-2, 2-3, 3-4)  I then took an average of the draw values and compared it to the next number drawn.  In 87% to 92% of the time the next draw does not equal the average Draw value from the previous 3 games.  This might be an important step in weeding out numbers.

  I need to test this more to see if it holds up.  I did this with a simple setup in Excel and a macro to generate the history data

  N4	5
  Game	2805	2806	2807	2808
  Y=	7	0	8	8
  X=	1	2	3	4
  Mid Point Y	3.5	4	7.5
  Avg Y	5