Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision Next revisionBoth sides next revision | ||
web:roadbook_creation [2017/07/07 10:41] – created admin | web:roadbook_creation [2021/05/29 13:09] – devemux86 | ||
---|---|---|---|
Line 2: | Line 2: | ||
If you are planning to do a rally or just prefer the old paper-style way of navigating, having a roadbook is always a good idea. | If you are planning to do a rally or just prefer the old paper-style way of navigating, having a roadbook is always a good idea. | ||
+ | |||
+ | ===== Creating the Roadbook ===== | ||
+ | |||
First of all, you need a route, if you don't have one, feel free to use this [[https:// | First of all, you need a route, if you don't have one, feel free to use this [[https:// | ||
- | It works using Kurviger web or the Kurviger App. On the website click on '' | + | It works using [[https:// |
You may: | You may: | ||
Line 11: | Line 14: | ||
- decide when to start the route (time of day like 9:00 am), | - decide when to start the route (time of day like 9:00 am), | ||
- decide at which waypoint(s) to have breaks and how long every one will be, | - decide at which waypoint(s) to have breaks and how long every one will be, | ||
- | - decide about the interval to which to round up the starting times after every break (at example 15 minutes, i.e. every time will be given rounded up to every 15 minutes)). | + | - decide about the interval to which to round up the starting times after every break (at example 15 minutes, i.e. every time will be given rounded up to every 15 minutes). |
The worksheet will tell you: | The worksheet will tell you: | ||
- | * some basic data like expected end of the route and some other (lokk at the header of the worksheet), | + | * some basic data like expected end of the route and some other (look at the header of the worksheet), |
* the rounded up starting time after every break (which means, up to which time of the day everyone of the group or any latecomers have to arrive at this waypoint to join the group). | * the rounded up starting time after every break (which means, up to which time of the day everyone of the group or any latecomers have to arrive at this waypoint to join the group). | ||
- | {{: | + | {{: |
+ | |||
+ | ===== Usage Example ===== | ||
+ | |||
+ | [[https:// | ||
+ | |||
+ | 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. 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' | ||
+ | ... the whole route in a " | ||
+ | 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 " | ||
+ | And additionally you know, that some Austrian friends will join the group after the coffee break, and some others will join the group after the lunch break, and so on. | ||
+ | So you 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, | ||
+ | |||
+ | - At first you plan the route by Kurviger of course by fixing waypoints as usual. | ||
+ | - 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. | ||
+ | - You export this Kurviger route by the Kurviger export function as a CSV-file (Kurviger app) or by copy& | ||
+ | - You paste the CSV or the copied table into the provided Excel worksheet (best after right click by the Excel paste option "only Data - use format of destination" | ||
+ | - Now you should decide at which day time you will start the trip, let's say 9 AM (enter this time in the red indicated field in the header of the worksheet.) - The worksheet will now calculate the time of day for every waypoint instead of relative times, shown in the column XI. | ||
+ | - Next you have to decide, how long the planned breaks will be, for example 0:30 Hours: | ||
+ | - The curvy route times are based on a certain speed driving behaviour, which is on average about 90 km/h (but of course depends on the chosen routes, e.g. number of speed restrictions or city crossings). If you know in advance that you are probably travelling slower (or faster), e.g. for classic car or bike tours, you can enter a correction factor (1st orange field); e.g. 3 for a tour speed of approx. 30 km/h. (Please note: These can only be rough approximations). | ||
+ | - Because you usually round up the times for meeting time points, you may enter the interval for up rounding | ||
+ | - You MAY insert additional values in the fields "Name of the route", | ||
+ | |||
+ | NOW you finally find some main information in the header: | ||
+ | * the total distance (in km, rounded up), | ||
+ | * the arrival time (in Hour: | ||
+ | * the pure riding (driving) time, | ||
+ | * the sum of planned breaks, | ||
+ | * the total duration of the planned trip, | ||
+ | * the intended additional information about the planned starting time of every meeting point in column XV!. | ||
+ | |||
+ | 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, and | ||
+ | * 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, | ||
+ | |||
+ | Additional Information: | ||
+ | Sometimes you want to provide the members of the group with more information, | ||
+ | |||
+ | Of course the worksheet contains all that information; | ||
+ | (Hiding or showing of rows and/or columns in excel is quite easy, if you know how to do.) | ||
+ | |||
+ | By the way: The route showed as an example here we, i.e. a group of 8 Barchetta roadsters, drove last weekend - which for me was a test of Kurviger V. 1.1.3 also - and it worked very well! :) And it was a very nice trip!! | ||
+ | |||
+ | {{: |