Choose a month
Excel workbooks · rebuilt with every 4-hourly report
September 2026
from the start of the race · so far: the month is still being sailed
Unofficial. Nothing in these files may be relayed to a competitor (NOR F.8.2). The positions are YB Tracking’s public feed; the wind and sea are Open-Meteo’s (CC BY 4.0), model values, not measured on board. If you use the data, please follow those sources’ guidelines.
In every file
Standing
One row per boat: the 24 hours to the newest report in the file. In a finished month, where the fleet stood as the month ended.
Daily
One row per boat per UTC day. A row closes at the 00:00 UTC report that follows the day, and a day belongs to the month it was sailed in.
Every report
One row per boat per 4-hourly report, with the 4-hour leg that ends at it.
Boats
The fleet: skipper, yacht, design, country.
Columns
What every column means, with its unit.
A blank cell means there is no value, never zero. A boat that missed a report keeps her last position with its true time, and current_fix says FALSE. legs_complete says how many of a day’s six 4-hour legs are whole: filter on 6 for clean 24-hour runs.
The columns
80 columns · the same list is inside every file
report_utc
UTC
Standing, Every report
The 4-hourly report: 00:00, 04:00, 08:00, 12:00, 16:00 or 20:00 UTC. On Standing, the newest report in the file; the row covers the 24 hours that end at it.
date_utc
date
Daily
The UTC day that was sailed. The row covers its 24 hours and closes at the 00:00 UTC report that follows.
race_day
Daily, Every report
GGR’s numbering: 6 September is day 0.
closing_report_utc
UTC
Daily
The report that closes the row.
boat_id
Standing, Daily, Every report
YB’s number for the boat; the same in every file.
skipper
Standing, Daily, Every report
The skipper’s name.
yacht
Standing, Daily, Every report
The yacht’s name.
design
Standing, Daily, Every report
The boat’s design.
country
Standing, Daily, Every report
Three-letter country code.
place
Standing, Daily, Every report
Rank by YB’s distance to finish at the report.
places_gained_24h
places
Standing, Daily, Every report
Places gained (+) or lost (−) since the report 24 hours earlier.
to_finish_nm
nm
Standing, Daily, Every report
Distance to finish, measured by YB along its course line. YB redrew the line on 22 September 2026, 844 nm longer from Trindade on, and recomputed its track; every figure here is on the new line.
gap_to_leader_nm
nm
Standing, Daily, Every report
This boat’s distance to finish minus the leader’s.
gap_to_boat_ahead_nm
nm
Standing, Daily, Every report
The same to the boat one place ahead. Blank for the leader.
lat
° north +
Standing, Daily, Every report
Latitude of the boat’s fix at the report, decimal degrees, north positive. A real fix from YB, never interpolated.
lon
° east +
Standing, Daily, Every report
Longitude of the same fix, decimal degrees, east positive.
fix_time_utc
UTC
Standing, Daily, Every report
The true time of that fix. Trackers do not all report on the second.
current_fix
TRUE/FALSE
Standing, Daily, Every report
FALSE when the boat missed this report: the position is then her last known one, with its older time, and the columns about the last 24 hours and 7 days are blank.
leg_nm
nm
Every report
Great-circle distance of the 4-hour leg that ends at this report. Blank: no fix at one end.
leg_avg_speed_kn
kt
Every report
That distance divided by the time between the two fixes: average speed over the ground.
leg_made_good_kn
kt
Every report
Speed made good toward the finish on the leg.
leg_course_made_good_deg
° true
Every report
The bearing from the leg’s first fix to its second. Not the heading.
start_lat
° north +
Standing, Daily
Latitude at the start of the 24 hours (the fix 24 hours earlier). Blank if either report was missed.
start_lon
° east +
Standing, Daily
Longitude at the start of the 24 hours.
run_24h_nm
nm
Standing, Daily, Every report
Miles sailed along the track over the six 4-hour legs of the 24 hours.
legs_complete
of 6
Standing, Daily, Every report
How many of the six 4-hour legs have a fix at both ends. With fewer than 6 the run holds a straight line across the silent stretch: a lower bound. Filter on 6 for clean runs.
run_crosses_silent_tracker
TRUE/FALSE
Standing, Daily, Every report
TRUE when the tracker missed a report in the 24 hours of the run: across it the boat is credited with a straight line, and if it was the first report of the 24 hours the run begins at the next one, so the run is the least the boat sailed. The site writes such a run ≥. It can be a record, and it counts in averages and medians unless it began late.
avg_speed_24h_kn
kt
Standing, Daily
The run divided by its hours: average speed over the ground.
made_good_24h_nm
nm
Standing, Daily
The fall in distance to finish over the 24 hours. This is what YB’s own 24-hour column shows.
made_good_24h_kn
kt
Standing, Daily
The same as a speed.
leg1_kn
kt
Standing, Daily
Average speed on the first 4-hour leg of the 24 hours (the oldest). Blank: no fix at one end.
leg2_kn
kt
Standing, Daily
Second leg.
leg3_kn
kt
Standing, Daily
Third leg.
leg4_kn
kt
Standing, Daily
Fourth leg.
leg5_kn
kt
Standing, Daily
Fifth leg.
leg6_kn
kt
Standing, Daily
Sixth leg (the newest).
gain_on_leader_24h_nm
nm
Standing, Daily, Every report
Miles gained (+) or lost (−) on the leader in 24 hours, fix to fix.
vs_boats_nearby_nm
nm
Standing, Daily
The 24-hour run minus the median run of the boats within 150 nm, which sail much the same weather. Blank when the boat’s own 24 hours began late.
boats_nearby
boats
Standing, Daily
How many boats that median is made of. Under 2, the column before is blank.
off_leader_track_nm
nm
Standing, Daily
Distance from the boat to the nearest point of the track the leader sailed.
off_leader_track_side
compass
Standing, Daily
The side of that track she lies on.
run_7d_nm
nm
Standing, Daily, Every report
Miles sailed over the last 42 legs. A restarted boat counts from her restart.
avg_speed_7d_kn
kt
Standing, Daily
Average speed over those legs.
made_good_7d_kn
kt
Standing, Daily
Speed made good toward the finish over 7 days; it drives the ETAs.
run_7d_crosses_silent_tracker
TRUE/FALSE
Standing, Daily, Every report
TRUE when the tracker missed a report in the seven days of the run: the 7-day run is then the least the boat sailed, and the site writes it ≥.
sailed_since_start_nm
nm
Standing, Daily
The sum of all 4-hour legs since the start (or the restart).
made_good_since_start_nm
nm
Standing, Daily
The fall in distance to finish since the start (or the restart).
best_24h_run_nm
nm
Standing, Daily
The boat’s longest 24-hour run so far. Where the tracker missed a report in its window it is the least the boat sailed: see best_24h_run_reports_missed.
best_24h_run_at_utc
UTC
Standing, Daily
The report that closed it.
best_4h_leg_kn
kt
Standing, Daily
The boat’s fastest 4-hour leg so far.
best_7d_run_nm
nm
Standing, Daily
The boat’s longest 7-day run so far. Where the tracker missed a report in its window it is the least the boat sailed: see best_7d_run_reports_missed.
personal_best_today
TRUE/FALSE
Standing, Daily
TRUE when this 24-hour run is the boat’s longest so far.
fleet_best_today
TRUE/FALSE
Standing, Daily
TRUE when it is also the longest of the whole fleet so far.
best_24h_run_reports_missed
reports
Standing, Daily
Reports the tracker missed in the window of the best 24-hour run. 0: every report was there. Above 0: the best is the least the boat sailed, and the site writes it ≥.
best_7d_run_reports_missed
reports
Standing, Daily
The same for the best 7-day run.
vs_van_den_heede_2018_nm
nm
Standing, Daily
Miles ahead (+) or behind (−) where Van Den Heede, the 2018 winner, was on the same race day.
vs_neuschafer_2022_nm
nm
Standing, Daily
The same against Neuschäfer, the 2022 winner.
speed_for_wind
ratio
Standing, Daily
Average leg speed divided by model wind speed, over legs sailed in 8–25 kt since the start. Needs ten legs.
speed_for_wind_legs
legs
Standing, Daily
How many legs that ratio is made of.
steadiness_7d_kn
kt
Standing, Daily
The spread (standard deviation) of 4-hour leg speeds over 7 days. Lower is steadier.
share_legs_5kn_7d
share
Standing, Daily
The share of legs at 5 kt or more over 7 days.
hours_parked_7d
h
Standing, Daily
Hours on legs under 2 kt over 7 days.
night_minus_day_kn
kt
Standing, Daily
Average leg speed at night (20:00–06:00 local solar time) minus by day, since the start. Needs six legs of each.
next_mark
Standing, Daily, Every report
The first mark of the course (NOR C.1.3) the boat has not yet passed.
next_mark_nm
nm
Standing, Daily, Every report
Great-circle distance to it.
next_mark_eta_utc
UTC
Standing, Daily, Every report
Distance to the mark divided by the 7-day made-good speed.
restart_utc
UTC
Standing, Daily
When a restarted boat left again (NOR C.1.2). Her runs and speeds count from then.
model_wind_kn
kt
Standing, Daily, Every report
MODEL wind at the fix (Open-Meteo, hourly mean at 10 m). Not measured on board.
model_gust_kn
kt
Standing, Daily, Every report
Model gust.
model_wind_from_deg
° true
Standing, Daily, Every report
The direction the model wind blows from.
model_pressure_hpa
hPa
Standing, Daily, Every report
Model sea-level pressure.
model_wave_m
m
Standing, Daily, Every report
Model significant wave height, sea and swell combined.
model_swell_m
m
Standing, Daily, Every report
Model swell height.
model_swell_period_s
s
Standing, Daily, Every report
Model swell period.
model_current_kn
kt
Standing, Daily, Every report
Model current speed.
model_current_to_deg
° true
Standing, Daily, Every report
The direction the model current sets toward.
model_sea_temp_c
°C
Standing, Daily, Every report
Model sea-surface temperature.
model_wind_mean_24h_kn
kt
Standing, Daily
The mean of the model wind at the reports of the 24 hours that have a value.
model_wind_max_24h_kn
kt
Standing, Daily
The highest of them.
model_wind_reports
of 6
Standing, Daily
How many of the six reports have a model value. The weather service does not always answer.