2020 Live Auction Spreadsheet (Google Sheets)
Last season I made a live auction spreadsheet for Google which automatically fetches stats/projections so with just a little updating it works each year. I can't remember where I got the layout from but it was from an amazing Excel sheet (I want to say Draftslayer, but not 100% sure).
Anyways, you can just save a copy to your own Google Drive and edit as you wish. The DEPTH CHARTS HAVE NOT BEEN UPDATED yet for 2020, but all you need to do is paste in the names. As long as they match the names in the Auction Sheet, they'll be crossed off as the Auction progresses.
The rest should be fairly self explanatory. DO NOT EDIT FORMULAS. Just enter the Team Owners on the Teams Sheet and set your scoring in the LeagueInfo sheet. On the Auction Sheet, you can enter Keepers, Amount Paid, and the Owner. During the Auction, just fill in the Amount Paid and the Owner. Everything should update.
There are Macro scripts that need permissions to run, but all they do is Sort and Hide depending on which you press.
If you come across any bugs, let me know and I'll try to look it over. Ideally I'll update the Depth Charts this weekend.
Best of Luck! Happy Drafting!
edit: I have updated the Depth Charts reflecting things as they stand JUST after Lenny F was let go but before he joined TB Tommy. The AAV have been updated as well per ESPN and Yahoo. There is a TAB that is currently hidden which you can input your own Values (DefaultAuctionValues). This will change the calculations throughout the sheet. As for importing Beersheets values, etc...You could enter the values as calculated by Beersheet in the DefaultAuctionValues tab and then selecting that on the LeagueInfo Tab in the Auction$ selection box. The sheet will then use those values to calculate everything.
edit2: Flex values are not calculating properly...I'm looking into it.
edit3: Sheet updated with Flex fixes. Values should be calculating better.
Posted Aug 28, 2020, 9:18 PM UTC · edited
This is just u/elboberto's Custom Auction value generator but in google sheets format right??
https://www.reddit.com/r/fantasyfootball/comments/i7qyzz/elbobertos_custom_auction_value_generator_2020/?ref=share&ref_source=link
THATS IT!!! Yes, absolutely that’s who I modeled it off of and then added some bells and whistles.