Performance Dashboard
Life University Women's Rugby
Don't see your name? Sign up
·
Staff / password login
Who are you?
Pick the role that fits you
Pick once · this device will remember you
| # | Player | Pos | G | Min | Attack | Defence | Overall | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Total | / G | / Min | Total | / G | / Min | Total | / Min | |||||
Drop all your player photos here — no need to rename them. If the filename happens to match a player (e.g. cora-haughey.jpg) it'll auto-assign, otherwise pick the player from the dropdown next to each photo. Saved to your browser so every PDF download includes the right photo. Re-do this once if you switch browsers or after the site goes live.
| Player | Dist (m) | Max Speed (km/h) | % of Max | Player Load | PL/min | m/min | Accel+Decel | Max Accel | Sprint Eff. | HR Exertion | Max HR | Avg HR | Impacts |
|---|
You're looking at the May 12 session baked in as static preview data so you can see the design before we wire the pipe. Once we agree the layout works, the next step is to add a GPS tab to the Google Sheet — every time a Catapult CTR CSV gets pasted in, this view picks it up live, just like the match data does.
For a fully automatic flow, OpenField can be set to schedule-export the CTR file to a Drive folder after every session — a small Apps Script then appends it to the sheet with zero clicks from you.
This tab reads from a tab in your Life Sheet called set_pieces. One row per event — a lineout, scrum, restart, kick, or breakdown.
Full schema is documented in SET_PIECES_SETUP.md in the project folder. Quick version:
Use the seed file set_pieces_seed.csv to bootstrap your tab with one match of example data, then replace with your own tagged matches.
Plans live in the Life Sheet, on a new tab called training_plans. The dashboard fetches and renders the plan on each reload — no editing needed in here.
training_plans (lowercase, with underscore).Date · Day · Theme · Block Group · Block · Time · Duration · Activity · Constraints · Work:Rest · Type · RPE · HR Zone · Contact · Equipment · Film · LeadFull schema details in TRAINING_PLAN_SETUP.md in the site folder.
Pro tip: if the Block Group names match the period names you set in Catapult OpenField, the dashboard will eventually be able to compare planned RPE / Zone vs actual GPS reading per block.
Coaches add events to the events tab of the team Google Sheet. Match fixtures are also auto-included from the home-page schedule. Coaches signed in with the coach password can also click any event and tap Edit to change it without leaving the dashboard (requires the Apps Script setup — see SCHEDULE_EDIT_SETUP.md). See SCHEDULE_SETUP.md for the basic sheet columns.
🧰 Need a quick way to add events to the sheet? Use the Event Builder ↗ — fill the form, click Copy row, paste straight into your events tab. Or download the starter template (events-template.tsv) and paste the worked example rows.
🎨 Set a day's RPE: Add an RPE column to the events tab. For any day you want to override the default intensity, fill the RPE cell with a number 1-10 on any event for that day — that becomes the colour of the whole day across every calendar view. 1-3 = light blue (recovery), 4-6 = green (moderate), 7-8 = yellow-orange (vigorous), 9-10 = red (max effort). Leave blank to use the day-of-week default.
This tab is visible only when signed in with the coach password. Players don't see it.
Traffic-light view of every player. 🟢 fit · 🟡 limited · 🔴 out. Sourced from today's daily_status rows, the open injuries rows, and wellness auto-flags. Click any card to open her Medical card with the full recovery timeline and smart cap.
Squad-wide strength snapshot from sc_testing, recent session activity from sc_session_logs (the mobile lift logger at strength.html), and exercise library from sc_exercises. Click any athlete to open her S&C player card. See STRENGTH_SETUP.md for the sheet schemas + Apps Script.
Named-individual force-plate + symptom data for athletes who've opted in. Trainer / S&C view. Click any athlete to drill into her player card. Standalone version with extra GPS & wellness overlays: cycle.html.
Your squad by position, ranked by game time. Coaches only. Team selection (drag the matchday 23) comes next.
Pick the matchday 23 for each fixture — tap a slot, then a player. Coaches only. (Publishing to players is the next step.)
Who's available to train and play — 🟢 fit · 🟡 limited · 🔴 out — for selection. Sourced from the medical board, but without the clinical detail (that stays with the medical / S&C staff).
Every login account in the Users tab. Set a person's role, reset a forgotten password, or activate / disable access. Passwords are stored only as a one-way hash — reset issues a new one.
Catapult OpenField exports a CTR (Catapult Training Report) CSV after each session. Three ways to land it here:
GPS tab of the Life sheet. Add a session date column at the start. Hit Reload on the dashboard.Names: The CSV uses full names ("Bella Vogel"); the rest of the dashboard uses short names ("B. Vogel"). The page handles the mapping automatically — clicking a name in the GPS table opens that player's full card.
Period filtering: Each Catapult export contains the whole session ("Session" period) plus the breakdown ("Primers", "Combat", "Channel Attack", etc.). Use the Period dropdown to look at the full session or zoom into a single block.
Each metric in Player Summary contributes a weighted amount to the score. Positive contributions add, errors subtract. Per-game divides by games played; per-minute divides by minutes played.
+1 × Total Points+5 × Line Breaks+8 × Try Assists (new)+3 × Offload Success+0.25 × Post Contact Metres+1 × Carries+0.5 × Gainline Success carries+0.2 × Pass Success+0.1 × Pass Attempts (playmaker volume bonus)+0.5 × Kicks From Hand (tactical kicking volume)+0.05 × Kick Metres (territory contribution)−2 × Handling Errors−3 × Turnovers Lost+1 × Tackle Success (count)+4 × Dominant Tackles+5 × Turnovers Won+2 × Tackle Assist / Double Tackle+0.5 × Defensive Breakdown Positive Arrival−2 × Negative Tackles−2.5 × Individual Penalty ConcededSame shape as 15s but with sevens-specific weights. Used on the 7s Individuals leaderboards and inside each 7s match's Match ratings table. Line breaks, turnovers won and try assists are rewarded more because they convert to tries at a much higher rate in 7s; missed tackles are penalised because there's no second-line cover.
+10 × Try Assists (vs +8 in 15s)+7 × Line Breaks (vs +5 in 15s)+7 × Turnovers Won (vs +5 in 15s)+1.5 × Tackle Success (vs +1 in 15s)+0.3 × Pass Success / Pass Attempts (vs +0.2 / +0.1 in 15s)−3 × Missed Tackles (NEW — usually = a try in 7s)−3 × Handling Errors (vs −2 in 15s)−4 × Turnovers Lost (vs −3 in 15s)−3 × Individual Penalty Conceded (vs −2.5 in 15s)Attack Effectiveness + Defensive Effectiveness. /Min is the most fair comparison across players with different game-time loads.
These weights are a starting point. If a metric is over- or under-weighted in your view, tell me which one and I'll adjust the formula.
Photos are optional — the dashboard works fine with the auto-generated initials avatars. To use real headshots:
Photo.Photo cell.Where to host the photos:
Photo cell. The dashboard auto-converts Drive share links into embeddable URLs..jpg / .png / .webp or returns an image directly.Square or close-to-square photos crop best (the avatar is circular).