Return to Baseball Leftovers

## In Season Pace Calculator

Moderator: Baseball Moderators

### In Season Pace Calculator

I was wondering if anyone else tracks players pace during the season. One of my biggest flaws when it comes to playing Roto is getting frustrated with a player that's in a slump. I jump ship way too early. I did this with a few players last season. Trading Mat Latos was probably my biggest mistake. I think a lot of times when a player is slumping if you look to see what pace they are on it would probably help to be more patient with them. I started creating a spreadsheet that would tell you where a player stands during the year and you can compare that with the projection you drafted him at. If I can see that Albert Pujols is actually on pace to exceed his projections I might be less willing to trade him away. Maybe there is someone in the Cafe that is a little more savvy with Excel & could take what I started and run with it....

http://www.freedrive.com/file/1710198
timgair
Softball Supervisor

Posts: 84
Joined: 17 Mar 2012
Home Cafe: Baseball

### Re: In Season Pace Calculator

If you believed in your pre-draft projections of your total roster, you would probably be better served to track your team totals to see if you were falling behind in any one particular category before you went looking for a culprit or help on the wire. Because if player A is lacking but player B is over his projections then you have no current problem, it's the team totals that count in the end.
So-Cal 25 Club _762_
ayebatter
Moderator

Posts: 12455
(Past Year: 763)
Joined: 15 Dec 2004
Home Cafe: Baseball
Location: I CAN SEE FOR MILES

### Re: In Season Pace Calculator

Most efficient way to do this I can think of:

One tab for projections
One tab for dougstats
One tab for players

Use drop-down lists for player selection
Use VLOOKUP for referencing current and projected stats from the respective tabs.
To calc pace, instead of punching in new GP numbers every time, just use the current pro-rated portion of the season: =(TODAY()-seasonstartdate)/(seasonenddate-seasonstartdate)
RugbyD
Hall of Fame Hero

Posts: 5589
(Past Year: -2)
Joined: 7 Dec 2004
Home Cafe: Baseball
Location: punting small dogs and being surly

### Re: In Season Pace Calculator

I like this idea. Would like to explore it further.
kaiser
Hall of Fame Hero

Posts: 5559
(Past Year: 171)
Joined: 8 Mar 2005
Home Cafe: Baseball
Location: Genco Olive Oil Co.

### Re: In Season Pace Calculator

ayebatter wrote:If you believed in your pre-draft projections of your total roster, you would probably be better served to track your team totals to see if you were falling behind in any one particular category before you went looking for a culprit or help on the wire. Because if player A is lacking but player B is over his projections then you have no current problem, it's the team totals that count in the end.

I agree with that but I think just trying to hit your projections is sort of like resting on your laurels. If I have a culprit that's not living up to expectations, why not replace him if there is a better option? I want to do everything in my power to win this year. I'm a bit of a rotisserie noob so anything I can do to neutralize my opponents edge, well I'm gonna do it.
timgair
Softball Supervisor

Posts: 84
Joined: 17 Mar 2012
Home Cafe: Baseball

### Re: In Season Pace Calculator

RugbyD wrote:Most efficient way to do this I can think of:

One tab for projections
One tab for dougstats
One tab for players

Use drop-down lists for player selection
Use VLOOKUP for referencing current and projected stats from the respective tabs.
To calc pace, instead of punching in new GP numbers every time, just use the current pro-rated portion of the season: =(TODAY()-seasonstartdate)/(seasonenddate-seasonstartdate)

I'm sorry. I don't really understand all of that. Can you tell me exactly what you mean by "dougstats"?

I like the idea for the pace calculation. I assume "GP" means games played?
timgair
Softball Supervisor

Posts: 84
Joined: 17 Mar 2012
Home Cafe: Baseball

### Re: In Season Pace Calculator

timgair wrote:
RugbyD wrote:Most efficient way to do this I can think of:

One tab for projections
One tab for dougstats
One tab for players

Use drop-down lists for player selection
Use VLOOKUP for referencing current and projected stats from the respective tabs.
To calc pace, instead of punching in new GP numbers every time, just use the current pro-rated portion of the season: =(TODAY()-seasonstartdate)/(seasonenddate-seasonstartdate)

I'm sorry. I don't really understand all of that. Can you tell me exactly what you mean by "dougstats"?

I like the idea for the pace calculation. I assume "GP" means games played?

www.dougstats.com is a site that posts updated daily stats. copy/paste/text to columns whenever you want to update your sheet. yes, GP=games played.
RugbyD
Hall of Fame Hero

Posts: 5589
(Past Year: -2)
Joined: 7 Dec 2004
Home Cafe: Baseball
Location: punting small dogs and being surly

Return to Baseball Leftovers

### Who is online

Users browsing this forum: No registered users and 10 guests