Using EXCEL during auction draft (please help) - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Frequently Asked Fantasy Questions

Using EXCEL during auction draft (please help)

Moderator: Baseball Moderators

Using EXCEL during auction draft (please help)

Postby gotbupkisNJ » Thu Apr 01, 2010 10:29 pm

I am bringing my laptop for the first time to an auction draft and I want to keep up with every team as the draft progresses. I am not great at Excel, and it took me some time) but came up with formulas for players remaining to be drafted and salary remaining for each team. I am struggling though with coming up with a formula that will calculate the maximum bid a team can make. Anyone use a formula like this before?
gotbupkisNJ
Softball Supervisor
Softball Supervisor


Posts: 67
(Past Year: 20)
Joined: 11 Nov 2005
Home Cafe: Baseball

Re: Using EXCEL during auction draft (please help)

Postby bigmck » Fri Jun 11, 2010 12:03 am

Money Remaining less players needed plus one = max bid on one player. Example $15 - 10 players + 1 = $6 max bid would leave you with 9 players and $9.
bigmck
Major League Manager
Major League Manager

User avatar

Posts: 1034
(Past Year: 59)
Joined: 9 Mar 2008
Home Cafe: Baseball
Location: Houston

Re: Using EXCEL during auction draft (please help)

Postby canatsfan » Tue Feb 15, 2011 2:52 pm

I've got an Excel spreadsheet that I've used in the past that is all set up. If you want to send me a PM with your email address I can email it to you. If nothing else it should give you something to work from.
Relax, all right? Don't try to strike everybody out. Strikeouts are boring! Besides that, they're fascist. Throw some ground balls - it's more democratic.
canatsfan
Little League Legend
Little League Legend

User avatar

Posts: 12
Joined: 19 Jan 2008
Home Cafe: Baseball

Re: Using EXCEL during auction draft (please help)

Postby Talos » Mon Feb 13, 2012 2:32 am

If you're going to have an excel file, worry less about $ left and more about inflation/deflation during the draft
Talos
College Coach
College Coach


Posts: 156
Joined: 30 Mar 2003
Home Cafe: Baseball


Return to Frequently Asked Fantasy Questions

Who is online

Users browsing this forum: joiingds and 0 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Wednesday, Sep. 3
(All times are EST, weather icons show forecast for game time)

Philadelphia at Atlanta
(12:10 pm)
Pittsburgh at St. Louis
(1:45 pm)
San Francisco at Colorado
(3:10 pm)
Washington at LA Dodgers
(3:10 pm)
Seattle at Oakland
(3:35 pm)
Boston at NY Yankees
(7:05 pm)
Detroit at Cleveland
(7:05 pm)
Cincinnati at Baltimore
(7:05 pm)
NY Mets at Miami
(7:10 pm)
indoors
Toronto at Tampa Bay
(7:10 pm)
indoors
Milwaukee at Chi Cubs
(8:05 pm)
LA Angels at Houston
(8:10 pm)
Texas at Kansas City
(8:10 pm)
Chi White Sox at Minnesota
(8:10 pm)
Arizona at San Diego
(10:05 pm)

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