PS3: 1ST IPL TOURNAMENT - KKR (RIZZYX) WIN THE TOURNAMENT!

[kushari]

@kushari you were KXI right? I can't find the saved file? Maybe we didn't save it at all! The game is missing!
@RIZZYX sorry about that. From my commentary thread, I can see that kushari scored 119 all out, and I chased it in the 16th over after losing 7 wickets. This should suffice for the NRR table. I don't know how many balls in the 16th over were bowled, so just take it midway or something.

How come your file is deleted too? Its so weird..I remember deleting few game files and must have deleted our match file during that time by mistake..But I am sure the file was saved as I checked it 01/02 times last evening...

@RIZZYX how you will take account of this match if no precise data and score card is available?

 

[arjwiz]

How many overs did Kushari bat?

And please can I ask for all future games if you post the scorecard here once the game has been completed, it would take maximum of 5-10 minutes.

Already posted today's game.

Kushari batted more than 17 overs according to my commentary. But that shouldn't matter in the NRR calculations. The losing team loses 20 overs no matter how many they batted.

 

[RIZZYX]

Already posted today's game.

Kushari batted more than 17 overs according to my commentary. But that shouldn't matter in the NRR calculations. The losing team loses 20 overs no matter how many they batted.

I did not know that, thanks for pointing it out.

I was doing it total runs scored/overs faced - total runs conceded/overs bowled.

I will have to re do the nrr for the table.

 

[arjwiz]

How come your file is deleted too? Its so weird..I remember deleting few game files and must have deleted our match file during that time by mistake..But I am sure the file was saved as I checked it 01/02 times last evening...

@RIZZYX how you will take account of this match if no precise data and score card is available?

No idea how it was lost. Maybe if you delete it then I lose it too.

It shouldn't affect the data for this tournament. We just need to know exactly how many balls were bowled in the 16th over of my innings. This is a minor detail. The number of overs you batter does not matter.

@RIZZYX I notice your Net Run Rate formula is incorrect in your spreadsheet. The losing team always loses 20 overs. Send me the spreadsheet and I will fix the formula. You cannot divide directly by overs.

----------

I did not know that, thanks for pointing it out.

I was doing it total runs scored/overs faced - total runs conceded/overs bowled.

I will have to re do the nrr for the table.

That is correct, with the caveat that the losing team loses all overs. In 50 over cricket, they lose 50 overs. In test matches, they lose 20 wickets (even if they declared their first innings). Think about it, without this, a team can score high in their first over or two, then declare (or get all out). They will lose the match, but will have a higher NRR. They can hit a six off the first ball then declare. Their NRR will be 36!

Similarly, the overs bowled for the winning team is always always 20 overs, no matter how many they actually bowled.

The other caveat is that this condition does not apply to incomplete (e.g. rain affected) games. In such games, the actual scores are counted. This doesn't affect your formula since we don't have such cases in DBC.

 

[RIZZYX]

My spread sheet is a bit all over the place, so yeh would be great if you could fix it up lol.

I have attached the file.

 

[arjwiz]

My spread sheet is a bit all over the place, so yeh would be great if you could fix it up lol.

I have attached the file.

No you haven't you liar!

 

[RIZZYX]

No you haven't you liar!

Oh yes I have. You should have gone to specsavers.

 

[Solomon]

@RIZZYX are you keeping tab batting and bowling stats?

 

[RIZZYX]

@RIZZYX are you keeping tab batting and bowling stats?

I have not yet, I will get around to doing these at some point during this week.

Need to make sure I have all full scorecards to do this.

(I am not that good with excel so can't come up with the fancy formulas that arjwiz has to automatically update everything lol)

----------

also @arjwiz i been meaning to ask you regarding pollard's bowling, i saw the by default pollard was a medium pacer in game, and i think that is about right or may be he can be notched up to medium fast, but i think you have him as a fast medium pace bowler who can bowl at 89mph.

In comparison I have Umesh Yadav also as a fast medium bowler with the same speed, when he can actually bowl 90+

Just think maybe you need to have another look at him.

 

[arjwiz]

I have not yet, I will get around to doing these at some point during this week.

Need to make sure I have all full scorecards to do this.

(I am not that good with excel so can't come up with the fancy formulas that arjwiz has to automatically update everything lol)

----------

also @arjwiz i been meaning to ask you regarding pollard's bowling, i saw the by default pollard was a medium pacer in game, and i think that is about right or may be he can be notched up to medium fast, but i think you have him as a fast medium pace bowler who can bowl at 89mph.

In comparison I have Umesh Yadav also as a fast medium bowler with the same speed, when he can actually bowl 90+

Just think maybe you need to have another look at him.

I don't know, I haven't touched any player's bowling type. Only skills. Not even fielding attributes.

He is definitely medium-fast in the game (or fast-medium....are they different?). He is not fast nor is he medium. This is a Llewelyn or Mrdconnors download.

 

[arjwiz]

I have attached the sheet. I haven't changed anything except one formula for points. The way it is built is different from what I might have done, so the way you are doing it now manually is also good.

The only difference you need to do is that when you fill in the scores manually, for the losing team, enter 20 as the number of overs played (and similarly enter 20 as the number of overs bowled by the winning team), irrespective of how many overs were actually played. Your formula will then be correct.

To be clear, the only elements you need for the points table, after any match, are:

Runs by winning team
Runs by losing team
Overs played by winning team

That's it. Just those three things. Not even wickets. Everything else is just added fun in case anyone wants to see the scorecards. So nothing will be lost in kushari and my game. Just say that MI won in 15.3 overs and then it should be fine.

 

[RIZZYX]

I don't know, I haven't touched any player's bowling type. Only skills. Not even fielding attributes.

He is definitely medium-fast in the game (or fast-medium....are they different?). He is not fast nor is he medium. This is a Llewelyn or Mrdconnors download.

I don't know what is going on then because the Pollard i have from Llewelyn is a medium pacer.

Anyway we will leave it as it is for this edition of the IPL as we have already started.

 

[arjwiz]

I don't know what is going on then because the Pollard i have from Llewelyn is a medium pacer.

Anyway we will leave it as it is for this edition of the IPL as we have already started.

Could be mrdconnors then. These are the only two I dowloaded all my players from, other than chandrakif for Indian domestic. The only person I edited the bowling type of was Rajat Bhatia to medium, since @valerian140 pointed it out. I haven't touched kits, appearance, nothing except for skills of every player.

 

[RIZZYX]

I have attached the sheet. I haven't changed anything except one formula for points. The way it is built is different from what I might have done, so the way you are doing it now manually is also good.

The only difference you need to do is that when you fill in the scores manually, for the losing team, enter 20 as the number of overs played (and similarly enter 20 as the number of overs bowled by the winning team), irrespective of how many overs were actually played. Your formula will then be correct.

To be clear, the only elements you need for the points table, after any match, are:

Runs by winning team
Runs by losing team
Overs played by winning team

That's it. Just those three things. Not even wickets. Everything else is just added fun in case anyone wants to see the scorecards. So nothing will be lost in kushari and my game. Just say that MI won in 15.3 overs and then it should be fine.

Thanks mate.

Is there a way to have a formula to convert the overs to the correct format?, for example if the winning side batted for 10.3 overs for the purpose of the NRR that should be calculated as 10.5, likewise 10.2 overs would be 10.333 etc...

I am doing this manually at the moment.

 

[RIZZYX]

Table has been updated for games played by end of 26/05/14

Table will be updated again when week 2 has been completed (After all games played by the end of Sunday 01/06/14)