Welcome Guest
Log In | Register )
You last visited January 16, 2017, 12:06 pm
All times shown are
Eastern Time (GMT-5:00)

SoniQ BOOM, a new P3/P4 system (Excel)

Topic closed. 116 replies. Last post 11 years ago by xavier102772.

Page 5 of 8
PrintE-mailLink
Avatar
Anna, TX
United States
Member #26720
November 21, 2005
263 Posts
Offline
Posted: January 4, 2006, 4:22 pm - IP Logged

try this again

here ya go
    Avatar
    Calgary
    Canada
    Member #9419
    December 7, 2004
    228 Posts
    Offline
    Posted: January 4, 2006, 4:57 pm - IP Logged

    Just looking through yours hareless.  It doesn't count correctly either.  I'm trying to figure out a formula that does count correctly.  Although, I guess if the wrong formula produces so many wins, do we care if the formula is wrong or what it is doing as long as it keeps winning.  Probably not, but I think we should get down to the bottom of the formula. 

      Avatar
      Calgary
      Canada
      Member #9419
      December 7, 2004
      228 Posts
      Offline
      Posted: January 4, 2006, 4:58 pm - IP Logged

      I used the file you emailed me to check through.  The link to your ftp doesn't seem to work.

        Avatar
        Anna, TX
        United States
        Member #26720
        November 21, 2005
        263 Posts
        Offline
        Posted: January 4, 2006, 5:00 pm - IP Logged

        yeah I fixed the link, but I don't know how to make the zip file public. Work on it later.

          Pogo's avatar - wfl
          NC
          United States
          Member #29378
          January 1, 2006
          552 Posts
          Offline
          Posted: January 4, 2006, 10:24 pm - IP Logged

          I have been giving it a whirl too, and it looks like the problem is that is counts the number that it is trying to match.
          For example: Previous number is 883 and current number is 230, so you get the 2 digit code 82, when it searches for 82 as a match it not onlys counts all previous 82 instances - it's also counting that very same instance. Not only am I finding this to disturb the count, but it is also resulting in the "false" correct picks. Again, if it didn't count the 82 code that it is actually trying to match than you get the actually tabulated pick versus the current predisposition towards what we already know is correct.

          If I have lost anyone or someone doesn't agree, let me know. But if your finding the same thing... ...let's see what we can do to fix it.

           BTW, hypersoniq... ...this is simply a piece of art you have made here. Very well thought out.

           Also instead of having the picks go from 0 to 9 or 9 to 0, I added an extra column (where the black out column was) to count the number of high numbers that matched and turn the background red. So, if the 82 code had 3 "0's" to follow, 3 "4's" to follow, and 3 "8's" to follow. The cell turns red and tells me that there are 3 matches for that numbered sequence.

          Again, hope this makes sense... ...Let me know, Pogo 

            retxx's avatar - mrthumbs
            BOSTON
            United States
            Member #48
            September 9, 2001
            3611 Posts
            Offline
            Posted: January 4, 2006, 10:40 pm - IP Logged

            I am confused also because i notice in the column that picks the new number to play it highlights pos. as if they were allready winning numbers drawn. Anyone else see this?

              Avatar
              Anna, TX
              United States
              Member #26720
              November 21, 2005
              263 Posts
              Offline
              Posted: January 4, 2006, 11:51 pm - IP Logged

              no I noticed it too. I am having a problem with the columns that play new picks period.

                hypersoniq's avatar - 8ball
                Pennsylvania
                United States
                Member #1340
                April 6, 2003
                2450 Posts
                Offline
                Posted: January 5, 2006, 6:06 am - IP Logged

                it does count the match it has, that's why the -1 is in there... to make sure you don't haave info that you wouldn't before hand.

                for the error, It may be becaue the announcer before you enter the next draw is 000 which then changes to the number when you enter it... if a 0 is called for, it highlights even tho it wasn't picked.

                I will continue to look into this... by tonight or fri... I will replace the sheets on my website with all 4 variants of the pick3... if that gets the bugs squished, pick4 is easy to adapt.

                Playing more than one ticket per game is betting against yourself.

                  Avatar
                  Calgary
                  Canada
                  Member #9419
                  December 7, 2004
                  228 Posts
                  Offline
                  Posted: January 5, 2006, 10:29 am - IP Logged

                  My bad.  I should have been more thorough with my counting.  The counting is just off by one on pretty much every count as per soniq.  Sorry.  I really need to learn how to count.  Maybe back to grade school.  LOL.

                    Avatar
                    Anna, TX
                    United States
                    Member #26720
                    November 21, 2005
                    263 Posts
                    Offline
                    Posted: January 5, 2006, 10:55 am - IP Logged

                    yeah, soniq is really on the something.

                      Avatar
                      Calgary
                      Canada
                      Member #9419
                      December 7, 2004
                      228 Posts
                      Offline
                      Posted: January 5, 2006, 11:24 am - IP Logged

                      Agreed hareless.  Surprising everyone isn't all over this like white on rice.  Looking at the history for my draws.  I should be getting a hit pretty soon since it hasn't hit for about 180 draws, which is unusual for the Western Canada Pick3 history.  Also, can't wait for all soniq's sheet's.  Definately gold.  :)

                        Avatar
                        Anna, TX
                        United States
                        Member #26720
                        November 21, 2005
                        263 Posts
                        Offline
                        Posted: January 5, 2006, 12:15 pm - IP Logged

                        it does count the match it has, that's why the -1 is in there... to make sure you don't haave info that you wouldn't before hand.

                        for the error, It may be becaue the announcer before you enter the next draw is 000 which then changes to the number when you enter it... if a 0 is called for, it highlights even tho it wasn't picked.

                        I will continue to look into this... by tonight or fri... I will replace the sheets on my website with all 4 variants of the pick3... if that gets the bugs squished, pick4 is easy to adapt.

                        oh yeah, doh. I wasn't really thinking about what he was saying. I know that if the new pick has a 0 it will highlight and mark as x  because of the 000 in j, k, and l.

                        I was just stuck in the fact the previous days picks were changing when you entered in the new draw....

                        which I may or may not matter. 

                          Avatar
                          Anna, TX
                          United States
                          Member #26720
                          November 21, 2005
                          263 Posts
                          Offline
                          Posted: January 5, 2006, 12:17 pm - IP Logged

                          Agreed hareless.  Surprising everyone isn't all over this like white on rice.  Looking at the history for my draws.  I should be getting a hit pretty soon since it hasn't hit for about 180 draws, which is unusual for the Western Canada Pick3 history.  Also, can't wait for all soniq's sheet's.  Definately gold.  :)

                          oh well, I am pretty sure people are paying attention.

                          I am starting to understand why he is waiting until he is done before posting the new ones. 

                            Avatar
                            Anna, TX
                            United States
                            Member #26720
                            November 21, 2005
                            263 Posts
                            Offline
                            Posted: January 5, 2006, 12:45 pm - IP Logged

                            OK OK. I see now why the pick changes. Now that I have had time to go back and learn something.

                            I shutup now. 

                              Avatar
                              Calgary
                              Canada
                              Member #9419
                              December 7, 2004
                              228 Posts
                              Offline
                              Posted: January 5, 2006, 1:12 pm - IP Logged

                              Did some calculations based on the skips of hits in my drawing history using soniq's system.  Here are the results(History has 3241 draws with 47 hits from soniq's spreadsheet, which is approximately 5.23 hits/year):

                              STDEVMEDAVG1STD(.68)2STD(.95)3STD(.99)
                              76.048533664.7234129.4468194.1702258.8936
                               

                              Skips

                              88
                              186
                              7
                              5
                              2
                              22
                              139
                              90
                              27
                              63
                              23
                              5
                              135
                              9
                              92
                              42
                              79
                              38
                              3
                              2
                              348
                              50
                              93
                              12
                              35
                              8
                              14
                              37
                              30
                              27
                              84
                              1
                              45
                              36
                              266
                              11
                              102
                              212
                              53
                              163
                              59
                              36
                              205
                              12
                              35
                              9
                              2

                                        206+