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/10 14:55] devemux86web: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/roadbook_kurviger.html|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 48: Line 48:
   - 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.   - 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: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.)   - 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: 
  • web/roadbook_creation.1499691356.txt.gz
  • Last modified: 2017/07/10 14:55
  • by devemux86