πŸ“Š
Drop Excel file
Release to load ranking data
Rankings
No file loaded View-only β€”
πŸ“Š
Drop your ranking file here
Drag and drop OP_Gold_for_website.xlsx
or any updated version of it
Accepts .xlsx Β· .xlsm Β· .xls Β· Drop again anytime to refresh

After each regatta, update col Y in the Excel file and drop it here again.

Manage regattas

Edit regatta names and dates. Regattas are automatically sorted in chronological order. The overall ranking uses the best 3 of the 5 latest regattas.

Multi-sailor simulation

Add sailors and assign hypothetical finish positions. The simulation adds a future Simulated Regatta and picks best 3 of the 5 latest regattas.

Squad criteria

All sailors must be ≀15yo. Best 3 of 5 latest regattas.

Nat A β€” top 8 per gender
MalesTop 8 ranked males
FemalesTop 8 ranked females
Nat B β€” per age group, max 8 per gender
13yo (2013)2M + 2F
12yo (2014)3M + 3F
11&U (2015+)3M + 3F
Unfilled β†’ next best same-gender
DS β€” ≀12yo, max 16
12yo (2014)1M + 1F
11yo (2015)4M + 4F
10&U (2016+)3M + 3F
Unfilled β†’ same-gender 11&U β†’ either-gender 11&U
Squad target calculator

Select a sailor and target squad to see the minimum finish needed in the next simulated regatta, who blocks them, and what-if scenarios.

How selection works

Nat A: age-agnostic top 8 per gender. Nat B: age-group quotas with same-gender backfill. DS: ≀12yo, strict quotas, same-gender then cross-gender backfill.

Scoring
EventsCalculated across latest 5 regattas
RuleBest 3 of the 5 latest regattas
Exclude from squad selection

Remove sailors who decline or are ineligible. Their spot passes to the next eligible sailor automatically.

What exclusions do

Excluded sailors are skipped in squad allocation. Persisted in local storage.

RankingsShown dimmed with reason
Squad badgeShows "Excl."
Permutation simExcluded from squad calc
Squad targetPool skips excluded sailor
Currently excluded
No sailors excluded
Major Competitions Tracker

Track and filter participation in major international and regional competitions over the years (2022 – 2026).

Historical Rankings & Gold Fleet Entry

Track when each sailor entered the Gold Fleet and their historical ranking snapshots at key milestones. Click on table headers to sort the milestones.

Show columns
Promote / Add New Sailor Β· Gold

Adds a sailor to the active Gold/Silver membership pool (sidebar pill). Gold and Silver sailors are ranked in separate series.

Roster upload uses the sidebar Gold / Silver pill. Columns: Name, Gender, Born, Club, School (header row). Sailors are added to the latest regatta of that fleet (or a new β€œFleet Roster” event) with blank ranks until scores are uploaded.

Legacy Browser Data Recovery

If you have previously input dates, metadata, or major competition participations in this browser that are not showing on the cloud, you can overwrite the cloud database with this browser's local cache.

Gold vs Silver membership

Each sailor belongs to one membership pool. Use β†’ Gold / β†’ Silver on a sailor to move them between fleets (e.g. promotion).

Gold / Silver pillWhich series board + membership list you manage
MembershipStored per sailor β€” only that fleet’s ranking counts them
DroppedHidden from rankings in their fleet; history kept
Regatta fleetEach event is Gold or Silver; scores stay in that series
Active Sailors

Click 'Drop' to remove a sailor from active rankings.

Dropped Sailors

Click 'Add / Re-promote' to restore them to active rankings.

Spreadsheet Import Verification

Compare and reconcile the uploaded spreadsheet with the active database before confirming.

Sailor Profile & Analysis
Major Competitions Participation
Optimist World Championship
Optimist European Championship
Optimist Asian & Oceanian Championship
SEA Games
Fleet Active fleet
Performance Analysis
Best Finish
β€”
Avg Finish
β€”
Regattas
β€”
Best Venue
β€”
STANDINGS & SQUAD HISTORY
As ofRankSquad
REGATTA RESULTS
Analysis

Squad score comparison for the top 20 sailors (best-3 score, lower is better), plus fleet distribution charts.

Squad Score Comparison (Top 20)

Avg score by squad

Rank vs score

Club distribution

Birth year distribution