Computerising teams

[Furface]

After my debacle in awarding the trophy to the wrong team the other week, I am returning to my search for the Holy Grail, a method of automatically generating team scores. I use Access, but what I really want is an algorithm.
Teams can have:-
Varying number of archers
Varying combinations of bow types
Varying combinations of gents/ladies/juniors
Varying combinations of Club/Region/Home Nation etc

Has anyone worked out how to do this without the intervention of mental arithmetic (or visual inspection)?

[Dave]

You should be able to use Access using SQL statements for retrieving the teams (identified by their club name) and then adding the scores together (SUM iirc) and displaying them in winning order (bit like the current League does with individual archers).

[Tarkwin]

another alternative would be to have a field for team name and then filter by the name into a query, then creating a sum field within the query.

You should then be able to do a report which runs the queries when launched..

Could be cumbersome for many teams/archers..

I have done this in the past...if I can find the sheet I will let you know..

what version of Access are you using?

have a look at this...

http://www.archery-software.co.uk/pr...lden-arrow.htm

it might be what you are looking for without the hair pulling

T.

[sky_high30]

I've tried to do it in excel. One of our club members has written a good (if IMO over complicated) spreadsheet that can pull out the top XX archers from a club, but finding a way of summing the scores together is a nightmare. It uses a filter to do it - so you can't specify the displayed range or it gives the same number each time.

I tried doing one in access - i'm sure there's a way of doing it but i've forgotten a lot of what I learnt - and in any case it didn't extend to writing SQL.

[Rik]

I put together a simple Excel spreadsheet for a team shoot we hold each year. It's not complicated to set up macros to add up the scores and generate the placings. We generally do it on a dozen by dozen basis, to create a leader board for the teams.

My one is fairly specific to the idiosyncracies of our shoot, though.
The ACME guys use a generalised one, that one of their team knocked up, which seems to work well - results usually available in a very short space of time.

Thinking about it, all you need is:
Archer's name
Archer's gender
Club name
plus identifying feature (target number and place on target, for example).

You enter the scores for each target, sum them, sort the archers by gender and sum of score (to give individual results). Sort the archers again, this time by club and score, sum the top X scores for each club, store that against the club name and sort the clubs by the team score to give the team results. Sorting and summing is the kind of thing Excel does reasonably well...