Jason Dobbs' 1800 administration spreadsheet for Excel

Go down

Jason Dobbs' 1800 administration spreadsheet for Excel

Post by Rob Kovach on 9/4/2017, 3:17 pm

Please see Jason Dobbs' great spreadsheet for administering 1800's:
I hope I didn't wreck anything when I cleared out the competitor info....

His developer notes follow:

Rob - 
 
Here is what I've been working with for the MFRGC matches.  The main power of this sheet is on the 1800 tab.  Most of the 'fancy' excel stuff happens there.  If you have someone who knows excel - they could probably figure out what's going on, though it's always tricky to reverse engineer someone else's spreadsheet  :-)  I think most clubs use Excel to help format their results sheet, but ultimately everything is calculated manually.  For smaller matches that can work, but I think it makes it easy for there to be errors.
 
With some work, this could be extended to allow for a 2700 - I could do that pretty easily I believe.  This isn't perfect, and I'm sure improvements could still be made.  I'll be interested to take a look at the other sheet you mentioned.  Might give me some ideas for this one.
 
 
Below are some high level notes about the tabs in the sheet:
 
 
SHOOTERS Tab: All the shooters that have shot at our club - this drives the drop-down boxes for the 1800 Tab and NRA Reporting tabs.  
 
1800 Tab: 
    Column C: Drop down box that pulls Names from the Shooters Tab.  
    Gray colored fields are cleared out (deleted) for a new match.  All others fields should not be touched as they contain formulas that need to stay.
    When adding additional shooters to a category, you must be careful to copy and entire row in that class, then insert / paste it back to ensure the formulas stay correct.
    There is conditional formatting that highlights the winners in green automatically.
    There are lots of hidden columns that do the calculations for who one each match (class and overall) that considers both raw score and X-Count to determine the winner.
    The match winnings (dollar awards) is a bit complicated and probably needs some re-work, or that could just be done manually.  It's setup for the MFGRC fall match.
    
NRA Reporting Tab: 
    Selecting the drop down in the NAME Column, you can choose the shooters that were at the match, and all pertinent information will be pulled in automatically after the name is chosen.  You will need to enter the number of shots fired manually.
 
EIC Service Tab: Manual record, not used this year.
 
Score Check: Quick score checking template so each shot can be entered to verify individual scorecards.  The sheet adds up the totals for each match and aggregate. I entered the X's as 10's in the fields, then just typed the X Count for each target manually.
Attachments
MFR&GC 08-06-17 1800 Match.xlsx You don't have permission to download attachments.(76 Kb) Downloaded 48 times
avatar
Rob Kovach
Admin

Posts : 2702
Join date : 2011-06-13
Age : 44
Location : Brooklyn, WI

Back to top Go down

Re: Jason Dobbs' 1800 administration spreadsheet for Excel

Post by fc60 on 9/6/2017, 12:55 pm

Greetings,

AttachmentsMFR&GC 08-06-17 1800 Match.xlsx You don't have permission to download attachments.(76 Kb) Downloaded 0 times
Unable to download? Change permissions for all users? chmod 777 ?

Cheers,

Dave
avatar
fc60

Posts : 341
Join date : 2011-06-11
Location : South Prairie, WA 98385

Back to top Go down

Re: Jason Dobbs' 1800 administration spreadsheet for Excel

Post by Rob Kovach on 9/6/2017, 4:43 pm

oh crap....Sorry...Downloads are now enabled....
avatar
Rob Kovach
Admin

Posts : 2702
Join date : 2011-06-13
Age : 44
Location : Brooklyn, WI

Back to top Go down

Re: Jason Dobbs' 1800 administration spreadsheet for Excel

Post by Wayneinky on 3/10/2018, 12:37 am

Just found this, thanks for posting. I am in a small group that meets once a week for a little shooting fun. I will try to adapt this for your use.
Thanks again
avatar
Wayneinky

Posts : 9
Join date : 2017-07-04

Back to top Go down

Re: Jason Dobbs' 1800 administration spreadsheet for Excel

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum