by : James D. Wilson – CKAP 341
Updated: 13th. March 2008
Hi CKAP Members,
James has created 2006 – 2007 and 2008 Excel formatted cycling logs. You will have to delete the “0” and type in your grand total from last year in the same cell. Address information, adding information To cells which already have information in them is best done using the formula bar at the top of the screen. all cells are left formatted so click on the left side of the cell such as “CKAP #” on the top left side of the log. this will put CKAP # in the formula bar and then place your cursor, using your mouse, beside CKAP # in the formula bar and type your number. then Ckick on “Name” and repeat the same procedure. You will see that your information will be the same style and will fit the cell. Once past the address informaton the cell are whole line cells and you must click on the row number on the left and put the whole line into the formula bar to add your cycling clubs and check marks.
These Excel files have been saved in 5.0/95 Excel version which means that most Excel users should be able to open them. These files are located above the PDF logs, click on the Cycling Logs Link at the top left of all pages, except Photo Galleries. Once saved you can update the file to your version of Excel However, James has Excel Version 2003. If you plan on sending the log by e-mail don’t save in a higher version or James will not be able to open.
At the end of year 2006 you can then send me the completed log as an attachment to an e-mail. Page Two should also be included. Or you can put the information in the body of your e-mail if sending by e-mail.
If you have earned awards in the incentive part of CKAP. You can print the log and mail along with your cheque, payable to CKAP.
The cycling logs at the CKAP web site in PDF format are for members who don’t have Excel.