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

HITPROFILES.xls

Topic closed. 6 replies. Last post 4 years ago by MonEl.

Page 1 of 1
PrintE-mailLink
MonEl's avatar - 24zd6s0

United States
Member #132100
August 26, 2012
1108 Posts
Offline
Posted: June 19, 2013, 11:59 am - IP Logged

HITPROFILES.xls

I don't remember who made that one.

On it I found "ovr VLH" and also "ovr VEO"

I am not sure, but I think that they might mean:

VTrac Low-High and VTrac Even-Odd

But it looks as if I am wrong on that, it must mean something else, because I looked at those stats and it has to be something else.

I don't know who made that, this is the first time that I look at it.

Maybe people should put their names or some I.D info on their spreadsheets just in case people have questions about them later.

Sorry, since I don't know who made that spreadsheet and for who or why (I downloaded it from somewhere long ago) I will not be posting it for download.

    MonEl's avatar - 24zd6s0

    United States
    Member #132100
    August 26, 2012
    1108 Posts
    Offline
    Posted: June 19, 2013, 12:06 pm - IP Logged

    I still have not tried to learn about excel so I really can't use that spreadsheet as I can't update the drawings on it yet, well I did see a very slow way of doing it, I guess that I could still use it that way, updating it one digit at a time.

      MonEl's avatar - 24zd6s0

      United States
      Member #132100
      August 26, 2012
      1108 Posts
      Offline
      Posted: June 19, 2013, 1:06 pm - IP Logged

      It looks as if only 21 horizontal lines have formulas on them and they are the only ones that give stats.

      Even without knowing anything about Excel, I am learning, I tried copy and paste and now I was able to put the formulas on other horizontal lines, so more past draws can be added to it.

      -----------

      I now extended the horizontal lines to about 103 so I can put on it up 103 past pick 3 draws, not bbad for somebody who doesn't know anythinjg aabout Excel.

      That is 103 horizontal lines have all the formulas in them for all the stats of the past history of pick 3 numbers.

      There is no limit, I could add as many as I wanted to if I wanted, but from 30 up to 100 would be more than enough.

        MonEl's avatar - 24zd6s0

        United States
        Member #132100
        August 26, 2012
        1108 Posts
        Offline
        Posted: June 19, 2013, 1:39 pm - IP Logged

        This is just a short sample not the whole spreasheet as it can't show right here, I tried.

        04/29/1988806APR 29APR291988FRI3EE.E.EL.2HH.L.H4512.15abc312412514HELEHE
        04/30/1988804APR 30APR301988SAT3EE.E.E2L.HH.L.L2312.15abc312415513HELELE
        05/01/1988880MAY 1MAY11988SUN3EE.E.EL.2HH.H.L6716.18aab221441551HEHELE
        05/02/1988715MAY 2MAY21988MON3OO.O.OL.2HH.L.H3412.15abc312321413HOLOHO
        05/03/1988841MAY 3MAY31988TUE2E.OE.E.O2L.HH.L.L3412.15abc321452531HELELO
        05/04/1988607MAY 4MAY41988WED2E.OE.E.OL.2HH.L.H3412.15abc213213414HELEHO
        05/05/1988614MAY 5MAY51988THU2E.OE.O.E2L.HH.L.L1209.11abc312225413HELOLE
        05/06/1988924MAY 6MAY61988FRI2E.OO.E.E2L.HH.L.L5612.15abc312535523HOLELE
        05/07/1988774MAY 7MAY71988SATE.2OO.O.EL.2HH.H.L8916.18aab221335443HOHOLE
        05/08/1988432MAY 8MAY81988SUN2E.OE.O.E3LL.L.L9909.11abc321543322LELOLE
        05/09/1988297MAY 9MAY91988MONE.2OE.O.OL.2HL.H.H8916.18abc132353254LEHOHO
        05/10/1988178MAY 10MAY101988TUEE.2OO.O.EL.2HL.H.H6716.18abc123234145LOHOHE
        05/11/1988071MAY 11MAY111988WEDE.2OE.O.O2L.HL.H.L8805.08abc132132141LEHOLO
        05/12/1988650MAY 12MAY121988THU2E.OE.O.EL.2HH.H.L1209.11abc321211431HEHOLE
        05/13/1988983MAY 13MAY131988FRIE.2OO.E.OL.2HH.H.L0223.27abc321544552HOHELO
        05/14/1988628MAY 14MAY141988SAT3EE.E.EL.2HH.L.H6716.18abc213234425HELEHE
        05/15/1988981MAY 15MAY151988SUNE.2OO.E.OL.2HH.H.L8916.18abc321542551HOHELO
        05/16/1988169MAY 16MAY161988MONE.2OO.E.OL.2HL.H.H6716.18abc123225145LOHEHO
        05/17/1988646MAY 17MAY171988TUE3EE.E.EL.2HH.L.H6716.18aba212252434HELEHE
        05/18/1988678MAY 18MAY181988WED2E.OE.O.E3HH.H.H1323.27abc123234445HEHOHE
        05/19/1988780MAY 19MAY191988THU2E.OO.E.EL.2HH.H.L5612.15abc231341451HOHELE
          MonEl's avatar - 24zd6s0

          United States
          Member #132100
          August 26, 2012
          1108 Posts
          Offline
          Posted: June 19, 2013, 1:41 pm - IP Logged

          Even that short sample still doesn't show up right here on LP, it comes out very bad.

          But on Excel it is really nice.

            MonEl's avatar - 24zd6s0

            United States
            Member #132100
            August 26, 2012
            1108 Posts
            Offline
            Posted: June 19, 2013, 2:01 pm - IP Logged

            What that spreadsheet doesn't have, is how many draws it has been since each of the patterns of the filters came out the last time and the averages of each of the patterns and what it overdue and for how long.

            It it doesn't have the skips either, I guess.

            And it doesn't have stats for the In-Out and the Bala-Nced filters and also not for the Lowest to Highest Width filter.

            Otherwise it is a GREAT spreadsheet, it has more, but I could not show that here on LP as it doesn't show O.K.

            When pasted here.

            If it had the extra stuff that I just said about here , it would then have just about everything other than the VTracs and their many stats.

              MonEl's avatar - 24zd6s0

              United States
              Member #132100
              August 26, 2012
              1108 Posts
              Offline
              Posted: June 19, 2013, 2:34 pm - IP Logged

              Ragwi and a few other made some incredible spreadsheets, but mostly Rahwi this is from one of them:

              It is just a very small portion of the very big and very complicated spreadsheet, I think that Ragwi is or was almost in a class all by itself with the making of lottery spreadsheets, maybe only Winsum and a few others could make such things, but maybe Ragwi is or was the TOP on spreadsheets.

              Take into account that these things don't show up right here on LP.

              Overall Position
              0123456789
                        
                        
                        
                        
                        
                        
                        
                        
                   x   x
               x x    x 
                 xx  x  
                 xx    x
               x x  x   
                  xx  x 
              x x       
              x x   x   
                 x x   x
                      xx
                xx     x
              xx     x  
                x  x   x
                    x x 
                  x    x
              xx        
                x  x  x 
               x   x    
                x      x
                 xx     
                    x xx
                xx    x 
               xx     x 
                 x xx   
               x  x    x
               xx     x 
              xx    x   
                   xx x 
              xxx       
                  xx    
              x     xx  
                x  x   x
                xxx     
                x   xx  
                xx    x 
                  x xx  
              xx        
                  x x   
                x      x
                 xx     
               x  xx    
                 xx   x 
                  x x   
                 x  xx  
                  xx  x 
                xx  x   
                  xx x  
              x x       
                   xx x 
               x  xx    
                   x   x
               x    x  x
              x      x x
                x      x