Welcome Guest
Log In | Register )
You last visited December 3, 2016, 6:31 am
All times shown are
Eastern Time (GMT-5:00)

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

Topic closed. 16 replies. Last post 10 months ago by AllenB.

Page 2 of 2
51
PrintE-mailLink
Avatar
Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
Posted: January 27, 2016, 1:07 pm - IP Logged

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

    Avatar
    Lincoln, California
    United States
    Member #167130
    June 27, 2015
    256 Posts
    Offline
    Posted: January 27, 2016, 1:23 pm - IP Logged

    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