Post by ex-Pittsburgh Pirates on Sept 29, 2011 18:04:17 GMT -5
Really? That's a simple spreadsheet. The roster spreadsheet is some serious rocket science. Here's the formula in one of the cells that computes a player's salary: =IF(F20=2009.0,IF(E20=1.0,D20,IF(E20=2.0,D20*0.9,IF(E20=3.0,D20*0.85,IF(E20=4.0,D20*0.85,IF(E20=5.0,D20*0.8,0.0))))),0.0)
If that's not crazy enough, the cells that formula is referencing also have formulas almost as long. You'd be surprised how hard it was to code since our salaries are on a scale per the number of years remaining on the contract.
Jason Kubel was, at one point, a total stud... if only for a day. This spreadsheet also proves that my team is typically all hitting and no (relief) pitching...
Last Edit: Sept 30, 2011 16:55:55 GMT -5 by Deleted
Post by ex-Pittsburgh Pirates on Nov 10, 2012 18:36:04 GMT -5
Updated. Again, Blue Jays and Twins are way ahead of the pack if you aggregate all seasons. Unfortunately for them, we don't give out an aggregate trophy.
Post by ex-Pittsburgh Pirates on Oct 5, 2015 9:19:35 GMT -5
Maybe you find this interesting. Maybe not. Here's a spreadsheet showing the aggregate data from 8 years of Cashman.
Top 2 teams are tied...Twins and Pirates at 144 points apiece. If you were doing an 8 year world series, it would come down to the tie-breaker as the categories are tied 6-6.