Okay, folks, let’s dive into my little adventure with fantasy football positional rankings.
So, the season is just around the corner, and like every year, I’m scrambling to get my draft strategy in order. This year, I decided to get a bit more methodical about it and really dig into positional rankings. I’ve always kinded of winged it, grabbing players I liked, but that hasn’t exactly led to championships, you know?
Getting Started
First thing I did was hit up the usual suspects. you know, all those big sports sites. I wanted to see what the “experts” were saying. I opened, like, a dozen tabs – seriously, my browser was crying.
I started jotting down the top-ranked players at each position (QB, RB, WR, TE, K, DEF) from each site. Just a simple list, nothing fancy. Man, that took a while, though. Lots of scrolling and clicking.
Compiling the Data
Then came the “fun” part. I figured, “Hey, I’ll just average out the rankings from all these sites and get a ‘consensus’ ranking!” Sounds easy, right? Wrong! Turns out, everyone ranks players a bit differently.
I ended up making a big old spreadsheet. Yep, a spreadsheet. My wife thought I was doing actual work, haha! I put each player’s name, their position, and then their ranking from each site I checked. Some sites had, like, 100 players ranked, others only 50. It was a mess.
The Averaging Headache
The averaging wasn’t as simple as I thought. If a player was ranked #1 on one site and #10 on another, that’s a big difference! And what about players who weren’t ranked on some sites? Do I count them as zero? Do I just ignore them? I ended up giving unranked players a low rank, like, the very bottom of the list. It wasn’t perfect, but it felt better than nothing.
I played around with some formulas in the spreadsheet, trying to weight the rankings, because I trusted my intuition that a player’s position is very important. I also wanted to make sure a player’s average ranking gave me a clear picture.
My Own Little Ranking
After a few hours of fiddling with the spreadsheet (and a few cups of coffee), I finally had something that resembled my own, personalized positional ranking. It wasn’t pretty, and I’m sure a real data analyst would laugh at it, but it felt… mine. It was based on a bunch of different sources, plus my own little tweaks.
The Results?
Well, I haven’t had my draft yet, so I can’t tell you if this whole thing was a brilliant success or a complete waste of time. But I feel more prepared. I have a list, a guide, something to help me make those crucial draft-day decisions. And hey, even if it doesn’t work out perfectly, at least I learned a few spreadsheet tricks, right?
Key Takeaways(Just my own experience)
- Gather Data: I started by collecting positional rankings from various sources.
- Compile: I used a spreadsheet to organize the data, noting each player’s ranking from each source.
- Calculate Average: Then averaged the rankings to get a “consensus” ranking for each player.
- Adjusted: I made some personal adjustments based on my own preferences and gut feelings.
- Make My Own Ranking List: Then it’s done, all based on my needs.
Wish me luck! I’ll update you guys after the draft and let you know how my “super-scientific” rankings performed.