2013 CQ Game Classics Edition - Page 7 - CyclingNews Forum

Go Back   CyclingNews Forum > Road > Games and Fantasy Cycling

Games and Fantasy Cycling Come in and talk about betting, computer games and cycling simulations, and your office's or online fantasy cycling leagues.

Reply
 
Thread Tools Display Modes
  #61  
Old 02-16-13, 21:45
J-King J-King is offline
Junior Member
 
Join Date: Sep 2012
Posts: 16
Default

I have the same problem, the scores don't come up automatically.
Reply With Quote
  #62  
Old 02-16-13, 21:55
Caruut's Avatar
Caruut Caruut is offline
Senior Member
 
Join Date: Oct 2011
Posts: 2,190
Default

Quote:
Originally Posted by mutschi View Post
Thanks, that is what I am asking. There are possible two ways and I wonder which one it is:
1. Example: Gilbert has 1000 points on 31/12/2012. Gilbert has 1800 Points after last Classics Race (L-B-L). Score: 800 Points

2. Gilbert has 1000 points on 31/12/202. He wins four WT Classics each 280 points = 1060 points.

Case one takes into account how he performed last year. Case two does not take into account last year. Which one is it?

Also, I klicked the link for the team entry list and downloaded the list but it is not working as there is no "2012 Results" Sheet attached to the "Your Team" Sheet, therefore the Vlookup Formula does not work. It looks like you guy have no problems so what do I do wrong? I also tried to enter riders on the web-page of the link (not downloading) but I can't do that either. Typing won't work. Clueless

Offredo was banned last year. What would be his starting points? I guess his 2011 end points but how can I get it without the entry list?

Cheers
It is neither. Hugo puts together a list of ~15 races, and adds up the CQ scored by each rider in those races.

I thought the sheet didn't work until I put the names in right. Make sure it's written CANCELLARA Fabian. Just checked and Offredo needs to be spelled OFFREDO Yoann to work, and appears to have a points value of 295.
Reply With Quote
  #63  
Old 02-16-13, 21:56
al_pacino al_pacino is offline
Senior Member
 
Join Date: Jun 2009
Posts: 269
Default

are you using the right format. for example

RODRIGUEZ OLIVER Joaquim

?
Reply With Quote
  #64  
Old 02-16-13, 22:02
the asian's Avatar
the asian the asian is offline
Senior Member
 
Join Date: Jan 2011
Location: Colombo
Posts: 3,294
Default

Copy paste the names from CQ ranking.
Reply With Quote
  #65  
Old 02-17-13, 08:55
the asian's Avatar
the asian the asian is offline
Senior Member
 
Join Date: Jan 2011
Location: Colombo
Posts: 3,294
Default

I'm having a really hard time picking my team, Some very tough choices to make.
Reply With Quote
  #66  
Old 02-17-13, 12:08
al_pacino al_pacino is offline
Senior Member
 
Join Date: Jun 2009
Posts: 269
Default

Quote:
Originally Posted by the asian View Post
I'm having a really hard time picking my team, Some very tough choices to make.
I agree. Very difficult to get the balance.
Reply With Quote
  #67  
Old 02-17-13, 14:31
Hugo Koblet's Avatar
Hugo Koblet Hugo Koblet is offline
Senior Member
 
Join Date: May 2010
Posts: 3,774
Default

Re points: The point system can be seen here under points: http://www.cqranking.com/men/asp/gen/rules.asp

So if Michael Rasmussen wins Paris-Roubaix he earns 280 points etc.

Re the Excel file: It should work. As someone mentioned, make sure you spell the name exactly as it is spelled on cqranking.com.

Re ex-dopers: Their value is equal to that of their last full season. So for instance, Contador costs 2272 because his last season unaffected by his suspension was 2009 in which he scored 2272 points.
__________________
Quote:
Originally Posted by Ryo Hazuki View Post
contador is such a coward
Reply With Quote
  #68  
Old 02-17-13, 21:27
mutschi mutschi is offline
Senior Member
 
Join Date: Jul 2009
Posts: 138
Default

Thanks for the tips. Table works now with the names right.

So the riders just score in each race according to the CQ Ranking points. It doesn't matter how they performed the year before in that same race? I guess, this is reflected by their CQ ranking on 31/12/2013.

Last question (hopefully). If I use a rider that was banned in 2012 I have to use his 2011 score (Last full season). Do I have to find that score myself on the CQ web-page or did Hugo already adjust that value when I type the name in. For Example, is Offredos value, mentioned above, the right one?

Cheers
Reply With Quote
  #69  
Old 02-17-13, 21:35
the asian's Avatar
the asian the asian is offline
Senior Member
 
Join Date: Jan 2011
Location: Colombo
Posts: 3,294
Default

Quote:
Originally Posted by mutschi View Post
Thanks for the tips. Table works now with the names right.

So the riders just score in each race according to the CQ Ranking points. It doesn't matter how they performed the year before in that same race? I guess, this is reflected by their CQ ranking on 31/12/2013.

Last question (hopefully). If I use a rider that was banned in 2012 I have to use his 2011 score (Last full season). Do I have to find that score myself on the CQ web-page or did Hugo already adjust that value when I type the name in. For Example, is Offredos value, mentioned above, the right one?

Cheers
It is adjusted in the excel sheet.
Reply With Quote
  #70  
Old 02-18-13, 08:00
Hugo Koblet's Avatar
Hugo Koblet Hugo Koblet is offline
Senior Member
 
Join Date: May 2010
Posts: 3,774
Default

Quote:
Originally Posted by mutschi View Post
Thanks for the tips. Table works now with the names right.

So the riders just score in each race according to the CQ Ranking points. It doesn't matter how they performed the year before in that same race? I guess, this is reflected by their CQ ranking on 31/12/2013.

Last question (hopefully). If I use a rider that was banned in 2012 I have to use his 2011 score (Last full season). Do I have to find that score myself on the CQ web-page or did Hugo already adjust that value when I type the name in. For Example, is Offredos value, mentioned above, the right one?

Cheers
Yeah, it doesn't matter how the rider performed the previous year. And yes, I have adjusted all riders in the Excel file
__________________
Quote:
Originally Posted by Ryo Hazuki View Post
contador is such a coward
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 23:56.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Copyright 2006 - 2009 Future Publishing Limited. All rights reserved. Future Publishing Limited is part of the Future plc group. Future Publishing Limited is a company registered in England and Wales with company registration number 2008885 whose registered office is at Beauford Court 30 Monmouth Street Bath, UK BA1 2BW England.