|
ICL15 - General Discussion | Riders Development
|
| Shonak |
Posted on 02-02-2015 09:20
|
Tour de France Champion
Posts: 15615
Joined: 16-07-2013
PCM$: 350.00
|
I like the Tour route, although the TTT in last week really is a potential game changer. Well, what ASO can do, Bikex can do better.  Since Quintana and Froome are both MT82 and Contador 81, I favor anything that helps the outsiders. 
Vuelta is a very punchy affair and with several sprint stages also a bit of newground. I thought about Purito to skip a GT but with this parcours, it's pretty much auto-selection for me at least in Spain.
"It’s a little bit scary when Contador attacks." - Tommy V
|
| |
|
|
| Ad Bot |
Posted on 22-11-2024 09:35
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| Bikex |
Posted on 02-02-2015 13:36
|
Team Leader
Posts: 7255
Joined: 25-08-2012
PCM$: 600.00
|
Thanks for the praise and critique for the GT routes. I see that you especially don't like the TTT of the Tour, but nevertheless I'll keep it. I don't think it will make that much of a difference.
So now to the Race Planning
Please download this sheet: https://www.mediafire.com/download/jvc...nning.xlsm
#1 Open the DB and copy/paste your entire team in the tab "Riders". Replace the example riders that are there.
#2 Go to tab "Teams". Look for the column with your team IDs in it. Copy that column. Go to "Selected Races" and paste it in G2. In "Races" you now see all your races listed and also race clashes, please remember them.
#3 Now onto the actual Planning: In "Planning", you'll see your riders listed aswell as the races. You can sort the riders by name, remaining race days and their stats that are shown there, simply by pressing the buttons on top. If you want a rider to take part in a race put a 1 in the according cell.
#4 Try to send full teams to all races you are taking part in. In row 3 you see how much riders are needed.
Rules:
#1 Every rider has to race at least 20 race days and not more than written in the DB.
#2 Riders are not allowed to take part in clashing races, please remember that.
#3 You have to send full teams to WT races and a minimum of 5 riders to CT races, if you can't manage to do that pm me and we'll find a solution.
When done, please upload the file this time and send me a link.
Alongside that please pm me a list of your 3 focus races. Your team's performance there will have an influence on your budget of next year. The more prestigious the race is the higher the possible gain, but also the possible reduction.
This is probably the most time consuming job of all ICL, but please try to be done on the weekend. If you have troubles to do so, please pm me in time so I can take care of your planners.
Edited by Bikex on 02-02-2015 18:26
|
| |
|
|
| TheManxMissile |
Posted on 02-02-2015 13:37
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
Link doesn't work
|
| |
|
|
| Bikex |
Posted on 02-02-2015 13:37
|
Team Leader
Posts: 7255
Joined: 25-08-2012
PCM$: 600.00
|
Oh and please PM me three focus races for your team. Next season's budget will partially depend on that. The more prestigious the race the higher the possible gain, but also the possible reduction.
Edit: link updated in a second.
Edit2: Should work now
Edited by Bikex on 02-02-2015 13:40
|
| |
|
|
| Ollfardh |
Posted on 02-02-2015 13:45
|
World Champion
Posts: 14563
Joined: 08-08-2011
PCM$: 9100.00
|
Is that three focus races for both the main and dev team?
Changed my sig, this was getting absurd.
|
| |
|
|
| Bikex |
Posted on 02-02-2015 13:46
|
Team Leader
Posts: 7255
Joined: 25-08-2012
PCM$: 600.00
|
Ollfardh wrote:
Is that three focus races for both the main and dev team?
Only main team. Development team has a fixed budget. |
| |
|
|
| matt17br |
Posted on 02-02-2015 13:52
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
I like that Vuelta route, definitely the best GT one, very well balanced and quite "Vuelta-like" route, love it, shame I won't take part 
Gonna send the Race Planning on Saturday the latest.
EDIT: Why have I got 2 riders (Trofimov and Dabrowski) in Riders' sheet?
Edited by matt17br on 02-02-2015 13:55
|
| |
|
|
| Bikex |
Posted on 02-02-2015 14:37
|
Team Leader
Posts: 7255
Joined: 25-08-2012
PCM$: 600.00
|
matt17br wrote:
EDIT: Why have I got 2 riders (Trofimov and Dabrowski) in Riders' sheet?
That are example riders, I just put them there to see how the file works out and so you know where to paste your riders. Just replace them. |
| |
|
|
| Croatia14 |
Posted on 02-02-2015 15:39
|
Directeur Sportif
Posts: 9099
Joined: 13-03-2013
PCM$: 2100.00
|
This time I am confused, no idea how to deal with this excel sheet...
|
| |
|
|
| Bikex |
Posted on 02-02-2015 15:56
|
Team Leader
Posts: 7255
Joined: 25-08-2012
PCM$: 600.00
|
Croatia14 wrote:
This time I am confused, no idea how to deal with this excel sheet...
Okay where is the problem exactly or do you have no clue at all? |
| |
|
|
| Croatia14 |
Posted on 02-02-2015 15:59
|
Directeur Sportif
Posts: 9099
Joined: 13-03-2013
PCM$: 2100.00
|
My problem is just how to start this. Is there a place where we can insert our number or is it all copy and paste from old tables?
|
| |
|
|
| Silvio Herklotz |
Posted on 02-02-2015 16:02
|
Protected Rider
Posts: 1246
Joined: 26-02-2014
PCM$: 200.00
|
I guess you want two separate planning sheets for normal and dev team?
|
| |
|
|
| Bikex |
Posted on 02-02-2015 16:12
|
Team Leader
Posts: 7255
Joined: 25-08-2012
PCM$: 600.00
|
Croatia14 wrote:
My problem is just how to start this. Is there a place where we can insert our number or is it all copy and paste from old tables?
Okay, first thing is to open the excel db, filter it by your team, copy all of your riders and paste it in the Planning file in "Riders" in A1.
Then you have to select the races you're part of in "Selected Races". The file works the way that as soon something is written in a cell in column G the race counts as selected. To not make you put an x behind every race you're part of again, there is the table "team". You'll see a column with only your team ID's in it. Copy that column and paste it in "Selected Races" in column G. That way your races are selected. Now you have your riders and your races in the file and can start.
You don't need your "number" anywhere as you use your riders and I know then this is your team.
Silvio Herklotz wrote:
I guess you want two separate planning sheets for normal and dev team?
Yes |
| |
|
|
| Bikex |
Posted on 02-02-2015 18:27
|
Team Leader
Posts: 7255
Joined: 25-08-2012
PCM$: 600.00
|
As always I made a very dumb mistake when completing the file. I'd like to ask you to use this file, now: https://www.mediafire.com/download/jvc...nning.xlsm
Just copy everything over and you should be fine when you already started.
I can also live with it if you don't want to do that, then the old file works as well, but it makes it a little harder for me. |
| |
|
|
| trekbmc |
Posted on 03-02-2015 04:50
|
Team Leader
Posts: 7366
Joined: 11-07-2014
PCM$: 700.00
|
For the 3 goal races do we have to win them or just perform well?
EDIT: Do we do this for Dev teams?
Edited by trekbmc on 03-02-2015 05:39
"What done is, is one." - Benji Naesen
|
| |
|
|
| trekbmc |
Posted on 03-02-2015 07:40
|
Team Leader
Posts: 7366
Joined: 11-07-2014
PCM$: 700.00
|
Sorry for the double post, but how do you know the id of your dev team?
"What done is, is one." - Benji Naesen
|
| |
|
|
| Luis Leon Sanchez |
Posted on 03-02-2015 07:44
|
Team Leader
Posts: 5533
Joined: 12-06-2013
PCM$: 500.00
|
It was in previous excel files on the team ID list
|
| |
|
|
| trekbmc |
Posted on 03-02-2015 07:54
|
Team Leader
Posts: 7366
Joined: 11-07-2014
PCM$: 700.00
|
Thanks, got it now, 
"What done is, is one." - Benji Naesen
|
| |
|
|
| Croatia14 |
Posted on 03-02-2015 10:27
|
Directeur Sportif
Posts: 9099
Joined: 13-03-2013
PCM$: 2100.00
|
Thx bikex :)
|
| |
|
|
| Ollfardh |
Posted on 03-02-2015 16:14
|
World Champion
Posts: 14563
Joined: 08-08-2011
PCM$: 9100.00
|
I forgot, do we have to check clashes ourselves or does the file give an error?
Changed my sig, this was getting absurd.
|
| |
|
![imgur.com/KlJUqDx.jpg[/img[img]]https://imgur.com/yUygrQ.jpg](https://imgur.com/KlJUqDx.jpg[/img[img]]https://imgur.com/yUygrQ.jpg)
