An EXCEL add-in, called BicycleLog, can be used to record your bicycle activities. This bicycle log, or bike log, or yearly log, as you will, is designed to keep track of those things of interest to a bicyclist, such as miles ridden, feet climbed, weather conditions, etc. It is freely available, distributed under the GNU General Public License, a copy of which is included with the download.
For setup instructions, scroll down to “Download and Installation.”
Please note, that this page contains all of the help information that is available, so in case of puzzlement, return here.
Please do not attempt to upgrade until you have read the Upgrade Section below.
How it works
For EXCEL 2007 and 2010, an AddIn’s item will appear at the top of the EXCEL 2007 window. When clicked it should show the yearly log button.
For other EXCEL’s, a new yearly log button should appear which when clicked will bring up the bicycle log.
The log may be closed by clicking on the close button or by closing EXCEL. You will be asked if you would like to save the data, which you should do. The design of the log is due to Wally Hertler. Ralph Levy added the graphs and the summary columns.
The years drop down list offers choices from 2000 to 2026, while the drop down list to the right of the years drop down list will change the statistic plotted. In the above, the statistic is “miles”. The other choices are “Temperature”, “100 Feet Climbed,” and “Average Speed.”
The data may be filtered by filling in items in the Data Filter cells shown at the right side of the screen. The illustration below shows the list filled in with bicycle names. Once filled in, and once data has been entered into the data base, clicking on one of the items will filter the data to show only associated data. The cell clicked on is grayed to remind the user that the data is filtered.
To add to or modify the filters, you will have to be in “Design Mode,” which is obtained by clicking on the Design Mode icon.
For EXCEL’s prior to 2007, the Design Mode Icon, will be visible on one of the ribbons at the top of the EXCEL screen. When clicked, this icon will have a box about it. After filling or editing this list, Design Mode should be exited by again clicking on the icon.
For EXCEL 2007, Microsoft, in it’s wisdom, has chosen to hide the Design Mode Icon. To make it visible, click the doohickey in the upper left of the EXCEL 2007 window, and then choose the “Excel Options” at the bottom of the new window. Then select the item that will show the developer tab, and click OK to exit.
For EXCEL 2010, click on the “File” menu and then the “options” item, then the “Customize Ribbon” item.
A “Developer” tab will now appear at the top if the EXCEL window, which when clicked, will show the Design Mode Icon.
Don’t forget to exit “Design Mode” when you are done by clicking on the icon.
It should not be necessary to point this out, but a willy-nilly changing of the filter item names can cause problems. Suppose someone defines a filter called “Blue Bike” and records some data using it, but then decides to change the data filter name to “Blue Fuji Bike”. The old data records will still have “Blue Bike” associated with them and the user should not expect to be able to use “Blue Fuji Bike” to access them.
Operation of the calendar
Clicking on a data cell brings up a dialog such as the following, which may be used to enter data into the database. Pressing the “Clear Data” button not only clears the form, but removes the data from the data base. Note that one of the Data Filter items is associated with the data for this date.
Clicking on the date number (beside the cell) will bring up a dialog such as the following, which may be used to record club events or dates of special interest. When such a recording has been made, the date number is marked in green.
Download and Installation
There are two versions of BicycleLog, one for EXCEL’s prior to EXCEL 2007, and one for newer EXCEL’s. Download the program by clicking on one of the words: BicycleLog20072010 or BicycleLog. The downloaded file is a self extracting zip file, simply click on it to extract the files.
Overview of the process
- Download the EXE file to any convenient folder. You may delete the file after it is used. If your computer asks questions about downloading or installing, tell it you want to proceed.
- Double click on the downloaded file and fill in the “Extract to:” window by using the browse button. Browse to the AddIns folder whose location is described below.
- Click OK.
In order to find the AddIns folder, files which are ordinarily hidden must be visible. To make them visible go to the Control Panel and then Folder OptionsView and click the radio button for “Show hidden files and folders.” After this is set, the AddIns folder may be browsed to as follows:
Details for EXCEL 2007, 2010
The AddIns folder is usually located at C:Users###AppDataRoamingMicrosoftAddIns”, where ### is a local name, often the user’s. If this doesn’t seem to be the case, you will have to fiddle around until you locate a normally hidden folder called “AppData” or “Application Data” and then the “Microsoft” folder somewhere under it, and the AddIns folder under that.Three files will be downloaded, “COPYING.txt,” “ReadMe.txt” and “BikeLog.xlam”. Do not load the file BikeLog file directly into EXCEL 2007 or EXCEL 2010. For EXCEL 2007, click on the doohicky in the upper left of the EXEL widow. Then click on “Excel Options” at the bottom of this window, and then on “Add-Ins” at the left of the new window. Highlight “Yealy Log”, and then at the bottom of the window make sure Excel Add-ins appears in the Manage drop down list and click Go.For EXCEL, click “File/options/Add-Ins” and then at the bottom of the screen there will be a Manage drop down box. Make sure “Exel Add-Ins” is showing and click “GO.”The dialog that appears should resemble the following. “Yearly Log” will appear in the Add-ins list, and all you have to do is put a check mark on it and close the dialog.You will probably have to close and reopen EXCEL 2007 to access the yearly log.
Details for EXCEL’s prior to EXCEL 2007
The AddIns folder is located at something like “C:Documents and Settings###Application DataMicrosoftAddIns”, where ### is a local name, often the user’s.),Three files will be downloaded, “COPYING.txt,” “ReadMe.txt” and “BikeLog.xla”Do not load the file BikeLog file directly into EXCEL, instead open Excel and click on the “Add-ins…” menu item.The dialog that appears should resemble the following. “Yearly Log” will appear in the Add-ins list, and all you have to do is put a check mark on it and close the dialog.You will probably have to close and reopen EXCEL to access the yearly log.
To upgrade copy the new version over the old one and then restore the saved data. In other words when you extract the new BikeLog version from the EXE file that you downloaded, you will allow it to replace the old BikeLog. There is an extra step required when upgrading to EXCEL 2007 and 2010, since the data files format must be changed — this is discussed below.The data is contained in a data sheet in the EXCEL workbook and overwriting the workbook contained in BikeLog will replace the data sheet with a blank data sheet; which is why it is necessary to restore the data.Two buttons off the right hand side of the main sheet enable the saving and restoring of data.
- Your data should have been saved each time you exited EXCEL because you have clicked the save data dialod, didn’t you? If not, save your data by clicking the “Save Data” button on the spreadsheet. This will place a file called BikeLogData in the AddIns folder.
- Make a copy of this file before proceeding, just in case something goes wrong.
- Download the EXE file as described above.
- To finish, open EXCEL and click on the calendar icon, and then click on the “Restore Data” button
Upgrading to EXCEL 2007 and 2010
If you are upgrading to EXCEL 2007 or 2010 from an EXCEL before 2007, you should first save your data with the old EXCEL. It will be placed in the BikeLogData.xls file in the AddIns folder. You will need a copy of this file after you have upgraded. Vista and Windows 7 do not usually show file extensions, but It is probably a good idea to be able to see them for the following steps. Go to the Control Panel and choose File Options then select View. Uncheck the “Hide extensions for known file types” box. File extensions should now appear on all files. If the saved file is named BikeLogData.xls, as it will be if it is saved from versions prior to EXCEL 2007, the file must be converted to the new format and named BikeLogData.xlsx. To do this, put BikeLogData.xls in the AddIns folder and then open it in EXCEL 2007 or 2010 by double clicking on it. Once EXCEL starts up click the doohicky at the upper left of the Window in 2007, or the “File” menu in 2010, and choose “Save As” and then click on the EXCEL Workbook icon at the top of the window and save to the AddIns folder with the xslx file type. A file named BikeLogData.xlsx should appear in the AddIns folder. Close EXCEL and reopen it.Once this file has been converted, you may use the “Restore Data” button in the Yearly Log to restore your data.
Club events may be saved and read by using the “Save Events” and “Read Events” buttons. The “Save Events” button creates a simple text file that can be passed to other club members, who can load it into their copy of the Bicycle Log.