# Need help figuring a math problem out.

Posts: 10,903 Member
I'm going to ride up Hurricane Ridge. Somebody is going to meet me at the top with electrolyte water and carbs.

This is a bit more sustained climbing that I've done before. The road is 17 miles long, and gains 5,240 feet. I'd like to have some idea how I'm going to pace myself, it'll help me make sure I'm ready.

Given my and the bike's weight, can Excel tell me how long it'll take to get to the top at a specific power output? I'd like to see a graph of my options.

With that, it should be pretty obvious how much training I'll need to make this comfortable, if any.

## Replies

• Posts: 103 Member
Basically you are converting work to potential energy. Here is a paper about walking up a hill, which is basically the same thing.
• Posts: 11,465 Member
I don't know the answer to your question , but I'm familiar with the road (from a car lol). Have fun and be prepared for any kind of weather!
• Posts: 955 Member
I know there is a way, because the same works backwards. That's how they used to say things like Contador needed 1400W to climb Alp D'huez in 15 minutes.
Its also how Strava's virtual power works.

I don't know it though.
• Posts: 11,465 Member
edited June 2017
Does this give you what you need?
http://bikecalculator.com/
or
http://www.wikihow.com/Calculate-Power-Output
You might be able to figure out the formula from this one.
• Posts: 10,903 Member
Thanks for sharing your thoughts, everyone!

@lorrpb the bike calculator worked. It gives me numbers very very close to what I've recorded in the past on big hills around here, so I trust it pretty well. I was hoping for a formula I could plug into Excel and chart a lot of different power levels, but instead I wound up having the bike calculator site come up with estimates for me at 20 watt intervals and, well, it's a little daunting.
• Posts: 11,465 Member
edited June 2017
Yes, Hurricane Ridge is one big "hill" lol. Glad the calculator helped! You are so cool, maybe we'll get to meet sometime.