Trending information - John

[spili2]

I am using iScore extensively and have scored 23 games so far this season...with lots more to come.

Another parent has a similar scoring application on his Palm. I haven't used it but understand that is has a "trend" indicator -- such as an up arrown in green, or a down arrow in red -- showing each team player's hitting/pitching/fielding trend based upon the last 3-5 games...which may be selectable.

Is there a similar way to see how each player is trending using iScore?

The only way I can manually achieve this (to my knowledge) is to take each game's Excel sheet and manually determine the performance of each player to see if they are going up or down in each category (hitting average, fielding percentage, ERA).

Does this feature exist in iScore?

Thanks in advance.

[FTMSupport]

We do not have any kind of "trending". There is a user in one of the threads that was working on a spreadsheet to supply this type of functionality from the CSV exports... not sure how far he got, but if he sees this, maybe he can respond.

[OhioTex]

Here is the post FTM is referring to from tragus.org

I'm working on something like that for Excel in my spare time but haven't had much of it (spare time, that is) lately. See my thread here: viewtopic.php?f=3&t=1477" onclick="window.open(this.href);return false; My current strategy is to paste the stats.xls data into a monster spreadsheet that will calculate the cumulative stats for graphing. At the moment I have it graphing a single batting stat that you pick from a list. If anyone comes up with something before I manage to post a solution you can count me in as a beta tester!

[iscore@tragus.org]

That's me...

I haven't had a lot of time to work on it lately but I did make some progress today. I have a relatively easy way to paste the stats.xls data in and I have sheets with "rolling" numbers for Batting, Fielding and Pitching stats. There are also per-player sheets which capture these rolling values for graphing.

I've run into a one thing along the way:
In the Pitching and Fielding sheets of stats.xls the player numbers are coming in as text rather than numeric. That's wrecking my vlookup() functions until I force them to numeric. I don't know if the data is generated that way on purpose or not but if can be made numeric there (or text on the Batting sheet), the consistency would be a big help.

Also, my OBP and BAA values are incorrect because, as noted in the other thread, iScore doesn't give me counts for SacBunt, SacFly or Catcher Interference that are required for that statistic.

Anyway, I have it available if anyone would like to take a look. What's the preferred approach for sharing? My basement-dwelling servers don't have a lot of bandwidth so that's probably not the best choice.