Okay, so, it’s week 5, and I’ve been staring at these fantasy football numbers all morning. I wanted to make a trade value chart for 2023, and let me tell you, it’s been a journey. I woke up early, grabbed a big mug of coffee, and started by gathering all the data I could find.
First, I opened up a bunch of fantasy football websites and just started copying stats. I used a simple spreadsheet to keep track of everything. You know, player names, their positions, how many points they scored in the last few games – all that jazz. It was a bit messy at first, but I managed to get it all organized.
Setting Up the Spreadsheet
- Created columns for player names, positions, and their fantasy points from the previous weeks.
- Added a column to calculate the average points per game. I just divided the total points by the number of games played. Simple math, but it does the trick.
- Made another column for some expert rankings I found online. I thought it would be good to compare my own calculations with what the pros say.
After I had all the raw data, I started crunching numbers. I wanted to figure out each player’s “trade value.” Basically, how much they’re worth if you want to trade them for someone else. It’s not just about their total points; it’s about how consistent they are, whether they’re on a hot streak, or if they’re just a one-hit-wonder.
I spent a good chunk of the day tweaking the formula. I added weights to recent performances, so a player who scored big last week would get a little boost. I also factored in their average points per game, so consistent players wouldn’t get overlooked. It took a lot of trial and error, but I finally came up with something that made sense.
The Final Touches
- Formatted the spreadsheet to make it easier to read. I used different colors for different positions and highlighted the top players in each category.
- Compared my trade values with the expert rankings. Surprisingly, they were pretty close in most cases. But there were a few players my system rated higher or lower, which was interesting.
- Double-checked all the calculations to make sure I didn’t mess anything up. It’s easy to make a mistake when you’re dealing with so many numbers.
Finally, I had my week 5 trade value chart for 2023. It’s not perfect, but I think it’s a pretty good tool for anyone looking to make some trades in their fantasy football league. I shared it on a few forums, and people seemed to find it helpful. Someone even said it helped them win a trade they were unsure about, which was cool to hear.
So, yeah, that’s how I spent my day. It was a lot of work, but I enjoy this kind of stuff. Plus, now I have a handy chart to use for my own trades. Hopefully, it’ll help me win my league this year!
