(FMinUSc1,FMinUSb1, FMinMc1, FMinMb1)
US = United States units, M = Metric units, c = colored version, b = black and white for those who might have problems opening colored versions.
Full Min is similar to Minical that was written up in Human Power #48, but is more complete. This has the same ability for drop and drag investigations with the addition of Temperature and Barometer plus Wheel Weight and Acceleration.
Because most of the spreadsheets contain so much information we have devised a system of colors, textures, shading and outlines as a way to lessen eye fatigue while playing your "What-if" games.
There are 13 user inputs and 3 formula cells to determine power. 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.
Other useful information can be found in;
To estimate CdA and Crr see Repchrt.jpg
For human power capability see HPcapTxt.doc and
Measuring you power capability see PwrCap.doc
Acceleration and wheel weight
Because Minical and Fmini… are the only spreadsheets that have Drop and Drag feature this will be covered here.
The following is a copy from the Minical article in Human Power #48 (cell addresses changed for FMini….)
One of the most useful
features, of a computerized spreadsheet like Minical, is an ability to explore
an array of numerical patterns with drop and drag. Drop and drag allows the
computer user to repeat the spreadsheet layout numerous times without having to
Click on cell A6. While hovering over the cell the cursor appears as a white plus sign but when moved to the lower right corner of the cell it will change to a dark + sign. With the cursor appearing as a dark plus sign hold down the mouse button while dragging across to the last cell to the right, P6 - release the mouse button. All the cells in row 6 should now be selected as indicated by a darkened background. Without touching the mouse buttons move
the cursor to the lower right corner of P6 until the cursor
changes into a dark cross. Click and drag down at least 10
rows. Drag down farther if you so wish. All of the data and formulas will have been repeated a number of times.
Select cell M6 -- velocity. Change it’s present value to 1. Move down one cell to M7 typing in the formula. =M6+1. Hit the "enter" key. The value 2 will appear. Once again select M7. Using the black + cursor, click the mouse while drawing the cursor down the row from M7 to as far as you have dragged the other rows. Release the button, you will observe the displayed velocity increasing in 1 mph (or km/h) increments in each sequential row, with the corresponding changes in the Power column.
You can do this operation to all user-defined non formula cells. You may also insert single values in any of the Drop and Drag columns to observe specific effects.