The collection of ALL data from CBS to a master excel log is almost complete. Once done, I'll be able to take any player, and highlight everything you'd want to know about them. Here's a preview of what this could look like, using B.J. Upton as our example.
B.J. Upton
Draft History
Date Pick Number Round Pick
1/27/2007 82 Round 11 Pick 2
3/30/2008 8 Round 1 Pick 8
3/21/2010 4 Round 1 Pick 4
3/20/2011 38 Round 5 Pick 6
2/21/2012 16 Round 2 Pick 8
3/23/2013 13 Round 2 Pick 5
3/11/2014 81 Round 11 Pick 1
3/25/2017 146 Round 19 Pick 2
Highest Pick: 4 Round 1 Pick 4
Lowest Pick: 146 Round 19 Pick 2
Keeper History:
2009 Kev Bombs (selected as the new franchise "keepers")
Champion History:
2012 Megalomaniacs
2013 Kingslayers
Transaction History:
Kept x1
Drafted x8
Traded x4
Service Time:
Team Days Total
Kingslayers 964 2 years, 234 days
Megalomaniacs 493 1 years, 128 days
Tommy Johns 372 1 years, 7 days
Pez Sox 363 0 years, 363 days
Ham Sandwiches 350 0 years, 350 days
Killer Pandas 337 0 years, 337 days
Two Starts 317 0 years, 317 days
Kev Bombs 71 0 years, 71 days
Kaiden's Krew 47 0 years, 47 days
Baseball Furies 1 0 years, 1 days
GM Days Total
Jon 1301 3 years, 206 days
Nick 735 2 years, 5 days
Dean 493 1 years, 128 days
Dan 350 0 years, 350 days
Bran 317 0 years, 317 days
Kev 118 0 years, 118 days
Mike 1 0 years, 1 days
Total Wombat Service Time: 3315 9 years, 30 days
Trade History:
Trade 1:
Player: Traded to: Date:
B.J. Upton Ham Sandwiches 6/26/2007
Fausto Carmona Ham Sandwiches 6/26/2007
for:
Reggie Willits Megalomaniacs 6/26/2007
Scot Shields Megalomaniacs 6/26/2007
Trade 2:
Player: Traded to: Date:
Joe Saunders Kingslayers 7/31/2007
Vernon Wells Kingslayers 7/31/2007
B.J. Upton Kingslayers 7/31/2007
for:
Ryan Garko Ham Sandwiches 7/31/2007
Gil Meche Ham Sandwiches 7/31/2007
Ichiro Suzuki Ham Sandwiches 7/31/2007
Trade 3:
Player: Traded to: Date:
B.J. Upton Megalomaniacs 5/3/2009
for:
Jacoby Ellsbury Kev Bombs 5/3/2009
Trade 4:
Player: Traded to: Date:
B.J. Upton Ham Sandwiches 5/3/2009
John Buck Ham Sandwiches 5/3/2009
Scot Shields Ham Sandwiches 5/3/2009
for:
Denard Span Megalomaniacs 5/3/2009
Mariano Rivera Megalomaniacs 5/3/2009
Rod Barajas Megalomaniacs 5/3/2009
ALL Transactions:
Add/Drop Transaction Type Team Date
Add Drafted Megalomaniacs 1/27/2007
Drop Trade Megalomaniacs 6/26/2007
Add Trade Ham Sandwiches 6/26/2007
Drop Trade Ham Sandwiches 7/31/2007
Add Trade Kingslayers 7/31/2007
Drop Not Kept Kingslayers 3/29/2008
Add Drafted Kingslayers 3/30/2008
Drop Not Kept Kingslayers 2/21/2009
N/A Kept Kev Bombs 2/21/2009
Drop Trade Kev Bombs 5/3/2009
Add Trade Megalomaniacs 5/3/2009
Drop Trade Megalomaniacs 5/9/2009
Add Trade Ham Sandwiches 5/9/2009
Drop Not Kept Ham Sandwiches 3/20/2010
Add Drafted Pez Sox 3/21/2010
Drop Not Kept Pez Sox 3/20/2011
Add Drafted Megalomaniacs 3/20/2011
Drop Not Kept Megalomaniacs 2/20/2012
Add Drafted Kingslayers 2/21/2012
Drop Not Kept Kingslayers 3/23/2013
Add Drafted Kaiden's Krew 3/23/2013
Drop Trade Kaiden's Krew 5/9/2013
Add Trade Killer Pandas 5/9/2013
Drop Not Kept Killer Pandas 3/10/2014
Add Drafted Tommy Johns 3/11/2014
Drop Not Kept Tommy Johns 3/18/2015
Add Waiver Killer Pandas 6/7/2015
Drop Waiver Killer Pandas 6/15/2015
Add Waiver Killer Pandas 4/16/2016
Drop Waiver Killer Pandas 5/10/2016
Add Waiver Two Starts 5/11/2016
Drop Not Kept Two Starts 3/24/2017
Add Drafted Baseball Furies 3/25/2017
Drop Waiver Baseball Furies 3/26/2017