Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

dwightcharles wrote:

Just a note... I goofed on cell g97 (it wants you to pick the first semifinal again...)
to resolve this...
with G97 selected on 'Data' tab, go to 'Data Tools' then 'Data Validation' ... under 'Settings' tab... in the 'Allow' drop down list, select 'list'.  Then in the 'source' box you can select the cells that will form the drop-down list to choose the match winner.   Please type in N4:N5.

sorry...!

say again?     lol wink

16 Wimby 14 US Open Yoda Cup
16 Wimby 14 RG Alpha Cup
12, 13 & 16 King Droid
15 Naboo Cup 14 Lord Vader- RU

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Yup, this prototype will soon be THE draw sheet over the internet. Then we can create our own website and our own fantasy tennis draw game!

If this works, I suggest we do a "Chewie" comp next year. Playing all 500, 1000 and GS as draw challenges. This would mean 24 event and a very tough competition!

2016: Rey Saber, Lord Vader, Supreme Jedi, Yoda Crew player of the year
2014: Lord Vader, King Droid, Naboo Champion, Yoda Crew player of the year
2013: Yoda Cup Wimbledon champion, Yoda Cup Guru Runner-up
2012: Yoda Cup Wimbledon champion

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

LOL....I got those instructions bang on BHP. wink.......I had that problem earlier and then read Dwight's comments after work.

I did my bracket on my work laptop just now so I'm all good to go now, the last bit Charles refers to is N$4 N$5.

2018 - Princess Leia Champ
2017 - Rey Saber Champ, Padme Champ, Obi Wan R-Up, BIG 5 Career Slam, Yoda Crew Hall Of Fame 2016 - Padme Runner-Up
2015 - Obi Wan Master, King Droid, Yoda Crew POTY 2014 - Guru Race Runner-Up
2013 - Guru Race Winner (2014 Yoda Cup Guru), US Open Yoda Cup, Yoda Crew POTY 2012 - Lord Vader 2011 - Wimbledon Yoda Cup

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

So does the sheet ENTIRELY work now? I don't want to wase time doing my picks if the sheet isn't 100% working wink

2016: Rey Saber, Lord Vader, Supreme Jedi, Yoda Crew player of the year
2014: Lord Vader, King Droid, Naboo Champion, Yoda Crew player of the year
2013: Yoda Cup Wimbledon champion, Yoda Cup Guru Runner-up
2012: Yoda Cup Wimbledon champion

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Ok, if you can do it, so can I.  lol  I will fill out a new bracket and follow the instructions this time.

16 Wimby 14 US Open Yoda Cup
16 Wimby 14 RG Alpha Cup
12, 13 & 16 King Droid
15 Naboo Cup 14 Lord Vader- RU

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Yeah it works in Excel Arnaud, but remember to fix the G97 box with the second semi-final though, Dwight has explained it well, or so I thought anyway.

Once the Yoda Crew get used to it I think it will work great for any bracket comps we want to compete in.

Last edited by Tono--2014-Yoda-Cup-Guru (Mar. 5, 2014 4:41am)

2018 - Princess Leia Champ
2017 - Rey Saber Champ, Padme Champ, Obi Wan R-Up, BIG 5 Career Slam, Yoda Crew Hall Of Fame 2016 - Padme Runner-Up
2015 - Obi Wan Master, King Droid, Yoda Crew POTY 2014 - Guru Race Runner-Up
2013 - Guru Race Winner (2014 Yoda Cup Guru), US Open Yoda Cup, Yoda Crew POTY 2012 - Lord Vader 2011 - Wimbledon Yoda Cup

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Did not work for me at home as I use google docs so could not follow those directions.  ;(

16 Wimby 14 US Open Yoda Cup
16 Wimby 14 RG Alpha Cup
12, 13 & 16 King Droid
15 Naboo Cup 14 Lord Vader- RU

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

I had a similar problem with my home laptop too BHP, the work one has XL so that was all sweet.

Being the defending two-time King Droid means you probably don't care too much whether you make any picks at all eh mate. wink

Last edited by Tono--2014-Yoda-Cup-Guru (Mar. 5, 2014 5:16am)

2018 - Princess Leia Champ
2017 - Rey Saber Champ, Padme Champ, Obi Wan R-Up, BIG 5 Career Slam, Yoda Crew Hall Of Fame 2016 - Padme Runner-Up
2015 - Obi Wan Master, King Droid, Yoda Crew POTY 2014 - Guru Race Runner-Up
2013 - Guru Race Winner (2014 Yoda Cup Guru), US Open Yoda Cup, Yoda Crew POTY 2012 - Lord Vader 2011 - Wimbledon Yoda Cup

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Okay, easy to fix the SF on excel.

2016: Rey Saber, Lord Vader, Supreme Jedi, Yoda Crew player of the year
2014: Lord Vader, King Droid, Naboo Champion, Yoda Crew player of the year
2013: Yoda Cup Wimbledon champion, Yoda Cup Guru Runner-up
2012: Yoda Cup Wimbledon champion

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

ok the correct table is in the thread

I'm posting in a few a video showing how to do your picks

2018: Obi Wan, Rey Saber, R2D2 Crown, C3PO Trophy, Most correct picks Award, Year End #2.
2017: BB-8 Cup, Year End #4.
2016: Padme Cup, Roland Garros Yoda Cup, Leia Tiara, Trophy Case Award, Rey Saber runner up, Year End #3.
2015: Lando Calrissian's Ring, GQ "The Green Anackin".

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

The video is on the thread

2018: Obi Wan, Rey Saber, R2D2 Crown, C3PO Trophy, Most correct picks Award, Year End #2.
2017: BB-8 Cup, Year End #4.
2016: Padme Cup, Roland Garros Yoda Cup, Leia Tiara, Trophy Case Award, Rey Saber runner up, Year End #3.
2015: Lando Calrissian's Ring, GQ "The Green Anackin".

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

oookay so deadline is tomorrow 7 pm GMT. Should you send me your picks first Edu or the opposite? Or almost at the same time? wink

2016: Rey Saber, Lord Vader, Supreme Jedi, Yoda Crew player of the year
2014: Lord Vader, King Droid, Naboo Champion, Yoda Crew player of the year
2013: Yoda Cup Wimbledon champion, Yoda Cup Guru Runner-up
2012: Yoda Cup Wimbledon champion

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

I'll send you and BHP mine, then you can send me yours

2018: Obi Wan, Rey Saber, R2D2 Crown, C3PO Trophy, Most correct picks Award, Year End #2.
2017: BB-8 Cup, Year End #4.
2016: Padme Cup, Roland Garros Yoda Cup, Leia Tiara, Trophy Case Award, Rey Saber runner up, Year End #3.
2015: Lando Calrissian's Ring, GQ "The Green Anackin".

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

I have a kind of technical question : can we block the automatic e-mails the forum sends you when someone reply on a topic you've posted on ?

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Okay fine. Don't worry, take your time. My picks are ready so I don't mind sending the sheet an hour before the deadline if you need more time. Thanks again for doing this, Eduardo ! If you need any help, I'm your 2nd host wink

2016: Rey Saber, Lord Vader, Supreme Jedi, Yoda Crew player of the year
2014: Lord Vader, King Droid, Naboo Champion, Yoda Crew player of the year
2013: Yoda Cup Wimbledon champion, Yoda Cup Guru Runner-up
2012: Yoda Cup Wimbledon champion

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Hey Edu,

well received your e-mail and your spreadsheet. I won't open it till the deadline is past.
I'll send you mine either tonight or tomorrow afternoon (for me, which means in the morning for you).

2016: Rey Saber, Lord Vader, Supreme Jedi, Yoda Crew player of the year
2014: Lord Vader, King Droid, Naboo Champion, Yoda Crew player of the year
2013: Yoda Cup Wimbledon champion, Yoda Cup Guru Runner-up
2012: Yoda Cup Wimbledon champion

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Alright everybody, both BHP and Adunar confirmed they received my picks.

you can all send your picks to me now smile

2018: Obi Wan, Rey Saber, R2D2 Crown, C3PO Trophy, Most correct picks Award, Year End #2.
2017: BB-8 Cup, Year End #4.
2016: Padme Cup, Roland Garros Yoda Cup, Leia Tiara, Trophy Case Award, Rey Saber runner up, Year End #3.
2015: Lando Calrissian's Ring, GQ "The Green Anackin".

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Done!

2016: Rey Saber, Lord Vader, Supreme Jedi, Yoda Crew player of the year
2014: Lord Vader, King Droid, Naboo Champion, Yoda Crew player of the year
2013: Yoda Cup Wimbledon champion, Yoda Cup Guru Runner-up
2012: Yoda Cup Wimbledon champion

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Adunar wrote:

Yup, this prototype will soon be THE draw sheet over the internet. Then we can create our own website and our own fantasy tennis draw game!

If this works, I suggest we do a "Chewie" comp next year. Playing all 500, 1000 and GS as draw challenges. This would mean 24 event and a very tough competition!

Don't want this to get missed...
I think this is a GREAT idea!  24 event draw challenge!

2017 Supreme Jedi, 2017 Lord Vader, 2017 Chivalrous Wookie, 2015 Naboo Champion, 2018 Big Fat Nothing

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

There was once a website doing this. Draws for every Masters 1000 and 500. Of course, there was only one draw challenge if there were two 500 the same week. This means you have to delete three events. So there were 21.

website was tennisdraw.com and we had the Chivalrous Wookie Medal also known as the "Chewie comp"! We could bring it back to life our own way...

2016: Rey Saber, Lord Vader, Supreme Jedi, Yoda Crew player of the year
2014: Lord Vader, King Droid, Naboo Champion, Yoda Crew player of the year
2013: Yoda Cup Wimbledon champion, Yoda Cup Guru Runner-up
2012: Yoda Cup Wimbledon champion

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Yes, I already put a reminder in my calendar to bring this back up.  Let's not forget.  But I think Dwight will have the spread sheet ready to go before that.  smile

16 Wimby 14 US Open Yoda Cup
16 Wimby 14 RG Alpha Cup
12, 13 & 16 King Droid
15 Naboo Cup 14 Lord Vader- RU

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Done!

Quite ill so my picks make no sense whatsoever and have had no time to think, but it's all part of the fun. Might be a stroke of genius in there somewhere.

V impressive spreadsheet.

Will try to rest before I do my Vader picks.

2018 Roland Garros Yoda Cup, Year End #3
2017 Obi Wan Master, Wimbledon Yoda Cup, Year End #2, Yoda Crew Player of the Year
2016 Obi Wan Master, Year End #2
2015 Lord Vader, Roland Garros Yoda Cup

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

You will need your strength to tackle Vader.

16 Wimby 14 US Open Yoda Cup
16 Wimby 14 RG Alpha Cup
12, 13 & 16 King Droid
15 Naboo Cup 14 Lord Vader- RU

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Any sign of the other guys?

2018: Obi Wan, Rey Saber, R2D2 Crown, C3PO Trophy, Most correct picks Award, Year End #2.
2017: BB-8 Cup, Year End #4.
2016: Padme Cup, Roland Garros Yoda Cup, Leia Tiara, Trophy Case Award, Rey Saber runner up, Year End #3.
2015: Lando Calrissian's Ring, GQ "The Green Anackin".

Re: 2014 R2D2 - Little trip into the California Desert - Indian Wells

Haven't heard from Don or Dragan, I thought they both might have be keen to play in this bracket comp but it appears not.

I will send you my picks later Edu, I will send them to my work e-mail first and double check that I haven't forgotten to make a selection or two. wink

2018 - Princess Leia Champ
2017 - Rey Saber Champ, Padme Champ, Obi Wan R-Up, BIG 5 Career Slam, Yoda Crew Hall Of Fame 2016 - Padme Runner-Up
2015 - Obi Wan Master, King Droid, Yoda Crew POTY 2014 - Guru Race Runner-Up
2013 - Guru Race Winner (2014 Yoda Cup Guru), US Open Yoda Cup, Yoda Crew POTY 2012 - Lord Vader 2011 - Wimbledon Yoda Cup