# Hill calculation formula

#

**1**Da Big Kahuna

Thread Starter

Join Date: May 2003

Location: Oahu, Hawaii

Posts: 814

Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

**Hill calculation formula**

Okay, I now have some data on my hills, but I need to be able to translate it into a grade percentage.

If I understand it correctly, going up hill for 5 miles with a 1 mile increase in elevation, would result in an angle of 20 degrees. If the increase were 2.5 miles, the angle would be 45 degrees. I know this isn't quite right since you should compare the horizontal distance, which would be a little less than the diagonal distance, but I suppose for bike angles of climb, that is not a major factor.

But how do you get the percentage of the grade? Isn't that different?

If I understand it correctly, going up hill for 5 miles with a 1 mile increase in elevation, would result in an angle of 20 degrees. If the increase were 2.5 miles, the angle would be 45 degrees. I know this isn't quite right since you should compare the horizontal distance, which would be a little less than the diagonal distance, but I suppose for bike angles of climb, that is not a major factor.

But how do you get the percentage of the grade? Isn't that different?

#

**2**Spinone Italiano

Join Date: Apr 2005

Location: Colorado Springs, CO

Posts: 338

Bikes:

*2000 Gary Fisher Marlin, 2006 Scattante CFR (the 2002 Bianchi Giro found a new home)*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

To calculate grade it

number of verticle (units) (usually feet)

---------------------------------------

number of horizontal (units) (same as above)

so for a 1 mile stretch of road if you gain 528 feet

528 ft

you have grade = ---------------- = 10% pretty steep climb

5280 ft

Steve

-numbers make us happy

number of verticle (units) (usually feet)

---------------------------------------

number of horizontal (units) (same as above)

so for a 1 mile stretch of road if you gain 528 feet

528 ft

you have grade = ---------------- = 10% pretty steep climb

5280 ft

Steve

-numbers make us happy

#

**3**Senior Member

Join Date: Jul 2005

Location: Littleton, CO

Posts: 206

Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Actually your angle is off...

Take the inverse tangent of the elevation divided by the horizontal to get the angle. To have a 45 degree angle (or 100% gradient), your elevation gain will equal your horizontal distance. In your example, arctan(1/5) = 11.31 degrees.

Gradient is simply rise divided by run. So 1 mile / 5 miles = 0.2 = 20% gradient = steep.

Take the inverse tangent of the elevation divided by the horizontal to get the angle. To have a 45 degree angle (or 100% gradient), your elevation gain will equal your horizontal distance. In your example, arctan(1/5) = 11.31 degrees.

Gradient is simply rise divided by run. So 1 mile / 5 miles = 0.2 = 20% gradient = steep.

#

**5**Senior Member

Join Date: Sep 2004

Location: Southern California

Posts: 1,068

Bikes:

*2013 KHS Flite 747*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

When you ride 5 miles up a hill, 5 miles is not the horizontal distance!

The angle (not the grade) of the slope is ARCSIN(1 mile/5 miles) = 11.537 degrees

The grade is just the TAN of the angle. TAN(11.537) = .204 or 20.4%

I uploaded a spreadsheet to do this a while back if you can find it.

The angle (not the grade) of the slope is ARCSIN(1 mile/5 miles) = 11.537 degrees

The grade is just the TAN of the angle. TAN(11.537) = .204 or 20.4%

I uploaded a spreadsheet to do this a while back if you can find it.

#

**6**Da Big Kahuna

Thread Starter

Join Date: May 2003

Location: Oahu, Hawaii

Posts: 814

Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Okay, let me see if I understand this.

Gradient, which is a PERCENTAGE is the vertical distance divided by the horizontal distance?

But this formula gives the ANGLE: arctan(verticla/horizontal) = a result in DEGREES?

If I have that right, I have two questions. First, which figure, percentage or degrees is most often used in hill descriptions (I think it is percentage)?

Second, since I'm trying to set up formulas for calculating the hills, I ran into a problem. Using Excel spreedsheet, it seems that "arctan" is not a term it recognizes. I found Atan, AtanH, and Atan2, but none of them seems to give a result like you show for the 1 mile vertical on a 5 mile ride. Any ideas on what the formula should be in excel?

Gradient, which is a PERCENTAGE is the vertical distance divided by the horizontal distance?

But this formula gives the ANGLE: arctan(verticla/horizontal) = a result in DEGREES?

If I have that right, I have two questions. First, which figure, percentage or degrees is most often used in hill descriptions (I think it is percentage)?

Second, since I'm trying to set up formulas for calculating the hills, I ran into a problem. Using Excel spreedsheet, it seems that "arctan" is not a term it recognizes. I found Atan, AtanH, and Atan2, but none of them seems to give a result like you show for the 1 mile vertical on a 5 mile ride. Any ideas on what the formula should be in excel?

#

**7**Senior Member

Join Date: Jul 2005

Location: Littleton, CO

Posts: 206

Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Originally Posted by

**TheRCF**Okay, let me see if I understand this.

Gradient, which is a PERCENTAGE is the vertical distance divided by the horizontal distance?

Gradient, which is a PERCENTAGE is the vertical distance divided by the horizontal distance?

But this formula gives the ANGLE: arctan(verticla/horizontal) = a result in DEGREES?

If I have that right, I have two questions. First, which figure, percentage or degrees is most often used in hill descriptions (I think it is percentage)?

Second, since I'm trying to set up formulas for calculating the hills, I ran into a problem. Using Excel spreedsheet, it seems that "arctan" is not a term it recognizes. I found Atan, AtanH, and Atan2, but none of them seems to give a result like you show for the 1 mile vertical on a 5 mile ride. Any ideas on what the formula should be in excel?

#

**8**Senior Member

Join Date: Jul 2005

Location: Littleton, CO

Posts: 206

Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Originally Posted by

**JavaMan**When you ride 5 miles up a hill, 5 miles is not the horizontal distance!

#

**9**Senior Member

Join Date: Sep 2004

Location: Southern California

Posts: 1,068

Bikes:

*2013 KHS Flite 747*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

OK, I found the post I was talking about - I did not upload the spreadsheet after all, but just posted the formula in spreadsheet form.

This is the correct formula. RISE is in feet, DISTANCE is in miles.

%GRADE = TAN(ASIN(RISE/(5280*DISTANCE)))*100

Put it into a spreadsheet for future use.

This is the correct formula. RISE is in feet, DISTANCE is in miles.

%GRADE = TAN(ASIN(RISE/(5280*DISTANCE)))*100

Put it into a spreadsheet for future use.

#

**10**Spinone Italiano

Join Date: Apr 2005

Location: Colorado Springs, CO

Posts: 338

Bikes:

*2000 Gary Fisher Marlin, 2006 Scattante CFR (the 2002 Bianchi Giro found a new home)*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Ok, JavaMan is getting hardcore with the significant digits. And I can dig that. So here is a way to use Excel to get down to the decimal points.

You need to know the (D)istance you travel up the hill (well will call that T and put that number in cell A1)

You also need to know the (E)levation gain from the bottom of the hill to the top of the hill (we will call that E and put that number in cell B1)

The formula for percent grade in cell C1 should look like this =B1/(SQRT((A1*A1)-(B1*B1))) format this to percent to 2 places

My previous example of 582ft elevation on a 1 mile hill should give the following results:

T=5280 ft in cell A1 // A1=5280

E=528 ft in cell B1 // B1=528

Using the formula above Cell C1 = 10.05%

Steve

-accuracy always counts, but it can be a bit boring

You need to know the (D)istance you travel up the hill (well will call that T and put that number in cell A1)

You also need to know the (E)levation gain from the bottom of the hill to the top of the hill (we will call that E and put that number in cell B1)

The formula for percent grade in cell C1 should look like this =B1/(SQRT((A1*A1)-(B1*B1))) format this to percent to 2 places

My previous example of 582ft elevation on a 1 mile hill should give the following results:

T=5280 ft in cell A1 // A1=5280

E=528 ft in cell B1 // B1=528

Using the formula above Cell C1 = 10.05%

Steve

-accuracy always counts, but it can be a bit boring

#

**11**Spinone Italiano

Join Date: Apr 2005

Location: Colorado Springs, CO

Posts: 338

Bikes:

*2000 Gary Fisher Marlin, 2006 Scattante CFR (the 2002 Bianchi Giro found a new home)*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Originally Posted by

**JavaMan**OK, I found the post I was talking about - I did not upload the spreadsheet after all, but just posted the formula in spreadsheet form.

This is the correct formula. RISE is in feet, DISTANCE is in miles.

%GRADE = TAN(ASIN(RISE/(5280*DISTANCE)))*100

Put it into a spreadsheet for future use.

This is the correct formula. RISE is in feet, DISTANCE is in miles.

%GRADE = TAN(ASIN(RISE/(5280*DISTANCE)))*100

Put it into a spreadsheet for future use.

Shoot! Beat out by JavaMan.

Steve

-there's more than one way to skin a hill cat

#

**12**Da Big Kahuna

Thread Starter

Join Date: May 2003

Location: Oahu, Hawaii

Posts: 814

Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Originally Posted by

**JavaMan**This is the correct formula. RISE is in feet, DISTANCE is in miles.

%GRADE = TAN(ASIN(RISE/(5280*DISTANCE)))*100

Put it into a spreadsheet for future use.

So the question becomes: Is your formula more accurate?

One of the nice things about computers is that once set, even a complicated formula can just be copied and pasted as necessary so I might as well go with whatever is best.

But while waiting for comments on the most accurate figures, I sure appreciate all the help.

Just saw another post by Fatboy but I'll have to check it out more later.

#

**13**Spinone Italiano

Join Date: Apr 2005

Location: Colorado Springs, CO

Posts: 338

Bikes:

*2000 Gary Fisher Marlin, 2006 Scattante CFR (the 2002 Bianchi Giro found a new home)*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Originally Posted by

**TheRCF**Okay, I have SirScott's formula working and we already know there is a small built-in error.

So the question becomes: Is your formula more accurate?

One of the nice things about computers is that once set, even a complicated formula can just be copied and pasted as necessary so I might as well go with whatever is best.

But while waiting for comments on the most accurate figures, I sure appreciate all the help.

Just saw another post by Fatboy but I'll have to check it out more later.

So the question becomes: Is your formula more accurate?

One of the nice things about computers is that once set, even a complicated formula can just be copied and pasted as necessary so I might as well go with whatever is best.

But while waiting for comments on the most accurate figures, I sure appreciate all the help.

Just saw another post by Fatboy but I'll have to check it out more later.

Steve

-isn't math fun

P.S. My formula calculates the real horizontal lentgh using c squared = a squared + b squared, where the distance up the hill is c and the elevation gain is a, and the real horizontal distance is b. Then I used the elevation / real horizontal distance to get the "real" grade.

#

**14**Da Big Kahuna

Thread Starter

Join Date: May 2003

Location: Oahu, Hawaii

Posts: 814

Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Okay, using Fatboy's formula - hopefully I finally did it right after a number of errors in my setup kept giving weird results - the steepest hill I think I've climbed covers three short blocks and the steepest part is 8.63. The average for all three is 7.07.

The distance is just 1065 feet. I've climbed it a few times with my old bike, which has a triple crank, but I have yet to make it with my newer bike (double crank). I've gotten half way up, but that's about it. I'm so slow, I have to worry about falling over so I can't make lock into the pedals - I'm afraind I'd start to fall and not be able to unclip successfully.

The distance is just 1065 feet. I've climbed it a few times with my old bike, which has a triple crank, but I have yet to make it with my newer bike (double crank). I've gotten half way up, but that's about it. I'm so slow, I have to worry about falling over so I can't make lock into the pedals - I'm afraind I'd start to fall and not be able to unclip successfully.

#

**15**Spinone Italiano

Join Date: Apr 2005

Location: Colorado Springs, CO

Posts: 338

Bikes:

*2000 Gary Fisher Marlin, 2006 Scattante CFR (the 2002 Bianchi Giro found a new home)*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Originally Posted by

**TheRCF**...the steepest hill I think I've climbed covers three short blocks and the steepest part is 8.63. The average for all three is 7.07.

Good luck with those hills.

Steve

-up, up and away

*Last edited by Fat Boy Biker; 09-23-05 at 11:07 AM.*

#

**16**Burnt Orange Blood

Join Date: Apr 2005

Location: Dripping Springs, Texas

Posts: 825

Bikes:

*Trek 7200, Lashout Electric Bike, Raleigh Talon*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

My biggest hill is 10.7% over about three blocks (using Google Earth to determine distance and elevation change) and I have to zigzag up it, even on my electric bike! I can't climb standing on the pedals and my heart rate went through the roof when I zigzagged up it on my Trek, even with a 32 granny gear.

#

**17**just over the next hill

Join Date: Aug 2005

Location: Kansas City MO

Posts: 543

Bikes:

*Bianchi Volpe 2006 Fuji Tahoe*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

To figure grade at one point. Use a 4' level and the # of inches from the street to the

bottom of the level (with the bubble leveled) divided by 48 = % slope.

If it is 4" from the street to the bottom of the level your equation is: 4/48 = .08333 which

would be 8.3% slope.

If you are using a 2' level you would divide by 24

bottom of the level (with the bubble leveled) divided by 48 = % slope.

If it is 4" from the street to the bottom of the level your equation is: 4/48 = .08333 which

would be 8.3% slope.

If you are using a 2' level you would divide by 24

__________________

Enjoy the ride.

Bianchi Volpe 2006; Fuji Tahoe 1990

Enjoy the ride.

Bianchi Volpe 2006; Fuji Tahoe 1990

#

**18**Da Big Kahuna

Thread Starter

Join Date: May 2003

Location: Oahu, Hawaii

Posts: 814

Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Originally Posted by

**Longhorn**My biggest hill is 10.7% over about three blocks (using Google Earth to determine distance and elevation change) and I have to zigzag up it, even on my electric bike! I can't climb standing on the pedals and my heart rate went through the roof when I zigzagged up it on my Trek, even with a 32 granny gear.

#

**19**Burnt Orange Blood

Join Date: Apr 2005

Location: Dripping Springs, Texas

Posts: 825

Bikes:

*Trek 7200, Lashout Electric Bike, Raleigh Talon*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Well, I just got one of these

so I'll doublecheck my Google Earth results.

so I'll doublecheck my Google Earth results.

#

**20**Sensible shoes.

Join Date: Aug 2005

Location: St. Paul,MN

Posts: 8,799

Bikes:

*A few.*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 2 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Originally Posted by

**CastIron**You lost me at "inverse tangent". Is there a field expedient (idiots) formula to use?

#

**21**Bent

Join Date: Jul 2004

Location: San Carlos, CA

Posts: 166

Bikes:

*2017 Trek FX S 6, 2010 Trek Madone 4.5, 2002 Gary Fisher Sugar 3+, 199? Trek 930 Singletrack*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 3 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Originally Posted by

**Fat Boy Biker**8 and 7 percent is pretty step. I did 2.5 miles on the back side of the Royal Gorge that I think averaged 10% with a few sections around 12. It was hard. One technique I saw other people use (this was on an MS-150 ride) was zig-zaging. I couldn't make that work. I just used my smallest gear. 30x25. I have a pretty standard road tripple.

I've got one section of a ride in Seattle - 41.9 feet rise over 298.2 ft, which should calculate to a 295.2 ft actual distance? It's part of a bigger hill, but it's a killa.

#

**22**Da Big Kahuna

Thread Starter

Join Date: May 2003

Location: Oahu, Hawaii

Posts: 814

Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Originally Posted by

**Longhorn**Well, I just got one of these

so I'll doublecheck my Google Earth results.

so I'll doublecheck my Google Earth results.

#

**23**Senior Member

Join Date: Sep 2004

Location: Southern California

Posts: 1,068

Bikes:

*2013 KHS Flite 747*Mentioned: 0 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

Originally Posted by

**Fat Boy Biker**JavaMan will have to explain his formula. My formula is more accurate than the simple elevation/distance. You can see in my example the real answer is 10.05% (rounded) and the close answer was 10%. Believe me, .05% wont make any difference, but as Sir Scott said, the steeper the hill, the more inaccurate it becomes. But trust me, if you can climb a 20% grade, you are the man in my books.

Steve

-isn't math fun

P.S. My formula calculates the real horizontal lentgh using c squared = a squared + b squared, where the distance up the hill is c and the elevation gain is a, and the real horizontal distance is b. Then I used the elevation / real horizontal distance to get the "real" grade.

Steve

-isn't math fun

P.S. My formula calculates the real horizontal lentgh using c squared = a squared + b squared, where the distance up the hill is c and the elevation gain is a, and the real horizontal distance is b. Then I used the elevation / real horizontal distance to get the "real" grade.

%GRADE = TAN(ASIN(RISE/(5280*DISTANCE)))*100

#

**24**Software for Cyclists

Join Date: Dec 2003

Location: Redding, California

Posts: 4,618

Bikes:

*Trek 5200, Specialized MTB*Mentioned: 2 Post(s)

Tagged: 0 Thread(s)

Quoted: 0 Post(s)

Likes: 0

Liked 0 Times
in
0 Posts

If anyone's interested, I've included a "Climbing Calculator" in my CycliStats training diary program. It calculates the grade of any hill, and allows you to estimate how much time the climb will take. It also calculates your "rate of climb" (in feet or meters climbed per hour).

And, yes, I think it's a pretty neat tool, especially if you ride much in the mountains.

And, yes, I think it's a pretty neat tool, especially if you ride much in the mountains.

*Last edited by SSP; 09-23-05 at 07:55 PM.*