Practice Run SheetTue & Thu, 4:00–5:30 · trial week Sept 15 & 17 · Month One rotation Sept 22 – Oct 13. Portrait reading copy — the coach forms print better from the landscape version.
4:00Kids run off to coaches — Session One.
4:45Jen blows the whistle. Kids switch to their second sport. Coaches hand their Session One forms to Elsa.
5:30Dismissal. Parents check in with Jen, and 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.
  • Elsa — on the field the full practice. Session One: floats — water, bathroom runs, whatever a coach needs. Session Two: inputting Session One's data 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, staying as many sessions as it takes.

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 — 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, so coaches meet their real rosters and Elsa's data pipeline gets a dry run on real data.

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

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

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 what goes on the forms

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 about 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, with an optional re-test at month end 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.

CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled

Open itemsConfirm

  • Coach sign-off on the fitness change above, before Sept 22.
  • 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; we have four Radostis, three Cardennises and two Mukans.
  • Dated schedule from Thursday still to circulate.

One form per coach per session — Session One's 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.

Part Two · for Elsa
The forms

One form per coach per session — twelve in all, plus the overflow sheet. Session One's form goes to Elsa at the 4:45 whistle; Session Two's at dismissal.

These print better from the landscape copy; they're here so the whole plan reads in one document.

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

Hand this to Elsa at the whistle (Session One) or at dismissal (Session Two). Fitness columns: week one of the month only, ~10 min, kids in pairs — one works, one counts. Date: ______________

Volleyball — Group Two
Coach Amanda · Tuesday · Session One · 4:00–4:45
14 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel
seen
SprintPush-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① ② ③

Hand this to Elsa at the whistle (Session One) or at dismissal (Session Two). Fitness columns: week one of the month only, ~10 min, kids in pairs — one works, one counts. Date: ______________

Soccer — Group Three
Coach Dave · Tuesday · Session One · 4:00–4:45
13 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel
seen
SprintPush-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.① ② ③

Hand this to Elsa at the whistle (Session One) or at dismissal (Session Two). Fitness columns: week one of the month only, ~10 min, kids in pairs — one works, one counts. Date: ______________

Dance Fitness — Group One
Coach Nico · Tuesday · Session Two · 4:45–5:30
11 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel
seen
SprintPush-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.① ② ③

Hand this to Elsa at the whistle (Session One) or at dismissal (Session Two). Fitness columns: week one of the month only, ~10 min, kids in pairs — one works, one counts. Date: ______________

Volleyball — Group Two
Coach Amanda · Tuesday · Session Two · 4:45–5:30
11 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel
seen
SprintPush-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.① ② ③

Hand this to Elsa at the whistle (Session One) or at dismissal (Session Two). Fitness columns: week one of the month only, ~10 min, kids in pairs — one works, one counts. Date: ______________

Soccer — Group Three
Coach Dave · Tuesday · Session Two · 4:45–5:30
11 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel
seen
SprintPush-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① ② ③

Hand this to Elsa at the whistle (Session One) or at dismissal (Session Two). Fitness columns: week one of the month only, ~10 min, kids in pairs — one works, one counts. Date: ______________

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

Hand this to Elsa at the whistle (Session One) or at dismissal (Session Two). Fitness columns: week one of the month only, ~10 min, kids in pairs — one works, one counts. Date: ______________

Volleyball — Group Two
Coach Amanda · Thursday · Session One · 4:00–4:45
13 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel
seen
SprintPush-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.① ② ③

Hand this to Elsa at the whistle (Session One) or at dismissal (Session Two). Fitness columns: week one of the month only, ~10 min, kids in pairs — one works, one counts. Date: ______________

Ultimate — Group Three
Coach Jeff · Thursday · Session One · 4:00–4:45
16 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel
seen
SprintPush-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① ② ③

Hand this to Elsa at the whistle (Session One) or at dismissal (Session Two). Fitness columns: week one of the month only, ~10 min, kids in pairs — one works, one counts. Date: ______________

Dance Fitness — Group One
Coach Nico · Thursday · Session Two · 4:45–5:30
10 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel
seen
SprintPush-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.① ② ③

Hand this to Elsa at the whistle (Session One) or at dismissal (Session Two). Fitness columns: week one of the month only, ~10 min, kids in pairs — one works, one counts. Date: ______________

Volleyball — Group Two
Coach Amanda · Thursday · Session Two · 4:45–5:30
16 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel
seen
SprintPush-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① ② ③

Hand this to Elsa at the whistle (Session One) or at dismissal (Session Two). Fitness columns: week one of the month only, ~10 min, kids in pairs — one works, one counts. Date: ______________

Ultimate — Group Three
Coach Jeff · Thursday · Session Two · 4:45–5:30
9 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteLevel
seen
SprintPush-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.① ② ③

Hand this to Elsa at the whistle (Session One) or at dismissal (Session Two). Fitness columns: week one of the month only, ~10 min, kids in pairs — one works, one counts. Date: ______________

Fitness — Group Four
Jen on Tuesdays · Dave on Thursdays · overflow only
0–2 kids
CConfidentSShyFFastNNaturalENeeds encouragementHHigh-energyLLoved itXStruggled
AthleteCame fromSessionLevel seenTag(s)Why they opted out
 ① ② ③
 ① ② ③
 ① ② ③
 ① ② ③
 ① ② ③
 ① ② ③
 ① ② ③
 ① ② ③

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 we can see if one sport keeps generating opt-outs. Date: ______________

Part Three · for Elsa
Where the forms go

Everything before this 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 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. Reading copy; the coach forms live in the landscape run sheet.
4:00–4:45
on the field
Float. Water, bathroom runs, whatever a coach needs. No data entry yet.
4:45
the whistle
Three Session One forms come in — Dance, Volleyball, and Soccer on Tuesdays or Ultimate on Thursdays. Plus the overflow sheet if Group Four ran.
4:45–5:30
batch one
Input Session One from phone or laptop, on the field, while Session Two is running.
5:30
batch two
Collect 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 you 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.

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

Reading the formsWhat's data, what isn't, and the one rule that matters most

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.

Everything on this page comes off the paper form. The next three pages are the spreadsheet those values land in.

Tab 1 — Class log · column specOne row per athlete per 45-minute session. The bold names are the literal spreadsheet headers.
Class logFitness baselinePipeline issues
HeaderComes fromAllowed valuesNotes
Context — off the form's header, or the run sheet
AdateForm headerISO date — 2026-09-22ISO only, so it sorts.
BweekdayForm headerTue / ThuDifferent sports run each day.
CsessionForm header1 or 21 = 4:00–4:45, 2 = 4:45–5:30.
DsportForm headerDance Fitness · Volleyball · Soccer · Ultimate · Fitness"Fitness" = Group Four overflow.
EcoachForm headerNico · Amanda · Dave · Jeff · JenRedundant with sport — kept for sub coverage and the overflow group.
FgroupForm headerOne · Two · Three · FourThe group number belongs to the sport, not the kid — it changes between sessions.
Athlete
GstudentFormFull name — Huxley JamesForms say "Huxley J." — expand to the full name.
Hpassport_slugRoster & link listhuxley-j-2v7nThe join key to the passport. Pre-fill before Day 1.
Ipresent☐ tick columnY / NN rows still get a row — absence is data.
What the coach observed
Jlevel_seen① ② ③ circled1 / 2 / 3, or blankBlank 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 separated — C,F,LVerbatim letters, original order.
Lcoach_note"Note for Elsa"Free textWord 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_minFour values in one session = four rows, or four columns if you prefer wide. The Fitness baseline tab is the source of truth either way.
Nmetric_valueFitness columnsNumber only, no units — 4.61Seconds to 2 decimals; reps as whole numbers.
Pipeline test — your own columns, and the point of the exercise
Oentered_whereYoufield / homeSession One is field, Session Two is home. Tells us whether on-field entry actually works.
Pentry_minutesYouNumber — 1.5Rough per-kid entry time. Decides whether 70 rows a night is sustainable.
Qissue_refYouRow # on Pipeline issues tab, or blankLinks 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 — five rows worth learning from
Huxley Jamesthe normal case
date2026-09-22
weekdayTue
session1
sport / coachSoccer · Dave
slughuxley-j-2v7n
presentY
level_seen3
tagsC,F
coach_noteLed the line drill unasked
metricsprint_sec
value4.61
entered_wherefield
entry_minutes1.5
Lillian ?no last name, no slug yet
studentLillian ?
slug— blank —
presentY
level_seen2
coach_noteWarmed up by the end
tagsS,E
metricsprint_sec
value5.48
issue_ref3
Type the first name and a question mark, and log it. Don't invent a slug — an unmatched row is fixable later, a wrongly matched one isn't.
Sarah Mukannothing circled
presentY
level_seen— blank —
tagsH
value6.02
coach_noteAll effort, no level circled
Leave the level blank. Don't infer one from the note. A blank note is also normal — only chase if a whole column is empty.
Indy Morrisabsent
presentN
level_seen
tags
value
coach_noteAbsent
An absent kid still gets a row. Absence is data — a kid who misses the testing session is why a metric is blank.
Mytis CardennisGroup Four overflow
sportFitness
coachJen
groupFour
presentY
coach_noteOpted out of soccer, did boot camp
Same session, different row. Sport becomes "Fitness", coach becomes whoever ran it, and the note records what they were scheduled for — so we can see if one sport keeps generating opt-outs.

Then the same row goes into the passport. What we're watching: does the passport have somewhere to put every one of these fields? Does a tag read like something a nine-year-old understands? Does a missing value break the screen or just sit empty? Does phone entry on the field actually work? Slugs above are placeholders.

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
sec
pushups
/min
plank
sec
squats
/min
coach
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 RadostiT/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 they can be keyed 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
HeaderValuesExample / notes
Aissue_no1, 2, 3…Just a counter — referenced from Class log column Q.
BdateISO dateThe session it came from.
Cstagecoach form · transcription · field entry · home entry · passport displayWhich step broke. Tells us who owns the fix.
Dwhat_happenedFree text, one sentencePhone keyboard too slow for 16 rows before 5:30
Estudent_or_formName / sport, or "all"How wide the problem is.
Fblocks_launchY / NY = families can't see this as-is.
GresolutionFree text, filled laterBring the laptop, not the phone — blank until decided.

What counts as an issue

  • Handwriting you 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 with no last name.
  • An overflow kid whose row didn't have a clean home.

What you report backAfter Sept 17

  • Rows entered vs. rows expected — 66 Tuesday, 70 Thursday.
  • How much of Session One you 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 you 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.

Portrait reading copy. The landscape run sheet has the same five pages at the back, plus the coach forms and the Tuesday/Thursday rotations.