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...
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 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.
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.
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.
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.
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
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
Cafe Home
Fantasy Football
Fantasy Basketball
Fantasy Hockey
by Chicago RedSox » Tue May 09, 2006 9:55 am 
/charlie2.gif){kind=small}
