I have been wanting to have this win prediction tool available for a while and finally have what I think is rather simple working model. This spreadsheet can be filled out with the players anyone thinks will be playing, along with their all their stats and then the team’s projected wins will be calculated.
Note: An error was found on the spreadsheet dealing with position adjustment and corrected around 4:30 EST on 11/4. If you downloaded it before then, you will need to re-download it. Sorry for the inconvenience. -Jeff
While it can be used to get an idea of how many wins a team might get in the up coming season, I plan on using it to evaluate changes in a team. Those changes could be a free agent signing, a trade, an injury or a rookie called up to the majors. The team’s expect wins before or after the roster change can be evaluated .
Today, I am not going to do look at any team. I just wanted to make it available and once the Royals sign Cliff Lee, I can see how their expected wins compare before and after the acquisition.
Read the rest of this entry »