4n to create keys from full range

We need all of them to appear as we can solve that defect since that is the basis of everything that we are making comparisons if they fail I do not have a real cross as I need it

To your best understanding and experience, what is causing that failure?

the keys are not created !!

the keys are not created !!

What do you mean?

ok  i see you did top pairs

we need then TRI KEYs

Great Job Best Expert

lets do TRi then 

Please don't ask the tri question yet.

ok i won't 

For Pair Top the user is asked to choose between pairs that occur two or more time or 3 or more times. In a week like 6W2012  no pair occurs more than once. What should that week (including TK and LK) look like?

Para Pair Top, se le pide al usuario que elija entre pares que ocurren dos o más veces o 3 o más veces. En una semana como 6W2012, ningún par ocurre más de una vez. ¿Cómo debería ser esa semana (incluidos TK y LK)?

ok give an chance

How many times does 81 occur in 8813? Once or twice?

And yes, I was incorrect when I said that no pairs occur more than once, but if you are looking for pairs that occur more than 2 (or 3)  times and there aren't any, what should the week look like?

¿Cuántas veces aparece 81 en 8813? ¿Una o dos veces?

Y sí, me equivoqué cuando dije que no hay pares que ocurren más de una vez, pero si estás buscando pares que ocurren más de 2 (o 3) veces y no hay ninguno, ¿cómo debería ser la semana?

How many times does 81 occur in 8813? Once or twice?

i see it twice

but if you are looking for pairs that occur more than 2 (or 3)  times and there aren't any, what should the week look like?

none

 Assuming TK or LK is blank do you want to be able to search for the blank TK or LK?

not

In your picture you show results for WED PM. Is that a part of Pair Top?

yes is PAIR TOP from WED PM  to SAT PM

That doesn't seem right to me. If WED PM is a part of Top the that means that of the 12 periods 7 are Top and 5 are not. Shouldn't it be 6 and 6?

Eso no me parece correcto. Si WED PM es parte de Top, eso significa que de los 12 períodos, 7 son Top y 5 no. ¿No deberían ser 6 y 6?

forgive me, I don't understand what you're saying

can you pic it ??

i count only pairs in week  6W2012
from MON Pm to SAT pm

I guess I'm confused. I thought that at some point you agreed that MON to WED would always be blank, but maybe that was some other type of count.
Supongo que estoy confundido. Pensé que en algún momento estabas de acuerdo en que de MON a WED siempre estaría en blanco, pero tal vez ese era otro tipo de conteo.

i just count the pairs PM  because in that week not   AM avaliable

In this question of yours I asked "Is it true that MON, TUE and WED will always be blank for PAIR TOP?" and you answered "Yes", so why are you showing counts in WED PM?

En esta pregunta tuya, pregunté "¿Es cierto que MON, TUE y WED siempre estarán en blanco para PAIR TOP?" y respondiste "Sí", entonces, ¿por qué estás mostrando recuentos en MIÉ por la tarde?

Sorry, I did not understand the question

couples are counted all the time from MON to SAT

What often happens is that no couples of more than two are seen until Wednesday

but there may be situations where they exist before

For me to count the pairs is to turn them into ORD, you do the pairs and count them looking for those who are repeated on more than one occasion

remember that this part of PAIRS TOP

We look for couples that repeat themselves no matter the day

I've attached the workbook where we first did Top Pair. Is it correct or not?
Adjunté el libro de trabajo donde hicimos por primera vez Top Pair. ¿Es correcto o no?
29218781c.xlsb

when you compare the 6W2012 week from 29218781c.xlsb 

and the pic i send

you see my pic is more complete

we have to count the pairs as in the pic here

because we are misssing information

the  correct count give us  the   right  moment so we cando an hit

Is 29218781c.xlsb correct or bot?

pairs top count in 29218781c.xlsb   is not correct

Your picture confuses me because the heading says "3 or more times" but in your arrow it says "2 times appear". In any case here is what I get when I ask for 2 or more times
and here is what I get when I ask for 3 or more times.

I understand that certain columns should be blank and I'll take care of that later.

For 3 or more I don't find any pairs that occurs 3 or more times for WED PM. If you do find 3 or more please show or tell me what they are.

For WED PM should I look in the ORDs from 70 to 75 or in 70 to 76. (I know that in this case both 70 and 76 are blank)

This is the correct for 2 and more

remember 2 and more include 3 times too

3 times and more not include 2 times 


in this pic i have 2 times and more

2 ≥ = to the pic for                6W2012




this is what i have to achive for 2 and more


i have not yet do 3 and more

Please answer this question

For week 6W2012 WED PM should I look in the ORDs from rows 70 to 75 or in rows 70 to 76. (I know that in this case both 70 and 76 are blank)

week 6W2012  is from rows 70 to 81  

(Mon PM to SAT PM )

I'm asking you to tell me which ORDs I should look at in order count the pairs for WED PM.

I look here 

then

 

in WEDNESDAY we have 

88
88

so we count the pairs 8 is 4 times

so

 

in descending

I am completely confused. Are you saying that for WED PM I include Tuesday? Let's talk about a week that doesn't have blanks like 26W2013. For each of the 12 periods for that week please tell me the range of rows I should search for each period. By "period" I mean that MON AM is one period, MON PM is another, TUE PM is another etc.

Estoy completamente confundido. ¿Estás diciendo que para el miércoles por la tarde incluyo el martes? Hablemos de una semana que no tiene espacios en blanco como 26W2013. Para cada uno de los 12 períodos de esa semana, dígame el rango de filas que debo buscar para cada período. Por "period" me refiero a que MON AM es un período, MON PM es otro, TUE PM es otro, etc.

HERE how to do it ...

you have to be a cumulative account per week

MON + TUE + WED + THU + Fri + SAt

And it is!

for 6W2012
so what do you say

Mon = have repeat pairs?
not
then TUE = MON + Tue are repeat pairs?
not
  then WED = MON + Tue + WED are PAIRS repeat?
yes then count the PAIRS

count 2 and more
or 3 and more

then
THUR = MON + TUE + WED + THU are repeat pairs


count 2 and more
or 3 and more

then FRI = MON + TUE + WED + THU + FRI are repeat pairs

count 2 and more
or 3 and more

then SAT = MON + TUE + WED + THU + FRI + SAT

count 2 and more
or 3 and more

By "period" I mean that MON AM is one period, MON PM is another, TUE PM is another etc.

you have to take week by week

when in the week

you have to count each ocurrence by day am/pm  then you have to count cumulative


after week 26W2013
first ocurren in each week is MON AM

so

MON AM =2839   are PAIRS REPAT ? no

then

MON PM = 2839 +2619 = are PAIRS REPAT ?     YES  29, 2 times  then we shows the count COLUMN in MON PM for TOP PAIRS

as shows

 MON PM 



then

TUE AM = 2839 + 2619 + 8579 = are PAIRS REPAT ?  YES  PAIRS 29, 89

then we shows the count COLUMN in TUE AM  for TOP PAIRS for 2 and more

as shows

  TUE AM 

Thanks.

;)

For 26W2013 counting 2 or more  I get this which agrees with the results you described for MON AM through TUE AM.
Para el 26W2013, contando 2 o más, obtengo esto que concuerda con los resultados que describió para el LUN AM hasta el TUE AM.
But for 6W2012 counting 2 or more I don't agree at all with what you show.
Pero para 6W2012 contando 2 o más, no estoy de acuerdo en absoluto con lo que muestran.

So let be verify something with you. Let's assume that in WED PM for some week that the pairs that occur 2 or more times are
Así que verifiquemos algo contigo. Supongamos que en WED PM durante una semana los pares que ocurren 2 o más veces son
29
33
59
49
Am I then supposed to count the digits in those pairs and find out that
¿Se supone que debo contar los dígitos de esos pares y descubrir que
9 occurs 3 times
3 occurs 2 times
4 occurs 1 time
5 occurs 1 time
2 occurs 1 time
8 occurs 0 times
7 occurs 0 times
6 occurs 0 times
1 occurs 0 times
0 occurs 0 times

and then show 9 and 3 as the first two results in WED PM?
y luego mostrar 9 y 3 como los dos primeros resultados en WED PM?

and then show 9 and 3 as the first two results in WED PM? 

yes!!

A situation that is happening is that the couples repeat themselves and we have to count them repetitions example

suppose that a place occurs

3 times

26
26
26


that pair 26 gives 2 = 3 and 6 = 3


is not 2 = 1 6 = 1

because we need to count the repetitions literally

do not summarize them

That's good. Please look at my results for 6W2012 MON PM and tell me if anything is wrong.

example

 


in WEDNESDAY we have

88
88
80
80

so we count the pairs
8=6
0=2


 

so

 

your 6W2012 is not good

this is the correct

so we count the pairs 8 is 4 times  = 8 =4

Please say that in a different way.

for THU we have

88
88
81
80
80

8=7
0=2
1=1

if you see i did an mistake
in  WED  at first i did not count 80 as an repeat pair but it is repeat

but is an repeat pair i did the correction

ok i see what you  means

8813

88
81
83

because they repeat 

you rigth

sorry my mistake  you rigth

i was only count 88 

this is rigth  because you take all pairs in count

from the first one

You did great JOB

sorry i was focus at some pairs like the 88 i lost the focus with  the others

you in the rigth track

Okay, I will make the same changes to the triples.

ok

one little detail is

in range  Top KEY  is rigth  and TOP LOW is rigth


but in PAIRS   should be inverse and TRi too

TK  is the first rows  and TL is the lowest rows

Have this situation

need th have the real key to be use to compare but is not

can be repair?

That's been that way for a long time and since you didn't say anything out it I thought you wanted it that way. I'll change it but first let me know if the triples ae correct.

 ok triples are ok 

need create in FKEYS sheet the keys HORI and VERTI
for  RANGE , PAIRS TOP  , TRI TOP  with one button for eachone

as we did for WEEK TOP NUM

Please ask a new question.