Excel document help for the draft - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Commissioner's Corner

Excel document help for the draft

Moderator: Baseball Moderators

Excel document help for the draft

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

I am using 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: Excel document help for the draft

Postby Matthias » Thu Apr 01, 2010 11:12 pm

It's easy. It's whatever money they have left minus their open positions.

What you can do is have 1 column for the players they've bought and the prices and then the column next to it that is an IF function that is IF column X equals "" then 1, else Column X. Check Excel Help for the exact syntax.
0-3 to 4-3. Worst choke in the history of baseball. Enough said.
Matthias
General Manager
General Manager


Posts: 4860
Joined: 16 Mar 2005
Home Cafe: Baseball

Re: Excel document help for the draft

Postby petachi » Fri Apr 02, 2010 9:06 am

I have a pretty good spreadsheet that I have used for a few years if you're interested.

Just email me and I'll send it to you.
petachi
Softball Supervisor
Softball Supervisor


Posts: 74
Joined: 5 Dec 2006
Home Cafe: Baseball

Re: Excel document help for the draft

Postby bigmck » Fri Apr 02, 2010 9:59 pm

Matthias wrote:It's easy. It's whatever money they have left minus their open positions.

What you can do is have 1 column for the players they've bought and the prices and then the column next to it that is an IF function that is IF column X equals "" then 1, else Column X. Check Excel Help for the exact syntax.


That isn't correct. If you have four players left and four dollars, 4-4 would equal zero which would not be the max bid. It should be Money Left minus Players Left plus one. If you have you have 4 dollars minus 4 players plus one would give you $1 as your max bid.
bigmck
Major League Manager
Major League Manager

User avatar

Posts: 1035
(Past Year: 60)
Joined: 9 Mar 2008
Home Cafe: Baseball
Location: Houston


Return to Commissioner's Corner

Who is online

Users browsing this forum: No registered users and 0 guests

cron
Forums Articles & Tips Sleepers Rankings Leagues


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

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

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