Hugo Koblet said:
Nice work!
ingsve, have you in some way managed to get the "program" or "spreadsheet" to count these by itself? Or have you manually counted it? I'm sure there are a lot of neat little tricks to be learned that could potentially save me a lot of time.
Hugo, while it may take some time to setup, you might want to spend some time now to make the updating easier as the season progresses.
CQ provides a download in XLS format in a format like this:
1 1 1994 ITA19841114 NIBALI Vincenzo LIQ ITA 26 2203
Column C (which is hidden) is the rider's ID, column E is their name and column I is their points.
If you change the name for the riders for each team to match the CQ format, or enter the rider ID for each rider (1994 for Nibali), you can do a vertical lookup from one sheet to another to get their points, then total it at the bottom for each team.
Then, all you have to do to update the points is to download the CQ data, copy it into your lookup sheet... and it will total automatically.