Excel Fill In forms for Speedskating
(Klik op het vlaggetje voor een introductie in het Nederlands)
Here you'll find, as a service for all speedskating fans and
statisticians some downloadable
Excel Fill In forms to keep track of the rankings and points in
samalog allround and sprint championships and to note
split times on all distances. Ranks and samalog points
are calculated immediately! Here you can see an example:
When you do a download, please inform me through mail (heyakeessie'at'kpnmail.nl),
so that I can inform you personally about updates or errors.
NEW: Sprint spreadsheets for up to a 100 skaters instead of the default 50.
Samalog allround tournaments:
-
ALLROUND.xlt:
Fill In workbook for all types of allround samalog championships.
You have a choice between the following options:
1. BIG combination: 500-5000-1500-10000(senior men)
2. SMALL combination: 500-3000-1500-5000(men junior / ladies in 2 day order)
3. SMALL combination: 500-1500-3000-5000 (men junior / ladies in 3 day order)
4. LITTLE combination: 500-1500-1000-3000(ladies junior in 2 day order)
5. LITTLE combination: 500-1000-1500-3000(ladies junior in 3 day order)
Download ALLROUND.zip
-
ALLROUNDQ.xlt:
Same as above, a special version: It contains a program to select the skaters
that qualify for the longest distance according to the rules that exist
since the season '98/'99.
Download ALLROUNDQ.zip
-
ALLROUNDSPECIAL.xlt:
Covers all samalogs, distance standings and all the lap- and splittimes for the big allround combination in one workbook.
Download ALLROUNDSPECIAL.zip
For the quickies:
-
SPRINT.xlt:
For a samalog sprintchampionship ;500/1000/500/1000 (50 skaters)
Download SPRINT.zip
Follow the races and see the gaps grow or shrink:
-
LAPTIMES.xlt: Fill in the splittimes,
and then laptimes and the time behind #1 are calculated.
(500,1000,1500,3000,5000 and 10000m)
Download LAPTIMES.zip
500m competition with 2 heats (WSD or OG):
Email list skate Koeln & Yahoo
Maintained by Kees de Vroege, last update: December 1, 2020