From: djconnel@leland.Stanford.EDU (Daniel Connelly)
Subject: Re: Tour de France (from l'Equipe):  Stage 4 (TTT)
Summary: more fun with sort and nawk
Organization: DSG, Stanford University, CA 94305, USA
Date: Sun, 26 Jul 92 17:11:55 GMT

For completeness, I ran the analysis performed previously
on the final time trial on the team time trial data from
L'Equipe as posted by Brent Seales.  I lack the comparable
post for the first individual time trial (stage 9) --
if anyone has it readily available I'd appreciate knowing
about it.

The first table shows each team'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
-------------------------------------------------------
Amaya          19.0 (21)   1454    47.0426    47.0426
Amaya          41.5 (21)   3179    46.9959    46.9565
Amaya          63.5 (21)   4673    48.9193    53.0120

Ariostea       19.0 (20)   1431    47.7987    47.7987
Ariostea       41.5 (18)   3117    47.9307    48.0427
Ariostea       63.5 (18)   4613    49.5556    52.9412

Banesto        19.0 (10)   1376    49.7093    49.7093
Banesto        41.5 (06)   3005    49.7171    49.7238
Banesto        63.5 (07)   4445    51.4286    55.0000

Buckler        19.0 (15)   1393    49.1027    49.1027
Buckler        41.5 (16)   3066    48.7280    48.4160
Buckler        63.5 (15)   4529    50.4747    54.1353

Carrera        19.0 (01)   1346    50.8172    50.8172
Carrera        41.5 (01)   2973    50.2523    49.7849
Carrera        63.5 (02)   4402    51.9309    55.4234

Castorama      19.0 (13)   1385    49.3863    49.3863
Castorama      41.5 (12)   3043    49.0963    48.8540
Castorama      63.5 (12)   4481    51.0154    55.0765

Clas           19.0 (16)   1395    49.0323    49.0323
Clas           41.5 (15)   3059    48.8395    48.6779
Clas           63.5 (16)   4529    50.4747    53.8776

Festina        19.0 (19)   1427    47.9327    47.9327
Festina        41.5 (19)   3134    47.6707    47.4517
Festina        63.5 (20)   4628    49.3950    53.0120

GB-MG          19.0 (05)   1364    50.1466    50.1466
GB-MG          41.5 (04)   3002    49.7668    49.4505
GB-MG          63.5 (08)   4454    51.3247    54.5455

Gatorade       19.0 (06)   1366    50.0732    50.0732
Gatorade       41.5 (03)   2986    50.0335    50.0000
Gatorade       63.5 (03)   4416    51.7663    55.3846

Helvetia       19.0 (17)   1402    48.7874    48.7874
Helvetia       41.5 (20)   3149    47.4436    46.3652
Helvetia       63.5 (19)   4619    49.4912    53.8776

Lotto          19.0 (22)   1486    46.0296    46.0296
Lotto          41.5 (22)   3217    46.4408    46.7938
Lotto          63.5 (22)   4718    48.4527    52.7648

Motorola       19.0 (04)   1362    50.2203    50.2203
Motorola       41.5 (09)   3012    49.6016    49.0909
Motorola       63.5 (06)   4443    51.4517    55.3459

Once           19.0 (02)   1353    50.5543    50.5543
Once           41.5 (05)   3002    49.7668    49.1207
Once           63.5 (05)   4442    51.4633    55.0000

PDM            19.0 (14)   1386    49.3506    49.3506
PDM            41.5 (10)   3025    49.3884    49.4204
PDM            63.5 (10)   4469    51.1524    54.8476

Panasonic      19.0 (03)   1355    50.4797    50.4797
Panasonic      41.5 (02)   2977    50.1847    49.9383
Panasonic      63.5 (01)   4395    52.0137    55.8533

Postobon       19.0 (18)   1422    48.1013    48.1013
Postobon       41.5 (17)   3102    48.1625    48.2143
Postobon       63.5 (17)   4563    50.0986    54.2094

RMO            19.0 (12)   1384    49.4220    49.4220
RMO            41.5 (13)   3045    49.0640    48.7658
RMO            63.5 (13)   4500    50.8000    54.4330

TVM            19.0 (09)   1376    49.7093    49.7093
TVM            41.5 (08)   3011    49.6181    49.5413
TVM            63.5 (09)   4461    51.2441    54.6207

Telekom        19.0 (11)   1383    49.4577    49.4577
Telekom        41.5 (14)   3051    48.9676    48.5612
Telekom        63.5 (14)   4516    50.6200    54.0614

Tulip          19.0 (08)   1375    49.7455    49.7455
Tulip          41.5 (11)   3026    49.3721    49.0612
Tulip          63.5 (11)   4474    51.0952    54.6961

Z              19.0 (07)   1373    49.8179    49.8179
Z              41.5 (07)   3009    49.6510    49.5110
Z              63.5 (04)   4435    51.5445    55.5400


Below is listed a ranking of average speeds over intervals.

Start (0km) to time check #1 (19.0km):
distance=19.0km

Name            (p1)   (p2)       time    km/hr
-------------------------------------------------
Carrera         (--)   (01)       1346    50.8172
Once            (--)   (02)       1353    50.5543
Panasonic       (--)   (03)       1355    50.4797
Motorola        (--)   (04)       1362    50.2203
GB-MG           (--)   (05)       1364    50.1466
Gatorade        (--)   (06)       1366    50.0732
Z               (--)   (07)       1373    49.8179
Tulip           (--)   (08)       1375    49.7455
TVM             (--)   (09)       1376    49.7093
Banesto         (--)   (10)       1376    49.7093
Telekom         (--)   (11)       1383    49.4577
RMO             (--)   (12)       1384    49.4220
Castorama       (--)   (13)       1385    49.3863
PDM             (--)   (14)       1386    49.3506
Buckler         (--)   (15)       1393    49.1027
Clas            (--)   (16)       1395    49.0323
Helvetia        (--)   (17)       1402    48.7874
Postobon        (--)   (18)       1422    48.1013
Festina         (--)   (19)       1427    47.9327
Ariostea        (--)   (20)       1431    47.7987
Amaya           (--)   (21)       1454    47.0426
Lotto           (--)   (22)       1486    46.0296


time check #1 (19.0km) to time check #2 (41.5km):
distance=22.5km

Name            (p1)   (p2)       time    km/hr
-------------------------------------------------
Gatorade       (06)   (03)       1620    50.0000
Panasonic      (03)   (02)       1622    49.9383
Carrera        (01)   (01)       1627    49.7849
Banesto        (10)   (06)       1629    49.7238
TVM            (09)   (08)       1635    49.5413
Z              (07)   (07)       1636    49.5110
GB-MG          (05)   (04)       1638    49.4505
PDM            (14)   (10)       1639    49.4204
Once           (02)   (05)       1649    49.1207
Motorola       (04)   (09)       1650    49.0909
Tulip          (08)   (11)       1651    49.0612
Castorama      (13)   (12)       1658    48.8540
RMO            (12)   (13)       1661    48.7658
Clas           (16)   (15)       1664    48.6779
Telekom        (11)   (14)       1668    48.5612
Buckler        (15)   (16)       1673    48.4160
Postobon       (18)   (17)       1680    48.2143
Ariostea       (20)   (18)       1686    48.0427
Festina        (19)   (19)       1707    47.4517
Amaya          (21)   (21)       1725    46.9565
Lotto          (22)   (22)       1731    46.7938
Helvetia       (17)   (20)       1747    46.3652


time check #2 (41.5km) to time finish (63.5km):
distance=22.0km

Name            (p1)   (p2)       time    km/hr
-------------------------------------------------
Panasonic      (02)   (01)       1418    55.8533
Z              (07)   (04)       1426    55.5400
Carrera        (01)   (02)       1429    55.4234
Gatorade       (03)   (03)       1430    55.3846
Motorola       (09)   (06)       1431    55.3459
Castorama      (12)   (12)       1438    55.0765
Once           (05)   (05)       1440    55.0000
Banesto        (06)   (07)       1440    55.0000
PDM            (10)   (10)       1444    54.8476
Tulip          (11)   (11)       1448    54.6961
TVM            (08)   (09)       1450    54.6207
GB-MG          (04)   (08)       1452    54.5455
RMO            (13)   (13)       1455    54.4330
Postobon       (17)   (17)       1461    54.2094
Buckler        (16)   (15)       1463    54.1353
Telekom        (14)   (14)       1465    54.0614
Clas           (15)   (16)       1470    53.8776
Helvetia       (20)   (19)       1470    53.8776
Festina        (19)   (20)       1494    53.0120
Amaya          (21)   (21)       1494    53.0120
Ariostea       (18)   (18)       1496    52.9412
Lotto          (22)   (22)       1501    52.7648


Dan



  

-- 
Newsgroups: rec.bicycles