Fantasy Baseball Files

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,180k
Last Updated: March 4, 2011
Author: Lloyd Sommerer
Download


(click for larger image)


(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
Download


(click for larger image)


(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
Download


(click for larger image)


(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
Download


(click for larger image)

2011Players Names

Description: This is a spreadsheet of about 4000 current baseball players in alphabetical order.
Type: Excel spreadsheet
Size: 275k
Last Updated: March 3, 2011 (ready for 2011 auction/draft)
Download


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
Download


(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
Download


(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
Download


(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
Download(seems to be gone)


(click for larger image)

(s