MisterMints
New Member
- Joined
- Jun 29, 2015
- Messages
- 7
I'm trying to organise an event which is timed. I have asked participants to submit their expected finishing times as part of the application process, and I'm trying to group them into teams accordingly using Excel if possible.
Format looks like this, and continues for 70 rows:
I want to group these 70 people into 7 teams of 10, or 10 teams of 7, where each person can only be in a single team, and the entire duration of all predicted times cannot exceed 3:00:00. If it isn't possible to group them into 7x10 or 10x7, then the total predicted time of 3hrs is the more important figure. Happy to give a 10 minute tolerance either way (2:50 - 3:10) on the time. The allocation should also be fairly random, so each team has a selection of fastest, middling, and slowest predicted times in it.
Is this possible?
I struggle to get my head round many of the basic formulae functions in Excel, so as simply as possible please!
Thanks
Format looks like this, and continues for 70 rows:
Name | Predicted Time |
John Smith | 24:22 |
Jane Smith | 32:45 |
Fred Jones | 27:50 |
Emma Jones | 21:30 |
I want to group these 70 people into 7 teams of 10, or 10 teams of 7, where each person can only be in a single team, and the entire duration of all predicted times cannot exceed 3:00:00. If it isn't possible to group them into 7x10 or 10x7, then the total predicted time of 3hrs is the more important figure. Happy to give a 10 minute tolerance either way (2:50 - 3:10) on the time. The allocation should also be fairly random, so each team has a selection of fastest, middling, and slowest predicted times in it.
Is this possible?
I struggle to get my head round many of the basic formulae functions in Excel, so as simply as possible please!
Thanks