Best Player

[qureshi82]

Hi Team,

Below is the table

<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>
[TD="class: xl63, width: 101"]Name[/TD]
[TD="class: xl63, width: 101"]Position[/TD]
[TD="class: xl64, width: 101"]Batting Average[/TD]
[TD="class: xl64, width: 137"]Batting Strike rate[/TD]
[TD="class: xl64, width: 101"]Bowling Average[/TD]
[TD="class: xl64, width: 224, colspan: 2"]Bowling Strike rate[/TD]
[TD="class: xl64, width: 101"][/TD]
[TD="class: xl64, width: 101"]Output[/TD]

[TD="class: xl65"]Sourav[/TD]
[TD="class: xl65"]Allrounder[/TD]
[TD="class: xl66, align: right"]40.73[/TD]
[TD="class: xl66, align: right"]73.71[/TD]
[TD="class: xl66, align: right"]38.49[/TD]
[TD="class: xl66, align: right"]45.61[/TD]

[TD="class: xl64"]Batsman[/TD]

[TD="class: xl65"]Yuvraj[/TD]
[TD="class: xl65"]Allrounder
[/TD]
[TD="class: xl66, align: right"]36.56
[/TD]
[TD="class: xl66, align: right"]87.68[/TD]
[TD="class: xl66, align: right"]38.68[/TD]
[TD="class: xl66, align: right"]45.48[/TD]

[TD="class: xl64"]Bowler[/TD]

[TD="class: xl65"]Irfan[/TD]
[TD="class: xl65"]Allrounder
[/TD]
[TD="class: xl66, align: right"]23.39
[/TD]
[TD="class: xl66, align: right"]79.55[/TD]
[TD="class: xl66, align: right"]29.73[/TD]
[TD="class: xl66, align: right"]33.84[/TD]

[TD="class: xl64"]Allrounder[/TD]

[TD="class: xl65"]Laxman[/TD]
[TD="class: xl65"]Batsman[/TD]
[TD="class: xl66, align: right"]30.76
[/TD]
[TD="class: xl66, align: right"]71.24[/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl65"]Rahul[/TD]
[TD="class: xl65"]Batsman[/TD]
[TD="class: xl66, align: right"]39.17[/TD]
[TD="class: xl66, align: right"]71.24[/TD]
[TD="class: xl66, align: right"]42.5[/TD]
[TD="class: xl66, align: right"]46.5[/TD]

[TD="class: xl65"]Virender[/TD]
[TD="class: xl65"]Batsman[/TD]
[TD="class: xl66, align: right"]35.06[/TD]
[TD="class: xl66, align: right"]104.34[/TD]
[TD="class: xl66, align: right"]40.14[/TD]
[TD="class: xl66, align: right"]45.75[/TD]

[TD="class: xl65"]Sachin[/TD]
[TD="class: xl65"]Batsman[/TD]
[TD="class: xl66, align: right"]44.83[/TD]
[TD="class: xl66, align: right"]86.24[/TD]
[TD="class: xl66, align: right"]44.48[/TD]
[TD="class: xl66, align: right"]52.3[/TD]

[TD="class: xl65"]Zaheer[/TD]
[TD="class: xl65"]Bowler
[/TD]
[TD="class: xl66, align: right"]12[/TD]
[TD="class: xl66, align: right"]73.47[/TD]
[TD="class: xl66, align: right"]29.44[/TD]
[TD="class: xl66, align: right"]35.8[/TD]

[TD="class: xl65"]Anil[/TD]
[TD="class: xl65"]Bowler
[/TD]
[TD="class: xl66, align: right"]10.54[/TD]
[TD="class: xl66, align: right"]61.07[/TD]
[TD="class: xl66, align: right"]30.9[/TD]
[TD="class: xl66, align: right"]43.01[/TD]

[TD="class: xl65"]Harbhajan[/TD]
[TD="class: xl65"]Bowler[/TD]
[TD="class: xl66, align: right"]13.3[/TD]
[TD="class: xl66, align: right"]81.06[/TD]
[TD="class: xl66, align: right"]33.36[/TD]
[TD="class: xl66, align: right"]46.39[/TD]

</tbody>

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

<colgroup><col style="width:76pt" width="101" span="8"> </colgroup><tbody>
[TD="class: xl65, width: 202, colspan: 2"]Problem Statement
[/TD]
[TD="class: xl66, width: 101"] [/TD]
[TD="class: xl66, width: 101"] [/TD]
[TD="class: xl66, width: 101"] [/TD]
[TD="class: xl66, width: 101"] [/TD]
[TD="class: xl66, width: 101"] [/TD]
[TD="class: xl66, width: 101"] [/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67, colspan: 7"]You are given a list of cricket players. Each player has the following information available (Please refer Player_Statistics sheet): [/TD]

[TD="class: xl67"][/TD]

[TD="class: xl67"]Name[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67, colspan: 3"]Position (Batsman/Bowler/Allrounder)[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"]Batting average[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67, colspan: 2"]Batting Strike Rate[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"]Bowling Average[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67, colspan: 2"]Bowling Strike Rate[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67, colspan: 6"]You are required to find the top 'n' players for each position based on the following criteria:[/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67, colspan: 3"]Batsman: (batting average)*(batting strike rate)[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67, colspan: 3"]Bowler: 10000/(bowling average*bowling strike rate)[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67, colspan: 6"]Allrounder: (batting average*batting strike rate)*10000/(bowling average*bowling strike rate)[/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl68, colspan: 7"]The value of 'n' can be different for each position and is defined in the Team_Composition sheet[/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl68, colspan: 5"]The worksheet should automatically handle the following changes:[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67, colspan: 6"]- Changes in team composition (Number of Batsman, Number of Bowlers and Number of Allrounders)[/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67, colspan: 6"]- Changes in the data set (Number of input players, batting/bowling averages/strike rates, etc.)[/TD]

</tbody>

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

[TABLE="width: 808"]
<colgroup><col span="8"></colgroup><tbody>[TR]
[TD]Output Required:[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 7"]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.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 5"]Please refer to the Example_Player_Statistics sheet for a sample output[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
---------------------------------------------------------------------------------------

Can anybody help me with out put?

Regards,
Aiyuh

 

[oldbrewer]

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

 

[qureshi82]

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

Where is the vba coding for it?