Page 49 of 50

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

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

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

PostPosted: Thu Mar 04, 2010 9:44 am
by zebulon
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

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

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

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

PostPosted: Sat Mar 06, 2010 12:48 am
by zebulon
New update just released today - contains the latest MDP data.

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

PostPosted: Sat Mar 06, 2010 12:40 pm
by mscogle
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?

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

PostPosted: Sat Mar 06, 2010 11:11 pm
by zebulon
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)

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

PostPosted: Wed Mar 10, 2010 7:50 pm
by TheRock
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.

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

PostPosted: Thu Mar 11, 2010 2:11 pm
by zebulon
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.

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

PostPosted: Mon Mar 15, 2010 12:18 pm
by zebulon
For those of you have not drafted yet, the latest MDP has been updated.

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

PostPosted: Mon Mar 15, 2010 2:28 pm
by xtreme99
Looks good. ;-D