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 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.
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.
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.