Handicap system

Get or give advice on equipment, reloading and other technical issues.

Moderator: Mod

Message
Author
Martin
Posts: 13
Joined: Mon Mar 16, 2020 6:36 pm

Re: Handicap system

#16 Postby Martin » Fri May 08, 2020 3:36 pm

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
Posts: 117
Joined: Wed Jun 10, 2009 8:16 pm

Re: Handicap system

#17 Postby RMc » Sat May 09, 2020 11:40 am

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
You do not have the required permissions to view the files attached to this post.

AlanF
Posts: 7495
Joined: Wed Jun 15, 2005 8:22 pm
Location: Maffra, Vic

Re: Handicap system

#18 Postby AlanF » Sat May 09, 2020 5:26 pm

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? :D

AlanF
Posts: 7495
Joined: Wed Jun 15, 2005 8:22 pm
Location: Maffra, Vic

Re: Handicap system

#19 Postby AlanF » Sat May 09, 2020 8:39 pm

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

Top5Mean.xlsx
You do not have the required permissions to view the files attached to this post.

RMc
Posts: 117
Joined: Wed Jun 10, 2009 8:16 pm

Re: Handicap system

#20 Postby RMc » Sat May 09, 2020 10:10 pm

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
You do not have the required permissions to view the files attached to this post.

AlanF
Posts: 7495
Joined: Wed Jun 15, 2005 8:22 pm
Location: Maffra, Vic

Re: Handicap system

#21 Postby AlanF » Sat May 09, 2020 11:56 pm

Richard,

Touché!!! I'm impressed!

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

RMc
Posts: 117
Joined: Wed Jun 10, 2009 8:16 pm

Re: Handicap system

#22 Postby RMc » Sun May 10, 2020 1:00 am

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
Posts: 13
Joined: Mon Mar 16, 2020 6:36 pm

Re: Handicap system

#23 Postby Martin » Sun May 10, 2020 2:05 pm

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

Handicap_v0.1.xlsm
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