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

Some new results on some old techniques.

Topic closed. 792 replies. Last post 3 years ago by Greenfox.

Page 18 of 53
4.710
PrintE-mailLink
Greenfox's avatar - IMAG01562
Burnsville
United States
Member #107244
March 4, 2011
853 Posts
Offline
Posted: January 3, 2013, 9:48 pm - IP Logged

Excel - Subtraction formula conversion:

=IF(C3<=9,C3,IF(VALUE(RIGHT(TEXT(C3,0),1))=0,

  ...if(right(text(c3,0),1)="0",

Thank you SergeM for any excel help!!!  Like i said, I'll take all the knowledge about it i can.

I'm adding any tips to my list. I don't know what the VALUE, TEXT and all that mean. I haven't tried to use any of them yet. I really got to learn what does what.

You can't steal second and keep your foot on FIRST!!!

“Strength does not come from winning. Your struggles develop your strengths.
When you go through hardships and decide not to surrender, that is strength”.

-Arnold (Ahnald) Schwarzenegger-

    llucas07's avatar - batman14
    Gastonia, NC
    United States
    Member #117368
    October 4, 2011
    1677 Posts
    Offline
    Posted: January 3, 2013, 10:01 pm - IP Logged

    Hi Greenfox, I am here. Shop just called me and told me to get on that you had something to show us.

     

    llucas

    I See Brighter Things AheadSun Smiley

      Greenfox's avatar - IMAG01562
      Burnsville
      United States
      Member #107244
      March 4, 2011
      853 Posts
      Offline
      Posted: January 3, 2013, 10:02 pm - IP Logged

      This is some changes i made to this. First, I put a new sheet at the first of the book. In this sheet, you can either put the draws in by hand here and have it fill the book, or you can link it to the even/odd book and it will do it when you fill in that page. You can use it either way.

      I have updated a copy with the formula that KnuckleHead wrote for us. I had to change the first part of it to show 0 if the cell it was getting info from was 9 or under. I couldn't see the numbers like i was.

      Thirdly, i had noticed in the new part, that where it added the total X together, that if it was a 10 I might should put another set of columns to show those numbers. I don't even know how to explain this. You just gotta see it. So here it is. I love this one, so I'm going to show it first. It's just cool!!!

      You may have to scroll over to see this. But you gotta see this!!!

      This is the December 31, 2012 day draw here in NC. 9-1-7 was the numbers drew.

      You can't steal second and keep your foot on FIRST!!!

      “Strength does not come from winning. Your struggles develop your strengths.
      When you go through hardships and decide not to surrender, that is strength”.

      -Arnold (Ahnald) Schwarzenegger-

        Greenfox's avatar - IMAG01562
        Burnsville
        United States
        Member #107244
        March 4, 2011
        853 Posts
        Offline
        Posted: January 3, 2013, 10:03 pm - IP Logged

        Hi Greenfox, I am here. Shop just called me and told me to get on that you had something to show us.

         

        llucas

        She was right. See what you think about this.....

        You can't steal second and keep your foot on FIRST!!!

        “Strength does not come from winning. Your struggles develop your strengths.
        When you go through hardships and decide not to surrender, that is strength”.

        -Arnold (Ahnald) Schwarzenegger-

          llucas07's avatar - batman14
          Gastonia, NC
          United States
          Member #117368
          October 4, 2011
          1677 Posts
          Offline
          Posted: January 3, 2013, 10:08 pm - IP Logged

          She was right. See what you think about this.....

          So without the 917 being in the date box for the 31st, would we still see the same info in the new boxes you just added?

          I See Brighter Things AheadSun Smiley

            Greenfox's avatar - IMAG01562
            Burnsville
            United States
            Member #107244
            March 4, 2011
            853 Posts
            Offline
            Posted: January 3, 2013, 10:14 pm - IP Logged

            So without the 917 being in the date box for the 31st, would we still see the same info in the new boxes you just added?

            That's what the data brought up with the formulas working. The winning number only comes in after the draws happen and you type it in either on the sheet it's self, the new first sheet i made, or in the even/odd books first page. Making this thing pick for us is way out of my knowledge of Excel usage. This is the info that the two previous draws brought up only. So yes your correct.

            You can't steal second and keep your foot on FIRST!!!

            “Strength does not come from winning. Your struggles develop your strengths.
            When you go through hardships and decide not to surrender, that is strength”.

            -Arnold (Ahnald) Schwarzenegger-

              llucas07's avatar - batman14
              Gastonia, NC
              United States
              Member #117368
              October 4, 2011
              1677 Posts
              Offline
              Posted: January 3, 2013, 10:16 pm - IP Logged

              That's what the data brought up with the formulas working. The winning number only comes in after the draws happen and you type it in either on the sheet it's self, the new first sheet i made, or in the even/odd books first page. Making this thing pick for us is way out of my knowledge of Excel usage. This is the info that the two previous draws brought up only. So yes your correct.

              Have you uploaded the new version so I can down load it?

              I See Brighter Things AheadSun Smiley

                Greenfox's avatar - IMAG01562
                Burnsville
                United States
                Member #107244
                March 4, 2011
                853 Posts
                Offline
                Posted: January 3, 2013, 10:19 pm - IP Logged

                Have you uploaded the new version so I can down load it?

                So you see it? No I haven't got them up yet. I will have them up in a sec and get the links up here.

                You can't steal second and keep your foot on FIRST!!!

                “Strength does not come from winning. Your struggles develop your strengths.
                When you go through hardships and decide not to surrender, that is strength”.

                -Arnold (Ahnald) Schwarzenegger-

                  llucas07's avatar - batman14
                  Gastonia, NC
                  United States
                  Member #117368
                  October 4, 2011
                  1677 Posts
                  Offline
                  Posted: January 3, 2013, 10:25 pm - IP Logged

                  So you see it? No I haven't got them up yet. I will have them up in a sec and get the links up here.

                  Yes I do and I love it, if it is going to do what I think it will. My ultimate goal is to be able find the winning number with no more than 5 numbers to play. I tried last night and I was off, but the winner was there staring me in the face and I still missed it. Today I was a little bit closer but still missed it.

                  I See Brighter Things AheadSun Smiley

                    Greenfox's avatar - IMAG01562
                    Burnsville
                    United States
                    Member #107244
                    March 4, 2011
                    853 Posts
                    Offline
                    Posted: January 3, 2013, 10:47 pm - IP Logged

                    1-2013 Days:

                    http://www.sendspace.com/file/c2j6nb

                     

                    1-2013 Evenings:

                    http://www.sendspace.com/file/zgs0az

                     

                    These have the bugs worked out with the highlighting issues, a new first page with dual linking capabilities. You can either put the numbers in the Draws sheet, or link it to the first sheet of the EVEN/ODD books.

                    Best of luck and enjoy!!!!!!

                    You can't steal second and keep your foot on FIRST!!!

                    “Strength does not come from winning. Your struggles develop your strengths.
                    When you go through hardships and decide not to surrender, that is strength”.

                    -Arnold (Ahnald) Schwarzenegger-

                      llucas07's avatar - batman14
                      Gastonia, NC
                      United States
                      Member #117368
                      October 4, 2011
                      1677 Posts
                      Offline
                      Posted: January 3, 2013, 10:52 pm - IP Logged

                      1-2013 Days:

                      http://www.sendspace.com/file/c2j6nb

                       

                      1-2013 Evenings:

                      http://www.sendspace.com/file/zgs0az

                       

                      These have the bugs worked out with the highlighting issues, a new first page with dual linking capabilities. You can either put the numbers in the Draws sheet, or link it to the first sheet of the EVEN/ODD books.

                      Best of luck and enjoy!!!!!!

                      Thank you, getting ready to test it out now. By the way are these books universal, meaning can we use them for future months or will we need new ones for the up coming months. Just thinking ahead....

                      I See Brighter Things AheadSun Smiley

                        Greenfox's avatar - IMAG01562
                        Burnsville
                        United States
                        Member #107244
                        March 4, 2011
                        853 Posts
                        Offline
                        Posted: January 3, 2013, 10:54 pm - IP Logged

                        The December 30, 2012 day draw for NC.

                        You think the 9 and 6 is connected? On these keep your eyes in the upper corner of this new part.

                        This one was 7-7-6

                         

                        You can't steal second and keep your foot on FIRST!!!

                        “Strength does not come from winning. Your struggles develop your strengths.
                        When you go through hardships and decide not to surrender, that is strength”.

                        -Arnold (Ahnald) Schwarzenegger-

                          llucas07's avatar - batman14
                          Gastonia, NC
                          United States
                          Member #117368
                          October 4, 2011
                          1677 Posts
                          Offline
                          Posted: January 3, 2013, 10:59 pm - IP Logged

                          The December 30, 2012 day draw for NC.

                          You think the 9 and 6 is connected? On these keep your eyes in the upper corner of this new part.

                          This one was 7-7-6

                           

                          Would you say it would have been safe to play both the 776 and the 779?

                          I See Brighter Things AheadSun Smiley

                            Greenfox's avatar - IMAG01562
                            Burnsville
                            United States
                            Member #107244
                            March 4, 2011
                            853 Posts
                            Offline
                            Posted: January 3, 2013, 11:06 pm - IP Logged

                            Would you say it would have been safe to play both the 776 and the 779?

                            Yes, i would have. LOL. Plus look in the root of 8 under the counter 23 and 24, then again in the root of 8 under the 18 and 19.

                            Plus in the root of 5 from under counter 5 to 9 and see what you see.

                            Gonna get a shave and shower and I be back with more.

                            You can't steal second and keep your foot on FIRST!!!

                            “Strength does not come from winning. Your struggles develop your strengths.
                            When you go through hardships and decide not to surrender, that is strength”.

                            -Arnold (Ahnald) Schwarzenegger-

                              Greenfox's avatar - IMAG01562
                              Burnsville
                              United States
                              Member #107244
                              March 4, 2011
                              853 Posts
                              Offline
                              Posted: January 3, 2013, 11:08 pm - IP Logged

                              Thank you, getting ready to test it out now. By the way are these books universal, meaning can we use them for future months or will we need new ones for the up coming months. Just thinking ahead....

                              You can always make copies, but I'm making all months. I have Feb about done. Just got a few more things to do to them. But yeah there will be more. I've even went back and tested the first draws in NC with it. I LIKE. 

                              BTW, anyone know when and where the first pick 3 game in the US was and when? I'd like to just play with it a bit.

                              You can't steal second and keep your foot on FIRST!!!

                              “Strength does not come from winning. Your struggles develop your strengths.
                              When you go through hardships and decide not to surrender, that is strength”.

                              -Arnold (Ahnald) Schwarzenegger-

                                 
                                Page 18 of 53