Best Table to compare RPE & Load during a mesocycle - Complementary Training

Best Table to compare RPE & Load during a mesocycle

This topic contains 4 replies, has 2 voices, and was last updated by mm Mladen Jovanovic 5 years, 4 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • 23/01/2019 at 18:52 #24652

    Greetings all,

    I’m trying to figure out the best way to make a table that compares REP & load week to week. My goal is to have a combo chart that has Load as columns and RPE as a line on the secondary axis.

    The current table I have is ugly!

    I have:

    Load (duration of trainiing * RPE) and RPE (on a 0-5 scale) as columns

    Dates in the rows
    – Week 1 Day 1
    – Week 1 Day 2
    – Week 1 Day 3
    – Week 1 Day 4
    – Week 1 Day 5
    – Week 1 Day 6
    – Week 2 Day 1
    – Week 2 Day 2
    – etc.

    Any better recommendation on how to plot this would be greatly appreciated!

    24/01/2019 at 21:14 #24664

    Karl Broman wrote an excellent paper on data organization in spreadsheets:

    You can also check paper by Hadley Wickham:

    So not sure if you want it per athlete, averaged per team. The simplest would be to have week on x-axis, and add two lines on y-axis using two columns. So data needs to be:

    Week —– Load —- Rpe
    1 120 130
    2 115 135

    If your data is segregated per individual, etc, then you would need to use Pivot table to aggregate it and then plot

    25/01/2019 at 22:50 #24669

    Thanks Mladen!

    02/02/2019 at 20:55 #24714


    I’m trying to make my spreadsheet “high speed” at this point with the recommendation you provided above. Thanks for your assistance.

    My question has to do with form control buttons…

    I’m trying to find a macro code for a button that when pushed – it produces a pop-up. In that pop-up, will have a block to put in the duration of training, RPE, and date. Once the member inputs the data into the pop-up, it’ll auto populate it on the data table.

    Would you know how to do this? I’ve searched the internet and I’m coming up empty handed.

    I appreciate your expertise.


    05/02/2019 at 18:54 #24729

    If it is only pop-up us msgBox function in VBA, otherwise you will need to create your own form which is more complex.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.