From: djconnel@leland.Stanford.EDU (Daniel Connelly)
Subject: Re: Tour de France (from l'Equipe):  Stage 19 (Time Trial)
Summary: fun with nawk and sort
Organization: DSG, Stanford University, CA 94305, USA
Date: Sat, 25 Jul 92 18:31:21 GMT

In article <25465@sophia.inria.fr> Brent writes:
>The Tour de France
>Stage 19 (Friday, July 24)
>Individual Time Trial 
>between Tours and Blois (64 km)
>
>[from l'Equipe Saturday, July 25]


I did some processing of the time trial data from L'Equipe as
translated by Brent Seales.

For those riders listed, here is the breakdown on the performance
between time checks.  Note that when a rider dropped out of the top 20
data is not available at that time check due to the limited listing of
L'Equipe.

The first table shows each rider's place and times in seconds at the
time checks along with their average speed to that point in km/hr
(s_net) and the average speed since the previous time check in km/hr
(s_int).


Name	       dist place  time	   s_net      s_int
-------------------------------------------------------
Bernard        29.0 (12)   2113    49.4084    49.4084
Bernard        46.0 (04)   3301    50.1666    51.5152
Bernard        64.0 (04)   4558    50.5485    51.5513

Bourguignon    15.5 (15)   1085    51.4286    51.4286
Bourguignon    29.0 (19)   2139    48.8079    46.1101
Bourguignon    64.0 (20)   4710    48.9172    49.0082

Breukink       15.5 (05)   1069    52.1983    52.1983
Breukink       29.0 (07)   2096    49.8092    47.3223
Breukink       46.0 (05)   3302    50.1514    50.7463
Breukink       64.0 (07)   4578    50.3277    50.7837

Bugno          15.5 (02)   1029    54.2274    54.2274
Bugno          29.0 (02)   2017    51.7600    49.1903
Bugno          46.0 (02)   3202    51.7177    51.6456
Bugno          64.0 (02)   4441    51.8802    52.3002

Chiappucci     15.5 (04)   1068    52.2472    52.2472
Chiappucci     29.0 (03)   2083    50.1200    47.8818
Chiappucci     46.0 (06)   3302    50.1514    50.2051
Chiappucci     64.0 (06)   4574    50.3717    50.9434

Chioccioli     15.5 (19)   1093    51.0522    51.0522

Chiurato       15.5 (10)   1079    51.7146    51.7146
Chiurato       29.0 (15)   2126    49.1063    46.4183
Chiurato       46.0 (20)   3385    48.9217    48.6100
Chiurato       64.0 (19)   4703    48.9900    49.1654

Delgado        15.5 (14)   1084    51.4760    51.4760
Delgado        29.0 (16)   2126    49.1063    46.6411
Delgado        46.0 (12)   3341    49.5660    50.3704
Delgado        64.0 (11)   4607    50.0109    51.1848

Ekimov         15.5 (11)   1080    51.6667    51.6667
Ekimov         29.0 (08)   2099    49.7380    47.6938
Ekimov         46.0 (03)   3287    50.3803    51.5152
Ekimov         64.0 (05)   4562    50.5042    50.8235

Fignon         15.5 (18)   1092    51.0989    51.0989
Fignon         29.0 (20)   2141    48.7623    46.3298
Fignon         46.0 (19)   3377    49.0376    49.5146
Fignon         64.0 (17)   4670    49.3362    50.1160

Fondriest      15.5 (16)   1088    51.2868    51.2868
Fondriest      29.0 (18)   2137    48.8535    46.3298
Fondriest      46.0 (16)   3361    49.2711    50.0000
Fondriest      64.0 (15)   4647    49.5804    50.3888

Hampsten       15.5 (03)   1061    52.5919    52.5919
Hampsten       29.0 (06)   2095    49.8329    47.0019
Hampsten       46.0 (14)   3345    49.5067    48.9600

Indurain       15.5 (01)   1026    54.3860    54.3860
Indurain       29.0 (01)   2015    51.8114    49.1405
Indurain       46.0 (01)   3201    51.7338    51.6020
Indurain       64.0 (01)   4401    52.3517    54.0000

Kasputis       46.0 (15)   3357    49.3298    49.3298
Kasputis       64.0 (12)   4616    49.9133    51.4694

Lino           15.5 (06)   1069    52.1983    52.1983
Lino           29.0 (10)   2109    49.5021    46.7308
Lino           46.0 (18)   3372    49.1103    48.4561

Louviot        15.5 (17)   1089    51.2397    51.2397
Louviot        29.0 (11)   2112    49.4318    47.5073
Louviot        46.0 (11)   3333    49.6850    50.1229
Louviot        64.0 (09)   4593    50.1633    51.4286

Montoya        15.5 (13)   1084    51.4760    51.4760
Montoya        29.0 (14)   2119    49.2685    46.9565
Montoya        46.0 (13)   3345    49.5067    49.9184
Montoya        64.0 (13)   4619    49.8809    50.8634

Perini         15.5 (08)   1071    52.1008    52.1008
Perini         29.0 (05)   2095    49.8329    47.4609
Perini         46.0 (08)   3315    49.9548    50.1639
Perini         64.0 (10)   4601    50.0761    50.3888

Robin          29.0 (17)   2132    48.9681    48.9681
Robin          46.0 (17)   3361    49.2711    49.7966
Robin          64.0 (16)   4654    49.5058    50.1160

Roche          15.5 (07)   1071    52.1008    52.1008
Roche          29.0 (04)   2087    50.0240    47.8346
Roche          46.0 (09)   3323    49.8345    49.5146
Roche          64.0 (08)   4592    50.1742    51.0638

Rue            15.5 (20)   1094    51.0055    51.0055

Vanzella       15.5 (09)   1074    51.9553    51.9553
Vanzella       29.0 (13)   2114    49.3851    46.7308
Vanzella       46.0 (10)   3324    49.8195    50.5785
Vanzella       64.0 (14)   4635    49.7087    49.4279

Yates          64.0 (18)   4692    49.1049    49.1049

Zhdanov        15.5 (12)   1082    51.5712    51.5712
Zhdanov        29.0 (09)   2107    49.5491    47.4146
Zhdanov        46.0 (07)   3310    50.0302    50.8728
Zhdanov        64.0 (03)   4549    50.6485    52.3002



Below is listed a ranking of average speeds over intervals.
Note that listings are provided only when a rider was ranked
in the top 20 at both endpoints of the interval.

Start to time check #1:

Name            (p1)   (p2)       time    km/hr
-------------------------------------------------
Indurain        (--)   (01)       1026    54.3860
Bugno           (--)   (02)       1029    54.2274
Hampsten        (--)   (03)       1061    52.5919
Chiappucci      (--)   (04)       1068    52.2472
Breukink        (--)   (05)       1069    52.1983
Lino            (--)   (06)       1069    52.1983
Roche           (--)   (07)       1071    52.1008
Perini          (--)   (08)       1071    52.1008
Vanzella        (--)   (09)       1074    51.9553
Chiurato        (--)   (10)       1079    51.7146
Ekimov          (--)   (11)       1080    51.6667
Zhdanov         (--)   (12)       1082    51.5712
Delgado         (--)   (14)       1084    51.4760
Montoya         (--)   (13)       1084    51.4760
Bourguignon     (--)   (15)       1085    51.4286
Fondriest       (--)   (16)       1088    51.2868
Louviot         (--)   (17)       1089    51.2397
Fignon          (--)   (18)       1092    51.0989
Chioccioli      (--)   (19)       1093    51.0522
Rue             (--)   (20)       1094    51.0055


time check #1 to time check #2:

Name            (p1)   (p2)       time    km/hr
-------------------------------------------------
Bugno          (02)   (02)        988    49.1903
Indurain       (01)   (01)        989    49.1405
Chiappucci     (04)   (03)       1015    47.8818
Roche          (07)   (04)       1016    47.8346
Ekimov         (11)   (08)       1019    47.6938
Louviot        (17)   (11)       1023    47.5073
Perini         (08)   (05)       1024    47.4609
Zhdanov        (12)   (09)       1025    47.4146
Breukink       (05)   (07)       1027    47.3223
Hampsten       (03)   (06)       1034    47.0019
Montoya        (13)   (14)       1035    46.9565
Lino           (06)   (10)       1040    46.7308
Vanzella       (09)   (13)       1040    46.7308
Delgado        (14)   (16)       1042    46.6411
Chiurato       (10)   (15)       1047    46.4183
Fignon         (18)   (20)       1049    46.3298
Fondriest      (16)   (18)       1049    46.3298
Bourguignon    (15)   (19)       1054    46.1101


time check #2 to time check #3:

Name            (p1)   (p2)       time    km/hr
-------------------------------------------------
Bugno          (02)   (02)       1185    51.6456
Indurain       (01)   (01)       1186    51.6020
Bernard        (12)   (04)       1188    51.5152
Ekimov         (08)   (03)       1188    51.5152
Zhdanov        (09)   (07)       1203    50.8728
Breukink       (07)   (05)       1206    50.7463
Vanzella       (13)   (10)       1210    50.5785
Delgado        (16)   (12)       1215    50.3704
Chiappucci     (03)   (06)       1219    50.2051
Perini         (05)   (08)       1220    50.1639
Louviot        (11)   (11)       1221    50.1229
Fondriest      (18)   (16)       1224    50.0000
Montoya        (14)   (13)       1226    49.9184
Robin          (17)   (17)       1229    49.7966
Fignon         (20)   (19)       1236    49.5146
Roche          (04)   (09)       1236    49.5146
Hampsten       (06)   (14)       1250    48.9600
Chiurato       (15)   (20)       1259    48.6100
Lino           (10)   (18)       1263    48.4561


time check #3 to finish:

Name            (p1)   (p2)       time    km/hr
-------------------------------------------------
Indurain       (01)   (01)       1200    54.0000
Bugno          (02)   (02)       1239    52.3002
Zhdanov        (07)   (03)       1239    52.3002
Bernard        (04)   (04)       1257    51.5513
Kasputis       (15)   (12)       1259    51.4694
Louviot        (11)   (09)       1260    51.4286
Delgado        (12)   (11)       1266    51.1848
Roche          (09)   (08)       1269    51.0638
Chiappucci     (06)   (06)       1272    50.9434
Montoya        (13)   (13)       1274    50.8634
Ekimov         (03)   (05)       1275    50.8235
Breukink       (05)   (07)       1276    50.7837
Fondriest      (16)   (15)       1286    50.3888
Perini         (08)   (10)       1286    50.3888
Fignon         (19)   (17)       1293    50.1160
Robin          (17)   (16)       1293    50.1160
Vanzella       (10)   (14)       1311    49.4279
Chiurato       (20)   (19)       1318    49.1654



Dan

-- 
Newsgroups: rec.bicycles