A fellow archer here in Victoria that I met at the Vic Fish and Game Club by the name of Lyn sent me a basic 3-D Shoot Score Card.
I've messed around with it and added a number of sheets and calculations. The first sheet can be printed out and used while out on the course to mark your score. This was the beauty of Lyn's original design. Just check off your score on a given target and easily add them up to get your score. Way better than trying to write the number down in the rain!!
When you get home to the computer open you score card, select an event tab (sheet) at the bottom of the workbook, and enter the scores for each target. It will automatically calculate the totals and percentages for you. Then click on the Annual tab, name the Event, and enter the totals for your morning and afternoon, click on the number of competitions and insert the appropriate number... bad-da-bing it will calculate averages over that number of events.
I don't know how to make it autofill the Averages Sheet from the Event Sheets which would make the whole thing really cool... hint... any excel whizzes out there??
You can download your copy from my site at http://www.members.shaw.ca/btozer/Em...-D%20Score.xls
Enjoy