Race Planners 2012
|
Heine |
Posted on 20-07-2011 05:06
|
Grand Tour Specialist
Posts: 4116
Joined: 08-04-2007
PCM$: 200.00
|
I Pmed you that I got the wrong race planner SN ;-)
|
|
|
|
roturn |
Posted on 20-07-2011 08:30
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
A little bit tidied up here. Next time please don`t feed the troll as Sharky wrote so nicely.
Then out of 1 message a whole new page makes it a bit confusing. |
|
|
|
Ad Bot |
Posted on 21-11-2024 20:16
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
ANFreeman |
Posted on 20-07-2011 09:01
|
Protected Rider
Posts: 1019
Joined: 11-05-2009
PCM$: 200.00
|
I had the same issue regarding the Tour De Pologne, and then the error 512, same as Tsmoha, when trying to paste in the new formulas.
I checked online, and it's something to do with a formula overflow, though honestly, I had no idea what it meant.
Bearing in mind, I'm using Open Office, rather than excel, so not sure whether the problem's limited to Open Office. I'd assume so, since it's worked for everyone else.
However, I did manage to fix it. Opening the formula in E5, I found the section that referred to Tour De Pologne, and removed the erroneous $ symbol, and then simply used the drag function to copy it into the boxes below. Everything seems to work now
Small error aside, it's a rather excellently made spreadsheet, SN
[url=https://pcmdaily.com/messages.php?msg_send=19438]-Requests for Man-Game 2014 jerseys are OPEN!
Click to request!-[/url]
|
|
|
|
SportingNonsense |
Posted on 20-07-2011 10:48
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
ANFreeman wrote:
However, I did manage to fix it. Opening the formula in E5, I found the section that referred to Tour De Pologne, and removed the erroneous $ symbol, and then simply used the drag function to copy it into the boxes below. Everything seems to work now
Yes, that is the easier way to fix the problem.
|
|
|
|
Rin |
Posted on 20-07-2011 13:21
|
Small Tour Specialist
Posts: 2748
Joined: 14-04-2008
PCM$: 200.00
|
I have problems to decide who should ride each race.. I will completly bonk that.. Especially after don't knowing that much who would be best for which race etc. and Cobo hasn't got that much race days
Team Bianchi - 2012 Man-Game ProContinental Tour Champions
|
|
|
|
rjc_43 |
Posted on 20-07-2011 13:40
|
Team Leader
Posts: 6716
Joined: 13-10-2007
PCM$: 200.00
|
Well, as long as you make a complete hash of it, and put Cobo into all the cobbled races, there's hope for the rest of us
[url=cleavercycling.co.uk] [/url]
|
|
|
|
Rin |
Posted on 20-07-2011 14:07
|
Small Tour Specialist
Posts: 2748
Joined: 14-04-2008
PCM$: 200.00
|
The only cobbled race for him would be the Profonde van Drenthe, I thought it would be hilly but.. after looking at the profile a big bianchi bust.. Maybe Ciolek or Lequatre for this but I doubt the will perform there
Actually Cobos race plan looks good, he will race the races I want him to be (for example defending his race wins last season and some harder races where I think Monfort, Gil, de la Fuente, Lloret, Claeys, Rabon etc. won't be that good like Cobo) and he got still race days left..
But the biggest problem is with so many hill riders is how they will work together and there will be races for Rabon for example where he would be the 4th best rider I think..^^
Team Bianchi - 2012 Man-Game ProContinental Tour Champions
|
|
|
|
Waghlon |
Posted on 20-07-2011 14:14
|
Grand Tour Champion
Posts: 7694
Joined: 18-08-2007
PCM$: 200.00
|
It costs 40.000 to have Valverde ride for a single day in the Continental Tour.
THE THOMAS VOECKLER PROPHET OF PCM DAILY
|
|
|
|
Rin |
Posted on 20-07-2011 17:39
|
Small Tour Specialist
Posts: 2748
Joined: 14-04-2008
PCM$: 200.00
|
When I put a 1 at the GP of Wales and the Österreichrundfahrt, it says that it will be clashing. But it doesn't say on the race profile threads that they are clashing, should I ignore that?
When I put a 1 at Öster. and Manx, it says right that it will be a race clash
Team Bianchi - 2012 Man-Game ProContinental Tour Champions
|
|
|
|
SportingNonsense |
Posted on 20-07-2011 17:51
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Rin wrote:
When I put a 1 at the GP of Wales and the Österreichrundfahrt, it says that it will be clashing. But it doesn't say on the race profile threads that they are clashing, should I ignore that?
When I put a 1 at Öster. and Manx, it says right that it will be a race clash
That is a mistake in the file. Easiest thing is to ignore the error message, and just remind me when you send the planner. (The alternate is to unhide the columns between CM and EM, delete Column DO, and then hide all those columns again*)
(*Note: If other teams are reading this, the column to delete is DO if you have no wildcards, DP if you have 1, DQ if you have 2 and DR if you have 3)
Also Rin, your planner file has the wrong Locatelli down for you - it should be Stefano, not Paolo. (Same amount of race days for both though)
|
|
|
|
Setzel |
Posted on 20-07-2011 17:55
|
Classics Specialist
Posts: 3692
Joined: 16-04-2007
PCM$: 200.00
|
So wheres my race planner ?
Eating my daily Breakfast at 9 pm
|
|
|
|
SportingNonsense |
Posted on 20-07-2011 17:56
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Setzel wrote:
So wheres my race planner ?
The more appropriate question being, wheres your transfers file?
|
|
|
|
Setzel |
Posted on 20-07-2011 17:56
|
Classics Specialist
Posts: 3692
Joined: 16-04-2007
PCM$: 200.00
|
In your inbox
Eating my daily Breakfast at 9 pm
|
|
|
|
SportingNonsense |
Posted on 20-07-2011 17:59
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Just checked, and SN-ManGame has no new messages. Certainly not any transfers files in the correct PM title format, as the topic required.
|
|
|
|
Setzel |
Posted on 20-07-2011 18:02
|
Classics Specialist
Posts: 3692
Joined: 16-04-2007
PCM$: 200.00
|
Well i can be a troll and spam your inbox until u read my pm'es if u wanna have fun today.
Eating my daily Breakfast at 9 pm
|
|
|
|
Rin |
Posted on 20-07-2011 18:28
|
Small Tour Specialist
Posts: 2748
Joined: 14-04-2008
PCM$: 200.00
|
The next problem (but not related to the race plan codes)
Do I have to enter the full number of riders to take part at a race?
Something doesn't work out in my race plan, many riders have 1 race day left and 2 races wouldn't have enough riders (they are clashing)
If I would fill in all riders possible in 1 race, the other race would have just 4 riders but I would prefer that both races wouldn't have the full number of riders so 1 race would have 6 and the other 5 riders instead of 7 (full) and 4 riders, is this ok?
I think they would still have a good enough result in there
Team Bianchi - 2012 Man-Game ProContinental Tour Champions
|
|
|
|
SportingNonsense |
Posted on 20-07-2011 18:36
|
Team Manager
Posts: 33046
Joined: 08-03-2007
PCM$: 200.00
|
Thats fine
|
|
|
|
Rin |
Posted on 20-07-2011 20:20
|
Small Tour Specialist
Posts: 2748
Joined: 14-04-2008
PCM$: 200.00
|
Ok, after thinking about this I got these both race line-ups to 7 riders each race so it's ok
Team Bianchi - 2012 Man-Game ProContinental Tour Champions
|
|
|
|
Rin |
Posted on 20-07-2011 20:27
|
Small Tour Specialist
Posts: 2748
Joined: 14-04-2008
PCM$: 200.00
|
Forgot to say that I am done with the race plan and I hope that I haven't cracked up the "race plan season", as I tend to get it wrong somehow
I can't wait for this season, it will be superb
Team Bianchi - 2012 Man-Game ProContinental Tour Champions
|
|
|
|
Sykkel_Freak |
Posted on 20-07-2011 21:08
|
Small Tour Specialist
Posts: 2073
Joined: 11-07-2010
PCM$: 200.00
|
Just finished mine. I must say it: If Di Maggio can perform, his amount of racedays should come in handy.
|
|
|