Welcome Guest
Log In | Register )
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
52
PrintE-mailLink
Avatar
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.

    SergeM's avatar - slow icon.png
    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?

      Avatar
      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.

        Avatar
        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.

          SergeM's avatar - slow icon.png
          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.

            Avatar
            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.

              SergeM's avatar - slow icon.png
              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.

                Avatar
                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.

                  Avatar
                  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.

                    SergeM's avatar - slow icon.png
                    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.

                      SergeM's avatar - slow icon.png
                      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.

                        Avatar
                        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?

                          SergeM's avatar - slow icon.png
                          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.

                            Avatar
                            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?

                              SergeM's avatar - slow icon.png
                              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.