Tracking Stats
Posted: Sat Feb 04, 2012 7:19 pmCan anyone teach this old dog a new trick?
Archive of SportingNews.com's old SOM Baseball forum
http://forum-365.strat-o-matic.com/archivesn/
Tracking Stats
http://forum-365.strat-o-matic.com/archivesn/viewtopic.php?f=13&t=628293
Page 1 of 1
Posted: Sat Feb 04, 2012 7:19 pmPosted: Sat Feb 04, 2012 7:49 pmWhat trick do you want to learn?
Posted: Sat Feb 04, 2012 9:45 pmHow to do it...the whole 9 yards....Starting with the simple question is Excel the best to put them on?
Posted: Sat Feb 04, 2012 11:37 pmI 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?
Posted: Sun Feb 05, 2012 11:09 amI'd like to keep my cumulative actuals just like diamond dope
Posted: Sun Feb 05, 2012 2:13 pmNev,
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
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