4N R Count increments by DAY

Please explain the significance of the colors.

Explique el significado de los colores.

the colors will be the same as the WEEK TOP NUM

green same week

red next week 

T5:T7 is a different color than T7:T8. Should they both be colored like T7:T8?

T5:T7 have the rigth color to be use

 T7:T8 colors was my mistake

an very important detail is need the range be  from MAYOR to MINOR  when sort 

as we did here,,,

Are you referring to a column in the 29216924b workbook? If so which one?

we did WEEK TOP NUM

now WK RANGE is needed

is the same way but now RANGE 

Using the 50 range for an example, how many pairs in the range 50 to 59 do there need to be in order to show it on the worksheet?

sorry i dont  understand the question

but the range in sheet 1 RANGE PAIRS button  is working as needed  

the range in sheet 1 RANGE PAIRS button  is working as needed  

Which one?

I don't undestand what  you shows in that pic

but as shows here

If a pair is in this week and next week should it be green and red?

Have you considered using the same colors as WEEK TOP NUM?

Have you considered using the same colors as WEEK TOP NUM? 

Please use  them

If a pair is in this week and next week should it be green and red? 

Green is the first always

Do you need to have the 1-, 2-, 3-, etc numbers and colors in column 'R'?
Do you need to have the 1-, 2-, 3-, etc numbers and colors in column 'AE'?

Do you need to have the 1-, 2-, 3-, etc numbers and colors in column 'R'?

Do you need to have the 1-, 2-, 3-, etc numbers and colors in column 'AE'? 

yes, please !!

Just to keep you up to date; I'm having some difficulties with this but I'll figure it out eventually.

Solo para mantenerte actualizado; Estoy teniendo algunas dificultades con esto, pero eventualmente lo resolveré.

:) you Lead the Way !

I have a question about WEEK TOP NUM. Look at column 'F' for 1W2012 (and every week where there is no AM data). Notice that the numbers are 9,8,7,6,5,4,3,2,1,0 ( the digits are in descending order). Is that correct?

Tengo una pregunta sobre WEEK TOP NUM. Mire la columna 'F' para 1W2012 (y todas las semanas donde no hay datos AM). Observe que los números son 9,8,7,6,5,4,3,2,1,0 (los dígitos están en orden descendente). ¿Es eso correcto?

 Is that correct?

yes! sort in descending is the way 

But A5 is blank, so what does 9,8,7,6 represent?

Pero A5 está en blanco, entonces, ¿qué representa 9,8,7,6?

What should column 'F' for 25W2013 look like?

What should column 'F' for 25W2013 look like?

NO ORD in MON AM so should be blank
  

I'm sorry but I realize now that I don't fully understand how to calculate the numbers in WEEK TOP NUM, so I need you to explain again, In 26W2013 I'd like you to explain where each the numbers in columns 'F' and 'G' come from. Your explanation should include a statement like "The 9 in cell F1006 comes from..."

Lo siento, pero ahora me doy cuenta de que no entiendo completamente cómo calcular los números en WEEK TOP NUM, así que necesito que me expliques nuevamente, en 26W2013 me gustaría que explicaras dónde están los números en las columnas 'F 'y' G 'provienen de. Su explicación debe incluir una declaración como "El 9 en la celda F1006 proviene de ..."

is ok now ?

Please explain if that's ok ?

I see that 9,8,32 comes from C1006 but why is it in that order? Where does 7.6.5.4.1.0 come from?

when  the week is begining

2839 shows up then you hit the ONE TOP COUNT
then it count the 2839

it sort the count descending
  that is the count 

What I asked you do do was thais:

I need you to explain again, In 26W2013 I'd like you to explain where each the numbers in columns 'F' and 'G' come from

Necesito que me expliques de nuevo. En 26W2013, me gustaría que explicaras de dónde provienen los números de las columnas 'F' y 'G'

 sorry i did

sorry i did

Where?

here you can review it

The explanation there is too long and too confusing and that's why I started asking you again.

wells i don't knows what is confused to you
because you don't explain me where you are lost...

you just ask explain all over again

i closed  an question as good solution
for the same question here  you are asking

may be you should goes step by step so i can see where is the step
you are missing

i undestand the person lost is you not me

is very easy at this point say start all over again
just because i get lost

you should explian where did you get lost and why

like you say

I need you to explain again, 

means to me you knows i explain this already

if you don't want finish this question
i understand we can leaves this here

wells i don't knows what is confused to you
because you don't explain where you are lost..

Assume that I don't know anything.

i closed  an question as good solution
for the same question here  you are asking

But it was wrong for some of the AM time periods.

i understand we can leaves this here

That is up to you but it should be a simple thing to explain where all the numbers in 26W2013 columns F and G come from.

we (not you alone) have worked together for many years many solutions

I think if I ask you to explain to me where you got lost
and that you go step by step explaining to me
Where did you stay, you can do it to understand why you don't understand

and to be more effective and save time

I have explained many things to you, so with my problems and my limitations and my poor command of the language
 
do not come to treat me as if I
a stupid person

and answer me when I ask you a question
with details and clarity

I have always been willing to cooperate and help and it is not for less that my time is despised

as I'm not interested in wasting your time either

do not come to treat me as if I
a stupid person

When did I do that?

In any case in your 4N Count By each Section question you said

example : Monday am = count Monday AM (the begining)

Monday PM = count Monday AM + Monday PM

Tuesday AM = Monday AM + MONDAY PM + Tuesday AM =

So in 26W2013 for example, the Monday AM ORD is 2839. What exactly should I count for column 'F'?

I understand that Monday AM is 2838, but what am I counting that results in 9832765410?

For 26W2013:

For Monday AM I count how many times 2 and 8 and 3 and 9 occur in 2839.
For Monday PM I count... ?

Are you reading my messages?
or do you just look at them?

Do i have to repeat the SAME again ??

I read them.

All I need you to do is to complete this sentence

For Monday PM I count... ?

just like it did in this sentence
For Monday AM I count how many times 2 and 8 and 3 and 9 occur in 2839.

I don't understand what you're trying to do
if I have to answer the questions only  your way
Or are you ridiculing me because I don't see things like you
or is this a power struggle?

I try to explain the best that I can

as I have repeated before
 
  MON PM = MON AM + MON PM

how many times you see 2 in 2839 MON AM

just 1 ??

Or are you ridiculing me because I don't see things like you
or is this a power struggle?

I would never do that.

I just want to be 100% sure what you mean by "counting" and I'm not.  

I know the numbers are shown in descending or of there occurrence count.

Are you saying that for column 'F' I count how many times the digits of the first ORD appear in the week? If so then I need you to write a sentence just like that one that says what I do for column G.

Yo nunca haría eso.

Solo quiero estar 100% seguro de lo que quieres decir con "contar" y no lo estoy.

Sé que los números se muestran en forma descendente o de recuento de ocurrencias.

¿Está diciendo que para la columna 'F' cuento cuántas veces aparecen los dígitos del primer ORD en la semana? Si es así, necesito que escribas una oración como esa que diga lo que hago para la columna G.

I give up.

sorry! you did 
the solution was done correctly
i never said it was wrong

why you now say you don't undestand something you already did?

and you did well!

why don't you explain that to me?

I didn't even say change some of that

you did that solution correctly

because if you're doing the same, you tell me you don't understand

why you now say you don't undestand something you already did?

I'm an old man.

for column 'F' I count how many times the digits of the first ORD appear in the week

Why haven't you done what I've asked for several times and that is to write a sentence like that for column G?

ok i apologize to you
  I don't know how to write that my english is not so good

okay. give me an sample to follow

Are you saying that for column 'F' I count how many times the digits of the first ORD appear in the week? If so then I need you to write a sentence just like that one that says what I do for column G. 

i don't Understand this

can you make more simple to me so i can write the sentence?

Do you understand the following sentence?
For column 'F' I count how many times the digits of the first ORD appear in the week.

It tells me what digits to count and where I should look to count them.

Me dice qué dígitos contar y dónde debo mirar para contarlos.

Sorry  I'm sorry I don't want to sound spoiled or anything like that

but i don't understand the question

you now you have to look and ORD (column BF)
26W2013  MON AM  2839  

when in sheet1

then i hit  ONE COUNT TOP button in columns DX 

How does ONE COUNT TOP help me fill in column G or any of the other columns in WEEK TOP COUNTon the BYPLAY sheet?

¿Cómo me ayuda ONE COUNT TOP a completar la columna G o cualquiera de las otras columnas de WEEK TOP COUNT en la hoja BYPLAY?

You didn't answer my question.

How does ONE COUNT TOP help me fill in column G or any of the other columns in WEEK TOP COUNTon the BYPLAY sheet?  

like i say is the counter

but in BYPLAY

have to be record  by each appearance

Sorry i dont undestand you question give an example
of the answer to follow

I did.

For column 'F' I count how many times the digits of the first ORD appear in the week.

and I need something like that for column G that tells me which ORDs to count and where to count them. So something like "For column 'G' you need to count how many times the digits of the first two ORDs appear in the week."

23W2013
MON AM  =2839  count it  in column F  ( it appear 1 times
MON PM =2839 + 2619 count each digit and appear in column G ( count each digit and shows in columns G)

2839 + 2619

That's what to count but you haven't told me where to look to count them.
Should I look in all the ORDS for the whole week (BF1006 to BF1017? If not then which rows? Please don't refer me to ONE COUNT TOP.

you should  goes to BY PLAY sheet

then count ORD is Column C
each week is an set
it beging with MON AM
we talk about 26W2013  then you have to goes at the firts apperance then add the follow
(Increment) until the week is finish (the week finish  at SAT OM

Please just answer yes or no. Should I always look in all the ORDS for the whole week (BF1006 to BF1017?

Yes 

Is an Great Job  im testing it

rainbow is an great  Name too!

For 1W2012

Is it true that when I do MON (PM) I count the occurrences of 4 and 6 and 1 and 9 in column 'A', rows 5 to 16 on the BYPLAY sheet?
Is it true that when I do TUE (PM) I count the occurrences of 4 and 6 and 1 and 9 and 8 and 3 in column 'A', rows 5 to 16 on the BYPLAY sheet?


Para 1W2012

¿Es cierto que cuando hago MON (PM) cuento las apariciones de 4 y 6 y 1 y 9 en la columna 'A', filas 5 a 16 en la hoja BYPLAY?
¿Es cierto que cuando hago TUE (PM) cuento las ocurrencias de 4 y 6 y 1 y 9 y 8 y 3 en la columna 'A', filas 5 a 16 en la hoja BYPLAY?

You didn't answer my questions and I don't understand what you mean by "... i lost the keys...".

Is it true that when I do MON (PM) I count the occurrences of 4 and 6 and 1 and 9 in column 'A', rows 5 to 16 on the BYPLAY sheet?

why column A?

yes count the ocurrences in Column C in BY PLAY sheet

Is it true that when I do TUE (PM) I count the occurrences of 4 and 6 and 1 and 9 and 8 and 3 in column 'A', rows 5 to 16 on the BYPLAY sheet? 

Yes count the ocurrences in Column C ByPLAy sheet

but you are making an error

you have to go to the Number by DAy By AM PM

Why  you don't goes to the each number as i shows in the PIc is not better ?

why column A?

I meant 'C'.

you have to go to the Number by DAy By AM PM

I don't know what that means.

Why  you don't goes to the each number as i shows in the PIc is not better

?Because you told me what to search but not where.

ok i will explain something but will need you help please
i need goes setp by step
is ok to you ?

please let me knows if i explain this MON PM good to go?

may be you are tired for today
are you in rest already?
i just try to explain in the best moment

Any time is OK with me.

are you avaliable now??

Not really but you can post now and as soon as I'm available I'll take a look at it.

Thank you very much for all your help and friendship for so long
I have no one to help me so much in my time
and less like you

I would like to make things work and I think I make my mistakes in my communication with the person who helps me the most

I do not know how to explain what I see, I would like to be able to talk without limitations

My best effort has been trying to convey the direction to you in the best way I can so as not to get stuck in something and move forward.

I apologize for my mistakes in my endeavor
It does not matter what is achieved, the most important thing for me has been to have a great friend like you in my desire to achieve this project.

i like the improves you dis to this file you did they are great and needed

is ok elimante the count where not AM is in ORD present (not ORD present) but need the key from 29216924a.xlsb 

this file have the WEEK TOP NUM as needed  29216924a.xlsb

I'm happy to work with you.

Are you saying that these are the numbers you want to see?

Do you have a copy of the workbook that put 9,8,7,6,5,4,3,2,1,0 in the AM periods of 1W2012?

29217156 (1).xlsb

here the file
the AM for  1W2012 to 25W2013 MON AM can be take off ?

Thanks.

I've been working on WEEK TOP NUM for days and I'm finding it to be very difficult, and at some point I may have to say that I don't know how to do it.

He estado trabajando en WEEK TOP NUM durante días y lo encuentro muy difícil, y en algún momento debo decir que no sé cómo hacerlo.

I understand but it is already done in this file as I need it, you could not do the best ones keeping the way in which the counter of this file works? 29217156 (1) .xlsb

any way we can keep going with others situations no problem to me

is ok let like that the file 

Please check the results in this picture.
Are the counts correct?

Should the key be 99999 rather than 999999999999?

Martin

the key is ok because is the ALL TOP

but the counts are not To Go

I'm going to propose something to you

this file has been a great experience

let me develop other alternatives

what I have thought and this we can leave it for finished

I have other ideas that are more practical and less tedious

I have others ideas to  try

but the counts are not To Go

I'm not sure what that means but aren't the counts in the first two columns the same as in your picture?

No