Last week's solution can be found here!
This week's challenge we are going to create a Weekly Challenge dream team... on a budget! Provided is a list of participants and the number of Challenges they have completed. But here's the rub, each person on your team is going to cost you some money and each ranking position has a 'salary' or 'value' associated with it. You first task is going to prep the data to attach a value to each person's rank. After assigning values, it's time to recruit your team of people. You goal when recruiting your team is to have a team of people that have completed the most weekly challenges. There are t20 simple rules when building your team: 1) You can only spend $1,500,000, 2) Your team must have 8 people. When you find your team, share your solution, tell us how many challenges your team completed and sound off who made it!
Since there are a lot of answers and only a few 'best answers', we wont be divulging our solution until next week. Good luck!
Note: The rank we used was a dense rank. So if my first two challengers tied, they both would be given a rank of one and the next (third) person would be given a rank of two. Some other methods would have given the third person the rank of three, but for the sake of the challenge we kept it 'dense'.
I've got my team picked out!
... Are substitutions\trades\re-drafts allowed?
If anyone would like to hire me at this value, I'd love to join your dream team.
But, looks like I'm in good company as a coach, with @NicoleJohnson, @PhilipMannering, @ggruccio, @patrick_digan, @JosephSerpis, @LordNeilLord, and @Natasha