PCM.daily banner
14-10-2019 21:27
PCM.daily
Users Online
· Guests Online: 19

· Members Online: 3
Azerbaijan, Tamijo, jalonsomunoz

· Total Members: 139,799
· Newest Member: WoPoll
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.
 
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.
 
Ad Bot
Posted on 14-10-2019 21:27
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
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.

i.imgur.com/nEJjzHN.png


If you're interested in weird music:
https://tamijo201...dpress.com
 
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 ?

i.imgur.com/nEJjzHN.png


If you're interested in weird music:
https://tamijo201...dpress.com
 
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.

i.imgur.com/nEJjzHN.png


If you're interested in weird music:
https://tamijo201...dpress.com
 
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.

i.imgur.com/nEJjzHN.png


If you're interested in weird music:
https://tamijo201...dpress.com
 
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
Tamijo's Stages - Danmark Rundt 2019 PCM 18: Stages 171 14-10-2019 21:24
[PT] Race Planners 2019 [Man-Game] The Rules and Announcements 11 14-10-2019 21:00
[PT] EA Vesuvio [2019] [Man-Game] Teams HQ 74 14-10-2019 20:49
PCM Velogames Championship 2019 - League Code 815672136 Cycling 448 14-10-2019 17:41
Penny Pinching 2019: Coach for success PCM 14: Stories 209 14-10-2019 07:24
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Leadout train
Leadout train
PCM12: General Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet Vien 19,234 PCM$
bullet df_Trek 10,901 PCM$
bullet jseadog1 9,992 PCM$
bullet baseba... 9,904 PCM$
bullet Paul23 9,050 PCM$

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

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