Hi all, I've been asked to help keep/calculate scores at our winter 10M air pistol league. The gent that has been doing it (for 41 years) does it all by hand.
I'm thinking there has to be a handy Excel file/ simple program out there to calculate /track weekly standings, shooters average, agrigate team score, etc. Can anyone help me out. I'd like to assure I get this right and timely.
Keeping Score- Help Please.
Moderators: pilkguns, m1963, David Levene, Spencer, Richard H
-
weehooker
Thanks
My Excel skills are a little rusty. I'll try the google thing. I'm just figureing that I'm nto the first person not to want to do this by hand.
As for postings, that is the point. If I automate, I can post the standigns every week. I jsut don't have the time to spend to do it all by hand. I know I will fall behind.
As for postings, that is the point. If I automate, I can post the standigns every week. I jsut don't have the time to spend to do it all by hand. I know I will fall behind.
-
Freepistol
- Posts: 773
- Joined: Sun Feb 10, 2008 5:52 pm
- Location: Berwick, PA
Here's a start for you to keep individual scores:
I used it to keep track of my FP scores and number of rounds fired as well as average, moving average, and number of rounds in each scoring ring. Delete that which is unnecessary for your use. You'll need to add a page that transfers the weekly score and average of each shooter, but that's easy.
HTH
Ben
I used it to keep track of my FP scores and number of rounds fired as well as average, moving average, and number of rounds in each scoring ring. Delete that which is unnecessary for your use. You'll need to add a page that transfers the weekly score and average of each shooter, but that's easy.
HTH
Ben
- Attachments
-
- AP.xls
- Air pistol stats
- (30 KiB) Downloaded 146 times
I took over scoring responsibilities last year from a guy who was doing it all by hand. He used some spreadsheets but only as a table to print; there were no formulas. I created a spreadsheet that does everything in one workbook. Basically all you do is enter the scores and the spreadsheet does results, grades, points, handicaps, number of shoots, etc. I've never implemented an average feature since nobody seems to care. To be honest, some parts were annoying to code, but there's a way around everything and it works perfectly now.
My club scoring spreadsheet wouldn't really help you, since it's for all ISSF pistol matches, only caters for my small club, and doesn't (yet) work out averages for shooters (I have my own spreadsheet for that.) My advice would be to sort out the layout of the sheet, then start coding the formulas. As mentioned before, Google is your friend, but if you need advice about how to approach some particular feature then post here and I should be able to help. Unless there is someone here who is an Excel whiz and isn't a self-taught hack like me, in which case I will defer to their expertise.
My club scoring spreadsheet wouldn't really help you, since it's for all ISSF pistol matches, only caters for my small club, and doesn't (yet) work out averages for shooters (I have my own spreadsheet for that.) My advice would be to sort out the layout of the sheet, then start coding the formulas. As mentioned before, Google is your friend, but if you need advice about how to approach some particular feature then post here and I should be able to help. Unless there is someone here who is an Excel whiz and isn't a self-taught hack like me, in which case I will defer to their expertise.
I use Google Docs to keep track and publish the results of the Canadian Airgun Forum monthly postal match. http://cafpostal.blogspot.com .
Just head over to docs.google.com, register an account and then open an account on blogspot... "Publish to web" fuction in Google Docs... copy paste and you're done.
Just head over to docs.google.com, register an account and then open an account on blogspot... "Publish to web" fuction in Google Docs... copy paste and you're done.
-
Raymond Odle