FFPC Playoff Challenge Roster Builder: Simulate Lineups Based On Expected Games Played, Average Scoring, More

FFPC Playoff Challenge Roster Builder: Simulate Lineups Based On Expected Games Played, Average Scoring, More article feature image

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:

  1. You have "insufficient players"
  2. You have "duplicate teams used"
  3. 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.

How would you rate this article?

This site contains commercial content. We may be compensated for the links provided on this page. The content on this page is for informational purposes only. Action Network makes no representation or warranty as to the accuracy of the information given or the outcome of any game or event.