Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

4n count by sections TP

4N wmanual colors to add Top PAIRS
29218692.xlsb


1- in BYPLAY sheet count by each DAY the TOP PAIR and shows in  PAIRS TOP
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

I need a more complete explanation and/or week1 manually filled in.

Necesito una explicación más completa y / o la semana1 completada manualmente.
Avatar of ADRIANA P

ASKER

1-User generated image
2-User generated image
3-User generated image
4-User generated image

User generated image
5-User generated image
6-User generated imageUser generated image
I'm sorry but I don't have any idea what you are trying to tell me in those pictures and I also don't know what "can you do 2" means.

Lo siento, pero no tengo ni idea de lo que estás tratando de decirme en esas fotos y tampoco sé qué significa "can you do 2".
ok

i shows how to goes day by day  and how have to be work to get the TOP PAIR  as needed in BYPLAY sheet
beging (start) 1- day1 = 2579     then count  
add 2-day 2 =  2201   then count 
 add 3-day 3 = 1157    then count
add 4-day 4  = 1357  then count
add 5-day 5  =  2819 then count
add 6-day 6 = 2199 end

that's  i shows how to goes day by day then  how have to be shows in the PAIR TOP

please forget about "can you do 2"   not te be done


For 26W2013, please show me what MON to WED should look like.

Para el 26W2013, muéstrame cómo debería ser de lunes a miércoles.
26W2013
START  MON AM  = 2839   then count  TOP PAIRS  then
ADD MON PM = 2619 then  count TOP PAIRS  then
ADD TUE AM  = 8579 then count TOP PAIRS then
ADD TUE PM = 2245 then count TOP PAIRS then
ADD WED AM = 2611 then count TOP PAIRS then
ADD WED PM = 6635 then count TOP PAIRS then .....User generated image

User generated image
For 26W2013, please show me what MON to WED should look like.
Where? In your picture BYPLAY 26W2013 is empty!
well it's because rigth now it begings couting pairs after 3 hits or  more
here THU AM  
User generated image
then
User generated image
Is it true that MON, TUE and WED will always be blank fot PAIR TOP?

I see that the numbers that you put in BYPLAY PAIR TOP for THU AM are the Sheet1 PAIR TOP counts. What goes in BYPLAY PAIR TOP for THU PM?

At some point in the future are you planning on deleting Sheet1? I ask because if you are then I can't simply copy the PAIR TOP counts from Sheet1 because some day they will be gone and so I need to calculate them instead.

¿Es cierto que MON, TUE y WED siempre estarán en blanco para PAIR TOP?

Veo que los números que pones en BYPLAY PAIR TOP para el jueves son los recuentos de Sheet1 PAIR TOP. ¿Qué incluye BYPLAY PAIR TOP para los jueves?

En algún momento en el futuro, ¿planea eliminar Sheet1? Lo pregunto porque si es así, entonces no puedo simplemente copiar los recuentos de PARES SUPERIORES de la Hoja1 porque algún día desaparecerán y entonces necesito calcularlos.

Is it true that MON, TUE and WED will always be blank fot PAIR TOP?

yes !
 because the pairs to be account for are 3 or more pairs repeated same week1  (hits by week)



What goes in BYPLAY PAIR TOP for THU PM?

as  shows
User generated image

User generated image


i have one question you see here  61 hit 4 times
then 26 hit 3 times
then 21 hit 3 times

i want to get the count for it  to shows the TOP PAIRS

Does it make any difference in the count ??? 4 times hits  3 times hits ??


At some point in the future are you planning on deleting Sheet1?  

I can't delete the data from sheet 1
in no time if I will add years to come

To compute the PAIRS TOP it is important to do with your own counter and start with MON AM then count then ADD MON PM

in increments of each occurrence because in this example they begin to be counted on Thursdays but there are other weeks that begin to appear earlier depending on how they are running
I don't have any idea what you want me to do.
This question is to create a counter that counts the couples that are repeated per week as I showed with the photos and the explanation
The pictures you show here really confuse me.

  1. Why are the cells in BF pointing to 21 under PAIR?
  2. Why is 21 pointing to TRIPLE TOP column DK
  3. Why are BYPLAY PAIR THU AM and PM columns the same?
  1. Why are the cells in BF pointing to 21 under PAIR?

I'm only showing or pointing out the pairs starting with pair 21 down

2-
  1. Why is 21 pointing to TRIPLE TOP column DK

you are right this show is wrong
  and I correct it should point to the DR column

as shows
User generated image
3- Why are BYPLAY PAIR THU AM and PM columns the same?

in that you are also right there are no changes
because no more couples have emerged in the count

every time a number is added it is counted and added when there are new pairs
because no more couples have emerged in the count
Are you expecting me to recalculate the data in Sheet1's PAIR TOP as a part of calculating BYPLAYS' PAIR TOP?
I need the routine to be done as I explain it

otherwise I would not be making this section effective
it must be like that

I understand that you should not use sheet 1 but do like this the counter for TOP PAIRS

26W2013
START MON AM = 2839 then count TOP PAIRS then
ADD MON PM = 2619 then count TOP PAIRS then
ADD TUE AM = 8579 then count TOP PAIRS then
ADD TUE PM = 2245 then count TOP PAIRS then
ADD WED AM = 2611 then count TOP PAIRS then
ADD WED PM = 6635 then count TOP PAIRS then ....

I understand that you should not use sheet 1
Then why do you show sheet 1 in your pictures????????

START MON AM = 2839 then count TOP PAIRS then
ADD MON PM = 2619 then count TOP PAIRS then
ADD TUE AM = 8579 then count TOP PAIRS then
ADD TUE PM = 2245 then count TOP PAIRS then
ADD WED AM = 2611 then count TOP PAIRS then
ADD WED PM = 6635 then count TOP PAIRS then .
I don't know what that means.
You're right  I'm trying to explain as best as possible and maybe that confuses you

 in this case I am trying to show everything I have to do to achieve the desired result and those are the details that I do that are tedious

Maybe I shouldn't have done it like that because it causes you confusion but I thought that explaining all the detail would help to understand what to do


You say "START MON AM = 2839 then count TOP PAIRS...". What does that mean exactly and what is the result when I do?

You then says "...then ADD MON PM = 2619 then count TOP PAIRS".What does that mean exactly and what is the result when I do?
every week starts on monday AM in this week
is 26W2013


every week starts on monday
every time an occurrence happens, I count adding to the previous occurrences



26W2013
START MON AM = 2839 then count TOP PAIRS  then l 
ADD MON PM = 2619 then count TOP PAIRS then
ADD TUE AM = 8579 then count TOP PAIRS then
ADD TUE PM = 2245 then count TOP PAIRS then
ADD WED AM = 2611 then count TOP PAIRS then
ADD WED PM = 6635 then count TOP PAIRS then ....

until the last occurrence SAT PM
You didn't answer my question.
I am answering as I understand it

You can show the question with an example and options


many times you says you  does not understand but does not give explanations of what you does not understand or where you stopped understanding


I have repeatedly explained the same
i did with steps which step you say you get lost
you never goes by the steps i do
In 26W2013 the first ORD is 2839. What do I do with 2839?
it is the beginning
where it begins to be counted

What do you not understand about that?
and explain if possible with examples

I'm answering, I still understand the question
If you don't ask me the question clearly, I won't understand
it is the beginning
where it begins to be counted
What is counted?
What is the result of the counting?
What do I do with the result?

¿Qué se cuenta?
¿Cuál es el resultado del conteo?
¿Qué hago con el resultado?
we are counting the pairs cumulatively from taking into account as they arise


the TOP PAIRS button counts the pairs
that are identified in column BX by weeks (SETS)
It is an example of what I want to achieve

in this case from the first occurrence I wish
count the pairs that are repeated

therefore you have to convert the number 2839
couples to be counted

2839 = 28 83 39 23 29
Yes I understand that the the four pairs in 2839 are 28 83 39 23 29, but what do I do with them?
then each number has to be converted to pairs


that will be counted cumulatively


2839 = 28 83 39 23 29
2619 = 26 61 19 21 29
8579 = 85 57 79 87 89
2245 = 22 24 25
2611 = 26 21
  6635 = 66 63 35

in this example: 26 appears 2 times
                                 29 appears twice
                             21   appears 2 times
                           89   appears 2 times

In this solution, what we are doing, I need to identify the pairs that appear more than 3 times and all those that appear more than 3 times.
that are identified then the digits of those pairs are counted to know the order from highest to lowest

and see it in a column by DAY  of an week
I know that I said that the pairs in 2839 are 28 83 39 23 29 but why isn't 89 a pair?
my mistake

Please identify all possible pairs of the number in ORD and count them
I know I said 3 but I could be 2 or more the repetition of the pairs?
or may be have the option to select 3 or 2 as needed?
I need to identify the pairs that appear more than 3 times and all those that appear more than 3 times.
Did you mean to say "I need to identify the pairs that occur 3 or more times"?

In any case when I look at 23W2013 and I get to SAT PM I find that
21 occurs 3 times
26 occurs 3 times
57 occurs 3 times
61 occurs 4 times

What do I do with that information?

I didn't see your previous two comments when I added this comment.
Did you mean to say "I need to identify the pairs that occur 3 or more times"?

yes!


What do I do with that information?

I need to count each digit
the times that are repeated

61
61
61
61
57
57
57
26
26
26
21
21
21
               = 6 = 7 times
                    1 = 7 times
                    2 = 6
                    7 = 3
                    5 = 3

this is the correct way to tell


this is what should appear in the SAT PM PAIRS TOP column

6
1
2
7
5
9
8
4
3
0
I am asking that although I asked to count only the pairs that are repeated more than 3 times
If I can have an option to choose between 2 and 3 as needed?
FYI, I'm still working on this but have been busy in my garden.
glad to know that the garden is well taken care of
moments of relaxation bring us peace and are the source of our inspiration ...
Yay! I have Top Pair SAT PM working.

BTW, my garden is almost 500 square meters so there's a lot of work:)
I see that the garden recharges you with energy and success

Please !!

never give it up  ;)
and I think that with 500 meters you have an adequate dose of Inspiration and Blessings!

I hope you think like me!  :)
Well at 80 it's harder than it used to be but as long as I have two good legs under me I'll keep doing it.
Touching the ground is a way of electrical discharge of your nervous system and if you do it while sunbathing for at least 10 minutes it is very healthy to relax and it should be done at least 3 times in weeks that also activates your defense system

but not only that breathing and letting life flow is an invitation to Health we are that Nature of God we are his creation

sowing is a way to give life to life I love it and see how they grow and become beautiful !!


For week 26W2013 it seems that for SAT PM I look for pairs in all the ORDS in rows 1006 to 1017. What rows do I look at for SAT AM?

Para la semana 26W2013 parece que para SAT PM busco pares en todos los ORDS en las filas 1006 a 1017. ¿Qué filas miro para SAT AM?
26W2013

SAT AM  will be from rows 1006 to 1016 ORD


Is this is correct? Please stop testing after the first error and tell me what is wrong.
¿Es esto correcto? Deje de probar después del primer error y dígame cuál es el problema.
User generated image
i also have a couple of other questions.
Look at 2W2012. For THU AM there is only one pair that occurs 3 or more times and that is 89. So are 8 and 9 the only numbers that I count and put in the Top pair column? There are two additional pairs that occur two times, 87 and 79. Should I also count the 7's?

What do I do if there are no pairs in THU AM (or any other column) that occur 3 or more times? Do I leave the column blank?

También tengo un par de preguntas más.
Mire 2W2012. Para los JUEVES, solo hay un par que ocurre 3 o más veces y es 89. Entonces, ¿son 8 y 9 los únicos números que cuento y coloco en la columna del par superior? Hay dos pares adicionales que ocurren dos veces, 87 y 79. ¿Debería contar también los 7?

¿Qué hago si no hay pares en THU AM (o en cualquier otra columna) que ocurran 3 o más veces? ¿Dejo la columna en blanco?
are you posting an file?
I wasn't planning on it. You have the ORDs in previous workbooks so I don't think you need one to answer my questions.
can i shows 26W2013  with pic so it help you??
Is this is correct? Please stop testing after the first error and tell me what is wrong. 

I ask you if you put any file why do you say try


ok i will put the pic for step by step  
I ask you if you put any file why do you say try
I don't understand what that means,
I wonder if you meant to say that it will test some file?
All I was asking you to do was to look at the picture and tell me if anything is wrong. I've done that in other questions and you didn't seem to have a problem with me doing that.

Todo lo que te pedía que hicieras era que miraras la foto y me dijeras si algo andaba mal. Lo he hecho en otras preguntas y no parece que tengas ningún problema en que lo haga.
ok I see
is not problem to me  is an good way

 im working doing the  26W2013 full so we check it

but give me an chance to upload it
1-BEGINING  MON AMUser generated image 
Why are you showing me Sheet1? Please don't. Just look at the picture I posted and tell me what is wrong if anything and also please answer my two questions.
2- now will be  MON AM + MON PM ( you count the pairs from mon am +mon PM )User generated image wil

User generated image

ok in this photo the only column in the correct way is AL

the final answer shoud be like this

User generated image
What do I do if there are no pairs in THU AM (or any other column) that occur 3 or more times? Do I leave the column blank? 
i need to say
can we have the option to select count 2 or more
or 3 or more pairs ??? i just asking to see is we can have an option for it??

Why is SAT AM empty?
i just asking to see is we can have an option for it??
Yes, sure, but let's figure out 3 first.
Why is SAT AM empty? 

it is empty because there is no change

that is, I need to see the changes
need to see the changes
Okay that's not hard to do but why didn't you tell me sooner?
my mistake
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great Job !

Best Expert !
If this is correct I will add the option to look for pairs occurring two or more times 

new question for ??
Not necessary.
:)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
have an situation when i try to update it don't

thats is  in all the update you did 
What are you trying to update?
i try it in all  where you put it

but for example  Summary  and BYYEARS
it erasse my manuals marks  or colors i put manually
For Summary please describe exactly what you did.

Para Summary, describa exactamente lo que hizo.
in Summary

1- in sheet1 (After i have new data in ) hit summary then hit replace
then  nothings happens

Please attach the workbook that has the new data.
you can use the  last book we did here

just cut  all the  ord you want to test and replace

then run summary

then add the cuts ord back and this time try replace
because you just want add  the news ones 
No, I need the workbook that didn't work.
that's the workbook im talking about

but to test  you have to take data from or out (cut) then run the replace button

then add back so you can see is not working
When the Summary button is clicked on Sheet1 and then you choose 'Replace', the first thing that happens is that all the data on the Summary sheet is deleted. Then the data for all the Summary columns are copied from Sheet1 to the Summary sheet.
ok  thats  working great

the problem belong when add data i just add one day then all i want is update not replace

1- i dont update

2- need dont loose the manuals color i  did ( formats)
yo can test it

taking out some data
later add back using update button
then you will see
  1. On the Summary sheet I made row 10 all yellow
  2. I then deleted week 52W2013 from Sheet1
  3. Then I clicked the Summary button and chose Update
  4. Row 10 stayed yellow
  5. I put week 52W2013 back
  6. clicked the Summary button and chose Update
  7. Row 10 stayed yellow
ok i agree with you  stay yellow  but don't update the data as needed


To be useful summary have to add in one place  ORD,  PAIRS TOP, RANGE, TRI TOP, ect..

and it doesn do it

but it dont add the new ord nums or news  pair Top , Range, Tri, ect..

example

1-take  all data (ORD )from week 19W2021 down and cut it

2- paste in a blank sheet to clean all week from 21W2021down

3- now run all the buttons ( pair Top , Range, Tri, ect...) so summary will update

4- now  get back week  19W2021  to  21w2021 and  press all the buttons  ( pair Top , Range, Tri, ect...)

5- now press summary then update

it don't change the colors rigth but it don't put the new numbers (ORD ) or the new pair Top , Range, Tri, ect... calculations    


so even it don't erase the colors but to add new data to summary the only way is Replace button
update button don't add newdata as needed to summary

so the only way to add new data as needed to summary will erase  the manually enters


I assume that "Update" means to add new data like a new year's data. What does it mean to you?

Supongo que "Update" significa agregar nuevos datos como los datos de un año nuevo. ¿Qué significa para ti?
wells i add data (ORD) daily as needed  

that that way to analize the track (AM /PM by day)

1- usually when i begins ( after you finish an solution ) i put the data then an replace is mandatory to havde all  the data ON

2- then  as days are running i need to update ( that is by day,  am /pm ) because need to analyze as ruuning the days

"Update" by years don't help me to see the daily track as needed
I don't understand what you want "Update" to do. Perhaps if you used Google Translate I would understand you better.

No entiendo qué quieres que haga la "Update". Quizás si usaras Google Translate te entendería mejor.
well!! I add data (ORD) daily

since that way I can analyze ORD (AM / PM by day)

1- I usually start when we finish a solution replacing the entire data. (When replacing all the DATA using the replace button helps me at that moment)

2-But once the data (ORD) is already set and as the days go by, I need to update (that is, per day, am / pm) because I need to analyze how (ORD) is developed in that monment I need the UPDATE button (q be it from day to day AM / PM)

"Refresh" for years does not help me to see the daily tracking as I need to see it

you can add the update button per day instead of per year
I believe the problem is that the Update process looks for new data in Sheet1 column 'B' rather than in Sheet1 column 'BF'. I'll change that.
I have the same problem with all update

1- I need to add marks manually that are not deleted

2-That allows you to add the data that you added new (after having given replace once) and that does not appear
that is, once I press the replace button, then I only want to give updates to be able to preserve the brands and information that I have analyzed


otherwise I lose it if I can only update the data using replace button


that is, I only need to do replace once, then it will be updates all the time
See if Update works like you want it to.
29218781b.xlsb
i just hit Summary button at sheet1  get this :

User generated image
User generated image

when  hit by years button sheet1
Have an Great Rest Time !
You lead the Way !

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
you did it as I need
it's a terrific great job

as always.....The Best !!