Practice Run Sheet — Trial Week & Month OneTue & Thu, 4:00–5:30 · trial week Sept 15 & 17, Month One rotation Sept 22 – Oct 13
4:00Kids run off to coaches — Session One.
4:45Jen blows the whistle. Kids switch to their second sport. Coaches hand Session One forms to Elsa.
5:30Dismissal. Parents check in with Jen; she ticks pickup on the attendance sheet. Coaches hand Elsa the Session Two forms.
Before anyone leavesField trash check — nobody goes home until it's clear.

Who does whatLocked

  • Jen — whistle at 4:45, attendance, pickup check-off at 5:30. Also runs the Group Four overflow on Tuesdays (instructing only, not doing it with them).
  • Elsa — on the field the full practice. Session One: floats — water, bathroom runs, whatever a coach needs. Session Two: inputting Session One's metrics from a phone or laptop on the field. Session Two forms go home with her.
  • Coaches — teach their group, record on the session form, hand it to Elsa at the whistle.
  • Kasey — on-site Tuesday to teach Elsa the input, and staying as many sessions as it takes to be smooth.

Three sports a day, not four

  • Tuesdays — Dance Fitness (Nico), Volleyball (Amanda), Soccer (Dave).
  • Thursdays — Dance Fitness (Nico), Volleyball (Amanda), Ultimate (Jeff).
  • Group Four is the optional overflow: boot-camp fitness with Jen on Tuesdays, Dave on Thursdays. Only for a child who absolutely will not do their group's sport — expect one or two kids, if any.

Trial week vs. the rotationRead this

Sept 15 & 17 — still trying out the sports. Same groups as Month One below, so coaches meet their real rosters and Elsa's pipeline gets a dry run on real data.

Sept 22 — Month One rotation officially starts and runs Sept 22, Sept 29, Oct 6, Oct 13. Sports rotate every four weeks, so a kid who doesn't have dance, soccer or ultimate this month gets it next month.

Headcount

35 kids on Thursdays, 33 on Tuesdays — Cecilia and Eliana come Thursday only.

Open itemsConfirm

  • Fitness baseline can't fit the rotation as written — Dave is Tuesday-only and Jeff is Thursday-only, so under one fixed month a kid may never meet them. Recommendation on page 4.
  • Name list needs last names for Elijah, Gabe, Eliana, Kinslee, Lillian, Layla, Cecilia and Isaiah, and one spelling each for Abby/Abigail Radosti, Abigail Carter and Thadd/Thaddeus — Elsa needs unique names to key data against.
  • Dated schedule from Thursday still to circulate.
Tuesdays
Month One — Sept 22, Sept 29, Oct 6, Oct 13 (trial run Sept 15)
33 kids · Dance · Volleyball · Soccer
Session One · 4:00–4:45

Dance Fitness

Nico
Group One · 6
Christus R., Rhema R., Rizzo B., Sawyer M., Owen R., Elijah

Volleyball

Amanda
Group Two · 14
Paxton J., Jonny L., Olivia A., Layla, Erykah R., Anthony R., Adonis C., Asher R., Titus R., Abby R., Isaiah, Avery J., Josh R., Abigail Carter

Soccer

Dave
Group Three · 13
Huxley J., Ailana M., Lillian, Gabe, Sarah M., Kinslee, Aminah R., Thaddeus C., Samuel H., Indy M., Mytis C., Mello B., Alvah R.

Fitness

Jen — if needed
Group Four · overflow
Boot-camp style: running, burpees, push-ups. Only for a kid who truly won't do their sport. Jen instructs, doesn't participate.
Session Two · 4:45–5:30

Dance Fitness

Nico
Group One · 11
Olivia A., Huxley J., Titus R., Abby R., Kinslee, Aminah R., Lillian, Ailana M., Sarah M., Mytis C., Mello B.

Volleyball

Amanda
Group Two · 11
Christus R., Rhema R., Rizzo B., Sawyer M., Owen R., Elijah, Gabe, Samuel H., Indy M., Alvah R., Thadd C.

Soccer

Dave
Group Three · 11
Paxton J., Jonny L., Erykah R., Anthony R., Adonis C., Isaiah, Josh R., Asher R., Avery J., Layla, Abigail Carter

Fitness

Jen — if needed
Group Four · overflow
Same as Session One. Log any kid who ends up here on the overflow sheet so Elsa can account for them.

Jen's whistle at 4:45 is the switch. Coaches: hand your Session One form to Elsa at the whistle, not at the end of practice — she inputs it while Session Two is running.

Thursdays
Month One — Sept 24, Oct 1, Oct 8, Oct 15 (trial run Sept 17)
35 kids · Dance · Volleyball · Ultimate
Session One · 4:00–4:45

Dance Fitness

Nico
Group One · 6
Christus R., Rhema R., Rizzo B., Sawyer M., Owen R., Elijah

Volleyball

Amanda
Group Two · 13
Gabe, Samuel H., Indy M., Alvah R., Thadd C., Huxley J., Eliana, Kinslee, Lillian, Mytis C., Mello B., Sarah M., Ailana M.

Ultimate

Jeff
Group Three · 16
Paxton J., Jonny L., Olivia A., Layla, Erykah R., Cecilia, Anthony R., Adonis C., Asher R., Aminah R., Titus R., Abby R., Isaiah, Avery J., Josh R., Abigail Carter

Fitness

Dave — if needed
Group Four · overflow
Boot-camp style, same as Tuesdays. Dave covers it Thursdays since Soccer doesn't run.
Session Two · 4:45–5:30

Dance Fitness

Nico
Group One · 10
Gabe, Samuel H., Alvah R., Thadd C., Huxley J., Eliana, Kinslee, Lillian, Sarah M., Ailana M.

Volleyball

Amanda
Group Two · 16
Paxton J., Jonny L., Olivia A., Layla, Cecilia, Erykah R., Anthony R., Adonis C., Asher R., Aminah R., Titus R., Abby R., Isaiah, Avery J., Josh R., Abigail Carter

Ultimate

Jeff
Group Three · 9
Christus R., Rhema R., Rizzo B., Sawyer M., Owen R., Elijah, Mytis C., Mello B., Indy M.

Fitness

Dave — if needed
Group Four · overflow
Same as Session One.

Cecilia and Eliana are Thursday-only — they appear on Thursday sheets and nowhere else. Amanda's Session Two group is 16; if that's too many to record on, say so before Sept 17.

Fitness baseline & recordingFour metrics per kid — Sprint, Push-ups/min, Plank, Squats/min — plus how the sheets work

The problem with one-metric-per-coachDecision needed

The old plan gave each coach one metric. That worked when all four sports ran daily and every group met every coach. Under this rotation they don't: Dave only coaches Tuesdays, Jeff only Thursdays, and a kid keeps the same rotation for four weeks. Several kids would finish Month One with two of the four metrics and no way to get the others.

Recommendation: every coach runs all fourProposed

  • In week one of each month (Sept 22 & 24, then the first week of Month Two), each coach spends ~10 minutes of each session running all four metrics on the group in front of them.
  • Groups are 6–16 kids, so run them in pairs — one kid works, one counts.
  • Every kid gets all four from whoever they happen to have. Same numbers, one page, no extra staffing.
  • Remaining weeks are pure instruction. Optional re-test at the end of the month to show improvement.

Needs a yes from all four coaches, plus David's sprint distance and the rep-count standards, before Sept 22.

What coaches record — and don't

  • Attendance tick for every kid on the sheet.
  • Level seen — circle ① ② ③ if you saw enough to judge. Blank is fine.
  • Fitness numbers in the four metric columns, week one only.
  • Tag letters from the legend below — as many as apply.
  • Note for Elsa — one line, plain words, only if there's something worth a parent or a kid seeing.

No rubric scores yet. Nothing here is a grade or a placement; it's what you saw.

Observation tags

CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled

Write the letters, comma separated, in whatever order they come to you.

One form per session, not per day

The sheets that follow are one per coach per session. Session One's form goes to Elsa at the 4:45 whistle; Session Two's at 5:30. Don't hold both until the end — the whole point is that Elsa gets a head start on the field.

Dance Fitness — Group One
Coach Nico · Tuesday · Session One · 4:00–4:45 · hand this to Elsa at the whistle
6 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel seenSprintPush-ups
/min
Plank
sec
Squats
/min
Tag(s)Note for Elsa
Christus R.① ② ③
Rhema R.① ② ③
Rizzo B.① ② ③
Sawyer M.① ② ③
Owen R.① ② ③
Elijah① ② ③

Fitness columns: week one of the month only (Sept 22 & 24), ~10 min, kids in pairs — one works, one counts. Other weeks leave them blank. Date this sheet before you hand it over: ______________

Volleyball — Group Two
Coach Amanda · Tuesday · Session One · 4:00–4:45 · hand this to Elsa at the whistle
14 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel seenSprintPush-ups
/min
Plank
sec
Squats
/min
Tag(s)Note for Elsa
Paxton J.① ② ③
Jonny L.① ② ③
Olivia A.① ② ③
Layla① ② ③
Erykah R.① ② ③
Anthony R.① ② ③
Adonis C.① ② ③
Asher R.① ② ③
Titus R.① ② ③
Abby R.① ② ③
Isaiah① ② ③
Avery J.① ② ③
Josh R.① ② ③
Abigail Carter① ② ③

Fitness columns: week one of the month only (Sept 22 & 24), ~10 min, kids in pairs — one works, one counts. Other weeks leave them blank. Date this sheet before you hand it over: ______________

Soccer — Group Three
Coach Dave · Tuesday · Session One · 4:00–4:45 · hand this to Elsa at the whistle
13 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel seenSprintPush-ups
/min
Plank
sec
Squats
/min
Tag(s)Note for Elsa
Huxley J.① ② ③
Ailana M.① ② ③
Lillian① ② ③
Gabe① ② ③
Sarah M.① ② ③
Kinslee① ② ③
Aminah R.① ② ③
Thaddeus C.① ② ③
Samuel H.① ② ③
Indy M.① ② ③
Mytis C.① ② ③
Mello B.① ② ③
Alvah R.① ② ③

Fitness columns: week one of the month only (Sept 22 & 24), ~10 min, kids in pairs — one works, one counts. Other weeks leave them blank. Date this sheet before you hand it over: ______________

Dance Fitness — Group One
Coach Nico · Tuesday · Session Two · 4:45–5:30 · hand this to Elsa at the whistle
11 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel seenSprintPush-ups
/min
Plank
sec
Squats
/min
Tag(s)Note for Elsa
Olivia A.① ② ③
Huxley J.① ② ③
Titus R.① ② ③
Abby R.① ② ③
Kinslee① ② ③
Aminah R.① ② ③
Lillian① ② ③
Ailana M.① ② ③
Sarah M.① ② ③
Mytis C.① ② ③
Mello B.① ② ③

Fitness columns: week one of the month only (Sept 22 & 24), ~10 min, kids in pairs — one works, one counts. Other weeks leave them blank. Date this sheet before you hand it over: ______________

Volleyball — Group Two
Coach Amanda · Tuesday · Session Two · 4:45–5:30 · hand this to Elsa at the whistle
11 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel seenSprintPush-ups
/min
Plank
sec
Squats
/min
Tag(s)Note for Elsa
Christus R.① ② ③
Rhema R.① ② ③
Rizzo B.① ② ③
Sawyer M.① ② ③
Owen R.① ② ③
Elijah① ② ③
Gabe① ② ③
Samuel H.① ② ③
Indy M.① ② ③
Alvah R.① ② ③
Thadd C.① ② ③

Fitness columns: week one of the month only (Sept 22 & 24), ~10 min, kids in pairs — one works, one counts. Other weeks leave them blank. Date this sheet before you hand it over: ______________

Soccer — Group Three
Coach Dave · Tuesday · Session Two · 4:45–5:30 · hand this to Elsa at the whistle
11 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel seenSprintPush-ups
/min
Plank
sec
Squats
/min
Tag(s)Note for Elsa
Paxton J.① ② ③
Jonny L.① ② ③
Erykah R.① ② ③
Anthony R.① ② ③
Adonis C.① ② ③
Isaiah① ② ③
Josh R.① ② ③
Asher R.① ② ③
Avery J.① ② ③
Layla① ② ③
Abigail Carter① ② ③

Fitness columns: week one of the month only (Sept 22 & 24), ~10 min, kids in pairs — one works, one counts. Other weeks leave them blank. Date this sheet before you hand it over: ______________

Dance Fitness — Group One
Coach Nico · Thursday · Session One · 4:00–4:45 · hand this to Elsa at the whistle
6 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel seenSprintPush-ups
/min
Plank
sec
Squats
/min
Tag(s)Note for Elsa
Christus R.① ② ③
Rhema R.① ② ③
Rizzo B.① ② ③
Sawyer M.① ② ③
Owen R.① ② ③
Elijah① ② ③

Fitness columns: week one of the month only (Sept 22 & 24), ~10 min, kids in pairs — one works, one counts. Other weeks leave them blank. Date this sheet before you hand it over: ______________

Volleyball — Group Two
Coach Amanda · Thursday · Session One · 4:00–4:45 · hand this to Elsa at the whistle
13 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel seenSprintPush-ups
/min
Plank
sec
Squats
/min
Tag(s)Note for Elsa
Gabe① ② ③
Samuel H.① ② ③
Indy M.① ② ③
Alvah R.① ② ③
Thadd C.① ② ③
Huxley J.① ② ③
Eliana① ② ③
Kinslee① ② ③
Lillian① ② ③
Mytis C.① ② ③
Mello B.① ② ③
Sarah M.① ② ③
Ailana M.① ② ③

Fitness columns: week one of the month only (Sept 22 & 24), ~10 min, kids in pairs — one works, one counts. Other weeks leave them blank. Date this sheet before you hand it over: ______________

Ultimate — Group Three
Coach Jeff · Thursday · Session One · 4:00–4:45 · hand this to Elsa at the whistle
16 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel seenSprintPush-ups
/min
Plank
sec
Squats
/min
Tag(s)Note for Elsa
Paxton J.① ② ③
Jonny L.① ② ③
Olivia A.① ② ③
Layla① ② ③
Erykah R.① ② ③
Cecilia① ② ③
Anthony R.① ② ③
Adonis C.① ② ③
Asher R.① ② ③
Aminah R.① ② ③
Titus R.① ② ③
Abby R.① ② ③
Isaiah① ② ③
Avery J.① ② ③
Josh R.① ② ③
Abigail Carter① ② ③

Fitness columns: week one of the month only (Sept 22 & 24), ~10 min, kids in pairs — one works, one counts. Other weeks leave them blank. Date this sheet before you hand it over: ______________

Dance Fitness — Group One
Coach Nico · Thursday · Session Two · 4:45–5:30 · hand this to Elsa at the whistle
10 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel seenSprintPush-ups
/min
Plank
sec
Squats
/min
Tag(s)Note for Elsa
Gabe① ② ③
Samuel H.① ② ③
Alvah R.① ② ③
Thadd C.① ② ③
Huxley J.① ② ③
Eliana① ② ③
Kinslee① ② ③
Lillian① ② ③
Sarah M.① ② ③
Ailana M.① ② ③

Fitness columns: week one of the month only (Sept 22 & 24), ~10 min, kids in pairs — one works, one counts. Other weeks leave them blank. Date this sheet before you hand it over: ______________

Volleyball — Group Two
Coach Amanda · Thursday · Session Two · 4:45–5:30 · hand this to Elsa at the whistle
16 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel seenSprintPush-ups
/min
Plank
sec
Squats
/min
Tag(s)Note for Elsa
Paxton J.① ② ③
Jonny L.① ② ③
Olivia A.① ② ③
Layla① ② ③
Cecilia① ② ③
Erykah R.① ② ③
Anthony R.① ② ③
Adonis C.① ② ③
Asher R.① ② ③
Aminah R.① ② ③
Titus R.① ② ③
Abby R.① ② ③
Isaiah① ② ③
Avery J.① ② ③
Josh R.① ② ③
Abigail Carter① ② ③

Fitness columns: week one of the month only (Sept 22 & 24), ~10 min, kids in pairs — one works, one counts. Other weeks leave them blank. Date this sheet before you hand it over: ______________

Ultimate — Group Three
Coach Jeff · Thursday · Session Two · 4:45–5:30 · hand this to Elsa at the whistle
9 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel seenSprintPush-ups
/min
Plank
sec
Squats
/min
Tag(s)Note for Elsa
Christus R.① ② ③
Rhema R.① ② ③
Rizzo B.① ② ③
Sawyer M.① ② ③
Owen R.① ② ③
Elijah① ② ③
Mytis C.① ② ③
Mello B.① ② ③
Indy M.① ② ③

Fitness columns: week one of the month only (Sept 22 & 24), ~10 min, kids in pairs — one works, one counts. Other weeks leave them blank. Date this sheet before you hand it over: ______________

Fitness — Group Four (overflow)
Jen on Tuesdays · Dave on Thursdays · only for a kid who won't join their sport
Expect 0–2 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteCame fromSessionLevel seenTag(s)Why they opted out — note for Elsa
 ① ② ③
 ① ② ③
 ① ② ③
 ① ② ③
 ① ② ③
 ① ② ③
 ① ② ③
 ① ② ③

Elsa still needs a row for these kids — they were present, just not in their assigned sport. "Came from" = the sport they were scheduled for, so the reason is recorded and we can see if one sport keeps generating opt-outs. Date: ______________

Part Two · for Elsa
Where the forms go

Everything up to here is the field: the clock, the groups, the forms coaches fill in. Everything after it is what Elsa does with those forms — the spreadsheet she types them into, column by column, and the log of everything that didn't fit.

Coaches don't need these five pages. Elsa, Kasey and Jen do.

Elsa's Intake SheetWhat comes off the coach forms and onto the spreadsheet — two batches a night, Tuesdays & Thursdays
4:00–4:45 · on the fieldFloat. Water, bathroom runs, whatever a coach needs. No data entry yet.
4:45 · whistleThree Session One forms come in — Dance, Volleyball, and Soccer (Tue) or Ultimate (Thu). Plus the overflow sheet if Group Four ran.
4:45–5:30 · batch oneInput Session One from phone or laptop, on the field, while Session Two is running.
5:30 · batch twoCollect the three Session Two forms at dismissal. Input at home the same night.

Three tabs, that's itLocked

  1. Class log — the main tab. One row per kid per session. Columns A–Q, spec on the next page.
  2. Fitness baseline — one row per kid, four metric columns. Filled in week one of each month.
  3. Pipeline issues — anything Elsa couldn't read, couldn't map, or had to guess at. This tab is the real deliverable of the trial.

How many rows to expect

  • Tuesdays — 33 kids × 2 sessions = 66 rows.
  • Thursdays — 35 kids × 2 sessions = 70 rows. Cecilia and Eliana are Thursday-only.
  • Roughly half get entered on the field, half at home.
  • Trial week is Sept 15 & 17; Month One rotation runs Sept 22, Sept 29, Oct 6, Oct 13.

TrainingLocked

Kasey is on-site Tuesday to walk through the input live, and staying for as many sessions as it takes before Elsa is on her own.

What's on a coach form

Six things per athlete, and they map straight across:

  • attendance tick → column I
  • ① ② ③ level seen, circled → column J
  • Four fitness columns, week one only → columns M–N
  • Tag letters → column K
  • "Note for Elsa" free text → column L

Nothing else on the form is data. No rubric scores exist yet — if a coach writes one in the margin, it goes in the note column, not a score column.

Don't interpretImportant

Tags and notes get copied verbatim — letters as letters, notes word for word. If handwriting is unreadable, leave the cell blank and log it in Pipeline issues rather than guessing; an unreadable cell is a finding, a guessed cell is corrupted data.

CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled

Before Sept 15Needed

  • Passport slugs for all 35 kids, so column H is pre-filled rather than looked up mid-entry.
  • Last names for Elijah, Gabe, Eliana, Kinslee, Lillian, Layla, Cecilia and Isaiah — and one spelling each for Abby/Abigail Radosti, Abigail Carter and Thadd/Thaddeus.
Tab 1 — Class log · column specOne row per athlete per 45-minute session. Bold names are the literal spreadsheet headers.
Class logFitness baselinePipeline issues
HeaderComes fromAllowed valuesExampleNotes
Context — off the form's header, or the run sheet
AdateForm headerISO date2026-09-22ISO only, so it sorts.
BweekdayForm headerTue / ThuTueDifferent sports run each day.
CsessionForm header1 or 211 = 4:00–4:45, 2 = 4:45–5:30.
DsportForm headerDance Fitness · Volleyball · Soccer · Ultimate · FitnessSoccer"Fitness" = Group Four overflow.
EcoachForm headerNico · Amanda · Dave · Jeff · JenDaveRedundant with sport — kept for sub coverage and the overflow group.
FgroupForm headerOne · Two · Three · FourThreeGroup number belongs to the sport, not the kid — it changes between sessions.
Athlete
GstudentFormFull nameHuxley JamesForms say "Huxley J." — expand to the full name.
Hpassport_slugRoster & link listslug stringhuxley-j-2v7nThe join key to the passport. Pre-fill before Day 1.
Ipresent☐ tick columnY / NYN rows still get a row — absence is data.
What the coach observed
Jlevel_seen① ② ③ circled1 / 2 / 3, or blank2Blank is fine and common. Never average two circles — take the higher and note it.
KtagsTag(s) columnC S F N E H L X, comma separatedC,F,LVerbatim letters, original order.
Lcoach_note"Note for Elsa"Free textFirst time volleying — kept goingWord for word. Don't tidy the grammar.
Fitness — week one of each month only, all four metrics from whoever that kid's coach is
MmetricFitness columnssprint_sec · pushups_min · plank_sec · squats_minsprint_secFour values in one session = four rows, or four columns if Elsa prefers wide. Fitness baseline tab is the source of truth either way.
Nmetric_valueFitness columnsNumber only, no units4.61Seconds to 2 decimals; reps as whole numbers.
Pipeline test — Elsa's own columns, and the point of the exercise
Oentered_whereElsafield / homefieldSession One is field, Session Two is home. Tells us if on-field entry actually works.
Pentry_minutesElsaNumber1.5Rough per-kid entry time. Decides whether 70 rows a night is sustainable.
Qissue_refElsaRow # on Pipeline issues tab, or blank12Links a bad row to its explanation.

Freeze the header row; A–F are identical for every kid on one form, so fill them once and drag down. One file for the whole season — wildlight-intake.xlsx in the shared drive.

Tab 1 — worked exampleDave's Soccer form, Tue Sept 22, Session One, Group Three — what it looks like once typed
datedaysesssportcoachstudentpassport_slugpreslvltagscoach_notemetricvalue
2026-09-22Tue1SoccerDaveHuxley Jameshuxley-j-2v7nY3C,FLed the line drill unaskedsprint_sec4.61
2026-09-22Tue1SoccerDaveAilana Mukanailana-m-k52vY2N,LGood first touch, needs both feetsprint_sec5.12
2026-09-22Tue1SoccerDaveLillian ?Y2S,EWarmed up by the endsprint_sec5.48
2026-09-22Tue1SoccerDaveSarah Mukansarah-m-r18jYHAll effort, no level circledsprint_sec6.02
2026-09-22Tue1SoccerDaveSamuel Haysamuel-h-t60cY1Ssprint_sec6.30
2026-09-22Tue1SoccerDaveIndy Morrisindy-m-8c4qNAbsent
2026-09-22Tue1FitnessJenMytis Cardennismytis-c-h37wYXOpted out of soccer, did boot camp

What the example is teaching

  • Row 3 — no last name, no slug yet. Type the first name and a ?, and log it; don't invent a slug.
  • Row 4 — no level circled. Leave blank; don't infer one from the note.
  • Row 5 — no note written. A blank note is normal; only chase if the whole column is empty.
  • Row 6 — an absent kid still gets a row, present = N, everything else dashed.
  • Row 7 — a Group Four overflow kid. Sport becomes "Fitness", coach becomes Jen, and the note records what they were scheduled for. Same session, different row.

Then the same row goes into the passport

For each row, open that kid's passport and enter the level, tags, note and any metric. What we're watching: does the passport have somewhere to put every one of these fields? Does a tag render as something a nine-year-old understands? Does a missing value break the screen, or just sit empty? Does on-field entry from a phone actually work, or does it need a laptop?

Anything that doesn't fit goes on the issues tab. A trial where Elsa reports twenty awkward fields is a successful trial.

Slugs above are placeholders — swap in the real ones from the roster & link generator before Sept 15.

Tab 2 — Fitness baselineOne row per athlete, all 35. Filled in week one of each month by whoever that kid's coach is that month.
Class logFitness baselinePipeline issues
studentpassport_slugdayssprint_secpushups_minplank_secsquats_mincoachall_four?complete
Christus RadostiT/Th
Rhema RadostiT/Th
Rizzo BacigalupoT/Th
Sawyer MorrisT/Th
Owen RoncaT/Th
Elijah ?T/Th
Gabe ?T/Th
Samuel HayT/Th
Indy MorrisT/Th
Alvah RadostiT/Th
Thadd CardennisT/Th
Huxley JamesT/Th
Kinslee ?T/Th
Lillian ?T/Th
Mytis CardennisT/Th
Mello BacigalupoT/Th
Sarah MukanT/Th
Ailana MukanT/Th
Aminah ReidT/Th
Paxton JamesT/Th
Jonny LynchT/Th
Olivia AlfredsT/Th
Layla ?T/Th
Erykah ReidT/Th
Anthony RodriguezT/Th
Adonis CardennisT/Th
Asher RadostiT/Th
Titus RadostiT/Th
Abigail Radosti (Abby R.)T/Th
Isaiah ?T/Th
Avery JeneretteT/Th
Josh RuizT/Th
Abigail CarterT/Th
Cecilia ?Thu only
Eliana ?Thu only

Numbers only — no "sec", no "reps". coach = who ran the test, since it's no longer one metric per coach. A blank after week one means that kid missed the testing session: flag it, don't back-fill from an estimate. Re-tests at month end go in the Class log (columns M–N) and never overwrite the baseline here. The eight ? names need last names before Elsa can key them reliably.

Tab 3 — Pipeline issuesThe real output of the trial. Every awkward moment gets a row; this is the list we fix before families see anything.
Class logFitness baselinePipeline issues
HeaderValuesExampleScopeNotes
Aissue_no1, 2, 3…12Referenced from Class log col QJust a counter.
BdateISO date2026-09-22Session it came from
Cstagecoach form · transcription · field entry · home entry · passport displayfield entryWhich step brokeTells us who owns the fix.
Dwhat_happenedFree text, one sentencePhone keyboard too slow for 16 rows before 5:30Plain language.
Estudent_or_formName / sport, or "all"allHow wide the problem is.
Fblocks_launchY / NYY = families can't see this as-is.
GresolutionFree text, filled laterElsa brings the laptop, not the phoneBlank until decided.

What counts as an issue

  • Handwriting Elsa couldn't read.
  • A field on the form with nowhere to go in the passport — or a passport field with nothing on the form to fill it.
  • Session One's batch not finished by 5:30, and why.
  • A tag that reads badly to a kid or a parent.
  • A missing fitness value, and how the passport displayed the gap.
  • A name matched by guesswork — four Radostis, three Cardennises, two Mukans, two Abigails, and eight kids without a last name.
  • An overflow kid whose row didn't have a clean home.

What Elsa reports backAfter Sept 17

  • Rows entered vs. rows expected — 66 Tuesday, 70 Thursday.
  • How much of Session One she actually cleared on the field, and on what device.
  • Average entry minutes per kid, from Class log column P. That's the number that decides whether this survives a real season at 35 kids.
  • The blocks_launch = Y list, as short as possible.
  • One sentence: would she run a real season on this, or does it need to be a proper form?

Still openConfirm

  • Real passport slugs, and last names for the eight unknowns, before Sept 15.
  • Phone or laptop for on-field entry — decide before Tuesday so Kasey trains on the real device.
  • Who reviews this before October family access.