ICL17 - General | Development
|
jserna735 |
Posted on 25-07-2016 18:01
|
Under 23
Posts: 80
Joined: 02-07-2015
PCM$: 200.00
|
Bikex wrote:
Round 3 of Free Agents: https://www.mediafire.com/download/9zt...nts+3.xlsx
Teams that need to be filled yet:
Filliers - Mora Pro Cycling Team
Feryn Bikes
Fast N' Loud Cycling Project
Sugoi - Xanterra
Allianz Cycling Team
Celesio Pro Cycling
CarbonSports Cycling - Lightweight
Italo - Ventilair
Fiskars Cykling
Leopard - Evonik Pro Cycling
Team Alitalia
TVM Cycling Team
Team Renova
Santos - Euskadi
The Spark Project p/b Bollé
Team Peugeot
Lufthansa IN Racing
Aeropostal Venezuela Ciclismo
Team Coldeportes
Teams that still need to sign riders for their dev team still:
Feryn Bikes
Celesio Pro Cycling
I hope to get a message from at least all of those teams even the ones that were not so active the last round. No fix deadline for now as the season can only start mid August anyways as I'm quite busy with exams until then.
This is the last round, please try to fill your team here. If you fail to do so you are still allowed to pick left over riders from the Free Agency afterwards.
So the rider's wage, when i enter it, is actually multiplying the amount of wage budget remaining by 5.
Manager of Team Coldeportes ICL17
|
|
|
|
Ad Bot |
Posted on 26-11-2024 17:01
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
the_hoyle |
Posted on 25-07-2016 18:29
|
Grand Tour Champion
Posts: 7651
Joined: 28-05-2009
PCM$: 200.00
|
I hope it has been ok that I have not bid since r1 - I have no budget and a full team
.: Manager of :.
.: My Awards :.
|
|
|
|
brewers90 |
Posted on 25-07-2016 19:37
|
Classics Specialist
Posts: 3711
Joined: 01-09-2010
PCM$: 200.00
|
What he said. ^
|
|
|
|
OZrocker |
Posted on 26-07-2016 08:36
|
Protected Rider
Posts: 1280
Joined: 21-07-2012
PCM$: 300.00
|
jserna735 wrote:
So the rider's wage, when i enter it, is actually multiplying the amount of wage budget remaining by 5.
I've had the same error, if you remove the *5;"" from the formula in L3 it should work. My sheet now has
=IF(J2<>"";L2-SUM(E$1:E$1048576)) in that cell if that helps.
When I first opened the file it appeared that all of row 3 on the transfers tab wasn't working properly, but now I have this issue instead. I assume something went wrong while fixing the first issue?
EDIT:I think it might have been caused by taking out the 'sacking' option that we had before this round.
Edited by OZrocker on 26-07-2016 08:45
|
|
|
|
DiCyc |
Posted on 26-07-2016 09:00
|
Sprinter
Posts: 1636
Joined: 09-03-2015
PCM$: 200.00
|
How many riders are the maximum permitted for a CT team? |
|
|
|
Bikex |
Posted on 26-07-2016 11:20
|
Team Leader
Posts: 7257
Joined: 25-08-2012
PCM$: 600.00
|
Yes the file was messed up, I've now replaced it on the same link with an updated version. Either download this or OZrocker's solution also works. He's right that this was because removing the sacking option.
Sorry I don't really have much time these days.
@DiCyc: There is no maximum |
|
|
|
Bikex |
Posted on 29-07-2016 13:23
|
Team Leader
Posts: 7257
Joined: 25-08-2012
PCM$: 600.00
|
I'm kind of disappointed by the amount of PMs I received for round 3, only about 10. If you are on the list I posted above please send something in. |
|
|
|
krisa |
Posted on 29-07-2016 19:49
|
Classics Specialist
Posts: 3962
Joined: 12-04-2011
PCM$: 200.00
|
I do not want more riders and I do not have money
|
|
|
|
matt17br |
Posted on 29-07-2016 20:14
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
You need to have at least 24 riders tho
|
|
|
|
krisa |
Posted on 29-07-2016 20:56
|
Classics Specialist
Posts: 3962
Joined: 12-04-2011
PCM$: 200.00
|
Nope 18 I'm CT
|
|
|
|
SSJ2Luigi |
Posted on 29-07-2016 20:59
|
World Champion
Posts: 11971
Joined: 21-07-2012
PCM$: 400.00
|
brb, disbanding and forming two teams for CT level
|
|
|
|
jandal7 |
Posted on 30-07-2016 05:41
|
World Champion
Posts: 11395
Joined: 17-12-2014
PCM$: 1020.00
|
dw you'll be there next year
Edited by jandal7 on 30-07-2016 06:56
24/02/21 - kandesbunzler said “I don't drink famous people."
15/08/22 - SotD said "Your [jandal's] humour is overrated"
11/06/24 - knockout said "Winning is fine I guess. Truth be told this felt completely unimportant."
[ICL] Santos-Euskadi | [PT] Xero Racing
5x x5
2x x2
2x x2
|
|
|
|
SSJ2Luigi |
Posted on 30-07-2016 11:05
|
World Champion
Posts: 11971
Joined: 21-07-2012
PCM$: 400.00
|
I love that people keep saying it despite imo I have my best team ever
|
|
|
|
Bikex |
Posted on 30-07-2016 17:31
|
Team Leader
Posts: 7257
Joined: 25-08-2012
PCM$: 600.00
|
Just 2 teams left, that haven't filled their teams and not sent anything in for this round. I'll give them 24 more hours before closing the round. |
|
|
|
Bikex |
Posted on 31-07-2016 17:33
|
Team Leader
Posts: 7257
Joined: 25-08-2012
PCM$: 600.00
|
I have basically finished the calendar, this is what it will look like:
WT
Spoiler Palm Classic | UAE | 111 | 111 | 1 | Tour of Toowoomba | Australia | 123 | 127 | 5 | Vuelta Ciclista al Pais Vasco | Spain | 222 | 227 | 6 | Omloop Het Nieuwsblad | Belgium | 301 | 301 | 1 | Strade Bianche | Italy | 305 | 305 | 1 | Vuelta a Tachira | Venezuela | 309 | 318 | 10 | Milano - Sanremo | Italy | 322 | 322 | 1 | E3 Prijs Vlaanderen - Harelbeke | Belgium | 328 | 328 | 1 | Gent - Wevelgem | Belgium | 330 | 330 | 1 | Ronde van Vlaanderen | Belgium | 404 | 404 | 1 | Ster ZLM Tour | Netherlands | 406 | 410 | 5 | Paris - Roubaix | France | 412 | 412 | 1 | Trofeo Campania | Italy | 421 | 421 | 1 | Amstel Gold Race | Netherlands | 423 | 423 | 1 | La Flèche Wallonne | Belgium | 425 | 425 | 1 | Liège - Bastogne - Liège | Belgium | 428 | 428 | 1 | University of Lincoln GP | Britain | 505 | 505 | 1 | Giro d'Italia | Italy | 509 | 529 | 21 | Deutschland Tour | Germany | 602 | 609 | 8 | Vuelta a Guatemala | Guatemala | 603 | 608 | 6 | Tour of Mount Fuji | Japan | 605 | 609 | 5 | Asmara Cup | Eritrea | 701 | 701 | 1 | Tour de France | France | 701 | 721 | 21 | Tour of Northern Europe | Sweden | 807 | 814 | 8 | Vattenfall Cyclassics | Germany | 822 | 822 | 1 | Eneco Tour | Belgium | 824 | 830 | 7 | Vuelta a España | Spain | 901 | 921 | 21 | Course de la Paix | Czech Republic | 916 | 921 | 6 | Quebec Sprint Challenge | Canada | 923 | 923 | 1 | Virginia Chrono Tour | USA | 927 | 930 | 4 | Bucaramanga Classic | Colombia | 1003 | 1003 | 1 | Paris - Tours | France | 1005 | 1005 | 1 | Il Lombardia | Italy | 1012 | 1012 | 1 | World TTT Championships | TBA | 1024 | 1024 | 1 |
CT.1
Spoiler La Tropicale Amissa Bongo | Gabon | 121 | 127 | 7 | Vuelta a Mallorca | Spain | 213 | 216 | 4 | Clasica di Tirreno - Adriatico | Italy | 303 | 303 | 1 | Roma Maxima | Italy | 307 | 307 | 1 | Paris - Nice | France | 311 | 318 | 8 | Istrian Spring Trophy | Croatia | 320 | 323 | 4 | Dwars door Vlaanderen | Belgium | 325 | 325 | 1 | Wallonië Prijs | Belgium | 407 | 407 | 1 | Giro del Trentino | Italy | 416 | 420 | 5 | Rheden GP | Netherlands | 419 | 419 | 1 | Colombia Team GP | Colombia | 430 | 430 | 1 | Tour des Fjords | Norway | 525 | 528 | 4 | La Jurassaine | Switzerland | 601 | 601 | 1 | Tour de Suisse | Switzerland | 612 | 620 | 9 | Int. Österreich-Rundfahrt | Austria | 702 | 709 | 8 | Tour of Vancouver | Canada | 724 | 730 | 7 | Clasica Ciclista San Sebastian | Spain | 801 | 801 | 1 | World Ports Classic | Netherlands | 802 | 803 | 2 | Tour de Pologne | Poland | 805 | 811 | 7 | Baltic Chain Tour | Latvia | 816 | 820 | 5 | USA Pro Cycling Challenge | USA | 816 | 822 | 7 | Tour of Britain | Britain | 907 | 914 | 8 | Richmond Criterium | USA | 925 | 925 | 1 | Tre Valli Varesine | Italy | 1001 | 1001 | 1 | Milano - Torino | Italy | 1004 | 1004 | 1 | Giro dell'Emilia | Italy | 1006 | 1006 | 1 | Chrono des Nations | France | 1020 | 1020 | 1 | Japan Cup | Japan | 1022 | 1022 | 1 |
CT.2
Spoiler Tour d'Indonesia | Indonesia | 114 | 119 | 6 | Christchurch - Akaroa | New Zealand | 129 | 129 | 1 | Volta ao Algarve | Portugal | 203 | 206 | 4 | National Capital Tour | Australia | 223 | 226 | 4 | Clasica Iberica | Spain | 302 | 302 | 1 | København Byrundtur | Danmark | 325 | 325 | 1 | Critérium International | France | 328 | 330 | 3 | Tour of South Africa | South Africa | 403 | 413 | 11 | 4 Jours de Dunkerque | France | 423 | 427 | 5 | Tour de Romandie | Switzerland | 502 | 507 | 6 | Amgen Tour of California | USA | 516 | 523 | 8 | Copenhagen - Malmö ITT | Sweden | 530 | 530 | 1 | GP Moscow | Russia | 531 | 531 | 1 | GP Luxembourg | Luxembourg | 610 | 610 | 1 | Tour d'Andorra | Andorra | 612 | 616 | 5 | Rheinland-Pfalz Rundfahrt | Germany | 618 | 622 | 5 | Aleko Vitoša | Bulgaria | 628 | 628 | 1 | Le Géant de Provence | France | 630 | 630 | 1 | Kigali GP | Rwanda | 710 | 710 | 1 | Volta a Portugal | Portugal | 712 | 722 | 11 | Circulo de Juarez | Mexico | 726 | 730 | 5 | RideLondon–Surrey Classic | Britain | 805 | 805 | 1 | Tour do Rio | Brazil | 814 | 814 | 1 | Criterium Hainleite | Germany | 823 | 823 | 1 | Post Danmark Rundt | Danmark | 826 | 831 | 6 | Cigar City Classic | USA | 901 | 901 | 1 | Praha - Karlovy Vary - Praha | Czech Republic | 906 | 906 | 1 | Grand Prix Cycliste de Québec | Canada | 928 | 928 | 1 | Grand Prix Cycliste de Montréal | Canada | 930 | 930 | 1 | Vuelta a Colombia | Colombia | 1008 | 1018 | 11 |
U23
Spoiler Copa America de Ciclismo | Brazil | 111 | 111 | 1 | Tour of Bishkek | Kirgizistan | 208 | 210 | 3 | Paris - Roubaix U23 | France | 327 | 327 | 1 | Ronde van Vlaanderen Espoirs | Belgium | 401 | 401 | 1 | ZLM Tour | Netherlands | 418 | 418 | 1 | GP Palio del Recioto | Italy | 421 | 421 | 1 | Liége - Bastogne - Liège Espoirs | Belgium | 428 | 428 | 1 | Rund um den Finanzplatz U23 | Germany | 501 | 501 | 1 | Giro Valle d'Aosta | Italy | 509 | 514 | 6 | Rutland - Melton | Britain | 526 | 526 | 1 | Tour de Berlin | Germany | 605 | 609 | 5 | Coupe des Nations Ville Saguenay | Canada | 624 | 626 | 3 | Chrono San Michel | France | 723 | 723 | 1 | Mauritius Sun Tour | Mauritius | 817 | 819 | 3 | Cascade Cycling Classic | USA | 902 | 905 | 4 | Tour de l'Avenir | France | 916 | 923 | 8 | Piccolo Lombardia | Italy | 1003 | 1003 | 1 | Paris-Tours Espoirs | France | 1005 | 1005 | 1 |
Removed: La Descente Pavee, La Cote Picarde
Added: Dunkerque, Emilia, Tre Valli, Aleko Vitosa, Richmond Crit, Tour do Rio, Mauritius, Luxembourg
Aleko Vitosa is a cobbled mountain race, Richmond is the WC route, Rio the Olympics, Mauritius is the 3 starting stages of the Tour of SA by tsmoha and GP Luxembourg is a prologue timetrial
Races that changed category: Fleche Wallonne, Paris-Tours -> WT, Milano - Torino -> CT.1
Races that changed length: Deutschland (9->8), Guatemala(8->6), Cascade(6->4)
This calendar is not the final version, though, if you have any ideas or complains please make them clear soon. I might add up to 2 stage races to CT.2 one of them De Panne and the other a mountainous like Oman or San Luis, I'm not sure though. To the WT a one day race could still fit on the calendar, maybe something mountainous, as there is no mountain WT one day race or something with cobbles?
Here is the calendar in an excel file, where you can check clashes better in table 2: https://www.mediafire.com/download/545...endar.xlsx
Transfer round 3 updated DB will be posted soon. |
|
|
|
Bikex |
Posted on 31-07-2016 17:46
|
Team Leader
Posts: 7257
Joined: 25-08-2012
PCM$: 600.00
|
Okay so here is the db for Round 3.1: https://www.mediafire.com/download/4qw...-R3.1.xlsx
I'll PM the lists for Part 2 now, you have 24 hours for that task. If you don't fill your team in that round, you can still sign riders after that round to fill your team.
Budgets:
Spoiler 1 | Vegeta Cycling Team | WT | 270 | 0 | 6 | Filliers - Mora Pro Cycling Team | WT | 920 | 0 | 7 | Illes Balears | WT | 1285 | 0 | 8 | Feryn Bikes | WT | 1175 | 1 | 9 | Fast N' Loud Cycling Project | CT | 5 | 0 | 11 | Sugoi - Xanterra | WT | 130 | 0 | 12 | Allianz Cycling Team | WT | 380 | 1 | 15 | Gaerne - CSF | CT | 135 | 0 | 16 | Celesio Pro Cycling | WT | 0 | 0 | 19 | Bunzl - Centrica | WT | 0 | 0 | 20 | CarbonSports Cycling - Lightweight | WT | 390 | 3 | 23 | Italo - Ventilair | WT | 130 | 1 | 29 | Fiskars Cykling | CT | 0 | 0 | 32 | Team Cymru Wales | CT | 390 | 0 | 34 | SAP - Bianchi | WT | 645 | 0 | 40 | Pedal Africa | CT | 50 | 0 | 41 | Leopard - Evonik Pro Cycling | WT | 460 | 2 | 42 | Team Alitalia | WT | 0 | 0 | 43 | TVM Cycling Team | WT | 25 | 0 | 44 | Suntory Lucozade Sport | WT | 5 | 0 | 45 | Saeco - Cannondale | WT | 35 | 0 | 46 | ICBC Cycling Team | CT | 1320 | 0 | 50 | CCC Sprandi Polkowice | CT | 745 | 0 | 51 | Team Renova | CT | 465 | 0 | 52 | Santos - Euskadi | CT | 5 | 0 | 53 | Sevilla Cycling Team | CT | 0 | 0 | 55 | The Spark Project p/b Bollé | WT | 1915 | 5 | 56 | Specialized World Cycling | CT | 0 | 0 | 58 | Team Peugeot | WT | 240 | 1 | 60 | Team W - Junior | CT | 1170 | 0 | 61 | VisitUkraine p/b Nemiroff | CT | 0 | 0 | 62 | Schuh p/b Wiggle | CT | 380 | 0 | 63 | Lufthansa IN Racing | CT | 0 | 0 | 64 | A1 Cycling Team | CT | 65 | 0 | 65 | Aeropostal Venezuela Ciclismo | CT | 0 | 0 | 66 | Team Heineken - Shell | CT | 1045 | 0 | 67 | Team Coldeportes | CT | 370 | 0 | 68 | Credit Suisse Pro Cycling | CT | 110 | 0 | 69 | Enel Pro Cycling | CT | 800 | 0 |
Edited by Bikex on 31-07-2016 17:53
|
|
|
|
krisa |
Posted on 31-07-2016 17:51
|
Classics Specialist
Posts: 3962
Joined: 12-04-2011
PCM$: 200.00
|
No Driedaagse De panne?
EDIT: Didn't saw the final message
|
|
|
|
AbhishekLFC |
Posted on 31-07-2016 18:03
|
Directeur Sportif
Posts: 11679
Joined: 27-07-2015
PCM$: 1861.50
|
Exactly 18 riders having spent exactly 4850! Don't know whether that's a good thing or a bad thing. Probably a bad thing coz I don't have any spare left for training/research etc.
|
|
|
|
Croatia14 |
Posted on 31-07-2016 18:10
|
Directeur Sportif
Posts: 9099
Joined: 13-03-2013
PCM$: 2100.00
|
some teams seem to plan on massive talent research...and I´m just glad to have brought in my GT domestiques and on the same way cycling legends Evans, Scarponi & Sammy Sanchez
would like de Panne and San Luis for CT.2 - maybe Tatranska Classic as 1-day race or something heavily cobbled...I´d still like the MG Tour du Faso in the WT though (3 stages, mainly cobbled)...
@Abishkek: remember that there are 100 per team for both training and research left
|
|
|
|
AbhishekLFC |
Posted on 31-07-2016 18:31
|
Directeur Sportif
Posts: 11679
Joined: 27-07-2015
PCM$: 1861.50
|
Croatia14 wrote:
@Abishkek: remember that there are 100 per team for both training and research left
Must've misunderstood then! Nice
San Luis for me too...
|
|
|