Workout tracking spreadsheet with PR auto-detect

Tell it your training style (powerlifting, marathon, Hyrox), your lifts, and your days/week — get a full Google Sheets workout log with PR auto-detection, volume load, and progress charts.

$3.99

Works in Claude (Pro/Max/Team) or ChatGPT (Plus/Team) · paid AI plan required

Both Claude + ChatGPT packages included — you can't pick the wrong one.

Updated May 26, 2026

Included

01Workout log columns built for your lifts: Date, Exercise, Set, Weight, Reps, RPE, e1RM, PR flag, Notes

02Epley e1RM auto-calc plus MAXIFS PR detection that fires the moment your e1RM beats the running max

03Weekly volume load per exercise via SUMPRODUCT, set counts for MEV/MRV, and acute:chronic workload ratio for runners

04Pace PR detection for 5K, 10K, half, marathon races using MINIFS — plus weekly mileage and easy/hard 80/20 split

05Different formula packs for powerlifting, general strength, marathon, 5K/10K, triathlon, and Hyrox (8-station log)

06Ships as HTML artifact + CSV + paste-ready Google Sheets formula block, with 8 weeks of example data pre-filled

What it does

MacroFactor, Strong, and FitNotes all charge $50-100 a year for tracking most lifters and runners could own in a Google Sheets workout tracker. This skill builds that spreadsheet for you — customized to your training style, your lifts, your schedule. Tell it whether you're powerlifting, marathon training, or doing Hyrox, list your main exercises, and say how many days a week you train. It outputs a ready-to-paste Google Sheets tracker: structured workout log, Epley e1RM auto-calc, MAXIFS-based PR auto-detection that flags every new personal record the moment you log it, weekly volume load per lift, and chart QUERY formulas you drop straight in. Runners get pace PRs by distance, weekly mileage SUMPRODUCT, the 10% rule check, and acute:chronic workload ratio for injury risk. Bundled reference files carry the formula library for strength and running, dashboard layout and conditional formatting (PRs in gold, volume warnings in orange), full Google Sheets setup with named ranges and data validation, and an example with 8 weeks of lifting plus 6 weeks of running already filled in. Want a biweekly summary, a Wilks column, or pace per km instead of miles — ask and it extends what it already built.

Frequently asked

How do I track PRs automatically in a Google Sheets workout log?

The skill ships an Epley e1RM formula (=E2*(1+F2/30)) in the e1RM column plus a MAXIFS PR-detection formula in the PR? column with an expanding range ($H$2:H2) that fires the moment your latest e1RM beats every prior session for that exercise. Conditional formatting paints the row gold. Same logic with MINIFS for running pace PRs by distance.

Does it work for powerlifting, marathon training, and Hyrox in the same tracker?

Different formula packs per style. Powerlifting gets e1RM PRs, rep-specific PRs, raw 1RM PRs, and weekly volume load. Marathon gets pace PRs by Run Type (5K Race, 10K Race, HM, Marathon), weekly mileage, acute:chronic workload ratio, and 80/20 easy/hard split. Hyrox gets a hybrid with 8-station MINIFS PRs added to the running log.

Does it actually build the spreadsheet, or just tell me what formulas to type?

It outputs the full formula blocks and sheet structure you paste into Google Sheets — not a tutorial. The setup guide walks you through named ranges (LogE1RM, LogExercise), data validation dropdowns for exercises, protected formula columns, and conditional formatting. Plus 8 weeks of example data pre-filled so you can see how MAXIFS PR detection behaves before you log a real set.

Can I just use Strong or MacroFactor instead of a spreadsheet?

You can — they cost $50-100/yr in perpetuity and you don't own the data. This is one prompt, no subscription, full ownership, and it does the same core tracking: log sessions, detect PRs, sum weekly volume, chart progress. Easier to customize too — add a Wilks column, a session-type filter for deloads, or a bodyweight column whenever you want.

Will the PR formulas break when I add new exercises later?

No. The PRTracker sheet uses =UNIQUE() to auto-discover exercises from your log, and MAXIFS uses the exercise name as the filter — so logging a new lift just adds a new PR row automatically. The setup guide also covers extending the row range from 500 to 2000 and using named ranges so formulas survive row insertions.

Install — no Terminal required

After checkout you land on a page with a one-click download and a pre-built install prompt. Pick the AI you already pay for — both packages are included, so you can't pick wrong.

What you'll see the second your payment clears

Your license key

ST-XXXX-XXXX-XXXX · permanent

Pre-built install prompt⧉ Copy

ChatGPT package (ZIP)⬇ Download

No setup work before you buy — copy, paste, done.

Have Claude Pro, Max, or Team?

Copy the prompt, paste into Claude

Copy the pre-built install prompt from the success page, paste it into any Claude Code chat, and Claude installs the skill itself — about 10 seconds. Using the app instead? Drop the downloaded folder into a Claude Project's knowledge and ask Claude to use it.

Have ChatGPT Plus or Team?

Build a Custom GPT — ~2 minutes

Click Download ChatGPT package (included with every purchase).
Unzip it — inside is a SETUP.md and a knowledge/ folder.
Go to chatgpt.com → your profile → My GPTs → Create a GPT → Configure.
Paste the Name, Description, and Instructions from SETUP.md into the matching fields.
Under Knowledge, upload every file in the knowledge/ folder.
Click Create/Save, open your GPT, and describe your task in plain English.

A paid plan on either platform is required — Claude (Pro, Max, or Team) or ChatGPT (Plus or Team). Comfortable with Terminal? A one-line npx skilltree-network install path is available too.

Workout tracking spreadsheet with PR auto-detect

What it does

Frequently asked

Install — no Terminal required

More in Spreadsheets & Templates

Personal Finance Dashboard Spreadsheet

Wedding Planning Spreadsheet Builder