Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video, I explain an Excel challenge to give players equal playing time in a basketball game. Here is the post with the rules: https://www.excelcampus.com/tips/equal-playing-time-challenge/
Here is the challenge:
How do we give 12 players equal playing time in a game with 9 periods if only 5 players can play during a period?
There are no substitutions within a period. Substitutions happen between each of the 9 periods.
And a bonus:
Can the playing time be made equal throughout the 6 games in the season, if it can't be made equal within one game?
You can leave a comment below with any questions. You can also leave a comment that explains your solution, and post a share link to your file that is stored on a cloud service like Dropbox, OneDrive, Google Drive, etc. Just make sure the file is public so we can see it.
Or, you can upload your file at the following link. That page also explains all the rules of the challenge.
https://www.excelcampus.com/tips/equal-playing-time-challenge/
I will do a follow-up video that walks through some popular and interesting solutions.
Have fun and good luck!
00:00 Introduction
00:15 The Challenge
00:49 Mission
01:09 Prize