Team score tracking spreadsheet


PDA
bdutton
March 15, 2007, 01:23 PM
I shoot in a bullseye league, national match course of fire (10 shots sf, 10 shots tf, 10 shots rf).

I have uploaded the latest version of it on my website: http://www.nepistol.com downloads section.

Feel free to download and modify if you wish.

Features:

10 Team Members
Individual score entry
Automatic shooter totals
Individual average
Team averages
Individual Scoring potential (max of each course of fire added together)
Potential Team Score (requires editing to sum correct columns)
Team match score (requires editing formula to sum correct columns)
Individual shooter Average charting
Individual shooter course of fire charting

EDIT: I just added some trend lines to the charts.

This can also be useful for bullseye shooters who want to track their shooting scores individually. It's not just for team captains.

If you enjoyed reading about "Team score tracking spreadsheet" here in TheHighRoad.org archive, you'll LOVE our community. Come join TheHighRoad.org today for the full version!
lil ski
March 16, 2007, 07:56 AM
Looks very good. Do you track Xs also on any of your sheets.

bdutton
March 16, 2007, 08:10 AM
No...not yet

If you enjoyed reading about "Team score tracking spreadsheet" here in TheHighRoad.org archive, you'll LOVE our community. Come join TheHighRoad.org today for the full version!