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 » Sun Feb 28, 2010 6:31 pm

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.

Thanks!


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
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 01, 2010 11:07 am

Here is a screenshot of a 20 team draft completed with DraftTracker. Yoda projected to come out 5th out of 20. Not too bad


Image
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 BALCO All-Stars » Mon Mar 01, 2010 11:34 am

WOW...great work guys...I thought the beta version was great, but this is fantastic.

Image
BALCO All-Stars
Major League Manager
Major League Manager

User avatar

Posts: 1995
(Past Year: 6)
Joined: 9 Apr 2007
Home Cafe: Baseball
Location: In mancave playing CodMW2

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby BALCO All-Stars » Mon Mar 01, 2010 11:41 am

Oops...premature celebration. When I try to type into a column, the autosearch function starts typing in the previous column...thoughts?
BALCO All-Stars
Major League Manager
Major League Manager

User avatar

Posts: 1995
(Past Year: 6)
Joined: 9 Apr 2007
Home Cafe: Baseball
Location: In mancave playing CodMW2

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby zebulon » Mon Mar 01, 2010 12:18 pm

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.
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 BALCO All-Stars » Mon Mar 01, 2010 12:27 pm

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.
BALCO All-Stars
Major League Manager
Major League Manager

User avatar

Posts: 1995
(Past Year: 6)
Joined: 9 Apr 2007
Home Cafe: Baseball
Location: In mancave playing CodMW2

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby zebulon » Mon Mar 01, 2010 12:46 pm

OK. Let me see if I can duplicate that behavior. I do not see that in 2007. I will see if I can find a copy of 2003 somewhere.
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 01, 2010 12:55 pm

Tested in on 2003 and did not have a problem. Can you post the exact steps you were doing so I can follow what you did?
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 KCollins1304 » Mon Mar 01, 2010 12:57 pm

BALCO All-Stars wrote:
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.


I can confirm that this happens with mine as well. Though after it does that if I reselect the correct column again I can type in it.
KCollins1304
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterCafe RankerMock(ing) DrafterEagle EyePick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 5089
Joined: 29 Dec 2005
Home Cafe: Baseball
Location: Charlotte, NC

Re: Drafttracker (Excel Kit) - Final Update 3.21.09

Postby mrbo » Wed Mar 03, 2010 1:38 pm

Hey, this looks really good. Thanks for all your hard work putting this together and keeping it updated!

I have a couple of questions and wasn't sure if its better to ask here or on the weebly site.

1) On the Setup tab, would it be possible for me to customize the lineup and/or stats? My league uses 1 IF position rather than MI/CI, and I would also like to be able to track LF, CF, RF and OF separately. Also would like to add OPS and Holds to the stats. (and maybe K/9?)

2) Is it normal to have a bunch of garbage data in the dropdowns after the last player? eg; df, ds, fdgs, It appears a baby was trying to enter some of the players :-b

Of course I don't expect you guys to make any changes just for me, just curious how hard it would be for me to modify it myself. I don't really know excel too well.

Thanks again.
mrbo
College Coach
College Coach


Posts: 163
Joined: 15 Jun 2004
Home Cafe: Baseball

PreviousNext

Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 10 guests