How to Calculate Training Volume in Excel (Formulas + Free Template)

Training volume is the workload an athlete absorbs — and it's the lever behind most progress and most overuse. The problem is that coaches usually estimate it by feel. Excel lets you actually measure it, with formulas simple enough to set up once and reuse forever.

Here's how to calculate training volume in Excel, from a single set to a full week, plus how to spot when one athlete's workload is drifting away from the group.

The core volume formula

The standard measure of strength-training volume is volume load — reps multiplied by the weight lifted. In Excel, for a set with reps in B2 and load in C2:

=B2*C2

That's volume for one set. A set of 5 reps at 200 lb is 1,000 lb of volume load. Drag the formula down your set list and every line calculates itself.

If you'd rather count hard sets (a common way to track hypertrophy work), volume is just a count:

=COUNTIF(D2:D20,">=7")

…where column D is RPE and you're counting sets at RPE 7 or higher.

Roll it up to the week

A single set doesn't tell you much — weekly volume does. Sum the per-set volume across all of an athlete's sessions:

=SUM(E2:E60)

…where column E holds each set's volume load. Now you can watch weekly volume climb through a build phase and drop on a deload, instead of guessing.

To compare exercises or athletes fairly, average it:

=AVERAGE(E2:E60)

Track variability with standard deviation

Here's the step most coaches skip. Two athletes can hit the same average load and be in completely different places — one steady, one all over the map. Standard deviation measures that spread. If you've ever searched how to work out SD on Excel, it's one function:

=STDEV.S(F2:F30)

…where F is the range of values you're checking — test scores, weekly volumes, bar speeds. A low number means the group (or the athlete) is consistent; a high number means something's worth a closer look. It's the same math behind a "strength profile," and it turns a column of test numbers into a real read on who's an outlier.

Average tells you the middle. Standard deviation tells you who's drifting from it. Coaches who only track the average miss the athlete quietly falling behind.

Build it once, reuse it forever

The beauty of doing this in Excel is that you set the formulas up a single time. After that, you type in reps and loads and the volume, weekly totals, and variability all update on their own. No recalculating, no notebook tallies.

Skip the setup — get the free template

If you'd rather not wire the formulas yourself, the free Evaluations & Testing template already has the volume and testing math built in — drop in the numbers and read the output. It's free to download alongside the rest of the library.