Live Auction/Draft Cheatsheet Tool

I adapted elboberto and beersheets (all hail the kings!!!) and put it all into google sheets so I can access it on the go anywhere. Here's my live auction cheat sheet. It also works for drafting as you can just enter $1 or whatever as the price when picked.

https://docs.google.com/spreadsheets/d/19ijNPS6BUDaSyV3BBWPpvFvMK1EZhvi77a51dQgAfjs/edit?usp=sharing

Just make a copy into your google drive and you're good to go. Couple heads up - if a player is released from an NFL team, you'll get an error on the auction page. You just need to scroll down to their name in the list and delete ONLY their name and position. Everything else autopopulates and recalculates (including the cheatsheet).

The Depth Charts need to manually changed when changes occur. But be sure the names match to what is entered on the Auction page.

If a player gets added and becomes relevant, they may show up on the cheat sheet with an error. That's because they need to be added to the Auction page. Just scroll down to an empty line and add their name and position only. Again, the rest will autopopulate. It should also update automatically year to year so long as the site it pulls the player stats from stays constant. All that needs to be changed is the Player list and Positions on the Auction page and the Bye weeks on that sheet (it's a hidden sheet). (first 2 columns. Just copy and paste in the names and positions)

edit: forgot to mention there are some simple macros that only filter the lists for quick searching. You can also filter or sort any of the columns on the Auction page. You can adjust your budget however you like. You can change your league settings on the LeagueInfo page such as scoring etc.

Hope it helps. If you have any questions on usage or issues, I'll try to answer as quickly as possible.

edit 2: I've been trying to keep up with the cutdowns today to keep it as up to date as possible so as to not get the n/a errors on the Auction page. Also Projections are getting revised almost constantly today and there is a step to update the Cheat Sheet (Beersheet) Page. Go to the sheets for the individual Posititions and resort the first column A-Z (just click that little triangle thingy where it says Rank). This reorders the positional rankings based on stat projections translated to VBD which in turn feeds the data to the Cheat Sheet.

edit 3: the internet and google are crapping on us. Getting html errors from the stat feed at fantasypros. Sometimes you just need to wait a few minutes and it fixes itself. Lots of stat projection corrections happening there so the cache gets out of sync. That's the cause of most if not all of the sheet errors we see today.

EDIT 4: DEPTH CHARTS ARE NOW DYNAMIC!!! They should update automatically! Fingers crossed. They pull the ESPN fantasy football depth charts. So when those are updated, this sheet should update as well.

Posted Aug 30, 2021, 9:46 PM UTC · edited

2822
Loading comments…