Kallisculator

I'm sure that there will be tributes to Jacques Kallis all over the web at the moment. I wanted to do something uniquely CricketGeeky. So I've put together an interactive calculator, similar to the Tendulkulator that I did when Tendulkar retired. You enter in the runs and say if they are out or not out, then the basic bowling figures and it will tell you where he will end up on the all time batting and all-rounder's average leader board. You will need to scroll to the right to see the full all-rounder's numbers


I've done my best to lock it down, but it is a shared file, so if you find a way round the security, please don't vandalise it. Let everyone else play too.

Tendulkulator

I'm sure that there will be tributes to Sachin Tendulkar all over the web at the moment. I wanted to do something uniquely CricketGeeky. So I've put together an interactive calculator. You enter in the 4 next scores and say if they are out or not out and then it will tell you where he will end up on the all time average leader board. The one joker in the pack is that Che Pujara is currently ahead of him, so if he has a terrible series, he might push Tendulkar up one.

I've excluded the supertest because, well, it was a bit rubbish and should never have been given test status.


I've done my best to lock it down, but it is a shared file, so if you find a way round the security, please don't vandalise it. Let everyone else play too.

2013 Champions League T20 Net Run Rate calculator

Here's are some Net Run Rate calculators. I've tried to make them so that only relevant cells can be edited, but it's a shared document so please don't vandalise it if your team loses.

Group A


Group B

Net Run Rate calculator Group A

Today there are 2 potentially interesting matches in the Champions League.

There are 3 basic outcomes possible from these matches (as well as a couple of unusual ones)

Option 1 - Auckland lose

Regardless of what happens in the second match if Auckland lose, both the Titans and the Daredevils are through to the semi-finals.

Option 2 - Auckland and Delhi win

If this happens then Auckland and Delhi are both through to the semi-finals.

Option 3 - Auckland and Titans win

It this happens then the Titans are through, and the team with the best net run rate out of Auckland and Delhi go through.

Additional options - rain stops play
If the first game is rained out, then Delhi are automatically through to the semi-final. Then if Delhi beat the Titans by a significant enough margin to cause the Titans' NRR to drop below Auckland's, Auckland would go through, otherwise the Titans would. Given that the Titans would know the formula, they would be likely to go for the lower target to ensure qualification.

If Auckland win the first game and the second is rained out, then again it would come down to NRR between the Aces and the Titans.

For any of those situations you can use this Net Run Rate calculator here: