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