PS3: Ranji Trophy Competition | Punjab Warriors (Kushari) WIN THE LEAGUE

Latest player and team statistics after DDC vs MS and DDC vs JH only. The rest of you, update your scores into the sheet so that we can all see updated statistics.

EvnoI7x.png
 
@arjwiz buddy I filled up your chart in Drop-box with the score of my Match with RBT..But My final score and few other formulas are not been updated automatically in the Score card sheet..Can you have a look and do the necessary changes, and also do same for other sheets so that I can further add remaining 02 games score card.

----------

Also you need to add Bonus Point for Innings Win in the formula..My points are showing 06 Only, it should be 07..
 
@arjwiz buddy I filled up your chart in Drop-box with the score of my Match with RBT..But My final score and few other formulas are not been updated automatically in the Score card sheet..Can you have a look and do the necessary changes, and also do same for other sheets so that I can further add remaining 02 games score card.

----------

Also you need to add Bonus Point for Innings Win in the formula..My points are showing 06 Only, it should be 07..
@arjwiz Sorry your Spreadsheet is 100% OK, I was doing mistake..Now I have corrected it..


Edit: I have filled-up the score of all the 03 Matches of Punjab Warriors...My Net Average Rate is +44.013 LOL.....
 
Last edited:
@arjwiz Sorry your Spreadsheet is 100% OK, I was doing mistake..Now I have corrected it..


Edit: I have filled-up the score of all the 03 Matches of Punjab Warriors...My Net Average Rate is +44.013 LOL.....

You scared me. I was unable to find any errors in the formulae. :) Thanks for updating.
@bradthelad can you also update your scores? I think then all the scores will have been updated.

----------

Updated scores

7vrBii1.jpg
 
no way I'm not last and also i got best in something felling accomplished
 
You scared me. I was unable to find any errors in the formulae. :) Thanks for updating.
@bradthelad can you also update your scores? I think then all the scores will have been updated.

----------

Updated scores

7vrBii1.jpg

@arjwiz In your Score sheet snapshot, the Ranking is Showing Kushari-3rd & Valerian140 as 1st.

How the Ranking Table are calculated?
 
Oh yeah I'll fix that, the first column shouldn't be sorting. It wasn't sorting when I created it...anyway. Currently Kushari is first, Valerian third. It is sorted in the correct order, just ignore the first column for this particular image. My image hasn't taken the point column of the table, but the spreadsheet has it all.
 
@arjwiz also wanted to check the fall of wickets for honu. If he has lost both his matches, his wickets lost should be 40 instead of 30
 
@arjwiz also wanted to check the fall of wickets for honu. If he has lost both his matches, his wickets lost should be 40 instead of 30

Oh that was my mistake...I have not mentioned Out / Not Out against each batsman for Jharkhands Second Innings..I will correct it..

EDIT: I have corrected it now...
 

Users who are viewing this thread

Top