Basketball Lineups

[Gabor Sebo]

-----Original Message-----
Here a problem regarding basketball lineups and team points. The worksheet
looks like this:

P1 P2 P3 P4 P5 PtsF PtsA
PlayerA PlayerB PlayerC PlayerD PlayerE 16 13
PlayerG PlayerB PlayerC PlayerI PlayerE 7 9
PlayerG PlayerF PlayerH PlayerI PlayerE 10 16
PlayerA PlayerF PlayerH PlayerD PlayerJ 9 2

The rows containing "Player" designations (A, B, C, etc.) are the five
players who are in the game at the same time.
Columns P1 through P5 show which player is playing which position (positions
1 - 5)
PtsF is the points the team scores while that 5-player combo is on the court.
PtsA is the points the team allows while that 5-player combo is on the court.

I want to be able to calculate for thousands of rows of data the:
number of points scored and allowed by each five-player combination
number of points scored and allowed when a particular player is on the court
number of points scored and allowed when a particular player is at
different positions
number of points scored and allowed when groups of 2, 3, or 4 players are
on the court

Thanks,
Bob
.

Hello Bob,

One way of grouping all PTSF.s and PTSA.s belonging to the
same team could be done by "Filtering a List" using
multicolumn filtering.
This would list all lines where say:khjkf players played
in these lineup(k=1,h=2 etc)

Ask more if in trouble.

Gabor

 

[bob]

Gabor,

I need to automate the process. Filtering each column for each lineup
combination will require too much manual work. There are hundreds of
combinations that will be need to be subtotaled and listed.

In other words, the first data row in my example may occur 25 times with
different points for/allowed figures. I need to add up all occurrences of
every combination, with total PtsF and PtsA.

Make sense?

Thanks,
Bob