PBP planning spreadsheets
348 views
Skip to first unread message
Tim Foon Feldman
Jun 8, 2011, 4:07:26 PM6/8/11
to randon
Paris-Brest-Paris Aspirants,
There are a couple of spreadsheets posted to the RUSA PBP wiki in the Maps & Planning Spreadsheets page.
I am the developer of PBP2011-planner.r5.xlsx and, as noted in the "rider instructions" tab, the spreadsheet support -- just my voyeuristic attempt to contribute. Please feel free to contact me with any issues, shortcomings or desired improvements.
A couple of additional notes:
- The distances are from the PBP site where the route is listed in 15 stages. The Interactive Route map for each stage lists the distance with 1-meter precision (!) and those distances were transcribed into the planner.
- The control open and close times are calculated base on the elapse distance based on parameters on the one of the Time Calculator pages on the RUSA site, with distinction based on the three different time limits (80, 84 and 90 hours). Please expect that the actual control open and close times will be different, but hopefully similar.
- The start time (cell planner!C3) is calculated based on the selected time limit. Directly overwrite this cell if a specific start time is needed.
- Credits: Inspired by a spreadsheet for Last Chance 2008 by Steve "Bones" Matney, co-director of the 2008 Shenandoah 1200.
- New revisions will be posted as significant fixes and improvements become available.
~Tim Foon Feldman
Rocky Mountain Cycling Club
There are a couple of spreadsheets posted to the RUSA PBP wiki in the Maps & Planning Spreadsheets page.
I am the developer of PBP2011-planner.r5.xlsx and, as noted in the "rider instructions" tab, the spreadsheet support -- just my voyeuristic attempt to contribute. Please feel free to contact me with any issues, shortcomings or desired improvements.
A couple of additional notes:
- The distances are from the PBP site where the route is listed in 15 stages. The Interactive Route map for each stage lists the distance with 1-meter precision (!) and those distances were transcribed into the planner.
- The control open and close times are calculated base on the elapse distance based on parameters on the one of the Time Calculator pages on the RUSA site, with distinction based on the three different time limits (80, 84 and 90 hours). Please expect that the actual control open and close times will be different, but hopefully similar.
- The start time (cell planner!C3) is calculated based on the selected time limit. Directly overwrite this cell if a specific start time is needed.
- Credits: Inspired by a spreadsheet for Last Chance 2008 by Steve "Bones" Matney, co-director of the 2008 Shenandoah 1200.
- New revisions will be posted as significant fixes and improvements become available.
~Tim Foon Feldman
Rocky Mountain Cycling Club
WMdeR
Jun 8, 2011, 4:17:38 PM6/8/11
to randon
Dear Foon,
Nice work. I look forward to generating a few goal scenarios, and
your work here will help us all out.
Best Regards,
Will
William M. deRosset
RUSA 2401
On Jun 8, 2:07 pm, Tim Foon Feldman <timfoonfeld...@gmail.com> wrote:
> Paris-Brest-Paris Aspirants,
>
> There are a couple of spreadsheets posted to the RUSA PBP
> wiki<http://pbpwiki.rusa.org/>in the Maps
> & Planning Spreadsheets <http://pbpwiki.rusa.org/home/maps> page.
Nice work. I look forward to generating a few goal scenarios, and
your work here will help us all out.
Best Regards,
Will
William M. deRosset
RUSA 2401
On Jun 8, 2:07 pm, Tim Foon Feldman <timfoonfeld...@gmail.com> wrote:
> Paris-Brest-Paris Aspirants,
>
> There are a couple of spreadsheets posted to the RUSA PBP
> & Planning Spreadsheets <http://pbpwiki.rusa.org/home/maps> page.
>
> I am the developer of PBP2011-planner.r5.xlsx and, as noted in the "rider
> instructions" tab, the spreadsheet support -- just my voyeuristic attempt to
> contribute. Please feel free to contact me with any issues, shortcomings or
> desired improvements.
>
> A couple of additional notes:
>
> - The distances are from the PBP
> site<http://www.paris-brest-paris.org/pbp2011/index2.php?lang=en&cat=accue...>where
> I am the developer of PBP2011-planner.r5.xlsx and, as noted in the "rider
> instructions" tab, the spreadsheet support -- just my voyeuristic attempt to
> contribute. Please feel free to contact me with any issues, shortcomings or
> desired improvements.
>
> A couple of additional notes:
>
> - The distances are from the PBP
> the route is listed in 15 stages. The Interactive Route map for each
> stage lists the distance with 1-meter precision (!) and those distances were
> transcribed into the planner.
>
> - The control open and close times are calculated base on the elapse
> distance based on parameters on the one of the Time Calculator
> <http://www.rusa.org/octime_rm.html>pages on the RUSA site, with distinction
> stage lists the distance with 1-meter precision (!) and those distances were
> transcribed into the planner.
>
> - The control open and close times are calculated base on the elapse
> distance based on parameters on the one of the Time Calculator
Tim Foon Feldman
Jul 11, 2011, 5:15:30 PM7/11/11
to randon
Mick Jordan pointed out that my calculated control open and close times are sometimes very different than the 2007 times (reference http://pbpwiki.rusa.org/planning/2007-control-open-close-times), so I revised the spreadsheet to directly use those times.
This new revision is now posted to Don Bennett's PBP wiki at Maps & Planning Spreadsheets as the "PBP2011-planner.r6.xlsx" attachment.
~Tim "Foon" Feldman
PS: Best of luck to the 48 riders currently riding the Colorado High Country 1200.
This new revision is now posted to Don Bennett's PBP wiki at Maps & Planning Spreadsheets as the "PBP2011-planner.r6.xlsx" attachment.
~Tim "Foon" Feldman
PS: Best of luck to the 48 riders currently riding the Colorado High Country 1200.
Erik Nilsson
Jul 12, 2011, 12:22:30 AM7/12/11
to randon
Here are the 90-hour control closings, based on an 18:00 start, from
the official dossier. These are somewhat different than my
transposition of the 2007 times.
control
Town closes
Guyancourt
VILLAINES LA JUHEL Mon 22 08:44
Fougères Mon 22 14:40
Tinteniac Mon 22 18:38
LOUDEAC Tue 23 01:08
Carhaix Tue 23 06:59
BREST Tue 23 13:19
Carhaix Tue 23 19:51
LOUDEAC Wed 24 01:56
Tinteniac Wed 24 08:47
Fougères Wed 24 13:04
VILLAINES LA JUHEL Wed 24 20:12
Mortagne au Perche Thu 25 01:56
Dreux Thu 25 07:12
Guyancourt Thu 25 12:00
On Jul 11, 2:15 pm, Tim Foon Feldman <timfoonfeld...@gmail.com> wrote:
> Mick Jordan pointed out that my calculated control open and close times are
> sometimes very different than the 2007 times (referencehttp://pbpwiki.rusa.org/planning/2007-control-open-close-times), so I
>
>
>
>
>
>
>
> > Paris-Brest-Paris Aspirants,
>
> > There are a couple of spreadsheets posted to the RUSA PBP wiki<http://pbpwiki.rusa.org/>in the Maps
> > & Planning Spreadsheets <http://pbpwiki.rusa.org/home/maps> page.
the official dossier. These are somewhat different than my
transposition of the 2007 times.
control
Town closes
Guyancourt
VILLAINES LA JUHEL Mon 22 08:44
Fougères Mon 22 14:40
Tinteniac Mon 22 18:38
LOUDEAC Tue 23 01:08
Carhaix Tue 23 06:59
BREST Tue 23 13:19
Carhaix Tue 23 19:51
LOUDEAC Wed 24 01:56
Tinteniac Wed 24 08:47
Fougères Wed 24 13:04
VILLAINES LA JUHEL Wed 24 20:12
Mortagne au Perche Thu 25 01:56
Dreux Thu 25 07:12
Guyancourt Thu 25 12:00
On Jul 11, 2:15 pm, Tim Foon Feldman <timfoonfeld...@gmail.com> wrote:
> Mick Jordan pointed out that my calculated control open and close times are
> revised the spreadsheet to directly use those times.
>
> This new revision is now posted to Don Bennett's PBP wiki at Maps & Planning
> Spreadsheets <https://sites.google.com/site/pbp2011usa/maps> as the
>
> This new revision is now posted to Don Bennett's PBP wiki at Maps & Planning
> "PBP2011-planner.r6.xlsx"
> attachment.
>
> ~Tim "Foon" Feldman
>
> PS: Best of luck to the 48 riders currently riding the Colorado High Country
> 1200 <http://www.rmccrides.com/brevet-chc-main.htm>.
> attachment.
>
> ~Tim "Foon" Feldman
>
> PS: Best of luck to the 48 riders currently riding the Colorado High Country
>
> On Wed, Jun 8, 2011 at 2:07 PM, Tim Foon Feldman
> <timfoonfeld...@gmail.com>wrote:
> On Wed, Jun 8, 2011 at 2:07 PM, Tim Foon Feldman
>
>
>
>
>
>
>
> > Paris-Brest-Paris Aspirants,
>
> > There are a couple of spreadsheets posted to the RUSA PBP wiki<http://pbpwiki.rusa.org/>in the Maps
> > & Planning Spreadsheets <http://pbpwiki.rusa.org/home/maps> page.
>
> > I am the developer of PBP2011-planner.r5.xlsx and, as noted in the "rider
> > instructions" tab, the spreadsheet support -- just my voyeuristic attempt to
> > contribute. Please feel free to contact me with any issues, shortcomings or
> > desired improvements.
>
> > A couple of additional notes:
>
> > - The distances are from the PBP site<http://www.paris-brest-paris.org/pbp2011/index2.php?lang=en&cat=accue...>where the route is listed in 15 stages. The Interactive Route map for each
> > I am the developer of PBP2011-planner.r5.xlsx and, as noted in the "rider
> > instructions" tab, the spreadsheet support -- just my voyeuristic attempt to
> > contribute. Please feel free to contact me with any issues, shortcomings or
> > desired improvements.
>
> > A couple of additional notes:
>
> > stage lists the distance with 1-meter precision (!) and those distances were
> > transcribed into the planner.
>
> > - The control open and close times are calculated base on the elapse
> > distance based on parameters on the one of the Time Calculator
> > <http://www.rusa.org/octime_rm.html>pages on the RUSA site, with
> > transcribed into the planner.
>
> > - The control open and close times are calculated base on the elapse
> > distance based on parameters on the one of the Time Calculator
Erik Nilsson
Jul 12, 2011, 12:43:12 AM7/12/11
to randon
Well, I can't seem to sign into the RUSA wiki, so here's a link to a
spreadsheet of control closing times based on which group you actually
start in, for the 90h start. This is derived based on the information
in the 2011 dossier. I've double-checked it, but of course comments
and corrections welcome.
http://www.eriknilsson.com/dox/PBP_2011_90h_closing_times.xls
Once you know your start time, just circle the column that applies to
you, copy out the relevant times onto your arm in laundry pen, or
whatever. That which is pre-calculated needn't be re-calculated.
- Erik
On Jul 11, 9:22 pm, Erik Nilsson <erik.nilsson.poph...@gmail.com>
wrote:
spreadsheet of control closing times based on which group you actually
start in, for the 90h start. This is derived based on the information
in the 2011 dossier. I've double-checked it, but of course comments
and corrections welcome.
http://www.eriknilsson.com/dox/PBP_2011_90h_closing_times.xls
Once you know your start time, just circle the column that applies to
you, copy out the relevant times onto your arm in laundry pen, or
whatever. That which is pre-calculated needn't be re-calculated.
- Erik
On Jul 11, 9:22 pm, Erik Nilsson <erik.nilsson.poph...@gmail.com>
wrote:
Reply all
Reply to author
Forward
0 new messages