Had to come back and leave a comment - great instructions all round, very informative and clear. Keep up the solid work, subscribed cause I'll be back for more!

@DSMStrength

3 жыл бұрын

Thanks so much for the comment! I really appreciate you taking the time to watch the videos!

@harmanhumanperformance2615

3 жыл бұрын

@@DSMStrength Just added some more data into my table, but the chart has left out the date on the new entry. Any thoughts or suggestions?

Thanks man. Great video, this makes my life so much easier!

@DSMStrength

3 жыл бұрын

Luca thanks so much for watching man!! are you an S&C coach?

@lucaclementino_

3 жыл бұрын

@@DSMStrengthI'm actually an Athlete from Argentina and my team has no conditioning coach. So I basically do all the routines for the team by myself and these videos really help me save time.

Hello Dave, thank you for this tutorial, very useful! I'm wondering whether the "time" can be replaced by 'time under tension", because the amount of work is different. I mean that if you performed 50min of work versus 70min of work in a 90min training session, the stress applied will not be the same. What's your opinion ?

The information is very clear, but i have trouble trying to develope the fisrt table at Google sheet, is ther any explanation how to create the first table?

@DSMStrength , I love your document. I work in a football team and i would like to get apart of the individual players load, a graphic with the average load for everyday if a choose a week. Is it possible to get it modifying little bit this table? Sorry if you explained in other videos before but i couldn't find it. Thank you for all your work, it is very helpful to my daily work

@DSMStrength

2 жыл бұрын

yes you can modify it for sure

Hi Dave, I had a question regarding what if you have the capabilities (ie through Polar or Catapult monitoring systems) to get an actual training load calculation instead of using an arbitrary RPE and Duration. Would this still work or what specific changes would need to be made? As always great content!

@DSMStrength

3 жыл бұрын

Hey Will, it should work pretty darn close depending on what the output of the data is. As long as there is a date, and a training load value you can perform the calculation!

Hi, I am an athletic trainer from Taiwan. This is such a useful instruction and makes my paper work much much easier than ever (even im not s&c). I would like to ask if there is any possibility to have some application on tracking athlete's rehab progression by using google sheet? Well , still want to say thank you for this awesome video.

@DSMStrength

3 жыл бұрын

Absolutely if you blend this with the athlete dashboard series I put out it should work well!

Hello, I can't make the type of session work. If I have several type of session, the type of session doesn't refer to the corresponding date. Can you help me ?

Hi! Great Video. Is it possible to do the same in google sheets? I am trying to copy that in my google sheets, however I find difficulties when it comes to name the table, since it is neccesary to put filter formula at the beginning (6:45). Regards!

@DSMStrength

3 жыл бұрын

It's possible but it does not work the same way

@rafarudowski5722

3 жыл бұрын

@@DSMStrength any advices?

Hi, great video. I can’t seem to get my rolling averages formulas to work. I have it the same as the video but it’s not working for me. I’m on PC

@DSMStrength

Жыл бұрын

sounds like you are trying to pull a list from multiple columns, please only choose one column

Great video. However, what is the fix for when an athlete takes part in multiple sessions of different training types in the same day? Thanks

@DSMStrength

3 жыл бұрын

Hey Kieran I got that question before here is the video I did for that one. Thanks for checking the videos out kzread.info/dash/bejne/qKdnmsucmryYkrg.html

@kieransmith3742

3 жыл бұрын

@@DSMStrength Outstanding, i'll look harder next time before asking the question!

@DSMStrength

3 жыл бұрын

@@kieransmith3742 no problem !! please let me know if there are any other videos you would like to see.. hardest part of running a channel is ideas lol

Do you need data first before setting up this or can you set it up before having the date?

@DSMStrength

3 жыл бұрын

You can create your own dummy data to set it up then add real data when you get it.. just make sure you set up ur dummy data in the same format as what you plan to collect

@segunoladele8802

3 жыл бұрын

@@DSMStrength alright thank you

Hi great video. Can you send me a copy of this please

what version of excel is this? My version is 2019 but i dont have unique or filter.

@DSMStrength

3 жыл бұрын

Are you on a Mac?

@varunghosh2384

3 жыл бұрын

@@DSMStrength yes sir

@DSMStrength

3 жыл бұрын

@@varunghosh2384 unfortunately that will be why.. mac excel does not have same features

@varunghosh2384

3 жыл бұрын

@@DSMStrength is there a solution? Google sheets?

I cant get the option of Unique on my PC, can i use a different function for this

@DSMStrength

3 жыл бұрын

you might just want to put in the things manually, or you could use an index match formula. I would recommend updating your excel to the newer version if you can

@ericroodhooft973

3 жыл бұрын

@@DSMStrength I use excel 2019

@DSMStrength

3 жыл бұрын

@@ericroodhooft973 mac or pc?

@ericroodhooft973

3 жыл бұрын

@@DSMStrength pc

@DSMStrength

3 жыл бұрын

@@ericroodhooft973 thats really weird because acording to this link it should be available in excel pc 2019: www.spreadsheetweb.com/excel-unique-function/#:~:text=The%20Excel%20UNIQUE%20function%20is,be%20released%20with%20Excel%202019.

can this work on google sheets?

@DSMStrength

3 жыл бұрын

hey varun I am working on a g-sheet version of this

The content is good but your video is a bit unclear.

@DSMStrength

3 жыл бұрын

What would you like me to cover to help you out?

Hello, I can't make the type of session work. If I have several type of session, the type of session doesn't refer to the corresponding date. Can you help me ?

@DSMStrength

Жыл бұрын

I do not understand your question

@gianmarcociotti5252

11 ай бұрын

​@@DSMStrength yes, on minute 10'24" I also get error on the formula. =filter(TBLrpe[session], (TBLrpe[athlete name]=l1)*(TBLrpe[date]>=i4)) I cannot make it work on the latest excel version as i get "there is a problem with this formula" window.