Excel workbook to keep/track scores NFAA Indoor

SandSquid · 11-06-2008, 11:54 PM

To keep my wife's scores logged so we can track/analyze her scores during the current 5 week tournament, I've searched high and low to find an existing spreadsheet to keep score for NFAA blue and white 5-spot or single-spot targets. After no joy, I just slapped together a quick excel workbook ....
It works OK but I have not figured out how to count X's the way they are recorded on the score sheets.

This MUST already exist somewhere, no?Either I'm not searching by the right keywords, or I'm nuttier than squirrel p00p.

If I can't find a workbook already created or figure out how to interpret an "X" as a "5" and add it to the X column, I'll need to sit down and write an SQL application to do it, but I really done want to invest that much effort.

I'm also thinking this would greatly ease the administrative load on the organizers of the events to compute scoring and rankings etc...

SandSquid · 11-07-2008, 10:08 PM

Took me a while to figure out the formula to deal with the "X" score but I got it nailed down... If anybody wants to play with the spreadsheet PM me and I'll send it to you. I can't attach a .xls file here.

trinibob · 11-08-2008, 05:55 AM

Quote:

Originally Posted by SandSquid

Took me a while to figure out the formula to deal with the "X" score but I got it nailed down... If anybody wants to play with the spreadsheet PM me and I'll send it to you. I can't attach a .xls file here.

so whare is our copy ???

BowhuntnHoosier · 11-08-2008, 06:55 AM

I can't remember where I seen them but someone was selling archery logbooks either here or on AT. They looked very nice. Hope you find some.

Ancient Archer · 11-08-2008, 10:16 AM

=IF (ISTEXT(A1),5,"") or IF (ISTEXT(A1),5,0)

SandSquid · 11-08-2008, 07:22 PM

Quote:

Originally Posted by trinibob

so whare is our copy ???

I can;t upload the file here.. it only accepts : bmp gif jpe jpeg jpg pdf png psd txt
If it's take a .xls or .zip I could!

SandSquid · 11-08-2008, 07:31 PM

Quote:

Originally Posted by Bulls Eye

=IF (ISTEXT(A1),5,"") or IF (ISTEXT(A1),5,0)

Show off!
It took me two steps to do it:
1 )Test for value entered for X and if X assign value of 5, otherwise use the value entered : =IF(C9="X",5,IF(C9=" ",0,C9))

2)Give each X a "1" value =IF(C9="X",1,0) then sum

Mathews Man · 11-09-2008, 10:33 AM

Lancaster has a "archery league manager" but it is salty like $120 But this may be what you are looking for.