Page 1 of 1

2021 DC Draft Tracker

Posted: November 30th, 2020, 9:34 pm
by butlerj25
First, thanks so much to Todd for putting this together. I'm though the first 11 rounds of my DC and it's working great. I just wanted to mention a couple of modifications that I've made to my copy in case you're interested.

The first thing I did was add the dollar values from your projections sheet to the Hitting and Pitching tabs. It would be great if your tracker player IDs matched the IDs in the projections spreadsheet, but I made it work. It gave me a way to sort the players by overall value. I'm also using that tab to cross off player names once they've been drafted. I used conditional formatting to shade the players dark gray as they are selected in the Picks list so that I can see who's taken and who's left.

The other thing I did was add categories targets for DCs. I used the 2019 final DC standings values that I found in The Process book. I'm sure it's not a perfect value to use, but it's a good ballpark.

Thanks!

Re: 2021 DC Draft Tracker

Posted: November 30th, 2020, 9:46 pm
by Todd Zola
Thanks for the feedback. The names need to be in the Tracker form to differentiate players with the same name. That said, I could carry over the MLB ID's.

As for the other suggestions, I actually already have them all coded, but I wanted to make sure the basic features of the Sheet were battle tested. I hope to be able to add on some really cool features next weekend.

Re: 2021 DC Draft Tracker

Posted: December 4th, 2020, 7:58 pm
by butlerj25
FYI - I did not find Tomoyuki Sugano on the list. He was drafted in the 27th round of my current DC.

Re: 2021 DC Draft Tracker

Posted: December 4th, 2020, 8:11 pm
by Todd Zola
Sugano was added to today's update. I just realized I forgot to add Sung Bum Na - I'll add him next week.

Re: 2021 DC Draft Tracker

Posted: December 7th, 2020, 4:09 pm
by butlerj25
There are a few more guys that were drafted in my current DC that I don't see in the tracker:
Spencer Torkelson
Scott Oberg
Mel Rojas
Haruki Nishikawa
Kohei Arihara
Reyes Moronta
Andres Munoz
Seth Beer

Also, Caleb Furguson had TJ in September, so he won't be pitching in 2021.

Re: 2021 DC Draft Tracker

Posted: December 7th, 2020, 4:15 pm
by Todd Zola
Thanks. I generally look at the NFBC ADP every few weeks and add any missing players. I should have time to scrub the list this weekend. Last week was goofy with the non-tenders.