The CT and PCT divisions have now 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 2021 season related
Column EC 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 EF 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).
There also is a macro for checking a single rider only, which is faster than the full sheet clash macro of the button.
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 Sunday, 3rd, 24:00 BST!
But the earlier they are in, the better really making it easier and faster for me to handle it.
Download the above blank planner and replace the blank with your team name. It now shows clashes without running a macro helping you to find clashes immediately.
- unhide all coloumns (works with CTRL+SHIFT+W as well)
- copy the "invisible" part from F4 to EB4
- paste it to the new blank planner above into the same F4-EB4 part
- run the hiding macro (CTRL+SHIFT+Q)
- you then should only see your races
- you can also copy&paste your data from the old planner to this one. Better do this as value though to avoid ruining the format or something
- whenever you do a clash, the full rider planning area from F5 to EB5 down to row 35 will immediately be in full red colour showing you, that your last edit was forcing a clash
- it also fixes the 3 riders only error for 3 races
If you can`t run macros to make the blank planner your very own race selection planner, please contact me.
Not a big fan of shame lists myself but as the deadline has passed already and managers were reminded, I hope to see those being sent in very fast.
I am not listing 2-3, which have sent their planner in but got it back due to a small mistake as I only responded to it lately.
But still missing the first version of the planner completely by
- Project Africa
- Polestar cycling
