Drafttracker (Excel Kit) - Final Update 3.21.09

[Amazinz]

Moved to Leftovers.

[Yoda]

Those of you who received the file, please give us some feedback. Thanks!

[C2ThaLo88]

Those of you who received the file, please give us some feedback. Thanks!

Yes please do. We're quite satisfied with what we've done and hope everyone else likes it as well.

[RynoDyno]

Damn boys, you've outdone yourselves, that's slick. Tiered ranking tied to MDP I believe (?) and overall lists both on one easy to view sheet. multiple projections, well done.

I only wish the draft tracker sheet could fit on one screen, but that's on me for not having a widescreen monitor (or dual monitors).

I'll get to play around with it more later, but it's lookin impressive.

PS. What are the positions in black at the bottom of the draft tracker for? Just a position reminder for leagues?

[rookies and cream]

I only wish the draft tracker sheet could fit on one screen, but that's on me for not having a widescreen monitor (or dual monitors).

View ---> Zoom ---> 75% should work just fine

[C2ThaLo88]

PS. What are the positions in black at the bottom of the draft tracker for? Just a position reminder for leagues?

Yeah, I believe you have to manually maintain that however. With players having multiple position eligibility and leagues with different formats, it would be difficult to have a formula take care of that.

[RynoDyno]

View ---> Zoom ---> 75% should work just fine

Thanks R&C, I had tried that, but it's that I'm stuck on a 1280x1024 at work and even at 75% teams 11/12 get cut off. I've got a 1600x1200 at home, I'm sure it'll be good there which is what matters for drafting.

[Yoda]

View ---> Zoom ---> 75% should work just fine

Thanks R&C, I had tried that, but it's that I'm stuck on a 1280x1024 at work and even at 75% teams 11/12 get cut off. I've got a 1600x1200 at home, I'm sure it'll be good there which is what matters for drafting.

Yeah as Rookies said you can change the view settings or just make the columns slimmer so you can fit the whole sheet on the screen.

As far as the positions at the bottom goes, you need to manually delete those as you enter the players into the sheet. You can put in your own league settings here and just keep track of who still needs what to fill. But definitely optional.

[Curtis Pride]

Conditional formatting is the easy way to do what you are looking for.

No need for cell equations.

To make it easy, have an extra column on each tab that shows "-1" or really anything you want if the player is listed on the drafted tab (vlookup).

Then have a conditional formatting statement that says if the extra column on the page is "-1" that you strike out the name or delete it entirely with a white font (I personally like strikeout).

Conditional formatting doesn't use as much system resources as having a bunch of formulas in every cell, so the sheet may be faster.

[Yoda]

We created one without PECOTA. People have been very good and honest about it but we will require you to email a copy of the PECOTA if you want it included in the Draft Kit. Thanks.