2016 August Mileage Log
Sept., 2016
Fleet Captain Natalie Wiest is providing here the HCC Mileage Log, as it stands year-to-date as of August, 2016. Members can download and view this Excel document to see where they stand, and how close they are to a 100-mile award.
To download the Excel spreadsheet, click here.
This document has security set for members-only.
For those not familiar with Excel software, here's a few tips on how you might want to manipulate the chart.
As is, the chart is in alphabetical order by member name. You can scroll down or up by grabbing the scroll bar on the far right with your cursor and pulling it down or up. Trips are arranged in chronological order horizontally, and you can scroll left and right by using the scroll bar on the bottom right.
Column B contains the total of miles by paddler, for all the club trips they've attended.
If you wish to filter out all the names with zero miles, click the filter icon in cell B2, un-check the zero in the pop-up selection list, and click OK. (See the example, below.) You'll now have a short list of just those members who have greater than zero registered miles.
If you wish to sort the member mileage by miles, click that same filter cell B2 again, select "Sort largest to smallest", and click OK. You'll now have the members ranked by miles-paddled.
As you can see, Kent Walters is once again leading the pack. Heck, he already had his 100-miles for the year by April...
If you have a goal of making 100-miles for the year, this spreadsheet will let you see where you stand, so you know how many more miles you need to accumulate to reach that goal.
This chart does not include non-club paddling miles.
|
Fleet Captain, Natalie Wiest |