Why and how to use the computing MS Excel worksheet in combination with Kurviger?
Imagine the following situation:
You are planning a long day's route in a bigger group, let's say, from starting in South Germany near Füssen, crossing Austria and Italy by famous passes and ending near Bozen in South Tyrol (in the example at the Hotel Castel Latemar in the region of Bozen, well known to bikers)!
Problem is, that you know already, that the group will not ride ...
(in my case, with the roadster: drive, but this doesn't make any difference, so I go on calling it "ride")
... the whole route in a "corso" (parade, all members in a line):
Different members of the group ride their own style and velocity, some prefer to ride hard, some prefer to have more stops for taking pictures (or for "liquid emission") and so on.
And additionally you know, that there will some Austrian friends will join the group only after the coffee break, and some others even after the lunch break, and so on.
So what you need is a Road Book, that not only gives the route, the waypoints and places of breaks, but also realistic (!) points in time, when all these latecomers will reliably catch the group.
That's where the table comes into play.
(First it may sound complicated, but once or twice done, it's quite easy to apply! Of course being a bit familiar with Excel may help, but is not really necessary.)
1. At first you plan the route by Kurviger of course by fixing waypoints as usual.
2. On the route you decide which waypoints will be places to have common breaks and which will be meeting points for the latecomers until a certain point of time.
3. You export this Kurviger route by the Kurviger export function as a CSV-file (Kurviger app) or by copy&paste (Kurviger browser version, by "Abbiegehinweise - Export Road Book").
4. You paste the CSV or the copied table into the offered Excel worksheet (best after right click by the Excel paste option "nur Daten - an Zielformatierung anpassen" to avoid importing problems like with the symbols), that means the 5 columns "II Beschreibung" to " VI Gesamt-Zeit". -
The worksheet will now compute automatically the columns VII-X as follows: the distances into the usual unit Kilometers and the times into Hours:Minutes.
6. Now you should decide at which day time you will start the trip, let's say 9:00 a clock (this time you have to enter in the red indicated field in the header of the worksheet.) -
The worksheet will now calculate the absolute day times for every waypoint instead of relative times, shown in the column XI.
7. Next you have to decide, how long the planned breaks will be, at example 0:30 Hours:Minutes for 2-3 coffee breaks during the trip and 1:30 Hours:Minutes for the lunch break, and insert every time periods for every planned break into the (red) column "XII Pausen" into the matching rows, at example "Zwischenziele" 5, 10, 12 (you may vary the length of the breaks with a look to the calculated total duration resp. the arrival time of the planned trip in the header of the worksheet, see below!) -
The worksheet will now calculate the day time for every waypoint depending from the starting time and all breaks before (columns XIII and XIV, which are usually hidden, because they are only calculating columns.)
(8. Because you usually round up the times for meeting time points, you may enter the interval for up rounding in the header in the field indicated orange, if you want to change the value preset to 0:15 hours, every value is possible.)
(You MAY insert additional values in the fields "Name of the route", "file name", "Version" and "Date of version, but they are not necessary for the computed parts of the worksheet, although they may be helpful to keep the overview about several routes or versions or to archive them.)
9. NOW you find finally:
some main information in the header:
a) the total distance (in km, rounded up),
b) the arrival time (in Hour:Minute, rounded up),
c) the pure riding (driving) time,
d) the sum of planned breaks,
e) the total duration of the planned trip,
f) the intended additional information about the planned starting time of every meeting point in column XV!.
And NOW you may
- take the whole worksheet, or
- hide the rows and/or columns, which you don't need for the road book (in fact you only need the header and the columns II and XV in those rows of the waypoints which are intended as break and meeting points, see example in the screen shot,
- print it, or
- export it as a PDF file
- send it, together with the Kurviger GPX file, to all members of the group.
With this combined information, all members or latecomers of the trip group will have a chance to find again the group at fixed times and places (indeed provided that you all stay patient and wait at every meeting point until the departure time of the list!! :) )
(Questions and hits are always welcome!!)
[Screenshots following asap!]