I used to spend two weeks on a fantasy projection spreadsheet every year. Built something that does it in an hour — want honest feedback
Website: Statsnap.io
Context for the tool: For years I built my fantasy projections in Excel. Every offseason I'd spend weeks setting up formulas, manually entering team stats, tweaking player share assumptions, and then watching the whole thing break when I changed one cell. It was genuinely fun but also kind of miserable — by the time I finished projecting all 32 teams I was exhausted and draft season was already halfway over. This year I decided to just build the thing properly.
Statsnap (statsnap.io) is essentially my Excel model turned into an actual web app. The idea is simple: instead of trusting someone else's rankings, you build your own from the ground up in about an hour. The flow is:
How it works:
- Pick a team, set their offensive profile — expected plays, pass rate, completion %, yards per carry, projected TDs
- Assign each player their shares — rush attempt share, target share, reception share, TD share
- Your rankings and WORP scores generate automatically
That's it. What used to take me two weeks of spreadsheet hell now takes about an hour to get a full set of projections. And because you built them yourself you actually understand why Player A is ranked ahead of Player B — it's not a black box.
What's exciting:
A few things I'm especially happy with:
- **Tier system** — instead of arbitrary cutoffs, the tool finds the biggest natural WORP gaps in your own rankings and draws tier lines there. Your tiers reflect your model, not some generic consensus.
- **Trade analyzer** — uses a scarcity model based on your actual league size. In an 8-team league the top 16 RBs are all starters, so the math weights elite players very differently than in a 14-teamer. So as you go through early season trades, it can help. It takes a hybrid of final 2025 WORP to account for previous 2025 WORP and your projected 2026 WORP
- **Dashboard** — shows your biggest risers and fallers vs 2025 actuals, TD swings for all 32 teams, and tracks how many teams you've projected so far.
What I'd love for you:
- Check it out and have fun
- Your feedback with questions below.
Honest questions for anyone who checks it out:
- Does the projection editor feel intuitive or like too much work?
- Are the WORP tiers actually useful during draft prep?
- What's the one thing missing that would make you actually use this?
Still in early access and genuinely just looking for feedback. If you're the kind of person who used to have a projection spreadsheet and gave up because it was too painful to maintain — this was built for you.