In Season Pace Calculator - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

In Season Pace Calculator

Moderator: Baseball Moderators

In Season Pace Calculator

Postby timgair » Tue Mar 12, 2013 8:50 pm

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
Softball Supervisor


Posts: 84
(Past Year: 29)
Joined: 17 Mar 2012
Home Cafe: Baseball

Re: In Season Pace Calculator

Postby ayebatter » Wed Mar 13, 2013 11:08 am

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
Moderator

User avatar
ModeratorCafeholicMock(ing) Drafter
Posts: 11819
(Past Year: 1604)
Joined: 15 Dec 2004
Home Cafe: Baseball
Location: I CAN SEE FOR MILES

Re: In Season Pace Calculator

Postby RugbyD » Thu Mar 14, 2013 10:27 pm

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)
TennCare rocks!!!!
RugbyD
Hall of Fame Hero
Hall of Fame Hero

User avatar
Cafe Ranker
Posts: 5591
(Past Year: 4)
Joined: 7 Dec 2004
Home Cafe: Baseball
Location: punting small dogs and being surly

Re: In Season Pace Calculator

Postby kaiser » Fri Mar 15, 2013 8:39 pm

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

User avatar
EditorCafeholicCafe Ranker
Posts: 5474
(Past Year: 428)
Joined: 8 Mar 2005
Home Cafe: Baseball
Location: Genco Olive Oil Co.

Re: In Season Pace Calculator

Postby timgair » Fri Mar 15, 2013 9:27 pm

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
Softball Supervisor


Posts: 84
(Past Year: 29)
Joined: 17 Mar 2012
Home Cafe: Baseball

Re: In Season Pace Calculator

Postby timgair » Fri Mar 15, 2013 9:30 pm

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
Softball Supervisor


Posts: 84
(Past Year: 29)
Joined: 17 Mar 2012
Home Cafe: Baseball

Re: In Season Pace Calculator

Postby RugbyD » Fri Mar 15, 2013 11:08 pm

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.
TennCare rocks!!!!
RugbyD
Hall of Fame Hero
Hall of Fame Hero

User avatar
Cafe Ranker
Posts: 5591
(Past Year: 4)
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: apz, BaezBlasts, Fantasy Sports Genie, germani40, NikkiSixx, wingman3110 and 9 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Thursday, Apr. 17
(All times are EST, weather icons show forecast for game time)

Atlanta at Philadelphia
(1:05 pm)
Cleveland at Detroit
(1:08 pm)
Toronto at Minnesota
(1:10 pm)
Seattle at Texas
(2:05 pm)
LA Dodgers at San Francisco
(3:45 pm)
Colorado at San Diego
(6:40 pm)
Milwaukee at Pittsburgh
(7:05 pm)
St. Louis at Washington
(7:05 pm)
NY Yankees at Tampa Bay
(7:10 pm)
indoors
Boston at Chi White Sox
(8:10 pm)
Kansas City at Houston
(8:10 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact