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.
2007 ZiPS Projection - Julio Lugo
———————————————————————————————————-
Period AB R H 2B 3B HR RBI BB SO SB BA OBP SLG
———————————————————————————————————-
Actual 2007* 299 36 59 13 1 5 40 31 43 22 .197 .273 .298
Rest of 2007 254 36 66 15 1 4 25 24 47 14 .260 .329 .374
———————————————————————————————————-
2007 Total 553 72 125 28 2 9 65 55 90 36 .226 .298 .333
2008 503 71 131 30 2 6 53 49 95 28 .260 .331 .364
———————————————————————————————————-
* - Includes minor league translation, if applicable.
Enjoy!
ZiPS In-Season Projection Tool, v. 3.1 (2007)
Update
Pitcher spreadsheet done as well.
Dan Szymborski
Posted: July 11, 2007 at 01:12 AM |
18 comment(s)
Login to Bookmark
Related News:
Reader Comments and Retorts
Go to end of page
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.
1. Mark S. is bored Posted: July 11, 2007 at 04:08 AM (#2437143)- Mark - two Jose Reyes unfortunately and the spreadsheet is confused.
Oh yeah. I didn't think you did a projection for the other Jose Reyes.
- Micah Hoffpauir doesn't play for STL but for CHC. Jarrett Hoffpauir was recently promoted to AAA in the Cardinals system.
- John Nelson was recently traded from STL to CHC.
Also, this is a fantastic tool -- very much appreciated Dan.
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.
Thanks for this and all of your work on ZiPS!
Why not just zip what you have done, and whoever wants it can just update the mgr profiles themselves? By the way, is the schedule fixed in v2?
You must be Registered and Logged In to post comments.
<< Back to main