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.

Google Auction Spreadsheet

Posted Aug 28, 2020, 9:18 PM UTC · edited

214
lethalmonk6•
3
ResevdogOP•

THATS IT!!! Yes, absolutely that’s who I modeled it off of and then added some bells and whistles.

1
ipoop_alot•

This is a neat adaptation of u/elboberto's sheet.

I think there are a few things that weren't updated from last year's values: The depth charts (as you mention), but also the ESPN auction values. I'm also not sure if they are supposed to represent the average auction values or the values ESPN suggests.

I'm also curious if you messed with budgeting/VBD per position? Elboberto's calculations don't give such high peaks for top tier QB, TE...

3
ResevdogOP•

Depth Charts and Default Values were just updated. The sheet lets you pick which values you want to use. The choice is made on the LeagueInfo tab.

I don't recall if I messed with the underlying formulas last year. But I'm using the starter/bench formulas (with a 90/10 split to starter value) instead of Avg VBD. That tends to weight more to the higher end. Switch to AVG VBD (also on the LeagueInfo tab) for a smoother curve or shift the balance of starter/bench to something more like 75/25.

1
RfLock7•

How does this even work bro

1
ResevdogOP•

Are you asking how to use it, or how does the magic happen?

2
RfLock7•

How do I use it

I want the magic

1
ResevdogOP•

Step 1: Save a copy to your Google Drive. Step 2: Go into the Tab LEAGUEINFO and set your scoring and League Settings. For example, 4pts per TD Pass enter 4. 6 Pts, enter 6. Step 3: Go to the TEAM tab and enter the Owners. Ten team league I believe was the default. Step 4: Any Keepers? Go to the Auction Tab and enter the Amount Paid, select YES in the Keeper column, Select the Owner. Repeat. Step 5: The Auction. As players are bid and bought, fill in the Amount Paid and the Owner on the AUCTION Tab. EVERYTHING else SHOULD update automatically. Teams, Depth Charts, Cheat Sheet, Budget, etc. I actually found the Depth Chart the most useful during the Auction as a quick reference for handcuffs, scarcity, and stacking. Step 6: Profit. Or not. This season is going to be a lot about luck...

2
RfLock7•

Yea but I’m on mobile

1
sykosexythatisme•

This is helpful, maybe add it to your post?

1
sykosexythatisme•

This is great. Thanks for sharing.

1
PartySpiders•

Is there any way to import beersheet values into this ?

1