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 » Thu Feb 25, 2010 7:58 am

Dugout Diamonds wrote:Wow! I just tried to use this in a CBS mock draft. With a 60 second interval between picks, I knew I would have to hurry to enter picks into the draft board. BUT, as us usually the case, after a couple rds, several people start dropping out, leaving the computer to pick. Before you knew it, things were happening too fast for me to keep the draftboard up, and got so far behind just had to quit. Add in trying to enter all team names, and was a real scramble for about 5 rds, before I scrapped it. I like the project, and believe it will work great during my real draft, but just wanted to try it out before the real thing, and see how the team projections thing worked in trying to adjust my picks. Again, thanks alot for this great tool, just didn't work out this time with me against 7 fast computer pickers. :^)


60 seconds between picks is tough. You might want to try Yahoo mock drafts. There is more time between picks. I've done a few of them and was able to keep up. With the new auto-complete features you shouldn't have to type the full name. In some cases you may only need to type 2 or 3 letters.
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 wrveres » Thu Feb 25, 2010 10:06 am

when you are tracking team names, why not just use 1,2,3,4,5 etc. who cares what they are called.
wrveres
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterEagle EyeInnovative MemberCafe Musketeer
Posts: 31782
(Past Year: 265)
Joined: 2 Mar 2003
Home Cafe: Baseball

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby zebulon » Thu Feb 25, 2010 11:05 am

wrveres wrote:when you are tracking team names, why not just use 1,2,3,4,5 etc. who cares what they are called.



The team names can be changed at the top of the Draft Board
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 wrveres » Thu Feb 25, 2010 11:06 am

thats great. I was responding to this i guess.

Add in trying to enter all team names, and was a real scramble for about 5 rds, before I scrapped it
wrveres
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterEagle EyeInnovative MemberCafe Musketeer
Posts: 31782
(Past Year: 265)
Joined: 2 Mar 2003
Home Cafe: Baseball

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby TheTrickster » Thu Feb 25, 2010 11:10 am

zebulon wrote:
TheTrickster wrote:
zebulon wrote:
You might want to use the MDP Rank sheet to sort by stat since that sheet just uses the composite projections.
The Hitter/Pitcher tabs are meant to be reference tools but aren't very useful in a live draft.


That's true, but you still have the problem if you wanted to see the top 10 HR hitters of 2009 or over the last 3 years or any of the other stat lists.


Well, you could just sort the category you want in Descending order - then you would get the top 10 and everyone else for that matter.


Yeah that's what I've been doing and it's an easy solution. I just wanted to let you know in case you wanted to fix the "Top 10" feature or drop it if it wasn't working. I'm sure it's a minor issue in the grand scheme.
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 » Sat Feb 27, 2010 9:06 am

****OFFICIAL VERSION RELEASED****

Up till now we have been releasing beta versions of the DraftTracker while we work out bugs. We have now released the official version. This version is pretty much functionally the same as the previous one, but has a new updated look and feel and we also added the MDP Rank value for players on the MDP Tiers sheet so both sheet can be cross-referenced.

We cleaned things up a bit to limit the amount of scrolling.

One note: since we changed the Draft Board to use a single cell instead of 2 cells for the name, if you are planning on copying players from an old sheet to the new one, you need to first copy the old draft sheet to a blank new sheet. Then, delete the 2nd blank column for each team, then copy to the new sheet.

Download 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 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: 6490
(Past Year: 15)
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.
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

PreviousNext

Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 8 guests