Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

4n to be adjusted in buttons

4n to be  Adjusted in Sheet  

Adriana4N (3).xlsb


as we did here : https://www.experts-exchange.com/questions/29228918/4n-to-be-Modify-to-work-with-3n-DATA-week-num.html

but now for this file 4N


1- ADJUST      BYPLAY    sheet  to WORK  as needed  


2- buttons RANGE ,   TOP PAIRS ,   TRITOP

Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

For Top Pair in 3N I talked about "developing a foolproof way of determining couples" and I gave 4 examples and each example represented a pattern.
Para Top Pair en 3N hablé sobre "desarrollar una manera infalible de determinar parejas" y di 4 ejemplos y cada ejemplo representaba un patrón.
444 pattern = AAA
011 pattern = ABB
440 pattern = AAB
019 pattern = ABC

In 4N it's more complex. I think that there are just these seven patterns. Let me know if I've missed any.
En 4N es más complejo. Creo que solo existen estos siete patrones. Avísame si me he perdido alguno.
AAAA example 4444
ABBB example 4333
BBBA example 4443
AABB example 4433
ABBC example 4660
ABCC example 4600
ABCD example 2460

Please tell me what the couples for those examples are.
Por favor, dígame cuáles son las parejas para esos ejemplos.
ADRIANA P

ASKER
AAAA example 4444
ABBB example 4333
BBBA example 4443
AABB example 4433
ABBC example 4660
ABCC example 4600
ABCD example 2460

I understand they are all
but if it is more complex



 



Martin Liss

but if it is more complex
Are you asking me a question?

There is one more pattern.

AAAA example 4444
ABBB example 4333
BBBA example 4443
AABB example 4433
ABBC example 4660
ABCC example 4600
ABCD example 2460
AABC example 4423

Please tell me what the couples for those examples are.
Por favor, dígame cuáles son las parejas para esos ejemplo
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ADRIANA P

ASKER
Are you asking me a question?

No




AAAA example 4444  = 44
ABBB example 4333  = 43  33
BBBA example 4443  = 44   43
AABB example 4433  =  44  33  43 
ABBC example 4660  =  46 66 40  06


ABCC example 4600   =  46 60  00 40
ABCD example 2460   =  24 46 60   26 20 40
AABC example 4423  =   44 42 43 23 
Martin Liss

In this workbook take a look at BYPLAY Pair Top week 33W2013. That week and a lot of others are now different then they were in the previous 4N workbook. Please let me know if 33W2013 is correct. If it is please don't select it as the answer because I still need to change Triple Top.

En este libro de trabajo, eche un vistazo a BYPLAY Pair Top semana 33W2013. Esa semana y muchas otras ahora son diferentes de lo que eran en el libro de trabajo de 4N anterior. Por favor, avíseme si 33W2013 es correcto. Si es así, por favor no la seleccione como respuesta porque todavía necesito cambiar Triple Top.
29229369.xlsb
ADRIANA P

ASKER
ok to go 
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

What are the triples for 2460?
ADRIANA P

ASKER
What are the triples for 2460?

246    460     240    260
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Great Job ! Best Expert !

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ADRIANA P

ASKER
an situation arise from 3N file   the TRIG ( column BS1) is not working as needed after  row 6693

i put data but is now showing back the data

also the Pair button need be adjustes to count 2 pairs by week
Martin Liss

an situation arise from 3N file
Please report the problem in the 3N question, not here.
ADRIANA P

ASKER
ok
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.