TOOLS

Sanders, Snyder & Tetz

set of Useful bike specific TOOLS in spreadsheet format.

Webmater note: This is a very useful set of spreadsheets and represents many, many days of work by the authors.
We are supplying a set of spreadsheet tools that will give a user the ability to quantify bicycle related issues such as determining your own power capabilities, power vs speed, power to climb hills, CdA (aerodynamic drag), Crr (rolling resistance), and many more.
We have set up separate spreadsheets to reduce informational overload, and a set of associated descriptive texts.
We also have included instructional texts to help guide the user in making proper measurements.
Read Intro.doc first (14k) .html format (ALL of the .doc in .ZIP format) (22k)

SPREADSHEETS (ALL of the .xls files in .ZIP format) ( 32k)

to get a free Excel Viewer
: FMiniUSb1.xls (17k) - For general use with drop and drag.; FMiniUSc1.xls (17k) - With colors and outlines.; FMiniMb1.xls (17k) - Metric, black and white.; PDGus1.xls ( 27k) - Power, Gearing, and % distribution.; CompUS1.xls (27k) - For comparing two vehicles.; USmMus1.xls (20k) - US to metric and Metric to us conversions.; Forcpower.xls (16k) - A metric Force & Power spreadsheet for HPV's; effctspd.xls (14k) - Math model of Social Speed hypothesis