Best Player

[qureshi82]

Hi Team,

Below is the table

Name	Position	Batting Average	Batting Strike rate	Bowling Average	Bowling Strike rate		Output
Sourav	Allrounder	40.73	73.71	38.49	45.61			Batsman
Yuvraj	Allrounder	36.56	87.68	38.68	45.48			Bowler
Irfan	Allrounder	23.39	79.55	29.73	33.84			Allrounder
Laxman	Batsman	30.76	71.24	0	0
Rahul	Batsman	39.17	71.24	42.5	46.5
Virender	Batsman	35.06	104.34	40.14	45.75
Sachin	Batsman	44.83	86.24	44.48	52.3
Zaheer	Bowler	12	73.47	29.44	35.8
Anil	Bowler	10.54	61.07	30.9	43.01
Harbhajan	Bowler	13.3	81.06	33.36	46.39

<colgroup><col style="mso-width-source:userset;mso-width-alt:3693; width:76pt" width="101" span="3"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:4498;width:92pt" width="123"> <col style="width:76pt" width="101" span="3"> </colgroup><tbody>
</tbody>

-----------------------------------------------------------------------------------------------------------------

Problem Statement
	You are given a list of cricket players. Each player has the following information available (Please refer Player_Statistics sheet):
		Name
		Position (Batsman/Bowler/Allrounder)
		Batting average
		Batting Strike Rate
		Bowling Average
		Bowling Strike Rate
	You are required to find the top 'n' players for each position based on the following criteria:
		Batsman: (batting average)*(batting strike rate)
		Bowler: 10000/(bowling average*bowling strike rate)
		Allrounder: (batting average*batting strike rate)*10000/(bowling average*bowling strike rate)
	The value of 'n' can be different for each position and is defined in the Team_Composition sheet
	The worksheet should automatically handle the following changes:
		- Changes in team composition (Number of Batsman, Number of Bowlers and Number of Allrounders)
		- Changes in the data set (Number of input players, batting/bowling averages/strike rates, etc.)

<colgroup><col style="width:76pt" width="101" span="8"> </colgroup><tbody>
</tbody>

--------------------------------------------------------------------------------------------------

Output Required:
	In the Player_Statistics sheet, column I is the output column for different positions. You are expected to populate the required number of players for each position in subsequent columns.
	Please refer to the Example_Player_Statistics sheet for a sample output

<colgroup><col span="8"></colgroup><tbody>
</tbody>

---------------------------------------------------------------------------------------

Can anybody help me with out put?

Regards,
Aiyuh

 

[oldbrewer]

Name	Position	Batting Average	Batting Strike rate	Bowling Average	Bowling Strike rate				rating	ranked	name
Sourav	Allrounder	40.73	73.71	38.49	45.61			1	17101.45	18494.61	Irfan
Yuvraj	Allrounder	36.56	87.68	38.68	45.48			2	18222.16	18222.16	Yuvraj
Irfan	Allrounder	23.39	79.55	29.73	33.84			3	18494.61	17101.45	Sourav
Laxman	Batsman	30.76	71.24	0	0			4	2191.342	3866.139	Sachin
Rahul	Batsman	39.17	71.24	42.5	46.5			5	2790.471	3658.16	Virender
Virender	Batsman	35.06	104.34	40.14	45.75			6	3658.16	2790.471	Rahul
Sachin	Batsman	44.83	86.24	44.48	52.3			7	3866.139	2191.342	Laxman
Zaheer	Bowler	12	73.47	29.44	35.8			8	9.488098	9.488098	Zaheer
Anil	Bowler	10.54	61.07	30.9	43.01			9	7.524404	7.524404	Anil
Harbhajan	Bowler	13.3	81.06	33.36	46.39			10	6.461742	6.461742	Harbhajan
		is it more complicated than this ?

<colgroup><col><col><col><col><col><col><col span="7"></colgroup><tbody>
</tbody>

 

[qureshi82]

Name	Position	Batting Average	Batting Strike rate	Bowling Average	Bowling Strike rate				rating	ranked	name
Sourav	Allrounder	40.73	73.71	38.49	45.61			1	17101.45	18494.61	Irfan
Yuvraj	Allrounder	36.56	87.68	38.68	45.48			2	18222.16	18222.16	Yuvraj
Irfan	Allrounder	23.39	79.55	29.73	33.84			3	18494.61	17101.45	Sourav
Laxman	Batsman	30.76	71.24	0	0			4	2191.342	3866.139	Sachin
Rahul	Batsman	39.17	71.24	42.5	46.5			5	2790.471	3658.16	Virender
Virender	Batsman	35.06	104.34	40.14	45.75			6	3658.16	2790.471	Rahul
Sachin	Batsman	44.83	86.24	44.48	52.3			7	3866.139	2191.342	Laxman
Zaheer	Bowler	12	73.47	29.44	35.8			8	9.488098	9.488098	Zaheer
Anil	Bowler	10.54	61.07	30.9	43.01			9	7.524404	7.524404	Anil
Harbhajan	Bowler	13.3	81.06	33.36	46.39			10	6.461742	6.461742	Harbhajan
		is it more complicated than this ?

<tbody>
</tbody>

Where is the vba coding for it?