💡 Training Load Monitoring – Practical Tools from Research to Application

In my last post https://lnkd.in/dQ3XMb5F, I explored how Session-RPE (sRPE) provides a reliable and evidence-based approach to monitoring internal training load using just two simple metrics:

➡️ Session duration and

➡️ Rating of Perceived Exertion (RPE)

📊 Building on that framework, I’ve developed a training load monitoring Excel spreadsheet (cca. in 30 min only) that brings these concepts into daily practice.

What’s inside?

✅ Training Load (TL) based on exposure hours and RPE
📈 Training Monotony: insight into weekly variability
🔁 Training Strain: combined volume × monotony metric
🧮 Auto-calculations and weekly summaries to flag potential overloads

🔗 To simplify data collection, I’ve created a Google Form for athletes to submit their RPE and session duration. This feeds directly into the Excel spreadsheet, allowing real-time, automatic calculation of all key training metrics.

📈 In future posts, I’ll be upgrading this monitoring tool with more comprehensive metrics:

🎯 MCID (Minimal Clinically Important Difference) thresholds for better interpretation

🔬 TRIMP methods (as previously discussed: https://lnkd.in/dzU7-kGD) for a more comprehensive understanding of internal load

Whether you're working with youth, elite teams, or individuals, this system is simple, scalable, and science-backed—designed to help you coach smarter, not harder.

For more insights on this and similar topics 👇
Follow me on LinkedIn: https://lnkd.in/d4s9r8pA 🔔

Let’s make performance data practical.

Currently, the Training Load Monitoring (TLM) V1.0 is designed in MS Excel 2021, where it works without any restrictions.
 
For users with older versions of Excel, you may need to replace some formulas with versions compatible with your software.
 
Here’s an example of using a filter function:
 
🔹 Excel 2021 (and newer):
=SUM(FILTER(N:N,(B:B=B2)))
 
🔹 Excel 2019 (and older):
=SUMIFS(N:N,B:B,B2)
 
In some cases, you may need to use a fixed range of cells with the $ sign:
 
=SUMIFS($N$2:$N$43,$B$2:$B$43,B2)
 
Which formula works best will depend on the Excel version you are currently using.
 
👉 If you experience any problems with the tool, please do not hesitate to contact me, and we’ll find a solution that works for your needs.