Indian Premier League 2008

[Abhas]

Whats Vlookup??

 

[SciD]

Whats Vlookup??

Its forumla in excel to match value against primary key in diffrent tables.

 

[ZexyZahid]

Update after the 54th Twenty20: http://content-uk.cricinfo.com/ipl/engine/match/336037.html

I stayed on number 6. Afridi played, but couldn't do anything. Raina, Dhoni and Morkel performed, so that doesn't help me either.

1 scion_sid 5202
2 aussie1st 4827
3 rahuldravidxi 4672
4 Abhas 4571
5 shan111 4566
6 ZexyZahid 4053
7 knightriders23 4037
8 vaibhav mehta 3875
9 viral1991 3834
10 afridi118 3831
11 Port Dominator 3819
12 mohu_123in 3763
13 WORLD CHAMPIONS 3713
14 Anuj Chhajed 3705
15 hassan2 3704
16 vimalmenon 3675
17 Brianlara400 3661
18 superstars 3658
19 varunparmar 3657
20 icyman 3623
21 Hacker 3622
22 koksmayu 3610
23 prasoonvidhu 3599
24 mks 3580
25 Bengal Rox!! 3573
26 Tarzan 3561
27 sohummisra 3530
28 .Mob 3521
29 addy91 3467
30 ajchovatiya 3397
31 send2yaari 3364
32 wardog 3356
33 dheerajkams 3264
34 woosaah 3221
35 pavanbharadwaj 3210
36 Visvenkat 3151
37 tannu_007in 3148
38 Dare 3148
39 vochelle 3141
40 hussainisgr8 3119
41 handsome 3116
42 mihir729 3014
43 Ashnal 3005
44 shantanu_rooney 3002
45 vasantharajan 2972
46 mihir6681 2919
47 kooljack9 2836
48 Hitterman 2821
49 Sarasvichu 2774
50 Dhoni7 2719
51 LORD_SHAIN 2697
52 macho212 2662
53 MS.Dhoni 2662
54 Yorkshire_No1 2657
55 Rajdeep009 2650
56 ngraham 2643
57 Arunava 2618
58 shanewarne 2593
59 y2j826 2572
60 lewis_f 2529
61 ansariaamir_leo 2490
62 skater 2486
63 nightprowler10 2395
64 coolio 2138
65 irottev 1942
66 Highlander999 1593

ZexyZahid added 9 Minutes and 57 Seconds later...

Update after the 55th Twenty20: http://content-uk.cricinfo.com/ipl/engine/match/336012.html

I stayed on number 6. Boucher made 18 runs, Jayasuriya 54 runs and Tendulkar got 40 runs and a catch. All helpful. Pollock failed for me though and Kallis didn't play.

1 scion_sid 5252
2 aussie1st 4857
3 rahuldravidxi 4707
4 Abhas 4651
5 shan111 4620
6 ZexyZahid 4171
7 knightriders23 4036
8 vaibhav mehta 3939
9 viral1991 3938
10 Port Dominator 3919
11 afridi118 3852
12 mohu_123in 3798
13 vimalmenon 3784
14 Hacker 3776
15 WORLD CHAMPIONS 3763
16 superstars 3744
17 hassan2 3728
18 Brianlara400 3725
19 Anuj Chhajed 3718
20 Tarzan 3715
21 varunparmar 3689
22 .Mob 3660
23 icyman 3654
24 mks 3626
25 koksmayu 3610
26 prasoonvidhu 3599
27 Bengal Rox!! 3557
28 sohummisra 3530
29 addy91 3485
30 ajchovatiya 3461
31 wardog 3426
32 send2yaari 3373
33 woosaah 3272
34 dheerajkams 3264
35 tannu_007in 3240
36 pavanbharadwaj 3221
37 handsome 3214
38 vochelle 3209
39 hussainisgr8 3169
40 Dare 3162
41 Visvenkat 3151
42 shantanu_rooney 3134
43 vasantharajan 3122
44 mihir729 3122
45 Ashnal 3023
46 mihir6681 3017
47 kooljack9 2890
48 LORD_SHAIN 2815
49 Dhoni7 2809
50 Hitterman 2778
51 Sarasvichu 2740
52 macho212 2727
53 MS.Dhoni 2712
54 shanewarne 2661
55 ngraham 2661
56 Yorkshire_No1 2657
57 y2j826 2622
58 Rajdeep009 2620
59 Arunava 2618
60 lewis_f 2579
61 skater 2486
62 ansariaamir_leo 2460
63 nightprowler10 2411
64 coolio 2292
65 irottev 1942
66 Highlander999 1661

ZexyZahid added 12 Minutes and 35 Seconds later...

Update after the 56th Twenty20: http://content-uk.cricinfo.com/ipl/engine/match/336019.html

I stayed on number 6. Eventually I'll be number 6 or 7. I didn't have any player playing in this match, because Warne was resting himself. And suddenly almost everybody started to perform in this match.

For the next three matches I'll have only available Sehwag, Malik, McGrath and Warne. And only three of them are likely to play.

1 scion_sid 5335
2 aussie1st 5064
3 Abhas 4800
4 rahuldravidxi 4745
5 shan111 4703
6 ZexyZahid 4171
7 knightriders23 4164
8 Port Dominator 4022
9 mohu_123in 3987
10 vaibhav mehta 3984
11 viral1991 3976
12 afridi118 3935
13 Anuj Chhajed 3904
14 vimalmenon 3829
15 superstars 3828
16 Hacker 3776
17 hassan2 3773
18 varunparmar 3772
19 Brianlara400 3770
20 WORLD CHAMPIONS 3763
21 Tarzan 3760
22 .Mob 3743
23 koksmayu 3731
24 icyman 3699
25 mks 3671
26 prasoonvidhu 3644
27 sohummisra 3638
28 Bengal Rox!! 3602
29 addy91 3530
30 ajchovatiya 3506
31 wardog 3426
32 send2yaari 3411
33 dheerajkams 3369
34 handsome 3297
35 tannu_007in 3285
36 woosaah 3272
37 pavanbharadwaj 3266
38 shantanu_rooney 3217
39 vochelle 3209
40 Dare 3207
41 vasantharajan 3205
42 hussainisgr8 3169
43 mihir729 3161
44 Visvenkat 3151
45 mihir6681 3062
46 Ashnal 3023
47 kooljack9 2935
48 LORD_SHAIN 2815
49 Dhoni7 2809
50 Hitterman 2778
51 Sarasvichu 2764
52 macho212 2727
53 MS.Dhoni 2712
54 ngraham 2706
55 y2j826 2705
56 Rajdeep009 2665
57 Arunava 2663
58 shanewarne 2661
59 Yorkshire_No1 2657
60 lewis_f 2579
61 skater 2486
62 ansariaamir_leo 2460
63 nightprowler10 2411
64 coolio 2316
65 irottev 1942
66 Highlander999 1661

 

[aussie1st]

Got that gap back under 300 now it's time for the Watson and Pathan show to continue. If not I might not even make the top 3.

 

[Abhas]

Shan has a great chance!! he has 7 people playing in the finals.. Rest have 5-6.

Good to see myself back in the Top 3

 

[aussie1st]

Hes also got his captain, I'm the only other one in the top 5 that has that. Hoping I can get two big games out of him. I can see Smith causing me problems.

 

[Abhas]

Looking at the teams more carefully,
I have 4 batsmen - Watson, Y. Pathan, Sehwag and Yuvraj, Albie Morkel, Mcgrath

Rahuldravidxi has only gambhir and smith as his batsmen, though he has almost all his bowlers playing.. Morkel, Pathan, Murli, Tanvir.

Shan has a very balanced side, and the advantage of his captain playing.
he has Gambhir Smith and Yuvraj, Pathan, Murli and warne and ofcourse his captain Dhoni..

 

[afridi118]

ahhh 12 not bad thoug.

 

[Highlander999]

Kind of ironic I feel

Standings after 1st IPL match - Kolkata Knight Riders VS Bangalore Royal Challengers


http://content-ind.cricinfo.com/ipl/engine/current/match/335982.html


1 irottev 336
2 macho212 280
3 y2j826 227
4 Highlander999 226

Update after the 56th Twenty20: http://content-uk.cricinfo.com/ipl/e...ch/336019.html
65 irottev 1942
66 Highlander999 1661

 

[Abhas]

Great Game for me!! Watson doing the Job 3rd place is slightly more secure than before!!

Also, Rajasthan will qualify, so Watson will get another Chance
The problem is that I am losing 3 delhi players, while Shan and rahuldravidxi are losing just 1 each.

This promises to be a cliffhanger

 

[aussie1st]

How comes the comeback Watson close to 200 points with his 50 bonus points, Pathan around 70 which doubles to 140 and both are in the final

 

[Abhas]

I have done the scoring, but somehow i cant access the Standings page.. If someone manages, please post the standings here.

 

[SciD]

How comes the comeback Watson close to 200 points with his 50 bonus points, Pathan around 70 which doubles to 140 and both are in the final

:crying

After yesterday when all Big 3 fired for Royals I am certain to come second in this game :crying

 

[Abhas]

The Standings page is not visible due to some problem, but I have seen the points of Sid and Syl..

Beware, now he is just 50 points away from you

 

[SciD]

Need Yuvi to fire badly tonight.