|
Custom Team League - Season Planning
|
| TheManxMissile |
Posted on 29-09-2015 23:22
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
Jamming in a late sign-up  And i've done the rider creation and am pm'ing it to you now 
Team Name: #YOLO
Abbreviation: YLO
Nationality: 
Secondary Nationality (optional): 
Other Nationalities:
Jersey*:
|
| |
|
|
| jandal7 |
Posted on 29-09-2015 23:27
|
World Champion
Posts: 11392
Joined: 17-12-2014
PCM$: 1020.00
|
Oh I called Hastag Yolo as soon as I saw TMM had posted.
Completely forgot about this btw, will try and do the rider creation soon.
24/02/21 - kandesbunzler said “I don't drink famous people."
15/08/22 - SotD said "Your [jandal's] humour is overrated"
11/06/24 - knockout said "Winning is fine I guess. Truth be told this felt completely unimportant."
[ICL] Santos-Euskadi | [PT]  Xero Racing
5x  x5
2x  x2
2x  x2 |
| |
|
|
| SSJ2Luigi |
Posted on 30-09-2015 19:53
|
World Champion
Posts: 11971
Joined: 21-07-2012
PCM$: 400.00
|
trekbmc wrote:
@SSJ2Luigi: You can but it'll need to be done by 20:00 Daily Time.
clutch 
Team Name: Vegeta Cycling Team
Abbreviation: VCT
Nationality: 
Secondary Nationality (optional): 
Other Nationalities: 
Jersey*: https://www.dropb...a.png?dl=0
Edited by SSJ2Luigi on 30-09-2015 20:02
|
| |
|
|
| trekbmc |
Posted on 01-10-2015 10:08
|
Team Leader
Posts: 7366
Joined: 11-07-2014
PCM$: 700.00
|
Ok, Thanks for joining.  Arrived home later than expected, but I've pretty much finished getting the next file ready (adding db and stuff), so I'll post it today or tomorrow morning (Austrlian time )
"What done is, is one." - Benji Naesen
|
| |
|
|
| Ad Bot |
Posted on 22-11-2024 12:26
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| trekbmc |
Posted on 02-10-2015 05:38
|
Team Leader
Posts: 7366
Joined: 11-07-2014
PCM$: 700.00
|
Ok, I'm really sorry for yet another delay (I have the motivation this time, but I get technical issues now  ), but really I couldn't do anything about it, I literally have the next document ready to post as soon as I get replies from some people due to something weird either on my computer or a website.
"What done is, is one." - Benji Naesen
|
| |
|
|
| trekbmc |
Posted on 04-10-2015 22:46
|
Team Leader
Posts: 7366
Joined: 11-07-2014
PCM$: 700.00
|
The calendar has been updated in the second post, the team time trial will be Stage 4 of the 2015 Paris-Nice, which is 24km slightly uphill.
Race clashes will be Tirreno and San Remo, Roubaix and Norway, TDF and Milano Torino, USA and Vattenfall, you'll have to check those yourself though.
All profiles are 2015 profiles, which can be found in PCM15 and probably online, if you can't find one, post here and I'll take a screenshot/post a link to it.
Team planning will be up soon.
"What done is, is one." - Benji Naesen
|
| |
|
|
| trekbmc |
Posted on 04-10-2015 23:46
|
Team Leader
Posts: 7366
Joined: 11-07-2014
PCM$: 700.00
|
Ok, finally Season Planning!  The sheet will also contain the database, although I won't release the database on it's own until we have national champions (I'll explain how that will work soon, but jerseys will be optional and not compulsory).
Instructions:
1.Download the season planning document here: https://www.media...4uh6x2u6yu
2.Put your team ID in cell B1.
3.Sort the database by ID, then Sort or filter the database to your team and copy paste the rider IDs, first names, last names, average and race days make sure they all match up with the right rider.
4. Columns G to AE are the race, row 1 is the name of each race, row 2 is number of race days, row 21 is the number of riders needed and row 22 is how many more riders you can have.
5. For each race put a 1 in the corresponding cell for any rider you would like to participate (it has to be a 1).
6.You must have at least within 2 of the amount of riders required (so if 8 riders is required you must have at least 6, if 5 riders is required, you must have at least 3) and you can't go over the amount (if so the number in row 22 will turn red).
7.Make sure their are no race clashes (as mentioned in the post above).
8. Upload the sheet and PM it to me.
I'm not setting a time limit as such, quite yet, but I'd like to see them all in the next week.
If you have any questions feel free to ask (I've probably forgotten something )
Edited by trekbmc on 05-10-2015 00:47
"What done is, is one." - Benji Naesen
|
| |
|
|
| Bikex |
Posted on 05-10-2015 00:21
|
Team Leader
Posts: 7255
Joined: 25-08-2012
PCM$: 600.00
|
Will take a closer look at this tomorrow, but some stuff I noticed already now.
1. I'm not happy at all how some of the others made their riders, it seems like 85s and 55s are the numbers that are represented the most in the DB. As someone who tried to make a balanced team, this kind of ruins that approach. A rider with 85 in 8 of 13 stats is just too OP to my liking.
2. The country is called Ecuador and the team Movistar Team and not Movistar Cycling. It's correct in the team tab but not in the Database.
3. Some funny names for some riders there, like Bruce Kanga-Roe and Greit Performans.
I for my part only took regen names, didn't have to be creative that way. |
| |
|
|
| TheManxMissile |
Posted on 05-10-2015 00:53
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
1. Very confused by the two 19yo's at CCC, when the min. age was 20
The minimum age is 20
See, nice and simple rule that one
2. Nice to see people going for realism, as per usual in this type of thing
3. Nice to see some people using a variety of ages and going into older riders (excluding the obvious jokes), not just eaking every last drop out of the rule. Props guys, really cool
4. Loving some of the creativity on names, CCC missing the point a bit i feel My fav's are '2' and 'Err:520'
5. I wish i didn't have so many 55's in my team but after making the first few riders i rapidy ran out of points
6. It's #YOLO, not just YOLO. Don't disgrace my team
|
| |
|
|
| trekbmc |
Posted on 05-10-2015 00:59
|
Team Leader
Posts: 7366
Joined: 11-07-2014
PCM$: 700.00
|
@TMM: 1.That's been fixed, I was 90% sure it was in the db, but I'll re-upload one that's fixed
2/3.
4. Wait, where did 2 and Err:520 come from, if it's CCC, then I'll fix it when I upload again (something went wrong with them on my side )
6. Nitpicking But I'll fix it since I'm updating it.
Actually I may have fixed some of these already without realising it, since my first upload didn't contain Vegeta Which has been fixed.
@bikex:
1.Yeah I know, at least the race days does something for it.
2. Sorry, I'll fix that as well.
"What done is, is one." - Benji Naesen
|
| |
|
|
| TheManxMissile |
Posted on 05-10-2015 01:02
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
trekbmc wrote:
1.That's been fixed, I was 90% sure it was in the db, but I'll re-upload one that's fixed
I assume they don't both go to 20, cause then CCC will have three 20yo's which is against another rule
|
| |
|
|
| TheManxMissile |
Posted on 05-10-2015 01:12
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
trekbmc wrote:
1.Yeah I know, at least the race days does something for it.
Just looking, i think the Race Days need some more adjusting. The, and i'm claiming this nickname, 'EPO-Monsters' (the 84-85AVGs) at the top of the AVG charts have 25 race days. Then we've got 8 riders with AVG80, on the same Race Days. To me that doesn't feel right when you make the easy conclusion of which riders will dominate.
In fact anyone AVG80+ has 25days, which is 30 riders, whereas at almost every other AVG change of 1 value.
Following through it should be 81=22, 82=19, 83=16, 84=12 and 85=7/8 (roughly), which i think would work pretty well with a few extras. Such as: The above race days OR one GT. +2 Race Days for each year over 2. You get the idea.
|
| |
|
|
| trekbmc |
Posted on 05-10-2015 01:12
|
Team Leader
Posts: 7366
Joined: 11-07-2014
PCM$: 700.00
|
The document is fixed. Let me know if you find any other mistakes.
Spoiler TheManxMissile wrote:
trekbmc wrote:
1.That's been fixed, I was 90% sure it was in the db, but I'll re-upload one that's fixed
I assume they don't both go to 20, cause then CCC will have three 20yo's which is against another rule
I made one of the 20 year olds 21 and one of the 21 year olds 22.
"What done is, is one." - Benji Naesen
|
| |
|
|
| trekbmc |
Posted on 05-10-2015 01:22
|
Team Leader
Posts: 7366
Joined: 11-07-2014
PCM$: 700.00
|
TheManxMissile wrote:
trekbmc wrote:
1.Yeah I know, at least the race days does something for it.
Just looking, i think the Race Days need some more adjusting. The, and i'm claiming this nickname, 'EPO-Monsters' (the 84-85AVGs) at the top of the AVG charts have 25 race days. Then we've got 8 riders with AVG80, on the same Race Days. To me that doesn't feel right when you make the easy conclusion of which riders will dominate.
In fact anyone AVG80+ has 25days, which is 30 riders, whereas at almost every other AVG change of 1 value.
Following through it should be 81=22, 82=19, 83=16, 84=12 and 85=7/8 (roughly), which i think would work pretty well with a few extras. Such as: The above race days OR one GT. +2 Race Days for each year over 2. You get the idea.
I can see what you mean, I went 25 to allow for GTs, especially as it won't kill anybody given they were probably going to race a GT anyway, I won't edit it quite yet though, I'll leave a little time so anybody who disagrees can post their opinion.
"What done is, is one." - Benji Naesen
|
| |
|
|
| SSJ2Luigi |
Posted on 05-10-2015 01:24
|
World Champion
Posts: 11971
Joined: 21-07-2012
PCM$: 400.00
|
oh god it's happening already
|
| |
|
|
| jandal7 |
Posted on 05-10-2015 03:45
|
World Champion
Posts: 11392
Joined: 17-12-2014
PCM$: 1020.00
|
I completely forgot about ages so that's why mine are minimums. I tried balanced as possible but I went for quality over quantity, maybe my time trial list, classics guy and to an extent (not really) Vaillenos are unbalanced. But I like my riders like Asquez for example.
It was fun making Brits, Yanks and Aussies with funny names work for the Kiwis
I think the one GT plus a bit rule is good for EPO-Monstersâ„¢, will make things interesting. I think a slightly adjusted scale for this season after this discussion and we see how it goes.
Damn I regret that time triallist now. At least I gave him decent GT domestique stats, because that is his job. He needs the rest of the season to get EPO out of his system
Now taking bets on how many times we can say "Greit Performans from him there" before everyone starts getting the pitchforks ready when someone does. 3, 4?
Peter Pal  what is the point of 80MON there. Finally we know the other four Feunards. And Oldfart really wanted the cobbled classics, didn't he 
Yes OZRocker how did you guess
Edited by jandal7 on 05-10-2015 03:51
24/02/21 - kandesbunzler said “I don't drink famous people."
15/08/22 - SotD said "Your [jandal's] humour is overrated"
11/06/24 - knockout said "Winning is fine I guess. Truth be told this felt completely unimportant."
[ICL] Santos-Euskadi | [PT] Xero Racing
5x x5
2x x2
2x x2 |
| |
|
|
| OZrocker |
Posted on 05-10-2015 03:46
|
Protected Rider
Posts: 1280
Joined: 21-07-2012
PCM$: 300.00
|
Looks good, one of my riders has the wrong surname though. Giuseppe Tagliani should be Giuseppe La Rocca but it doesn't really matter for how the file works.
Liking some of the names, Tao Google Earth has to be one of the best so far! I have a feeling H. Choker from Strava was created this weekend
|
| |
|
|
| trekbmc |
Posted on 05-10-2015 03:57
|
Team Leader
Posts: 7366
Joined: 11-07-2014
PCM$: 700.00
|
Corrected it for you. But couldn't make the M in the right spot.
@Ozrocker: Sorry, I'll fix it up.
"What done is, is one." - Benji Naesen
|
| |
|
|
| jandal7 |
Posted on 05-10-2015 03:59
|
World Champion
Posts: 11392
Joined: 17-12-2014
PCM$: 1020.00
|
trekbmc wrote:
Corrected it for you. But couldn't make the M in the right spot.
@Ozrocker: Sorry, I'll fix it up.
I was going to do that but then I found the actual â„¢ button on my tablet and it looked weird. Didn't think of small text
24/02/21 - kandesbunzler said “I don't drink famous people."
15/08/22 - SotD said "Your [jandal's] humour is overrated"
11/06/24 - knockout said "Winning is fine I guess. Truth be told this felt completely unimportant."
[ICL] Santos-Euskadi | [PT] Xero Racing
5x x5
2x x2
2x x2 |
| |
|
|
| trekbmc |
Posted on 05-10-2015 04:07
|
Team Leader
Posts: 7366
Joined: 11-07-2014
PCM$: 700.00
|
I can't even get the normal TM on my computer.
The sheet has been updated again as Ozrocker said, no need to download it again, although I have added birthdates (all 1st January) and first initial.lastname more for conveniency with the actual database.
Whenever someone finds a mistake I'll update it, but I'm 99% sure there will be nothing that requires a re-download, unless we make the "EPO-Monstersâ„¢M" racedays change.
Also, it'd be great if someone with some database making experience could give me and hand, I've put all the tables as I assume correctly into the excel editor, but the build CBD button doesn't work.
"What done is, is one." - Benji Naesen
|
| |
|
![imgur.com/KlJUqDx.jpg[/img[img]]https://imgur.com/yUygrQ.jpg](https://imgur.com/KlJUqDx.jpg[/img[img]]https://imgur.com/yUygrQ.jpg)
