December 13, 2017

A spreadsheet for Sprint acceleration Force-Velocity-Power profiling

Written with Dr Pierre Samozino (University Savoie Mont Blanc)

Due to popular demand and frequent requests from sport practitioners and researchers, we have decided to publish a spreadsheet and tutorial for implementing our sprinting FVP field method based on split times measurements during a 30-m, all-out sprint acceleration, from a standing (2 or 3-point) start. This simple method has been initially proposed and validated against force plate data by Samozino et al. in 2016, and used afterwards in several publications (see here).

Download this spreadsheet HERE.

Watch the 10’ video tutorial here: 

This spreadsheet will automatically calculate the sprint force-velocity profile based on the following input variables: 5 split times over a 30 or 40-m acceleration, air temperature and pressure, stature and body mass of the athlete, based on the modeling of the position-time curve by an exponential function. 
After a quick adjustment of the 2 variables of the exponential model (maximal velocity Vmax and time constant Tau) to fit the actually measured split times, it will automatically display the FVP curves, the main mechanical outputs and the mechanical effectiveness. Note that you will need to install/use the Excel Solver add-in macro for this adjustment. 
For full details on the definition and practical meaning of these variables, please read this commentary paper.
In addition to exploring your athlete’s performance, it will indicate the underlying mechanical variables, and help you design more effective, individualized training content.
Furthermore, in the context of rehabilitation and return-to-sport processes, knowing an athlete’s pre-injury profile is gold to an effective, sprint-oriented rehabilitation and return-to-sport decision. See Jurdan Mendiguchia’s works on the topic in 2014, 2016 and 2017.
This “profiling” test may be done with only 4 split times (5, 10, 20, and 30m), but for more accuracy we recommend using 5 or 6.

As to the devices needed, well, it’s up to you, any device that accurately measures split times may be used: timing gates, iOS app MySprint, etc… But one thing is important to keep in mind: the most important thing to ensure that the measurements are valid and the data make sense is that the time measurement starts as soon as any propulsive action is produced. So what we recommend if you are using timing gates and not the iOS app MySprint, is that a system that reacts to the athlete’s first propulsive action triggers the timing (see review here). In case of a trigger by a first pair of cells (eg 20 or 50 cm in front of the athlete’s starting position), the split times will be underestimated, and thus F0 and Pmax variables will be largely overestimated. This is how soccer players are sometimes described as “faster than Bolt” in the News! When using this starting procedure, the athlete’s body has in fact a high forward velocity at the moment of triggering, which leads to erroneous values and performance/mechanics overestimations. For the same reasons, a standing start from a still position must be used.

Finally, this is a short list of normative values for the different mechanical variables, ranging from physically active (male) individuals with no specific sprint experience to elite athletes (mostly rugby players or sprinters), based on our own experience (please see the literature on the topic for more details).

F0 (N/kg): from 3-4 to 10-12 N/kg
V0 (m/s): from 5 to 12 m/s
Pmax (W/kg): from 6-7 to 25-30 W/kg
RF max (%): from 20 to 60%
Drf (%): from -10 to -4%

Note that our group will soon publish an extensive database for both male and female athletes. 
Should you obtain values beyond these standards, don’t blame the method or the spreadsheet, the issue is with the device used to measure split times, and/or the starting/triggering procedure. See our recent discussion on these overestimations here.

Using this model, this is the FVP profile of Usain Bolt during the current 100-m World Record:
Usain Bolt's 100-m record force-velocity-power profile

Ready, Set, Enjoy! 


  1. Dr. Morin,
    How do you propose one use external mechanical power-time signature to train effectively? Would the goal be to see maximum power delivery or the rise time of the power-time signal or both? Secondly, what is the implication of not being able to quantify internal power to move hands and limbs? This appears to be a significant omission to the analysis and (unfortunately) there maybe no easy field based way to quantify this? Shouldn't additional accelererometers on the hands for example be able to communicate this information to a center accelerometer?

    1. Hi Ron, thanks for your comments,
      the training associated with the "signature" has been partly addressed in our invited comment in International Journal of Sports Physiology and Performance and we've started to run some experimental studies to test what training intervention is useful to improve what variable in the profile (eg recently published study on the effects of very heavy sled on the "Ratio of Force" variable
      Our approach is based on an integrative approach based on the overall motion of the body so yes we can not assess "internal" work but as it relates to sports performance the most important is how body moves relative to the ground rather than how segments move relative to the body
      as you said, no easy way to quantify it !!
      accelerometers may be a track of research, but tough game ! to eventually know something that may not be relevant to performance on the track/field, i.e. how segments move around the CoM

  2. Your site is very useful for me,Thanks for your sharing.


  3. Thank you so much for the spread sheet and your site in general. I have one question though, how do you calculate the optimal slope of the force-velocity curve for horizontal sprint running in order to compare this to the actual slope? For example, in the instructional video the calculated slope is -0.8 N/s/m/kg, but wouldn´t you need to know the optimal slope in order to calculate if the F-v profile is deficient in force, velocity or well balanced? Is this a possibility as is the case for vertical profiling?

  4. I hope you continue to have such quality information to share with everyone! For ICC Cricket World Cup 2019 Schedule, click here!

    ICC 2019 Cricket World Cup Teams

    IPL 2019 Match Schedule

  5. Love to read it,Waiting For More new Update and I Already Read your Recent Post its Great Thanks. age of empires guide

  6. Hello, Its Very Nice blog also very useful for me.Thanks for sharing. Tired of searching websites of betting to get the best odds XML feed? Stop your searching and fulfill your demand. To know more, contact us now!

  7. Hiii...Thanks for sharing Great info...Nice post...Keep move on...
    Angular JS Training in Hyderabad

  8. creativity of writer is purely impressive. It has touched to the level of expertise with his writing. Everything is up to the mark. Written perfectly and I can use such information for my coming assignment.bioresonantie hilversum

  9. That’s what I was looking for. I am talking about all topics bundled in this blog. They all are really very useful for me as well as for my team. We are definitely going to use its highlighted information.hulp bij belastingaangifte amsterdam

  10. Awesome and interesting article. Great things you've always shared with us. Thanks. Just continue composing this kind of post.

  11. Automatic playing of videos will not increase the number of viewing hits unless viewers replay the videos. アプリ

  12. Fantastic post, very informative. I wonder why the other specialists of this sector do not notice this. You must continue your writing. I'm confident, you have a great readers' base already!bioresonantie hilversum

  13. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. sports and outdoors reviews

  14. Sometime few educational blogs become very helpful while getting relevant and new information related to your targeted area. As I found this blog and appreciate the information delivered to my database.bioresonantie apeldoorn

  15. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    top angularjs online training
    best angularjs online training
    angularjs online training

  16. Wow! this is Amazing! Do you know your hidden name meaning ? Click here to find your hidden name meaning