Ok I need help Setting up this excell spread sheet. I have done it but am not getting the right answers. A university mountain bike (MTB) coach is in the process of reworking the drivetrain for his newest scholarship rider. He will install the 11-34T sprocket configuration. unloaded tire diameter = 29 inches tire radius= 14.5 LOADED tire radius.= 13.75 The coach has instructed the new athlete to create a robust spreadsheet. At a MINIMUM, it shall include: All of the Velocity Ratios An automated calculation(s) for the following: Given: MTB Speed (mph) Sprocket (# Teeth) Chainring (# Teeth) Find: The rpm the rider must pedal to maintain this speed (aka rider's cadence)
Ok I need help Setting up this excell spread sheet. I have done it but am not getting the right answers. A university mountain bike (MTB) coach is in the process of reworking the drivetrain for his newest scholarship rider. He will install the 11-34T sprocket configuration. unloaded tire diameter = 29 inches tire radius= 14.5 LOADED tire radius.= 13.75 The coach has instructed the new athlete to create a robust spreadsheet. At a MINIMUM, it shall include: All of the Velocity Ratios An automated calculation(s) for the following: Given: MTB Speed (mph) Sprocket (# Teeth) Chainring (# Teeth) Find: The rpm the rider must pedal to maintain this speed (aka rider's cadence)
Related questions
Question
Ok I need help Setting up this excell spread sheet. I have done it but am not getting the right answers.
- A university mountain bike (MTB) coach is in the process of reworking the drivetrain for his newest scholarship rider.
- He will install the 11-34T sprocket configuration.
unloaded tire diameter = 29 inches
tire radius= 14.5
LOADED
tire radius.= 13.75
- The coach has instructed the new athlete to create a robust spreadsheet.
- At a MINIMUM, it shall include:
- All of the Velocity Ratios
- An automated calculation(s) for the following:
- Given:
- MTB Speed (mph)
- Sprocket (# Teeth)
- Chainring (# Teeth)
- Find:
- The rpm the rider must pedal to maintain this speed (aka rider's cadence)
- Given:
- At a MINIMUM, it shall include:
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution