facebook Twitter RSS Feed YouTube StumbleUpon

Home | Forum | Chat | Tours | Articles | Pictures | News | Tools | History | Tourism | Search

 
 


Go Back   BanglaCricket Forum > Cricket > Cricket

Cricket Join fellow Tigers fans to discuss all things Cricket

Reply
 
Thread Tools Display Modes
  #1  
Old February 23, 2004, 03:35 PM
chinaman chinaman is offline
Retired BC Admin
 
Join Date: August 14, 2003
Location: pc near u
Posts: 8,021
Default Chinaman\'s Dynamic Formula

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]
Reply With Quote

  #2  
Old February 23, 2004, 04:26 PM
billah billah is offline
Banned
 
Join Date: September 5, 2003
Posts: 5,364

Very concise, Chinaman bhai. Let's not forget to send a copy to the U-19 coach. For future use, you know.
Reply With Quote
  #3  
Old February 23, 2004, 05:08 PM
Navarene's Avatar
Navarene Navarene is offline
Cricket Legend
 
Join Date: December 25, 2003
Location: Polatok
Favorite Player: Sangakkara
Posts: 2,235

Quote:
Very concise
Not sure if it is in very concised or in a deliberated form, but one thing is for sure that we cricket fans in this forum are now concerned about the importance of Net Run Rate issue. Given the thought that more and more ODI tournaments are being played nowadays and the NRR will be computed if the points of two or more teams are the same. That's why it is important for the think-tank or the coach of a team to have the clear perception about NRR.

After all, we all know why Shaun Maclean Pollock of South Africa was sacked from captaincy for not electing to bat first in a last world cup match.
Reply With Quote
  #4  
Old February 23, 2004, 05:28 PM
reverse_swing's Avatar
reverse_swing reverse_swing is offline
Chief Moderator
 
Join Date: August 22, 2003
Favorite Player: Shakib Al Hasan
Posts: 5,942

[quote]Originally posted by Navarene
Quote:


After all, we all know why Shaun Maclean Pollock of South Africa was sacked from captaincy for not electing to bat first in a last world cup match.
Pollock was not sacked because of this. This is totally baseless. They played their last match against Srilanka.And in that match Srilanka won the toss. Pollock did not have a clear idea about D/L method as that match was rain affected.

Scorecard of that match

[Edited on 23-2-2004 by rezwan1977]
Reply With Quote
  #5  
Old February 23, 2004, 06:21 PM
Navarene's Avatar
Navarene Navarene is offline
Cricket Legend
 
Join Date: December 25, 2003
Location: Polatok
Favorite Player: Sangakkara
Posts: 2,235

Thank you Rezwan for pointing out my mistake. Yes, you are right, Pollock was not sacked for miscomputing anything about NRR, but for "miscalculated the target needed in the rain-hit tie against Sri Lanka"
source

Anyway, hope you see the essence of my post still doesn't defer much from whether Pollock miscomputed the target according to D/L method or NRR method.
Reply With Quote
  #6  
Old February 23, 2004, 06:32 PM
rafiq rafiq is offline
Cricket Legend
 
Join Date: September 22, 2002
Location: Chicago
Posts: 3,394

Chinaman I don't have time to test this formula right now but I trust Adnan will give it a thorough run through and I, apparently along with Coach McInnes and his wife, trust Adnan's math. In any case, conceptually it sounds easy enough to follow and all jokes aside, you have done a great service to cricket. This spreadsheet or applet needs to be put on all coach's PDAs or the very least send it to the laptop-carrying statistician who goes around with the national team these days. cheers
Reply With Quote
  #7  
Old February 24, 2004, 11:50 PM
chinaman chinaman is offline
Retired BC Admin
 
Join Date: August 14, 2003
Location: pc near u
Posts: 8,021
Default TRROC

Thank you for all the encouragements.

Dr. Z was very kind to convert this formula into an online calculator. He has been intrumental in the development of the project. I owe him big time.

Now that the calculator is born, we named it "Target Run, Rate and Over Calculator" or simply TRROC. We hope TRROC will help us prepare decisivly for future challenges should the need arise.

Please feel free to report suggestions, bugs and errors.

Link to TRROC
Reply With Quote
  #8  
Old February 25, 2004, 12:18 AM
AsifTheManRahman's Avatar
AsifTheManRahman AsifTheManRahman is offline
Super Moderator
BC Editorial Team
 
Join Date: February 12, 2004
Location: Canada
Favorite Player: Ice Man, Chatter Box
Posts: 27,678

I'm surprised that Adnan bhai hasn't yet made any posts to this string...
Reply With Quote
  #9  
Old February 25, 2004, 01:37 AM
rafiq rafiq is offline
Cricket Legend
 
Join Date: September 22, 2002
Location: Chicago
Posts: 3,394

Zunaid, Chinaman: my 10 second review is that there is a disconnect between the 3 things the calculator is supposed to calculate and the online form. Maybe the user can choose which of the three things they want to calculate, and then fill out the appropriate data. Right now you can input data for each line and come up with something meaningless or an error.
Reply With Quote
  #10  
Old February 25, 2004, 01:41 AM
chinaman chinaman is offline
Retired BC Admin
 
Join Date: August 14, 2003
Location: pc near u
Posts: 8,021

Please explain. Has been working fine with me.

Try playing with BD-India data:

Target Net Run Rate: 1.18 or whatever you like
Total Overs For: 62.2
Total Overs Against: 99.2
Total Runs For: 298
Total Runs Against: 299
Reply With Quote
  #11  
Old February 25, 2004, 01:44 AM
rafiq rafiq is offline
Cricket Legend
 
Join Date: September 22, 2002
Location: Chicago
Posts: 3,394

I'm sure the calc works fine with the right data as in above example. But it's not clear what data the user has to supply and what will be calculated - separate the user input from the results. Z might know what I am talking about.
Reply With Quote
  #12  
Old February 25, 2004, 01:47 AM
Zunaid Zunaid is offline
Administrator
 
Join Date: January 22, 2004
Posts: 22,100

Quote:
Originally posted by rafiq
Zunaid, Chinaman: my 10 second review is that there is a disconnect between the 3 things the calculator is supposed to calculate and the online form. Maybe the user can choose which of the three things they want to calculate, and then fill out the appropriate data. Right now you can input data for each line and come up with something meaningless or an error.
Could you give some examples of data you plugged in - I haven't put in a lot of data validation to ensure that the right data is entered - just minimals ones... For example you could enter - values.

Your input will help to make this idiot proof.

thanks for kicking the tires

- Zunaid
Reply With Quote
  #13  
Old February 25, 2004, 01:51 AM
Zunaid Zunaid is offline
Administrator
 
Join Date: January 22, 2004
Posts: 22,100

to add to the above ,,

i could just put in 1, 2, 3, 4, 5 in sequence and get some meaningless output..
Reply With Quote
  #14  
Old February 25, 2004, 01:51 AM
chinaman chinaman is offline
Retired BC Admin
 
Join Date: August 14, 2003
Location: pc near u
Posts: 8,021

I think I got it.

You are right, the "Opponents Score (if batting first)" is the only optional data and it is used to compute the "Target Over".

All other fields are required and both Target Run and Required Run Rate are generated.

Let's see what Dr. Z thinks to make it more user friendly. He's been working on it all day long and might give another thought later on.
Reply With Quote
  #15  
Old February 25, 2004, 01:55 AM
Zunaid Zunaid is offline
Administrator
 
Join Date: January 22, 2004
Posts: 22,100

Not all day ...

just stealing company time a little bit here and a little bit there ..

I will wait for additional comments before I make the next major update...

I am also looking at UI issues - how to make it clear and simple. Looks like one useful addition would be to mark things as required and optional and reject invalid input data.

Any others?

- Zunaid
Reply With Quote
  #16  
Old February 25, 2004, 02:00 AM
rafiq rafiq is offline
Cricket Legend
 
Join Date: September 22, 2002
Location: Chicago
Posts: 3,394

depending on how much time you want to spend on it, here are suggestions.

1. Ask user what they want to calculate - from the 3 things listed on the top of the page. Based on that, only allow user input for relevant data needed to calculate that choice. I would imagine all fields will be mandatory. Show result at the end.

2. To trap for meaningless data entry, you can put in some validation and rules - again not sure what you are coding in.

3. If there is an error, explain why.

This doesn't have to be done overnight. You should protect the IP around it (maybe?), not sure if this is available on other sites. In fact, a calculator section would be welcome on live sites like crickinfo eg NRR or D/L calculations on the fly as people are following live games.
Reply With Quote
  #17  
Old February 25, 2004, 02:03 AM
fab fab is offline
Test Cricketer
 
Join Date: June 30, 2003
Posts: 1,476

I just tried it out

Data: (Current England U19 team if they want to get 1.95)
Target Net Run Rate: 1.95
Total Overs For: 50
Total Overs Against: 50
Total Runs For: 306
Total Runs Against: 209
Opponents Score (if batting first): 250

Result:
Warning: Division by zero in /home/banglacr/public_html/tools/nrr.php on line 133
Warning: Division by zero in /home/banglacr/public_html/tools/nrr.php on line 135


Data: (For Zimb U19 to go from -1.947 to 1.94)
Target Net Run Rate: -1.940
Total Overs For: 50
Total Overs Against: 30
Total Runs For: 141
Total Runs Against: 143
Opponents Score (if batting first): 250


Result
Target Run (T-Run): 630
Required Run Rate (RRR): 12.6
Target Overs (T-Ov): 19.84126984127

You entered
Target Net Run Rate: -1.940
Total Overs For: 50
Total Overs Against: 30
Total Runs For: 143
Total Runs Against: 143
Opponents Score (if batting first): 250

-------

Okay, I haven't been following the NRR calculations thread, but is this correct? To improve the NRR by .007 they need to score 250 runs in 19 overs?

-----

Minor comment, seems like the "Total runs for" field in the results section is displaying the total runs against instead.

[Edited on 25-2-2004 by fab : typo]
Reply With Quote
  #18  
Old February 25, 2004, 02:09 AM
chinaman chinaman is offline
Retired BC Admin
 
Join Date: August 14, 2003
Location: pc near u
Posts: 8,021

Will be looking into this. Thanks for the suggestions.
Reply With Quote
  #19  
Old February 25, 2004, 02:12 AM
Zunaid Zunaid is offline
Administrator
 
Join Date: January 22, 2004
Posts: 22,100

Quote:
Originally posted by rafiq
depending on how much time you want to spend on it, here are suggestions.

1. Ask user what they want to calculate - from the 3 things listed on the top of the page. Based on that, only allow user input for relevant data needed to calculate that choice. I would imagine all fields will be mandatory. Show result at the end.

2. To trap for meaningless data entry, you can put in some validation and rules - again not sure what you are coding in.

3. If there is an error, explain why.

This doesn't have to be done overnight. You should protect the IP around it (maybe?), not sure if this is available on other sites. In fact, a calculator section would be welcome on live sites like crickinfo eg NRR or D/L calculations on the fly as people are following live games.
1. Good idea

2. Will work on adding traps for invalid data.

3. We would like to add other tools. About protecting the IP, the fundamental idea is public domain - ours is just one implementation of it. As for D/L - it is actually proprietary to a certain extent. The ICC has a 9 pager document on it

By law, one HAS to use the official software which requires an extensive table built by D&L. As a starter, we could create a simpler version to give some idea of the reuired score - can't make it exactly accurate until I have hunted down the full D&L resource table. The one's I see only have granularity at the over level and not at the ball level, so I need to do some interpolation. There are actually a few D&L calculator available for download. Haven't seen a RRR calculator yet though.

As fab pointed out, there was a mini bug which has been fixed. The divide by zero exception will be fixed as we add more data validation rules.

Looking at the explnation, the blurb for total (runs/overs) against could be made clearer.

This is still work in progress and is now available for the members here to put it through it's paces.

Thanks,
Z
Reply With Quote
  #20  
Old February 25, 2004, 02:16 AM
fab fab is offline
Test Cricketer
 
Join Date: June 30, 2003
Posts: 1,476

btw, thanks for the effort. It's looking great!
Reply With Quote
  #21  
Old February 25, 2004, 02:17 AM
Zunaid Zunaid is offline
Administrator
 
Join Date: January 22, 2004
Posts: 22,100

Quote:
Originally posted by fab
I just tried it out

Data: (Current England U19 team if they want to get 1.95)
Target Net Run Rate: 1.95
Total Overs For: 50
Total Overs Against: 50
Total Runs For: 306
Total Runs Against: 209
Opponents Score (if batting first): 250
Chinaman,

With TOF = TOA, the denominator of your equation results in a division by zero.. Is TOF=TOA a possible scenario. If so, is there a special case handling?

- Z
Reply With Quote
  #22  
Old February 25, 2004, 02:18 AM
tnb tnb is offline
Club Cricketer
 
Join Date: July 17, 2003
Location: FL, USA
Posts: 134

Great. strated playing with it immediately.

one of the trial was like this:

Target Net Run Rate: 1.2
Total Overs For: 99
Total Overs Against: 98
Total Runs For: 300
Total Runs Against: 250
Opponents Score (if batting first): 25

got Invalid data.

Then i saw all the input fields were erased. I am too lazy to fill all the fields again. just want to edit the erroneous data.
Reply With Quote
  #23  
Old February 25, 2004, 02:21 AM
Zunaid Zunaid is offline
Administrator
 
Join Date: January 22, 2004
Posts: 22,100

Quote:
Originally posted by tnb

Then i saw all the input fields were erased. I am too lazy to fill all the fields again. just want to edit the erroneous data.
boshte dile shuite chae ... bah humbug

version 2.0

ps. thanks for the comments. I myself am lazy... if I pre-fill the fields with earlier results, then the reset button will not clear all.. if you can live with that...
Reply With Quote
  #24  
Old February 25, 2004, 02:27 AM
tnb tnb is offline
Club Cricketer
 
Join Date: July 17, 2003
Location: FL, USA
Posts: 134

lol.
i can live with that (hoping wont make mistakes in every filed ).
thanks to all of you.
Reply With Quote
  #25  
Old February 25, 2004, 02:32 AM
chinaman chinaman is offline
Retired BC Admin
 
Join Date: August 14, 2003
Location: pc near u
Posts: 8,021

Quote:
Originally posted by Zunaid

Chinaman,

With TOF = TOA, the denominator of your equation results in a division by zero.. Is TOF=TOA a possible scenario. If so, is there a special case handling?

- Z
Will be working on it tomorrow.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On



All times are GMT -5. The time now is 05:39 AM.



Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
BanglaCricket.com
 

About Us | Contact Us | Privacy Policy | Partner Sites | Useful Links | Banners |

© BanglaCricket