Worked example
Fictional client Alex, 12 due sessions, 10 completed including one partial session, and four separately tracked check-ins.
A client tracker that makes recording gaps visible.
An editable workbook that combines a lightweight client roster with detailed session, check-in, and performance records for one selected client.
Start with the blank template.
Start with the clean workbook. The worked example shows the calculations and separate check-in tracking.
Download example XLSX
The file is an .xlsx workbook for Excel. Google Sheets opens it through import; check the formulas, formatting, and validation after importing.
What the workbook contains
- A Clients sheet for a lightweight roster of IDs, names or codes, goals, start dates, upcoming dates, active status, and notes.
- Summary and Records sheets for detailed sessions and check-ins for one selected client.
- A Performance sheet for set-level load, reps, and RPE observations.
- Visible recording gaps so a blank cell is not treated as a confirmed missed session.
How to start using the tracker
The workbook is a working aid, not an automatic judgement about a client. First decide what you will consistently record for every session.
01
Open Instructions and Clients
Add the lightweight roster to Clients. For another client's detailed records, duplicate the whole file and preserve the supplied status labels because the formulas depend on them.
02
Record the actual state
Exclude future sessions. Mark a missing record as a data gap rather than automatically calling it a missed session.
03
Review the context
Compare attendance with feedback and check-ins. A percentage alone does not explain why something changed.
Client data stays in your file.
The download requires no sign-up and the page does not receive client details. You control access, sharing, and retention for the completed workbook in your own storage.
Related templates and workflows
Connect the tracker to a plan, client onboarding, and a regular review.
Want to connect tracking with daily coaching?
Socra.fit brings plans, workout logs, check-ins, and adherence into one coaching workflow.
Your first three active clients are free, with no time limit.