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

The F17 System

Topic closed. 137 replies. Last post 8 years ago by Wheeler.

Page 8 of 10
4.85
PrintE-mailLink
Fibonacci's avatar - Lottery-050.jpg
New York, NY
United States
Member #39471
May 16, 2006
2696 Posts
Offline
Posted: February 18, 2009, 9:15 am - IP Logged

Sorry folks. I don't know why box.net isn't working. I will seek another repo site but if anyone knows a another site that works let me know--via PM-- and i will u/l it there.

$$$

    lovemoney's avatar - Lottery-052.jpg
    yosemite kentucky
    United States
    Member #59350
    March 13, 2008
    47 Posts
    Offline
    Posted: February 18, 2009, 9:56 am - IP Logged

    could you do that for kentucky on 198 and 102 i did but dont think i got the right numbers

    or do you know if it works in kentucky

      Fibonacci's avatar - Lottery-050.jpg
      New York, NY
      United States
      Member #39471
      May 16, 2006
      2696 Posts
      Offline
      Posted: February 18, 2009, 10:58 am - IP Logged

      could you do that for kentucky on 198 and 102 i did but dont think i got the right numbers

      or do you know if it works in kentucky

      198 -102

      Difference between draws is 198-102=096

      F17 on Difference

      179176196796026026066266092093023923

      F17 on Raw Draws

      189188198898126128168268192195125925
      180182102802117112172172101109119019

      $$$

        Fibonacci's avatar - Lottery-050.jpg
        New York, NY
        United States
        Member #39471
        May 16, 2006
        2696 Posts
        Offline
        Posted: February 18, 2009, 11:38 am - IP Logged

        NY Feb 18 (last three days' draws). NO, you are not expected to play all the numbers--it's a system--a guide.

        I have retooled the F17..it now will calculate F17 based on both the raw draws and the difference between the draws. Instructions are also in the interface.

        Good luck. Feedback welcomed.

        Excel pros...need help to create a button for user to change the "differential" from 17 to any other number without tampering manually with the code which intimidates users not comfortable with copying and pasting excel formulas..

        Download the F17 V2.0

        200209209009317319379179302306326026
        255257257557822827827227852854824524
        224222242242521522512212541549519419
        182185125825119115195195122122122222
        241243213413718713783183712710720120
        248246286486725726756256782783723823

         

        Based on difference between draws (last three days )

         

        224228248248521528518218542545525425
        201205215015318315385185312312322122
        211217217117418417487187412414424124
        228228288288525528558258582585525825
        177173173773024023043243072070020720

        $$$

          ace649's avatar - Lottery-019.jpg

          Canada
          Member #66533
          October 28, 2008
          170 Posts
          Offline
          Posted: February 18, 2009, 6:40 pm - IP Logged

          Hi

          Do u want me  to try ODD numbers coz 19 and 15 is not working either...desperately need one.

          thanks bud cheers.Sad Wavey

            LottoChica23's avatar - Aquarius
            Fughedaboutit (NY)
            United States
            Member #8160
            October 26, 2004
            6777 Posts
            Offline
            Posted: February 18, 2009, 6:48 pm - IP Logged

            NY Feb 18 (last three days' draws). NO, you are not expected to play all the numbers--it's a system--a guide.

            I have retooled the F17..it now will calculate F17 based on both the raw draws and the difference between the draws. Instructions are also in the interface.

            Good luck. Feedback welcomed.

            Excel pros...need help to create a button for user to change the "differential" from 17 to any other number without tampering manually with the code which intimidates users not comfortable with copying and pasting excel formulas..

            Download the F17 V2.0

            200209209009317319379179302306326026
            255257257557822827827227852854824524
            224222242242521522512212541549519419
            182185125825119115195195122122122222
            241243213413718713783183712710720120
            248246286486725726756256782783723823

             

            Based on difference between draws (last three days )

             

            224228248248521528518218542545525425
            201205215015318315385185312312322122
            211217217117418417487187412414424124
            228228288288525528558258582585525825
            177173173773024023043243072070020720

            Tried to PM you but your box is full...

             

            Fibonacci,

            You can change the "17" factor without fiddling with the code by naming a cell in the spreadsheet and use that name in the formula.

            e.g. I added a row at the top of the sheet, named the cell (B1 "Factor") and included it in the formula (C3+Factor) as follows:

             

            fib1

             

            fib2

             

            When you cange the number in B1 the results will change accordingly. So... Everywhere in the spreadsheet that yhou have the "17", you need to change the "17" to the named range.

             

            HTH

            Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

            check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

            You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

              Fibonacci's avatar - Lottery-050.jpg
              New York, NY
              United States
              Member #39471
              May 16, 2006
              2696 Posts
              Offline
              Posted: February 18, 2009, 10:28 pm - IP Logged

              Thanks Lottochica. Here i was thinkiong of a longer more involved way to do this. I appreciate that. Sorry about PM box everyone--will clear.

              $$$

                Fibonacci's avatar - Lottery-050.jpg
                New York, NY
                United States
                Member #39471
                May 16, 2006
                2696 Posts
                Offline
                Posted: February 19, 2009, 11:35 am - IP Logged

                Tried to PM you but your box is full...

                 

                Fibonacci,

                You can change the "17" factor without fiddling with the code by naming a cell in the spreadsheet and use that name in the formula.

                e.g. I added a row at the top of the sheet, named the cell (B1 "Factor") and included it in the formula (C3+Factor) as follows:

                 

                fib1

                 

                fib2

                 

                When you cange the number in B1 the results will change accordingly. So... Everywhere in the spreadsheet that yhou have the "17", you need to change the "17" to the named range.

                 

                HTH

                Hi Lottochica,

                I am not sure I understood what you said. I wanted to make this as easy as possible for people not familiar with Excel formulas to simply make a single change in a cell and having everything update without doing anything else.

                I am not all too clear if that is what the change you proposed is able to do.

                $$$

                  Premonitionz's avatar - 8ball
                  Detroit, Michigan
                  United States
                  Member #67067
                  November 15, 2008
                  315 Posts
                  Offline
                  Posted: February 19, 2009, 12:31 pm - IP Logged


                  Fibonacci,

                  I appreciate the work and effort you put into this. I like the version 2 you created, but the numbers that are highlighted are in a very dark blue color, which isn't easy on the eyes. I believe what LottoChica23 did was, she added an additional input area where you can change the variable from +17 to any number you think works best, which I think is an excellent idea.

                  Once again, thanks for the work you do, it's very much appreciated.

                    ace649's avatar - Lottery-019.jpg

                    Canada
                    Member #66533
                    October 28, 2008
                    170 Posts
                    Offline
                    Posted: February 19, 2009, 12:48 pm - IP Logged

                    Hi Fibonacci

                    Do u want me to try the odd numbers  coz u gave me  these 15,19,17 ...but its not working. Do u think u would be able to give me another set of numbers.really need one buddy.

                    cheersSad Wavey

                      Elizabeth03's avatar - cat anm.gif
                      Nova Scotia
                      Canada
                      Member #9934
                      December 27, 2004
                      884 Posts
                      Offline
                      Posted: February 19, 2009, 12:51 pm - IP Logged

                      How about for lotto 649, any system for it?Group Hug

                        Fibonacci's avatar - Lottery-050.jpg
                        New York, NY
                        United States
                        Member #39471
                        May 16, 2006
                        2696 Posts
                        Offline
                        Posted: February 19, 2009, 1:18 pm - IP Logged

                        Ok F17 2.1 is available. Not sure if is the same approach Lottochica took but I have now changed the factor from a constant to a cell reference which will be referenced absolutely not relatively. In any case thanks Lottochica for setting me thinking in the right direction.

                         

                        All instructions are in the Spreadsheet. Now all you have to do is change the Factor. Nothing else needs to be tampered with. Sorry about the colors. Looks good on my laptop but I have kept white as much as possible.

                        F17 V2.1 Available

                        $$$

                          LottoChica23's avatar - Aquarius
                          Fughedaboutit (NY)
                          United States
                          Member #8160
                          October 26, 2004
                          6777 Posts
                          Offline
                          Posted: February 19, 2009, 7:07 pm - IP Logged

                          Ok F17 2.1 is available. Not sure if is the same approach Lottochica took but I have now changed the factor from a constant to a cell reference which will be referenced absolutely not relatively. In any case thanks Lottochica for setting me thinking in the right direction.

                           

                          All instructions are in the Spreadsheet. Now all you have to do is change the Factor. Nothing else needs to be tampered with. Sorry about the colors. Looks good on my laptop but I have kept white as much as possible.

                          F17 V2.1 Available

                          You're welcome Fibonacci... You got the gist of what I was saying. 

                          The same thing can be accomplished using a named range. Named ranges and dynamic ranges have become my very good lottery spreadsheet friends.

                          Here is some information about ranges in Excel: http://www.cpearson.com/excel/named.htm

                          Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

                          check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

                          You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

                            Wheeler's avatar - Lottery-023.jpg
                            Pittsburg, Ks
                            United States
                            Member #3382
                            January 17, 2004
                            80626 Posts
                            Online
                            Posted: February 20, 2009, 6:12 am - IP Logged

                            I have been using the +3+1+2 (found on the NOrth Carolina thread in the Pic3 Forum)system and the F17 to make my predictions for All States. Out of the 7 States the F17 hit 6 times

                             God Bless America

                             

                            US Flag

                              Fibonacci's avatar - Lottery-050.jpg
                              New York, NY
                              United States
                              Member #39471
                              May 16, 2006
                              2696 Posts
                              Offline
                              Posted: February 20, 2009, 8:12 am - IP Logged

                              I have been using the +3+1+2 (found on the NOrth Carolina thread in the Pic3 Forum)system and the F17 to make my predictions for All States. Out of the 7 States the F17 hit 6 times

                              Thanks Wheeler. I would love to hear a bit more detail. I am trying to find the post on the NC thread--it's so long---.

                              I get nit ytu mean add 3 to the first digit 2 to the second and 1 to the third?

                               I am already working on the F17 3.0 which would include the 3+2+1 as an option. Thanks.

                              $$$

                                 
                                Page 8 of 10