Analyzing your team using MS Excel - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

Analyzing your team using MS Excel

Moderator: Baseball Moderators

Analyzing your team using MS Excel

Postby Chicago RedSox » Tue May 09, 2006 9:55 am

Does anyone else use excel (or similar program) to track and analyze your team's results week to week? I've been plugging in my results week by week to help me see what the big holes in my lineup are.

At first I thought my team was going to suffer horribly for steals, but I've won steals four out of five weeks. I didn't need excel to see that, but it helps to put it all out there on one spread sheet to see your gaps and surplusses.

Just wondering if anyone else does this, or if you know a better way to do it...
Chicago RedSox
Major League Manager
Major League Manager

User avatar

Posts: 1436
Joined: 30 Mar 2005
Home Cafe: Baseball
Location: SanDiego

Postby MashinSpuds » Tue May 09, 2006 9:57 am

Geez, what a great idea. Do you just copy/paste H2H results or weekly totals from players? I wonder how one would do this effectively..
MashinSpuds
General Manager
General Manager

User avatar
Cafe WriterCafe RankerEagle EyeCafecaster
Posts: 2563
(Past Year: 109)
Joined: 25 Jul 2003
Home Cafe: Baseball
Location: Boston

Postby Yoda » Tue May 09, 2006 10:20 am

It's tedious but I've been doing it for years now. Last season, Yahoo showed accumulated stats so you wouldn't have to do it. But for some reason that feature is missing.

THe thing that helps about keeping track of stats from year to year is you can really plan out your roster. You know appx what you need from each category to win.
"Think of how stupid the average person is, and realize half of them are stupider than that." ~George Carlin
Yoda
Hall of Fame Hero
Hall of Fame Hero

User avatar
Fantasy ExpertMock(ing) Drafter
Posts: 21344
Joined: 21 Jan 2005
Home Cafe: Baseball
Location: 15th green...

Postby Chicago RedSox » Tue May 09, 2006 10:49 am

Yoda wrote:THe thing that helps about keeping track of stats from year to year is you can really plan out your roster. You know appx what you need from each category to win.


I was actually going to mention that. Thanks for bringing it up. I love that I can see on average how many hits I need to win every week. If my opponants are averaging 54 hits per week, I'll try to put together a team averaging 56 or whatever.

Time comsuming, but I like spending time on FBB
Chicago RedSox
Major League Manager
Major League Manager

User avatar

Posts: 1436
Joined: 30 Mar 2005
Home Cafe: Baseball
Location: SanDiego

Postby Hobbes » Tue May 09, 2006 11:03 am

I do this and I just copy and paste the weekly H2H matchup results for all of the teams. I can then sort each week's data by each category to see where I fell compared to all twelve teams in each category. So even if I've won runs for the week against my opponent, I might be tenth overall compared to all teams.

It can certainly help show where your true weaknesses are in a H2H league where you normally only see how you compare to one opponent each week.
Hobbes
Minor League Mentor
Minor League Mentor


Posts: 403
Joined: 18 Apr 2006
Home Cafe: Baseball

Postby MashinSpuds » Tue May 09, 2006 11:33 am

This is a great idea. What do you do for roto, though?
MashinSpuds
General Manager
General Manager

User avatar
Cafe WriterCafe RankerEagle EyeCafecaster
Posts: 2563
(Past Year: 109)
Joined: 25 Jul 2003
Home Cafe: Baseball
Location: Boston

Postby roninmedia » Tue May 09, 2006 12:18 pm

I just do a simple cut and paste and let excel automatically rank my performance in a series of categories and assign the respective point values like in roto. (#1 in half the categories, #2 and #3 in two more, 5th in one, and last in the final one). Time to move to improve that struggling area.

This works well for roto leagues. This works for my head to head points league, because I can see what certain categories I am slumping in and what I can do revamp against my opponent for that respective week and calculate chances of success. This is working out well in defining the strategy changes in drafting for H2H pts vs. any form of roto.
roninmedia
Major League Manager
Major League Manager

User avatar
CafeholicEagle Eye
Posts: 1647
Joined: 16 Jul 2003
Home Cafe: Baseball

Postby The Loveable Losers » Tue May 09, 2006 2:02 pm

I do the same thing but I stick to projected values and tweak the projections if I see fit. I could also add a player's pro-rated projected values to the current standings to project where I'm likely to finish but normally you've already got a good idea on that.
The Loveable Losers
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterWeb Supporter
Posts: 7290
Joined: 30 Mar 2005
Home Cafe: Baseball
Location: Cubs Win!!! Cubs Win!!!

Postby Yoda » Tue May 09, 2006 2:17 pm

roninmedia wrote:I just do a simple cut and paste and let excel automatically rank my performance in a series of categories and assign the respective point values like in roto. (#1 in half the categories, #2 and #3 in two more, 5th in one, and last in the final one). Time to move to improve that struggling area.

This works well for roto leagues. This works for my head to head points league, because I can see what certain categories I am slumping in and what I can do revamp against my opponent for that respective week and calculate chances of success. This is working out well in defining the strategy changes in drafting for H2H pts vs. any form of roto.


Yep. Also, if you play in the same league year after year, you can get the average of the leaders of each category. This way, come draft day, you know what type of production you need to win each category.
"Think of how stupid the average person is, and realize half of them are stupider than that." ~George Carlin
Yoda
Hall of Fame Hero
Hall of Fame Hero

User avatar
Fantasy ExpertMock(ing) Drafter
Posts: 21344
Joined: 21 Jan 2005
Home Cafe: Baseball
Location: 15th green...

Postby The Loveable Losers » Tue May 09, 2006 2:29 pm

Yoda wrote:
roninmedia wrote:I just do a simple cut and paste and let excel automatically rank my performance in a series of categories and assign the respective point values like in roto. (#1 in half the categories, #2 and #3 in two more, 5th in one, and last in the final one). Time to move to improve that struggling area.

This works well for roto leagues. This works for my head to head points league, because I can see what certain categories I am slumping in and what I can do revamp against my opponent for that respective week and calculate chances of success. This is working out well in defining the strategy changes in drafting for H2H pts vs. any form of roto.


Yep. Also, if you play in the same league year after year, you can get the average of the leaders of each category. This way, come draft day, you know what type of production you need to win each category.


GotowarMissAgnes actually generated a great listing of the average stats to win 12 team roto leagues. I forget how many leagues he compiled the totals from but it was quite a few teams. Here's the original thread:
http://www.fantasybaseballcafe.com/foru ... p?t=158921
The Loveable Losers
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterWeb Supporter
Posts: 7290
Joined: 30 Mar 2005
Home Cafe: Baseball
Location: Cubs Win!!! Cubs Win!!!

Next

Return to Baseball Leftovers

Who is online

Users browsing this forum: Google [Bot], scarnicease and 7 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Saturday, Sep. 20
(All times are EST, weather icons show forecast for game time)

LA Dodgers at Chi Cubs
(1:05 pm)
Detroit at Kansas City
(1:05 pm)
Toronto at NY Yankees
(4:05 pm)
Philadelphia at Oakland
(4:05 pm)
Arizona at Colorado
(4:10 pm)
Boston at Baltimore
(7:05 pm)
Milwaukee at Pittsburgh
(7:05 pm)
Chi White Sox at Tampa Bay
(7:10 pm)
indoors
Cleveland at Minnesota
(7:10 pm)
Washington at Miami
(7:10 pm)
indoors
Seattle at Houston
(7:10 pm)
NY Mets at Atlanta
(7:10 pm)
Cincinnati at St. Louis
(7:15 pm)
San Francisco at San Diego
(8:40 pm)
Texas at LA Angels
(9:05 pm)

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