5 replies to this topic

[F1Frog]

I don't know if this is the right place to ask this so it can be moved if appropriate, but this is where I thought I was most likely to get an answer. Autosport currently reveal at the end of the F1 season, a set of 'super-times', where they take each driver and car's fastest lap of a weekend as a percentage of the fastest of all, and then average them all out to get a total score for each driver and car for the season. Essentially, it calculates the average qualifying pace of every driver and car. For 2022, for example, the results were:

 

Max Verstappen 100.161

Charles Leclerc 100.168

Carlos Sainz 100.334

Sergio Perez 100.706

George Russell 100.95

Lewis Hamilton 101.108

Lando Norris 101.336

Fernando Alonso 101.4

Esteban Ocon 101.699

Valtteri Bottas 101.875

Pierre Gasly 101.972

Daniel Ricciardo 102.012

Kevin Magnussen 102.185

Sebastian Vettel 102.189

Yuki Tsunoda 102.227

Mick Schumacher 102.315

Zhou Guanyu 102.319

Lance Stroll 102.438

Alexander Albon 102.537

Nicholas Latifi 103.387

 

The race, meanwhile, revealed the results of the cars to be:

 

Ferrari 100.070

Red Bull 100.194

Mercedes 100.893

Alpine 101.331

McLaren 101.335

Alfa Romeo 101.601

Alpha Tauri 101.773

Haas 101.800

Aston Martin 102.127

Williams 102.716

 

I suppose it is possible that they just put it into a spreadsheet at the end of each weekend, but Autosport also clearly have these statistics for the past as well. In the article about comparing different eras a few years ago, it was mentioned that Ferrari had a 0.218% advantage over BAR in 2004, and Cooper had 0.042% over Lotus in 1960. As well as the average gap from 1st to 2nd and 1st to 5th in every era. I cannot believe that someone from Autosport has manually plugged into a computer every single fastest lap of the weekend for every driver and team in history and calculated all these supertimes. There must be a quicker way to do it, or they must be available somewhere. I would like to find them. Does anyone have any suggestions? 

Edited by F1Frog, 07 October 2023 - 17:20.

[john aston]

Well, as Autosport has now become almost an F1 fanzine , as most of its readership equates motor sport with F1 , I wouldn't be surprised if they got the work experience kids to do it . 

 

Not a big fan of Latifi are you ? And he speaks so highly of you    

Edited by john aston, 09 October 2023 - 06:18.

[F1Frog]

I suppose it could be done in maybe a week if you had nothing else to do but would be very boring, so work experience kids fit the bill perfectly! I might have a go at one season and see how long it takes. I still think there is some kind of trick beyond basic excel knowledge.

And the Latifi comment in the signature actually isn’t about Latifi at all. A couple of years ago, I made a blog about F1 (and other motorsport but predominantly F1 as it is the one I enjoy most), and to help it become more popular on search engines, my friend, who had no knowledge or interest in motorsport beyond having seen the 2021 Abu Dhabi Grand Prix with me, decided to make five accounts on it and, over the next year wrote many weird and nonsensical, but also very clever and amusing comments (many of which did not pass the moderation system) under that name to make me laugh and motivate me to write the blog, including that one about Latifi and Blahaj which I particularly like. I am very grateful to him and wanted more people to see his funny way of writing, particularly after he recently passed away.

[Michael Ferner]

Some years (perhaps most, I didn't pay attention), the Autocourse annual had something similar, adding all qualifying times for the respective year.

[F1Frog]

Here are the results for 1950 (taking about one hour to calculate). I only used the qualifying times shown on Wikipedia, as I believe these included all practice sessions, did they not? But the Monaco Grand Prix results suggest an extra session that I don't know where to find the data for. It took about one hour to do this so maybe with a group of work experience kids, it could have been worked out in a few days for every season.

 

Cars (ignoring a few wildly anomalous results):

Alfa Romeo 100

Ferrari 102.038

Talbot-Lago 104.8429

Maserati 106.39

ERA 110.7581

Simca-Gordini 112.4752

Alta 117.4188

 

Drivers:

Juan Manuel Fangio

(Alfa Romeo)

100.0602

 

Giuseppe Farina

(Alfa Romeo)

100.9003

 

Reg Parnell

(Alfa Romeo)

101.2635

 

Consalvo Sanesi

(Alfa Romeo)

101.5177

 

Luigi Fagioli

(Alfa Romeo)

102.407

 

Luigi Villoresi

(Ferrari)

102.6611

 

Alberto Ascari

(Ferrari)

102.9375

 

Peter Walker

(ERA)

105.2347

 

Eugene Martin

(Talbot-Lago)

105.6539

 

Dorino Serafini

(Ferrari)

105.9022

 

Yves Giraud-Cabantous

(Talbot-Lago)

105.9449

 

Leslie Johnson

(ERA)

105.9567

 

Philippe Etancelin

(Talbot-Lago)

106.4401

 

Raymond Sommer

(Ferrari)

106.7595

 

Jose Froilan Gonzalez

(Maserati)

107.3649

 

Louis Rosier

(Talbot-Lago)

107.8868

 

B Bira

(Maserati)

108.0866

 

Emmanuele de Graffenried

(Maserati)

108.7068

 

Bob Gerard

(ERA)

108.9675

 

Raymond Sommer

(Talbot-Lago)

110.3663

 

Franco Rol

(Maserati)

111.093

 

Cuth Harrison

(ERA)

111.2996

 

Maurice Trintignant

(Simca-Gordini)

111.3211

 

Louis Chiron

(Maserati)

111.698

 

Pierre Levegh

(Talbot-Lago)

112.1883

 

Guy Mairesse

(Talbot-Lago)

112.3103

 

Robert Manzon

(Simca-Gordini)

112.4752

 

Henri Louveau

(Talbot-Lago)

112.8162

 

Eugene Chaboud

(Talbot-Lago)

112.9391

 

Felice Bonetto

(Maserati)

113.0441

 

Joe Kelly

(Alta)

113.8989

 

David Hampshire

(Maserati)

114.1978

 

Joe Fry

(Maserati)

114.6209

 

Nello Pagani

(Maserati)

115.2375

 

Reg Parnell

(Maserati)

115.5378

 

Johnny Claes

(Talbot-Lago)

116.078

 

David Murray

(Maserati)

116.5438

 

Geoffrey Crossley

(Alta)

117.4188

 

Peter Whitehead

(Ferrari)

117.5129

 

Harry Schell

(Talbot-Lago)

118.137

 

Charles Pozzi

(Talbot-Lago)

118.1939

 

Toni Branca

(Maserati)

120.8802

 

Clemente Biondetti

(Ferrari)

126.9815

 

Franco Comotti

(Maserati)

129.511

 

Paul Pietsch

(Maserati)

151.9393

 

 

The order is a bit skewed by drivers only competing in a few events.

Edited by F1Frog, 11 October 2023 - 12:56.

[F1Frog]

1951

 

Alfa Romeo   100.3987

Ferrari   101.0023

BRM   107.9505

Simca-Gordini   111.4093

Talbot-Lago   111.6802

ERA   113.1528

HWM-Alta   114.4323

Veritas   116.4849

OSCA   117.8445

Maserati   118.221

Alta   133.8491            

 

 

Juan Manuel Fangio Alfa Romeo 100.3987

Giuseppe Farina Alfa Romeo 101.4148

Jose Froilan Gonzalez Ferrari 101.7579

Alberto Ascari Ferrari 101.9465

Luigi Villoresi Ferrari 102.6188 ,

Paul Pietsch Alfa Romeo 103.34

Consalvo Sanesi Alfa Romeo 103.9365

Piero Taruffi Ferrari 104.1299

Luigi Fagioli Alfa Romeo 105.0789

Emmanuele de Graffenried Alfa Romeo 106.2781

Felice Bonetto Alfa Romeo 107.4623

Reg Parnell BRM 107.9505

Rudi Fischer Ferrari 108.1869

Ken Richardson BRM 110.9541

Reg Parnell Ferrari 112.5601

Henri Louveau Talbot-Lago 113.0212

Bob Gerard ERA 113.1528

Yves Giraud-Cabantous Talbot-Lago 113.3148

Maurice Trintignant Simca-Gordini 113.5205

Jose Froilan Gonzalez Talbot-Lago 113.7267

Louis Chiron Talbot-Lago 114.1334

Brian Shawe-Taylor ERA 114.3133

Robert Manzon Simca-Gordini 114.324

Andre Simon Simca-Gordini 114.3392

Stirling Moss HWM-Alta 114.4323

Louis Rosier Talbot-Lago 114.4609

Toni Branca Maserati 115.2568

Philippe Etancelin Talbot-Lago 115.3672

Chico Landi Ferrari 115.9011

Emmanuele de Graffenried Maserati 115.9095

Duncan Hamilton Talbot-Lago 116.1981

Peter Whitehead Ferrari 116.2273

Eugene Chaboud Talbot-Lago 116.4036

Peter Hirt Veritas 116.4849

Onofre Marimon Maserati 116.6095

Aldo Gordini Simca-Gordini 116.884

Franco Rol OSCA 117.8445

Louis Chiron Maserati 117.8961

Johnny Claes Talbot-Lago 118.1223

George Abecassis HWM-Alta 118.73

Georges Grignard Talbot-Lago 119.1362

Andre Pilette Talbot-Lago 119.2453

Pierre Levegh Talbot-Lago 119.3379

Paco Godia Maserati 120.5682

Harry Schell Maserati 120.9561

David Murray Maserati 121.8569

Jacques Swaters Talbot-Lago 122.4941

Guy Mairesse Talbot-Lago 122.7996

Juan Jover Maserati 124.0447

B Bira Maserati 127.1077

Philip Fotheringham-Parker Maserati 128.8201

John James Maserati 132.4952

Joe Kelly Alta 133.8491

Edited by F1Frog, 12 October 2023 - 17:20.