PCM.daily banner
22-11-2024 18:40
PCM.daily
Users Online
· Guests Online: 71

· Members Online: 0

· Total Members: 161,786
· Newest Member: noxairindia
View Thread
PCM.daily » PCM.daily's Management Game » [Man-Game] The Rules and Announcements
 Print Thread
[PCT/CT] Race Planners 2017
SportingNonsense
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:
i.imgur.com/HVqEpyZ.png

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:
i.imgur.com/PL47N4Z.png

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
farm8.staticflickr.com/7458/9357923136_f1e68270f3_n.jpg
 
weirdskyfan64
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
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
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?
farm8.staticflickr.com/7458/9357923136_f1e68270f3_n.jpg
 
TheManxMissile
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 Smile
i.imgur.com/UmX5YX1.jpgi.imgur.com/iRneKpI.jpgi.imgur.com/fljmGSP.jpgi.imgur.com/qV5ItIc.jpgimgur.com/dr2BAI6.jpgimgur.com/KlJUqDx.jpg[/img[img]]https://imgur.com/yUygrQ.jpgi.imgur.com/C1rG9BW.jpgi.imgur.com/sEDS7gr.jpg
 
tastasol
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.
 
Ad Bot
Posted on 22-11-2024 18:40
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
hillis91
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
i.imgur.com/sqJ8APc.png
www.pcmdaily.com/images/mg/Awards2022/jerseydesigner.png
www.pcmdaily.com/images/mg/Awards2022/graphicartist.png
 
SportingNonsense
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 F4GrinQ4 in the race planner file (It is better if you do it Paste Values)

farm8.staticflickr.com/7458/9357923136_f1e68270f3_n.jpg
 
Martii_Scots01
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.
 
tastasol
Ah, yhees. I copied that in the Sheet 2 in the planer, misunderstood that one. Thanks Smile
 
sammyt93
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
I would also like to get the file sent to me post-transfers if possible, thanks in advance!
 
Scorchio
I would like the file sent to me too come the time. Thanks
Manager of ISA - Hexacta in the MG
 
whitejersey
I would also like to have the file sent to me.
 
Vien
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
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? Rolling Eyes
Manager of ISA - Hexacta in the MG
 
Yellow Jersey
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
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? Rolling Eyes


Select all columns from E to DR, then right click somewhere on the columns bar and click Unhide
farm8.staticflickr.com/7458/9357923136_f1e68270f3_n.jpg
 
Booker
I'd like the sheet sent to me as well, please Smile
 
Ian Butler
I'd like to wait for the complete and correct file after transfers. Thanks!
 
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
New Stage Editor: 1
New Stage Editor: 1
PCM10: Official Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 18,376 PCM$
bullet df_Trek 17,374 PCM$
bullet Marcovdw 15,345 PCM$
bullet jseadog1 13,552 PCM$
bullet baseba... 10,439 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 21,890 PCM$
bullet df_Trek 15,520 PCM$
bullet Marcovdw 14,800 PCM$
bullet jseadog1 13,500 PCM$
bullet baseball... 7,332 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.40 seconds