please, rate the pick 3 under the 8 conditions.

jack

Member
please, rate the pick 3 under the 8 conditions.
we have, then 8 conditions of the standards each pick
* will always have two standards, we have 16
http://www.mediafire.com/file/kkq34145arw345e/8_padroes.xlsx
 

jack

Member
hello, ok on the draw list, of course it will be placed
* more draws every semama, the macro, will identify, in which pattern
* this present, then identify the pair of patterns, and see in the doubles the hot and cold
(most drawn and least drawn)
objective = filter by patterns in arrears in a given number of drawings.
* You have to look at the table of 4 patterns.
 

Frank

Member
hello, ok on the draw list, of course it will be placed
* more draws every semama, the macro, will identify, in which pattern
* this present, then identify the pair of patterns, and see in the doubles the hot and cold
(most drawn and least drawn)
objective = filter by patterns in arrears in a given number of drawings.
* You have to look at the table of 4 patterns.



https://www.mediafire.com/file/cz9g5cjd71ye20h/8_padroes.xlsm/file
 

jack

Member
hello frank, very good job, conglatulations
* What does eeehhh mean?
* When you want to put something, feel free.
* I have this doubt what is eeehhh please
* Great job, congratulations, thank you.
 

Frank

Member
E = Even , 1 = yes. H= High . 1= Yes.

EEE ( 111) is 3 evens. If it’s not even , it is odd. If it’s not high it is low.

Just part of the logic Excel is working with. You can hide those columns if you don’t want to see them.
 

jack

Member
hello, frank sorry forgot, why, if I want to locate the pair in positions
* example we have 4 patterns = 2 pairs one odd, two odd and one pair and two high and one low
* and two bass and one high these 4 patterns, I can locate in the positions of the doubles
* 1.2 1.3 2.3
* example = no two pairs and an odd
* 496 = position 1.3 for the pairs
so I can locate them in the correct position under the pick3 and locate the pattern itself
* Can you do just this? please
* tell me if you have doubts
 

jack

Member
hello frank, when I copy and paste the list of draws, a list of 600 drawings
* and I'm going to paste the formulas of the error, will I have to enter each draw?
Can you fix this? ie I will copy and paste the formular does not work, only when I type each draw, please
 

jack

Member
3 5 9 1 1 1 1 1
7 7 1 1 1 1 1 1
6 5 3 1 1 1 1 1 1
2 3 4 1 1 1 1 1 1 1
2 1 3 1 1 1 1 1 1
0 8 0 1 1 1 1 1 1 1 1
2 9 1 1 1 1 1 1 1
2 8 3 1 1 1 1 1 1 1
9 2 4 1 1 1 1 1 1 1
5 3 8 1 1 1 1 1 1
8 9 4 1 1 1 1 1 1 1
5 7 3 1 1 1 1 1
1 3 9 1 1 1 1 1
1 4 4 1 1 1 1 1 1 1
9 7 2 1 1 1 1 1 1
3 0 0 1 1 1 1 1 1 1
8 0 7 1 1 1 1 1 1 1
7 5 2 1 1 1 1 1 1
9 9 2 1 1 1 1 1 1
6 3 0 1 1 1 1 1 1 1
8 6 5 1 1 1 1 1 1 1
8 3 9 1 1 1 1 1 1
2 5 0 1 1 1 1 1 1 1
0 0 5 1 1 1 1 1 1 1
9 6 8 1 1 1 1 1 1 1
1 9 5 1 1 1 1 1
8 6 3 1 1 1 1 1 1 1
8 5 4 1 1 1 1 1 1 1
7 5 4 1 1 1 1 1 1
5 0 3 1 1 1 1 1 1
0 1 2 1 1 1 1 1 1 1
4 1 5 1 1 1 1 1 1
4 3 5 1 1 1 1 1 1
5 9 4 1 1 1 1 1 1
 

Frank

Member
hello frank, when I copy and paste the list of draws, a list of 600 drawings
* and I'm going to paste the formulas of the error, will I have to enter each draw?
Can you fix this? ie I will copy and paste the formular does not work, only when I type each draw, please

Well I just did the same thing pasted 600 results and it worked perfectly.

You dont say what error you are getting. That might have helped.

The version I uploaded only had formulas entered up to row 29.
The formulas are from column E to column U, make sure you copy all the formulas down as far as you need. If you did hide columns E:J dont forget they still need formulas in them!

Make sure that your data has 3 digits, one digit per column and you only copy 3 columns. When pasting, paste values and check that after pasting in they are still one digit per column.

Check you abide by these rules and it should work !
 

Frank

Member
hello, frank sorry forgot, why, if I want to locate the pair in positions
* example we have 4 patterns = 2 pairs one odd, two odd and one pair and two high and one low
* and two bass and one high these 4 patterns, I can locate in the positions of the doubles
* 1.2 1.3 2.3
* example = no two pairs and an odd
* 496 = position 1.3 for the pairs
so I can locate them in the correct position under the pick3 and locate the pattern itself
* Can you do just this? please
* tell me if you have doubts

You are talking in riddles. I have not got the faintest idea what you just said. Sorry.
 

jack

Member
ok frank, thank you for seeing, but the positions are like this
* example = 469 we have here the pattern two pairs and an odd
* the question in which position is the pair of pairs? she is in position1ª,2ª
* of the 3 possibilities
1ª2ª3ª
* 4 9 6 = in this example this 1ª.3ª
946 this 2ª.3ª
* so I can locate in which positions the two even digits
* doubts?
 

Frank

Member
ok frank, thank you for seeing, but the positions are like this
* example = 469 we have here the pattern two pairs and an odd
* the question in which position is the pair of pairs? she is in position1ª,2ª
* of the 3 possibilities
1ª2ª3ª
* 4 9 6 = in this example this 1ª.3ª
946 this 2ª.3ª
* so I can locate in which positions the two even digits
* doubts?

So by pair you mean EVEN ?

So 496 has EVEN numbers in positions 1 and 3 ?

You do NOT want to know where the ODD numbers are ? just the even ?
How do you want the result displayed ?

496.............. 1.3 ?
 

jack

Member
hello frank yes, you're correct, let's give an example
You chose the default two odd and even
but now you want to know what position pairs have!
* well we have 3 conditions for the pair pairs, low odd and high pairs under the pick3
we have = 1ª 2ª , 1ª 3ª and 2ª 3ª
* so a position filter is created inside the pick3 in the base
then = opt for the pattern two pairs and one odd in the 1st position
* I'm only going to use the pairs = 0,2,4,6,8 in the positions of 1st and 3rd
logically the digit of the remaining position the 2nd will be odd1,3,5,7,9
* and so on the low ones, only when we have 2 digits for one
objective is to locate the pair, in its 3 possible positions
* you can create a topic of two odd and two odd and one pair
* and two high ones one low and two lows and one high in the positions 1ª 2ª 1ª 3ª 2ª 3ª
* has to create 4 topics next, as it will help me to filter by position
 

jack

Member
so only the doubles will be positioned inside the pick3, consequently the 3rd digit also, example
* 469 the odd digit (9) is in the 3rd position, but could be in the 2nd and 1st position, let's see only the double
that automatically the 3rd digit is positioned, so it will work with the standard and in the positions, creating a reference for very good filters! and so by column in excel you will be able to see the delays
 

Frank

Member
Sorry, cant be bothered with silly superscripts, too complicated to do within formulas.

159
680
115
894 1a3a
6
89 1a2a
463 1a2a
159
896 1a3a
093
183
482
344
2a3a

Why the silly 'a' s anyway ?? They add nothing useful.
 

jack

Member
hello frank, ok this is correct you can create 4 topics
* 1st item 1,2 1,3 2,3 for two pairs and one odd
* adds a lot in the filtering because you know which position will be the pair,
* example you choose the default two im pairs and a pair
* but in which positions will the odd pair go? na 1,2 1,3 2,3
* consequently the digit pair goes in the rest, for the doubles there are only three positions for the doubles in the pick3, note that the digit shows the pattern but does not show the positions of the pair understands!
 

jack

Member
I'll give an example = you chose
* the default, two low and one high
* What is the paosiçao of the pair of highs? 1.2. or 1,3! or 2,3
* inside the pick3, this helps to identify the positioning
in delays, to filter already in the choice, this facilitates the filtration by position, will be very useful for when you do not want to play with the three conditions of the doubles
 

Frank

Member
I wish you would stop posting. The more you post the less I understand. I am totally confused, I have no idea what you want, you ve moved from positions of evens to highs and lows. I give up.
I'm out.
 

Sidebar

Top