Zimbabwe v Bangladesh (5 ODI)

[Abhas]

Thanks a lot Rabs
It's made in Excel.. I copied the rankings from this match and the last.. did some sorting, subtraction, re-sorting, beautification, and Done

I remember doing something like this for the 1st IPL, where I compared the rankings from the 1st game, till the 50th game or something..
The original idea belongs to Sohum though, I saw it in some thread of his..

Abhas added 11 Minutes and 53 Seconds later...

As suggested by Rabs, I've added the column showing the change in Rankings since the 1st game. Interesting to see Syl gain 14 places!

This is the link to the original post where I used this idea.. http://www.planetcricket.org/forums/1096133-post669.html

 

[SciD]

2 minute job in Excel

Well done Abby.

 

[Abhas]

Teach me how to use Vlookup.

 

[Akash00]

I still don't know why I am so bad at picking my bonus players.

 

[D0N]

McLOVIN i chosed Taibu as 5th Batsman my wicketkeeper is rahim change taibu

 

[WestIndian]

2 minute job in Excel

Well done Abby.

Teach me how to use Vlookup.

I too would like to learn Sid.

Abhas, it looks even better, would be interesting to see how this play on other such Series, I love the improvement, gives a pretty good view of players movements Up and Down.

 

[SciD]

VLookup is left hand job. We should meet in virtual world to discuss this.

 

[Abhas]

I always believed this was a virtual world

 

[SciD]

I always believed this was a virtual world

I mean classroom.

 

[Abhas]

Ok, You choose a place

Abhas added 2 Minutes and 13 Seconds later...

I too would like to learn Sid.

Abhas, it looks even better, would be interesting to see how this play on other such Series, I love the improvement, gives a pretty good view of players movements Up and Down.

We can probably do this for all ODI series, showing a movement chart, if I can work out a simpler method than what I am using right now.
What I'm doing is very much manual, and a bit complicated.. would be better if I can understand vlookup.

 

[McLOVIN]

McLOVIN i chosed Taibu as 5th Batsman my wicketkeeper is rahim change taibu

LOl sorry about that, i was in hurry..miss read

done

MacLovin added 1 Minutes and 26 Seconds later...

LOL nice work AB :laugh

 

[D0N]

LOl sorry about that, i was in hurry..miss read

done

MacLovin added 1 Minutes and 26 Seconds later...

LOL nice work AB :laugh

Thanks mate score please

 

[Abhas]

LOl sorry about that, i was in hurry..miss read

done

MacLovin added 1 Minutes and 26 Seconds later...

LOL nice work AB :laugh

You forced me to do it

 

[Abhas]

Ok, I got the Ranking change thing working properly.. We just need to copy the 1st match data in one sheet, and the rest of the matches can be overwritten on another sheet to generate new stats.

Still trying to figure out a way to implement the points change per match.
Thanks Syl for the file.. It helped a bit, I looked up excel help as well, which is quite good!

 

[McLOVIN]

Taylor finally did something for me, after all that 3 ducks!

Riyad too, but Naeem kinda over did his work!