Super Selector - India tour of Australia

  • Thread starter Thread starter ~Hami~
  • Start date Start date
  • Replies Replies 296
  • Views Views 32,913
Ok I have created small google spreadsheet, which calculates show points
automatically for all participants

Google Docs - superselector

Note: I am not participating, my table is created just for testing purpose.

All you have to do is insert runs and wkts taken by each player everyday and everything else will be calculated automatically.

Currently its in read only mode, if ppl like it I will transfer rights to whoever wishes to.
 
heh! nice obs amish.that means manu1991 is out? :Pdont transfer rights, just invite people (sneezymelon AT gmail )
 
@amish,

nice find amish. u r right... :)

manu1991 sorry ya.. u r eliminated...

_________________________________________________

Match is over on the 4th Day itself:

Points Receivers on 4th Day:

Dravid 16
Jaffer 15
Laxman 42
Sachin 15
Ganguly 40
Yuvraj 5
Dhoni 11
Kumble 8
RP Singh 2

B.Lee 20
B.Hogg 20
M.Johnson 30
Clark 10
Symonds 10

_____________________________________________________
 
Points of asdfgf brought forward:

653

Points earned on day 4 :

16 + 40 + 10 + 20 + 2 + 10 + 20 + 30 = 148

so,

Total Points at the end of 1st Test:

653 + 148=

801

__________________________________________________
 


Points of Sneezymelon brought forward:

631

Points earned on Day 4:

5 + 42 + 11 + 10 + 40 + 8 + 2 + 30 + 10 = 158

so,

Total POints of Sneezymelon at the end of 1st TEst:

631 + 158 =

789

__________________________________________________


POints of vln_arun brought forward:

536

Points earned on Day 4:

5 + 15 + 10 + 30 + 2 + 10 = 72

so,

Total Points of vln_arun at the end of 1st Test:

536 + 72 =

608

__________________________________________________


Points of Harshal brought forward:

506

Points earned on Day 4:

16 + 42 + 15 + 10 + 5 + 30 + 10 + 2 = 130

so,

Total Points of Harshal at the end of 1st TEst:

506 + 130 =

636

____________________________________________________


POints of ajuravi007 brought forward:

361

Points earned on Day 4:

10 + 15 + 40 + 16 + 5 + 11 + 20 + 20 + 30 + 10 = 177

So,

Total points of ajuravi007 at the end of 1st TEst:

361 + 177 =

538

______________________________________________________
 
@asdfgfcan I change my team for 2nd test? Or I can only make substitutions for the players who are not playing?
 
Rank Standings at the end of 1st Test:

1. asdfgf 801
2. Sneezymelon 789
3. Harshal 636
4. vln_arun 608
5. ajuravi007 538



and the winner of first test is:


:yahoo: asdfgf :yahoo:

runners up:

2nd


:thumbsup: Sneezymelon :thumbsup:

3rd

:) Harshal :)

@asdfgf
can I change my team for 2nd test? Or I can only make substitutions for the players who are not playing?

yah. we can change the entire team :)
 

Back