foldout
Free + Pro 6-sheet workbook no macros

Reps — workout log spreadsheet

One row per set: date, exercise, weight, reps. Volume per set, this week's sessions, sets and volume, and the best weight and best set per exercise. Pro adds an Exercises sheet with bests, last done and days since, a twelve-week view, and a body-weight log with change. No macros.

  • XLSX
  • No macros
  • SUMPRODUCT
  • COUNTIFS
  • Conditional formatting
  • Google Sheets

The sheets

  1. 01
    Log

    600 sets with an exercise dropdown; volume = weight × reps. This week's sessions (distinct dates), sets and volume; last four weeks' sessions; all-time sets. Free: best weight, best set volume and last done per exercise on the sheet. This week's rows shaded.

    Free + Pro
  2. 02
    Exercises

    Per exercise: sets, sessions, best weight, best set, total volume with bars, last done, days since — yellow at two weeks.

    Pro
  3. 03
    Weekly

    Twelve weeks ending with the current one: sessions, sets, volume with bars; totals and averages over active weeks.

    Pro
  4. 04
    Body

    60 weigh-ins with two measurements; change since the previous entry and since the start; latest, lowest, entries.

    Pro
  5. 05
    Setup

    As-of date, twelve exercises.

    Pro
  6. 06
    Formulas

    Seven formulas explained: distinct dates with SUMPRODUCT(1/COUNTIF), SUMPRODUCT(MAX()) for bests.

    Pro

Built for

  • Excel 2016+
  • Google Sheets
  • Numbers

Every workbook is recalculated in LibreOffice and by a second, independent formula engine on the sample data; the totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors. We don't run Excel itself on the build machine, so this says built for, not tested in — open the live preview to see the numbers the formulas produce.

What that means app by app: in Google Sheets, in Apple Numbers, in LibreOffice Calc.

Pro

$5

Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.

Set log with volume and weekly numbers
yes
Best weight and best set per exercise
yes
Sessions, last done, days since per exercise
yes
Twelve-week view
yes
Body-weight log
yes
Formulas walkthrough sheet
yes
Credit line on the sheet
not required
Updates and support
12 months, email

Licence

Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.

Full licence terms →

Sets in, progress out

A training log is a long list of sets, and everything you want to know is a question about that list: how many sessions this week, how much volume, what’s my best squat, when did I last deadlift. Each is a formula here. Sessions are distinct dates — SUMPRODUCT(1 / COUNTIF(dates, dates)), so a session with twelve sets counts once — and the best weight per exercise is SUMPRODUCT(MAX((exercise = name) × weight)), which makes MAX see the whole column without array entry.

Pro: per exercise, per week, per body

Exercises lines them up: sets, sessions, best weight, best set, total volume, last done and days since — yellow at two weeks, which is the honest way to notice what you’ve been avoiding. Weekly shows the last twelve weeks with bars. Body is the weigh-in log with change since the previous entry and since the start, green when it goes down.

Checked, not just built

The build recalculates both workbooks in LibreOffice and in a second, independent engine and compares twenty-nine values — volumes, this week’s sessions and sets, per-exercise bests and days since, the weekly table, body-weight changes — against numbers computed outside Excel.

Free download

  • reps.xlsx · Log sheet
  • README.md · LICENCE.txt

Pro download

  • reps-pro.xlsx · Log, Exercises, Weekly, Body,
  • Setup, Formulas
  • README.md · LICENCE.txt (Pro)

Read before you build

Version history

  • 1.0.02026-09-14

    First release

  • 0
    macros
  • 7
    formulas explained
  • 29
    checks the build runs
  • 600
    sets

Related spreadsheets

Meds — medication schedule and refill planner spreadsheet preview

One row per medicine with its strength, dose and the times of day it's taken; the week grid records doses actually taken and works out adherence against what was due. Pro adds a refill planner — units used a day, days left, the date it runs out and the date to order — and a dated dose log. A tracker, not medical advice. No macros.

  • XLSX
  • No macros
  • SUMPRODUCT
live demo →
Aim — goal and KPI tracker spreadsheet preview

One row per goal or KPI: start, target, current, dates, owner. Progress, expected progress from the calendar, days left and a status — Done, On track, Behind, Overdue — are calculated. Pro adds monthly check-ins that feed the current value, and a view by area and by owner. No macros.

  • XLSX
  • No macros
  • COUNTIFS
live demo →
Fleet — vehicle maintenance log spreadsheet preview

One row per service or repair with the odometer and the next-due the garage gave you; days and km to each, overdue and due-soon flags, cost this year. Pro adds a Vehicles sheet with cost per km and tax, insurance and inspection reminders, and a service schedule that reads last-done from the log. No macros.

  • XLSX
  • No macros
  • SUMPRODUCT
live demo →

Tell us what happened

Goes straight to a person. No account, no ticket number.

What is this about?

We keep the message and the page it came from. Nothing else — not your IP, not your browser. Privacy.