Drafttracker (Excel Kit) - Final Update 3.21.09 - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

Drafttracker (Excel Kit) - Final Update 3.21.09

Moderator: Baseball Moderators

Re: Excel Draft Kit

Postby Yoda » Mon Feb 09, 2009 5:01 pm

Yeah one version may already have it done like that. If it works then you are all set.

I sent a quite a few out there so please let us know if you see any other issues. Thanks.
"Think of how stupid the average person is, and realize half of them are stupider than that." ~George Carlin
Yoda
Hall of Fame Hero
Hall of Fame Hero

User avatar
Fantasy ExpertMock(ing) Drafter
Posts: 21344
Joined: 21 Jan 2005
Home Cafe: Baseball
Location: 15th green...

Re: Excel Draft Kit

Postby Yoda » Mon Feb 09, 2009 8:02 pm

If you feel overwhelmed by the info on the stats sheet, always remember to start with the LIST you want to use. The easiest way to find a player's stats is to go to LIST (I usually do all) -> POSITION -> PLAYER (sort alphabetically). You want to reset (start with LIST again) every time you change the position.
"Think of how stupid the average person is, and realize half of them are stupider than that." ~George Carlin
Yoda
Hall of Fame Hero
Hall of Fame Hero

User avatar
Fantasy ExpertMock(ing) Drafter
Posts: 21344
Joined: 21 Jan 2005
Home Cafe: Baseball
Location: 15th green...

Re: Excel Draft Kit

Postby bigtyme » Mon Feb 09, 2009 10:07 pm

Wow great spreadsheet! Thanks Yoda and all who contributed. It took a little to get a hang of, but I love the comprehensiveness and ease of use with the draft tracker tab.
bigtyme
Little League Legend
Little League Legend


Posts: 14
Joined: 25 Apr 2007
Home Cafe: Baseball

Re: Excel Draft Kit

Postby YerInUrine » Tue Feb 10, 2009 11:47 am

How does one get their hands on this?

Is it possible for someone to email it to: themaestro36@yahoo.com

Thanks in advance!
YerInUrine
Minor League Mentor
Minor League Mentor

User avatar

Posts: 370
Joined: 24 Oct 2006
Home Cafe: Football
Location: Yawkey Way

Re: Excel Draft Kit

Postby RynoDyno » Tue Feb 10, 2009 12:00 pm

How hard would it be for me to extend the draft to 30+ rounds and still have it remove the players names from the tiered rankings? I copied and pasted the cells for the draft tracker, and while it still takes the player off the MDP list, it doesn't remove them from the tiers for the new rounds I created.
DaSh 1s wrote:PS how do u not want to cup the best player in baseball's sack?


ewwww
RynoDyno
College Coach
College Coach

User avatar

Posts: 274
Joined: 7 Jan 2005
Home Cafe: Baseball

Re: Excel Draft Kit

Postby hot4tx » Tue Feb 10, 2009 12:03 pm

I normally make a similar excel draft file for each draft. If you wouldn't mind sending it to me also I'd appreciate it. jr_ewing_56@yahoo.com
hot4tx
Major League Manager
Major League Manager

User avatar

Posts: 1933
(Past Year: 135)
Joined: 16 Feb 2007
Home Cafe: Baseball

Re: Excel Draft Kit

Postby Yoda » Tue Feb 10, 2009 12:06 pm

RynoDyno wrote:How hard would it be for me to extend the draft to 30+ rounds and still have it remove the players names from the tiered rankings? I copied and pasted the cells for the draft tracker, and while it still takes the player off the MDP list, it doesn't remove them from the tiers for the new rounds I created.


You have to unhide the left columns and make sure the list goes down to 30. That is where the other sheets are picking up the names from. Then link those cells to the snake draft section. Email me if you still have issues.
"Think of how stupid the average person is, and realize half of them are stupider than that." ~George Carlin
Yoda
Hall of Fame Hero
Hall of Fame Hero

User avatar
Fantasy ExpertMock(ing) Drafter
Posts: 21344
Joined: 21 Jan 2005
Home Cafe: Baseball
Location: 15th green...

Re: Excel Draft Kit

Postby Syfo-Dyas » Tue Feb 10, 2009 3:03 pm

Im not into Excel and not even sure how it works, but this thing sounds awesome, and I'd really like to see it.
could you send me a copy to
amonte27@gmail.com

thanks
Image
the awesome sig by soty


"You should be mindful of the future, but not at the expense of the
moment." - Qui-Gon Jinn (keeper league expert?)
Syfo-Dyas
Major League Manager
Major League Manager


Posts: 1849
Joined: 23 Jul 2007
Home Cafe: Baseball

Re: Excel Draft Kit

Postby cwrtlm » Tue Feb 10, 2009 3:21 pm

Would love to get my hands on this kit. Could I get an email with it at
RENFRCW@hotmail.com

Thanks
C- Hundley, Iannetta
1b- Wallace
2b- Barney/Barmes
3b- J. Lopez
CO- G. Sanchez
SS- Tulo
MI- Castro
OF- Bay, Hart, Pagan, Smith, Francisco, Ankiel
U- C. Ross(DL), Cantu
P- Carpent, Billings, Volquez, Marcum, Norris, J. Vazquez, Westbrook, Wolf, E Rogers
cwrtlm
Major League Manager
Major League Manager

User avatar

Posts: 1032
Joined: 3 Oct 2004
Home Cafe: Football

Re: Excel Draft Kit

Postby fantasyfantasy » Tue Feb 10, 2009 5:44 pm

This is a great tool! Thanks guys. My draft started today and I will get some great use out of this over the next couple of weeks.

Not sure if its been mentioned but the links to C.C. Sabathia in the Draft Tracker are a little off because in some places he's referred to as CC and in others as C.C.
fantasyfantasy
T-Ball Trainer


Posts: 4
Joined: 18 Sep 2008
Home Cafe: Baseball

PreviousNext

Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 8 guests

Forums Articles & Tips Sleepers Rankings Leagues


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

Detroit at Baltimore
(5:37 pm)
Kansas City at LA Angels
(9:07 pm)

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