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

JADE's Pick 3 Even/Odd Low/High Karnaugh Heat Map

Topic closed. 20 replies. Last post 3 years ago by JADELottery.

Page 1 of 2
4.86
PrintE-mailLink
JADELottery's avatar - MeAtWork 03.PNG
The Quantum Master
West Concord, MN
United States
Member #21
December 7, 2001
3675 Posts
Online
Posted: January 21, 2014, 10:40 pm - IP Logged

Well, we're done playing around with the test and are releasing the Excel file we created.

http://www.jadexcode.com/Files/Excel/Pick3EOLHKHeatMap00.xlsm

ftp://www.jadexcode.com/Excel/Pick3EOLHKHeatMap00.xlsm


The Even/Odd Low/High Karnaugh Heat Map breaks down Pick 3 combos into smaller sets and shows the hit frequency in each set as a hot, medium, or cold value.

Each set is separated out into Even/Odd combos, then each of those sets are broken down into Low/High sets.

Each of the sets are all laid out in a tables in the Excel file for both Straight sets and Boxed sets.

To use the Excel file, just enter the pick 3 numbers only in columns A, B, and C, like so.



Then choose a range to analyze and click 'Map Range of Draws'.

Also, you can change the font color to see the colors more clearly for hot and cold hits by selecting the type of Map Font Display shown below.



Below is an example Karnaugh Heat Map of 100 draws.



The map has an 'n' value for both Even/Odd and Low/High that can be used to look up combo sets in the following tables.







As an example, the following Karnaugh Heat Map shows the map for 100 draws.

This is also in the file if you download it.

You'll notice the colors are explained in the Scale section.

In this map we can see that Even/Odd 1, Low/High 3 has a hit count of 5.



Looking up in the tables we can find the Straight or Boxed combos related to that section of the map.



 

Have fun and Good Luck.

Wink

Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.
Use at your own risk.

Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish
Jehocifer

    Igamble's avatar - spider
    nj
    United States
    Member #145657
    August 10, 2013
    974 Posts
    Offline
    Posted: January 22, 2014, 12:19 am - IP Logged

    APPROVED ! GOOD STUFF .What a nice find ...it pays off being a night hawk .

      Avatar
      Florida
      United States
      Member #66575
      October 30, 2008
      3549 Posts
      Offline
      Posted: January 22, 2014, 12:37 am - IP Logged

      Jade

      I entered the 100 draws but in cell B2  it indicates  " 0 " total draws . Any suggestion  ??

      Carlig

        Avatar
        Florida
        United States
        Member #66575
        October 30, 2008
        3549 Posts
        Offline
        Posted: January 22, 2014, 2:35 am - IP Logged

        Jade

        I entered the 100 draws but in cell B2  it indicates  " 0 " total draws . Any suggestion  ??

        Carlig

        Never Mind, I figured it out

        Thanks

        Carlig

          JADELottery's avatar - MeAtWork 03.PNG
          The Quantum Master
          West Concord, MN
          United States
          Member #21
          December 7, 2001
          3675 Posts
          Online
          Posted: January 22, 2014, 8:00 am - IP Logged

          Also, this is a Macro type spreadsheet, so you may need to enable it when you open it in Excel for the button and other parts of the programming to work.

          Presented 'AS IS' and for Entertainment Purposes Only.
          Any gain or loss is your responsibility.
          Use at your own risk.

          Order is a Subset of Chaos
          Knowledge is Beyond Belief
          Wisdom is Not Censored
          Douglas Paul Smallish
          Jehocifer

            sully16's avatar - sharan
            Ringleader
            Michigan
            United States
            Member #81740
            October 28, 2009
            40421 Posts
            Offline
            Posted: January 22, 2014, 8:16 am - IP Logged

            Thank you Jade, this is going to be very helpful, thanks for taking the time to share this with us.Thumbs Up

            Did you exchange a walk on part in the war ?

            For a lead role in a cage?

             

                                                        From Pink Floyd's " Wish you were here"

              Avatar
              Florida
              United States
              Member #66575
              October 30, 2008
              3549 Posts
              Offline
              Posted: January 22, 2014, 12:53 pm - IP Logged

              Also, this is a Macro type spreadsheet, so you may need to enable it when you open it in Excel for the button and other parts of the programming to work.

              For me the issue was I copied and pasted the draws , but what I found out was that I needed to enter draws manually, Once I did that it worked fine..

              Still back testing some .

               

              Carlig

                JADELottery's avatar - MeAtWork 03.PNG
                The Quantum Master
                West Concord, MN
                United States
                Member #21
                December 7, 2001
                3675 Posts
                Online
                Posted: January 22, 2014, 4:37 pm - IP Logged

                For me the issue was I copied and pasted the draws , but what I found out was that I needed to enter draws manually, Once I did that it worked fine..

                Still back testing some .

                 

                Carlig

                Haven't had any paste issues.

                Just make sure you're not tring to paste the whole number.

                Each number must be in a separate column; tab or comma delimited.

                Also, make sure it's real numbers not formulae; 2 3 4 not =INT(B4) or something like that.

                To make sure you are pasting just values, press Alt, then E, then S.

                It should bring up a Paste Special selection window, in the Paste section select Values as the option.

                Presented 'AS IS' and for Entertainment Purposes Only.
                Any gain or loss is your responsibility.
                Use at your own risk.

                Order is a Subset of Chaos
                Knowledge is Beyond Belief
                Wisdom is Not Censored
                Douglas Paul Smallish
                Jehocifer

                  JADELottery's avatar - MeAtWork 03.PNG
                  The Quantum Master
                  West Concord, MN
                  United States
                  Member #21
                  December 7, 2001
                  3675 Posts
                  Online
                  Posted: January 22, 2014, 4:55 pm - IP Logged

                  Just tried something and was able to reproduce the error.

                  We'll get back with a fix in a bit.

                  Naughty

                  Presented 'AS IS' and for Entertainment Purposes Only.
                  Any gain or loss is your responsibility.
                  Use at your own risk.

                  Order is a Subset of Chaos
                  Knowledge is Beyond Belief
                  Wisdom is Not Censored
                  Douglas Paul Smallish
                  Jehocifer

                    JADELottery's avatar - MeAtWork 03.PNG
                    The Quantum Master
                    West Concord, MN
                    United States
                    Member #21
                    December 7, 2001
                    3675 Posts
                    Online
                    Posted: January 22, 2014, 6:03 pm - IP Logged

                    Just tried something and was able to reproduce the error.

                    We'll get back with a fix in a bit.

                    Naughty

                    Ok, ah-better now.

                    Presented 'AS IS' and for Entertainment Purposes Only.
                    Any gain or loss is your responsibility.
                    Use at your own risk.

                    Order is a Subset of Chaos
                    Knowledge is Beyond Belief
                    Wisdom is Not Censored
                    Douglas Paul Smallish
                    Jehocifer

                      JADELottery's avatar - MeAtWork 03.PNG
                      The Quantum Master
                      West Concord, MN
                      United States
                      Member #21
                      December 7, 2001
                      3675 Posts
                      Online
                      Posted: January 22, 2014, 6:13 pm - IP Logged

                      If you are wondering, there are other heat maps.

                      In pick 3 there is one that relates to what is known here at the Lottery Post as the V-trac and some other value system.

                      Also, pick 4 has its own heat maps as well.

                      Just a heads up.

                      Wink

                      Presented 'AS IS' and for Entertainment Purposes Only.
                      Any gain or loss is your responsibility.
                      Use at your own risk.

                      Order is a Subset of Chaos
                      Knowledge is Beyond Belief
                      Wisdom is Not Censored
                      Douglas Paul Smallish
                      Jehocifer

                        Igamble's avatar - spider
                        nj
                        United States
                        Member #145657
                        August 10, 2013
                        974 Posts
                        Offline
                        Posted: January 22, 2014, 6:52 pm - IP Logged

                        can you make it so that when input the p3  it does it in one sequence ?like on the "search results "on LP YOU CAN INPUT NUMBER AND EACH DIGIT GOES AUTOMATED IN ITS COLUMN.and then its automated to the next row to inputnext number...a pick 4 heat map would b nice.Thanks.

                          JADELottery's avatar - MeAtWork 03.PNG
                          The Quantum Master
                          West Concord, MN
                          United States
                          Member #21
                          December 7, 2001
                          3675 Posts
                          Online
                          Posted: January 23, 2014, 9:52 am - IP Logged

                          can you make it so that when input the p3  it does it in one sequence ?like on the "search results "on LP YOU CAN INPUT NUMBER AND EACH DIGIT GOES AUTOMATED IN ITS COLUMN.and then its automated to the next row to inputnext number...a pick 4 heat map would b nice.Thanks.

                          possibly, but this is just a test sheet.

                          this is being worked in someplace else and no more activity is planned for it.

                          Presented 'AS IS' and for Entertainment Purposes Only.
                          Any gain or loss is your responsibility.
                          Use at your own risk.

                          Order is a Subset of Chaos
                          Knowledge is Beyond Belief
                          Wisdom is Not Censored
                          Douglas Paul Smallish
                          Jehocifer

                            LottoBux's avatar - 2elh5if
                            Ontario
                            Canada
                            Member #109243
                            April 9, 2011
                            31437 Posts
                            Offline
                            Posted: January 23, 2014, 10:10 am - IP Logged

                            Well, we're done playing around with the test and are releasing the Excel file we created.

                            http://www.jadexcode.com/Files/Excel/Pick3EOLHKHeatMap00.xlsm

                            ftp://www.jadexcode.com/Excel/Pick3EOLHKHeatMap00.xlsm


                            The Even/Odd Low/High Karnaugh Heat Map breaks down Pick 3 combos into smaller sets and shows the hit frequency in each set as a hot, medium, or cold value.

                            Each set is separated out into Even/Odd combos, then each of those sets are broken down into Low/High sets.

                            Each of the sets are all laid out in a tables in the Excel file for both Straight sets and Boxed sets.

                            To use the Excel file, just enter the pick 3 numbers only in columns A, B, and C, like so.



                            Then choose a range to analyze and click 'Map Range of Draws'.

                            Also, you can change the font color to see the colors more clearly for hot and cold hits by selecting the type of Map Font Display shown below.



                            Below is an example Karnaugh Heat Map of 100 draws.



                            The map has an 'n' value for both Even/Odd and Low/High that can be used to look up combo sets in the following tables.







                            As an example, the following Karnaugh Heat Map shows the map for 100 draws.

                            This is also in the file if you download it.

                            You'll notice the colors are explained in the Scale section.

                            In this map we can see that Even/Odd 1, Low/High 3 has a hit count of 5.



                            Looking up in the tables we can find the Straight or Boxed combos related to that section of the map.



                             

                            Have fun and Good Luck.

                            Wink

                            What Is The 2nd Download Link?

                            ftp://www.jadexcode.com/Excel/Pick3EOLHKHeatMap00.xlsm

                            Are Both Necessary?

                                                   

                              JADELottery's avatar - MeAtWork 03.PNG
                              The Quantum Master
                              West Concord, MN
                              United States
                              Member #21
                              December 7, 2001
                              3675 Posts
                              Online
                              Posted: January 23, 2014, 10:57 am - IP Logged

                              What Is The 2nd Download Link?

                              ftp://www.jadexcode.com/Excel/Pick3EOLHKHeatMap00.xlsm

                              Are Both Necessary?

                              yes, they are.

                              we have had problems working through the website and found the ftp system to be a good backup access.

                              both locations are the same file.

                              Presented 'AS IS' and for Entertainment Purposes Only.
                              Any gain or loss is your responsibility.
                              Use at your own risk.

                              Order is a Subset of Chaos
                              Knowledge is Beyond Belief
                              Wisdom is Not Censored
                              Douglas Paul Smallish
                              Jehocifer