Hi Frank
Just a little questions
I am using your template for the heat maps and together with advice and help fro EJ (Bloubul) am getting the feel for using the template for UK49 and PB south africa.
My question will it be possible time permitting for you to convert the template for the pick3 that we have here now
REgards
Raj
It might be a little question, but its not a little job! You are pushing your luck Raj!
However, I have made a few assumptions, since I dont do Pick 3, we dont have that type of pick 3 in the UK.
There are only 10 digits, but order is important, so both value and position can be classified as a parameter to measure heat for. This creates 30 possible outcomes of digit and position combination. So 1a would be digit 1 in the first position, 4c would be digit 4 in the third position etc.
I have modified that original template somewhat, because it was a little inflexible, not much room in the first columns for expansion without rewriting macros. So all the tracking of skips and also a 0 or 1 grid are on sheet 2. There is also a list a list of
test results which i generated.
This version has the latest or newest result at the bottom of the list. Formulas look for the last 24 results, and it is this info which is displayed on sheet 2.
Now you have a choice, to use skips or to use a hit/miss grid. On sheet 1 are two new buttons, which you use to choose which source of data to use., skips or grid. Clicking the button of your choice copies and paste-links the appropriate heat scores into column N on sheet 1. The lookup table is upside down, a consequence of it needing to be in order descending in the first column. This is a side effect of using a 0' or 1' grid which means high score = hot, the opposite of what we had before. This played havoc with placement in the final heat table, I had to create an upside down sub total, used to assign rows to the numbers in the table. The heat scores derived from skips have been 'inverted' to match the philosphy of high score = hot as well.
Anyway Ive had enough of heat charts now, my job is done, I wont be amending or creating any more. I'm off to the pub.
https://www.mediafire.com/?gjst188r11qs6nc