COMPARITORS ver 1

(CompUSc1.xls, CompMc1.xls)

US represents United States units. M= Metric units. c= colored versions.

The Comparitor contains two calculators. Use this layout to quickly compare things like two different bikes, or changes made on a bike. The left section is set up as a reference called Control and the one on the right is called Test. Below the calculators are handy % distribution charts.

You could compare the cycling effort of changing the grade, velocity, adding or subtracting weight, wind effects etc. You could see what the effect of changing the CdA or Crr can do for you. Lots of different uses and parlor games are possible.

And the distribution tables will show you where the power is distributed.

Before using this spreadsheet review LAYOUTS.doc to understand the colors, textures and outline system.

POWER CALCULATORS. There are 14 user inputs and 6 formula cells in each Power Calculator section. CAUTION; if you accidentally type something in the formula cells you will destroy the formula. To protect yourself, make a backup copy before using the calculators.

You may click on the formula cells and the formula will appear in the formula tool bar which is a informative thing to do. Then move off the cell and click on the background. The Power cell contains a long formula. The formulation was derived by Joel Sanders from first principles of mechanics and can be read in “PRIMER ON BICYCLE MECHANICS”, which can be obtained as a monograph from the HPVA.

% DISTRIBUTION CHART: Gives a breakdown of power and % distribution of that power. As you change the user inputs in the Power calculator section the % distribution of power are automatically calculated. Do not type anything in any of the distribution chart cells.

To estimate CdA and Crr see Repchrt.jpg

Measuring you power capability see PwrCap.doc

For human power capability see HPcapTxt.doc

and Hpcap.jpg

Acceleration and wheel weight see Accel.doc.