I've downloaded the spreadsheet and can see what the problem is. In Column M you used =SUM(F7:J7)/3 which of course will only give the correct number if you have exactly 3 entries. Better use =AVERAGE(F7:J7) which will give the correct answer regardless of how many trials have been recorded.
Thought we'd also reply to this one. We updated to the =AVERAGE(F7:J7) formula. It obviously didn't get updated properly whilst we were building the spreadsheet.
I cant seem to find the spread sheet. great video guys :) was also going to point out the issue about the average but judging form the comments it seems to have been fixed
great info - is there not a hold "hold" function on the unit to accurately know the max force produced? (instead of going back to look at the frames from the phone camera)
Great to hear, Erick :)! You're absolutely right and that's why Mike is in the video recording with an iPhone so that he can using the "scrubbing/slow-mo" feature to find the peak value. We didn't spend too much time scrubbing through the video to find the peak value, so it may well have been 144.05kg. But for the purpose of the educational video, we showed everything needed to empower coaches with the knowledge they need to do it for themselves :)
Many Android phones have a slow motion video option that records video at 120 or 240 frames per second. Using that recording option makes it easier to spot the maximum value
@@mufc13aidan Most likely not, no. The reason being is if you don't use a firm surface (e.g. weight plate) to hold the straps down and simply try to with your feet, your feet will move and that will affect the data. You need a strong, immovable object to pull against to ensure no there is zero flex.
You're sure that a Crane Scale with maximum of 300kg is enough to test athlete ? Especially with IMTP , and similar, that can be execute at specific angles.
It won't be enough for all athletes, no. But it is enough for the largest majority of them. If you download our free crane scale how-to guide via the link below, you'll see some normative data. www.scienceforsport.com/how-to-test-an-athletes-max-strength-on-a-shoestring-budget/
The average column is being calculated wrong in the video. There is no way the average could be over 200 when all of your trials were around 130 (quick math at a glance). It may be dividing by the wrong number. Should be (131.75 + 130 + 128 + 134 + 131) / 5 (because you have 5 trials) = 130.95. Not 218. Honest mistake made in the sheets formula. Otherwise, great video.
Great video thank you. I dont know how to access the spreadsheet, could you send a link please ?. Thanks
I've downloaded the spreadsheet and can see what the problem is. In Column M you used =SUM(F7:J7)/3 which of course will only give the correct number if you have exactly 3 entries. Better use =AVERAGE(F7:J7) which will give the correct answer regardless of how many trials have been recorded.
Thought we'd also reply to this one. We updated to the =AVERAGE(F7:J7) formula. It obviously didn't get updated properly whilst we were building the spreadsheet.
S&C data nerd bullying. luv it.
Great video and explanation ( and excel sheet, saves me some time to build one) . cant believe this video has less than 4000 views
Very pleased to hear you think so 😁 I guess we'll have to improve the SEO of this video and maybe market it a little more then 👍
hi where can i download the spreadsheet.Great video
Hola!! Gran aporte!! Adquirí la grua!! Donde puedo conseguir la planilla? Saludos!!
I cant seem to find the spread sheet. great video guys :) was also going to point out the issue about the average but judging form the comments it seems to have been fixed
I have that same crane scale, mine has a "Hold" feature, it holds the Peak force
Any normative data that you have for this?
great info - is there not a hold "hold" function on the unit to accurately know the max force produced? (instead of going back to look at the frames from the phone camera)
Glad you liked it. Not on this device, unfortunately.
hiii, where can I download excel sheet for that?
Great Info. Definitely need something like Coach's Eye to see the peak strength. At 1:09 the peak strength seems to be 144.05.
Great to hear, Erick :)!
You're absolutely right and that's why Mike is in the video recording with an iPhone so that he can using the "scrubbing/slow-mo" feature to find the peak value. We didn't spend too much time scrubbing through the video to find the peak value, so it may well have been 144.05kg. But for the purpose of the educational video, we showed everything needed to empower coaches with the knowledge they need to do it for themselves :)
Many Android phones have a slow motion video option that records video at 120 or 240 frames per second. Using that recording option makes it easier to spot the maximum value
quick question: why multiply by gravity for avg N?
Because that allows us to calculate the average force production in Newtons, rather than just in Kg.
Hi, where I cand download excel file?
is there any crane scale available with peak force measure capability? would be useful when you have none to record the lift.
Same as above your average of lifts is over estimated!
You're absolutely right, and thanks for letting us. We've updated the file accordingly :)
How do you put the ratchet straps around the plate? Cant see how its set up in the video
No special way, they're literally just looped around :)
Science for Sport so you could just stand on the straps without using a plate or anything? Just to make it more portable
@@mufc13aidan Most likely not, no.
The reason being is if you don't use a firm surface (e.g. weight plate) to hold the straps down and simply try to with your feet, your feet will move and that will affect the data.
You need a strong, immovable object to pull against to ensure no there is zero flex.
There's an error in the spreadsheet. There's no way the average in column M can be higher than the peak in column K
Great spot, thanks for pointing it out for us :). We've updated the spreadsheet accordingly. We also hope that you find it useful.
You're sure that a Crane Scale with maximum of 300kg is enough to test athlete ?
Especially with IMTP , and similar, that can be execute at specific angles.
It won't be enough for all athletes, no. But it is enough for the largest majority of them. If you download our free crane scale how-to guide via the link below, you'll see some normative data.
www.scienceforsport.com/how-to-test-an-athletes-max-strength-on-a-shoestring-budget/
The average column is being calculated wrong in the video. There is no way the average could be over 200 when all of your trials were around 130 (quick math at a glance). It may be dividing by the wrong number. Should be (131.75 + 130 + 128 + 134 + 131) / 5 (because you have 5 trials) = 130.95. Not 218. Honest mistake made in the sheets formula. Otherwise, great video.