My One-Day International Cricket Ratings to the end of 2007

[Days of Grace]

But one point you made is very much valid...Standardising results for different eras is very much needed for ODI ranking, be it batting or bowling...

I have an argument against this. Please hear me out

It is logical to standardise results for test cricket according to eras, as pitch conditions changed an awful lot, esp. between 1875-1930.

But, in the history of ODI cricket, it is not so much the pitch conditions, as the players' attitudes that have changed. Thus, batsman playing today are arguably better players then those playing in the 1970s as they understand the game more. I don't think pitch conditions since 1975 have changed that much, certainly not compared to the changes that took place between 1875-1930.

 

[Days of Grace]

Can you please explain to me how you get a formula in which a lower strike-rate/economy rate converts to greater points/value. How do you get Microsoft Excel to do that?

And, also, can you please give me details as to how to copy a list of players' stats from cricinfo and somehow paste it into Microsoft excel without having to spend hours adjusting the columns afterwards?

Cheers.

Can anyone help me at all??

 

[sanga1337]

Michael Bevan at 9? He should be in the top 3 at least IMO.

 

[weldone]

But, in the history of ODI cricket, it is not so much the pitch conditions, as the players' attitudes that have changed. Thus, batsman playing today are arguably better players then those playing in the 1970s as they understand the game more. I don't think pitch conditions since 1975 have changed that much, certainly not compared to the changes that took place between 1875-1930.

Please understand while playing in the 70s or 80s, batsmen were chasing scores like 200, now they're chasing 300...You play differently when you chase 200 than when you chase 300...

Also, when they batted first, Richards (for instance) knew that 250 will be a winning score, so he played accordingly (which is common-sensical)...But now batsmen know that even 300 is not a winning score...So, their s.r. is bound to increase...Who knows maybe some batsmen of that time were able to score quicker but they did play cautiously because they knew a 250 is a winning score...

 

[weldone]

Can anyone help me at all??

Say you want points to increase with decreasing bowling average...Then you may allocate your points like (=a constant/bowling average)...Here, as bowling average decreases, more points you score...

 

[Days of Grace]

Please understand while playing in the 70s or 80s, batsmen were chasing scores like 200, now they're chasing 300...You play differently when you chase 200 than when you chase 300...

Also, when they batted first, Richards (for instance) knew that 250 will be a winning score, so he played accordingly (which is common-sensical)...But now batsmen know that even 300 is not a winning score...So, their s.r. is bound to increase...Who knows maybe some batsmen of that time were able to score quicker but they did play cautiously because they knew a 250 is a winning score...

You make a very valid point. But I will just say that their increased s/r over the years was due to the human factor. Natural progression and evolution.

Whearas the changes in test cricket were the non-human factors, i.e. pitch conditions.

 

[Migara]

Can you please explain to me how you get a formula in which a lower strike-rate/economy rate converts to greater points/value. How do you get Microsoft Excel to do that?

And, also, can you please give me details as to how to copy a list of players' stats from cricinfo and somehow paste it into Microsoft excel without having to spend hours adjusting the columns afterwards?

Cheers.

#1 - I just put your points in a table. Then plotted a scatter graph using that. Then, when looking at the shape of the graph, I once realized that that the numbers change exponentially. So I used Add trend line option, with displaying it's equation. Bingo!

#2 - Just copy and paste the cricinfo sheet on to the Notepad. Then save it as a text file. Then using Insert Data -> from text file import the file.

I'll explain with scree caps bit later.

 

[Migara]

Step 1 - copy and paste data from statsguru to a text file. It should look like this

 

[Migara]

Step 2 - I am using Excel 2007. But you'll find same things in 2003 version as well.

Select Data tab. Select from text icon.

 

[Migara]

Step 3 - Excel will ask what is the text file to be imported. Select the above saved file. You'll be then presented with a wizard. Select Delimited option. Don't make any other changes in the Wizard. Click Next.

Step 4 - Enable the check box Tab in Delimiters grpup. Click Next.

 

[Migara]

Step 5 - Now you can see each colum in the Wizard Window. Keep the format of data as General for the numbers, and as Text for the Best bowling figures.

Click Finish.

 

[Migara]

Step 6 - The following dialog box appears. Place the cursor on the pace where you want the table to begin and click OK

There's your Excel table!!

 

[Migara]

How to create formulars

#1 - Prepare your table in Excel

#2 - Select data and using Insert -> Graph -> Scatter create a scatter graph.

Right click on the markers and a pop up menu appears. Select Add trendline

 

[Migara]

#3 - Under trendline options, select the type of trendline you want to create. In this example, it looks like an Exponential line will fit the scatter. Then enable the option Display the equation on chart

You'll end up with a graph like this. Then you can clearly see the equation of the trendline.

So there you are!

 

[GIMH]

Hey I am not one for these stat debates but that is a great step-by-step. Very useful for me in my work actually that sort of thing, always looking to learn new things on Excel

 

[Days of Grace]

Migara, that is a great step-by-step. Thanks a lot.

I copied and pasted from statsguru the other day and all of a sudden it converts straight to the columns without my having to do anything.

I am working on a new ratings system now that I can now copy every single player's stats straight from statsguru.

It will be similiar to the old system but I will incorporate new things such as peak average after 20 matches or more and away averages.

I wish that statsguru would have a function where you could look up away averages for every single player in one click instead of going to each player's page individually. Am I missing something here?

 

[Days of Grace]

#3 - Under trendline options, select the type of trendline you want to create. In this example, it looks like an Exponential line will fit the scatter. Then enable the option Display the equation on chart

You'll end up with a graph like this. Then you can clearly see the equation of the trendline.

So there you are!

I am now wondering how you get to convert an individual player's strike-rate into points using that formula?

For example, I enter the player's strike-rate into one column and in the next column I want to convert it into points using the formula. I tried =y=..... but it didn't work.

 

[Migara]

I am now wondering how you get to convert an individual player's strike-rate into points using that formula?

For example, I enter the player's strike-rate into one column and in the next column I want to convert it into points using the formula. I tried =y=..... but it didn't work.

The graph shown is that of economay rate. Sorry, I've posted the wrong one.

Here Y - points, X - Economay rate e - natural logarithm

The excel formula would be =6456.8 * (EXP(D3 * -0.08567)) - Here D3 is the address of the cell that contain the Economy rate.

I think it will work out.

 

[Migara]

I wish that statsguru would have a function where you could look up away averages for every single player in one click instead of going to each player's page individually. Am I missing something here?

Is this what you are after?

 

[Days of Grace]

Is this what you are after?

Ah yes. Cheers for both of those posts.

Am quite excited about these latest developments, tbh. I can work much faster now. I should be able to turn out a new ratings top 100 for tests by the end of the week.