Kurt, great to hear from you man. glad someone is finding some use from them. I dont always get them out as often as Id like but ill keep trying. hope you are well cheers
Hi Dave, I have been going through and creating the yearly training plan. When I came to the step where you type in the formula for week =weeknum followed by F12, I got a 2 instead of a 1 to coincide the microcycle week. Granted I know you made this in 2017, I was taking the current year 2020 and the first Monday started on the 6th. I don't know why is isn't recognizing it as the first week. Any thoughts on how to fix this situation?
Weeknum(F12,13). Enter this, because the first day of the year is on a wednesday for the year 2020, which will be returned by the number 13. That should resolve the issue I suppose.
Hi, I just want to let you know, your videos are great. I have been watching all of them and plan on staying up tonight to make an excel spread sheet with you template. I also wanted to tell you that I am a personal trainer and have been trying to learn how to write up a annual planner so that my clients will know what is to come for the year, But the problem is Im still trying to figure out how to fill in your template with the pre-planned workouts, reps, phase, cycles and just about everything else. If you can help me that would be wonderful.
These tutorials are great as I am following along on the yearly planner. Question that I have for this specific tutorial is once you have set the conditional formatting for the competition dates with the fill in colour that you want and everything is working smoothly, is there a way to have the competition date box show nothing in it again after you have already chosen a specific date of competition if the dates get changed. Not sure if this makes sense, but as an example, lets say in the first week column for the competition date I had previously checked that there is a game that week on whatever day. The game gets moved to the next week and I want to cancel out the checked colour and date from the original scheduled game and I would like that column to show nothing for competition dates now. Is there a way to change this as I can't seem to figure out how? Thanks again for posting these tutorials and any help is much appreciated.
I am not sure I quite understand what you are asking. I would say just have this document be fluid and delete the date from the box so that the colors disappear from the schedule if you need the ability to add multiple games in a week you could always make more rows and term them Home game #1, home game #2 etc and follow the same process to have them all highlight up. if you want further help you can email me at dsmtrength@gmail.com I could take a look for you
Hey Dustin, thanks for checking out the videos. I am not sure if you saw some of the other videos in this series but this one: ruclips.net/video/9Ryt5MpaE04/видео.html has the tutorial on how to create the scrolling dates. hope that helps
These videos are incredibly helpful, thanks for doing this. One question, I would like to have both lifts and competitions highlighted throughout the week. Is there a way to have two boxes at the bottom, one for competitions and one for lifts? Just trying to get everything I need on one schedule.
regarding competition highlighting man, when using the scroll macro because the (list options change) when you scroll through it no longer highlights the dates. Example you set the competition dates and then as you go through the week and scroll* all the highlighted ones are off because the corresponding boxes have changed (main question) - how do you get the comp box inputs to rotate(specifically with the date that was initially selected?)
What do you do if you have more than one competition a week like in hockey, baseball, or hockey? You addressed it in the Opponent box, but not the Competition box.
+Jason CSCS hey Jason good question. Lots of options for something like that obviously you will need to Taylor to your needs.. my solution would be to make the opponent box longer so there is more room to type on it. Also add more date boxes to select game days.. traveldays etc
Hello, I am not quite sure what you mean. I must apologize for being late getting back to you I was on vacation. if you are still having this issue feel free to email me your sheet and I can have a look at some point dsmstrength@gmail.com
i look at the YTP as something the is specific to you.. i typically just add boxes for home and away matches but it has to be something that you will look at and understand.
Weeknum(F12,13). Enter this, because the first day of the year is on a wednesday for the year 2020, which will be returned by the number 13. That should resolve the issue I suppose.
Weeknum(F12,13). Enter this, because the first day of the year is on a wednesday for the year 2020, which will be returned by the number 13. That should resolve the issue I suppose.
@@alpocio117 well it shouldnt really matter as you are just using that row to signify the week in the year.. but if you want to just label it 1 2 3 4 etc yourself without a formula
Hi, my question would how to add another competition column with selected dates to the same week above, I tried to do the same thing with a different color but all I get is ### or weird numbers. For example, I want to make the annual plan for the basketball team and they have two games a week how do I set up so I can highlight two dates in one week? Please let me know. Thank you
Support my channel consider subscribing HERE: bit.ly/2DkcNdl
Love it. Looking forward to the next video to finish off the template! Love learning these excel hacks.
yeah we are pretty close now!
Thanks for doing these. Really appreciate your time.
Kurt, great to hear from you man.
glad someone is finding some use from them.
I dont always get them out as often as Id like but ill keep trying.
hope you are well cheers
Great video thanks coach!
Thanks for watching Draeshawn
Theses videos are great. Do think you might start from a blank spreadsheet and go step by step.
Yes absolutely that is for sure something I will look at doing!
Hi Dave, I have been going through and creating the yearly training plan. When I came to the step where you type in the formula for week =weeknum followed by F12, I got a 2 instead of a 1 to coincide the microcycle week. Granted I know you made this in 2017, I was taking the current year 2020 and the first Monday started on the 6th. I don't know why is isn't recognizing it as the first week. Any thoughts on how to fix this situation?
Hey William it is because the first week of 2020 started on a wednesday, and there will be 53 weeks because of that
Weeknum(F12,13). Enter this, because the first day of the year is on a wednesday for the year 2020, which will be returned by the number 13. That should resolve the issue I suppose.
This is magic
thanks matthew ! it is a work in progress for sure
Hi, I just want to let you know, your videos are great. I have been watching all of them and plan on staying up tonight to make an excel spread sheet with you template. I also wanted to tell you that I am a personal trainer and have been trying to learn how to write up a annual planner so that my clients will know what is to come for the year, But the problem is Im still trying to figure out how to fill in your template with the pre-planned workouts, reps, phase, cycles and just about everything else. If you can help me that would be wonderful.
Hey Coach,
what sort of help do you need?
These tutorials are great as I am following along on the yearly planner. Question that I have for this specific tutorial is once you have set the conditional formatting for the competition dates with the fill in colour that you want and everything is working smoothly, is there a way to have the competition date box show nothing in it again after you have already chosen a specific date of competition if the dates get changed. Not sure if this makes sense, but as an example, lets say in the first week column for the competition date I had previously checked that there is a game that week on whatever day. The game gets moved to the next week and I want to cancel out the checked colour and date from the original scheduled game and I would like that column to show nothing for competition dates now. Is there a way to change this as I can't seem to figure out how? Thanks again for posting these tutorials and any help is much appreciated.
Figured it out. Simple delete...sorry for the silly question. As I am still a beginner excel guy sometimes I overthink it for sure.
I am not sure I quite understand what you are asking.
I would say just have this document be fluid and delete the date from the box so that the colors disappear from the schedule
if you need the ability to add multiple games in a week you could always make more rows and term them Home game #1, home game #2 etc and follow the same process to have them all highlight up.
if you want further help you can email me at dsmtrength@gmail.com I could take a look for you
How did you add the scroll bar at the top allowing you to scroll through the entire calendar?
Hey Dustin, thanks for checking out the videos.
I am not sure if you saw some of the other videos in this series but this one: ruclips.net/video/9Ryt5MpaE04/видео.html
has the tutorial on how to create the scrolling dates.
hope that helps
These videos are incredibly helpful, thanks for doing this. One question, I would like to have both lifts and competitions highlighted throughout the week. Is there a way to have two boxes at the bottom, one for competitions and one for lifts? Just trying to get everything I need on one schedule.
Yes all you would have to do is repeat the process and change the formulas
@@DSMStrength how would I go about doing that? We have multiple games back to back is there a way to highlight both days?
regarding competition highlighting man, when using the scroll macro because the (list options change) when you scroll through it no longer highlights the dates. Example you set the competition dates and then as you go through the week and scroll* all the highlighted ones are off because the corresponding boxes have changed (main question) - how do you get the comp box inputs to rotate(specifically with the date that was initially selected?)
In order to achieve this functionality it would require a lot more complicated formulas.
What do you do if you have more than one competition a week like in hockey, baseball, or hockey? You addressed it in the Opponent box, but not the Competition box.
+Jason CSCS hey Jason good question. Lots of options for something like that obviously you will need to Taylor to your needs.. my solution would be to make the opponent box longer so there is more room to type on it. Also add more date boxes to select game days.. traveldays etc
That was my first thought. Thought you may have some kind of trick. Great videos.Thanks
Jason CSCS there are other ways to do it but I don't want to over complicate the process lol.
how did you set the start and end season top.. my weeks are not getting properly enter .. even though I change my date on top ..
Hello,
I am not quite sure what you mean. I must apologize for being late getting back to you I was on vacation.
if you are still having this issue feel free to email me your sheet and I can have a look at some point dsmstrength@gmail.com
If in week there r more then 2 9or three match then how would u make adjustments with colous and date ?
i look at the YTP as something the is specific to you.. i typically just add boxes for home and away matches but it has to be something that you will look at and understand.
When I do the weeknum command it keeps inputting 2 instead of 1 for the week. Any tips?
it will need to be the first week of the year
Weeknum(F12,13). Enter this, because the first day of the year is on a wednesday for the year 2020, which will be returned by the number 13. That should resolve the issue I suppose.
I have 53 weeks mate.....any ideas?
haha.. thats interesting let me play around with it... you may just need to do a manual entry of your weeks.
Weeknum(F12,13). Enter this, because the first day of the year is on a wednesday for the year 2020, which will be returned by the number 13. That should resolve the issue I suppose.
Why is it when input =weeknum(F10) it gives me 2? & when i scroll it goes 52,53?
because the first sunday / monday for 2021 is in the second week of the year since january started on a friday
@@DSMStrength So what would be the work around to get the 1 value?
@@alpocio117 well it shouldnt really matter as you are just using that row to signify the week in the year.. but if you want to just label it 1 2 3 4 etc yourself without a formula
Hi, my question would how to add another competition column with selected dates to the same week above, I tried to do the same thing with a different color but all I get is ### or weird numbers. For example, I want to make the annual plan for the basketball team and they have two games a week how do I set up so I can highlight two dates in one week? Please let me know. Thank you
I am pretty sure I emailed you the answer
Milana can you forward this email to me by chance? Thanks!
@@DSMStrength or if you can send, that would be great!
@@DSMStrength can you email this to me as well please?
@@jakethesnake7408 Hi jake if you want I have an annual planner template for purchase on my website
thanks for watching