|
Baseball Goodies If you find any errors or if you have any questions, feel free to email me at replaybaseball@aol.com (Mark Miller) To see what programs I personally run on my PC, scroll down to the bottom section. . . . . . . . . . . . . . .
. . Cleaning
. . . . . . . . . . . . . . . . |
|
Last Updated: [ Sunday, April 20, 2008 10:38:45 AM ] |
|
|
![]() |
![]() |
![]() |
![]() |
![]() |
NOTICESRecipients of Retrosheet data are free to make any desired use of the information, including (but not limited to) selling it, giving it away, or producing a commercial product based upon the data. Retrosheet has one requirement for any such transfer of data or product development, which is that the following statement must appear prominently: The information used here was obtained free of
charge from and is copyrighted by Retrosheet. Interested
parties may contact Retrosheet at 20 Sunset Rd.,
Newark, DE 19711.
www.retrosheet.org
NEW ADDITIONS!
January 17, 2008 BF and R ratings for pitchers 1876-2001 ZIP file uploaded. January 2, 2008 Uploaded all files with updated information, including 2007 season. BASEBALL GOODIES.MDB (MS-ACCESS Database - 33MB) is now available. You can get all the downloadable files in the ACCESS database instead. December 28, 2007 Removed Auto-Play V4 ZIP files Added Auto-Play V5 ZIP files (V5 added real-life winner option and complete as-scheduled schedules) Auto-Play V5 of 2006 and 2007 1871 to 2007 available in Auto-Play format (prior to 1880 there are no as-scheduled schedules) V5 of Auto-Play Enhancements: 1 - Added more season as-scheduled schedules 2 - Added real-life winner option for determining winners 3 - Correctly handles forefeits (V4 did not) November 14, 2006 Added "Baseball Schedules" zip file (1MB). Not my creation, but someone did a wonderful job. This has starting pitchers were the data is available. See link below. May 20, 2006 Added Auto-Play 2005 version to decades download below (2000-2009) Restored Auto-Play zip files for 1890-1899 and 1900-1909 (removed due to lack of disk space) New seasons added (1937, 1968, 1994, 1995, 2005) from ATMgr files (transactions and lineups) A number of seasons had minor corrections and have been uploaded (1927, 1947, 1948, 1950, 1961) Opening Day Rosters ZIP file updated to include new ATMgr seasons (1937, 1968, 1994, 1995, 2005) Complete Team Rosters ZIP file updated to include 2005 Season Enhanced As-Played Lineup ZIP files updated (All seasons listed above may have had changes) Most Common Lineups ZIP file updated (includes all seasons listed above - new and possible corrections) Suggested Lineups ZIP file updated (includes all seasons listed above - new and possible corrections) ATMgr Transactions ZIP file updated (includes all seasons listed above - new and possible corrections) (No schedule file or transactions for 2005 available on Retrosheet as of May 20, 2006) |
Auto-Play - Use Auto-Play to determine winners and losers for as-played and as-scheduled schedules. You can roll some games and let Auto-Play play the others. You have the option of using actual results or Log5 method to determine who wins. Requires MS-EXCEL. Each season is it's own spreadsheet, but multiple seasons are zipped up for downloading.
In the 1981 Bill James Baseball Abstract, Bill introduced the log5 method to answer the question, "how often should team A be expected to beat team B?" It took him several pages to describe and justify the method, so we won't take the space to do all of that again here. Instead, we'll just give the formula:
A - A * B
WPct = -----------------
A + B - 2 * A * B
where A is team A's winning percentage and B is team B's winning percentage.
In other words, if you have a .600 team playing a .400 team, this method shows that the better team can be expected to win 69.2% of the games between these two teams:
.600 - .600 * .400 .360
WPct = ----------------------------- = ------ = .692
.600 + .400 - 2 * .600 * .400 .520
Just in case the link is ever down, I have copied the above from www.diamond-mind.com. The actual link is:
http://www.diamond-mind.com/articles/playoff2002.htm
Opening Day Rosters - All the opening day rosters that come courtesy of Gary Leven's "ATMgr for BBW" files (http://groups.yahoo.com/group/ATMgrForBBW). This is a CSV file that you can import into a spreadsheet or database. One file contains all 79 seasons available.
Complete Team Rosters - Every player for every team (with fielding positions). All courtesy from Sean Lahman's database (http://www.baseball1.com). These are CSV files that you can import into a spreadsheet or database. All 137 seasons are grouped in 5 text files in one zip file.
Enhanced As-Played Lineup Files - All but 1 season is from Gary's ATMgr files. 1992 is from Retrosheet's game logs (http://www.retrosheet.org). These are CSV files that you can import into a spreadsheet or database. Each season is it's own separate CSV file. Multiple seasons are zipped up. These are enhanced with 2 new features: (1) fielding positions are alpha instead of numbers and (2) the starting pitcher's throwing hand is a new field. Note - The data on some older players is incomplete, so if Sean Lahman's database listed a throwing hand of "blank", I made it a R. Not perfect, but close enough for jazz.
Transactions - There are 3 main sources for transactions. (1) Gary Leven's ATMgr files, (2) Retrosheet's file and (3) an old spreadsheet that I downloaded that I believe Kerry Leibowitz had posted (not for sure the data source). Individually, I don't think any one source is 100% complete, but I have made all 3 individual sources available, plus I have all 3 sources combined into one zip file, broken out as 3 groups of seasons. The problem is that it was next to impossible to avoid having duplicate (or even triplicate) entries with the combined source, since all 3 sources use different naming conventions/standards/formats. These are CSV files that you can import into a spreadsheet or database.
Most Common Lineups - For the 80 seasons that have as-played lineups, this text file shows for each team, the most common lineup they used versus a LHP and a RHP for that specific season. Starting player names only. No match was done by actual position. Just the same exact batting order. Pitchers are excluded from the list, so you will see a blank where the pitcher batted, meaning the other 8 guys determined the most common lineup. From an historical perspective, looking at all 80 seasons together, the 1984 Boston Red Sox lead the way with the same lineup used versus a RHP at 66 times. There are only 37 teams over the course of these seasons that used the same lineup versus a RHP more than 30 times. For most seasons, you typically see the same exact batting order used less than 15 times. Interesting stuff, although, I don't know how it might be used in a replay project to be honest. It does show that it is really difficult to nail down one suggested lineup that would match most games played in a given season, just because teams don't typically have just one set lineup.
Suggested Lineups - For the 80 seasons that have as-played lineups, this text file shows for each team, a starting 8 or 9 batters (non-DH have 8, DH have 9, obviously) and their position. To determine the batting order, please refer to the next 9 columns after their name. This will tell you how many times they batted in each slot (leadoff (1st), 2nd, 3rd, etc.). As a guide, any number that has an (*) next to it means that this is batting slot that this batter was slotted the most. There will be some ties among the players, so you can decide how to break those ties. There is a vs. LHP and vs. RHP lineup available for each team.
Unless noted, the downloads should be less than 1MB. Some are quite large (4 to 7MB).
versions of Opening Day Rosters, Complete Team Rosters, Suggested Lineups, ATMgr Transactions and Kerry Leibowitz Transactions are available for any season by emailing me with your request. At some point, they may be made available as a download. Simply email me at replaybaseball@aol.com and let me know what season(s) you want PDF reports.
***Note - You can also email and ask for PDF versions of the as-played lineups, or if you have MS-EXCEL, I can load the text files (or you can do it yourself, if you are comfortable with importing text files).
| Auto-Play
V5 (requires MS-EXCEL)
* NOTE * V5 DOC tab states to look for "things" under the OPTIONS menu bar. That needs to read
"AUTO-PLAY" on the menu bar. At this point, I don't feel like
modifying 130-some odd spreadsheets for documentation purposes. |
| Baseball Goodies (requires MS-ACCESS) |
| Baseball Goodies MS-ACCESS DB (has all downloadable files in one file) |
| Rosters |
|
Opening Day Rosters |
1901-2007 | 75 seasons - only those from ATMGR |
| Complete Team Rosters (with Positions) | All seasons from Lahman DB |
| Enhanced As-Played Lineup Files |
| 1901-1939 | 1940-1949 | 1950-1959 | 1960-1969 |
| 1970-1979 | 1980-1989 | 1990-1999 | 2000-2007 |
| Transactions |
| ATMGR Transactions | 1901-2007 | 75 seasons - only those from ATMG |
| Retrosheet Transactions | 1874-2007 | 128 seasons from retrosheet.org |
| Kerry Leibowitz Transactions | 1901-1998 | 98 seasons (old excel spreadsheet) |
| All 3 sources combined (1.83MB) | 1874-2007 | 129 seasons (will be duplicates) |
| Lineup Analysis |
| Most Common Lineup (vs LHP/RHP) | 1901-2007 | 76 seasons |
| Suggested Lineup (vs LHP/RHP) | 1901-2007 | 76 seasons |
| Baseball Rule Changes (PDF) | Auto-Scoresheet | Auto-Stat | Replay Baseball Game Seasons | 162 Rare Plays for any baseball board game | Baseball Schedules |
| BF and R ratings (1876 to 2001) | . |
|
Other Websites |
|
Protect your PC!!!!!!! Rule #1 - Install ONE FIREWALL
Burning data to a CD is a cheap way to back up your data. Nowadays, you can pick up a DVD burner and burn 4GB of data. This should be done on an interval that is often enough that you won't lose much recent data. That amount depends on how much you can stand to lose. Even if you don't back up everything, ask yourself this question: "If I lost <insert file/program name here> today, would I be in a world of hurt? Could I recreate it? Could I reinstall from the original? Can I redownload it?" If you can't answer no to the first question or yes to any of the others, then for all means...put that puppy on a CD!
Unplugging the cable from the modem to your computer does not stop someone from using your wireless connection. You need to enter a password and then generate a key (which is needed to get into the connection). If not, you run the risk of leaving your connection wide open for anyone to use. Not all SPYWARE/ADWARE programs are safe. I am listing the programs I personally use below. |
|
End of Document |