| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Anyone have an Excel template for Skeet /Trap Scores?
We would like to keep records of scores on an Excel file. Anyone been there?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Anyone have an Excel template for Skeet /Trap Scores?
Do you want a shot by shot scoreboard, or do you just want to keep records of
total scores per shoot? Shot by shot: Col A = Name of Shottist, Col B Membership nr, Col C:AA contains either "0" or "1" for your 25 shots, Col AB is the score for the shoot. Formula = IF(SUM(C2:AA2)=0,"",SUM(C2:AA2)). You can get fancy and devide the 25 shots into the five stations if you wish. All depends on what stats you want to be able to pull. Total Scores is very straightforward, having name, number and score. "Ed in Mesquite, TX" wrote: We would like to keep records of scores on an Excel file. Anyone been there? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Anyone have an Excel template for Skeet /Trap Scores?
Of course, if it is an inter club shoot, you will need a column for the club
name as well, which will require a slight adaptation of the formula. Iso C2:AA2, it will become D2:AB2 "Ed in Mesquite, TX" wrote: We would like to keep records of scores on an Excel file. Anyone been there? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I have Excel cells populate a Word label template? | Excel Discussion (Misc queries) | |||
| Help with Default Excel file and template | Excel Discussion (Misc queries) | |||
| How to create default template in Excel 2002 | Excel Discussion (Misc queries) | |||
| excel template wizard | Excel Discussion (Misc queries) | |||
| How do I auto number cells in an Excel template? | Excel Discussion (Misc queries) | |||
Linear Mode
