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

another excel question

Topic closed. 23 replies. Last post 1 year ago by lakerben.

Page 1 of 2
PrintE-mailLink
lakerben's avatar - spherewall
New Mexico
United States
Member #86099
January 29, 2010
11119 Posts
Offline
Posted: June 22, 2015, 10:38 pm - IP Logged

I want to use the last 12 to 15 draws to highlight the corresponding pair(s) on the 55 pair chart.  This is a short term 12 to 15 draws and the pairs that don't hit stand out.  Is there a way to enter a draw and the corresponding pair light up and stays colored on the chart??

 

example:

 

 

042

693

941

467

003

114

567

919

110

219

341

661

340

005

                           

 

 

 

 

 

00  01  02  03 04 05 06  07  08 09 

11  12  13  14 15  16  17  18  19

22  23 24  25  26  27 28 29

33 34 35 36 37 38 39

44 45 46 47 48 49

55 56 57 58 59

66 67 68 69

77 78 79

88 89

99

How about them cowboys!

 

 

US Flag

    SergeM's avatar - slow icon.png
    Economy class
    Belgium
    Member #123700
    February 27, 2012
    4035 Posts
    Offline
    Posted: June 23, 2015, 9:19 am - IP Logged

    Why  03 ?

      lakerben's avatar - spherewall
      New Mexico
      United States
      Member #86099
      January 29, 2010
      11119 Posts
      Offline
      Posted: June 23, 2015, 11:16 am - IP Logged

      Why  03 ?

      Typo.

      How about them cowboys!

       

       

      US Flag

        SergeM's avatar - slow icon.png
        Economy class
        Belgium
        Member #123700
        February 27, 2012
        4035 Posts
        Offline
        Posted: June 24, 2015, 12:06 pm - IP Logged

        Boxed pair was drawn

         

        00010203040506070809
          111213141516171819
            2223242526272829
              33343536373839
                444546474849
                  5556575859
                    66676869
                      777879
                        8889
                          99

         

         See pick 3 USA-CA ... .
          This was asked several times before.
          You guys are repeating your requests.

          lakerben's avatar - spherewall
          New Mexico
          United States
          Member #86099
          January 29, 2010
          11119 Posts
          Offline
          Posted: June 24, 2015, 1:26 pm - IP Logged

          Boxed pair was drawn

           

          00010203040506070809
            111213141516171819
              2223242526272829
                33343536373839
                  444546474849
                    5556575859
                      66676869
                        777879
                          8889
                            99

           

           See pick 3 USA-CA ... .
            This was asked several times before.
            You guys are repeating your requests.

          Repeating ourselves? You are assuming that I read every single thread in the site? 

          I don't recall asking about this before and I have not seen  another member request for this particular idea with the 55 pair chart.  Feel free to help but the remark doesn't help me solve this issue.

           

          US Flag

          How about them cowboys!

           

           

          US Flag

            SergeM's avatar - slow icon.png
            Economy class
            Belgium
            Member #123700
            February 27, 2012
            4035 Posts
            Offline
            Posted: June 24, 2015, 3:14 pm - IP Logged

            I have a memory for this. Maybe several people came up with the same ideas.

            Why don't you try to break the problem into small pieces and put them together to solve the problem?

              Avatar

              United States
              Member #41846
              June 23, 2006
              459 Posts
              Offline
              Posted: June 25, 2015, 3:33 pm - IP Logged

              Lakerben  check out this link. is this what you are looking for.   pick4 portion is not finished

               

              https://www.dropbox.com/s/4spbxm271cozsif/laker_ben.xls?dl=0

                lakerben's avatar - spherewall
                New Mexico
                United States
                Member #86099
                January 29, 2010
                11119 Posts
                Offline
                Posted: June 26, 2015, 10:10 am - IP Logged

                Lakerben  check out this link. is this what you are looking for.   pick4 portion is not finished

                 

                https://www.dropbox.com/s/4spbxm271cozsif/laker_ben.xls?dl=0

                Thanks I'll check it out!

                 

                 

                Thumbs Up

                How about them cowboys!

                 

                 

                US Flag

                  lakerben's avatar - spherewall
                  New Mexico
                  United States
                  Member #86099
                  January 29, 2010
                  11119 Posts
                  Offline
                  Posted: June 26, 2015, 11:06 am - IP Logged

                  Lakerben  check out this link. is this what you are looking for.   pick4 portion is not finished

                   

                  https://www.dropbox.com/s/4spbxm271cozsif/laker_ben.xls?dl=0

                  I entered data from NM draws nd there is no change on the 55 pair chart.  I saved it to the desktop .

                  How about them cowboys!

                   

                   

                  US Flag

                    Avatar

                    United States
                    Member #41846
                    June 23, 2006
                    459 Posts
                    Offline
                    Posted: June 26, 2015, 11:20 am - IP Logged

                    Did you replace the draw info on the data sheet?

                    this uses a macro so you have to click the button to start the process. it reads the info from the data sheet based on what game you select in row 2 column 1-4

                      lakerben's avatar - spherewall
                      New Mexico
                      United States
                      Member #86099
                      January 29, 2010
                      11119 Posts
                      Offline
                      Posted: June 26, 2015, 11:37 am - IP Logged

                      Did you replace the draw info on the data sheet?

                      this uses a macro so you have to click the button to start the process. it reads the info from the data sheet based on what game you select in row 2 column 1-4

                      I hit the button and the game is at "1".  I typed over the data from the sheet and saved.

                      How about them cowboys!

                       

                       

                      US Flag

                        Avatar

                        United States
                        Member #41846
                        June 23, 2006
                        459 Posts
                        Offline
                        Posted: June 26, 2015, 1:44 pm - IP Logged

                        my apology. i use this type program everyday and tend to forget that someone else would not understand how to use it without explanation.

                        i have added some notes that should help.  see link below.  again the pick 4 selections would only show pair data only for the first three digits.

                         

                        https://www.dropbox.com/s/4spbxm271cozsif/laker_ben.xls?dl=0

                          lakerben's avatar - spherewall
                          New Mexico
                          United States
                          Member #86099
                          January 29, 2010
                          11119 Posts
                          Offline
                          Posted: June 26, 2015, 2:34 pm - IP Logged

                          my apology. i use this type program everyday and tend to forget that someone else would not understand how to use it without explanation.

                          i have added some notes that should help.  see link below.  again the pick 4 selections would only show pair data only for the first three digits.

                           

                          https://www.dropbox.com/s/4spbxm271cozsif/laker_ben.xls?dl=0

                          Thanks for your work!  Is there a way to have an input data foe both p3 games?

                          I'll try it again!

                          How about them cowboys!

                           

                           

                          US Flag

                            Avatar

                            United States
                            Member #41846
                            June 23, 2006
                            459 Posts
                            Offline
                            Posted: June 26, 2015, 9:31 pm - IP Logged

                            Thanks for your work!  Is there a way to have an input data foe both p3 games?

                            I'll try it again!

                            yes.  there is more work to doing that than it sounds like. not difficult, just tedious.  expecting storms tomorrow. may have some time. give me a day or so

                              lakerben's avatar - spherewall
                              New Mexico
                              United States
                              Member #86099
                              January 29, 2010
                              11119 Posts
                              Offline
                              Posted: June 26, 2015, 9:54 pm - IP Logged

                              yes.  there is more work to doing that than it sounds like. not difficult, just tedious.  expecting storms tomorrow. may have some time. give me a day or so

                              Works great now.  The instructions are good. I hope they are permanent instructions in case I forget. Is the color code on the right changeable?  Is it programmed to show multiple hits?  If not that cool it is what I needed as far as the program!!  Nice job!

                               

                              Lurking

                              How about them cowboys!

                               

                               

                              US Flag