Re: Matching.....

On Aug 30, 8:52 am, Pete_UK <pashu...@xxxxxxxxxxx> wrote:
Yes, but what does your schedule look like? Is it:

teamA teamB date
teamM teamH date
teamF teamC date

and so on...? Or is it:

date teamA teamB
date teamM teamH
date teamF teamC

or even some other format?

Is this list in another *** of the same file, or if it is on the
same *** then what columns does it occupy and starting from which
cell?

Please give exact details of what you have.

Pete

On Aug 30, 2:35 pm, Noob Jedi <sephiroths...@xxxxxxxxx> wrote:



On Aug 29, 6:57 pm, Pete_UK <pashu...@xxxxxxxxxxx> wrote:

Do you mean that this is a knockout competition with 50 teams starting
but only the winners of games in each round progress to the next
round? Otherwise, I don't see how not all teams will play each other,
because in a league that is what happens, and you may have home and
away fixtures so teams play each other twice.

One way of representing the league-type situation is to arrange the
list of teams vertically in one column (these are the home teams) and
the same list of teams is arranged horizontally in the row above,
starting in the next column, and this represents the away teams.
Obviously, team1 cannot play itself, nor can team2, team3 etc, so the
leading (main) diagonal is void, but any other cell in the grid
represents a match between the vertical team (home) and the horizontal
team (away). The cells could contain a date (for the fixture), or a
result if the match has already taken place, or a simple Y/N to show
if the game has been played.

In a straight knockout competition each round represents a maximum of
a power of 2 teams playing each other, i.e. in the final there are two
teams, in the semi-final there are 4, in the quarter finals 8, in the
previous round 16, then 32, 64, 128 etc in the earlier rounds. In your
case, with 50 teams, for the first round you would have to allow 14
teams to have byes (progess directly into the next round), so that the
remaining 36 teams will yield 18 winners to give 32 teams in the next
round. Thus in 1 column you would have up to 64 entries, then 32 in
the next, 16 in the next, and so on.

Of course, there are some competitions with a mixture of mini-league
arrangements for the early rounds, and then winners of these leagues
progress into the knockout phase.

I'm sure you know all this, so can you explain in a bit more detail
exactly what you have and what you want out of it?

Pete

On Aug 29, 9:51 pm, Noob Jedi <sephiroths...@xxxxxxxxx> wrote:

Let's say you have a list of 20 teams. And there is a schedule that
includes the total number of 50 teams total to play each other. Not
all teams will play each other. Within that list of 20, how do I go
about setting up the spread*** to count how many times a team in
that list of 20 will play another team in that same list? I hope I'm
asking this with enough clarity.- Hide quoted text -

- Show quoted text -

Well, I was using 50 and 20 as a sample number and not really focusing
on the math part. I thought about using your approach of vertical and
horizontal lines to represent when they play each other. This is
actually an addition to the previous question that you helped me with
me before. Basically, with that same list of predictions that I had
before, I want to see how many occurences of a team in that list plays
another team in that list exists. So if Team 4 and Team 9 are chosen,
and they are on the schedule to play each other at one point in time,
then that counts as one occurence. Now if Team 13 is chosen but does
not play any other team on that that predictions list, then no
occurence has occured, so it's not counted. I'm trying to see how I
can set up the spread*** to return these numbers.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Well, I can format it either way in your scenario. The original
schedule in the spread*** has the date as the top row. The rows
below, list out all possible teams. Respectively to each date per
column, it lists the teams the teams listed by row will play.

E.G.
B1:Z1 lists the dates assuming there are 26 teams
A2:A26 lists all possible teams...again assuming there are 26 teams
B2:Z2 Lists all the teams A2 will play respectively to the dates on
the top row.

Although, I think the stronger setup might be your second suggestion
as I tried it that way myself.

Once I get this setup, based on that predictions list again, I want to
it to automate how many times an occurence of a team playing each
other and both teams exist on that predictions list, which I'm sure
already know is my goal.

.