September 2026 · Archive
Connected Excel training records
Training Blocks feed Workout View and a prefilled Session Log. Completed sessions update record boards and the Progress Dashboard.
Excel Training System
An Excel workbook connecting training plans to completed sessions, personal records, and progress dashboards.
StatusMaintainingContextpersonalPeriodUpdated September 2026Primary toolsMicrosoft Excel · Structured tables
The problem
Training data often lives in disconnected sheets, notes, and templates, making it difficult to plan, review, and improve over time.
Project details
- Connected planning, session logging, and record boards
- Progress dashboard with weekly and training-block views
- A connected workflow from planned sessions to completed training records
Features
Training Blocks feed Workout View and prefill Session Log
Editable actual sets, repetitions, load, and workout date
Completion checkboxes control updates to Max Board and PR Date Board
Progress Dashboard shows consistency, weekly and block charts, workout dates, and completion status
Microsoft ExcelStructured tablesFormulasData validation
Approach
- 1
Connect programmed workouts to the session checklist
- 2
Separate editable actuals from calculated workout views
- 3
Limit record calculations to completed, valid results
- 4
Check data propagation, historical records, checkbox resets, formulas, and charts
Project journal
Continue exploring
Back to all projects