Prog |
Weather |
Amiga |
Music |
Energy |
Food |
Garden |
Kayak |
Bike |
Medical |
Buddha |
Chomsky |
Other
New LINKS |
Activism |
TECH -
Wheels -
Gears -
Crank Length -
Lights -
Rack&Fender -
Framebuilding -
Other
Retail -
Cool -
Big -
Other -
Classified |
The Engine |
Component Manfacturers |
Frame Builders |
Bike Manufacturers |
Recumbants
Zines |
Bike Clubs |
Other Bike Pages
Original Bike Content:
Muscle Recovery Beverage |
Openoffice.org Spocalc Macros |
My gear Calculator |
Carradice
Quick Release |
My Mileage Log
My Bikes
My (New and Improved) Muscle Recovery Drink
I made my own Muscle Recover Drink. Read all about it
here.
Spocalc Macros
Want to use Damon Rinard's
Spocalc spoke calculator for Microsoft Excel with
OpenOffice.org?
You can do it with My macros. You can get them
HERE.
At the request of
Peter White
I added a toolbar with icons to make it easier to run
my macros. You can get the complete spreadsheet
for OpenOffice.org 2.0 with a spocalc toolbar, or
for OpenOffice.org 2.1 with both a spocalc toolbar and a spocalc
pull down menu.
Damon's Spocalc can also be found on
Sheldon
Brown's web pages
My Gear Calculator
And Still Better Again!
And Still
The old versions my gear calculator are still here too.
The Web version of
My Gear Calculator
is temporairally off line.
You can download the
perl cgi
source here.
But, you can have a stand alone version to
run on a
Pee Cee or a version that
runs on a Sun
Workstation
These are stand-alone, file-driven programs where you write a file that
describes one or more sets of gears. The program reads the file and
displays the gearing tables and graphs.
The have more outputs than my Web version did, but don't have the nice,
interactive way of clicking cogs up and down.
There's a
help file
to show how to enter parameters, and a
example file
with some 7 speed freewheel configurations.
I also have on-line the
C source
code for one of the latest vesion of the program
HERE.
And here
is a
Quick
Release mount I made for my Carradice Camper.
My 2008 Mileage Log
It's just an excel /
OpenOffice.org
spreadsheet. You can
download
it HERE.
The Log Data (first) sheet has a row for each day with the date in the first column.
The next two columns are for recording morning resting heart rate and
weight. I never use them, but left them in anyways.
Next are two sets of columns for recording two seperate rides a day.
Each of these records the bike ridden, the miles ridden, ride time in
hours, minutes, and seconds, the average speed, the max speed, weather
conditions, and some
notes on the ride.
Usually, these are used for the commute to and from work. I usually note
the weather conditions in the notes.
Tucked in the second set is a column that I record a C if the ride
was a commute to work or a D on days I drove to work.
After those columns, are two more columns to record the bike and miles
for a third ride of the day.
Following that is the daily total mileage. Then miles for the year and a count
of days ridden for the year. Then commute miles and days for the year.
The Sub Totals (second) sheet shows a bunch of statistics. So if you want to know what
percentage of use each bike gets, how often I had a head wind riding to
work, or how much CO2 is didn't put into the atmosphere, the numbers are
on the Sub Totals sheet.
The Graphs (third) page has some graphs. Right now, it has there's a daily mileage
bar graph, a total mileage / commute mileage graph, a commute speeds graph,
and a percentage of use pie chart.
There's also a Tools page with some little calculators. And an About
page with some instructions.
With the exception of the graph formatting, the sheet works fine on Excel,
OpenOffice.org,
and gnumeric spreadsheets.
I also have a smaller version without all of the statistics and graphs
HERE that I keep on my Palm computer.
One Stop Surfing
Sheldon Brown's
Bicycles and Frame Links,
Parts and Accessories Links, and of course his
Bicycle
Glossary
BikeCrawler
bicycle search engine
Two Wheel Fetish:
Alternative Urban/e Cycling ezine, parts and
A Journal
Not much below has been updated recently
Yahoo's list of
Bike Shops
The Web version of
My Gear Calculator
is temporairally off line.