PCM.daily banner
26-02-2020 21:47
PCM.daily
Users Online
· Guests Online: 30

· Members Online: 1
Kiserlovski01

· Total Members: 140,488
· Newest Member: gasten
Donate
View Thread
PCM.daily » PCM.daily's Management Game » [Man-Game] The Rules and Announcements
 Print Thread
[PCT/CT] Race Planners 2019
Fabianski
So, planning is almost done.
One (hopefully) last question: Will the planner be checked for fulfillment of the loan clauses? I calculated everything multiple times (of course including Avenir points - just must not miss nominations), so I'm pretty sure I got it right, but not 100% sure. And what would happen if I indeed failed to fulfill a clause? I mean, if I mess my maths up for one of my own riders, I have to live with it myself. But if I mess up for a loaned-out rider, another manager will be quite unhappy...
 
SportingNonsense
Intention will be to check them and require changes if any loan clause is not met.
farm8.staticflickr.com/7458/9357923136_f1e68270f3_n.jpg
 
roturn
All of you should now have the planner in your dropbox.

So please work on them and upload them filled to your dropbox again with a PM to Mangame-Admin once you have done.
 
Azerbaijan
Nearly done. I just need to do the math on some riders.
 
Ad Bot
Posted on 26-02-2020 21:47
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
Ollfardh
Is there a DB post transfers and training yet?
Changed my sig, this was getting absurd.
 
viking90
It should alert when I assign a rider to many racedays right?

Seems like that does not work or me atleast even tried to run "check race clashes" but that dont give any alert either.

Jurgen Roelandts have 59 RD in PCT and have a signed him for 61 RD and yet no alert.

I could plan the season and keep track on the Race Days myself but I could make a mistake that dont get noticed.
 
SportingNonsense
You're right, and it looks like this might be an issue with all team's planners.

It can be manually fixed - unhide Column ER, put the following formula in Cell ER5 "=IF(E5>D5,1,0)", and drag that formula down the column.

Else you'll just need to keep an eye on it yourself.
farm8.staticflickr.com/7458/9357923136_f1e68270f3_n.jpg
 
sammyt93
Will that solve the issue I had where it told me riders had too many days when they were nearly 30 days under?
 
SportingNonsense
sammyt93 wrote:
Will that solve the issue I had where it told me riders had too many days when they were nearly 30 days under?


It will, yes.

That column should be formulas. The files I've looked at now just have it hard-coded to 0s, and it looks in your file that there are a few rows with it hard-coded to 1s.
farm8.staticflickr.com/7458/9357923136_f1e68270f3_n.jpg
 
Tamijo
If my case it is =IF(E5>D5;1;0) so , replaced by ;

May be the same for others.
 
Fabianski
Changing column ER won't unfortunately help that much.
I already contacted roturn, as the cause of this is a mistake in the Macro that calculates the race clashes. Apparently, there's one race more in the calendar than last season, but the Macro wasn't updated. So the Macro writes the result of the race clash test into column ER instead of ES.
If you put that formula into ER, it will probably be overridden if you check again for race clashes. So don't rely on this solution. Roturn told me he would fix it in the file he'd use to check our race planners, but there won't probably be a correct file for each of us.

The wrong field the Macro uses is the cause for the incorrect message; it displays "too many RDs" instead of "Race Clash". The race clash column will actually never contain an error. So we have to be extra careful!

If you want to play around with the Macro, you should make it write the result into column 149 (ES) instead of 148 (ER).
Edited by Fabianski on 05-10-2019 23:23
 
Tamijo
Are we waiting for an updated file - or expected to solve this race clash / race day issue on our own ?
 
Fabianski
I don't think there will be an updated file, as it has to be created individually for each team.
Race clash detection actually works, it just writes to the wrong column. As a quick fix, you can use the solution that SN presented, but write the formula to column ES instead of ER. So it will flag a race clash when the rider uses too many RDs, and it will flag too many RDs when there is a race clash. I think we should be able to work with that for this time. In any case, I've uploaded my planner several days ago, so I won't need a new file anyway.
i.imgur.com/Ivui2bO.png
 
Tamijo
Dont understand why there must be a file for each team?
Race clashes is the same for everyone.
 
viking90
Tamijo wrote:
Dont understand why there must be a file for each team?
Race clashes is the same for everyone.


But different schedule for (almost) every team?
 
Tamijo
Ohh. Then I guess i'll have to figure it out myself.
 
viking90
Tamijo wrote:
Ohh. Then I guess i'll have to figure it out myself.


For my file the "race clashes" worked fine when I tested to put one rider in two races at the same day.(without changing any formulas) But the racedays did not work but that is very easy to keep track on yourself.
 
Fabianski
Actually, the same file is used as a basis for every team's planner. Then, for every team, they set a "1" for every race you participate in, in Row 4. You see that when you select any of the columns in Row 4.
Then, there's a Macro named "Hiding", which will hide all races you don't participate in. And voilĂ , you've got a different file for every team.

However, all the races are there, they're just hidden. Hence, all the columns are the same for every single planner file. That's why SN could tell exactly where to insert the formula, as it's the same for everyone.

Tamijo wrote:
Ohh. Then I guess i'll have to figure it out myself.

I'd love to help you with your planner, but I surely shouldn't see it now. But if you go with my proposition of putting the formula "=E5>D5;1;0" in the (hidden by default) column ES, cell 5, and then copy it to the cells below, you'd have a more or less working file. As I said, it would say "Error" in the "Race Days Used" column when there's a clash (and you execute the Check Race Clashes Macro), and it would say "Error" in the "Race Clashes" column when a rider uses too many RDs.

Personally, I just checked columns D and E manually, without any formula. As I haven't got feedback on my planner yet, I guess it was all fine. So yeah, there might be a "comfort" feature missing, but I think every manager will be able to compare two numbers. There will just not be a red flag when you assign too many RDs. But imho that's doable Smile

@viking: Did it really say "Race Clash" or "Too many RDs"? When I had a race clash, it said that one or more riders were above their RD allocations. Azerbaijan mentioned that "flagging issue" already way earlier.
i.imgur.com/Ivui2bO.png
 
viking90
@fabianski

Here is a picture when I put a rider in two races at the same day hence race clashe and with that race he also came over his max Racedays but that dont give an error

i.imgur.com/TB3USfp.png
 
Fabianski
OK, that's indeed correct. Then I have to take back what I said concerning all having basically the same file. Maybe it's different for PCT.

Well, the important thing is that the race clash check somehow works for all of us, no matter what error message it finally displays (for me, it definitely says that I'm above RD allocation). And that we must be careful, as the RD check does not seem to work. So in your case, I think SN's solution (add formula to colum ER) should work; in my case, it wouldn't. Sorry for the confusion. In the future, I won't suppose that everyone has got the same file Wink
i.imgur.com/Ivui2bO.png
 
Jump to Forum:
Similar Threads
Thread Forum Replies Last Post
[PCM19] A.S.O.DB 2019 PCM 19: Database 26 26-02-2020 08:15
PCM 06 - 2019 DB Pro Cycling Manager 2006 28 22-02-2020 20:59
[CT] Equinor Pro Cycling [2019] [Man-Game] Teams HQ 30 20-02-2020 18:02
CycloCross Season 2019/2020 Cycling 15 18-02-2020 07:56
1 day of race negates 1 week of break? PCM 19: General 3 08-02-2020 15:46
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Track 4
Track 4
PCM09: General Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet dominox 739 PCM$
bullet baseba... 711 PCM$
bullet jseadog1 700 PCM$
bullet Ripley 680 PCM$
bullet jandal7 602 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet baseball... 13,456 PCM$
bullet jseadog1 12,855 PCM$
bullet Marcovdw 11,593 PCM$
bullet trekbmc 11,294 PCM$
bullet Vien 10,000 PCM$

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