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 Amazinz » Mon Feb 09, 2009 10:06 am

Moved to Leftovers. ;-D
Image
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Re: Excel Draft Kit

Postby Yoda » Mon Feb 09, 2009 10:31 am

Those of you who received the file, please give us some feedback. 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 C2ThaLo88 » Mon Feb 09, 2009 10:39 am

Yoda wrote:Those of you who received the file, please give us some feedback. Thanks!

Yes please do. We're quite satisfied with what we've done and hope everyone else likes it as well.
C2ThaLo88 Beginner
Minor League Mentor
Minor League Mentor

User avatar

Posts: 379
Joined: 5 Dec 2008
Home Cafe: Baseball

Re: Excel Draft Kit

Postby RynoDyno » Mon Feb 09, 2009 11:20 am

Damn boys, you've outdone yourselves, that's slick. Tiered ranking tied to MDP I believe (?) and overall lists both on one easy to view sheet. multiple projections, well done.

I only wish the draft tracker sheet could fit on one screen, but that's on me for not having a widescreen monitor (or dual monitors).

I'll get to play around with it more later, but it's lookin impressive.

PS. What are the positions in black at the bottom of the draft tracker for? Just a position reminder for leagues?
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 rookies and cream » Mon Feb 09, 2009 11:25 am

RynoDyno wrote:
I only wish the draft tracker sheet could fit on one screen, but that's on me for not having a widescreen monitor (or dual monitors).



View ---> Zoom ---> 75% should work just fine ;-D
Image
rookies and cream
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerGraphics ExpertMock(ing) DrafterWeb Supporter
Posts: 6487
(Past Year: 43)
Joined: 4 Apr 2007
Home Cafe: Baseball
Location: Long Island, NY

Re: Excel Draft Kit

Postby C2ThaLo88 » Mon Feb 09, 2009 11:33 am

RynoDyno wrote:PS. What are the positions in black at the bottom of the draft tracker for? Just a position reminder for leagues?


Yeah, I believe you have to manually maintain that however. With players having multiple position eligibility and leagues with different formats, it would be difficult to have a formula take care of that.
C2ThaLo88 Beginner
Minor League Mentor
Minor League Mentor

User avatar

Posts: 379
Joined: 5 Dec 2008
Home Cafe: Baseball

Re: Excel Draft Kit

Postby RynoDyno » Mon Feb 09, 2009 11:34 am

rookies and cream wrote:View ---> Zoom ---> 75% should work just fine ;-D


Thanks R&C, I had tried that, but it's that I'm stuck on a 1280x1024 at work and even at 75% teams 11/12 get cut off. I've got a 1600x1200 at home, I'm sure it'll be good there which is what matters for drafting. ;-D
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 Yoda » Mon Feb 09, 2009 11:54 am

RynoDyno wrote:
rookies and cream wrote:View ---> Zoom ---> 75% should work just fine ;-D


Thanks R&C, I had tried that, but it's that I'm stuck on a 1280x1024 at work and even at 75% teams 11/12 get cut off. I've got a 1600x1200 at home, I'm sure it'll be good there which is what matters for drafting. ;-D


Yeah as Rookies said you can change the view settings or just make the columns slimmer so you can fit the whole sheet on the screen.

As far as the positions at the bottom goes, you need to manually delete those as you enter the players into the sheet. You can put in your own league settings here and just keep track of who still needs what to fill. But definitely optional.
"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 Curtis Pride » Mon Feb 09, 2009 12:10 pm

Conditional formatting is the easy way to do what you are looking for.

No need for cell equations.

To make it easy, have an extra column on each tab that shows "-1" or really anything you want if the player is listed on the drafted tab (vlookup).

Then have a conditional formatting statement that says if the extra column on the page is "-1" that you strike out the name or delete it entirely with a white font (I personally like strikeout).

Conditional formatting doesn't use as much system resources as having a bunch of formulas in every cell, so the sheet may be faster.
Curtis Pride
Major League Manager
Major League Manager

User avatar

Posts: 1361
(Past Year: 3)
Joined: 19 May 2007
Home Cafe: Baseball

Re: Excel Draft Kit

Postby Yoda » Mon Feb 09, 2009 12:33 pm

We created one without PECOTA. People have been very good and honest about it but we will require you to email a copy of the PECOTA if you want it included in the Draft Kit. 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...

PreviousNext

Return to Baseball Leftovers

Who is online

Users browsing this forum: buiviopaufamp, unioreimi and 5 guests

Forums Articles & Tips Sleepers Rankings Leagues


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

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

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