# Gradient Formula Help please

berliner
Posts:

**340**
I just climbed a hill 1.71 k length total climb 137 meters.

How do I work out the the average gradient?

An excel formula would be great.

Thanks

How do I work out the the average gradient?

An excel formula would be great.

Thanks

0

## Posts

3,1391710Cell A2 enter

137Cell A3 enter '

=A2/A1*100" (ignore the speech marks)Answer should be around 8%

Cell A3 enter the combined weight of the bike and you in kgs

Cell A4 enter

"=A3*9.81*A2" (this in how many kilojoules you used, and is roughly the calories used too)Cell A5 enter the time taken in seconds to climb the hill

Cell A6 enter "

A4/A5" (this is the average watts you produced over the climbI can build you an excel spreadsheet if you like. PM me your email address and I'll do it tonight.

2,877e.g

137 / 1710 * 100 = 8.01%

edit : beaten to it! 8)

1,951http://www.bikeforums.net/showthread.ph ... calculator

501Interesting.

I did not know that riding on the flat you use ZERO energy or power.

3403,139You don't (as you know), but on the flat all your power is consumed by the various drags and frictions. For a climb you can work out how much power is required to lift the weight a known distance, and from that make an assessment of power used. While not purely scientific, assuming the same hill and the same bike, it is a simple way to see if power is increasing through training.

On my local hill I produce 350W power for 8 mins (measured with a PowerTap) of which 40W is drag/resistance (at a speed of 7mph). For different riders the drag figure will be different, but roughly constant to the individual over time so can be largely ignored.

Hope that helps.

1,951If you have constrained all the variables then time alone would tell you same thing surely.

3,1391,951Ahh ok. I thought you had said you were assuming they were the same however I notice you only mentioned the ame bike so that leaves the riders weight as still possible to change. My bad