Go Back  Bike Forums > Bike Forums > Long Distance Competition/Ultracycling, Randonneuring and Endurance Cycling
Reload this Page >

Posted: Cue Sheets, GPS Files, and Planning Spreadsheet for PBP 2015

Notices
Long Distance Competition/Ultracycling, Randonneuring and Endurance Cycling Do you enjoy centuries, double centuries, brevets, randonnees, and 24-hour time trials? Share ride reports, and exchange training, equipment, and nutrition information specific to long distance cycling. This isn't for tours, this is for endurance events cycling

Posted: Cue Sheets, GPS Files, and Planning Spreadsheet for PBP 2015

Old 07-09-15, 02:53 PM
  #1  
Senior Member
Thread Starter
 
Join Date: Dec 2003
Posts: 1,009

Bikes: SOMA Grand Randonneur, Gunnar Sport converted to 650B, Rivendell Rambouillet, '82 Trek 728, '84 Trek 610, '85 Trek 500, C'Dale F600, Burley Duet, Lotus Legend

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 8 Post(s)
Likes: 0
Liked 3 Times in 3 Posts
Posted: Cue Sheets, GPS Files, and Planning Spreadsheet for PBP 2015

Cue Sheets, GPS Files, and Planning Spreadsheet for PBP 2015 are posted here:
DC Randonneurs » Blog Archive » Cue Sheets, GPS Files, and Planning Spreadsheet for PBP 2015

These are "use at your own risk"--official PBP documents always supercede anything provided here.

The planning spreadsheet is the most complicated thing here. The page "Notes on the spreadsheet" should be helpful in understanding how to use it. Beyond that, the spreadsheet is "self-documenting"--all you have to do is figure out how it works :-)

Feel free to ask questions--I'll do my best to respond, given time constraints.

Please let me know if you see something you think is an error.

Nick Bull
Regional Brevet Administrator for the MD:Capital Region
Club Brevet Administrator for DC Randonneurs
thebulls is offline  
Old 07-13-15, 08:01 AM
  #2  
bike rider
 
Join Date: Sep 2004
Posts: 178
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 10 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Wow - thanks for the treasure of info.
9606 is offline  
Old 07-15-15, 07:16 AM
  #3  
RR3
Banned
 
Join Date: Aug 2014
Posts: 1,226
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 2 Times in 2 Posts
Great Spreadsheet.

Which column do I adjust to change the stoppage at controls (not sleep, I figured that one out)

Does the model assume a constant power output?

Does the model assume no drafting (solo)?

My bike and I will weigh 210 lbs. I know I can average 170 watts on a 600K but guess my power will drop to around 110-130 watts on the return to Paris owing to inevitable fatigue. Would it make sense to input 140 watts....just your opinion if you have time. Thanks.
RR3 is offline  
Old 07-15-15, 12:27 PM
  #4  
Senior Member
Thread Starter
 
Join Date: Dec 2003
Posts: 1,009

Bikes: SOMA Grand Randonneur, Gunnar Sport converted to 650B, Rivendell Rambouillet, '82 Trek 728, '84 Trek 610, '85 Trek 500, C'Dale F600, Burley Duet, Lotus Legend

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 8 Post(s)
Likes: 0
Liked 3 Times in 3 Posts
Originally Posted by RR3
Great Spreadsheet.

Which column do I adjust to change the stoppage at controls (not sleep, I figured that one out)

Does the model assume a constant power output?

Does the model assume no drafting (solo)?

My bike and I will weigh 210 lbs. I know I can average 170 watts on a 600K but guess my power will drop to around 110-130 watts on the return to Paris owing to inevitable fatigue. Would it make sense to input 140 watts....just your opinion if you have time. Thanks.
Column BQ for the hand-adjusted control time. You can either put hard-code the amount of time, or you could put in a formula and assume, e.g. that you can control in 3/4 of the time that I've allowed, or whatever.

The model assumes that you slow down progressively as you get further into the ride--implicitly, I think this has to mean that it assumes power output declines. However, it also assumes that if you sleep for one sleep cycle or longer (90 minutes) then this is so refreshing that it is as if you had only ridden 80 percent of the cumulative distance--see column BD at row 115 where I have a 90-minute sleep at Loudeac and when you wake up from that sleep, it is as if you are only 346 km into the ride instead of 487km. This is entirely ad hoc!

You can actually put that you are drafting by changing the zeroes in column AK to ones.

I would put in the average watts for the entire ride, and take advantage of the fact that the forecast assumes that you progressively slow down during the ride (with resets for sleep).

Also, to correct a small error in the spreadsheet, go to the PBP15 page, cell CA2 and input the formula +CA5.
Nick

Last edited by thebulls; 07-15-15 at 12:34 PM.
thebulls is offline  
Old 07-18-15, 11:32 AM
  #5  
Senior Member
Thread Starter
 
Join Date: Dec 2003
Posts: 1,009

Bikes: SOMA Grand Randonneur, Gunnar Sport converted to 650B, Rivendell Rambouillet, '82 Trek 728, '84 Trek 610, '85 Trek 500, C'Dale F600, Burley Duet, Lotus Legend

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 8 Post(s)
Likes: 0
Liked 3 Times in 3 Posts
On the blog entry referred to above ... I have updated the GPS file to include a route from Charles de Gaulle airport to the Bastille and vice versa.. The route is based on David May's website, here:
Bicycle from CDG Airport to Paris or vice-versa

Possibly of use to riders who are staying on after PBP to do some tourism and who might be using an airport hotel.

There is also a small bug-fix to the planning spreadsheet. You can either download it again or modify the PBP15 page so that cell CA2 contains the formula +CA5. Improvements to power-to-weight ratio were being double-counted with changes to total rider+luggage weight.

Nick
thebulls is offline  
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Wattsup
General Cycling Discussion
12
11-19-18 07:08 PM
GMJ
"The 33"-Road Bike Racing
69
02-09-17 11:29 PM
OldZephyr
Touring
18
10-26-15 09:47 AM
La Tortue
Long Distance Competition/Ultracycling, Randonneuring and Endurance Cycling
101
04-29-15 10:05 PM
skiffrun
Long Distance Competition/Ultracycling, Randonneuring and Endurance Cycling
10
12-20-14 12:13 PM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.