Welcome Guest
You last visited December 4, 2016, 9:25 pm
All times shown are
Eastern Time (GMT-5:00)

# Daily Picker in Excel

Topic closed. 25 replies. Last post 1 year ago by lakerben.

 Page 1 of 2
Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
 Posted: July 27, 2015, 3:00 pm - IP Logged

For the last month I have been developing an Excel Worksheet that creates picks based on any calculation involving a previous number or sequence.

The first step was to download all of the picks for the California Daily 3 and calculate all of the mirror numbers for each sequence.  The numbers are listed by game number (descending from Last draw) as follows:  N1 N2 N3 M1 M2 M3

The next step was to create a formula set for each Number and Mirror number.  For example: using M2 from a previous draw + or – any number calculates a new number.  The INDIRECT function allows this formula to change the Number or Mirror Number  or +/- number.  More complicated formulas use multiple previous numbers or mirror numbers in multiple games (added, subtracted or multiplied) to create a pick For example Take M2 from the previous game and add it to N1 from the picks 3 games back.

The indirect function allows the rapid calculation of the formula for any Number or Mirror and for any previous game.  The initial setup uses scenarios for each Number and Mirror Number (6).

The calculated Numbers and their corresponding Mirror numbers are lined up on the same row as the game being analyzed and are generated for the next game.  Using the COUNTIF function in the formula for Conditional Formatting allows the numbers to be highlighted if they are in the numbers selected for that row (game) including colors that indicate the position (N1, N2, or N3).

For each Game all possible sequences from the selected numbers are calculated starting with the Straight Sequence (N1-N2-N3) and including the other 5 Box sequences.

Adjacent to each set of formula scenarios, number sequences are calculated in the same way.  The Worksheet also allows for the Primary Calculation or the Mirror Calculation to be turned on or off to reduce the number of projected numbers from 12 to 6.

Conditional Formatting highlights a Straight of Box if it hits.

The % of hits for each formula scenario can be calculated for any number of the previous games.  Using a number of previous games (I use 5 of 10).  Each of the 6 Senario formulas can be changed by selecting different Numbers or Mirrors, Games Back, Numbers to +/-/*.  Formulas can also include exponent values to apply to the Numbers or results in or of the scenario formula.  I use a formula that uses only the last digit in the calculated Scenario Values.

The results of the scenarios can then be viewed to see how many times they have produced a winner for each game.  I manipulate each Scenario formula until I get at least 4 winners from the previous 5 games.  The funny thing is that for the games prior to the last 5 there are almost no winners.  I am working on an adjustment factor to the Scenarios needed to produce more winners for each series of 5 games prior to the last 5.

I am wondering if anyone might be interested or has tried this approach.  I would appreciate any comments or questions out there.  I would like to invite anyone to suggest Scenario formulas for analysis.

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: July 27, 2015, 3:56 pm - IP Logged

Is this about pick 3? I did some with php, here for California: Pick 3 CA USA .

What kind of scenarios are you looking for?

Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
 Posted: July 27, 2015, 4:00 pm - IP Logged

Yes,  my dat is based on California, but any Pick 3 Can Be quickly inserted into the games block.

Ohio
United States
Member #157792
July 31, 2014
1119 Posts
Offline
 Posted: July 27, 2015, 4:02 pm - IP Logged

Thanks Allen, let me and the crew know when it's ready. Sounds like another great tool. Thanks.

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: July 27, 2015, 4:03 pm - IP Logged

I use a lite database for now.

With Excel you better don't over do it with functions.
Better keep values in cells than fill the sheets from top to bottom, and left to right with functions.
It crashes or delivers wrong values. It is finer working by lines. It never fails like that, and it is faster to use.
Also if you are playing locally, you don't need other stacks of drawings.

Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
 Posted: July 27, 2015, 4:06 pm - IP Logged

I have run a bunch of scenarios using 1 to 3 of the numbers N1,N2,N3 and M1,M2,M3 with an individual games back for each plus multiple adds or subtracts.

I have also run formulas with exponents.  there are so many option, I am looking for another persons ideas.

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: July 27, 2015, 4:09 pm - IP Logged

You need to look in the Systems forum, there you can read hundreds of posts of systems, that you call scenarios.

I have a page inspired by some wishes from members: Nuthouse , for pick 3 and pick 4. There is a system page too, but you weren't looking for that.

Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
 Posted: July 27, 2015, 4:12 pm - IP Logged

You are right about overdoing this with functions.  I have created a large number of scenarios in one worksheet and it gets to complicated and produces to many numbers.  I have tried to use these multiple scenarios by selecting a diferent set for each number.  The results are about the same.

Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
 Posted: July 27, 2015, 4:14 pm - IP Logged

Thanks,  that is where I got the idea for this.  I played with some of the posted sugestions and from that developed the Worksheet.

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: July 27, 2015, 4:15 pm - IP Logged

Reposting:

I have a page inspired by some wishes from members: Nuthouse , for pick 3 and pick 4. There is a system page too, but you weren't looking for that.

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: July 27, 2015, 4:22 pm - IP Logged

Hits

• RED: repeat
• GREEN: leapfrog
• BLUE: hit
DATEDT0123456789
2015-07-2210123456789
2015-07-2220123456789
2015-07-2310123456789
2015-07-2320123456789
2015-07-2410123456789
2015-07-2420123456789
2015-07-2510123456789
2015-07-2520123456789
2015-07-2610123456789
2015-07-2620123456789

Spans

DATEDT0123456789
2015-07-2210123456789
2015-07-2220123456789
2015-07-2310123456789
2015-07-2320123456789
2015-07-2410123456789
2015-07-2420123456789
2015-07-2510123456789
2015-07-2520123456789
2015-07-2610123456789
2015-07-2620123456789

Copied from my website. I did this in Excel years ago, now it is in html, quick and clean.

Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
 Posted: July 27, 2015, 4:34 pm - IP Logged

Have you established a consistant set of "scenarios" that produce the numbers in the boxes you show?

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: July 27, 2015, 4:39 pm - IP Logged

In pick 3 you are mostly close to probability and the expectancy of payout ratio is 50%.

It is up to the reader to guess and play, if wished. Once you get used to the view, you may find good clues.

You are asking about sequence and combination. There is probability. I posted mathematics around followers straight and boxed.
There are followers charts on my webpage for California.

Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
 Posted: July 27, 2015, 5:04 pm - IP Logged

I logged into "nuthouse" and California daily 3 on you site (I think).  There was a box with labels but no numbers.  Is this the right site?

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: July 27, 2015, 6:33 pm - IP Logged

Yes, surf to the menu page first.

https://emuis.be/pick3CA

There are 9 styled buttons. The buttons kind of work like links.
Some of the results are very big, others are short. You have to click and read through all of them.

By clicking on a button you request data from the server.
This can take a second or longer, depending of how much you are asking.

Nuthouse

You enter numbers and the server will return the combinations.
There are systems like one up or one down.
You enter values and click the button to get the combinations.

I rent two other servers, but not for this.

 Page 1 of 2