For the interested guys the "All-in-1 preview" by jandal and me is out now in the "Preview & Statistics" thread Hope you enjoy reading it!

If either of you guys need me to help out with this, just drop me a pm

Holy crap, how do I follow that preview!!

My mostly mathematical preview of the ICL is now also posted in the 'Previews and Statistics' thread, in case you've not caught up with it already. Hope you like it

Race Planning
Please download this sheet: https://www.dropbox.com/s/1g5y9lmnjuh....xlsm?dl=0

#1 Open the DB and copy/paste your entire team in the tab "Riders". Replace the example riders that are there.
#2 Go to tab "Teams". Look for the column with your team IDs in it. Copy that column. Go to "Selected Races" and paste it in G1, overwrite "Selected?". In "Races" you now see all your races listed and also race clashes, please remember them.
#3 Now onto the actual Planning: In "Planning", you'll see your riders listed aswell as the races. You can sort the riders by name, remaining race days and their stats that are shown there, simply by pressing the buttons on top. If you want a rider to take part in a race put a 1 in the according cell.
#4 Try to send full teams to all races you are taking part in. In row 3 you see how much riders are needed.
New Features:
1. In columns BV to BY you can see how much race days a rider will do in what race category. If a WT rider is planned to have too much CT race days, the according cell in BZ will turn red.
2. It is now possible to mark and check for race clashes via a makro. If you click the button "Clashes" the clashes will be marked below the riders with "X"s. With the button "Check" you can check if some of your riders are planned for clashing races. If that's the case the according cell in BU will turn red.
Only push the buttons after you have added your riders and races to the file.
I had not that much time to check the makros, so it is possible that there are some mistakes.

Rules:
#1 Every rider has to race at least 20 race days and not more than written in the DB.
#2 Riders are not allowed to take part in clashing races, please remember that.
#3 You have to send full teams to WT races and a minimum of 5 riders to CT races, if you can't manage to do that pm me and we'll find a solution.
#4 WT teams regulations in CT races can be found here: https://pcmdaily.com/forum/viewthread....st_1188170

When done, please upload the file this time and send me a link.

If you haven't done the Race Selections yet, you of course can't fill this task out yet. Please do that first and I'll update the Planning file asap.

I hope I get the most planners until the weekend but I know that this is a very long taking task, I'll set deadlines during the next days, seeing how much I already got until then.

Well, I'm on vacation until 4th September... But I will try send it in few days, since I have prepared something before I went on holiday.

My excel gives an error, can't open the file

Mediafire somehow messes the file up, try this link: https://www.dropbox.com/s/1g5y9lmnjuh....xlsm?dl=0

can you repost the latest rider DB, i forgot to rename them and i dont recall which one was the last one.

The latest DB can always be found in this thread https://pcmdaily.c...d_id=37223

The clashes and check makro work great for me. Thanks a lot for implementation of that!

But it's a bit weird that some managers have access to race selections of other teams now before sending in their one, not a fan of that.

Do we have to send Goals too? And is there again a rule that we have to have at least 1 stage race + one-day race? (I'd rather not lol, one days are so much lottery )

btw just noticed now that Chrono San Michel U23 is only 13 kilometers long, isn't that rather short for a special TT event, especially since it implies importance of prologue stat rather than TT?

This definitely should not be happening, people can see and avoid/take races depending on what others selected.

Is there a statistic about riders who have done all 3 GTs in a year? Because Di Gregorio's going to do that with his perfect 63 race days, let's go grab some yolo KoM wins/stages

EDIT: Planning is done too, took less than 3 consecutive hours. At night it's so much easier to stay focused and avoid rushing things, I have the feeling we'll stay up. It's also easier to get carried away, which means we'll still get relegated

Happy to have all my races selected Africa is coming to the Vuelta!!

Is it correct that only 8 riders are allowed at the GTs?

yes

Planning is basically done but need to reevaluate a bit when I find time. Imo good race choices, WT calendar is more balanced due to late inclusion of Sochi, thanks.

Looking forward to the start of the season-

This may not be really fair, but I think managers that haven't send in anything yet are more of the lazy kind or don't have much time, so probably won't check out the Race Planner before sending in selections. To hide the selections would've been too much work. But if someone wants to change their selections I'll still allow it.

About goals, I still haven't figured out if and how to implement the World Cup, that's why I haven't posted that yet.

@matt: Only Adam Hansen has done this so far in the 2015 season. Last year 2 or 3 riders tried as well but all DNFed at the Giro, Dehaes, I think, only missing the time limit at the last stage.

Nice, would be awesome to at least join Hansen

Di Gregorio was really too good in the sole GT he participated to last year, attacking tons of times and getting good results in the KoM standings, while not even getting close to that performance the rest of the reason, so I figured I should just send him to all 3 GTs

@Matt: you won't be the only one my friend

Will see if I can get around to fill in the planning this weekend, is amazing weather here though, so won't promise anything jut yet.