…and if you want add another hitter, you can do so. This is how it looks with just three hitters entered… If you add a game’s stats to Jerry Ribbie’s sheet for example, his totals immediately and automatically get updated on this sheet. All data is linked to this sheet from the individual players’ sheets described above. Once I got this worksheet set up the way I wanted it, I don’t edit this sheet in any way. Here’s an example of a pitcher’s worksheet. Also, the formatting of the ‘Game’ column can be in number format as shown above or date depending if you’re doing a tournament/short season or a more strict season replay.Īs I mentioned, each player and pitcher on the team has his own worksheet. It certainly wasn’t necessary but I liked it. One of the features I added was a instant total line at the top so it gets immediately calculated as you enter in stats. Almost all stat entry takes place in these worksheet pages. With the system that I use, each file represents one team and each player has his own worksheet within the spreadsheet. Note: when you delete the stats for your own use, delete them from the player’s worksheet NOT from the Team worksheet. You can delete the stats from the individual players’ worksheets and use it how you wish. Just playing with the method of keeping stats is part of the fun for me.īecause the Monsters-Terribles project is a little unconventional to put it mildly, I’ve created a spreadsheet with some fictional names who play for the “Hometown Champions” and some random stats in the sheet just so you can get a sense of how it works. ![]() For now, I’m pretty tied to my method of keeping stats using Excel simply because I can customize to my needs. For those interested, Jeff Pappas did review of BallStat on The APBA Blog a while back. It honestly sounds like quite a program and I tell myself I really should try it some time just so I can properly review it. I believe I’ve made a version of this available before but since then, I have refined it a bit and made some revisions that make it work for me a lot better.īefore I go on, I know a lot of you have used BallStat and are quite happy with it. ![]() Once I started filling in the names and stat data from the MCM-TCT project, it worked like a dream.īelow, I’m linking my team spreadsheet that I’m using for the MCM-TCT project. Then I cleared all stat data from it including players’ names. I made a copy and renamed it to something more appropriate. I really just had to copy one team spreadsheet from my current 1966 replay stats setup and use that. That was part of the fun, right? To establish how bad the Terribles were as opposed to the mighty Monsters.īut did I really want to re-invent the wheel? Did I have to re-create a whole new stats environment within Excel for a simple 21 game project?įortunately, no. As I’ve begun my little 21-game project between the Monday Monsters and the Tuesday Terribles, I of course wanted to keep stats.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |