PBP Planners on Wiki
23 views
Skip to first unread message
Pam Wright
Jun 14, 2011, 9:25:12 PM6/14/11
to randon
I'm in luv! I finally took a few minutes to look at Tim Feldman's and Willy Nevin's planners on the PBP Wiki site - Wowza Wow Wow! I like to play in Excel and these guys have saved me from even starting to play. Both are fabulous tools.
Willy's is straightforward and looks a lot like mine, but the best thing is he's already done the work :)
Tim's took me a few minutes to get the hang of, but once I did, I was zinging through it like I hope to zing through PBP...with a smile on my face. I really got a kick out of seeing cells turn colors as my calculations might put me too close to closing times. Heck, it makes spreadsheets "fun!"
Thanks to you guys, I'm going to have to figure out which Office app I want for my iphone in case I have time to play logistical changes to "my" spreadsheets! Huge giant thanks again for sharing your hard work.
(Next on my list looks to be the hours of work, Don has put into creating not just Google maps of PBP stages, but he's even got 1/2 of the stages into bikeroutetoaster to download. I've only owned a GPS unit for a week, but it already gives me giggle fits, now Don makes it easy to start learning to use the darn thing - thanks Don!!)
The more time I spend looking at the Wiki site, the more I'm amazed at how many hours of work has gone into this. It is truly a treasure trove of information and I thank all of you for sharing it with us!
Pam Wright |
Yiping Lin
Jun 14, 2011, 10:02:19 PM6/14/11
to randon
I also just noticed these two planners myself. Haven't played them
yet.
Special thanks to Tim Feldman and Willy Nevin. :-)
Yiping
yet.
Special thanks to Tim Feldman and Willy Nevin. :-)
Yiping
Tim Foon Feldman
Jun 15, 2011, 5:50:47 PM6/15/11
to randon
I received a question that may be of general interest, so let me share it here.
Comparing the closing times of the last two controls, Dreux and Guyancourt, to the intervening distance shows a minimum speed of 16 mph is required for this last leg. Is this really true?!
Yes, and this is due to the vagaries of the definition of control closing times if I understand it correctly.
First, note that PBP is a nominally a 1200-km brevet that has a actual distance of 1232 km.
The closing time for intermediate controls is based on minimum speeds* and the actual distance. But the closing for the last control is based on the nominal distance and not the actual distance. Thus, the Guyancourt control closes 90 hours after your start (for the 90-hour limit riders), and not the longer time that would correspond to 1232 km at the minimum speed (92:24).
This can lead to a conundrum for a penultimate control that is too close to the finish in which the closing time for the penultimate control could be after the time limit for the brevet! In particular, any control that is not the final control but is past the nominal distance of the brevet would have this characteristic. That is, any control between the 1200-km point and the end would have a closing time more than 90 hours after the start!
What is seen with Dreux is a partial exposure of this phenomenon. Riders are allowed to get to Dreux as late as the minimum pace allows, but have to get to Guyancourt to finish within 90 hours, and if ones leaves Dreux as late as the control close allows you do indeed need to cover the final leg in 2.5 hours (16 mph or 26 km/h). This is also seen as a change in the slope of the control close time on the chart in my spreadsheet.
I believe this description to be accurate, but of course the actual control open and close times will be defined by ACP and may differ from the calculations in the spreadsheet.
The lesson is, don't be too squeezed for time by riding too close to the control close near the end of the ride.
~Tim Foon Feldman
* See the "limits" tab on my spreadsheet for the three different speed tables for PBP and its the three different time limits.
Comparing the closing times of the last two controls, Dreux and Guyancourt, to the intervening distance shows a minimum speed of 16 mph is required for this last leg. Is this really true?!
Yes, and this is due to the vagaries of the definition of control closing times if I understand it correctly.
First, note that PBP is a nominally a 1200-km brevet that has a actual distance of 1232 km.
The closing time for intermediate controls is based on minimum speeds* and the actual distance. But the closing for the last control is based on the nominal distance and not the actual distance. Thus, the Guyancourt control closes 90 hours after your start (for the 90-hour limit riders), and not the longer time that would correspond to 1232 km at the minimum speed (92:24).
This can lead to a conundrum for a penultimate control that is too close to the finish in which the closing time for the penultimate control could be after the time limit for the brevet! In particular, any control that is not the final control but is past the nominal distance of the brevet would have this characteristic. That is, any control between the 1200-km point and the end would have a closing time more than 90 hours after the start!
What is seen with Dreux is a partial exposure of this phenomenon. Riders are allowed to get to Dreux as late as the minimum pace allows, but have to get to Guyancourt to finish within 90 hours, and if ones leaves Dreux as late as the control close allows you do indeed need to cover the final leg in 2.5 hours (16 mph or 26 km/h). This is also seen as a change in the slope of the control close time on the chart in my spreadsheet.
I believe this description to be accurate, but of course the actual control open and close times will be defined by ACP and may differ from the calculations in the spreadsheet.
The lesson is, don't be too squeezed for time by riding too close to the control close near the end of the ride.
~Tim Foon Feldman
* See the "limits" tab on my spreadsheet for the three different speed tables for PBP and its the three different time limits.
--
You received this message because you are subscribed to the Google Groups "randon" group.
To post to this group, send email to ran...@googlegroups.com.
To unsubscribe from this group, send email to randon+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/randon?hl=en.
Reply all
Reply to author
Forward
0 new messages