JADE's Pick 4 Even/Odd Low/High Karnaugh Heat MapPrev TopicNext Topic

• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,812 Posts
  Offline
  Feb 8, 2014, 9:32 pm

  ▲▼

  Well, it's here:

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

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

   

  Refer to the related topic for the basics:

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

   

  

  The One Over None
  I Know...
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,812 Posts
  Offline
  Feb 9, 2014, 6:11 pm

  ▲▼

  If you ever need to find this topic without going though the forum, you can just look for it in our Favorites listings.
  
  We use the Favorites as a bookmark for all the stuff we post here and a few other topics or posts we find useful.

  https://www.lotterypost.com/member/1170/favorites

  The One Over None
  I Know...
• retxx

  

  BOSTON
  United States
  Member #48
  September 9, 2001
  3,954 Posts
  Offline
  Feb 10, 2014, 8:54 pm

  ▲▼

  I deleted all the past draws.deleted all the o/e, entered the last 10 draws and nothing happened. the o/e column did not fill in or the chart stayed blank. can you help? thanks
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,812 Posts
  Offline
  Feb 10, 2014, 9:20 pm

  ▲▼
  In response to retxx

  Quote: Originally posted by retxx on Feb 10, 2014

  I deleted all the past draws.deleted all the o/e, entered the last 10 draws and nothing happened. the o/e column did not fill in or the chart stayed blank. can you help? thanks

  After you enter the data, click the 'Map Range of Draws' button.

  Also, make sure you enable the Macros & ActiveX when you first open the spreadsheet.

  Excel by default will not run any Macros or ActiveX programming.

  There's usually an 'Option' button near the top of the page to allow you to enable running Macros & ActiveX content.

   

  

   

  

  The One Over None
  I Know...
• retxx

  

  BOSTON
  United States
  Member #48
  September 9, 2001
  3,954 Posts
  Offline
  Feb 11, 2014, 1:53 pm

  ▲▼

  I checked to see if active x was enabled also macros and they are. Still nothing. can you give me the link with the cells empty so i can enter my last 10 draws and see what happens. thanks any other suggestions would help.
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,812 Posts
  Offline
  Feb 11, 2014, 3:34 pm

  ▲▼

  dunno, we tried this on 3 different systems; works for us.

  might need to download the file again.

  other wise delete what's in the A B C D columns, then save it, close it, and reopen it, then try again.

  The One Over None
  I Know...
• retxx

  

  BOSTON
  United States
  Member #48
  September 9, 2001
  3,954 Posts
  Offline
  Feb 12, 2014, 10:06 am

  ▲▼

  got it Jade finally. thanks question; the o/e l/h cells do not auto fill up when I enter the draws and where is link to download the pic 3 link?
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,812 Posts
  Offline
  Feb 12, 2014, 10:17 am

  ▲▼
  In response to retxx

  Quote: Originally posted by retxx on Feb 12, 2014

  got it Jade finally. thanks question; the o/e l/h cells do not auto fill up when I enter the draws and where is link to download the pic 3 link?

  Cell F4 should contain this formula: =IF(A4<=B$2,(8*MOD(B4,2)+4*MOD(C4,2)+2*MOD(D4,2)+1*MOD(E4,2))&", "&(8*INT(B4/5)+4*INT(C4/5)+2*INT(D4/5)+1*INT(E4/5)),"")

  All the other cells in the F column should have a similar formula.

  If they do not, then it will not auto fill.

  Make sure you did not delete it.

  Otherwise copy the above formula into cell F4, then copy F4 and paste to the other cells under it down to the last indexed row.

  This only relates to this Pick 4 topic.

  If there is a problem in the Pick 3 version, post problems in the JADE's Pick 3 Even/Odd Low/High Karnaugh Heat Map topic.

  The One Over None
  I Know...