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

1. Rename Original Columns:

   • Rename the original Latitude and Longitude columns to:
     RMS Latitude and RMS Longitude.

2. Create New Columns:

   • In the two adjacent columns, add headers titled Latitude and Longitude.

3. Apply the Conversion Formula:

   • In the first cell under your new Latitude column (assume it's cell L2 and RMS 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.

4. Repeat for Longitude:

   • In the first cell under the new Longitude column (assume it's M2 and RMS 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.