Click on required log
Save cycling log in a folder on your computer.
Open using Microsoft Excel - Navigate to folder where you saved the log.
This is a good time to change the file name by adding your CKAP number.
Example; The CKAP Coodinator's would be 2009CyclingLogFormatted341.xls
The logs have been formatted in whole km and when entered they will show in the colour red, as well as the Quarterly Totals.
You can type your km direct onto the log but all other information requires the use of the formula bar at the top of the screen.
All cell that require you to add your information have been formatted with the margin set to "Left" this will allow you to type through
one cell into the next but olny when using the formula bar.
Start by ckicking on the "CKAP No." on the top left hand side of the log. This will put it into the "Formula Bar" at the top of the page,
where you can type in your CKAP number. Once done click the log to return that information to the log and go on to the address section,
which is done in the same manner.
Some lines which require your "X" mark use the whole line as a cell. To put those lines in the formula bar, click on the extreme left of the
line (page row number) and proceed in the same manner.
If you wish to color your information, put the cell into the formula bar and highlight just your information, then click the arrow
on the right of the large "A" at the top right of your screen and select a colour, click on it, this will put it under the "A", then highlight
each part of your address information and click on the "A"each time.
Please remember to delete the "0" for your "Grand Total 2006 =", add your 2006 Grand Total (km total from when you joined CKAP) into the same cell as you deleted the "0"
To know that you have done this correctly, your Grand Total 2008 will also show in your 2009 Grand Total.
Remember to save your information before you exit log. Completed Excel logs can be sent as an attachment to a email
(please don't inbed in the body of the email) as they don't print well. You can add your comments for "From the Peloton" to page two of the log
or in the body of your email. Your CKAP Coordinator will print your log and your email on the back of the log if you don't use page two. Please
save a tree and don't send the coodinator another log when mailing in your payment for awards in the incentive part of CKAP.
If you owe for a award you will have to post your cheque. payable to CKAP.
Badges are $8.00 and medals are $18.00 each. As all CKAP's km
are cumulative you only earn and pay for these awards in the 1,000 to 25,000 km incentive program once. All major awards are free.
Remember you helping to pay for your future free award when you pay for the awards in the incentive part of CKAP, we have no annual fees.
If you don't have Microsoft Excel or a program that can use them, then use the CKAP logs below which are in PDF format, Which you would
save and open with an Adobe Reader (most computers come with one) If you have a problem in most cases you need to update your Adobe Reader
which is free. Print the log fill in with pen and mail with your postal service. More information below PDF cycling logs.