|
UCPCL Draft Thread - Round 13+14
|
| baggieboys32 |
Posted on 07-12-2012 14:27
|
Sprinter
Posts: 1981
Joined: 01-10-2011
PCM$: 200.00
|
All you lovely people, After talking to themanxmissile, I've put together this file which shows every 'real' rider available in the draft. It also contains the nationality, and D.o.B, and you can sort the riders by any variable you like, should make it easier for everyone to put together a shortlist 
Here's the first file, and at the end of every round in the draft, I'll be uploading a new file where I've removed every rider whose been drafted.
https://www.mediafire.com/view/?7432j4...47v41avv26
Edited by baggieboys32 on 07-12-2012 14:32
|
| |
|
|
| SSJ2Luigi |
Posted on 07-12-2012 14:34
|
World Champion
Posts: 11971
Joined: 21-07-2012
PCM$: 400.00
|
is it for the full draft or only the first three rounds?
|
| |
|
|
| baggieboys32 |
Posted on 07-12-2012 14:38
|
Sprinter
Posts: 1981
Joined: 01-10-2011
PCM$: 200.00
|
This has no limits on it, it contains every rider in the 1.3.0.0 Dailydb
Each Round I will produce a new file which applies to that round in the draft
|
| |
|
|
| Atlantius |
Posted on 07-12-2012 14:50
|
Team Leader
Posts: 6795
Joined: 21-07-2010
PCM$: 200.00
|
Wonderful.
There seems to be errors in some of the D.O.B.'s - at least Hushovd is written as born in 1988 (nit that I would mind  )
|
| |
|
|
| baggieboys32 |
Posted on 07-12-2012 16:04
|
Sprinter
Posts: 1981
Joined: 01-10-2011
PCM$: 200.00
|
I know the algorithm for converting the D.O.B to a date from a number didn't work perrfectly, but about 98% are correct and between making that change, and changing country id's to a useable format took forever, so i'm afraid they're unlikely to get edited
|
| |
|
|
| Ollfardh |
Posted on 07-12-2012 16:12
|
World Champion
Posts: 14563
Joined: 08-08-2011
PCM$: 9100.00
|
I get an error opening your file, any advice?
Changed my sig, this was getting absurd.
|
| |
|
|
| Ad Bot |
Posted on 22-11-2024 01:18
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| juszta |
Posted on 07-12-2012 16:18
|
Protected Rider
Posts: 1175
Joined: 24-07-2012
PCM$: 200.00
|
@Ollfardh
You probably have the 2003 version of Excel or some other similar program (open office, etc.), which can't always handle .xlsx files.
So you might have to convert the file to .xls
You can get any converter, or do it online (for example on www.zamzar.com )
Edited by juszta on 07-12-2012 16:18
|
| |
|
|
| Ollfardh |
Posted on 07-12-2012 16:46
|
World Champion
Posts: 14563
Joined: 08-08-2011
PCM$: 9100.00
|
Thanks!
And darn Gilbert sucks in this DB 
Changed my sig, this was getting absurd.
|
| |
|
|
| SSJ2Luigi |
Posted on 07-12-2012 16:50
|
World Champion
Posts: 11971
Joined: 21-07-2012
PCM$: 400.00
|
Ollfardh wrote:
darn Gilbert sucks in this DB
Gilbert sucked in the first half of the season (imo in the whole season, winning only +/- 2 stages and the worlds isn't enough)
|
| |
|
|
| TheManxMissile |
Posted on 07-12-2012 16:53
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
Ollfardh wrote:
And darn Gilbert sucks in this DB
If by sucks you mean, can still win any hilly race and is in the top 15 riders then yes, he sucks 
Its also like Voeckler being in the top15 as well... sometimes the daily stats look odd, but the results cant be matched
|
| |
|
|
| Ollfardh |
Posted on 07-12-2012 16:55
|
World Champion
Posts: 14563
Joined: 08-08-2011
PCM$: 9100.00
|
SSJ2Luigi wrote:
Ollfardh wrote:
darn Gilbert sucks in this DB
Gilbert sucked in the first half of the season (imo in the whole season, winning only +/- 2 stages and the worlds isn't enough)
Out of shape doesn't mean bad
But I didn't want to start a discussion here, carry on 
Changed my sig, this was getting absurd.
|
| |
|
|
| dev4ever |
Posted on 07-12-2012 17:03
|
Small Tour Specialist
Posts: 2282
Joined: 13-03-2011
PCM$: 200.00
|
Maybe a stupid question, but will it be easily possible to renew contracts? (after a year, ofcourse)
Really don't want to lose Contador, for exempel
|
| |
|
|
| TheManxMissile |
Posted on 07-12-2012 17:08
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
dev4ever wrote:
Maybe a stupid question, but will it be easily possible to renew contracts? (after a year, ofcourse)
Really don't want to lose Contador, for exempel
Depends on many things.
It could be easy, it could be impossible.
|
| |
|
|
| ste_18 |
Posted on 07-12-2012 18:43
|
Protected Rider
Posts: 1430
Joined: 06-08-2012
PCM$: 200.00
|
Great job baggie this could be very useful. |
| |
|
|
| sutty68 |
Posted on 07-12-2012 23:43
|
Tour de France Champion
Posts: 34654
Joined: 22-08-2010
PCM$: 200.00
|
It won't let me download the base file, it says it is unavailable |
| |
|
|
| TheManxMissile |
Posted on 07-12-2012 23:48
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
The file has also/will be attached to the post containing the round order
so if you cant download it, its there
|
| |
|
|
| fcancellara |
Posted on 08-12-2012 00:31
|
Grand Tour Specialist
Posts: 5194
Joined: 18-08-2011
PCM$: 200.00
|
Baggie, very nice and very useful, thanks
|
| |
|
|
| SSJ2Luigi |
Posted on 08-12-2012 00:33
|
World Champion
Posts: 11971
Joined: 21-07-2012
PCM$: 400.00
|
according to the file, degenkolb is 39 years old.
I'm pretty sure that is not right
|
| |
|
|
| Atlantius |
Posted on 08-12-2012 00:39
|
Team Leader
Posts: 6795
Joined: 21-07-2010
PCM$: 200.00
|
SSJ2Luigi wrote:
according to the file, degenkolb is 39 years old.
I'm pretty sure that is not right
baggieboys32 wrote:
I know the algorithm for converting the D.O.B to a date from a number didn't work perrfectly, but about 98% are correct and between making that change, and changing country id's to a useable format took forever, so i'm afraid they're unlikely to get edited
|
| |
|
|
| SSJ2Luigi |
Posted on 08-12-2012 00:40
|
World Champion
Posts: 11971
Joined: 21-07-2012
PCM$: 400.00
|
Atlantius wrote:
SSJ2Luigi wrote:
according to the file, degenkolb is 39 years old.
I'm pretty sure that is not right
baggieboys32 wrote:
I know the algorithm for converting the D.O.B to a date from a number didn't work perrfectly, but about 98% are correct and between making that change, and changing country id's to a useable format took forever, so i'm afraid they're unlikely to get edited
I knew that but I thought that was kinda funny. and somehow Breschel is 41
|
| |
|
![imgur.com/KlJUqDx.jpg[/img[img]]https://imgur.com/yUygrQ.jpg](https://imgur.com/KlJUqDx.jpg[/img[img]]https://imgur.com/yUygrQ.jpg)
