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.
10/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.
Melres United S1 Div 5:38 | S2 Div 4:23 | S3 Div 4:26 | S4 Div 3:13 | S5 Div 2:2 | S6 Div 1:1 | S7 Div 2:2 | S8 Div 2:2 | S9 Div 2:2 | S10 Div 2:2 | S11 Div 2:2 | S12 Div 1:1 | S13 Div 2:2 | S14 Div 2:2 | S15 Div 2:2 | S16 Div 2:2 | S17 Div 2:2 | S18 Div 3:2 | S19 Div 3:2 | S20 Div 2:1 | S21 Div 1:1 | S22 Div 2:1 | S23 Div 2:1 |
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.