SDC Rhythm XP Performance Measurement Tool

Any team serious about training needs to track their progress. Jack Jefferies (Airspeed) in an article published in 2002 explains why. SDC Rhythm XP would like to share the tool we developed. It was really helpful for us last year to quantify our strengths and weaknesses. Feel free to share it with anyone you want. We just request that you do not resell or use it for profit. We would also really appreciate your comments and suggestions. Visit the Frequently Asked Questions page for most common issues. For feedback or to get an answer not yet covered in the FAQ page, please go to our forum. There is a section dedicated. If you feel this tool can help you, enjoy!

Downloads: Blank file / Rhythm 2007 stats as a demo
Updated 03/06/2009 - New logos and passwords

Main features

Existing data transfer

If you would like to use this program but already have a lot of data in an existing file, we can help you transfer the data automatically. Contact Laurent for help.

How to use it (basic steps)

First, the security option in your excel application must be set to Medium or low. To check, open a blank excel file and go to: Tools>Options>Security (Tab)>Macro Security> Set to "Medium"
Once you've done this, open the file and click "Enable Macros" when prompted.

In all pages, the cells where you can input data are green with red border: Input Cell

Set the key parameters on the Menu page

  • Select mode: 4-way or 8-way
  • Select Hill Time: On the menu page. Enter the time you consider to be "on the hill." This is generally accepted as 8-10 seconds. Any formation started before this time will be considered on the hill. For more advanced team, the bottom of the hill might not affect your times that much. In such case, you may want to select a lower value to target a specific zone after exit.
Menu Page

Set your Targets in Dashboard

Click on "Dashboard" from the menu.
  • You can enter the times you target and the score.
  • To make sure the target times are in line with the targeted score, click on the "Target" button. A pop-up window allows you to set target times and see the resulting score from those times. If you don't know what times to select, you can set the values after you have timed a few jumps.
Targets

Time your jumps

Click on "Time and Add New Jumps" from the menu.
  • Date: Enter the date of the jump. You can use the popup calendar by clicking on the icon on the left of the cell.
  • Week#: Enter the week# here. Start with 1.
  • Exit formation: By default, it is the 1st point once you enter the dive. We recommend leaving it this way even if you transition to the 1st point. This will help you keep track your performance on exit for all formation.
  • Bust: Enter the # of busts for this jump
  • # Jumps that week: Enter how many jumps you did that week. In order to keep a true count of your total jumps, you may want to include the jumps that you could not time. Over the course of your jump entry, the last value you enter will be the value used for that week. You can also update this in the sheet "Weekly Progress."
  • Dive: Enter each formation starting from the top. Randoms must be in capital letters. If the dive has 3 points, leave the rest blank
  • Select this dive: Once you've entered the dive, click on "Select this Dive or Reset" button. You can also use this button to redo the timing. Just click on it again and all the times for that jump will be erased.
  • Track 1st Key option: If you would like to track the time between the first judgeable point and the first key, select "Yes." If you select this option, you must click once when you judge the exit formation complete, and once again with the first key. You may consider this a useful metric of exit performance.
  • Beep on: This enables a beep every time you click while timing the jump.
  • Exit button: This button or "s" starts the timer.
  • Point button: After you click the "Exit" button, click on this or [SPACE] to add each point. If you select "Track the 1st Key", then the first click on this button is when the first point is visible, and the second click is when the first key happens. There is no stop button.
    Tip: the time is recorded when you release the button. If you use a mouse, it means that the time is recorded when you release the mouse button. So if you click too soon, keep the button down and release only at the moment you want
  • Copy to "Data" Sheet: Click on this button to add the data for this jump to the database. Nothing gets added until this is clicked, so if you made a mistake, click "Select the Dive" and try again.
Page
General
Dive
Options
Buttons

Calculate

Once you have timed and validated all your jumps, return to the menu and click "Calculate All". Until you do this, nothing is updated with the jumps you just entered. If you check the "Check Data" box, the program will check for common data problems before calculating. If you didn't change anything directly in the "Data" or "Weekly Progress" sheets, you don't need this.

Calculate

See the results

You can navigate from the Menu page or with the tabs at the bottom.

Dashboard: This page shows various statistics from last week and overall.
  • Exit times: This is calculated with the last 2 exits even if they did not occur in the most recent week.
  • Weekly Average (or last practiced): Columns J-L is a copy of the data you will find in the "Weekly Progress" page for the latest week. The times for each formation are for the latest week only or the last week practiced if that formation was not practiced during the latest week.
  • Best of season: Shows the best time and corresponding jump #.
  • Variance: Shows the min, max and average for the period selected in cells Q9 and Q10. In future release, this may be replaced by another indicator to track consistency.
Weekly Progress: This page shows the stats for each week entered.
  • Times: (Lines 5-8) Shows the overall weekly average for that week. If a formation wasn't practiced that week, the last week it was practiced is considered.
  • Estimated Overall Possible Score: Shows an estimate for each week of your score considering your performance on ALL the blocks and randoms. It eliminates the artificial high or low actual scores resulting from your training focus in a given week. It's calculated considering the averages on the hill and flat for randoms, top of block and block execution with respectively 26.7%, 36.7% and 36.7% contribution to the score. Those % come from the split when considering all 16 randoms and 22 blocks (16 randoms, 22 top of block, 22 block execution => 60 points total)
  • Exits: (Lines 9-10) Shows the average times at exit for the last 2 exits for each formation.
  • Times for each formation:: (Lines 14-76) Shows the details for each formation. Again if a particular formation was not practiced that week, it looks at the week before.
Charts: You can customize all your charts except two ("Individual Times" and "Times by Repetitions - Block").
Important comment for the charts: Don't delete any data series. This will mess up the page when you come back to it. The scales (X and Y axis) are set automatically when you activate the page.

Sorting: This page allows you to sort the formations by time. The data are from the latest week. You can also compare with top teams, though these numbers are estimates only. If you have better numbers for top teams, we will be happy to include them.

Prediction: This page allows you to simulate mock meets and predict your score based on your current performance. Simply input the dives (1 up to 10) and click the "Calculate" button. The way it is now is probably conservative so this might be updated later on as well.
Dashboard
Weekly Progress
Chart
Sorting
Prediction

Modify the data

Click on "Raw Data" from the menu.
You can unlock the page and modify or delete any data after you added them. Just make sure you keep the format the way it is. This page is the most important page. The data for 1 jump takes 3 rows. So if you need to delete a jump, delete the 3 rows.
Data

If you still have additional questions, please visit our forum. If you don't find the answer, you can contact us. Contact Laurent if you have specific questions about what the code does and how to customize this file.

Advice for newer teams

We found that rather than focusing on doing things faster, a more effective way to use this tool is to find the places where we were least consistent and work on those. Trying to go faster is rarely the answer to a better skydive. This tool will help you identify areas to work on most, then only practice will make those improvements happen.

SDC
Skydive Chicago (SDC)
PD Canopies
Performance Designs
Paraclete XP
Paraclete XP Wind Tunnel