|
Race Planners 2013
|
| alexkr00 |
Posted on 29-12-2012 22:54
|
World Champion
Posts: 13915
Joined: 05-08-2008
PCM$: 300.00
|
SotD wrote:
And if I get a 10th place at the TdF, that could probably be better used somewhere else where Contador could podium.
Well, that's pretty much what I'm doing with Gesink.
I think Tirreno is definitely for puncheurs and I'd put Ulissi in it since he's Italian as well. But in Paris - Nice, I think Contador would do better since in the third and last stage there's a first category climb very close to the finish. I'd say that's for climbers, not puncheurs.
But if you want to make sure Contador scores that podium just avoid these type of races and send him in those with more mountains such as Romandie, Dauphine, Suisse, Colombia, California, Catalunya or Deutschland Tour.
|
| |
|
|
| SotD |
Posted on 29-12-2012 23:06
|
World Champion
Posts: 12188
Joined: 29-11-2006
PCM$: 2980.00
|
Yeah Catalunya and Vuelta a España are no brainers for me with Contador, but Pais Vasco is difficult for me to decide...
Deutschland Tour is for Fothen of course 
I'm pretty sure Contador isn't doing two GT's, he didn't do two last season and did very well overall. Fothen did two but flopped them both, so I'm looking at perhaps putting him into the Giro and then dropping the Tour.
|
| |
|
|
| SportingNonsense |
Posted on 29-12-2012 23:11
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
As I understand it, a hill profile means that the Mountain rating will be less than .5. So hill stat will be more important than Mountain stat.
PCM12 is a change from the past though, in that the game determines the mountain rating - not me. So, short of going through and opening each stage individually in the stage viewer, I dont know what the Mountain ratings will be.
|
| |
|
|
| Spilak23 |
Posted on 29-12-2012 23:16
|
Team Leader
Posts: 7357
Joined: 22-08-2011
PCM$: 200.00
|
I have a question. PCM now decides self if a stage is flat or hilly. So a lot of stages which used to be hilly with a flat finish are now classified as flat automatically by the game. Does the MO/Hi ratio play any role in this stages?
|
| |
|
|
| Ad Bot |
Posted on 24-11-2024 17:26
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| SportingNonsense |
Posted on 29-12-2012 23:18
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Spilak23 wrote:
I have a question. PCM now decides self if a stage is flat or hilly. So a lot of stages which used to be hilly with a flat finish are now classified as flat automatically by the game. Does the MO/Hi ratio play any role in this stages?
I would expect the MO/Hi ratio to be 0 for all flat stages - so hill stat is all important and mountain stat does not matter. I could be wrong though, I havent gone through and checked - and I dont currently have access to my computer which has PCM12 installed, plus all the stages.
|
| |
|
|
| Vien |
Posted on 29-12-2012 23:21
|
Small Tour Specialist
Posts: 2322
Joined: 16-06-2008
PCM$: 200.00
|
@Spilak: Most stages end up in a mass sprint, and even the riders with the lowest hillstat will survive. The hardest type of stages usually finish in a group of 50-75, but unless the finish is really uphill (Emerald Race for example), I've seen riders with 52 HIL win.
Riders with a high HIL and no sprint usually don't stand a chance, but will attack.
|
| |
|
|
| Spilak23 |
Posted on 29-12-2012 23:23
|
Team Leader
Posts: 7357
Joined: 22-08-2011
PCM$: 200.00
|
Is what I thought as well. Iirc Mo/Hi ratio was always 0 in PCM 11 so will probably have stayed the same. Flat stages in Algerie look to have long climbs in. If the Mo/Hi ratio does count in these stages, it might be smarter not to bring Anton Martin or Lay and let Moreno be my sprinter instead.
|
| |
|
|
| Vien |
Posted on 29-12-2012 23:25
|
Small Tour Specialist
Posts: 2322
Joined: 16-06-2008
PCM$: 200.00
|
Anton Martin and Lay will do well in Algerie, I'll promise you that
|
| |
|
|
| Spilak23 |
Posted on 29-12-2012 23:27
|
Team Leader
Posts: 7357
Joined: 22-08-2011
PCM$: 200.00
|
Yeah, I think I though a bit too long on that one. Far fetched 
|
| |
|
|
| SportingNonsense |
Posted on 30-12-2012 09:14
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
For PCT teams who received the planner yesterday (which was all of you) it looks like the race clash macro doesnt work anymore. Ill try to fix it when I have the time, but until then, race clash checking will need to be done manually
|
| |
|
|
| SportingNonsense |
Posted on 31-12-2012 12:13
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
To get the Race clash macro working, you need to replace the current code for the race clash macro with:
Spoiler
Sub RaceClash()
Dim Race1(1 To 144) As Integer
Dim Race2(1 To 144) As Integer
Dim Choice(1 To 144) As Integer
Dim R1 As Integer, R2 As Integer, A As Integer, B As Integer
Dim Clash As Integer
For j = 5 To 35
For i = 1 To 141
Race1(i) = Worksheets(3).Cells(1, i).Value
Race2(i) = Worksheets(3).Cells(2, i).Value
Next i
Next j
For j = 5 To 35
For i = 1 To 141
Choice(i) = Worksheets(2).Cells(j, i + 5).Value
Next i
Clash = 0
For i = 1 To 141
R1 = Race1(i)
R2 = Race2(i)
If Choice(R1) = 1 Then
A = 1
Else
A = 0
End If
If Choice(R2) = 1 Then
B = 1
Else
B = 0
End If
If A + B = 2 Then
Clash = Clash + 1
End If
If Clash = 0 Then
Worksheets(2).Cells(j, 149).Value = 0
ElseIf Clash > 0 Then
Worksheets(2).Cells(j, 149).Value = 1
End If
Next i
Next j
End Sub
In Excel 2007, you can do this by going to the View tab, clicking Macros and selecting View Macros, then choose to edit the RaceClash macro and change the code.
Edited by SportingNonsense on 31-12-2012 12:53
|
| |
|
|
| SportingNonsense |
Posted on 31-12-2012 12:53
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Columns EQ through to ET also need fixing.
Looking at the first rider in your file.
EQ5 should look like
=IF(ER5=1,"Error","Good")
ER5 should look like
Just put all 0s for now in column ES5 (The macro will change them to 1s if there is race clashes.
ET5 should look like
=IF(ES5=1,"Error","Good")
Replicate that code for all other riders (so for the next rider any reference to 5 should be changed to 6) - selecting the cell and dragging the value down the whole column should do the trick.
Columns ER and ES will initially be hidden. You can view them by selecting columns EQ and ET, then right clicking on the column bar and selecting unhide.
|
| |
|
|
| Gustavovskiy |
Posted on 31-12-2012 15:47
|
Team Leader
Posts: 6036
Joined: 20-07-2008
PCM$: 200.00
|
Thanks for the uodate on that, but the unhide function doesn't really do anything in my file. I selected the 2 columns as instructed but nothing appears between them.
|
| |
|
|
| SportingNonsense |
Posted on 31-12-2012 17:53
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Just realised the so-called fixed code still didnt work.
But this will:
Spoiler
Sub RaceClash()
Dim Race1(1 To 144) As Integer
Dim Race2(1 To 144) As Integer
Dim Choice(1 To 144) As Integer
Dim R1 As Integer, R2 As Integer, A As Integer, B As Integer
Dim Clash As Integer
For j = 5 To 35
For i = 1 To 141
Race1(i) = Worksheets(3).Cells(1, i).Value
Race2(i) = Worksheets(3).Cells(2, i).Value
Next i
Next j
For j = 5 To 35
For i = 1 To 141
Choice(i) = Worksheets(2).Cells(j, i + 5).Value
Next i
Clash = 0
For i = 1 To 141
R1 = Race1(i) - 5
R2 = Race2(i) - 5
If Choice(R1) = 1 Then
A = 1
Else
A = 0
End If
If Choice(R2) = 1 Then
B = 1
Else
B = 0
End If
If A + B = 2 Then
Clash = Clash + 1
End If
If Clash = 0 Then
Worksheets(2).Cells(j, 149).Value = 0
ElseIf Clash > 0 Then
Worksheets(2).Cells(j, 149).Value = 1
End If
Next i
Next j
End Sub
Not sure why unhide wouldnt work, Gustavovskiy
|
| |
|
|
| CountArach |
Posted on 01-01-2013 13:17
|
Grand Tour Champion
Posts: 8290
Joined: 14-07-2008
PCM$: 200.00
|
The code still doesn't work for me. The race day use code does but the clashing macro still won't fire even when I try to break it.
|
| |
|
|
| Heine |
Posted on 01-01-2013 13:22
|
Grand Tour Specialist
Posts: 4116
Joined: 08-04-2007
PCM$: 200.00
|
It works for me now  And made me realize I made a mistake in my planning  Keizer is supposed to be in 2 races at the same time... This gotta take some work
|
| |
|
|
| MrOBJ |
Posted on 01-01-2013 20:22
|
Stagiare
Posts: 187
Joined: 25-06-2011
PCM$: 200.00
|
Is there any different between the "Green Good" and the "White Good" in Race Day Use?
And I´m not quite sure about the Race Clashes.. Do I have to check manually, or will the Race Clashes column correct me, if a rider participate in some races, which clash? |
| |
|
|
| Miguel98 |
Posted on 01-01-2013 20:25
|
World Champion
Posts: 10497
Joined: 23-06-2011
PCM$: 200.00
|
When you finish putting the rider to the races, do Shift + Ctrl + C. |
| |
|
|
| MrOBJ |
Posted on 01-01-2013 20:44
|
Stagiare
Posts: 187
Joined: 25-06-2011
PCM$: 200.00
|
So if nothing happen after pressing Shift + Ctrl + C the Planner can be send back? |
| |
|
|
| Miguel98 |
Posted on 01-01-2013 20:48
|
World Champion
Posts: 10497
Joined: 23-06-2011
PCM$: 200.00
|
Then check the last column to see. If it's all green, it's all good. If there's something on red, you need to check that rider's schedule. |
| |
|
