FFPC Playoff Challenge Roster Builder: Simulate Lineups Based On Expected Games Played, Average Scoring, More
Playing in any fantasy football contests for the 2022 NFL playoffs?
Samantha Previte created a tool so you can compare potential lineups before locking in your roster for contests like the FFPC Playoff Challenge. She used the very same downloadable spreadsheet to simulate the postseason, calculate expected points for players accordingly, and build a sample lineup for that FFPC contest here.
Below are step-by-step instructions on how to do the same.
FFPC Playoff Challenge Roster Builder
Step 1: Download the spreadsheet
First, you’ll need to download the spreadsheet, which you can do by clicking here.
Step 2: Project the bracket
Since playoff contests are scored based on the full postseason, accounting for how many games a player could play in is a critical factor when creating lineups.
That’s why the base of Samantha’s spreadsheet builder is the “Playoff Bracket” tab, which you can use to project which teams you’re expecting to win each matchup of every round:
The number expected games played for each player changes based on the result of any changes to that bracket tab, then factors into their “Expected Total Fantasy Points (FPTS)” calculation in the “Projected Playoff Fantasy Points” tab, which multiples their expected games played by the average number of PPR points they scored between Weeks 1-17 of the regular season.
The final column of that “Projected Playoff Fantasy Points” tab also shows the difference between the expected points calculation for a given player vs. the positional average:
Step 3: Simulate Lineups
Now you’re ready to get down to business.
By using the dropdown menus in Column C, you can select a player to plug into each roster slot. Once you’ve filled out a full lineup, then Column H will offer one of the three diagnoses:
- You have “insufficient players”
- You have “duplicate teams used”
- Your lineup is “Good!” (in the sense you met the roster requirement and avoided duplicate teams)
And, finally, the last column of that tab updates to let you know which teams remain unused:
Note: There are footnotes with instructions on the final two tabs.