[font=Times New Roman][/font]
[font=Times New Roman] [/font]
[font=Times New Roman]Hi,[/font]
[font=Times New Roman] [/font]
[font=Times New Roman]In order to measure the grade at certain sections of a very (very) steep ‘service road’, I checked the LISTING file of the POLAR software and copied it to an excel spreadsheet.[/font]
[font=Times New Roman]Parameters are sampled every 5 sec. and I was dividing the ‘change in Altitude’ by the ‘change in distance’[/font]
[font=Times New Roman] [/font]
[font=Times New Roman]Theoretically this should be the way to measure.. only there are sections there that the ratio over one sample is even higher then 50% !! (attached XLS spreadsheet).[/font]
[font=Times New Roman] [/font]
[font=Times New Roman]Well this hill is indeed very steep – I climb with CX bike (CX tires) and use ring/cog 34/34 or 34/30 - lean forward and even when the road is dry, I feel some slidings at the rear wheel…!! [/font]
[font=Times New Roman] [/font]
[font=Times New Roman]Altitude values are negative as the part of the place is below sea level[/font]
[font=Times New Roman] [/font]
[font=Times New Roman]Does it make sense .. what can be the wrong things here.. ? Thanks!![/font]
[font=Times New Roman] [/font]
[font=Times New Roman] [/font]
[font=Arial]HR[/font]
[font=Arial]spd[/font]
[font=Arial]altitude[/font]
[font=Arial]distance[/font]
[font=Arial] [/font]
[font=Arial] [/font]
[font=Arial]Grade..!![/font]
[right][font=Arial]159[/font]
[/right]
[right][font=Arial]5.5[/font]
[/right]
[right][font=Arial]-70[/font]
[/right]
[right][font=Arial]14.678[/font]
[/right]
[right][font=Arial]4[/font]
[/right]
[right][font=Arial]-7[/font]
[/right]
[right][font=Arial]-57.14%[/font]
[/right]
[right][font=Arial]160[/font]
[/right]
[right][font=Arial]4.9[/font]
[/right]
[right][font=Arial]-68[/font]
[/right]
[right][font=Arial]14.685[/font]
[/right]
[right][font=Arial]2[/font]
[/right]
[right][font=Arial]-7[/font]
[/right]
[right][font=Arial]-28.57%[/font]
[/right]
[right][font=Arial]159[/font]
[/right]
[right][font=Arial]5.1[/font]
[/right]
[right][font=Arial]-67[/font]
[/right]
[right][font=Arial]14.692[/font]
[/right]
[right][font=Arial]1[/font]
[/right]
[right][font=Arial]-8[/font]
[/right]
[right][font=Arial]-12.50%[/font]
[/right]
[right][font=Arial]158[/font]
[/right]
[right][font=Arial]5.7[/font]
[/right]
[right][font=Arial]-66[/font]
[/right]
[right][font=Arial]14.7[/font]
[/right]
[right][font=Arial]1[/font]
[/right]
[right][font=Arial]-12[/font]
[/right]
[right][font=Arial]-8.33%[/font]
[/right]
[right][font=Arial]159[/font]
[/right]
[right][font=Arial]8.3[/font]
[/right]
[right][font=Arial]-64[/font]
[/right]
[right][font=Arial]14.712[/font]
[/right]
[right][font=Arial]2[/font]
[/right]
[right][font=Arial]-11[/font]
[/right]
[right][font=Arial]-18.18%[/font]
[/right]
[right][font=Arial]163[/font]
[/right]
[right][font=Arial]7.8[/font]
[/right]
[right][font=Arial]-62[/font]
[/right]
[right][font=Arial]14.723[/font]
[/right]
[right][font=Arial]2[/font]
[/right]
[right][font=Arial]-11[/font]
[/right]
[right][font=Arial]-18.18%[/font]
[/right]
[right][font=Arial]166[/font]
[/right]
[right][font=Arial]7.8[/font]
[/right]
[right][font=Arial]-58[/font]
[/right]
[right][font=Arial]14.734[/font]
[/right]
[right][font=Arial]4[/font]
[/right]
[right][font=Arial]-8[/font]
[/right]
[right][font=Arial]-50.00%[/font]
[/right]
[right][font=Arial]169[/font]
[/right]
[right][font=Arial]6.1[/font]
[/right]
[right][font=Arial]-55[/font]
[/right]
[right][font=Arial]14.742[/font]
[/right]
[right][font=Arial]3[/font]
[/right]
[right][font=Arial]-8[/font]
[/right]
[right][font=Arial]-37.50%[/font]
[/right]
[right][font=Arial]170[/font]
[/right]
[right][font=Arial]5.4[/font]
[/right]
[right][font=Arial]-53[/font]
[/right]
[right][font=Arial]14.75[/font]
[/right]
[right][font=Arial]2[/font]
[/right]
[right][font=Arial]-7[/font]
[/right]
[right][font=Arial]-28.57%[/font]
[/right]
[right][font=Arial]170[/font]
[/right]
[right][font=Arial]5.1[/font]
[/right]
[right][font=Arial]-52[/font]
[/right]
[right][font=Arial]14.757[/font]
[/right]
[right][font=Arial]1[/font]
[/right]
[right][font=Arial]-7[/font]
[/right]
[right][font=Arial]-14.29%[/font]
[/right]
[right][font=Arial]169[/font]
[/right]
[right][font=Arial]4.9[/font]
[/right]
[right][font=Arial]-50[/font]
[/right]
[right][font=Arial]14.764[/font]
[/right]
[right][font=Arial]2[/font]
[/right]
[right][font=Arial]-7[/font]
[/right]
[right][font=Arial]-28.57%[/font]
[/right]
[right][font=Arial]167[/font]
[/right]
[right][font=Arial]4.7[/font]
[/right]
[right][font=Arial]-50[/font]
[/right]
[right][font=Arial]14.771[/font]
[/right]
[right][font=Arial]0[/font]
[/right]
[right][font=Arial]-7[/font]
[/right]
[right][font=Arial]0.00%[/font]
[/right]
[right][font=Arial]166[/font]
[/right]
[right][font=Arial]4.8[/font]
[/right]
[right][font=Arial]-47[/font]
[/right]
[right][font=Arial]14.778[/font]
[/right]
[right][font=Arial]3[/font]
[/right]
[right][font=Arial]-7[/font]
[/right]
[right][font=Arial]-42.86%[/font]
[/right]
[right][font=Arial]165[/font]
[/right]
[right][font=Arial]5.2[/font]
[/right]
[right][font=Arial]-45[/font]
[/right]
[right][font=Arial]14.785[/font]
[/right]
[right][font=Arial]2[/font]
[/right]
[right][font=Arial]-8[/font]
[/right]
[right][font=Arial]-25.00%[/font]
[/right]
[font=Times New Roman] [/font]