Spreadsheets for running a draft/auction (and prep work) - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Commissioner's Corner

Spreadsheets for running a draft/auction (and prep work)

Moderator: Baseball Moderators

Spreadsheets for running a draft/auction (and prep work)

Postby lsommerer » Mon Jan 19, 2009 9:28 am

I've moved the files that people have sent to me and put them on a real (as in real simple) webpage instead of the directory listing they had been at. The new page includes screenshots, and descriptions so you have more of an idea what you're downloading.

You can find it here:

http://www.lloydandlauren.com/baseball/

If you've got any spreadsheets or other fantasy baseball documents that you would like to share, send them my way and I'll put them up.

Lloyd Sommerer
mailto:Lloyd@LloydAndLauren.com
lsommerer
College Coach
College Coach


Posts: 111
Joined: 15 Feb 2006
Home Cafe: Baseball
Location: Nebraska

Re: Spreadsheets for running a draft/auction (and prep work)

Postby Schwetty Balls » Wed Jan 21, 2009 10:11 pm

thank you for doing this Lloyd, i have used your collection for the past 2 years.
Schwetty Balls
Softball Supervisor
Softball Supervisor

User avatar

Posts: 35
Joined: 15 Feb 2007
Home Cafe: Baseball
Location: Champaign

Re: Spreadsheets for running a draft/auction (and prep work)

Postby Bwanna » Tue Jan 27, 2009 1:44 pm

lsommerer wrote:I've moved the files that people have sent to me and put them on a real (as in real simple) webpage instead of the directory listing they had been at. The new page includes screenshots, and descriptions so you have more of an idea what you're downloading.

You can find it here:

http://www.lloydandlauren.com/baseball/

If you've got any spreadsheets or other fantasy baseball documents that you would like to share, send them my way and I'll put them up.

Lloyd Sommerer
mailto:Lloyd@LloydAndLauren.com


Lloyd,

Do you know of an auction/roster sheet that can be imported into a Google spreadsheet in order to facilitate a slow auction? (and still show remaining $, max bid, etc.?) Here's one that I've used for a couple of leagues ( http://spreadsheets.google.com/ccc?key= ... UUe7VKCMZA ), but it's not perfect.
[reg season/playoffs]
LFoD '08 [1st/3rd], '10 [1st/3rd], '11 [1st/2nd], '12 [1st/1st], '13, [1st/2nd], '14, [1st/1st]
BRAL '09 2nd, '10 1st
Bwanna
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicEagle EyeInnovative MemberWeb Supporter
Posts: 5655
(Past Year: 247)
Joined: 27 Sep 2005
Home Cafe: Baseball

Re: Spreadsheets for running a draft/auction (and prep work)

Postby Schwetty Balls » Tue Jan 27, 2009 1:54 pm

i like that google spreadsheet and would like to learn more about how it works. How do you enter the players names?
Schwetty Balls
Softball Supervisor
Softball Supervisor

User avatar

Posts: 35
Joined: 15 Feb 2007
Home Cafe: Baseball
Location: Champaign

Re: Spreadsheets for running a draft/auction (and prep work)

Postby Bwanna » Tue Jan 27, 2009 2:05 pm

Schwetty Balls wrote:i like that google spreadsheet and would like to learn more about how it works. How do you enter the players names?

One of the commissioners just types them in along with their value, nothing fancy. We do a forum-based slow auction. The sheet just helps people keep track of how much they've spent and what their max bid is, which is calculated automatically when each player's value is entered. But, it could be improved I'm sure, as it's not nearly as full-featured as some of the sheets Lloyd has on his site.
[reg season/playoffs]
LFoD '08 [1st/3rd], '10 [1st/3rd], '11 [1st/2nd], '12 [1st/1st], '13, [1st/2nd], '14, [1st/1st]
BRAL '09 2nd, '10 1st
Bwanna
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicEagle EyeInnovative MemberWeb Supporter
Posts: 5655
(Past Year: 247)
Joined: 27 Sep 2005
Home Cafe: Baseball


Return to Commissioner's Corner

Who is online

Users browsing this forum: No registered users and 2 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Tuesday, Oct. 21
(All times are EST, weather icons show forecast for game time)

San Francisco at Kansas City
(8:07 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact