Tracking Stats

[nevdully's]

Can anyone teach this old dog a new trick?

[AeroDave10]

What trick do you want to learn?

[nevdully's]

How to do it...the whole 9 yards....Starting with the simple question is Excel the best to put them on?

[AeroDave10]

I use Excel for a lot of SOM related stuff. It's good for calculating things on large groups of data very quickly. "Tracking stats" still sounds pretty vague to me. What exactly do you want to track?

[nevdully's]

I'd like to keep my cumulative actuals just like diamond dope

[childsmwc]

Nev,

If you are trying to keep a data base of your historical stats, Access might be the better long term solution over Excel, since it is a data base program. I however am not an Access user, so anything I do is in Excel. Excel will however slow down if you track enough data, and then have too many pivot tables and other reports and formulas running in the background/foreground.

Because Access is a data base it typically runs better and can handle larger blocks of data over Excel. If you are comfortable with pivot tables and the like in Excel, you can still house the data in Access and run pivot tables against the data so your outputs are in Excel.

Mark