[PCT/CT] Race Planners 2023
|
roturn |
Posted on 24-08-2023 08:58
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
The CT and PCT divisions will soon get their race planners in the dropbox folder.
Please check first if your race selection is correct and for PCT teams the wildcards are included correctly.
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 2023 season related
Column DY 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 EA and Cells A/D2 will warn you if a rider is being sent to more than one race at the same time.
This year there is a direct red colouring once you have send a rider to clashing races. You can`t miss this as the rider`s full line becomes red as also the A/D2 box.
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.
Submitting
When completed, upload to dropbox and rename it to "PCT_TeamName" or "CT_TeamName" and PM ManGame-Admin to say it is there.
Deadline
The deadline to finish the race planners is Sunday, 03/09, 24:00 BST!
But the earlier they are in, the better really making it easier and faster for me to handle it. |
|
|
|
Ollfardh |
Posted on 24-08-2023 09:36
|
World Champion
Posts: 14562
Joined: 08-08-2011
PCM$: 9100.00
|
Could the person taking care of the PCT send me a PM to see how we can do this without dropbox?
Changed my sig, this was getting absurd.
|
|
|
|
KaiserAdler |
Posted on 24-08-2023 09:48
|
Domestique
Posts: 570
Joined: 13-07-2022
PCM$: 5800.00
|
Same for me aswel. I’d like to recieve this file without the dropbox if possible.
|
|
|
|
roturn |
Posted on 24-08-2023 10:03
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
We might find a way to do so.
Ideally dropbox is working as it`s easiest without any links. But in especially for those, that e.g. have no chance to join there due to server/work regulatory, a way can be found. |
|
|
|
AbhishekLFC |
Posted on 24-08-2023 10:34
|
Directeur Sportif
Posts: 11675
Joined: 27-07-2015
PCM$: 1861.50
|
New DB is not out yet right?
|
|
|
|
roturn |
Posted on 24-08-2023 10:44
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Coming asap.
All PCT managers have their planner now!
Enjoy.
CT managers will follow soon. |
|
|
|
Ad Bot |
Posted on 21-11-2024 15:02
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
roturn |
Posted on 25-08-2023 08:50
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
CT planners in dropbox for all managers.
Please check your races, in case of questions a PM to me is best.
Same deadline for you as for the other divisions as posted above.
19 CT teams and 45 races were impacted in the attempt to get all races to 24 teams maximum as also trying to get all teams the wanted backup races.
And this obviously meant, that several backup races quickly also came to the 24 teams maximum to make backups from backups needed as well.
Hopefully all of you are now happy with the planning still. |
|
|
|
Blasing |
Posted on 25-08-2023 09:44
|
Neo-Pro
Posts: 278
Joined: 27-06-2011
PCM$: 200.00
|
Quick question. The Y/N column only shows a Y when we select 8 riders. But we can select a variaton from 6-8 riders, right?
Manager of JEWA TIROL Cycling Team
|
|
|
|
redordead |
Posted on 25-08-2023 09:50
|
Grand Tour Specialist
Posts: 4881
Joined: 18-10-2017
PCM$: 200.00
|
Blasing wrote:
Quick question. The Y/N column only shows a Y when we select 8 riders. But we can select a variaton from 6-8 riders, right?
Yes, 6 is the minimum.
"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
|
|
|
|
roturn |
Posted on 25-08-2023 09:53
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Yes.
If you have 6-8 riders, it`s fine, even though at 6 and 7 it still shows a red N.
For TT classics it`s 1-3 only. |
|
|
|
Blasing |
Posted on 25-08-2023 10:56
|
Neo-Pro
Posts: 278
Joined: 27-06-2011
PCM$: 200.00
|
When do we hit August so that we can use our Stagiaires?
Manager of JEWA TIROL Cycling Team
|
|
|
|
Imladrik |
Posted on 25-08-2023 11:05
|
Breakaway Specialist
Posts: 807
Joined: 05-10-2021
PCM$: 600.00
|
You've got the calendar here https://pcmdaily....d_id=64840
(Also useful for clashes).
Once again, thank you very much roturn and all others involved in this work, seems like it was not easy.
Probably won't be able to do my planning before Wednesday, but I'll try to be effective
“...the secret of the Great Stories is that they have no secrets. The Great Stories are the ones you have heard and want to hear again. The ones you can enter anywhere and inhabit comfortably."
A. Roy
|
|
|
|
Jakstar22 |
Posted on 27-08-2023 13:27
|
Team Leader
Posts: 7293
Joined: 11-04-2012
PCM$: 200.00
|
Just super quick, If we are doing PT wildcard races, does that count as the PCT Race days or do they come out of the riders PT race days?
|
|
|
|
jandal7 |
Posted on 27-08-2023 13:29
|
World Champion
Posts: 11392
Joined: 17-12-2014
PCM$: 1020.00
|
Jakstar22 wrote:
Just super quick, If we are doing PT wildcard races, does that count as the PCT Race days or do they come out of the riders PT race days?
They have no RD cost
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
|
|
|
|
Jakstar22 |
Posted on 27-08-2023 13:38
|
Team Leader
Posts: 7293
Joined: 11-04-2012
PCM$: 200.00
|
jandal7 wrote:
Jakstar22 wrote:
Just super quick, If we are doing PT wildcard races, does that count as the PCT Race days or do they come out of the riders PT race days?
They have no RD cost
Thanks!
|
|
|
|
Fabianski |
Posted on 27-08-2023 20:08
|
Grand Tour Specialist
Posts: 4667
Joined: 29-09-2018
PCM$: 185.00
|
No RD cost, but no points, either (would obviously be unfair otherwise). And: Clash rules still apply!
|
|
|
|
Hosaur |
Posted on 27-08-2023 21:13
|
Under 23
Posts: 98
Joined: 08-07-2023
PCM$: 500.00
|
I pm'd roturn about finding another way for me to edit my race planner (not using dropbox and paying for excel) a couple days ago, and he has yet to respond. Just was wondering if any other mods could find a way to send me my race planner in google sheets? |
|
|
|
roturn |
Posted on 27-08-2023 21:30
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
You will get it tomorrow this way.
Wasn't at home over the weekend, so not able to open/edit the file.
Tomorrow I should have time to work on this. |
|
|
|
SportingNonsense |
Posted on 27-08-2023 22:33
|
Team Manager
Posts: 33045
Joined: 08-03-2007
PCM$: 200.00
|
Hosaur wrote:
I pm'd roturn about finding another way for me to edit my race planner (not using dropbox and paying for excel) a couple days ago, and he has yet to respond. Just was wondering if any other mods could find a way to send me my race planner in google sheets?
I think many do use OpenOffice for this as the easiest alternative.
|
|
|
|
Ollfardh |
Posted on 29-08-2023 09:06
|
World Champion
Posts: 14562
Joined: 08-08-2011
PCM$: 9100.00
|
Is there an update on this? I'd like to take a look at my HC races competition.
Changed my sig, this was getting absurd.
|
|
|