Dominate your Fantasy Draft with this Custom Cheat Sheet!

I created a Fantasy Football ranking sheet last year a spreadsheet and it pretty much allows you to make your own rankings and compare them versus consensus uh rankings and I want to say ADP but it's not actually ADP it's just the consensus rankings on different websites and so I have those ranks and I put it in a spreadsheet and I'll share the spreadsheet with you and I want to do a quick walk through uh about what the sheet is I did this sheet in 2023 this is an updated version of it I had people in the comments asking for a new version of the spreadsheet and so I'm a man of the people I I went and it is 2: a.m. and I went through and I made a new uh updated sheet and so without further Ado here it is this is the spreadsheet and it's pretty simple all there's everything's labeled you pretty much in order to change the ranks so uh if you wanted to this right here over here is your your rank in order to change the rank you need to uncheck this check boox and then you can move stuff around so say I thought Tyreek Hill was the number one player I could do that and and then boom number one player but you're not done yet you still have to save it so in order to save it you have to run a script that I I made and you just press this lock button and boom now it's locked and so Tyreek Hill is your number one player once I moved him so it's simple as that just drag and drop you have to remember this like locking mechanism where you unlock it with the checkbox and then lock it with the thing there's going to be a popup when you first do this to uh lock it in and it's just basically asking for permission to run the script um and you can just go through and and accept the permission in order to get it to work so that's that that's very simple if you press this drafted button it Grays them out so you could also use this as your draft tracker uh you've got your position rank here you can manually do tiers right so like you think Tyreek Hills tier one do that it's red right now because I don't have lower tiers in there but if you if you fill it all out it'll be green to Red where red is the lowest tier so let's clear that out and then this right here is just your rank versus Yahoo and you can go through and change it to whatever platform you want ESPN we also have the fantasy pros ECR which is expert consensus rank shout out to Juicebox one on Reddit he's the one who's supplying kind of all this uh data all these rankings data to make this possible this is all getting pulled directly from his spreadsheet and feeding into mine so yeah I left his I left his info here his Twitter at and his uh Reddit username right there and then this is the one that I spent the most time on it's called the draft board View and simply it's just taking whatever platform you input here and it's saying okay this is the round these are the players in round one for on sleeper and then all it's doing is ordering them by whatever rank you want and so you could do your rank and it'll order it by your rank it'll order order it by your rank and just will be the players that go in the first round on sleeper so that way like when you're drafting you you can basically just get a sense for you know who your ranks like the best without like reaching by round and rounds of ADP if that makes any sense there's also the ability to so like once you cross guys out here too it also will will update on the draft board view as well so I just a double check I did CD lamb and Justin Jefferson if you go back CD lamb and Justin Jefferson are great out here so that works just fine it only goes 15 rounds this is all one quarterback leagues unfortunately I am a fan of super flex but I figured most people play in one quarterback if you have a different draft type for whatever reason it's like a weird kind of League say you don't do snake where you basically just do laner where you go straight and then and so the first person with the first pick would also get the first pick in the second round and blah blah blah that's most most leagues are not like that but it's an option if you wanted to look at third round reversal this is uh a format where you basically it's just like snake but the third round is just reversed order and then it goes on from snake from there so that it has those different draft type options you can change your your league size settings too I went up to 14 uh sorry to all those 16 team sickos out there um I apologize that you can't use this but yeah that's that's pretty much it I spent a decent bit of time on this update here and yeah if you like it like comment subscribe if you have any like suggestions feedback anything of the sort let me know this might be the last year that this sheet exist as a spreadsheet because and don't don't don't hold me to this but there's a potential that this sheet gets converted into a website that has pretty much a same functionality and does the same thing but isn't on Google Sheets you know you'll be able to make your own rankings do everything that you can do on the sheet hopefully next year on a website and I'll keep you guys posted if I'm able to get it on a website before the season starts I think it's possible but I'm not 100% sure so again don't hold me to that but yeah appreciate it and good luck in your drafts