Results 1 to 2 of 2

Thread: Distance in exported file

  1. #1
    Potential Tuner
    Join Date
    Aug 2019
    Posts
    3

    Distance in exported file

    How can I export the distance into CSV file either from trackaddict or Racerender ?

  2. #2
    HPT Employee Weston@HPTuners's Avatar
    Join Date
    Jul 2014
    Location
    39.735034, -103.894459
    Posts
    868
    Distance is a calculated field based on GPS movement over time, so unfortunately there's presently no logging or export of that.

    We have had some users add this to their CSV file via an Excel formula in the past, although that is a fairly involved process: You'd have to convert latitude and longitude from absolute degrees into relative degrees by subtracting the initial values, and then convert those into meters based on the current latitude ( http://www.csgnetwork.com/degreelenllavcalc.html ), then calculate the hypotenuse ( sqrt(lat_m^2 + lon_m^2) ) to get the distance between the current point and the previous point, and finally make a cumulative distance field that adds up all those individual distance calcs between points. So, it's possible, but a bit of work to set up the first time.