Team Selection Problem Solving with Data...Please help

sur · Jun 5, 2018

Hello Team,

Here is the Problem Statement, please help to resolve this:

Problem Statement: We need to select the best team for EACH STATE Given a set of player information, some selection criteria and the required number of players at each position as input,automatically mark whether a player is selected or not for his state team The worksheet should automatically handle the following changes: - Changes in team composition (Number of Batsman, Number of Bowlers and Number of All Rounders) - Addition of more states in the dataset - Changes in the data set (Batting Averages / Wickets and Wicketkeeper flag)
Selection Criteria: - There has to be one wicketkeeper-batsman in the team. In case there are multiple candidate wicketkeepers in the state, the one with highest batting average is selected. - Select the remaining number of required batsmen in a decreasing order of their batting averages. - Select the required number of bowlers in the decreasing order of wickets/match. - Select the allrounders based on the formula (Batting average + 5*wickets/match). The higher this value, the better the allrounder and needs to be chosen

IMP:

1) To get the selected players, you should write VBA macros which populate the value of isSelected
	- If needed, you can add columns to the right of isSelected which would help you in the processing
2) The submitted solution should be generic so that it should work on changing the Player Info and the required team composition

Per Team Composition:

Batsman 4
Bowler 3
All Rounder 4
Player Statistics: