Tracking your scores

[Marcus]

For over a year now I have been tracking my scores in a database system I have built (and am hoping to release on PC soon)
What I have found very usefull about it is using it to identify not only what my best scores, but also my average and an off night. Another great feature is finding out if a change made was for the better or not. Having done this for a year now I am convinced that every archer can benifit from it greatly.
Here are some examples

http://panther.kitsune.com.au/image_upload/indoor_details.gif

Here is a detailed look at a round shot.
I have records of the date, the round, the score, the X count, the rating, any notes on the round, where it was shot and if done in practise or competition.
I also record the equipment used with it. This is vital so I know if a certain bit of gear has lead to a decline in scores.

For example my average indoor score with different release aids:
Carter Just Cuz: 294.84
Carter Insatiable: 294.22
Carter Atension: 291.89

Which says, keep the Just Cuz.

I can also see the rounds in a list format
http://panther.kitsune.com.au/image_upload/indoor_list.gif

This is of huge advantage as I can see at a glance that have improved.

Finally I can export into Excel and create a graph

http://panther.kitsune.com.au/image_upload/indoor_avg.gif

This graph shows Aust 1 Indoor rounds in blue and the pink shows the running average. So while I and not consistant (many peaks and valleys) the pink line shows I am improving. All I try and do is keep the blue above the pink line and I don't worry. Even 1-2 points under is OK, as long as my recents rounds have been good.
The good thing with this is that I use to stress out about shooting lower than my expectations. Now, although I expect to shoot 296+ I don't get upset if I don't.

Do others do this?

[Eberbachl]

Nice work! I used to keep all of my scores in Excel - just a simple spreadsheet - but I've been very lazy, and haven't added a score to it for ages.

I'm sure it's something I should be doing!

Your system looks great :wink:

[The One]

Seems like a great idea marcus!

[Kuru]

Looks great dude !

[clever_guy]

Already did it in T-SQL with a MS Access Frontend..

;) :lol: :lol:

Great minds think a like..

-CG

[Steve B]

really like the concept of doing that Marcus very nice indeed. Looking forward to it being released in the pc format.

CG, is yours for public release or just something you have done for yourself ? (had to ask as I am not a programmer in any way, shape or form)

[clever_guy]

Just a fun DB dev project. Mine is more of score/training DB, I have no plans to release it. It is pretty easy to make up a basic one in MS Access though.

-CG

[Bruce]

Marcus , I reckon you could do that well on palm as well using filemaker so you could score straight onto the palm and then when you hot sync it would put the data into your database on the computer.

[Harald]

Made something to log your score in eVB 30 for Pocket PC 2002. is slowly porting it to VB .NET Worked fine for logging the data and now using SQL CE database should be even more easy to import into ms axcis excel or whatever. Too lazy to finish the analyze bit but might do it in a couple of months.

BTW Can't find a graphic object for visualizing graphs in Visual Studio .NET for smart devices. Have to make the drawing of a curve myself. Think you should be able to define a circle by three points with X,Y defined coordinates on it's ring. Anyone remembers this formula??
Must be some tangens/cotangens tanga thing.... :bday:

Where is that Pythagoras guy when you need him...?? :fist:

[Marcus]

Marcus , I reckon you could do that well on palm as well using filemaker so you could score straight onto the palm and then when you hot sync it would put the data into your database on the computer.I agree Bruce, IF I could get Palm to connect to my Mac. Stupid software!

[mbomike]

How hard would it be to have that connected to our profiles (hidden or not).
We seem to spend most of our time on this forum, why not place our scores on here as well, when we return from a shoot.
IMO :D

[Eberbachl]

Marcus , I reckon you could do that well on palm as well using filemaker so you could score straight onto the palm and then when you hot sync it would put the data into your database on the computer.I agree Bruce, IF I could get Palm to connect to my Mac. Stupid software!

A Palm version would be awesome!

:D

What version of Palm Desktop have you tried Marcus - works OK here with Palm Desktop 4.2.1...

[grantwomack]

I've thought about building a database that includes round shot, date and conditions. It will calculate the handicap (based on GNAS handicap ratings), plot your handicap for the round on a graph that shows other scores from the same round or from all rounds combined, in a specified period of time. I started but never got very far due to the time it would take and my severe inability to use MS Access these days.

Anyone have something that would work as a substitute?

[clever_guy]

grantwomack;

TargetPlot does some of that, you need a Palm though to get the most out of it.

What you are looking to do is pretty easy in MS Access, you just have to learn how to use the designer interface, it's all pretty much canned. I think you just need to pick up a good Intermediate/Advanced book on MS Access, and there are 100 of them out there. Trying to learn how to build an Access database using just the helpfile can be a pretty high (and frustrating) learning curve. At worst you can export in *.csv into MS Excel like Marcus is doing for the graphs. I doubt it would take you more than a few hours to knock something out.

-CG

[Marcus]

Yeah nothing in this DB is overly complicated. However it does have more than you would want from an Excel spreadsheet.
Files: 3
Archery Log
Archers
Rounds

Fields in Archery Log: 67
More complex stuff
Score totals calculated
Averages
distance average
tournament or practise flag
Above or Below Average
Running total
Running Average
Inner 10 Score If round is Aust 1 indoor


So nothing fancy, all Excel doable.

Luke, just looked, may be an old version, will try again

[clever_guy]

"Files: 3 Fields in Archery Log: 67"

Pfftt..now I am feeling anal-retentive, I think I have about 25 tables, and 300 fields, 10 stored procedures I wrote, and not to mention the annoying VB code in MS Access to make it work well with SQL..

:o :lol: :lol:

Of the worst part is as you are developing it, you just *know* that a simpler version just in MS Access would work just as well, and would eliminate half the complexity just using a standarc MS Access *.db..

:P :lol: :lol:

-CG

[Bruce]

Marcus , I have no problems syncing my palm with either machine . I use filemaker mob 2 and filemaker 6 .

I think it may be because you are using an old op system on your desktop

[Michigander]

You should consider marketing this on a disc Marcus.Being almost completely computer illiterate,I'd certainly buy one for score tracking........if nothing else watching your average after changes made to yor bow then entered onto a graph would be money well spent.
Jerry

[Marcus]

I have just gotten a copy of Filemaker Pro Developer and my first project with it will be making this app a Mac/PC one so people can download and use.
It will be free.

[grantwomack]

It will be free.
Great to hear! That's what makes this forum so popular - the fact that people are willing to share and aren't always after the quick buck!

[Marcus]

Here is the Mac OS X Version

http://www.kitsune.com.au/downloads/archeryforumlog.zip

[Eberbachl]

Thanks Marcus - I'll play with that when I get home :wink:

[Michigander]

Very good of you,will this link work for windows 98?
Thanks,
Jerry

[Marcus]

I don't think so, but have not tried yet. Still looking into how to make it for PC

[Shannon Hearse]

Here