Welcome Guest
Log In | Register )
You last visited January 17, 2017, 7:50 am
All times shown are
Eastern Time (GMT-5:00)

GC FL330 Page 7/Worksheet

Topic closed. 21 replies. Last post 5 years ago by Teamprofit.

Page 2 of 2
44
PrintE-mailLink
Avatar
Central, Florida
United States
Member #4202
March 30, 2004
38 Posts
Offline
Posted: November 22, 2011, 8:48 pm - IP Logged

Coversion chart after 10 draws

 

 

R3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

R4

 

#

G

 

#

G

 

 

 

 

 

 

 

 

 

 

 

LT

 

LR

 

#

R5

 

0

 

 

8

4

 

 

 

 

 

 

 

 

 

 

 

3

 

1

 

0

R6

 

1

 

 

2

2

 

 

 

 

 

 

 

 

 

 

 

2

 

1

 

1

R7

 

2

 

 

6

6

8

 

 

 

 

 

 

 

 

 

 

3

 

 

 

2

R8

 

3

 

 

9

8

 

 

 

 

 

 

 

 

 

 

 

1

 

 

 

3

R9

 

4

 

 

9

1

 

 

 

 

 

 

 

 

 

 

 

4

 

 

 

4

R10

 

5

 

 

0

8

9

 

 

 

 

 

 

 

 

 

 

3

 

 

 

5

R11

 

6

 

 

0

1

 

 

 

 

 

 

 

 

 

 

 

2

 

 

 

6

R12

 

7

 

 

9

2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

7

R13

 

8

 

 

1

9

10

 

 

 

 

 

 

 

 

 

 

5

 

 

 

8

R14

 

9

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

7

 

1

 

9

R15

 

8

2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

30

 

 

 

 

R16

 

1

9

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

R17

 

9

3

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

R18

 

9

1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

LT

 

LR

 

G

R19

 

5

6

 

 

 

 

 

 

 

 

 

 

 

 

 

 

5

 

1

 

1

R20

 

2

9

2

 

 

 

 

 

 

 

 

 

 

 

 

 

4

 

1

 

2

R21

 

9

3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3

 

 

 

3

R22

 

8

5

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2

 

 

 

4

R23

 

8

1

3

 

 

 

 

 

 

 

 

 

 

 

 

 

2

 

 

 

5

R24

 

9

2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3

 

 

 

6

R25

 

4

8

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1

 

 

 

7

R26

 

4

1

4

 

 

 

 

 

 

 

 

 

 

 

 

 

4

 

 

 

8

R27

 

5

5

 

 

 

 

 

 

 

 

 

 

 

 

 

 

4

 

1

 

9

R28

 

0

0

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2

 

 

 

0

R29

 

4

3

5

 

 

 

 

 

 

 

 

 

 

 

 

 

30

 

 

 

 

R30

 

6

9

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

R31

 

3

0

 

 

 

 

 

 

 

 

 

 

 

 

 

 

LT

 

CR

 

DBLS

R32

 

8

7

6

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

0

R33

 

4

4

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1

R34

 

5

6

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2

R35

 

2

8

7

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1

 

 

 

4

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

5

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

6

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

7

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1

 

 

 

8

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1

 

 

 

9

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3

 

 

 

 

    Avatar
    Central, Florida
    United States
    Member #4202
    March 30, 2004
    38 Posts
    Offline
    Posted: November 22, 2011, 8:56 pm - IP Logged

    Tracking Numbers & Gaps first ten draws. I made a few mistakes on this. Hope I corrected everything.

    R1C1C2C3C4C5C6C7C8C9C10C11C12C13C14C15C16C17C18C19C20C21C22C23C24C25C26C27C28C29C30C31C32
    R2L#   TRACKINGG#
    R3Draws819952988944504638452826990091
    R4012345678910111213#123456789101112##12
    R511#123456789101112131415161718192021222324252627#
    R6212345#1234567891011121314#1#1234567
    R7312445678910111213141516#12345678910111213
    R8412345678910##12#123#1234567891011
    R951234#1234567#123456#12345678910
    R106123456789101112131415#1234567#123456
    R117123456789101112131415161718192021222324252627282930
    R128#234567##12345678#123#12345678
    R13912##12#12#1234567891011121314##12#1
    R14S
    R15
    R16Gap293169351281503907468426818129
    R171123#1234#12#12345678910111213#1#12
    R182#12345678#123456789101112#12345#1
    R19312#123#1234567#123456789101112131415
    R204123456789101112131415161718#12#12345678
    R2151234567#1234#1234567891011121314151617
    R2261234#1234567891011121314#123#123456
    R2371234567891011121314151617#123456789101112
    R24811245678910#121314151617181920#123#1#123
    R2591#123#123456789#12345678910111213#
    R26012345678910111213#12#12345678910111213
    R27S
    R28
    R29
    R3012345678910
      Avatar
      Central, Florida
      United States
      Member #4202
      March 30, 2004
      38 Posts
      Offline
      Posted: November 22, 2011, 9:28 pm - IP Logged

      Tracking PI

      Columns just won't line up properly

       

      R1C1

      C2

      C3

      C4

      C5

      C6

      C7

      C8

      C9

      C10

      C11

      C12

      C13

      C14

      C15

      R2

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      R3

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      R4

      F!

       

      1

       

       

       

       

      2

      1

      1

       

       

       

      5

      R5

      F2

      2

       

       

       

       

      1

      1

       

       

       

       

       

      4

      R6

      F3

       

      1

      1

      1

      1

       

       

       

       

      1

       

       

      5

      R7

      F4

       

       

       

       

       

      1

       

       

       

       

       

       

      1

      R8

      F5

       

       

       

      1

      1

       

       

       

       

       

       

       

      2

      R9

      L1

       

       

      1

       

       

       

       

       

       

       

       

      1

      R10

      L2

       

      1

      1

       

      1

       

       

      1

      1

      1

       

       

      6

      R11

      L3

      1

       

       

      1

       

      1

       

      1

       

       

       

       

      4

      R12

      L4

       

       

       

       

       

       

       

       

      1

      1

       

       

      2

      R13

      L5

       

       

       

       

       

       

       

       

       

       

       

       

      0

      R14

      S

       

       

       

       

       

       

       

       

       

       

       

       

      30

      R15

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      R16

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      R17

      1A

       

       

      1

       

       

      1

       

      1

      1

       

       

      4

      R18

      2A

      1

       

       

       

      1

       

      1

      1

       

       

      4

      R19

      3A

       

       

      1

      1

      1

       

       

      2

       

       

       

       

      5

      R20

      4B

      1

       

       

       

      1

       

       

       

       

       

       

       

      2

      R21

      5B

       

       

      1

       

      1

      1

       

       

       

       

       

       

      3

      R22

      6B

       

       

       

       

       

       

       

       

       

       

       

       

      0

      R23

      7C

       

      1

       

      1

       

       

       

      1

       

       

       

       

      3

      R24

      8C

       

       

       

       

       

      1

      1

       

       

      1

       

       

      3

      R25

      9C

      1

       

       

      1

       

       

       

       

       

       

       

       

      2

      R26

      0R

       

      2

       

       

       

      1

       

       

      1

       

       

       

      4

      R27

      S

       

       

       

       

       

       

       

       

       

       

       

       

      30

      R28

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      R29

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      R30

       

      1

      2

      3

      4

      5

      6

      7

      8

      9

      10

       

       

       

        Avatar
        FL
        United States
        Member #93841
        July 8, 2010
        576 Posts
        Offline
        Posted: November 22, 2011, 11:57 pm - IP Logged

        Tracking Numbers & Gaps first ten draws. I made a few mistakes on this. Hope I corrected everything.

        R1C1C2C3C4C5C6C7C8C9C10C11C12C13C14C15C16C17C18C19C20C21C22C23C24C25C26C27C28C29C30C31C32
        R2L#   TRACKINGG#
        R3Draws819952988944504638452826990091
        R4012345678910111213#123456789101112##12
        R511#123456789101112131415161718192021222324252627#
        R6212345#1234567891011121314#1#1234567
        R7312445678910111213141516#12345678910111213
        R8412345678910##12#123#1234567891011
        R951234#1234567#123456#12345678910
        R106123456789101112131415#1234567#123456
        R117123456789101112131415161718192021222324252627282930
        R128#234567##12345678#123#12345678
        R13912##12#12#1234567891011121314##12#1
        R14S
        R15
        R16Gap293169351281503907468426818129
        R171123#1234#12#12345678910111213#1#12
        R182#12345678#123456789101112#12345#1
        R19312#123#1234567#123456789101112131415
        R204123456789101112131415161718#12#12345678
        R2151234567#1234#1234567891011121314151617
        R2261234#1234567891011121314#123#123456
        R2371234567891011121314151617#123456789101112
        R24811245678910#121314151617181920#123#1#123
        R2591#123#123456789#12345678910111213#
        R26012345678910111213#12#12345678910111213
        R27S
        R28
        R29
        R3012345678910

        I changed the way my  tracking pages looks to make it easier to follow, and i automated this page.  Well I have to update the numbers and make certain changes but it highlights the numbers that came out for me.

        Here is an image so you can see the change....

        Lottery and Gap tracking

         

        PI and AI Tracking

        "It's evolve or die, really, you have to evolve, you have to move on otherwise it just becomes stagnant."

          lakerben's avatar - Lottery-061.jpg
          New Mexico
          United States
          Member #86099
          January 29, 2010
          11158 Posts
          Offline
          Posted: November 23, 2011, 1:41 pm - IP Logged

          I changed the way my  tracking pages looks to make it easier to follow, and i automated this page.  Well I have to update the numbers and make certain changes but it highlights the numbers that came out for me.

          Here is an image so you can see the change....

          Lottery and Gap tracking

           

          PI and AI Tracking

          Nice work can't wait for the download.

            Avatar
            Central, Florida
            United States
            Member #4202
            March 30, 2004
            38 Posts
            Offline
            Posted: November 23, 2011, 3:42 pm - IP Logged

            Teamprofit,

             

            I like it, I like it,

            I am not an excel expert. I can use it for the basic stuff and that's it. Glad your providing some great talent.

            One thing, I've learned with using previous draws in any system.

            Save your work. I save my charts to a file after every draw: Draw 1, Draw 2, etc, etc.

            If you have to make a correction, It's a lot easier.

             

            Scrooge

              Avatar
              FL
              United States
              Member #93841
              July 8, 2010
              576 Posts
              Offline
              Posted: November 23, 2011, 5:22 pm - IP Logged

              Teamprofit,

               

              I like it, I like it,

              I am not an excel expert. I can use it for the basic stuff and that's it. Glad your providing some great talent.

              One thing, I've learned with using previous draws in any system.

              Save your work. I save my charts to a file after every draw: Draw 1, Draw 2, etc, etc.

              If you have to make a correction, It's a lot easier.

               

              Scrooge

              I doubt i have any errors with the data because i automated the counting process, I just have to change things around to make it give me what I'm looking for.  Still need some more work before I can show some of the automated work on the spreadsheet.  I did automate some minor things though.........

              I updated the spreadsheet up to yesterdays draw for FL(Nov 1 - Nov 22)...

              • The totals on page 2 are currently automated and it should stay that way until that column is done.
              • The active cells are shown on page 3
              • Page 4 & 5 are also updated until Nov 22, the page is automated so just enter the information and then drag the formula down to update.

              I still don't have everything together so I can't automate the whole thing...I still need some more details.

              bobby sent me a copy of his sheets, once i get it I will look it over and hopefully it will answer some more questions that i don't seem to understand.

              But this is what I have now, I didn't put the books because i'm still working on it...

              Here is the new link https://docs.google.com/spreadsheet/ccc?key=0AuSMTjqZcwpjdHhXMDhWWllFMTBweER4bUVUSU1ENlE

              "It's evolve or die, really, you have to evolve, you have to move on otherwise it just becomes stagnant."