Yesterday, I tried to mash up a line-up prediction tool with Google spreadsheet (gsheet). If you had taken a look, you must have been disappointed - even I was. For some reason, Google hasn’t yet implemented an online interactive ability to its gsheets.
By online interactivity, I mean an online calculator type of spreadsheet where you enter some values and see an end result calculated and projected.
Such simple tools are:
BTP, instead of wasting a huge amount of time with a IPL-5 playoff prediction with a gsheet, isn’t it better to run with zoho sheet? This is what I’ve done.
The original post of yesterday, ‘IPL-5 (2012) Playoff Line-up with Google Spreadsheet’ has been updated with a zoho sheet (and renamed appropriately), which allows interactivity.
We can input a predicted result for ‘Team 1’ in the coloured cells and see what the playoff line-up will be. While keeping all other results the same, we can ‘toggle’ the result for one match, and see the change in the line-up.
Once and for all, no more speculation. I am sick of arguments like ‘see if CSK wins the next (last) match (on 17th), they will definitely be in the playoffs’. If you play around with the interactive sheet, you will find that it is not ‘so’ certain.
If RCB win both their matches (on 17th and 20th) against DD and DC respectively, it can possibly be a 3 way tie for the 4th spot between CSK, KKR & RCB. Then it will depend on run rates. Though CSK has better run rate than RCB now, CSK has only 1 match to improve it further, while RCB have 2 to do it.
And it also proves a point which I’d been making for the last few days. If RCB had won the match against MI yesterday (14th May), it was more probable that CSK would have been out of the playoffs.
Cheers!
By online interactivity, I mean an online calculator type of spreadsheet where you enter some values and see an end result calculated and projected.
Such simple tools are:
- a mile to kilometre to nautical mile calculator and vice versa; or
- a temperature convertor from Celsius to Fahrenheit & vice versa; and the like.
BTP, instead of wasting a huge amount of time with a IPL-5 playoff prediction with a gsheet, isn’t it better to run with zoho sheet? This is what I’ve done.
The original post of yesterday, ‘IPL-5 (2012) Playoff Line-up with Google Spreadsheet’ has been updated with a zoho sheet (and renamed appropriately), which allows interactivity.
We can input a predicted result for ‘Team 1’ in the coloured cells and see what the playoff line-up will be. While keeping all other results the same, we can ‘toggle’ the result for one match, and see the change in the line-up.
Once and for all, no more speculation. I am sick of arguments like ‘see if CSK wins the next (last) match (on 17th), they will definitely be in the playoffs’. If you play around with the interactive sheet, you will find that it is not ‘so’ certain.
If RCB win both their matches (on 17th and 20th) against DD and DC respectively, it can possibly be a 3 way tie for the 4th spot between CSK, KKR & RCB. Then it will depend on run rates. Though CSK has better run rate than RCB now, CSK has only 1 match to improve it further, while RCB have 2 to do it.
And it also proves a point which I’d been making for the last few days. If RCB had won the match against MI yesterday (14th May), it was more probable that CSK would have been out of the playoffs.
Cheers!
No comments:
Post a Comment