Page 1 of 7 123 ... LastLast
Results 1 to 15 of 100
Like Tree9Likes

Thread: Windies vs NZ spreadsheet challenge

  1. #1
    Cricketer Of The Year Hurricane's Avatar
    Join Date
    Aug 2009
    Location
    Stopping the AFL spreading to NZ
    Posts
    9,715

    Windies vs NZ spreadsheet challenge

    I decided to give this a new thread to keep track of the different entrants - only expecting 3-4 peeps but it should be fun.

    Instructions
    1) Open up the attached spreadsheet and follow the instructions. You will name the team of XI players who you think will do the best in the test series. The formula will calculate a cost for each player. Your team needs to be a "team" with batsman, openers, keeper, bowlers etc.
    2) You can't go past 1500 points or you are Disqualified.
    3) You are also disqualified if you bat someone out of position. Hurricane's opinion is final on this but you can argue your case if you like. Some license will be given however so it doesn't need to be exact.
    4) Once you have made your selections attach your completed spreadsheet (with your username in the file name) to a post in this thread.
    5) Entries close when the first ball of the first test is bowled so you can wait until the last minute to see the line ups if you like.
    6) At the end of the series you will populate the results section. Person with the highest score in the results section wins. Remember to make a new post and attach your completed spreadsheet with results in it.
    7) Any errors I have overlooked in the spreadsheet let me know and I will quickly fix it.
    8) You are welcome to examine the formulas to help you pick your team.
    9) You are on your CW honour code not to fiddle with the formulas.

    Any other questions ask.

    Cheers

    Attached Files Attached Files
    Last edited by Hurricane; 05-06-2014 at 02:53 AM.
    Quote Originally Posted by HeathDavisSpeed View Post
    I got great enjoyment in going to the game and shouting "WHY THE **** ISN'T THIS GAME BEING PLAYED AT THE BASIN?!>!?!?" to reasonably significant cheers from the sparse crowd
    Proudly against the bring back Bennett movement since he is injury prone and won't last 5 days.

  2. #2
    International Regular Kippax's Avatar
    Join Date
    Jan 2005
    Location
    Central Districts
    Posts
    3,126
    I'd need a way to play without me having any comps with Excel on them anymore, ftr.
    Quote Originally Posted by The Feral Abacus View Post
    Another exaggerated personality stereotype conspiracy brought to you by Kippax.
    NZ RAIN RADAR . TAB CRICKET OPTIONS . KIPPAX CRICKET . DOOR TO THE VAULT

  3. #3
    Cricketer Of The Year Hurricane's Avatar
    Join Date
    Aug 2009
    Location
    Stopping the AFL spreading to NZ
    Posts
    9,715
    Quote Originally Posted by Kippax View Post
    I'd need a way to play without me having any comps with Excel on them anymore, ftr.
    I may be able to make a googledocs spreadsheet for you - would that work? Before I make it will you definitely play?

  4. #4
    JJD Heads Athlai's Avatar
    Duck Hunt Champion! Plops Champion!
    Tournaments Won: 2
    Join Date
    Mar 2007
    Location
    ksfls;fsl:lsFJg/s
    Posts
    27,475
    Aren't you able to just give us the values of the players in the squads and we choose them? Unsure why we need a spreadsheet.
    Direbirds FTW!

    Quote Originally Posted by Athlai View Post
    Wellington will win the whole thing next year. Mark my words.
    Quote Originally Posted by Flem274* View Post
    I'll offer up my avatar to Athlai forever if Wellington wins the Champions League.
    President of T.I.T.S
    Tamim Is Talented Society


  5. #5
    International Debutant ohnoitsyou's Avatar
    Join Date
    Nov 2012
    Location
    Hamilton, city of well....
    Posts
    2,230
    When i read it originally i thought everyone submitted a team, then 'costs' were assigned based on the number of times people picked, then we re-picked.

  6. #6
    International Debutant ohnoitsyou's Avatar
    Join Date
    Nov 2012
    Location
    Hamilton, city of well....
    Posts
    2,230
    Someone who's good at this sort of stuff figure out where Hurricanes messed up the weightings and game the system

  7. #7
    JJD Heads Athlai's Avatar
    Duck Hunt Champion! Plops Champion!
    Tournaments Won: 2
    Join Date
    Mar 2007
    Location
    ksfls;fsl:lsFJg/s
    Posts
    27,475
    Cribb to just tell me the best CPL team

  8. #8
    International Regular Kippax's Avatar
    Join Date
    Jan 2005
    Location
    Central Districts
    Posts
    3,126
    Quote Originally Posted by Hurricane View Post
    I may be able to make a googledocs spreadsheet for you - would that work? Before I make it will you definitely play?
    Just trying something here at my end, to let me participate. I'll get back to you.

  9. #9
    International Regular Kippax's Avatar
    Join Date
    Jan 2005
    Location
    Central Districts
    Posts
    3,126
    Okay, so that's sort of a WindieWeathers team. I'll touch it up and lock it in on Sunday.


  10. #10
    Dan
    Dan is offline
    Global Moderator / Cricket Web Staff Member Dan's Avatar
    Join Date
    Apr 2007
    Location
    A small planet somewhere in the vicinity of Betelgeuse
    Posts
    6,200
    If I'm picking a 'keeper as a non-keeper, do I mark them as a 'keeper?

    And if they're BJ Watling, do I only count his 54 'keeper catches, or all 64 of his career ones?
    My sworn enemy:
    Quote Originally Posted by Hurricane View Post
    I hate s smith.
    Quote Originally Posted by Hurricane View Post
    I give out points for style of which Steve(n) Smith has none.

  11. #11
    International Regular Kippax's Avatar
    Join Date
    Jan 2005
    Location
    Central Districts
    Posts
    3,126
    Nah Watling isn't allowed to become an option in the piss-weak openers' positions. People will pick McCullum there next.

  12. #12
    Dan
    Dan is offline
    Global Moderator / Cricket Web Staff Member Dan's Avatar
    Join Date
    Apr 2007
    Location
    A small planet somewhere in the vicinity of Betelgeuse
    Posts
    6,200
    The agribusiness will make him into an opener again. Just you watch.

    Name Points
    1. Kieran Powell
    2. BJ Watling
    3. Kane Williamson
    4. Darren Bravo
    5. Brendon McCullum
    6. Denesh Ramdin +
    7. Mark Craig
    8. Tim Southee
    9. Kemar Roach
    10. Trent Boult
    11. Shane Shillingford
    42.54
    140.12
    133.34
    216.19
    183.09
    125.35
    0.00
    149.10
    165.40
    175.10
    109.30
    Total 1440.25

  13. #13
    International Regular Kippax's Avatar
    Join Date
    Jan 2005
    Location
    Central Districts
    Posts
    3,126
    Yep, good team. It's so difficult for Chanders to play to his handicap, even at Sodhi Oaks Country Club. I may've made an error there.

  14. #14
    Hall of Fame Member Howe_zat's Avatar
    Join Date
    Nov 2010
    Location
    Top floor, bottom buzzer
    Posts
    16,038
    Bashed one together

    And we still haven't walked in the glow of each other's majestic presence.

  15. #15
    Hall of Fame Member Howe_zat's Avatar
    Join Date
    Nov 2010
    Location
    Top floor, bottom buzzer
    Posts
    16,038
    fun fact: all Sodhi's points are from batting

Page 1 of 7 123 ... LastLast


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Spreadsheet Exercise
    By Hurricane in forum Cricket Chat
    Replies: 28
    Last Post: 23-10-2011, 03:22 AM
  2. How bad are the Windies
    By Jigga988 in forum Cricket Chat
    Replies: 129
    Last Post: 15-12-2008, 10:04 AM
  3. Retrieving Saved over Excel spreadsheet?
    By Mard in forum Off Topic
    Replies: 6
    Last Post: 12-11-2008, 02:28 AM
  4. Windies grounds
    By brockley in forum Cricket Chat
    Replies: 12
    Last Post: 18-02-2007, 03:55 PM
  5. Windies win
    By dro87 in forum ICC Champions Trophy 2004
    Replies: 26
    Last Post: 27-09-2004, 07:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •