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

Reply #20

JADELottery — Fri, 21 Feb 2014 01:37:29 GMT

no, you can add, remove, change any number of draws you'd like, as long as it's just the draws you change.

the lines go out to 32768; for a daily game drawn every day, that's about 89.7 years worth of draws.

Reply #19

scj2574 — Thu, 20 Feb 2014 21:28:44 GMT

Do you have to enter the 100 draws evertime time with a new draw

Reply #18

JADELottery — Mon, 10 Feb 2014 17:07:47 GMT

Select the draw data in Pick 3 - A, B, C or Pick 4 - A, B, C, D columns; then Delete.

Paste or enter your new draw data in its place.

We've tweaked the speadsheets a bit so the columns right of the data is automated a little better.

Reply #17

retxx — Mon, 10 Feb 2014 15:17:57 GMT

silly question;how to wipe out the 1000 draws and replace with 100 current.also when adding latest draw in top row how to drop it down. thanks

Reply #16

JADELottery — Sun, 09 Feb 2014 23:11:01 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

Reply #15

JADELottery — Mon, 27 Jan 2014 04:15:05 GMT

Added a little tweak.

Look carefully, there's a new option.

Reply #14

JADELottery — Thu, 23 Jan 2014 15:57:51 GMT

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.

Reply #13

LottoBux — Thu, 23 Jan 2014 15:10:15 GMT

What Is The 2nd Download Link?

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

Are Both Necessary

Reply #12

JADELottery — Thu, 23 Jan 2014 14:52:20 GMT

possibly, but this is just a test sheet.

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

Reply #11

Igamble — Wed, 22 Jan 2014 23:52:22 GMT

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.

Reply #10

JADELottery — Wed, 22 Jan 2014 23:13:58 GMT

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.

Reply #9

JADELottery — Wed, 22 Jan 2014 23:03:54 GMT

Ok, ah-better now.

Reply #8

JADELottery — Wed, 22 Jan 2014 21:55:16 GMT

Just tried something and was able to reproduce the error.

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

Reply #7

JADELottery — Wed, 22 Jan 2014 21:37:44 GMT

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.

Reply #6

CarliG — Wed, 22 Jan 2014 17:53:48 GMT

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

Reply #5

sully16 — Wed, 22 Jan 2014 13:16:53 GMT

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

Reply #4

JADELottery — Wed, 22 Jan 2014 13:00:23 GMT

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.

Reply #3

CarliG — Wed, 22 Jan 2014 07:35:28 GMT

Never Mind, I figured it out

Thanks

Carlig

Reply #2

CarliG — Wed, 22 Jan 2014 05:37:29 GMT

Jade

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

Carlig

Reply #1

Igamble — Wed, 22 Jan 2014 05:19:40 GMT

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

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

JADELottery — Wed, 22 Jan 2014 03:40:45 GMT

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.

Eac... [ More ]