detect the smallest with the highest number in each sector, forming two pairs
https://www.excelforum.com/attachmen...1&d=1586555398
detect the smallest with the highest number in each sector, forming two pairs
https://www.excelforum.com/attachmen...1&d=1586555398
Hi jorel,
What changes in your problem? Do you get to color the boxes? Does the columns of data change? I just don't understand the problem yet. I need more explaination.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
hello MARVINP ok, thanks for viewing the post,
* we have a lottery 01 to 25 (lotofacil)
* where 15 numbers are drawn, the draws
* are registered in the list on the left,
it was divided into two sectors one yellow the other green
* the macro will see in each draw line,
* the smallest and largest number in each sector will then have two pairs
* what is the purpose of this? = is to have the smallest and largest number in each sector, to then complete the 15 numbers within the limits of the smallest and largest numbers
How are the sectors determined? Is it always the 1st number yellow then the 8th number green for low and the 10th and 15th for yellow and green for high numbers?
no, see, the yellow sector was divided into two lines and two columns, there were 9 numbers left in the green, a draw has 15 on average, but it varies we have 9 in yellow and 6 in green, look at the edges in the matrix and in the draw, they show in the 1st draw the numbers
* smaller 02 ......... larger 16 and so in the other sector13 .... 25 let's assume that in the sector seeing the largest number was 23 would be 13 ... 23,
* then you set up the two pairs in the list on the side
if I know the two pairs then I will put the rest of the numbers within the limits of each sector
Hi jorel,
Give me 4 rows with 15 numbers and show me the result that you want. I'm still clueless on what process you use to get your outcome. It still looks like you want in yellow (1st number, 10th number) and for green (8th number, 15th number).
I don't get the other stuff in the middle.
ok hello=https://www.excelforum.com/attachment.php?attachmentid=671838&stc=1&d=1586562040
helo
setor 1 setor 2
01 13
02 14
03 15
04 18
05 19
06 20
07 23
08 24
09 25
10
11
12
16
17
21
22
you can put in two lists
* the yellow sector and the green sector,
and compare each row of 15 numbers
* which is the smallest and largest number in each list
* forming two pairs of smaller and larger, easy
Hi jorel,
I've put my answer in your workbook (attached). Tell me why it isn't correct.
ver a maior emenor dezena por jorel.xlsx
hello MAVIMP we have an error the numbers 11 and 12 are from the yellow sector, it is not part of the green it cannot start
* the green double, because 11 and 12 are in yellow
02 12 10 24
02 19 12 25 error 10,11,12 setor yellow
01 12 10 25
03 14 11 23
01 18 14 25
helo
setor 1 setor 2
01 13
02 14
03 15
04 18
05 19
06 20
07 23
08 24
09 25
10
11
12
16
17
21
22
Sorry jorel,
I'm passing this off to someone who might understand the question better than I do. I have no idea how you get your "sectors" and hope someone else will understand it.
sectors, are the division of two groups,
group A (YELLOW) and groupB (GREEN) because the number 12 is in green ??
hello,MarvinP the error is because you chose the same column to assemble the pairs, that's why it's wrong
* you have to choose the smallest and the largest number
* corresponds in each sector within the line of each draw
Hi jorel,
Rows go from left to right. Columns go up and down. I saw this problem as giving 15 numbers in the same ROW. I asked how you got those colors and I never did understand it. You have yellow and green cells but I don't know how you determined them. It may seem obvious to you but I just don't see how the sectors are selected. I gave you my first answer with a pretty easy down a COLUMN and you said I was wrong.
I put this question out to everyone and it hasn't been solved or even been replied to from anyone else. Can you explain what you are trying to achieve again?
hello MARVINP thanks for the effort, when you understand it will be clearer and easier,
let's take it easy inside the 5x5 matrix, we have
* there are two groups represented by two colors, yellow and green, in yellow we have 16 numbers
and in green the remaining 9 numbers, when a draw passes through the matrix, it will always leave the smallest and largest number in each sector - there are 4 numbers after the other 11 numbers are completed, but I need to define, the two doubles,
then within the doubles limits I will complete
* the 15 numbers, in your example you put in the same column as the example is wrong, you have
* look inside each color the 1st and last number of each color
Hi jorel,
I see in your example spreadsheet in the Q-U Columns 5x5 square; you have the numbers 19 and 20 missing. Is that by mistake?
01 02 03 04 05
06 07 08 09 10
11 12 13 14 15
16 17 16 17 18
21 22 23 24 25
Here are the numbers in that rectangle and you have 16 and 17 twice and no 19 or 20. Did you mean to do that?
Last edited by MarvinP; 04-11-2020 at 09:04 PM.
Possibly...Please Login or Register to view this content.
Last edited by dangelor; 04-11-2020 at 11:37 PM.
hello,MARvinp yes sorry, there is a mistake,
* the correct is 18 19, you are right,
* I hadn't seen this repetition error, bah
* the corret is 18 19
corret
01 02 03 04 05
06 07 08 09 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25
hello,[COLOR="#FF0000"]Dan[/COLOR]gelor, very good work, it is working correctly, when you win a prize you will be rewarded thanks for the hard work
hello, dangelor, ok thank you!!
IF you win a prize ... And if you do, it will be pure luck.when you win a prize you will be rewarded thanks for the hard work
Please mark the thread as solved.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
hello ALI, think positive, these statistics in excel alone agree
* with you, but when it crosses with other statistics it changes, look at the corona, he alone
* it's nothing, but when it penetrates or crosses with another in this case the cell, then it almost ends up with the world,
* for some it's over, what I mean is that
* statistics and crossed patterns, everything happens,
this data serves to have a panoramic view of the central range of the gauss curve, of course for several
* events or sweepstakes, if it's just for one event
* there luck enters the 80/20 now for several draws
* will 20/80, when i win will i be rewarded?
* thanks ALI
Glad to help!
What statistics? You can 'prove' anything with statistics.these statistics in excel alone agree
You are sadly deluded. No lottery draw is influenced in any way by any previous lottery draw - it's absolutely the luck of the draw every time, and nothing else, that will determine which numbers are drawn. However, if you want to generate these rows of numbers for fun, or as an academic exercise, there's no harm in that, it just won't help you win a lottery and you should stop believing it will. I'll bet I've won more on the lottery with my weekly lucky dip numbers than you have with your carefully crafted ones.
Have fun!
Hi jorel,
So I've got about a hour of work on your problem and you gave me the matrix wrong?
I'm not working on your problems again!
I am glad someone ignored your matrix and gave you a VBA answer. Hope you lotto goes well but I won't be playing.
ok,ALI but think of a filter where patterns happened in a certain number of previous draws, then excel can generally match the patterns that most often happen, in the central range of the gauss curve, that is, it will be different games but with the same patterns of greater frequency
* one hour the patterns will repeat
Jorel - you can find patterns in any random series of numbers if you look hard enough. No sequence is any more likely to repeat than any other, so looking for these patterns is a complete waste of time. But as I said, if you want to do it just out of curiosity, that's your prerogative.
If the patters repeat then the randomness of your random number generator aren't very good. Here are some tests to give your lotto.
https://www.drdobbs.com/testing-rand...tors/184403185
https://ezinearticles.com/?How-To-An...tem&id=8662808
ok MARVINP,very good article, the great difficulty in lotteries is to find a reference point, or a base, we can then using the drawings already passed
* to filter, see patterns, and repetition counts etc, to set up up to 80% of the bet line = example in a 49/6 lottery the set of 4 numbers, the other two can give a maximum prize, the important thing are secondary prizes frequently
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks