This page has been moved.

You are being redirected.

This collection of fantasy baseball files was created by readers of the Fantasy Baseball Cafe Forums. It includes documents for preparing for a draft/auction and documents for running one.

If you have a document that has worked well for you and you want to offer it to others, please email it to me, and I'll add it to the list. Please include a brief description like the ones below and whether I can add your email address. If you've significantly modified a file that is already here, I'd like to include that as well.

The files presented here are free to download, use, and modify as you see fit, but they obviously come without any warranties. I've included the email address of the person who created each file if they have given permission to do so. Feel free to contact them if you have questions about their file or to thank them for it, but they might not be able to get back to you right away.

Lloyd Sommerer
Lloyd@LloydAndLauren.com

All in One Auctioneer Spreadsheet

Description: This is a spreadsheet for the person running your draft/auction to use to keep track of owner's budgets and rosters. It was designed to be used with three monitors (or video projectors), but can be used with a single monitor. Here are the highlights:

Works with keeper and non-keeper leagues
Works with auctions or drafts (just ignore the dollar amounts in drafts)
Works with "nominating players" or "auction from list"
Works with variable starting cash (we give new owners extra cash)
Setup for up to 16 owners (you could add more or use fewer)
Automatically removes players from list as they are selected
Owners/Players selected via drop down list (no typing)
Customizable list of players

Type: Excel spreadsheet

Size: 1,032k

Last Updated: February 18, 2008

Author: Lloyd Sommerer

(click for larger image)

Auto Auction

Description: This is a spreadsheet for the person running your draft/auction to use to keep track of owner's budgets and rosters. It was designed specifically to facilitate an auction that uses a poker style of bidding, but will work for any type of auction. Some highlights:

Works with keeper and non-keeper leagues
Visually displays the highest bid from each player
Macro records winning bid with one key press
Setup for up to 12 owners (you could add more or use fewer)
Owners/Players selected via drop down list (no typing)
Customizable list of players

Type: Excel spreadsheet

Size: 566k

Last Updated: March 23, 2007 (ready for 2007 auction/draft)

Author: Greg Leonard

(click for larger image)

Tollminator Fantasy Auction Spreadsheet

Description: This is a spreadsheet for the person running your draft/auction to use to keep track of owner's budgets, remaining positions and rosters. It was designed to be used for an auction draft but could also be used for a straight draft. Chris did a nice job implementing a user interface that is very easy to use. The included instructions are also top notch.

Works with keeper and non-keeper leagues
Works with auctions or drafts (just ignore the dollar amounts in drafts)
Allows commissioner to select players nominated for auction form drop down menu
Allows commissioner to select starting salary cap
Setup for up to 13 owners (you could use fewer)
Automatically removes players from list as they are selected
Owners/Players selected via drop down list (no typing)
Keeps track of remaining positions
NL only version, AL only version, and Combined version available
Customizable list of players

Type: Excel spreadsheet

Size: 410k to 514k, depending on version

Versions: combined NL and AL, NL only, AL only

Last Updated: March 21, 2008 (ready for 2008 auction/draft)

Author: Chris Tolle

(click for larger image)

Auction Display

Description: This is a spreadsheet for the person running your draft/auction to use to keep track of owner's budgets and rosters. All of the information is contained on this single screen.

Works with keeper and non-keeper leagues
Setup for up to 14 owners
Players selected by position or from full list
Players selected via drop down list (no typing)
Customizable list of players

Type: Excel spreadsheet

Size: 491k

Last Updated: February 18, 2008 (ready for 2008 auction/draft)

Author: Lloyd Sommerer

(click for larger image)

2008 Players Names

Description: This is a spreadsheet of about 3000 current baseball players in alphabetical order.

Type: Excel spreadsheet

Size: 209k

Last Updated: February 18, 2008 (ready for 2008 auction/draft)

Auction Worksheet

Description: This is a document for owners to use to keep track of their own players during an auction/draft.

Type: Word document

Size: 63k

Last Updated: March 23, 2007

Author: Lloyd Sommerer

(click for larger image)

Lloyd Sommerer's Draftday Prep

Description: This is a spreadsheet to use when you prepare for your auction. I'm in a points league, and I don't want to do a lot of predicting of individual stats, so I look at points/at bat and points/inning. Then compute a dollar value by dividing the total available money by the points from each position. Once that's done, the dollars for each player at that position are divided.

Type: Excel spreadsheet

Size: 1645k

Last Updated: February 19, 2008

Author: Lloyd Sommerer

(click for larger image)

klvrdude's Draftday Prep

Description: This is a spreadsheet to use when you prepare for your auction.This spreadsheet is an amazing collection of data to use to project players and to determine auction value. You'd have to update it with current information, but it gives you a layout that is ready to do that.

Type: Excel spreadsheet

Size: 741k

Last Updated: February 19, 2006

Author: klvrdude

(click for larger image)

J35J's Draftday Prep

Description: This spreadsheet is of the 2007 regular season stats with each position on its own worksheet. I have the ages for all the players. The position eligibility for each player (based on Yahoo). The minor league numbers for every young player who didn't reach 200ABs or 75IPs. Each player is linked to their ESPN player profile and/or their MILB.com player profile for easy access to more information, and more. I've also included, once again, my formulas for my ranking/projection system I use. Any and all of this information can be tweaked however you see fit.

Type: Excel spreadsheet

Size: 176k (zipped) 761k (unzipped)

Last Updated: February 17, 2008

Author: J35J

(click for larger image)