Converting RedMX RMS Map Data for Chief 360
📍 Converting RedMX RMS Map Data for Chief 360
If you have exported your map data from Alpine Software Corporation’s RedMX RMS system, the latitude and longitude values must be converted before importing into Chief 360.
🔁 Conversion in Excel
-
Rename Original Columns:
-
Rename the original
Latitude
andLongitude
columns to:
RMS Latitude
andRMS Longitude
.
-
-
Create New Columns:
-
In the two adjacent columns, add headers titled
Latitude
andLongitude
.
-
-
Apply the Conversion Formula:
-
In the first cell under your new
Latitude
column (assume it's cell L2 andRMS Latitude
is in J2), enter the following formula:=TRUNC(J2) + (J2 - TRUNC(J2)) * (10 / 6)
-
Drag this formula down the column to convert all latitude values.
-
-
Repeat for Longitude:
-
In the first cell under the new
Longitude
column (assume it's M2 andRMS Longitude
is in K2), use the same formula structure:=TRUNC(K2) + (K2 - TRUNC(K2)) * (10 / 6)
-
Again, drag this formula down the column to apply it to all longitude values.
-
⚠️ Make sure to update the cell references (e.g.,
J2
,K2
) to match your actual spreadsheet layout.
Once complete, your map data is formatted correctly for upload into Chief 360.
Attached is an example Spreadsheet.
🐍 Conversion Using Python
If you're processing data using Python, you can apply the following formulas using math.trunc()
:
# Latitude conversion
converted_lat = math.trunc(lat) + (lat - math.trunc(lat)) * 10 / 6
# Longitude conversion
converted_lon = math.trunc(lon) + (lon - math.trunc(lon)) * 10 / 6
Replace lat
and lon
with your actual latitude and longitude variables.