Help me determine rate of imprement for my players!

September 19, 2009 1:28 PM

I coach a high school soccer team. Each practice we go through a routine which involves repetitions of various skills. The number of repetitions accomplished by a player for each skill is recorded in an excel spreadsheet for ranking purposes. I want to determine the rate of improvement so the players can see their progress and who's improving most. Is there a simple excel function that would help me do this?
posted by TheManticore to computers & internet (2 comments total)

I don't know if there's a formula, but you could try an entry in your table like this.
posted by I_pity_the_fool at 1:39 PM on September 19

The formula provided by I pity the fool is the correct one to use.
posted by dfriedman at 1:41 PM on September 19