Club Records

[Flying Whale]

Originally Posted by Furface

This is Archrecs (http://www.mike-douglas.co.uk/) and is what I use at Adel. It is Access-based, works, and makes life a heck of a lot simpler. My main gripe is that individuals have to be entered once for each bow type they use, but I can live with that. It handles normal club activity very well, and manages club records. And, the big plus is that it does work out handicaps and classifications.

We also have Archrecs. Has there been an update for

new compound classifications?
new barebow classifcations?
new longbow classifications?

We have not had any notification that there is.

[Trunkles]

Originally Posted by Vae

One question to end with. Do other records officers doublecheck each score sheet they're given or do you just accept the score signed for as correct?

Archers (of whatever age) cannot add up so I check them - sometimes just a visual consistency check, sometime a full arithmetic job. I too use Joe Tapley's program. Must try it on my new Vista machine.

[FlourPower]

Originally Posted by Trunkles

Archers (of whatever age) cannot add up

Woah how have you seen my results?

[Furface]

Originally Posted by Flying Whale

We also have Archrecs. Has there been an update for

new compound classifications?
new barebow classifcations?
new longbow classifications?

We have not had any notification that there is.

Yes, there is one (we weren't told about it, but I asked, and details of how to get it are on the website)

Originally Posted by moo mop

Does it do finals totals and cope with with allowing second sessions for those rounds where they are applicable? How does it do juniors records? Most systems I've come across don't work correctly as they will pull up records that GNAS do not allow, and our clubs and counties follow GNAS' lead eg they tend to pull out a u12, u14, u16, u18 junior gents york record when there should be just one junior gents york record. Does it do the FITA junior and cadet and masters age groups?

Sadly, I think that most of those are a complexity too far. As I said, it copes with "club" records. At Adel, we took the decision to keep distinct records for all GNAS age groups anyway - there's nothing in the rules against this. Again, out of interest a) how do other clubs do this and b) do other clubs keep separate FITA age-band records?

[moo-mop]

Originally Posted by Furface

Again, out of interest a) how do other clubs do this and b) do other clubs keep separate FITA age-band records?

The club I designed this follows the records allowed at national level for simplicity and validity, prevents arguments and stops silly records being claimed by adults or younger juniors (and that includes finals total and match rounds).

As national level doesn't have separate records for FITA groups (although the small print in archery UK said they should IIRC) neither does the club.

For my database it isn't a complexity too far, as the fields are present and it would be easy to pull them out (easier still if all FITA shoots put it on the results sheets if the rounds were shot by juniors, cadet or masters as the ones organised by GNAS do) ie in this case I've remembered to think about it so the problem is in data availability not in design. I don't want to store date of birth in the database which would solve many many problems because I think that info is a bit too personal and carries more risks.

[paulhuk]

Originally Posted by Furface

At Adel, we took the decision to keep distinct records for all GNAS age groups anyway - there's nothing in the rules against this. Again, out of interest a) how do other clubs do this and b) do other clubs keep separate FITA age-band records?

I took over as our club's records officer and we also use ArchRecords (the Ron Douglas one) and I also got the new version for the 2008 classifications after asking for it. I understand that it handles the rules for juniors changing age groups mid-season, but I've yet to see this in action. Vae, you must have an old version because the version that I've have for some months now has all of the classifications and handicaps built in. It even has the rules built in for the GNAS 'Handicap Improvers Medal'. BTW it only covers indoor and outdoor target, not clout, field or flight.

However, it only recognises the GNAS and FITA 'named' rounds, but not the individual distance FITA rounds. I seem to remember reading somewhere that the author is contemplating allowing non-standard rounds to be entered in a later version.

Having said that I have still set up a set of Excel spreadsheet for the 'club records' for target because we hold more details than the software (full breakdown by all GNAS age ranges for all disciplines, etc).

[Flying Whale]

Originally Posted by paulhuk

Vae, you must have an old version because the version that I've have for some months now has all of the classifications and handicaps built in. It even has the rules built in for the GNAS 'Handicap Improvers Medal'.

I think you will find Vae said they are using Joe Tapley's program, not ArchRecs.

[Vae]

Ah yes we use use Joe Tapleys program which I wrongly called archrecs when it's actually called clubrecs. The Mike Douglas program, as Furface correctly identified, is the one I was thinking of when I referred to an archery program seeming old.

I just wish there was a program out there (commercial would be fine) that would cover everything and make records officers jobs that little bit easier but I suppose we're not a big enough market. Instead we have solutions that are most of the way there i.e. Joe Tapley's 'clubrecs', Mike Douglas's 'archrecs' or end up with individual clubs coming up with their own solution e.g. MooMop's or Meta's

The issue of handicap copyright seems one of the major hurdles but I doubt anything will ever be done about that.

[Flying Whale]

Originally Posted by Vae

Ah yes we use use Joe Tapleys program which I wrongly called archrecs when it's actually called clubrecs. The Mike Douglas program, as Furface correctly identified, is the one I was thinking of when I referred to an archery program seeming old.

I just wish there was a program out there (commercial would be fine) that would cover everything and make records officers jobs that little bit easier but I suppose we're not a big enough market. Instead we have solutions that are most of the way there i.e. Joe Tapley's 'clubrecs', Mike Douglas's 'archrecs' or end up with individual clubs coming up with their own solution e.g. MooMop's or Meta's

The issue of handicap copyright seems one of the major hurdles but I doubt anything will ever be done about that.

While not DOS based, ArchRecs does live within the limitations of applications written in Access. It does the job, just.

We have now gone down the route of writing our own. Having started working on it last year for our records officer, I am glad I did, since I am now club records officer. It is very nice being able to add all the little features and niceties as I like them. Just about to build in a direct link to our club web site so that I can automatically update the current handicaps and classifications in the members area.


Best of luck in your records officer's job!

[Zippo]

Wow, with all the handicapping and classifications and all the different types of rounds, I think my club can consider itself really lucky. Guess we'll try out spreadsheets first to see how it goes. We're still at the beginning of evolution. Its really interesting to learn about how each club handle their records though.