Collar catalogue filtering options
Introduction
Since the launch of the Club des Cent Cols mountain pass database, members have been able to download a large number of mountain pass catalogues. What's more, updates can be made at a faster rate than with the old annual versions. For these reasons, the Club no longer offers additive files. So how do you find out which new collars have been added? Here we provide documentation based on an initial version prepared by Alain Benoist (CC 5663).
Download catalogues
For members, all catalogues can be obtained as spreadsheet files, either XLSX (for Excel), or ODS (for LibreOffice). These formats can also be used for Numbers or for OpenOfficerespectively. The download page can be accessed via the Collar catalogues on the Club's website. Or directly at the following address:
https://centcols.org/membres/outils/telecat.php
If you are not already logged in as a member, you will need to log in to access this page.
Recent catalogues are marked in colour as new or updated. Choose the catalogue you want in the appropriate format, ODS or XLSX, and download it to your computer. As with any download, you need to make a note of where the file is saved... or find it using your browser's download button.
Opening the catalogue file
Normally, a simple double-click on the file should open it in the appropriate software. Alternatively, you can first launch the appropriate program and then open the file from there. Or drag and drop the file icon onto the program icon. It all depends on the system and the settings, so it's up to you... Freshly downloaded files are generally protected against modification. To override this restriction, click on edit document or activate changes or equivalent, depending on the programme you are working with.
Once the file is open, you can see that it contains several sheets represented by tabs at the bottom. The sheets containing the passes of a country are noted by their code ISO 3166 with two letters. Once you have read the copyright notice, click on the tab to go to the sheet you want.
Tracking columns
On the far right, the catalogues now contain three columns linked to the history of each pass in our database. These columns are follow-up, date added and last update. The first summarises the changes made by year, the second gives the exact date the collar was added to the catalogue and the third indicates when the last change was made. These columns are particularly useful for searching, sorting or filtering new collars.
Simple method: search
Even without doing a search, you can see at a glance what's new in the columns date added and last updatebecause they are in red. To find the collars added or modified during the current year (or another year) one by one, simply mark one of the two columns and search for the year.
Refined method: filtering
Filters are a set of criteria that are applied to the different columns in the table. You start by selecting the columns you want to filter. In Excel, simply click on the column headers. With LibreOffice Calc, on the other hand, you need to select the columns you want with all their data. In the dataDepending on the version, you will see a funnel-shaped symbol or a heading automatic filter or something similar. In any case, it should insert a small button with an arrow on the header of the columns you want to filter on.
Clicking on one of these arrows takes you to the criteria for the column. In the case of an automatic filter, you can choose one or more of the existing values. For example, you can select all the collars with a certain date added by clicking only on that value.
Once such a filter has been applied, the status bar at the bottom left shows the number of rows (in this case: cols) corresponding to the criteria. If you define criteria for several columns at once, they are all applied at the same time. For example, you can keep only the new road passes by applying filters to the following columns type and date added. A filter on a column can be deactivated simply by clicking on all (or: select all).
All the filters can be removed by clicking on the funnel symbol with a red cross (Excel) or by clicking again on AutoFilter (Calc).
Obtain an additive
We can use filtering to obtain an additive list, i.e. a list showing only new collars (and those which are now accepted even though they were previously unrecognised). To do this, we create a filter on the date added as above. From the list, select all the dates that are more recent than the last version of the catalogue you already had, for example all the dates from 2022 onwards if you last downloaded a catalogue at the end of 2021.
Once you have the list you want, you can copy it and paste it, for example, into a file with a custom cols list. To do this, the order of the columns in the two tables must of course be the same. If this is not the case, you might consider reordering the columns in your personal table so that they correspond to those in the official catalogue, possibly with customised columns on the far right. This will make future updates easier.