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.
Handicap system
Moderator: Mod
-
- Posts: 117
- Joined: Wed Jun 10, 2009 8:16 pm
Re: Handicap system
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.
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.
You do not have the required permissions to view the files attached to this post.
-
- Posts: 7495
- Joined: Wed Jun 15, 2005 8:22 pm
- Location: Maffra, Vic
Re: Handicap system
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?
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?
-
- Posts: 7495
- Joined: Wed Jun 15, 2005 8:22 pm
- Location: Maffra, Vic
Re: Handicap system
And BTW I did come up with a Excel solution without Macros. Took about 30mins ....
You do not have the required permissions to view the files attached to this post.
-
- Posts: 117
- Joined: Wed Jun 10, 2009 8:16 pm
Re: Handicap system
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.
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.
You do not have the required permissions to view the files attached to this post.
-
- Posts: 7495
- Joined: Wed Jun 15, 2005 8:22 pm
- Location: Maffra, Vic
Re: Handicap system
Richard,
Touché!!! I'm impressed!
You realise of course that makes Excel even better (than a database)....
Touché!!! I'm impressed!
You realise of course that makes Excel even better (than a database)....
-
- Posts: 117
- Joined: Wed Jun 10, 2009 8:16 pm
Re: Handicap system
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
But it comes down to what you are comfortable with.
Richard
-
- Posts: 13
- Joined: Mon Mar 16, 2020 6:36 pm
Re: Handicap system
Thanks to Alan's advice I have worked out how to add an attachment.
You do not have the required permissions to view the files attached to this post.
Return to “Equipment & Technical”
Who is online
Users browsing this forum: No registered users and 49 guests