2021 DC Draft Tracker
Posted: November 30th, 2020, 9:34 pm
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!
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!