Last Man Standing for European Football League is an excel spreadsheet to accommodate prediction game for your soccer league competition. The aim of this game is to find a lone survivor at the end of respective sport competition. A lone survivor is a player who predict the outcome of each matches correctly, and this game is like a race game where any incorrect prediction will eliminate the players for competing.
It should be easy in the beginning, but it could be tougher toward the end of the competition since players can’t pick similar team within one game competition. For example, if you want to implement this for England Premier League game, it will be easy to predict Manchester City or Arsenal will win their first matches. But, after that, you can’t pick them again. You must select underdog teams wisely when they will win their matches before you won’t have any choices except to pick them.
To use this spreadsheet, you must learn basic regulations as follows :
> One competition is defined as a half competition where all teams will meet each other once. You can customize it by specifying the number of round and matches.
> Players must pick match winner in each round in the whole competition
> Players are not allowed to pick similar team in any rounds
> If team’s match is postponed, respective players will advance to the next round automatically
> If result of team’s match is draw, respective players will be eliminated
> This game rolls on until all players eliminated except one regardless the competition is not completed yet. And this remaining player will be the Lone Survivor or the Winner of the game.
To start using this spreadsheet, you can follow instructions as follows :
> Go to Setup worksheet
> Type team names (it is already set to 20 teams)
SETUP PLAYER and PICK TEAMS
> Go to Player Pick Board worksheet
> Type player name (10 players in Free version and there are up to 100 players in paid version)
> Start selecting your player’s picks
> Players can pick their teams in every rounds using a dropdown list
> Do not copy and paste between rows. It will break the dropdown list formula for respective players
PUT ACTUAL RESULTS
> Go to Fixtures worksheet
> Type actual results in fixtures box score fields. Winning teams will be revealed automatically.
> Set wild card by selecting Postponed or Pass in Status column. It will allow all players to skip particular match.
TRACK PLAYER’S PREDICTION
> Go to Player Leaderboard worksheet
> See your player standing race in this worksheet. Correct predictions will have green colors. Eliminated players will have light grey color with incorrect team prediction in its cell at the end of their pick rows.
Each competition will be divided into 2 game period where players can reset their prediction after the first period. And there are additional player leaderboard to combine predictions from those period. You can set it based on number of correct prediction of the average of player’s ranks.
You can download the Last Man Standing spreadsheet below. The free version can accommodate until 10 players and 38 rounds. One spreadsheet is already filled with dummy data to help you understanding this spreadsheet properly. More detail information can be found in its author site.
Last Man Standing Game - Premier League 2021/2022 (4.1 MiB, 1,426 hits)
Last Man Standing Game - Serie A 2021/2022 (4.1 MiB, 287 hits)
Last Man Standing Game - La Liga 2021/2022 (4.1 MiB, 287 hits)
Last Man Standing Game - Ligue 1 2021/2022 (4.1 MiB, 278 hits)