Drafttracker (Excel Kit) - Final Update 3.21.09 - Fantasy Baseball Cafe 2015 Fantasy Baseball Cafe


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 zebulon » Wed Mar 03, 2010 1:54 pm

Our player list doesn't distinguish OF positions - by LF, CF, RF, so we only support generic OF designation.
In terms of supporting a single IF position, we built the tool to fit with most standard setups. It would be almost impossible to account for every variation unfortunately. The position tracking has some fairly sophisticated formulas that help determine where to slot players.

As for the garbage letters, they are really just meant to be place holders since our player list is shorter this year than last year, but we wanted to preserve the formatting of the macros on the draft board - so you can just disregard that. You really shouldn't need to use the drop down anyway as it updates as you type.

Being that this is the official release, we aren't releasing any more functionality changes - just MDP updates at this point. However, once you download it, you can do whatever you want to it to try and make it better except that he keep the macro code password protected to protect the hard work of the developers.
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 » Thu Mar 04, 2010 9:44 am

It is fairly easy to manually assign picks to other teams in the case of picks traded. Here is a screenshot from our league:

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 zebulon » Thu Mar 04, 2010 1:51 pm

Well technically, but when it got that pick in the draft, you would just enter the pick under the owner who owns the pick at that point. Since I have the names listed next to the number I know who it belongs to.
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 » Sat Mar 06, 2010 12:48 am

New update just released today - contains the latest MDP data.
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 mscogle » Sat Mar 06, 2010 12:40 pm

Thanks again for sharing this great resource with us all. This will be my second year using the spreadsheet for my drafts. Can't wait to put it into action again.

Question: Composite batting average projection for Chipper Jones is shown as 0.376. Data entry error?
mscogle
T-Ball Trainer

User avatar

Posts: 4
Joined: 6 Mar 2010
Home Cafe: Baseball

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby zebulon » Sat Mar 06, 2010 11:11 pm

Chipper has been corrected to show a .292 avg projection.

Also, a couple of players were missing from the Tiers tab which were added back in.

Updated download at: http://drafttracker.weebly.com (Version 3.5)
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 TheRock » Wed Mar 10, 2010 7:50 pm

zebulon wrote:Chipper has been corrected to show a .292 avg projection.

Also, a couple of players were missing from the Tiers tab which were added back in.

Updated download at: http://drafttracker.weebly.com (Version 3.5)


So if I have half a draft entered in on an older copy, how would I get the new MDP data into my existing spreadsheet? Not seeing a readily apparent way to do that.
Image
TheRock
General Manager
General Manager

User avatar
CafeholicCafe WriterMock(ing) Drafter
Posts: 3055
(Past Year: 3)
Joined: 16 Apr 2003
Home Cafe: Baseball
Location: America's Heartland

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby zebulon » Thu Mar 11, 2010 2:11 pm

TheRock wrote:
zebulon wrote:Chipper has been corrected to show a .292 avg projection.

Also, a couple of players were missing from the Tiers tab which were added back in.

Updated download at: http://drafttracker.weebly.com (Version 3.5)


So if I have half a draft entered in on an older copy, how would I get the new MDP data into my existing spreadsheet? Not seeing a readily apparent way to do that.


You can download the latest version. Then from the older version cut and paste your draft board into the new version.
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 15, 2010 12:18 pm

For those of you have not drafted yet, the latest MDP has been updated.
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 xtreme99 » Mon Mar 15, 2010 2:28 pm

Looks good. ;-D
Image
I feel sorry for people who don't drink. When they wake up in the morning, that's as good as they're going to feel all day.
xtreme99
Minor League Mentor
Minor League Mentor

User avatar

Posts: 494
(Past Year: 20)
Joined: 3 May 2005
Home Cafe: Baseball

PreviousNext

Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 3 guests

Forums Articles & Tips Sleepers Rankings Leagues


Get Ready...
The 2015 MLB season starts in 8:32 hours
(and 23 days)

  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact