Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revisionLast revisionBoth sides next revision | ||
web:roadbook_creation [2017/07/09 10:05] – admin | web:roadbook_creation [2022/12/18 16:48] – admin | ||
---|---|---|---|
Line 8: | Line 8: | ||
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 14: | 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: | ||
Line 22: | Line 22: | ||
{{: | {{: | ||
- | ===== Example ===== | + | ===== Usage Example ===== |
- | Uli provided us with an example where he used the worksheet to plan a trip, thanks Uli! | + | [[https:// |
Why and how to use the computing MS Excel worksheet in combination with Kurviger? | Why and how to use the computing MS Excel worksheet in combination with Kurviger? | ||
Line 36: | Line 36: | ||
... the whole route in a " | ... 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 " | 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 there will some Austrian friends will join the group only after the coffee break, and some others | + | And additionally you know, that some Austrian friends will join the group after the coffee break, and some others |
- | 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. | + | 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. | That's where the table comes into play. | ||
Line 44: | Line 44: | ||
- At first you plan the route by Kurviger of course by fixing waypoints as usual. | - 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. | - 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 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 offered | + | - You paste the CSV or the copied table into the provided |
- | - 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 | + | - 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, at example 0:30 Hours: | + | - Next you have to decide, how long the planned breaks will be, for example 0:30 Hours: |
- | - Because you usually round up the times for meeting time points, you may enter the interval for up rounding | + | - 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: | NOW you finally find some main information in the header: | ||
Line 65: | Line 67: | ||
* send it, together with the Kurviger GPX file, to all members of the group. | * send it, together with the Kurviger GPX file, to all members of the group. | ||
- | With this combined information, | + | 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!! | ||
+ | |||
+ | {{: |