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

Clairvoyance System - GA

Topic closed. 28 replies. Last post 11 years ago by CARBOB.

Page 2 of 2
PrintE-mailLink
SirMetro's avatar - center
East of Atlanta
United States
Member #6191
August 11, 2004
1389 Posts
Offline
Posted: April 20, 2006, 1:24 pm - IP Logged

Yahoo is currently having some problems with the Groups. Give it a little while before you try to download. If need be, I will post it again.

    retxx's avatar - mrthumbs
    BOSTON
    United States
    Member #48
    September 9, 2001
    3583 Posts
    Offline
    Posted: April 20, 2006, 1:30 pm - IP Logged

    sir metro; if you do e-mail it in Mass. we have a pick 4 but we payoff on the first 3 also. I assume your excel works on both,correct? why not just send it to me anyway.thanks

      SirMetro's avatar - center
      East of Atlanta
      United States
      Member #6191
      August 11, 2004
      1389 Posts
      Offline
      Posted: April 20, 2006, 2:58 pm - IP Logged

      Retxx...I honestly do not have a clue.

      You will have to import your numbers and test it.

      I don't have time to test for GA so your pretty much on your own, I am just providing another tool for you to use.

        Raven62's avatar - binary
        New Jersey
        United States
        Member #17843
        June 28, 2005
        49619 Posts
        Offline
        Posted: April 20, 2006, 3:44 pm - IP Logged

        I'd like to take a look at your Spreadsheet, but I'm still getting file not on Server message.

          luckylady's avatar - Lottery-009.jpg
          GA
          United States
          Member #3072
          December 20, 2003
          638 Posts
          Offline
          Posted: April 20, 2006, 5:18 pm - IP Logged

          I got the 159 today thanks to this system!!

          WTG

           

                                              Cheers

            Avatar
            Hampton,VA
            United States
            Member #32721
            February 15, 2006
            88 Posts
            Offline
            Posted: April 20, 2006, 7:34 pm - IP Logged

            Still can't download spreadsheet.Disapprove

              retxx's avatar - mrthumbs
              BOSTON
              United States
              Member #48
              September 9, 2001
              3583 Posts
              Offline
              Posted: April 20, 2006, 10:53 pm - IP Logged

              sir metro thanks just one question; when i entered the date and tonights number all the columns entered except the cash 4 stayed blank. Is this right as i thought the macros should have filled all the columns including results.

                SirMetro's avatar - center
                East of Atlanta
                United States
                Member #6191
                August 11, 2004
                1389 Posts
                Offline
                Posted: April 21, 2006, 9:18 am - IP Logged

                For those who wasn't already on my mail list, you can email me at sirmetro@yahoo.com and I will send you a copy at my earliest convience.

                Retxx...The Cash4 column is merely a placeholder so you can back track the system to see if it is predicting anything for you. Use it if you wish, ignore it if you wish, up to you.

                Note to All: a number such as 121 or 212 may reflect several blanks. I do not have time to fix it at the moment. Problem is, 12-12=0, when you convert 0 to TEXT, it becomes a blank. When this happens, enter 0 in the cell so that the error in the other cells go away.

                  CARBOB's avatar - FL LOTTERY_LOGO.png
                  ORLANDO, FLORIDA
                  United States
                  Member #4924
                  June 3, 2004
                  5893 Posts
                  Offline
                  Posted: April 21, 2006, 11:11 am - IP Logged

                  To fix zero problem click format-cells-number-custom, click single zero, then type in another zero.

                    SirMetro's avatar - center
                    East of Atlanta
                    United States
                    Member #6191
                    August 11, 2004
                    1389 Posts
                    Offline
                    Posted: April 21, 2006, 1:34 pm - IP Logged

                    CarBob's idea works perfect. For those who understand how, you can replace the formulas in the first 4 columns with the ones listed below. If you don't understand, just leave it alone.

                    AB-12 - =IF(((LEFT($C3534,2)*1))>11,SUM(LEFT($C3534,2)*1)-12,SUM((LEFT($C3534,2)*1)-12+100))

                    BC-12 - =IF(((RIGHT($C3534,2)*1))>11,SUM(RIGHT($C3534,2)*1)-12,SUM((RIGHT($C3534,2)*1)-12+100))

                    BA-12 - =IF(((CONCATENATE((MID($C3534,2,1)),(LEFT($C3534,1))))*1)>11,SUM(((CONCATENATE((MID($C3534,2,1)),(LEFT($C3534,1))))*1)-12),SUM(((CONCATENATE((MID($C3534,2,1)),(LEFT($C3534,1))))*1)-12+100))

                    CB-12 - =IF(((CONCATENATE((RIGHT($C3534,1)),(MID($C3534,2,1))))*1)>11,SUM((CONCATENATE((RIGHT($C3534,1)),(MID($C3534,2,1))))*1)-12,SUM(((CONCATENATE((RIGHT($C3534,1)),(MID($C3534,2,1))))*1)-12+100))

                     

                     

                      Avatar

                      United States
                      Member #36065
                      March 27, 2006
                      229 Posts
                      Offline
                      Posted: April 27, 2006, 2:51 pm - IP Logged

                      How do I enter the foruma into Excel so I can use it??  I can't download the .xls file because I get a server not found error.

                        luckylady's avatar - Lottery-009.jpg
                        GA
                        United States
                        Member #3072
                        December 20, 2003
                        638 Posts
                        Offline
                        Posted: April 27, 2006, 3:09 pm - IP Logged

                        All I did was copy and paste

                          Raven62's avatar - binary
                          New Jersey
                          United States
                          Member #17843
                          June 28, 2005
                          49619 Posts
                          Offline
                          Posted: April 27, 2006, 9:57 pm - IP Logged

                          For those who wasn't already on my mail list, you can email me at sirmetro@yahoo.com and I will send you a copy at my earliest convience.

                          Retxx...The Cash4 column is merely a placeholder so you can back track the system to see if it is predicting anything for you. Use it if you wish, ignore it if you wish, up to you.

                          Note to All: a number such as 121 or 212 may reflect several blanks. I do not have time to fix it at the moment. Problem is, 12-12=0, when you convert 0 to TEXT, it becomes a blank. When this happens, enter 0 in the cell so that the error in the other cells go away.

                          Have all the files been mailed out? If so I didn't receive one.

                            CARBOB's avatar - FL LOTTERY_LOGO.png
                            ORLANDO, FLORIDA
                            United States
                            Member #4924
                            June 3, 2004
                            5893 Posts
                            Offline
                            Posted: April 28, 2006, 7:36 am - IP Logged

                            Instead of using Excel, goto link below and download the same tool.

                            Look for paurths home page also.

                             

                            http://www.lotterypost.com/thread/132487