Handicap system

[Martin]

Alan,
My idea was more theory than practice. A custom function would be required for excel to do the gruntwork.
I have knocked up one that should do the job.
It is used as =HandicapAvg(cellrange,Count,Top)
where count and top would be 10 and 5 resp. if you wanted to average the best 5 scores out of the last 10 scores. ceelrange is the range of cells containing the shooters scores (one dimensional array of cells in time order left to right or top to bottom).

I can't see how to add an attachment to this post so can't share it.

[RMc]

Alan, I finally had an hour to spare so I produced the below.
It saves into a free database, collects the last 10 scores, discards the lowest 5
And gives the average (The maths is irrelevant)

From this, I hope that you stop setting your expectations on your own limitations.

Time for the delete button as it obviously just too hard to achieve.

Handicap.JPG

[AlanF]

Martin,
I sent you a PM yesterday re: attachments.

Richard,
My discussion of the topic was in terms of MS Excel. You have used a database, and I can see how a database would handle the basic calculation efficiently. But how many people have Excel skills as against database? I'd suggest many more? On the other hand if a fully configurable and user friendly application was going to be written for widespread use by people without database skills, then you sound like you could get the job done very quickly?

[AlanF]

And BTW I did come up with a Excel solution without Macros. Took about 30mins ....

Top5Mean.xlsx

[RMc]

Thanks, Alan, if you re-read my first post that is what was stated.

Had a look at your Excel sheet good logic.
I have added a line to your sheet in the attachment, one cell formula (5min)
Excell is powerful but takes a lot more maintaining than a database.

Top5Mean_Adjusted.xlsx

[AlanF]

Richard,

Touché!!! I'm impressed!

You realise of course that makes Excel even better (than a database)....

[RMc]

Alan, unfortunately, excel crunches numbers really well but it takes a lot of input to keep track of the data, a database allows you to store all the data and just extract what you want, and how you want it. Excel should only be used for short term items, if you need to keep using the same data over and over again then you will spend a lot less time by using a database.
But it comes down to what you are comfortable with.
Richard

[Martin]

Thanks to Alan's advice I have worked out how to add an attachment.

Handicap_v0.1.xlsm