Does anyone have any advice on how best to monitor what I have, and what I still need, while a draft is actually in progress? In other words, i am hoping to find a quick and easy way to keep track of the projected stats of the players I have drafted so that I may get a better idea in mid-draft of what i should be looking for. Am I short on HR? Do I have plenty of SB? How am I doing with K's?

I could do it with paper, pencil and calculator, but I'm hoping perhaps there is an easier way.

If you've got your projections in a spreadsheet, just make a new page for that spreadsheet and as you draft players, copy and paste them into that new page. Then have some equations running at the bottom of the page in order to tally up your total stats.

QUESTION: How do I know what I need to score to win? How many home runs do I need? How many steals? What average? I think this has been gone over before but I never really understood it. I would assume that the numbers are for 12-teamers, but how would they translate to a 10-teamer?

BronXBombers51 wrote:If you've got your projections in a spreadsheet, just make a new page for that spreadsheet and as you draft players, copy and paste them into that new page. Then have some equations running at the bottom of the page in order to tally up your total stats.

QUESTION: How do I know what I need to score to win? How many home runs do I need? How many steals? What average? I think this has been gone over before but I never really understood it. I would assume that the numbers are for 12-teamers, but how would they translate to a 10-teamer?

Can anyone help me out with this?

Do you have the stats for your particular league for the last 2-3 years? If so, you can average those - this will give you a MUCH better idea for your particular situation because it automatically factors in your league mate's tendencies/skills and league size/settings. If you use CBS, you can go to the standings page and export the standings for the last few years and copy them right into your spreadsheet then average them.

"The government cannot give to anyone anything that it does not first take from someone else"

For online drafts, I set up a massive spreadsheet with my overall rankings, the Y! rankings and ESPN rankings (so I can see what most of my opponents are watching), projections of players sorted by position and then tier'd, and an area to total my projected stats for my team.

They are all linked and are all based on if/then/else formulas so that when I delete the number in my overall rankings it removes them from all the rankings and projections. When I select a person I highlight them and then cut/paste values their projection into my team total area. When someone else selects, I simply delete the number and that player goes away.

This way I can easily see who's left in my rankings, Y! rankings and ESPN rankings, as well as look at who's left in my tiers by position. This works great as long as I stay away from the Miller Lite before the 7th round. If I can hold off until then, I'm fine. If not I get confused with my spreadsheet around round 15 and have to abort and draft the rest of way based strictly on my pre-rankings list.

BronXBombers51 wrote:QUESTION: How do I know what I need to score to win? How many home runs do I need? How many steals? What average? I think this has been gone over before but I never really understood it. I would assume that the numbers are for 12-teamers, but how would they translate to a 10-teamer?

Can anyone help me out with this?

Yes, check out Matt Buser's article on yahoo for 12 team data. I think if you look at the numbers for the top team in a 12 team league, you'd probably be pretty close to what was needed to compete in a 10 team league. Derek Carty over at Hardball Times has asked FBB fans to email him their previous results to see if he can put this together for a whole range of leagues.

"I don't want to play golf. When I hit a ball, I want someone else to chase it."

Wrt spreadsheets, one of my commishes started using Google spreadsheets this year to track our snake draft, and I was sold. Since, I've gone from using Excel to Google spreadsheets, simply because I can access them from anywhere, and I can share the entire spreadsheet or just a single sheet with the rest of the league. Here are some examples from some leagues I'm in: