Clickable Fantasy Football cheat sheet

August 24, 2024 8:33 PM

I'm going to an in-person fantasy football draft done on a big board, and every year I have to kludge together a bunch of different lights and spreadsheets just to be able to teach who's been taken. Is there a website, spreadsheet, or Google doc that I can just use instead?

A few things:
-I need it to be more than just the top 100 players. Ideally it's all of them but whenever I've used the limited ones it doesn't work
-Sortable would be great, but it would be fine if it's sorted by the consensus top players
-By clickable I mean I want to be able to click on a name or a button and have it disappear, or get blacked out, or striked out, having to do that myself for every player picked falls apart later in the draft.

I don't know if this exists, but I mainly just want to duplicate having a big paper list that I strike out with a sharpie, but digitally.

posted by Carillon to Sports, Hobbies, & Recreation (3 answers total)

I have a friend who I think did this. I have a call into him to ask about it. I think what he did was go to one of the FF websites such as Yahoo, CBS or ESPN. He was able to download a .csv file of every player with all sorts of rankings and stats. He put it into a spreadsheet and set up an extra column where he put an "X" in there when the player was drafted. He would then sort by that column. All the "X's" were then at the bottom and the other players could be sorted alpha or by position or by any of the columns. It was cumbersome and he lost a lot time sorting and looking for players. but it helped.

Why can't your league do both a big board in person draft and have someone, the commissioner or his son or his wife or anyone also enter the players into the website that will ultimately be entered into anyway? Maybe delay the entry into the system by one or two draft spots so there is still the focus on the board. We did that one year and after that the draft was held in the same room, but all electronically.

If/when I hear from said friend, I will post what his solution was.
posted by JohnnyGunn at 9:57 PM on August 24

I just saw this. A how to create a csv file of the players and their data on ESPN
posted by JohnnyGunn at 10:10 PM on August 24

Seems like the easiest way to achieve this would be to take that big csv, open it in sheets or excel, and add a column with a radio button. You can add conditional formatting to black out any row that the button is selected on, and then keep sorting by the button row to keep unclaimed prospects on top. Sorting by ranking first would probably be easiest to read.
posted by skookumsaurus rex at 7:09 AM on August 25