Fantasy Sports League Team Building: Points Rules, Value per Price, Budget-Constrained Squads, Captain Picks & Transfer Planning
Build a stronger fantasy team with numbers rather than hunches. You will turn a fictional points system into expected points, rank players by value per price, build a squad that fits the budget and position limits, choose captains, plan transfers including points penalties and review a season's decisions, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you build a fantasy team in a spreadsheet instead of by gut feeling. You turn match stats into points with a position-based scoring table and SUMPRODUCT, weight recent form and fixture difficulty into expected points, and rank players by points per credit across the pool and within each position. You check a squad against the budget and position limits, make greedy picks with MAXIFS, compare captains by expected points and spread, value bench players with start chances, and work out when a penalised transfer breaks even. A season review with a cumulative chart closes the course. All leagues and players are fictional – no betting, no prize money.
Lessons
- Points Rules: Turning Match Stats into Fantasy Points Pro
- Expected Points: Weighted Recent Form and Fixture Difficulty Pro
- Value per Price: Points per Credit and Rankings by Position Pro
- Squad Building: Budget, Position Limits and Greedy Picks Pro
- Captain Picks: Double Points, Expected Value and Risk Pro
- Bench & Rotation: Playing Chances and Expected Bench Points Pro
- Transfers: Points Penalties, Gain over n Rounds and Break-Even Pro
- Season Review: Points by Decision Type, Best & Worst Picks and a Cumulative Chart Pro