Windies vs NZ spreadsheet challenge

[BeeGee]

Neesham: 1451.7? I guess nobody will be able to select him.

Benn: 0?

Some of those numbers look dubious.

 

[Kippax]

Yeah an average over 40 with the ball and under 25 with the bat is instant zero.

 

[Hurricane]

Yeah an average over 40 with the ball and under 25 with the bat is instant zero.

Thanks Kippax.

I should have put a formula in there to prevent peeps like neesham getting such high scores. Next time.

 

[Athlai]

Edwards - 115.11
Latham - 0
Williamson - 133.34
Taylor - 261.18
Chanderpaul - 381.49
Samuels - 134.93
Ramdin - 125.35
Southee - 149.91
Taylor - 84.6
Benn - 0
Shillingford - 109.3

Total 1494.40

 

[hendrix]

Latham 0
Edwards 115
Bravo 216
Taylor 261
McCullum 183
Anderson 180
Ramdin 125
Craig 0
Southee 149
Boult 175
Benn 0

= 1404

 

[HeathDavisSpeed]

1. Latham 0
2. Brathwaite 0
3. Williamson 133.34
4. Edwards 115.11
5. Powell 42.54
6. Ramdin 125.35
7. Craig 0
8. Jerome Taylor 84.6
9. Shillingford 109.3
10. Benn 0
11. Holder 18.1

 

[Athlai]

1. Latham 0
2. Brathwaite 0
3. Williamson 133.34
4. Edwards 115.11
5. Powell 42.54
6. Ramdin 125.35
7. Craig 0
8. Jerome Taylor 84.6
9. Shillingford 109.3
10. Benn 0
11. Holder 18.1

 

[HeathDavisSpeed]

I'm going for a high pick efficiency rating here. Gutted there weren't any zero rated middle order batsmen. Luke Ronchi doesn't count.

 

[Dan]

Is the second spreadsheet about increasing overall career points numbers, or a formula of runs scored and wickets taken in the series?

If the former, Heef's got this in the bag.

 

[Kippax]

Yeah Holder doesn't cost 18.1 points, ftr. Looks like I made a new column there and copied Gabriel's contents into it.

 

[HeathDavisSpeed]

Yeah Holder doesn't cost 18.1 points, ftr. Looks like I made a new column there and copied Gabriel's contents into it.

Bugger. How will I ever fit his higher player rating within my salary cap?!?

 

[Kippax]

I need Hurricane to present his list of acceptable openers, before tomorrow. Dan and Howe I suspect will be DQ'd.

 

[Dan]

Come on, Watling's more acceptable than KW or McCullum. Watling's actually done it in the past 3 years...

 

[Kippax]

Come on, Watling's more acceptable than KW or McCullum. Watling's actually done it in the past 3 years...

McCullum's more recent than Watling itbt.

 

[Hurricane]

Bashed one together

Williamson is not an opener. You need to find someone else.

Baz isn't an opener anymore however if you can find one person* other than Dan in the next 6 hours to back you up you can have him.

Dan regarding watling that is also a stretch - however if you can find one person* other than Howe in the next 6 hours to back you up you can have him.

The one person must have more than 1000 posts on cw and you each need a different person.

 

[Athlai]

Baz and Watling are opener cover.

 

[Athlai]

That said, they shouldn't get points unless they open.

 

[ohnoitsyou]

Watlings a better opener that Rudds, Fulton, Latham, Powell and Braithwaite.

 

[NUFAN]

Baz is an opener IMO.

1 McCullum 183.09
2 Powell 42.54
3 Williamson 133.34
4 Taylor 261.18
5 Anderson 180.37
6 Samuels 134.93
7 Watling 140.12
8 Southee 149.1
9 Taylor 84.6
10 Benn 0
11 Boult 175.1

 

[Hurricane]

Ok Baz is approved by NUFAN. Watling is still a question mark.