2 Replies Latest reply on Dec 16, 2016 7:30 AM by diego.medrano

    Mapping routes for multiple vehicles with different spreadsheets

    Paul H

      Hi All,

       

      I'm attempting to visualise shipping routes over a large period with a large variety of cargo, and load ports. I also have different trade route information on a separate spreadsheet.

       

      The issue I'm having is that I need the "load port" to link or use the set of coordinates for the routes. I have struggled in linking the sheets in order to achieve this. I have the chronology of the trade routes too, but do not know how to approach this.

      What I have considered is using unique route names and matching them. I didn't have an issue, however, it shows the whole route as opposed to the point-by-point data. The route information is lat/ln in either minute by minute or a standardised 1km basis.

       

      Any help or alternative solutions will be appreciated.

       

      Thanks in advance