[PCT/CT] Race Planners 2017
|
SportingNonsense |
Posted on 14-09-2017 21:42
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
We're going to try something new this year, and give all PCT and CT managers the opportunity to work on their race planner during transfers.
Race calendars will not be finalised until after transfers - but still you might find this helpful, and some teams will be in a position to work on this already.
Files:
PCT: https://www.dropbox.com/s/nemaqqzr80n....xlsm?dl=0
CT: https://www.dropbox.com/s/e537uk6da94....xlsm?dl=0
Instructions
1. From the DB take the ID, rider names, and race day allowances, and add them to the planner file.
2. If you're planning on training, add it to the DB, run the macro (CTRL+SHIFT+O) then check the info thread to see if their RDs have now changed
If you want to hide the columns of races you are not entering then:
3. Fill in the C1C2 selection file with the races you want
4. Go to the Tabelle2 sheet and select and copy cells A5 to DL5 (The 1s and 0s)
5. Paste it into cells F4:DQ4 in the race planner file (It is better if you do it Paste Values)
6. If you are planning on any wildcards (PT for PCT, HC for CT) and don't want those columns being hidden, then find them in a race planner file and put a '1' in row 4 for that race.
7. Run the 'Hiding' macro (CTRL+SHIFT+Q)
Then your race planner is ready to go. But of course, your calendar may still change.
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: That is neither the actual Eritel race calendar, or my race lineups for those races (if I'm even in them)
Column DR 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 DU 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. Remember that you must send at least 6 riders to each races.
PCT teams should remember the limits on rider strength for lineups they send to C2 races.
Alternatives
1. If you'd rather wait until after transfers and have the file sent to you, filled in with rider details and showing your calendar, then please post in this thread to request that
2. If you can't open .xlsm files, an .xls version can be provided - without any of the macros.
Submitting
When completed, upload to dropbox with the name "PCT_TeamName" or "CT_TeamName" and PM ManGame-Admin to say it is there. Clearly, this will not be required until some time after the transfer period has ended.
Edited by SportingNonsense on 14-09-2017 21:58
|
|
|
|
weirdskyfan64 |
Posted on 14-09-2017 21:46
|
Protected Rider
Posts: 1387
Joined: 15-03-2014
PCM$: 200.00
|
I'd prefer to wait for the completed file, just so I don't make any stupid errors.
Sorry, and thank you.
Disclaimer- Most of my posts are me thinking aloud. And most of what I think is rubbish.
Winner of a FIFA Prediction Fair Play Award (a phrase becoming increasingly ironic)
"... Because he (me) has a sound tactical mind in general..." jandal7, at 9:30 am GMT on 12th May 2016
|
|
|
|
tastasol |
Posted on 14-09-2017 22:39
|
Classics Specialist
Posts: 2889
Joined: 11-09-2010
PCM$: 200.00
|
I've followed the instructions, but the macro doesn't seem to work? The normal ctrl+shift+o works fine in the DB and the race clash macro in the race planner works normal.
|
|
|
|
SportingNonsense |
Posted on 14-09-2017 22:40
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
tastasol wrote:
I've followed the instructions, but the macro doesn't seem to work? The normal ctrl+shift+o works fine in the DB and the race clash macro in the race planner works normal.
Can you put the file in your Dropbox so I can have a look?
|
|
|
|
TheManxMissile |
Posted on 14-09-2017 22:42
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
I'd rather wait to be sent the complete file.
Partly to avoid mistakes, but also because i'll be waiting on wildcard results as well so don't want to waste my own time planning only to then replan.
Will be quick when it's sent through though
|
|
|
|
tastasol |
Posted on 14-09-2017 22:43
|
Classics Specialist
Posts: 2889
Joined: 11-09-2010
PCM$: 200.00
|
SportingNonsense wrote:
tastasol wrote:
I've followed the instructions, but the macro doesn't seem to work? The normal ctrl+shift+o works fine in the DB and the race clash macro in the race planner works normal.
Can you put the file in your Dropbox so I can have a look?
Uploaded.
|
|
|
|
hillis91 |
Posted on 14-09-2017 22:46
|
Team Leader
Posts: 5897
Joined: 30-11-2006
PCM$: 1500.00
|
1. If you'd rather wait until after transfers and have the file sent to you, filled in with rider details and showing your calendar, then please post in this thread to request that
=
ME
|
|
|
|
SportingNonsense |
Posted on 14-09-2017 22:48
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
tastasol wrote:
SportingNonsense wrote:
tastasol wrote:
I've followed the instructions, but the macro doesn't seem to work? The normal ctrl+shift+o works fine in the DB and the race clash macro in the race planner works normal.
Can you put the file in your Dropbox so I can have a look?
Uploaded.
You haven't done this bit:
If you want to hide the columns of races you are not entering then:
3. Fill in the C1C2 selection file with the races you want
4. Go to the Tabelle2 sheet and select and copy cells A5 to DL5 (The 1s and 0s)
5. Paste it into cells F4 Q4 in the race planner file (It is better if you do it Paste Values)
|
|
|
|
Martii_Scots01 |
Posted on 14-09-2017 22:49
|
Neo-Pro
Posts: 301
Joined: 29-07-2015
PCM$: 200.00
|
I'd also prefer to wait for the completed file after transfers have ended, so I also don't make stupid errors and ridiculous planning decisions... Thanks a lot for all the work btw guys/girls. |
|
|
|
Ad Bot |
Posted on 22-11-2024 18:32
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
tastasol |
Posted on 14-09-2017 22:51
|
Classics Specialist
Posts: 2889
Joined: 11-09-2010
PCM$: 200.00
|
Ah, yhees. I copied that in the Sheet 2 in the planer, misunderstood that one. Thanks
|
|
|
|
sammyt93 |
Posted on 14-09-2017 23:16
|
Classics Specialist
Posts: 3634
Joined: 03-07-2012
PCM$: 300.00
|
I'd like to wait until after transfers and have the file sent to me please,
Partly to avoid me making any mistakes setting it up but mainly because I'm hoping to see a post transfers DB before I have to fill it in.
|
|
|
|
Bjartne |
Posted on 14-09-2017 23:32
|
Classics Specialist
Posts: 2907
Joined: 15-07-2007
PCM$: 300.00
|
I would also like to get the file sent to me post-transfers if possible, thanks in advance! |
|
|
|
Scorchio |
Posted on 14-09-2017 23:41
|
Small Tour Specialist
Posts: 2073
Joined: 14-09-2013
PCM$: 4500.00
|
I would like the file sent to me too come the time. Thanks
Manager of ISA - Hexacta in the MG
|
|
|
|
whitejersey |
Posted on 14-09-2017 23:47
|
Classics Specialist
Posts: 2905
Joined: 07-08-2011
PCM$: 300.00
|
I would also like to have the file sent to me.
|
|
|
|
Vien |
Posted on 14-09-2017 23:57
|
Small Tour Specialist
Posts: 2322
Joined: 16-06-2008
PCM$: 200.00
|
sammyt93 wrote:
I'd like to wait until after transfers and have the file sent to me please,
Partly to avoid me making any mistakes setting it up but mainly because I'm hoping to see a post transfers DB before I have to fill it in.
Same. |
|
|
|
Scorchio |
Posted on 15-09-2017 00:11
|
Small Tour Specialist
Posts: 2073
Joined: 14-09-2013
PCM$: 4500.00
|
Run the 'Hiding' macro (CTRL+SHIFT+Q)
Is there an 'unhiding' macro for thos of us who din't really know what they are doing?
Manager of ISA - Hexacta in the MG
|
|
|
|
Yellow Jersey |
Posted on 15-09-2017 00:14
|
Classics Specialist
Posts: 2809
Joined: 16-04-2013
PCM$: 900.00
|
sammyt93 wrote:
I'd like to wait until after transfers and have the file sent to me please,
Partly to avoid me making any mistakes setting it up but mainly because I'm hoping to see a post transfers DB before I have to fill it in.
Here too!
|
|
|
|
SportingNonsense |
Posted on 15-09-2017 00:35
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Scorchio wrote:
Run the 'Hiding' macro (CTRL+SHIFT+Q)
Is there an 'unhiding' macro for thos of us who din't really know what they are doing?
Select all columns from E to DR, then right click somewhere on the columns bar and click Unhide
|
|
|
|
Booker |
Posted on 15-09-2017 10:14
|
Breakaway Specialist
Posts: 875
Joined: 03-07-2013
PCM$: 200.00
|
I'd like the sheet sent to me as well, please
|
|
|
|
Ian Butler |
Posted on 15-09-2017 11:37
|
Tour de France Champion
Posts: 21854
Joined: 01-05-2012
PCM$: 400.00
|
I'd like to wait for the complete and correct file after transfers. Thanks! |
|
|