One Dayers: Ladder and Statistics after Round 1

Jolldo87

New Member
One Dayers: Ladder and Statistics after Round 1

Code:
Pos		        P	W	L	T	BP	P	RF	OF	RA	OB	NRR
1	Nairboi Nuggets	1	1	0	0	0	2	297	42	294	50	1.19
2	Geelong Gators	1	1	0	0	0	2	232	50	192	50	0.80
3	Western Wizards	1	1	0	0	0	2	228	50	227	50	0.02
---------------------------------------------------------------------------------------------------------------
4	Kingston Kings	1	0	1	0	0	0	227	50	228	50	-0.02
5	Madrid Magic 	1	0	1	0	0	0	192	50	232	50	-0.80
6	Chittagong 	1	0	1	0	0	0	294	50	297	42	-1.19

Stats up tomorrow.
 
Re: One Dayers: Ladder and Statistics after Round 1

Code:
BEST INDIVIDUAL PERFORMANCES

Highest no of runs scored     92       Flawed Genius NRN
Highest batting average       92.00    Flawed Genius NRN
Highest batting strike rate  216.67    Mid Wicket MM
Highest individual score      92       Flawed Genius NRN
Most centuries scored          0

Highest number of wickets      4       Keep Wandering CC, diablo14 MM
Lowest Economy Rate            2.00    HOWZAAT WTW
Lowest Bowling Average         4.00    HOWZAAT WTW
Best Bowling Effort            4/44    diablo14 MM
Most five wicket hauls         0
 
Re: One Dayers: Ladder and Statistics after Round 1

Code:
CC - CHITTAGONG CHEETAHS
Played: 1      Won: 0       Tied: 0       Lost: 1       N/R: 0       Win%:   0.0

Player     Mch  In  Runs  Avge S/R HS 50 100 Ovrs  Runs Wkt  Avge E/R Best 4w 5w
daddy'eyes   1   1    62  62.0  91  62  1  0    0     0   0   -.- -.- -/-   0  0
A Aleks      1   1    33  33.0  87  33  0  0    0     0   0   -.- -.- -/-   0  0
H Hougie     1   1    44  44.0 138  44  0  0    0     0   0   -.- -.- -/-   0  0
t tugga      1   1     6   6.0 150   6  0  0    0     0   0   -.- -.- -/-   0  0
J Jolldo87   1   1    22  22.0 147  22  0  0    0     0   0   -.- -.- -/-   0  0
P PHX        1   1    78   -.-  91  78  1  0    0     0   0   -.- -.- -/-   0  0
Y YOTC       1   1    26  26.0  96  26  0  0   10    57   1  57.0 5.7 1/57  0  0
the_s'lite   1   1     5   5.0  36   5  0  0    6    54   0   -.- 9.0 -/-   0  0
E Equus      1   1     2   2.0  33   2  0  0    8    56   0   -.- 7.0 -/-   0  0
Wandering    1   1     1   1.0  33   1  0  0    9    63   4  15.8 7.0 4/63  1  0
m cambios    1   1     5   5.0  71   5  0  0    9    64   0   -.- 7.1 -/-   0  0

Code:
GG - GEELONG GATORS
Played: 1      Won: 1       Tied: 0       Lost: 0       N/R: 0       Win%: 100.0

Player     Mch  In  Runs  Avge S/R HS 50 100 Ovrs  Runs Wkt  Avge E/R Best 4w 5w
B Badger     1   1    53  53.0  93  53  1  0    0     0   0   -.- -.- -/-   0  0
a ants14     1   1    62  62.0 107  62  1  0    0     0   0   -.- -.- -/-   0  0
a effort     1   1    17  17.0  85  17  0  0    0     0   0   -.- -.- -/-   0  0
I Pies       1   1    46   -.-  72  46  0  0    0     0   0   -.- -.- -/-   0  0
j park       1   1     6   6.0  46   6  0  0    0     0   0   -.- -.- -/-   0  0
g ipl        1   1     6   6.0  27   6  0  0    3    13   1  13.0 4.3 1/13  0  0
T Rissole    1   1     0   0.0   0   0  0  0   10    37   1  37.0 3.7 1/37  0  0
SHANE'ARNE   1   1    11  11.0  42  11  0  0    8    45   3  15.0 5.6 3/45  0  0
m mdf30586   1   1    17  17.0  74  17  0  0    7    23   0   -.- 3.3 -/-   0  0
B Buddy23#   1   1     0   0.0   0   0  0  0   10    42   2  21.0 4.2 2/42  0  0
c crktluva   1   1     0   0.0   0   0  0  0    8    29   2  14.5 3.5 2/29  0  0

Code:
KK - KINGSTON KINGS
Played: 1      Won: 0       Tied: 0       Lost: 1       N/R: 0       Win%:   0.0

Player     Mch  In  Runs  Avge S/R HS 50 100 Ovrs  Runs Wkt  Avge E/R Best 4w 5w
D D.K.       1   1    10  10.0  63  10  0  0    0     0   0   -.- -.- -/-   0  0
c tigez      1   1    28  28.0  97  28  0  0    0     0   0   -.- -.- -/-   0  0
T Therbs     1   1     1   1.0  20   1  0  0    0     0   0   -.- -.- -/-   0  0
K Kshitiz    1   1    41  41.0 105  41  0  0    0     0   0   -.- -.- -/-   0  0
D Double07   1   1    16  16.0  89  16  0  0    0     0   0   -.- -.- -/-   0  0
Highl'r999   1   1     4   4.0 133   4  0  0    0     0   0   -.- -.- -/-   0  0
bundybulls   1   1    31  31.0  50  31  0  0   10    41   0   -.- 4.1 -/-   0  0
F Fred       1   1    17  17.0  49  17  0  0   10    60   1  60.0 6.0 1/60  0  0
W Patrol     1   1    33   -.-  61  33  0  0   10    38   3  12.7 3.8 3/38  0  0
J Jimmy13    1   1    18  18.0  47  18  0  0   10    49   2  24.5 4.9 2/49  0  0
A Mc         1   1     1   -.-  20   1  0  0   10    31   1  31.0 3.1 1/31  0  0


Code:
MM - MADRID MAGIC
Played: 1      Won: 0       Tied: 0       Lost: 1       N/R: 0       Win%:   0.0

Player     Mch  In  Runs  Avge S/R HS 50 100 Ovrs  Runs Wkt  Avge E/R Best 4w 5w
Q Quinzate   1   1     8   8.0  38   8  0  0    0     0   0   -.- -.- -/-   0  0
siddl'klin   1   1    14  14.0  48  14  0  0    0     0   0   -.- -.- -/-   0  0
E Edge       1   1     0   0.0   0   0  0  0    0     0   0   -.- -.- -/-   0  0
B Breeno     1   1    76  76.0  67  76  1  0    0     0   0   -.- -.- -/-   0  0
doggi'in08   1   1    31  31.0  69  31  0  0    0     0   0   -.- -.- -/-   0  0
T Tongs      1   1    16  16.0  53  16  0  0    0     0   0   -.- -.- -/-   0  0
M Wicket     1   1    13  13.0 217  13  0  0   10    52   0   -.- 5.2 -/-   0  0
M Mousey     1   1     2   2.0  40   2  0  0    9    32   2  16.0 3.6 2/32  0  0
T Tristo     1   1    13   -.-  54  13  0  0   10    47   2  23.5 4.7 2/47  0  0
d diablo14   1   1     0   0.0   0   0  0  0    9    44   4  11.0 5.0 4/44  1  0
T Wizz       1   1     2   2.0  29   2  0  0   10    49   2  24.5 4.9 2/49  0  0


Code:
NRN - NAIROBI NUGGETS
Played: 1      Won: 1       Tied: 0       Lost: 0       N/R: 0       Win%: 100.0

Player     Mch  In  Runs  Avge S/R HS 50 100 Ovrs  Runs Wkt  Avge E/R Best 4w 5w
S Sean       1   1    54  54.0  93  54  1  0    0     0   0   -.- -.- -/-   0  0
SouthSwans   1   1    43  43.0  91  43  0  0    0     0   0   -.- -.- -/-   0  0
eddiesmith   1   1     4   4.0 133   4  0  0    0     0   0   -.- -.- -/-   0  0
loopy_cam    1   1    57  57.0 119  57  1  0    0     0   0   -.- -.- -/-   0  0
F Genius     1   1    92  92.0 144  92  1  0    0     0   0   -.- -.- -/-   0  0
d together   1   1    23  23.0  96  23  0  0    0     0   0   -.- -.- -/-   0  0
B Bluto11    1   1    12   -.-  92  12  0  0   10    78   1  78.0 7.8 1/78  0  0
royla'roos   1   1     2   -.- 100   2  0  0   10    49   0   -.- 4.9 -/-   0  0
weapo'5/06   1   0     0   -.-   -   0  0  0   10    58   2  29.0 5.8 2/58  0  0
K Kram81     1   0     0   -.-   -   0  0  0   10    46   3  15.3 4.6 3/46  0  0
L Ljp86      1   0     0   -.-   -   0  0  0    9    58   3  19.3 6.3 3/58  0  0


Code:
WTW - WESTERN WIZARDS
Played: 1      Won: 1       Tied: 0       Lost: 0       N/R: 0       Win%: 100.0

Player     Mch  In  Runs  Avge S/R HS 50 100 Ovrs  Runs Wkt  Avge E/R Best 4w 5w
D DILLIGAF   1   1     7   7.0  70   7  0  0    2     4   0   -.- 2.0 -/-   0  0
t up         1   1    40  40.0  91  40  0  0    0     0   0   -.- -.- -/-   0  0
f fmr13      1   1     0   0.0   0   0  0  0    0     0   0   -.- -.- -/-   0  0
B Biggie     1   1    44  44.0  85  44  0  0    2    15   0   -.- 7.5 -/-   0  0
H HOWZAAT    1   1    29  29.0 104  29  0  0    2     4   1   4.0 2.0 1/4   0  0
p peterss    1   1     7   7.0  39   7  0  0    4    28   0   -.- 7.0 -/-   0  0
A A|dan      1   1    54   -.-  66  54  1  0    0     0   0   -.- -.- -/-   0  0
kevieyang    1   1    13  13.0  48  13  0  0   10    37   2  18.5 3.7 2/37  0  0
R Resist     1   1    10  10.0  36  10  0  0   10    41   3  13.7 4.1 3/41  0  0
postmanpav   1   1    10   -.-  83  10  0  0   10    40   1  40.0 4.0 1/40  0  0
D DJHussey   1   0     0   -.-   -   0  0  0   10    45   2  22.5 4.5 2/45  0  0
 
Re: One Dayers: Ladder and Statistics after Round 1

Just a small request Jolldo. Once a couple of bowlers reach 5 wickets can we have a minimum wickets rule to get in the best individual performances? HOWZAAT is a pure batsman but was lucky enough to bowl 2 overs and snag a wicket, cheaply. No-one now has a chance of beating his average of 4, any chance we can change it?

Just a suggestion. Thanks.
 
Re: One Dayers: Ladder and Statistics after Round 1

Just exclude pure bats from the best bowling and pure bowlers from the best batting.
 
Re: One Dayers: Ladder and Statistics after Round 1

Nope.

Too busy playing indoor, going to the gym, working and ****ing random females. :)
 
Re: One Dayers: Ladder and Statistics after Round 1

Divorced teh wife eh? Sure did, well seperated anyway. Cant divorce for another 10 months. :)

Just requires a simple excel table. I could do it but....

Okay OD fixture done. Just trying to figure out the formulas for the table. Ugh haven't excelled in a while...

The Runs For/Against is all good, just trying to figure out the win/loss columns now..... also that's crazy shit Biggie...

Just so you guys know, the excel file won't be available until tomorrow. Need to consult a friend on how to complete it. My lack of geek killed my progress.
 
Re: One Dayers: Ladder and Statistics after Round 1

Okay Fellas. Here it is.

Code:
	Team		P	W	L	D	BP	RF	Ov. 	RA	O.B.	Net	Pts
1	Nuggets		2	2	0	0	0	574	89	570	100	0.75	4
2	Cheetahs	2	1	1	0	1	574	100	472	82	-0.05	3
3	Magic		2	1	1	0	1	358	82	397	90	-0.07	3
----------------------------------------------------------------------------------------------------------
4	Gators		2	1	1	0	0	407	90	472	100	-0.17	2
5	Wizards		2	1	1	0	0	504	100	504	97	-0.16	2
6	Kings		2	0	2	0	0	392	90	394	82	-0.42	0

Excel File nearly complete, just got to put in the fixture for the Tests.
 
Re: One Dayers: Ladder and Statistics after Round 1

YOTC, I'm going to take your word and use this table just as is, assuming its right! If it ain't I get to you :p! Nah jokes, Brilliant effort, and I'm sure its right. :)
 
Back
Top