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

GS FL330 - Page 6A

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

Page 2 of 2
44
PrintE-mailLink
Avatar
FL
United States
Member #93841
July 8, 2010
576 Posts
Offline
Posted: November 18, 2011, 5:06 pm - IP Logged

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

You have to download the page to have access to editing.

I've only updated the Gap numbers up until the current draw Fri, Nov 18, 2011    5-7-7

I'm not sure how to update...

LT

LR

CT

DBL

 

bobby623 please look at the page and tell me if it looks correct so far......

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

    bobby623's avatar - abstract
    San Angelo, Texas
    United States
    Member #1097
    January 31, 2003
    1394 Posts
    Offline
    Posted: November 18, 2011, 6:45 pm - IP Logged

    I'll be checking the Google link later. Don't really have time right now to do a thorough analysis.

    Values for LT, LR are entered when a D&C page is filled.

    The CR Current Round totals are entered in the LR Last Round cells.

    The LT Long Term cells will be empty until the second page is complete. At that time, the Current and Last
    Round totals are added. This shows how many times each Lottery and Gap numbers have come up
    since Nov. 1.

    The DBL cell totals are placed in the LR cells when the page is complete.

    The Doubles sequence, less repeats, are transferred to the second page, etc.

      Avatar
      Central, Florida
      United States
      Member #4202
      March 30, 2004
      38 Posts
      Offline
      Posted: November 19, 2011, 1:27 pm - IP Logged

      I'm jumping in to this group too.

      I thought, I would be able to paste in a copy of my worksheet, but I can't.

      Can anybody tell me how to do it ?

      I'm only a once in a while visitor.

      Scrooge

        bobby623's avatar - abstract
        San Angelo, Texas
        United States
        Member #1097
        January 31, 2003
        1394 Posts
        Offline
        Posted: November 19, 2011, 2:42 pm - IP Logged

        WOW!!

        Good Job!

        Impressive!

        How does it work?

        I just type in a number and the program does the work, and updates the files??

        Sure wish I had your programming skills.

        But, alas, too late in life to learn.

        Thanks

        I'm sure the LP crowd will be jumping on!

          Avatar
          Central, Florida
          United States
          Member #4202
          March 30, 2004
          38 Posts
          Offline
          Posted: November 19, 2011, 7:45 pm - IP Logged

          I tried to upload a picture of my chart, but no luck, so I'm doing it the hard way.

          Starting on the left side, red numbers are the start of the chart. Numbers under red are the drawn numbers from Nov. 1 to Nov. 17 mid-day.

          Numbers along side are the gap numbers. On the right hand side numbers under LR are the totals fot each digit's appearance.

          Second section is for gap totals.

          The last group on the bottom show the number of appearances for doubles drawn. I checked my figures twice for accuracy, so this should all be correct. Any mistakes, Let me know

          I'm trying to help out in this project.

          Scrooge

           

          # G          # G        # G        # G                                          LT          LR          #            

          0              8   4        1 9          4 1                                                        10            0

          1             2   2       1 1          3 0                                                        13            1

          2              6   6        2 7          7 3                                                          13            2

          3              9   8        0 7          2 4                                                          8            3

          4             9   1        1 3          5 9                                                        16            4

          5             0   8        4 8         6 0                                                          7            5

          6              0   1        1 2          1 8                                                          7            6

                       9   2        6 7          2 4                                                          7            7

          8             1   9        4 3          7 5                                                        12            8

          9              3   9        6 2          4 7                                                        12            9

          8 2          4   9        8 8          2 3

          1 9          3   2        2 6          1 4

          9 3           3   1        1 5          4 3                                          LT          LR          G           

          9 1          0   5        1 1          3 7                                                        13            1

          5 6            4   3        4 5          1 3                                                        10            2

          2 9           8   8        8 4          4 3                                                        14            3

          9 3          9   6        8 1          9 9                                                        10            4

          8 5           1   6        5 0          3 4                                                          8            5

          8 1           4   4        5 1          2 5                                                          9            6

          9 2          3   6        8 2          5 8                                                        10            7

          4  8          4   2        0 7         7 7                                                        11            8

          4 1           7   0        2 6          7 1                                                        14            9

          5 5           0   7        0 2                                                                        6            0

          0 0          6   8        8 3

          4 3           2   9        2 3                                                          LT          CR          DBLS

          6 9          0   3        9 9                                                                             1          0

          3 0           8   9        1 7                                                                             2          1                             

          8 7           6   4        0 5                                                                                          2

          4 4           9   9        2 4                                                                             1          3

          5 6           9   1        7 9                                                                             2          4

          2 8           7   6        4 8                                                                             1          5

                                                                                                                                        6

                                                                                                                          1          7

                                                                                                                           2          8

                                                                                                                                              9

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

            WOW!!

            Good Job!

            Impressive!

            How does it work?

            I just type in a number and the program does the work, and updates the files??

            Sure wish I had your programming skills.

            But, alas, too late in life to learn.

            Thanks

            I'm sure the LP crowd will be jumping on!

            I'm not sure who your post was referring to..but if it's my sheet it's not automated yet.  I did all the work manually, once i figure everything out I will then attempt to automate.

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

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

              I think, I may have finally figured it out.

              Here is my chart for the last nine days endind Nov 17 mid-day.

              This is for tracking number and gap.

              Anybody wants the whole chart from day 1, i'll upload it

               

              Scrooge         

              0171819202122232425
              12#1234567
              234567#123
              3#123#1234
              412#123456
              591011121314#12
              68910111213141516
              7567891011##
              8212223242526272829
              9192021#1234

              5

               

              01314151617181920#
              1222324252627282930
              21##123456
              32345#1234
              456789#123
              5232425262728293131
              6#123456#1
              7789101112#12
              891011#12345
              98910111213141516
                paradisenow's avatar - 6769831
                nassau
                Bahamas
                Member #103452
                January 2, 2011
                4347 Posts
                Offline
                Posted: November 19, 2011, 8:42 pm - IP Logged

                I think, I may have finally figured it out.

                Here is my chart for the last nine days endind Nov 17 mid-day.

                This is for tracking number and gap.

                Anybody wants the whole chart from day 1, i'll upload it

                 

                Scrooge         

                0171819202122232425
                12#1234567
                234567#123
                3#123#1234
                412#123456
                591011121314#12
                68910111213141516
                7567891011##
                8212223242526272829
                9192021#1234

                5

                 

                01314151617181920#
                1222324252627282930
                21##123456
                32345#1234
                456789#123
                5232425262728293131
                6#123456#1
                7789101112#12
                891011#12345
                98910111213141516

                please upload thanks

                  Avatar
                  Central, Florida
                  United States
                  Member #4202
                  March 30, 2004
                  38 Posts
                  Offline
                  Posted: November 19, 2011, 9:47 pm - IP Logged

                  Full Chart. Use bottom slider to view to the right

                   

                  Scrooge

                   

                  R1C1C2C3C4C5C6C7C8C9C10C11C12C13C14C15C16C17C18C19C20C21C22C23C24C25C26C27C28C29C30C31C32C33C34C35C36C37C38C39C40C41C42C43C44C45C46C47C48C49C50C51C52C53C54C55C56C57C58C59C60C61C62C63C64C65C66C67C68C69C70C71C72C73C74C75C76C77C78C79C80C81C82C83C84C85C86C87C88C89C90C91C92C93C94C95C96C97C98C99C100C101C102C103C104C105C106C107
                  R2   x
                  R3
                  R4012345678910111213#123456789101112##123456#12345678#12#12345678#12345678910111213141516#1#1234#12345678910111213141516171819202122232425
                  R511#123456789101112131415161718192021222324252627#12345678#12345678910111213##12#1#12345##123456789101112#12345678910#1234#12#1234567
                  R6212345#1234567891011121314#1#12345678910111213141516171819202122#12345678#12345678#123456789#12#123#12345#123#12#1234567#123
                  R7312345678910111213141516#12345678910111213#1##123456#12345678910111213141516171819202122232425262728293031323334353637383940414243#1234567891011#123#1234
                  R8412345678910##12#123#123456789101112#123#123#1#123456789101112131415#12#12345#123456789101112131415##12345678#12#12#123456
                  R951234#1234567#123456#12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849##12345678910111213141516#1234567891011121314#12
                  R106123456789101112131415#1234567#1234567891011121314151617181920#123#12345678910#1#1234567891011121314151617181920212223242526#12345678910111213141516
                  R117123456789101112131415161718192021222324252627282930313233343536373839404142#12345612#1234567891011121314151617181920212223242526272829#123#12345#1234567891011##
                  R128#123456##12345678#123#1234567891011121314#12345678910#12345678910111213141516171819##12#123#1234567891011121314151617181920212223242526272829
                  R13912##12#12#1234567891011121314##12#12345678#1234567891011##1234567891011121314151617181920212223242526#123456789101112131415161718192021#12345
                  R14S
                  R15                                                                                                          
                  R16
                  R171123#1234#12#12345678910111213#1#12345#12345678910111213141516#12#1234567891011#12#1#123456789101112#1234567891011121314151617181920#
                  R182#12345678#123456789101112#12345#123#12345678#12345678910111213141516#12#123456789#12#123456789101112131415161718192021222324252627282930
                  R19312#123#1234567#1234567891011121314151617181920#12345678910#123456789#123#12#1234567891011##12345678#1234567#1#1##123456
                  R204123456789101112131415161718#12#1234567891011121314151617#12345678#123456789101112131415161718#123456789101112#12345#123#123#12345#1234
                  R2151234567#1234#123456789101112131415161718192021#1234567891011121314151617181920212223242526272829#1#123456789101112#1234567891011#123456789#123
                  R2261234#1234567891011121314#1234567891011121314151617##1#12345678910#1234567891011#123456789#12345678910111213141516171819202122232425262728293132
                  R2371234567891011121314151617#12345#12345678910111213141516171819#12345678910##123#123456789101112#12345#12345678910111213#123#123456#1
                  R24812345678910#123456789#123#1#1234567891011121314151617#123456789101112#1234#12345678910111213141516171819#123456#123456789101112#12
                  R2591#123#123456789#12345678910111213###12345678910111213#1#1#12#123456789101112131415161718192021222324#123#12345#1234567891011#12345
                  R26012345678910111213#12#123456781234567891011121314151617#1234567891011121314161718192021222324252627#1234567891011121314#123#12345678910111213141516
                    bobby623's avatar - abstract
                    San Angelo, Texas
                    United States
                    Member #1097
                    January 31, 2003
                    1394 Posts
                    Offline
                    Posted: November 19, 2011, 10:34 pm - IP Logged

                    Good Job!

                    I found one typo in my Gap combination list

                    Lottery Combination 091 = Gap combination 129

                    I had 139

                    Your inventory totals are correct.

                    I'll update mine

                    ADD

                    Row 32 C25-26

                    Enter SEQ (sequence)

                    R31-40 Enter in C25

                    8

                    4

                    9

                    3

                    4

                    9

                    1

                    1

                    8

                    5

                    R31-33 C26

                    0

                    4

                    7

                     

                    Glad you have joined.

                    The more folks involved will provide a more accurate product.

                      bobby623's avatar - abstract
                      San Angelo, Texas
                      United States
                      Member #1097
                      January 31, 2003
                      1394 Posts
                      Offline
                      Posted: November 19, 2011, 10:49 pm - IP Logged

                      I'm not sure who your post was referring to..but if it's my sheet it's not automated yet.  I did all the work manually, once i figure everything out I will then attempt to automate.

                      Mel,

                      Incorrect assumption on my part.

                      I think I need to take a break!!

                      Bobby

                        retxx's avatar - mrthumbs
                        BOSTON
                        United States
                        Member #48
                        September 9, 2001
                        3594 Posts
                        Offline
                        Posted: November 20, 2011, 11:37 am - IP Logged

                        Question; I am trying to follow along and wondering if teamprofits chart i downloaded is an excel spreadsheet and if so where can I replace Fl numbers with my state numbers. by the way very interesting.

                          Avatar
                          FL
                          United States
                          Member #93841
                          July 8, 2010
                          576 Posts
                          Offline
                          Posted: November 20, 2011, 12:13 pm - IP Logged

                          Question; I am trying to follow along and wondering if teamprofits chart i downloaded is an excel spreadsheet and if so where can I replace Fl numbers with my state numbers. by the way very interesting.

                          All the work was done manually....I created a blank version for anyone who wants to start on their own with ther own state

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

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

                            retxx's avatar - mrthumbs
                            BOSTON
                            United States
                            Member #48
                            September 9, 2001
                            3594 Posts
                            Offline
                            Posted: November 20, 2011, 2:43 pm - IP Logged

                            thanks but it would really simplify things with an excel program if someone steps up.

                              Avatar
                              FL
                              United States
                              Member #93841
                              July 8, 2010
                              576 Posts
                              Offline
                              Posted: November 20, 2011, 3:09 pm - IP Logged

                              thanks but it would really simplify things with an excel program if someone steps up.

                              There is no way to make spreadsheet without understanding how the system functions....Believe me I wish it was simpler but for now we have to learn to work with this manually until every step is understood

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