Here’s my overall plan for this project. No telling how far I will get, but these are the goals that I am working towards.
- Create MySQL Database for Out of the Park Baseball data
- Define and Create Tables
- Define Primary Keys
- Create views and additional tables to calculate statistics
- Batting Stats
- The traditional counting and rate stats
- wOBA
- wRC
- wRC+
- wRAA
- OBP+
- BABIP
- K%
- BB%
- BB/K
- Pitching Stats
- The traditional counting and rate stats
- FIP
- xFIP
- WHIP
- ERA-
- FIP-
- xFIP-
- GB%
- FB%
- Search for players based on their organization
- Search for players based on their current defensive ratings
- Create a presentation layer in Excel to display the above stats in a meaningful way based on current year, last 3 years, and career timeframes
- Create a web based presentation layer
- Create a configurable utility in one or both of the above presentation layers to create and display results of ad-hoc queries
- Batting Stats