After race 5 of the 2022 season.


F1 Driver Standings

PosDriverTeamPointsWins
1mcCharles LeclercFerrari1042
2nlMax VerstappenRed Bull853
3mxSergio PrezRed Bull660
4gbGeorge RussellMercedes590
5esCarlos SainzFerrari530
6gbLewis HamiltonMercedes360
7gbLando NorrisMcLaren350
8fiValtteri BottasAlfa Romeo300
9frEsteban OconAlpine F1 Team240
10dkKevin MagnussenHaas F1 Team150
11auDaniel RicciardoMcLaren110
12jpYuki TsunodaAlphaTauri100
13frPierre GaslyAlphaTauri60
14deSebastian VettelAston Martin40
15thAlexander AlbonWilliams30
16esFernando AlonsoAlpine F1 Team20
17caLance StrollAston Martin20
18cnGuanyu ZhouAlfa Romeo10
19deMick SchumacherHaas F1 Team00
20deNico HlkenbergAston Martin00

F1 Constructor Standings

POSTeamPoints
1itFerrari157
2atRed Bull151
3deMercedes95
4gbMcLaren46
5chAlfa Romeo31
6frAlpine F1 Team26
7itAlphaTauri16
8usHaas F1 Team15
9gbAston Martin6
10gbWilliams3

Race winners this season

DateDriverTeamRaceGrid Pos
20/03/2022Charles LeclercFerrariBahrain Grand Prix, Bahrain1
27/03/2022Max VerstappenRed BullSaudi Arabian Grand Prix, Saudi Arabia4
10/04/2022Charles LeclercFerrariAustralian Grand Prix, Australia1
24/04/2022Max VerstappenRed BullEmilia Romagna Grand Prix, Italy1
08/05/2022Max VerstappenRed BullMiami Grand Prix, USA3

An example of data automation using the ergast.com API as a source of F1 data loaded into Excel using the legacy get data xml method. A VBA macro creates the table html and uploads it to the server and is embedded in this web page using a server-side include.

For more info on F1 visit the excellent formula1hub.com.