Guided project · 6 steps Cellwise Plus
Running log and weekly miles in Excel
Turn two weeks of runs into pace per run, a true average pace and progress toward a weekly mileage goal.
You will use: ROUND, SUM, SUMIFS, DATE, MIN, MATCH, INDEX
Starting data
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Date | Type | Miles | Minutes | Pace (min/mi) | Total miles | ||
| 2 | Nov 2, 2026 | Easy | 3.1 | 30.5 | Average pace | |||
| 3 | Nov 4, 2026 | Tempo | 4 | 34.8 | Miles, week of Nov 9 | |||
| 4 | Nov 6, 2026 | Easy | 3.1 | 31.2 | Weekly goal (miles) | 22 | ||
| 5 | Nov 8, 2026 | Long | 6.5 | 66.3 | Share of goal | |||
| 6 | Nov 10, 2026 | Easy | 3.5 | 34.6 | Fastest run type | |||
| 7 | Nov 12, 2026 | Intervals | 4.2 | 36.1 | ||||
| 8 | Nov 14, 2026 | Easy | 3.1 | 30.1 | ||||
| 9 | Nov 15, 2026 | Long | 7.5 | 77.4 |
Build it step by step
Step 1
Work out the pace of each run in E2: minutes divided by miles, rounded to 2 decimals. Fill to E9.
Step 2
Total the miles in H1.
Step 3
What is your real average pace across all running? Total minutes divided by total miles, rounded to 2 decimals, in H2.
Step 4
How many miles did you run in the week starting November 9 (up to November 15)? Put it in H3.
Step 5
What share of your weekly goal in H4 did that week reach? Round to 2 decimals in H5.
Step 6
Which type of run had the fastest pace? Return its type in H6.