Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
web:roadbook_creation [2017/07/09 10:12] adminweb:roadbook_creation [2023/02/05 09:42] (current) admin
Line 8: Line 8:
 First of all, you need a route, if you don't have one, feel free to use this [[https://goo.gl/jJ37TR|fantastic route]]. First of all, you need a route, if you don't have one, feel free to use this [[https://goo.gl/jJ37TR|fantastic route]].
  
-It works using Kurviger web or the Kurviger App. On the website click on ''Turn Instructions'' and then on ''Export Roadbook''. Now you can simply copy the table. If you are using the app you can export the route as CSV file. Our user Uli was so friendly to provide us a worksheet to import make it easy to either paste the copied roadbook or open the CSV. You can get the worksheet [[http://leinhos-heinke.de/Routenplanung_Master_V01i.xlsx|here]].+It works using [[https://kurviger.de|Kurviger web]] or the [[https://play.google.com/store/apps/details?id=com.kurviger.app|Kurviger App]]Click on the dropdown menu, right of the RouteName, then on ''Turn Instructions'' and then on ''Export Roadbook''. Now you can simply copy the table. You can can export the turn instructions as CSV file as well. Our user Uli was so friendly to provide us a worksheet to import make it easy to either paste the copied roadbook or open the CSV. You can get the worksheet [[https://barchetta-blog.de/roadbook_kurviger.html|here]] (English version included).
  
 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:
 {{:web:snap_2017.07.05_22h16m02s_001.png?600|}}{{:web:snap_2017.07.05_22h16m17s_002.png?400|}} {{:web:snap_2017.07.05_22h16m02s_001.png?600|}}{{:web:snap_2017.07.05_22h16m17s_002.png?400|}}
  
-===== Example =====+===== Usage Example =====
  
 [[https://groups.google.com/d/msg/kurviger/wwxZtiFeYv4/fdW4KMA5AwAJ|Uli provided us with an example where he used the worksheet to plan a trip, thanks Uli!]] [[https://groups.google.com/d/msg/kurviger/wwxZtiFeYv4/fdW4KMA5AwAJ|Uli provided us with an example where he used the worksheet to plan a trip, thanks Uli!]]
Line 36: Line 36:
 ... the whole route in a "corso" (parade, all members in a line): ... 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. 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. +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 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&paste (Kurviger browser version, by "Abbiegehinweise - Export Road Book"). +  - You export this Kurviger route by the Kurviger export function as a CSV-file (Kurviger app) or by copy&paste (Kurviger browser version, by "Turn Instructions - Export Road Book"). 
-  - 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. +  - 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" to avoid importing problems, e.g., 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. 
-  - 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. +  - 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: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.) +  - Next you have to decide, how long the planned breaks will be, for 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, for example waypoints 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.) 
-  - 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.)+  - 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  in the header (2nd orange field), 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.
  
 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, all members of the group will have a chance to find 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!! :) )+With this combined information, all members of the group have a chance to find the group at fixed times and places (indeed provided that you all stay patient and wait at every meeting point until the departure time provided in the list!! :) )
  
 Additional Information: Additional Information:
Line 74: Line 76:
  
 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!!  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!! 
- 
  
 {{:web:snap_2017.07.07_21h31m47s_003.png?500|}}{{:web:snap_2017.07.07_21h34m21s_005.png?500|}} {{:web:snap_2017.07.07_21h31m47s_003.png?500|}}{{:web:snap_2017.07.07_21h34m21s_005.png?500|}}
  • web/roadbook_creation.1499587924.txt.gz
  • Last modified: 2017/07/09 10:12
  • by admin