Link to home
Start Free TrialLog in
Avatar of simon
simon

asked on

Looking for duplet and triplet buddies while directly clicking on the latest draw numbers

" Click directly on the latest draw number could display buddies and triplets" in a new tab , called TabTwo29253815c 12 Feb 23.xlsb
In the 1 to 80 tab,  the following is the latest draw numbers of 12th Feb 23 at 10 am

 
2371115253133424850525861666869727479


So  the code will focus always  on the latest draw.
So if I click on number 2 in the cell,  all that the code is looking for is what were the past buddies , the code be set to cap upto 6 buddies maximum for now.
So similary when I click on number 3 in the cell, it will do the same thing, till I click (on all the 20 numbers) upto number 79 to look for upto 6 buddies in the draws depending on the draw period.

So now if the code looks at it this way, the alternate patterns, clusters is not needed.

Example of the first number 2 , that hit.
If say buddy of 2 was  2   11, then all buddies of 2 and 11 would be displayed upto 6 sets of buddies in the past draw which would be highlighted with another color than green.
But the possibility is number 2 could have many buddy groups, let's say after 2 11, it could be 2  25,  2  58   and 2  79.
So when I click on number 2 for its buddy (2  11) , the past 6 buddies will display with highlight color
But if I want to see the next set of buddies example 2   25,  you could add hold down Shift key +1,  similarly for  2  52 ,shift+2,
 2  79 shift + 3 and so on.
Now when we select number 3, the code will similary look for  6 past buddies and then apply the above example till all 20 numbers are covered.
But if there is no buddy on a particular number in the selected draw period, a pop would confirm that

Similar process for triplets, here if  hold control key + 1, control key +2 , etc could be used.
If the new tab could be called Tab two.






User generated image

Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Please attach your current workbook.

You do realize that lotteries use random numbers and that the randomness is tested on a regular basis.

If I flip a coin 49 times and get heads what are the odds on flipping heads on the next flip? it is still 50/50.. Same as the converse, because I got heads 49 times it doesn't increase the odds of a tails being the result increasing (its still 50/50)  


The results of previous draws does not change the odds on subsequent draws.


I realize this is not answering your question but don't use the results of this to influence your gambling pattern.  People that use these strategies are the casino's favorite customers. 

Avatar of simon
simon

ASKER

Workbook attached  29253815c 12 Feb 23.xlsb

I agree with David's comment and I think I suggested the same thing before. Given that, if you still want to continue with this I'm happy to help but it was my understanding via our EE messages that you wanted help with how you currently choose what you believe are the numbers that have the best chances of winning. This question doesn't do that and creating a new tab that replicates some of what is done on the 1 to 80 tab is too difficult.
Avatar of simon

ASKER

Based on the latest draw and clicking on number 2, following are the buddies for draw period 6feb to 12 feb. 


In row 4 , I selected , the first cell number 2 and then I visually saw  the buddy 2    3   have come 4 times within the selected draw period.


User generated image



Here is what I see.
User generated imageIgnoring the red numbers in row 2 which shouldn't be there when the Group is None, why is my result different from yours? I'm using the workbook you attached here.
Avatar of simon

ASKER

I don't know why it is different from yours.  I have done it manually to show an example



You attached two workbooks in this question. I was using the second one but now I'm using the first and what I see now is similar to your picture.

In row 4 , I selected , the first cell number 2 and then I visually saw  the buddy 2    3   have come 4 times within the selected draw period.
What do you do with that information?
Avatar of simon

ASKER

I quickly snapshot it and move on to the next one till I complete all the 20 numbers in the latest draw and then decide which is the best one to play.

Would a button on the 1 to 80 tab that would
  1. Copy your snapshots 1 by 1 to a new tab that looked something like this, and
  2. Highlight in green cases when a number in a snapshot repeats 4 or more times help?
User generated image
Avatar of simon

ASKER

User generated image

was there an example in that picture to view.

Avatar of simon

ASKER

Copy your snashot and Highlight in green cases when a number in a snapshot repeats 4 or more times help?

Open in new window

yes

Elsewhere you said (The bolding is mine)
So if I click on number 2 in the cell,  all that the code is looking for is what were the past buddies , you could set the code to cap upto 6 buddies maxium.
So similary when I click on number 3 in the cell, it will do the same thing, till I click on number 77 to look for upto 6 buddies in the draws depending on the draw period.
What number 2 are you referring to?
Avatar of simon

ASKER

Number 2 was the first hit of the 20 numbers that were drawn

Yes, but what did you mean when you said you "click on number 2"?
Avatar of simon

ASKER

Click on the cell that has number 2

I need a video.
Avatar of simon

ASKER

Ok

Avatar of simon

ASKER

video gif uploadedtest number 2 buddies.gif

Avatar of simon

ASKER

so in the first cell d4, the first number that hit was number 2 and I clicked in that cell  and this would automatically all number 2  3 buddies for the selected draw period

Okay, thanks,  now see what you are doing.

  • When you are done with 2 and 3 what do you currently do with the yellow numbers?
  • After you are done with 2 and 3 do you do the same for 3 and 4?
  • After you finish with 79 and 80 do you start over with 1, 2, 3 and then 2, 3 ,4 etcetera?
Avatar of simon

ASKER

  • When you are done with 2 and 3 what do you currently do with the yellow numbers?
    

    Open in new window

I take a snapshot and save it and then move to the next number 3 in the draw



  • After you are done with 2 and 3 do you do the same for 3 and 4?

yes , till I cover all the 20 numbers drawn.


  • After you finish with 79 and 80 do you start over with 1, 2, 3 and then 2, 3 ,4 etcetera?

No.  Because in the next draw of 12 Feb 23 , the numbers drawn started with number 4, then 6 as seen in below picture.  So in the draw below , I will look for number 4  buddies and so on

User generated image



Here is a preliminary version of what I propose to do. Click the Best Bets button on the new Best Bets tab. It currently takes 18 seconds to run on my PC.

In the results row 3 I have created pairs from the most recent 1 to 80 results and I have done the same for row 12.

In rows 4 to 9 I have copied 6 rows of data from the 1 to 80 tab and I plan on doing the same thing for the triplets.

I was planning on highlighting the buddies (for example 2  & 3) if there were 4 or more of them but with only 6 rows of data (rows 4 to 9) there are no cases with 4 or more buddies. Should I copy more than 6 rows and if so how many?
29254705.xlsb
Avatar of simon

ASKER

In the results row 3 I have created pairs from the most recent 1 to 80 results and I have done the same for row 12.

Through your prelim version, it seems  the code is only looking at adjacent pairs and not testing across the rest of the 19hits.


What I was looking for was the first number being checked across the 19 hits and then come with associated buddies for the first number 2, then 3 and so on as the chances for  testing adjacent buddies are slim.


For example if number 2 could check across all the 19 hits of the 20 numbers, then number 2 could have more buddies than just 2 3.



I was planning on highlighting the buddies (for example 2  & 3) if there were 4 or more of them but with only 6 rows of data (rows 4 to 9) there are no cases with 4 or more buddies. Should I copy more than 6 rows and if so how many?

So if you could make it to be based on the draw period that I select, that way the rows in the best bets tab would automatically populate based on my draw period selection.

Avatar of simon

ASKER

2    13  

2  58  


Since the code is checking only adjacent buddies, the above buddies would have got missed for the 6 draws


But in saying that the rows of best bets should populate depending on the draw period I select, otherwise there will be only 6 or 12 draws to test best bets.


Usually I test atleast 7 to 15 days worth of draws.

Okay I guess I wasted a lot of time. Please manually update the Duplets part to show how you want it to look including row 3. Don't worry about selecting or showing more rows for now.
Avatar of simon

ASKER

I manually updated the duplets for 2  3.

Here number 2 has 5 buddies 2  3  , 2  11,  2  14,  2  33 and 2  74,

But I did not highlight 2  74 as the picture would become large.

But because 2 would show up with multiple buddies at the same time

That is the why the shortcut was needed which then display only one buddy at a time,  2  3(3 duplets) ,  2  11 (2 duplets) and so on.

Example :  clicking in the cell 2 would display the first buddy 2  3 with all the buddies under 2  3 being color highlighted.


With cell 2 still selected, 

Shift key + 1 would display  2  11

Shift key + 2 would display  2  14,

Shift key + 3 would display  2  33

Shift key + 4 would display  2  74


User generated image

Example of Number 3 buddies


User generated image

Duplets are 3  2,  3  6 ,  3   31,  3  43

Please update the Best Bets tab.
Avatar of simon

ASKER

When I entered the duplets information , I visually missed out other duplets , so for 6 draws it turned out to be a separate of duplets below


I was also thinking instead of a Shift key +1 for 2  25 and Shift key + 2 for 2  58,

the other idea, was just keep pressing entering in cell to display a different buddy each time till you come back to the first buddy 2  3.


I select the cell number 2 and I click enter , it displays 2  3,  if I enter again then it would display 2  25 till I come to the last duplet 2  69 and then pressing enter again would come back to the first  duplet  2  3


2  3,   2  25,  2   58,  2  68,  2  69


User generated image





I'm sorry but I really don't understand any of that and since this workbook is incorrectly checking only adjacent buddies, there isn't any reason to pursue this approach.

I still really want to help you, so here is another idea. It currently looks like the Monitored Numbers section of the MG tab and it's ability to show Duplets and Triplets seems to be similar to what you want to do except that currently the numbers in AJ2 to BC2 are manually entered by you rather than reflecting the latest draw. Would it help if I added a button in the Monitored Numbers section that would fill in AJ2 to BC2 with the numbers from the latest draw? That button could be a toggle that after clicking the first time would show the numbers from the latest draw but if clicked again it would restore the previous numbers.

Here is a picture of what the results would look like after clicking the new Best Bets button, selecting Duplets, and then tabbing through the yellow buddies userform until you arrived at the 2 - 3 = 5 Times entry. Note that the numbers in AJ2 to BC2 are from the latest draw.
User generated image
Avatar of simon

ASKER

Would it help if I added a button in the Monitored Numbers section that would fill in AJ2 to BC2 with the numbers from the latest draw? That button could be a toggle that after clicking the first time would show the numbers from the latest draw but if clicked again it would restore the previous numbers.


Yes adding a button would help to populate numbers from latest draw.


 but if clicked again it would restore the previous numbers.

I have not understand this one.  But I am assuming the original set of numbers will stay on and in order to understand that I am uploading the latest results updated workbook updated till 14Feb 23 at 3pm.


At the moment this is original set of numbers 74,25...etc in mg tab, would that be retained, when the toggle button is used.

User generated image


Please apply the coding to latest updated results workbook. thanks

Updated workbook  :  29253815c 14 Feb 23.xlsb

What I'm saying is that if the monitored numbers were 74, 25, 19 etc like you show in the picture all those numbers would be replaced with the most recent draws numbers after clicking Best Bets. Clicking it again would restore 74, 25, 19 etc. Do you want the "restore" ability?
Avatar of simon

ASKER

Do you want the "restore" ability? 

yes

ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of simon

ASKER

That works . Thanks


Just was wondering if I need to input my numbers manually in the 20 cells,  would that also highlight the duplets and triplets using the coding of your duplets and triplets  




Avatar of simon

ASKER

User generated image

Getting run time error 424

Just was wondering if I need to input my numbers manually in the 20 cells...
Just do what you've always done and it will work the same way. When you click the Best Bets button those values (whether there are 2 or 3 or 20 of them) will be saved and then restored when you click the Restore MN button.

The run-time error does not occur in my workbook so please attach yours.
I edited my previous comment.
Avatar of simon

ASKER

the runtime error did not come this time, it comes randomly.  If it comes again , I will click on debug so atleast I can take a picture of that error.


Meanwhile I was wondering since all tabs in the workbook are interconnected ,  how do I pull out a tab to display it on one monitor while I look at another tab in the workbook on the second monitor  in order to avoid tabbing back and forth constantly

Avatar of simon

ASKER

I get two errors in below picture when selecting the draw period on main tab


User generated image


User generated image


Avatar of simon

ASKER

Workbook attached to check the error


29254705a 16 February 10 am with best bet button.xlsb

I can't reproduce the error but I added a line of code that I hope helps.

As for multiple monitors I'm pretty sure it can be done but I have no idea how, so you'll need to ask a new question for someone else to answer.
Avatar of simon

ASKER

I can't reproduce the error but I added a line of code that I hope helps.

do you have the upload ?

Avatar of simon

ASKER

Thanks for upload


As for multiple monitors I'm pretty sure it can be done but I have no idea how, so you'll need to ask a new question for someone else to answer.

ok will do.

 


Just do what you've always done and it will work the same way.

In your above comment you said and that works, but the highlight does not go down the sliding way, when I input numbers manually in monitored numbers group.


Example of sliding highlights which your one does.

User generated image


Next sliding highlight .  13   56  is next row sliding higlight

User generated image


I did nothing except to fill the monitored numbers from the most recent WNR draw when you click the Best Bets button, so except for that it is working the same way as it always did.

In any case what you show in the pictures is correct since in the second picture the first green cell is further from the top than in the first picture.
Avatar of simon

ASKER

ok I will retest for today and see how it goes and hopefully everything is as you said. thanks

Avatar of simon

ASKER

run time error 1004 popping  up and cells are missing only the numbers are visible. this happened after I udpated to today's 10 am draw.

User generated image


User generated image

workbook attached  :  29254705b 17 feb23.xlsb

Avatar of simon

ASKER

I  had to dump the runtime error workbook and download a fresh copy of your B file and had to manually udpate the draws again.

And so this new downloaded copy worked ok after manually udpating the results.

Strange why the other workbook caused run time errors and made the cells missing

As the messages are trying to tell you, you first need to close the time filter on the MG tab and then Select Draws on the Main tab.
Avatar of simon

ASKER

I always do, since the pop up informs me too.

Okay but in the workbook you attached, you hadn't.
Avatar of simon

ASKER

ok will keep a watch on the pop up.

Avatar of simon

ASKER

User generated image

ok the same run time error has come up again , all I did was select the draw period and clicked ok and then error 1004 popped up.


User generated image


I have been selecting draw period for a long time now without errors, So not sure what went wrong?


All I did was update the 1pm draw manually and then select the draw period

It is a complete mystery to me why such a simple, standard, line of code should fail. I did some research and found that other people have experienced the same problem and one solution was to use Excel's Repair function to repair the problem workbook. I did that in the attached workbook.
29254705c.xlsb
Avatar of simon

ASKER

I downloaded your  "c" file.

I manually updated the workbook to 17 Feb 23 at 6pm.


Now all I did was in the main tab, I selected the draw period 17 Feb 23 to 8 Feb 23  and clicked ok button,  but the run time error 1004 popped up again.

 Below is the picture 

User generated image


User generated image


Also how do I get rid of the below menu bar, it is very annoying whenever I open the excel file the menu bar also switches on, this has never happened before.   Menu bar in below picture


User generated image



This workbook contains the last thing that I can think of to do. With this code if there's an error you won't see it, but C2 to L2 probably won't clear. If that's the case you'll need to clear C2 to L2 manually.

If the menu bar is still a problem you can drag it down (or up) one row, or drag it off the workbook entirely.
29254705d.xlsb
Avatar of simon

ASKER

 that's the case you'll need to clear C2 to L2 manually.

which tab is that  which I need to clearly manually.

And do I clear it before the manual update or after ?

The MG tab.

And do I clear it before the manual update or after ?
After the update if you go to the MG tab and the "Continuous" section doesn't look correct you'll need to update it manually. Or you could just clear C2 to L2 manually before the update.
Avatar of simon

ASKER

the mg tab was blank when I checked.


So I updated the draws manually till 17 Feb 6pm


So the problem occurs when I select the draw period and click oK.


The first time the workbook got busy and closed by itself and that is strange.


and the second time when I tried again, the workbook is frozen and unusable.


So I am attaching the manually updated workbook.


29254705d 18 Feb for 1pm.xlsb


Also giving the last file update upto 15 Feb 23 from the lotto server


54f3625e-ad6e-11ed-bd7d-005056819165  (update tilll 15 Feb 23)


I have no idea what to do about that. All I can suggest is that you close Excel completely, reopen the "d" version and try again.
Avatar of simon

ASKER

all the uploads till "d" version for some reason have gone faulty with errors and I did what you said closing excel and opening again , still the problem.


A few comments ago you had uploaded "a" file with best bets button and that is working ok after doing all the manual updates.  

all the uploads till "d" version for some reason have gone faulty,,,
That sounds like a problem at your end so reboot.