Tour-Only VDS Reminder... And An Update!
by Chris Fontecchio on Jun 29, 2009 12:43 PM EDT
in FSA Directeur Sportif
Email
PrintAs you recall, in an historic development last week we opened the Tour de France-Only Virtual Directeur Sportif to all PdC members, not just the ones who were too lazy to join the yearlong battle royale. In that regard, here's an important update: I fixed the spreadsheet!
You'll recall, the first version didn't recognize the changed rider values for about 30 guys, which meant making a manual tally. Now it works automatically, as long as you select riders by using the dropdown button (as opposed to keying in the name yourself). Incidentally, I replaced the older one with the updated one, so were you to access this file through the original announcement you'd be working with the new one regardless. For the dozen or so teams who have already submitted their entry, don't worry about sending in a new one, I can handle your submission as long as you followed the directions. 
Now for some reminders:
- Deadline is this Friday, July 3, Noon Pacific time!
- Don't forget to verify your submission carefully. Check the rules!
- If you have already sent in a submission, you can make changes up until the deadline.
- Email your submission to tourbecco@yahoo.com
- First prize is looking better, thanks to some donations. Up the ante through Paypal (podiumcafe@yahoo.com)!
Tourbecco says: "What are you waiting for? It's free!"
47 comments
|
0 recs |
Do you like this story?
Comments
yeah
when i have a time i will send. This needs precisions calculations :P.
I just decide to include a rule in my team. I decided to only choose riders that i don’t have in my VDS Team’s season.
Me too. Gives me ten more guys to root for in the Tour.
I can't understand why people cheat--Mark Cavendish
Impossible
You can never bring yourself to exclude Rui Costa.
"Where there’s a will, there’s a way.": Alberto Contador, shortly after waking up from brain surgery.
I sacrificed, so can you
I decided not to include Thomas Lövkvist in my TdF-team. You will just have to do the same with Costa.
ok
to compensate, i will name my team noCosta!!
by semprenaroda on Jun 30, 2009 3:50 PM EDT up reply actions
Hm, just send mine in using the old spreadsheet
but it appears that, since I copied over the point values rather than rely on the macros, it should be ok…
You know that you'll get caught later, sent to your room without supper and have to give him back
copy the formula from I5 into I4 and you’ll feel so much better about yourself.
Hurry up Boonen decision..
all i’m waiting on…
"the rest was over 30. And that doesn't mean old and useless, but experienced and with the stamina"
Jens! Voigt, Crit Intl Interview, 2009
Fyi
fictional characters won’t be running the spreadsheets.
Your power is turning our darkness to dawn,
Roll on Columbia, Roll on!
by Chris Fontecchio on Jun 30, 2009 1:41 AM EDT up reply actions
Idiot alert
What is a dropdown button and how do I sue it?
by LurkerMcLurkerson on Jun 29, 2009 9:39 PM EDT reply actions
click in the white box where the names should go.. Hey weall have bad days!!
a arrow on the right hand side should appear, click and Wala!!
you will get the complete list of names.. then make your choice!!!
"the rest was over 30. And that doesn't mean old and useless, but experienced and with the stamina"
Jens! Voigt, Crit Intl Interview, 2009
Tried that
No arrow. I’m using a mac, so that might be it. I’ll just do it by hand then.
by LurkerMcLurkerson on Jun 30, 2009 12:15 AM EDT up reply actions
Hmm weird, at the worst just write in the names and that will do
if you don’t know how to spell them look it up on the rider sheet on the spreadsheet.
I've noticed that the macros don't work so well
on Excel for Mac, so you’re probably right.
The Mac is new
And I’d never rule out (my own) incompetence.
Hey, maybe I should get a job with the UCI…
by LurkerMcLurkerson on Jun 30, 2009 4:56 AM EDT up reply actions
"the mac is new"
What I meant by that was I’m still learning how to use it. I’ve been a PC gal up until now.
by LurkerMcLurkerson on Jun 30, 2009 4:57 AM EDT up reply actions
I don't know if Excel on the Mac has this
but put the cursor in the first box where the names should be appearing then go to the “Data” menu and click on “Validation” On the “Settings” tab, the box saying “Allow” should be set on “List” and the box saying “Source” should read “=AlphaRiderList” Or if that’s too fiddly then just copy and paste. The consolidation stuff kicks out any entry with names that it doesn’t recognise, so unless you misspell Contador as Karpets then you should be OK
I love this initiative
Selecting riders for a TdF is a lot of fun. Plenty of bargains to hunt for.
"Where there’s a will, there’s a way.": Alberto Contador, shortly after waking up from brain surgery.
6
and 3 0-pointers. Cheap team!
"Where there’s a will, there’s a way.": Alberto Contador, shortly after waking up from brain surgery.
Cheap team - but their website has launched its own competition (best I've found so far)
You go to their home page and the first thing that appears is an invitation to join their comp (also has it’s own tab if your internet settings are more sophisticated than mine) Can win a team race bike, signed jersery and other “lesser prizes” by naming the first three skil riders home on each stage. Now that’s what I call a lottery!
Adds a whole new dimension when following the race though.
Cavendish - "le Mozart du onze-dents" (the Mozart of the 11-tooth sprocket) – L’Equipe
I saw that too
Thought about making a post about it but it might be too obscure for the general taste around here.
"Where there’s a will, there’s a way.": Alberto Contador, shortly after waking up from brain surgery.
I don't have Excel, now what?
I volunteered to make this whole thing into a web app with lots of automated goodness, but Chris said it wasn’t necessary. Oh well, maybe next year.
i thought i had heard that there was an internet version of excel
but now i can’t find the link. i do know there are programs out there that will let you read the file (but not change it, i don’t think…)
Google Docs perhaps?
Staring at the swim team gets you killed by a gang of dancing ninja men who know how to twirl.
by TheFigurehead on Jun 30, 2009 12:50 PM EDT up reply actions
Open Office is supposed to have a spreadsheet that's compatible with Excel.
I’ve never used it, though, so can’t vouch for it personally. Open Office site here.
I can't understand why people cheat--Mark Cavendish
It works but Microsoft Word is 10 times better..
I never thought I would say that
Crashdan: "Veni Vidi Vici beats Wing Kong Exchange... … and I’ll change my signature to a backwards smile for a month."
Frining "It's what he thinks.. But he always do.. I eat my shoe if he ride top 15 in le Tour" about Devolder
just put the names in an email
I can do the rest.
Your power is turning our darkness to dawn,
Roll on Columbia, Roll on!
by Chris Fontecchio on Jun 30, 2009 2:53 PM EDT up reply actions
You could probably use visicalc for this one
(should you have a copy knocking around), or any other spreadsheet programme you can get your hands on. The routines that put it all together just read the rider names from cells H4-H13 then compare the names to a master file and run a few validation checks. If you copy and paste the names then you’ll get through that bit OK. They then pick up the team name, DS (a second chance to come up with a crap pun) and your log-on here from cells H32, H33 and H34. Everything else gets ignored.
BOOM!
That sound you heard was Tourbecco’s inbox receiving my winning VDS entry! Don’t be alarmed. Just be discouraged.
How much is Fumi Beppu?
Got a good feeling about this Japanese cat!
Racing for Victory and Free Beer!
For an overview of VDS costs of all TdF riders
go here
Thanks AndrewP.
Made selecting 1-4 pointers a lot easier!
"Where there’s a will, there’s a way.": Alberto Contador, shortly after waking up from brain surgery.
TdF VDS results posted when??
J can’t wait to see The Angry Elf Team in first place and all the accolades that that Phil and Paul will spew about it.
Comments For This Post Are Closed
Secondary Sidebar
User Tools
FanPosts
Community blog posts and discussion.
Recommended FanPosts
Recent FanPosts
Celebrate the Giro d'Italia at Podium Cafe!
Check our Giro Section for race updates, on-the-scene reports, and other hijinx.
Featured Stories
FanShots
Quick hits of video, photos, quotes, chats, links and lists that you find around the web.
Recent FanShots
