Wednesday, July 11, 2007

ZiPS In-Season Projection Tool, v. 3.1

This is the updated projection tool to calculate rest-of-season projections based on 2007 ZiPS Projections and the current up-to-date stats of any player. As is generally the case with spreadsheets I release to the public, green fields are for putting stuff in, yellow fields are values the spreadsheet calculates, and gray fields are the ones you shouldn’t touch unless you want to muck up a formula or something.

The only field that should be confusing is the player name at the top left. Enter in the player you want to project, a comma, and then no space before the first name. This should be apparent from the example already entered in, but it’s always good to head off these questions at the pass.

Red Sox’s Nation’s Favoritest Middle Infielder of All Time is an ideal example. Oh, I’m talking about Julio Lugo.

Reader Comments and Retorts

Statements posted here are those of our readers and do not represent the BaseballThinkFactory. Names are provided by the poster and are not verified. We ask that posters follow our submission policy. Please report any inappropriate comments.

Thanks Dan, I only asked because build 2 was never released, and I thought you were a couple mgr profiles away from having it completed on the Memorial Day update. I can continue to use build 1, so no hurry.

Found another bug. In the hitter and pitcher projection sheets, players on the dodgers are assigned the team abbreviation 'LAD' - however, on the page that provides team-based weightings, the dodgers are listed as 'LA'. If you don't change the 'LA' to 'LAD' dodgers players' projections won't work.

Dan, what is the easiest way to acquire a spreadsheet that contains YTD stats updated on a daily basis, in the same format as the current spreadsheet (i.e., with the player names formatted in the same way and containing all of the relevant stats)? I'd like to build on the spreadshet to make daily updates for each player without having to type in all of the data by hand every day.