| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | VERSION 8.2 IS NOW AVAILABLE! | |||||||||
2 | https://docs.google.com/spreadsheets/d/1PeOWFDZmDC-d_TrM-ffiYTS6OtabfnLcPctAOIvoF8s/edit?usp=sharing | |||||||||
3 | ||||||||||
4 | ||||||||||
5 | Created by @Dubner_Michael | |||||||||
6 | ||||||||||
7 | Instructions | Instructions for updating an old tracker to the new version of the tracker: | ||||||||
8 | This template is "view only". Click "File" -> "Make a Copy" to download your personal copy. | *ignore this if starting new | ||||||||
9 | - NEW Tutorial: Updating Tracker | |||||||||
10 | Link to Tutorial | -Make a personal copy of the tracker: "file" -> "make a copy" | ||||||||
11 | Subscribe to the email list to receive notifications when updated versions of the tracker become available. https://forms.gle/ghs5U5VitWTYTEsRA | -Copy old rosters: In your old tracker, go to "Rosters" tab, highlight and copy cells B1-B#. Go to "rosters" tab in new tracker, paste values only into cell B1. Go to rosters in old tracker, copy all players, then paste values only into new rosters. | ||||||||
12 | ||||||||||
13 | ||||||||||
14 | If you already use an older version of the tracker, upgrade to the newest version by following the instructions in cell G3. | -That is all. Everything else will auto-update. *See youtube tutorial (linked above) regarding incomplete teams + checking for errors. | ||||||||
15 | This tracker can be used for all Best Ball platforms, and currently supports 1000 rosters. If you need additional rosters, DM me on Twitter, and I can add as many as you need. | If you imported Underdog rosters without the bulk roster import tool | ||||||||
16 | *ignore this if you used the bulk roster import tool for all UD rosters. Your old rosters may be using the incorrect League Name and/or League ID. You have two options: 1. If you DO NOT have any notes in the "untracked notes" metadata, I recommend DO NOT copy your underdog teams from your old tracker into your new tracker. Instead, just use the underdog bulk roster import tool to import all UD teams into your new tracker. Then use instructions in G3 to copy & paste your non-underdog teams into the new tracker. 2. If you DO use the "untracked notes" fields and do not want to lose these notes, you can either A) (Recommended) Use the UD bulk roster import tool to import all of your underdog teams. Then pull up your old tracker and manually add your old untracked notes to the new rosters. B) Update to the new tracker with the instructions in cell G3, then manually update the league names (to match those listed in the dropdown menu) & correct your League IDs (see note attached to "League ID" cells in the "Rosters" tab for instructions). | |||||||||
17 | ||||||||||
18 | Cells with a black triangle in the top right corner (like this cell) have a note attached. Click on the cell to view the note, which will explain what certain things mean and will answer most questions. | |||||||||
19 | ||||||||||
20 | ||||||||||
21 | If you have additional questions, comments, or suggestions, my twitter is @Dubner_Michael. You can use this form to submit feature requests: https://forms.gle/oTMK1iscJxShx35F7 | |||||||||
22 | ||||||||||
23 | ||||||||||
24 | ||||||||||
25 | ||||||||||
26 | If you find this tracker helpful and would like to donate (maybe a BBM or Puppy draft!) to help keep it free: Venmo - @Michael-Dubner; PayPal - michael.dubner@gmail.com | |||||||||
27 | ||||||||||
28 | 8.1 Updates | |||||||||
29 | The following link brings you back to the Best Ball Tracker Template: https://docs.google.com/spreadsheets/d/1WLDY7WKfd2FR8uvaschnP8itEybKBUjf2RTORCZAgMA/edit?usp=sharing | - Metadata updates: removed "regular season points" field, added "quarterfinals", "semifinals", and "finals" advance status. | ||||||||
30 | - Roster finder: Added playoff advance status to settings filter. During the season, you can now use the roster finder to show all teams that are still alive in the playoffs to help you sweat the games. | |||||||||
31 | - New video tutorial for upgrading to version 8.1+ of the tracker (cell G5) | |||||||||
32 | - On The Clock: Next player considerations now displays your exposures. | |||||||||
33 | - "Results": Draft Splits | |||||||||
34 | ||||||||||
35 | Version 8 Update Log | |||||||||
36 | - "Roster Finder" Tool | |||||||||
37 | - Underdog player name changes: Tutorial; in "Rosters" click "edit" -> "find and replace" -> find "Kenneth Walker" & replace with "Ken Walker" on "This sheet" -> "Replace All". Do the same for find "Brian Robinson Jr" replace with "Brian Robinson". | |||||||||
38 | ||||||||||
39 | - Improved Hyper Fragile and Robust RB definitions (see note attached to roster construction cells in Exposures tabs for updated definitions) | |||||||||
40 | - Added League Name "Rookies & Sophomores" & "Rookies + Sophomores 2". use UD Bulk Roster Import Tool to import R&S drafts. | |||||||||
41 | - Updated note on tracking "Rosters" metadata for DraftKings - the app displays "Draft Speed" for completed drafts, click on the gears icons, then scroll to "other details" | |||||||||
42 | - Updated conditional formatting so position colors match Underdog (purple QB, green RB, yellow WR, blue TE) | |||||||||
43 | - "Results" added additional settings filters | |||||||||
44 | - Updated Underdog ADP | |||||||||
45 | - Maintenance and bug fixes | |||||||||
46 | ||||||||||
47 | Current To-Do List | |||||||||
48 | ||||||||||
49 | ||||||||||
50 | Wish List | |||||||||
51 | - Player Exposures for a Key Roster Construction; roster construction Exposures for a Key Player | |||||||||
52 | -Auto-update ADP: find site where we can use =importhtml table for best ball adp | |||||||||
53 | - Exposures to playoff game stacks. eg. % of teams with any BUF/CIN stack. Could get more granular and show the type of stacks QB/WR/Opp WR, QB/WR/WR/Opp RB, WR/TE/Opp WR etc etc. | |||||||||
54 | -DST for BestBall10s | |||||||||
55 | - continue to improve Results tab; ideally UD lets us download our results and I create a results import tool | |||||||||
56 | ||||||||||
57 | ||||||||||
58 | ||||||||||
59 | ||||||||||
60 | ||||||||||
61 | ||||||||||
62 | ||||||||||