Hey. I did my debut comrades this year. Finished 9:50 with the prestigious Robert Mtshali medal. I watched all your videos. Found them very helpful. I even carried the pace plan for every 10 km section as small index cards with me. I was able to execute a perfect race plan! Thank you from the bottom of my heart!
Hi there, great video. My only recommendation to everyone is to please remember(batch dependent) to add +- 1KM to your total race mileage when doing your calculations. You will never run the exact route distance and in my experience I'm always a little more than 1KM over(G Batch Runner).
Thank you so much for the spreadsheet Andre, much appreciated. Please explain again the colour codes, or maybe add it as a legend as you did with the abbreviations. Please, and thank you.🤩🌼
Wow; this is excellent, I will definitely be using this; do you by any chance have the elevation difference every 333 meters or 1 km, so it can be input into the excel cells and with conditional formatting the cell colours can be automatically coloured say from green to red. (instead of manual as you have done)
Hi. Thank you for the kind words. You can export from Plotaroute to a GPX file. From here you can get the altitude and use formulas to get the distance between GPS points. The Plotaroute map of the 2024 up-run is available here: www.plotaroute.com/route/2374494. To get the data point for every 333.33m will take some VLOOKUP XLS skills. 🙂
Hey. I did my debut comrades this year. Finished 9:50 with the prestigious Robert Mtshali medal. I watched all your videos. Found them very helpful. I even carried the pace plan for every 10 km section as small index cards with me. I was able to execute a perfect race plan! Thank you from the bottom of my heart!
Awesome! Well done with your Robert Mtshali medal. Glad I could help. See you at Comrades 2025!
Hi there, great video. My only recommendation to everyone is to please remember(batch dependent) to add +- 1KM to your total race mileage when doing your calculations. You will never run the exact route distance and in my experience I'm always a little more than 1KM over(G Batch Runner).
Thank you! Love the idea. Maybe add 2km as very few of us start on the start line.
Thank you Andre. Very helpful and informative sheet.
Wonderful video thank you Andre
This is very helpful, thank you so much. With my injury at least I know how I can manage my race.
I hope your injury recovers in time! Give it a good rest and see a physiotherapist if you can. All the best!
Thanks Andre, very helpful.
Thank you so much for the spreadsheet Andre, much appreciated. Please explain again the colour codes, or maybe add it as a legend as you did with the abbreviations. Please, and thank you.🤩🌼
Thank you. I have included the legend below the plan on the sheet.
@@ChurchMouse54978 Thank you sooo much, Andre! You're a star! See you in Durban... Or Scottsville! All the best with your run ♥
@@ketlamadileng3327 Have a fantastic race! Hope to see you on the route.
Very good information. Thank you Andre
Wow; this is excellent, I will definitely be using this; do you by any chance have the elevation difference every 333 meters or 1 km, so it can be input into the excel cells and with conditional formatting the cell colours can be automatically coloured say from green to red. (instead of manual as you have done)
Hi. Thank you for the kind words. You can export from Plotaroute to a GPX file. From here you can get the altitude and use formulas to get the distance between GPS points. The Plotaroute map of the 2024 up-run is available here: www.plotaroute.com/route/2374494. To get the data point for every 333.33m will take some VLOOKUP XLS skills. 🙂
This is very helpful, I have downloaded
Thanks Andrè