Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
A solution to last week’s challenge can be found here.
This challenge is the final selection for the Weekly Challenge User Group October Takeover event, and it was contributed by Talia Sanders (@tsand22), a member of the Indianapolis User Group. We extend our gratitude to Talia for your valuable contribution, and we are excited for everyone to dive into this challenge!
In this challenge, you are the manager of a Fantasy Football team, tasked with making draft picks before your league starts. Your dataset includes details on the first-round draft order, the total number of teams in the league, and players' overall rankings; however, the draft extends beyond a single round.
For this challenge, you must complete three tasks:
1. Build a workflow that snakes the draft order so that Round 1 starts with Team 1 and ends with Team 6, then Round 2 starts with Team 6 and ends with Team 1. This alternating pattern continues for five more rounds, unfolding as follows:
2. Identify the top 6 players for each listed position. These positions include kicker, running back, quarterback, tight end, and wide receiver.
3. Determine the draft order for each round and players selected, including team and position.
Note: Assume that every team manager in the league has agreed to select players for the same position in each round. For example, everyone will pick a kicker in Round 1. By the end of Round 5, each team should have one player for each position. Also assume that the draft picks will go in order of the players’ rankings.
Source: https://www.fantasypros.com/nfl/rankings/consensus-cheatsheets.php
Challenge Update on October 25th: The authorship for this challenge has been corrected today, and it is now accurately credited to the rightful author. We sincerely apologize for any prior confusion.
Fun challenge, and I'm excited to see how others provide a more efficient way of solving this!
Went for some Generate Rows fun for this one just to see if it worked