Old 03-18-09, 09:46 AM
  #318  
waterrockets 
Making a kilometer blurry
 
waterrockets's Avatar
 
Join Date: May 2006
Location: Austin (near TX)
Posts: 26,170

Bikes: rkwaki's porn collection

Mentioned: 4 Post(s)
Tagged: 0 Thread(s)
Quoted: 37 Post(s)
Liked 91 Times in 38 Posts
Originally Posted by ijgoodwin
Very helpful! Much easier than going through and trying to recalculate a bunch of columns.
I also am thinking more clearly since waking up, and reduced it down to one magic number:
=B2*C2*0.832694550466497

If you have a 700x23c on the rear, that will cover it for you with a circumference of 2096. If your circ is different, scale the magic number the appropriate % to account for the difference from 2096 (1% smaller circumference = 1% smaller magic number).
waterrockets is offline