Go Back  Bike Forums > Bike Forums > General Cycling Discussion
Reload this Page >

Bike sim .xls - should interest engineers and nerds.

General Cycling Discussion Have a cycling related question or comment that doesn't fit in one of the other specialty forums? Drop on in and post in here! When possible, please select the forum above that most fits your post!

Bike sim .xls - should interest engineers and nerds.

Old 10-28-06, 09:35 PM
Thread Starter
Join Date: Sep 2006
Posts: 27
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Bike sim .xls - should interest engineers and nerds.


This spreadsheet tells you how fast a simulated rider would go given the rider's mass, tires, riding position, power output, and what sort of grade and headwind he faces. Maybe it's been posted before, but even if so, it's worthy of a re-post.

I ran the numbers through for my bike. Given a hypothetical, level, 20 mile route and a rider putting out 200W continuously, I should be able to complete the run on my MTB in 1:12:08.

Switching from my knobbies to semi-slicks improves my time to 1:06:33, a boost from 16.5mph to 18mph.

Weight savings were far less impressive, yielding just 30s per 10lb on gently rolling (1% grade) terrain. I'll put my money elsewhere for now.

Aerodynamically, there's big room for improvement vs. my upright position on my MTB. I could potentailly reach 20mph (instead of 16.5mph) at my 200W level by ditching the backpack and the MTB and getting some spandex pants and drop bars.

Who says it's not about the bike?

p.s. Does anyone have a good estimate of the coefficient of drag and frontal area of a fully faired and non-faired recumbent?

Last edited by BobSmalls; 10-28-06 at 10:05 PM.
BobSmalls is offline  
Related Topics
Thread Starter
Last Post
Professional Cycling For the Fans
01-20-12 02:56 PM
Training & Nutrition
05-19-10 10:17 AM
Road Cycling
02-09-09 05:13 PM
Road Cycling
12-30-05 12:32 PM
"The 33"-Road Bike Racing
06-22-04 10:50 AM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.