Combining a couple of my previous article on UZR projections (now updated with UZR/150 values) and the wOBA to WAR conversion, I have created a spreadsheet to project 2010 WAR values of most FA hitters and determine how much money should be spent for the player's production for a multi-year contract.
Here are the 20 top projected free agent position players:
|Rank||Name||2010 Projected WAR||Position||UZR/150||OBP||SLG||PA|
Instructions and assumption on using the spreadsheet after the jump.
UZR/150 values were used.
Projected hitting values are from Chone's projected batting values. I didn't need to have BA included, but I kept it there to make the cut and paste easier from Chones projections page.
To calculate the the wOBA, I used (1.66 * OBA + SLG)/3 = wOBA where the 1.66 from determining what multiple helped to predict the wOBA best for all qualified 2009 hitters.
I used 4.4 million dollars per WAR as the rate to paid for all years the player signs. The user can feel free to change these values to what ever value they want.
Each player was projected to age by 0.5 WAR per year not matter what their age is currently. Most are over the age of 31, so I don't see this as a problem. If the user want to change these values in the cells, feel free.
To get the ideal contract value for the projected WAR, goto column Y on the spreadsheet. Columns Y, Z and AA are the values projected for a 1 year contract in 2009 using the above assumptions. These values continure for up to eight years. For example, a 6 year contract for Matt Holliday would be worth 90.4 millions dollars according to the methods I used in the spreadsheet.
Players can be added and values changed as the user see fit.
Let me know if you have any questions or comments.