chinaman

February 23, 2004, 03:35 PM

Much has been said about NRR and how to calculate it. However the NRR itself can not answer some very important questions. Chinaman's Dynamic Formula is here to answer them accurately.

I must admit, I was confused anwsering these questions even few days ago. This formula is the result of that failure.

The formula does look teeth breaking. But in the form of an html form, it should be a breeze. I have it in Excel format (see attachment) but don't know how to make it in html. Anyone can give me a hand for a trial web page to see how it works. If everything turns out ok, we may put it up some where in our site for the fans and coaches alike to get answers on the fly.

Chinaman's Dynamic Formula addresses following three issues:

1. If the Team Bat First, the minimum runs required to score to achieve a Target NRR.

2. If the Team Bat Last, the minimum Run Rate required to topple the oponent's score and achieve a Target NRR.

3. If the Team Bat Last, the maximum numbers of Overs required to topple the oponent's score and achieve a Target NRR.

With the formula, we can see that,

if we batted FIRST against India, we had to:

Score atleast 239 runs to achieve 1.18 NRR or

Score atleast 238 runs to achieve 1.179 NRR (which was just above NZ's NRR)

if we batted LAST against India, we had to:

Just win the game if they scored anything above 238.

Win the game at a run rate of atleast 4.77 if they scored anything below 238 or

Win the game within a maximum of 42 overs if they scored just 200 (Could be calculated for any score)

Feel free to play with the formula in excel. Feedback? Error? Feel free to post.

PS, Please don't laugh at the name, will change it later. But it was meant to give some laugh though!

[Edited on 2-24-2004 by chinaman : TR to TRun]

[Edited on 2-25-2004 by chinaman : Formula and link removed]

I must admit, I was confused anwsering these questions even few days ago. This formula is the result of that failure.

The formula does look teeth breaking. But in the form of an html form, it should be a breeze. I have it in Excel format (see attachment) but don't know how to make it in html. Anyone can give me a hand for a trial web page to see how it works. If everything turns out ok, we may put it up some where in our site for the fans and coaches alike to get answers on the fly.

Chinaman's Dynamic Formula addresses following three issues:

1. If the Team Bat First, the minimum runs required to score to achieve a Target NRR.

2. If the Team Bat Last, the minimum Run Rate required to topple the oponent's score and achieve a Target NRR.

3. If the Team Bat Last, the maximum numbers of Overs required to topple the oponent's score and achieve a Target NRR.

With the formula, we can see that,

if we batted FIRST against India, we had to:

Score atleast 239 runs to achieve 1.18 NRR or

Score atleast 238 runs to achieve 1.179 NRR (which was just above NZ's NRR)

if we batted LAST against India, we had to:

Just win the game if they scored anything above 238.

Win the game at a run rate of atleast 4.77 if they scored anything below 238 or

Win the game within a maximum of 42 overs if they scored just 200 (Could be calculated for any score)

Feel free to play with the formula in excel. Feedback? Error? Feel free to post.

PS, Please don't laugh at the name, will change it later. But it was meant to give some laugh though!

[Edited on 2-24-2004 by chinaman : TR to TRun]

[Edited on 2-25-2004 by chinaman : Formula and link removed]