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: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby rookies and cream » Sat Feb 27, 2010 11:11 am

The official release is fantastic. I suggest that everyone take a look. ;-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: 46)
Joined: 4 Apr 2007
Home Cafe: Baseball
Location: Long Island, NY

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby AquaMan2342 » Sat Feb 27, 2010 11:36 am

Make sure to thank Yoda. :-D
AquaMan2342
Hall of Fame Hero
Hall of Fame Hero

User avatar
EditorCafeholicCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb Supporter
Posts: 7852
Joined: 19 Sep 2007
Home Cafe: Baseball
Location: Searchin for my mainline....I couldn't hit it sideways

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby zebulon » Sun Feb 28, 2010 9:06 am

Here's a quick tip. If you have a large screen like say a 24" widescreen, you can easily open multiple windows of different sizes to show different tabs, so that you can have all of the info you need open at the same time without clicking back and forth between tabs.

For instance, you could keep the draft board open in 1 window, the Roster Stats in another, and the MDP Rank in another. As you enter names in the draft board, the other windows will update automatically. So it will be much easier to track positions and available players at the same time.

To do this, within Excel go to View > New View. Then Arrange All. Choose Horizontal. Repeat this step for as many different views you want open at the same time.
DraftTracker 2010 FREE Download Now Available at: http://drafttracker.weebly.com
zebulon
College Coach
College Coach


Posts: 294
Joined: 24 May 2002
Home Cafe: Baseball
Location: Holly Springs, NC

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby TheTrickster » Sun Feb 28, 2010 5:02 pm

For any leagues where teams can trade draft picks, is there a way to edit the formulas for the team rosters to direct them to look at different cells?

For example if Team 5 actually had the first pick in Round 3, is there a way to tell the roster stats page to look to cell B1327 rather than F1327 for their third pick?

Your Excel skills are over my head and I couldn't figure out how to do it myself. I don't mind if it's tedious, but since I couldn't figure out how it worked I wasn't sure if it was even possible.

Thanks!
TheTrickster
Little League Legend
Little League Legend


Posts: 20
Joined: 3 Oct 2008
Home Cafe: Football

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby zebulon » Sun Feb 28, 2010 6:31 pm

TheTrickster wrote:For any leagues where teams can trade draft picks, is there a way to edit the formulas for the team rosters to direct them to look at different cells?

For example if Team 5 actually had the first pick in Round 3, is there a way to tell the roster stats page to look to cell B1327 rather than F1327 for their third pick?

Your Excel skills are over my head and I couldn't figure out how to do it myself. I don't mind if it's tedious, but since I couldn't figure out how it worked I wasn't sure if it was even possible.

Thanks!


The way it is setup, you would just enter the pick for the teams in order. In other words, if Team 5 has the first pick in round 3, you would just enter Team 5's pick in the Team 5 slot for round 3. The Roster Stats page lists all of the team's picks in the order they are entered on the draft sheet.
DraftTracker 2010 FREE Download Now Available at: http://drafttracker.weebly.com
zebulon
College Coach
College Coach


Posts: 294
Joined: 24 May 2002
Home Cafe: Baseball
Location: Holly Springs, NC

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby zebulon » Mon Mar 01, 2010 11:07 am

Here is a screenshot of a 20 team draft completed with DraftTracker. Yoda projected to come out 5th out of 20. Not too bad


Image
DraftTracker 2010 FREE Download Now Available at: http://drafttracker.weebly.com
zebulon
College Coach
College Coach


Posts: 294
Joined: 24 May 2002
Home Cafe: Baseball
Location: Holly Springs, NC

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby BALCO All-Stars » Mon Mar 01, 2010 11:34 am

WOW...great work guys...I thought the beta version was great, but this is fantastic.

Image
Image
BALCO All-Stars
Major League Manager
Major League Manager

User avatar

Posts: 1990
(Past Year: 38)
Joined: 9 Apr 2007
Home Cafe: Baseball
Location: In mancave playing CodMW2

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby BALCO All-Stars » Mon Mar 01, 2010 11:41 am

Oops...premature celebration. When I try to type into a column, the autosearch function starts typing in the previous column...thoughts?
Image
BALCO All-Stars
Major League Manager
Major League Manager

User avatar

Posts: 1990
(Past Year: 38)
Joined: 9 Apr 2007
Home Cafe: Baseball
Location: In mancave playing CodMW2

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby zebulon » Mon Mar 01, 2010 12:18 pm

Not sure. Never seen that. Make sure you click in the cell you want. Then you can move around with the tab or arrow keys after you enter the name you want.

Also, just want to make sure you are on Windows with Excel 2000,2003, or 2007.
DraftTracker 2010 FREE Download Now Available at: http://drafttracker.weebly.com
zebulon
College Coach
College Coach


Posts: 294
Joined: 24 May 2002
Home Cafe: Baseball
Location: Holly Springs, NC

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby BALCO All-Stars » Mon Mar 01, 2010 12:27 pm

zebulon wrote:Not sure. Never seen that. Make sure you click in the cell you want. Then you can move around with the tab or arrow keys after you enter the name you want.

Also, just want to make sure you are on Windows with Excel 2000,2003, or 2007.


Yes sir. 2003, obviously clicking in the cell that I'm trying to type in. It caught me by surprise too. I downloaded the new version, created the new draft board (14 teams, 22 rounds), then followed the instruction to copy the old draft board (doing a slow draft right now) into a new sheet, deleted the empty columns since the old tracker used two columns per pick, then pasted them into the new draft board. All of the picks were properly removed from the MDP boards but when I went to type in a new pick it reverts to the previous cell.

I opened up the original sheet that I downloaded this morning, and without changing anything, try typing "Albert Pujols" into into the first pick...it reverts to Column A instead of typing in Column B.
Image
BALCO All-Stars
Major League Manager
Major League Manager

User avatar

Posts: 1990
(Past Year: 38)
Joined: 9 Apr 2007
Home Cafe: Baseball
Location: In mancave playing CodMW2

PreviousNext

Return to Baseball Leftovers

Who is online

Users browsing this forum: footballisbetter.com, HotRephoantee, NikkiSixx, wingman3110 and 14 guests

Forums Articles & Tips Sleepers Rankings Leagues


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

Atlanta at Atlanta
(12:35 pm)
NY Yankees at NY Yankees
(12:35 pm)
Chi Cubs at Chi Cubs
(1:05 pm)
Detroit at Detroit
(1:10 pm)
Cleveland at Cleveland
(3:40 pm)
Washington at Miami
(7:05 pm)
indoors
Seattle at Texas
(7:05 pm)
Kansas City at Houston
(7:08 pm)
Toronto at Minnesota
(7:10 pm)
Boston at Chi White Sox
(8:05 pm)
LA Angels at LA Angels
(8:10 pm)
Oakland at Oakland
(8:10 pm)
San Diego at San Diego
(8:10 pm)
Colorado at Colorado
(10:05 pm)
San Francisco at San Francisco
(10:10 pm)
LA Dodgers at LA Dodgers
(10:15 pm)

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