|
Post by heppie on Aug 8, 2017 14:47:31 GMT 1
I have other problem for you Are you sure all that stages are SPRINT? I dont have enough time to see if you re excel is 100% accurate But i think this 2 are not SPRINT 18/11 Sa 1020 0 WC U21 TTT Norway Norway NO 20 5 5 15 0 0 0 flat SP U21 19/11 Su 1021 0 WC ITT Norway Norway NO 10 10 5 10 0 0 0 mountain SP TTT and ITT aren't sprint ofcourse but then the type should not be NO(rmal) Schizm is right. In the excel sheet a race is displayed as SP if it is a normal race without attacking points. For these cases the type of the races is wrong, not only in the excel sheet, also in the online race profiles. To fix this in the planning sheet, one can change cells E1000 and E1001 of the (hidden) sheet races2 from NO to TTT and ITT.
|
|
|
Post by Ab Normaal on Aug 8, 2017 16:37:31 GMT 1
Schizm10/7/2017 Sa Orléans - Paris Tour de France Change 10/8/2017 Su Montereau - Paris Tour de France Change this first 2 stages of France are SPRINT stages? ElGringo Ab Normaalthis first 2 stages of France are SPRINT stages? Yes. Deliberately. That is something new and forces managers to choose.
|
|
|
Post by rarau on Aug 8, 2017 17:16:11 GMT 1
tk Ab good idea
|
|
|
Post by zenekkonevka on Aug 8, 2017 19:22:41 GMT 1
Can someone post here or send me excel sheet simple version xls ?
|
|
|
Post by rarau on Aug 8, 2017 19:44:34 GMT 1
Can someone post here or send me excel sheet simple version xls ? attach Peloton_Template_S18.rar (292.35 KB) last 2 weeks could have problems
|
|
|
Post by zenekkonevka on Aug 8, 2017 20:02:04 GMT 1
Can someone post here or send me excel sheet simple version xls ? attach last 2 weeks could have problems last 2 weeks ? Thx, but I see only 3 first weeks are completed till 30.08.2017. All semptember, october, november races without terrain (M, H, F, D)
|
|
|
Post by ElGringo on Aug 8, 2017 22:14:07 GMT 1
First 2 races of France are sprint? is ok? Schizm10/7/2017 Sa Orléans - Paris Tour de France Change 10/8/2017 Su Montereau - Paris Tour de France Change this first 2 stages of France are SPRINT stages? Yes they are. Is intencional.
|
|
|
Post by rarau on Aug 9, 2017 8:14:18 GMT 1
attach last 2 weeks could have problems last 2 weeks ? Thx, but I see only 3 first weeks are completed till 30.08.2017. All semptember, october, november races without terrain (M, H, F, D) i send you an e mail on your personal mail (mail you have here on forum) i send you .ods filei cant attach here because the archive is more then 1 MB (the limit here) i try to make another .xls but have errors i make a pdf but have 9 or 58 pages i try to copy/paste in another file/ xls but lost all terrain detailes (M,H,F,D) i dont know what to do. Open Office and Libre Office are free on internet. On work i have excel 2016 but at home only Libre Office
|
|
|
Post by zenekkonevka on Aug 9, 2017 9:45:30 GMT 1
Rarau, thx for you help
because of errors I tried the simplest solution and copied missing terrain data from dropbox file. Its enough for me.
|
|
|
Post by Schizm on Aug 9, 2017 19:16:54 GMT 1
Rarau, thx for you help because of errors I tried the simplest solution and copied missing terrain data from dropbox file. Its enough for me. indeed the simplest solution is to copy the first columns (the part before the cyclists and "paste values" at the same location and then delete everything after the cyclist columns. It is also better remove the other pages.
|
|