Session RPE and Drill RPE Excel Workbook and User Guide

Last time I wrote about this, I had an outline for implementing session and drill RPE strategies that I finally have some experience with. Today I am going to give to you my workbook that I (and my soccer coaches) use on Excel to lay out weekly training plans. That previous article has been one of my most popular ones since I wrote it, and at the time, I wished someone had uploaded something like this that I could use. None were available so I made my own. With a little bit of input on your part, you will end up with a weekly profile for your team like this:

rpechart

It is very easy to implement and use once you get the hang of it, so I will do my best to help you understand what input is required so that the spreadsheets will do the rest for you. Download the Excel doc and then follow along with the instructions.

SO HERE IT IS:

Excel Document Download: drill-session-rpe-workbook

SO. When you open it, you’ll see 3 Tabs:

  1. ON FIELD DATA COLLECTION
  2. DRILL ENTRY
  3. DRILL DATA
  4. WEEKLY REPORT

Here’s what you need to do with each page..

1. ON FIELD DATA COLLECTION

Before training, you are going to have to decide what focal points you will have for your session. Once you have determined those, you can fill them in on the first sheet in the left column. Instead of “Drill 1” “Drill 2” etc. it will say “2v2” or “4v4” etc. (depending what you are working on that day) and assign a fixed time to that drill. Generally speaking, 8-12 minutes is a comfortable time to get a fair assessment from the players.

rpe-entry

So after each 8-12 minutes of the drill, the players will use the scale to report their scores of RPE for that specific drill. The scale is designed so that players will respect the severity of both 0 and 10. If you wish, feel free to change the “criteria” for each value. These work for us in our experimental phase, others may work for you in yours. The spreadsheet is set up to allow different reports for different position groups as well as offense, defense, or full team drills.

2. DRILL ENTRY

Once you have collected data for your practice session, you can enter it into your drill catalogue on tab 2: “DRILL ENTRY.”

drill-entry

manualentry

You’ll also need to manually enter rounded scores for each drill into the “SCORE” Column.

All you need to do on this tab is enter the player scores (1-10) for each drill in the corresponding players column in their role during the drill. The spreadsheet will average the data for full team, offense, defense, as well as each “position group” to the right. It will also automatically flag the average reported score as within (green) approaching (yellow) or red (outside) 1 standard deviation. This will alert you of players who may be over or under reporting their scores. In this case, you need to use your intuition about the players character, or the nature of the drill to determine what may have caused these outliers. In some cases, you may elect to delete the outliers’ score and go with the resulting average, or reassess during another session.

3. DRILL DATA

Once Tab 2 of the spreadsheet has done the leg work for you, you will need to enter the DRILL NAME and the resulting SCORES (RED BOXES) into your “DRILL DATA” tab.

drill-entry2

For example, you need to copy the name of the drill “8 v 6” and the calculated scores (red box to the right into the 3rd TAB as shown below:

drill-entry3

  1. Ensure you have entered the drill name as you wish it to appear in “WEEKLY PLAN”
  2. Choose the “PASTE VALUES” Function to avoid missing formulas
  3. See that the scores show up the same as they appear in TAB 2

As you build your catalog of drills and scores, you will be able to pick more from the drop down menus in the next step. We ended our Fall season with scores for 51 drills in our “DRILL DATA” catalog, as well as values for each 15 minutes of a game. I consider the game data to be the most important since it allows us to compare our practice training loads to that of a regular season match.

4. WEEKLY REPORT

The part you’ve been waiting for. Once you have your drills cataloged and are ready to put together training loads over a 7-day span (or less) you can use the final sheet to automatically populate in your training days. As discussed in the previous article, TIME as the multiplier is the most important. After initial collection, you will MANUALLY ENTER (in the yellow columns) the number of minutes you spend on each drill so that a score will be calculated for the position group, for that drill, that day.

rpeentry

Once you select the drills used in order for your training plan on TAB 4, and manually enter the number of minutes spent on each drill, the total scores for each position group will automatically populate in the “TOTAL PLAYER/POSITION LOADS” table on the same tab. The Chart should also automatically populate with training loads as shown below:

rpechart

Good luck, it takes a little bit of patience and a few extra hands to handle the on field entry, but it will be worth it for communicating with your athletic trainers and strength and conditioning coaches. Please comment with questions if you have them.

 

-Alex

One thought on “Session RPE and Drill RPE Excel Workbook and User Guide

  1. Pingback: Problem with Periodization Part II: A Function of Human Error | Alex Carnall: Physical Preparation

Comments are closed.