Season 5/6 Draft Information

[thewizard1o1]

Last pick yay!

 

[Simon]

guys, the first round draft list will be released tomorrow, ill be emailing it out for the first round only, after that, all draft information will only be available in this thread...

 

[nibbs]

sweet. i wonder what i'm gonna pick??? hmmmm

 

[Mr. P]

awesome good stuff mate...

 

[lord_of_darkness]

whens the draft players list out simon?

 

[bugssy]

good stuff mate

 

[Simon]

whens the draft players list out simon?

tomorrow, or if dave posts his free state squad before i go to bed, then tonight maybe...

 

[Simon]

guys, here is the first draft list in excel (not entirely sure it will work, but it did for me) and in notepad, you have until Midnight Wednesday 26th January to email me your selections, send them to glendad01@optusnet.com.au clearly mark your team and your order. remember to include enough players to cover your picks, eg, if you are picking 19th, email 19 players, if u are picking 4th, email 4 players. pretty simple...

Excel

Notepad

 

[Simon]

draft lists received

Kent
Northerns
Surrey
Karnataka
Tasmania
Warwickshire
Queensland
Karachi
Western Australia
South Australia
Auckland
Galle
Lahore
Jamaica
Lancashire
Guyana
Northern Districts
Gauteng
Chittagong
Barbados
New South Wales
ACT
Mashonaland
Victoria
Colts
Canterbury
Western Province
Tamil Nadu
Glamorgan
Somerset
Free State
Leicestershire

 

[bryce]

so your saying i have to go through and analyze no less than 513 players statistics while carefully selecting the 33 players that would best suit my team?
i'm sorry but is there any easier way to go about this?

 

[Simon]

so your saying i have to go through and analyze no less than 513 players statistics while carefully selecting the 33 players that would best suit my team?
i'm sorry but is there any easier way to go about this?

everyone else does it, if u r using excel u can use the filters that are there to find the type of player u want...

if u can come up with an alternative to this let me know...

 

[thewizard1o1]

In Excel select all the players, name the group and then just use the sort function to sort the columns. Was simple for me to do 36! that way...

 

[bryce]

can you explain a bit further thanks wizard, i'm not very well accquianted with excel

 

[Mister Wright]

can you explain a bit further thanks wizard, i'm not very well accquianted with excel

There is a simple way to do it. You can use the fitlers provided in the original document, otherwise you can copy the entire row that you are looking for, ie. 4D strike rate or 1d batting average and then paste it to be the first row. Then sort them from highest to lowest (depending on what your looking for).

 

[bryce]

thanks alot mister wright, i got it now

 

[Coach_Pearson]

Mine sent....

 

[Simon]

Mine sent....

and it has been received

 

[Cloete]

and it has been received

Did you get mine?

 

[Simon]

Did you get mine?

no i didnt...

 

[Cloete]

no i didnt...

oh ****.. I thought it might have had an error. Now I have to do it all over again