select data in 3n prs

Why are those cells different colors?

Where do the numbers in columns DI:DK come from?

MArtin

Where do the numbers in columns DI:DK come from?

the source column is AY

I understand that, but why are some of them green and some of them violet?

Martin

I understand that, but why are some of them green and some of them violet?

what need to achive here  is

as an DDBRO number is true

then

1) Why do you need the numbers in columns DI:DK?

2) If I understand you correctly, week 1 shows the results of weeks 1 to 3. What is the next range to look at? Is it weeks 4 to 6 or is it 2 to 4?

1) Why do you need the numbers in columns DI:DK?

well as i try to explain  as better as i can
i show it this way

If I understand you correctly, week 1 shows the results of weeks 1 to 3. What is the next range to look at? Is it weeks 4 to 6 or is it 2 to 4?

remember when an DDBRO appea  in the 13 row set  it make the point to establish the first week then the sencond week and 3 week

DDBRO is the base to follow

If what you want to do is highlight the cells in the DDBRO and DBRO areas then you don't need columns DI to DK.

2) If I understand you correctly, week 1 shows the results of weeks 1 to 3. What is the next range to look at? Is it weeks 4 to 6 or is it 2 to 4?

Please answer with either "4 to 6" or "2 to 4".

Si lo que quiere hacer es resaltar las celdas en las áreas DDBRO y DBRO, entonces no necesita las columnas DI a DK.

2) Si lo entiendo correctamente, la semana 1 muestra los resultados de las semanas 1 a 3. ¿Cuál es el próximo rango que se debe analizar? ¿Son las semanas 4 a 6 o son de 2 a 4?

Responda con ya sea "4 a 6" o "2 a 4"

2) If I understand you correctly, week 1 shows the results of weeks 1 to 3. What is the next range to look at? Is it weeks 4 to 6 or is it 2 to 4?
Please answer with eather "4 to 6" or "2 to 4".

Martin i don't undestand this question


each DDBRO beging an new range of 3 weeks foward

OK let me ask the question in a different way.

I assume that the cells in week 1 are highlighted based on the content of weeks 1 to 3. Are the cells in week 2 highlighted based on the content of weeks 2 to 4?

Supongo que las celdas de la semana 1 se resaltan en función del contenido de las semanas 1 a 3. ¿Se destacan las celdas de la semana 2 en función del contenido de las semanas 2 a 4?

this the range of weeks for number 299

That totally confuses me. I was looking for a simple "yes" or "no" answer,

Martin

That totally confuses me. I was looking for a simple "yes" or "no" answer,

patiente

the reason i dont answer is because i dont undertans the question

but each  DDBRO have his own weeks cycle

Martin
 i have problems to explain this

remember each number that appear in DDBRO comes out because it have an repeat digit

in  the source column  AY

I don't know how to be any clearer, but let's back up a bit.

Is the purpose of this question to highlight the cells in columns CX to DG? Please answer yes or no.

No sé cómo ser más claro, pero retrocedamos un poco.

¿El propósito de esta pregunta es resaltar las celdas de las columnas CX a DG? Por favor, responde sí o no.

Martin

Is the purpose of this question to highlight the cells in columns CX to DG? Please answer yes or no

Yes

I can do that without putting anything in columns DI to DK. Is that OK?

Martin

Yes. That will be Great

A while back you said "the source column is AY" and I agreed but the source is actually CG, correct?

Martin

while back you said "the source column is AY" and I agreed but the source is actually CG, correct?

Yes ,

OK., let me ask you these questions. Why is cell CX13 green? Is it because "24" appears in column CG for that week? If so why is DC13 pink since "79" is also in column CG for that week?

 I have some other things to do but I'll be back later.

OK., let me ask you these questions. Why is cell CX13 green? Is it because "24" appears in column CG for that week? If so why is DC13 pink since "79" is also in column CG for that week?

is not because that


let focus in column AY

when  number 299  ( im interest in numbers with repeat difgit like 99 in this number )

then i will have 3 weeks foward


then when number  669 hit  ( it have 66 repeat digit)

i will have 3 weeks foward   but  his 3 weeks dont have nothing  with the weeks for number 299


each repeat digit have his own week count  indpendet from each other

so 677 will have his own 3 weeks count and don't have nothing to be with  number 299 or 669

Are you saying that you believe that currently there is processing that spans 3 weeks?

¿Estás diciendo que crees que actualmente hay un procesamiento que se extiende por 3 semanas?

Are you saying that you believe that currently there is processing that spans 3 weeks?

for example lets take numbers 299

these are the pairs that comes from 299  = 24      27      29      47      49      79


then i need check  for 3 weeks (inside these 3 weeks)

if any combination appear

and  get marked  is in week 1  , week 2 or week3  after 299 hit

Are you saying that you believe that currently there is processing that spans 3 weeks?

i can say an compare in an 3 weeks range for an number with 2 digit repeat

Are you saying that you believe that currently there is processing that spans 3 weeks? Yes or no please.

may  I ask what you mean with an processing??

because dont understand that

i can say that in an 3 weeks outputs relatives will show

I'm not asking about the future. Do you believe that in the workbook that you attached that the results in CX13 to DC13 come from more than one week?

Do you believe that in the workbook that you attached that the results in CX13 to DC13 come from more than one week?

no

We're making progress now:)
I see that cell CX13 is 24 and it's green and that cell DC13 is 79 and it's pink is pink. Why is that since both are in CG13?

I see that cell CX13 is 24 and it's green and that cell DC13 is 79 and it's pink is pink. Why is that since both are in CG13?

No

I see that cell CX13 is 24 and it's green and that cell DC13 is 79 and it's pink.  Both 24 and 79 are in CG13, so why is one green and one pink?

Veo que la celda CX13 es 24 y es verde y que la celda DC13 es 79 y es rosa. Tanto 24 como 79 están en CG13, entonces ¿por qué uno es verde y uno rosa?

Martin

well i see you don't undertsand me

not either my pic

i explain alredy where it comes from

I'm talking about the workbook you posted.
 

i explain alredy where it comes from

If I understood your explanation I wouldn't be asking.

Martin
can you  understand me with this

we are talking about one week for number 299

is ok ??

can you  understand me with this

No, I can't because 79 is in the same week (in cell AY17) so why isn't cell DC13 green instead of pink?

No, I can't because 79 is in the same week (in cell AY17) so why isn't cell DC13 green instead of pink?

when number 299 appeaR   it create his DDBRO and DBRO

then

 i need follow his 1 week  (green color)

then his 2 week ( pink color)

and  his 3 week ( blue color)

is any of the numbers that DDBRO associated to 299 appear in the  1week to 3week

But you haven't answered my question. 79 is also in the first week so why isn't DC13 green? Without an explanation of that I can't do this for you.

But you haven't answered my question. 79 is also in the first week so why isn't DC13 green? Without an explanation of that I can't do this for you.

ok i see my error you rigth

number 179 is with 79  shound be then green

my mistake because it appear in the   1 week range




sorry like i say in the begining i have problem to explain  this
because the weeks

in any case number 79 appear in week 1   but then in week 2

i don't know if an special color for the double hit could be used

to let me know is an double  hit in the 3 weeks follow

OK, hopefully these will be the last questions. Please answer yes or no if you can.

Is a "week" Thursday to Wednesday?

Is CX13 which has a value of 24 green because there is a "24" in AY20 which is in the 7-day period from 1/5 to 1/11?

If so are you aware that the 24 in CX13 has nothing to do with the value in AY20?

You have talked about 3 weeks and so I assume that to color the cells in CX13 to DC13 that I should look in weeks 1/5 to 1/11, 1/12 to 1/18 and 1/19 to 1/25. Is that correct?

If it is correct, and I find a match only in 1/19 to 1/25, what color would the match in CX13:DC13 be?

Is a "week" is Thursday to Wednesday?

not.  

an week in this situation begings as an  DDBRO is create

the ddbro comes out of an number with repeat digit


299 is just the first

but  

669 follow

then
 677


then

999

and so on

Is CX13 which has a value of 24 green because there is a "24" in AY20 which is in the 7-day period from 1/5 to 1/11?

yes ..

 number 299 create  the DDBRO and DBRO
 then  we need follow DDBRO and DBRO  in the 1 week then 2 week and  3 week  to see the numbers
that  show up from DDBRO and DBRO

If so are you aware that the 24 in CX13 has nothing to do with the value in AY20?

as they have one of the pair from DDBro and Dbro
that what i need

You have talked about 3 weeks and so I assume that to color the cells in CX13 to DC13 that I should look in weeks 1/5 to 1/11, 1/12 to 1/18 and 1/19 to 1/25. Is that correct?

I don't understand this question

but

number 299 create the ddbro and dbro

then in the first 7 days ( 1 week) any pair that appear in this range shoud be color in CX13 to DG 13

as green because is the first week

2 week  range pink
3 week  range  blue

If it is correct, and I find a match only in 1/19 to 1/25, what color would the match in CX13:DC13 be?

fro number 299 that will be the 3 week should be color ligth blue
like this

DDBRO and DBRO are only created when an repeat digit number appear

then  

3 weeks for that DDBRO and DBRO is follow to see what numbers
have the pair that DDBRO have in

but the 3 weeks is for each DDBRO created
and each one is independet  of  each other

what i mean for any DDBRO and DBRO
created

we need follow it  by 3 weeks

to see what pair comes true

Is a "week" is Thursday to Wednesday?

not.  

What???

What does this mean then? It seems to clearly show that a week is Thursday to Wednesday.

I don't understand most of the rest that you just said but I'm going to make changes to the workbook and then you can tell me if it's correct or not.

Question: I assume that week 1 for the data in CX13:DC13  is Thursday AM to Wednesday Pm, in other words rows 12 to 24. What is week 1 for the data in CX22:DC22?

What does this mean then? It seems to clearly show that a week is Thursday to Wednesday.

yes

I assume that week 1 for the data in CX13:DC13  is Thursday AM to Wednesday Pm, in other words rows 12 to 24. What is week 1 for the data in CX22:DC22?

you rigth  each day have an am and pm  

in this case the numbers appear just in PM

but will be show with AM and PM foward


in the case of number in CX22:DC22

here the week

for the data in CX13:DC13

OK, so far this does only DDBRO. Please check the results carefully and if you see a problem with the colors, please report the problem like the following example. (I don't need pictures)
OK, hasta ahora esto solo hace DDBRO. Verifique los resultados cuidadosamente y si ve un problema con los colores, informe el problema como en el siguiente ejemplo. (No necesito fotos)

Cell DC13 should be blue because AY33 contains 79

We both know that DC13 should be green and the above is just an example.
Los dos sabemos que DC13 debe ser verde y lo anterior es solo un ejemplo.
29089548.xlsb

Martin

need an button to  apply  this the a new  data added

When you click DDBRO it will happen automatically.

Martin

looking great to me



CX147 :DB147

it show  0   5  

should be  00  05

when 0 leading

Updated. Let me know if you see any of the little green triangles in the DDBRO columns.

If you say this workbook is OK I'll make the required changes to DBROW.
29089548a.xlsb

Martin

one more change will help  me

the color

Where does that color come from?

Never mind I found it.

Where does the pink color come from?

Martin

when look for numbers like 577 in AY

you see all  are  green with  57 pair in DC but is not in 1 week range


adjusted are needed

From everything you've said I assume that the rows under DDBRO that have data determine where week 1 starts. For example the first row with DDBRO data is 13 and so week 1 starts at row 13. So, since there is DDBRO data in row 126, week 1 for that data starts at row 126, and since 577 is in AY126 it is in week1.

what a struggle... Martin, I take my hat off for that much devotion.  :-)

Thanks but am I correct when I said this?

From everything you've said I assume that the rows under DDBRO that have data determine where week 1 starts. For example the first row with DDBRO data is 13 and so week 1 starts at row 13. So, since there is DDBRO data in row 126, week 1 for that data starts at row 126, and since 577 is in AY126 it is in week1.

While I'm waiting for your answer, try this.
29089548b.xlsb

From everything you've said I assume that the rows under DDBRO that have data determine where week 1 starts.

Yes !
 each DDBRO have his on 3 weeks


for example we begings  with

at CX13  which have 3 weeks to look for

but  

then

we have

CX26 which have his own 3 weeks

then


CX 24  which have his own 3 weeks to looks for

they are near each other but they are independent each one of the other

Also each  DDBRO can not count itself

because we are looking for see the  repeat pairs that come from  the

DDBRO but not counting it self  (after it)

Also each  DDBRO can not count itself

because we are looking for see the  repeat pairs that come from  the

DDBRO but not counting it self  (after it)

Are you telling me that there's a problem?

for example

AY126     577   create  CX126     20      25      27      05      07      57

number 57  appear in 3 week   then shou be  blue ligth   but appaer green color

and do the same for all the 57 that appear for  577 when you look for

Also the correct  12 count 12 rows after the DDBRO appear

so it make the fisrt week then 12 rows make the second week   then 12 rows make the third week  

each week is an 12 rows an set

Again I can't tell if you are reporting a problem. For now please simply list the rows for the DDBROW in row 13. I assume they are

Week 1  12: to 24
Week 2  25: to 37
Week 3  38: to 50

Martin

trying to get the data for 577

i have problems

Please just answer my question.

Martin

Week 1  12: to 24
Week 2  25: to 37
Week 3  38: to 50


this is ok

But for week 1 you are telling me that row 13 shouldn't be included. Is that correct?

Is that correct?

yes you are correct

If the DDBRO were in row 12 (Thursday AM) should I include values found in row 13 (Thursday PM)?

If the DDBRO were in row 12 (Thursday AM) should I include values found in row 13 (Thursday PM)?

yes !

after any question you have

can we see 577 in AY  i need show an problem i have

Please tell me now.

when i look for  numbers 577 in AY to find the DDBRO
i found 57 is all green mark

but for example  

in the first 577 search  it appear in row 126

but then 57 is not in the  1 week is in the 3 week

then the second 577 appear in row 802

and 57 in his second week

but in this 2 examples 57 is marked green as it was in first week

Great JOB !!

working as needed

 Very best expet!