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

Reply #7

JADELottery — Wed, 12 Feb 2014 15:17:52 GMT

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 pr... [ More ]

Reply #6

retxx — Wed, 12 Feb 2014 15:06:35 GMT

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

Reply #5

JADELottery — Tue, 11 Feb 2014 20:34:15 GMT

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.

Reply #4

retxx — Tue, 11 Feb 2014 18:53:48 GMT

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.

Reply #3

JADELottery — Tue, 11 Feb 2014 02:20:57 GMT

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.

Reply #2

retxx — Tue, 11 Feb 2014 01:54:53 GMT

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

Reply #1

JADELottery — Sun, 09 Feb 2014 23:11:39 GMT

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

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

JADELottery — Sun, 09 Feb 2014 02:32:19 GMT

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