Friday, March 04, 2005

Using Microsoft Excel to your Advantage in Fantasy Baseball

This Microsoft article tells you how to use Excel to pick the perfect fantasy team. The example is football but...
Of course, the same methodology I've described for selecting a fantasy football team can be applied to baseball or basketball fantasy leagues. Enjoy!

My Secret Source tells me:
The key is finding some place to give you good projections

7 Comments:

At 8:55 AM, Anonymous STL Bert said...

I've used solver in some classes in engineering. It could work, but it would be really tedious to enter all the data and all the equations. And I don't even know the way our baseball league is going to calculate the points yet. Is that available somewhere?

 
At 9:04 AM, Blogger jbox said...

NERD! Just kidding. Dex you wanna field this one? You're the commish of this league.

 
At 9:09 AM, Blogger Dex said...

I believe that for each of the stats that it scores for, you just have to do better than the team you're playing against for the week. You score a point (run) for each stat that you lead in and whoever scores the most wins that week's game.

 
At 9:11 AM, Anonymous STL Bert said...

There is definetly a nerd factor is this fantasy baseball thing. But if I get it working, I'll share the file after I get a big enough lead to beat everyone this season.

 
At 9:12 AM, Anonymous STL Bert said...

Is there a list of the stats that it scores somewhere? And how many of each type of player are you supposed to field each week?

 
At 9:13 AM, Blogger jbox said...

Nerd! Okay I'm not kidding anymore.

 
At 9:17 AM, Blogger Dex said...

For batters: R, HR, RBI, SB, AVG, OPS For Pitchers: W, SV, K, HLD, ERA, WHIP

You field one player at every position plus one utility man. You field 7 pitchers. Two starters, two relievers and three more of your choosing.

I believe you also get 5 players for your bench that don't count towards your points plus one for DL if you need it.

 

Post a Comment

<< Home