**Our Take: Transform your workout data into progress you can see and measure.**
ChrisF79 has asked a question that cuts to the heart of what data tracking should do: help you make better decisions, not just collect numbers. The problem isn't that spreadsheets are hard, it's that most people design them backward. They start with rows and columns and hope the insights magically appear. What Chris actually needs is a structure that answers one specific question before he even opens the app: "What did I do last time, and what should I do next?" That's the difference between a log and a tool.
The practical solution is simpler than it sounds. Create a single flat table with these columns: Date, Exercise, Set Number, Planned Weight, Planned Reps, Actual Weight, Actual Reps. Each set gets its own row. So for that bench press example, you'd have three rows for the three sets, one for each, with the date and exercise repeated. This design lets you pivot or filter by exercise, then chart actual weight or reps over time. The key insight is that "planned" and "actual" are separate columns. Chris mentioned failing on the third set, that failure is data, not a mistake. Recording it honestly turns a disappointing session into a signal for next time: maybe drop the weight, adjust rep targets, or add a rest day.
The reporting then becomes straightforward. A pivot table grouped by exercise and date can show the sum of actual reps per session, or the average weight per set. A pivot chart of that data reveals trends, are you stalling on bench press at 135 pounds? That's visible as a flat line, not a feeling. The table Chris wants for "what I did last time" is just a filter on the most recent date for each exercise. No complex formulas, no macros. Just clean, consistent structure. The human-centered truth here is that progress tracking should motivate, not overwhelm. When you see a line trending upward over weeks, that's the reward for logging the grind.
The takeaway is concrete: stop trying to design a perfect spreadsheet upfront. Start with this flat table, log your next three workouts, and build the pivot chart after. If the chart doesn't tell you something useful, like "my squat volume is inconsistent" or "my bench reps drop after set two", then adjust your columns. But start with action, not perfection. The data will reveal what you need next.