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

Looking for ABCDEFGHIJKL converter to Digits Program or Excel

Topic closed. 38 replies. Last post 2 years ago by TasBob.

Page 3 of 3
PrintE-mailLink
Tialuvslotto's avatar - Jailin
Texas
United States
Member #150797
December 31, 2013
815 Posts
Offline
Posted: May 14, 2015, 7:45 am - IP Logged

Building a lotto spreadsheet is a great way to learn Excel on the fly!  Best place to put your study efforts is =IF and =COUNTIF, both great help in describing what is happening in your game.

That said, I still keep a lotto journal to jot down anything I notice as I am going through my spreadsheet.

"There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

~Robert A. Heinlein

    TasBob's avatar - 4NJ9EUA
    Bowling Green ,Florida
    United States
    Member #108735
    March 30, 2011
    4091 Posts
    Offline
    Posted: May 14, 2015, 10:17 am - IP Logged

    "Please don't tell me to stick with paper and pen"

    Some members like paper and pen, they claim it's faster and easier than learning Excel or how to program.

    Yes I will always use paper and pen,and use the human element..Excel will just help me do that better,and save me time on my workouts.

    The array of numbers to letters is the start ..I call  this  phase 1 ( the base of the Master System).  Sheet 1 of the work sheet..

    This may take weeks or months....Not sure....

    Work sheet 2 will be the Exciting part, The data from work sheet 1 will merge with work sheet 2 .. at that point don't know if I will need

    more work sheets or not.

    You may ask what in the world is going on with this Master System, what are your goals?

    Hold on to your hat!!  In the end what I want is a system, that gives you no more than 6 numbers to play each draw..

    And make Money each week...Will I reach that Goal maybe or maybe not..But IF I don't push myself ,I would never know.

    All of know by now systems come and go....And you know I want this one to stay.

    Procrastination Stops Progress ⇒Σ

      SergeM's avatar - slow icon.png
      Economy class
      Belgium
      Member #123700
      February 27, 2012
      4035 Posts
      Offline
      Posted: May 14, 2015, 10:59 am - IP Logged

      Yes I will always use paper and pen,and use the human element..Excel will just help me do that better,and save me time on my workouts.

      The array of numbers to letters is the start ..I call  this  phase 1 ( the base of the Master System).  Sheet 1 of the work sheet..

      This may take weeks or months....Not sure....

      Work sheet 2 will be the Exciting part, The data from work sheet 1 will merge with work sheet 2 .. at that point don't know if I will need

      more work sheets or not.

      You may ask what in the world is going on with this Master System, what are your goals?

      Hold on to your hat!!  In the end what I want is a system, that gives you no more than 6 numbers to play each draw..

      And make Money each week...Will I reach that Goal maybe or maybe not..But IF I don't push myself ,I would never know.

      All of know by now systems come and go....And you know I want this one to stay.

      In resumé:

      Excel has a lot of ready features, like connection to Access database. There is a lot more to it than worksheet-functions.

      Functions are sorted by for what they are used, like text, statistics or other. I add custom functions and subroutines.

      For the beginner:

      You have to know and practice with cell referencing, it is the A to Z in this.

      When you try a function, you have to read the information that MSDN gives you and try a few things.

      The best way to access and use functions is to click on the Fx, than pick a function by category. That decreases the risk of mistakes.

      The main questions that come up here are like how do I deal with strings? The answer is, you use text functions. The way to go further is to put the values in separate cells. Sorting is done with mouse clicks, or you apply functions like small(). Again here you use the cell referencing. The top level of spreadsheet functions is composed by matrix functions that can be complicated. Some buy programs to write them, I don't, I use VBA-coding.

      Tricks:
      A cell has a format like date, text or number value. Experiment!

      Basics you should learn first: logical functions (and, or, not, true, false ...) and text functions (mid, ...).

      OR = from two at least one is true
      XOR = from two only one is true
      AND = from two both are true

      ...

      Defects in Excel:

      Some functions don't do well. The solution is to write your own functions or not to use them.
      Not a defect is exhausting the memory and the display of wrong results, but very annoying. The solution is programming sub routines.
      Concatenation is best done with ampersand '&'.

      Some solution with bigger data is to place it in Access or SQL-server and query it. This needs coding. You can also query in the workbooks.

      ...

      A tip:

      Use conditional formatting for your tables. It has become very efficient. It does a visual sorting.

      After importing data that is coming in one column, use the split to cells.

        TasBob's avatar - 4NJ9EUA
        Bowling Green ,Florida
        United States
        Member #108735
        March 30, 2011
        4091 Posts
        Offline
        Posted: May 14, 2015, 11:55 am - IP Logged

        In resumé:

        Excel has a lot of ready features, like connection to Access database. There is a lot more to it than worksheet-functions.

        Functions are sorted by for what they are used, like text, statistics or other. I add custom functions and subroutines.

        For the beginner:

        You have to know and practice with cell referencing, it is the A to Z in this.

        When you try a function, you have to read the information that MSDN gives you and try a few things.

        The best way to access and use functions is to click on the Fx, than pick a function by category. That decreases the risk of mistakes.

        The main questions that come up here are like how do I deal with strings? The answer is, you use text functions. The way to go further is to put the values in separate cells. Sorting is done with mouse clicks, or you apply functions like small(). Again here you use the cell referencing. The top level of spreadsheet functions is composed by matrix functions that can be complicated. Some buy programs to write them, I don't, I use VBA-coding.

        Tricks:
        A cell has a format like date, text or number value. Experiment!

        Basics you should learn first: logical functions (and, or, not, true, false ...) and text functions (mid, ...).

        OR = from two at least one is true
        XOR = from two only one is true
        AND = from two both are true

        ...

        Defects in Excel:

        Some functions don't do well. The solution is to write your own functions or not to use them.
        Not a defect is exhausting the memory and the display of wrong results, but very annoying. The solution is programming sub routines.
        Concatenation is best done with ampersand '&'.

        Some solution with bigger data is to place it in Access or SQL-server and query it. This needs coding. You can also query in the workbooks.

        ...

        A tip:

        Use conditional formatting for your tables. It has become very efficient. It does a visual sorting.

        After importing data that is coming in one column, use the split to cells.

        Ok Thank You I need all the help I can Get.

        Procrastination Stops Progress ⇒Σ

          mmx1's avatar - 8ball

          Canada
          Member #90040
          April 20, 2010
          473 Posts
          Offline
          Posted: May 14, 2015, 1:52 pm - IP Logged

          I have played a lot with this idea in my programs and here is a part of it.

          There are two parts here, one is the Main test (Bob is looking for) and 2nd part is a simulation test of playing certain order positions (Bob's order: A-K or my order: 1.-10.)

          In this example digits are ordered by current skip (green column) showing how many draws each digit has been out.

          Digits could be ordered in other ways instead of current skip as:

          • digits occurrences
          • by total hits
          • by max skip

          Bob's idea seems to be sorting digits by total number of hits in the last X drawings.

          Once we have digits in the certain order we can wheel digits from some positions.

          In this example I simulated playing 35 combos, SINGLES, BOX, wheel conditions: "If 3 of 7 digits at positions 1. - 7. (A - G)".

          By the way my sorting is very precise so that if we have the same digits at two or more positions they are sorted by another priority.

          In this example digits are ordered by current skip. If we have the same digit at two or more positions priority is given to digit with more hits, if that's still the same for all them, then priority is given to digits with lower maxSkip etc. Priority means that a digit gets a lower order position.

          --------------------------------------------------------------------------------------------------------------

          Main test:

                         M      C L                            T      D  C   L
                  T    M a      u a                     T      o      i  u   a
                  o    a x      r s             T       o      t      g  r   s
                  t    x S      r t     D       o       t                r   t
                         k              i       t              S      O     
                  H    S p      S S     g               C      c      c  S   S
                  i    k Q      k k     i       W       o      o      c  k   k
                  t    i t      i i     t       i       s      r      u  i   i
                  s    p y      p p     s       n       t      e      r  p   p <<--Recent skip pattern<<-- 
           
          A  1.  13    9(1)     0(0)    5    2250   -2200     50     15  0   0   0 0 0 6 9 1 0 1 1 1 7.....        © 
          2.  14   11(1)     0(1)    4    2700   -2200    500     16  0   1   2 1 0 0 4 0 3 0 4 11 0 0..        --© 
          3.   7   17(1)     0(3)    0    1200   -2200  -1000      7  0   3   1 2 2 0 8.................  ©----- 
          4.  10    8(1)     1       7    1800   -2200   -400     11  1   1   3 6 1 3 3 0 2 2...........     •-- 
          5.   7   13(1)     1       3    1200   -2200  -1000      7  1   13  10 2 1 3 0................  •----- 
          6.  12    6(1)     2       1    2100   -2200   -100     13  2   1   6 0 4 0 1 1 1 2 4 3.......       • 
          7.   8   11(1)     3       6    1350   -2200   -850      9  3   3   0 1 4 3 11 2..............   •---- 
          8.  16    4(1)     5       8    3000   -2200    800     18  5   2   1 0 0 3 2 1 4 0 0 0 0 1 0.        ----• 
          9.  12    6(1)     5       9    2400   -2200    200     13  5   0   6 3 5 3 5 0 0 1 0 0.......        -• 
          K 10.  10   10(1)     6       2    1650   -2200   -550     11  6   3   2 0 2 0 2 0 10 1..........     •-- 
           
          =======================================================================================================

          Here bellow is the result of this strategy for the last 40 draws. 5407316 is the set for Midday today.

          As you can see, noting special. We're close to zero (-50).

          This doesn't mean a different sorting and playing different wheels wouldn't make a profit.

           

          Simulation results starting from the bottom:

          =======================================================================================================

           41. Play next: 5407316    0  -35  -35       0    -35    -35 

           MaxSkip(Qty): 15(1),  CurrentSkip: 0,  TotalSkips: 31     0 4 2 15 1 0 0 4 4 1 ................ 
           
           41. ------???  5407316       -35      TotWin TotCost Profit                     
           40. 504------  7531460  150  -35  115    1350  -1400    -50       © 
           39. 537------  1547608    0  -35  -35    1200  -1365   -165       • 
           38. 541------  7561089    0  -35  -35    1200  -1330   -130       • 
           37. 675------  1509842    0  -35  -35    1200  -1295    -95       • 
           36. 015------  9842076    0  -35  -35    1200  -1260    -60       • 
           35. 894------  9207468  150  -35  115    1200  -1225    -25       © 
           34. 290------  7468021    0  -35  -35    1050  -1190   -140       • 
           33. 476------  8460215    0  -35  -35    1050  -1155   -105       • 
           32. 846------  4082615  150  -35  115    1050  -1120    -70       © 
           31. ---044---  8261509    0  -35  -35     900  -1085   -185       • 
           30. 286------  1850927    0  -35  -35     900  -1050   -150       • 
           29. 158------  1809274    0  -35  -35     900  -1015   -115       • 
           28. 810------  9207436    0  -35  -35     900   -980    -80       • 
           27. 209------  7243689    0  -35  -35     900   -945    -45       • 
           26. 724------  3468791    0  -35  -35     900   -910    -10       • 
           25. 634------  8791246    0  -35  -35     900   -875     25        • 
           24. ---788---  9128467    0  -35  -35     900   -840     60        • 
           23. 192------  1284675    0  -35  -35     900   -805     95        • 
           22. ---221---  8461725    0  -35  -35     900   -770    130        • 
           21. 846------  1748520    0  -35  -35     900   -735    165        • 
           20. 417------  8521097    0  -35  -35     900   -700    200        -• 
           19. 285------  1209574    0  -35  -35     900   -665    235        -• 
           18. 201------  9517483    0  -35  -35     900   -630    270        -• 
           17. ---559---  1754839    0  -35  -35     900   -595    305        -• 
           16. 751------  7438591  150  -35  115     900   -560    340        -© 
           15. ---477---  3859176    0  -35  -35     750   -525    225        -• 
           14. 358------  9187536  150  -35  115     750   -490    260        -© 
           13. 981------  7583619  150  -35  115     600   -455    145        © 
           12. 857------  3856719  150  -35  115     450   -420     30        © 
           11. ---883---  5863719    0  -35  -35     300   -385    -85       • 
           10. ---855---  6371892    0  -35  -35     300   -350    -50       • 
            9. 673------  1892634    0  -35  -35     300   -315    -15       • 
            8. ---181---  9286314    0  -35  -35     300   -280     20        • 
            7. 928------  9623184  150  -35  115     300   -245     55        © 
            6. ---696---  9231845    0  -35  -35     150   -210    -60       • 
            5. 293------  3189456    0  -35  -35     150   -175    -25       • 
            4. 318------  9456732    0  -35  -35     150   -140     10        • 
            3. ---449---  9456732    0  -35  -35     150   -105     45        • 
            2. 954------  9467352  150  -35  115     150    -70     80        © 
            1. ---949---  6735241    0  -35  -35       0    -35    -35       • 

            TasBob's avatar - 4NJ9EUA
            Bowling Green ,Florida
            United States
            Member #108735
            March 30, 2011
            4091 Posts
            Offline
            Posted: May 14, 2015, 4:20 pm - IP Logged

            I have played a lot with this idea in my programs and here is a part of it.

            There are two parts here, one is the Main test (Bob is looking for) and 2nd part is a simulation test of playing certain order positions (Bob's order: A-K or my order: 1.-10.)

            In this example digits are ordered by current skip (green column) showing how many draws each digit has been out.

            Digits could be ordered in other ways instead of current skip as:

            • digits occurrences
            • by total hits
            • by max skip

            Bob's idea seems to be sorting digits by total number of hits in the last X drawings.

            Once we have digits in the certain order we can wheel digits from some positions.

            In this example I simulated playing 35 combos, SINGLES, BOX, wheel conditions: "If 3 of 7 digits at positions 1. - 7. (A - G)".

            By the way my sorting is very precise so that if we have the same digits at two or more positions they are sorted by another priority.

            In this example digits are ordered by current skip. If we have the same digit at two or more positions priority is given to digit with more hits, if that's still the same for all them, then priority is given to digits with lower maxSkip etc. Priority means that a digit gets a lower order position.

            --------------------------------------------------------------------------------------------------------------

            Main test:

                           M      C L                            T      D  C   L
                    T    M a      u a                     T      o      i  u   a
                    o    a x      r s             T       o      t      g  r   s
                    t    x S      r t     D       o       t                r   t
                           k              i       t              S      O     
                    H    S p      S S     g               C      c      c  S   S
                    i    k Q      k k     i       W       o      o      c  k   k
                    t    i t      i i     t       i       s      r      u  i   i
                    s    p y      p p     s       n       t      e      r  p   p <<--Recent skip pattern<<-- 
             
            A  1.  13    9(1)     0(0)    5    2250   -2200     50     15  0   0   0 0 0 6 9 1 0 1 1 1 7.....        © 
            2.  14   11(1)     0(1)    4    2700   -2200    500     16  0   1   2 1 0 0 4 0 3 0 4 11 0 0..        --© 
            3.   7   17(1)     0(3)    0    1200   -2200  -1000      7  0   3   1 2 2 0 8.................  ©----- 
            4.  10    8(1)     1       7    1800   -2200   -400     11  1   1   3 6 1 3 3 0 2 2...........     •-- 
            5.   7   13(1)     1       3    1200   -2200  -1000      7  1   13  10 2 1 3 0................  •----- 
            6.  12    6(1)     2       1    2100   -2200   -100     13  2   1   6 0 4 0 1 1 1 2 4 3.......       • 
            7.   8   11(1)     3       6    1350   -2200   -850      9  3   3   0 1 4 3 11 2..............   •---- 
            8.  16    4(1)     5       8    3000   -2200    800     18  5   2   1 0 0 3 2 1 4 0 0 0 0 1 0.        ----• 
            9.  12    6(1)     5       9    2400   -2200    200     13  5   0   6 3 5 3 5 0 0 1 0 0.......        -• 
            K 10.  10   10(1)     6       2    1650   -2200   -550     11  6   3   2 0 2 0 2 0 10 1..........     •-- 
             
            =======================================================================================================

            Here bellow is the result of this strategy for the last 40 draws. 5407316 is the set for Midday today.

            As you can see, noting special. We're close to zero (-50).

            This doesn't mean a different sorting and playing different wheels wouldn't make a profit.

             

            Simulation results starting from the bottom:

            =======================================================================================================

             41. Play next: 5407316    0  -35  -35       0    -35    -35 

             MaxSkip(Qty): 15(1),  CurrentSkip: 0,  TotalSkips: 31     0 4 2 15 1 0 0 4 4 1 ................ 
             
             41. ------???  5407316       -35      TotWin TotCost Profit                     
             40. 504------  7531460  150  -35  115    1350  -1400    -50       © 
             39. 537------  1547608    0  -35  -35    1200  -1365   -165       • 
             38. 541------  7561089    0  -35  -35    1200  -1330   -130       • 
             37. 675------  1509842    0  -35  -35    1200  -1295    -95       • 
             36. 015------  9842076    0  -35  -35    1200  -1260    -60       • 
             35. 894------  9207468  150  -35  115    1200  -1225    -25       © 
             34. 290------  7468021    0  -35  -35    1050  -1190   -140       • 
             33. 476------  8460215    0  -35  -35    1050  -1155   -105       • 
             32. 846------  4082615  150  -35  115    1050  -1120    -70       © 
             31. ---044---  8261509    0  -35  -35     900  -1085   -185       • 
             30. 286------  1850927    0  -35  -35     900  -1050   -150       • 
             29. 158------  1809274    0  -35  -35     900  -1015   -115       • 
             28. 810------  9207436    0  -35  -35     900   -980    -80       • 
             27. 209------  7243689    0  -35  -35     900   -945    -45       • 
             26. 724------  3468791    0  -35  -35     900   -910    -10       • 
             25. 634------  8791246    0  -35  -35     900   -875     25        • 
             24. ---788---  9128467    0  -35  -35     900   -840     60        • 
             23. 192------  1284675    0  -35  -35     900   -805     95        • 
             22. ---221---  8461725    0  -35  -35     900   -770    130        • 
             21. 846------  1748520    0  -35  -35     900   -735    165        • 
             20. 417------  8521097    0  -35  -35     900   -700    200        -• 
             19. 285------  1209574    0  -35  -35     900   -665    235        -• 
             18. 201------  9517483    0  -35  -35     900   -630    270        -• 
             17. ---559---  1754839    0  -35  -35     900   -595    305        -• 
             16. 751------  7438591  150  -35  115     900   -560    340        -© 
             15. ---477---  3859176    0  -35  -35     750   -525    225        -• 
             14. 358------  9187536  150  -35  115     750   -490    260        -© 
             13. 981------  7583619  150  -35  115     600   -455    145        © 
             12. 857------  3856719  150  -35  115     450   -420     30        © 
             11. ---883---  5863719    0  -35  -35     300   -385    -85       • 
             10. ---855---  6371892    0  -35  -35     300   -350    -50       • 
              9. 673------  1892634    0  -35  -35     300   -315    -15       • 
              8. ---181---  9286314    0  -35  -35     300   -280     20        • 
              7. 928------  9623184  150  -35  115     300   -245     55        © 
              6. ---696---  9231845    0  -35  -35     150   -210    -60       • 
              5. 293------  3189456    0  -35  -35     150   -175    -25       • 
              4. 318------  9456732    0  -35  -35     150   -140     10        • 
              3. ---449---  9456732    0  -35  -35     150   -105     45        • 
              2. 954------  9467352  150  -35  115     150    -70     80        © 
              1. ---949---  6735241    0  -35  -35       0    -35    -35       • 

            Tks for posting mark , I love your Universal Filter For Digits...Use it almost daily.

            Other parts of your program , I'll need time to make sure I'm doing it right.

            For now I will stay Focus on the foundation of the Master Chart.

            I sure a lot of people rise there eyebrows When they seen your post  .. WOW

             5407316     

            In your program can you take the string down to 6 numbers ? That is one of my goals..

            6 numbers is 20 plays ..The hard part is to ele 3 numbers, you got to be right,,

            Procrastination Stops Progress ⇒Σ

              TasBob's avatar - 4NJ9EUA
              Bowling Green ,Florida
              United States
              Member #108735
              March 30, 2011
              4091 Posts
              Offline
              Posted: May 14, 2015, 7:18 pm - IP Logged

              Procrastination Stops Progress ⇒Σ

                mmx1's avatar - 8ball

                Canada
                Member #90040
                April 20, 2010
                473 Posts
                Offline
                Posted: May 14, 2015, 7:29 pm - IP Logged

                Once you have an ordered set of 10 digits for the next draw you can do anything you want with them.

                You can wheel and play as many of them as you want, but which ones?

                There are two questions here:

                • what is the best digits ordering criteria (current hit skip - how many draws each digit didn't show up, digits occurrences - how many times each digit showed up in the last X drawings, quantity of hits - how many hits each digit had in the last X drawings, max skip - the longest consecutive absence of each digits in the last X drawings...)
                • digits from which positions to play all the time

                You can't figure out this without PC simulation program.

                This analysis is very demanding and cannot be tested on the paper.

                Betting strategy and timing seem to be more important than digits selection strategy.

                  TasBob's avatar - 4NJ9EUA
                  Bowling Green ,Florida
                  United States
                  Member #108735
                  March 30, 2011
                  4091 Posts
                  Offline
                  Posted: May 14, 2015, 8:33 pm - IP Logged

                                                                       Base

                  A....use 10 letters for now and later add 2 more letters to help with Doubles later  Put in by hand

                  B...array of numbers     Put in by hand   

                  C...Winning Number Straight   Put in by hand     E...small to largest number

                  D...Straight      F...From A to  L  box

                  First let go to B  array of numbers will change each and  every draw. Block A(A-L) is the problem, what I think we have to do is have buttons, or clicks.

                  in A........ Top roll 210 came in . .The letters I H and B.. 

                  First we would type in 210 in C  that would do  E at the same time..

                  Then go to A with the mouse  and touch the letters I H and B they would go to D(IHB) and F(BIJ)

                  Ok  This is just the base Idea I'm sure will change as time goes on...

                  There's nothing new here..And yes we could add odd even in and out ,and go on and on...

                  But for now let's build the base. Any and all help with formulas is appreciated ...

                  Procrastination Stops Progress ⇒Σ