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: 1033
(Past Year: 60)
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: No registered users and 0 guests

Forums Articles & Tips Sleepers Rankings Leagues


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

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

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