[PCT/CT] Race Planners 2020
|
roturn |
Posted on 13-10-2020 09:19
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
The CT division has now their race planners in the dropbox folder.
PCT manager need to wait a bit until the wildcard process is finished.
The Race Planner now includes your race selection and gives you the opportunity to fill your rider squads for those. As it`s individual planners, please only add to those races shown and don`t start to add numbers to hidden race coloumns, as you don`t take part there and would make it just more difficult for us.
Instructions
1. From the DB take the ID, rider names, and race day allowances (of your division!), and add them to the planner file. (Take care you copy paste the number and not any formula for the rd)
2. If you're planning on training, add it to the DB, run the macro (CTRL+SHIFT+O) and take the updated race day allowance!
Then your race planner is ready to go.
General race planner instructions (Recommended for new or forgetful managers)
Spoiler This will look something like this:
To fill in a rider's schedule, put a 1 in the column for each race you want them to ride. It should look something like this:
Note: This planner is simply an example, nothing 2020 season related
Column ES and Cells A/D3 will warn you if you have sent a rider to more races than they have race days for. This updates automatically.
Column EV and Cells A/D2 will warn you if a rider is being sent to more than one race at the same time. This only updates when you click the 'Check Race Clashes' button. Once you have clicked that button, wait until a Text Box prompt appears telling you that the check has been completed. You can also check which races clash in the Calendar excel file, or in the Race Profiles forum.
Rows 36 and 37 show how many riders you have sent to a race. The team size is 8 for every race except some of the TT classics, which are 3 maximum. Remember that you must send at least 6 riders to each races to participate in those.
PCT teams should remember the limits on rider strength for lineups they send to C2 races.
Alternatives
If you can't open .xlsm files, an .xls version can be provided - without any of the macros.
The planner should give you all needed information if you made a mistake such as too many or too few riders in a race, if spending too many race days or if using a rider in a clashing race (once clicking the macro button there).
Submitting
When completed, upload to dropbox with the same name as uploaded "PCT_TeamName" or "CT_TeamName" and PM ManGame-Admin to say it is there.
Deadline
The deadline to finish the race planners is next Wednesday, 21st, 12:00 BST! |
|
|
|
ManGame-Admin |
Posted on 13-10-2020 11:50
|
Directeur Sportif
Posts: 1183
Joined: 28-05-2011
PCM$: 400.00
|
What can be said for PCT teams: all of you got exactly the C1/C2 races you requested. |
|
|
|
jandal7 |
Posted on 13-10-2020 11:56
|
World Champion
Posts: 11392
Joined: 17-12-2014
PCM$: 1020.00
|
Brilliant team effort everyone
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
|
|
|
|
Ollfardh |
Posted on 13-10-2020 11:58
|
World Champion
Posts: 14563
Joined: 08-08-2011
PCM$: 9100.00
|
Go PCT!
Changed my sig, this was getting absurd.
|
|
|
|
Ad Bot |
Posted on 22-11-2024 00:57
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
redordead |
Posted on 13-10-2020 12:03
|
Grand Tour Specialist
Posts: 4881
Joined: 18-10-2017
PCM$: 200.00
|
Great, now get those wildcards in!
"I am a cyclist, I may not be the best, but that is what I strive to be. I may never get there, but I will never quit trying." - Tadej Pogačar
|
|
|
|
Guave |
Posted on 14-10-2020 07:20
|
Stagiare
Posts: 163
Joined: 07-09-2020
PCM$: 200.00
|
Question: the 15 RD of a stagiaire, does this include the U23 races or can stagiaires compete on top of the 15 RD's?
|
|
|
|
redordead |
Posted on 14-10-2020 07:28
|
Grand Tour Specialist
Posts: 4881
Joined: 18-10-2017
PCM$: 200.00
|
Guave wrote:
Question: the 15 RD of a stagiaire, does this include the U23 races or can stagiaires compete on top of the 15 RD's?
U23 races don't cost any RD's.
"I am a cyclist, I may not be the best, but that is what I strive to be. I may never get there, but I will never quit trying." - Tadej Pogačar
|
|
|
|
Guave |
Posted on 14-10-2020 07:39
|
Stagiare
Posts: 163
Joined: 07-09-2020
PCM$: 200.00
|
redordead wrote:
Guave wrote:
Question: the 15 RD of a stagiaire, does this include the U23 races or can stagiaires compete on top of the 15 RD's?
U23 races don't cost any RD's.
Ok, thanks for the clarification!
|
|
|
|
roturn |
Posted on 15-10-2020 10:50
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
PCT Teams also have their race planners in dropbox!
Deadline next Wednesday!
Most probably later today there will be a final or provisional Post Transfers DB including trainings and updated RDs according to new OVLs.
If you want to start earlier already, please make sure you have updated the OVL and Race Days in the transfers DB yourself!
All wildcards and PTHC/HC/C1/C2 races should be according to your selections. Please check if you find any mistakes asap! |
|
|
|
roturn |
Posted on 15-10-2020 10:58
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Additional Info or Reminder for PCT managers in C2 and loans in general!
We will check if you have fulfilled the C2 stat limitations. But as this is time consuming, we hope that you check yourself first and ideally not having any mistakes there to speed things up!
Same goes for loans! Please check that you fulfill the clauses. It will be checked as well but can`t 100% guaranteed, that we will find, in especially as we simply consider Avenir nomination by you for example. |
|
|
|
Ollfardh |
Posted on 15-10-2020 12:32
|
World Champion
Posts: 14563
Joined: 08-08-2011
PCM$: 9100.00
|
*refresh*
*refresh*
*refresh*
Changed my sig, this was getting absurd.
|
|
|
|
the_hoyle |
Posted on 20-10-2020 22:34
|
Grand Tour Champion
Posts: 7651
Joined: 28-05-2009
PCM$: 200.00
|
Planner done and PM sent
.: Manager of :.
.: My Awards :.
|
|
|
|
aidanvn13 |
Posted on 21-10-2020 08:09
|
Classics Specialist
Posts: 2797
Joined: 06-11-2010
PCM$: 200.00
|
Am I the only one having issues with the Race Clash macro? It seems stuck in an infinite loop |
|
|
|
quadsas |
Posted on 21-10-2020 08:16
|
Small Tour Specialist
Posts: 2518
Joined: 18-01-2013
PCM$: 300.00
|
aidanvn13 wrote:
Am I the only one having issues with the Race Clash macro? It seems stuck in an infinite loop
worked perfectly fine for me
|
|
|
|
roturn |
Posted on 21-10-2020 08:17
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
The macro takes quite some time but normally should work well.
In the end if you need a quick check, you can also upload the file to your dropbox and send me directly a PM (and MG Admin) asking to check quickly as I can check without macro. |
|
|
|
the_hoyle |
Posted on 21-10-2020 08:51
|
Grand Tour Champion
Posts: 7651
Joined: 28-05-2009
PCM$: 200.00
|
aidanvn13 wrote:
Am I the only one having issues with the Race Clash macro? It seems stuck in an infinite loop
Worked fine for me, but it was a good 5 mins of thinking, so walk off and do something else whilst it does it's thing
.: Manager of :.
.: My Awards :.
|
|
|
|
DubbelDekker |
Posted on 21-10-2020 09:10
|
Small Tour Specialist
Posts: 2633
Joined: 20-04-2008
PCM$: 200.00
|
I also had issues with the race clash button; it returned an error.
But there's a simple workaround: just select a cell in the row of a rider you want to check and press ctrl+shift+r. It checks that rider very quickly. Repeat for all riders.
|
|
|
|
Ollfardh |
Posted on 21-10-2020 09:32
|
World Champion
Posts: 14563
Joined: 08-08-2011
PCM$: 9100.00
|
This is gonna be a long day for me. I know I do this every year, but yeah, selected races without looking at the clashes. I'm especially ashamed for my PT wildcards, will be my C team for San Remo and Giro.
Changed my sig, this was getting absurd.
|
|
|
|
quadsas |
Posted on 21-10-2020 09:36
|
Small Tour Specialist
Posts: 2518
Joined: 18-01-2013
PCM$: 300.00
|
Ollfardh wrote:
This is gonna be a long day for me. I know I do this every year, but yeah, selected races without looking at the clashes. I'm especially ashamed for my PT wildcards, will be my C team for San Remo and Giro.
I was told deadline is at noon BST
|
|
|
|
Ollfardh |
Posted on 21-10-2020 09:42
|
World Champion
Posts: 14563
Joined: 08-08-2011
PCM$: 9100.00
|
quadsas wrote:
Ollfardh wrote:
This is gonna be a long day for me. I know I do this every year, but yeah, selected races without looking at the clashes. I'm especially ashamed for my PT wildcards, will be my C team for San Remo and Giro.
I was told deadline is at noon BST
Right, thanks for that!
Changed my sig, this was getting absurd.
|
|
|