New File Added: 2008 Classification Pivot Tables

[rohenwto]

Downloads: A new file has been added by rohenwto:

2008 Classification Pivot Tables

2008 Classification Tables in excel pivot tables.
one tab displays age group in columns the other tab displays age group in rows.
To use, a selection MUST be made from each of the following:

1. From Types select imperial or metric
2. From Bow select required bow type
3. From sex select Lady or Gent

You can then use the drop down menus to select specific round(s) or age group(s)

[Marcus26]

I must be using it wrong.
I selected Metric, Compound Male and it showed up the scores. Looked right.
Then changed Male to Lady and the scores went a bit nuts and no GMB scores are shown.

[grimsby archer]

afraid I can't open it at all. The file opens in excel, but then I get a "microsoft appologises for the inconvenience" screen before it shuts down.

[rohenwto]

2008 Classification Pivot Tables v1.1 has been updated!

Now v1.1, please delete old version.
A couple of errors have come to light (thanks Marcus), namely missing classifications in ladies metric compound rounds.
The panel of proof readers have been dealt with

[rohenwto]

Originally Posted by Marcus26

I must be using it wrong.
I selected Metric, Compound Male and it showed up the scores. Looked right.
Then changed Male to Lady and the scores went a bit nuts and no GMB scores are shown.

You are not using them incorrectly. Tables had a couple of errors, which managed to slip through the proof reading stage.
Tables now corrected if you down load again (now V1.1) all should be OK. Unless you find some more errors

[rohenwto]

Originally Posted by grimsby archer

afraid I can't open it at all. The file opens in excel, but then I get a "microsoft appologises for the inconvenience" screen before it shuts down.

no idea. Are you using excel 2003 or later?
Turns out it has some errors any way. Down load v1.1 and see if it works.

[bundy]

Hi

Excellent work, but I've got the same problem as Marcus, but with the Ladies Barebow stuff - there are no scores for the Ladies Fita seniors.

Cheers

Helen

[rohenwto]

2008 Classification Pivot Tables v1.2 has been updated!



Now v1.2, please delete old version.
A couple of (more) errors have come to light (thanks Helen), namely missing classifications in ladies metric barebow, recurve & longbow rounds.
The panel of proof readers have been dealt with (again)

[rohenwto]

2008 Classification Pivot Tables v1.3 has been updated!

Ok final issue (I hope)
Gents compound U18 2nd class scores, where wrong by one hcap point, (49 instead of 48)

[Cimbian]

Seems to work for me... thanks for sharing.